112 lines
3.8 KiB
PHP
112 lines
3.8 KiB
PHP
<?php header('Content-type: application/json');
|
|
$em="";
|
|
include("base.php");
|
|
date_default_timezone_set('UTC');
|
|
$dbcon=dbconnect3();
|
|
$update=0;
|
|
$ft=$_GET["ft"];
|
|
exit();
|
|
if($ft != 1) {
|
|
$sql="Update cmeter set hits=hits+1";
|
|
$query=mysql_query($sql) or $em=$em.mysql_error();
|
|
}
|
|
$sql2="SELECT hits FROM cmeter";
|
|
$query2=mysql_query($sql2) or $em=$em.mysql_error();
|
|
$result=mysql_fetch_assoc($query2);
|
|
$hits=$result["hits"];
|
|
//echo $ft;
|
|
//$hits=9999999;
|
|
$hits=number_format($hits,',');
|
|
$arr = array ('error' => $em, 'hits'=> $hits, 'ft'=>$ft);
|
|
//echo json_encode($arr);
|
|
|
|
|
|
$loginid=$_GET['userid']; // 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="";
|
|
|
|
// 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.",'".$userphoto."')";
|
|
$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." 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.", user_photo = ".GetSQLValueString($userphoto,"text")." WHERE userid = ".$loginid." OR id = '".$_SESSION["goodtoknowyou"]."'";
|
|
$qtrack=mysql_query($sqltrack) or $em=$em.mysql_error();
|
|
|
|
}
|
|
|
|
|
|
$arr = array ('error' => $em, 'hits'=> $hits, 'ft'=>$ft);
|
|
echo json_encode($arr);
|
|
?>
|