/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

'PAGINATION' => generate_pagination($url . "&i=$id&action=$action&mode=$mode&sd=$sort_dir&sk=$sort_key&st=$sort_days" . (($merge_select) ? $selected_ids : ''), $forum_topics, $topics_per_page, $start),

'PAGE_NUMBER' => on_page($forum_topics, $topics_per_page, $start),

));

// Grab icons

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

if ($total)

{

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

WHERE ' . $db->sql_in_set('p.post_id', $post_list) . '

AND t.topic_id = p.topic_id

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

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

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

}

$db->sql_freeresult($result);

}

$template->assign_vars(array(

'S_HIDDEN_FIELDS' => $s_hidden_fields,

'S_MCP_QUEUE_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue"),

));

}

}

if ($total)

{

'FROM' => array(

REPORTS_TABLE => 'r',

REPORTS_REASONS_TABLE => 'rr',

TOPICS_TABLE => 't',

USERS_TABLE => array('u', 'u2'),

),

'LEFT_JOIN' => array(

array(

'FROM' => array(FORUMS_TABLE => 'f'),

),

'WHERE' => 'r.post_id = p.post_id

AND p.poster_id = u2.user_id

AND ' . $db->sql_in_set('p.forum_id', $forum_list),

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

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

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

'REPORT_TIME' => $user->format_date($row['report_time']),

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

));

}

}

}

}

{

include($phpbb_root_path . 'includes/functions_privmsgs.' . $phpEx);

'FROM' => array(

REPORTS_TABLE => 'r',

REPORTS_REASONS_TABLE => 'rr',

USERS_TABLE => array('u', 'u2'),

),

'WHERE' => 'r.pm_id = p.msg_id

AND r.user_id = u.user_id

AND p.author_id = u2.user_id',

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

$pm_by_id = $pm_list = array();

'REPORT_TIME' => $user->format_date($row['report_time']),

'PM_TIME' => $user->format_date($row['message_time']),

'RECIPIENTS' => implode(', ', $address_list[$row['msg_id']]),

));

}

}

}

// Latest 5 logs

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

$template->assign_vars(array(

'PAGE_NUMBER' => on_page($log_count, $config['topics_per_page'], $start),

'PAGINATION' => generate_pagination($this->u_action . "&$u_sort_param$keywords_param", $log_count, $config['topics_per_page'], $start),

'L_TITLE' => $user->lang['MCP_LOGS'],

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

{

global $auth, $user, $db, $phpEx, $phpbb_root_path;

switch ($action)

{

case 'make_announce':

default:

$new_topic_type = POST_NORMAL;

$l_new_type = (sizeof($topic_ids) == 1) ? 'MCP_MAKE_NORMAL' : 'MCP_MAKE_NORMALS';

break;

}

$redirect = request_var('redirect', build_url(array('action', 'quickmod')));

$s_hidden_fields = array(

if (!isset($search_type) && $topic_row['enable_indexing'])

{

// Select the search method and do some additional checks to ensure it can actually be utilised

if (!class_exists($search_type))

{

}

$error = false;

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

'PAGE_NUMBER' => on_page($log_count, $config['topics_per_page'], $start),

'PAGINATION' => generate_pagination($this->u_action . "&$u_sort_param$keywords_param", $log_count, $config['topics_per_page'], $start),

'RANK_TITLE' => $rank_title,

'JOINED' => $user->format_date($userrow['user_regdate']),

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

'REPORT_TIME' => $user->format_date($row['report_time']),

'RECIPIENTS' => implode(', ', $address_list[$row['msg_id']]),

));

}

}

'PAGINATION' => generate_pagination($this->u_action . "&st=$sort_days&sk=$sort_key&sd=$sort_dir", $total, $config['topics_per_page'], $start),

'PAGE_NUMBER' => on_page($total, $config['topics_per_page'], $start),

'TOTAL' => $total,

)

);

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

}

// Get Reports

{

$sql = 'SELECT r.*, re.*, u.user_id, u.username

FROM ' . REPORTS_TABLE . ' r, ' . USERS_TABLE . ' u, ' . REPORTS_REASONS_TABLE . " re

}

// refresh search cache of this post

{

// We do some additional checks in the module to ensure it can actually be utilised

$error = false;

$search = new $search_type($error);

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

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

'POST_IPADDR' => ($auth->acl_get('m_info', $post_info['forum_id']) && request_var('lookup', '')) ? @gethostbyaddr($post_info['poster_ip']) : '',

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

'U_LOOKUP_IP' => ($auth->acl_get('m_info', $post_info['forum_id'])) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&mode=approve_details&f=' . $post_info['forum_id'] . '&p=' . $post_id . '&lookup=' . $post_info['poster_ip']) . '#ip' : '',

));

if (sizeof($post_ids))

{

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

WHERE ' . $db->sql_in_set('p.post_id', $post_ids) . '

AND t.topic_id = p.topic_id

}

else

{

FROM ' . TOPICS_TABLE . " t

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

AND topic_approved = 0

'FORUM_NAME' => $forum_names[$row['forum_id']],

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

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

}

unset($rowset, $forum_names);

'PAGINATION' => generate_pagination($this->u_action . "&f=$forum_id&st=$sort_days&sk=$sort_key&sd=$sort_dir", $total, $config['topics_per_page'], $start),

'PAGE_NUMBER' => on_page($total, $config['topics_per_page'], $start),

'TOPIC_ID' => $topic_id,

));

$this->tpl_name = 'mcp_queue';

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

{

$additional_msg = $user->lang['NO_REASON_DISAPPROVAL'];

$request->overwrite('confirm', null, phpbb_request_interface::POST);

}

else

{

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

$message = bbcode_nl2br($message);

$message = smiley_text($message);

if ($post_info['post_attachment'] && $auth->acl_get('u_download') && $auth->acl_get('f_download', $post_info['forum_id']))

{

if (sizeof($report_ids))

{

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

WHERE ' . $db->sql_in_set('r.report_id', $report_ids) . '

AND t.topic_id = p.topic_id

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

'REPORT_ID' => $row['report_id'],

'REPORT_TIME' => $user->format_date($row['report_time']),

}

$db->sql_freeresult($result);

unset($report_ids, $row);

'PAGE_NUMBER' => on_page($total, $config['topics_per_page'], $start),

'TOPIC_ID' => $topic_id,

'TOTAL' => $total,

)

);

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

'S_CHECKED' => (($submitted_id_list && !in_array(intval($row['post_id']), $submitted_id_list)) || in_array(intval($row['post_id']), $checked_ids)) ? true : false,

'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? true : false,

'PAGE_NUMBER' => on_page($total, $posts_per_page, $start),

'PAGINATION' => (!$posts_per_page) ? '' : generate_pagination(append_sid("{$phpbb_root_path}mcp.$phpEx", "i=$id&t={$topic_info['topic_id']}&mode=$mode&action=$action&to_topic_id=$to_topic_id&posts_per_page=$posts_per_page&st=$sort_days&sk=$sort_key&sd=$sort_dir"), $total, $posts_per_page, $start),

));

}

/**

*

* @package mcp

* @copyright (c) 2005 phpBB Group

*

*/

'PAGE_NUMBER' => on_page($user_count, $config['topics_per_page'], $start),

'PAGINATION' => generate_pagination(append_sid("{$phpbb_root_path}mcp.$phpEx", "i=warn&mode=list&st=$st&sk=$sk&sd=$sd"), $user_count, $config['topics_per_page'], $start),

));

}