aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/acp/acp_main.php
diff options
context:
space:
mode:
authorNathan Guse <nathaniel.guse@gmail.com>2013-07-13 08:57:20 -0700
committerNathan Guse <nathaniel.guse@gmail.com>2013-07-13 08:57:20 -0700
commit87795eba55172ed43119dd0ee022db68cf3ba8f6 (patch)
tree046da75f4a7ff4de734584b021ab86c06ea1feff /phpBB/includes/acp/acp_main.php
parentd879acb7cca1a05a9adacc2376ab4118bd81ab4a (diff)
parent167ca1f33f8265e5dea6481cc69de16ccfdd0dce (diff)
downloadforums-87795eba55172ed43119dd0ee022db68cf3ba8f6.tar
forums-87795eba55172ed43119dd0ee022db68cf3ba8f6.tar.gz
forums-87795eba55172ed43119dd0ee022db68cf3ba8f6.tar.bz2
forums-87795eba55172ed43119dd0ee022db68cf3ba8f6.tar.xz
forums-87795eba55172ed43119dd0ee022db68cf3ba8f6.zip
Merge pull request #1017 from nickvergessen/feature/softdelete-1-permission
Soft delete
Diffstat (limited to 'phpBB/includes/acp/acp_main.php')
-rw-r--r--phpBB/includes/acp/acp_main.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/includes/acp/acp_main.php b/phpBB/includes/acp/acp_main.php
index c44bc1b8a6..64c2b338fd 100644
--- a/phpBB/includes/acp/acp_main.php
+++ b/phpBB/includes/acp/acp_main.php
@@ -144,14 +144,14 @@ class acp_main
$sql = 'SELECT COUNT(post_id) AS stat
FROM ' . POSTS_TABLE . '
- WHERE post_approved = 1';
+ WHERE post_visibility = ' . ITEM_APPROVED;
$result = $db->sql_query($sql);
set_config('num_posts', (int) $db->sql_fetchfield('stat'), true);
$db->sql_freeresult($result);
$sql = 'SELECT COUNT(topic_id) AS stat
FROM ' . TOPICS_TABLE . '
- WHERE topic_approved = 1';
+ WHERE topic_visibility = ' . ITEM_APPROVED;
$result = $db->sql_query($sql);
set_config('num_topics', (int) $db->sql_fetchfield('stat'), true);
$db->sql_freeresult($result);
@@ -232,7 +232,7 @@ class acp_main
$sql = 'SELECT COUNT(post_id) AS num_posts, poster_id
FROM ' . POSTS_TABLE . '
WHERE post_id BETWEEN ' . ($start + 1) . ' AND ' . ($start + $step) . '
- AND post_postcount = 1 AND post_approved = 1
+ AND post_postcount = 1 AND post_visibility = ' . ITEM_APPROVED . '
GROUP BY poster_id';
$result = $db->sql_query($sql);