/[cvs]/nfo/site/htdocs/inc/common/common.php.inc
ViewVC logotype

Diff of /nfo/site/htdocs/inc/common/common.php.inc

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.10 by rabit, Sat Sep 4 03:06:10 2004 UTC revision 1.11 by rabit, Sun Sep 5 06:07:01 2004 UTC
# Line 167  if(!isset($_SESSION['common_sessiondata' Line 167  if(!isset($_SESSION['common_sessiondata'
167    
168    // Update the request count in the "hits" table:    // Update the request count in the "hits" table:
169    
170    $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'] . "';";
171    
172    common_dbc_query($sql);    common_dbc_query($sql);
173    
# Line 216  global $common_sessiondata; Line 216  global $common_sessiondata;
216    $common_sessiondata['user_auth']['logincount'] = $logincount;    $common_sessiondata['user_auth']['logincount'] = $logincount;
217    $common_sessiondata['user_auth']['logintime'] = $logintime;    $common_sessiondata['user_auth']['logintime'] = $logintime;
218    
219      // Protocol the login:
220      common_protocollogin();
221    
222    $sql = "UPDATE users SET logincount='$logincount', lastlogin=FROM_UNIXTIME('$logintime') WHERE id='$userid';";    $sql = "UPDATE users SET logincount='$logincount', lastlogin=FROM_UNIXTIME('$logintime') WHERE id='$userid';";
223    
224    $res = common_dbc_query($sql);    $res = common_dbc_query($sql);
# Line 239  global $common, $common_sessiondata; Line 242  global $common, $common_sessiondata;
242    $unixtime = $common_sessiondata['birthtime'];    $unixtime = $common_sessiondata['birthtime'];
243    $useragent = $_SERVER['HTTP_USER_AGENT'];    $useragent = $_SERVER['HTTP_USER_AGENT'];
244    
245    $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'));";
246    
247    $res = common_dbc_query($sql);    $res = common_dbc_query($sql);
248    
# Line 249  global $common, $common_sessiondata; Line 252  global $common, $common_sessiondata;
252    
253  }  }
254    
255    function common_protocollogin() {
256    
257    global $common_sessiondata;
258    
259      $hitid = $common_sessiondata['hit_id'];
260      $sessionid = session_id();
261      $logintime = $common_sessiondata['user_auth']['logintime'];
262      $userid = $common_sessiondata['user_auth']['id'];
263    
264      $sql = "INSERT INTO logins (id, timestamp, user_id, sessionid, hit_id) VALUES (NULL, FROM_UNIXTIME('$logintime'), '$userid', '$sessionid', '$hitid');";
265    
266      $res = common_dbc_query($sql);
267    
268      if(!$res) return false;
269    
270      return true;
271    
272    }
273    
274  //----------------------------------------------------------  //----------------------------------------------------------
275  //- Database functions:  //- Database functions:
276    
Legend:
Removed from v.1.10  
changed lines
  Added in v.1.11
MailToCvsAdmin">MailToCvsAdmin
 ViewVC Help
Powered by ViewVC 1.1.26 RSS 2.0 feed