/**

*

* @package mcp

* @version $Id: mcp_main.php 8950 2008-09-27 10:59:25Z toonarmy $

* @copyright (c) 2005 phpBB Group

* @license http://opensource.org/licenses/gpl-license.php GNU Public License

*

*/

/**

* @ignore

*/

if (!defined('IN_PHPBB'))

{

	exit;

}

/**

* mcp_main

* Handling mcp actions

* @package mcp

*/

class mcp_main

{

	var $p_master;

	var $u_action;

	function mcp_main(&$p_master)

	{

		$this->p_master = &$p_master;

	}

	function main($id, $mode)

	{

		global $auth, $db, $user, $template, $action;

		global $config, $phpbb_root_path, $phpEx;

		$quickmod = ($mode == 'quickmod') ? true : false;

		switch ($action)

		{

			case 'lock':

			case 'unlock':

				$topic_ids = (!$quickmod) ? request_var('topic_id_list', array(0)) : array(request_var('t', 0));

				if (!sizeof($topic_ids))

				{

					trigger_error('NO_TOPIC_SELECTED');

				}

				lock_unlock($action, $topic_ids);

			break;

			case 'lock_post':

			case 'unlock_post':

				$post_ids = (!$quickmod) ? request_var('post_id_list', array(0)) : array(request_var('p', 0));

				if (!sizeof($post_ids))

				{

					trigger_error('NO_POST_SELECTED');

				}

				lock_unlock($action, $post_ids);

			break;

			case 'make_announce':

			case 'make_sticky':

			case 'make_global':

			case 'make_normal':

				$topic_ids = (!$quickmod) ? request_var('topic_id_list', array(0)) : array(request_var('t', 0));

				if (!sizeof($topic_ids))

				{

					trigger_error('NO_TOPIC_SELECTED');

				}

				change_topic_type($action, $topic_ids);

			break;

			case 'move':

				$user->add_lang('viewtopic');

				$topic_ids = (!$quickmod) ? request_var('topic_id_list', array(0)) : array(request_var('t', 0));

				if (!sizeof($topic_ids))

				{

					trigger_error('NO_TOPIC_SELECTED');

				}

				mcp_move_topic($topic_ids);

			break;

			case 'fork':

				$user->add_lang('viewtopic');

				$topic_ids = (!$quickmod) ? request_var('topic_id_list', array(0)) : array(request_var('t', 0));

				if (!sizeof($topic_ids))

				{

					trigger_error('NO_TOPIC_SELECTED');

				}

				mcp_fork_topic($topic_ids);

			break;

			case 'delete_topic':

				$user->add_lang('viewtopic');

				$topic_ids = (!$quickmod) ? request_var('topic_id_list', array(0)) : array(request_var('t', 0));

				if (!sizeof($topic_ids))

				{

					trigger_error('NO_TOPIC_SELECTED');

				}

				mcp_delete_topic($topic_ids);

			break;

			case 'delete_post':

				$user->add_lang('posting');

				$post_ids = (!$quickmod) ? request_var('post_id_list', array(0)) : array(request_var('p', 0));

				if (!sizeof($post_ids))

				{

					trigger_error('NO_POST_SELECTED');

				}

				mcp_delete_post($post_ids);

			break;

		}

		switch ($mode)

		{

			case 'front':

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

				$user->add_lang('acp/common');

				mcp_front_view($id, $mode, $action);

				$this->tpl_name = 'mcp_front';

				$this->page_title = 'MCP_MAIN';

			break;

			case 'forum_view':

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

				$user->add_lang('viewforum');

				$forum_id = request_var('f', 0);

				$forum_info = get_forum_data($forum_id, 'm_', true);

				if (!sizeof($forum_info))

				{

					$this->main('main', 'front');

					return;

				}

				$forum_info = $forum_info[$forum_id];

				mcp_forum_view($id, $mode, $action, $forum_info);

				$this->tpl_name = 'mcp_forum';

				$this->page_title = 'MCP_MAIN_FORUM_VIEW';

			break;

			case 'topic_view':

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

				mcp_topic_view($id, $mode, $action);

				$this->tpl_name = 'mcp_topic';

				$this->page_title = 'MCP_MAIN_TOPIC_VIEW';

			break;

			case 'post_details':

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

				mcp_post_details($id, $mode, $action);

				$this->tpl_name = ($action == 'whois') ? 'mcp_whois' : 'mcp_post';

				$this->page_title = 'MCP_MAIN_POST_DETAILS';

			break;

			default:

				trigger_error('NO_MODE', E_USER_ERROR);

			break;

		}

	}

}

