<?php
/**
*
* @package migration
* @copyright (c) 2012 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2
*
*/

class phpbb_db_migration_data_310_dev extends phpbb_db_migration
{
	public function effectively_installed()
	{
		return version_compare($this->config['version'], '3.1.0-dev', '>=');
	}

	static public function depends_on()
	{
		return array(
			'phpbb_db_migration_data_310_extensions',
			'phpbb_db_migration_data_310_style_update_p2',
			'phpbb_db_migration_data_310_timezone_p2',
			'phpbb_db_migration_data_310_reported_posts_display',
		);
	}

	public function update_schema()
	{
		return array(
			'add_columns'		=> array(
				$this->table_prefix . 'groups'		=> array(
					'group_teampage'	=> array('UINT', 0, 'after' => 'group_legend'),
				),
				$this->table_prefix . 'profile_fields'	=> array(
					'field_show_on_pm'		=> array('BOOL', 0),
				),
				$this->table_prefix . 'styles'		=> array(
					'style_path'			=> array('VCHAR:100', ''),
					'bbcode_bitfield'		=> array('VCHAR:255', 'kNg='),
					'style_parent_id'		=> array('UINT:4', 0),
					'style_parent_tree'		=> array('TEXT', ''),
				),
				$this->table_prefix . 'reports'		=> array(
					'reported_post_text'		=> array('MTEXT_UNI', ''),
					'reported_post_uid'			=> array('VCHAR:8', ''),
					'reported_post_bitfield'	=> array('VCHAR:255', ''),
				),
			),
			'change_columns'	=> array(
				$this->table_prefix . 'groups'		=> array(
					'group_legend'		=> array('UINT', 0),
				),
			),
		);
	}

	public function revert_schema()
	{
		return array(
			'drop_columns'		=> array(
				$this->table_prefix . 'groups'		=> array(
					'group_teampage',
				),
				$this->table_prefix . 'profile_fields'	=> array(
					'field_show_on_pm',
				),
				$this->table_prefix . 'styles'		=> array(
					'style_path',
					'bbcode_bitfield',
					'style_parent_id',
					'style_parent_tree',
				),
				$this->table_prefix . 'reports'		=> array(
					'reported_post_text',
					'reported_post_uid',
					'reported_post_bitfield',
				),
			),
		);
	}

	public function update_data()
	{
		return array(
			array('config.update', array('search_type', 'phpbb_search_' . $this->config['search_type'])),

			array('config.add', array('fulltext_postgres_ts_name', 'simple')),
			array('config.add', array('fulltext_postgres_min_word_len', 4)),
			array('config.add', array('fulltext_postgres_max_word_len', 254)),
			array('config.add', array('fulltext_sphinx_stopwords', 0)),
			array('config.add', array('fulltext_sphinx_indexer_mem_limit', 512)),

			array('config.add', array('load_jquery_cdn', 0)),
			array('config.add', array('load_jquery_url', '//ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js')),

			array('config.add', array('use_system_cron', 0)),

			array('config.add', array('legend_sort_groupname', 0)),
			array('config.add', array('teampage_forums', 1)),
			array('config.add', array('teampage_memberships', 1)),

			array('config.add', array('load_cpf_pm', 0)),

			array('config.add', array('display_last_subject', 1)),

			array('config.add', array('assets_version', 1)),

			array('config.add', array('site_home_url', '')),
			array('config.add', array('site_home_text', '')),

			array('permission.add', array('u_chgprofileinfo', true, 'u_sig')),

			array('module.add', array(
				'acp',
				'ACP_GROUPS',
				array(
					'module_basename'	=> 'acp_groups',
					'modes'				=> array('position'),
				),
			)),
			array('module.add', array(
				'acp',
				'ACP_ATTACHMENTS',
				array(
					'module_basename'	=> 'acp_attachments',
					'modes'				=> array('manage'),
				),
			)),
			array('module.add', array(
				'acp',
				'ACP_STYLE_MANAGEMENT',
				array(
					'module_basename'	=> 'acp_styles',
					'modes'				=> array('install', 'cache'),
				),
			)),
			array('module.add', array(
				'ucp',
				'UCP_PROFILE',
				array(
					'module_basename'	=> 'ucp_profile',
					'modes'				=> array('autologin_keys'),
				),
			)),
			// Module will be renamed later
			array('module.add', array(
				'acp',
				'ACP_CAT_STYLES',
				'ACP_LANGUAGE'
			)),

			array('module.remove', array(
				'acp',
				false,
				'ACP_TEMPLATES',
			)),
			array('module.remove', array(
				'acp',
				false,
				'ACP_THEMES',
			)),
			array('module.remove', array(
				'acp',
				false,
				'ACP_IMAGESETS',
			)),

			array('custom', array(array($this, 'rename_module_basenames'))),
			array('custom', array(array($this, 'rename_styles_module'))),
			array('custom', array(array($this, 'add_group_teampage'))),
			array('custom', array(array($this, 'update_group_legend'))),
			array('custom', array(array($this, 'localise_global_announcements'))),
			array('custom', array(array($this, 'update_ucp_pm_basename'))),
			array('custom', array(array($this, 'update_ucp_profile_auth'))),
			array('custom', array(array($this, 'move_customise_modules'))),

			array('config.update', array('version', '3.1.0-dev')),
		);
	}

