+# With Apache 2.4 the "Order, Deny" syntax has been deprecated and moved from

+# module mod_authz_host to a new module called mod_access_compat (which may be

+# disabled) and a new "Require" syntax has been introduced to mod_authz_host.

+# We could just conditionally provide both versions, but unfortunately Apache

+# does not explicitly tell us its version if the module mod_version is not

+# available. In this case, we check for the availability of module

+# mod_authz_core (which should be on 2.4 or higher only) as a best guess.

+<IfModule mod_version.c>

+ <IfVersion < 2.4>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfVersion>

+ <IfVersion >= 2.4>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfVersion>

+</IfModule>

+<IfModule !mod_version.c>

+ <IfModule !mod_authz_core.c>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfModule>

+ <IfModule mod_authz_core.c>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfModule>

+</IfModule>

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class local_url_bbcode extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_12_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+

+ /**

+ * Update BBCodes that currently use the LOCAL_URL tag

+ *

+ * To fix http://tracker.phpbb.com/browse/PHPBB3-8319 we changed

+ * the second_pass_replace value, so that needs updating for existing ones

+ */

+ public function update_local_url_bbcode()

+ {

+ $sql = 'SELECT *

+ FROM ' . BBCODES_TABLE . '

+ WHERE bbcode_match ' . $this->db->sql_like_expression($this->db->get_any_char() . 'LOCAL_URL' . $this->db->get_any_char());

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

+

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

+ {

+ if (!class_exists('acp_bbcodes'))

+ {

+ if (function_exists('phpbb_require_updated'))

+ {

+ phpbb_require_updated('includes/acp/acp_bbcodes.' . $this->php_ext);

+ }

+ else

+ {

+ require($this->phpbb_root_path . 'includes/acp/acp_bbcodes.' . $this->php_ext);

+ }

+ }

+

+ $bbcode_match = $row['bbcode_match'];

+ $bbcode_tpl = $row['bbcode_tpl'];

+

+ $acp_bbcodes = new \acp_bbcodes();

+ $sql_ary = $acp_bbcodes->build_regexp($bbcode_match, $bbcode_tpl);

+

+ $sql = 'UPDATE ' . BBCODES_TABLE . '

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

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

+ $this->sql_query($sql);

+ }

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

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_0 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.0', '>=');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_tables' => array(

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

+ 'COLUMNS' => array(

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

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

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

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

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

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

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

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

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

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

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

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

+ 'filesize' => array('UINT:20', 0),

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

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

+ ),

+ 'PRIMARY_KEY' => 'attach_id',

+ 'KEYS' => array(

+ 'filetime' => array('INDEX', 'filetime'),

+ 'post_msg_id' => array('INDEX', 'post_msg_id'),

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'poster_id' => array('INDEX', 'poster_id'),

+ 'is_orphan' => array('INDEX', 'is_orphan'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

+ 'auth_setting' => array('TINT:2', 0),

+ ),

+ 'KEYS' => array(

+ 'group_id' => array('INDEX', 'group_id'),

+ 'auth_opt_id' => array('INDEX', 'auth_option_id'),

+ 'auth_role_id' => array('INDEX', 'auth_role_id'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

+ 'auth_option' => array('VCHAR:50', ''),

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'auth_option_id',

+ 'KEYS' => array(

+ 'auth_option' => array('INDEX', 'auth_option'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

+ 'role_type' => array('VCHAR:10', ''),

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

+ ),

+ 'PRIMARY_KEY' => 'role_id',

+ 'KEYS' => array(

+ 'role_type' => array('INDEX', 'role_type'),

+ 'role_order' => array('INDEX', 'role_order'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

+ 'auth_setting' => array('TINT:2', 0),

+ ),

+ 'PRIMARY_KEY' => array('role_id', 'auth_option_id'),

+ 'KEYS' => array(

+ 'ath_op_id' => array('INDEX', 'auth_option_id'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

+ 'auth_setting' => array('TINT:2', 0),

+ ),

+ 'KEYS' => array(

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

+ 'auth_option_id' => array('INDEX', 'auth_option_id'),

+ 'auth_role_id' => array('INDEX', 'auth_role_id'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

+ 'ban_ip' => array('VCHAR:40', ''),

+ 'ban_email' => array('VCHAR_UNI:100', ''),

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

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'ban_id',

+ 'KEYS' => array(

+ 'ban_end' => array('INDEX', 'ban_end'),

+ 'ban_user' => array('INDEX', array('ban_userid', 'ban_exclude')),

+ 'ban_email' => array('INDEX', array('ban_email', 'ban_exclude')),

+ 'ban_ip' => array('INDEX', array('ban_ip', 'ban_exclude')),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

+ 'bbcode_id' => array('TINT:3', 0),

+ 'bbcode_tag' => array('VCHAR:16', ''),

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

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

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

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

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'bbcode_id',

+ 'KEYS' => array(

+ 'display_on_post' => array('INDEX', 'display_on_posting'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

+ ),

+ 'PRIMARY_KEY' => array('topic_id', 'user_id'),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

+ 'bot_name' => array('STEXT_UNI', ''),

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'bot_id',

+ 'KEYS' => array(

+ 'bot_active' => array('INDEX', 'bot_active'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'config_name',

+ 'KEYS' => array(

+ 'is_dynamic' => array('INDEX', 'is_dynamic'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

+ 'confirm_id' => array('CHAR:32', ''),

+ 'session_id' => array('CHAR:32', ''),

+ 'confirm_type' => array('TINT:3', 0),

+ 'code' => array('VCHAR:8', ''),

+ 'seed' => array('UINT:10', 0),

+ ),

+ 'PRIMARY_KEY' => array('session_id', 'confirm_id'),

+ 'KEYS' => array(

+ 'confirm_type' => array('INDEX', 'confirm_type'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

+ ),

+ 'PRIMARY_KEY' => 'disallow_id',

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

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

+ 'draft_subject' => array('XSTEXT_UNI', ''),

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

+ ),

+ 'PRIMARY_KEY' => 'draft_id',

+ 'KEYS' => array(

+ 'save_time' => array('INDEX', 'save_time'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'extension_id',

+ ),

+

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

+ 'COLUMNS' => array(

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

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

+ 'cat_id' => array('TINT:2', 0),

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

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

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

+ 'max_filesize' => array('UINT:20', 0),

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

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

+ ),

+ 'PRIMARY_KEY' => 'group_id',

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

+ 'forum_parents' => array('MTEXT', ''),

+ 'forum_name' => array('STEXT_UNI', ''),

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

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

+ 'forum_desc_options' => array('UINT:11', 7),

+ 'forum_desc_uid' => array('VCHAR:8', ''),

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

+ 'forum_password' => array('VCHAR_UNI:40', ''),

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

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

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

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

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

+ 'forum_rules_options' => array('UINT:11', 7),

+ 'forum_rules_uid' => array('VCHAR:8', ''),

+ 'forum_topics_per_page' => array('TINT:4', 0),

+ 'forum_type' => array('TINT:4', 0),

+ 'forum_status' => array('TINT:4', 0),

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

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

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

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

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

+ 'forum_last_post_subject' => array('XSTEXT_UNI', ''),

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

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

+ 'forum_last_poster_colour'=> array('VCHAR:6', ''),

+ 'forum_flags' => array('TINT:4', 32),

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

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

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

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

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'forum_id',

+ 'KEYS' => array(

+ 'left_right_id' => array('INDEX', array('left_id', 'right_id')),

+ 'forum_lastpost_id' => array('INDEX', 'forum_last_post_id'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

+ 'session_id' => array('CHAR:32', ''),

+ ),

+ 'PRIMARY_KEY' => array('forum_id', 'user_id', 'session_id'),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'forum_id'),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

+ ),

+ 'KEYS' => array(

+ 'forum_id' => array('INDEX', 'forum_id'),

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

+ 'notify_stat' => array('INDEX', 'notify_status'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

+ 'group_type' => array('TINT:4', 1),

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

+ 'group_name' => array('VCHAR_CI', ''),

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

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

+ 'group_desc_options' => array('UINT:11', 7),

+ 'group_desc_uid' => array('VCHAR:8', ''),

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

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

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

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

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

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

+ 'group_colour' => array('VCHAR:6', ''),

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'group_id',

+ 'KEYS' => array(

+ 'group_legend' => array('INDEX', 'group_legend'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

+ 'icons_width' => array('TINT:4', 0),

+ 'icons_height' => array('TINT:4', 0),

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

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

+ ),

+ 'PRIMARY_KEY' => 'icons_id',

+ 'KEYS' => array(

+ 'display_on_posting' => array('INDEX', 'display_on_posting'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

+ 'lang_id' => array('TINT:4', NULL, 'auto_increment'),

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

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

+ 'lang_english_name' => array('VCHAR_UNI:100', ''),

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

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

+ ),

+ 'PRIMARY_KEY' => 'lang_id',

+ 'KEYS' => array(

+ 'lang_iso' => array('INDEX', 'lang_iso'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

+ 'log_type' => array('TINT:4', 0),

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

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

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

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

+ 'log_ip' => array('VCHAR:40', ''),

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'log_id',

+ 'KEYS' => array(

+ 'log_type' => array('INDEX', 'log_type'),

+ 'forum_id' => array('INDEX', 'forum_id'),

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'reportee_id' => array('INDEX', 'reportee_id'),

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

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

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

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

+ ),

+ 'KEYS' => array(

+ 'disp_idx' => array('INDEX', 'display_on_index'),

+ 'forum_id' => array('INDEX', 'forum_id'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

+ 'module_class' => array('VCHAR:10', ''),

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

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

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'module_id',

+ 'KEYS' => array(

+ 'left_right_id' => array('INDEX', array('left_id', 'right_id')),

+ 'module_enabled' => array('INDEX', 'module_enabled'),

+ 'class_left_id' => array('INDEX', array('module_class', 'left_id')),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

+ 'poll_option_id' => array('TINT:4', 0),

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

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

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

+ ),

+ 'KEYS' => array(

+ 'poll_opt_id' => array('INDEX', 'poll_option_id'),

+ 'topic_id' => array('INDEX', 'topic_id'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

+ 'poll_option_id' => array('TINT:4', 0),

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

+ 'vote_user_ip' => array('VCHAR:40', ''),

+ ),

+ 'KEYS' => array(

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'vote_user_id' => array('INDEX', 'vote_user_id'),

+ 'vote_user_ip' => array('INDEX', 'vote_user_ip'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

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

+ 'poster_ip' => array('VCHAR:40', ''),

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

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

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

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

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

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

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

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

+ 'post_subject' => array('XSTEXT_UNI', '', 'true_sort'),

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

+ 'post_checksum' => array('VCHAR:32', ''),

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

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

+ 'bbcode_uid' => array('VCHAR:8', ''),

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

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

+ 'post_edit_reason' => array('STEXT_UNI', ''),

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'post_id',

+ 'KEYS' => array(

+ 'forum_id' => array('INDEX', 'forum_id'),

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'poster_ip' => array('INDEX', 'poster_ip'),

+ 'poster_id' => array('INDEX', 'poster_id'),

+ 'post_approved' => array('INDEX', 'post_approved'),

+ 'tid_post_time' => array('INDEX', array('topic_id', 'post_time')),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

+ 'author_ip' => array('VCHAR:40', ''),

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

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

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

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

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

+ 'message_subject' => array('XSTEXT_UNI', ''),

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

+ 'message_edit_reason' => array('STEXT_UNI', ''),

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

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

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

+ 'bbcode_uid' => array('VCHAR:8', ''),

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'msg_id',

+ 'KEYS' => array(

+ 'author_ip' => array('INDEX', 'author_ip'),

+ 'message_time' => array('INDEX', 'message_time'),

+ 'author_id' => array('INDEX', 'author_id'),

+ 'root_level' => array('INDEX', 'root_level'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'folder_id',

+ 'KEYS' => array(

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

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

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

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

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

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

+ 'rule_folder_id' => array('INT:11', 0),

+ ),

+ 'PRIMARY_KEY' => 'rule_id',

+ 'KEYS' => array(

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

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

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

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

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

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

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

+ 'folder_id' => array('INT:11', 0),

+ ),

+ 'KEYS' => array(

+ 'msg_id' => array('INDEX', 'msg_id'),

+ 'author_id' => array('INDEX', 'author_id'),

+ 'usr_flder_id' => array('INDEX', array('user_id', 'folder_id')),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

+ 'field_type' => array('TINT:4', 0),

+ 'field_ident' => array('VCHAR:20', ''),

+ 'field_length' => array('VCHAR:20', ''),

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

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

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

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

+ 'field_validation' => array('VCHAR_UNI:20', ''),

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

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

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'field_id',

+ 'KEYS' => array(

+ 'fld_type' => array('INDEX', 'field_type'),

+ 'fld_ordr' => array('INDEX', 'field_order'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

+ ),

+ 'PRIMARY_KEY' => 'user_id',

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

+ 'field_type' => array('TINT:4', 0),

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

+ ),

+ 'PRIMARY_KEY' => array('field_id', 'lang_id', 'option_id'),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => array('field_id', 'lang_id'),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'rank_id',

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'report_id',

+ ),

+

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

+ 'COLUMNS' => array(

+ 'reason_id' => array('USINT', NULL, 'auto_increment'),

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'reason_id',

+ ),

+

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

+ 'COLUMNS' => array(

+ 'search_key' => array('VCHAR:32', ''),

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

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

+ 'search_authors' => array('MTEXT', ''),

+ ),

+ 'PRIMARY_KEY' => 'search_key',

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'word_id',

+ 'KEYS' => array(

+ 'wrd_txt' => array('UNIQUE', 'word_text'),

+ 'wrd_cnt' => array('INDEX', 'word_count'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

+ ),

+ 'KEYS' => array(

+ 'unq_mtch' => array('UNIQUE', array('word_id', 'post_id', 'title_match')),

+ 'word_id' => array('INDEX', 'word_id'),

+ 'post_id' => array('INDEX', 'post_id'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

+ 'session_id' => array('CHAR:32', ''),

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

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

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

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

+ 'session_ip' => array('VCHAR:40', ''),

+ 'session_browser' => array('VCHAR:150', ''),

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

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'session_id',

+ 'KEYS' => array(

+ 'session_time' => array('INDEX', 'session_time'),

+ 'session_user_id' => array('INDEX', 'session_user_id'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

+ 'key_id' => array('CHAR:32', ''),

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

+ 'last_ip' => array('VCHAR:40', ''),

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

+ ),

+ 'PRIMARY_KEY' => array('key_id', 'user_id'),

+ 'KEYS' => array(

+ 'last_login' => array('INDEX', 'last_login'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

+ 'site_ip' => array('VCHAR:40', ''),

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

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

+ ),

+ 'PRIMARY_KEY' => 'site_id',

+ ),

+

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

+ 'COLUMNS' => array(

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

+// We may want to set 'code' to VCHAR:50 or check if unicode support is possible... at the moment only ASCII characters are allowed.

+ 'code' => array('VCHAR_UNI:50', ''),

+ 'emotion' => array('VCHAR_UNI:50', ''),

+ 'smiley_url' => array('VCHAR:50', ''),

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'smiley_id',

+ 'KEYS' => array(

+ 'display_on_post' => array('INDEX', 'display_on_posting'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

+ 'style_id' => array('USINT', NULL, 'auto_increment'),

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

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

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'style_id',

+ 'KEYS' => array(

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

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

+ 'theme_id' => array('INDEX', 'theme_id'),

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

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

+ 'template_id' => array('USINT', 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),

+ ),

+ 'PRIMARY_KEY' => 'template_id',

+ 'KEYS' => array(

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

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

+ 'template_id' => array('USINT', 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('USINT', 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'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

+ 'imageset_id' => array('USINT', 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('USINT', 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('USINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'image_id',

+ 'KEYS' => array(

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

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

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

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

+ 'topic_title' => array('XSTEXT_UNI', '', 'true_sort'),

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

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

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

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

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

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

+ 'topic_status' => array('TINT:3', 0),

+ 'topic_type' => array('TINT:3', 0),

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

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

+ 'topic_first_poster_colour' => array('VCHAR:6', ''),

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

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

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

+ 'topic_last_poster_colour' => array('VCHAR:6', ''),

+ 'topic_last_post_subject' => array('XSTEXT_UNI', ''),

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

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

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

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

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

+ 'poll_title' => array('STEXT_UNI', ''),

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

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

+ 'poll_max_options' => array('TINT:4', 1),

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

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

+ ),

+ 'PRIMARY_KEY' => 'topic_id',

+ 'KEYS' => array(

+ 'forum_id' => array('INDEX', 'forum_id'),

+ 'forum_id_type' => array('INDEX', array('forum_id', 'topic_type')),

+ 'last_post_time' => array('INDEX', 'topic_last_post_time'),

+ 'topic_approved' => array('INDEX', 'topic_approved'),

+ 'forum_appr_last' => array('INDEX', array('forum_id', 'topic_approved', 'topic_last_post_id')),

+ 'fid_time_moved' => array('INDEX', array('forum_id', 'topic_last_post_time', 'topic_moved_id')),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'topic_id'),

+ 'KEYS' => array(

+ 'forum_id' => array('INDEX', 'forum_id'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'topic_id'),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

+ ),

+ 'KEYS' => array(

+ 'topic_id' => array('INDEX', 'topic_id'),

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

+ 'notify_stat' => array('INDEX', 'notify_status'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

+ ),

+ 'KEYS' => array(

+ 'group_id' => array('INDEX', 'group_id'),

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

+ 'group_leader' => array('INDEX', 'group_leader'),

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

+ 'user_type' => array('TINT:2', 0),

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

+ 'user_permissions' => array('MTEXT', ''),

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

+ 'user_ip' => array('VCHAR:40', ''),

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

+ 'username' => array('VCHAR_CI', ''),

+ 'username_clean' => array('VCHAR_CI', ''),

+ 'user_password' => array('VCHAR_UNI:40', ''),

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

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

+ 'user_email' => array('VCHAR_UNI:100', ''),

+ 'user_email_hash' => array('BINT', 0),

+ 'user_birthday' => array('VCHAR:10', ''),

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

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

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

+ 'user_lastpage' => array('VCHAR_UNI:200', ''),

+ 'user_last_confirm_key' => array('VCHAR:10', ''),

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

+ 'user_warnings' => array('TINT:4', 0),

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

+ 'user_login_attempts' => array('TINT:4', 0),

+ 'user_inactive_reason' => array('TINT:2', 0),

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

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

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

+ 'user_timezone' => array('DECIMAL', 0),

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

+ 'user_dateformat' => array('VCHAR_UNI:30', 'd M Y H:i'),

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

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

+ 'user_colour' => array('VCHAR:6', ''),

+ 'user_new_privmsg' => array('INT:4', 0),

+ 'user_unread_privmsg' => array('INT:4', 0),

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

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

+ 'user_full_folder' => array('INT:11', -3),

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

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

+ 'user_topic_sortby_type' => array('VCHAR:1', 't'),

+ 'user_topic_sortby_dir' => array('VCHAR:1', 'd'),

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

+ 'user_post_sortby_type' => array('VCHAR:1', 't'),

+ 'user_post_sortby_dir' => array('VCHAR:1', 'a'),

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

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

+ 'user_notify_type' => array('TINT:4', 0),

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

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

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

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

+ 'user_options' => array('UINT:11', 895),

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

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

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

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

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

+ 'user_sig_bbcode_uid' => array('VCHAR:8', ''),

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

+ 'user_from' => array('VCHAR_UNI:100', ''),

+ 'user_icq' => array('VCHAR:15', ''),

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

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

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

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

+ 'user_website' => array('VCHAR_UNI:200', ''),

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

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

+ 'user_actkey' => array('VCHAR:32', ''),

+ 'user_newpasswd' => array('VCHAR_UNI:40', ''),

+ 'user_form_salt' => array('VCHAR_UNI:32', ''),

+

+ ),

+ 'PRIMARY_KEY' => 'user_id',

+ 'KEYS' => array(

+ 'user_birthday' => array('INDEX', 'user_birthday'),

+ 'user_email_hash' => array('INDEX', 'user_email_hash'),

+ 'user_type' => array('INDEX', 'user_type'),

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

+ ),

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'warning_id',

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'word_id',

+ ),

+

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

+ 'COLUMNS' => array(

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

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

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

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

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'zebra_id'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'attachments',

+ $this->table_prefix . 'acl_groups',

+ $this->table_prefix . 'acl_options',

+ $this->table_prefix . 'acl_roles',

+ $this->table_prefix . 'acl_roles_data',

+ $this->table_prefix . 'acl_users',

+ $this->table_prefix . 'banlist',

+ $this->table_prefix . 'bbcodes',

+ $this->table_prefix . 'bookmarks',

+ $this->table_prefix . 'bots',

+ $this->table_prefix . 'config',

+ $this->table_prefix . 'confirm',

+ $this->table_prefix . 'disallow',

+ $this->table_prefix . 'drafts',

+ $this->table_prefix . 'extensions',

+ $this->table_prefix . 'extension_groups',

+ $this->table_prefix . 'forums',

+ $this->table_prefix . 'forums_access',

+ $this->table_prefix . 'forums_track',

+ $this->table_prefix . 'forums_watch',

+ $this->table_prefix . 'groups',

+ $this->table_prefix . 'icons',

+ $this->table_prefix . 'lang',

+ $this->table_prefix . 'log',

+ $this->table_prefix . 'moderator_cache',

+ $this->table_prefix . 'modules',

+ $this->table_prefix . 'poll_options',

+ $this->table_prefix . 'poll_votes',

+ $this->table_prefix . 'posts',

+ $this->table_prefix . 'privmsgs',

+ $this->table_prefix . 'privmsgs_folder',

+ $this->table_prefix . 'privmsgs_rules',

+ $this->table_prefix . 'privmsgs_to',

+ $this->table_prefix . 'profile_fields',

+ $this->table_prefix . 'profile_fields_data',

+ $this->table_prefix . 'profile_fields_lang',

+ $this->table_prefix . 'profile_lang',

+ $this->table_prefix . 'ranks',

+ $this->table_prefix . 'reports',

+ $this->table_prefix . 'reports_reasons',

+ $this->table_prefix . 'search_results',

+ $this->table_prefix . 'search_wordlist',

+ $this->table_prefix . 'search_wordmatch',

+ $this->table_prefix . 'sessions',

+ $this->table_prefix . 'sessions_keys',

+ $this->table_prefix . 'sitelist',

+ $this->table_prefix . 'smilies',

+ $this->table_prefix . 'styles',

+ $this->table_prefix . 'styles_template',

+ $this->table_prefix . 'styles_template_data',

+ $this->table_prefix . 'styles_theme',

+ $this->table_prefix . 'styles_imageset',

+ $this->table_prefix . 'styles_imageset_data',

+ $this->table_prefix . 'topics',

+ $this->table_prefix . 'topics_track',

+ $this->table_prefix . 'topics_posted',

+ $this->table_prefix . 'topics_watch',

+ $this->table_prefix . 'user_group',

+ $this->table_prefix . 'users',

+ $this->table_prefix . 'warnings',

+ $this->table_prefix . 'words',

+ $this->table_prefix . 'zebra',

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_1_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.1')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_10 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.10', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_10_rc3');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.10')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_10_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.10-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_9');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('email_max_chunk_size', 50)),

+

+ array('config.update', array('version', '3.0.10-RC1')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_10_rc2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.10-RC2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_10_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.10-RC2')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_10_rc3 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.10-RC3', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_10_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.10-RC3')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_11 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.11', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_11_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.11')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_11_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.11-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_10');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'cleanup_deactivated_styles'))),

+ array('custom', array(array(&$this, 'delete_orphan_private_messages'))),

+

+ array('config.update', array('version', '3.0.11-RC1')),

+ );

+ }

+

+ public function cleanup_deactivated_styles()

+ {

+ // Updates users having current style a deactivated one

+ $sql = 'SELECT style_id

+ FROM ' . STYLES_TABLE . '

+ WHERE style_active = 0';

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

+

+ $deactivated_style_ids = array();

+ while ($style_id = $this->db->sql_fetchfield('style_id', false, $result))

+ {

+ $deactivated_style_ids[] = (int) $style_id;

+ }

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

+

+ if (!empty($deactivated_style_ids))

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_style = ' . (int) $this->config['default_style'] .'

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

+ $this->sql_query($sql);

+ }

+ }

+

+ public function delete_orphan_private_messages()

+ {

+ // Delete orphan private messages

+ $batch_size = 500;

+

+ $sql_array = array(

+ 'SELECT' => 'p.msg_id',

+ 'FROM' => array(

+ PRIVMSGS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(PRIVMSGS_TO_TABLE => 't'),

+ 'ON' => 'p.msg_id = t.msg_id',

+ ),

+ ),

+ 'WHERE' => 't.user_id IS NULL',

+ );

+ $sql = $this->db->sql_build_query('SELECT', $sql_array);

+

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

+

+ $delete_pms = array();

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

+ {

+ $delete_pms[] = (int) $row['msg_id'];

+ }

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

+

+ if (!empty($delete_pms))

+ {

+ $sql = 'DELETE FROM ' . PRIVMSGS_TABLE . '

+ WHERE ' . $this->db->sql_in_set('msg_id', $delete_pms);

+ $this->sql_query($sql);

+

+ // Return false to have the Migrator call this function again

+ return false;

+ }

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_11_rc2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.11-RC2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_11_rc1');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'field_show_novalue',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.11-RC2')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_12 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.12', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_12_rc3');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.12', '<'),

+ array('config.update', array('version', '3.0.12')),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+/** @todo DROP LOGIN_ATTEMPT_TABLE.attempt_id in 3.0.12-RC1 **/

+

+class release_3_0_12_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.12-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_11');

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ array('custom', array(array(&$this, 'disable_bots_from_receiving_pms'))),

+

+ array('config.update', array('version', '3.0.12-RC1')),

+ );

+ }

+

+ public function disable_bots_from_receiving_pms()

+ {

+ // Disable receiving pms for bots

+ $sql = 'SELECT user_id

+ FROM ' . BOTS_TABLE;

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

+

+ $bot_user_ids = array();

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

+ {

+ $bot_user_ids[] = (int) $row['user_id'];

+ }

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

+

+ if (!empty($bot_user_ids))

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_allow_pm = 0

+ WHERE ' . $this->db->sql_in_set('user_id', $bot_user_ids);

+ $this->sql_query($sql);

+ }

+ }

+

+ public function update_module_auth()

+ {

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET module_auth = \'acl_u_sig\'

+ WHERE module_class = \'ucp\'

+ AND module_basename = \'profile\'

+ AND module_mode = \'signature\'';

+ $this->sql_query($sql);

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_12_rc2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.12-RC2', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_12_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.12-RC2', '<'),

+ array('config.update', array('version', '3.0.12-RC2')),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_12_rc3 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.12-RC3', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_12_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.12-RC3', '<'),

+ array('config.update', array('version', '3.0.12-RC3')),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_13 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.13', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_13_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.13', '<'),

+ array('config.update', array('version', '3.0.13')),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_13_pl1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.13-PL1', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_13');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.13-PL1', '<'),

+ array('config.update', array('version', '3.0.13-PL1')),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_13_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.13-RC1', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_12');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.13-RC1', '<'),

+ array('config.update', array('version', '3.0.13-RC1')),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_14 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.14', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_14_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.14', '<'),

+ array('config.update', array('version', '3.0.14')),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_14_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.14-RC1', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_13');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.14-RC1', '<'),

+ array('config.update', array('version', '3.0.14-RC1')),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_1_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.1-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_0');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

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

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

+ ),

+ ),

+ 'drop_keys' => array(

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

+ 'group_legend',

+ ),

+ ),

+ 'add_index' => array(

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

+ 'session_forum_id' => array('session_forum_id'),

+ ),

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

+ 'group_legend_name' => array('group_legend', 'group_name'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'display_subforum_list',

+ ),

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

+ 'session_forum_id',

+ ),

+ ),

+ 'add_index' => array(

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

+ 'group_legend' => array('group_legend'),

+ ),

+ ),

+ 'drop_keys' => array(

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

+ 'session_forum_id',

+ ),

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

+ 'group_legend_name',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'fix_unset_last_view_time'))),

+ array('custom', array(array(&$this, 'reset_smiley_size'))),

+

+ array('config.update', array('version', '3.0.1-RC1')),

+ );

+ }

+

+ public function fix_unset_last_view_time()

+ {

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

+ SET topic_last_view_time = topic_last_post_time

+ WHERE topic_last_view_time = 0";

+ $this->sql_query($sql);

+ }

+

+ public function reset_smiley_size()

+ {

+ // Update smiley sizes

+ $smileys = array('icon_e_surprised.gif', 'icon_eek.gif', 'icon_cool.gif', 'icon_lol.gif', 'icon_mad.gif', 'icon_razz.gif', 'icon_redface.gif', 'icon_cry.gif', 'icon_evil.gif', 'icon_twisted.gif', 'icon_rolleyes.gif', 'icon_exclaim.gif', 'icon_question.gif', 'icon_idea.gif', 'icon_arrow.gif', 'icon_neutral.gif', 'icon_mrgreen.gif', 'icon_e_ugeek.gif');

+

+ foreach ($smileys as $smiley)

+ {

+ if (file_exists($this->phpbb_root_path . 'images/smilies/' . $smiley))

+ {

+ list($width, $height) = getimagesize($this->phpbb_root_path . 'images/smilies/' . $smiley);

+

+ $sql = 'UPDATE ' . SMILIES_TABLE . '

+ SET smiley_width = ' . $width . ', smiley_height = ' . $height . "

+ WHERE smiley_url = '" . $this->db->sql_escape($smiley) . "'";

+

+ $this->sql_query($sql);

+ }

+ }

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_2_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.2')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_2_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.2-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_1');

+ }

+

+ public function update_data()

+ {

+ return array(

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

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

+ array('config.add', array('mime_triggers', 'body|head|html|img|plaintext|a href|pre|script|table|title')),

+

+ array('config.update', array('version', '3.0.2-RC1')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_2_rc2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.2-RC2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_2_rc1');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

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

+ 'draft_subject' => array('STEXT_UNI', ''),

+ ),

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

+ 'forum_last_post_subject' => array('STEXT_UNI', ''),

+ ),

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

+ 'post_subject' => array('STEXT_UNI', '', 'true_sort'),

+ ),

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

+ 'message_subject' => array('STEXT_UNI', ''),

+ ),

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

+ 'topic_title' => array('STEXT_UNI', '', 'true_sort'),

+ 'topic_last_post_subject' => array('STEXT_UNI', ''),

+ ),

+ ),

+ 'drop_keys' => array(

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

+ 'session_forum_id',

+ ),

+ ),

+ 'add_index' => array(

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

+ 'session_fid' => array('session_forum_id'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_index' => array(

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

+ 'session_forum_id' => array(

+ 'session_forum_id',

+ ),

+ ),

+ ),

+ 'drop_keys' => array(

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

+ 'session_fid',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.2-RC2')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_3 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.3', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_3_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.3')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_3_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.3-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_2');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

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

+ ),

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

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

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'template_inherits_id',

+ 'template_inherit_path',

+ ),

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

+ 'group_max_recipients',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ array('config.add', array('queue_trigger_posts', '3')),

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

+ array('custom', array(array(&$this, 'set_group_default_max_recipients'))),

+ array('config.add', array('dbms_version', $this->db->sql_server_info(true))),

+ array('permission.add', array('u_masspm_group', true, 'u_masspm')),

+ array('custom', array(array(&$this, 'correct_acp_email_permissions'))),

+

+ array('config.update', array('version', '3.0.3-RC1')),

+ );

+ }

+

+ public function correct_acp_email_permissions()

+ {

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

+ SET module_auth = \'acl_a_email && cfg_email_enable\'

+ WHERE module_class = \'acp\'

+ AND module_basename = \'email\'';

+ $this->sql_query($sql);

+ }

+

+ public function set_group_default_max_recipients()

+ {

+ // Set maximum number of recipients for the registered users, bots, guests group

+ $sql = 'UPDATE ' . GROUPS_TABLE . ' SET group_max_recipients = 5

+ WHERE ' . $this->db->sql_in_set('group_name', array('GUESTS', 'REGISTERED', 'REGISTERED_COPPA', 'BOTS'));

+ $this->sql_query($sql);

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_4 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.4', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_4_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'rename_log_delete_topic'))),

+

+ array('config.update', array('version', '3.0.4')),

+ );

+ }

+

+ public function rename_log_delete_topic()

+ {

+ if ($this->db->get_sql_layer() == 'oracle')

+ {

+ // log_operation is CLOB - but we can change this later

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

+ SET log_operation = 'LOG_DELETE_TOPIC'

+ WHERE log_operation LIKE 'LOG_TOPIC_DELETED'";

+ $this->sql_query($sql);

+ }

+ else

+ {

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

+ SET log_operation = 'LOG_DELETE_TOPIC'

+ WHERE log_operation = 'LOG_TOPIC_DELETED'";

+ $this->sql_query($sql);

+ }

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_4_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.4-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_3');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

+ ),

+ 'change_columns' => array(

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

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

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

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

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

+ ),

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

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

+ ),

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

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

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

+ ),

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

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

+ ),

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

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

+ ),

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

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

