+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_310_avatars extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return isset($this->config['allow_avatar_gravatar']);

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

+ $this->table_prefix . 'users' => array(

+ 'user_avatar_type' => array('VCHAR:255', ''),

+ ),

+ $this->table_prefix . 'groups' => array(

+ 'group_avatar_type' => array('VCHAR:255', ''),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'change_columns' => array(

+ $this->table_prefix . 'users' => array(

+ 'user_avatar_type' => array('TINT:2', ''),

+ ),

+ $this->table_prefix . 'groups' => array(

+ 'group_avatar_type' => array('TINT:2', ''),

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('allow_avatar_gravatar', 0)),

+ array('custom', array(array($this, 'update_module_auth'))),

+ );

+ }

+

+ public function update_module_auth()

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . "modules

+ SET module_auth = 'cfg_allow_avatar'

+ WHERE module_class = 'ucp'

+ AND module_basename = 'ucp_profile'

+ AND module_mode = 'avatar'";

+ $this->db->sql_query($sql);

+ }

+}

+<?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);

+ }

+ }

+}

+<?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_extensions extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_table_exists($this->table_prefix . 'ext');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_tables' => array(

+ $this->table_prefix . 'ext' => array(

+ 'COLUMNS' => array(

+ 'ext_name' => array('VCHAR', ''),

+ 'ext_active' => array('BOOL', 0),

+ 'ext_state' => array('TEXT', ''),

+ ),

+ 'KEYS' => array(

+ 'ext_name' => array('UNIQUE', 'ext_name'),

+ ),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'ext',

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ // Module will be renamed later

+ array('module.add', array(

+ 'acp',

+ 'ACP_CAT_STYLES',

+ 'ACP_EXTENSION_MANAGEMENT'

+ )),

+ array('module.add', array(

+ 'acp',

+ 'ACP_EXTENSION_MANAGEMENT',

+ array(

+ 'module_basename' => 'acp_extensions',

+ 'modes' => array('main'),

+ ),

+ )),

+ array('permission.add', array('a_extensions', true, 'a_styles')),

+ );

+ }

+}

