diff options
| -rw-r--r-- | phpBB/includes/mcp/mcp_front.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/includes/mcp/mcp_front.php b/phpBB/includes/mcp/mcp_front.php index 41953a71e6..4278511c01 100644 --- a/phpBB/includes/mcp/mcp_front.php +++ b/phpBB/includes/mcp/mcp_front.php @@ -44,10 +44,10 @@ function mcp_front_view($id, $mode, $action) $sql_ary = array( 'SELECT' => 'COUNT(post_id) AS total', 'FROM' => array( - POSTS_TABLE => '', + POSTS_TABLE => 'p', ), - 'WHERE' => $db->sql_in_set('forum_id', $forum_list) . ' - AND ' . $db->sql_in_set('post_visibility', array(ITEM_UNAPPROVED, ITEM_REAPPROVE)) + 'WHERE' => $db->sql_in_set('p.forum_id', $forum_list) . ' + AND ' . $db->sql_in_set('p.post_visibility', array(ITEM_UNAPPROVED, ITEM_REAPPROVE)) ); /** |