+ $sql = 'SELECT forum_name, (forum_topics_approved + forum_topics_unapproved + forum_topics_softdeleted) AS total_topics

+ if ($row['total_topics'])

+ $url = $this->u_action . "&parent_id={$this->parent_id}&f=$forum_id&action=sync&start=$start&topics_done=$topics_done&total={$row['total_topics']}";

+ 'U_PROGRESS_BAR' => $this->u_action . "&action=progress_bar&start=$topics_done&total={$row['total_topics']}",

+ 'UA_PROGRESS_BAR' => addslashes($this->u_action . "&action=progress_bar&start=$topics_done&total={$row['total_topics']}"),

+ 'L_PROGRESS_EXPLAIN' => sprintf($user->lang['SYNC_IN_PROGRESS_EXPLAIN'], $topics_done, $row['total_topics']))

+ 'L_PROGRESS_EXPLAIN' => sprintf($user->lang['SYNC_IN_PROGRESS_EXPLAIN'], 0, $row['total_topics']))

+ 'FORUM_TOPICS' => $row['forum_topics_approved'],

+ 'FORUM_POSTS' => $row['forum_posts_approved'],

+ $forum_data_sql['forum_posts_approved'] = $forum_data_sql['forum_posts_unapproved'] = $forum_data_sql['forum_posts_softdeleted'] = $forum_data_sql['forum_topics_approved'] = $forum_data_sql['forum_topics_unapproved'] = $forum_data_sql['forum_topics_softdeleted'] = 0;

+ $forum_data_sql['forum_last_post_id'] = $forum_data_sql['forum_last_poster_id'] = $forum_data_sql['forum_last_post_time'] = 0;

+ $forum_data_sql['forum_posts_approved'] = 0;

+ $forum_data_sql['forum_posts_unapproved'] = 0;

+ $forum_data_sql['forum_posts_softdeleted'] = 0;

+ $forum_data_sql['forum_topics_approved'] = 0;

+ $forum_data_sql['forum_topics_unapproved'] = 0;

+ $forum_data_sql['forum_topics_softdeleted'] = 0;

+ AND post_visibility = ' . ITEM_APPROVED;

+ WHERE post_visibility = ' . ITEM_APPROVED;

+ WHERE topic_visibility = ' . ITEM_APPROVED;

+ WHERE post_visibility = ' . ITEM_APPROVED;

+ WHERE topic_visibility = ' . ITEM_APPROVED;

+ AND post_postcount = 1 AND post_visibility = ' . ITEM_APPROVED . '

+ $sql = 'SELECT topic_id, post_visibility, COUNT(post_id) AS total_posts

+ GROUP BY topic_id, post_visibility";

+ $topic_id_ary[$row['topic_id']][$row['post_visibility']] = $row['total_posts'];

+ $sql = 'SELECT topic_id, forum_id, topic_title, topic_posts_approved, topic_posts_unapproved, topic_posts_softdeleted, topic_attachment

+ if ($topic_id_ary[$row['topic_id']][ITEM_APPROVED] == $row['topic_posts_approved']

+ && $topic_id_ary[$row['topic_id']][ITEM_UNAPPROVED] == $row['topic_posts_unapproved']

+ && $topic_id_ary[$row['topic_id']][ITEM_DELETED] == $row['topic_posts_softdeleted'])

+ 'topic_visibility' => ITEM_APPROVED,

+ AND post_visibility = ' . ITEM_UNAPPROVED;

+define('ITEM_UNAPPROVED', 0); // => has not yet been approved

+define('ITEM_APPROVED', 1); // => has been approved, and has not been soft deleted

+define('ITEM_DELETED', 2); // => has been soft deleted

+

+<?php

+/**

+*

+* @package phpbb

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* phpbb_visibility

+* Handle fetching and setting the visibility for topics and posts

+* @package phpbb

+*/

+class phpbb_content_visibility

+{

+ /**

+ * Can the current logged-in user soft-delete posts?

+ *

+ * @param $forum_id int Forum ID whose permissions to check

+ * @param $poster_id int Poster ID of the post in question

+ * @param $post_locked bool Is the post locked?

+ * @return bool

+ */

+ static function can_soft_delete($forum_id, $poster_id, $post_locked)

+ {

+ global $auth, $user;

+

+ if ($auth->acl_get('m_softdelete', $forum_id))

+ {

+ return true;

+ }

+ else if ($auth->acl_get('f_softdelete', $forum_id) && $poster_id == $user->data['user_id'] && !$post_locked)

+ {

+ return true;

+ }

+

+ return false;

+ }

+

+ /**

+ * Get the topics post count or the forums post/topic count based on permissions

+ *

+ * @param $mode string One of topic_posts, forum_posts or forum_topics

+ * @param $data array Array with the topic/forum data to calculate from

+ * @param $forum_id int The forum id is used for permission checks

+ * @return int Number of posts/topics the user can see in the topic/forum

+ */

+ static public function get_count($mode, $data, $forum_id)

+ {

+ global $auth;

+

+ if (!$auth->acl_get('m_approve', $forum_id))

+ {

+ return (int) $data[$mode . '_approved'];

+ }

+

+ return (int) $data[$mode . '_approved'] + (int) $data[$mode . '_unapproved'] + (int) $data[$mode . '_softdeleted'];

+ }

+

+ /**

+ * Create topic/post visibility SQL for a given forum ID

+ *

+ * Note: Read permissions are not checked.

+ *

+ * @param $mode string Either "topic" or "post"

+ * @param $forum_id int The forum id is used for permission checks

+ * @param $table_alias string Table alias to prefix in SQL queries

+ * @return string The appropriate combination SQL logic for topic/post_visibility

+ */

+ static public function get_visibility_sql($mode, $forum_id, $table_alias = '')

+ {

+ global $auth;

+

+ if ($auth->acl_get('m_approve', $forum_id))

+ {

+ return '1 = 1';

+ }

+

+ return $table_alias . $mode . '_visibility = ' . ITEM_APPROVED;

+ }

+

+ /**

+ * Create topic/post visibility SQL for a set of forums

+ *

+ * Note: Read permissions are not checked. Forums without read permissions

+ * should not be in $forum_ids

+ *

+ * @param $mode string Either "topic" or "post"

+ * @param $forum_ids array Array of forum ids which the posts/topics are limited to

+ * @param $table_alias string Table alias to prefix in SQL queries

+ * @return string The appropriate combination SQL logic for topic/post_visibility

+ */

+ static public function get_forums_visibility_sql($mode, $forum_ids = array(), $table_alias = '')

+ {

+ global $auth, $db;

+

+ $where_sql = '(';

+

+ $approve_forums = array_intersect($forum_ids, array_keys($auth->acl_getf('m_approve', true)));

+

+ if (sizeof($approve_forums))

+ {

+ // Remove moderator forums from the rest

+ $forum_ids = array_diff($forum_ids, $approve_forums);

+

+ if (!sizeof($forum_ids))

+ {

+ // The user can see all posts/topics in all specified forums

+ return $db->sql_in_set($table_alias . 'forum_id', $approve_forums);

+ }

+ else

+ {

+ // Moderator can view all posts/topics in some forums

+ $where_sql .= $db->sql_in_set($table_alias . 'forum_id', $approve_forums) . ' OR ';

+ }

+ }

+ else

+ {

+ // The user is just a normal user

+ return "$table_alias{$mode}_visibility = " . ITEM_APPROVED . '

+ AND ' . $db->sql_in_set($table_alias . 'forum_id', $forum_ids, false, true);

+ }

+

+ $where_sql .= "($table_alias{$mode}_visibility = " . ITEM_APPROVED . '

+ AND ' . $db->sql_in_set($table_alias . 'forum_id', $forum_ids) . '))';

+

+ return $where_sql;

+ }

+

+ /**

+ * Create topic/post visibility SQL for all forums on the board

+ *

+ * Note: Read permissions are not checked. Forums without read permissions

+ * should be in $exclude_forum_ids

+ *

+ * @param $mode string Either "topic" or "post"

+ * @param $exclude_forum_ids array Array of forum ids which are excluded

+ * @param $table_alias string Table alias to prefix in SQL queries

+ * @return string The appropriate combination SQL logic for topic/post_visibility

+ */

+ static public function get_global_visibility_sql($mode, $exclude_forum_ids = array(), $table_alias = '')

+ {

+ global $auth, $db;

+

+ $where_sqls = array();

+

+ $approve_forums = array_diff(array_keys($auth->acl_getf('m_approve', true)), $exclude_forum_ids);

+

+ if (sizeof($exclude_forum_ids))

+ {

+ $where_sqls[] = '(' . $db->sql_in_set($table_alias . 'forum_id', $exclude_forum_ids, true) . "

+ AND $table_alias{$mode}_visibility = " . ITEM_APPROVED . ')';

+ }

+ else

+ {

+ $where_sqls[] = "$table_alias{$mode}_visibility = " . ITEM_APPROVED;

+ }

+

+ if (sizeof($approve_forums))

+ {

+ $where_sqls[] = $db->sql_in_set($table_alias . 'forum_id', $approve_forums);

+ return '(' . implode(' OR ', $where_sqls) . ')';

+ }

+

+ // There is only one element, so we just return that one

+ return $where_sqls[0];

+ }

+

+ /**

+ * Change visibility status of one post or all posts of a topic

+ *

+ * @param $visibility int Element of {ITEM_APPROVED, ITEM_DELETED}

+ * @param $post_id mixed Post ID or array of post IDs to act on,

+ * if it is empty, all posts of topic_id will be modified

+ * @param $topic_id int Topic where $post_id is found

+ * @param $forum_id int Forum where $topic_id is found

+ * @param $user_id int User performing the action

+ * @param $time int Timestamp when the action is performed

+ * @param $reason string Reason why the visibilty was changed.

+ * @param $is_starter bool Is this the first post of the topic changed?

+ * @param $is_latest bool Is this the last post of the topic changed?

+ * @param $limit_visibility mixed Limit updating per topic_id to a certain visibility

+ * @param $limit_delete_time mixed Limit updating per topic_id to a certain deletion time

+ * @return array Changed post data, empty array if an error occured.

+ */

+ static public function set_post_visibility($visibility, $post_id, $topic_id, $forum_id, $user_id, $time, $reason, $is_starter, $is_latest, $limit_visibility = false, $limit_delete_time = false)

+ {

+ global $db;

+

+ if (!in_array($visibility, array(ITEM_APPROVED, ITEM_DELETED)))

+ {

+ return array();

+ }

+

+ if ($post_id)

+ {

+ if (is_array($post_id))

+ {

+ $where_sql = $db->sql_in_set('post_id', array_map('intval', $post_id));

+ }

+ else

+ {

+ $where_sql = 'post_id = ' . (int) $post_id;

+ }

+ $where_sql .= ' AND topic_id = ' . (int) $topic_id;

+ }

+ else

+ {

+ $where_sql = 'topic_id = ' . (int) $topic_id;

+

+ // Limit the posts to a certain visibility and deletion time

+ // This allows us to only restore posts, that were approved

+ // when the topic got soft deleted. So previous soft deleted

+ // and unapproved posts are still soft deleted/unapproved

+ if ($limit_visibility !== false)

+ {

+ $where_sql .= ' AND post_visibility = ' . (int) $limit_visibility;

+ }

+

+ if ($limit_delete_time !== false)

+ {

+ $where_sql .= ' AND post_delete_time = ' . (int) $limit_delete_time;

+ }

+ }

+

+ $sql = 'SELECT poster_id, post_id, post_postcount, post_visibility

+ FROM ' . POSTS_TABLE . '

+ WHERE ' . $where_sql;

+ $result = $db->sql_query($sql);

+

+ $post_ids = $poster_postcounts = $postcounts = $postcount_visibility = array();

+ while ($row = $db->sql_fetchrow($result))

+ {

+ $post_ids[] = (int) $row['post_id'];

+

+ if ($row['post_visibility'] != $visibility)

+ {

+ if ($row['post_postcount'] && !isset($poster_postcounts[(int) $row['poster_id']]))

+ {

+ $poster_postcounts[(int) $row['poster_id']] = 1;

+ }

+ else if ($row['post_postcount'])

+ {

+ $poster_postcounts[(int) $row['poster_id']]++;

+ }

+

+ if (!isset($postcount_visibility[$row['post_visibility']]))

+ {

+ $postcount_visibility[$row['post_visibility']] = 1;

+ }

+ else

+ {

+ $postcount_visibility[$row['post_visibility']]++;

+ }

+ }

+ }

+ $db->sql_freeresult($result);

+

+ if (empty($post_ids))

+ {

+ return array();

+ }

+

+ $data = array(

+ 'post_visibility' => (int) $visibility,

+ 'post_delete_user' => (int) $user_id,

+ 'post_delete_time' => ((int) $time) ?: time(),

+ 'post_delete_reason' => truncate_string($reason, 255, 255, false),

+ );

+

+ $sql = 'UPDATE ' . POSTS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $data) . '

+ WHERE ' . $db->sql_in_set('post_id', $post_ids);

+ $db->sql_query($sql);

+

+ // Group the authors by post count, to reduce the number of queries

+ foreach ($poster_postcounts as $poster_id => $num_posts)

+ {

+ $postcounts[$num_posts][] = $poster_id;

+ }

+

+ // Update users postcounts

+ foreach ($postcounts as $num_posts => $poster_ids)

+ {

+ if ($visibility == ITEM_DELETED)

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_posts = 0

+ WHERE ' . $db->sql_in_set('user_id', $poster_ids) . '

+ AND user_posts < ' . $num_posts;

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_posts = user_posts - ' . $num_posts . '

+ WHERE ' . $db->sql_in_set('user_id', $poster_ids) . '

+ AND user_posts >= ' . $num_posts;

+ $db->sql_query($sql);

+ }

+ else

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_posts = user_posts + ' . $num_posts . '

+ WHERE ' . $db->sql_in_set('user_id', $poster_ids);

+ $db->sql_query($sql);

+ }

+ }

+

+ $update_topic_postcount = true;

+

+ // Sync the first/last topic information if needed

+ if (!$is_starter && $is_latest)

+ {

+ // update_post_information can only update the last post info ...

+ if ($topic_id)

+ {

+ update_post_information('topic', $topic_id, false);

+ }

+ if ($forum_id)

+ {

+ update_post_information('forum', $forum_id, false);

+ }

+ }

+ else if ($is_starter && $topic_id)

