64 lines
2.7 KiB
PHP
64 lines
2.7 KiB
PHP
|
|
<?php header('Content-type: application/json');
|
||
|
|
if ( !defined('PATHTOINCLUDES') ) define('PATHTOINCLUDES', $_SERVER["DOCUMENT_ROOT"] . '/cmeter/');
|
||
|
|
include(PATHTOINCLUDES."base.php");
|
||
|
|
$loginid=$_GET['loginid']; // user_id
|
||
|
|
$username=$_GET['username'];
|
||
|
|
$pagename=$_GET['pagename'];
|
||
|
|
$useragent=$_SERVER['HTTP_USER_AGENT'];
|
||
|
|
$ip=getRealIpAddr();
|
||
|
|
$em="";
|
||
|
|
$dbcon=dbconnect3();
|
||
|
|
// check for possible registration flag
|
||
|
|
if(!isset($_SESSION["setstate"])){
|
||
|
|
$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();
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
$chkhb="SELECT userid 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);
|
||
|
|
|
||
|
|
if($chbc==0)
|
||
|
|
{
|
||
|
|
$sihb="INSERT INTO track (id, userid, displayname, ison,lastsession,pagename,ip,useragent) VALUES('".$_SESSION["goodtoknowyou"]."',".$loginid.",'".$username."',UTC_TIMESTAMP(),UTC_TIMESTAMP(),'".$pagename."','".$ip."','".$useragent."')";
|
||
|
|
$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"]=$_COOKIE["goodtoknowyou"];
|
||
|
|
}
|
||
|
|
else {
|
||
|
|
$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) 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() WHERE userid = ".$loginid." AND id = '".$_SESSION["goodtoknowyou"]."'";
|
||
|
|
$qtrack=mysql_query($sqltrack) or $em=$em.mysql_error();
|
||
|
|
}
|
||
|
|
?>
|