+ ),

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

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

+ ),

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

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

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'field_show_profile',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'update_custom_profile_fields'))),

+

+ array('config.update', array('version', '3.0.4-RC1')),

+ );

+ }

+

+ public function update_custom_profile_fields()

+ {

+ // Update the Custom Profile Fields based on previous settings to the new \format

+ $sql = 'SELECT field_id, field_required, field_show_on_reg, field_hide

+ FROM ' . PROFILE_FIELDS_TABLE;

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

+

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

+ {

+ $sql_ary = array(

+ 'field_required' => 0,

+ 'field_show_on_reg' => 0,

+ 'field_hide' => 0,

+ 'field_show_profile'=> 0,

+ );

+

+ if ($row['field_required'])

+ {

+ $sql_ary['field_required'] = $sql_ary['field_show_on_reg'] = $sql_ary['field_show_profile'] = 1;

+ }

+ else if ($row['field_show_on_reg'])

+ {

+ $sql_ary['field_show_on_reg'] = $sql_ary['field_show_profile'] = 1;

+ }

+ else if ($row['field_hide'])

+ {

+ // Only administrators and moderators can see this CPF, if the view is enabled, they can see it, otherwise just admins in the acp_users module

+ $sql_ary['field_hide'] = 1;

+ }

+ else

+ {

+ // equivelant to "none", which is the "Display in user control panel" option

+ $sql_ary['field_show_profile'] = 1;

+ }

+

+ $this->sql_query('UPDATE ' . $this->table_prefix . 'profile_fields SET ' . $this->db->sql_build_array('UPDATE', $sql_ary) . ' WHERE field_id = ' . $row['field_id'], $errored, $error_ary);

+ }

+

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

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_5 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.5', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_5_rc1part2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.5')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+use phpbb\db\migration\container_aware_migration;

