diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-05-08 01:14:14 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-05-08 01:14:14 +0000 |
| commit | 711d90b44ff23b5bc9ad63382f0251ca8ef30491 (patch) | |
| tree | 3237f7b1dce32ee368176b8d395fdefed912be58 /phpBB/includes/session.php | |
| parent | bb373ebcba8d4ea15e617cd7edbfd54681712fcc (diff) | |
| download | forums-711d90b44ff23b5bc9ad63382f0251ca8ef30491.tar forums-711d90b44ff23b5bc9ad63382f0251ca8ef30491.tar.gz forums-711d90b44ff23b5bc9ad63382f0251ca8ef30491.tar.bz2 forums-711d90b44ff23b5bc9ad63382f0251ca8ef30491.tar.xz forums-711d90b44ff23b5bc9ad63382f0251ca8ef30491.zip | |
Changed forum_link_track to forum_flags for storage of additional info [ pruning related ], moved lang selection into DB, other minor changes, still working on admin_prune, per forum styling for posting
git-svn-id: file:///svn/phpbb/trunk@3989 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/session.php')
| -rw-r--r-- | phpBB/includes/session.php | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/phpBB/includes/session.php b/phpBB/includes/session.php index 9f350c868e..ee234922d0 100644 --- a/phpBB/includes/session.php +++ b/phpBB/includes/session.php @@ -289,12 +289,12 @@ class session $SID = '?sid='; // Delete existing session, update last visit info first! - $sql = "UPDATE " . USERS_TABLE . " - SET user_lastvisit = " . intval($this->data['session_time']) . " - WHERE user_id = " . $this->data['user_id']; + $sql = 'UPDATE ' . USERS_TABLE . ' + SET user_lastvisit = ' . $this->data['session_time'] . ' + WHERE user_id = ' . $this->data['user_id']; $db->sql_query($sql); - $sql = "DELETE FROM " . SESSIONS_TABLE . " + $sql = 'DELETE FROM ' . SESSIONS_TABLE . " WHERE session_id = '" . $this->session_id . "' AND session_user_id = " . $this->data['user_id']; $db->sql_query($sql); @@ -310,10 +310,10 @@ class session global $db, $config; // Get expired sessions, only most recent for each user - $sql = "SELECT session_user_id, session_page, MAX(session_time) AS recent_time - FROM " . SESSIONS_TABLE . " - WHERE session_time < " . ($current_time - $config['session_length']) . " - GROUP BY session_user_id, session_page"; + $sql = 'SELECT session_user_id, session_page, MAX(session_time) AS recent_time + FROM ' . SESSIONS_TABLE . ' + WHERE session_time < ' . ($current_time - $config['session_length']) . ' + GROUP BY session_user_id, session_page'; $result = $db->sql_query_limit($sql, 5); $del_user_id = ''; @@ -322,10 +322,10 @@ class session { do { - if (intval($row['session_user_id']) != ANONYMOUS) + if ($row['session_user_id'] != ANONYMOUS) { - $sql = "UPDATE " . USERS_TABLE . " - SET user_lastvisit = " . $row['recent_time'] . ", user_lastpage = '" . $db->sql_escape($row['session_page']) . "' + $sql = 'UPDATE ' . USERS_TABLE . ' + SET user_lastvisit = ' . $row['recent_time'] . ", user_lastpage = '" . $db->sql_escape($row['session_page']) . "' WHERE user_id = " . $row['session_user_id']; $db->sql_query($sql); } @@ -339,7 +339,7 @@ class session if ($del_user_id != '') { // Delete expired sessions - $sql = "DELETE FROM " . SESSIONS_TABLE . " + $sql = 'DELETE FROM ' . SESSIONS_TABLE . " WHERE session_user_id IN ($del_user_id) AND session_time < " . ($current_time - $config['session_length']); $db->sql_query($sql); |