+//

+// Check if user did or did not confirm

+// If they did not, forward them to the last page they were on

+//

+if (isset($_POST['cancel']))

+{

+ if ($topic_id)

+ {

+ $redirect = "viewtopic.$phpEx$SID&t=$topic_id&start=$start";

+ }

+ elseif ($forum_id)

+ {

+ $redirect = "viewforum.$phpEx$SID&f=$forum_id&start=$start";

+ }

+ else

+ {

+ $redirect = "index.$phpEx$SID";

+ }

+

+ redirect($redirect);

+}

+

+$return_mcp = '<br /><br />' . sprintf($user->lang['Click_return_mcp'], '<a href="mcp.' . $phpEx . $SID . '">', '</a>');

+$action = (!empty($_GET['action'])) ? $_GET['action'] : '';

+ break;

+

+ if (!$row = $db->sql_fetchrow($result))

+if ($to_forum_id)

+ $result = $db->sql_query('SELECT * FROM ' . FORUMS_TABLE . ' WHERE forum_id = ' . $to_forum_id);

+

+ if (!$row = $db->sql_fetchrow($result))

+ {

+ trigger_error($user->lang['Forum_not_exist'] . $return_mcp);

+ }

+

+

+ switch ($mode)

+ {

+ case 'move':

+ $is_auth = $auth->acl_gets('f_post', 'm_', 'a_', $to_forum_id);

+ break;

+

+ case 'merge':

+ $is_auth = $auth->acl_gets('f_post', 'f_reply', 'm_', 'a_', $to_forum_id);

+ break;

+

+ default:

+ trigger_error('Died here with mode ' . $mode);

+ }

+

+ // TODO: prevent moderators to move topics/posts to locked forums/topics?

+ if (!$is_auth || !$forum_data[$to_forum_id]['forum_postable'])

+ {

+ trigger_error('User_cannot_post');

+ }

+ $selected_post_ids[] = (int) base_convert($short, 36, 10);

+$topic_id_sql = implode(', ', array_unique($topic_id_list));

+$post_id_sql = implode(', ', array_unique($post_id_list));

+$forum_id_list = array_unique($forum_id_list);

+$topic_id_list = array_unique($topic_id_list);

+$post_id_list = array_unique($post_id_list);

+

+ if (!$forum_id || count($forum_id_list) == 1)

+ if (!$topic_id || count($topic_id_list) == 1)

+ if (!$post_id || count($post_id_list) == 1)

+ // There's no forums list available so the user either submitted an empty or invalid list of posts/topics or isn't a moderator

+

+// There we're done validating input.

+//

+// $post_id_list contains the complete list of post_id's, same for $topic_id_list and $forum_id_list

+// $post_id, $topic_id, $forum_id have all been set.

+//

+// $forum_data is an array where $forum_data[<forum_id>] contains the corresponding row, same for $topic_data and $post_data.

+// $forum_info is set to $forum_data[$forum_id] for quick reference, same for topic and post.

+//

+// We know that the user has m_ or a_ access to all the selected forums/topics/posts but we still have to check for specific authorisations.

+// Currently, this method may prevent moderators to merge topics if they do not have m_ or a_ access to both topics.

+$return_mcp = '<br /><br />' . sprintf($user->lang['Click_return_mcp'], '<a href="' . $mcp_url . '">', '</a>');

+// Do major work ... (<= being the 1-billion dollars man)

+// Current modes:

+// - resync Resyncs topics

+// - delete_posts Delete posts, displays confirmation if unconfirmed

+// - delete Delete topics, displays confirmation

+// - select_topic Forward the user to forum view to select a destination topic for the merge

+// - merge Topic view, only displays the Merge button

+// - split Topic view, only displays the split buttons

+// - massdelete Topic view, only displays the Delete button

+// - topic_view Topic view, similar to viewtopic.php

+// - forum_view Forum view, similar to viewforum.php

+// - move Move selected topic(s), displays the forums list for confirmation. Used for quickmod as well

+// - lock, unlock Lock or unlock topic(s). No confirmation. Used for quickmod.

+// - merge_posts Actually merge posts to selected topic. Untested yet.

+// - ip Displays poster's ip and other ips the user has posted from. (imported straight from 2.0.x)

+//

+// TODO:

+// - split_all Actually split selected topic

+// - split_beyond Actually split selected topic

+// - post_view Displays post details. Has quick links to (un)approve post.

