+ $sql_and = (!$config['coppa_enable']) ? (($exclude_sql) ? ' AND ' : ' WHERE ') . "group_name <> 'REGISTERED_COPPA'" : '';

+ $forum_rows = array();

+ else if ($fname[0] != '.' && is_dir("$rootdir$dir$fname"))

+ $db->sql_freeresult($result);

+ include_once("{$phpbb_root_path}includes/search/$search_type.$phpEx");

+ switch ($db->sql_layer)

+ $db->sql_multi_insert(TOPICS_POSTED_TABLE, $sql_ary);

+ if ($mode == 'forum' || $mode == 'topic' || $mode == 'topic_approved')

+ $where_sql = 'WHERE (' . $mode[0] . ".$where_ids)";

+ $where_sql = 'WHERE ' . $db->sql_in_set($mode[0] . '.' . $where_type, $where_ids);

+ $where_sql = 'WHERE ' . $db->sql_in_set($mode[0] . '.' . $where_type, $where_ids);

+ switch ($db->sql_layer)

+ switch ($db->sql_layer)

+

+ $db->sql_freeresult($result);

+ $forum_data[$forum_id]['last_post_subject'] = '';

+ $forum_data[$forum_id]['last_poster_colour'] = '';

+ $forum_ids = array_values($forum_ids);

+

+ if (sizeof($forum_ids) == 1)

+ {

+ $sql = 'SELECT COUNT(post_id) AS forum_posts, MAX(post_id) AS last_post_id

+ FROM ' . POSTS_TABLE . '

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

+ AND post_approved = 1';

+ }

+ else

+ {

+ $sql = 'SELECT forum_id, COUNT(post_id) AS forum_posts, MAX(post_id) AS last_post_id

+ FROM ' . POSTS_TABLE . '

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

+ AND post_approved = 1

+ GROUP BY forum_id';

+ }

+

+ $forum_id = (sizeof($forum_ids) == 1) ? (int) $forum_ids[0] : (int) $row['forum_id'];

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

+ $forum_data[$forum_id]['last_post_subject'] = $post_info[$data['last_post_id']]['post_subject'];

+ $forum_data[$forum_id]['last_poster_colour'] = $post_info[$data['last_post_id']]['user_colour'];

+ $forum_data[$forum_id]['last_post_subject'] = '';

+ $forum_data[$forum_id]['last_poster_colour'] = '';

+ $fieldnames = array('posts', 'topics', 'topics_real', 'last_post_id', 'last_post_subject', 'last_post_time', 'last_poster_id', 'last_poster_name', 'last_poster_colour');

+ if (preg_match('#(name|colour|subject)$#', $fieldname))

+ $sql = 'SELECT t.topic_id, t.forum_id, t.topic_moved_id, t.topic_approved, ' . (($sync_extra) ? 't.topic_attachment, t.topic_reported, ' : '') . 't.topic_poster, t.topic_time, t.topic_replies, t.topic_replies_real, 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]['replies'] = 0;

+ $where_sql

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

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

+ $topic_data[$topic_id]['first_poster_colour'] = $row['user_colour'];

+ $topic_data[$topic_id]['last_post_subject'] = $row['post_subject'];

+ $topic_data[$topic_id]['last_poster_colour'] = $row['user_colour'];

+ $fieldnames = array('time', 'replies', 'replies_real', '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');

+ if (isset($row[$fieldname]) && isset($row['topic_' . $fieldname]) && $row['topic_' . $fieldname] != $row[$fieldname])

+ sync('forum', 'forum_id', array_values($resync_forums), true);

+ if (!($prune_flags & FORUM_FLAG_PRUNE_ANNOUNCE))

+ if (!($prune_flags & FORUM_FLAG_PRUNE_STICKY))

+ if ($prune_flags & FORUM_FLAG_PRUNE_POLL)

+ $db->sql_query((($db->sql_layer != 'sqlite') ? 'TRUNCATE TABLE ' : 'DELETE FROM ') . MODERATOR_CACHE_TABLE);

+ (($db->sql_layer == 'mssql' || $db->sql_layer == 'mssql_odbc') ? " ESCAPE '\\'" : ''),

+ // Do not continue if user does not exist

+ if (!isset($usernames_ary[$user_id]))

+ {

+ continue;

+ }

