$sql = 'SELECT topic_id, forum_id, topic_title

FROM ' . TOPICS_TABLE . '

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

// Log this action

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE . '

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

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

$sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.username, t.topic_id, t.topic_title, t.topic_first_post_id, p.forum_id

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

AND t.topic_id = p.topic_id

AND p.poster_id = u.user_id

ORDER BY p.post_time DESC';

$sql_in[] = $mark;

}

unset($sql_in);

}

if (confirm_box(true))

{

$sql = "UPDATE $table

$db->sql_query($sql);

$data = ($action == 'lock' || $action == 'unlock') ? get_topic_data($ids) : get_post_data($ids);

{

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_type = $new_topic_type

AND forum_id <> 0';

$db->sql_query($sql);

{

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_type = $new_topic_type, forum_id = $forum_id

AND forum_id = 0';

$db->sql_query($sql);

// Update forum_ids for all posts

$sql = 'UPDATE ' . POSTS_TABLE . "

SET forum_id = $forum_id

AND forum_id = 0';

$db->sql_query($sql);

// Get away with those topics already being a global announcement by re-calculating $topic_ids

$sql = 'SELECT topic_id

FROM ' . TOPICS_TABLE . '

AND forum_id <> 0';

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

{

// Delete topic shadows for global announcements

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

$db->sql_query($sql);

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_type = $new_topic_type, forum_id = 0

$db->sql_query($sql);

// Update forum_ids for all posts

$sql = 'UPDATE ' . POSTS_TABLE . '

SET forum_id = 0

$db->sql_query($sql);

sync('forum', 'forum_id', $forum_id);

$sql = 'SELECT DISTINCT topic_id

FROM ' . POSTS_TABLE . '

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

$topic_id_list = array();

$sql = 'SELECT COUNT(topic_id) AS topics_left

FROM ' . TOPICS_TABLE . '

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

$deleted_topics = ($row = $db->sql_fetchrow($result)) ? ($affected_topics - $row['topics_left']) : $affected_topics;

{

$sql_in[] = $mark;

}

unset($sql_in);

}

if (sizeof($post_ids))

{

$sql = 'SELECT t.topic_id, t.topic_title, t.forum_id, p.post_id, p.post_subject, p.post_username, p.poster_id, p.post_time, u.username

AND t.topic_id = p.topic_id

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

$post_data = $rowset = array();

// Select the names for the forum_ids

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE . '

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

$forum_names = array();

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_approved = 1

$db->sql_query($sql);

}

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_approved = 1

$db->sql_query($sql);

}

$forum_id = $topic_info['forum_id'];

}

if (!$forum_id)

{

foreach ($forum_list_reports as $row)

{

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

$global_id = $forum_list[0];

{

trigger_error('NOT_MODERATOR');

}

$sql = 'SELECT SUM(forum_topics) as sum_forum_topics

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

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

$db->sql_freeresult($result);

}

$forum_info = $forum_info[$forum_id];

$global_id = $forum_id;

}

$forum_data = array();

$forum_options = '<option value="0"' . (($forum_id == 0) ? ' selected="selected"' : '') . '>' . $user->lang['ALL_FORUMS'] . '</option>';

}

$sql = 'SELECT r.report_id

$report_state

AND r.post_id = p.post_id

" . (($sort_order_sql[0] == 'u') ? 'AND u.user_id = p.poster_id' : '') . '

if (sizeof($report_ids))

{

$sql = 'SELECT t.forum_id, t.topic_id, t.topic_title, p.post_id, p.post_subject, p.post_username, p.poster_id, p.post_time, u.username, r.user_id as reporter_id, ru.username as reporter_name, r.report_time, r.report_id

AND t.topic_id = p.topic_id

AND r.post_id = p.post_id

AND u.user_id = p.poster_id

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

$report_data = $rowset = array();

$sql = 'SELECT r.post_id, r.report_closed, r.user_id, r.user_notify, u.username, u.user_email, u.user_jabber, u.user_lang, u.user_notify_type

FROM ' . REPORTS_TABLE . ' r, ' . USERS_TABLE . ' u

' . (($action == 'close') ? 'AND r.report_closed = 0' : '') . '

AND r.user_id = u.user_id';

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

// Get a list of topics that still contain reported posts

$sql = 'SELECT DISTINCT topic_id

FROM ' . POSTS_TABLE . '

AND post_reported = 1

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

$keep_report_topics = array();

{

$sql = 'UPDATE ' . REPORTS_TABLE . '

SET report_closed = 1

}

else

{

$sql = 'DELETE FROM ' . REPORTS_TABLE . '

}

$db->sql_query($sql);

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_reported = 0

$db->sql_query($sql);

if (sizeof($close_report_topics))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_reported = 0

$db->sql_query($sql);

}