+ {

+ if (!function_exists('sync'))

+ {

+ global $phpEx, $phpbb_root_path;

+ include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

+ }

+

+ // ... so we need to use sync, if the first post is changed.

+ // The forum is resynced recursive by sync() itself.

+ sync('topic', 'topic_id', $topic_id, true);

+

+ // sync recalculates the topic replies and forum posts by itself, so we don't do that.

+ $update_topic_postcount = false;

+ }

+

+ // Update the topic's reply count and the forum's post count

+ if ($update_topic_postcount)

+ {

+ $cur_posts = $cur_unapproved_posts = $cur_softdeleted_posts = 0;

+ foreach ($postcount_visibility as $post_visibility => $visibility_posts)

+ {

+ // We need to substract the posts from the counters ...

+ if ($post_visibility == ITEM_APPROVED)

+ {

+ $cur_posts += $visibility_posts;

+ }

+ else if ($post_visibility == ITEM_UNAPPROVED)

+ {

+ $cur_unapproved_posts += $visibility_posts;

+ }

+ else if ($post_visibility == ITEM_DELETED)

+ {

+ $cur_softdeleted_posts += $visibility_posts;

+ }

+ }

+

+ $sql_ary = array();

+ if ($visibility == ITEM_DELETED)

+ {

+ if ($cur_posts)

+ {

+ $sql_ary['posts_approved'] = ' - ' . $cur_posts;

+ }

+ if ($cur_unapproved_posts)

+ {

+ $sql_ary['posts_unapproved'] = ' - ' . $cur_unapproved_posts;

+ }

+ if ($cur_posts + $cur_unapproved_posts)

+ {

+ $sql_ary['posts_softdeleted'] = ' + ' . ($cur_posts + $cur_unapproved_posts);

+ }

+ }

+ else

+ {

+ if ($cur_unapproved_posts)

+ {

+ $sql_ary['posts_unapproved'] = ' - ' . $cur_unapproved_posts;

+ }

+ if ($cur_softdeleted_posts)

+ {

+ $sql_ary['posts_softdeleted'] = ' - ' . $cur_softdeleted_posts;

+ }

+ if ($cur_softdeleted_posts + $cur_unapproved_posts)

+ {

+ $sql_ary['posts_approved'] = ' + ' . ($cur_softdeleted_posts + $cur_unapproved_posts);

+ }

+ }

+

+ if (sizeof($sql_ary))

+ {

+ $topic_sql = $forum_sql = array();

+

+ foreach ($sql_ary as $field => $value_change)

+ {

+ $topic_sql[] = 'topic_' . $field . ' = topic_' . $field . $value_change;

+ $forum_sql[] = 'forum_' . $field . ' = forum_' . $field . $value_change;

+ }

+

+ // Update the number for replies and posts

+ $sql = 'UPDATE ' . TOPICS_TABLE . '

+ SET ' . implode(', ', $topic_sql) . '

+ WHERE topic_id = ' . (int) $topic_id;

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET ' . implode(', ', $forum_sql) . '

+ WHERE forum_id = ' . (int) $forum_id;

+ $db->sql_query($sql);

+ }

+ }

+

+ return $data;

+ }

+

+ /**

+ * Set topic visibility

+ *

+ * Allows approving (which is akin to undeleting/restore) or soft deleting an entire topic.

+ * Calls set_post_visibility as needed.

+ *

+ * Note: By default, when a soft deleted topic is restored. Only posts that

+ * were approved at the time of soft deleting, are being restored.

+ * Same applies to soft deleting. Only approved posts will be marked

+ * as soft deleted.

+ * If you want to update all posts, use the force option.

+ *

+ * @param $visibility int Element of {ITEM_APPROVED, ITEM_DELETED}

+ * @param $topic_id mixed Topic ID to act on

+ * @param $forum_id int Forum where $topic_id is found

+ * @param $user_id int User performing the action

+ * @param $time int Timestamp when the action is performed

+ * @param $reason string Reason why the visibilty was changed.

+ * @param $force_update_all bool Force to update all posts within the topic

+ * @return array Changed topic data, empty array if an error occured.

+ */

+ static public function set_topic_visibility($visibility, $topic_id, $forum_id, $user_id, $time, $reason, $force_update_all = false)

+ {

+ global $db;

+

+ if (!in_array($visibility, array(ITEM_APPROVED, ITEM_DELETED)))

+ {

+ return array();

+ }

+

+ if (!$force_update_all)

+ {

+ $sql = 'SELECT topic_visibility, topic_delete_time

+ FROM ' . TOPICS_TABLE . '

+ WHERE topic_id = ' . (int) $topic_id;

+ $result = $db->sql_query($sql);

+ $original_topic_data = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ if (!$original_topic_data)

+ {

+ // The topic does not exist...

+ return array();

+ }

+ }

+

+ // Note, we do not set a reason for the posts, just for the topic

+ $data = array(

+ 'topic_visibility' => (int) $visibility,

+ 'topic_delete_user' => (int) $user_id,

+ 'topic_delete_time' => ((int) $time) ?: time(),

+ 'topic_delete_reason' => truncate_string($reason, 255, 255, false),

+ );

+

+ $sql = 'UPDATE ' . TOPICS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $data) . '

+ WHERE topic_id = ' . (int) $topic_id;

+ $db->sql_query($sql);

+

+ if (!$db->sql_affectedrows())

+ {

+ return array();

+ }

+

+ if (!$force_update_all && $original_topic_data['topic_delete_time'] && $original_topic_data['topic_visibility'] == ITEM_DELETED && $visibility == ITEM_APPROVED)

+ {

+ // If we're restoring a topic we only restore posts, that were soft deleted through the topic soft deletion.

+ self::set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true, $original_topic_data['topic_visibility'], $original_topic_data['topic_delete_time']);

+ }

+ else if (!$force_update_all && $original_topic_data['topic_visibility'] == ITEM_APPROVED && $visibility == ITEM_DELETED)

+ {

+ // If we're soft deleting a topic we only approved posts are soft deleted.

+ self::set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true, $original_topic_data['topic_visibility']);

+ }

+ else

+ {

+ self::set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true);

+ }

+

+ return $data;

+ }

+

+ /**

+ * Add post to topic and forum statistics

+ *

+ * @param $data array Contains information from the topics table about given topic

+ * @param $sql_data array Populated with the SQL changes, may be empty at call time

+ * @return void

+ */

+ static public function add_post_to_statistic($data, &$sql_data)

+ {

+ $sql_data[TOPICS_TABLE] = (($sql_data[TOPICS_TABLE]) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_posts_approved = topic_posts_approved + 1';

+

+ $sql_data[FORUMS_TABLE] = (($sql_data[FORUMS_TABLE]) ? $sql_data[FORUMS_TABLE] . ', ' : '') . 'forum_posts_approved = forum_posts_approved + 1';

+

+ if ($data['post_postcount'])

+ {

+ $sql_data[USERS_TABLE] = (($sql_data[USERS_TABLE]) ? $sql_data[USERS_TABLE] . ', ' : '') . 'user_posts = user_posts + 1';

+ }

+

+ set_config_count('num_posts', 1, true);

+ }

+

+ /**

+ * Remove post from topic and forum statistics

+ *

+ * @param $data array Contains information from the topics table about given topic

+ * @param $sql_data array Populated with the SQL changes, may be empty at call time

+ * @return void

+ */

+ static public function remove_post_from_statistic($data, &$sql_data)

+ {

+ $sql_data[TOPICS_TABLE] = ((!empty($sql_data[TOPICS_TABLE])) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_posts_approved = topic_posts_approved - 1';

+ $sql_data[FORUMS_TABLE] = ((!empty($sql_data[FORUMS_TABLE])) ? $sql_data[FORUMS_TABLE] . ', ' : '') . 'forum_posts_approved = forum_posts_approved - 1';

+

+ if ($data['post_postcount'])

+ {

+ $sql_data[USERS_TABLE] = ((!empty($sql_data[USERS_TABLE])) ? $sql_data[USERS_TABLE] . ', ' : '') . 'user_posts = user_posts - 1';

+ }

+

+ set_config_count('num_posts', -1, true);

+ }

+

+ /**

+ * Remove topic from forum statistics

+ *

+ * @param $topic_id int The topic to act on

+ * @param $forum_id int Forum where the topic is found

+ * @param $topic_row array Contains information from the topic, may be empty at call time

+ * @param $sql_data array Populated with the SQL changes, may be empty at call time

+ * @return void

+ */

+ static public function remove_topic_from_statistic($topic_id, $forum_id, &$topic_row, &$sql_data)

+ {

+ global $db;

+

+ // Do we need to grab some topic informations?

+ if (!sizeof($topic_row))

+ {

+ $sql = 'SELECT topic_type, topic_posts_approved, topic_posts_unapproved, topic_posts_softdeleted, topic_visibility

+ FROM ' . TOPICS_TABLE . '

+ WHERE topic_id = ' . $topic_id;

+ $result = $db->sql_query($sql);

+ $topic_row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+ }

+

+ // If this is an edited topic or the first post the topic gets completely disapproved later on...

+ $sql_data[FORUMS_TABLE] = (($sql_data[FORUMS_TABLE]) ? $sql_data[FORUMS_TABLE] . ', ' : '') . 'forum_topics_approved = forum_topics_approved - 1';

+ $sql_data[FORUMS_TABLE] .= ', forum_posts_approved = forum_posts_approved - ' . $topic_row['topic_posts_approved'];

+ $sql_data[FORUMS_TABLE] .= ', forum_posts_unapproved = forum_posts_unapproved - ' . $topic_row['topic_posts_unapproved'];

+ $sql_data[FORUMS_TABLE] .= ', forum_posts_softdeleted = forum_posts_softdeleted - ' . $topic_row['topic_posts_softdeleted'];

+

+ set_config_count('num_topics', -1, true);

+ set_config_count('num_posts', $topic_row['topic_posts_approved'] * (-1), true);

+

+ // Get user post count information

+ $sql = 'SELECT poster_id, COUNT(post_id) AS num_posts

+ FROM ' . POSTS_TABLE . '

+ WHERE topic_id = ' . $topic_id . '

+ AND post_postcount = 1

+ AND post_visibility = ' . ITEM_APPROVED . '

+ GROUP BY poster_id';

+ $result = $db->sql_query($sql);

+

+ $postcounts = array();

+ while ($row = $db->sql_fetchrow($result))

+ {

+ $postcounts[(int) $row['num_posts']][] = (int) $row['poster_id'];

+ }

+ $db->sql_freeresult($result);

+

+ // Decrement users post count

+ foreach ($postcounts as $num_posts => $poster_ids)

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_posts = 0

+ WHERE user_posts < ' . $num_posts . '

+ AND ' . $db->sql_in_set('user_id', $poster_ids);

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_posts = user_posts - ' . $num_posts . '

+ WHERE user_posts >= ' . $num_posts . '

+ AND ' . $db->sql_in_set('user_id', $poster_ids);

+ $db->sql_query($sql);

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

+class phpbb_db_migration_data_310_softdelete_p1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_column_exists($this->table_prefix . 'posts', 'post_visibility');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_310_dev');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

+ $this->table_prefix . 'forums' => array(

+ 'forum_posts_approved' => array('UINT', 0),

+ 'forum_posts_unapproved' => array('UINT', 0),

+ 'forum_posts_softdeleted' => array('UINT', 0),

+ 'forum_topics_approved' => array('UINT', 0),

+ 'forum_topics_unapproved' => array('UINT', 0),

+ 'forum_topics_softdeleted' => array('UINT', 0),

+ ),

+ $this->table_prefix . 'posts' => array(

+ 'post_visibility' => array('TINT:3', 0),

+ 'post_delete_time' => array('TIMESTAMP', 0),

+ 'post_delete_reason' => array('STEXT_UNI', ''),

+ 'post_delete_user' => array('UINT', 0),

+ ),

+ $this->table_prefix . 'topics' => array(

+ 'topic_visibility' => array('TINT:3', 0),

+ 'topic_delete_time' => array('TIMESTAMP', 0),

+ 'topic_delete_reason' => array('STEXT_UNI', ''),

+ 'topic_delete_user' => array('UINT', 0),

+ 'topic_posts_approved' => array('UINT', 0),

+ 'topic_posts_unapproved' => array('UINT', 0),

+ 'topic_posts_softdeleted' => array('UINT', 0),

+ ),

+ ),

+ 'add_index' => array(

+ $this->table_prefix . 'posts' => array(

+ 'post_visibility' => array('post_visibility'),

+ ),

+ $this->table_prefix . 'topics' => array(

+ 'topic_visibility' => array('topic_visibility'),

+ 'forum_vis_last' => array('forum_id', 'topic_visibility', 'topic_last_post_id'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ $this->table_prefix . 'forums' => array(

+ 'forum_posts_approved',

+ 'forum_posts_unapproved',

+ 'forum_posts_softdeleted',

+ 'forum_topics_approved',

+ 'forum_topics_unapproved',

+ 'forum_topics_softdeleted',

+ ),

+ $this->table_prefix . 'posts' => array(

+ 'post_visibility',

+ 'post_delete_time',

+ 'post_delete_reason',

+ 'post_delete_user',

+ ),

+ $this->table_prefix . 'topics' => array(

+ 'topic_visibility',

+ 'topic_delete_time',

+ 'topic_delete_reason',

+ 'topic_delete_user',

+ 'topic_posts_approved',

+ 'topic_posts_unapproved',

+ 'topic_posts_softdeleted',

+ ),

+ ),

+ 'drop_keys' => array(

+ $this->table_prefix . 'posts' => array('post_visibility'),

+ $this->table_prefix . 'topics' => array('topic_visibility', 'forum_vis_last'),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array($this, 'update_post_visibility'))),

+ array('custom', array(array($this, 'update_topic_visibility'))),

+ array('custom', array(array($this, 'update_topic_forum_counts'))),

+

+ array('permission.add', array('f_softdelete', false)),

+ array('permission.add', array('m_softdelete', false)),

+ );

+ }

+

+ public function update_post_visibility()

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . 'posts

+ SET post_visibility = post_approved';

+ $this->sql_query($sql);

+ }

+

+ public function update_topic_visibility()

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . 'topics

+ SET topic_visibility = topic_approved';

+ $this->sql_query($sql);

+ }

+

+ public function update_topic_forum_counts()

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . 'topics

+ SET topic_posts_approved = topic_replies + 1,

+ topic_posts_unapproved = topic_replies_real - topic_replies

+ WHERE topic_visibility = ' . ITEM_APPROVED;

+ $this->sql_query($sql);

+