+

+class release_3_0_5_rc1 extends container_aware_migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.5-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_4');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ $search_indexing_state = $this->config['search_indexing_state'];

+

+ return array(

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

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

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

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

+ array('config.add', array('max_num_search_keywords', 10)),

+ array('config.remove', array('search_indexing_state')),

+ array('config.add', array('search_indexing_state', $search_indexing_state, true)),

+ array('custom', array(array(&$this, 'hash_old_passwords'))),

+ array('custom', array(array(&$this, 'update_ichiro_bot'))),

+ );

+ }

+

+ public function hash_old_passwords()

+ {

+ $passwords_manager = $this->container->get('passwords.manager');

+ $sql = 'SELECT user_id, user_password

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

+ WHERE user_pass_convert = 1';

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

+

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

+ {

+ if (strlen($row['user_password']) == 32)

+ {

+ $sql_ary = array(

+ 'user_password' => '$CP$' . $passwords_manager->hash($row['user_password'], 'passwords.driver.salted_md5'),

+ );

+

+ $this->sql_query('UPDATE ' . $this->table_prefix . 'users SET ' . $this->db->sql_build_array('UPDATE', $sql_ary) . ' WHERE user_id = ' . $row['user_id']);

+ }

+ }

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

+ }

+

+ public function update_ichiro_bot()