+<?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_notifications extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_table_exists($this->table_prefix . 'notifications');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_310_dev');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_tables' => array(

+ $this->table_prefix . 'notification_types' => array(

+ 'COLUMNS' => array(

+ 'notification_type' => array('VCHAR:255', ''),

+ 'notification_type_enabled' => array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => array('notification_type', 'notification_type_enabled'),

+ ),

+ $this->table_prefix . 'notifications' => array(

+ 'COLUMNS' => array(

+ 'notification_id' => array('UINT', NULL, 'auto_increment'),

+ 'item_type' => array('VCHAR:255', ''),

+ 'item_id' => array('UINT', 0),

+ 'item_parent_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'notification_read' => array('BOOL', 0),

+ 'notification_time' => array('TIMESTAMP', 1),

+ 'notification_data' => array('TEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'notification_id',

+ 'KEYS' => array(

+ 'item_ident' => array('INDEX', array('item_type', 'item_id')),

+ 'user' => array('INDEX', array('user_id', 'notification_read')),

+ ),

+ ),

+ $this->table_prefix . 'user_notifications' => array(

+ 'COLUMNS' => array(

+ 'item_type' => array('VCHAR:255', ''),

+ 'item_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'method' => array('VCHAR:255', ''),

+ 'notify' => array('BOOL', 1),

+ ),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'notification_types',

+ $this->table_prefix . 'notifications',

+ $this->table_prefix . 'user_notifications',

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('module.add', array(

+ 'ucp',

+ 'UCP_MAIN',

+ array(

+ 'module_basename' => 'ucp_notifications',

+ 'modes' => array('notification_list'),

+ ),

+ )),

+ array('module.add', array(

+ 'ucp',

+ 'UCP_PREFS',

+ array(

+ 'module_basename' => 'ucp_notifications',

+ 'modes' => array('notification_options'),

+ ),

+ )),

+ array('config.add', array('load_notifications', 1)),

+ array('custom', array(array($this, 'convert_notifications'))),

+ );

+ }

+

+ public function convert_notifications()

+ {

+ $convert_notifications = array(

+ array(

+ 'check' => ($this->config['allow_topic_notify']),

+ 'item_type' => 'post',

+ ),

+ array(

+ 'check' => ($this->config['allow_forum_notify']),

+ 'item_type' => 'topic',

+ ),

+ array(

+ 'check' => ($this->config['allow_bookmarks']),

+ 'item_type' => 'bookmark',

+ ),

+ array(

+ 'check' => ($this->config['allow_privmsg']),

+ 'item_type' => 'pm',

+ ),

+ );

+

+ foreach ($convert_notifications as $convert_data)

+ {

+ if ($convert_data['check'])

+ {

+ $sql = 'SELECT user_id, user_notify_type

+ FROM ' . USERS_TABLE . '

+ WHERE user_notify = 1';

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

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

+ {

+ $this->sql_query('INSERT INTO ' . $this->table_prefix . 'user_notifications ' . $this->db->sql_build_array('INSERT', array(

+ 'item_type' => $convert_data['item_type'],

+ 'item_id' => 0,

+ 'user_id' => $row['user_id'],

+ 'method' => '',

+ )));

+

+ if ($row['user_notify_type'] == NOTIFY_EMAIL || $row['user_notify_type'] == NOTIFY_BOTH)

+ {

+ $this->sql_query('INSERT INTO ' . $this->table_prefix . 'user_notifications ' . $this->db->sql_build_array('INSERT', array(

+ 'item_type' => $convert_data['item_type'],

+ 'item_id' => 0,

+ 'user_id' => $row['user_id'],

+ 'method' => 'email',

+ )));

+ }

+

+ if ($row['user_notify_type'] == NOTIFY_IM || $row['user_notify_type'] == NOTIFY_BOTH)

+ {

+ $this->sql_query('INSERT INTO ' . $this->table_prefix . 'user_notifications ' . $this->db->sql_build_array('INSERT', array(

+ 'item_type' => $convert_data['item_type'],

+ 'item_id' => 0,

+ 'user_id' => $row['user_id'],

+ 'method' => 'jabber',

+ )));

+ }

+ }

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

+ }

+ }

+ }

+}

+<?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_reported_posts_display extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_column_exists($this->table_prefix . 'reports', 'reported_post_enable_bbcode');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

+ $this->table_prefix . 'reports' => array(

+ 'reported_post_enable_bbcode' => array('BOOL', 1),

+ 'reported_post_enable_smilies' => array('BOOL', 1),

+ 'reported_post_enable_magic_url' => array('BOOL', 1),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ $this->table_prefix . 'reports' => array(

+ 'reported_post_enable_bbcode',

+ 'reported_post_enable_smilies',

+ 'reported_post_enable_magic_url',

+ ),

+ ),

+ );

+ }

+}

+<?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_style_update_p1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_table_exists($this->table_prefix . 'styles_imageset');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array($this, 'styles_update'))),

+ );

+ }

+

+ public function styles_update()

