database_query($chkhb) or $em=$em.$database->database_error(); $chbc=$database->database_num_rows($qchkhb); $chb=$database->database_fetch_assoc($qchkhb); date_default_timezone_set('UTC'); $sqlprofile="SELECT `se_profilevalues`.`profilevalue_4`, `se_profilevalues`.`profilevalue_9`, `se_profilevalues`.`profilevalue_10`, `se_profilevalues`.`profilevalue_12`, `se_profilevalues`.`profilevalue_16`, `se_profilevalues`.`profilevalue_26` FROM `se_profilevalues` WHERE `se_profilevalues`.`profilevalue_user_id` = ".$_SESSION["cp_userid"]; $qprofile=$database->database_query($sqlprofile) or $em=$em.$database->database_error(); $p=$database->database_fetch_assoc($qprofile); $age=$p["profilevalue_4"]; $user_region=$p["profilevalue_12"]; $sexorient=$p["profilevalue_10"]; $csize=$p["profilevalue_9"]; $user_hair=$p["profilevalue_16"]; if($sexorient==""){$sexorient=-1;} if($csize==""){$csize=-1;} if($user_hair==""){$user_hair=-1;} if($sexorient==-1){$sexorient="Not Listed";} elseif($sexorient==1){$sexorient="Gay";} elseif($sexorient==2){$sexorient="Bi";} elseif($sexorient==3){$sexorient="Straight";} elseif($sexorient==4){$sexorient="Trans";} elseif($sexorient==5){$sexorient="Solosexual";} elseif($sexorient==6){$sexorient="Rather Not Say";} if($csize==-1){$csize="Not Listed";} elseif($csize==1){$csize="Small";} elseif($csize==2){$csize="Average";} elseif($csize==3){$csize="Above Average";} elseif($csize==4){$csize="Large";} elseif($csize==5){$csize="Monster";} elseif($csize==6){$csize="Rather Not Say";} if($user_hair==-1){$user_hair="Not Listed";} elseif($user_hair==1){$user_hair="None";} elseif($user_hair==2){$user_hair="Shaved";} elseif($user_hair==3){$user_hair="Average";} elseif($user_hair==4){$user_hair="Chest";} elseif($user_hair==5){$user_hair="Chest and Back";} elseif($user_hair==6){$user_hair="Gorilla";} elseif($user_hair==7){$user_hair="Rather Not Say";} $bday = new DateTime($age); $today = new DateTime('now'); $diff = $today->diff($bday); $age = $diff->y; $ip=getRealIpAddr(); $SESSION["ipaddress"]=$ip; $thebrowser=$_SERVER['HTTP_USER_AGENT']; if($_SESSION["invisible"]==""){$_SESSION["invisible"]=0;} echo $p["profilevalue_26"]; if($p["profilevalue_26"] == 1){$age="";} if($chbc==0) { //temp patch $sqldelcid="DELETE FROM heartbeat WHERE id = '".$_SESSION["goodtoknowyou"]."'"; $database->database_query($sqldelcid) or $em=$em.$database->database_error(); $sihb="INSERT INTO heartbeat (id, userid, ison, lastsession, pagename,ip,nickname,userphoto,useragent,invisible,blocklist,user_age,user_region,user_so,user_cs,user_hair,userlevel) VALUES('".$_SESSION["goodtoknowyou"]."',".$_SESSION["cp_userid"].",Now(),Now(),'".$_SESSION["pagename"]."','".$ip."','".$_SESSION["nickname"]."','".$_SESSION["userphoto"]."','".$thebrowser."',".$_SESSION["invisible"].",".GetSQLValueString($_SESSION["blocklist"],"text").",".GetSQLValueString($age, "int").",".GetSQLValueString($user_region,"text").",".GetSQLValueString($sexorient, "text").",".GetSQLValueString($csize,'text').",".GetSQLValueString($user_hair,'text').",".$_SESSION["cp_userlevel"].")"; $database->database_query($sihb) or $em=$em.$database->database_error(); } else { $sql="UPDATE heartbeat SET ison = Now(), lastsession = Now(), pagename='".$_SESSION["pagename"]."', visits = (visits+1), ip = '".$ip."', userphoto = '".$_SESSION["userphoto"]."', useragent = '".$thebrowser."', invisible = ".$_SESSION["invisible"].", blocklist = ".GetSQLValueString($_SESSION["blocklist"],'text').", user_age = ".GetSQLValueString($age,'int').", user_region = ".GetSQLValueString($user_region, 'text').", user_so = ".GetSQLValueString($sexorient, 'text').", user_cs = ".GetSQLValueString($csize,'text').", user_hair = ".GetSQLValueString($user_hair,'text').", userlevel = ".$_SESSION["cp_userlevel"]." WHERE userid = ".$_SESSION["cp_userid"]; $query=$database->database_query($sql) or $em=$em.$database->database_error(); echo $sql; } $_SESSION["newvisit"]=1; ?>