+

+ // If there is no group, we do not assign it...

+ if (!isset($groupnames_ary[$group_id]))

+ {

+ continue;

+ }

+

+ $db->sql_multi_insert(MODERATOR_CACHE_TABLE, $sql_ary);

+* Update foes - remove moderators and administrators from foe lists...

+*/

+function update_foes()

+{

+ global $db, $auth;

+

+ $perms = array();

+ foreach ($auth->acl_get_list(false, array('a_', 'm_'), false) as $forum_id => $forum_ary)

+ {

+ foreach ($forum_ary as $auth_option => $user_ary)

+ {

+ $perms = array_merge($perms, $user_ary);

+ }

+ }

+

+ if (sizeof($perms))

+ {

+ $sql = 'DELETE FROM ' . ZEBRA_TABLE . '

+ WHERE ' . $db->sql_in_set('zebra_id', array_unique($perms)) . '

+ AND foe = 1';

+ $db->sql_query($sql);

+ }

+ unset($perms);

+}

+

+/**

+* Lists inactive users

+*/

+function view_inactive_users(&$users, &$user_count, $limit = 0, $offset = 0, $limit_days = 0, $sort_by = 'user_inactive_time DESC')

+{

+ global $db, $user;

+

+ $sql = 'SELECT user_id, username, user_regdate, user_lastvisit, user_inactive_time, user_inactive_reason

+ FROM ' . USERS_TABLE . '

+ WHERE user_type = ' . USER_INACTIVE .

+ (($limit_days) ? " AND user_inactive_time >= $limit_days" : '') . "

+ ORDER BY $sort_by";

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

+

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

+ {

+ $row['inactive_reason'] = $user->lang['INACTIVE_REASON_UNKNOWN'];

+ switch ($row['user_inactive_reason'])

+ {

+ case INACTIVE_REGISTER:

+ $row['inactive_reason'] = $user->lang['INACTIVE_REASON_REGISTER'];

+ break;

+

+ case INACTIVE_PROFILE:

+ $row['inactive_reason'] = $user->lang['INACTIVE_REASON_PROFILE'];

+ break;

+

+ case INACTIVE_MANUAL:

+ $row['inactive_reason'] = $user->lang['INACTIVE_REASON_MANUAL'];

+ break;

+

+ case INACTIVE_REMIND:

+ $row['inactive_reason'] = $user->lang['INACTIVE_REASON_REMIND'];

+ break;

+ }

+

+ $users[] = $row;

+ }

+

+ $sql = 'SELECT COUNT(user_id) AS user_count

+ FROM ' . USERS_TABLE . '

+ WHERE user_type = ' . USER_INACTIVE .

+ (($limit_days) ? " AND user_inactive_time >= $limit_days" : '');

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

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

+ $db->sql_freeresult($result);

+

+ return;

+}

+

+/**

+ switch ($db->sql_layer)

+ if (strpos($row['Name'], $table_prefix) !== false)

+ $errstr = $user->lang['FILE_NOT_FOUND'] . ': ' . $filename;

+ $user_list[$row['user_id']] = isset($user_list[$row['user_id']]) ? $user_list[$row['user_id']]++ : 1;

+ set_config('database_last_gc', time(), true);

+}

+

+/**

+* Add permission language - this will make sure custom files will be included

+*/

+function add_permission_language()

+{

+ global $user, $phpEx;

+ // First of all, our own file.

+ $user->add_lang('acp/permissions_phpbb');

+ $files_to_add = array();

+

+ // Now search in acp and mods folder for permissions_ files.

+ foreach (array('acp/', 'mods/') as $path)

+ {

+ $dh = opendir($user->lang_path . $path);

+

+ if ($dh !== false)

+ {

+ while (($file = readdir($dh)) !== false)

+ {

+ if (strpos($file, 'permissions_') === 0 && strpos($file, 'permissions_phpbb') === false && substr($file, -(strlen($phpEx) + 1)) === '.' . $phpEx)

+ {

+ $files_to_add[] = $path . substr($file, 0, -(strlen($phpEx) + 1));

+ }

+ }

+ closedir($dh);

+ }

+ }

+

+ if (!sizeof($files_to_add))

+ {

+ return false;

+ }

+

+ $user->add_lang($files_to_add);

+ return true;