Posted by Steve on 10/14/06 00:23

ok...been a long day.

you'll need this function too (last one, promise). either put a call to it
in each page or call the function in an include_once or require_once php
file. notice that it has to call the db::execute function too...so, replace
that call with dbExecute.

function siteTracking($page, $user)
{
$ip = '';
if (!$ip = $_SERVER['HTTP_CLIENT_IP'])
{
if (!$ip = $_SERVER['HTTP_X_FORWARDED_FOR'])
{
if (!$ip = $_SERVER['REMOTE_ADDR']){ $ip = 'UNKNOWN'; }
}
}
$sql = "
INSERT INTO siteTracking
(
Page ,
IpAddress ,
UserName ,
Stamp
)
VALUES
(
'" . $page . "' ,
'" . $ip . "' ,
'" . $user . "' ,
'" . date('Y-m-d H:i:s') . "'
)
";
db::execute($sql);
}

to call this function, you'd do something like this:

siteTracking(basename($_SERVER['PHP_SELF']), $userName);

where $userName is the variable that holds the user name of a logged on
user. change $userName to the appropriate variable. this way you can tell
not only ip's but what person was accessing a page.

[Back to original message]