return;

}

// Reset to minimum possible left and right id

$sql = "SELECT MIN(left_id) as min_left_id, MIN(right_id) as min_right_id

FROM $sql_table

$sql_where";

$substract = (int) (min($row['min_left_id'], $row['min_right_id']) - 1);

$sql = "UPDATE $sql_table

SET left_id = left_id - $substract, right_id = right_id - $substract

$sql_where";

}

$sql = "SELECT $sql_id, parent_id, left_id, right_id

FROM $sql_table

$sql_where

ORDER BY left_id ASC, parent_id ASC, $sql_id ASC";

{

if ($item_data['parent_id'])

{

FROM $sql_table

$sql_where " . (($sql_where) ? 'AND' : 'WHERE') . "

$sql_id = {$item_data['parent_id']}";

{

$sql = "UPDATE $sql_table SET parent_id = 0 WHERE $sql_id = " . $item_data[$sql_id];

}

$sql = "UPDATE $sql_table

SET left_id = left_id + 2, right_id = right_id + 2

$sql_where " . (($sql_where) ? 'AND' : 'WHERE') . "

left_id > {$row['right_id']}";

$sql = "UPDATE $sql_table

SET right_id = right_id + 2

$sql_where " . (($sql_where) ? 'AND' : 'WHERE') . "

{$row['left_id']} BETWEEN left_id AND right_id";

$item_data['left_id'] = $row['right_id'];

$item_data['right_id'] = $row['right_id'] + 1;

$sql = "SELECT MAX(right_id) AS right_id

FROM $sql_table

$sql_where";

$item_data['left_id'] = $row['right_id'] + 1;

$item_data['right_id'] = $row['right_id'] + 2;

$sql = "UPDATE $sql_table

SET left_id = {$item_data['left_id']}, right_id = {$item_data['right_id']}

WHERE $sql_id = " . $item_data[$sql_id];

}

}

*/

$sql = 'SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

$right = 0;

$padding_store = array('0' => '');

// This is the result of forums not displayed at index, having list permissions and a parent of a forum with no permissions.

// If this happens, the padding could be "broken"

{

if ($row['left_id'] < $right)

{

$forum_list .= '<option value="' . $row['forum_id'] . '"' . (($disabled) ? ' disabled="disabled" class="disabled-option"' : $selected) . '>' . $padding . $row['forum_name'] . '</option>';

}

}

unset($padding_store);

return $forum_list;

*/

function group_select_options($group_id, $exclude_ids = false, $manage_founder = false)

{

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

$sql_founder = ($manage_founder !== false) ? (($exclude_sql || $sql_and) ? ' AND ' : ' WHERE ') . 'group_founder_manage = ' . (int) $manage_founder : '';

$sql_and

$sql_founder

ORDER BY group_type DESC, group_name ASC";

$s_group_options = '';

{

$selected = ($row['group_id'] == $group_id) ? ' selected="selected"' : '';

$s_group_options .= '<option' . (($row['group_type'] == GROUP_SPECIAL) ? ' class="sep"' : '') . ' value="' . $row['group_id'] . '"' . $selected . '>' . (($row['group_type'] == GROUP_SPECIAL) ? phpbb::$user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

}

return $s_group_options;

}

$sql = 'SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

$forum_rows = array();

$right = $padding = 0;

$padding_store = array('0' => 0);

{

if ($row['left_id'] < $right)

{

$forum_rows[] = $row;

}

unset($padding_store);

}

LEFT JOIN ' . FORUMS_TABLE . " f2 ON ($condition)

WHERE f1.forum_id = $forum_id

ORDER BY f2.left_id " . (($order == 'descending') ? 'ASC' : 'DESC');

{

if (!$include_forum && $row['forum_id'] == $forum_id)

{

$rows[] = $row;

}

return $rows;

}

}

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

AND forum_id = ' . $forum_id;

if ($auto_sync)

{

$sql = 'SELECT DISTINCT forum_id

FROM ' . TOPICS_TABLE . '

{

$forum_ids[] = $row['forum_id'];

}

}

