define('IN_PHPBB', true);

$phpbb_root_path = './';

$phpEx = substr(strrchr(__FILE__, '.'), 1);

// Start session management

$user->session_begin();

{

if ($user->data['is_bot'])

{

}

login_box('', $user->lang['LOGIN_EXPLAIN_MCP']);

'make_sticky' => 'f_sticky',

'make_announce' => 'f_announce',

'make_global' => 'f_announce',

$allow_user = false;

if ($quickmod && isset($user_quickmod_actions[$action]) && $user->data['is_registered'] && $auth->acl_gets($user_quickmod_actions[$action], $forum_id))

if ($forum_id)

{

}

// Instantiate module system and generate list of available modules

case 'delete_post':

case 'delete_topic':

$module->load('mcp', 'main', 'quickmod');

case 'topic_logs':

$module->set_active('logs', 'topic_logs');

$module->load_active();

// Assign data to the template engine for the list of modules

// Generate the page

$module->display($module->get_page_title());

function extra_url()

{

global $forum_id, $topic_id, $post_id;

$url_extra = '';

$url_extra .= ($forum_id) ? "&f=$forum_id" : '';

$url_extra .= ($topic_id) ? "&t=$topic_id" : '';

$url_extra .= ($post_id) ? "&p=$post_id" : '';

return $url_extra;

}

{

global $auth, $db;

static $rowset = array();

$topics = array();

if (!sizeof($topic_ids))

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

}

}

foreach ($cache_topic_ids as $id)

function get_post_data($post_ids, $acl_list = false)

{

global $db, $auth;

$rowset = array();

if (!sizeof($post_ids))

),

'WHERE' => 'p.post_id IN (' . implode(', ', $post_ids) . ')

));

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

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

}

return $rowset;

}

function get_forum_data($forum_id, $acl_list = 'f_list')

{

global $auth, $db;

$rowset = array();

if (!sizeof($forum_id))

{

continue;

}

if ($auth->acl_get('m_approve', $row['forum_id']))

{

$row['forum_topics'] = $row['forum_topics_real'];

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

}

return $rowset;

}

$type = 'topics';

$default_key = 't';

$default_dir = 'd';

$sql = 'SELECT COUNT(topic_id) AS total

FROM ' . TOPICS_TABLE . "

$where_sql forum_id = $forum_id

{

$sql .= 'AND topic_approved = 1';

}

case 'viewtopic':

$type = 'posts';

$default_key = 't';

$default_dir = 'a';

$sql = 'SELECT COUNT(post_id) AS total

FROM ' . POSTS_TABLE . "

$where_sql topic_id = $topic_id

AND post_time >= $min_time";

if (!$auth->acl_get('m_approve', $forum_id))

{

$sql .= 'AND post_approved = 1';

}

case 'unapproved_posts':

$type = 'posts';

$where_sql forum_id IN (" . (($forum_id) ? $forum_id : implode(', ', get_forum_list('m_approve'))) . ')

AND post_approved = 0

AND post_time >= ' . $min_time;

case 'unapproved_topics':

$type = 'topics';

$default_key = 't';

$default_dir = 'd';

$sql = 'SELECT COUNT(topic_id) AS total

FROM ' . TOPICS_TABLE . "

$where_sql forum_id IN (" . (($forum_id) ? $forum_id : implode(', ', get_forum_list('m_approve'))) . ')

AND topic_approved = 0

AND topic_time >= ' . $min_time;

case 'reports':

case 'reports_closed':

$where_sql

AND p.post_id = r.post_id

$limit_time_sql";

case 'viewlogs':

$type = 'logs';

$default_key = 't';

$default_dir = 'd';

$sql = 'SELECT COUNT(log_id) AS total

FROM ' . LOG_TABLE . "

$where_sql forum_id IN (" . (($forum_id) ? $forum_id : implode(', ', get_forum_list('m_'))) . ')

AND log_time >= ' . $min_time . '

AND log_type = ' . LOG_MOD;

}

$sort_key = request_var('sk', $default_key);

$sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => 't.topic_last_post_time', 'tt' => 't.topic_time', 'r' => (($auth->acl_get('m_approve', $forum_id)) ? 't.topic_replies_real' : 't.topic_replies'), 's' => 't.topic_title', 'v' => 't.topic_views');

$limit_time_sql = ($min_time) ? "AND t.topic_last_post_time >= $min_time" : '';

case 'posts':

$limit_days = array(0 => $user->lang['ALL_POSTS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 's' => $user->lang['SUBJECT']);

$sort_by_sql = array('a' => 'u.username', 't' => 'p.post_id', 's' => 'p.post_subject');

$limit_time_sql = ($min_time) ? "AND p.post_time >= $min_time" : '';

case 'reports':

$limit_days = array(0 => $user->lang['ALL_REPORTS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['AUTHOR'], 'r' => $user->lang['REPORTER'], 'p' => $user->lang['POST_TIME'], 't' => $user->lang['REPORT_TIME'], 's' => $user->lang['SUBJECT']);

$sort_by_sql = array('a' => 'u.username', 'r' => 'ru.username', 'p' => 'p.post_id', 't' => 'r.report_time', 's' => 'p.post_subject');

case 'logs':

$limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_sql = array('u' => 'l.user_id', 't' => 'l.log_time', 'i' => 'l.log_ip', 'o' => 'l.log_operation');

$limit_time_sql = ($min_time) ? "AND l.log_time >= $min_time" : '';

}

$sort_order_sql = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');

gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $sort_url);

$template->assign_vars(array(

);

if (($sort_days && $mode != 'viewlogs') || in_array($mode, array('reports', 'unapproved_topics', 'unapproved_posts')) || $where_sql != 'WHERE')

{

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

}

else

{

if (!$forum_id)

{

}

$sql = "SELECT $sql_id FROM $table