--- nfo/site/htdocs/inc/common/common.php.inc 2004/09/04 03:06:10 1.10 +++ nfo/site/htdocs/inc/common/common.php.inc 2004/09/05 06:07:01 1.11 @@ -4,7 +4,7 @@ --- Setup and common functions include file. -------------------------------------------------------------------------------- --- rabit, 04:31 24.08.2004 ---- $Id: common.php.inc,v 1.10 2004/09/04 03:06:10 rabit Exp $ +--- $Id: common.php.inc,v 1.11 2004/09/05 06:07:01 rabit Exp $ ------------------------------------------------------------------------------*/ //------------------------------------------------------------------------------ @@ -167,7 +167,7 @@ // Update the request count in the "hits" table: - $sql = "UPDATE hits SET requestcount=requestcount+1 WHERE id='" . $common_sessiondata['hit_id'] . "';"; + $sql = "UPDATE hits SET requestcount=requestcount+1, lastrequest=NOW() WHERE id='" . $common_sessiondata['hit_id'] . "';"; common_dbc_query($sql); @@ -216,6 +216,9 @@ $common_sessiondata['user_auth']['logincount'] = $logincount; $common_sessiondata['user_auth']['logintime'] = $logintime; + // Protocol the login: + common_protocollogin(); + $sql = "UPDATE users SET logincount='$logincount', lastlogin=FROM_UNIXTIME('$logintime') WHERE id='$userid';"; $res = common_dbc_query($sql); @@ -239,7 +242,7 @@ $unixtime = $common_sessiondata['birthtime']; $useragent = $_SERVER['HTTP_USER_AGENT']; - $sql = "INSERT INTO hits (id, timestamp, address, entryurl, referer, sessionid, useragent, requestcount) VALUES (NULL, FROM_UNIXTIME('$unixtime'), '$address', '$entryurl', '$referer', '$sessionid', '$useragent', '1');"; + $sql = "INSERT INTO hits (id, timestamp, address, entryurl, referer, sessionid, useragent, requestcount, lastrequest) VALUES (NULL, FROM_UNIXTIME('$unixtime'), '$address', '$entryurl', '$referer', '$sessionid', '$useragent', '1', FROM_UNIXTIME('$unixtime'));"; $res = common_dbc_query($sql); @@ -249,6 +252,25 @@ } +function common_protocollogin() { + +global $common_sessiondata; + + $hitid = $common_sessiondata['hit_id']; + $sessionid = session_id(); + $logintime = $common_sessiondata['user_auth']['logintime']; + $userid = $common_sessiondata['user_auth']['id']; + + $sql = "INSERT INTO logins (id, timestamp, user_id, sessionid, hit_id) VALUES (NULL, FROM_UNIXTIME('$logintime'), '$userid', '$sessionid', '$hitid');"; + + $res = common_dbc_query($sql); + + if(!$res) return false; + + return true; + +} + //---------------------------------------------------------- //- Database functions: