183 lines
4.5 KiB
PHP
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;
|
|
|
|
?>
|
|
|