+ {

+ // Adjust bot entry

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

+ SET bot_agent = 'ichiro/'

+ WHERE bot_agent = 'ichiro/2'";

+ $this->sql_query($sql);

+ }

+

+ public function remove_duplicate_auth_options()

+ {

+ // Before we are able to add a unique key to auth_option, we need to remove duplicate entries

+ $sql = 'SELECT auth_option

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

+ GROUP BY auth_option

+ HAVING COUNT(*) >= 2';

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

+

+ $auth_options = array();

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

+ {

+ $auth_options[] = $row['auth_option'];

+ }

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

+

+ // Remove specific auth options

+ if (!empty($auth_options))

+ {

+ foreach ($auth_options as $option)

+ {

+ // Select auth_option_ids... the largest id will be preserved

+ $sql = 'SELECT auth_option_id

+ FROM ' . ACL_OPTIONS_TABLE . "

+ WHERE auth_option = '" . $this->db->sql_escape($option) . "'

+ ORDER BY auth_option_id DESC";

+ // sql_query_limit not possible here, due to bug in postgresql layer

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

+

+ // Skip first row, this is our original auth option we want to preserve

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

+

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

+ {

+ // Ok, remove this auth option...

+ $this->sql_query('DELETE FROM ' . ACL_OPTIONS_TABLE . ' WHERE auth_option_id = ' . $row['auth_option_id']);

+ $this->sql_query('DELETE FROM ' . ACL_ROLES_DATA_TABLE . ' WHERE auth_option_id = ' . $row['auth_option_id']);

+ $this->sql_query('DELETE FROM ' . ACL_GROUPS_TABLE . ' WHERE auth_option_id = ' . $row['auth_option_id']);

+ $this->sql_query('DELETE FROM ' . ACL_USERS_TABLE . ' WHERE auth_option_id = ' . $row['auth_option_id']);

+ }

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

+ }

+ }

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_5_rc1part2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.5-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_5_rc1');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_keys' => array(

+ $this->table_prefix . 'acl_options' => array('auth_option'),

+ ),

+ 'add_unique_index' => array(

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

+ 'auth_option' => array('auth_option'),

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.5-RC1')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_6 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.6', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_6_rc4');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.6')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_6_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.6-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_5');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

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

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

+ 'user_reminded' => array('TINT:4', 0),

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

+ ),

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

