diff options
| author | Jim Wigginton <terrafrost@phpbb.com> | 2009-09-04 14:53:35 +0000 |
|---|---|---|
| committer | Jim Wigginton <terrafrost@phpbb.com> | 2009-09-04 14:53:35 +0000 |
| commit | 295fb5373ae0a37bfbc36a4461dc3ed2c3cbf9cb (patch) | |
| tree | e2ac171880763020ed937d24fef794ae0b6a2abf /phpBB/includes/session.php | |
| parent | 186abf0798463d2bb9e37117ec7d451efd37b7a1 (diff) | |
| download | forums-295fb5373ae0a37bfbc36a4461dc3ed2c3cbf9cb.tar forums-295fb5373ae0a37bfbc36a4461dc3ed2c3cbf9cb.tar.gz forums-295fb5373ae0a37bfbc36a4461dc3ed2c3cbf9cb.tar.bz2 forums-295fb5373ae0a37bfbc36a4461dc3ed2c3cbf9cb.tar.xz forums-295fb5373ae0a37bfbc36a4461dc3ed2c3cbf9cb.zip | |
- fixed bug #44975
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10103 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/session.php')
| -rw-r--r-- | phpBB/includes/session.php | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/phpBB/includes/session.php b/phpBB/includes/session.php index 112cf4e2fd..dcfde14159 100644 --- a/phpBB/includes/session.php +++ b/phpBB/includes/session.php @@ -1361,6 +1361,20 @@ class session WHERE user_id = ' . (int) $user_id; $db->sql_query($sql); + // Update last visit info first before deleting sessions + $sql = 'SELECT session_time, session_page + FROM ' . SESSIONS_TABLE . ' + WHERE session_user_id = ' . (int) $user_id . ' + ORDER BY session_time DESC'; + $result = $db->sql_query_limit($sql, 1); + $row = $db->sql_fetchrow($result); + $db->sql_freeresult($result); + + $sql = 'UPDATE ' . USERS_TABLE . ' + SET user_lastvisit = ' . (int) $row['session_time'] . ", user_lastpage = '" . $db->sql_escape($row['session_page']) . "' + WHERE user_id = " . (int) $user_id; + $db->sql_query($sql); + // Let's also clear any current sessions for the specified user_id // If it's the current user then we'll leave this session intact $sql_where = 'session_user_id = ' . (int) $user_id; |