+ $sql = 'UPDATE ' . $this->table_prefix . 'topics

+ SET topic_posts_approved = 0,

+ topic_posts_unapproved = (topic_replies_real - topic_replies) + 1

+ WHERE topic_visibility = ' . ITEM_UNAPPROVED;

+ $this->sql_query($sql);

+

+ $sql = 'SELECT forum_id, topic_visibility, COUNT(topic_id) AS sum_topics, SUM(topic_posts_approved) AS sum_posts_approved, SUM(topic_posts_unapproved) AS sum_posts_unapproved

+ FROM ' . $this->table_prefix . 'topics

+ GROUP BY forum_id, topic_visibility';

+ $result = $this->db->sql_query($sql);

+

+ $update_forums = array();

+ while ($row = $this->db->sql_fetchrow($result))

+ {

+ $forum_id = (int) $row['forum_id'];

+ if (!isset($update_forums[$forum_id]))

+ {

+ $update_forums[$forum_id] = array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ );

+ }

+

+ $update_forums[$forum_id]['forum_posts_approved'] += (int) $row['sum_posts_approved'];

+ $update_forums[$forum_id]['forum_posts_unapproved'] += (int) $row['sum_posts_unapproved'];

+

+ $update_forums[$forum_id][(($row['topic_visibility'] == ITEM_APPROVED) ? 'forum_topics_approved' : 'forum_topics_unapproved')] += (int) $row['sum_topics'];

+ }

+ $this->db->sql_freeresult($result);

+

+ foreach ($update_forums as $forum_id => $forum_data)

+ {

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET ' . $this->db->sql_build_array('UPDATE', $forum_data) . '

+ WHERE forum_id = ' . $forum_id;

+ $this->sql_query($sql);

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

+class phpbb_db_migration_data_310_softdelete_p2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'posts', 'post_approved');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ 'phpbb_db_migration_data_310_dev',

+ 'phpbb_db_migration_data_310_softdelete_p1',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ $this->table_prefix . 'forums' => array('forum_posts', 'forum_topics', 'forum_topics_real'),

+ $this->table_prefix . 'posts' => array('post_approved'),

+ $this->table_prefix . 'topics' => array('topic_approved', 'topic_replies', 'topic_replies_real'),

+ ),

+ 'drop_keys' => array(

+ $this->table_prefix . 'posts' => array('post_approved'),

+ $this->table_prefix . 'topics' => array('forum_appr_last'),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

+ $this->table_prefix . 'forums' => array(

+ 'forum_posts' => array('UINT', 0),

+ 'forum_topics' => array('UINT', 0),

+ 'forum_topics_real' => array('UINT', 0),

+ ),

+ $this->table_prefix . 'posts' => array(

+ 'post_approved' => array('BOOL', 1),

+ ),

+ $this->table_prefix . 'topics' => array(

+ 'topic_approved' => array('BOOL', 1),

+ 'topic_replies' => array('UINT', 0),

+ 'topic_replies_real' => array('UINT', 0),

+ ),

+ ),

+ 'add_index' => array(

+ $this->table_prefix . 'posts' => array(

+ 'post_approved' => array('post_approved'),

+ ),

+ $this->table_prefix . 'topics' => array(

+ 'forum_appr_last' => array('forum_id', 'topic_approved', 'topic_last_post_id'),

+ ),

+ ),

+ );

+ }

+}

+ $sql_visibility = phpbb_content_visibility::get_visibility_sql('topic', $this->forum_id);

+ ' . (($sql_visibility) ? ' AND ' . $sql_visibility : '') . '

+ $sql_visibility = phpbb_content_visibility::get_visibility_sql('post', $this->forum_id, 'p.');

+

+ 'SELECT' => 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_visibility, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ ' . (($sql_visibility) ? ' AND ' . $sql_visibility : '') . '

+ f.forum_topics_approved, f.forum_posts_approved',

+ $item_row['statistics'] = $this->user->lang('TOTAL_TOPICS', (int) $row['forum_topics_approved'])

+ . ' ' . $this->separator_stats . ' ' . $this->user->lang('TOTAL_POSTS_COUNT', (int) $row['forum_posts_approved']);

+ AND topic_visibility = ' . ITEM_APPROVED . '

+ t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_posts_approved, t.topic_posts_unapproved, t.topic_posts_softdeleted, t.topic_views, t.topic_time, t.topic_last_post_time,

+ WHERE topic_moved_id = 0

+ AND ' . phpbb_content_visibility::get_forums_visibility_sql('topic', $forum_ids) . '

+ $sql_visibility = phpbb_content_visibility::get_visibility_sql('post', array(), 'p.');

+

+ 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_visibility, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ ' . (($sql_visibility) ? ' AND ' . $sql_visibility : '') . '

+ . (($this->is_moderator_approve_forum($row['forum_id']) && $row['post_visibility'] !== ITEM_APPROVED) ? ' ' . $this->separator_stats . ' ' . $this->user->lang['POST_UNAPPROVED'] : '');

+ $sql = 'SELECT f.forum_options, f.forum_password, t.topic_id, t.forum_id, t.topic_visibility, t.topic_title, t.topic_time, t.topic_views, t.topic_replies, t.topic_type

+ $sql_visibility = phpbb_content_visibility::get_visibility_sql('post', $this->forum_id, 'p.');

+

+ 'SELECT' => 'p.post_id, p.post_time, p.post_edit_time, p.post_visibility, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ ' . (($sql_visibility) ? ' AND ' . $sql_visibility : '') . '

+ . ' ' . $this->separator_stats . ' ' . $this->user->lang['REPLIES'] . ' ' . phpbb_content_visibility::get_count('topic_posts', $row, $row['forum_id']) - 1

+ . (($this->is_moderator_approve_forum($row['forum_id']) && $row['topic_posts_unapproved']) ? ' ' . $this->separator_stats . ' ' . $this->user->lang['POSTS_UNAPPROVED'] : '');

+ AND topic_visibility = ' . ITEM_APPROVED . '

+ t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_posts_approved, t.topic_posts_unapproved, t.topic_posts_softdeleted, t.topic_views, t.topic_time, t.topic_last_post_time,

+ AND topic_visibility = ' . ITEM_APPROVED . '

+ t.topic_id, t.topic_title, t.topic_posts_approved, t.topic_posts_unapproved, t.topic_posts_softdeleted, t.topic_views,

+ $sql_update_unapproved = phpbb_content_visibility::get_visibility_sql('topic', $forum_id, 't.');

+ $sql_update_unapproved = ($sql_update_unapproved) ? ' AND ' . $sql_update_unapproved : '';

+ $sql = 'SELECT topic_id, forum_id, topic_visibility, topic_moved_id

+ if ($row['topic_visibility'] == ITEM_APPROVED && !$row['topic_moved_id'])

+ $sql = 'SELECT post_id, poster_id, post_visibility, post_postcount, topic_id, forum_id

+ if ($row['post_postcount'] && $post_count_sync && $row['post_visibility'] == ITEM_APPROVED)

+ if ($row['post_visibility'] == ITEM_APPROVED)

+ if ($approved_posts && $post_count_sync)

+* - topic_visibility Resyncs the topic_visibility flag according to the status of the first post

+ if ($mode == 'forum' || $mode == 'topic' || $mode == 'topic_visibility' || $mode == 'topic_reported' || $mode == 'post_reported')

+ case 'topic_visibility':

+

+ $sql = 'SELECT t.topic_id, p.post_visibility

+ FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . " p

+ $where_sql_and p.topic_id = t.topic_id

+ AND p.post_visibility = " . ITEM_APPROVED;

+ $result = $db->sql_query($sql);

+

+ $topics_approved = array();

+ while ($row = $db->sql_fetchrow($result))

+ $topics_approved[] = (int) $row['topic_id'];

+ }

+ $db->sql_freeresult($result);

+ $sql = 'SELECT t.topic_id, p.post_visibility

+ FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . " p

+ $where_sql_and " . $db->sql_in_set('t.topic_id', $topics_approved, true, true) . '

+ AND p.topic_id = t.topic_id

+ AND p.post_visibility = ' . ITEM_DELETED;

+ $result = $db->sql_query($sql);

+ $topics_softdeleted = array();

+ while ($row = $db->sql_fetchrow($result))

+ {

+ $topics_softdeleted[] = (int) $row['topic_id'];

+ }

+ $db->sql_freeresult($result);

+ $topics_softdeleted = array_diff($topics_softdeleted, $topics_approved);

+ $topics_not_unapproved = array_merge($topics_softdeleted, $topics_approved);

+

+ $update_ary = array(

+ ITEM_UNAPPROVED => (!empty($topics_not_unapproved)) ? $where_sql_and . ' ' . $db->sql_in_set('topic_id', $topics_not_unapproved, true) : '',

+ ITEM_APPROVED => (!empty($topics_approved)) ? ' WHERE ' . $db->sql_in_set('topic_id', $topics_approved) : '',

+ ITEM_DELETED => (!empty($topics_softdeleted)) ? ' WHERE ' . $db->sql_in_set('topic_id', $topics_softdeleted) : '',

+ );

+ foreach ($topic_visiblities as $visibility => $sql_where)

+ {

+ if ($sql_where)

+ {

+ SET topic_visibility = ' . $visibility . '

+ ' . $sql_where;

+ }

+ $forum_data[$forum_id]['posts_approved'] = 0;

+ $forum_data[$forum_id]['posts_unapproved'] = 0;

+ $forum_data[$forum_id]['posts_softdeleted'] = 0;

+ $forum_data[$forum_id]['topics_approved'] = 0;

+ $forum_data[$forum_id]['topics_unapproved'] = 0;

+ $forum_data[$forum_id]['topics_softdeleted'] = 0;

+ $sql = 'SELECT forum_id, topic_visibility, COUNT(topic_id) AS total_topics

+ GROUP BY forum_id, topic_visibility';

+ if ($row['topic_visibility'] == ITEM_APPROVED)

+ $forum_data[$forum_id]['topics_approved'] = $row['total_topics'];

+ }

+ else if ($row['topic_visibility'] == ITEM_UNAPPROVED)

+ {

+ $forum_data[$forum_id]['topics_unapproved'] = $row['total_topics'];

+ }

+ else if ($row['topic_visibility'] == ITEM_DELETED)

