Files
Testing/mailservices/includes/validate.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

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
?>