+ {

+ // Get list of valid 3.1 styles

+ $available_styles = array('prosilver');

+

+ $iterator = new DirectoryIterator($this->phpbb_root_path . 'styles');

+ $skip_dirs = array('.', '..', 'prosilver');

+ foreach ($iterator as $fileinfo)

+ {

+ if ($fileinfo->isDir() && !in_array($fileinfo->getFilename(), $skip_dirs) && file_exists($fileinfo->getPathname() . '/style.cfg'))

+ {

+ $style_cfg = parse_cfg_file($fileinfo->getPathname() . '/style.cfg');

+ if (isset($style_cfg['phpbb_version']) && version_compare($style_cfg['phpbb_version'], '3.1.0-dev', '>='))

+ {

+ // 3.1 style

+ $available_styles[] = $fileinfo->getFilename();

+ }

+ }

+ }

+

+ // Get all installed styles

+ if ($this->db_tools->sql_table_exists($this->table_prefix . 'styles_imageset'))

+ {

+ $sql = 'SELECT s.style_id, t.template_path, t.template_id, t.bbcode_bitfield, t.template_inherits_id, t.template_inherit_path, c.theme_path, c.theme_id, i.imageset_path

+ FROM ' . STYLES_TABLE . ' s, ' . $this->table_prefix . 'styles_template t, ' . $this->table_prefix . 'styles_theme c, ' . $this->table_prefix . "styles_imageset i

+ WHERE t.template_id = s.template_id

+ AND c.theme_id = s.theme_id

+ AND i.imageset_id = s.imageset_id";

+ }

+ else

+ {

+ $sql = 'SELECT s.style_id, t.template_path, t.template_id, t.bbcode_bitfield, t.template_inherits_id, t.template_inherit_path, c.theme_path, c.theme_id

+ FROM ' . STYLES_TABLE . ' s, ' . $this->table_prefix . 'styles_template t, ' . $this->table_prefix . "stles_theme c

+ WHERE t.template_id = s.template_id

+ AND c.theme_id = s.theme_id";

+ }

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

+

+ $styles = array();

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

+ {

+ $styles[] = $row;

+ }

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

+

+ // Decide which styles to keep, all others will be deleted

+ $valid_styles = array();

+ foreach ($styles as $style_row)

+ {

+ if (

+ // Delete styles with parent style (not supported yet)

+ $style_row['template_inherits_id'] == 0 &&

+ // Check if components match

+ $style_row['template_path'] == $style_row['theme_path'] && (!isset($style_row['imageset_path']) || $style_row['template_path'] == $style_row['imageset_path']) &&

+ // Check if components are valid

+ in_array($style_row['template_path'], $available_styles)

+ )

+ {

+ // Valid style. Keep it

+ $sql_ary = array(

+ 'style_path' => $style_row['template_path'],

+ 'bbcode_bitfield' => $style_row['bbcode_bitfield'],

+ 'style_parent_id' => 0,

+ 'style_parent_tree' => '',

+ );

+ $this->sql_query('UPDATE ' . STYLES_TABLE . '

+ SET ' . $this->db->sql_build_array('UPDATE', $sql_ary) . '

+ WHERE style_id = ' . $style_row['style_id']);

+ $valid_styles[] = (int) $style_row['style_id'];

+ }

+ }

+

+ // Remove old entries from styles table

+ if (!sizeof($valid_styles))

+ {

+ // No valid styles: remove everything and add prosilver

+ $this->sql_query('DELETE FROM ' . STYLES_TABLE, $errored, $error_ary);

+

+ $sql_ary = array(

+ 'style_name' => 'prosilver',

+ 'style_copyright' => '&copy; phpBB Group',

+ 'style_active' => 1,

+ 'style_path' => 'prosilver',

+ 'bbcode_bitfield' => 'lNg=',

+ 'style_parent_id' => 0,

+ 'style_parent_tree' => '',

+

+ // Will be removed in the next step

+ 'imageset_id' => 0,

+ 'template_id' => 0,

+ 'theme_id' => 0,

+ );

+

+ $sql = 'INSERT INTO ' . STYLES_TABLE . ' ' . $this->db->sql_build_array('INSERT', $sql_ary);

+ $this->sql_query($sql);

+

+ $sql = 'SELECT style_id

+ FROM ' . $table . "

+ WHERE style_name = 'prosilver'";

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

+ $default_style = $this->db->sql_fetchfield($result);

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

+

+ set_config('default_style', $default_style);

+

+ $sql = 'UPDATE ' . USERS_TABLE . ' SET user_style = 0';

+ $this->sql_query($sql);

+ }

+ else

+ {

+ // There are valid styles in styles table. Remove styles that are outdated

+ $this->sql_query('DELETE FROM ' . STYLES_TABLE . '

+ WHERE ' . $this->db->sql_in_set('style_id', $valid_styles, true));

+

+ // Change default style

+ if (!in_array($this->config['default_style'], $valid_styles))

+ {

+ $this->sql_query('UPDATE ' . CONFIG_TABLE . "

+ SET config_value = '" . $valid_styles[0] . "'

+ WHERE config_name = 'default_style'");

+ }

+

+ // Reset styles for users

+ $this->sql_query('UPDATE ' . USERS_TABLE . '

+ SET user_style = 0

+ WHERE ' . $this->db->sql_in_set('user_style', $valid_styles, true));

+ }

+ }

+}

+<?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_style_update_p2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_table_exists($this->table_prefix . 'styles_imageset');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_310_style_update_p1');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ $this->table_prefix . 'styles' => array(

+ 'imageset_id',

+ 'template_id',

+ 'theme_id',

+ ),

+ ),

+

+ 'drop_tables' => array(

+ $this->table_prefix . 'styles_imageset',

+ $this->table_prefix . 'styles_imageset_data',

+ $this->table_prefix . 'styles_template',

+ $this->table_prefix . 'styles_template_data',

+ $this->table_prefix . 'styles_theme',

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

+ $this->table_prefix . 'styles' => array(

+ 'imageset_id' => array('UINT', 0),

+ 'template_id' => array('UINT', 0),

+ 'theme_id' => array('UINT', 0),

+ ),

+ ),

+

+ 'add_tables' => array(

+ $this->table_prefix . 'styles_imageset' => array(

+ 'COLUMNS' => array(

+ 'imageset_id' => array('UINT', NULL, 'auto_increment'),

+ 'imageset_name' => array('VCHAR_UNI:255', ''),

+ 'imageset_copyright' => array('VCHAR_UNI', ''),

+ 'imageset_path' => array('VCHAR:100', ''),

+ ),

+ 'PRIMARY_KEY' => 'imageset_id',

+ 'KEYS' => array(

+ 'imgset_nm' => array('UNIQUE', 'imageset_name'),

+ ),

+ ),

+ $this->table_prefix . 'styles_imageset_data' => array(

+ 'COLUMNS' => array(

+ 'image_id' => array('UINT', NULL, 'auto_increment'),

+ 'image_name' => array('VCHAR:200', ''),

+ 'image_filename' => array('VCHAR:200', ''),

+ 'image_lang' => array('VCHAR:30', ''),

+ 'image_height' => array('USINT', 0),

+ 'image_width' => array('USINT', 0),

+ 'imageset_id' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'image_id',

+ 'KEYS' => array(

+ 'i_d' => array('INDEX', 'imageset_id'),

+ ),

+ ),

+ $this->table_prefix . 'styles_template' => array(

+ 'COLUMNS' => array(

+ 'template_id' => array('UINT', NULL, 'auto_increment'),

+ 'template_name' => array('VCHAR_UNI:255', ''),

+ 'template_copyright' => array('VCHAR_UNI', ''),

+ 'template_path' => array('VCHAR:100', ''),

+ 'bbcode_bitfield' => array('VCHAR:255', 'kNg='),

+ 'template_storedb' => array('BOOL', 0),

+ 'template_inherits_id' => array('UINT:4', 0),

+ 'template_inherit_path' => array('VCHAR', ''),

+ ),

+ 'PRIMARY_KEY' => 'template_id',

+ 'KEYS' => array(

+ 'tmplte_nm' => array('UNIQUE', 'template_name'),

+ ),

+ ),

+ $this->table_prefix . 'styles_template_data' => array(

+ 'COLUMNS' => array(

+ 'template_id' => array('UINT', 0),

+ 'template_filename' => array('VCHAR:100', ''),

+ 'template_included' => array('TEXT', ''),

+ 'template_mtime' => array('TIMESTAMP', 0),

+ 'template_data' => array('MTEXT_UNI', ''),

+ ),

+ 'KEYS' => array(

+ 'tid' => array('INDEX', 'template_id'),

+ 'tfn' => array('INDEX', 'template_filename'),

+ ),

+ ),

+ $this->table_prefix . 'styles_theme' => array(

+ 'COLUMNS' => array(

+ 'theme_id' => array('UINT', NULL, 'auto_increment'),

+ 'theme_name' => array('VCHAR_UNI:255', ''),

+ 'theme_copyright' => array('VCHAR_UNI', ''),

+ 'theme_path' => array('VCHAR:100', ''),

+ 'theme_storedb' => array('BOOL', 0),

+ 'theme_mtime' => array('TIMESTAMP', 0),

+ 'theme_data' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'theme_id',

+ 'KEYS' => array(

+ 'theme_name' => array('UNIQUE', 'theme_name'),

+ ),

+ ),

+ ),

+ );

+ }

+}