+ {

+ $forum_data[$forum_id]['topics_softdeleted'] = $row['total_topics'];

+ $sql = 'SELECT SUM(t.topic_posts_approved) AS forum_posts_approved, SUM(t.topic_posts_unapproved) AS forum_posts_unapproved, SUM(t.topic_posts_softdeleted) AS forum_posts_softdeleted

+ $sql = 'SELECT t.forum_id, SUM(t.topic_posts_approved) AS forum_posts_approved, SUM(t.topic_posts_unapproved) AS forum_posts_unapproved, SUM(t.topic_posts_softdeleted) AS forum_posts_softdeleted

+ $forum_data[$forum_id]['posts_approved'] = (int) $row['forum_posts_approved'];

+ $forum_data[$forum_id]['posts_unapproved'] = (int) $row['forum_posts_unapproved'];

+ $forum_data[$forum_id]['posts_softdeleted'] = (int) $row['forum_posts_softdeleted'];

+ AND t.topic_visibility = ' . ITEM_APPROVED;

+ AND t.topic_visibility = ' . ITEM_APPROVED . '

+ array_push($fieldnames, 'posts_approved', 'posts_unapproved', 'posts_softdeleted', 'topics_approved', 'topics_unapproved', 'topics_softdeleted');

+ $topic_data = $post_ids = $resync_forums = $delete_topics = $delete_posts = $moved_topics = array();

+ $sql = 'SELECT t.topic_id, t.forum_id, t.topic_moved_id, t.topic_visibility, ' . (($sync_extra) ? 't.topic_attachment, t.topic_reported, ' : '') . 't.topic_poster, t.topic_time, t.topic_posts_approved, t.topic_posts_unapproved, t.topic_posts_softdeleted, t.topic_first_post_id, t.topic_first_poster_name, t.topic_first_poster_colour, t.topic_last_post_id, t.topic_last_post_subject, t.topic_last_poster_id, t.topic_last_poster_name, t.topic_last_poster_colour, t.topic_last_post_time

+ $topic_data[$topic_id]['visibility'] = ITEM_UNAPPROVED;

+ $topic_data[$topic_id]['posts_approved'] = 0;

+ $topic_data[$topic_id]['posts_unapproved'] = 0;

+ $topic_data[$topic_id]['posts_softdeleted'] = 0;

+ // NOTE: 't.post_visibility' in the GROUP BY is causing a major slowdown.

+ $sql = 'SELECT t.topic_id, t.post_visibility, COUNT(t.post_id) AS total_posts, MIN(t.post_id) AS first_post_id, MAX(t.post_id) AS last_post_id

+ GROUP BY t.topic_id, t.post_visibility";

+ if ($row['post_visibility'] == ITEM_APPROVED)

+ {

+ $topic_data[$topic_id]['posts_approved'] = $row['total_posts'];

+ }

+ else if ($row['post_visibility'] == ITEM_UNAPPROVED)

+ {

+ $topic_data[$topic_id]['posts_unapproved'] = $row['total_posts'];

+ }

+ else if ($row['post_visibility'] == ITEM_DELETED)

+ {

+ $topic_data[$topic_id]['posts_softdeleted'] = $row['total_posts'];

+ }

+ if ($row['post_visibility'] == ITEM_APPROVED)

+ $topic_data[$topic_id]['visibility'] = ITEM_APPROVED;

+ $topic_data[$topic_id]['first_post_id'] = $row['first_post_id'];

+ else if ($topic_data[$topic_id]['visibility'] != ITEM_APPROVED)

+ {

+ // If there is no approved post, we take the min/max of the other visibilities

+ // for the last and first post info, because it is only visible to moderators anyway

+ $topic_data[$topic_id]['first_post_id'] = (!empty($topic_data[$topic_id]['first_post_id'])) ? min($topic_data[$topic_id]['first_post_id'], $row['first_post_id']) : $row['first_post_id'];

+ $topic_data[$topic_id]['last_post_id'] = max($topic_data[$topic_id]['last_post_id'], $row['last_post_id']);

+

+ if ($topic_data[$topic_id]['visibility'] == ITEM_UNAPPROVED)

+ {

+ // Soft delete status is stronger than unapproved.

+ $topic_data[$topic_id]['visibility'] = $row['post_visibility'];

+ }

+ }

+ $sql = 'SELECT p.post_id, p.topic_id, p.post_visibility, p.poster_id, p.post_subject, p.post_username, p.post_time, u.username, u.user_colour

+ $sql = 'SELECT p.post_id, p.topic_id, p.post_visibility, p.poster_id, p.post_subject, p.post_username, p.post_time, u.username, u.user_colour

+ $fieldnames = array('time', 'visibility', 'posts_approved', 'posts_unapproved', 'posts_softdeleted', 'poster', 'first_post_id', 'first_poster_name', 'first_poster_colour', 'last_post_id', 'last_post_subject', 'last_post_time', 'last_poster_id', 'last_poster_name', 'last_poster_colour');

+ AND post_visibility = ' . ITEM_APPROVED . '

+ WHERE post_visibility = ' . ITEM_APPROVED;

+ WHERE topic_visibility = ' . ITEM_APPROVED;

+ $row['forum_id_unapproved_topics'] = ($auth->acl_get('m_approve', $forum_id) && $row['forum_topics_unapproved']) ? $forum_id : 0;

+ $row['forum_posts'] = phpbb_content_visibility::get_count('forum_posts', $row, $forum_id);

+ $row['forum_topics'] = phpbb_content_visibility::get_count('forum_topics', $row, $forum_id);

+ ($user->data['is_registered'] && ($auth->acl_gets('f_delete', 'm_delete', $forum_id) || $auth->acl_gets('f_softdelete', 'm_softdelete', $forum_id)) && !$locked) ? $user->lang['RULES_DELETE_CAN'] : $user->lang['RULES_DELETE_CANNOT'],

+ $forum_read_ary = $auth->acl_getf('f_read');

+ foreach ($forum_read_ary as $forum_id => $allowed)

+ if ($allowed['f_read'])

+ $forum_ary = array_diff($forum_ary, $user->get_passworded_forums());

+ $active_f_row = $active_t_row = array();

+ if (!empty($forum_ary))

+ // 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 ' . phpbb_content_visibility::get_forums_visibility_sql('post', $forum_ary) . '

+ GROUP BY forum_id

+ ORDER BY num_posts DESC';

+ $result = $db->sql_query_limit($sql, 1);

+ $active_f_row = $db->sql_fetchrow($result);

+ if (!empty($active_f_row))

+ {

+ $sql = 'SELECT forum_name

+ FROM ' . FORUMS_TABLE . '

+ WHERE forum_id = ' . $active_f_row['forum_id'];

+ $result = $db->sql_query($sql, 3600);

+ $active_f_row['forum_name'] = (string) $db->sql_fetchfield('forum_name');

+ $db->sql_freeresult($result);

+ }

+ // Obtain active topic

+ $sql = 'SELECT topic_id, COUNT(post_id) AS num_posts

+ FROM ' . POSTS_TABLE . '

+ WHERE poster_id = ' . $userdata['user_id'] . '

+ AND post_postcount = 1

+ AND ' . phpbb_content_visibility::get_forums_visibility_sql('post', $forum_ary) . '

+ GROUP BY topic_id

+ ORDER BY num_posts DESC';

+ $result = $db->sql_query_limit($sql, 1);

+ $active_t_row = $db->sql_fetchrow($result);

+

+ if (!empty($active_t_row))

+ {

+ $sql = 'SELECT topic_title

+ FROM ' . TOPICS_TABLE . '

+ WHERE topic_id = ' . $active_t_row['topic_id'];

+ $result = $db->sql_query($sql);

+ $active_t_row['topic_title'] = (string) $db->sql_fetchfield('topic_title');

+ $db->sql_freeresult($result);

+ }

+ $topic_condition = 'AND t.topic_id = p.topic_id AND t.topic_visibility = ' . ITEM_APPROVED;

+ AND p.post_visibility = " . ITEM_APPROVED;

+ AND p.post_visibility = " . ITEM_APPROVED . "

+ AND " . phpbb_content_visibility::get_visibility_sql('post', $forum_id, 'p.') . '

+function delete_post($forum_id, $topic_id, $post_id, &$data, $is_soft = false, $softdelete_reason = '')

+ if (($data['topic_first_post_id'] === $data['topic_last_post_id']) && ($data['topic_posts_approved'] + $data['topic_posts_unapproved'] + $data['topic_posts_softdeleted'] == 1))

+ // (Soft) delete the post

+ if ($is_soft && ($post_mode != 'delete_topic'))

+ phpbb_content_visibility::set_post_visibility(ITEM_DELETED, $post_id, $topic_id, $forum_id, $user->data['user_id'], time(), $softdelete_reason, ($data['topic_first_post_id'] == $post_id), ($data['topic_last_post_id'] == $post_id));

+ }

+ else if (!$is_soft)

+ {

+ if (!delete_posts('post_id', array($post_id), false, false, false))

+ // Try to delete topic, we may had an previous error causing inconsistency

+ if ($post_mode == 'delete_topic')

+ {

+ delete_topics('topic_id', array($topic_id), false);

+ }

+ trigger_error('ALREADY_DELETED');

+ $sql_data[FORUMS_TABLE] = $sql_data[TOPICS_TABLE] = '';

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET forum_topics_approved = forum_topics_approved - ' . $topic_count . '

+ WHERE forum_id = ' . $updated_forum;

+ $db->sql_query($sql);

+ if ($is_soft)

+ {

+ $topic_row = array();

+ phpbb_content_visibility::set_topic_visibility(ITEM_DELETED, $topic_id, $forum_id, $user->data['user_id'], time(), $softdelete_reason);

+ }

+ else

+ {

+ delete_topics('topic_id', array($topic_id), false);

+ if ($data['topic_visibility'] == ITEM_APPROVED)

+ {

+ $sql_data[FORUMS_TABLE] .= 'forum_posts_approved = forum_posts_approved - 1, forum_topics_approved = forum_topics_approved - 1';

+ }

+ else if ($data['topic_visibility'] == ITEM_UNAPPROVED)

+ {

+ $sql_data[FORUMS_TABLE] .= 'forum_posts_unapproved = forum_posts_unapproved - 1, forum_topics_unapproved = forum_topics_unapproved - 1';

+ }

+ else if ($data['topic_visibility'] == ITEM_DELETED)

+ {

+ $sql_data[FORUMS_TABLE] .= 'forum_posts_softdeleted = forum_posts_softdeleted - 1, forum_topics_softdeleted = forum_topics_softdeleted - 1';

+ }

+ $update_sql = update_post_information('forum', $forum_id, true);

+ if (sizeof($update_sql))

+ {

+ $sql_data[FORUMS_TABLE] .= ($sql_data[FORUMS_TABLE]) ? ', ' : '';

+ $sql_data[FORUMS_TABLE] .= implode(', ', $update_sql[$forum_id]);

+ }

+

+ AND p.post_visibility = " . ITEM_APPROVED . '

+ ORDER BY p.post_time ASC';

+ if (!$row)

+ {

+ // No approved post, so the first is a not-approved post (unapproved or soft deleted)

+ $sql = 'SELECT p.post_id, p.poster_id, p.post_time, p.post_username, u.username, u.user_colour

+ FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . " u

+ WHERE p.topic_id = $topic_id

+ AND p.poster_id = u.user_id

+ ORDER BY p.post_time ASC";

+ $result = $db->sql_query_limit($sql, 1);

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+ }

+

+ $sql_data[TOPICS_TABLE] = $db->sql_build_array('UPDATE', array(

+ 'topic_poster' => (int) $row['poster_id'],

+ 'topic_first_post_id' => (int) $row['post_id'],

+ 'topic_first_poster_colour' => $row['user_colour'],

+ 'topic_first_poster_name' => ($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username'],

+ 'topic_time' => (int) $row['post_time'],

+ ));

+ if (!$is_soft)

+ // Update last post information when hard deleting. Soft delete already did that by itself.

+ $update_sql = update_post_information('forum', $forum_id, true);

+ if (sizeof($update_sql))

+ {

+ $sql_data[FORUMS_TABLE] = (($sql_data[FORUMS_TABLE]) ? $sql_data[FORUMS_TABLE] . ', ' : '') . implode(', ', $update_sql[$forum_id]);

+ }

+ $sql_data[TOPICS_TABLE] = (($sql_data[TOPICS_TABLE]) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_bumped = 0, topic_bumper = 0';

+ $update_sql = update_post_information('topic', $topic_id, true);

+ if (!empty($update_sql))

+ {

+ $sql_data[TOPICS_TABLE] .= ', ' . implode(', ', $update_sql[$topic_id]);

+ $next_post_id = (int) str_replace('topic_last_post_id = ', '', $update_sql[$topic_id][0]);

+ }

+

+ if (!$next_post_id)

+ WHERE topic_id = $topic_id

+ AND " . phpbb_content_visibility::get_visibility_sql('post', $forum_id);

+ $next_post_id = (int) $db->sql_fetchfield('last_post_id');

+ WHERE topic_id = $topic_id

+ AND " . phpbb_content_visibility::get_visibility_sql('post', $forum_id) . '

+ $next_post_id = (int) $db->sql_fetchfield('post_id');

+ if (!$is_soft)

+ {

+ if ($data['post_visibility'] == ITEM_APPROVED)

+ {

+ phpbb_content_visibility::remove_post_from_statistic($data, $sql_data);

+ }

+ else if ($data['post_visibility'] == ITEM_UNAPPROVED)

+ {

+ $sql_data[FORUMS_TABLE] = (($sql_data[FORUMS_TABLE]) ? $sql_data[FORUMS_TABLE] . ', ' : '') . 'forum_posts_unapproved = forum_posts_unapproved - 1';

+ $sql_data[TOPICS_TABLE] = (($sql_data[TOPICS_TABLE]) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_posts_unapproved = topic_posts_unapproved - 1';

+ }

+ else if ($data['post_visibility'] == ITEM_DELETED)

+ {

+ $sql_data[FORUMS_TABLE] = (($sql_data[FORUMS_TABLE]) ? $sql_data[FORUMS_TABLE] . ', ' : '') . 'forum_posts_softdeleted = forum_posts_softdeleted - 1';

+ $sql_data[TOPICS_TABLE] = (($sql_data[TOPICS_TABLE]) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_posts_softdeleted = topic_posts_softdeleted - 1';

+ }

+ }

+

+ $sql_data[TOPICS_TABLE] = (($sql_data[TOPICS_TABLE]) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_attachment = 0';

+ USERS_TABLE => 'user_id = ' . $data['poster_id'],

+ $post_mode = ($data['topic_posts_approved'] + $data['topic_posts_unapproved'] + $data['topic_posts_softdeleted'] == 1) ? 'edit_topic' : (($data['topic_first_post_id'] == $data['post_id']) ? 'edit_first_post' : (($data['topic_last_post_id'] == $data['post_id']) ? 'edit_last_post' : 'edit'));

+ if ($mode == 'edit' && (!isset($data['post_visibility']) || !isset($data['topic_visibility']) || $data['post_visibility'] === false || $data['topic_visibility'] === false))

+ $sql = 'SELECT p.post_visibility, t.topic_type, t.topic_posts_approved, t.topic_posts_unapproved, t.topic_posts_softdeleted, t.topic_visibility

+ $data['topic_visibility'] = $topic_row['topic_visibility'];

+ $data['post_visibility'] = $topic_row['post_visibility'];

+ // This variable indicates if the user is able to post or put into the queue

+ $post_visibility = ITEM_APPROVED;

+ $post_visibility = ITEM_UNAPPROVED;

+ // MODs/Extensions are able to force any visibility on posts

+ $post_visibility = (in_array((int) $data['force_approved_state'], array(ITEM_APPROVED, ITEM_UNAPPROVED, ITEM_DELETED))) ? (int) $data['force_approved_state'] : $post_visibility;

+ }

+ if (isset($data['force_visibility']))

+ {

+ $post_visibility = (in_array((int) $data['force_visibility'], array(ITEM_APPROVED, ITEM_UNAPPROVED, ITEM_DELETED))) ? (int) $data['force_visibility'] : $post_visibility;

+ 'post_visibility' => $post_visibility,

+ // We will change the visibility later

+ //'post_visibility' => $post_visibility,

+ 'topic_posts_approved' => ($post_visibility == ITEM_APPROVED) ? 1 : 0,

+ 'topic_posts_softdeleted' => ($post_visibility == ITEM_DELETED) ? 1 : 0,

+ 'topic_posts_unapproved' => ($post_visibility == ITEM_UNAPPROVED) ? 1 : 0,

+ 'topic_visibility' => $post_visibility,

+ 'topic_delete_user' => ($post_visibility != ITEM_APPROVED) ? (int) $user->data['user_id'] : 0,

+ $sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_visibility == ITEM_APPROVED) ? ', user_posts = user_posts + 1' : '');

+ if ($post_visibility == ITEM_APPROVED)

+ {

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_approved = forum_topics_approved + 1';

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts_approved = forum_posts_approved + 1';

+ }

+ else if ($post_visibility == ITEM_UNAPPROVED)

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_unapproved = forum_topics_unapproved + 1';

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts_unapproved = forum_posts_unapproved + 1';

+ }

+ else if ($post_visibility == ITEM_DELETED)

+ {

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_softdeleted = forum_topics_softdeleted + 1';

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts_softdeleted = forum_posts_softdeleted + 1';

+ (($post_visibility == ITEM_APPROVED) ? ', topic_posts_approved = topic_posts_approved + 1' : '') .

+ (($post_visibility == ITEM_UNAPPROVED) ? ', topic_posts_unapproved = topic_posts_unapproved + 1' : '') .

+ (($post_visibility == ITEM_DELETED) ? ', topic_posts_softdeleted = topic_posts_softdeleted + 1' : '') .

+ $sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_visibility == ITEM_APPROVED) ? ', user_posts = user_posts + 1' : '');

+ if ($post_visibility == ITEM_APPROVED)

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts_approved = forum_posts_approved + 1';

+ }

+ else if ($post_visibility == ITEM_UNAPPROVED)

+ {

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts_unapproved = forum_posts_unapproved + 1';

+ }

+ else if ($post_visibility == ITEM_DELETED)

+ {

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts_softdeleted = forum_posts_softdeleted + 1';

+ 'topic_id' => $data['topic_id'],

+ ));

+ if ($post_mode == 'post' || $post_visibility == ITEM_APPROVED)

+ 'topic_last_poster_id' => $sql_data[POSTS_TABLE]['sql']['poster_id'],

+ 'topic_last_poster_name' => ($user->data['user_id'] == ANONYMOUS) ? $sql_data[POSTS_TABLE]['sql']['post_username'] : $user->data['username'],

+ if ($post_mode == 'post')

+ {

+ $sql_data[TOPICS_TABLE]['sql']['topic_first_post_id'] = $data['post_id'];

+ }

+

+ // Update total post count and forum information

+ if ($post_visibility == ITEM_APPROVED)

+ {

+ if ($post_mode == 'post')

+ {

+ set_config_count('num_topics', 1, true);

+ }

+ set_config_count('num_posts', 1, true);

+

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . $data['post_id'];

+ $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = '" . $db->sql_escape($subject) . "'";

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . $current_time;

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) $user->data['user_id'];

+ $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape((!$user->data['is_registered'] && $username) ? $username : (($user->data['user_id'] != ANONYMOUS) ? $user->data['username'] : '')) . "'";

+ $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = '" . $db->sql_escape($user->data['user_colour']) . "'";

+ }