+// - mod_queue Displays a list or unapproved posts and/or topics. I haven't designed the interface yet but it will have to be able to filter/order them by type (posts/topics), by timestamp or by forum.

+// - post_reports Displays a list of reported posts. No interface yet, must be able to order them by priority(?), type, timestamp or forum. Action: view all (default), read, delete.

+// - approve/unapprove Actually un/approve selected topic(s) or post(s). NOTE: after some second thoughts we'll need three modes: (which names are still to be decided) the first to approve items, the second to set them back as "unapproved" and a third one to "disapprove" them. (IOW, delete them and eventually send a notification to the user)

+// - notes Displays moderators notes for current forum or for all forums the user is a moderator of. Actions: view all (default), read, add, delete, edit(?).

+// - a hell lot of other things

+//

+// TODO: add needed acl checks for each mode.

+

+ $l_redirect = sprintf($user->lang['Click_return_mcp'], '<a href="mcp.' . $phpEx . $SID . '&amp;f=' . $forum_id . '">', '</a>');

+ if (!count($post_id_list))

+ $l_redirect = sprintf($user->lang['Click_return_mcp'], '<a href="mcp.' . $phpEx . $SID . '&amp;f=' . $forum_id . '">', '</a>');

+ $l_redirect = sprintf($user->lang['Click_return_mcp'], '<a href="mcp.' . $phpEx . $SID . '&amp;f=' . $forum_id . '">', '</a>');

+ $post_id_str = short_id_list($post_id_list);

+ $i = 1;

+ $checked = ($mode == 'merge' && in_array(intval($row['post_id']), $selected_post_ids)) ? 'checked="checked" ' : '';

+ 'S_CHECKBOX' => $s_checkbox,

+ 'ROW_CLASS' => 'row' . $i

+ $i = 3 - $i;

+ $return_move = '<br /><br />' . sprintf($user->lang['Click_return_mcp'], '<a href="' . $mcp_url . '&amp;mode=move">', '</a>');

+

+ if (!$to_forum_id)

+ trigger_error($user->lang['Forum_not_exist'] . $return_move);

+

+ $result = $db->sql_query('SELECT forum_id, forum_postable FROM ' . FORUMS_TABLE . ' WHERE forum_id = ' . $to_forum_id);

+ $row = $db->sql_fetchrow($result);

+

+ if ($to_forum_id != $forum_id)

+ if (!$row['forum_postable'])

+ {

+ trigger_error($user->lang['Forum_not_postable'] . $return_move);

+ }

+

+ move_topics($topic_id_list, $to_forum_id);

+

+ if (!empty($_POST['move_leave_shadow']))

+ {

+ $shadow = $topic_info;

+ $shadow['topic_status'] = ITEM_MOVED;

+ $shadow['topic_moved_id'] = $topic_info['topic_id'];

+ unset($shadow['topic_id']);

+

+ $db->sql_query('INSERT INTO ' . TOPICS_TABLE . ' ' . $db->sql_build_array('INSERT', $shadow));

+ }

+ 'S_HIDDEN_FIELDS' => $s_hidden_fields,

+ 'S_FORUM_SELECT' => make_forum_select(0, $forum_id)

+ $message .= sprintf($user->lang['Click_return_mcp'], '<a href="' . $redirect_page . '">', '</a>');

+ case 'split_all':

+ case 'split_beyond':

+ if (empty($_POST['subject']))

+ {

+ $post_id_str = short_id_list($post_id_list);

+ $message = $user->lang['Empty_subject'] . '<br /><br />' . sprintf($user->lang['Click_return_mcp'], '<a href="' . $mcp_url . '&amp;mode=split&amp;post_id_list=' . $post_id_str . '">', '</a>');

+

+ trigger_error($message);

+ }

+

+ $sql = 'INSERT INTO ' . TOPICS_TABLE . " (topic_title)

+ VALUES ('" . $db->sql_escape($_POST['subject']) . "')";

+ $db->sql_query($sql);

+ $return_url = '<br /><br />' . sprintf($user->lang['Click_return_topic'], '<a href="viewtopic.' . $phpEx . $SID . '&amp;t=' . $to_topic_id . '">', '</a>');

+ 'PAGE_NUMBER' => sprintf($user->lang['PAGE_OF'], (floor($start / $config['topics_per_page']) + 1), ceil($forum_info ['forum_topics'] / $config['topics_per_page']))

+ ));

+ if (!is_array($post_ids))

