$sql = 'SELECT username, user_email, user_ip

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

switch ($mode)

{

case 'user':

break;

case 'ip':

break;

case 'email':

break;

}

}

else if ($post_id)

{

" . ((phpbb::$acl->acl_get('m_approve', $forum_id)) ? '' : 'AND t.topic_approved = 1') . "

$limit_time_sql

ORDER BY t.topic_type DESC, $sort_order_sql";

$topic_list = $topic_tracking_info = array();

{

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

}

$sql = "SELECT t.*$read_tracking_select

FROM " . TOPICS_TABLE . " t $read_tracking_join

{

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

}

// If there is more than one page, but we have no topic list, then the start parameter is... erm... out of sync

if (!sizeof($topic_list) && $forum_topics && $start > 0)

$sql = 'SELECT topic_id, forum_id, topic_title

FROM ' . TOPICS_TABLE . '

// Log this action

{

add_log('mod', $row['forum_id'], $row['topic_id'], 'LOG_TOPIC_RESYNC', $row['topic_title']);

}

$msg = (sizeof($topic_ids) == 1) ? phpbb::$user->lang['TOPIC_RESYNC_SUCCESS'] : phpbb::$user->lang['TOPICS_RESYNC_SUCCESS'];

{

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

$post_id_list = array();

{

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

}

}

if (!sizeof($post_id_list))

// If the topic no longer exist, we will update the topic watch table.

// To not let it error out on users watching both topics, we just return on an error...

// Link to the new topic

$return_link .= (($return_link) ? '<br /><br />' : '') . sprintf(phpbb::$user->lang['RETURN_NEW_TOPIC'], '<a href="' . append_sid('viewtopic', 'f=' . $to_forum_id . '&amp;t=' . $to_topic_id) . '">', '</a>');

FROM ' . POSTS_TABLE . '

WHERE forum_id IN (0, ' . implode(', ', $forum_list) . ')

AND post_approved = 0';

if ($total)

{

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE . '

{

$forum_names[$row['forum_id']] = $row['forum_name'];

}

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

WHERE forum_id IN (0, ' . implode(', ', $forum_list) . ')

AND post_approved = 0

ORDER BY post_time DESC';

{

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

}

if (empty($post_list))

{

{

$sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.username, u.username_clean, u.user_colour, 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';

{

$global_topic = ($row['forum_id']) ? false : true;

if ($global_topic)

'POST_TIME' => phpbb::$user->format_date($row['post_time']))

);

}

}

$template->assign_vars(array(

WHERE r.post_id = p.post_id

AND r.report_closed = 0

AND p.forum_id IN (0, ' . implode(', ', $forum_list) . ')';

if ($total)

{

$global_id = $forum_list[0];

'SELECT' => 'r.report_time, p.post_id, p.post_subject, p.post_time, u.username, u.username_clean, u.user_colour, u.user_id, u2.username as author_name, u2.username_clean as author_name_clean, u2.user_colour as author_colour, u2.user_id as author_id, t.topic_id, t.topic_title, f.forum_id, f.forum_name',

'FROM' => array(

'ORDER_BY' => 'p.post_time DESC'

));

{

$global_topic = ($row['forum_id']) ? false : true;

if ($global_topic)

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

if (!in_array($forum_id, $forum_list))

{

{

$sql = 'DELETE FROM ' . LOG_TABLE . '

WHERE log_type = ' . LOG_MOD . '

add_log('admin', 'LOG_CLEAR_MOD');

}

{

$sql = 'DELETE FROM ' . LOG_TABLE . '

WHERE log_type = ' . LOG_MOD . '

if ($mode == 'topic_logs')

{

$sql .= ' AND topic_id = ' . $topic_id;

}

add_log('admin', 'LOG_CLEAR_MOD');

}

{

$sql = "UPDATE $table

SET $set_id = " . (($action == 'lock' || $action == 'lock_post') ? ITEM_LOCKED : ITEM_UNLOCKED) . '

$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';

// Reset forum id if a global topic is within the array

$to_forum_id = request_var('to_forum_id', 0);

{

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_type = $new_topic_type, forum_id = $to_forum_id

AND forum_id = 0';

// Update forum_ids for all posts

$sql = 'UPDATE ' . POSTS_TABLE . "

SET forum_id = $to_forum_id

AND forum_id = 0';

// Do a little forum sync stuff

$sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts, COUNT(t.topic_approved) as topics_authed

FROM ' . TOPICS_TABLE . ' t

$sync_sql = array();

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET ' . implode(', ', $array) . '

WHERE forum_id = ' . $forum_id_key;

}

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

// 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';

$topic_ids = array();

{

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

}

if (sizeof($topic_ids))

{

// Delete topic shadows for global announcements

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_type = $new_topic_type, forum_id = 0

// Update forum_ids for all posts

$sql = 'UPDATE ' . POSTS_TABLE . '

SET forum_id = 0

// Do a little forum sync stuff

$sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts, COUNT(t.topic_approved) as topics_authed

FROM ' . TOPICS_TABLE . ' t

$sync_sql = array();

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET ' . implode(', ', $array) . '

WHERE forum_id = ' . $forum_id_key;

}

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

{

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . '

AND forum_id = 0';

if ($row)

{

}

}

$sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts

FROM ' . TOPICS_TABLE . ' t

$sync_sql = array();

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_type = ' . POST_ANNOUNCE . '

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

}

// Leave a redirection if required and only if the topic is visible to users

'poll_last_vote' => (int) $row['poll_last_vote']

);

$topics_authed_moved--;

$topics_moved--;

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET ' . implode(', ', $array) . '

WHERE forum_id = ' . $forum_id_key;

}

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

}

$sql = 'SELECT DISTINCT topic_id

FROM ' . POSTS_TABLE . '

$topic_id_list = array();

{

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

}

$affected_topics = sizeof($topic_id_list);

$post_data = get_post_data($post_ids);

$sql = 'SELECT COUNT(topic_id) AS topics_left

FROM ' . TOPICS_TABLE . '

$topic_id = request_var('t', 0);

'poll_length' => (int) $topic_row['poll_length']

);

$new_topic_id_list[$topic_id] = $new_topic_id;

if ($topic_row['poll_start'])

$sql = 'SELECT *

FROM ' . POLL_OPTIONS_TABLE . "

WHERE topic_id = $topic_id";

{

$sql_ary = array(

'poll_option_id' => (int) $row['poll_option_id'],

'poll_option_total' => 0

);

}

}