+

+

+ unset($sql_data[TOPICS_TABLE]['sql']);

+

+ unset($sql_data[POSTS_TABLE]['sql']);

+ // Fix the post's and topic's visibility and first/last post information, when the post is edited

+ if (($post_mode != 'post' && $post_mode != 'reply') && $data['post_visibility'] != $post_visibility)

+ // If the post was not approved, it could also be the starter,

+ // so we sync the starter after approving/restoring, to ensure that the stats are correct

+ // Same applies for the last post

+ $is_starter = ($post_mode == 'edit_first_post' || $data['post_visibility'] != ITEM_APPROVED);

+ $is_latest = ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || $data['post_visibility'] != ITEM_APPROVED);

+ phpbb_content_visibility::set_post_visibility($post_visibility, $data['post_id'], $data['topic_id'], $data['forum_id'], $user->data['user_id'], time(), '', $is_starter, $is_latest);

+ else if ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || ($post_mode == 'edit_first_post' && !$data['topic_replies']))

+ if ($post_visibility == ITEM_APPROVED || $data['topic_visibility'] == $post_visibility)

+ if ($post_visibility == ITEM_APPROVED)

+ {

+ // this does not _necessarily_ mean that we must update the info again,

+ // it just means that we might have to

+ $sql = 'SELECT forum_last_post_id, forum_last_post_subject

+ FROM ' . FORUMS_TABLE . '

+ WHERE forum_id = ' . (int) $data['forum_id'];

+ $result = $db->sql_query($sql);

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+ // this post is the latest post in the forum, better update

+ if ($row['forum_last_post_id'] == $data['post_id'] && ($row['forum_last_post_subject'] !== $subject || $data['poster_id'] == ANONYMOUS))

+ {

+ // the post's subject changed

+ if ($row['forum_last_post_subject'] !== $subject)

+ {

+ $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = '" . $db->sql_escape($subject) . "'";

+ }

+ // Update the user name if poster is anonymous... just in case a moderator changed it

+ if ($data['poster_id'] == ANONYMOUS)

+ {

+ $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape($username) . "'";

+ }

+ }

+ }

+ $where_sql = array(

+ POSTS_TABLE => 'post_id = ' . $data['post_id'],

+ TOPICS_TABLE => 'topic_id = ' . $data['topic_id'],

+ FORUMS_TABLE => 'forum_id = ' . $data['forum_id'],

+ USERS_TABLE => 'user_id = ' . $poster_id

+ );

+ if ($post_visibility == ITEM_APPROVED)

+ else if ($post_visibility == ITEM_UNAPPROVED)

+ // @todo: Check whether these notification deletions are correct

+ $phpbb_notifications->delete_notifications('topic', $data['topic_id']);

+

+ $phpbb_notifications->delete_notifications(array(

+ 'quote',

+ 'bookmark',

+ 'post',

+ ), $data['post_id']);

+ break;

+ }

+ }

+ else if ($post_visibility == ITEM_DELETED)

