155 lines
4.7 KiB
PHP
155 lines
4.7 KiB
PHP
|
|
<?php header('Content-type: application/json');
|
||
|
|
if ( !defined('PATHTOINCLUDES') ) define('PATHTOINCLUDES', $_SERVER["DOCUMENT_ROOT"] . '/mailservices/includes/');
|
||
|
|
include(PATHTOINCLUDES."base.php");
|
||
|
|
if(!isset($_SESSION["login_attempts"])){$_SESSION["login_attempts"]=0;}
|
||
|
|
|
||
|
|
$_SESSION["login_attempts"]=$_SESSION["login_attempts"]++;
|
||
|
|
if($_SESSION["login_attempts"]==5)
|
||
|
|
{
|
||
|
|
//captcha
|
||
|
|
}
|
||
|
|
|
||
|
|
if(!isset($_POST["user"]) || !isset($_POST["pass"]))
|
||
|
|
{
|
||
|
|
$arr = array ('rights'=>"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="
|
||
|
|
<ul id=\"login-menu\">
|
||
|
|
<li><a href=\"javascript:donothing();\" onclick=\"signout();\" class=\"mi-last\">Sign Out</a></li>
|
||
|
|
<li><a href=\"javascript:donothing();\" onclick=\"getdashboard('/mailservices/bateworld/dashboard.php','content','/mailservices/bateworld/users.php','section_content');\">B8World</a></li>
|
||
|
|
<li><a href=\"javascript:donothing();\" onclick=\"getdashboard('/mailservices/admin/dashboard.php','content','/mailservices/admin/usermgr/accounts.php','section_content');\">Admin</a></li>
|
||
|
|
<li><a href=\"javascript:donothing();\" onclick=\"getdashboard('/mailservices/ads/dashboard.php','content','/mailservices/ads/ads.php','section_content');\">Ads</a></li>
|
||
|
|
</ul>
|
||
|
|
";
|
||
|
|
$_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
|
||
|
|
?>
|