+<?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_teampage extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_table_exists($this->table_prefix . 'teampage');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_310_dev');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_tables' => array(

+ $this->table_prefix . 'teampage' => array(

+ 'COLUMNS' => array(

+ 'teampage_id' => array('UINT', NULL, 'auto_increment'),

+ 'group_id' => array('UINT', 0),

+ 'teampage_name' => array('VCHAR_UNI:255', ''),

+ 'teampage_position' => array('UINT', 0),

+ 'teampage_parent' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'teampage_id',

+ ),

+ ),

+ 'drop_columns' => array(

+ $this->table_prefix . 'groups' => array(

+ 'group_teampage',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'teampage',

+ ),

+ 'add_columns' => array(

+ $this->table_prefix . 'groups' => array(

+ 'group_teampage' => array('UINT', 0, 'after' => 'group_legend'),

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array($this, 'add_groups_teampage'))),

+ );

+ }

+

+ public function add_groups_teampage()

+ {

+ $sql = 'SELECT teampage_id

+ FROM ' . TEAMPAGE_TABLE;

+ $result = $this->db->sql_query_limit($sql, 1);

+ $added_groups_teampage = (bool) $this->db->sql_fetchfield('teampage_id');

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

+

+ if (!$added_groups_teampage)

+ {

+ $sql = 'SELECT *

+ FROM ' . GROUPS_TABLE . '

+ WHERE group_type = ' . GROUP_SPECIAL . "

+ AND (group_name = 'ADMINISTRATORS'

+ OR group_name = 'GLOBAL_MODERATORS')

+ ORDER BY group_name ASC";

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

+

+ $teampage_entries = array();

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

+ {

+ $teampage_entries[] = array(

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

+ 'teampage_name' => '',

+ 'teampage_position' => sizeof($teampage_entries) + 1,

+ 'teampage_parent' => 0,

+ );

+ }

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

+

+ if (sizeof($teampage_entries))

+ {

+ $this->db->sql_multi_insert(TEAMPAGE_TABLE, $teampage_entries);

+ }

+ unset($teampage_entries);

+ }

+

+ }

