diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-12-15 16:40:35 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-12-15 16:40:35 +0000 |
| commit | 284dbec9cfcaa1479e56582540c25a1590878cf7 (patch) | |
| tree | 52c24f42cfd4a1c2c1f3904089646a96cc461fa2 /phpBB/includes | |
| parent | ec67266aa508fa6be5764c5f78fc8ae0743ae693 (diff) | |
| download | forums-284dbec9cfcaa1479e56582540c25a1590878cf7.tar forums-284dbec9cfcaa1479e56582540c25a1590878cf7.tar.gz forums-284dbec9cfcaa1479e56582540c25a1590878cf7.tar.bz2 forums-284dbec9cfcaa1479e56582540c25a1590878cf7.tar.xz forums-284dbec9cfcaa1479e56582540c25a1590878cf7.zip | |
Various changes to accompany session updates ... MSSQL users should be prepared to alter or remove the session_last_visit field or face potential problems
git-svn-id: file:///svn/phpbb/trunk@1588 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes')
| -rw-r--r-- | phpBB/includes/sessions.php | 21 |
1 files changed, 5 insertions, 16 deletions
diff --git a/phpBB/includes/sessions.php b/phpBB/includes/sessions.php index 522911ee81..3c1f3814d0 100644 --- a/phpBB/includes/sessions.php +++ b/phpBB/includes/sessions.php @@ -152,7 +152,7 @@ function session_begin($user_id, $user_ip, $page_id, $session_length, $auto_crea // Create or update the session // $sql = "UPDATE " . SESSIONS_TABLE . " - SET session_user_id = $user_id, session_start = $current_time, session_time = $current_time, session_last_visit = " . $sessiondata['lastvisit'] . ", session_page = $page_id, session_logged_in = $login + SET session_user_id = $user_id, session_start = $current_time, session_time = $current_time, session_page = $page_id, session_logged_in = $login WHERE session_id = '" . $session_id . "' AND session_ip = '$user_ip'"; $result = $db->sql_query($sql); @@ -162,8 +162,8 @@ function session_begin($user_id, $user_ip, $page_id, $session_length, $auto_crea $session_id = md5(uniqid($user_ip)); $sql = "INSERT INTO " . SESSIONS_TABLE . " - (session_id, session_user_id, session_start, session_time, session_last_visit, session_ip, session_page, session_logged_in) - VALUES ('$session_id', $user_id, $current_time, $current_time, " . $sessiondata['lastvisit'] . ", '$user_ip', $page_id, $login)"; + (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) + VALUES ('$session_id', $user_id, $current_time, $current_time, '$user_ip', $page_id, $login)"; $result = $db->sql_query($sql); if(!$result) { @@ -182,10 +182,9 @@ function session_begin($user_id, $user_ip, $page_id, $session_length, $auto_crea } $sessiondata['autologinid'] = ( $enable_autologin && $sessionmethod == SESSION_METHOD_COOKIE ) ? $auto_login_key : ""; + $sessiondata['userid'] = $user_id; } - $sessiondata['userid'] = $user_id; - $serialised_cookiedata = serialize($sessiondata); setcookie($cookiename . '_data', $serialised_cookiedata, ($current_time + 31536000), $cookiepath, $cookiedomain, $cookiesecure); setcookie($cookiename . '_sid', $session_id, 0, $cookiepath, $cookiedomain, $cookiesecure); @@ -392,19 +391,9 @@ function session_end($session_id, $user_id) { unset($sessiondata['autologinid']); } - - $sql = "UPDATE " . USERS_TABLE . " - SET user_lastvisit = " . time() . " - WHERE user_id = $user_id"; - $result = $db->sql_query($sql); - if (!$result) - { - message_die(CRITICAL_ERROR, "Couldn't reset user autologin key : session_end", "", __LINE__, __FILE__, $sql); - } - } - $sessiondata['userid'] = ANONYMOUS; + unset($sessiondata['userid']); $serialised_cookiedata = serialize($sessiondata); setcookie($cookiename . '_data', $serialised_cookiedata, ($current_time + 31536000), $cookiepath, $cookiedomain, $cookiesecure); |