diff options
| author | Oleg Pudeyev <oleg@bsdpower.com> | 2011-11-24 21:51:10 -0500 |
|---|---|---|
| committer | Oleg Pudeyev <oleg@bsdpower.com> | 2011-11-24 21:51:10 -0500 |
| commit | 90a7f55831e563265cb2f9dbf4ac8cdd26c1a5fa (patch) | |
| tree | da2116f54c64f11ef5ea932ff0d91bf3936c112b /phpBB/includes/functions_posting.php | |
| parent | 6b2b98d8550d47c2d9c58d8acd2e9314e1022a87 (diff) | |
| parent | 4c77903129749008cd08c346006d2a57cf6ff544 (diff) | |
| download | forums-90a7f55831e563265cb2f9dbf4ac8cdd26c1a5fa.tar forums-90a7f55831e563265cb2f9dbf4ac8cdd26c1a5fa.tar.gz forums-90a7f55831e563265cb2f9dbf4ac8cdd26c1a5fa.tar.bz2 forums-90a7f55831e563265cb2f9dbf4ac8cdd26c1a5fa.tar.xz forums-90a7f55831e563265cb2f9dbf4ac8cdd26c1a5fa.zip | |
Merge remote-tracking branch 'nickvergessen/ticket/10484' into develop
* nickvergessen/ticket/10484:
[ticket/10484] Use variables for sql_build_query() calls
Conflicts:
phpBB/includes/mcp/mcp_front.php
Diffstat (limited to 'phpBB/includes/functions_posting.php')
| -rw-r--r-- | phpBB/includes/functions_posting.php | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/phpBB/includes/functions_posting.php b/phpBB/includes/functions_posting.php index dd8437da1a..960359b936 100644 --- a/phpBB/includes/functions_posting.php +++ b/phpBB/includes/functions_posting.php @@ -1005,7 +1005,7 @@ function topic_review($topic_id, $forum_id, $mode = 'topic_review', $cur_post_id $mode = 'post_review'; } - $sql = $db->sql_build_query('SELECT', array( + $sql_ary = array( 'SELECT' => 'u.username, u.user_id, u.user_colour, p.*, z.friend, z.foe', 'FROM' => array( @@ -1016,14 +1016,15 @@ function topic_review($topic_id, $forum_id, $mode = 'topic_review', $cur_post_id '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); $bbcode_bitfield = ''; |