diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2005-11-28 18:38:49 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2005-11-28 18:38:49 +0000 |
| commit | 6d101df7dc3dc6f5542ccb11d626dcacbd148de6 (patch) | |
| tree | f55c85d2de9f11e9517b7f54fe3d0e2548af41e8 /phpBB/ucp.php | |
| parent | 0dc59b9e0d1bd7d10fa3dddae3541f2dba01f4ef (diff) | |
| download | forums-6d101df7dc3dc6f5542ccb11d626dcacbd148de6.tar forums-6d101df7dc3dc6f5542ccb11d626dcacbd148de6.tar.gz forums-6d101df7dc3dc6f5542ccb11d626dcacbd148de6.tar.bz2 forums-6d101df7dc3dc6f5542ccb11d626dcacbd148de6.tar.xz forums-6d101df7dc3dc6f5542ccb11d626dcacbd148de6.zip | |
- some SQL:2003 changes (basicly joins, mysql5 is sql:2003 compliant in strict mode now) - postgresql not supporting this standard. :/
- acp changes
git-svn-id: file:///svn/phpbb/trunk@5313 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/ucp.php')
| -rwxr-xr-x | phpBB/ucp.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/ucp.php b/phpBB/ucp.php index 61679d5076..73d976f3b1 100755 --- a/phpBB/ucp.php +++ b/phpBB/ucp.php @@ -144,8 +144,8 @@ if (!$user->data['is_registered']) $update_time = $config['load_online_time'] * 60; $sql = 'SELECT DISTINCT u.user_id, u.username, MAX(s.session_time) as online_time, MIN(s.session_viewonline) AS viewonline - FROM ((' . ZEBRA_TABLE . ' z - LEFT JOIN ' . SESSIONS_TABLE . ' s ON s.session_user_id = z.zebra_id), ' . USERS_TABLE . ' u) + FROM (' . ZEBRA_TABLE . ' z, ' . USERS_TABLE . ' u) + LEFT JOIN ' . SESSIONS_TABLE . ' s ON (s.session_user_id = z.zebra_id) WHERE z.user_id = ' . $user->data['user_id'] . ' AND z.friend = 1 AND u.user_id = z.zebra_id |