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



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

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

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

if($row["count_id"])
{
	$sql2 = array('table'=>'shop','count'=>'count(id) AS count_id','where'=>"email = '". $email ."' AND password = '". $pass_md5 ."'");
	$view_sql2 = $view_db->view($sql2);
	$row2 = $view_db->q($view_sql2);	
	if($row2["count_id"])
	{
		$sql_id = array('table'=>'shop','where'=>"email = '".$email."' AND password = '".$pass_md5."'");
		$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"] = "shop";
		$_SESSION["simDed_folder"] = $row_id["codeshop"];
		
		if($row_id['package_expired'] == '0000-00-00')
		{
			?><meta http-equiv="refresh" content="0;URL=../shopadmin/home/index.php"/><?php
			exit;
		}
		else
		{
			if( date("Y-m-d") > $row_id['package_expired'])
			{
				?><meta http-equiv="refresh" content="0;URL=../shopadmin/payment/index.php"/><?php
				exit;
			}
			else
			{
				?><meta http-equiv="refresh" content="0;URL=../shopadmin/home/index.php"/><?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	
}


?>