".$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 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) VALUES('".$_SESSION["goodtoknowyou"]."',".$loginid.",'".$username."',UTC_TIMESTAMP(),UTC_TIMESTAMP(),'".$pagename."','".$ip."','".$useragent."','".$useremail."',".$userlevel.")"; //$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." 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." WHERE userid = ".$loginid." OR id = '".$_SESSION["goodtoknowyou"]."'"; $qtrack=mysql_query($sqltrack) or $em=$em.mysql_error(); } ?>