diff options
| author | brunoais <brunoaiss@gmail.com> | 2015-03-01 20:57:06 +0000 |
|---|---|---|
| committer | brunoais <brunoaiss@gmail.com> | 2015-03-01 20:57:06 +0000 |
| commit | 21cc1fda8562dcb20f0d850da232d69281d6df51 (patch) | |
| tree | c64007dcbb400bf8d254d2c01a468f8e5daba1ae /phpBB/includes/mcp/mcp_front.php | |
| parent | 5fa6871ebf486eb70052c2e5a07b96d6b23d88c0 (diff) | |
| download | forums-21cc1fda8562dcb20f0d850da232d69281d6df51.tar forums-21cc1fda8562dcb20f0d850da232d69281d6df51.tar.gz forums-21cc1fda8562dcb20f0d850da232d69281d6df51.tar.bz2 forums-21cc1fda8562dcb20f0d850da232d69281d6df51.tar.xz forums-21cc1fda8562dcb20f0d850da232d69281d6df51.zip | |
[ticket/13664] Added alias to table to make modding easier.
PHPBB3-13664
Diffstat (limited to 'phpBB/includes/mcp/mcp_front.php')
| -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)) ); /** |