Snippets Other
Other
Super user session tracker with PHP, mySql and Cookies .
by: DarkLight
|
April 3, 2004
Version: 1.0
Type: Class
Category: Other
License: GNU General Public License
Description: It works like this . It creates an id for every user that visits the site . It sets a cookie for him . The cookie contains the unique id that is a row in a table . Expired users are automatically remove from db . $Tracker=new UserTracker(); $Tracker->setVar("name","value"); $Tracker->getVar("name"); $Tracker->delVar("name"); //initiate mysql connection before using this . it creates table if missing . you can keep login count , user status , informations , online users , ... , anything .
<?php
//You can do anything with this but you can't claim it or remove this line and the next .
//Copyright : darklight@home.ro 2004 . send feedback here .
class UserTracker
{
/*
$trackerTable;
$newSession;
$trackerID;
$expireTime;
$cookieName;
isNewSession();
is this the first visit in the seesion.
listUsers();
returns an array with all the users available.
userCount($max=0);
returns and user count . the tricky thing is this :
you can set sessions to expire in 1 year .
but this doesn't mean the user is online .
$max=means the maximum offline time .
so you can count the users who loaded your page in the last $max minutes .
endSession($uid="");
end this session. get rid of cookie and db info .
getIP($uid="");
get the ip of an users . left blank returns yours .
getUserAgent($uid="");
get the browser of an users . left blank returns yours .
loginTime($uid="");
get the online time of an user . left blank returns yours .
this is the time from the tracking begin utill the last time he loaded the page .
smaller than expire time .
delVar($name,$uid="");
delete a var
getVar($name,$uid="");
get a var . this vars can be any php vars .
setVar($name,$data,$uid="");
any php var . the content is serialized .
lastVisitTime($uid="");
myID();
my uid .
getTableName();
table name .
setExpiryTime($minutes);
session expiry time . this is set when you initiate the class but if you want to
give certain users longer sessions you set the time here .
getExpiryTime();
get the expire time .
*/
var $trackerTable="UTracker";
var $newSession=0;
var $trackerID="";
var $expireTime=15;
var $cookieName="CTracker";
function UserTracker ($table="UTracker",$cookie="CTracker",$minutes=15)
{
if($minutes<15)
$minutes=15;
$this->expireTime=$minutes;
$this->cookieName=$cookie;
$this->trackerTable=$table;
$query="CREATE TABLE IF NOT EXISTS `".$this->trackerTable."` (
`UID` int(10) unsigned NOT NULL auto_increment,
`ID` varchar(35) NOT NULL,
`JTime` int(15) NOT NULL,
`Time` int(15) NOT NULL,
`Expire` int(10) NOT NULL,
`IP` varchar(15) NOT NULL default '',
`UserAgent` varchar(255) NOT NULL default '',
`Data` text NOT NULL default '',
PRIMARY KEY (`UID`)
) TYPE=MyISAM";mysql_query ($query);
//remove all the expired sessions . no need to keep them . cookies are long gone anyway .
$query="DELETE FROM `".$this->trackerTable."` WHERE (".time()."-Time)>Expire";
mysql_query($query);
$this->trackerID=$_COOKIE["$cookie"];
$query="SELECT * FROM `".$this->trackerTable."` WHERE `ID`='".$this->trackerID."'";
$result=mysql_query($query);
$rec=array();
$rows=(int)mysql_num_rows($result);
if($rows>0)
{
$rec=mysql_fetch_assoc($result);
$this->expireTime=(int)$rec['Expire']/60;
}
//if the id is not in the database we create a new one even if we have an orphan cookie .
if(($this->trackerID=="") || ($rows==0))
{
$this->trackerID=md5((string)time().$_SERVER["HTTP_USER_AGENT"].$_SERVER["REMOTE_ADDR"]);
//make sure there are no two identical sessions . it can`t happen for two different users from different hosts .
$query="DELETE FROM `".$this->trackerTable."` WHERE `ID`=".$this->trackerID;
mysql_query($query);
setCookie($cookie,$this->trackerID,time()+($this->expireTime*60));
$query="INSERT INTO `".$this->trackerTable."` (`ID`,`Time`,`JTime`,`Expire`,`Data`,`UserAgent`,`IP`) VALUES ('".$this->trackerID."','".time()."','".time()."','".($this->expireTime*60)."','".serialize(array())."','".$_SERVER["HTTP_USER_AGENT"]."','".$_SERVER["REMOTE_ADDR"]."')";
$result=mysql_query($query);
$this->newSession=1;
}
else
{
setCookie("$cookie",$this->trackerID,time()+($this->expireTime*60));
//make the life of the cookie longer and update time and IP .
$query="UPDATE `".$this->trackerTable."` SET `Time`='".time()."',`IP`='".$_SERVER["REMOTE_ADDR"]."' WHERE `ID`='".$this->trackerID."'";
$result=mysql_query($query);
$this->newSession=0;
}
}
function getExpiryTime()
{
return $this->expireTime;
}
function setExpiryTime($minutes)
{
if($minutes<15)
$minutes=15;
$this->expireTime=$minutes;
$query="UPDATE `".$this->trackerTable."` SET `Expire`='".($this->expireTime*60)."' WHERE `ID`='".$this->trackerID."'";
$result=mysql_query($query);
}
function myID()
{
return $this->trackerID;
}
function getTableName()
{
return $this->trackerTable;
}
function isNewSession()
{
return (bool)($this->newSession==1);
}
function setVar($name,$value,$uid="")
{
if($uid=="")
$uid=$this->trackerID;
$data=array();
$query="SELECT `Data` FROM `".$this->trackerTable."` WHERE `ID`='".$uid."'";
$result=mysql_query($query);
if(mysql_num_rows($result)>0)
{
$rec=mysql_fetch_array($result);
$data=unserialize($rec[0]);
if(!is_array($data))
$data=array();
mysql_free_result($result);
}
$data["$name"]=$value;
$query="UPDATE `".$this->trackerTable."` SET `Data`='".serialize($data)."' WHERE `ID`='".$uid."'";
$result=mysql_query($query);
}
function delVar($name,$uid="")
{
if($uid=="")
$uid=$this->trackerID;
$data=array();
$query="SELECT `Data` FROM `".$this->trackerTable."` WHERE `ID`='".$uid."'";
$result=mysql_query($query);
if(mysql_num_rows($result)>0)
{
$rec=mysql_fetch_array($result);
$data=unserialize($rec[0]);
if(!is_array($data))
$data=array();
mysql_free_result($result);
}
unset($data["$name"]);
$query="UPDATE `".$this->trackerTable."` SET `Data`='".serialize($data)."' WHERE `ID`='".$uid."'";
$result=mysql_query($query);
}
function getVar($name,$uid="")
{
if($uid=="")
$uid=$this->trackerID;
$data=array();
$query="SELECT `Data` FROM `".$this->trackerTable."` WHERE `ID`='".$uid."'";
$result=mysql_query($query);
if(mysql_num_rows($result)>0)
{
$rec=mysql_fetch_array($result);
$data=unserialize($rec[0]);
if(!is_array($data))
$data=array();
mysql_free_result($result);
}
return $data["$name"];
}
function loginTime($uid="")
{
if($uid=="")
$uid=$this->trackerID;
$data=0;
$query="SELECT `JTime` FROM `".$this->trackerTable."` WHERE `ID`='".$uid."'";
$result=mysql_query($query);
if(mysql_num_rows($result)>0)
{
$rec=mysql_fetch_array($result);
$data=$rec[0];
mysql_free_result($result);
}
return $data;
}
function lastVisitTime($uid="")
{
if($uid=="")
$uid=$this->trackerID;
$data=0;
$query="SELECT `Time` FROM `".$this->trackerTable."` WHERE `ID`='".$uid."'";
$result=mysql_query($query);
if(mysql_num_rows($result)>0)
{
$rec=mysql_fetch_array($result);
$data=$rec[0];
mysql_free_result($result);
}
return $data;
}
function getUserAgent($uid="")
{
if($uid=="")
$uid=$this->trackerID;
$data="";
$query="SELECT `UserAgent` FROM `".$this->trackerTable."` WHERE `ID`='".$uid."'";
$result=mysql_query($query);
if(mysql_num_rows($result)>0)
{
$rec=mysql_fetch_array($result);
$data=$rec[0];
mysql_free_result($result);
}
return $data;
}
function getIP($uid="")
{
if($uid=="")
$uid=$this->trackerID;
$data="";
$query="SELECT `IP` FROM `".$this->trackerTable."` WHERE `ID`='".$uid."'";
$result=mysql_query($query);
if(mysql_num_rows($result)>0)
{
$rec=mysql_fetch_array($result);
$data=$rec[0];
mysql_free_result($result);
}
return $data;
}
function userCount($max=0)
{
$query="SELECT COUNT(*) FROM `".$this->trackerTable."`";
if($maxSleep>0)
$query.=" WHERE (".time()."-`JTime`)<".($max*60)."";
$result=mysql_query($query);
$rec=mysql_fetch_array($result);
return (int)$rec[0];
}
function listUsers()
{
$uids=array();
$result=mysql_query("SELECT `ID` FROM `".$this->trackerTable."`");
if(mysql_num_rows($result)>0)
{
while($rec=mysql_fetch_array($result))
{
array_push($uids,$rec[0]);
}
mysql_free_result($result);
}
return $uids;
}
function endSession($uid="")
{
if($uid=="")
$uid=$this->trackerID;
$query="DELETE FROM `".$this->trackerTable."` WHERE `ID`='".$uid."'";
mysql_query($query);
}
};
?>
PHPBuilder
Policies
PHP Developer
Topics
PHP Developer
Resources
PHP Developer
References