+ {

+ switch ($mode)

+ {

+ case 'post':

+ case 'reply':

+ case 'quote':

+ // Nothing to do here

+ break;

+

+ case 'edit_topic':

+ case 'edit_first_post':

+ case 'edit':

+ case 'edit_last_post':

+ // @todo: Check whether these notification deletions are correct

+ if ($post_visibility == ITEM_APPROVED)

+ 'deleted_topics' => array('title' => 'MCP_QUEUE_DELETED_TOPICS', 'auth' => 'aclf_m_approve', 'cat' => array('MCP_QUEUE')),

+ 'deleted_posts' => array('title' => 'MCP_QUEUE_DELETED_POSTS', 'auth' => 'aclf_m_approve', 'cat' => array('MCP_QUEUE')),

+ $forum_topics = ($total == -1) ? $forum_info['forum_topics_approved'] : $total;

+ 'S_CAN_RESTORE' => $auth->acl_get('m_approve', $forum_id),

+ AND ' . phpbb_content_visibility::get_visibility_sql('topic', $forum_id, 't.') . "

+ $replies = phpbb_content_visibility::get_count('topic_posts', $row, $forum_id) - 1;

+ $topic_unapproved = ($row['topic_visibility'] == ITEM_UNAPPROVED && $auth->acl_get('m_approve', $row['forum_id'])) ? true : false;

+ $posts_unapproved = ($row['topic_visibility'] == ITEM_APPROVED && $row['topic_posts_unapproved'] && $auth->acl_get('m_approve', $row['forum_id'])) ? true : false;

+ $topic_deleted = $row['topic_visibility'] == ITEM_DELETED;

+ $u_mcp_queue = (!$u_mcp_queue && $topic_deleted) ? $url . '&amp;i=queue&amp;mode=deleted_topics&amp;t=' . $topic_id : $u_mcp_queue;

+ 'DELETED_IMG' => ($topic_deleted) ? $user->img('icon_topic_deleted', 'POSTS_DELETED') : '',

+ 'REPLIES' => phpbb_content_visibility::get_count('topic_posts', $row, $row['forum_id']) - 1,

+ 'S_TOPIC_DELETED' => $topic_deleted,

+ AND post_visibility = ' . ITEM_UNAPPROVED;

+ AND post_visibility = ' . ITEM_UNAPPROVED . '

+ global $config, $phpbb_root_path, $phpEx, $request;

+ // f parameter is not reliable for permission usage, however we just use it to decide

+ // which permission we will check later on. So if it is manipulated, we will still catch it later on.

+ $forum_id = $request->variable('f', 0);

+ $topic_ids = (!$quickmod) ? $request->variable('topic_id_list', array(0)) : array($request->variable('t', 0));

+ $soft_delete = (($request->is_set_post('confirm') && !$request->is_set_post('delete_permanent')) || !$auth->acl_get('m_delete', $forum_id)) ? true : false;

+ mcp_delete_topic($topic_ids, $soft_delete, ($soft_delete) ? $request->variable('delete_reason', '', true) : '');

+ // f parameter is not reliable for permission usage, however we just use it to decide

+ // which permission we will check later on. So if it is manipulated, we will still catch it later on.

+ $forum_id = $request->variable('f', 0);

+ $post_ids = (!$quickmod) ? $request->variable('post_id_list', array(0)) : array($request->variable('p', 0));

+ $soft_delete = (($request->is_set_post('confirm') && !$request->is_set_post('delete_permanent')) || !$auth->acl_get('m_delete', $forum_id)) ? true : false;

+ mcp_delete_post($post_ids, $soft_delete, ($soft_delete) ? $request->variable('delete_reason', '', true) : '');

+ break;

+

+ case 'restore_topic':

+ $user->add_lang('posting');

+

+ $topic_ids = (!$quickmod) ? $request->variable('topic_id_list', array(0)) : array($request->variable('t', 0));

+

+ if (!sizeof($topic_ids))

+ {

+ trigger_error('NO_TOPIC_SELECTED');

+ }

+

+ mcp_restore_topic($topic_ids);

+ $topics_moved = $topics_moved_unapproved = $topics_moved_softdeleted = 0;

+ $posts_moved = $posts_moved_unapproved = $posts_moved_softdeleted = 0;

+ if ($topic_info['topic_visibility'] == ITEM_APPROVED)

+ $topics_moved++;

+ elseif ($topic_info['topic_visibility'] == ITEM_UNAPPROVED)

+ $topics_moved_unapproved++;

+ }

+ elseif ($topic_info['topic_visibility'] == ITEM_DELETED)

+ {

+ $topics_moved_softdeleted++;

+ $posts_moved += $topic_info['topic_posts_approved'];

+ $posts_moved_unapproved += $topic_info['topic_posts_unapproved'];

+ $posts_moved_softdeleted += $topic_info['topic_posts_softdeleted'];

+ $topics_moved = sizeof($topic_data);

+ $db->sql_transaction('begin');

+ if ($leave_shadow && $row['topic_visibility'] == ITEM_APPROVED && $row['topic_type'] != POST_GLOBAL)

+ 'topic_visibility' => ITEM_APPROVED, // a shadow topic is always approved

+ 'topic_posts_approved' => (int) $row['topic_posts_approved'],

+ 'topic_posts_unapproved'=> (int) $row['topic_posts_unapproved'],

+ 'topic_posts_softdeleted'=> (int) $row['topic_posts_softdeleted'],

+ $shadow_topics++;

+ $sync_sql = array();

+ if ($posts_moved)

+ $sync_sql[$to_forum_id][] = 'forum_posts_approved = forum_posts_approved + ' . (int) $posts_moved;

+ $sync_sql[$forum_id][] = 'forum_posts_approved = forum_posts_approved - ' . (int) $posts_moved;

+ if ($posts_moved_unapproved)

+ {

+ $sync_sql[$to_forum_id][] = 'forum_posts_unapproved = forum_posts_unapproved + ' . (int) $posts_moved_unapproved;

+ $sync_sql[$forum_id][] = 'forum_posts_unapproved = forum_posts_unapproved - ' . (int) $posts_moved_unapproved;

+ }

+ if ($posts_moved_softdeleted)

+ $sync_sql[$to_forum_id][] = 'forum_posts_softdeleted = forum_posts_softdeleted + ' . (int) $posts_moved_softdeleted;

+ $sync_sql[$forum_id][] = 'forum_posts_softdeleted = forum_posts_softdeleted - ' . (int) $posts_moved_softdeleted;

+ if ($topics_moved)

+ $sync_sql[$to_forum_id][] = 'forum_topics_approved = forum_topics_approved + ' . (int) $topics_moved;

+ if ($topics_moved - $shadow_topics > 0)

+ {

+ $sync_sql[$forum_id][] = 'forum_topics_approved = forum_topics_approved - ' . (int) ($topics_moved - $shadow_topics);

+ }

+ }

+ if ($topics_moved_unapproved)

+ {

+ $sync_sql[$to_forum_id][] = 'forum_topics_unapproved = forum_topics_unapproved + ' . (int) $topics_moved_unapproved;

+ $sync_sql[$forum_id][] = 'forum_topics_unapproved = forum_topics_unapproved - ' . (int) $topics_moved_unapproved;

+ }

+ if ($topics_moved_softdeleted)

+ {

+ $sync_sql[$to_forum_id][] = 'forum_topics_softdeleted = forum_topics_softdeleted + ' . (int) $topics_moved_softdeleted;

+ $sync_sql[$forum_id][] = 'forum_topics_softdeleted = forum_topics_softdeleted - ' . (int) $topics_moved_softdeleted;

+* Restore Topics

+*/

+function mcp_restore_topic($topic_ids)

+{

+ global $auth, $user, $db, $phpEx, $phpbb_root_path, $request;

+

+ if (!check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_approve')))

+ {

+ return;

+ }

+

+ $redirect = $request->variable('redirect', build_url(array('action', 'quickmod')));

+ $forum_id = $request->variable('f', 0);

+

+ $s_hidden_fields = build_hidden_fields(array(

+ 'topic_id_list' => $topic_ids,

+ 'f' => $forum_id,

+ 'action' => 'restore_topic',

+ 'redirect' => $redirect,

+ ));

+ $success_msg = '';

+

+ if (confirm_box(true))

+ {

+ $success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_RESTORED_SUCCESS' : 'TOPICS_RESTORED_SUCCESS';

+

+ $data = get_topic_data($topic_ids);

+

+ foreach ($data as $topic_id => $row)

+ {

+ $return = phpbb_content_visibility::set_topic_visibility(ITEM_APPROVED, $topic_id, $row['forum_id'], $user->data['user_id'], time(), '');

+ if (!empty($return))

+ {

+ add_log('mod', $row['forum_id'], $topic_id, 'LOG_RESTORE_TOPIC', $row['topic_title'], $row['topic_first_poster_name']);

+ }

+ }

+ }

+ else

+ {

+ confirm_box(false, (sizeof($topic_ids) == 1) ? 'RESTORE_TOPIC' : 'RESTORE_TOPICS', $s_hidden_fields);

+ }

+

+ $topic_id = $request->variable('t', 0);

+ if (!$request->is_set('quickmod', phpbb_request_interface::REQUEST))

+ {

+ $redirect = $request->variable('redirect', "index.$phpEx");

+ $redirect = reapply_sid($redirect);

+ $redirect_message = 'PAGE';

+ }

+ else if ($topic_id)

+ {

+ $redirect = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . $topic_id);

+ $redirect_message = 'TOPIC';

+ }

+ else

+ {

+ $redirect = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id);

+ $redirect_message = 'FORUM';

+ }

+

+ if (!$success_msg)

+ {

+ redirect($redirect);

+ }

+ else

+ {

+ meta_refresh(3, $redirect);

+ trigger_error($user->lang[$success_msg] . '<br /><br />' . sprintf($user->lang['RETURN_' . $redirect_message], '<a href="' . $redirect . '">', '</a>'));

+ }

+}

+

+/**

+function mcp_delete_topic($topic_ids, $is_soft = false, $soft_delete_reason = '', $action = 'delete_topic')

+ global $auth, $user, $db, $phpEx, $phpbb_root_path, $request;

+ $redirect = $request->variable('redirect', build_url(array('action', 'quickmod')));

+ $forum_id = $request->variable('f', 0);

+ $s_hidden_fields = array(

+ 'action' => $action,

+ 'redirect' => $redirect,

+ // Only soft delete non-shadow topics

+ if ($is_soft)

+ {

+ $return = phpbb_content_visibility::set_topic_visibility(ITEM_DELETED, $topic_id, $row['forum_id'], $user->data['user_id'], time(), $soft_delete_reason);

+ if (!empty($return))

+ {

+ add_log('mod', $row['forum_id'], $topic_id, 'LOG_SOFTDELETE_TOPIC', $row['topic_title'], $row['topic_first_poster_name']);

+ }

+ }

+ else

+ {

+ add_log('mod', $row['forum_id'], $topic_id, 'LOG_DELETE_TOPIC', $row['topic_title'], $row['topic_first_poster_name']);

+ }

+ if (!$is_soft)

+ {

+ $return = delete_topics('topic_id', $topic_ids);

+ }

+ global $template;

+

+ $user->add_lang('posting');

+

+ $only_softdeleted = false;

+ if ($auth->acl_get('m_delete', $forum_id) && $auth->acl_get('m_softdelete', $forum_id))

+ {

+ // If there are only soft deleted topics, we display a message why the option is not available

+ $sql = 'SELECT topic_id

+ FROM ' . TOPICS_TABLE . '

+ WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '

+ AND topic_visibility <> ' . ITEM_DELETED;

+ $result = $db->sql_query_limit($sql, 1);

+ $only_softdeleted = !$db->sql_fetchfield('topic_id');

+ $db->sql_freeresult($result);

+ }

+

+ $template->assign_vars(array(

+ 'S_SOFTDELETED' => $only_softdeleted,

+ 'S_TOPIC_MODE' => true,

+ 'S_ALLOWED_DELETE' => $auth->acl_get('m_delete', $forum_id),

+ 'S_ALLOWED_SOFTDELETE' => $auth->acl_get('m_softdelete', $forum_id),

+ 'S_DELETE_REASON' => $auth->acl_get('m_softdelete', $forum_id),

+ ));

+

+ $l_confirm = (sizeof($topic_ids) == 1) ? 'DELETE_TOPIC' : 'DELETE_TOPICS';

+ if ($only_softdeleted)

+ {

+ $l_confirm .= '_PERMANENTLY';

+ $s_hidden_fields['delete_permanent'] = '1';

+ }

+ else if (!$auth->acl_get('m_softdelete', $forum_id))

+ {

+ $s_hidden_fields['delete_permanent'] = '1';

+ }

+

+ confirm_box(false, $l_confirm, build_hidden_fields($s_hidden_fields), 'confirm_delete_body.html');

+ $topic_id = $request->variable('t', 0);

+ if (!$request->is_set('quickmod', phpbb_request_interface::REQUEST))

+ $redirect = $request->variable('redirect', "index.$phpEx");

+ else if ($is_soft && $topic_id)

+ {

+ $redirect = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . $topic_id);

+ $redirect_message = 'TOPIC';

+ }

+function mcp_delete_post($post_ids, $is_soft = false, $soft_delete_reason = '', $action = 'delete_post')

+ global $auth, $user, $db, $phpEx, $phpbb_root_path, $request;

+ if (!check_ids($post_ids, POSTS_TABLE, 'post_id', array('m_softdelete')))

+ $redirect = $request->variable('redirect', build_url(array('action', 'quickmod')));

+ $forum_id = $request->variable('f', 0);

+ $s_hidden_fields = array(

+ 'action' => $action,

+ 'redirect' => $redirect,

+ if (confirm_box(true) && $is_soft)

+ {

+ $post_info = get_post_data($post_ids);

+

+ $topic_info = $approve_log = array();

+

+ // Group the posts by topic_id

+ foreach ($post_info as $post_id => $post_data)

+ {

+ if ($post_data['post_visibility'] != ITEM_APPROVED)

+ {

+ continue;

+ }

+ $topic_id = (int) $post_data['topic_id'];

+

+ $topic_info[$topic_id]['posts'][] = (int) $post_id;

+ $topic_info[$topic_id]['forum_id'] = (int) $post_data['forum_id'];

+

+ if ($post_id == $post_data['topic_first_post_id'])

+ {

+ $topic_info[$topic_id]['first_post'] = true;

+ }

+

+ if ($post_id == $post_data['topic_last_post_id'])

+ {

+ $topic_info[$topic_id]['last_post'] = true;

+ }

+

+ $approve_log[] = array(

+ 'forum_id' => $post_data['forum_id'],

+ 'topic_id' => $post_data['topic_id'],

+ 'post_subject' => $post_data['post_subject'],

+ 'poster_id' => $post_data['poster_id'],

+ 'post_username' => $post_data['post_username'],

+ 'username' => $post_data['username'],

+ );

+ }

+

+ foreach ($topic_info as $topic_id => $topic_data)

+ {

+ phpbb_content_visibility::set_post_visibility(ITEM_DELETED, $topic_data['posts'], $topic_id, $topic_data['forum_id'], $user->data['user_id'], time(), $soft_delete_reason, isset($topic_data['first_post']), isset($topic_data['last_post']));

+ }

+ $affected_topics = sizeof($topic_info);

+ // None of the topics is really deleted, so a redirect won't hurt much.

+ $deleted_topics = 0;

+

+ $success_msg = (sizeof($post_info) == 1) ? 'POST_DELETED_SUCCESS' : 'POSTS_DELETED_SUCCESS';

+

+ foreach ($approve_log as $row)

+ {

+ $post_username = ($row['poster_id'] == ANONYMOUS && !empty($row['post_username'])) ? $row['post_username'] : $row['username'];

+ add_log('mod', $row['forum_id'], $row['topic_id'], 'LOG_SOFTDELETE_POST', $row['post_subject'], $post_username);

+ }

+

+ $topic_id = $request->variable('t', 0);

+

+ // Return links

+ $return_link = array();

+ if ($affected_topics == 1 && $topic_id)

+ {

+ $return_link[] = sprintf($user->lang['RETURN_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=$topic_id") . '">', '</a>');

+ }

+ $return_link[] = sprintf($user->lang['RETURN_FORUM'], '<a href="' . append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id) . '">', '</a>');

+

+ }

+ else if (confirm_box(true))

+ $topic_id = $request->variable('t', 0);

+ global $template;

+

+ $user->add_lang('posting');

+

+ $only_softdeleted = false;

+ if ($auth->acl_get('m_delete', $forum_id) && $auth->acl_get('m_softdelete', $forum_id))

+ {

+ // If there are only soft deleted posts, we display a message why the option is not available

+ $sql = 'SELECT post_id

+ FROM ' . POSTS_TABLE . '

+ WHERE ' . $db->sql_in_set('post_id', $post_ids) . '

+ AND post_visibility <> ' . ITEM_DELETED;

+ $result = $db->sql_query_limit($sql, 1);

+ $only_softdeleted = !$db->sql_fetchfield('post_id');

+ $db->sql_freeresult($result);

+ }

+

+ $template->assign_vars(array(

+ 'S_SOFTDELETED' => $only_softdeleted,

+ 'S_ALLOWED_DELETE' => $auth->acl_get('m_delete', $forum_id),

+ 'S_ALLOWED_SOFTDELETE' => $auth->acl_get('m_softdelete', $forum_id),

+ 'S_DELETE_REASON' => $auth->acl_get('m_softdelete', $forum_id),

+ ));

+

+ $l_confirm = (sizeof($post_ids) == 1) ? 'DELETE_POST' : 'DELETE_POSTS';

+ if ($only_softdeleted)

+ {

+ $l_confirm .= '_PERMANENTLY';

+ $s_hidden_fields['delete_permanent'] = '1';

+ }

+ else if (!$auth->acl_get('m_softdelete', $forum_id))

+ {

+ $s_hidden_fields['delete_permanent'] = '1';

+ }

+

+ confirm_box(false, $l_confirm, build_hidden_fields($s_hidden_fields), 'confirm_delete_body.html');

+ $redirect = $request->variable('redirect', "index.$phpEx");

+ 'topic_visibility' => ITEM_APPROVED,

+ 'topic_posts_approved' => (int) $topic_row['topic_posts_approved'],

+ 'topic_posts_unapproved' => (int) $topic_row['topic_posts_unapproved'],

+ 'topic_posts_softdeleted' => (int) $topic_row['topic_posts_softdeleted'],

+ 'post_visibility' => ITEM_APPROVED,

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET forum_posts_approved = forum_posts_approved + ' . $total_posts . ',

+ forum_topics_approved = forum_topics_approved + ' . sizeof($new_topic_id_list) . '

+ WHERE forum_id = ' . $to_forum_id;

+ $db->sql_query($sql);

+ sync('topic', 'topic_id', $new_topic_id_list);

+

+ // Deleting information

+ if ($post_info['post_visibility'] == ITEM_DELETED && $post_info['post_delete_user'])

+ {

+ // User having deleted the post also being the post author?

+ if (!$post_info['post_delete_user'] || $post_info['post_delete_user'] == $post_info['poster_id'])

+ {

+ $display_username = get_username_string('full', $post_info['poster_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']);

+ }

+ else

+ {

+ $sql = 'SELECT user_id, username, user_colour

+ FROM ' . USERS_TABLE . '

+ WHERE user_id = ' . (int) $post_info['post_delete_user'];

+ $result = $db->sql_query($sql);

+ $user_delete_row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+ $display_username = get_username_string('full', $post_info['post_delete_user'], $user_delete_row['username'], $user_delete_row['user_colour']);

+ }

+

+ $user->add_lang('viewtopic');

+ $l_deleted_by = $user->lang('DELETED_INFORMATION', $display_username, $user->format_date($post_info['post_delete_time'], false, true));

+ }

+ else

+ {

+ $l_deleted_by = '';

+ }

+

+ 'S_POST_UNAPPROVED' => ($post_info['post_visibility'] == ITEM_UNAPPROVED) ? true : false,

+ 'S_POST_DELETED' => ($post_info['post_visibility'] == ITEM_DELETED) ? true : false,

+ 'DELETED_MESSAGE' => $l_deleted_by,

+ 'DELETE_REASON' => $post_info['post_delete_reason'],

+ 'DELETED_IMG' => $user->img('icon_topic_deleted', $user->lang['POST_DELETED']),

+ if ($post_info['post_postcount'] && $post_info['post_visibility'] == ITEM_APPROVED)

+ public function mcp_queue(&$p_master)

+ public function main($id, $mode)

+ global $auth, $db, $user, $template, $cache, $request;

+ case 'restore':

+ $post_id_list = $request->variable('post_id_list', array(0));

+ $topic_id_list = $request->variable('topic_id_list', array(0));

+ if (!empty($post_id_list))

+ {

+ self::approve_posts($action, $post_id_list, 'queue', $mode);

+ }

+ else if (!empty($topic_id_list))

+ {

+ self::approve_topics($action, $topic_id_list, 'queue', $mode);

+ }

+ else

+ break;

+

+ case 'delete':

+ $post_id_list = $request->variable('post_id_list', array(0));

+ $topic_id_list = $request->variable('topic_id_list', array(0));

+ if (!empty($post_id_list))

+ {

+ if (!function_exists('mcp_delete_post'))

+ {

+ global $phpbb_root_path, $phpEx;

+ include($phpbb_root_path . 'includes/mcp/mcp_main.' . $phpEx);

+ }

+ mcp_delete_post($post_id_list, false, '', $action);

+ }

+ else if (!empty($topic_id_list))

+ if (!function_exists('mcp_delete_topic'))

+ {

+ global $phpbb_root_path, $phpEx;

+ include($phpbb_root_path . 'includes/mcp/mcp_main.' . $phpEx);

+ }

+ mcp_delete_topic($topic_id_list, false, '', $action);

+ trigger_error('NO_POST_SELECTED');

+ break;

+ case 'disapprove':

+ $post_id_list = $request->variable('post_id_list', array(0));

+ $topic_id_list = $request->variable('topic_id_list', array(0));

+

+ if (!empty($topic_id_list) && $mode == 'deleted_topics')

+ {

+ if (!function_exists('mcp_delete_topics'))

+ {

+ global $phpbb_root_path, $phpEx;

+ include($phpbb_root_path . 'includes/mcp/mcp_main.' . $phpEx);

+ }

+ mcp_delete_topic($topic_id_list, false, '', 'disapprove');

+ return;

+ }

+

+ include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

+

+ if (!empty($topic_id_list))

+ {

+ $post_visibility = ($mode == 'deleted_topics') ? ITEM_DELETED : ITEM_UNAPPROVED;

+ $sql = 'SELECT post_id

+ FROM ' . POSTS_TABLE . '

+ WHERE post_visibility = ' . $post_visibility . '

+ AND ' . $db->sql_in_set('topic_id', $topic_id_list);

+ $result = $db->sql_query($sql);

+

+ $post_id_list = array();

+ while ($row = $db->sql_fetchrow($result))

+ {

+ $post_id_list[] = (int) $row['post_id'];

+ }

+ $db->sql_freeresult($result);

+ }

+

+ if (!empty($post_id_list))

+ {

+ self::disapprove_posts($post_id_list, 'queue', $mode);

+ }

+ else

+ {

+ trigger_error('NO_POST_SELECTED');

+ }

+ // Deleting information

+ if ($post_info['post_visibility'] == ITEM_DELETED && $post_info['post_delete_user'])

+ {

+ // User having deleted the post also being the post author?

+ if (!$post_info['post_delete_user'] || $post_info['post_delete_user'] == $post_info['poster_id'])

+ {

+ $display_username = get_username_string('full', $post_info['poster_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']);

+ }

+ else

+ {

+ $sql = 'SELECT u.user_id, u.username, u.user_colour

+ FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

+ WHERE p.post_id = ' . $post_info['post_id'] . '

+ AND p.post_delete_user = u.user_id';

+ $result = $db->sql_query($sql);

+ $post_delete_userinfo = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+ $display_username = get_username_string('full', $post_info['post_delete_user'], $post_delete_userinfo['username'], $post_delete_userinfo['user_colour']);

+ }

+

+ $l_deleted_by = $user->lang('DELETED_INFORMATION', $display_username, $user->format_date($post_info['post_delete_time'], false, true));

+ }

+ else

+ {

+ $l_deleted_by = '';

+ }

+

+ 'S_POST_UNAPPROVED' => ($post_info['post_visibility'] == ITEM_UNAPPROVED),

+ 'S_POST_DELETED' => ($post_info['post_visibility'] == ITEM_DELETED),

+ 'DELETED_MESSAGE' => $l_deleted_by,

+ 'DELETE_REASON' => $post_info['post_delete_reason'],

+

+ case 'deleted_topics':

+ case 'deleted_posts':

+ $m_perm = 'm_approve';

+ $is_topics = ($mode == 'unapproved_topics' || $mode == 'deleted_topics') ? true : false;

+ $is_restore = ($mode == 'deleted_posts' || $mode == 'deleted_topics') ? true : false;

+ $visibility_const = (!$is_restore) ? ITEM_UNAPPROVED : ITEM_DELETED;

+

+ $topic_id = $request->variable('t', 0);

+ $forum_list_approve = get_forum_list($m_perm, false, true);

+ $sql = 'SELECT SUM(forum_topics_approved) as sum_forum_topics

+ $forum_info['forum_topics_approved'] = (int) $db->sql_fetchfield('sum_forum_topics');

+ $forum_info = get_forum_data(array($forum_id), $m_perm);

+ $forum_topics = ($total == -1) ? $forum_info['forum_topics_approved'] : $total;

+ if (!$is_topics)

+ AND p.post_visibility = ' . $visibility_const . '

+ AND (t.topic_visibility <> p.post_visibility

+ OR t.topic_delete_user = 0)

+ FROM ' . TOPICS_TABLE . ' t

+ WHERE ' . $db->sql_in_set('forum_id', $forum_list) . '

+ AND topic_visibility = ' . $visibility_const . "

+ AND topic_delete_user <> 0

+ $row['post_username'] = $row['username'] ?: $user->lang['GUEST'];

+ 'TOPIC_ID' => $row['topic_id'],

+ 'L_DISPLAY_ITEMS' => (!$is_topics) ? $user->lang['DISPLAY_POSTS'] : $user->lang['DISPLAY_TOPICS'],

+ 'L_EXPLAIN' => $user->lang['MCP_QUEUE_' . strtoupper($mode) . '_EXPLAIN'],

+ 'L_TITLE' => $user->lang['MCP_QUEUE_' . strtoupper($mode)],

+ 'S_TOPICS' => $is_topics,

+ 'S_RESTORE' => $is_restore,

+ 'TOTAL' => $user->lang(((!$is_topics) ? 'VIEW_TOPIC_POSTS' : 'VIEW_FORUM_TOPICS'), (int) $total),

+ /**

+ * Approve/Restore posts

+ *

+ * @param $action string Action we perform on the posts ('approve' or 'restore')

+ * @param $post_id_list array IDs of the posts to approve/restore

+ * @param $id mixed Category of the current active module

+ * @param $mode string Active module

+ * @return null

+ */

+ static public function approve_posts($action, $post_id_list, $id, $mode)

+ global $db, $template, $user, $config, $request, $phpbb_container;

+ global $phpEx, $phpbb_root_path;

+ if (!check_ids($post_id_list, POSTS_TABLE, 'post_id', array('m_approve')))

+ {

+ trigger_error('NOT_AUTHORISED');

+ }

+ $redirect = $request->variable('redirect', build_url(array('quickmod')));

+ $success_msg = $post_url = '';

+ $approve_log = array();

+ $s_hidden_fields = build_hidden_fields(array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'post_id_list' => $post_id_list,

+ 'action' => $action,

+ 'redirect' => $redirect,

+ ));