FROM ' . POSTS_TABLE . "

WHERE topic_id = $topic_id

ORDER BY post_time ASC";

$post_rows = array();

{

$post_rows[] = $row;

}

if (!sizeof($post_rows))

{

'post_postcount' => 0,

);

// Copy whether the topic is dotted

markread('post', $to_forum_id, $new_topic_id, 0, $row['poster_id']);

WHERE post_msg_id = {$row['post_id']}

AND topic_id = $topic_id

AND in_message = 0";

$sql_ary = array();

{

$sql_ary[] = array(

'post_msg_id' => (int) $new_post_id,

'thumbnail' => (int) $attach_row['thumbnail']

);

}

if (sizeof($sql_ary))

{

}

}

}

$sql = 'SELECT user_id, notify_status

FROM ' . TOPICS_WATCH_TABLE . '

WHERE topic_id = ' . $topic_id;

$sql_ary = array();

{

$sql_ary[] = array(

'topic_id' => (int) $new_topic_id,

'notify_status' => (int) $row['notify_status'],

);

}

if (sizeof($sql_ary))

{

}

}

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET ' . implode(', ', $array) . '

WHERE forum_id = ' . $forum_id_key;

}

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

add_form_key('mcp_notes');

$sql = 'SELECT *

FROM ' . USERS_TABLE . "

