diff options
Diffstat (limited to 'phpBB/mcp.php')
| -rw-r--r-- | phpBB/mcp.php | 26 |
1 files changed, 20 insertions, 6 deletions
diff --git a/phpBB/mcp.php b/phpBB/mcp.php index 8c6c94fa3e..eb2dd03085 100644 --- a/phpBB/mcp.php +++ b/phpBB/mcp.php @@ -258,12 +258,26 @@ function get_post_data($post_ids, $acl_list = false) global $db, $auth; $rowset = array(); - $sql = 'SELECT p.*, u.*, t.*, f.* - FROM (' . USERS_TABLE . ' u, ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . ' p) - LEFT JOIN ' . FORUMS_TABLE . ' f ON (f.forum_id = p.forum_id) - WHERE p.post_id IN (' . implode(', ', $post_ids) . ') - AND u.user_id = p.poster_id - AND t.topic_id = p.topic_id'; + $sql = $db->sql_build_query('SELECT', array( + 'SELECT' => 'p.*, u.*, t.*, f.*', + + 'FROM' => array( + USERS_TABLE => 'u', + TOPICS_TABLE => 't', + POSTS_TABLE => 'p' + ), + + 'LEFT_JOIN' => array( + array( + 'FROM' => array(FORUMS_TABLE => 'f'), + 'ON' => 'f.forum_id = p.forum_id' + ) + ), + + 'WHERE' => 'p.post_id IN (' . implode(', ', $post_ids) . ') + AND u.user_id = p.poster_id + AND t.topic_id = p.topic_id', + )); $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) |