+ {

+ $post_ids = array($post_ids);

+ }

+ $forum_ids = array();

+ $topic_ids = array($topic_id);

+

+ $forum_ids[] = $row['forum_id'];

+ $forum_ids[] = $row['forum_id'];

+

+ resync('forum', 'forum_id', $forum_ids);

+/* NOTES:

+

+Queries are kinda tricky.

+

+- subforums: we have to be able to get post/topic counts including subforums, hence the join

+- empty topics/forums: we have to be able to resync empty topics as well as empty forums therefore we have to use a LEFT join because a full join would only return results greater than 0

+- approved posts and topics: I do not like to put the "*_approved = 1" condition in the left join condition but if it's put as a WHERE condition it won't return any row for empty forums. If it causes any problem it could be replaced with a group condition like "GROUP BY p.post_approved"

+

+*/

+function resync($type, $where_type = '', $where_ids = '', $resync_parents = FALSE)

+ $where_sql = ($type == 'forum') ? 'WHERE' : '';

+ if ($resync_parents)

+ {

+ $forum_ids = array();

+

+ $sql = 'SELECT f2.forum_id

+ FROM ' . FORUMS_TABLE . ' f, ' . FORUMS_TABLE . " f2

+ $where_sql f.left_id BETWEEN f2.left_id AND f2.right_id";

+

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

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

+ {

+ $forum_ids[] = $row['forum_id'];

+ }

+

+ if (count($forum_ids))

+ {

+ resync('forum', 'forum_id', $forum_ids);

+ }

+

+ return;

+ }

+

+ switch ($dbms)

+ {

+ default:

+ // We have to use a left join to be able to resync empty forums

+ //

+ // This query does NOT take subforums into account

+ //

+ $sql = 'SELECT f.*, COUNT(p.post_id) AS posts, MAX(p.post_id) AS last_post_id

+ FROM ' . FORUMS_TABLE . ' f

+ LEFT JOIN ' . POSTS_TABLE . " p ON p.forum_id = f.forum_id

+ $where_sql p.post_approved = 1

+ GROUP BY f.forum_id";

+

+ // This _untested_ query would (hopefully)

+ $sql = 'SELECT f.*, COUNT(p.post_id) AS posts, MAX(p.post_id) AS last_post_id

+ FROM ' . FORUMS_TABLE . ' f, ' . FORUMS_TABLE . ' f2

+ LEFT JOIN ' . POSTS_TABLE . " p ON p.forum_id = f2.forum_id

+ AND p.post_approved = 1

+ $where_sql f2.left_id BETWEEN f.left_id AND f.right_id

+ GROUP BY f.forum_id";

+ }

+ if (!$row['last_post_id'])

+ {

+ $row['last_post_id'] = 0;

+ }

+ else

+ {

+ $post_ids[] = $row['last_post_id'];

+ }

+ switch ($dbms)

+ {

+ default:

+ $sql = 'SELECT f.forum_id, COUNT(t.topic_id) AS forum_topics

+ FROM ' . FORUMS_TABLE . ' f

+ LEFT JOIN ' . TOPICS_TABLE . " t ON t.forum_id = f.forum_id

+ AND t.topic_type <> " . ITEM_MOVED . '

+ AND t.topic_approved = 1

+ GROUP BY f.forum_id';

+

+ $sql = 'SELECT f.forum_id, COUNT(t.topic_id) AS forum_topics

+ FROM ' . FORUMS_TABLE . ' f, ' . FORUMS_TABLE . ' f2

+ LEFT JOIN ' . TOPICS_TABLE . ' t ON t.forum_id = f2.forum_id

+ AND t.topic_status <> ' . ITEM_MOVED . "

+ AND t.topic_approved = 1

+ $where_sql f2.left_id BETWEEN f.left_id AND f.right_id

+ GROUP BY f.forum_id";

+ }

+

+ $forum_data[$row['forum_id']]['topics'] = intval($row['forum_topics']);

+ $sql = 'SELECT p.forum_id, p.post_id, p.poster_id, p.post_username, p.post_time, u.username

+

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

+ if (isset($row[$fieldname]))

+ {

+ $sql['forum_' . $fieldname] = (string) $row[$fieldname];

+ }

+ else

+ {

+ $sql['forum_' . $fieldname] = '';

+ }

+ if (isset($row[$fieldname]))

+ {

+ $sql['forum_' . $fieldname] = (int) $row[$fieldname];

+ }

+ else

