// include required files
require_once("classes/legoFront.class.php");
// instantiate class and connect to database
$classOBJ = new LegoFront();
$classOBJ->_connect();
// get session id
$sid = session_id();
if ($_SESSION['ses_user_id']!="") {
header("Location: dashboard.php?PHPSESSID=$sid");
}
if ($_POST['mode']=="login") {
foreach($_POST as $key => $value) {
$$key = str_replace("'","`",trim(mysql_real_escape_string($value)));
}
$err = "";
if($email=="" || $classOBJ->validateEmail($email) !=1 ){
$err.= "- Enter valid user name [email].
";
}
if($password==""){
$err.= "- Enter password.
";
}
if ($err=="") {
$sql = "SELECT a.id, CONCAT(a.fname, ' ',a.lname) as name FROM lg_user_a a, lg_users_c c WHERE a.id=c.c_user_id AND email='$email' AND a.status='1' AND c.password='".md5($password)."'";
$result = mysql_query($sql);
if (mysql_num_rows($result)>0) {
$row = mysql_fetch_array($result);
$last_login_time = date('Y-m-d H:i:s');
$sql = "UPDATE lg_user_a SET last_login_time='$last_login_time' WHERE id='".intval($row['id'])."'";
$classOBJ->query($sql);
if ($_SESSION['ses_cookies_status']==1) {
if ($rem=="true") {
$enc_password = base64_encode($password);
setcookie("login_email", $email, time()+604800);
setcookie("login_pass", $enc_password, time()+604800);
} else {
setcookie("login_email","", time()-604800);
setcookie("login_pass","", time()-604800);
}
}
$_SESSION['ses_user_id'] = $row['id'];
$_SESSION['ses_user_name'] = $row['name'];
header("Location: dashboard.php?PHPSESSID=$sid");
exit;
} else {
$err.= "- Login incorrect
";
}
}
}
// import_request_variables("gpc");
?>