+}

+<?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_timezone extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_dst');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

+ $this->table_prefix . 'users' => array(

+ 'user_timezone' => array('VCHAR:100', ''),

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array($this, 'update_timezones'))),

+ );

+ }

+

+ public function update_timezones()

+ {

+ // Update user timezones

+ $sql = 'SELECT user_dst, user_timezone

+ FROM ' . $this->table_prefix . 'users

+ GROUP BY user_timezone, user_dst';

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

+

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

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . "users

+ SET user_timezone = '" . $this->db->sql_escape($this->convert_phpbb30_timezone($row['user_timezone'], $row['user_dst'])) . "'

+ WHERE user_timezone = '" . $this->db->sql_escape($row['user_timezone']) . "'

+ AND user_dst = " . (int) $row['user_dst'];

+ $this->sql_query($sql);

+ }

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

+

+ // Update board default timezone

+ $sql = 'UPDATE ' . $this->table_prefix . "config

+ SET config_value = '" . $this->convert_phpbb30_timezone($this->config['board_timezone'], $this->config['board_dst']) . "'

+ WHERE config_name = 'board_timezone'";

+ $this->sql_query($sql);

+ }

+

+ /**

+ * Determine the new timezone for a given phpBB 3.0 timezone and

+ * "Daylight Saving Time" option

+ *

+ * @param $timezone float Users timezone in 3.0

+ * @param $dst int Users daylight saving time

+ * @return string Users new php Timezone which is used since 3.1

+ */

+ public function convert_phpbb30_timezone($timezone, $dst)