+ {

+ $sql['forum_' . $fieldname] = 0;

+ }

+ $topic_data = $post_ids = $topic_ids = $resync_forums = array();

+ switch ($dbms)

+ {

+ default:

+ $sql = 'SELECT t.*, COUNT(p.post_id) AS total_posts, MIN(p.post_id) AS first_post_id, MAX(p.post_id) AS last_post_id

+ FROM ' . TOPICS_TABLE . ' t

+ LEFT JOIN ' . POSTS_TABLE . " p ON p.topic_id = t.topic_id

+ AND p.post_approved = 1

+ $where_sql

+ GROUP BY t.topic_id";

+ }

+ $row['total_posts'] = intval($row['total_posts']);

+ $row['first_post_id'] = intval($row['first_post_id']);

+ $row['last_post_id'] = intval($row['last_post_id']);

+ $row['replies'] = $row['total_posts'] - 1;

+ $topic_data[$row['topic_id']] = $row;

+

+ if (!$row['total_posts'])

+ else

+ $post_ids[] = $row['last_post_id'];

+ if ($row['first_post_id'] != $row['last_post_id'])

+ {

+ $post_ids[] = $row['first_post_id'];

+ }

+ // If we get there, topic ids were invalid or topics did not contain any posts

+ if ($row['post_id'] == $topic_data[$row['topic_id']]['first_post_id'])

+ {

+ $topic_data[$row['topic_id']]['time'] = $row['post_time'];

+ $topic_data[$row['topic_id']]['first_poster_name'] = ($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : '';

+ }

+ $sql['topic_' . $fieldname] = (string) $row[$fieldname];

+ $sql['topic_' . $fieldname] = (int) $row[$fieldname];

+ // NOTE: should shadow topics be updated as well?

+

+ $resync_forums[] = $row['forum_id'];

+ }

+ }

+

+ // if some topics have been resync'ed then resync parent forums

+ if (count($resync_forums))

+ {

+ $sql = 'SELECT f.forum_id

+ FROM ' .FORUMS_TABLE . ' f, ' . FORUMS_TABLE . ' f2

+ WHERE f.left_id BETWEEN f2.left_id AND f2.right_id

+ AND f2.forum_id IN (' . implode(', ', array_unique($resync_forums)) . ')

+ GROUP BY f.forum_id';

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

+

+ $forum_ids = array();

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

+ {

+ $forum_ids[] = $row['forum_id'];

+ }

+ if (count($forum_ids))

+ {

+ resync('forum', 'forum_id', $forum_ids, $resync_parents);

+ break;

+

+

+function short_id_list($id_list)

+{

+ $max_len = 0;

+ $short_id_list = array();

+

+ foreach ($id_list as $id)

+ {

+ $short = base_convert($id, 10, 36);

+ $max_len = max(strlen($short), $max_len);

+ $short_id_list[] = $short;

+ }

+

+ $id_str = $max_len;

+ foreach ($short_id_list as $short)

+ {

+ $id_str .= str_pad($short, $max_len, '0', STR_PAD_LEFT);

+ }

+

+ return $id_str;

+}

+

+ $lang = array(

+ 'Forum_not_postable' => 'This forum is not postable',

+ 'SELECTED_TOPICS' => 'You selected the following topic(s)',

+ 'Topic_not_exist' => 'The topic you selected does not exist',

+ 'Posts_merged' => 'The selected posts have been merged',

+ 'Select_for_merge' => '%sSelect%s',

+ 'Select_topic' => 'Select topic',

+ 'Topic_number_is' => 'Topic #%d is %s',

+ 'POST_REMOVED' => 'The selected post has been successfully removed from the database.',

+ 'POSTS_REMOVED' => 'The selected posts have been successfully removed from the database.',

+ 'TOPIC_MOVED' => 'The selected topic has been successfully moved.',

+ 'TOPICS_MOVED' => 'The selected topics have been successfully moved.',

+ 'CONFIRM_DELETE_POSTS' => 'Are you sure you want to delete these posts?',

+ 'TOPIC_RESYNCHRONISED' => 'The selected topic has been resynchronised',

+ 'TOPICS_RESYNCHRONISED' => 'The selected topics have been resynchronised',

+ 'RESYNC' => 'Resync'

+ );

+ $user->lang = array_merge($user->lang, $lang);

+ 'forum_view' => 'View Forum',

+ 'topic_view' => 'View Topic',

+ 'post_view' => 'Post Details',