42 lines
2.0 KiB
PHP
42 lines
2.0 KiB
PHP
<?php
|
|
//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
|
|
include_once($_SERVER["DOCUMENT_ROOT"] . '/include/dbinclude.php');
|
|
|
|
|
|
$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');
|
|
|
|
if($chb["force_logout"]=="Y")
|
|
{
|
|
//header("Location:/forced_signout.php");
|
|
//exit();
|
|
}
|
|
//$_SESSION["cp_userid"]=$user->user_info['user_id'];
|
|
//$_SESSION["pagename"]="Community Page";
|
|
//$_SESSION["nickname"]=$user->user_info['user_username'];
|
|
//$_SESSION["userphoto"]=$user->user_info["user_photo"];
|
|
$sessid=session_id();
|
|
$ip=getRealIpAddr();
|
|
$SESSION["ipaddress"]=$ip;
|
|
$thebrowser=$_SERVER['HTTP_USER_AGENT'];
|
|
if($_SESSION["invisible"]==""){$_SESSION["invisible"]=0;}
|
|
if($chbc==0)
|
|
{
|
|
$sihb="INSERT INTO heartbeat (id, userid, ison, lastsession, pagename,ip,nickname,userphoto,useragent,invisible,blocklist) VALUES('".$_SESSION["goodtoknowyou"]."',".$_SESSION["cp_userid"].",Now(),Now(),'".$_SESSION["pagename"]."','".$ip."','".$_SESSION["nickname"]."','".$_SESSION["userphoto"]."','".$thebrowser."',".$_SESSION["invisible"].",".GetSQLValueString($_SESSION["blocklist"],text).")";
|
|
$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)." WHERE userid = '".$_SESSION["cp_userid"]."'";
|
|
$query=$database->database_query($sql) or $em=$em.$database->database_error();
|
|
}
|
|
$_SESSION["newvisit"]=1;
|
|
?>
|