diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2011-11-21 16:22:07 +0100 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2011-11-21 16:22:07 +0100 |
| commit | 4c77903129749008cd08c346006d2a57cf6ff544 (patch) | |
| tree | b9d6811f263fd868c1ca0d29353f32ec2cd3d3df /phpBB/ucp.php | |
| parent | ff91c037c9ff575a6085c43406fa68f351842792 (diff) | |
| download | forums-4c77903129749008cd08c346006d2a57cf6ff544.tar forums-4c77903129749008cd08c346006d2a57cf6ff544.tar.gz forums-4c77903129749008cd08c346006d2a57cf6ff544.tar.bz2 forums-4c77903129749008cd08c346006d2a57cf6ff544.tar.xz forums-4c77903129749008cd08c346006d2a57cf6ff544.zip | |
[ticket/10484] Use variables for sql_build_query() calls
It's easier for mods/extensions to extend the arrays.
PHPBB3-10484
Diffstat (limited to 'phpBB/ucp.php')
| -rw-r--r-- | phpBB/ucp.php | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/phpBB/ucp.php b/phpBB/ucp.php index 505dbb998b..c8a0795bcb 100644 --- a/phpBB/ucp.php +++ b/phpBB/ucp.php @@ -274,19 +274,19 @@ if ($module->is_active('zebra', 'friends')) // Output listing of friends online $update_time = $config['load_online_time'] * 60; - $sql = $db->sql_build_query('SELECT_DISTINCT', array( + $sql_ary = array( 'SELECT' => 'u.user_id, u.username, u.username_clean, u.user_colour, MAX(s.session_time) as online_time, MIN(s.session_viewonline) AS viewonline', 'FROM' => array( USERS_TABLE => 'u', - ZEBRA_TABLE => 'z' + ZEBRA_TABLE => 'z', ), 'LEFT_JOIN' => array( array( 'FROM' => array(SESSIONS_TABLE => 's'), - 'ON' => 's.session_user_id = z.zebra_id' - ) + 'ON' => 's.session_user_id = z.zebra_id', + ), ), 'WHERE' => 'z.user_id = ' . $user->data['user_id'] . ' @@ -296,8 +296,9 @@ if ($module->is_active('zebra', 'friends')) 'GROUP_BY' => 'z.zebra_id, u.user_id, u.username_clean, u.user_colour, u.username', 'ORDER_BY' => 'u.username_clean ASC', - )); + ); + $sql = $db->sql_build_query('SELECT_DISTINCT', $sql_ary); $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) |