+ 'group_skip_auth' => array('BOOL', 0, 'after' => 'group_founder_manage'),

+ ),

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

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

+ ),

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

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

+ ),

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

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

+ ),

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

+ 'forum_options' => array('UINT:20', 0),

+ ),

+ ),

+ 'change_columns' => array(

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

+ 'user_options' => array('UINT:11', 230271),

+ ),

+ ),

+ 'add_index' => array(

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

+ 'post_id' => array('post_id'),

+ 'pm_id' => array('pm_id'),

+ ),

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

+ 'post_username' => array('post_username:255'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'attempts',

+ ),

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

+ 'user_new',

+ 'user_reminded',

+ 'user_reminded_time',

+ ),

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

+ 'group_skip_auth',

+ ),

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

+ 'message_reported',

+ ),

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

+ 'pm_id',

+ ),

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

+ 'field_show_on_vt',

+ ),

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

+ 'forum_options',

+ ),

+ ),

+ 'drop_keys' => array(

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

+ 'post_id',

+ 'pm_id',

+ ),

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

+ 'post_username',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('captcha_plugin', 'phpbb_captcha_nogd')),

+ array('if', array(

+ ($this->config['captcha_gd']),

+ array('config.update', array('captcha_plugin', 'phpbb_captcha_gd')),

+ )),

+

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

+ array('config.add', array('feed_limit', 10)),

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

+ array('config.add', array('feed_overall_forums_limit', 15)),

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

+ array('config.add', array('feed_overall_topics_limit', 15)),

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

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

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

+

+ array('config.add', array('smilies_per_page', 50)),

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

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

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

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

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

+ array('config.add', array('delete_time', $this->config['edit_time'])),

+

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

+ array('if', array(

+ ($this->config['allow_avatar_upload'] || $this->config['allow_avatar_local'] || $this->config['allow_avatar_remote']),

+ array('config.update', array('allow_avatar', 1)),

+ )),

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

+ array('if', array(

+ ($this->config['allow_avatar_remote'] && $this->config['allow_avatar_upload']),

+ array('config.update', array('allow_avatar_remote_upload', 1)),

+ )),

+

+ array('module.add', array(

+ 'acp',

+ 'ACP_BOARD_CONFIGURATION',

+ array(

+ 'module_basename' => 'acp_board',

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

+ ),

+ )),

+ array('module.add', array(

+ 'acp',

+ 'ACP_CAT_USERS',

+ array(

+ 'module_basename' => 'acp_users',

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

+ ),

+ )),

+ array('module.add', array(

+ 'acp',

+ 'ACP_SERVER_CONFIGURATION',

+ array(

+ 'module_basename' => 'acp_send_statistics',

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

+ ),

+ )),

+ array('module.add', array(

+ 'acp',

+ 'ACP_FORUM_BASED_PERMISSIONS',

+ array(

+ 'module_basename' => 'acp_permissions',

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

+ ),

+ )),

+ array('module.add', array(

+ 'mcp',

+ 'MCP_REPORTS',

+ array(

+ 'module_basename' => 'mcp_pm_reports',

+ 'modes' => array('pm_reports','pm_reports_closed','pm_report_details'),

+ ),

+ )),

+ array('custom', array(array(&$this, 'add_newly_registered_group'))),

+ array('custom', array(array(&$this, 'set_user_options_default'))),

+

+ array('config.update', array('version', '3.0.6-RC1')),

+ );

+ }

+

+ public function set_user_options_default()

+ {

+ // 229376 is the added value to enable all three signature options

+ $sql = 'UPDATE ' . USERS_TABLE . ' SET user_options = user_options + 229376';

+ $this->sql_query($sql);

+ }

+

+ public function add_newly_registered_group()

+ {

+ // Add newly_registered group... but check if it already exists (we always supported running the updater on any schema)

+ $sql = 'SELECT group_id

+ FROM ' . GROUPS_TABLE . "

+ WHERE group_name = 'NEWLY_REGISTERED'";

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

+ $group_id = (int) $this->db->sql_fetchfield('group_id');

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

+

+ if (!$group_id)

+ {

+ $sql = 'INSERT INTO ' . GROUPS_TABLE . " (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('NEWLY_REGISTERED', 3, 0, '', 0, '', '', '', 5)";

+ $this->sql_query($sql);

+

+ $group_id = $this->db->sql_nextid();

+ }

+

+ // Insert new user role... at the end of the chain

+ $sql = 'SELECT role_id

+ FROM ' . ACL_ROLES_TABLE . "

+ WHERE role_name = 'ROLE_USER_NEW_MEMBER'

+ AND role_type = 'u_'";

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

+ $u_role = (int) $this->db->sql_fetchfield('role_id');

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

+

+ if (!$u_role)

+ {

+ $sql = 'SELECT MAX(role_order) as max_order_id

+ FROM ' . ACL_ROLES_TABLE . "

+ WHERE role_type = 'u_'";

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

+ $next_order_id = (int) $this->db->sql_fetchfield('max_order_id');

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

+

+ $next_order_id++;

+

+ $sql = 'INSERT INTO ' . ACL_ROLES_TABLE . " (role_name, role_description, role_type, role_order) VALUES ('ROLE_USER_NEW_MEMBER', 'ROLE_DESCRIPTION_USER_NEW_MEMBER', 'u_', $next_order_id)";

+ $this->sql_query($sql);

+ $u_role = $this->db->sql_nextid();

+

+ // Now add the correct data to the roles...

+ // The standard role says that new users are not able to send a PM, Mass PM, are not able to PM groups

+ $sql = 'INSERT INTO ' . ACL_ROLES_DATA_TABLE . " (role_id, auth_option_id, auth_setting) SELECT $u_role, auth_option_id, 0 FROM " . ACL_OPTIONS_TABLE . " WHERE auth_option LIKE 'u_%' AND auth_option IN ('u_sendpm', 'u_masspm', 'u_masspm_group')";

+ $this->sql_query($sql);

+

+ // Add user role to group

+ $sql = 'INSERT INTO ' . ACL_GROUPS_TABLE . " (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES ($group_id, 0, 0, $u_role, 0)";

+ $this->sql_query($sql);

+ }

+

+ // Insert new forum role

+ $sql = 'SELECT role_id

+ FROM ' . ACL_ROLES_TABLE . "

+ WHERE role_name = 'ROLE_FORUM_NEW_MEMBER'

+ AND role_type = 'f_'";

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

+ $f_role = (int) $this->db->sql_fetchfield('role_id');

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

+

+ if (!$f_role)

+ {

+ $sql = 'SELECT MAX(role_order) as max_order_id

+ FROM ' . ACL_ROLES_TABLE . "

+ WHERE role_type = 'f_'";

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

+ $next_order_id = (int) $this->db->sql_fetchfield('max_order_id');

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

+

+ $next_order_id++;

+

+ $sql = 'INSERT INTO ' . ACL_ROLES_TABLE . " (role_name, role_description, role_type, role_order) VALUES ('ROLE_FORUM_NEW_MEMBER', 'ROLE_DESCRIPTION_FORUM_NEW_MEMBER', 'f_', $next_order_id)";

+ $this->sql_query($sql);

+ $f_role = $this->db->sql_nextid();

+

+ $sql = 'INSERT INTO ' . ACL_ROLES_DATA_TABLE . " (role_id, auth_option_id, auth_setting) SELECT $f_role, auth_option_id, 0 FROM " . ACL_OPTIONS_TABLE . " WHERE auth_option LIKE 'f_%' AND auth_option IN ('f_noapprove')";

+ $this->sql_query($sql);

+ }

+

+ // Set every members user_new column to 0 (old users) only if there is no one yet (this makes sure we do not execute this more than once)

+ $sql = 'SELECT 1

+ FROM ' . USERS_TABLE . '

+ WHERE user_new = 0';

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

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

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

+

+ if (!$row)

+ {

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

+ $this->sql_query($sql);

+ }

+

+ // To mimick the old "feature" we will assign the forum role to every forum, regardless of the setting (this makes sure there are no "this does not work!!!! YUO!!!" posts...

+ // Check if the role is already assigned...

+ $sql = 'SELECT forum_id

+ FROM ' . ACL_GROUPS_TABLE . '

+ WHERE group_id = ' . $group_id . '

+ AND auth_role_id = ' . $f_role;

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

+ $is_options = (int) $this->db->sql_fetchfield('forum_id');

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

+

+ // Not assigned at all... :/

+ if (!$is_options)

+ {

+ // Get postable forums

+ $sql = 'SELECT forum_id

+ FROM ' . FORUMS_TABLE . '

+ WHERE forum_type != ' . FORUM_LINK;

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

+

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

+ {

+ $this->sql_query('INSERT INTO ' . ACL_GROUPS_TABLE . ' (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (' . $group_id . ', ' . (int) $row['forum_id'] . ', 0, ' . $f_role . ', 0)');

+ }

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

+ }

+

+ // Clear permissions...

+ include_once($this->phpbb_root_path . 'includes/acp/auth.' . $this->php_ext);

+ $auth_admin = new \auth_admin();

+ $auth_admin->acl_clear_prefetch();

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_6_rc2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.6-RC2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_6_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.6-RC2')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_6_rc3 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.6-RC3', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_6_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'update_cp_fields'))),

