$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);

}

set_error_handler(defined('PHPBB_MSG_HANDLER') ? PHPBB_MSG_HANDLER : 'msg_handler');

// Setup class loader first

$phpbb_class_loader->register();

// Set up container (must be done here because extensions table may not exist)

$container_extensions = array(

);

$container_passes = array(

);

$phpbb_container = phpbb_create_container($container_extensions, $phpbb_root_path, $phpEx);

while (!$migrator->finished())

{

try

{

$migrator->update();

}

{

echo $e->getLocalisedMessage($user);

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)

{

phpbb_require_updated('includes/functions_install.' . $phpEx);

// Setup class loader first

$phpbb_class_loader_new->register();

$phpbb_class_loader->register();

$phpbb_class_loader_ext->register();

// Set up container

// Set PHP error handler to ours

set_error_handler(defined('PHPBB_MSG_HANDLER') ? PHPBB_MSG_HANDLER : 'msg_handler');

// Add own hook handler, if present. :o

if (file_exists($phpbb_root_path . 'includes/hooks/index.' . $phpEx))

}

// Set some standard variables we want to force

'load_tplcompile' => '1'

));

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

$paths = array_filter($paths, 'is_dir');

$template->assign_var('T_ASSETS_PATH', '../assets');

$template->assign_var('T_TEMPLATE_PATH', $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':

unset($dbpasswd);

// We need to fill the config to let internal functions correctly work

set_config(null, null, null, $config);

set_config_count(null, null, null, $config);

$this->page_title = $lang['STAGE_SETTINGS'];

// We need to fill the config to let internal functions correctly work

set_config(null, null, null, $config);

set_config_count(null, null, null, $config);

{

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

}

// Check table prefix

if (!sizeof($error))

unset($dbpasswd);

// We need to fill the config to let internal functions correctly work

set_config(null, null, null, $config);

set_config_count(null, null, null, $config);

// For conversions we are a bit less strict and set to a search backend we know exist...

if (!class_exists($search_type))

{

set_config('search_type', $search_type);

}

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";

break;

case 'final':

$request->enable_super_globals();

// Create a normal container now

// Ok tables have been built, let's fill in the basic information

$sql_query = file_get_contents('schemas/schema_data.sql');

switch ($data['dbms'])

{

case 'mssql':

case 'postgres':

$sql_query = preg_replace('#\# POSTGRES (BEGIN|COMMIT) \##s', '\1; ', $sql_query);

break;

}

// Change prefix

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'",

include_once($phpbb_root_path . 'phpbb/search/fulltext_native.' . $phpEx);

// We need to fill the config to let internal functions correctly work

set_config(null, null, null, $config);

set_config_count(null, null, null, $config);

$error = false;

$sql = 'SELECT post_id, post_subject, post_text, poster_id, forum_id

FROM ' . POSTS_TABLE;

$data = $this->get_submitted_data();

// We need to fill the config to let internal functions correctly work

set_config(null, null, null, $config);

set_config_count(null, null, null, $config);

$data = $this->get_submitted_data();

// We need to fill the config to let internal functions correctly work

set_config(null, null, null, $config);

set_config_count(null, null, null, $config);

* "installs" means it adds all migrations to the migrations table, but does not

* perform any of the actions in the migrations.

*

*/

function populate_migrations($extension_manager, $migrator)

{

function main($mode, $sub)

{

global $request, $phpbb_admin_path, $phpbb_adm_relative_path, $phpbb_container;

// We must enable super globals, otherwise creating a new instance of the request class,

unset($dbpasswd);

// We need to fill the config to let internal functions correctly work

set_config(null, null, null, $config);

set_config_count(null, null, null, $config);

// Set custom template again. ;)

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

$paths = array_filter($paths, 'is_dir');

$template->assign_vars(array(

'S_USER_LANG' => $user->lang['USER_LANG'],

$this->include_file('includes/diff/renderer.' . $phpEx);

// Make sure we stay at the file check if checking the files again

{

$sub = $this->p_master->sub = 'file_check';

}

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

// We are directly within an update. To make sure our update list is correct we check its status.

$modified = ($update_list !== false) ? @filemtime($cache->get_driver()->cache_dir . 'data_update_list.' . $phpEx) : 0;

// Make sure the list is up-to-date

END;;

# Table: 'phpbb_poll_options'

CREATE TABLE phpbb_poll_options (

poll_option_id INTEGER DEFAULT 0 NOT NULL,

/*

Table: 'phpbb_poll_options'

*/

CREATE TABLE [phpbb_poll_options] (

);

# 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_poll_options'

CREATE TABLE phpbb_poll_options (

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

/*

Table: 'phpbb_poll_options'

*/

CREATE TABLE phpbb_poll_options (

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 ('email_max_chunk_size', '50');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_package_size', '20');

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

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_enable', '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);

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',