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/viewtopic.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/viewtopic.php')
| -rw-r--r-- | phpBB/viewtopic.php | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/phpBB/viewtopic.php b/phpBB/viewtopic.php index ceb9f3ea1c..e78ba73cd7 100644 --- a/phpBB/viewtopic.php +++ b/phpBB/viewtopic.php @@ -943,7 +943,7 @@ if (!sizeof($post_list)) // We need to grab it because we do reverse ordering sometimes $max_post_time = 0; -$sql = $db->sql_build_query('SELECT', array( +$sql_ary = array( 'SELECT' => 'u.*, z.friend, z.foe, p.*', 'FROM' => array( @@ -954,14 +954,15 @@ $sql = $db->sql_build_query('SELECT', array( 'LEFT_JOIN' => array( array( 'FROM' => array(ZEBRA_TABLE => 'z'), - 'ON' => 'z.user_id = ' . $user->data['user_id'] . ' AND z.zebra_id = p.poster_id' - ) + 'ON' => 'z.user_id = ' . $user->data['user_id'] . ' AND z.zebra_id = p.poster_id', + ), ), 'WHERE' => $db->sql_in_set('p.post_id', $post_list) . ' - AND u.user_id = p.poster_id' -)); + AND u.user_id = p.poster_id', +); +$sql = $db->sql_build_query('SELECT', $sql_ary); $result = $db->sql_query($sql); $now = phpbb_gmgetdate(time() + $user->timezone + $user->dst); |