/**

* Lock/Unlock Topic/Post

*/

function lock_unlock($action, $ids)

{

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

	if ($action == 'lock' || $action == 'unlock')

	{

		$table = TOPICS_TABLE;

		$sql_id = 'topic_id';

		$set_id = 'topic_status';

		$l_prefix = 'TOPIC';

	}

	else

	{

		$table = POSTS_TABLE;

		$sql_id = 'post_id';

		$set_id = 'post_edit_locked';

		$l_prefix = 'POST';

	}

	$orig_ids = $ids;

	if (!check_ids($ids, $table, $sql_id, array('m_lock')))

	{

		// Make sure that for f_user_lock only the lock action is triggered.

		if ($action != 'lock')

		{

			return;

		}

		$ids = $orig_ids;

		if (!check_ids($ids, $table, $sql_id, array('f_user_lock')))

		{

			return;

		}

	}

	unset($orig_ids);

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

	$s_hidden_fields = build_hidden_fields(array(

		$sql_id . '_list'	=> $ids,

		'action'			=> $action,

		'redirect'			=> $redirect)

	);

	$success_msg = '';

	if (confirm_box(true))

	{

		$sql = "UPDATE $table

			SET $set_id = " . (($action == 'lock' || $action == 'lock_post') ? ITEM_LOCKED : ITEM_UNLOCKED) . '

			WHERE ' . $db->sql_in_set($sql_id, $ids);

		$db->sql_query($sql);

		$data = ($action == 'lock' || $action == 'unlock') ? get_topic_data($ids) : get_post_data($ids);

		foreach ($data as $id => $row)

		{

			add_log('mod', $row['forum_id'], $row['topic_id'], 'LOG_' . strtoupper($action), $row['topic_title']);

		}

		$success_msg = $l_prefix . ((sizeof($ids) == 1) ? '' : 'S') . '_' . (($action == 'lock' || $action == 'lock_post') ? 'LOCKED' : 'UNLOCKED') . '_SUCCESS';

	}

	else

	{

		confirm_box(false, strtoupper($action) . '_' . $l_prefix . ((sizeof($ids) == 1) ? '' : 'S'), $s_hidden_fields);

	}

	$redirect = request_var('redirect', "index.$phpEx");

	$redirect = reapply_sid($redirect);

	if (!$success_msg)

	{

		redirect($redirect);

	}

	else

	{

		meta_refresh(2, $redirect);

		trigger_error($user->lang[$success_msg] . '

' . sprintf($user->lang['RETURN_PAGE'], '', ''));

	}

}

/**

* Change Topic Type

*/

function change_topic_type($action, $topic_ids)

{

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

	// For changing topic types, we only allow operations in one forum.

	$forum_id = check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('f_announce', 'f_sticky', 'm_'), true);

	if ($forum_id === false)

	{

		return;

	}

	switch ($action)

	{

		case 'make_announce':

			$new_topic_type = POST_ANNOUNCE;

			$check_acl = 'f_announce';

			$l_new_type = (sizeof($topic_ids) == 1) ? 'MCP_MAKE_ANNOUNCEMENT' : 'MCP_MAKE_ANNOUNCEMENTS';

		break;

		case 'make_global':

			$new_topic_type = POST_GLOBAL;

			$check_acl = 'f_announce';

			$l_new_type = (sizeof($topic_ids) == 1) ? 'MCP_MAKE_GLOBAL' : 'MCP_MAKE_GLOBALS';

		break;

		case 'make_sticky':

			$new_topic_type = POST_STICKY;

			$check_acl = 'f_sticky';

			$l_new_type = (sizeof($topic_ids) == 1) ? 'MCP_MAKE_STICKY' : 'MCP_MAKE_STICKIES';

		break;

		default:

			$new_topic_type = POST_NORMAL;

			$check_acl = '';

			$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(

		'topic_id_list'	=> $topic_ids,

		'f'				=> $forum_id,

		'action'		=> $action,

		'redirect'		=> $redirect,

	);

	$success_msg = '';

	if (confirm_box(true))

	{

		if ($new_topic_type != POST_GLOBAL)

		{

			$sql = 'UPDATE ' . TOPICS_TABLE . "

				SET topic_type = $new_topic_type

				WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '

					AND forum_id <> 0';

			$db->sql_query($sql);

			// Reset forum id if a global topic is within the array

			$to_forum_id = request_var('to_forum_id', 0);

			if ($to_forum_id)

			{

				$sql = 'UPDATE ' . TOPICS_TABLE . "

					SET topic_type = $new_topic_type, forum_id = $to_forum_id

					WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '

						AND forum_id = 0';

				$db->sql_query($sql);

				// Update forum_ids for all posts

				$sql = 'UPDATE ' . POSTS_TABLE . "

					SET forum_id = $to_forum_id

					WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '

						AND forum_id = 0';

				$db->sql_query($sql);

				// Do a little forum sync stuff

				$sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts, COUNT(t.topic_approved) as topics_authed

					FROM ' . TOPICS_TABLE . ' t

					WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);

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

				$row_data = $db->sql_fetchrow($result);

				$db->sql_freeresult($result);

				$sync_sql = array();

				if ($row_data['topic_posts'])

				{

					$sync_sql[$to_forum_id][]	= 'forum_posts = forum_posts + ' . (int) $row_data['topic_posts'];

				}

				if ($row_data['topics_authed'])

				{

					$sync_sql[$to_forum_id][]	= 'forum_topics = forum_topics + ' . (int) $row_data['topics_authed'];

				}

				$sync_sql[$to_forum_id][]	= 'forum_topics_real = forum_topics_real + ' . (int) sizeof($topic_ids);

				foreach ($sync_sql as $forum_id_key => $array)

				{

					$sql = 'UPDATE ' . FORUMS_TABLE . '

						SET ' . implode(', ', $array) . '

						WHERE forum_id = ' . $forum_id_key;

					$db->sql_query($sql);

				}

				sync('forum', 'forum_id', $to_forum_id);

			}

		}

		else

		{

			// Get away with those topics already being a global announcement by re-calculating $topic_ids

			$sql = 'SELECT topic_id

				FROM ' . TOPICS_TABLE . '

				WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '

					AND forum_id <> 0';

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

			$topic_ids = array();

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

			{

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

			}

			$db->sql_freeresult($result);

			if (sizeof($topic_ids))

			{

				// Delete topic shadows for global announcements

				$sql = 'DELETE FROM ' . TOPICS_TABLE . '

					WHERE ' . $db->sql_in_set('topic_moved_id', $topic_ids);

				$db->sql_query($sql);

				$sql = 'UPDATE ' . TOPICS_TABLE . "

					SET topic_type = $new_topic_type, forum_id = 0

						WHERE " . $db->sql_in_set('topic_id', $topic_ids);

				$db->sql_query($sql);

				// Update forum_ids for all posts

				$sql = 'UPDATE ' . POSTS_TABLE . '

					SET forum_id = 0

					WHERE ' . $db->sql_in_set('topic_id', $topic_ids);

				$db->sql_query($sql);

				// Do a little forum sync stuff

				$sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts, COUNT(t.topic_approved) as topics_authed

					FROM ' . TOPICS_TABLE . ' t

					WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);

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

				$row_data = $db->sql_fetchrow($result);

				$db->sql_freeresult($result);

				$sync_sql = array();

				if ($row_data['topic_posts'])

				{

					$sync_sql[$forum_id][]	= 'forum_posts = forum_posts - ' . (int) $row_data['topic_posts'];

				}

				if ($row_data['topics_authed'])

				{

					$sync_sql[$forum_id][]	= 'forum_topics = forum_topics - ' . (int) $row_data['topics_authed'];

				}

				$sync_sql[$forum_id][]	= 'forum_topics_real = forum_topics_real - ' . (int) sizeof($topic_ids);

				foreach ($sync_sql as $forum_id_key => $array)

				{

					$sql = 'UPDATE ' . FORUMS_TABLE . '

						SET ' . implode(', ', $array) . '

						WHERE forum_id = ' . $forum_id_key;

					$db->sql_query($sql);

				}

				sync('forum', 'forum_id', $forum_id);

			}

		}

		$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_TYPE_CHANGED' : 'TOPICS_TYPE_CHANGED';

		if (sizeof($topic_ids))

		{

			$data = get_topic_data($topic_ids);

			foreach ($data as $topic_id => $row)

			{

				add_log('mod', $forum_id, $topic_id, 'LOG_TOPIC_TYPE_CHANGED', $row['topic_title']);

			}

		}

	}

	else

	{

		// Global topic involved?

		$global_involved = false;

		if ($new_topic_type != POST_GLOBAL)

		{

			$sql = 'SELECT forum_id

				FROM ' . TOPICS_TABLE . '

				WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '

					AND forum_id = 0';

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

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

			$db->sql_freeresult($result);

			if ($row)

			{

				$global_involved = true;

			}

		}

		if ($global_involved)

		{

			global $template;

			$template->assign_vars(array(

				'S_FORUM_SELECT'		=> make_forum_select(request_var('f', $forum_id), false, false, true, true),

				'S_CAN_LEAVE_SHADOW'	=> false,

				'ADDITIONAL_MSG'		=> (sizeof($topic_ids) == 1) ? $user->lang['SELECT_FORUM_GLOBAL_ANNOUNCEMENT'] : $user->lang['SELECT_FORUM_GLOBAL_ANNOUNCEMENTS'])

			);

			confirm_box(false, $l_new_type, build_hidden_fields($s_hidden_fields), 'mcp_move.html');

		}

		else

		{

			confirm_box(false, $l_new_type, build_hidden_fields($s_hidden_fields));

		}

	}

	$redirect = request_var('redirect', "index.$phpEx");

	$redirect = reapply_sid($redirect);

	if (!$success_msg)

	{

		redirect($redirect);

	}

	else

	{

		meta_refresh(2, $redirect);

		trigger_error($user->lang[$success_msg] . '

' . sprintf($user->lang['RETURN_PAGE'], '', ''));

	}

}