$table_ary = array(TOPICS_TABLE, POSTS_TABLE, LOG_TABLE, DRAFTS_TABLE, TOPICS_TRACK_TABLE);

{

$sql = "UPDATE $table

SET forum_id = $forum_id

}

unset($table_ary);

$sql = 'SELECT DISTINCT topic_id, forum_id

FROM ' . POSTS_TABLE . '

{

$forum_ids[] = $row['forum_id'];

$topic_ids[] = $row['topic_id'];

}

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

if (!$forum_row)

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET forum_id = ' . $forum_row['forum_id'] . ", topic_id = $topic_id

$sql = 'UPDATE ' . ATTACHMENTS_TABLE . "

SET topic_id = $topic_id, in_message = 0

if ($auto_sync)

{

return array('topics' => 0, 'posts' => 0);

}

}

// Making sure that delete_posts does not call delete_topics again...

$sql = 'SELECT topic_id, forum_id, topic_approved, topic_moved_id

FROM ' . TOPICS_TABLE . '

WHERE ' . $where_clause;

{

$forum_ids[] = $row['forum_id'];

$topic_ids[] = $row['topic_id'];

$approved_topics++;

}

}

$return['topics'] = sizeof($topic_ids);

return $return;

}

$table_ary = array(TOPICS_TRACK_TABLE, TOPICS_POSTED_TABLE, POLL_VOTES_TABLE, POLL_OPTIONS_TABLE, TOPICS_WATCH_TABLE, TOPICS_TABLE);

foreach ($table_ary as $table)

{

$sql = "DELETE FROM $table

}

unset($table_ary);

// update the other forums

$sql = 'SELECT topic_id, forum_id

FROM ' . TOPICS_TABLE . '

{

$forum_ids[] = $row['forum_id'];

$moved_topic_ids[] = $row['topic_id'];

}

if (sizeof($moved_topic_ids))

{

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

}

if ($auto_sync)

{

return false;

}

}

$approved_posts = 0;

$sql = 'SELECT post_id, poster_id, post_approved, post_postcount, topic_id, forum_id

FROM ' . POSTS_TABLE . '

WHERE ' . $where_clause;

{

$post_ids[] = $row['post_id'];

$poster_ids[] = $row['poster_id'];

$approved_posts++;

}

}

if (!sizeof($post_ids))

{

return false;

}

$table_ary = array(POSTS_TABLE, REPORTS_TABLE);

foreach ($table_ary as $table)

{

$sql = "DELETE FROM $table

}

unset($table_ary);

SET user_posts = 0

WHERE user_id = ' . $poster_id . '

AND user_posts < ' . $substract;

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_posts = user_posts - ' . $substract . '

WHERE user_id = ' . $poster_id . '

AND user_posts >= ' . $substract;

}

}

{

$sql = 'SELECT topic_id

FROM ' . POSTS_TABLE . '

GROUP BY topic_id';

{

$remove_topics[] = $row['topic_id'];

}

// Actually, those not within remove_topics should be removed. ;)

$remove_topics = array_diff($topic_ids, $remove_topics);

delete_attachments('post', $post_ids, false);

// Resync topics_posted table

if ($posted_sync)

// Collect post and topic ids for later use if we need to touch remaining entries (if resync is enabled)

$sql = 'SELECT post_msg_id, topic_id, in_message, physical_filename, thumbnail, filesize, is_orphan

FROM ' . ATTACHMENTS_TABLE . '

{

// We only need to store post/message/topic ids if resync is enabled and the file is not orphaned

if ($resync && !$row['is_orphan'])

$physical[] = array('filename' => $row['physical_filename'], 'thumbnail' => $row['thumbnail'], 'filesize' => $row['filesize'], 'is_orphan' => $row['is_orphan']);

}

// Delete attachments

$sql = 'DELETE FROM ' . ATTACHMENTS_TABLE . '

if (!$num_deleted)

{

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_attachment = 0

}

// Update message table if messages are affected

{

$sql = 'UPDATE ' . PRIVMSGS_TABLE . '

SET message_attachment = 0

}

// Now update the topics. This is a bit trickier, because there could be posts still having attachments within the topic

// Just check which topics are still having an assigned attachment not orphaned by querying the attachments table (much less entries expected)

$sql = 'SELECT topic_id

FROM ' . ATTACHMENTS_TABLE . '

AND is_orphan = 0';

$remaining_ids = array();

{

$remaining_ids[] = $row['topic_id'];

}

// Now only unset those ids remaining

$topic_ids = array_diff($topic_ids, $remaining_ids);

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_attachment = 0

}

}

