diff options
author | Dries Buytaert <dries@buytaert.net> | 2004-01-17 10:06:04 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2004-01-17 10:06:04 +0000 |
commit | 51f4693c8be9335e19c373fe31005634ec6715f6 (patch) | |
tree | 9892bfb495178e1127b64ed1e93408bd95d75ec7 /includes/session.inc | |
parent | 860a5cc388f9ee729e54ece9425eb0275c340a4d (diff) | |
download | brdo-51f4693c8be9335e19c373fe31005634ec6715f6.tar.gz brdo-51f4693c8be9335e19c373fe31005634ec6715f6.tar.bz2 |
- Fixed bug in session query that prevented sessions to work on PostgreSQL.
Patch by Adrian.
Diffstat (limited to 'includes/session.inc')
-rw-r--r-- | includes/session.inc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/includes/session.inc b/includes/session.inc index 71dc64806..14f98cf92 100644 --- a/includes/session.inc +++ b/includes/session.inc @@ -17,7 +17,7 @@ function sess_close() { function sess_read($key) { global $user; - $result = db_query_range("SELECT u.*, s.*, r.name AS role FROM {users} u INNER JOIN {role} r ON u.rid = r.rid INNER JOIN {sessions} s ON u.uid = s.uid WHERE s.sid = '%s' AND u.status < 3", $key, 0, 1); + $result = db_query_range("SELECT u.*, s.*, r.name AS role FROM {users} u INNER JOIN {sessions} s ON u.uid = s.uid LEFT JOIN {role} r ON u.rid = r.rid WHERE s.sid = '%s' AND u.status < 3", $key, 0, 1); if (!db_num_rows($result)) { $result = db_query("SELECT u.*, r.name AS role FROM {users} u INNER JOIN {role} r ON u.rid = r.rid WHERE u.uid = 0"); |