/**

* Move Topic

*/

function mcp_move_topic($topic_ids)

{

	global $auth, $user, $db, $template;

	global $phpEx, $phpbb_root_path;

	// Here we limit the operation to one forum only

	$forum_id = check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_move'), true);

	if ($forum_id === false)

	{

		return;

	}

	$to_forum_id = request_var('to_forum_id', 0);

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

	$additional_msg = $success_msg = '';

	$s_hidden_fields = build_hidden_fields(array(

		'topic_id_list'	=> $topic_ids,

		'f'				=> $forum_id,

		'action'		=> 'move',

		'redirect'		=> $redirect)

	);

	if ($to_forum_id)

	{

		$forum_data = get_forum_data($to_forum_id, 'f_post');

		if (!sizeof($forum_data))

		{

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

		}

		else

		{

			$forum_data = $forum_data[$to_forum_id];

			if ($forum_data['forum_type'] != FORUM_POST)

			{

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

			}

			else if (!$auth->acl_get('f_post', $to_forum_id))

			{

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

			}

			else if ($forum_id == $to_forum_id)

			{

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

			}

		}

	}

	else if (isset($_POST['confirm']))

	{

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

	}

	if (!$to_forum_id || $additional_msg)

	{

		unset($_POST['confirm']);

		unset($_REQUEST['confirm_key']);

	}

	if (confirm_box(true))

	{

		$topic_data = get_topic_data($topic_ids);

		$leave_shadow = (isset($_POST['move_leave_shadow'])) ? true : false;

		$topics_moved = sizeof($topic_ids);

		$topics_authed_moved = 0;

		$forum_sync_data = array();

		$forum_sync_data[$forum_id] = current($topic_data);

		$forum_sync_data[$to_forum_id] = $forum_data;

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

		{

			if ($topic_info['topic_approved'] == '1')

			{

				$topics_authed_moved++;

			}

		}

		$db->sql_transaction('begin');

		$sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts

			FROM ' . TOPICS_TABLE . ' t

			WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);

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

		$row_data = $db->sql_fetchrow($result);

		$db->sql_freeresult($result);

		$sync_sql = array();

		if ($row_data['topic_posts'])

		{

			$sync_sql[$forum_id][]		= 'forum_posts = forum_posts - ' . (int) $row_data['topic_posts'];

			$sync_sql[$to_forum_id][]	= 'forum_posts = forum_posts + ' . (int) $row_data['topic_posts'];

		}

		if ($topics_authed_moved)

		{

			$sync_sql[$to_forum_id][]	= 'forum_topics = forum_topics + ' . (int) $topics_authed_moved;

		}

		$sync_sql[$to_forum_id][]	= 'forum_topics_real = forum_topics_real + ' . (int) $topics_moved;

		// Move topics, but do not resync yet

		move_topics($topic_ids, $to_forum_id, false);

		$forum_ids = array($to_forum_id);

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

		{

			// Get the list of forums to resync, add a log entry

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

			add_log('mod', $to_forum_id, $topic_id, 'LOG_MOVE', $row['forum_name'], $forum_data['forum_name']);

			// If we have moved a global announcement, we need to correct the topic type

			if ($row['topic_type'] == POST_GLOBAL)

			{

				$sql = 'UPDATE ' . TOPICS_TABLE . '

					SET topic_type = ' . POST_ANNOUNCE . '

					WHERE topic_id = ' . (int) $row['topic_id'];

				$db->sql_query($sql);

			}

			// Leave a redirection if required and only if the topic is visible to users

			if ($leave_shadow && $row['topic_approved'] && $row['topic_type'] != POST_GLOBAL)

			{

				$shadow = array(

					'forum_id'				=>	(int) $row['forum_id'],

					'icon_id'				=>	(int) $row['icon_id'],

					'topic_attachment'		=>	(int) $row['topic_attachment'],

					'topic_approved'		=>	1, // a shadow topic is always approved

					'topic_reported'		=>	0, // a shadow topic is never reported

					'topic_title'			=>	(string) $row['topic_title'],

					'topic_poster'			=>	(int) $row['topic_poster'],

					'topic_time'			=>	(int) $row['topic_time'],

					'topic_time_limit'		=>	(int) $row['topic_time_limit'],

					'topic_views'			=>	(int) $row['topic_views'],

					'topic_replies'			=>	(int) $row['topic_replies'],

					'topic_replies_real'	=>	(int) $row['topic_replies_real'],

					'topic_status'			=>	ITEM_MOVED,

					'topic_type'			=>	POST_NORMAL,

					'topic_first_post_id'	=>	(int) $row['topic_first_post_id'],

					'topic_first_poster_colour'=>(string) $row['topic_first_poster_colour'],

					'topic_first_poster_name'=>	(string) $row['topic_first_poster_name'],

					'topic_last_post_id'	=>	(int) $row['topic_last_post_id'],

					'topic_last_poster_id'	=>	(int) $row['topic_last_poster_id'],

					'topic_last_poster_colour'=>(string) $row['topic_last_poster_colour'],

					'topic_last_poster_name'=>	(string) $row['topic_last_poster_name'],

					'topic_last_post_subject'=>	(string)  $row['topic_last_post_subject'],

					'topic_last_post_time'	=>	(int) $row['topic_last_post_time'],

					'topic_last_view_time'	=>	(int) $row['topic_last_view_time'],

					'topic_moved_id'		=>	(int) $row['topic_id'],

					'topic_bumped'			=>	(int) $row['topic_bumped'],

					'topic_bumper'			=>	(int) $row['topic_bumper'],

					'poll_title'			=>	(string) $row['poll_title'],

					'poll_start'			=>	(int) $row['poll_start'],

					'poll_length'			=>	(int) $row['poll_length'],

					'poll_max_options'		=>	(int) $row['poll_max_options'],

					'poll_last_vote'		=>	(int) $row['poll_last_vote']

				);

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

				$topics_authed_moved--;

				$topics_moved--;

			}

		}

		unset($topic_data);

		$sync_sql[$forum_id][]	= 'forum_topics_real = forum_topics_real - ' . (int) $topics_moved;

		if ($topics_authed_moved)

		{

			$sync_sql[$forum_id][]	= 'forum_topics = forum_topics - ' . (int) $topics_authed_moved;

		}

		$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_MOVED_SUCCESS' : 'TOPICS_MOVED_SUCCESS';

		foreach ($sync_sql as $forum_id_key => $array)

		{

			$sql = 'UPDATE ' . FORUMS_TABLE . '

				SET ' . implode(', ', $array) . '

				WHERE forum_id = ' . $forum_id_key;

			$db->sql_query($sql);

		}

		$db->sql_transaction('commit');