Files
Testing/cmeter/update_state2.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

86 lines
3.4 KiB
PHP

<?php header('Content-type: application/json');
if ( !defined('PATHTOINCLUDES') ) define('PATHTOINCLUDES', $_SERVER["DOCUMENT_ROOT"] . '/cmeter/');
include(PATHTOINCLUDES."base.php");
exit();
$loginid=$_GET['loginid']; // user_id
$username=$_GET['username'];
$pagename=$_GET['pagename'];
$useragent=$_SERVER['HTTP_USER_AGENT'];
$userinvisible=$_GET["userinvisible"];
$useremail=$_GET["useremail"];
$userlevel=$_GET["userlevel"];
$userphoto=$_GET["userphoto"];
$ip=getRealIpAddr();
$em="";
$dbcon=dbconnect3();
// check for possible registration flag
//echo $_SESSION["goodtoknowyou"];
$sqlrflag="SELECT count(id) AS rflag FROM track WHERE id = '".$_SESSION["goodtoknowyou"]."' AND userid <> ".$loginid;
$qrflag=mysql_query($sqlrflag) or $em=$em.mysql_error();
$f=mysql_fetch_assoc($qrflag);
if($f["rflag"] > 0)
{
$sqlsetflag="UPDATE track SET registration_flag = 'Y', flag_userid = ".$loginid." WHERE id = '".$_SESSION["goodtoknowyou"]."'";
$qrflag=mysql_query($sqlsetflag) or $em=$em.mysql_error();
}
if(!isset($_SESSION["setstate"])){
$chkhb="SELECT count(userid) AS thecount FROM track WHERE id = '".$_SESSION['goodtoknowyou']."'";
$qchkhb=mysql_query($chkhb) or $em=$em.mysql_error();
$chbc=mysql_num_rows($qchkhb);
$chb=mysql_fetch_assoc($qchkhb);
$chbc=$chb["thecount"];
if($chbc==0)
{
$sihb="INSERT INTO track (id, userid, displayname, ison,lastsession,pagename,ip,useragent,user_email,user_level,user_photo)
VALUES('".$_SESSION["goodtoknowyou"]."',".$loginid.",'".$username."',UTC_TIMESTAMP(),UTC_TIMESTAMP(),'".$pagename."','".$ip."','".$useragent."','".$useremail."',".$userlevel.",".GetSQLValueString($userphoto, "text").")";
$qihb=mysql_query($sihb) or $em=$em.mysql_error();
$sqlcp="SELECT id FROM track WHERE userid = ".$loginid." AND id <> '".$_SESSION["goodtoknowyou"]."'";
$qcp=mysql_query($sqlcp) or $em=$em.mysql_error();
$dup=mysql_num_rows($qcp);
if($dup > 0)
{
$sqlgp="SELECT id FROM track WHERE userid = ".$loginid." AND `track`.`primary` = 'Y'";
$qgp=mysql_query($sqlgp) or $em=$em.mysql_error();
$p=mysql_fetch_assoc($qgp);
setcookie('goodtoknowyou','',time()-3600);
$expire=strtotime("+3 years");
setcookie('goodtoknowyou', $p['id'], $expire,'/', false, 0);
$_SESSION["goodtoknowyou"]=$p['id'];
}
else {
$qihb=mysql_query($sihb) or $em=$em.mysql_error();
$sqlprimary="UPDATE track SET `track`.`primary` = 'Y' WHERE userid = ".$loginid." AND id = '".$_SESSION["goodtoknowyou"]."'";
$qprimary=mysql_query($sqlprimary) or $em=$em.mysql_error();
}
}
$_SESSION["setstate"]=1;
} //end setstate
if(!isset($_SESSION["firsthitmade"]))
{
$sqltrack="UPDATE track SET ison = UTC_TIMESTAMP(),
lastsession = UTC_TIMESTAMP(),
visits = (visits+1),
displayname = '".$username."',
pagename = '".$pagename."',
useragent = '".$useragent."',
user_email = '".$useremail."',
user_level = '".$userlevel."',
user_invisible = ".$userinvisible.",
user_photo = ".GetSQLValueString($userphoto, "text")."
WHERE userid = ".$loginid." AND id = '".$_SESSION["goodtoknowyou"]."'";
$qtrack=mysql_query($sqltrack) or $em=$em.mysql_error();
$_SESSION["firsthitmade"]="Yes";
}
else {
$sqltrack="UPDATE track SET ison = UTC_TIMESTAMP(), pagename = '".$pagename."', user_invisible = ".$userinvisible." WHERE userid = ".$loginid." OR id = '".$_SESSION["goodtoknowyou"]."'";
$qtrack=mysql_query($sqltrack) or $em=$em.mysql_error();
}
$arr = array ('error' => $em);
echo json_encode($arr);
?>