+

+ array('config.update', array('version', '3.0.6-RC3')),

+ );

+ }

+

+ public function update_cp_fields()

+ {

+ // Update the Custom Profile Fields based on previous settings to the new \format

+ $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . '

+ SET field_show_on_vt = 1

+ WHERE field_hide = 0

+ AND (field_required = 1 OR field_show_on_reg = 1 OR field_show_profile = 1)';

+ $this->sql_query($sql);

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_6_rc4 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.6-RC4', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_6_rc3');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.6-RC4')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_7 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.7', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_7_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.7')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_7_pl1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.7-pl1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_7');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.7-pl1')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_7_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.7-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_6');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_keys' => array(

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

+ 'log_time',

+ ),

+ ),

+ 'add_index' => array(

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

+ 'topic_id' => array('topic_id'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_index' => array(

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

+ 'log_time' => array('log_time'),

+ ),

+ ),

+ 'drop_keys' => array(

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

+ 'topic_id',

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

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

+ array('config.add', array('feed_limit_post', $this->config['feed_limit'])),

+ array('config.add', array('feed_limit_topic', $this->config['feed_overall_topics_limit'])),

+ array('config.add', array('feed_topics_new', $this->config['feed_overall_topics'])),

+ array('config.add', array('feed_topics_active', $this->config['feed_overall_topics'])),

+ array('custom', array(array(&$this, 'delete_text_templates'))),

+

+ array('config.update', array('version', '3.0.7-RC1')),

+ );

+ }

+

+ public function delete_text_templates()

+ {

+ // Delete all text-templates from the template_data

+ $sql = 'DELETE FROM ' . STYLES_TEMPLATE_DATA_TABLE . '

+ WHERE template_filename ' . $this->db->sql_like_expression($this->db->get_any_char() . '.txt');

+ $this->sql_query($sql);

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_7_rc2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.7-RC2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_7_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'update_email_hash'))),

+

+ array('config.update', array('version', '3.0.7-RC2')),

+ );

+ }

+

+ public function update_email_hash($start = 0)

+ {

+ $limit = 1000;

+

+ $sql = 'SELECT user_id, user_email, user_email_hash

+ FROM ' . USERS_TABLE . '

+ WHERE user_type <> ' . USER_IGNORE . "

+ AND user_email <> ''";

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

+

+ $i = 0;

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

+ {

+ $i++;

+

+ // Snapshot of the phpbb_email_hash() function

+ // We cannot call it directly because the auto updater updates the DB first. :/

+ $user_email_hash = sprintf('%u', crc32(strtolower($row['user_email']))) . strlen($row['user_email']);

+

+ if ($user_email_hash != $row['user_email_hash'])

+ {

+ $sql_ary = array(

+ 'user_email_hash' => $user_email_hash,

+ );

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

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

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

+ $this->sql_query($sql);

+ }

+ }

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

+

+ if ($i < $limit)

+ {

+ // Completed

+ return;

+ }

+

+ // Return the next start, will be sent to $start when this function is called again

+ return $start + $limit;

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_8 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.8', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_8_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.8')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_8_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.8-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_7_pl1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'update_file_extension_group_names'))),

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

+ array('custom', array(array(&$this, 'delete_orphan_shadow_topics'))),

+ array('module.add', array(

+ 'acp',

+ 'ACP_MESSAGES',

+ array(

+ 'module_basename' => 'acp_board',

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

+ ),

+ )),

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

+ array('config.update_if_equals', array(600, 'queue_interval', 60)),

+ array('config.update_if_equals', array(50, 'email_package_size', 20)),

+

+ array('config.update', array('version', '3.0.8-RC1')),

+ );

+ }

+

+ public function update_file_extension_group_names()

+ {

+ // Update file extension group names to use language strings.

+ $sql = 'SELECT lang_dir

+ FROM ' . LANG_TABLE;

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

+

+ $extension_groups_updated = array();

+ while ($lang_dir = $this->db->sql_fetchfield('lang_dir'))

+ {

+ $lang_dir = basename($lang_dir);

+

+ // The language strings we need are either in language/.../acp/attachments.php

+ // in the update package if we're updating to 3.0.8-RC1 or later,

+ // or they are in language/.../install.php when we're updating from 3.0.7-PL1 or earlier.

+ // On an already updated board, they can also already be in language/.../acp/attachments.php

+ // in the board root.

+ $lang_files = array(

+ "{$this->phpbb_root_path}install/update/new/language/$lang_dir/acp/attachments.{$this->php_ext}",

+ "{$this->phpbb_root_path}language/$lang_dir/install.{$this->php_ext}",

+ "{$this->phpbb_root_path}language/$lang_dir/acp/attachments.{$this->php_ext}",

+ );

+

+ foreach ($lang_files as $lang_file)

+ {

+ if (!file_exists($lang_file))

+ {

+ continue;

+ }

+

+ $lang = array();

+ include($lang_file);

+

+ foreach($lang as $lang_key => $lang_val)

+ {

+ if (isset($extension_groups_updated[$lang_key]) || strpos($lang_key, 'EXT_GROUP_') !== 0)

+ {

+ continue;

+ }

+

+ $sql_ary = array(

+ 'group_name' => substr($lang_key, 10), // Strip off 'EXT_GROUP_'

+ );

+

+ $sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . '

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

+ WHERE group_name = '" . $this->db->sql_escape($lang_val) . "'";

+ $this->sql_query($sql);

+

+ $extension_groups_updated[$lang_key] = true;

+ }

+ }

+ }

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

+ }

+

+ public function update_module_auth()

+ {

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET module_auth = \'cfg_allow_avatar && (cfg_allow_avatar_local || cfg_allow_avatar_remote || cfg_allow_avatar_upload || cfg_allow_avatar_remote_upload)\'

+ WHERE module_class = \'ucp\'

+ AND module_basename = \'profile\'

+ AND module_mode = \'avatar\'';

+ $this->sql_query($sql);

+ }

+

+ public function delete_orphan_shadow_topics()

+ {

+ // Delete shadow topics pointing to not existing topics

+ $batch_size = 500;

+

+ // Set of affected forums we have to resync

+ $sync_forum_ids = array();

+

+ $sql_array = array(

+ 'SELECT' => 't1.topic_id, t1.forum_id',

+ 'FROM' => array(

+ TOPICS_TABLE => 't1',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(TOPICS_TABLE => 't2'),

+ 'ON' => 't1.topic_moved_id = t2.topic_id',

+ ),

+ ),

+ 'WHERE' => 't1.topic_moved_id <> 0

+ AND t2.topic_id IS NULL',

+ );

+ $sql = $this->db->sql_build_query('SELECT', $sql_array);

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

+

+ $topic_ids = array();

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

+ {

+ $topic_ids[] = (int) $row['topic_id'];

+

+ $sync_forum_ids[(int) $row['forum_id']] = (int) $row['forum_id'];

+ }

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

+

+ if (!empty($topic_ids))

+ {

+ $sql = 'DELETE FROM ' . TOPICS_TABLE . '

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

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

+

+ // Sync the forums we have deleted shadow topics from.

+ sync('forum', 'forum_id', $sync_forum_ids, true, true);

+

+ return false;

+ }

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_9 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.9', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_9_rc4');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.9')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_9_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.9-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_8');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_tables' => array(

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