WHERE $sql_where";

if (!$userrow)

{

{

$sql_in[] = $mark;

}

unset($sql_in);

}

WHERE log_type = ' . LOG_USERS . "

AND reportee_id = $user_id

$where_sql";

add_log('admin', 'LOG_CLEAR_USER', $userrow['username']);

if ($action == 'chgposter')

{

$username = request_var('username', '', true);

}

else

{

$sql = 'SELECT *

FROM ' . USERS_TABLE . '

WHERE ' . $sql_where;

if (!$row)

{

WHERE post_msg_id = ' . $post_id . '

AND in_message = 0

ORDER BY filetime DESC, post_msg_id ASC';

{

$attachments[] = $row;

}

if (sizeof($attachments))

{

AND r.reason_id = re.reason_id

AND u.user_id = r.user_id

ORDER BY r.report_time DESC";

{

$template->assign_var('S_SHOW_REPORTS', true);

'REPORT_TEXT' => bbcode_nl2br(trim($row['report_text'])),

));

}

}

}

// Get IP

// Get other users who've posted under this IP

$sql = 'SELECT poster_id, COUNT(poster_id) as postings

FROM ' . POSTS_TABLE . "

GROUP BY poster_id

ORDER BY postings DESC";

{

// Fill the user select list with users who have posted under this IP

if ($row['poster_id'] != $post_info['poster_id'])

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

}

}

if (sizeof($users_ary))

{

// Get the usernames

$sql = 'SELECT user_id, username

FROM ' . USERS_TABLE . '

{

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

$usernames_ary[utf8_clean_string($row['username'])] = $users_ary[$row['user_id']];

}

foreach ($users_ary as $user_id => $user_row)

{

WHERE poster_id = ' . $post_info['poster_id'] . "

GROUP BY poster_ip

ORDER BY postings DESC";

{

$hostname = (($rdns_ip_num == $row['poster_ip'] || $rdns_ip_num == 'all') && $row['poster_ip']) ? @gethostbyaddr($row['poster_ip']) : '';

'U_WHOIS' => append_sid('mcp', "i=$id&amp;mode=$mode&amp;action=whois&amp;p=$post_id&amp;ip={$row['poster_ip']}"))

);

}

$user_select = '';

$sql = 'UPDATE ' . POSTS_TABLE . "

SET poster_id = {$userdata['user_id']}

WHERE post_id = $post_id";

// Resync topic/forum if needed

if ($post_info['topic_last_post_id'] == $post_id || $post_info['forum_last_post_id'] == $post_id || $post_info['topic_first_post_id'] == $post_id)

SET user_posts = user_posts - 1

WHERE user_id = ' . $post_info['user_id'] .'

AND user_posts > 0';

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_posts = user_posts + 1

WHERE user_id = ' . $userdata['user_id'];

}

// Add posted to information for this topic for the new user

FROM ' . POSTS_TABLE . '

WHERE topic_id = ' . $post_info['topic_id'] . '

AND poster_id = ' . $post_info['user_id'];

if (!$topic_id)

{

$sql = 'DELETE FROM ' . TOPICS_POSTED_TABLE . '

WHERE user_id = ' . $post_info['user_id'] . '

AND topic_id = ' . $post_info['topic_id'];

}

}

WHERE poster_id = ' . $post_info['user_id'] . '

AND post_msg_id = ' . $post_info['post_id'] . '

AND topic_id = ' . $post_info['topic_id'];

}

// refresh search cache of this post

WHERE post_msg_id = ' . $post_id . '

AND in_message = 0

ORDER BY filetime DESC, post_msg_id ASC';

{

$attachments[] = $row;

}

if (sizeof($attachments))

{

$sql = 'SELECT SUM(forum_topics) as sum_forum_topics

FROM ' . FORUMS_TABLE . "

WHERE forum_id IN (0, $forum_list)";

}

