<?php
include("class.php");
include("table_name.php");
/*
echo "<pre>";
print_r($_POST);
echo "</pre>";
*/
if(@$_POST){
  $l= "iLAW";
  $email = addslashes(trim($_POST['Username']));
  $pass= addslashes(trim($l.$_POST['Password']));
  $pass_md5 = $User_db->cus_pass($pass);

  //echo $pass_md5;

  $sql = array("table"=>$name_table61,"where"=>"UserName='".$email."' OR EmailAddress = '".$email."'");
  $view = $view_db->view($sql);
  $row = $view_db->q($view);
  $row_ = $view_db->q_re($view);
  $row_count = $view_db->q_nr($row_);


  if($row_count==1){
    $list = array(
			'table'=>$name_table61,
			'EmailAddress'=>$email,
			'Password'=>$pass_md5,
			'LastUpdateDateTime'=>$date,
			'LastUpdateBy'=>$row['Id'],
		);
    if($row['UserName']==$email){
      $list = array(
  			'table'=>$name_table61,
  			'UserName'=>$email,
  			'Password'=>$pass_md5,
  			'LastUpdateDateTime'=>$date,
  			'LastUpdateBy'=>$row['Id'],
  		);
    }
		$add = $actiondata_db->edit_db($list);
    if($add['suc']==1){
      $_SESSION['er'] = 'successfully';
      $_SESSION['er_data'] = 'Changed password successfully';
    }else{
      $_SESSION['er'] = 'false';
      $_SESSION['er_data'] = 'Failed to complete the transaction Please try again.';
    }
    echo "<script>window.location.href='../'</script>";
  }else{
    $_SESSION['er'] = 'false';
    $_SESSION['er_data'] = 'Username not found';
    echo "<script>window.location.href='../'</script>";

  }

}
?>