diff options
author | Andreas Fischer <bantu@phpbb.com> | 2010-06-15 20:11:00 +0200 |
---|---|---|
committer | Andreas Fischer <bantu@phpbb.com> | 2010-06-15 20:20:02 +0200 |
commit | e66c089626eb1bd24751893778b04c941dcf1cf8 (patch) | |
tree | 8bbd45b1241471d75263e48228a4c3f54ff311fe | |
parent | Merge branch 'ticket/nickvergessen/9528' into develop-olympus (diff) | |
download | phpbb-e66c089626eb1bd24751893778b04c941dcf1cf8.tar.gz phpbb-e66c089626eb1bd24751893778b04c941dcf1cf8.tar.bz2 phpbb-e66c089626eb1bd24751893778b04c941dcf1cf8.zip |
[ticket/9112] Make sure current user can see most active forum/topic.
PHPBB3-9112
-rw-r--r-- | phpBB/includes/functions_display.php | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/phpBB/includes/functions_display.php b/phpBB/includes/functions_display.php index ea77551fc4..8d25ec3c34 100644 --- a/phpBB/includes/functions_display.php +++ b/phpBB/includes/functions_display.php @@ -969,11 +969,16 @@ function display_user_activity(&$userdata) $forum_ary = array_unique($forum_ary); $forum_sql = (sizeof($forum_ary)) ? 'AND ' . $db->sql_in_set('forum_id', $forum_ary, true) : ''; + $fid_m_approve = $auth->acl_getf('m_approve', true); + $sql_m_approve = (!empty($fid_m_approve)) ? 'OR ' . $db->sql_in_set('forum_id', array_keys($fid_m_approve)) : ''; + // Obtain active forum $sql = 'SELECT forum_id, COUNT(post_id) AS num_posts FROM ' . POSTS_TABLE . ' WHERE poster_id = ' . $userdata['user_id'] . " AND post_postcount = 1 + AND (post_approved = 1 + $sql_m_approve) $forum_sql GROUP BY forum_id ORDER BY num_posts DESC"; @@ -996,6 +1001,8 @@ function display_user_activity(&$userdata) FROM ' . POSTS_TABLE . ' WHERE poster_id = ' . $userdata['user_id'] . " AND post_postcount = 1 + AND (post_approved = 1 + $sql_m_approve) $forum_sql GROUP BY topic_id ORDER BY num_posts DESC"; |