var $p_master;

var $u_action;

{

}

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpEx, $action, $phpbb_container, $phpbb_dispatcher;

include_once($phpbb_root_path . 'includes/functions_posting.' . $phpEx);

$this->page_title = 'MCP_REPORTS';

case 'delete':

include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

{

trigger_error('NO_REPORT_SELECTED');

}

$user->add_lang(array('posting', 'viewforum', 'viewtopic'));

// closed reports are accessed by report id

$sql_ary = array(

'SELECT' => 'r.post_id, r.user_id, r.report_id, r.report_closed, report_time, r.report_text, r.reported_post_text, r.reported_post_uid, r.reported_post_bitfield, r.reported_post_enable_magic_url, r.reported_post_enable_smilies, r.reported_post_enable_bbcode, rr.reason_title, rr.reason_description, u.username, u.username_clean, u.user_colour',

trigger_error('NO_REPORT');

}

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

if (!$report_id && $report['report_closed'])

{

$post_info = phpbb_get_post_data(array($post_id), 'm_report', true);

{

trigger_error('NO_REPORT_SELECTED');

}

));

}

// Get topic tracking info

if ($config['load_db_lastread'])

{

}

$db->sql_freeresult($result);

{

$update_count = array();

parse_attachments($post_info['forum_id'], $message, $attachments, $update_count);

}

}

'S_MCP_REPORT' => true,

'S_CLOSE_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&mode=report_details&f=' . $post_info['forum_id'] . '&p=' . $post_id),

'S_CAN_VIEWIP' => $auth->acl_get('m_info', $post_info['forum_id']),

'POST_SUBJECT' => ($post_info['post_subject']) ? $post_info['post_subject'] : $user->lang['NO_SUBJECT'],

'POST_DATE' => $user->format_date($post_info['post_time']),

'POST_IP' => $post_info['poster_ip'],

'POST_ID' => $post_info['post_id'],

'U_LOOKUP_IP' => ($auth->acl_get('m_info', $post_info['forum_id'])) ? $this->u_action . '&r=' . $report_id . '&p=' . $post_id . '&f=' . $forum_id . '&lookup=' . $post_info['poster_ip'] . '#ip' : '',

$this->tpl_name = 'mcp_post';

case 'reports':

case 'reports_closed':

$forum_info = array();

$forum_list_reports = get_forum_list('m_report', false, true);

{

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

{

trigger_error('TOPIC_NOT_EXIST');

}

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

}

{

trigger_error('NOT_MODERATOR');

}

$sql = 'SELECT SUM(forum_topics_approved) as sum_forum_topics

FROM ' . FORUMS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $forum_list);

{

$forum_info = phpbb_get_forum_data(array($forum_id), 'm_report');

{

trigger_error('NOT_MODERATOR');

}

$forum_list = array($forum_id);

}

$forum_list[] = 0;

$forum_data = array();

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

foreach ($forum_list_reports as $row)

$sort_by_sql = $sort_order_sql = array();

phpbb_mcp_sorting($mode, $sort_days, $sort_key, $sort_dir, $sort_by_sql, $sort_order_sql, $total, $forum_id, $topic_id);

$limit_time_sql = ($sort_days) ? 'AND r.report_time >= ' . (time() - ($sort_days * 86400)) : '';

if ($mode == 'reports')

}

$db->sql_freeresult($result);

{

$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, p.post_attachment, 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

ORDER BY ' . $sort_order_sql;

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

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

{

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

*/

function close_report($report_id_list, $mode, $action, $pm = false)

{

global $phpEx, $phpbb_root_path, $phpbb_container;

$pm_where = ($pm) ? ' AND r.post_id = 0 ' : ' AND r.pm_id = 0 ';

{

if (!$auth->acl_getf_global('m_report'))

{

trigger_error('NOT_AUTHORISED');

}

}

{

if (!phpbb_check_ids($post_id_list, POSTS_TABLE, 'post_id', array('m_report')))

{

trigger_error('NOT_AUTHORISED');

}

}

if ($action == 'delete' && strpos($user->data['session_page'], 'mode=report_details') !== false)

{

}

else if ($action == 'delete' && strpos($user->data['session_page'], 'mode=pm_report_details') !== false)

{

}

{

}

else

{

}

$success_msg = '';

$forum_ids = array();

}

$db->sql_freeresult($result);

{

$close_report_posts = array_unique($close_report_posts);

$close_report_topics = array_unique($close_report_topics);

{

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

$sql = 'SELECT DISTINCT topic_id

}

$db->sql_query($sql);

{

if ($pm)

{

WHERE ' . $db->sql_in_set('post_id', $close_report_posts);

$db->sql_query($sql);

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_reported = 0

}

unset($close_report_posts, $close_report_topics);

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

foreach ($reports as $report)

{

if ($pm)

{

$phpbb_notifications->delete_notifications('notification.type.report_pm', $report['pm_id']);

}

else

{

$phpbb_notifications->delete_notifications('notification.type.report_post', $report['post_id']);

}

}

// Notify reporters

{

foreach ($notify_reporters as $report_id => $reporter)

{

unset($notify_reporters, $post_info, $reports);

}

else

{

}

$redirect = reapply_sid($redirect);

if (!$success_msg)

if (!$pm)

{

{

$return_forum = sprintf($user->lang['RETURN_FORUM'], '<a href="' . append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . current($forum_ids)) . '">', '</a>') . '<br /><br />';

}

{

$return_topic = sprintf($user->lang['RETURN_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . current($topic_ids) . '&amp;f=' . current($forum_ids)) . '">', '</a>') . '<br /><br />';

}