<?php
include('../include72/class.php');

$email = addslashes(trim($_POST['email']));
$pass = addslashes(trim($_POST['password']));

$pass_md5 = $User_db->cus_pass($pass);
//$pass_md5 = $pass;


$sql = array('table'=>'member','count'=>'count(id) AS count_id','where'=>"email = '". $email ."' AND  status = 1");
$view_sql = $view_db->view($sql);
$row = $view_db->q($view_sql);

if($row["count_id"])
{
	$sql2 = array('table'=>'member','count'=>'count(id) AS count_id','where'=>"email = '". $email ."' AND password = '". $pass_md5 ."' AND  status = 1");
	$view_sql2 = $view_db->view($sql2);
	$row2 = $view_db->q($view_sql2);
	if($row2["count_id"])
	{
		$sql_id = array('table'=>'member','where'=>"email = '".$email."' AND password = '".$pass_md5."' AND  status = 1");
		$viewid_sql = $view_db->view($sql_id);
		$row_id = $view_db->q($viewid_sql);

		$_SESSION["simDed_login"] = 1;
		$_SESSION["simDed_mail"] = $row_id["email"];
		$_SESSION["simDed_id"] = $row_id["id"];
		$_SESSION["simDed_name"] = $row_id["name"];
		$_SESSION["simDed_lastname"] = $row_id["lastname"];
		$_SESSION["simDed_type"] = "member";
		?><meta http-equiv="refresh" content="0;URL=../home/" /><?php
		exit;
	}
	else
	{
		?>
            <div class="alert alert-danger alert-dismissible" role="alert">
            <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true" style="font-family:Tahoma">&times;</span></button>
            <strong>Warning!</strong> อีเมล หรือ รหัสผ่านไม่ถูกต้อง กรุณาลองใหม่อีกครั้งค่ะ
            </div>
        <?php
	}
}
else
{
	?>
        <div class="alert alert-danger alert-dismissible" role="alert">
        <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true" style="font-family:Tahoma">&times;</span></button>
        <strong>Warning!</strong> อีเมล หรือ รหัสผ่านไม่ถูกต้อง กรุณาลองใหม่อีกครั้งค่ะ
        </div>
	<?php
}


?>