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

+ global $db, $config, $phpbb_container;

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

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

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

+

+ $phpbb_notifications->delete_notifications(array(

+ 'topic',

+ 'approve_topic',

+ 'topic_in_queue',

+ ), $topic_ids);

+

+ global $db, $config, $phpbb_root_path, $phpEx, $auth, $user, $phpbb_container;

+ $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)

+ $search_type = $config['search_type'];

+ if (!class_exists($search_type))

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ if ($approved_posts && $post_count_sync)

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

+

+ $phpbb_notifications->delete_notifications(array(

+ 'quote',

+ 'bookmark',

+ 'post',

+ 'approve_post',

+ 'post_in_queue',

+ ), $post_ids);

+

+* - 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');

+ $sql_and .= ' AND topic_type <> ' . POST_GLOBAL;

+* Cache moderators. Called whenever permissions are changed

+* via admin_permissions. Changes of usernames and group names

+* must be carried through for the moderators table.

+* @param \phpbb\db\driver\driver $db Database connection

+* @param \phpbb\cache\driver\driver_interface Cache driver

+* @param \phpbb\auth\auth $auth Authentication object

+* @return null

+function phpbb_cache_moderators($db, $cache, $auth)

+ $sql_ary_deny = array(

+ 'ON' => 'a.auth_role_id = r.role_id',

+ ),

+ );

+ $sql = $db->sql_build_query('SELECT', $sql_ary_deny);

+* Cache moderators. Called whenever permissions are changed

+* via admin_permissions. Changes of usernames and group names

+* must be carried through for the moderators table.

+*

+* @deprecated 3.1

+* @return null

+*/

+function cache_moderators()

+{

+ global $db, $cache, $auth;

+ return phpbb_cache_moderators($db, $cache, $auth);

+}

+

+/**

+*

+* @param string $mode The mode defines which log_type is used and from which log the entry is retrieved

+* @param array &$log The result array with the logs

+* @param mixed &$log_count If $log_count is set to false, we will skip counting all entries in the database.

+* Otherwise an integer with the number of total matching entries is returned.

+* @param int $limit Limit the number of entries that are returned

+* @param int $offset Offset when fetching the log entries, f.e. when paginating

+* @param mixed $forum_id Restrict the log entries to the given forum_id (can also be an array of forum_ids)

+* @param int $topic_id Restrict the log entries to the given topic_id

+* @param int $user_id Restrict the log entries to the given user_id

+* @param int $log_time Only get log entries newer than the given timestamp

+* @param string $sort_by SQL order option, e.g. 'l.log_time DESC'

+* @param string $keywords Will only return log entries that have the keywords in log_operation or log_data

+*

+* @return int Returns the offset of the last valid page, if the specified offset was invalid (too high)

+ global $phpbb_log;

+ $count_logs = ($log_count !== false);

+ $log = $phpbb_log->get_logs($mode, $count_logs, $limit, $offset, $forum_id, $topic_id, $user_id, $limit_days, $sort_by, $keywords);

+ $log_count = $phpbb_log->get_log_count();

+ return $phpbb_log->get_valid_offset();

+* Removes moderators and administrators from foe lists.

+*

+* @param \phpbb\db\driver\driver $db Database connection

+* @param \phpbb\auth\auth $auth Authentication object

+* @param array|bool $group_id If an array, remove all members of this group from foe lists, or false to ignore

+* @param array|bool $user_id If an array, remove this user from foe lists, or false to ignore

+* @return null

+function phpbb_update_foes($db, $auth, $group_id = false, $user_id = false)

+ $sql_ary = array(

+ ACL_GROUPS_TABLE => 'a',

+ 'ON' => 'a.auth_role_id = r.role_id',

+ 'GROUP_BY' => 'a.group_id',

+ );

+ $sql = $db->sql_build_query('SELECT', $sql_ary);

+* Removes moderators and administrators from foe lists.

+*

+* @deprecated 3.1

+* @param array|bool $group_id If an array, remove all members of this group from foe lists, or false to ignore

+* @param array|bool $user_id If an array, remove this user from foe lists, or false to ignore

+* @return null

+*/

+function update_foes($group_id = false, $user_id = false)

+{

+ global $db, $auth;

+ return phpbb_update_foes($db, $auth, $group_id, $user_id);

+}

+

+/**

+ global $user, $phpEx, $phpbb_extension_manager;

+ // add permission language files from extensions

+ $finder = $phpbb_extension_manager->get_finder();

+ $lang_files = $finder

+ ->prefix('permissions_')

+ ->suffix(".$phpEx")

+ ->core_path('language/' . $user->lang_name . '/')

+ ->extension_directory('/language/' . $user->lang_name)

+ ->find();

+ foreach ($lang_files as $lang_file => $ext_name)

+ if ($ext_name === '/')

+ $user->add_lang($lang_file);

+ }

+ else

+ {

+ $user->add_lang_ext($ext_name, $lang_file);