+ 'COLUMNS' => array(

+ // this column was removed from the database updater

+ // after 3.0.9-RC3 was released. It might still exist

+ // in 3.0.9-RCX installations and has to be dropped as

+ // soon as the db_tools class is capable of properly

+ // removing a primary key.

+ // 'attempt_id' => array('UINT', NULL, 'auto_increment'),

+ 'attempt_ip' => array('VCHAR:40', ''),

+ 'attempt_browser' => array('VCHAR:150', ''),

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

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

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

+ 'username' => array('VCHAR_UNI:255', 0),

+ 'username_clean' => array('VCHAR_CI', 0),

+ ),

+ //'PRIMARY_KEY' => 'attempt_id',

+ 'KEYS' => array(

+ 'att_ip' => array('INDEX', array('attempt_ip', 'attempt_time')),

+ 'att_for' => array('INDEX', array('attempt_forwarded_for', 'attempt_time')),

+ 'att_time' => array('INDEX', array('attempt_time')),

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

+ ),

+ ),

+ ),

+ 'change_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'login_attempts',

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('ip_login_limit_max', 50)),

+ array('config.add', array('ip_login_limit_time', 21600)),

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

+ array('custom', array(array(&$this, 'update_file_extension_group_names'))),

+ array('custom', array(array(&$this, 'fix_firebird_qa_captcha'))),

+

+ array('config.update', array('version', '3.0.9-RC1')),

+ );

+ }

+

+ public function update_file_extension_group_names()

+ {

+ // Update file extension group names to use language strings, again.

+ $sql = 'SELECT group_id, group_name

+ FROM ' . EXTENSION_GROUPS_TABLE . '

+ WHERE group_name ' . $this->db->sql_like_expression('EXT_GROUP_' . $this->db->get_any_char());

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

+

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

+ {

+ $sql_ary = array(

+ 'group_name' => substr($row['group_name'], 10), // Strip off 'EXT_GROUP_'

+ );

+

+ $sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . '

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

+ WHERE group_id = ' . $row['group_id'];

+ $this->sql_query($sql);

+ }

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

+ }

+

+ public function fix_firebird_qa_captcha()

+ {

+ // Recover from potentially broken Q&A CAPTCHA table on firebird

+ // Q&A CAPTCHA was uninstallable, so it's safe to remove these

+ // without data loss

+ if ($this->db_tools->sql_layer == 'firebird')

+ {

+ $tables = array(

+ $this->table_prefix . 'captcha_questions',

+ $this->table_prefix . 'captcha_answers',

+ $this->table_prefix . 'qa_confirm',

+ );

+ foreach ($tables as $table)

+ {

+ if ($this->db_tools->sql_table_exists($table))

+ {

+ $this->db_tools->sql_table_drop($table);

+ }

+ }

+ }

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_9_rc2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.9-RC2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_9_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.9-RC2')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_9_rc3 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.9-RC3', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_9_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.9-RC3')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_9_rc4 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.9-RC4', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_9_rc3');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.0.9-RC4')),

+ );

+ }

+}

+# With Apache 2.4 the "Order, Deny" syntax has been deprecated and moved from

+# module mod_authz_host to a new module called mod_access_compat (which may be

+# disabled) and a new "Require" syntax has been introduced to mod_authz_host.

+# We could just conditionally provide both versions, but unfortunately Apache

+# does not explicitly tell us its version if the module mod_version is not

+# available. In this case, we check for the availability of module

+# mod_authz_core (which should be on 2.4 or higher only) as a best guess.

+<IfModule mod_version.c>

+ <IfVersion < 2.4>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfVersion>

+ <IfVersion >= 2.4>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfVersion>

+</IfModule>

+<IfModule !mod_version.c>

+ <IfModule !mod_authz_core.c>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfModule>

+ <IfModule mod_authz_core.c>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfModule>

+</IfModule>

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class acp_prune_users_module extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ $sql = 'SELECT module_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = 'acp'

+ AND module_langname = 'ACP_CAT_USERS'";

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

+ $acp_cat_users_id = (int) $this->db->sql_fetchfield('module_id');

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

+

+ $sql = 'SELECT parent_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = 'acp'

+ AND module_basename = 'acp_prune'

+ AND module_mode = 'users'";

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

+ $acp_prune_users_parent = (int) $this->db->sql_fetchfield('parent_id');

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

+

+ // Skip migration if "Users" category has been deleted

+ // or the module has already been moved to that category

+ return !$acp_cat_users_id || $acp_cat_users_id === $acp_prune_users_parent;

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\beta1');

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+

+ public function move_prune_users_module()

+ {

+ $sql = 'SELECT module_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = 'acp'

+ AND module_basename = 'acp_prune'

+ AND module_mode = 'users'";

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

+ $acp_prune_users_id = (int) $this->db->sql_fetchfield('module_id');

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

+

+ $sql = 'SELECT module_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = 'acp'

+ AND module_langname = 'ACP_CAT_USERS'";

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

+ $acp_cat_users_id = (int) $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);

+ }

+ $module_manager = new \acp_modules();

+ $module_manager->module_class = 'acp';

+ $module_manager->move_module($acp_prune_users_id, $acp_cat_users_id);

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class acp_style_components_module extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ $sql = 'SELECT module_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = 'acp'

+ AND module_langname = 'ACP_STYLE_COMPONENTS'";

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

+ $module_id = $this->db->sql_fetchfield('module_id');

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

+

+ return $module_id == false;

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\dev');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('module.remove', array(

+ 'acp',

+ false,

+ 'ACP_STYLE_COMPONENTS',

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class allow_cdn extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

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

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\jquery_update',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('allow_cdn', (int) $this->config['load_jquery_cdn'])),

+ array('config.remove', array('load_jquery_cdn')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class alpha1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.1.0-a1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v30x\local_url_bbcode',

+ '\phpbb\db\migration\data\v30x\release_3_0_12',

+ '\phpbb\db\migration\data\v310\acp_style_components_module',

+ '\phpbb\db\migration\data\v310\allow_cdn',

+ '\phpbb\db\migration\data\v310\auth_provider_oauth',

+ '\phpbb\db\migration\data\v310\avatars',

+ '\phpbb\db\migration\data\v310\boardindex',

+ '\phpbb\db\migration\data\v310\config_db_text',

+ '\phpbb\db\migration\data\v310\forgot_password',

+ '\phpbb\db\migration\data\v310\mod_rewrite',

+ '\phpbb\db\migration\data\v310\mysql_fulltext_drop',

+ '\phpbb\db\migration\data\v310\namespaces',

+ '\phpbb\db\migration\data\v310\notifications_cron',

+ '\phpbb\db\migration\data\v310\notification_options_reconvert',

+ '\phpbb\db\migration\data\v310\plupload',

+ '\phpbb\db\migration\data\v310\signature_module_auth',

+ '\phpbb\db\migration\data\v310\softdelete_mcp_modules',

+ '\phpbb\db\migration\data\v310\teampage',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-a1')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class alpha2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.1.0-a2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\alpha1',

+ '\phpbb\db\migration\data\v310\notifications_cron_p2',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-a2')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class alpha3 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.1.0-a3', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\alpha2',

+ '\phpbb\db\migration\data\v310\avatar_types',

+ '\phpbb\db\migration\data\v310\passwords',

+ '\phpbb\db\migration\data\v310\profilefield_types',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-a3')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class auth_provider_oauth extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

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

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_tables' => array(

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

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0), // phpbb_users.user_id

+ 'session_id' => array('CHAR:32', ''), // phpbb_sessions.session_id used only when user_id not set

+ 'provider' => array('VCHAR', ''), // Name of the OAuth provider

+ 'oauth_token' => array('MTEXT', ''), // Serialized token

+ ),

+ 'KEYS' => array(

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

+ 'provider' => array('INDEX', 'provider'),

+ ),

+ ),

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

+ 'COLUMNS' => array(

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

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

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

+ ),

+ 'PRIMARY_KEY' => array(

+ 'user_id',

+ 'provider',

+ ),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'oauth_tokens',

+ $this->table_prefix . 'oauth_accounts',

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('module.add', array(

+ 'ucp',

+ 'UCP_PROFILE',

+ array(

+ 'module_basename' => 'ucp_auth_link',

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

+ ),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class auth_provider_oauth2 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\auth_provider_oauth',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(

+ array($this, 'update_auth_link_module_auth'),

+ )),

+ );

+ }

+

+ public function update_auth_link_module_auth()

+ {

+ $sql = 'UPDATE ' . MODULES_TABLE . "

+ SET module_auth = 'authmethod_oauth'

+ WHERE module_class = 'ucp'

+ AND module_basename = 'ucp_auth_link'

+ AND module_mode = 'auth_link'

+ AND module_auth = ''";

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

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class avatar_types extends \phpbb\db\migration\migration

+{

+ /**

+ * @var avatar type map

+ */

+ protected $avatar_type_map = array(

+ AVATAR_UPLOAD => 'avatar.driver.upload',

+ AVATAR_REMOTE => 'avatar.driver.remote',

+ AVATAR_GALLERY => 'avatar.driver.local',

+ );

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\dev',

+ '\phpbb\db\migration\data\v310\avatars',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

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

+ );

+ }

+

+ public function update_user_avatar_type()

+ {

+ foreach ($this->avatar_type_map as $old => $new)

+ {

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

+ SET user_avatar_type = '$new'

+ WHERE user_avatar_type = '$old'";

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

+ }

+ }

+

+ public function update_group_avatar_type()

