$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); ?>