*/

function delete_topic_shadows($max_age, $forum_id = '', $auto_sync = true)

{

{

$sql = 'DELETE FROM ' . TOPICS_TABLE . ' t

USING ' . TOPICS_TABLE . ' t2

WHERE t.topic_moved_id = t2.topic_id

AND t.topic_time < ' . (time() - $max_age)

. $where;

}

else

{

WHERE t.topic_moved_id = t2.topic_id

AND t.topic_time < ' . (time() - $max_age)

. $where;

$topic_ids = array();

{

$topic_ids[] = $row['topic_id'];

}

if (sizeof($topic_ids))

{

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

}

}

// First of all, let us remove any posted information for these topics

$sql = 'DELETE FROM ' . TOPICS_POSTED_TABLE . '

// Now, let us collect the user/topic combos for rebuilding the information

$sql = 'SELECT poster_id, topic_id

FROM ' . POSTS_TABLE . '

AND poster_id <> ' . ANONYMOUS . '

GROUP BY poster_id, topic_id';

$posted = array();

{

// Add as key to make them unique (grouping by) and circumvent empty keys on array_unique

$posted[$row['poster_id']][] = $row['topic_id'];

}

// Now add the information...

$sql_ary = array();

}

unset($posted);

}

/**

// Because of copying topics or modifications a physical filename could be assigned more than once. If so, do not remove the file itself.

$sql = 'SELECT COUNT(attach_id) AS num_entries

FROM ' . ATTACHMENTS_TABLE . "

// Do not remove file if at least one additional entry with the same name exist.

if (($entry_removed && $num_entries > 0) || (!$entry_removed && $num_entries > 1))

// Limit the topics/forums we are syncing, use specific topic/forum IDs.

// $where_type contains the field for the where clause (forum_id, topic_id)

$where_sql_and = $where_sql . "\n\tAND";

}

}

}

// $where_type contains the field for the where clause (forum_id, topic_id)

$where_sql_and = $where_sql . "\n\tAND";

}

switch ($mode)

{

case 'topic_moved':

{

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

USING ' . TOPICS_TABLE . ' t1, ' . TOPICS_TABLE . " t2

WHERE t1.topic_moved_id = t2.topic_id

AND t1.forum_id = t2.forum_id";

}

else

{

FROM ' .TOPICS_TABLE . ' t1, ' . TOPICS_TABLE . " t2

WHERE t1.topic_moved_id = t2.topic_id

AND t1.forum_id = t2.forum_id";

$topic_id_ary = array();

{

$topic_id_ary[] = $row['topic_id'];

}

if (!sizeof($topic_id_ary))

{

}

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

}

break;

case 'topic_approved':

{

$sql = 'UPDATE ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . " p

SET t.topic_approved = p.post_approved

$where_sql_and t.topic_first_post_id = p.post_id";

}

else

{

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

$where_sql_and p.post_id = t.topic_first_post_id

AND p.post_approved <> t.topic_approved";

$topic_ids = array();

{

$topic_ids[] = $row['topic_id'];

}

if (!sizeof($topic_ids))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_approved = 1 - topic_approved

}

break;

FROM ' . POSTS_TABLE . " p

$where_sql

GROUP BY p.post_id, p.post_reported";

{

$post_ids[$row['post_id']] = $row['post_id'];

if ($row['post_reported'])

$post_reported[$row['post_id']] = 1;

}

}

$sql = 'SELECT DISTINCT(post_id)

FROM ' . REPORTS_TABLE . '

AND report_closed = 0';

$post_ids = array();

{

if (!isset($post_reported[$row['post_id']]))

{

unset($post_reported[$row['post_id']]);

}

}

// $post_reported should be empty by now, if it's not it contains

// posts that are falsely flagged as reported

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_reported = 1 - post_reported

}

break;

$sql = 'SELECT DISTINCT(t.topic_id)

FROM ' . POSTS_TABLE . " t

$where_sql_and t.post_reported = 1";

{

$topic_reported[$row['topic_id']] = 1;

}

$sql = 'SELECT t.topic_id, t.topic_reported

FROM ' . TOPICS_TABLE . " t

$where_sql";

{

if ($row['topic_reported'] ^ isset($topic_reported[$row['topic_id']]))

{

$topic_ids[] = $row['topic_id'];

}

}

if (sizeof($topic_ids))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_reported = 1 - topic_reported

}

break;

FROM ' . POSTS_TABLE . " p

$where_sql

GROUP BY p.post_id, p.post_attachment";

{

$post_ids[$row['post_id']] = $row['post_id'];

if ($row['post_attachment'])

$post_attachment[$row['post_id']] = 1;

}

}

$sql = 'SELECT DISTINCT(post_msg_id)

FROM ' . ATTACHMENTS_TABLE . '

AND in_message = 0';

$post_ids = array();

{

if (!isset($post_attachment[$row['post_msg_id']]))

{

unset($post_attachment[$row['post_msg_id']]);

}

}

// $post_attachment should be empty by now, if it's not it contains

// posts that are falsely flagged as having attachments

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_attachment = 1 - post_attachment

}

break;

$sql = 'SELECT DISTINCT(t.topic_id)

FROM ' . POSTS_TABLE . " t

$where_sql_and t.post_attachment = 1";

{

$topic_attachment[$row['topic_id']] = 1;

}

$sql = 'SELECT t.topic_id, t.topic_attachment

FROM ' . TOPICS_TABLE . " t

$where_sql";

{

if ($row['topic_attachment'] ^ isset($topic_attachment[$row['topic_id']]))

{

$topic_ids[] = $row['topic_id'];

}

}

if (sizeof($topic_ids))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_attachment = 1 - topic_attachment

}

break;

$sql = 'SELECT f.*

FROM ' . FORUMS_TABLE . " f

$where_sql";

$forum_data = $forum_ids = $post_ids = $last_post_id = $post_info = array();

{

if ($row['forum_type'] == FORUM_LINK)

{

$forum_data[$forum_id]['last_poster_name'] = '';

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

}

if (!sizeof($forum_ids))

{

{

$sql = 'SELECT forum_id, topic_approved, COUNT(topic_id) AS forum_topics

FROM ' . TOPICS_TABLE . '

GROUP BY forum_id, topic_approved';

{

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

$forum_data[$forum_id]['topics_real'] += $row['forum_topics'];

$forum_data[$forum_id]['topics'] = $row['forum_topics'];

}

}

}

// 3: Get post count for each forum (optional)

{

$sql = 'SELECT SUM(t.topic_replies + 1) AS forum_posts

FROM ' . TOPICS_TABLE . ' t

AND t.topic_approved = 1

AND t.topic_status <> ' . ITEM_MOVED;

}

{

$sql = 'SELECT t.forum_id, SUM(t.topic_replies + 1) AS forum_posts

FROM ' . TOPICS_TABLE . ' t

AND t.topic_approved = 1

AND t.topic_status <> ' . ITEM_MOVED . '

GROUP BY t.forum_id';

}

{

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

$forum_data[$forum_id]['posts'] = (int) $row['forum_posts'];

}

}

// 4: Get last_post_id for each forum

{

$sql = 'SELECT MAX(t.topic_last_post_id) as last_post_id

FROM ' . TOPICS_TABLE . ' t

AND t.topic_approved = 1';

}

else

{

$sql = 'SELECT t.forum_id, MAX(t.topic_last_post_id) as last_post_id

FROM ' . TOPICS_TABLE . ' t

AND t.topic_approved = 1

GROUP BY t.forum_id';

}

{

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

$post_ids[] = $row['last_post_id'];

}

// 5: Retrieve last_post infos

if (sizeof($post_ids))

{

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

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

AND p.poster_id = u.user_id';

{

$post_info[$row['post_id']] = $row;

}

foreach ($forum_data as $forum_id => $data)

{

if (sizeof($sql_ary))

{

$sql = 'UPDATE ' . FORUMS_TABLE . '

WHERE forum_id = ' . $forum_id;

}

}

break;

$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

FROM ' . TOPICS_TABLE . " t

$where_sql";

{

if ($row['topic_moved_id'])

{

$topic_data[$topic_id]['attachment'] = 0;

}

}

// Use "t" as table alias because of the $where_sql clause

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

FROM ' . POSTS_TABLE . " t

$where_sql

GROUP BY t.topic_id, t.post_approved";

{

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

}

}

}

foreach ($topic_data as $topic_id => $row)

{

$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

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

AND u.user_id = p.poster_id';

$post_ids = array();

{

$topic_id = intval($row['topic_id']);

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

}

}

// Make sure shadow topics do link to existing topics

if (sizeof($moved_topics))

$sql = 'SELECT t1.topic_id, t1.topic_moved_id

FROM ' . TOPICS_TABLE . ' t1

LEFT JOIN ' . TOPICS_TABLE . ' t2 ON (t2.topic_id = t1.topic_moved_id)

AND t2.topic_id IS NULL';

{

$delete_topics[] = $row['topic_id'];

}

if (sizeof($delete_topics))

{

// Make sure shadow topics having no last post data being updated (this only rarely happens...)

$sql = 'SELECT topic_id, topic_moved_id, topic_last_post_id, topic_first_post_id

FROM ' . TOPICS_TABLE . '

AND topic_last_post_time = 0';

$shadow_topic_data = $post_ids = array();

{

$shadow_topic_data[$row['topic_moved_id']] = $row;

$post_ids[] = $row['topic_last_post_id'];

$post_ids[] = $row['topic_first_post_id'];

}

$sync_shadow_topics = array();

if (sizeof($post_ids))

{

$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

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

AND u.user_id = p.poster_id';

$post_ids = array();

{

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

}

}

}

$shadow_topic_data = array();

foreach ($sync_shadow_topics as $sync_topic_id => $sql_ary)

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

WHERE topic_id = ' . $sync_topic_id;

}

}

}

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_approved = 1 - topic_approved

}

unset($approved_unapproved_ids);

$where_sql_and p.topic_id = t.topic_id

AND p.post_reported = 1

GROUP BY t.topic_id, p.post_id";

$fieldnames[] = 'reported';

{

$topic_data[intval($row['topic_id'])]['reported'] = 1;

}

// This routine assumes that post_attachment values are correct

// if they are not, use sync('post_attachment') first

$where_sql_and p.topic_id = t.topic_id

AND p.post_attachment = 1

GROUP BY t.topic_id, p.post_id";

$fieldnames[] = 'attachment';

{

$topic_data[intval($row['topic_id'])]['attachment'] = 1;

}

}

foreach ($topic_data as $topic_id => $row)

if (sizeof($sql_ary))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

$resync_forums[$row['forum_id']] = $row['forum_id'];

}

$sql = 'SELECT topic_id

FROM ' . TOPICS_TABLE . '

AND poll_start = 0

$sql_and";

$topic_list = array();

{

$topic_list[] = $row['topic_id'];

}

if ($prune_flags & FORUM_FLAG_PRUNE_POLL)

{

$sql = 'SELECT topic_id

FROM ' . TOPICS_TABLE . '

AND poll_start > 0

AND poll_last_vote < $prune_date

$sql_and";

{

$topic_list[] = $row['topic_id'];

}

$topic_list = array_unique($topic_list);

}

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

if ($row)

{

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET prune_next = $next_prune

WHERE forum_id = $forum_id";

add_log('admin', 'LOG_AUTO_PRUNE', $row['forum_name']);

}

phpbb::$acm->destroy_sql(MODERATOR_CACHE_TABLE);

// Clear table

{

}

else

{

}

// We add moderators who have forum moderator permissions without an explicit ACL_NEVER setting

$ug_id_ary = array_keys($hold_ary);

// Remove users who have group memberships with DENY moderator permissions

'SELECT' => 'a.forum_id, ug.user_id',

'FROM' => array(

AND ((a.auth_setting = ' . phpbb::ACL_NEVER . ' AND r.auth_setting IS NULL)

OR r.auth_setting = ' . phpbb::ACL_NEVER . ')

AND a.group_id = ug.group_id

AND ug.user_pending = 0

));

{

if (isset($hold_ary[$row['user_id']][$row['forum_id']]))

{

unset($hold_ary[$row['user_id']][$row['forum_id']]);

}

}

if (sizeof($hold_ary))

{

// Get usernames...

$sql = 'SELECT user_id, username

FROM ' . USERS_TABLE . '

$usernames_ary = array();

{

$usernames_ary[$row['user_id']] = $row['username'];

}

// Make sure not hidden or special groups are involved...

$sql = 'SELECT group_name, group_id, group_type

FROM ' . GROUPS_TABLE . '

$groupnames_ary = array();

{

if ($row['group_type'] == GROUP_HIDDEN || $row['group_type'] == GROUP_SPECIAL)

{

$groupnames_ary[$row['group_id']] = $row['group_name'];

}

foreach ($hold_ary as $group_id => $forum_id_ary)

{

}

}

}

/**

if (is_array($user_id) && sizeof($user_id))

{

$sql = 'DELETE FROM ' . ZEBRA_TABLE . '

AND foe = 1';

return;

}

if (is_array($group_id) && sizeof($group_id))

{

// Grab group settings...

'SELECT' => 'a.group_id',

'FROM' => array(

),

'WHERE' => '(ao.auth_option_id = a.auth_option_id OR ao.auth_option_id = r.auth_option_id)

AND ao.auth_option IN ('a_', 'm_')",

'GROUP_BY' => 'a.group_id'

));

$groups = array();

{

$groups[] = (int) $row['group_id'];

}

if (!sizeof($groups))

{

return;

}

{

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

USING ' . USER_GROUP_TABLE . ' ug

WHERE z.zebra_id = ug.user_id

AND z.foe = 1

}

else

{

$sql = 'SELECT user_id

FROM ' . USER_GROUP_TABLE . '

$users = array();

{

$users[] = (int) $row['user_id'];

}

if (sizeof($users))

{

$sql = 'DELETE FROM ' . ZEBRA_TABLE . '

AND foe = 1';

}

}

if (sizeof($perms))

{

$sql = 'DELETE FROM ' . ZEBRA_TABLE . '

AND foe = 1';

}

unset($perms);

}

WHERE user_warnings > 0

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

ORDER BY $sort_by";

$sql = 'SELECT count(user_id) AS user_count

FROM ' . USERS_TABLE . '

WHERE user_warnings > 0

' . (($limit_days) ? "AND user_last_warning >= $limit_days" : '');

return;

}

$sql = 'SELECT * FROM ' . WARNINGS_TABLE . "

WHERE warning_time < $expire_date";

{

$warning_list[] = $row['warning_id'];

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

}

if (sizeof($warning_list))

{

$sql = 'DELETE FROM ' . WARNINGS_TABLE . '

foreach ($user_list as $user_id => $value)

{

$sql = 'UPDATE ' . USERS_TABLE . " SET user_warnings = user_warnings - $value

WHERE user_id = $user_id";

}

}

set_config('warnings_last_gc', time(), true);

// Sometimes, it can happen permission tables having forums listed which do not exist

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE;

$forum_ids = array(0);

{

$forum_ids[] = $row['forum_id'];

}

// Delete those rows from the acl tables not having listed the forums above

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . '

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

}