<?php
include("class.php");
include("table_name.php");
/*
echo "<pre>";
print_r($_POST);
echo "</pre>";
*/
unset($_SESSION['UserInfo']);
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."') AND Password = '".$pass_md5."'");
  $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){
    $sql_role_item = array("table"=>$name_table25,"where"=>"UserId='".$row['Id']."'");
    $view_role_item = $view_db->view($sql_role_item);
    $result_role_item = $view_db->q_re($view_role_item);

    $_SESSION['UserInfo'][0]['Name'] = $row['Name']." ".$row['Surname'];
    $_SESSION['UserInfo'][0]['RoleIds'] = $row_role_item['RoleId'];
    $_SESSION['UserInfo'][0]['UserId'] = $row['Id'];
    $_SESSION['UserInfo'][0]['UserName'] = $row['UserName'];


    $i=0;
    while($row_role_item = $view_db->q_ro($result_role_item)){
      $sql_role = array("table"=>$name_table24,"where"=>"RoleId='".$row_role_item['RoleId']."'");
      $view_role = $view_db->view($sql_role);
      $row_role = $view_db->q($view_role);

      $_SESSION['UserInfo'][0]['Role'][$i]['RoleId'] = $row_role['RoleId'];
      $_SESSION['UserInfo'][0]['Role'][$i]['RoleName'] = $row_role['Name'];
      $_SESSION['UserInfo'][0]['Role'][$i]['Del'] = $row_role['Del'];
      $_SESSION['UserInfo'][0]['Role'][$i]['Description'] = '';

      if($i==0){$ii = 'a';}
      if($i==1){$ii = 'b';}
      if($i==2){$ii = 'c';}
      if($i==3){$ii = 'd';}
      if($i==4){$ii = 'e';}
      $_SESSION['RoleId'][$ii] = $row_role['Name'];
      $i++;
    }




    /*
    
echo "<pre>";
    print_r($row);
    echo "</pre>";
    */
    echo "<script>window.location.href='../Dashboard/'</script>";

  }else{
    $_SESSION['er'] = 'false';
    $_SESSION['er_data'] = 'Username not found';
    echo "<script>window.location.href='../'</script>";
  }


}
?>