+ {

+ $offset = $timezone + $dst;

+

+ switch ($timezone)

+ {

+ case '-12':

+ return 'Etc/GMT+' . abs($offset); //'[UTC - 12] Baker Island Time'

+ case '-11':

+ return 'Etc/GMT+' . abs($offset); //'[UTC - 11] Niue Time, Samoa Standard Time'

+ case '-10':

+ return 'Etc/GMT+' . abs($offset); //'[UTC - 10] Hawaii-Aleutian Standard Time, Cook Island Time'

+ case '-9.5':

+ return 'Pacific/Marquesas'; //'[UTC - 9:30] Marquesas Islands Time'

+ case '-9':

+ return 'Etc/GMT+' . abs($offset); //'[UTC - 9] Alaska Standard Time, Gambier Island Time'

+ case '-8':

+ return 'Etc/GMT+' . abs($offset); //'[UTC - 8] Pacific Standard Time'

+ case '-7':

+ return 'Etc/GMT+' . abs($offset); //'[UTC - 7] Mountain Standard Time'

+ case '-6':

+ return 'Etc/GMT+' . abs($offset); //'[UTC - 6] Central Standard Time'

+ case '-5':

+ return 'Etc/GMT+' . abs($offset); //'[UTC - 5] Eastern Standard Time'

+ case '-4.5':

+ return 'America/Caracas'; //'[UTC - 4:30] Venezuelan Standard Time'

+ case '-4':

+ return 'Etc/GMT+' . abs($offset); //'[UTC - 4] Atlantic Standard Time'

+ case '-3.5':

+ return 'America/St_Johns'; //'[UTC - 3:30] Newfoundland Standard Time'

+ case '-3':

+ return 'Etc/GMT+' . abs($offset); //'[UTC - 3] Amazon Standard Time, Central Greenland Time'

+ case '-2':

+ return 'Etc/GMT+' . abs($offset); //'[UTC - 2] Fernando de Noronha Time, South Georgia &amp; the South Sandwich Islands Time'

+ case '-1':

+ return 'Etc/GMT+' . abs($offset); //'[UTC - 1] Azores Standard Time, Cape Verde Time, Eastern Greenland Time'

+ case '0':

+ return (!$dst) ? 'UTC' : 'Etc/GMT-1'; //'[UTC] Western European Time, Greenwich Mean Time'

+ case '1':

+ return 'Etc/GMT-' . $offset; //'[UTC + 1] Central European Time, West African Time'

+ case '2':

+ return 'Etc/GMT-' . $offset; //'[UTC + 2] Eastern European Time, Central African Time'

+ case '3':

+ return 'Etc/GMT-' . $offset; //'[UTC + 3] Moscow Standard Time, Eastern African Time'

+ case '3.5':

+ return 'Asia/Tehran'; //'[UTC + 3:30] Iran Standard Time'

+ case '4':

+ return 'Etc/GMT-' . $offset; //'[UTC + 4] Gulf Standard Time, Samara Standard Time'

+ case '4.5':

+ return 'Asia/Kabul'; //'[UTC + 4:30] Afghanistan Time'

+ case '5':

+ return 'Etc/GMT-' . $offset; //'[UTC + 5] Pakistan Standard Time, Yekaterinburg Standard Time'

+ case '5.5':

+ return 'Asia/Kolkata'; //'[UTC + 5:30] Indian Standard Time, Sri Lanka Time'

+ case '5.75':

+ return 'Asia/Kathmandu'; //'[UTC + 5:45] Nepal Time'

+ case '6':

+ return 'Etc/GMT-' . $offset; //'[UTC + 6] Bangladesh Time, Bhutan Time, Novosibirsk Standard Time'

+ case '6.5':

+ return 'Indian/Cocos'; //'[UTC + 6:30] Cocos Islands Time, Myanmar Time'

+ case '7':

+ return 'Etc/GMT-' . $offset; //'[UTC + 7] Indochina Time, Krasnoyarsk Standard Time'

+ case '8':

+ return 'Etc/GMT-' . $offset; //'[UTC + 8] Chinese Standard Time, Australian Western Standard Time, Irkutsk Standard Time'

+ case '8.75':

+ return 'Australia/Eucla'; //'[UTC + 8:45] Southeastern Western Australia Standard Time'

+ case '9':

+ return 'Etc/GMT-' . $offset; //'[UTC + 9] Japan Standard Time, Korea Standard Time, Chita Standard Time'

+ case '9.5':

+ return 'Australia/ACT'; //'[UTC + 9:30] Australian Central Standard Time'

+ case '10':

+ return 'Etc/GMT-' . $offset; //'[UTC + 10] Australian Eastern Standard Time, Vladivostok Standard Time'

+ case '10.5':

+ return 'Australia/Lord_Howe'; //'[UTC + 10:30] Lord Howe Standard Time'

+ case '11':

+ return 'Etc/GMT-' . $offset; //'[UTC + 11] Solomon Island Time, Magadan Standard Time'

+ case '11.5':

+ return 'Pacific/Norfolk'; //'[UTC + 11:30] Norfolk Island Time'

+ case '12':

+ return 'Etc/GMT-12'; //'[UTC + 12] New Zealand Time, Fiji Time, Kamchatka Standard Time'

+ case '12.75':

+ return 'Pacific/Chatham'; //'[UTC + 12:45] Chatham Islands Time'

+ case '13':

+ return 'Pacific/Tongatapu'; //'[UTC + 13] Tonga Time, Phoenix Islands Time'

+ case '14':

+ return 'Pacific/Kiritimati'; //'[UTC + 14] Line Island Time'

+ default:

+ return 'UTC';

+ }

+ }

+}

+<?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_timezone_p2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_dst');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_310_timezone');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ $this->table_prefix . 'users' => array(

+ 'user_dst',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

+ $this->table_prefix . 'users' => array(

+ 'user_dst' => array('BOOL', 0),

+ ),

+ ),

+ );

+ }

+}