<?php

/**

*

*

*/

/**

* mcp_queue

* Handling the moderation queue

*/

class mcp_queue

{

public function main($id, $mode)

{

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

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

$this->page_title = 'MCP_QUEUE';

case 'delete':

$post_id_list = $request->variable('post_id_list', array(0));

$topic_id_list = $request->variable('topic_id_list', array(0));

if (!empty($post_id_list))

{

global $phpbb_root_path, $phpEx;

include($phpbb_root_path . 'includes/mcp/mcp_main.' . $phpEx);

}

}

else if (!empty($topic_id_list))

{

global $phpbb_root_path, $phpEx;

include($phpbb_root_path . 'includes/mcp/mcp_main.' . $phpEx);

}

}

else

{

if (!empty($topic_id_list))

{

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

AND ' . $db->sql_in_set('topic_id', $topic_id_list);

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

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

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

if ($topic_id)

{

if (isset($topic_info[$topic_id]['topic_first_post_id']))

{

$post_id = (int) $topic_info[$topic_id]['topic_first_post_id'];

}

else

{

}

}

if (!sizeof($post_info))

{

));

}

// Get topic tracking info

if ($config['load_db_lastread'])

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

{

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

WHERE post_msg_id = ' . $post_id . '

$template->assign_vars(array(

'S_MCP_QUEUE' => true,

'U_APPROVE_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue&amp;p=$post_id&amp;f=$forum_id"),

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

'S_POST_REPORTED' => $post_info['post_reported'],

'S_POST_LOCKED' => $post_info['post_edit_locked'],

'S_USER_NOTES' => true,

'S_POST_DELETED' => ($post_info['post_visibility'] == ITEM_DELETED),

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

'RETURN_QUEUE' => sprintf($user->lang['RETURN_QUEUE'], '<a href="' . append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue' . (($topic_id) ? '&amp;mode=unapproved_topics' : '&amp;mode=unapproved_posts')) . '&amp;start=' . $start . '">', '</a>'),

'RETURN_POST' => sprintf($user->lang['RETURN_POST'], '<a href="' . $post_url . '">', '</a>'),

'RETURN_TOPIC_SIMPLE' => sprintf($user->lang['RETURN_TOPIC_SIMPLE'], '<a href="' . $topic_url . '">', '</a>'),

'POST_SUBJECT' => $post_info['post_subject'],

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

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

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

'S_FIRST_POST' => ($post_info['topic_first_post_id'] == $post_id),

$m_perm = 'm_approve';

$is_topics = ($mode == 'unapproved_topics' || $mode == 'deleted_topics') ? true : false;

$is_restore = ($mode == 'deleted_posts' || $mode == 'deleted_topics') ? true : false;

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

$topic_id = $request->variable('t', 0);

$forum_info = array();

$pagination = $phpbb_container->get('pagination');

if ($topic_id)

{

if (!sizeof($topic_info))

{

}

else

{

if (!sizeof($forum_info))

{

trigger_error('NOT_MODERATOR');

}

$forum_list = $forum_id;

}

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

foreach ($forum_list_approve as $row)

{

}

$sort_days = $total = 0;

$sort_key = $sort_dir = '';

$sort_by_sql = $sort_order_sql = array();

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

$forum_names = array();

$sql = 'SELECT p.post_id

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

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

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

' . (($topic_id) ? 'AND p.topic_id = ' . $topic_id : '') . "

AND t.topic_id = p.topic_id

OR t.topic_delete_user = 0)

$limit_time_sql

ORDER BY $sort_order_sql";

$result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);

$i = 0;

$sql = 'SELECT t.forum_id, t.topic_id, t.topic_title, t.topic_title AS post_subject, t.topic_time AS post_time, t.topic_poster AS poster_id, t.topic_first_post_id AS post_id, t.topic_attachment AS post_attachment, t.topic_first_poster_name AS username, t.topic_first_poster_colour AS user_colour

FROM ' . TOPICS_TABLE . ' t

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

AND topic_delete_user <> 0

$limit_time_sql

ORDER BY $sort_order_sql";

$result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);

$rowset = array();

*/

static public function approve_posts($action, $post_id_list, $id, $mode)

{

{

trigger_error('NOT_AUTHORISED');

}

$redirect = $request->variable('redirect', build_url(array('quickmod')));

$redirect = reapply_sid($redirect);

$approve_log = array();

$s_hidden_fields = build_hidden_fields(array(

'i' => $id,

'redirect' => $redirect,

));

if (confirm_box(true))

{

$approve_log[] = array(

'forum_id' => $post_data['forum_id'],

'topic_id' => $post_data['topic_id'],

'post_subject' => $post_data['post_subject'],

);

}

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

foreach ($topic_info as $topic_id => $topic_data)

{

$phpbb_content_visibility->set_post_visibility(ITEM_APPROVED, $topic_data['posts'], $topic_id, $topic_data['forum_id'], $user->data['user_id'], time(), '', isset($topic_data['first_post']), isset($topic_data['last_post']));

}

foreach ($approve_log as $log_data)

{

}

// Only send out the mails, when the posts are being approved

if ($action == 'approve')

{

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

// Handle notifications

// A single topic approval may also happen here, so handle deleting the respective notification.

if (!$post_data['topic_posts_approved'])

{

}

), $post_data['post_id'], $user->data['user_id']);

// Notify Poster?

continue;

}

}

}

}

