$convertor_data = array(

'forum_name' => 'phpBB 2.0.x',

'version' => '1.0.3',

'author' => '<a href="https://www.phpbb.com/">phpBB Group</a>',

'dbms' => $dbms,

'dbhost' => $dbhost,

'avatar_max_width' => 'avatar_max_width',

'avatar_max_height' => 'avatar_max_height',

'default_dateformat' => 'phpbb_set_encoding(default_dateformat)',

'allow_privmsg' => 'not(privmsg_disable)',

'gzip_compress' => 'gzip_compress',

'coppa_enable' => '!is_empty(coppa_mail)',

update_folder_pm_count();

', '

update_unread_count();

', '

phpbb_convert_authentication(\'start\');

', '

array('is_orphan', 0, ''),

array('poster_id', 'attachments.user_id_1 AS poster_id', 'phpbb_user_id'),

array('physical_filename', 'attachments_desc.physical_filename', 'import_attachment'),

array('download_count', 'attachments_desc.download_count', ''),

array('attach_comment', 'attachments_desc.comment', array('function1' => 'phpbb_set_encoding', 'function2' => 'utf8_htmlspecialchars')),

array('extension', 'attachments_desc.extension', ''),

array('topic_title', 'topics.topic_title', 'phpbb_set_encoding'),

array('topic_time', 'topics.topic_time', ''),

array('topic_views', 'topics.topic_views', ''),

array('topic_posts_unapproved', 0, ''),

array('topic_posts_softdeleted',0, ''),

array('topic_last_post_id', 'topics.topic_last_post_id', ''),

array('topic_type', 'topics.topic_type', 'phpbb_convert_topic_type'),

array('topic_first_post_id', 'topics.topic_first_post_id', ''),

array('topic_last_view_time', 'posts.post_time', 'intval'),

array('poll_title', 'vote_desc.vote_text', array('function1' => 'null_to_str', 'function2' => 'phpbb_set_encoding', 'function3' => 'htmlspecialchars_decode', 'function4' => 'utf8_htmlspecialchars')),

array('poll_start', 'vote_desc.vote_start', 'null_to_zero'),

array('poll_length', 'vote_desc.vote_length', 'null_to_zero'),

array('topic_title', 'topics.topic_title', 'phpbb_set_encoding'),

array('topic_time', 'topics.topic_time', ''),

array('topic_views', 'topics.topic_views', ''),

array('topic_posts_unapproved', 0, ''),

array('topic_posts_softdeleted',0, ''),

array('topic_last_post_id', 'topics.topic_last_post_id', ''),

array('topic_moved_id', 'topics.topic_moved_id', ''),

array('topic_type', 'topics.topic_type', 'phpbb_convert_topic_type'),

array('topic_first_post_id', 'topics.topic_first_post_id', ''),

array('poll_title', 'vote_desc.vote_text', array('function1' => 'null_to_str', 'function2' => 'phpbb_set_encoding', 'function3' => 'htmlspecialchars_decode', 'function4' => 'utf8_htmlspecialchars')),

array('poll_start', 'vote_desc.vote_start', 'null_to_zero'),

array('post_edit_count', 'posts.post_edit_count', ''),

array('post_edit_reason', '', ''),

array('post_edit_user', '', 'phpbb_post_edit_user'),

array('bbcode_uid', 'posts.post_time', 'make_uid'),

array('post_text', 'posts_text.post_text', 'phpbb_prepare_message'),

array(

'target' => GROUPS_TABLE,

'autoincrement' => 'group_id',

array('group_id', 'groups.group_id', ''),

array('group_type', 'groups.group_type', 'phpbb_convert_group_type'),

'query_first' => array('target', $convert->truncate_statement . USER_GROUP_TABLE),

'execute_first' => '

add_default_groups();

',

array('group_id', 'groups.group_id', ''),

'autoincrement' => 'user_id',

'query_first' => array(

array('target', 'DELETE FROM ' . USERS_TABLE . ' WHERE user_id <> ' . ANONYMOUS),

),

'execute_last' => '

array('user_lastmark', 'users.user_lastvisit', 'intval'),

array('user_lang', $config['default_lang'], ''),

array('', 'users.user_lang', ''),

array('user_dateformat', 'users.user_dateformat', array('function1' => 'phpbb_set_encoding', 'function2' => 'fill_dateformat')),

array('user_inactive_reason', '', 'phpbb_inactive_reason'),

array('user_inactive_time', '', 'phpbb_inactive_time'),

array('user_sig_bbcode_bitfield', '', 'get_bbcode_bitfield'),

array('', 'users.user_regdate AS post_time', ''),

'where' => 'users.user_id <> -1',

),

),

return (int) $user_id;

}

/* Copy additional table fields from old forum to new forum if user wants this (for Mod compatibility for example)

function phpbb_copy_table_fields()

{

}

/**

* Obtain list of forums in which different attachment categories can be used

*/

function phpbb_attachment_forum_perms($forum_permissions)

$drop_sql = 'DROP TABLE ' . USERCONV_TABLE;

$db->sql_query($drop_sql);

}

while (!$migrator->finished())

