phpBB

<?php

/**

*

* @package acp

* @version $Id$

* @copyright (c) 2005 phpBB Group

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

*

*/

/**

* @ignore

*/

if (!defined('IN_PHPBB'))

{

	exit;

}

/**

* @package acp

*/

class acp_forums

{

	var $u_action;

	var $parent_id = 0;

	function main($id, $mode)

	{

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

		global $config, $phpbb_admin_path, $phpbb_root_path, $phpEx;

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

		$this->tpl_name = 'acp_forums';

		$this->page_title = 'ACP_MANAGE_FORUMS';

		$form_key = 'acp_forums';

		add_form_key($form_key);

		$action		= request_var('action', '');

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

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

		$this->parent_id	= request_var('parent_id', 0);

		$forum_data = $errors = array();

		if ($update && !check_form_key($form_key))

		{

			$update = false;

			$errors[] = $user->lang['FORM_INVALID'];

		}

		// Check additional permissions

		switch ($action)

		{

			case 'progress_bar':

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

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

				$this->display_progress_bar($start, $total);

				exit;

			break;

			case 'delete':

				if (!$auth->acl_get('a_forumdel'))

				{

					trigger_error($user->lang['NO_PERMISSION_FORUM_DELETE'] . adm_back_link($this->u_action . '&parent_id=' . $this->parent_id), E_USER_WARNING);

				}

			break;

			case 'add':

				if (!$auth->acl_get('a_forumadd'))

				{

					trigger_error($user->lang['NO_PERMISSION_FORUM_ADD'] . adm_back_link($this->u_action . '&parent_id=' . $this->parent_id), E_USER_WARNING);

				}

			break;

		}

		// Major routines

		if ($update)

		{

			switch ($action)

			{

				case 'delete':

					$action_subforums	= request_var('action_subforums', '');

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

					$action_posts		= request_var('action_posts', '');

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

					$errors = $this->delete_forum($forum_id, $action_posts, $action_subforums, $posts_to_id, $subforums_to_id);

					if (sizeof($errors))

					{

						break;

					}

					$auth->acl_clear_prefetch();

					$cache->destroy('sql', FORUMS_TABLE);

					trigger_error($user->lang['FORUM_DELETED'] . adm_back_link($this->u_action . '&parent_id=' . $this->parent_id));

				break;

				case 'edit':

					$forum_data = array(

						'forum_id'		=>	$forum_id

					);

				// No break here

				case 'add':

					$forum_data += array(

						'parent_id'				=> request_var('forum_parent_id', $this->parent_id),

						'forum_type'			=> request_var('forum_type', FORUM_POST),

						'type_action'			=> request_var('type_action', ''),

						'forum_status'			=> request_var('forum_status', ITEM_UNLOCKED),

						'forum_parents'			=> '',

						'forum_name'			=> utf8_normalize_nfc(request_var('forum_name', '', true)),

						'forum_link'			=> request_var('forum_link', ''),

						'forum_link_track'		=> request_var('forum_link_track', false),

						'forum_desc'			=> utf8_normalize_nfc(request_var('forum_desc', '', true)),

						'forum_desc_uid'		=> '',

						'forum_desc_options'	=> 7,

						'forum_desc_bitfield'	=> '',

						'forum_rules'			=> utf8_normalize_nfc(request_var('forum_rules', '', true)),

						'forum_rules_uid'		=> '',

						'forum_rules_options'	=> 7,

						'forum_rules_bitfield'	=> '',

						'forum_rules_link'		=> request_var('forum_rules_link', ''),

						'forum_image'			=> request_var('forum_image', ''),

						'forum_style'			=> request_var('forum_style', 0),

						'display_subforum_list'	=> request_var('display_subforum_list', false),

						'display_on_index'		=> request_var('display_on_index', false),

						'forum_topics_per_page'	=> request_var('topics_per_page', 0),

						'enable_indexing'		=> request_var('enable_indexing', true),

						'enable_icons'			=> request_var('enable_icons', false),

						'enable_prune'			=> request_var('enable_prune', false),

						'enable_post_review'	=> request_var('enable_post_review', true),

						'prune_days'			=> request_var('prune_days', 7),

						'prune_viewed'			=> request_var('prune_viewed', 7),

						'prune_freq'			=> request_var('prune_freq', 1),

						'prune_old_polls'		=> request_var('prune_old_polls', false),

						'prune_announce'		=> request_var('prune_announce', false),

						'prune_sticky'			=> request_var('prune_sticky', false),

						'forum_password'		=> request_var('forum_password', '', true),

						'forum_password_confirm'=> request_var('forum_password_confirm', '', true),

						'forum_password_unset'	=> request_var('forum_password_unset', false),

					);

					// Use link_display_on_index setting if forum type is link

					if ($forum_data['forum_type'] == FORUM_LINK)

					{

						$forum_data['display_on_index'] = request_var('link_display_on_index', false);

					}

					// Linked forums and categories are not able to be locked...

					if ($forum_data['forum_type'] == FORUM_LINK || $forum_data['forum_type'] == FORUM_CAT)

					{

						$forum_data['forum_status'] = ITEM_UNLOCKED;

					}

					$forum_data['show_active'] = ($forum_data['forum_type'] == FORUM_POST) ? request_var('display_recent', false) : request_var('display_active', false);

					// Get data for forum rules if specified...

					if ($forum_data['forum_rules'])

					{

						generate_text_for_storage($forum_data['forum_rules'], $forum_data['forum_rules_uid'], $forum_data['forum_rules_bitfield'], $forum_data['forum_rules_options'], request_var('rules_parse_bbcode', false), request_var('rules_parse_urls', false), request_var('rules_parse_smilies', false));

					}

					// Get data for forum description if specified

					if ($forum_data['forum_desc'])

					{

						generate_text_for_storage($forum_data['forum_desc'], $forum_data['forum_desc_uid'], $forum_data['forum_desc_bitfield'], $forum_data['forum_desc_options'], request_var('desc_parse_bbcode', false), request_var('desc_parse_urls', false), request_var('desc_parse_smilies', false));

					}

					$errors = $this->update_forum_data($forum_data);

					if (!sizeof($errors))

					{

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

						// Copy permissions?

						if ($forum_perm_from && !empty($forum_perm_from) && $forum_perm_from != $forum_data['forum_id'] &&

							(($action != 'edit') || empty($forum_id) || ($auth->acl_get('a_fauth') && $auth->acl_get('a_authusers') && $auth->acl_get('a_authgroups') && $auth->acl_get('a_mauth'))))

						{

							// if we edit a forum delete current permissions first

							if ($action == 'edit')

							{

								$sql = 'DELETE FROM ' . ACL_USERS_TABLE . '

									WHERE forum_id = ' . (int) $forum_data['forum_id'];

								$db->sql_query($sql);

								$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '

									WHERE forum_id = ' . (int) $forum_data['forum_id'];

								$db->sql_query($sql);

							}

							// From the mysql documentation:

							// Prior to MySQL 4.0.14, the target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query. This limitation is lifted in 4.0.14.

							// Due to this we stay on the safe side if we do the insertion "the manual way"

							// Copy permisisons from/to the acl users table (only forum_id gets changed)

							$sql = 'SELECT user_id, auth_option_id, auth_role_id, auth_setting

								FROM ' . ACL_USERS_TABLE . '

								WHERE forum_id = ' . $forum_perm_from;

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

							$users_sql_ary = array();

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

							{

								$users_sql_ary[] = array(

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

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

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

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

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

								);

							}

							$db->sql_freeresult($result);

							// Copy permisisons from/to the acl groups table (only forum_id gets changed)

							$sql = 'SELECT group_id, auth_option_id, auth_role_id, auth_setting

								FROM ' . ACL_GROUPS_TABLE . '

								WHERE forum_id = ' . $forum_perm_from;

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

							$groups_sql_ary = array();

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

							{

								$groups_sql_ary[] = array(

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

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

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

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

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

								);

							}

							$db->sql_freeresult($result);

							// Now insert the data

							$db->sql_multi_insert(ACL_USERS_TABLE, $users_sql_ary);

							$db->sql_multi_insert(ACL_GROUPS_TABLE, $groups_sql_ary);

							cache_moderators();

						}

						$auth->acl_clear_prefetch();

						$cache->destroy('sql', FORUMS_TABLE);

						$acl_url = '&mode=setting_forum_local&forum_id[]=' . $forum_data['forum_id'];

						$message = ($action == 'add') ? $user->lang['FORUM_CREATED'] : $user->lang['FORUM_UPDATED'];

						// Redirect to permissions

						if ($auth->acl_get('a_fauth'))

						{

							$message .= '<br /><br />' . sprintf($user->lang['REDIRECT_ACL'], '<a href="' . append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions' . $acl_url) . '">', '</a>');

						}

						// redirect directly to permission settings screen if authed

						if ($action == 'add' && !$forum_perm_from && $auth->acl_get('a_fauth'))

						{

							meta_refresh(4, append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions' . $acl_url));

						}

						trigger_error($message . adm_back_link($this->u_action . '&parent_id=' . $this->parent_id));

					}

				break;

			}

		}

		switch ($action)

		{

			case 'move_up':

			case 'move_down':

				if (!$forum_id)

				{

					trigger_error($user->lang['NO_FORUM'] . adm_back_link($this->u_action . '&parent_id=' . $this->parent_id), E_USER_WARNING);

				}

				$sql = 'SELECT *

					FROM ' . FORUMS_TABLE . "

					WHERE forum_id = $forum_id";

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

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

				$db->sql_freeresult($result);

				if (!$row)

				{

					trigger_error($user->lang['NO_FORUM'] . adm_back_link($this->u_action . '&parent_id=' . $this->parent_id), E_USER_WARNING);

				}

				$move_forum_name = $this->move_forum_by($row, $action, 1);

				if ($move_forum_name !== false)

				{

					add_log('admin', 'LOG_FORUM_' . strtoupper($action), $row['forum_name'], $move_forum_name);

					$cache->destroy('sql', FORUMS_TABLE);

				}

			break;

			case 'sync':

				if (!$forum_id)

				{

					trigger_error($user->lang['NO_FORUM'] . adm_back_link($this->u_action . '&parent_id=' . $this->parent_id), E_USER_WARNING);

				}

				@set_time_limit(0);

				$sql = 'SELECT forum_name, forum_topics_real

					FROM ' . FORUMS_TABLE . "

					WHERE forum_id = $forum_id";

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

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

				$db->sql_freeresult($result);

				if (!$row)

				{

					trigger_error($user->lang['NO_FORUM'] . adm_back_link($this->u_action . '&parent_id=' . $this->parent_id), E_USER_WARNING);

				}

				if ($row['forum_topics_real'])

				{

					$sql = 'SELECT MIN(topic_id) as min_topic_id, MAX(topic_id) as max_topic_id

						FROM ' . TOPICS_TABLE . '

						WHERE forum_id = ' . $forum_id;

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

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

					$db->sql_freeresult($result);

					// Typecast to int if there is no data available

					$row2['min_topic_id'] = (int) $row2['min_topic_id'];

					$row2['max_topic_id'] = (int) $row2['max_topic_id'];

					$start = request_var('start', $row2['min_topic_id']);

					$batch_size = 2000;

					$end = $start + $batch_size;

					// Sync all topics in batch mode...

					sync('topic_approved', 'range', 'topic_id BETWEEN ' . $start . ' AND ' . $end, true, false);

					sync('topic', 'range', 'topic_id BETWEEN ' . $start . ' AND ' . $end, true, true);

					if ($end < $row2['max_topic_id'])

					{

						// We really need to find a way of showing statistics... no progress here

						$sql = 'SELECT COUNT(topic_id) as num_topics

							FROM ' . TOPICS_TABLE . '

							WHERE forum_id = ' . $forum_id . '

								AND topic_id BETWEEN ' . $start . ' AND ' . $end;

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

						$topics_done = request_var('topics_done', 0) + (int) $db->sql_fetchfield('num_topics');

						$db->sql_freeresult($result);

						$start += $batch_size;

						$url = $this->u_action . "&parent_id={$this->parent_id}&f=$forum_id&action=sync&start=$start&topics_done=$topics_done&total={$row['forum_topics_real']}";

						meta_refresh(0, $url);

						$template->assign_vars(array(

							'U_PROGRESS_BAR'		=> $this->u_action . "&action=progress_bar&start=$topics_done&total={$row['forum_topics_real']}",

							'UA_PROGRESS_BAR'		=> addslashes($this->u_action . "&action=progress_bar&start=$topics_done&total={$row['forum_topics_real']}"),

							'S_CONTINUE_SYNC'		=> true,

							'L_PROGRESS_EXPLAIN'	=> sprintf($user->lang['SYNC_IN_PROGRESS_EXPLAIN'], $topics_done, $row['forum_topics_real']))

						);

						return;

					}

				}

				$url = $this->u_action . "&parent_id={$this->parent_id}&f=$forum_id&action=sync_forum";

				meta_refresh(0, $url);

				$template->assign_vars(array(

					'U_PROGRESS_BAR'		=> $this->u_action . '&action=progress_bar',

					'UA_PROGRESS_BAR'		=> addslashes($this->u_action . '&action=progress_bar'),

					'S_CONTINUE_SYNC'		=> true,

					'L_PROGRESS_EXPLAIN'	=> sprintf($user->lang['SYNC_IN_PROGRESS_EXPLAIN'], 0, $row['forum_topics_real']))

				);

				return;

			break;

			case 'sync_forum':

				$sql = 'SELECT forum_name, forum_type

					FROM ' . FORUMS_TABLE . "

					WHERE forum_id = $forum_id";

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

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

				$db->sql_freeresult($result);

				if (!$row)

				{

					trigger_error($user->lang['NO_FORUM'] . adm_back_link($this->u_action . '&parent_id=' . $this->parent_id), E_USER_WARNING);

				}

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

				add_log('admin', 'LOG_FORUM_SYNC', $row['forum_name']);

				$cache->destroy('sql', FORUMS_TABLE);

				$template->assign_var('L_FORUM_RESYNCED', sprintf($user->lang['FORUM_RESYNCED'], $row['forum_name']));

			break;

			case 'add':

			case 'edit':

				if ($update)

				{

					$forum_data['forum_flags'] = 0;

					$forum_data['forum_flags'] += (request_var('forum_link_track', false)) ? FORUM_FLAG_LINK_TRACK : 0;

					$forum_data['forum_flags'] += (request_var('prune_old_polls', false)) ? FORUM_FLAG_PRUNE_POLL : 0;

					$forum_data['forum_flags'] += (request_var('prune_announce', false)) ? FORUM_FLAG_PRUNE_ANNOUNCE : 0;

					$forum_data['forum_flags'] += (request_var('prune_sticky', false)) ? FORUM_FLAG_PRUNE_STICKY : 0;

					$forum_data['forum_flags'] += ($forum_data['show_active']) ? FORUM_FLAG_ACTIVE_TOPICS : 0;

					$forum_data['forum_flags'] += (request_var('enable_post_review', true)) ? FORUM_FLAG_POST_REVIEW : 0;

				}