meta_refresh(3, $redirect);

$message = $user->lang[$success_msg];

{

foreach ($post_info as $post_data)

{

{

}

{

$show_notify = true;

}

}

}

'S_' . strtoupper($action) => true,

));

}

redirect($redirect);

*/

static public function approve_topics($action, $topic_id_list, $id, $mode)

{

{

trigger_error('NOT_AUTHORISED');

}

'redirect' => $redirect,

));

if (confirm_box(true))

{

$notify_poster = ($action == 'approve' && isset($_REQUEST['notify_poster'])) ? true : false;

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

$first_post_ids = array();

foreach ($approve_log as $log_data)

{

}

// Only send out the mails, when the posts are being approved

$db->sql_freeresult($result);

// Handle notifications

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

foreach ($topic_info as $topic_id => $topic_data)

'post_subject' => $topic_data['topic_title'],

'post_time' => $topic_data['topic_time'],

'poster_id' => $topic_data['topic_poster'],

));

if ($notify_poster)

{

}

}

}

meta_refresh(3, $redirect);

$message = $user->lang[$success_msg];

*/

static public function disapprove_posts($post_id_list, $id, $mode)

{

{

trigger_error('NOT_AUTHORISED');

}

$redirect = reapply_sid($redirect);

$reason = $request->variable('reason', '', true);

$reason_id = $request->variable('reason_id', 0);

$s_hidden_fields = build_hidden_fields(array(

'i' => $id,

}

}

$is_disapproving = false;

foreach ($post_info as $post_id => $post_data)

if (confirm_box(true))

{

$topic_posts_unapproved = $post_disapprove_list = $topic_information = array();

// Build a list of posts to be disapproved and get the related topics real replies count

foreach ($post_info as $post_id => $post_data)

{

$post_disapprove_list[$post_id] = $post_data['topic_id'];

if (!isset($topic_posts_unapproved[$post_data['topic_id']]))

{

$topic_posts_unapproved[$post_data['topic_id']]++;

}

// Now we build the log array

foreach ($post_disapprove_list as $post_id => $topic_id)

{

if ($is_disapproving)

{

$l_log_message = ($log_data['type'] == 'topic') ? 'LOG_TOPIC_DISAPPROVED' : 'LOG_POST_DISAPPROVED';

}

else

{

$l_log_message = ($log_data['type'] == 'topic') ? 'LOG_DELETE_TOPIC' : 'LOG_DELETE_POST';

}

}

}

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

$lang_reasons = array();

$topic_information[$topic_id]['topic_posts_softdeleted'] == 0 &&

$topic_information[$topic_id]['topic_posts_unapproved'] == $topic_posts_unapproved[$topic_id];

// Do we disapprove the whole topic? Remove potential notifications

if ($disapprove_all_posts_in_topic)

{

}

// Notify Poster?

continue;

}

if (isset($disapprove_reason_lang))

{

// Okay we need to get the reason from the posters language

$post_data['disapprove_reason'] .= ($reason) ? "\n\n" . $reason : '';

}

if ($disapprove_all_posts_in_topic && $topic_information[$topic_id]['topic_posts_unapproved'] == 1)

{

// If there is only 1 post when disapproving the topic,

// we send the user a "disapprove topic" notification...

}

else

{

// ... otherwise there are multiple unapproved posts and

// all of them are disapproved as posts.

}

}

}

if ($num_disapproved_topics)

{

$success_msg = ($num_disapproved_topics == 1) ? 'TOPIC' : 'TOPICS';

$success_msg .= '_DELETED_SUCCESS';

}

meta_refresh(3, $redirect);

$message = $user->lang[$success_msg];

}

else

{

$show_notify = false;

foreach ($post_info as $post_data)

$confirm_template = 'mcp_approve.html';

if ($is_disapproving)

{

}

else

{