{

try

{

$migrator->update();

if (isset($migrator->last_run_migration['effectively_installed']) && $migrator->last_run_migration['effectively_installed'])

{

}

else

{

{

}

else if ($state['migration_schema_done'])

{

}

}

// Are we approaching the time limit? If so we want to pause the update and continue after refreshing

if ((time() - $update_start_time) >= $safe_time_limit)

{

'load_tplcompile' => '1'

));

$phpbb_path_helper = $phpbb_container->get('path_helper');

$template = new \phpbb\template\twig\twig($phpbb_path_helper, $config, $user, new \phpbb\template\context());

$paths = array($phpbb_root_path . 'install/update/new/adm/style', $phpbb_admin_path . 'style');

/**

* Generate the relevant HTML for an input field and the associated label and explanatory text

*/

{

global $lang;

$tpl_type = explode(':', $type);

function main($mode, $sub)

{

global $lang, $template, $phpbb_root_path, $phpEx, $cache, $config, $language, $table_prefix;

$this->tpl_name = 'install_convert';

$this->mode = $mode;

$convert = new convert($this->p_master);

switch ($sub)

{

case 'intro':

{

$error[] = sprintf($lang['TABLE_PREFIX_SAME'], $src_table_prefix);

}

// Check table prefix

if (!sizeof($error))

function finish_conversion()

{

global $db, $phpbb_root_path, $phpEx, $convert, $config, $language, $user, $template;

$db->sql_query('DELETE FROM ' . CONFIG_TABLE . "

WHERE config_name = 'convert_progress'

phpbb_cache_moderators($db, $cache, $auth);

// And finally, add a note to the log

add_log('admin', 'LOG_INSTALL_CONVERTED', $convert->convertor_data['forum_name'], $config['version']);

$url = $this->p_master->module_url . "?mode={$this->mode}&amp;sub=final&amp;language=$language";

SET config_value = '" . md5(mt_rand()) . "'

WHERE config_name = 'avatar_salt'",

'UPDATE ' . $data['table_prefix'] . "users

SET username = '" . $db->sql_escape($data['admin_name']) . "', user_password='" . $db->sql_escape(md5($data['admin_pass1'])) . "', user_ip = '" . $db->sql_escape($user_ip) . "', user_lang = '" . $db->sql_escape($data['default_lang']) . "', user_email='" . $db->sql_escape($data['board_email']) . "', user_dateformat='" . $db->sql_escape($lang['default_dateformat']) . "', user_email_hash = " . $db->sql_escape(phpbb_email_hash($data['board_email'])) . ", username_clean = '" . $db->sql_escape(utf8_clean_string($data['admin_name'])) . "'

WHERE username = 'Admin'",

}

}*/

{

$this->get_custom_info($update_list['new'], $file);

$update_list['new'][] = array('filename' => $file, 'custom' => false);

CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users(auth_option_id);;

CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users(auth_role_id);;

# Table: 'phpbb_banlist'

CREATE TABLE phpbb_banlist (

ban_id INTEGER NOT NULL,

END;;

# Table: 'phpbb_poll_options'

CREATE TABLE phpbb_poll_options (

poll_option_id INTEGER DEFAULT 0 NOT NULL,

/*

Table: 'phpbb_banlist'

*/

CREATE TABLE [phpbb_banlist] (

/*

Table: 'phpbb_poll_options'

*/

CREATE TABLE [phpbb_poll_options] (

);

# Table: 'phpbb_banlist'

CREATE TABLE phpbb_banlist (

ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,

);

# Table: 'phpbb_poll_options'

CREATE TABLE phpbb_poll_options (

poll_option_id tinyint(4) DEFAULT '0' NOT NULL,

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

# Table: 'phpbb_banlist'

CREATE TABLE phpbb_banlist (

ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

# Table: 'phpbb_poll_options'

CREATE TABLE phpbb_poll_options (

poll_option_id tinyint(4) DEFAULT '0' NOT NULL,

/

/*

Table: 'phpbb_banlist'

*/

CREATE TABLE phpbb_banlist (

/*

Table: 'phpbb_poll_options'

*/

CREATE TABLE phpbb_poll_options (

CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id);

/*

Table: 'phpbb_banlist'

*/

CREATE SEQUENCE phpbb_banlist_seq;

CREATE INDEX phpbb_notifications_user ON phpbb_notifications (user_id, notification_read);

/*

Table: 'phpbb_poll_options'

*/

CREATE TABLE phpbb_poll_options (

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_birthdays', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bookmarks', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_emailreuse', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_password_reset', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_forum_notify', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_cpf_viewtopic', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_db_lastread', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_db_track', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_jquery_url', '//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_jumpbox', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_moderators', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('new_member_group_default', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pass_complex', 'PASS_TYPE_ANY');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_edit_time', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_boxes', '4');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_msgs', '50');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('print_pm', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('queue_interval', '60');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('ranks_path', 'images/ranks');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('referer_validation', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_gc', '7200');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_interval', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_anonymous_interval', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_store_results', '1800');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('secure_allow_deny', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('secure_allow_empty_referer', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_icons_path', 'images/upload_icons');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_path', 'files');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('use_system_cron', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_expire_days', '90');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_posts', '1', 1);

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_topics', '1', 1);

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_users', '1', 1);

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('rand_seed', '0', 1);

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('rand_seed_last_update', '0', 1);

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_date', '0', 1);

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('record_online_users', '0', 1);

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('search_indexing_state', '', 1);

CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users (auth_option_id);

CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id);

# Table: 'phpbb_banlist'

CREATE TABLE phpbb_banlist (

ban_id INTEGER PRIMARY KEY NOT NULL ,

CREATE INDEX phpbb_notifications_item_ident ON phpbb_notifications (notification_type_id, item_id);

CREATE INDEX phpbb_notifications_user ON phpbb_notifications (user_id, notification_read);

# Table: 'phpbb_poll_options'

CREATE TABLE phpbb_poll_options (

poll_option_id tinyint(4) NOT NULL DEFAULT '0',