	public function move_customise_modules()
	{
		// Move language management to new location in the Customise tab
		// First get language module id
		$sql = 'SELECT module_id FROM ' . MODULES_TABLE . "
			WHERE module_basename = 'acp_language'";
		$result = $this->db->sql_query($sql);
		$language_module_id = $this->db->sql_fetchfield('module_id');
		$this->db->sql_freeresult($result);
		// Next get language management module id of the one just created
		$sql = 'SELECT module_id FROM ' . MODULES_TABLE . "
			WHERE module_langname = 'ACP_LANGUAGE'";
		$result = $this->db->sql_query($sql);
		$language_management_module_id = $this->db->sql_fetchfield('module_id');
		$this->db->sql_freeresult($result);

		if (!class_exists('acp_modules'))
		{
			include($this->phpbb_root_path . 'includes/acp/acp_modules.' . $this->php_ext);
		}
		// acp_modules calls adm_back_link, which is undefined at this point
		if (!function_exists('adm_back_link'))
		{
			include($this->phpbb_root_path . 'includes/functions_acp.' . $this->php_ext);
		}
		$module_manager = new acp_modules();
		$module_manager->module_class = 'acp';
		$module_manager->move_module($language_module_id, $language_management_module_id);
	}

	public function update_ucp_pm_basename()
	{
		$sql = 'SELECT module_id, module_basename
			FROM ' . MODULES_TABLE . "
			WHERE module_basename <> 'ucp_pm' AND
				module_langname='UCP_PM'";
		$result = $this->db->sql_query_limit($sql, 1);

		if ($row = $this->db->sql_fetchrow($result))
		{
			// This update is still not applied. Applying it

			$sql = 'UPDATE ' . MODULES_TABLE . "
				SET module_basename = 'ucp_pm'
				WHERE  module_id = " . (int) $row['module_id'];

			$this->sql_query($sql);
		}
		$this->db->sql_freeresult($result);
	}

	public function update_ucp_profile_auth()
	{
		// Update the auth setting for the module
		$sql = 'UPDATE ' . MODULES_TABLE . "
			SET module_auth = 'acl_u_chgprofileinfo'
			WHERE module_class = 'ucp'
				AND module_basename = 'ucp_profile'
				AND module_mode = 'profile_info'";
		$this->sql_query($sql);
	}

	public function rename_styles_module()
	{
		// Rename styles module to Customise
		$sql = 'UPDATE ' . MODULES_TABLE . "
			SET module_langname = 'ACP_CAT_CUSTOMISE'
			WHERE module_langname = 'ACP_CAT_STYLES'";
		$this->sql_query($sql);
	}

	public function rename_module_basenames()
	{
		// rename all module basenames to full classname
		$sql = 'SELECT module_id, module_basename, module_class
			FROM ' . MODULES_TABLE;
		$result = $this->db->sql_query($sql);

		while ($row = $this->db->sql_fetchrow($result))
		{
			$module_id = (int) $row['module_id'];
			unset($row['module_id']);

			if (!empty($row['module_basename']) && !empty($row['module_class']))
			{
				// all the class names start with class name or with phpbb_ for auto loading
				if (strpos($row['module_basename'], $row['module_class'] . '_') !== 0 &&
					strpos($row['module_basename'], 'phpbb_') !== 0)
				{
					$row['module_basename'] = $row['module_class'] . '_' . $row['module_basename'];

					$sql_update = $this->db->sql_build_array('UPDATE', $row);

					$sql = 'UPDATE ' . MODULES_TABLE . '
						SET ' . $sql_update . '
						WHERE module_id = ' . $module_id;
					$this->sql_query($sql);
				}
			}
		}

		$this->db->sql_freeresult($result);
	}

	public function add_group_teampage()
	{
		$sql = 'UPDATE ' . GROUPS_TABLE . '
			SET group_teampage = 1
			WHERE group_type = ' . GROUP_SPECIAL . "
				AND group_name = 'ADMINISTRATORS'";
		$this->sql_query($sql);

		$sql = 'UPDATE ' . GROUPS_TABLE . '
			SET group_teampage = 2
			WHERE group_type = ' . GROUP_SPECIAL . "
				AND group_name = 'GLOBAL_MODERATORS'";
		$this->sql_query($sql);
	}