+ $post_info = get_post_data($post_id_list, 'm_approve');

+ if (confirm_box(true))

+ {

+ $notify_poster = ($action == 'approve' && isset($_REQUEST['notify_poster']));

+ $topic_info = array();

+ // Group the posts by topic_id

+ foreach ($post_info as $post_id => $post_data)

+ if ($post_data['post_visibility'] == ITEM_APPROVED)

+ {

+ continue;

+ }

+ $topic_id = (int) $post_data['topic_id'];

+ $topic_info[$topic_id]['posts'][] = (int) $post_id;

+ $topic_info[$topic_id]['forum_id'] = (int) $post_data['forum_id'];

+ // Refresh the first post, if the time or id is older then the current one

+ if ($post_id <= $post_data['topic_first_post_id'] || $post_data['post_time'] <= $post_data['topic_time'])

+ {

+ $topic_info[$topic_id]['first_post'] = true;

+ }

+ // Refresh the last post, if the time or id is newer then the current one

+ if ($post_id >= $post_data['topic_last_post_id'] || $post_data['post_time'] >= $post_data['topic_last_post_time'])

+ {

+ $topic_info[$topic_id]['last_post'] = true;

+ }

+

+ $post_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$post_data['forum_id']}&amp;t={$post_data['topic_id']}&amp;p={$post_data['post_id']}") . '#p' . $post_data['post_id'];

+ 'post_subject' => $post_data['post_subject'],

+

+ foreach ($topic_info as $topic_id => $topic_data)

+ phpbb_content_visibility::set_post_visibility(ITEM_APPROVED, $topic_data['posts'], $topic_id, $topic_data['forum_id'], $user->data['user_id'], time(), '', isset($topic_data['first_post']), isset($topic_data['last_post']));

+ if (sizeof($post_info) >= 1)

+ {

+ $success_msg = (sizeof($post_info) == 1) ? 'POST_' . strtoupper($action) . 'D_SUCCESS' : 'POSTS_' . strtoupper($action) . 'D_SUCCESS';

+ }

+ foreach ($approve_log as $log_data)

+ add_log('mod', $log_data['forum_id'], $log_data['topic_id'], 'LOG_POST_' . strtoupper($action) . 'D', $log_data['post_subject']);

+ // Only send out the mails, when the posts are being approved

+ if ($action == 'approve')

+ {

+ $phpbb_notifications = $phpbb_container->get('notification_manager');

+ // Handle notifications

+ foreach ($post_info as $post_id => $post_data)

+ {

+ $phpbb_notifications->delete_notifications('post_in_queue', $post_id);

+ $phpbb_notifications->add_notifications(array(

+ 'quote',

+ 'bookmark',

+ 'post',

+ ), $post_data);

+

+ $phpbb_notifications->mark_notifications_read(array(

+ 'quote',

+ 'bookmark',

+ 'post',

+ ), $post_data['post_id'], $user->data['user_id']);

+

+ // Notify Poster?

+ if ($notify_poster)

+ {

+ if ($post_data['poster_id'] == ANONYMOUS)

+ {

+ continue;

+ }

+ $phpbb_notifications->add_notifications('approve_post', $post_data);

+ }

+ }

+ }

+ }

+ else

+ $show_notify = false;

+

+ if ($action == 'approve' && ($config['email_enable'] || $config['jab_enable']))

+ {

+ foreach ($post_info as $post_data)

+ {

+ if ($post_data['poster_id'] == ANONYMOUS)

+ {

+ continue;

+ }

+ else

+ {

+ $show_notify = true;

+ break;

+ }

+ }

+ }

+

+ $template->assign_vars(array(

+ 'S_NOTIFY_POSTER' => $show_notify,

+ 'S_' . strtoupper($action) => true,

+ ));

+

+ confirm_box(false, strtoupper($action) . '_POST' . ((sizeof($post_id_list) == 1) ? '' : 'S'), $s_hidden_fields, 'mcp_approve.html');

+ $redirect = $request->variable('redirect', "index.$phpEx");

+ $redirect = reapply_sid($redirect);

+ if (!$success_msg)

+ redirect($redirect);

+ else

+ meta_refresh(3, $redirect);

+ // If approving one post, also give links back to post...

+ $add_message = '';

+ if (sizeof($post_info) == 1 && $post_url)

+ $add_message = '<br /><br />' . sprintf($user->lang['RETURN_POST'], '<a href="' . $post_url . '">', '</a>');

+ $message = $user->lang[$success_msg] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], "<a href=\"$redirect\">", '</a>') . $add_message;

+

+ if ($request->is_ajax())

+ $json_response = new phpbb_json_response;

+ $json_response->send(array(

+ 'MESSAGE_TITLE' => $user->lang['INFORMATION'],

+ 'MESSAGE_TEXT' => $message,

+ 'REFRESH_DATA' => null,

+ 'visible' => true,

+ ));

+ trigger_error($message);

+ }

+ /**

+ * Approve/Restore topics

+ *

+ * @param $action string Action we perform on the posts ('approve' or 'restore')

+ * @param $topic_id_list array IDs of the topics to approve/restore

+ * @param $id mixed Category of the current active module

+ * @param $mode string Active module

+ * @return null

+ */

+ static public function approve_topics($action, $topic_id_list, $id, $mode)

+ {

+ global $db, $template, $user, $config;

+ global $phpEx, $phpbb_root_path, $request;

+

+ if (!check_ids($topic_id_list, TOPICS_TABLE, 'topic_id', array('m_approve')))

+ trigger_error('NOT_AUTHORISED');

+ $redirect = $request->variable('redirect', build_url(array('quickmod')));

+ $success_msg = $topic_url = '';

+ $approve_log = array();

+ $s_hidden_fields = build_hidden_fields(array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'topic_id_list' => $topic_id_list,

+ 'action' => $action,

+ 'redirect' => $redirect,

+ ));

+ $topic_info = get_topic_data($topic_id_list, 'm_approve');

+ if (confirm_box(true))

+ $notify_poster = ($action == 'approve' && isset($_REQUEST['notify_poster'])) ? true : false;

+

+ foreach ($topic_info as $topic_id => $topic_data)

+ phpbb_content_visibility::set_topic_visibility(ITEM_APPROVED, $topic_id, $topic_data['forum_id'], $user->data['user_id'], time(), '');

+ $topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$topic_data['forum_id']}&amp;t={$topic_id}");

+ $approve_log[] = array(

+ 'forum_id' => $topic_data['forum_id'],

+ 'topic_id' => $topic_data['topic_id'],

+ 'topic_title' => $topic_data['topic_title'],

+ );

+ }

+ if (sizeof($topic_info) >= 1)

+ {

+ $success_msg = (sizeof($topic_info) == 1) ? 'TOPIC_' . strtoupper($action) . 'D_SUCCESS' : 'TOPICS_' . strtoupper($action) . 'D_SUCCESS';

+

+ foreach ($approve_log as $log_data)

+ add_log('mod', $log_data['forum_id'], $log_data['topic_id'], 'LOG_TOPIC_' . strtoupper($action) . 'D', $log_data['topic_title']);

+ }

+ // Only send out the mails, when the posts are being approved

+ if ($action == 'approve')

+ {

+ // Handle notifications

+ $phpbb_notifications = $phpbb_container->get('notification_manager');

+ foreach ($topic_info as $topic_id => $topic_data)

+ $phpbb_notifications->delete_notifications('topic_in_queue', $post_data['topic_id']);

+ $phpbb_notifications->add_notifications(array(

+ 'quote',

+ 'topic',

+ ), $post_data);

+ $phpbb_notifications->mark_notifications_read('quote', $post_data['post_id'], $user->data['user_id']);

+ $phpbb_notifications->mark_notifications_read('topic', $post_data['topic_id'], $user->data['user_id']);

+ if ($notify_poster)

+ {

+ $phpbb_notifications->add_notifications('approve_topic', $post_data);

+ }

+ }

+ }

+ $show_notify = false;

+ if ($action == 'approve' && ($config['email_enable'] || $config['jab_enable']))

+ foreach ($topic_info as $topic_data)

+ if ($topic_data['topic_poster'] == ANONYMOUS)

+ {

+ continue;

+ }

+ else

+ {

+ $show_notify = true;

+ break;

+ }

+ $template->assign_vars(array(

+ 'S_NOTIFY_POSTER' => $show_notify,

+ 'S_' . strtoupper($action) => true,

+ ));

+ confirm_box(false, strtoupper($action) . '_TOPIC' . ((sizeof($topic_id_list) == 1) ? '' : 'S'), $s_hidden_fields, 'mcp_approve.html');

+ $redirect = $request->variable('redirect', "index.$phpEx");

+ $redirect = reapply_sid($redirect);

+ if (!$success_msg)

+ redirect($redirect);

+ else

+ {

+ meta_refresh(3, $redirect);

+ // If approving one topic, also give links back to topic...

+ $add_message = '';

+ if (sizeof($topic_info) == 1 && $topic_url)

+ {

+ $add_message = '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], '<a href="' . $topic_url . '">', '</a>');

+ }

+ $message = $user->lang[$success_msg] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], "<a href=\"$redirect\">", '</a>') . $add_message;

+ if ($request->is_ajax())

+ {

+ $json_response = new phpbb_json_response;

+ $json_response->send(array(

+ 'MESSAGE_TITLE' => $user->lang['INFORMATION'],

+ 'MESSAGE_TEXT' => $message,

+ 'REFRESH_DATA' => null,

+ 'visible' => true,

+ ));

+ }

+

+ trigger_error($message);

+ }

+ /**

+ * Disapprove Post

+ *

+ * @param $post_id_list array IDs of the posts to disapprove/delete

+ * @param $id mixed Category of the current active module

+ * @param $mode string Active module

+ * @return null

+ */

+ static public function disapprove_posts($post_id_list, $id, $mode)

+ {

+ global $db, $template, $user, $config, $phpbb_container;

+ global $phpEx, $phpbb_root_path, $request;

+ if (!check_ids($post_id_list, POSTS_TABLE, 'post_id', array('m_approve')))

+ {

+ trigger_error('NOT_AUTHORISED');

+ }

+ $redirect = $request->variable('redirect', build_url(array('t', 'mode', 'quickmod')) . "&amp;mode=$mode");

+ $reason = $request->variable('reason', '', true);

+ $reason_id = $request->variable('reason_id', 0);

+ $success_msg = $additional_msg = '';

+

+ $s_hidden_fields = build_hidden_fields(array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'post_id_list' => $post_id_list,

+ 'action' => 'disapprove',

+ 'redirect' => $redirect)

+ );

+ $notify_poster = $request->is_set('notify_poster');

+ $disapprove_reason = '';

+ if ($reason_id)

+ $sql = 'SELECT reason_title, reason_description

+ FROM ' . REPORTS_REASONS_TABLE . "

+ WHERE reason_id = $reason_id";

+ $result = $db->sql_query($sql);

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ if (!$row || (!$reason && strtolower($row['reason_title']) == 'other'))

+ $additional_msg = $user->lang['NO_REASON_DISAPPROVAL'];

+

+ $request->overwrite('confirm', null, phpbb_request_interface::POST);

+ $request->overwrite('confirm_key', null, phpbb_request_interface::POST);

+ $request->overwrite('confirm_key', null, phpbb_request_interface::REQUEST);

+ else

+ {

+ // If the reason is defined within the language file, we will use the localized version, else just use the database entry...

+ $disapprove_reason = (strtolower($row['reason_title']) != 'other') ? ((isset($user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])])) ? $user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])] : $row['reason_description']) : '';

+ $disapprove_reason .= ($reason) ? "\n\n" . $reason : '';

+ if (isset($user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])]))

+ {

+ $disapprove_reason_lang = strtoupper($row['reason_title']);

+ }

+ }

+ $post_info = get_post_data($post_id_list, 'm_approve');

