Files
Testing/include/analytics/setstate3.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

183 lines
4.5 KiB
PHP

<?php if ( !defined('PATHTOINCLUDES') ) define('PATHTOINCLUDES', $_SERVER["DOCUMENT_ROOT"] . '/include/analytics/');
ini_set('session.bug_compat_warn', 0);
ini_set('session.bug_compat_42', 0);
include_once(PATHTOINCLUDES."base.php");
/* $Id: community.php 59 2012-03-25 03:25:54Z phil $ */
//copyright 2008 Philip Poremba
//no one may use this code
//inserting or updating heartbeat and clearing values that might be held over from previous session that we want to reset
$em="";
$chkhb="SELECT nickname FROM heartbeat WHERE userid = ".$_SESSION["cp_userid"];
$qchkhb=$database->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;
?>