else

{

AND t.topic_first_post_id <> p.post_id

$limit_time_sql

ORDER BY $sort_order_sql";

$i = 0;

$post_ids = array();

{

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

$row_num[$row['post_id']] = $i++;

}

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, u.username_clean, u.user_colour

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

AND t.topic_id = p.topic_id

AND u.user_id = p.poster_id

ORDER BY ' . $sort_order_sql;

$post_data = $rowset = array();

{

if ($row['forum_id'])

{

}

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

}

foreach ($post_ids as $post_id)

{

AND topic_approved = 0

$limit_time_sql

ORDER BY $sort_order_sql";

$rowset = array();

{

if ($row['forum_id'])

{

}

$rowset[] = $row;

}

}

if (sizeof($forum_names))

// Select the names for the forum_ids

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE . '

$forum_names = array();

{

$forum_names[$row['forum_id']] = $row['forum_name'];

}

}

foreach ($rowset as $row)

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_approved = 1

}

if (sizeof($post_approve_sql))

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_approved = 1

}

foreach ($approve_log as $log_data)

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_replies = topic_replies + $num_replies

WHERE topic_id = $topic_id";

}

}

$sql .= ($row['forum_posts']) ? "forum_posts = forum_posts + {$row['forum_posts']}" : '';

$sql .= " WHERE forum_id = $forum_id";

}

}

{

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_posts = user_posts + ' . $user_posts . '

}

}

$sql = 'SELECT reason_title, reason_description

FROM ' . REPORTS_REASONS_TABLE . "

WHERE reason_id = $reason_id";

if (!$row || (!$reason && strtolower($row['reason_title']) == 'other'))

{

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET forum_topics_real = forum_topics_real - $topics_real

WHERE forum_id = $forum_id";

}

}

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_replies_real = topic_replies_real - $num_replies

WHERE topic_id = $topic_id";

}

}

AND rr.reason_id = r.reason_id

AND r.user_id = u.user_id

ORDER BY report_closed ASC';

if (!$report)

{

WHERE post_msg_id = ' . $post_id . '

AND in_message = 0

ORDER BY filetime DESC, post_msg_id ASC';

{

$attachments[] = $row;

}

if (sizeof($attachments))

{

$sql = 'SELECT SUM(forum_topics) as sum_forum_topics

FROM ' . FORUMS_TABLE . '

}

else

{

$sql = 'SELECT r.report_id

FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . REPORTS_TABLE . ' r ' . (($sort_order_sql[0] == 'u') ? ', ' . USERS_TABLE . ' u' : '') . (($sort_order_sql[0] == 'r') ? ', ' . USERS_TABLE . ' ru' : '') . '

$report_state

AND r.post_id = p.post_id

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

AND t.topic_id = p.topic_id

$limit_time_sql

ORDER BY $sort_order_sql";

$i = 0;

$report_ids = array();

{

$report_ids[] = $row['report_id'];

$row_num[$row['report_id']] = $i++;

}

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, u.username_clean, u.user_colour, r.user_id as reporter_id, ru.username as reporter_name, ru.user_colour as reporter_colour, r.report_time, r.report_id

FROM ' . REPORTS_TABLE . ' r, ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . ' u, ' . USERS_TABLE . ' ru

AND t.topic_id = p.topic_id

AND r.post_id = p.post_id

AND u.user_id = p.poster_id

AND ru.user_id = r.user_id

ORDER BY ' . $sort_order_sql;

$report_data = $rowset = array();

{

$global_topic = ($row['forum_id']) ? false : true;

if ($global_topic)

'TOPIC_TITLE' => $row['topic_title'])

);

}

unset($report_ids, $row);

}