+ $is_disapproving = false;

+ if ($post_data['post_visibility'] == ITEM_DELETED)

+ continue;

+

+ $is_disapproving = true;

+ if (confirm_box(true))

+ $disapprove_log = $disapprove_log_topics = $disapprove_log_posts = array();

+ $topic_posts_unapproved = $post_disapprove_list = $topic_information = array();

+

+ // Build a list of posts to be disapproved and get the related topics real replies count

+ foreach ($post_info as $post_id => $post_data)

+ $post_disapprove_list[$post_id] = $post_data['topic_id'];

+ if (!isset($topic_posts_unapproved[$post_data['topic_id']]))

+ $topic_information[$post_data['topic_id']] = $post_data;

+ $topic_posts_unapproved[$post_data['topic_id']] = 0;

+ $topic_posts_unapproved[$post_data['topic_id']]++;

+

+ // Now we build the log array

+ foreach ($post_disapprove_list as $post_id => $topic_id)

+ // If the count of disapproved posts for the topic is equal

+ // to the number of unapproved posts in the topic, and there are no different

+ // posts, we disapprove the hole topic

+ if ($topic_information[$topic_id]['topic_posts_approved'] == 0 &&

+ $topic_information[$topic_id]['topic_posts_softdeleted'] == 0 &&

+ $topic_information[$topic_id]['topic_posts_unapproved'] == $topic_posts_unapproved[$topic_id])

+ {

+ // Don't write the log more than once for every topic

+ if (!isset($disapprove_log_topics[$topic_id]))

+ {

+ // Build disapproved topics log

+ $disapprove_log_topics[$topic_id] = array(

+ 'type' => 'topic',

+ 'post_subject' => $post_info[$post_id]['topic_title'],

+ 'forum_id' => $post_info[$post_id]['forum_id'],

+ 'topic_id' => 0, // useless to log a topic id, as it will be deleted

+ 'post_username' => ($post_info[$post_id]['poster_id'] == ANONYMOUS && !empty($post_info[$post_id]['post_username'])) ? $post_info[$post_id]['post_username'] : $post_info[$post_id]['username'],

+ );

+ }

+ }

+ else

+ {

+ // Build disapproved posts log

+ $disapprove_log_posts[] = array(

+ 'type' => 'post',

+ 'post_subject' => $post_info[$post_id]['post_subject'],

+ 'forum_id' => $post_info[$post_id]['forum_id'],

+ 'topic_id' => $post_info[$post_id]['topic_id'],

+ 'post_username' => ($post_info[$post_id]['poster_id'] == ANONYMOUS && !empty($post_info[$post_id]['post_username'])) ? $post_info[$post_id]['post_username'] : $post_info[$post_id]['username'],

+ );

+ }

+ // Get disapproved posts/topics counts separately

+ $num_disapproved_topics = sizeof($disapprove_log_topics);

+ $num_disapproved_posts = sizeof($disapprove_log_posts);

+ // Build the whole log

+ $disapprove_log = array_merge($disapprove_log_topics, $disapprove_log_posts);

+ // Unset unneeded arrays

+ unset($post_data, $disapprove_log_topics, $disapprove_log_posts);

+ // Let's do the job - delete disapproved posts

+ if (sizeof($post_disapprove_list))

+ if (!function_exists('delete_posts'))

+ {

+ include_once($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

+ }

+ // We do not check for permissions here, because the moderator allowed approval/disapproval should be allowed to delete the disapproved posts

+ // Note: function delete_posts triggers related forums/topics sync,

+ // so we don't need to call update_post_information later and to adjust real topic replies or forum topics count manually

+ delete_posts('post_id', array_keys($post_disapprove_list));

+ foreach ($disapprove_log as $log_data)

+ {

+ if ($is_disapproving)

+ {

+ $l_log_message = ($log_data['type'] == 'topic') ? 'LOG_TOPIC_DISAPPROVED' : 'LOG_POST_DISAPPROVED';

+ add_log('mod', $log_data['forum_id'], $log_data['topic_id'], $l_log_message, $log_data['post_subject'], $disapprove_reason);

+ }

+ else

+ {

+ $l_log_message = ($log_data['type'] == 'topic') ? 'LOG_DELETE_TOPIC' : 'LOG_DELETE_POST';

+ add_log('mod', $log_data['forum_id'], $log_data['topic_id'], $l_log_message, $log_data['post_subject'], $log_data['post_username']);

+ }

+ }

+ $phpbb_notifications = $phpbb_container->get('notification_manager');

+ $disapprove_all_posts_in_topic = $topic_information[$topic_id]['topic_posts_approved'] == 0 &&

+ $topic_information[$topic_id]['topic_posts_softdeleted'] == 0 &&

+ $topic_information[$topic_id]['topic_posts_unapproved'] == $topic_posts_unapproved[$topic_id];

+

+ $phpbb_notifications->delete_notifications('post_in_queue', $post_id);

+

+ // Do we disapprove the whole topic? Remove potential notifications

+ if ($disapprove_all_posts_in_topic)

+ {

+ $phpbb_notifications->delete_notifications('topic_in_queue', $post_data['topic_id']);

+ }

+

+ // Notify Poster?

+ if ($notify_poster)

+ if ($post_data['poster_id'] == ANONYMOUS)

+ continue;

+ }

+ $post_data['disapprove_reason'] = '';

+ if (isset($disapprove_reason_lang))

+ {

+ // Okay we need to get the reason from the posters language

+ if (!isset($lang_reasons[$post_data['user_lang']]))

+ // Assign the current users translation as the default, this is not ideal but getting the board default adds another layer of complexity.

+ $lang_reasons[$post_data['user_lang']] = $user->lang['report_reasons']['DESCRIPTION'][$disapprove_reason_lang];

+ // Only load up the language pack if the language is different to the current one

+ if ($post_data['user_lang'] != $user->lang_name && file_exists($phpbb_root_path . '/language/' . $post_data['user_lang'] . '/mcp.' . $phpEx))

+ // Load up the language pack

+ $lang = array();

+ @include($phpbb_root_path . '/language/' . basename($post_data['user_lang']) . '/mcp.' . $phpEx);

+ // If we find the reason in this language pack use it

+ if (isset($lang['report_reasons']['DESCRIPTION'][$disapprove_reason_lang]))

+ {

+ $lang_reasons[$post_data['user_lang']] = $lang['report_reasons']['DESCRIPTION'][$disapprove_reason_lang];

+ }

+

+ unset($lang); // Free memory

+ }

+

+ $post_data['disapprove_reason'] = $lang_reasons[$post_data['user_lang']];

+ $post_data['disapprove_reason'] .= ($reason) ? "\n\n" . $reason : '';

+ if ($disapprove_all_posts_in_topic && $topic_information[$topic_id]['topic_posts_unapproved'] == 1)

+ // If there is only 1 post when disapproving the topic,

+ // we send the user a "disapprove topic" notification...

+ else

+ // ... otherwise there are multiple unapproved posts and

+ // all of them are disapproved as posts.

+ unset($lang_reasons, $post_info, $disapprove_reason, $disapprove_reason_lang);

+

+ if ($num_disapproved_topics)

+ {

+ $success_msg = ($num_disapproved_topics == 1) ? 'TOPIC' : 'TOPICS';

+ }

+ else

+ {

+ $success_msg = ($num_disapproved_posts == 1) ? 'POST' : 'POSTS';

+ }

+

+ if ($is_disapproving)

+ {

+ $success_msg .= '_DISAPPROVED_SUCCESS';

+ }

+ else

+ {

+ $success_msg .= '_DELETED_SUCCESS';

+ }

+ include_once($phpbb_root_path . 'includes/functions_display.' . $phpEx);

+ $show_notify = false;

+ foreach ($post_info as $post_data)

+ {

+ if ($post_data['poster_id'] == ANONYMOUS)

+ {

+ continue;

+ }

+ else

+ {

+ $show_notify = true;

+ break;

+ }

+ }

+ $l_confirm_msg = 'DISAPPROVE_POST';

+ $confirm_template = 'mcp_approve.html';

+ if ($is_disapproving)

+ display_reasons($reason_id);

+ $user->add_lang('posting');

+

+ $l_confirm_msg = 'DELETE_POST_PERMANENTLY';

+ $confirm_template = 'confirm_delete_body.html';

+ $l_confirm_msg .= ((sizeof($post_id_list) == 1) ? '' : 'S');

+ $template->assign_vars(array(

+ 'S_NOTIFY_POSTER' => $show_notify,

+ 'S_APPROVE' => false,

+ 'REASON' => ($is_disapproving) ? $reason : '',

+ 'ADDITIONAL_MSG' => $additional_msg,

+ ));

+ confirm_box(false, $l_confirm_msg, $s_hidden_fields, $confirm_template);

+ }

+ $redirect = $request->variable('redirect', "index.$phpEx");

+ $redirect = reapply_sid($redirect);

+ if (!$success_msg)

+ redirect($redirect);

+ else

+ {

+ $message = $user->lang[$success_msg] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], "<a href=\"$redirect\">", '</a>');

+ if ($request->is_ajax())

+ {

+ $json_response = new phpbb_json_response;

+ $json_response->send(array(

+ 'MESSAGE_TITLE' => $user->lang['INFORMATION'],

+ 'MESSAGE_TEXT' => $message,

+ 'REFRESH_DATA' => null,

+ 'visible' => false,

+ ));

+ }

+

+ meta_refresh(3, $redirect);

+ trigger_error($message);

+ }

+ 'S_POST_UNAPPROVED' => ($post_info['post_visibility'] == POST_UNAPPROVED),

+ $sql = 'SELECT SUM(forum_topics_approved) as sum_forum_topics

+ $forum_info['forum_topics_approved'] = (int) $db->sql_fetchfield('sum_forum_topics');

+ $forum_topics = ($total == -1) ? $forum_info['forum_topics_approved'] : $total;

+ // Restore or pprove posts?

+ if (($action == 'restore' || $action == 'approve') && $auth->acl_get('m_approve', $topic_info['forum_id']))

+ mcp_queue::approve_posts($action, $post_id_list, $id, $mode);

+ $total = phpbb_content_visibility::get_count('topic_posts', $topic_info, $topic_info['forum_id']);

+ p.topic_id = ' . $topic_id . '

+ AND ' . phpbb_content_visibility::get_visibility_sql('post', $topic_info['forum_id'], 'p.') . '

+ $has_unapproved_posts = $has_deleted_posts = false;

+ if ($row['post_visibility'] == ITEM_UNAPPROVED)

+ if ($row['post_visibility'] == ITEM_DELETED)

+ {

+ $has_deleted_posts = true;

+ }

+

+ 'S_POST_UNAPPROVED' => ($row['post_visibility'] == ITEM_UNAPPROVED && $auth->acl_get('m_approve', $topic_info['forum_id'])),

+ 'S_POST_DELETED' => ($row['post_visibility'] == ITEM_DELETED && $auth->acl_get('m_approve', $topic_info['forum_id'])),

+ 'DELETED_IMG' => $user->img('icon_topic_deleted', 'POST_DELETED_RESTORE'),

+ 'S_CAN_RESTORE' => ($has_deleted_posts && $auth->acl_get('m_approve', $topic_info['forum_id'])) ? true : false,

+ $sql = 'SELECT p.post_id, p.forum_id, p.post_visibility

+ $sql = 'SELECT p.post_id, p.forum_id, p.post_visibility

+ if ($row['post_visibility'] == ITEM_UNAPPROVED && !$auth->acl_get('m_approve', $row['forum_id']))

+ 'forum_id' => $to_forum_id,

+ 'topic_title' => $subject,

+ 'icon_id' => $icon_id,

+ 'topic_visibility' => 1

+ * @param string $post_visibility specifies which types of posts the user can view in which forums

+ public function keyword_search($type, $fields, $terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $post_visibility, $topic_id, $author_ary, $author_name, &$id_ary, &$start, $per_page)

+ $post_visibility,

+ $sql_where_options .= ' AND ' . $post_visibility;

+ * @param string $post_visibility specifies which types of posts the user can view in which forums

+ $post_visibility,

+ $m_approve_fid_sql = ' AND ' . $post_visibility;

+ * @param string $post_visibility specifies which types of posts the user can view in which forums

+ public function keyword_search($type, $fields, $terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $post_visibility, $topic_id, $author_ary, $author_name, &$id_ary, &$start, $per_page)

+ $post_visibility,

+ $sql_where[] = $post_visibility;

+ * @param string $post_visibility specifies which types of posts the user can view in which forums

+ public function author_search($type, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $post_visibility, $topic_id, $author_ary, $author_name, &$id_ary, &$start, $per_page)

+ $post_visibility,

+ $post_visibility = ($post_visibility) ? ' AND ' . $post_visibility : '';

+ $post_visibility

+ $post_visibility

+ $post_visibility

+ $post_visibility

+ * @param string $post_visibility specifies which types of posts the user can view in which forums

+ public function keyword_search($type, $fields, $terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $post_visibility, $topic_id, $author_ary, $author_name, &$id_ary, &$start, $per_page)

+ $post_visibility,

+ $sql_where_options .= ' AND ' . $post_visibility;

+ * @param string $post_visibility specifies which types of posts the user can view in which forums

+ public function author_search($type, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $post_visibility, $topic_id, $author_ary, $author_name, &$id_ary, &$start, $per_page)

+ $post_visibility,

+ $m_approve_fid_sql = ' AND ' . $post_visibility;

+ p.post_visibility,

+ array('sql_attr_uint', 'post_visibility'),

+ p.post_visibility,

+ * @param string $post_visibility specifies which types of posts the user can view in which forums

+ public function keyword_search($type, $fields, $terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $post_visibility, $topic_id, $author_ary, $author_name, &$id_ary, &$start, $per_page)

+ // As this is not simply possible at the moment, we limit the result to approved posts.

+ // This will make it impossible for moderators to search unapproved and softdeleted posts,

+ // but at least it will also cause the same for normal users.

+ $this->sphinx->SetFilter('post_visibility', array(ITEM_APPROVED));

+

+ * @param string $post_visibility specifies which types of posts the user can view in which forums

+ public function author_search($type, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $post_visibility, $topic_id, $author_ary, $author_name, &$id_ary, $start, $per_page)

+ return $this->keyword_search($type, $fields, $terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $post_visibility, $topic_id, $author_ary, $author_name, $id_ary, $start, $per_page);

+ $replies = phpbb_content_visibility::get_count('topic_posts', $row, $forum_id) - 1;