+ {

+ foreach ($this->avatar_type_map as $old => $new)

+ {

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

+ SET group_avatar_type = '$new'

+ WHERE group_avatar_type = '$old'";

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

+ }

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class avatars extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ // Get current avatar type of guest user

+ $sql = 'SELECT user_avatar_type

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

+ WHERE user_id = ' . ANONYMOUS;

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

+ $backup_type = $this->db->sql_fetchfield('user_avatar_type');

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

+

+ // Try to set avatar type to string

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

+ SET user_avatar_type = 'avatar.driver.upload'

+ WHERE user_id = " . ANONYMOUS;

+ $this->db->sql_return_on_error(true);

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

+ $this->db->sql_return_on_error();

+

+ // Restore avatar type of guest user to previous state

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

+ SET user_avatar_type = '{$backup_type}'

+ WHERE user_id = " . ANONYMOUS;

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

+

+ return $effectively_installed !== false;

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_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

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class beta1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.1.0-b1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\alpha3',

+ '\phpbb\db\migration\data\v310\passwords_p2',

+ '\phpbb\db\migration\data\v310\postgres_fulltext_drop',

+ '\phpbb\db\migration\data\v310\profilefield_change_load_settings',

+ '\phpbb\db\migration\data\v310\profilefield_location',

+ '\phpbb\db\migration\data\v310\soft_delete_mod_convert2',

+ '\phpbb\db\migration\data\v310\ucp_popuppm_module',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-b1')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class beta2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.1.0-b2', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\beta1',

+ '\phpbb\db\migration\data\v310\acp_prune_users_module',

+ '\phpbb\db\migration\data\v310\profilefield_location_cleanup',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-b2')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class beta3 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.1.0-b3', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\beta2',

+ '\phpbb\db\migration\data\v310\auth_provider_oauth2',

+ '\phpbb\db\migration\data\v310\board_contact_name',

+ '\phpbb\db\migration\data\v310\jquery_update2',

+ '\phpbb\db\migration\data\v310\live_searches_config',

+ '\phpbb\db\migration\data\v310\prune_shadow_topics',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-b3')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class beta4 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.1.0-b4', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\beta3',

+ '\phpbb\db\migration\data\v310\extensions_version_check_force_unstable',

+ '\phpbb\db\migration\data\v310\reset_missing_captcha_plugin',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-b4')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class board_contact_name extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

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

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\beta2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('board_contact_name', '')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class boardindex extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

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

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('board_index_text', '')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class bot_update extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\rc6');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'update_bing_bot'))),

+ array('custom', array(array(&$this, 'update_bots'))),

+ );

+ }

+

+ public function update_bing_bot()

+ {

+ $bot_name = 'Bing [Bot]';

+ $bot_name_clean = utf8_clean_string($bot_name);

+

+ $sql = 'SELECT user_id

+ FROM ' . USERS_TABLE . "

+ WHERE username_clean = '" . $this->db->sql_escape($bot_name_clean) . "'";

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

+ $bing_already_added = (bool) $this->db->sql_fetchfield('user_id');

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

+

+ if (!$bing_already_added)

+ {

+ $bot_agent = 'bingbot/';

+ $bot_ip = '';

+ $sql = 'SELECT group_id, group_colour

+ FROM ' . GROUPS_TABLE . "

+ WHERE group_name = 'BOTS'";

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

+ $group_row = $this->db->sql_fetchrow($result);

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

+

+ if (!$group_row)

+ {

+ // default fallback, should never get here

+ $group_row['group_id'] = 6;

+ $group_row['group_colour'] = '9E8DA7';

+ }

+

+ if (!function_exists('user_add'))

+ {

+ include($this->phpbb_root_path . 'includes/functions_user.' . $this->php_ext);

+ }

+

+ $user_row = array(

+ 'user_type' => USER_IGNORE,

+ 'group_id' => $group_row['group_id'],

+ 'username' => $bot_name,

+ 'user_regdate' => time(),

+ 'user_password' => '',

+ 'user_colour' => $group_row['group_colour'],

+ 'user_email' => '',

+ 'user_lang' => $this->config['default_lang'],

+ 'user_style' => $this->config['default_style'],

+ 'user_timezone' => 0,

+ 'user_dateformat' => $this->config['default_dateformat'],

+ 'user_allow_massemail' => 0,

+ );

+

+ $user_id = user_add($user_row);

+

+ $sql = 'INSERT INTO ' . BOTS_TABLE . ' ' . $this->db->sql_build_array('INSERT', array(

+ 'bot_active' => 1,

+ 'bot_name' => (string) $bot_name,

+ 'user_id' => (int) $user_id,

+ 'bot_agent' => (string) $bot_agent,

+ 'bot_ip' => (string) $bot_ip,

+ ));

+

+ $this->sql_query($sql);

+ }

+ }

+

+ public function update_bots()

+ {

+ // Update bots

+ if (!function_exists('user_delete'))

+ {

+ include($this->phpbb_root_path . 'includes/functions_user.' . $this->php_ext);

+ }

+

+ $bots_updates = array(

+ // Bot Deletions

+ 'NG-Search [Bot]' => false,

+ 'Nutch/CVS [Bot]' => false,

+ 'OmniExplorer [Bot]' => false,

+ 'Seekport [Bot]' => false,

+ 'Synoo [Bot]' => false,

+ 'WiseNut [Bot]' => false,

+

+ // Bot Updates

+ // Bot name to bot user agent map

+ 'Baidu [Spider]' => 'Baiduspider',

+ 'Exabot [Bot]' => 'Exabot',

+ 'Voyager [Bot]' => 'voyager/',

+ 'W3C [Validator]' => 'W3C_Validator',

+ );

+

+ foreach ($bots_updates as $bot_name => $bot_agent)

+ {

+ $sql = 'SELECT user_id

+ FROM ' . USERS_TABLE . '

+ WHERE user_type = ' . USER_IGNORE . "

+ AND username_clean = '" . $this->db->sql_escape(utf8_clean_string($bot_name)) . "'";

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

+ $bot_user_id = (int) $this->db->sql_fetchfield('user_id');

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

+

+ if ($bot_user_id)

+ {

+ if ($bot_agent === false)

+ {

+ $sql = 'DELETE FROM ' . BOTS_TABLE . "

+ WHERE user_id = $bot_user_id";

+ $this->sql_query($sql);

+

+ user_delete('retain', $bot_user_id);

+ }

+ else

+ {

+ $sql = 'UPDATE ' . BOTS_TABLE . "

+ SET bot_agent = '" . $this->db->sql_escape($bot_agent) . "'

+ WHERE user_id = $bot_user_id";

+ $this->sql_query($sql);

+ }

+ }

+ }

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class captcha_plugins extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\rc2',

+ );

+ }

+

+ public function update_data()

+ {

+ $captcha_plugin = $this->config['captcha_plugin'];

+ if (strpos($captcha_plugin, 'phpbb_captcha_') === 0)

+ {

+ $captcha_plugin = substr($captcha_plugin, strlen('phpbb_captcha_'));

+ }

+ else if (strpos($captcha_plugin, 'phpbb_') === 0)

+ {

+ $captcha_plugin = substr($captcha_plugin, strlen('phpbb_'));

+ }

+

+ return array(

+ array('if', array(

+ (is_file($this->phpbb_root_path . 'phpbb/captcha/plugins/' . $captcha_plugin . '.' . $this->php_ext)),

+ array('config.update', array('captcha_plugin', 'core.captcha.plugins.' . $captcha_plugin)),

+ )),

+ array('if', array(

+ (!is_file($this->phpbb_root_path . 'phpbb/captcha/plugins/' . $captcha_plugin . '.' . $this->php_ext)),

+ array('config.update', array('captcha_plugin', 'core.captcha.plugins.nogd')),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class config_db_text extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

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

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_11');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_tables' => array(

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

+ 'COLUMNS' => array(

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

+ 'config_value' => array('MTEXT', ''),

+ ),

+ 'PRIMARY_KEY' => 'config_name',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'config_text',

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class contact_admin_acp_module extends \phpbb\db\migration\migration

+{

+ public function update_data()

+ {

+ return array(

+ array('module.add', array(

+ 'acp',

+ 'ACP_BOARD_CONFIGURATION',

+ array(

+ 'module_basename' => 'acp_contact',

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

+ ),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class contact_admin_form extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

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

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\config_db_text');

+ }

+

+ public function update_data()

+ {

+ return array(

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

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

+ );

+ }

+

+ public function contact_admin_info()

+ {

+ $text_config = new \phpbb\config\db_text($this->db, $this->table_prefix . 'config_text');

+ $text_config->set_array(array(

+ 'contact_admin_info' => '',

+ 'contact_admin_info_uid' => '',

+ 'contact_admin_info_bitfield' => '',

+ 'contact_admin_info_flags' => OPTION_FLAG_BBCODE + OPTION_FLAG_SMILIES + OPTION_FLAG_LINKS,

+ ));

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class dev extends \phpbb\db\migration\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\v310\extensions',

+ '\phpbb\db\migration\data\v310\style_update_p2',

+ '\phpbb\db\migration\data\v310\timezone_p2',

+ '\phpbb\db\migration\data\v310\reported_posts_display',

+ '\phpbb\db\migration\data\v310\migrations_table',

+ );

+ }

+

+ 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),

+ ),

+ ),

+ );

+ }