{

$sql = 'SELECT r.post_id

FROM ' . REPORTS_TABLE . ' r

$post_id_list = array();

{

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

}

$sql = 'SELECT r.report_id, r.post_id, r.report_closed, r.user_id, r.user_notify, u.username, u.username_clean, 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';

$reports = $close_report_posts = $close_report_topics = $notify_reporters = $report_id_list = array();

{

$reports[$report['report_id']] = $report;

$report_id_list[] = $report['report_id'];

$notify_reporters[$report['report_id']] = &$reports[$report['report_id']];

}

}

if (sizeof($reports))

{

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

$sql = 'SELECT DISTINCT topic_id

FROM ' . POSTS_TABLE . '

AND post_reported = 1

$keep_report_topics = array();

{

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

}

$close_report_topics = array_diff($close_report_topics, $keep_report_topics);

unset($keep_report_topics);

}

if ($action == 'close')

{

$sql = 'UPDATE ' . REPORTS_TABLE . '

SET report_closed = 1

}

else

{

$sql = 'DELETE FROM ' . REPORTS_TABLE . '

}

if (sizeof($close_report_posts))

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_reported = 0

if (sizeof($close_report_topics))

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_reported = 0

}

}

}

unset($close_report_posts, $close_report_topics);

AND p.poster_id = u.user_id ' .

$limit_time_sql . '

ORDER BY ' . $sort_order_sql;

$rowset = $post_id_list = array();

$bbcode_bitfield = '';

{

$rowset[] = $row;

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

$bbcode_bitfield = $bbcode_bitfield | base64_decode($row['bbcode_bitfield']);

}

if ($bbcode_bitfield !== '')

{

{

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

AND in_message = 0

ORDER BY filetime DESC, post_msg_id ASC';

{

$attachments[$row['post_msg_id']][] = $row;

}

}

}

$limit_time_sql

ORDER BY $sort_order_sql";

}

$store = false;

$post_id_list = array();

{

// If split from selected post (split_beyond), we split the unapproved items too.

if (!$row['post_approved'] && !phpbb::$acl->acl_get('m_approve', $row['forum_id']))

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

}

}

}

if (!sizeof($post_id_list))

'topic_approved'=> 1

);

move_posts($post_id_list, $to_topic_id);

$topic_info = get_topic_data(array($topic_id));

// Change topic title of first post

$sql = 'UPDATE ' . POSTS_TABLE . "

WHERE post_id = {$post_id_list[0]}";

$success_msg = 'TOPIC_SPLIT_SUCCESS';

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

if ($row)

{

{

// If the topic no longer exist, we will update the topic watch table.

// To not let it error out on users watching both topics, we just return on an error...

}

// Link to the new topic

FROM ' . USERS_TABLE . ' u, ' . WARNINGS_TABLE . ' w

WHERE u.user_id = w.user_id

ORDER BY w.warning_time DESC';

{

$template->assign_block_vars('latest', array(

'U_NOTES' => append_sid('mcp', 'i=notes&amp;mode=user_notes&amp;u=' . $row['user_id']),

'WARNINGS' => $row['user_warnings'],

));

}

}

/**

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

WHERE post_id = $post_id

AND u.user_id = p.poster_id";

if (!$user_row)

{

$sql = 'SELECT post_id

FROM ' . WARNINGS_TABLE . "

WHERE post_id = $post_id";

if ($row)

{

$notify = phpbb_request::is_set('notify_user');

$warning = utf8_normalize_nfc(request_var('warning', '', true));

$sql = 'SELECT *

FROM ' . USERS_TABLE . '

WHERE ' . $sql_where;

if (!$user_row)

{

'warning_time' => time(),

);

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_warnings = user_warnings + 1,

user_last_warning = ' . time() . '

WHERE user_id = ' . $user_row['user_id'];

// We add this to the mod log too for moderators to see that a specific user got warned.

$sql = 'SELECT forum_id, topic_id

FROM ' . POSTS_TABLE . '

WHERE post_id = ' . $post_id;

add_log('mod', $row['forum_id'], $row['topic_id'], 'LOG_USER_WARNING', $user_row['username']);

}