	public function update_group_legend()
	{
		$sql = 'SELECT group_id
			FROM ' . GROUPS_TABLE . '
			WHERE group_legend = 1
			ORDER BY group_name ASC';
		$result = $this->db->sql_query($sql);

		$next_legend = 1;
		while ($row = $this->db->sql_fetchrow($result))
		{
			$sql = 'UPDATE ' . GROUPS_TABLE . '
				SET group_legend = ' . $next_legend . '
				WHERE group_id = ' . (int) $row['group_id'];
			$this->sql_query($sql);

			$next_legend++;
		}
		$this->db->sql_freeresult($result);
	}

	public function localise_global_announcements()
	{
		// Localise Global Announcements
		$sql = 'SELECT topic_id, topic_approved, (topic_replies + 1) AS topic_posts, topic_last_post_id, topic_last_post_subject, topic_last_post_time, topic_last_poster_id, topic_last_poster_name, topic_last_poster_colour
			FROM ' . TOPICS_TABLE . '
			WHERE forum_id = 0
				AND topic_type = ' . POST_GLOBAL;
		$result = $this->db->sql_query($sql);

		$global_announcements = $update_lastpost_data = array();
		$update_lastpost_data['forum_last_post_time'] = 0;
		$update_forum_data = array(
			'forum_posts'		=> 0,
			'forum_topics'		=> 0,
			'forum_topics_real'	=> 0,
		);

		while ($row = $this->db->sql_fetchrow($result))
		{
			$global_announcements[] = (int) $row['topic_id'];

			$update_forum_data['forum_posts'] += (int) $row['topic_posts'];
			$update_forum_data['forum_topics_real']++;
			if ($row['topic_approved'])
			{
				$update_forum_data['forum_topics']++;
			}

			if ($update_lastpost_data['forum_last_post_time'] < $row['topic_last_post_time'])
			{
				$update_lastpost_data = array(
					'forum_last_post_id'		=> (int) $row['topic_last_post_id'],
					'forum_last_post_subject'	=> $row['topic_last_post_subject'],
					'forum_last_post_time'		=> (int) $row['topic_last_post_time'],
					'forum_last_poster_id'		=> (int) $row['topic_last_poster_id'],
					'forum_last_poster_name'	=> $row['topic_last_poster_name'],
					'forum_last_poster_colour'	=> $row['topic_last_poster_colour'],
				);
			}
		}
		$this->db->sql_freeresult($result);

		if (!empty($global_announcements))
		{
			// Update the post/topic-count for the forum and the last-post if needed
			$sql = 'SELECT forum_id
				FROM ' . FORUMS_TABLE . '
				WHERE forum_type = ' . FORUM_POST;
			$result = $this->db->sql_query_limit($sql, 1);
			$ga_forum_id = $this->db->sql_fetchfield('forum_id');
			$this->db->sql_freeresult($result);

			$sql = 'SELECT forum_last_post_time
				FROM ' . FORUMS_TABLE . '
				WHERE forum_id = ' . $ga_forum_id;
			$result = $this->db->sql_query($sql);
			$lastpost = (int) $this->db->sql_fetchfield('forum_last_post_time');
			$this->db->sql_freeresult($result);

			$sql_update = 'forum_posts = forum_posts + ' . $update_forum_data['forum_posts'] . ', ';
			$sql_update .= 'forum_topics_real = forum_topics_real + ' . $update_forum_data['forum_topics_real'] . ', ';
			$sql_update .= 'forum_topics = forum_topics + ' . $update_forum_data['forum_topics'];
			if ($lastpost < $update_lastpost_data['forum_last_post_time'])
			{
				$sql_update .= ', ' . $this->db->sql_build_array('UPDATE', $update_lastpost_data);
			}

			$sql = 'UPDATE ' . FORUMS_TABLE . '
				SET ' . $sql_update . '
				WHERE forum_id = ' . $ga_forum_id;
			$this->sql_query($sql);

			// Update some forum_ids
			$table_ary = array(TOPICS_TABLE, POSTS_TABLE, LOG_TABLE, DRAFTS_TABLE, TOPICS_TRACK_TABLE);
			foreach ($table_ary as $table)
			{
				$sql = "UPDATE $table
					SET forum_id = $ga_forum_id
					WHERE " . $this->db->sql_in_set('topic_id', $global_announcements);
				$this->sql_query($sql);
			}
			unset($table_ary);
		}
	}
}