aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/mcp/mcp_front.php
diff options
context:
space:
mode:
authorAndy Chase <asperous2@gmail.com>2013-07-22 11:29:36 -0700
committerAndy Chase <asperous2@gmail.com>2013-07-22 11:29:36 -0700
commite2a769ac79ad408e94935c97a5fc1325fb838c4f (patch)
tree5f56bbc9d9290f49a6c88987561f345df49f8a3c /phpBB/includes/mcp/mcp_front.php
parentcc1aef47fb4f5d37415436c62067ad2dcde768bb (diff)
parentb71038486e067daf0c608d73aabeb60a56e86840 (diff)
downloadforums-e2a769ac79ad408e94935c97a5fc1325fb838c4f.tar
forums-e2a769ac79ad408e94935c97a5fc1325fb838c4f.tar.gz
forums-e2a769ac79ad408e94935c97a5fc1325fb838c4f.tar.bz2
forums-e2a769ac79ad408e94935c97a5fc1325fb838c4f.tar.xz
forums-e2a769ac79ad408e94935c97a5fc1325fb838c4f.zip
Merge branch 'develop' into ticket/11620
Diffstat (limited to 'phpBB/includes/mcp/mcp_front.php')
-rw-r--r--phpBB/includes/mcp/mcp_front.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/includes/mcp/mcp_front.php b/phpBB/includes/mcp/mcp_front.php
index ba4b15895a..44cab5d910 100644
--- a/phpBB/includes/mcp/mcp_front.php
+++ b/phpBB/includes/mcp/mcp_front.php
@@ -39,7 +39,7 @@ function mcp_front_view($id, $mode, $action)
$sql = 'SELECT COUNT(post_id) AS total
FROM ' . POSTS_TABLE . '
WHERE ' . $db->sql_in_set('forum_id', $forum_list) . '
- AND post_approved = 0';
+ AND post_visibility = ' . ITEM_UNAPPROVED;
$result = $db->sql_query($sql);
$total = (int) $db->sql_fetchfield('total');
$db->sql_freeresult($result);
@@ -60,7 +60,7 @@ function mcp_front_view($id, $mode, $action)
$sql = 'SELECT post_id
FROM ' . POSTS_TABLE . '
WHERE ' . $db->sql_in_set('forum_id', $forum_list) . '
- AND post_approved = 0
+ AND post_visibility = ' . ITEM_UNAPPROVED . '
ORDER BY post_time DESC';
$result = $db->sql_query_limit($sql, 5);