"0", 'authorized'=> "0", 'msg'=>"Credentials Not Verified. Security is being enhanced.", 'ecode' => "1"); echo json_encode($arr); exit(); } $em=""; $filters = array ( "user" => array ( "filter"=>FILTER_SANITIZE_STRING ), "pass" => array ( "filter"=>FILTER_SANITIZE_STRING ), ); $result=filter_input_array(INPUT_POST, $filters); $emsg=""; $em=""; $pass=trim($_POST["pass"]); $user=trim($_POST["user"]); $dbcon=dbconnect2(); $sql="SELECT `users`.`uid`, `users`.`cookieid`, `users`.`active`, `users`.`firstname`, `users`.`mi`, `users`.`lastname`, `users`.`salutation`, `users`.`email`, `users`.`user`, `users`.`pass`, `users`.`admin`, `users`.`default_admin`, `users`.`nickname`, `heartbeat`.`userid` FROM `users` Left Outer Join `heartbeat` ON `heartbeat`.`id` = `users`.`cookieid` WHERE user = AES_ENCRYPT(".GetSQLValueString($user, "text").",'".$wordgames."') AND pass = AES_ENCRYPT(".GetSQLValueString($pass, "text").",'".$wordgames."')"; $query=mysql_query($sql) or $em=mysql_error(); if($em != "") { $arr = array ('rights'=>"0", 'authorized'=> "0", 'msg'=>"System error.", 'ecode' => "2"); echo json_encode($arr); exit(); } if(mysql_num_rows($query) != 1) { $arr = array ('rights'=>"0", 'authorized'=> "0", 'msg'=>"Authorization Failed.", 'ecode' => "3"); echo json_encode($arr); exit(); } $u=mysql_fetch_assoc($query); //handle cookieid date_default_timezone_set('UTC'); $thedate=date("Y-m-d H:i:s"); if($_COOKIE["goodtoknowyou"] != $u["cookieid"] || $u["cookieid"]=="") { $sql1="UPDATE users SET cookieid = '".$_COOKIE["goodtoknowyou"]."' WHERE uid = ".$u["uid"]; $query1=mysql_query($sql1) or $em=mysql_error(); } if($u["active"]=="N") { $arr = array ('rights'=>"0", 'authorized'=> "0", 'msg'=>"Your account has been deactivate.", 'ecode' => "4"); echo json_encode($arr); exit(); } $_SESSION["authorized"]=1; $_SESSION["rights"]=0; $_SESSION["userid"]=$u["uid"]; $_SESSION["email"]=$u["email"]; $_SESSION["nickname"]=$u["nickname"]; ///log out any other users signed in with the userid --- ///collect data on users with userid $sqlmu="SELECT id, ip, sessionid FROM heartbeat WHERE userid=".$u["uid"]." AND id <> '".$_COOKIE["goodtoknowyou"]."'"; $qlmu=mysql_query($sqlmu); if(mysql_num_rows($qlmu) >=1) { while ($mu = mysql_fetch_assoc($qlmu)) { $sql="INSERT INTO multiple_browser_logins (userid,cookieid,thedate,ipaddress) VALUES(".$_SESSION["userid"].",'".$mu["id"]."', UTC_TIMESTAMP(), '".$mu["ip"]."','".$mu["sessionid"]."')"; $query=mysql_query($sql) or $em=$em.mysql_error(); } $sqltwo="UPDATE heartbeat SET userid = null, nickname = null, force_logout = 'Y' WHERE id <> '".$_COOKIE["goodtoknowyou"]."' AND userid = '".$_SESSION["userid"]."'"; $querytwo=mysql_query($sqltwo); } if($u["userid"] != $u["uid"]) { $sqla="UPDATE heartbeat SET userid = null WHERE userid=".$u["uid"]; $qsqla=mysql_query($sqla); } //this won't be needed once user registration is set up if(isset($_SESSION["authorized"])) { $sql="UPDATE heartbeat SET userid = ".$_SESSION["userid"].", nickname = '".$_SESSION["nickname"]."', signin = 'Y' WHERE id = '".$_COOKIE["goodtoknowyou"]."'"; $query=mysql_query($sql); } $sql3="UPDATE users SET logged_in = 'Y', lastlogin = UTC_TIMESTAMP() WHERE uid = ".$u["uid"]; $query3=mysql_query($sql3); $rights=1; if($u["admin"]=="Y") { $rights=2; } if($u["default_admin"]=="Y") { $rights=3; $_SESSION["default_admin"]="Y"; } $menu=" "; $_SESSION["rights"]=$rights; $arr = array ('rights'=>$rights, 'authorized'=> "1", 'msg'=>"", 'ecode' => "0", 'menu'=>$menu); echo json_encode($arr); exit(); //written by Philip Poremba - 05/03/2012 All rights reserved ?>