8 files changed, 5939 insertions, 3 deletions
diff --git a/phpBB/install/convert/controller/convertor.php b/phpBB/install/convert/controller/convertor.php
new file mode 100644
index 0000000000..a40f1d0b52
--- /dev/null
+++ b/phpBB/install/convert/controller/convertor.php
@@ -0,0 +1,866 @@
+<?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\convert\controller;
+
+use phpbb\cache\driver\driver_interface;
+use phpbb\exception\http_exception;
+use phpbb\install\controller\helper;
+use phpbb\install\helper\container_factory;
+use phpbb\install\helper\database;
+use phpbb\install\helper\install_helper;
+use phpbb\install\helper\iohandler\factory;
+use phpbb\install\helper\iohandler\iohandler_interface;
+use phpbb\install\helper\navigation\navigation_provider;
+use phpbb\language\language;
+use phpbb\request\request_interface;
+use phpbb\template\template;
+use Symfony\Component\HttpFoundation\StreamedResponse;
+
+/**
+ * Controller for forum convertors
+ *
+ * WARNING: This file did not meant to be present in a production environment, so moving
+ * 			this file to a location which is accessible after board installation might
+ * 			lead to security issues.
+ */
+class convertor
+{
+	/**
+	 * @var driver_interface
+	 */
+	protected $cache;
+
+	/**
+	 * @var driver_interface
+	 */
+	protected $installer_cache;
+
+	/**
+	 * @var \phpbb\config\db
+	 */
+	protected $config;
+
+	/**
+	 * @var \phpbb\config_php_file
+	 */
+	protected $config_php_file;
+
+	/**
+	 * @var string
+	 */
+	protected $config_table;
+
+	/**
+	 * @var helper
+	 */
+	protected $controller_helper;
+
+	/**
+	 * @var database
+	 */
+	protected $db_helper;
+
+	/**
+	 * @var \phpbb\db\driver\driver_interface
+	 */
+	protected $db;
+
+	/**
+	 * @var install_helper
+	 */
+	protected $install_helper;
+
+	/**
+	 * @var iohandler_interface
+	 */
+	protected $iohandler;
+
+	/**
+	 * @var language
+	 */
+	protected $language;
+
+	/**
+	 * @var navigation_provider
+	 */
+	protected $navigation_provider;
+
+	/**
+	 * @var request_interface
+	 */
+	protected $request;
+
+	/**
+	 * @var string
+	 */
+	protected $session_keys_table;
+
+	/**
+	 * @var string
+	 */
+	protected $session_table;
+
+	/**
+	 * @var template
+	 */
+	protected $template;
+
+	/**
+	 * @var string
+	 */
+	protected $phpbb_root_path;
+
+	/**
+	 * @var string
+	 */
+	protected $php_ext;
+
+	/**
+	 * Constructor
+	 *
+	 * @param driver_interface		$cache
+	 * @param container_factory		$container
+	 * @param database				$db_helper
+	 * @param helper				$controller_helper
+	 * @param install_helper		$install_helper
+	 * @param factory				$iohandler
+	 * @param language				$language
+	 * @param navigation_provider	$nav
+	 * @param request_interface		$request
+	 * @param template				$template
+	 * @param string				$phpbb_root_path
+	 * @param string				$php_ext
+	 */
+	public function __construct(driver_interface $cache, container_factory $container, database $db_helper, helper $controller_helper, install_helper $install_helper, factory $iohandler, language $language, navigation_provider $nav, request_interface $request, template $template, $phpbb_root_path, $php_ext)
+	{
+		$this->installer_cache		= $cache;
+		$this->controller_helper	= $controller_helper;
+		$this->db_helper			= $db_helper;
+		$this->install_helper		= $install_helper;
+		$this->language				= $language;
+		$this->navigation_provider	= $nav;
+		$this->request				= $request;
+		$this->template				= $template;
+		$this->phpbb_root_path		= $phpbb_root_path;
+		$this->php_ext				= $php_ext;
+
+		$iohandler->set_environment('ajax');
+		$this->iohandler = $iohandler->get();
+
+		if (!$this->install_helper->is_phpbb_installed() || !defined('IN_INSTALL'))
+		{
+			throw new http_exception(403, 'INSTALL_PHPBB_NOT_INSTALLED');
+		}
+
+		$this->controller_helper->handle_language_select();
+
+		$this->cache	= $container->get('cache.driver');
+		$this->config	= $container->get('config');
+		$this->config_php_file	= new \phpbb\config_php_file($this->phpbb_root_path, $this->php_ext);
+		$this->db		= $container->get('dbal.conn.driver');
+
+		$this->config_table			= $container->get_parameter('tables.config');
+		$this->session_keys_table	= $container->get_parameter('tables.sessions_keys');
+		$this->session_table		= $container->get_parameter('tables.sessions');
+	}
+
+	/**
+	 * Render the intro page
+	 *
+	 * @param bool|int	$start_new	Whether or not to force to start a new convertor
+	 *
+	 * @return \Symfony\Component\HttpFoundation\Response
+	 */
+	public function intro($start_new)
+	{
+		$this->setup_navigation('intro');
+
+		if ($start_new)
+		{
+			if ($this->request->is_ajax())
+			{
+				$response = new StreamedResponse();
+				$iohandler = $this->iohandler;
+				$url = $this->controller_helper->route('phpbb_convert_intro', array('start_new' => 'new'));
+				$response->setCallback(function() use ($iohandler, $url) {
+					$iohandler->redirect($url);
+				});
+				$response->headers->set('X-Accel-Buffering', 'no');
+
+				return $response;
+			}
+
+			$this->config['convert_progress'] = '';
+			$this->config['convert_db_server'] = '';
+			$this->config['convert_db_user'] = '';
+			$this->db->sql_query('DELETE FROM ' . $this->config_table . "
+				WHERE config_name = 'convert_progress'
+					OR config_name = 'convert_db_server'
+					OR config_name = 'convert_db_user'"
+			);
+		}
+
+		// Let's see if there is a conversion in the works...
+		$options = array();
+		if (!empty($this->config['convert_progress']) &&
+			!empty($this->config['convert_db_server']) &&
+			!empty($this->config['convert_db_user']) &&
+			!empty($this->config['convert_options']))
+		{
+			$options = unserialize($this->config['convert_progress']);
+			$options = array_merge($options,
+				unserialize($this->config['convert_db_server']),
+				unserialize($this->config['convert_db_user']),
+				unserialize($this->config['convert_options'])
+			);
+		}
+
+		// This information should have already been checked once, but do it again for safety
+		if (!empty($options) && !empty($options['tag']) &&
+			isset($options['dbms']) &&
+			isset($options['dbhost']) &&
+			isset($options['dbport']) &&
+			isset($options['dbuser']) &&
+			isset($options['dbpasswd']) &&
+			isset($options['dbname']) &&
+			isset($options['table_prefix']))
+		{
+			$this->template->assign_vars(array(
+				'TITLE'				=> $this->language->lang('CONTINUE_CONVERT'),
+				'BODY'				=> $this->language->lang('CONTINUE_CONVERT_BODY'),
+				'S_CONTINUE'		=> true,
+				'U_NEW_ACTION'		=> $this->controller_helper->route('phpbb_convert_intro', array('start_new' => 'new')),
+				'U_CONTINUE_ACTION'	=> $this->controller_helper->route('phpbb_convert_convert', array('converter' => $options['tag'])),
+			));
+
+			return $this->controller_helper->render('installer_convert.html', 'CONTINUE_CONVERT', true);
+		}
+
+		return $this->render_convert_list();
+	}
+
+	/**
+	 * Obtain convertor settings
+	 *
+	 * @param string	$convertor	Name of the convertor
+	 *
+	 * @return \Symfony\Component\HttpFoundation\Response|StreamedResponse
+	 */
+	public function settings($convertor)
+	{
+		$this->setup_navigation('settings');
+
+		require_once ($this->phpbb_root_path . 'includes/constants.' . $this->php_ext);
+		require_once ($this->phpbb_root_path . 'includes/functions_convert.' . $this->php_ext);
+
+		// Include convertor if available
+		$convertor_file_path = $this->phpbb_root_path . 'install/convertors/convert_' . $convertor . '.' . $this->php_ext;
+		if (!file_exists($convertor_file_path))
+		{
+			if ($this->request->is_ajax())
+			{
+				$response = new StreamedResponse();
+				$ref = $this;
+				$response->setCallback(function() use ($ref) {
+					$ref->render_error('CONVERT_NOT_EXIST');
+				});
+				$response->headers->set('X-Accel-Buffering', 'no');
+
+				return $response;
+			}
+
+			$this->render_error('CONVERT_NOT_EXIST');
+			return $this->controller_helper->render('installer_convert.html', 'STAGE_SETTINGS', true);
+		}
+
+		$get_info = true;
+		$phpbb_root_path = $this->phpbb_root_path; // These globals are required
+		$phpEx = $this->php_ext; // See above
+		include_once ($convertor_file_path);
+
+		// The test_file is a file that should be present in the location of the old board.
+		if (!isset($test_file))
+		{
+			if ($this->request->is_ajax())
+			{
+				$response = new StreamedResponse();
+				$ref = $this;
+				$response->setCallback(function() use ($ref) {
+					$ref->render_error('DEV_NO_TEST_FILE');
+				});
+				$response->headers->set('X-Accel-Buffering', 'no');
+
+				return $response;
+			}
+
+			$this->render_error('DEV_NO_TEST_FILE');
+			return $this->controller_helper->render('installer_convert.html', 'STAGE_SETTINGS', true);
+		}
+
+		if ($this->request->variable('submit', false))
+		{
+			// It must be an AJAX request at this point
+			$response = new StreamedResponse();
+			$ref = $this;
+			$response->setCallback(function() use ($ref, $convertor) {
+				$ref->proccess_settings_form($convertor);
+			});
+			$response->headers->set('X-Accel-Buffering', 'no');
+
+			return $response;
+		}
+		else
+		{
+			$this->template->assign_vars(array(
+				'U_ACTION'	=> $this->controller_helper->route('phpbb_convert_settings', array(
+					'convertor'	=> $convertor,
+				))
+			));
+
+			if ($this->request->is_ajax())
+			{
+				$response = new StreamedResponse();
+				$ref = $this;
+				$response->setCallback(function() use ($ref) {
+					$ref->render_settings_form();
+				});
+				$response->headers->set('X-Accel-Buffering', 'no');
+
+				return $response;
+			}
+
+			$this->render_settings_form();
+		}
+
+		return $this->controller_helper->render('installer_convert.html', 'STAGE_SETTINGS', true);
+	}
+
+	/**
+	 * Run conversion
+	 */
+	public function convert($converter)
+	{
+		$this->setup_navigation('convert');
+
+		if ($this->request->is_ajax())
+		{
+			$route = $this->controller_helper->route('phpbb_convert_convert', array('converter' => $converter));
+			$response = new StreamedResponse();
+			$ref = $this;
+			$response->setCallback(function() use ($ref, $route) {
+				$ref->redirect_to_html($route);
+			});
+			$response->headers->set('X-Accel-Buffering', 'no');
+
+			return $response;
+		}
+
+		$convertor = new \phpbb\convert\convertor($this->template, $this->controller_helper);
+		$convertor->convert_data($converter);
+
+		return $this->controller_helper->render('installer_convert.html', 'STAGE_IN_PROGRESS');
+	}
+
+	/**
+	 * Render the final page of the convertor
+	 */
+	public function finish()
+	{
+		$this->setup_navigation('finish');
+
+		$this->template->assign_vars(array(
+			'TITLE'		=> $this->language->lang('CONVERT_COMPLETE'),
+			'BODY'		=> $this->language->lang('CONVERT_COMPLETE_EXPLAIN'),
+		));
+
+		// If we reached this step (conversion completed) we want to purge the cache and log the user out.
+		// This is for making sure the session get not screwed due to the 3.0.x users table being completely new.
+		$this->cache->purge();
+		$this->installer_cache->purge();
+
+		require_once($this->phpbb_root_path . 'includes/constants.' . $this->php_ext);
+		require_once($this->phpbb_root_path . 'includes/functions_convert.' . $this->php_ext);
+
+		$sql = 'SELECT config_value
+			FROM ' . $this->config_table . '
+			WHERE config_name = \'search_type\'';
+		$result = $this->db->sql_query($sql);
+
+		if ($this->db->sql_fetchfield('config_value') != 'fulltext_mysql')
+		{
+			$this->template->assign_vars(array(
+				'S_ERROR_BOX'	=> true,
+				'ERROR_TITLE'	=> $this->language->lang('SEARCH_INDEX_UNCONVERTED'),
+				'ERROR_MSG'		=> $this->language->lang('SEARCH_INDEX_UNCONVERTED_EXPLAIN'),
+			));
+		}
+
+		$this->db->sql_freeresult($result);
+
+		switch ($this->db->get_sql_layer())
+		{
+			case 'sqlite':
+			case 'sqlite3':
+				$this->db->sql_query('DELETE FROM ' . $this->session_keys_table);
+				$this->db->sql_query('DELETE FROM ' . $this->session_table);
+			break;
+
+			default:
+				$this->db->sql_query('TRUNCATE TABLE ' . $this->session_keys_table);
+				$this->db->sql_query('TRUNCATE TABLE ' . $this->session_table);
+			break;
+		}
+
+		return $this->controller_helper->render('installer_convert.html', 'CONVERT_COMPLETE');
+	}
+
+	/**
+	 * Validates settings form
+	 *
+	 * @param string	$convertor
+	 */
+	public function proccess_settings_form($convertor)
+	{
+		global $phpbb_root_path, $phpEx, $get_info;
+
+		$phpbb_root_path = $this->phpbb_root_path;
+		$phpEx = $this->php_ext;
+		$get_info = true;
+
+		require_once($this->phpbb_root_path . 'includes/constants.' . $this->php_ext);
+		require_once($this->phpbb_root_path . 'includes/functions_convert.' . $this->php_ext);
+
+		// Include convertor if available
+		$convertor_file_path = $this->phpbb_root_path . 'install/convertors/convert_' . $convertor . '.' . $this->php_ext;
+		include ($convertor_file_path);
+
+		// We expect to have an AJAX request here
+		$src_dbms			= $this->request->variable('src_dbms', $convertor_data['dbms']);
+		$src_dbhost			= $this->request->variable('src_dbhost', $convertor_data['dbhost']);
+		$src_dbport			= $this->request->variable('src_dbport', $convertor_data['dbport']);
+		$src_dbuser			= $this->request->variable('src_dbuser', $convertor_data['dbuser']);
+		$src_dbpasswd		= $this->request->variable('src_dbpasswd', $convertor_data['dbpasswd']);
+		$src_dbname			= $this->request->variable('src_dbname', $convertor_data['dbname']);
+		$src_table_prefix	= $this->request->variable('src_table_prefix', $convertor_data['table_prefix']);
+		$forum_path			= $this->request->variable('forum_path', $convertor_data['forum_path']);
+		$refresh			= $this->request->variable('refresh', 1);
+
+		// Default URL of the old board
+		// @todo Are we going to use this for attempting to convert URL references in posts, or should we remove it?
+		//		-> We should convert old urls to the new relative urls format
+		// $src_url = $request->variable('src_url', 'Not in use at the moment');
+
+		// strip trailing slash from old forum path
+		$forum_path = (strlen($forum_path) && $forum_path[strlen($forum_path) - 1] == '/') ? substr($forum_path, 0, -1) : $forum_path;
+
+		$error = array();
+		if (!file_exists($this->phpbb_root_path . $forum_path . '/' . $test_file))
+		{
+			$error[] = $this->language->lang('COULD_NOT_FIND_PATH', $forum_path);
+		}
+
+		$connect_test = false;
+		$available_dbms = $this->db_helper->get_available_dbms(false, true, true);
+		if (!isset($available_dbms[$src_dbms]) || !$available_dbms[$src_dbms]['AVAILABLE'])
+		{
+			$error[] = $this->language->lang('INST_ERR_NO_DB');
+		}
+		else
+		{
+			$connect_test = $this->db_helper->check_database_connection($src_dbms, $src_dbhost, $src_dbport, $src_dbuser, $src_dbpasswd, $src_dbname, $src_table_prefix);
+		}
+
+		extract($this->config_php_file->get_all());
+
+		// The forum prefix of the old and the new forum can only be the same if two different databases are used.
+		if ($src_table_prefix === $table_prefix && $src_dbms === $dbms && $src_dbhost === $dbhost && $src_dbport === $dbport && $src_dbname === $dbname)
+		{
+			$error[] = $this->language->lang('TABLE_PREFIX_SAME', $src_table_prefix);
+		}
+
+		if (!$connect_test)
+		{
+			$error[] = $this->language->lang('INST_ERR_DB_CONNECT');
+		}
+
+		$src_dbms = $this->config_php_file->convert_30_dbms_to_31($src_dbms);
+
+		// Check table prefix
+		if (empty($error))
+		{
+			// initiate database connection to old db if old and new db differ
+			global $src_db, $same_db;
+			$src_db = $same_db = false;
+
+			if ($src_dbms != $dbms || $src_dbhost != $dbhost || $src_dbport != $dbport || $src_dbname != $dbname || $src_dbuser != $dbuser)
+			{
+				/** @var \phpbb\db\driver\driver_interface $src_db */
+				$src_db = new $src_dbms();
+				$src_db->sql_connect($src_dbhost, $src_dbuser, htmlspecialchars_decode($src_dbpasswd), $src_dbname, $src_dbport, false, true);
+				$same_db = false;
+			}
+			else
+			{
+				$src_db = $this->db;
+				$same_db = true;
+			}
+
+			$src_db->sql_return_on_error(true);
+			$this->db->sql_return_on_error(true);
+
+			// Try to select one row from the first table to see if the prefix is OK
+			$result = $src_db->sql_query_limit('SELECT * FROM ' . $src_table_prefix . $tables[0], 1);
+
+			if (!$result)
+			{
+				$prefixes = array();
+
+				$db_tools_factory = new \phpbb\db\tools\factory();
+				$db_tools = $db_tools_factory->get($src_db);
+				$tables_existing = $db_tools->sql_list_tables();
+				$tables_existing = array_map('strtolower', $tables_existing);
+				foreach ($tables_existing as $table_name)
+				{
+					compare_table($tables, $table_name, $prefixes);
+				}
+				unset($tables_existing);
+
+				foreach ($prefixes as $prefix => $count)
+				{
+					if ($count >= sizeof($tables))
+					{
+						$possible_prefix = $prefix;
+						break;
+					}
+				}
+
+				$msg = '';
+				if (!empty($convertor_data['table_prefix']))
+				{
+					$msg .= $this->language->lang_array('DEFAULT_PREFIX_IS', array($convertor_data['forum_name'], $convertor_data['table_prefix']));
+				}
+
+				if (!empty($possible_prefix))
+				{
+					$msg .= '<br />';
+					$msg .= ($possible_prefix == '*') ? $this->language->lang('BLANK_PREFIX_FOUND') : $this->language->lang_array('PREFIX_FOUND', array($possible_prefix));
+					$src_table_prefix = ($possible_prefix == '*') ? '' : $possible_prefix;
+				}
+
+				$error[] = $msg;
+			}
+
+			$src_db->sql_freeresult($result);
+			$src_db->sql_return_on_error(false);
+		}
+
+		if (empty($error))
+		{
+			// Save convertor Status
+			$this->config->set('convert_progress', serialize(array(
+				'step'			=> '',
+				'table_prefix'	=> $src_table_prefix,
+				'tag'			=> $convertor,
+			)), false);
+			$this->config->set('convert_db_server', serialize(array(
+				'dbms'			=> $src_dbms,
+				'dbhost'		=> $src_dbhost,
+				'dbport'		=> $src_dbport,
+				'dbname'		=> $src_dbname,
+			)), false);
+			$this->config->set('convert_db_user', serialize(array(
+				'dbuser'		=> $src_dbuser,
+				'dbpasswd'		=> $src_dbpasswd,
+			)), false);
+
+			// Save options
+			$this->config->set('convert_options', serialize(array(
+				'forum_path' => $this->phpbb_root_path . $forum_path,
+				'refresh' => $refresh
+			)), false);
+
+			$url = $this->controller_helper->route('phpbb_convert_convert', array('converter' => $convertor));
+			$this->iohandler->redirect($url);
+			$this->iohandler->send_response(true);
+		}
+		else
+		{
+			$this->render_settings_form($error);
+		}
+	}
+
+	/**
+	 * Renders settings form
+	 *
+	 * @param array	$error	Array of errors
+	 */
+	public function render_settings_form($error = array())
+	{
+		foreach ($error as $msg)
+		{
+			$this->iohandler->add_error_message($msg);
+		}
+
+		$dbms_options = array();
+		foreach ($this->db_helper->get_available_dbms() as $dbms_key => $dbms_array)
+		{
+			$dbms_options[] = array(
+				'value'		=> $dbms_key,
+				'label'		=> 'DB_OPTION_' . strtoupper($dbms_key),
+			);
+		}
+
+		$form_title = 'SPECIFY_OPTIONS';
+		$form_data = array(
+			'src_dbms'	=> array(
+				'label'		=> 'DBMS',
+				'type'		=> 'select',
+				'options'	=> $dbms_options,
+			),
+			'src_dbhost' => array(
+				'label'			=> 'DB_HOST',
+				'description'	=> 'DB_HOST_EXPLAIN',
+				'type'			=> 'text',
+			),
+			'src_dbport' => array(
+				'label'			=> 'DB_PORT',
+				'description'	=> 'DB_PORT_EXPLAIN',
+				'type'			=> 'text',
+			),
+			'src_dbname' => array(
+				'label'		=> 'DB_NAME',
+				'type'		=> 'text',
+			),
+			'src_dbuser' => array(
+				'label'		=> 'DB_USERNAME',
+				'type'		=> 'text',
+			),
+			'src_dbpasswd' => array(
+				'label'	=> 'DB_PASSWORD',
+				'type'	=> 'password',
+			),
+			'src_table_prefix' => array(
+				'label'			=> 'TABLE_PREFIX',
+				'description'	=> 'TABLE_PREFIX_EXPLAIN',
+				'type'			=> 'text',
+			),
+			'forum_path' => array(
+				'label'			=> 'FORUM_PATH',
+				'description'	=> 'FORUM_PATH_EXPLAIN',
+				'type'			=> 'text',
+			),
+			'refresh' => array(
+				'label'			=> 'REFRESH_PAGE',
+				'description'	=> 'REFRESH_PAGE_EXPLAIN',
+				'type'			=> 'radio',
+				'options'		=> array(
+					array(
+						'value'		=> 0,
+						'label'		=> 'NO',
+						'selected'	=> true,
+					),
+					array(
+						'value'		=> 1,
+						'label'		=> 'YES',
+						'selected'	=> false,
+					),
+				),
+			),
+			'submit' => array(
+				'label'	=> 'SUBMIT',
+				'type'	=> 'submit',
+			),
+		);
+
+		if ($this->request->is_ajax())
+		{
+			$this->iohandler->add_user_form_group($form_title, $form_data);
+			$this->iohandler->send_response(true);
+		}
+		else
+		{
+			$rendered_form = $this->iohandler->generate_form_render_data($form_title, $form_data);
+
+			$this->template->assign_vars(array(
+				'TITLE'		=> $this->language->lang('STAGE_SETTINGS'),
+				'CONTENT'	=> $rendered_form,
+			));
+		}
+	}
+
+	/**
+	 * Render the list of available convertors
+	 *
+	 * @return \Symfony\Component\HttpFoundation\Response
+	 */
+	protected function render_convert_list()
+	{
+		$this->template->assign_vars(array(
+			'TITLE'		=> $this->language->lang('CONVERT_INTRO'),
+			'BODY'		=> $this->language->lang('CONVERT_INTRO_BODY'),
+			'S_LIST'	=> true,
+		));
+
+		$convertors = $sort = array();
+		$get_info = true; // Global flag
+
+		$handle = @opendir($this->phpbb_root_path . 'install/convertors/');
+
+		if (!$handle)
+		{
+			die('Unable to access the convertors directory');
+		}
+
+		while ($entry = readdir($handle))
+		{
+			if (preg_match('/^convert_([a-z0-9_]+).' . $this->php_ext . '$/i', $entry, $m))
+			{
+				$phpbb_root_path = $this->phpbb_root_path; // These globals are required
+				$phpEx = $this->php_ext; // See above
+				include_once($this->phpbb_root_path . 'install/convertors/' . $entry);
+				if (isset($convertor_data))
+				{
+					$sort[strtolower($convertor_data['forum_name'])] = sizeof($convertors);
+
+					$convertors[] = array(
+						'tag'			=>	$m[1],
+						'forum_name'	=>	$convertor_data['forum_name'],
+						'version'		=>	$convertor_data['version'],
+						'dbms'			=>	$convertor_data['dbms'],
+						'dbhost'		=>	$convertor_data['dbhost'],
+						'dbport'		=>	$convertor_data['dbport'],
+						'dbuser'		=>	$convertor_data['dbuser'],
+						'dbpasswd'		=>	$convertor_data['dbpasswd'],
+						'dbname'		=>	$convertor_data['dbname'],
+						'table_prefix'	=>	$convertor_data['table_prefix'],
+						'author'		=>	$convertor_data['author']
+					);
+				}
+				unset($convertor_data);
+			}
+		}
+		closedir($handle);
+
+		@ksort($sort);
+
+		foreach ($sort as $void => $index)
+		{
+			$this->template->assign_block_vars('convertors', array(
+				'AUTHOR'	=> $convertors[$index]['author'],
+				'SOFTWARE'	=> $convertors[$index]['forum_name'],
+				'VERSION'	=> $convertors[$index]['version'],
+
+				'U_CONVERT'	=> $this->controller_helper->route('phpbb_convert_settings', array('convertor' => $convertors[$index]['tag'])),
+			));
+		}
+
+		return $this->controller_helper->render('installer_convert.html', 'SUB_INTRO', true);
+	}
+
+	/**
+	 * Renders an error form
+	 *
+	 * @param string		$msg
+	 * @param string|bool	$desc
+	 */
+	public function render_error($msg, $desc = false)
+	{
+		if ($this->request->is_ajax())
+		{
+			$this->iohandler->add_error_message($msg, $desc);
+			$this->iohandler->send_response(true);
+		}
+		else
+		{
+			$this->template->assign_vars(array(
+				'S_ERROR_BOX'	=> true,
+				'ERROR_TITLE'	=> $this->language->lang($msg),
+			));
+
+			if ($desc)
+			{
+				$this->template->assign_var('ERROR_MSG', $this->language->lang($desc));
+			}
+		}
+	}
+
+	/**
+	 * Redirects an AJAX request to a non-JS version
+	 *
+	 * @param string	$url	URL to redirect to
+	 */
+	public function redirect_to_html($url)
+	{
+		$this->iohandler->redirect($url);
+		$this->iohandler->send_response(true);
+	}
+
+	private function setup_navigation($stage)
+	{
+		$active = true;
+		$completed = false;
+
+		switch ($stage)
+		{
+			case 'finish':
+				$this->navigation_provider->set_nav_property(
+					array('convert', 0, 'finish'),
+					array(
+						'selected'	=> $active,
+						'completed'	=> $completed,
+					)
+				);
+
+				$active = false;
+				$completed = true;
+			// no break;
+
+			case 'convert':
+				$this->navigation_provider->set_nav_property(
+					array('convert', 0, 'convert'),
+					array(
+						'selected'	=> $active,
+						'completed'	=> $completed,
+					)
+				);
+
+				$active = false;
+				$completed = true;
+			// no break;
+
+			case 'settings':
+				$this->navigation_provider->set_nav_property(
+					array('convert', 0, 'settings'),
+					array(
+						'selected'	=> $active,
+						'completed'	=> $completed,
+					)
+				);
+
+				$active = false;
+				$completed = true;
+			// no break;
+
+			case 'intro':
+				$this->navigation_provider->set_nav_property(
+					array('convert', 0, 'intro'),
+					array(
+						'selected'	=> $active,
+						'completed'	=> $completed,
+					)
+				);
+			break;
+		}
+	}
+}
diff --git a/phpBB/install/convert/convert.php b/phpBB/install/convert/convert.php
new file mode 100644
index 0000000000..03913d6ae6
--- /dev/null
+++ b/phpBB/install/convert/convert.php
@@ -0,0 +1,60 @@
+<?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\convert;
+
+/**
+ * Class holding all convertor-specific details.
+ *
+ * WARNING: This file did not meant to be present in a production environment, so moving this file to a location which
+ * 			is accessible after board installation might lead to security issues.
+ */
+class convert
+{
+	var $options = array();
+
+	var $convertor_tag = '';
+	var $src_dbms = '';
+	var $src_dbhost = '';
+	var $src_dbport = '';
+	var $src_dbuser = '';
+	var $src_dbpasswd = '';
+	var $src_dbname = '';
+	var $src_table_prefix = '';
+
+	var $convertor_data = array();
+	var $tables = array();
+	var $config_schema = array();
+	var $convertor = array();
+	var $src_truncate_statement = 'DELETE FROM ';
+	var $truncate_statement = 'DELETE FROM ';
+
+	var $fulltext_search;
+
+	// Batch size, can be adjusted by the conversion file
+	// For big boards a value of 6000 seems to be optimal
+	var $batch_size = 2000;
+	// Number of rows to be inserted at once (extended insert) if supported
+	// For installations having enough memory a value of 60 may be good.
+	var $num_wait_rows = 20;
+
+	// Mysqls internal recoding engine messing up with our (better) functions? We at least support more encodings than mysql so should use it in favor.
+	var $mysql_convert = false;
+
+	var $p_master;
+
+	function convert($p_master)
+	{
+		$this->p_master = $p_master;
+	}
+}
diff --git a/phpBB/install/convert/convertor.php b/phpBB/install/convert/convertor.php
new file mode 100644
index 0000000000..2dae356c26
--- /dev/null
+++ b/phpBB/install/convert/convertor.php
@@ -0,0 +1,1618 @@
+<?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\convert;
+
+use phpbb\install\controller\helper;
+use phpbb\template\template;
+
+/**
+ * Convertor backend class
+ *
+ * WARNING: This file did not meant to be present in a production environment, so moving this file to a location which
+ * 			is accessible after board installation might lead to security issues.
+ */
+class convertor
+{
+	/**
+	 * @var helper
+	 */
+	protected $controller_helper;
+
+	/**
+	 * @var \phpbb\filesystem\filesystem
+	 */
+	protected $filesystem;
+
+	/**
+	 * @var \phpbb\template\template
+	 */
+	protected $template;
+
+	/**
+	 * Constructor
+	 *
+	 * @param template	$template
+	 * @param helper	$controller_helper
+	 */
+	public function __construct(template $template, helper $controller_helper)
+	{
+		global $convert, $phpbb_filesystem;
+
+		$this->template = $template;
+		$this->filesystem = $phpbb_filesystem;
+		$this->controller_helper = $controller_helper;
+
+		$convert = new convert($this);
+	}
+
+	/**
+	 * The function which does the actual work (or dispatches it to the relevant places)
+	 */
+	function convert_data($converter)
+	{
+		global $user, $phpbb_root_path, $phpEx, $db, $lang, $config, $cache, $auth;
+		global $convert, $convert_row, $message_parser, $skip_rows, $language;
+		global $request, $phpbb_dispatcher;
+
+		$phpbb_config_php_file = new \phpbb\config_php_file($phpbb_root_path, $phpEx);
+		extract($phpbb_config_php_file->get_all());
+
+		require_once($phpbb_root_path . 'includes/constants.' . $phpEx);
+		require_once($phpbb_root_path . 'includes/functions_convert.' . $phpEx);
+
+		$dbms = $phpbb_config_php_file->convert_30_dbms_to_31($dbms);
+
+		/** @var \phpbb\db\driver\driver_interface $db */
+		$db = new $dbms();
+		$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, true);
+		unset($dbpasswd);
+
+		// We need to fill the config to let internal functions correctly work
+		$config = new \phpbb\config\db($db, new \phpbb\cache\driver\dummy, CONFIG_TABLE);
+
+		// Override a couple of config variables for the duration
+		$config['max_quote_depth'] = 0;
+
+		// @todo Need to confirm that max post length in source is <= max post length in destination or there may be interesting formatting issues
+		$config['max_post_chars'] = $config['min_post_chars'] = 0;
+
+		// Set up a user as well. We _should_ have enough of a database here at this point to do this
+		// and it helps for any core code we call
+		$user->session_begin();
+		$user->page = $user->extract_current_page($phpbb_root_path);
+
+		$convert->options = array();
+		if (isset($config['convert_progress']))
+		{
+			$convert->options = unserialize($config['convert_progress']);
+			$convert->options = array_merge($convert->options, unserialize($config['convert_db_server']), unserialize($config['convert_db_user']), unserialize($config['convert_options']));
+		}
+
+		// This information should have already been checked once, but do it again for safety
+		if (empty($convert->options) || empty($convert->options['tag']) ||
+			!isset($convert->options['dbms']) ||
+			!isset($convert->options['dbhost']) ||
+			!isset($convert->options['dbport']) ||
+			!isset($convert->options['dbuser']) ||
+			!isset($convert->options['dbpasswd']) ||
+			!isset($convert->options['dbname']) ||
+			!isset($convert->options['table_prefix']))
+		{
+			$this->error($user->lang['NO_CONVERT_SPECIFIED'], __LINE__, __FILE__);
+		}
+
+		$this->template->assign_var('S_CONV_IN_PROGRESS', true);
+
+		// Make some short variables accessible, for easier referencing
+		$convert->convertor_tag = basename($convert->options['tag']);
+		$convert->src_dbms = $convert->options['dbms'];
+		$convert->src_dbhost = $convert->options['dbhost'];
+		$convert->src_dbport = $convert->options['dbport'];
+		$convert->src_dbuser = $convert->options['dbuser'];
+		$convert->src_dbpasswd = $convert->options['dbpasswd'];
+		$convert->src_dbname = $convert->options['dbname'];
+		$convert->src_table_prefix = $convert->options['table_prefix'];
+
+		// initiate database connection to old db if old and new db differ
+		global $src_db, $same_db;
+		$src_db = $same_db = null;
+		if ($convert->src_dbms != $dbms || $convert->src_dbhost != $dbhost || $convert->src_dbport != $dbport || $convert->src_dbname != $dbname || $convert->src_dbuser != $dbuser)
+		{
+			$dbms = $convert->src_dbms;
+			/** @var \phpbb\db\driver\driver $src_db */
+			$src_db = new $dbms();
+			$src_db->sql_connect($convert->src_dbhost, $convert->src_dbuser, htmlspecialchars_decode($convert->src_dbpasswd), $convert->src_dbname, $convert->src_dbport, false, true);
+			$same_db = false;
+		}
+		else
+		{
+			$src_db = $db;
+			$same_db = true;
+		}
+
+		$convert->mysql_convert = false;
+		switch ($src_db->sql_layer)
+		{
+			case 'sqlite':
+			case 'sqlite3':
+				$convert->src_truncate_statement = 'DELETE FROM ';
+				break;
+
+			// Thanks MySQL, for silently converting...
+			case 'mysql':
+			case 'mysql4':
+				if (version_compare($src_db->sql_server_info(true, false), '4.1.3', '>='))
+				{
+					$convert->mysql_convert = true;
+				}
+				$convert->src_truncate_statement = 'TRUNCATE TABLE ';
+				break;
+
+			case 'mysqli':
+				$convert->mysql_convert = true;
+				$convert->src_truncate_statement = 'TRUNCATE TABLE ';
+				break;
+
+			default:
+				$convert->src_truncate_statement = 'TRUNCATE TABLE ';
+				break;
+		}
+
+		if ($convert->mysql_convert && !$same_db)
+		{
+			$src_db->sql_query("SET NAMES 'binary'");
+		}
+
+		switch ($db->get_sql_layer())
+		{
+			case 'sqlite':
+			case 'sqlite3':
+				$convert->truncate_statement = 'DELETE FROM ';
+				break;
+
+			default:
+				$convert->truncate_statement = 'TRUNCATE TABLE ';
+				break;
+		}
+
+		$get_info = false;
+
+		// check security implications of direct inclusion
+		if (!file_exists('./convertors/convert_' . $convert->convertor_tag . '.' . $phpEx))
+		{
+			$this->error($user->lang['CONVERT_NOT_EXIST'], __LINE__, __FILE__);
+		}
+
+		if (file_exists('./convertors/functions_' . $convert->convertor_tag . '.' . $phpEx))
+		{
+			include_once('./convertors/functions_' . $convert->convertor_tag . '.' . $phpEx);
+		}
+
+		$get_info = true;
+		include('./convertors/convert_' . $convert->convertor_tag . '.' . $phpEx);
+
+		// Map some variables...
+		$convert->convertor_data = $convertor_data;
+		$convert->tables = $tables;
+		$convert->config_schema = $config_schema;
+
+		// Now include the real data
+		$get_info = false;
+		include('./convertors/convert_' . $convert->convertor_tag . '.' . $phpEx);
+
+		$convert->convertor_data = $convertor_data;
+		$convert->tables = $tables;
+		$convert->config_schema = $config_schema;
+		$convert->convertor = $convertor;
+
+		// The test_file is a file that should be present in the location of the old board.
+		if (!file_exists($convert->options['forum_path'] . '/' . $test_file))
+		{
+			$this->error(sprintf($user->lang['COULD_NOT_FIND_PATH'], $convert->options['forum_path']), __LINE__, __FILE__);
+		}
+
+		$search_type = $config['search_type'];
+
+		// For conversions we are a bit less strict and set to a search backend we know exist...
+		if (!class_exists($search_type))
+		{
+			$search_type = '\phpbb\search\fulltext_native';
+			$config->set('search_type', $search_type);
+		}
+
+		if (!class_exists($search_type))
+		{
+			trigger_error('NO_SUCH_SEARCH_MODULE');
+		}
+
+		$error = false;
+		$convert->fulltext_search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher);
+
+		if ($error)
+		{
+			trigger_error($error);
+		}
+
+		include_once($phpbb_root_path . 'includes/message_parser.' . $phpEx);
+		$message_parser = new \parse_message();
+
+		$jump = $request->variable('jump', 0);
+		$final_jump = $request->variable('final_jump', 0);
+		$sync_batch = $request->variable('sync_batch', -1);
+		$last_statement = $request->variable('last', 0);
+
+		// We are running sync...
+		if ($sync_batch >= 0)
+		{
+			$this->sync_forums($converter, $sync_batch);
+			return;
+		}
+
+		if ($jump)
+		{
+			$this->jump($converter, $jump, $last_statement);
+			return;
+		}
+
+		if ($final_jump)
+		{
+			$this->final_jump($final_jump);
+			return;
+		}
+
+		$current_table = $request->variable('current_table', 0);
+		$old_current_table = min(-1, $current_table - 1);
+		$skip_rows = $request->variable('skip_rows', 0);
+
+		if (!$current_table && !$skip_rows)
+		{
+			if (!$request->variable('confirm', false))
+			{
+				// If avatars / ranks / smilies folders are specified make sure they are writable
+				$bad_folders = array();
+
+				$local_paths = array(
+					'avatar_path'			=> path($config['avatar_path']),
+					'avatar_gallery_path'	=> path($config['avatar_gallery_path']),
+					'icons_path'			=> path($config['icons_path']),
+					'ranks_path'			=> path($config['ranks_path']),
+					'smilies_path'			=> path($config['smilies_path'])
+				);
+
+				foreach ($local_paths as $folder => $local_path)
+				{
+					if (isset($convert->convertor[$folder]))
+					{
+						if (empty($convert->convertor['test_file']))
+						{
+							// test_file is mandantory at the moment so this should never be reached, but just in case...
+							$this->error($user->lang['DEV_NO_TEST_FILE'], __LINE__, __FILE__);
+						}
+
+						if (!$local_path || !$this->filesystem->is_writable($phpbb_root_path . $local_path))
+						{
+							if (!$local_path)
+							{
+								$bad_folders[] = sprintf($user->lang['CONFIG_PHPBB_EMPTY'], $folder);
+							}
+							else
+							{
+								$bad_folders[] = $local_path;
+							}
+						}
+					}
+				}
+
+				if (sizeof($bad_folders))
+				{
+					$msg = (sizeof($bad_folders) == 1) ? $user->lang['MAKE_FOLDER_WRITABLE'] : $user->lang['MAKE_FOLDERS_WRITABLE'];
+					sort($bad_folders);
+					$this->error(sprintf($msg, implode('<br />', $bad_folders)), __LINE__, __FILE__, true);
+
+					$this->template->assign_vars(array(
+						'L_SUBMIT'	=> $user->lang['INSTALL_TEST'],
+						'U_ACTION'	=> $this->controller_helper->route('phpbb_convert_convert', array('converter' => $converter)),
+					));
+					return;
+				}
+
+				// Grab all the tables used in convertor
+				$missing_tables = $tables_list = $aliases = array();
+
+				foreach ($convert->convertor['schema'] as $schema)
+				{
+					// Skip those not used (because of addons/plugins not detected)
+					if (!$schema['target'])
+					{
+						continue;
+					}
+
+					foreach ($schema as $key => $val)
+					{
+						// we're dealing with an array like:
+						// array('forum_status',			'forums.forum_status',				'is_item_locked')
+						if (is_int($key) && !empty($val[1]))
+						{
+							$temp_data = $val[1];
+							if (!is_array($temp_data))
+							{
+								$temp_data = array($temp_data);
+							}
+
+							foreach ($temp_data as $value)
+							{
+								if (preg_match('/([a-z0-9_]+)\.([a-z0-9_]+)\)* ?A?S? ?([a-z0-9_]*?)\.?([a-z0-9_]*)$/i', $value, $m))
+								{
+									$table = $convert->src_table_prefix . $m[1];
+									$tables_list[$table] = $table;
+
+									if (!empty($m[3]))
+									{
+										$aliases[] = $convert->src_table_prefix . $m[3];
+									}
+								}
+							}
+						}
+						// 'left_join'		=> 'topics LEFT JOIN vote_desc ON topics.topic_id = vote_desc.topic_id AND topics.topic_vote = 1'
+						else if ($key == 'left_join')
+						{
+							// Convert the value if it wasn't an array already.
+							if (!is_array($val))
+							{
+								$val = array($val);
+							}
+
+							for ($j = 0; $j < sizeof($val); ++$j)
+							{
+								if (preg_match('/LEFT JOIN ([a-z0-9_]+) AS ([a-z0-9_]+)/i', $val[$j], $m))
+								{
+									$table = $convert->src_table_prefix . $m[1];
+									$tables_list[$table] = $table;
+
+									if (!empty($m[2]))
+									{
+										$aliases[] = $convert->src_table_prefix . $m[2];
+									}
+								}
+							}
+						}
+					}
+				}
+
+				// Remove aliased tables from $tables_list
+				foreach ($aliases as $alias)
+				{
+					unset($tables_list[$alias]);
+				}
+
+				// Check if the tables that we need exist
+				$src_db->sql_return_on_error(true);
+				foreach ($tables_list as $table => $null)
+				{
+					$sql = 'SELECT 1 FROM ' . $table;
+					$_result = $src_db->sql_query_limit($sql, 1);
+
+					if (!$_result)
+					{
+						$missing_tables[] = $table;
+					}
+					$src_db->sql_freeresult($_result);
+				}
+				$src_db->sql_return_on_error(false);
+
+				// Throw an error if some tables are missing
+				// We used to do some guessing here, but since we have a suggestion of possible values earlier, I don't see it adding anything here to do it again
+
+				if (sizeof($missing_tables) == sizeof($tables_list))
+				{
+					$this->error($user->lang['NO_TABLES_FOUND'] . ' ' . $user->lang['CHECK_TABLE_PREFIX'], __LINE__, __FILE__);
+				}
+				else if (sizeof($missing_tables))
+				{
+					$this->error(sprintf($user->lang['TABLES_MISSING'], implode($user->lang['COMMA_SEPARATOR'], $missing_tables)) . '<br /><br />' . $user->lang['CHECK_TABLE_PREFIX'], __LINE__, __FILE__);
+				}
+
+				$url = $this->save_convert_progress($converter, 'confirm=1');
+				$msg = $user->lang['PRE_CONVERT_COMPLETE'];
+
+				if ($convert->convertor_data['author_notes'])
+				{
+					$msg .= '</p><p>' . sprintf($user->lang['AUTHOR_NOTES'], $convert->convertor_data['author_notes']);
+				}
+
+				$this->template->assign_vars(array(
+					'L_SUBMIT'		=> $user->lang['CONTINUE_CONVERT'],
+					'BODY'			=> $msg,
+					'U_ACTION'		=> $url,
+				));
+
+				return;
+			} // if (!$request->variable('confirm', false)))
+
+			$this->template->assign_block_vars('checks', array(
+				'S_LEGEND'		=> true,
+				'LEGEND'		=> $user->lang['STARTING_CONVERT'],
+			));
+
+			// Convert the config table and load the settings of the old board
+			if (!empty($convert->config_schema))
+			{
+				restore_config($convert->config_schema);
+
+				// Override a couple of config variables for the duration
+				$config['max_quote_depth'] = 0;
+
+				// @todo Need to confirm that max post length in source is <= max post length in destination or there may be interesting formatting issues
+				$config['max_post_chars'] = $config['min_post_chars'] = 0;
+			}
+
+			$this->template->assign_block_vars('checks', array(
+				'TITLE'		=> $user->lang['CONFIG_CONVERT'],
+				'RESULT'	=> $user->lang['DONE'],
+			));
+
+			// Now process queries and execute functions that have to be executed prior to the conversion
+			if (!empty($convert->convertor['execute_first']))
+			{
+				// @codingStandardsIgnoreStart
+				eval($convert->convertor['execute_first']);
+				// @codingStandardsIgnoreEnd
+			}
+
+			if (!empty($convert->convertor['query_first']))
+			{
+				if (!is_array($convert->convertor['query_first']))
+				{
+					$convert->convertor['query_first'] = array('target', array($convert->convertor['query_first']));
+				}
+				else if (!is_array($convert->convertor['query_first'][0]))
+				{
+					$convert->convertor['query_first'] = array(array($convert->convertor['query_first'][0], $convert->convertor['query_first'][1]));
+				}
+
+				foreach ($convert->convertor['query_first'] as $query_first)
+				{
+					if ($query_first[0] == 'src')
+					{
+						if ($convert->mysql_convert && $same_db)
+						{
+							$src_db->sql_query("SET NAMES 'binary'");
+						}
+
+						$src_db->sql_query($query_first[1]);
+
+						if ($convert->mysql_convert && $same_db)
+						{
+							$src_db->sql_query("SET NAMES 'utf8'");
+						}
+					}
+					else
+					{
+						$db->sql_query($query_first[1]);
+					}
+				}
+			}
+
+			$this->template->assign_block_vars('checks', array(
+				'TITLE'		=> $user->lang['PREPROCESS_STEP'],
+				'RESULT'	=> $user->lang['DONE'],
+			));
+		} // if (!$current_table && !$skip_rows)
+
+		$this->template->assign_block_vars('checks', array(
+			'S_LEGEND'		=> true,
+			'LEGEND'		=> $user->lang['FILLING_TABLES'],
+		));
+
+		// This loop takes one target table and processes it
+		while ($current_table < sizeof($convert->convertor['schema']))
+		{
+			$schema = $convert->convertor['schema'][$current_table];
+
+			// The target table isn't set, this can be because a module (for example the attachement mod) is taking care of this.
+			if (empty($schema['target']))
+			{
+				$current_table++;
+				continue;
+			}
+
+			$this->template->assign_block_vars('checks', array(
+				'TITLE'	=> sprintf($user->lang['FILLING_TABLE'], $schema['target']),
+			));
+
+			// This is only the case when we first start working on the tables.
+			if (!$skip_rows)
+			{
+				// process execute_first and query_first for this table...
+				if (!empty($schema['execute_first']))
+				{
+					// @codingStandardsIgnoreStart
+					eval($schema['execute_first']);
+					// @codingStandardsIgnoreEnd
+				}
+
+				if (!empty($schema['query_first']))
+				{
+					if (!is_array($schema['query_first']))
+					{
+						$schema['query_first'] = array('target', array($schema['query_first']));
+					}
+					else if (!is_array($schema['query_first'][0]))
+					{
+						$schema['query_first'] = array(array($schema['query_first'][0], $schema['query_first'][1]));
+					}
+
+					foreach ($schema['query_first'] as $query_first)
+					{
+						if ($query_first[0] == 'src')
+						{
+							if ($convert->mysql_convert && $same_db)
+							{
+								$src_db->sql_query("SET NAMES 'binary'");
+							}
+							$src_db->sql_query($query_first[1]);
+							if ($convert->mysql_convert && $same_db)
+							{
+								$src_db->sql_query("SET NAMES 'utf8'");
+							}
+						}
+						else
+						{
+							$db->sql_query($query_first[1]);
+						}
+					}
+				}
+
+				if (!empty($schema['autoincrement']))
+				{
+					switch ($db->get_sql_layer())
+					{
+						case 'postgres':
+							$db->sql_query("SELECT SETVAL('" . $schema['target'] . "_seq',(select case when max(" . $schema['autoincrement'] . ")>0 then max(" . $schema['autoincrement'] . ")+1 else 1 end from " . $schema['target'] . '));');
+							break;
+
+						case 'oracle':
+							$result = $db->sql_query('SELECT MAX(' . $schema['autoincrement'] . ') as max_id FROM ' . $schema['target']);
+							$row = $db->sql_fetchrow($result);
+							$db->sql_freeresult($result);
+
+							$largest_id = (int) $row['max_id'];
+
+							if ($largest_id)
+							{
+								$db->sql_query('DROP SEQUENCE ' . $schema['target'] . '_seq');
+								$db->sql_query('CREATE SEQUENCE ' . $schema['target'] . '_seq START WITH ' . ($largest_id + 1));
+							}
+							break;
+					}
+				}
+			}
+
+			// Process execute_always for this table
+			// This is for code which needs to be executed on every pass of this table if
+			// it gets split because of time restrictions
+			if (!empty($schema['execute_always']))
+			{
+				// @codingStandardsIgnoreStart
+				eval($schema['execute_always']);
+				// @codingStandardsIgnoreEnd
+			}
+
+			//
+			// Set up some variables
+			//
+			// $waiting_rows	holds rows for multirows insertion (MySQL only)
+			// $src_tables		holds unique tables with aliases to select from
+			// $src_fields		will quickly refer source fields (or aliases) corresponding to the current index
+			// $select_fields	holds the names of the fields to retrieve
+			//
+
+			$sql_data = array(
+				'source_fields'		=> array(),
+				'target_fields'		=> array(),
+				'source_tables'		=> array(),
+				'select_fields'		=> array(),
+			);
+
+			// This statement is building the keys for later insertion.
+			$insert_query = $this->build_insert_query($schema, $sql_data, $current_table);
+
+			// If no source table is affected, we skip the table
+			if (empty($sql_data['source_tables']))
+			{
+				$skip_rows = 0;
+				$current_table++;
+				continue;
+			}
+
+			$distinct = (!empty($schema['distinct'])) ? 'DISTINCT ' : '';
+
+			$sql = 'SELECT ' . $distinct . implode(', ', $sql_data['select_fields']) . " \nFROM " . implode(', ', $sql_data['source_tables']);
+
+			// Where
+			$sql .= (!empty($schema['where'])) ? "\nWHERE (" . $schema['where'] . ')' : '';
+
+			// Group By
+			if (!empty($schema['group_by']))
+			{
+				$schema['group_by'] = array($schema['group_by']);
+				foreach ($sql_data['select_fields'] as $select)
+				{
+					$alias = strpos(strtolower($select), ' as ');
+					$select = ($alias) ? substr($select, 0, $alias) : $select;
+					if (!in_array($select, $schema['group_by']))
+					{
+						$schema['group_by'][] = $select;
+					}
+				}
+			}
+			$sql .= (!empty($schema['group_by'])) ? "\nGROUP BY " . implode(', ', $schema['group_by']) : '';
+
+			// Having
+			$sql .= (!empty($schema['having'])) ? "\nHAVING " . $schema['having'] : '';
+
+			// Order By
+			if (empty($schema['order_by']) && !empty($schema['primary']))
+			{
+				$schema['order_by'] = $schema['primary'];
+			}
+			$sql .= (!empty($schema['order_by'])) ? "\nORDER BY " . $schema['order_by'] : '';
+
+			// Counting basically holds the amount of rows processed.
+			$counting = -1;
+			$batch_time = 0;
+
+			while ($counting === -1 || ($counting >= $convert->batch_size && still_on_time()))
+			{
+				$old_current_table = $current_table;
+
+				$rows = '';
+				$waiting_rows = array();
+
+				if (!empty($batch_time))
+				{
+					$mtime = explode(' ', microtime());
+					$mtime = $mtime[0] + $mtime[1];
+					$rows = ceil($counting/($mtime - $batch_time)) . " rows/s ($counting rows) | ";
+				}
+
+				$this->template->assign_block_vars('checks', array(
+					'TITLE'		=> "skip_rows = $skip_rows",
+					'RESULT'	=> $rows . ((defined('DEBUG') && function_exists('memory_get_usage')) ? ceil(memory_get_usage()/1024) . ' ' . $user->lang['KIB'] : ''),
+				));
+
+				$mtime = explode(' ', microtime());
+				$batch_time = $mtime[0] + $mtime[1];
+
+				if ($convert->mysql_convert && $same_db)
+				{
+					$src_db->sql_query("SET NAMES 'binary'");
+				}
+
+				// Take skip rows into account and only fetch batch_size amount of rows
+				$___result = $src_db->sql_query_limit($sql, $convert->batch_size, $skip_rows);
+
+				if ($convert->mysql_convert && $same_db)
+				{
+					$src_db->sql_query("SET NAMES 'utf8'");
+				}
+
+				// This loop processes each row
+				$counting = 0;
+
+				$convert->row = $convert_row = array();
+
+				if (!empty($schema['autoincrement']))
+				{
+					switch ($db->get_sql_layer())
+					{
+						case 'mssql':
+						case 'mssql_odbc':
+						case 'mssqlnative':
+							$db->sql_query('SET IDENTITY_INSERT ' . $schema['target'] . ' ON');
+							break;
+					}
+				}
+
+				// Now handle the rows until time is over or no more rows to process...
+				while ($counting === 0 || still_on_time())
+				{
+					$convert_row = $src_db->sql_fetchrow($___result);
+
+					if (!$convert_row)
+					{
+						// move to the next batch or table
+						break;
+					}
+
+					// With this we are able to always save the last state
+					$convert->row = $convert_row;
+
+					// Increment the counting variable, it stores the number of rows we have processed
+					$counting++;
+
+					$insert_values = array();
+
+					$sql_flag = $this->process_row($schema, $sql_data, $insert_values);
+
+					if ($sql_flag === true)
+					{
+						switch ($db->get_sql_layer())
+						{
+							// If MySQL, we'll wait to have num_wait_rows rows to submit at once
+							case 'mysql':
+							case 'mysql4':
+							case 'mysqli':
+								$waiting_rows[] = '(' . implode(', ', $insert_values) . ')';
+
+								if (sizeof($waiting_rows) >= $convert->num_wait_rows)
+								{
+									$errored = false;
+
+									$db->sql_return_on_error(true);
+
+									if (!$db->sql_query($insert_query . implode(', ', $waiting_rows)))
+									{
+										$errored = true;
+									}
+									$db->sql_return_on_error(false);
+
+									if ($errored)
+									{
+										$db->sql_return_on_error(true);
+
+										// Because it errored out we will try to insert the rows one by one... most of the time this
+										// is caused by duplicate entries - but we also do not want to miss one...
+										foreach ($waiting_rows as $waiting_sql)
+										{
+											if (!$db->sql_query($insert_query . $waiting_sql))
+											{
+												$this->db_error($user->lang['DB_ERR_INSERT'], htmlspecialchars($insert_query . $waiting_sql) . '<br /><br />' . htmlspecialchars(print_r($db->_sql_error(), true)), __LINE__, __FILE__, true);
+											}
+										}
+
+										$db->sql_return_on_error(false);
+									}
+
+									$waiting_rows = array();
+								}
+
+								break;
+
+							default:
+								$insert_sql = $insert_query . '(' . implode(', ', $insert_values) . ')';
+
+								$db->sql_return_on_error(true);
+
+								if (!$db->sql_query($insert_sql))
+								{
+									$this->db_error($user->lang['DB_ERR_INSERT'], htmlspecialchars($insert_sql) . '<br /><br />' . htmlspecialchars(print_r($db->_sql_error(), true)), __LINE__, __FILE__, true);
+								}
+								$db->sql_return_on_error(false);
+
+								$waiting_rows = array();
+
+								break;
+						}
+					}
+
+					$skip_rows++;
+				}
+				$src_db->sql_freeresult($___result);
+
+				// We might still have some rows waiting
+				if (sizeof($waiting_rows))
+				{
+					$errored = false;
+					$db->sql_return_on_error(true);
+
+					if (!$db->sql_query($insert_query . implode(', ', $waiting_rows)))
+					{
+						$errored = true;
+					}
+					$db->sql_return_on_error(false);
+
+					if ($errored)
+					{
+						$db->sql_return_on_error(true);
+
+						// Because it errored out we will try to insert the rows one by one... most of the time this
+						// is caused by duplicate entries - but we also do not want to miss one...
+						foreach ($waiting_rows as $waiting_sql)
+						{
+							$db->sql_query($insert_query . $waiting_sql);
+							$this->db_error($user->lang['DB_ERR_INSERT'], htmlspecialchars($insert_query . $waiting_sql) . '<br /><br />' . htmlspecialchars(print_r($db->_sql_error(), true)), __LINE__, __FILE__, true);
+						}
+
+						$db->sql_return_on_error(false);
+					}
+
+					$waiting_rows = array();
+				}
+
+				if (!empty($schema['autoincrement']))
+				{
+					switch ($db->get_sql_layer())
+					{
+						case 'mssql':
+						case 'mssql_odbc':
+						case 'mssqlnative':
+							$db->sql_query('SET IDENTITY_INSERT ' . $schema['target'] . ' OFF');
+							break;
+
+						case 'postgres':
+							$db->sql_query("SELECT SETVAL('" . $schema['target'] . "_seq',(select case when max(" . $schema['autoincrement'] . ")>0 then max(" . $schema['autoincrement'] . ")+1 else 1 end from " . $schema['target'] . '));');
+							break;
+
+						case 'oracle':
+							$result = $db->sql_query('SELECT MAX(' . $schema['autoincrement'] . ') as max_id FROM ' . $schema['target']);
+							$row = $db->sql_fetchrow($result);
+							$db->sql_freeresult($result);
+
+							$largest_id = (int) $row['max_id'];
+
+							if ($largest_id)
+							{
+								$db->sql_query('DROP SEQUENCE ' . $schema['target'] . '_seq');
+								$db->sql_query('CREATE SEQUENCE ' . $schema['target'] . '_seq START WITH ' . ($largest_id + 1));
+							}
+							break;
+					}
+				}
+			}
+
+			// When we reach this point, either the current table has been processed or we're running out of time.
+			if (still_on_time() && $counting < $convert->batch_size/* && !defined('DEBUG')*/)
+			{
+				$skip_rows = 0;
+				$current_table++;
+			}
+			else
+			{/*
+				if (still_on_time() && $counting < $convert->batch_size)
+				{
+					$skip_rows = 0;
+					$current_table++;
+				}*/
+
+				// Looks like we ran out of time.
+				$url = $this->save_convert_progress($converter, 'current_table=' . $current_table . '&amp;skip_rows=' . $skip_rows);
+
+				$current_table++;
+//				$percentage = ($skip_rows == 0) ? 0 : floor(100 / ($total_rows / $skip_rows));
+
+				$msg = sprintf($user->lang['STEP_PERCENT_COMPLETED'], $current_table, sizeof($convert->convertor['schema']));
+
+				$this->template->assign_vars(array(
+					'BODY'			=> $msg,
+					'L_SUBMIT'		=> $user->lang['CONTINUE_CONVERT'],
+					'U_ACTION'		=> $url,
+				));
+
+				$this->meta_refresh($url);
+				return;
+			}
+		}
+
+		// Process execute_last then we'll be done
+		$url = $this->save_convert_progress($converter, 'jump=1');
+
+		$this->template->assign_vars(array(
+			'L_SUBMIT'		=> $user->lang['FINAL_STEP'],
+			'U_ACTION'		=> $url,
+		));
+
+		$this->meta_refresh($url);
+		return;
+	}
+
+	/**
+	 * Sync function being executed at the middle, some functions need to be executed after a successful sync.
+	 */
+	function sync_forums($converter, $sync_batch)
+	{
+		global $user, $db, $phpbb_root_path, $phpEx, $config, $cache;
+		global $convert;
+
+		include_once ($phpbb_root_path . 'includes/functions_admin.' . $phpEx);
+
+		$this->template->assign_block_vars('checks', array(
+			'S_LEGEND'	=> true,
+			'LEGEND'	=> $user->lang['SYNC_TOPICS'],
+		));
+
+		$batch_size = $convert->batch_size;
+
+		$sql = 'SELECT MIN(topic_id) as min_value, MAX(topic_id) AS max_value
+			FROM ' . TOPICS_TABLE;
+		$result = $db->sql_query($sql);
+		$row = $db->sql_fetchrow($result);
+		$db->sql_freeresult($result);
+
+		// Set values of minimum/maximum primary value for this table.
+		$primary_min = $row['min_value'];
+		$primary_max = $row['max_value'];
+
+		if ($sync_batch == 0)
+		{
+			$sync_batch = (int) $primary_min;
+		}
+
+		if ($sync_batch == 0)
+		{
+			$sync_batch = 1;
+		}
+
+		// Fetch a batch of rows, process and insert them.
+		while ($sync_batch <= $primary_max && still_on_time())
+		{
+			$end = ($sync_batch + $batch_size - 1);
+
+			// Sync all topics in batch mode...
+			sync('topic', 'range', 'topic_id BETWEEN ' . $sync_batch . ' AND ' . $end, true, true);
+
+			$this->template->assign_block_vars('checks', array(
+				'TITLE'		=> sprintf($user->lang['SYNC_TOPIC_ID'], $sync_batch, ($sync_batch + $batch_size)) . ((defined('DEBUG') && function_exists('memory_get_usage')) ? ' [' . ceil(memory_get_usage()/1024) . ' ' . $user->lang['KIB'] . ']' : ''),
+				'RESULT'	=> $user->lang['DONE'],
+			));
+
+			$sync_batch += $batch_size;
+		}
+
+		if ($sync_batch >= $primary_max)
+		{
+			$url = $this->save_convert_progress($converter, 'final_jump=1');
+
+			$this->template->assign_vars(array(
+				'L_SUBMIT'		=> $user->lang['CONTINUE_CONVERT'],
+				'U_ACTION'		=> $url,
+			));
+
+			$this->meta_refresh($url);
+			return;
+		}
+		else
+		{
+			$sync_batch--;
+		}
+
+		$url = $this->save_convert_progress($converter, 'sync_batch=' . $sync_batch);
+
+		$this->template->assign_vars(array(
+			'L_SUBMIT'		=> $user->lang['CONTINUE_CONVERT'],
+			'U_ACTION'		=> $url,
+		));
+
+		$this->meta_refresh($url);
+		return;
+	}
+
+	/**
+	 * Save the convertor status
+	 */
+	function save_convert_progress($convertor_tag, $step)
+	{
+		global $config, $convert, $language;
+
+		// Save convertor Status
+		$config->set('convert_progress', serialize(array(
+			'step'			=> $step,
+			'table_prefix'	=> $convert->src_table_prefix,
+			'tag'			=> $convert->convertor_tag,
+		)), false);
+
+		$config->set('convert_db_server', serialize(array(
+			'dbms'			=> $convert->src_dbms,
+			'dbhost'		=> $convert->src_dbhost,
+			'dbport'		=> $convert->src_dbport,
+			'dbname'		=> $convert->src_dbname,
+		)), false);
+
+		$config->set('convert_db_user', serialize(array(
+			'dbuser'		=> $convert->src_dbuser,
+			'dbpasswd'		=> $convert->src_dbpasswd,
+		)), false);
+
+		return $this->controller_helper->route('phpbb_convert_convert', array('converter' => $convertor_tag)) . '?' . $step;
+	}
+
+	/**
+	 * Finish conversion, the last function to be called.
+	 */
+	function finish_conversion()
+	{
+		global $db, $phpbb_root_path, $phpEx, $convert, $config, $language, $user;
+		global $cache, $auth, $phpbb_container, $phpbb_log;
+
+		include_once ($phpbb_root_path . 'includes/functions_admin.' . $phpEx);
+
+		$db->sql_query('DELETE FROM ' . CONFIG_TABLE . "
+			WHERE config_name = 'convert_progress'
+				OR config_name = 'convert_options'
+				OR config_name = 'convert_db_server'
+				OR config_name = 'convert_db_user'");
+		$db->sql_query('DELETE FROM ' . SESSIONS_TABLE);
+
+		@unlink($phpbb_root_path . 'cache/data_global.' . $phpEx);
+		phpbb_cache_moderators($db, $cache, $auth);
+
+		// And finally, add a note to the log
+		$phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_INSTALL_CONVERTED', false, array($convert->convertor_data['forum_name'], $config['version']));
+
+		$url = $this->controller_helper->route('phpbb_convert_finish');
+
+		$this->template->assign_vars(array(
+			'L_SUBMIT'		=> $user->lang['FINAL_STEP'],
+			'U_ACTION'		=> $url,
+		));
+
+		$this->meta_refresh($url);
+		return;
+	}
+
+	/**
+	 * This function marks the steps after syncing
+	 */
+	function final_jump($final_jump)
+	{
+		global $user, $src_db, $same_db, $db, $phpbb_root_path, $phpEx, $config, $cache;
+		global $convert;
+
+		$this->template->assign_block_vars('checks', array(
+			'S_LEGEND'	=> true,
+			'LEGEND'	=> $user->lang['PROCESS_LAST'],
+		));
+
+		if ($final_jump == 1)
+		{
+			$db->sql_return_on_error(true);
+
+			update_topics_posted();
+
+			$this->template->assign_block_vars('checks', array(
+				'TITLE'		=> $user->lang['UPDATE_TOPICS_POSTED'],
+				'RESULT'	=> $user->lang['DONE'],
+			));
+
+			if ($db->get_sql_error_triggered())
+			{
+				$this->template->assign_vars(array(
+					'S_ERROR_BOX'	=> true,
+					'ERROR_TITLE'	=> $user->lang['UPDATE_TOPICS_POSTED'],
+					'ERROR_MSG'		=> $user->lang['UPDATE_TOPICS_POSTED_ERR'],
+				));
+			}
+			$db->sql_return_on_error(false);
+
+			$this->finish_conversion();
+			return;
+		}
+	}
+
+	/**
+	 * This function marks the steps before syncing (jump=1)
+	 */
+	function jump($converter, $jump, $last_statement)
+	{
+		/** @var \phpbb\db\driver\driver_interface $src_db */
+		/** @var \phpbb\cache\driver\driver_interface $cache */
+		global $user, $src_db, $same_db, $db, $phpbb_root_path, $phpEx, $config, $cache;
+		global $convert;
+
+		include_once ($phpbb_root_path . 'includes/functions_admin.' . $phpEx);
+
+		$this->template->assign_block_vars('checks', array(
+			'S_LEGEND'	=> true,
+			'LEGEND'	=> $user->lang['PROCESS_LAST'],
+		));
+
+		if ($jump == 1)
+		{
+			// Execute 'last' statements/queries
+			if (!empty($convert->convertor['execute_last']))
+			{
+				if (!is_array($convert->convertor['execute_last']))
+				{
+					// @codingStandardsIgnoreStart
+					eval($convert->convertor['execute_last']);
+					// @codingStandardsIgnoreEnd
+				}
+				else
+				{
+					while ($last_statement < sizeof($convert->convertor['execute_last']))
+					{
+						// @codingStandardsIgnoreStart
+						eval($convert->convertor['execute_last'][$last_statement]);
+						// @codingStandardsIgnoreEnd
+
+						$this->template->assign_block_vars('checks', array(
+							'TITLE'		=> $convert->convertor['execute_last'][$last_statement],
+							'RESULT'	=> $user->lang['DONE'],
+						));
+
+						$last_statement++;
+						$url = $this->save_convert_progress($converter, 'jump=1&amp;last=' . $last_statement);
+
+						$percentage = ($last_statement == 0) ? 0 : floor(100 / (sizeof($convert->convertor['execute_last']) / $last_statement));
+						$msg = sprintf($user->lang['STEP_PERCENT_COMPLETED'], $last_statement, sizeof($convert->convertor['execute_last']), $percentage);
+
+						$this->template->assign_vars(array(
+							'L_SUBMIT'		=> $user->lang['CONTINUE_LAST'],
+							'BODY'			=> $msg,
+							'U_ACTION'		=> $url,
+						));
+
+						$this->meta_refresh($url);
+						return;
+					}
+				}
+			}
+
+			if (!empty($convert->convertor['query_last']))
+			{
+				if (!is_array($convert->convertor['query_last']))
+				{
+					$convert->convertor['query_last'] = array('target', array($convert->convertor['query_last']));
+				}
+				else if (!is_array($convert->convertor['query_last'][0]))
+				{
+					$convert->convertor['query_last'] = array(array($convert->convertor['query_last'][0], $convert->convertor['query_last'][1]));
+				}
+
+				foreach ($convert->convertor['query_last'] as $query_last)
+				{
+					if ($query_last[0] == 'src')
+					{
+						if ($convert->mysql_convert && $same_db)
+						{
+							$src_db->sql_query("SET NAMES 'binary'");
+						}
+
+						$src_db->sql_query($query_last[1]);
+
+						if ($convert->mysql_convert && $same_db)
+						{
+							$src_db->sql_query("SET NAMES 'utf8'");
+						}
+					}
+					else
+					{
+						$db->sql_query($query_last[1]);
+					}
+				}
+			}
+
+			// Sanity check
+			$db->sql_return_on_error(false);
+			$src_db->sql_return_on_error(false);
+
+			fix_empty_primary_groups();
+
+			$sql = 'SELECT MIN(user_regdate) AS board_startdate
+				FROM ' . USERS_TABLE;
+			$result = $db->sql_query($sql);
+			$row = $db->sql_fetchrow($result);
+			$db->sql_freeresult($result);
+
+			if (!isset($config['board_startdate']) || ($row['board_startdate'] < $config['board_startdate'] && $row['board_startdate'] > 0))
+			{
+				$config->set('board_startdate', $row['board_startdate']);
+				$db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_regdate = ' . $row['board_startdate'] . ' WHERE user_id = ' . ANONYMOUS);
+			}
+
+			update_dynamic_config();
+
+			$this->template->assign_block_vars('checks', array(
+				'TITLE'		=> $user->lang['CLEAN_VERIFY'],
+				'RESULT'	=> $user->lang['DONE'],
+			));
+
+			$url = $this->save_convert_progress($converter, 'jump=2');
+
+			$this->template->assign_vars(array(
+				'L_SUBMIT'		=> $user->lang['CONTINUE_CONVERT'],
+				'U_ACTION'		=> $url,
+			));
+
+			$this->meta_refresh($url);
+			return;
+		}
+
+		if ($jump == 2)
+		{
+			$db->sql_query('UPDATE ' . USERS_TABLE . " SET user_permissions = ''");
+
+			// TODO: sync() is likely going to bomb out on forums with a considerable amount of topics.
+			// TODO: the sync function is able to handle FROM-TO values, we should use them here (batch processing)
+			sync('forum', '', '', false, true);
+			$cache->destroy('sql', FORUMS_TABLE);
+
+			$this->template->assign_block_vars('checks', array(
+				'TITLE'		=> $user->lang['SYNC_FORUMS'],
+				'RESULT'	=> $user->lang['DONE'],
+			));
+
+			// Continue with synchronizing the forums...
+			$url = $this->save_convert_progress($converter, 'sync_batch=0');
+
+			$this->template->assign_vars(array(
+				'L_SUBMIT'		=> $user->lang['CONTINUE_CONVERT'],
+				'U_ACTION'		=> $url,
+			));
+
+			$this->meta_refresh($url);
+			return;
+		}
+	}
+
+	function build_insert_query(&$schema, &$sql_data, $current_table)
+	{
+		global $db, $user;
+		global $convert;
+
+		// Can we use IGNORE with this DBMS?
+		$sql_ignore = (strpos($db->get_sql_layer(), 'mysql') === 0 && !defined('DEBUG')) ? 'IGNORE ' : '';
+		$insert_query = 'INSERT ' . $sql_ignore . 'INTO ' . $schema['target'] . ' (';
+
+		$aliases = array();
+
+		$sql_data = array(
+			'source_fields'		=> array(),
+			'target_fields'		=> array(),
+			'source_tables'		=> array(),
+			'select_fields'		=> array(),
+		);
+
+		foreach ($schema as $key => $val)
+		{
+			// Example: array('group_name',				'extension_groups.group_name',		'htmlspecialchars'),
+			if (is_int($key))
+			{
+				if (!empty($val[0]))
+				{
+					// Target fields
+					$sql_data['target_fields'][$val[0]] = $key;
+					$insert_query .= $val[0] . ', ';
+				}
+
+				if (!is_array($val[1]))
+				{
+					$val[1] = array($val[1]);
+				}
+
+				foreach ($val[1] as $valkey => $value_1)
+				{
+					// This should cover about any case:
+					//
+					// table.field					=> SELECT table.field				FROM table
+					// table.field AS alias			=> SELECT table.field	AS alias	FROM table
+					// table.field AS table2.alias	=> SELECT table2.field	AS alias	FROM table table2
+					// table.field AS table2.field	=> SELECT table2.field				FROM table table2
+					//
+					if (preg_match('/^([a-z0-9_]+)\.([a-z0-9_]+)( +AS +(([a-z0-9_]+?)\.)?([a-z0-9_]+))?$/i', $value_1, $m))
+					{
+						// There is 'AS ...' in the field names
+						if (!empty($m[3]))
+						{
+							$value_1 = ($m[2] == $m[6]) ? $m[1] . '.' . $m[2] : $m[1] . '.' . $m[2] . ' AS ' . $m[6];
+
+							// Table alias: store it then replace the source table with it
+							if (!empty($m[5]) && $m[5] != $m[1])
+							{
+								$aliases[$m[5]] = $m[1];
+								$value_1 = str_replace($m[1] . '.' . $m[2], $m[5] . '.' . $m[2], $value_1);
+							}
+						}
+						else
+						{
+							// No table alias
+							$sql_data['source_tables'][$m[1]] = (empty($convert->src_table_prefix)) ? $m[1] : $convert->src_table_prefix . $m[1] . ' ' . $m[1];
+						}
+
+						$sql_data['select_fields'][$value_1] = $value_1;
+						$sql_data['source_fields'][$key][$valkey] = (!empty($m[6])) ? $m[6] : $m[2];
+					}
+				}
+			}
+			else if ($key == 'where' || $key == 'group_by' || $key == 'order_by' || $key == 'having')
+			{
+				if (@preg_match_all('/([a-z0-9_]+)\.([a-z0-9_]+)/i', $val, $m))
+				{
+					foreach ($m[1] as $value)
+					{
+						$sql_data['source_tables'][$value] = (empty($convert->src_table_prefix)) ? $value : $convert->src_table_prefix . $value . ' ' . $value;
+					}
+				}
+			}
+		}
+
+		// Add the aliases to the list of tables
+		foreach ($aliases as $alias => $table)
+		{
+			$sql_data['source_tables'][$alias] = $convert->src_table_prefix . $table . ' ' . $alias;
+		}
+
+		// 'left_join'		=> 'forums LEFT JOIN forum_prune ON forums.forum_id = forum_prune.forum_id',
+		if (!empty($schema['left_join']))
+		{
+			if (!is_array($schema['left_join']))
+			{
+				$schema['left_join'] = array($schema['left_join']);
+			}
+
+			foreach ($schema['left_join'] as $left_join)
+			{
+				// This won't handle concatened LEFT JOINs
+				if (!preg_match('/([a-z0-9_]+) LEFT JOIN ([a-z0-9_]+) A?S? ?([a-z0-9_]*?) ?(ON|USING)(.*)/i', $left_join, $m))
+				{
+					$this->error(sprintf($user->lang['NOT_UNDERSTAND'], 'LEFT JOIN', $left_join, $current_table, $schema['target']), __LINE__, __FILE__);
+				}
+
+				if (!empty($aliases[$m[2]]))
+				{
+					if (!empty($m[3]))
+					{
+						$this->error(sprintf($user->lang['NAMING_CONFLICT'], $m[2], $m[3], $schema['left_join']), __LINE__, __FILE__);
+					}
+
+					$m[2] = $aliases[$m[2]];
+					$m[3] = $m[2];
+				}
+
+				$right_table = $convert->src_table_prefix . $m[2];
+				if (!empty($m[3]))
+				{
+					unset($sql_data['source_tables'][$m[3]]);
+				}
+				else if ($m[2] != $m[1])
+				{
+					unset($sql_data['source_tables'][$m[2]]);
+				}
+
+				if (strpos($sql_data['source_tables'][$m[1]], "\nLEFT JOIN") !== false)
+				{
+					$sql_data['source_tables'][$m[1]] = '(' . $sql_data['source_tables'][$m[1]] . ")\nLEFT JOIN $right_table";
+				}
+				else
+				{
+					$sql_data['source_tables'][$m[1]] .= "\nLEFT JOIN $right_table";
+				}
+
+				if (!empty($m[3]))
+				{
+					unset($sql_data['source_tables'][$m[3]]);
+					$sql_data['source_tables'][$m[1]] .= ' AS ' . $m[3];
+				}
+				else if (!empty($convert->src_table_prefix))
+				{
+					$sql_data['source_tables'][$m[1]] .= ' AS ' . $m[2];
+				}
+				$sql_data['source_tables'][$m[1]] .= ' ' . $m[4] . $m[5];
+			}
+		}
+
+		// Remove ", " from the end of the insert query
+		$insert_query = substr($insert_query, 0, -2) . ') VALUES ';
+
+		return $insert_query;
+	}
+
+	/**
+	 * Function for processing the currently handled row
+	 */
+	function process_row(&$schema, &$sql_data, &$insert_values)
+	{
+		global $user, $phpbb_root_path, $phpEx, $db, $lang, $config, $cache;
+		global $convert, $convert_row;
+
+		$sql_flag = false;
+
+		foreach ($schema as $key => $fields)
+		{
+			// We are only interested in the lines with:
+			// array('comment', 'attachments_desc.comment', 'htmlspecialchars'),
+			if (is_int($key))
+			{
+				if (!is_array($fields[1]))
+				{
+					$fields[1] = array($fields[1]);
+				}
+
+				$firstkey_set = false;
+				$firstkey = 0;
+
+				foreach ($fields[1] as $inner_key => $inner_value)
+				{
+					if (!$firstkey_set)
+					{
+						$firstkey = $inner_key;
+						$firstkey_set = true;
+					}
+
+					$src_field = isset($sql_data['source_fields'][$key][$inner_key]) ? $sql_data['source_fields'][$key][$inner_key] : '';
+
+					if (!empty($src_field))
+					{
+						$fields[1][$inner_key] = $convert->row[$src_field];
+					}
+				}
+
+				if (!empty($fields[0]))
+				{
+					// We have a target field, if we haven't set $sql_flag yet it will be set to TRUE.
+					// If a function has already set it to FALSE it won't change it.
+					if ($sql_flag === false)
+					{
+						$sql_flag = true;
+					}
+
+					// No function assigned?
+					if (empty($fields[2]))
+					{
+						$value = $fields[1][$firstkey];
+					}
+					else if (is_array($fields[2]) && !is_callable($fields[2]))
+					{
+						// Execute complex function/eval/typecast
+						$value = $fields[1];
+
+						foreach ($fields[2] as $type => $execution)
+						{
+							if (strpos($type, 'typecast') === 0)
+							{
+								if (!is_array($value))
+								{
+									$value = array($value);
+								}
+								$value = $value[0];
+								settype($value, $execution);
+							}
+							else if (strpos($type, 'function') === 0)
+							{
+								if (!is_array($value))
+								{
+									$value = array($value);
+								}
+
+								$value = call_user_func_array($execution, $value);
+							}
+							else if (strpos($type, 'execute') === 0)
+							{
+								if (!is_array($value))
+								{
+									$value = array($value);
+								}
+
+								$execution = str_replace('{RESULT}', '$value', $execution);
+								$execution = str_replace('{VALUE}', '$value', $execution);
+								// @codingStandardsIgnoreStart
+								eval($execution);
+								// @codingStandardsIgnoreEnd
+							}
+						}
+					}
+					else
+					{
+						$value = call_user_func_array($fields[2], $fields[1]);
+					}
+
+					if (is_null($value))
+					{
+						$value = '';
+					}
+
+					$insert_values[] = $db->_sql_validate_value($value);
+				}
+				else if (!empty($fields[2]))
+				{
+					if (is_array($fields[2]))
+					{
+						// Execute complex function/eval/typecast
+						$value = '';
+
+						foreach ($fields[2] as $type => $execution)
+						{
+							if (strpos($type, 'typecast') === 0)
+							{
+								$value = settype($value, $execution);
+							}
+							else if (strpos($type, 'function') === 0)
+							{
+								if (!is_array($value))
+								{
+									$value = array($value);
+								}
+
+								$value = call_user_func_array($execution, $value);
+							}
+							else if (strpos($type, 'execute') === 0)
+							{
+								if (!is_array($value))
+								{
+									$value = array($value);
+								}
+
+								$execution = str_replace('{RESULT}', '$value', $execution);
+								$execution = str_replace('{VALUE}', '$value', $execution);
+								// @codingStandardsIgnoreStart
+								eval($execution);
+								// @codingStandardsIgnoreEnd
+							}
+						}
+					}
+					else
+					{
+						call_user_func_array($fields[2], $fields[1]);
+					}
+				}
+			}
+		}
+
+		return $sql_flag;
+	}
+
+	/**
+	 * Own meta refresh function to be able to change the global time used
+	 */
+	function meta_refresh($url)
+	{
+		global $convert;
+
+		if ($convert->options['refresh'])
+		{
+			// Because we should not rely on correct settings, we simply use the relative path here directly.
+			$this->template->assign_vars(array(
+					'S_REFRESH'	=> true,
+					'META'		=> '<meta http-equiv="refresh" content="5; url=' . $url . '" />')
+			);
+		}
+	}
+
+	/**
+	 * Error handler function
+	 *
+	 * This function needs to be kept for BC
+	 *
+	 * @param $error
+	 * @param $line
+	 * @param $file
+	 * @param bool|false $skip
+	 */
+	public function error($error, $line, $file, $skip = false)
+	{
+		$this->template->assign_block_vars('errors', array(
+			'TITLE'	=> $error,
+			'DESCRIPTION' => 'In ' . $file . ' on line ' . $line,
+		));
+	}
+
+	/**
+	 * Database error handler function
+	 *
+	 * This function needs to be kept for BC
+	 *
+	 * @param $error
+	 * @param $sql
+	 * @param $line
+	 * @param $file
+	 * @param bool|false $skip
+	 */
+	public function db_error($error, $sql, $line, $file, $skip = false)
+	{
+		$this->template->assign_block_vars('errors', array(
+			'TITLE'	=> $error,
+			'DESCRIPTION' => 'In ' . $file . ' on line ' . $line . '<br /><br /><strong>SQL:</strong> ' . $sql,
+		));
+	}
+}
diff --git a/phpBB/install/convertors/convert_phpbb20.php b/phpBB/install/convertors/convert_phpbb20.php
index 282b3d238a..414d23623a 100644
--- a/phpBB/install/convertors/convert_phpbb20.php
+++ b/phpBB/install/convertors/convert_phpbb20.php
@@ -38,7 +38,7 @@ $dbms = $phpbb_config_php_file->convert_30_dbms_to_31($dbms);
 $convertor_data = array(
 	'forum_name'	=> 'phpBB 2.0.x',
 	'version'		=> '1.0.3',
-	'phpbb_version'	=> '3.2.0-a2',
+	'phpbb_version'	=> '3.2.0-b1',
 	'author'		=> '<a href="https://www.phpbb.com/">phpBB Limited</a>',
 	'dbms'			=> $dbms,
 	'dbhost'		=> $dbhost,
diff --git a/phpBB/install/phpbbcli.php b/phpBB/install/phpbbcli.php
index 649d0c4283..70a8a9c7ea 100755
--- a/phpBB/install/phpbbcli.php
+++ b/phpBB/install/phpbbcli.php
@@ -23,7 +23,7 @@ if (php_sapi_name() !== 'cli')
 define('IN_PHPBB', true);
 define('IN_INSTALL', true);
 define('PHPBB_ENVIRONMENT', 'production');
-define('PHPBB_VERSION', '3.2.0-a2-dev');
+define('PHPBB_VERSION', '3.2.0-b2-dev');
 $phpbb_root_path = __DIR__ . '/../';
 $phpEx = substr(strrchr(__FILE__, '.'), 1);
 
diff --git a/phpBB/install/schemas/schema.json b/phpBB/install/schemas/schema.json
new file mode 100644
index 0000000000..ce2263b7d1
--- /dev/null
+++ b/phpBB/install/schemas/schema.json
@@ -0,0 +1,3389 @@
+{
+    "phpbb_acl_groups": {
+        "COLUMNS": {
+            "group_id": [
+                "UINT",
+                0
+            ],
+            "forum_id": [
+                "UINT",
+                0
+            ],
+            "auth_option_id": [
+                "UINT",
+                0
+            ],
+            "auth_role_id": [
+                "UINT",
+                0
+            ],
+            "auth_setting": [
+                "TINT:2",
+                0
+            ]
+        },
+        "KEYS": {
+            "group_id": [
+                "INDEX",
+                "group_id"
+            ],
+            "auth_opt_id": [
+                "INDEX",
+                "auth_option_id"
+            ],
+            "auth_role_id": [
+                "INDEX",
+                "auth_role_id"
+            ]
+        }
+    },
+    "phpbb_acl_options": {
+        "COLUMNS": {
+            "auth_option_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "auth_option": [
+                "VCHAR:50",
+                ""
+            ],
+            "is_global": [
+                "BOOL",
+                0
+            ],
+            "is_local": [
+                "BOOL",
+                0
+            ],
+            "founder_only": [
+                "BOOL",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "auth_option_id",
+        "KEYS": {
+            "auth_option": [
+                "UNIQUE",
+                [
+                    "auth_option"
+                ]
+            ]
+        }
+    },
+    "phpbb_acl_roles": {
+        "COLUMNS": {
+            "role_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "role_name": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "role_description": [
+                "TEXT_UNI",
+                ""
+            ],
+            "role_type": [
+                "VCHAR:10",
+                ""
+            ],
+            "role_order": [
+                "USINT",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "role_id",
+        "KEYS": {
+            "role_type": [
+                "INDEX",
+                "role_type"
+            ],
+            "role_order": [
+                "INDEX",
+                "role_order"
+            ]
+        }
+    },
+    "phpbb_acl_roles_data": {
+        "COLUMNS": {
+            "role_id": [
+                "UINT",
+                0
+            ],
+            "auth_option_id": [
+                "UINT",
+                0
+            ],
+            "auth_setting": [
+                "TINT:2",
+                0
+            ]
+        },
+        "PRIMARY_KEY": [
+            "role_id",
+            "auth_option_id"
+        ],
+        "KEYS": {
+            "ath_op_id": [
+                "INDEX",
+                "auth_option_id"
+            ]
+        }
+    },
+    "phpbb_acl_users": {
+        "COLUMNS": {
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "forum_id": [
+                "UINT",
+                0
+            ],
+            "auth_option_id": [
+                "UINT",
+                0
+            ],
+            "auth_role_id": [
+                "UINT",
+                0
+            ],
+            "auth_setting": [
+                "TINT:2",
+                0
+            ]
+        },
+        "KEYS": {
+            "user_id": [
+                "INDEX",
+                "user_id"
+            ],
+            "auth_option_id": [
+                "INDEX",
+                "auth_option_id"
+            ],
+            "auth_role_id": [
+                "INDEX",
+                "auth_role_id"
+            ]
+        }
+    },
+    "phpbb_attachments": {
+        "COLUMNS": {
+            "attach_id": [
+                "ULINT",
+                null,
+                "auto_increment"
+            ],
+            "post_msg_id": [
+                "ULINT",
+                0
+            ],
+            "topic_id": [
+                "ULINT",
+                0
+            ],
+            "in_message": [
+                "BOOL",
+                0
+            ],
+            "poster_id": [
+                "ULINT",
+                0
+            ],
+            "is_orphan": [
+                "BOOL",
+                1
+            ],
+            "physical_filename": [
+                "VCHAR",
+                ""
+            ],
+            "real_filename": [
+                "VCHAR",
+                ""
+            ],
+            "download_count": [
+                "UINT",
+                0
+            ],
+            "attach_comment": [
+                "TEXT_UNI",
+                ""
+            ],
+            "extension": [
+                "VCHAR:100",
+                ""
+            ],
+            "mimetype": [
+                "VCHAR:100",
+                ""
+            ],
+            "filesize": [
+                "UINT:20",
+                0
+            ],
+            "filetime": [
+                "TIMESTAMP",
+                0
+            ],
+            "thumbnail": [
+                "BOOL",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "attach_id",
+        "KEYS": {
+            "filetime": [
+                "INDEX",
+                "filetime"
+            ],
+            "post_msg_id": [
+                "INDEX",
+                "post_msg_id"
+            ],
+            "topic_id": [
+                "INDEX",
+                "topic_id"
+            ],
+            "poster_id": [
+                "INDEX",
+                "poster_id"
+            ],
+            "is_orphan": [
+                "INDEX",
+                "is_orphan"
+            ]
+        }
+    },
+    "phpbb_banlist": {
+        "COLUMNS": {
+            "ban_id": [
+                "ULINT",
+                null,
+                "auto_increment"
+            ],
+            "ban_userid": [
+                "ULINT",
+                0
+            ],
+            "ban_ip": [
+                "VCHAR:40",
+                ""
+            ],
+            "ban_email": [
+                "VCHAR_UNI:100",
+                ""
+            ],
+            "ban_start": [
+                "TIMESTAMP",
+                0
+            ],
+            "ban_end": [
+                "TIMESTAMP",
+                0
+            ],
+            "ban_exclude": [
+                "BOOL",
+                0
+            ],
+            "ban_reason": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "ban_give_reason": [
+                "VCHAR_UNI",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "ban_id",
+        "KEYS": {
+            "ban_end": [
+                "INDEX",
+                "ban_end"
+            ],
+            "ban_user": [
+                "INDEX",
+                [
+                    "ban_userid",
+                    "ban_exclude"
+                ]
+            ],
+            "ban_email": [
+                "INDEX",
+                [
+                    "ban_email",
+                    "ban_exclude"
+                ]
+            ],
+            "ban_ip": [
+                "INDEX",
+                [
+                    "ban_ip",
+                    "ban_exclude"
+                ]
+            ]
+        }
+    },
+    "phpbb_bbcodes": {
+        "COLUMNS": {
+            "bbcode_id": [
+                "USINT",
+                0
+            ],
+            "bbcode_tag": [
+                "VCHAR:16",
+                ""
+            ],
+            "bbcode_helpline": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "display_on_posting": [
+                "BOOL",
+                0
+            ],
+            "bbcode_match": [
+                "TEXT_UNI",
+                ""
+            ],
+            "bbcode_tpl": [
+                "MTEXT_UNI",
+                ""
+            ],
+            "first_pass_match": [
+                "MTEXT_UNI",
+                ""
+            ],
+            "first_pass_replace": [
+                "MTEXT_UNI",
+                ""
+            ],
+            "second_pass_match": [
+                "MTEXT_UNI",
+                ""
+            ],
+            "second_pass_replace": [
+                "MTEXT_UNI",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "bbcode_id",
+        "KEYS": {
+            "display_on_post": [
+                "INDEX",
+                "display_on_posting"
+            ]
+        }
+    },
+    "phpbb_bookmarks": {
+        "COLUMNS": {
+            "topic_id": [
+                "ULINT",
+                0
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ]
+        },
+        "PRIMARY_KEY": [
+            "topic_id",
+            "user_id"
+        ]
+    },
+    "phpbb_bots": {
+        "COLUMNS": {
+            "bot_id": [
+                "ULINT",
+                null,
+                "auto_increment"
+            ],
+            "bot_active": [
+                "BOOL",
+                1
+            ],
+            "bot_name": [
+                "STEXT_UNI",
+                ""
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "bot_agent": [
+                "VCHAR",
+                ""
+            ],
+            "bot_ip": [
+                "VCHAR",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "bot_id",
+        "KEYS": {
+            "bot_active": [
+                "INDEX",
+                "bot_active"
+            ]
+        }
+    },
+    "phpbb_config": {
+        "COLUMNS": {
+            "config_name": [
+                "VCHAR",
+                ""
+            ],
+            "config_value": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "is_dynamic": [
+                "BOOL",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "config_name",
+        "KEYS": {
+            "is_dynamic": [
+                "INDEX",
+                "is_dynamic"
+            ]
+        }
+    },
+    "phpbb_config_text": {
+        "COLUMNS": {
+            "config_name": [
+                "VCHAR",
+                ""
+            ],
+            "config_value": [
+                "MTEXT",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "config_name"
+    },
+    "phpbb_confirm": {
+        "COLUMNS": {
+            "confirm_id": [
+                "CHAR:32",
+                ""
+            ],
+            "session_id": [
+                "CHAR:32",
+                ""
+            ],
+            "confirm_type": [
+                "TINT:3",
+                0
+            ],
+            "code": [
+                "VCHAR:8",
+                ""
+            ],
+            "seed": [
+                "UINT:10",
+                0
+            ],
+            "attempts": [
+                "UINT",
+                0
+            ]
+        },
+        "PRIMARY_KEY": [
+            "session_id",
+            "confirm_id"
+        ],
+        "KEYS": {
+            "confirm_type": [
+                "INDEX",
+                "confirm_type"
+            ]
+        }
+    },
+    "phpbb_disallow": {
+        "COLUMNS": {
+            "disallow_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "disallow_username": [
+                "VCHAR_UNI:255",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "disallow_id"
+    },
+    "phpbb_drafts": {
+        "COLUMNS": {
+            "draft_id": [
+                "ULINT",
+                null,
+                "auto_increment"
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "topic_id": [
+                "ULINT",
+                0
+            ],
+            "forum_id": [
+                "UINT",
+                0
+            ],
+            "save_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "draft_subject": [
+                "STEXT_UNI",
+                ""
+            ],
+            "draft_message": [
+                "MTEXT_UNI",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "draft_id",
+        "KEYS": {
+            "save_time": [
+                "INDEX",
+                "save_time"
+            ]
+        }
+    },
+    "phpbb_ext": {
+        "COLUMNS": {
+            "ext_name": [
+                "VCHAR",
+                ""
+            ],
+            "ext_active": [
+                "BOOL",
+                0
+            ],
+            "ext_state": [
+                "TEXT",
+                ""
+            ]
+        },
+        "KEYS": {
+            "ext_name": [
+                "UNIQUE",
+                "ext_name"
+            ]
+        }
+    },
+    "phpbb_extension_groups": {
+        "COLUMNS": {
+            "group_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "group_name": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "cat_id": [
+                "TINT:2",
+                0
+            ],
+            "allow_group": [
+                "BOOL",
+                0
+            ],
+            "download_mode": [
+                "BOOL",
+                1
+            ],
+            "upload_icon": [
+                "VCHAR",
+                ""
+            ],
+            "max_filesize": [
+                "UINT:20",
+                0
+            ],
+            "allowed_forums": [
+                "TEXT",
+                ""
+            ],
+            "allow_in_pm": [
+                "BOOL",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "group_id"
+    },
+    "phpbb_extensions": {
+        "COLUMNS": {
+            "extension_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "group_id": [
+                "UINT",
+                0
+            ],
+            "extension": [
+                "VCHAR:100",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "extension_id"
+    },
+    "phpbb_forums": {
+        "COLUMNS": {
+            "forum_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "parent_id": [
+                "UINT",
+                0
+            ],
+            "left_id": [
+                "UINT",
+                0
+            ],
+            "right_id": [
+                "UINT",
+                0
+            ],
+            "forum_parents": [
+                "MTEXT",
+                ""
+            ],
+            "forum_name": [
+                "STEXT_UNI",
+                ""
+            ],
+            "forum_desc": [
+                "TEXT_UNI",
+                ""
+            ],
+            "forum_desc_bitfield": [
+                "VCHAR:255",
+                ""
+            ],
+            "forum_desc_options": [
+                "UINT:11",
+                7
+            ],
+            "forum_desc_uid": [
+                "VCHAR:8",
+                ""
+            ],
+            "forum_link": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "forum_password": [
+                "VCHAR:255",
+                ""
+            ],
+            "forum_style": [
+                "UINT",
+                0
+            ],
+            "forum_image": [
+                "VCHAR",
+                ""
+            ],
+            "forum_rules": [
+                "TEXT_UNI",
+                ""
+            ],
+            "forum_rules_link": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "forum_rules_bitfield": [
+                "VCHAR:255",
+                ""
+            ],
+            "forum_rules_options": [
+                "UINT:11",
+                7
+            ],
+            "forum_rules_uid": [
+                "VCHAR:8",
+                ""
+            ],
+            "forum_topics_per_page": [
+                "TINT:4",
+                0
+            ],
+            "forum_type": [
+                "TINT:4",
+                0
+            ],
+            "forum_status": [
+                "TINT:4",
+                0
+            ],
+            "forum_last_post_id": [
+                "ULINT",
+                0
+            ],
+            "forum_last_poster_id": [
+                "ULINT",
+                0
+            ],
+            "forum_last_post_subject": [
+                "STEXT_UNI",
+                ""
+            ],
+            "forum_last_post_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "forum_last_poster_name": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "forum_last_poster_colour": [
+                "VCHAR:6",
+                ""
+            ],
+            "forum_flags": [
+                "TINT:4",
+                32
+            ],
+            "display_on_index": [
+                "BOOL",
+                1
+            ],
+            "enable_indexing": [
+                "BOOL",
+                1
+            ],
+            "enable_icons": [
+                "BOOL",
+                1
+            ],
+            "enable_prune": [
+                "BOOL",
+                0
+            ],
+            "prune_next": [
+                "TIMESTAMP",
+                0
+            ],
+            "prune_days": [
+                "UINT",
+                0
+            ],
+            "prune_viewed": [
+                "UINT",
+                0
+            ],
+            "prune_freq": [
+                "UINT",
+                0
+            ],
+            "display_subforum_list": [
+                "BOOL",
+                1
+            ],
+            "forum_options": [
+                "UINT:20",
+                0
+            ],
+            "forum_posts_approved": [
+                "UINT",
+                0
+            ],
+            "forum_posts_unapproved": [
+                "UINT",
+                0
+            ],
+            "forum_posts_softdeleted": [
+                "UINT",
+                0
+            ],
+            "forum_topics_approved": [
+                "UINT",
+                0
+            ],
+            "forum_topics_unapproved": [
+                "UINT",
+                0
+            ],
+            "forum_topics_softdeleted": [
+                "UINT",
+                0
+            ],
+            "enable_shadow_prune": [
+                "BOOL",
+                0
+            ],
+            "prune_shadow_days": [
+                "UINT",
+                7
+            ],
+            "prune_shadow_freq": [
+                "UINT",
+                1
+            ],
+            "prune_shadow_next": [
+                "INT:11",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "forum_id",
+        "KEYS": {
+            "left_right_id": [
+                "INDEX",
+                [
+                    "left_id",
+                    "right_id"
+                ]
+            ],
+            "forum_lastpost_id": [
+                "INDEX",
+                "forum_last_post_id"
+            ]
+        }
+    },
+    "phpbb_forums_access": {
+        "COLUMNS": {
+            "forum_id": [
+                "UINT",
+                0
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "session_id": [
+                "CHAR:32",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": [
+            "forum_id",
+            "user_id",
+            "session_id"
+        ]
+    },
+    "phpbb_forums_track": {
+        "COLUMNS": {
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "forum_id": [
+                "UINT",
+                0
+            ],
+            "mark_time": [
+                "TIMESTAMP",
+                0
+            ]
+        },
+        "PRIMARY_KEY": [
+            "user_id",
+            "forum_id"
+        ]
+    },
+    "phpbb_forums_watch": {
+        "COLUMNS": {
+            "forum_id": [
+                "UINT",
+                0
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "notify_status": [
+                "BOOL",
+                0
+            ]
+        },
+        "KEYS": {
+            "forum_id": [
+                "INDEX",
+                "forum_id"
+            ],
+            "user_id": [
+                "INDEX",
+                "user_id"
+            ],
+            "notify_stat": [
+                "INDEX",
+                "notify_status"
+            ]
+        }
+    },
+    "phpbb_groups": {
+        "COLUMNS": {
+            "group_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "group_type": [
+                "TINT:4",
+                1
+            ],
+            "group_founder_manage": [
+                "BOOL",
+                0
+            ],
+            "group_skip_auth": [
+                "BOOL",
+                0
+            ],
+            "group_name": [
+                "VCHAR_CI",
+                ""
+            ],
+            "group_desc": [
+                "TEXT_UNI",
+                ""
+            ],
+            "group_desc_bitfield": [
+                "VCHAR:255",
+                ""
+            ],
+            "group_desc_options": [
+                "UINT:11",
+                7
+            ],
+            "group_desc_uid": [
+                "VCHAR:8",
+                ""
+            ],
+            "group_display": [
+                "BOOL",
+                0
+            ],
+            "group_avatar": [
+                "VCHAR",
+                ""
+            ],
+            "group_avatar_type": [
+                "VCHAR:255",
+                ""
+            ],
+            "group_avatar_width": [
+                "USINT",
+                0
+            ],
+            "group_avatar_height": [
+                "USINT",
+                0
+            ],
+            "group_rank": [
+                "UINT",
+                0
+            ],
+            "group_colour": [
+                "VCHAR:6",
+                ""
+            ],
+            "group_sig_chars": [
+                "UINT",
+                0
+            ],
+            "group_receive_pm": [
+                "BOOL",
+                0
+            ],
+            "group_message_limit": [
+                "UINT",
+                0
+            ],
+            "group_legend": [
+                "UINT",
+                0
+            ],
+            "group_max_recipients": [
+                "UINT",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "group_id",
+        "KEYS": {
+            "group_legend_name": [
+                "INDEX",
+                [
+                    "group_legend",
+                    "group_name"
+                ]
+            ]
+        }
+    },
+    "phpbb_icons": {
+        "COLUMNS": {
+            "icons_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "icons_url": [
+                "VCHAR",
+                ""
+            ],
+            "icons_width": [
+                "TINT:4",
+                0
+            ],
+            "icons_height": [
+                "TINT:4",
+                0
+            ],
+            "icons_alt": [
+                "VCHAR",
+                ""
+            ],
+            "icons_order": [
+                "UINT",
+                0
+            ],
+            "display_on_posting": [
+                "BOOL",
+                1
+            ]
+        },
+        "PRIMARY_KEY": "icons_id",
+        "KEYS": {
+            "display_on_posting": [
+                "INDEX",
+                "display_on_posting"
+            ]
+        }
+    },
+    "phpbb_lang": {
+        "COLUMNS": {
+            "lang_id": [
+                "TINT:4",
+                null,
+                "auto_increment"
+            ],
+            "lang_iso": [
+                "VCHAR:30",
+                ""
+            ],
+            "lang_dir": [
+                "VCHAR:30",
+                ""
+            ],
+            "lang_english_name": [
+                "VCHAR_UNI:100",
+                ""
+            ],
+            "lang_local_name": [
+                "VCHAR_UNI:255",
+                ""
+            ],
+            "lang_author": [
+                "VCHAR_UNI:255",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "lang_id",
+        "KEYS": {
+            "lang_iso": [
+                "INDEX",
+                "lang_iso"
+            ]
+        }
+    },
+    "phpbb_log": {
+        "COLUMNS": {
+            "log_id": [
+                "ULINT",
+                null,
+                "auto_increment"
+            ],
+            "log_type": [
+                "TINT:4",
+                0
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "forum_id": [
+                "UINT",
+                0
+            ],
+            "topic_id": [
+                "ULINT",
+                0
+            ],
+            "post_id": [
+                "ULINT",
+                0
+            ],
+            "reportee_id": [
+                "ULINT",
+                0
+            ],
+            "log_ip": [
+                "VCHAR:40",
+                ""
+            ],
+            "log_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "log_operation": [
+                "TEXT_UNI",
+                ""
+            ],
+            "log_data": [
+                "MTEXT_UNI",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "log_id",
+        "KEYS": {
+            "log_type": [
+                "INDEX",
+                "log_type"
+            ],
+            "forum_id": [
+                "INDEX",
+                "forum_id"
+            ],
+            "topic_id": [
+                "INDEX",
+                "topic_id"
+            ],
+            "reportee_id": [
+                "INDEX",
+                "reportee_id"
+            ],
+            "user_id": [
+                "INDEX",
+                "user_id"
+            ]
+        }
+    },
+    "phpbb_login_attempts": {
+        "COLUMNS": {
+            "attempt_ip": [
+                "VCHAR:40",
+                ""
+            ],
+            "attempt_browser": [
+                "VCHAR:150",
+                ""
+            ],
+            "attempt_forwarded_for": [
+                "VCHAR:255",
+                ""
+            ],
+            "attempt_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "username": [
+                "VCHAR_UNI:255",
+                0
+            ],
+            "username_clean": [
+                "VCHAR_CI",
+                0
+            ]
+        },
+        "KEYS": {
+            "att_ip": [
+                "INDEX",
+                [
+                    "attempt_ip",
+                    "attempt_time"
+                ]
+            ],
+            "att_for": [
+                "INDEX",
+                [
+                    "attempt_forwarded_for",
+                    "attempt_time"
+                ]
+            ],
+            "att_time": [
+                "INDEX",
+                [
+                    "attempt_time"
+                ]
+            ],
+            "user_id": [
+                "INDEX",
+                "user_id"
+            ]
+        }
+    },
+    "phpbb_migrations": {
+        "COLUMNS": {
+            "migration_name": [
+                "VCHAR",
+                ""
+            ],
+            "migration_depends_on": [
+                "TEXT",
+                ""
+            ],
+            "migration_schema_done": [
+                "BOOL",
+                0
+            ],
+            "migration_data_done": [
+                "BOOL",
+                0
+            ],
+            "migration_data_state": [
+                "TEXT",
+                ""
+            ],
+            "migration_start_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "migration_end_time": [
+                "TIMESTAMP",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "migration_name"
+    },
+    "phpbb_moderator_cache": {
+        "COLUMNS": {
+            "forum_id": [
+                "UINT",
+                0
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "username": [
+                "VCHAR_UNI:255",
+                ""
+            ],
+            "group_id": [
+                "UINT",
+                0
+            ],
+            "group_name": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "display_on_index": [
+                "BOOL",
+                1
+            ]
+        },
+        "KEYS": {
+            "disp_idx": [
+                "INDEX",
+                "display_on_index"
+            ],
+            "forum_id": [
+                "INDEX",
+                "forum_id"
+            ]
+        }
+    },
+    "phpbb_modules": {
+        "COLUMNS": {
+            "module_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "module_enabled": [
+                "BOOL",
+                1
+            ],
+            "module_display": [
+                "BOOL",
+                1
+            ],
+            "module_basename": [
+                "VCHAR",
+                ""
+            ],
+            "module_class": [
+                "VCHAR:10",
+                ""
+            ],
+            "parent_id": [
+                "UINT",
+                0
+            ],
+            "left_id": [
+                "UINT",
+                0
+            ],
+            "right_id": [
+                "UINT",
+                0
+            ],
+            "module_langname": [
+                "VCHAR",
+                ""
+            ],
+            "module_mode": [
+                "VCHAR",
+                ""
+            ],
+            "module_auth": [
+                "VCHAR",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "module_id",
+        "KEYS": {
+            "left_right_id": [
+                "INDEX",
+                [
+                    "left_id",
+                    "right_id"
+                ]
+            ],
+            "module_enabled": [
+                "INDEX",
+                "module_enabled"
+            ],
+            "class_left_id": [
+                "INDEX",
+                [
+                    "module_class",
+                    "left_id"
+                ]
+            ]
+        }
+    },
+    "phpbb_notification_types": {
+        "COLUMNS": {
+            "notification_type_id": [
+                "USINT",
+                null,
+                "auto_increment"
+            ],
+            "notification_type_name": [
+                "VCHAR:255",
+                ""
+            ],
+            "notification_type_enabled": [
+                "BOOL",
+                1
+            ]
+        },
+        "PRIMARY_KEY": [
+            "notification_type_id"
+        ],
+        "KEYS": {
+            "type": [
+                "UNIQUE",
+                [
+                    "notification_type_name"
+                ]
+            ]
+        }
+    },
+    "phpbb_notifications": {
+        "COLUMNS": {
+            "notification_id": [
+                "UINT:10",
+                null,
+                "auto_increment"
+            ],
+            "notification_type_id": [
+                "USINT",
+                0
+            ],
+            "item_id": [
+                "UINT",
+                0
+            ],
+            "item_parent_id": [
+                "UINT",
+                0
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "notification_read": [
+                "BOOL",
+                0
+            ],
+            "notification_time": [
+                "TIMESTAMP",
+                1
+            ],
+            "notification_data": [
+                "TEXT_UNI",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "notification_id",
+        "KEYS": {
+            "item_ident": [
+                "INDEX",
+                [
+                    "notification_type_id",
+                    "item_id"
+                ]
+            ],
+            "user": [
+                "INDEX",
+                [
+                    "user_id",
+                    "notification_read"
+                ]
+            ]
+        }
+    },
+    "phpbb_oauth_accounts": {
+        "COLUMNS": {
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "provider": [
+                "VCHAR",
+                ""
+            ],
+            "oauth_provider_id": [
+                "TEXT_UNI",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": [
+            "user_id",
+            "provider"
+        ]
+    },
+    "phpbb_oauth_states": {
+        "COLUMNS": {
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "session_id": [
+                "CHAR:32",
+                ""
+            ],
+            "provider": [
+                "VCHAR",
+                ""
+            ],
+            "oauth_state": [
+                "VCHAR",
+                ""
+            ]
+        },
+        "KEYS": {
+            "user_id": [
+                "INDEX",
+                "user_id"
+            ],
+            "provider": [
+                "INDEX",
+                "provider"
+            ]
+        }
+    },
+    "phpbb_oauth_tokens": {
+        "COLUMNS": {
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "session_id": [
+                "CHAR:32",
+                ""
+            ],
+            "provider": [
+                "VCHAR",
+                ""
+            ],
+            "oauth_token": [
+                "MTEXT",
+                ""
+            ]
+        },
+        "KEYS": {
+            "user_id": [
+                "INDEX",
+                "user_id"
+            ],
+            "provider": [
+                "INDEX",
+                "provider"
+            ]
+        }
+    },
+    "phpbb_poll_options": {
+        "COLUMNS": {
+            "poll_option_id": [
+                "TINT:4",
+                0
+            ],
+            "topic_id": [
+                "ULINT",
+                0
+            ],
+            "poll_option_text": [
+                "TEXT_UNI",
+                ""
+            ],
+            "poll_option_total": [
+                "UINT",
+                0
+            ]
+        },
+        "KEYS": {
+            "poll_opt_id": [
+                "INDEX",
+                "poll_option_id"
+            ],
+            "topic_id": [
+                "INDEX",
+                "topic_id"
+            ]
+        }
+    },
+    "phpbb_poll_votes": {
+        "COLUMNS": {
+            "topic_id": [
+                "ULINT",
+                0
+            ],
+            "poll_option_id": [
+                "TINT:4",
+                0
+            ],
+            "vote_user_id": [
+                "ULINT",
+                0
+            ],
+            "vote_user_ip": [
+                "VCHAR:40",
+                ""
+            ]
+        },
+        "KEYS": {
+            "topic_id": [
+                "INDEX",
+                "topic_id"
+            ],
+            "vote_user_id": [
+                "INDEX",
+                "vote_user_id"
+            ],
+            "vote_user_ip": [
+                "INDEX",
+                "vote_user_ip"
+            ]
+        }
+    },
+    "phpbb_posts": {
+        "COLUMNS": {
+            "post_id": [
+                "ULINT",
+                null,
+                "auto_increment"
+            ],
+            "topic_id": [
+                "ULINT",
+                0
+            ],
+            "forum_id": [
+                "UINT",
+                0
+            ],
+            "poster_id": [
+                "ULINT",
+                0
+            ],
+            "icon_id": [
+                "UINT",
+                0
+            ],
+            "poster_ip": [
+                "VCHAR:40",
+                ""
+            ],
+            "post_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "post_reported": [
+                "BOOL",
+                0
+            ],
+            "enable_bbcode": [
+                "BOOL",
+                1
+            ],
+            "enable_smilies": [
+                "BOOL",
+                1
+            ],
+            "enable_magic_url": [
+                "BOOL",
+                1
+            ],
+            "enable_sig": [
+                "BOOL",
+                1
+            ],
+            "post_username": [
+                "VCHAR_UNI:255",
+                ""
+            ],
+            "post_subject": [
+                "STEXT_UNI",
+                "",
+                "true_sort"
+            ],
+            "post_text": [
+                "MTEXT_UNI",
+                ""
+            ],
+            "post_checksum": [
+                "VCHAR:32",
+                ""
+            ],
+            "post_attachment": [
+                "BOOL",
+                0
+            ],
+            "bbcode_bitfield": [
+                "VCHAR:255",
+                ""
+            ],
+            "bbcode_uid": [
+                "VCHAR:8",
+                ""
+            ],
+            "post_postcount": [
+                "BOOL",
+                1
+            ],
+            "post_edit_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "post_edit_reason": [
+                "STEXT_UNI",
+                ""
+            ],
+            "post_edit_user": [
+                "ULINT",
+                0
+            ],
+            "post_edit_count": [
+                "USINT",
+                0
+            ],
+            "post_edit_locked": [
+                "BOOL",
+                0
+            ],
+            "post_visibility": [
+                "TINT:3",
+                0
+            ],
+            "post_delete_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "post_delete_reason": [
+                "STEXT_UNI",
+                ""
+            ],
+            "post_delete_user": [
+                "ULINT",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "post_id",
+        "KEYS": {
+            "forum_id": [
+                "INDEX",
+                "forum_id"
+            ],
+            "topic_id": [
+                "INDEX",
+                "topic_id"
+            ],
+            "poster_ip": [
+                "INDEX",
+                "poster_ip"
+            ],
+            "poster_id": [
+                "INDEX",
+                "poster_id"
+            ],
+            "tid_post_time": [
+                "INDEX",
+                [
+                    "topic_id",
+                    "post_time"
+                ]
+            ],
+            "post_username": [
+                "INDEX",
+                [
+                    "post_username:255"
+                ]
+            ],
+            "post_visibility": [
+                "INDEX",
+                [
+                    "post_visibility"
+                ]
+            ]
+        }
+    },
+    "phpbb_privmsgs": {
+        "COLUMNS": {
+            "msg_id": [
+                "ULINT",
+                null,
+                "auto_increment"
+            ],
+            "root_level": [
+                "UINT",
+                0
+            ],
+            "author_id": [
+                "ULINT",
+                0
+            ],
+            "icon_id": [
+                "UINT",
+                0
+            ],
+            "author_ip": [
+                "VCHAR:40",
+                ""
+            ],
+            "message_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "enable_bbcode": [
+                "BOOL",
+                1
+            ],
+            "enable_smilies": [
+                "BOOL",
+                1
+            ],
+            "enable_magic_url": [
+                "BOOL",
+                1
+            ],
+            "enable_sig": [
+                "BOOL",
+                1
+            ],
+            "message_subject": [
+                "STEXT_UNI",
+                ""
+            ],
+            "message_text": [
+                "MTEXT_UNI",
+                ""
+            ],
+            "message_edit_reason": [
+                "STEXT_UNI",
+                ""
+            ],
+            "message_edit_user": [
+                "ULINT",
+                0
+            ],
+            "message_attachment": [
+                "BOOL",
+                0
+            ],
+            "bbcode_bitfield": [
+                "VCHAR:255",
+                ""
+            ],
+            "bbcode_uid": [
+                "VCHAR:8",
+                ""
+            ],
+            "message_edit_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "message_edit_count": [
+                "USINT",
+                0
+            ],
+            "to_address": [
+                "TEXT_UNI",
+                ""
+            ],
+            "bcc_address": [
+                "TEXT_UNI",
+                ""
+            ],
+            "message_reported": [
+                "BOOL",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "msg_id",
+        "KEYS": {
+            "author_ip": [
+                "INDEX",
+                "author_ip"
+            ],
+            "message_time": [
+                "INDEX",
+                "message_time"
+            ],
+            "author_id": [
+                "INDEX",
+                "author_id"
+            ],
+            "root_level": [
+                "INDEX",
+                "root_level"
+            ]
+        }
+    },
+    "phpbb_privmsgs_folder": {
+        "COLUMNS": {
+            "folder_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "folder_name": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "pm_count": [
+                "UINT",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "folder_id",
+        "KEYS": {
+            "user_id": [
+                "INDEX",
+                "user_id"
+            ]
+        }
+    },
+    "phpbb_privmsgs_rules": {
+        "COLUMNS": {
+            "rule_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "rule_check": [
+                "UINT",
+                0
+            ],
+            "rule_connection": [
+                "UINT",
+                0
+            ],
+            "rule_string": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "rule_user_id": [
+                "ULINT",
+                0
+            ],
+            "rule_group_id": [
+                "UINT",
+                0
+            ],
+            "rule_action": [
+                "UINT",
+                0
+            ],
+            "rule_folder_id": [
+                "INT:11",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "rule_id",
+        "KEYS": {
+            "user_id": [
+                "INDEX",
+                "user_id"
+            ]
+        }
+    },
+    "phpbb_privmsgs_to": {
+        "COLUMNS": {
+            "msg_id": [
+                "ULINT",
+                0
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "author_id": [
+                "ULINT",
+                0
+            ],
+            "pm_deleted": [
+                "BOOL",
+                0
+            ],
+            "pm_new": [
+                "BOOL",
+                1
+            ],
+            "pm_unread": [
+                "BOOL",
+                1
+            ],
+            "pm_replied": [
+                "BOOL",
+                0
+            ],
+            "pm_marked": [
+                "BOOL",
+                0
+            ],
+            "pm_forwarded": [
+                "BOOL",
+                0
+            ],
+            "folder_id": [
+                "INT:11",
+                0
+            ]
+        },
+        "KEYS": {
+            "msg_id": [
+                "INDEX",
+                "msg_id"
+            ],
+            "author_id": [
+                "INDEX",
+                "author_id"
+            ],
+            "usr_flder_id": [
+                "INDEX",
+                [
+                    "user_id",
+                    "folder_id"
+                ]
+            ]
+        }
+    },
+    "phpbb_profile_fields": {
+        "COLUMNS": {
+            "field_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "field_name": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "field_type": [
+                "VCHAR:100",
+                ""
+            ],
+            "field_ident": [
+                "VCHAR:20",
+                ""
+            ],
+            "field_length": [
+                "VCHAR:20",
+                ""
+            ],
+            "field_minlen": [
+                "VCHAR",
+                ""
+            ],
+            "field_maxlen": [
+                "VCHAR",
+                ""
+            ],
+            "field_novalue": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "field_default_value": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "field_validation": [
+                "VCHAR_UNI:64",
+                ""
+            ],
+            "field_required": [
+                "BOOL",
+                0
+            ],
+            "field_show_on_reg": [
+                "BOOL",
+                0
+            ],
+            "field_hide": [
+                "BOOL",
+                0
+            ],
+            "field_no_view": [
+                "BOOL",
+                0
+            ],
+            "field_active": [
+                "BOOL",
+                0
+            ],
+            "field_order": [
+                "UINT",
+                0
+            ],
+            "field_show_profile": [
+                "BOOL",
+                0
+            ],
+            "field_show_on_vt": [
+                "BOOL",
+                0
+            ],
+            "field_show_novalue": [
+                "BOOL",
+                0
+            ],
+            "field_show_on_pm": [
+                "BOOL",
+                0
+            ],
+            "field_show_on_ml": [
+                "BOOL",
+                0
+            ],
+            "field_is_contact": [
+                "BOOL",
+                0
+            ],
+            "field_contact_desc": [
+                "VCHAR",
+                ""
+            ],
+            "field_contact_url": [
+                "VCHAR",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "field_id",
+        "KEYS": {
+            "fld_type": [
+                "INDEX",
+                "field_type"
+            ],
+            "fld_ordr": [
+                "INDEX",
+                "field_order"
+            ]
+        }
+    },
+    "phpbb_profile_fields_data": {
+        "COLUMNS": {
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "pf_phpbb_interests": [
+                "MTEXT",
+                ""
+            ],
+            "pf_phpbb_occupation": [
+                "MTEXT",
+                ""
+            ],
+            "pf_phpbb_icq": [
+                "VCHAR",
+                ""
+            ],
+            "pf_phpbb_twitter": [
+                "VCHAR",
+                ""
+            ],
+            "pf_phpbb_facebook": [
+                "VCHAR",
+                ""
+            ],
+            "pf_phpbb_skype": [
+                "VCHAR",
+                ""
+            ],
+            "pf_phpbb_youtube": [
+                "VCHAR",
+                ""
+            ],
+            "pf_phpbb_location": [
+                "VCHAR",
+                ""
+            ],
+            "pf_phpbb_googleplus": [
+                "VCHAR",
+                ""
+            ],
+            "pf_phpbb_website": [
+                "VCHAR",
+                ""
+            ],
+            "pf_phpbb_yahoo": [
+                "VCHAR",
+                ""
+            ],
+            "pf_phpbb_aol": [
+                "VCHAR",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "user_id"
+    },
+    "phpbb_profile_fields_lang": {
+        "COLUMNS": {
+            "field_id": [
+                "UINT",
+                0
+            ],
+            "lang_id": [
+                "UINT",
+                0
+            ],
+            "option_id": [
+                "UINT",
+                0
+            ],
+            "field_type": [
+                "VCHAR:100",
+                ""
+            ],
+            "lang_value": [
+                "VCHAR_UNI",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": [
+            "field_id",
+            "lang_id",
+            "option_id"
+        ]
+    },
+    "phpbb_profile_lang": {
+        "COLUMNS": {
+            "field_id": [
+                "UINT",
+                0
+            ],
+            "lang_id": [
+                "UINT",
+                0
+            ],
+            "lang_name": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "lang_explain": [
+                "TEXT_UNI",
+                ""
+            ],
+            "lang_default_value": [
+                "VCHAR_UNI",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": [
+            "field_id",
+            "lang_id"
+        ]
+    },
+    "phpbb_ranks": {
+        "COLUMNS": {
+            "rank_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "rank_title": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "rank_min": [
+                "UINT",
+                0
+            ],
+            "rank_special": [
+                "BOOL",
+                0
+            ],
+            "rank_image": [
+                "VCHAR",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "rank_id"
+    },
+    "phpbb_reports": {
+        "COLUMNS": {
+            "report_id": [
+                "ULINT",
+                0
+            ],
+            "reason_id": [
+                "USINT",
+                0
+            ],
+            "post_id": [
+                "ULINT",
+                0
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "user_notify": [
+                "BOOL",
+                0
+            ],
+            "report_closed": [
+                "BOOL",
+                0
+            ],
+            "report_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "report_text": [
+                "MTEXT_UNI",
+                ""
+            ],
+            "pm_id": [
+                "ULINT",
+                0
+            ],
+            "reported_post_enable_bbcode": [
+                "BOOL",
+                1
+            ],
+            "reported_post_enable_smilies": [
+                "BOOL",
+                1
+            ],
+            "reported_post_enable_magic_url": [
+                "BOOL",
+                1
+            ],
+            "reported_post_text": [
+                "MTEXT_UNI",
+                ""
+            ],
+            "reported_post_uid": [
+                "VCHAR:8",
+                ""
+            ],
+            "reported_post_bitfield": [
+                "VCHAR:255",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "report_id",
+        "KEYS": {
+            "post_id": [
+                "INDEX",
+                [
+                    "post_id"
+                ]
+            ],
+            "pm_id": [
+                "INDEX",
+                [
+                    "pm_id"
+                ]
+            ]
+        }
+    },
+    "phpbb_reports_reasons": {
+        "COLUMNS": {
+            "reason_id": [
+                "USINT",
+                null,
+                "auto_increment"
+            ],
+            "reason_title": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "reason_description": [
+                "MTEXT_UNI",
+                ""
+            ],
+            "reason_order": [
+                "USINT",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "reason_id"
+    },
+    "phpbb_search_results": {
+        "COLUMNS": {
+            "search_key": [
+                "VCHAR:32",
+                ""
+            ],
+            "search_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "search_keywords": [
+                "MTEXT_UNI",
+                ""
+            ],
+            "search_authors": [
+                "MTEXT",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "search_key"
+    },
+    "phpbb_search_wordlist": {
+        "COLUMNS": {
+            "word_id": [
+                "ULINT",
+                null,
+                "auto_increment"
+            ],
+            "word_text": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "word_common": [
+                "BOOL",
+                0
+            ],
+            "word_count": [
+                "UINT",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "word_id",
+        "KEYS": {
+            "wrd_txt": [
+                "UNIQUE",
+                "word_text"
+            ],
+            "wrd_cnt": [
+                "INDEX",
+                "word_count"
+            ]
+        }
+    },
+    "phpbb_search_wordmatch": {
+        "COLUMNS": {
+            "post_id": [
+                "ULINT",
+                0
+            ],
+            "word_id": [
+                "ULINT",
+                0
+            ],
+            "title_match": [
+                "BOOL",
+                0
+            ]
+        },
+        "KEYS": {
+            "word_id": [
+                "INDEX",
+                "word_id"
+            ],
+            "post_id": [
+                "INDEX",
+                "post_id"
+            ],
+            "un_mtch": [
+                "UNIQUE",
+                [
+                    "word_id",
+                    "post_id",
+                    "title_match"
+                ]
+            ]
+        }
+    },
+    "phpbb_sessions": {
+        "COLUMNS": {
+            "session_id": [
+                "CHAR:32",
+                ""
+            ],
+            "session_user_id": [
+                "ULINT",
+                0
+            ],
+            "session_last_visit": [
+                "TIMESTAMP",
+                0
+            ],
+            "session_start": [
+                "TIMESTAMP",
+                0
+            ],
+            "session_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "session_ip": [
+                "VCHAR:40",
+                ""
+            ],
+            "session_browser": [
+                "VCHAR:150",
+                ""
+            ],
+            "session_forwarded_for": [
+                "VCHAR:255",
+                ""
+            ],
+            "session_page": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "session_viewonline": [
+                "BOOL",
+                1
+            ],
+            "session_autologin": [
+                "BOOL",
+                0
+            ],
+            "session_admin": [
+                "BOOL",
+                0
+            ],
+            "session_forum_id": [
+                "UINT",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "session_id",
+        "KEYS": {
+            "session_time": [
+                "INDEX",
+                "session_time"
+            ],
+            "session_user_id": [
+                "INDEX",
+                "session_user_id"
+            ],
+            "session_fid": [
+                "INDEX",
+                [
+                    "session_forum_id"
+                ]
+            ]
+        }
+    },
+    "phpbb_sessions_keys": {
+        "COLUMNS": {
+            "key_id": [
+                "CHAR:32",
+                ""
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "last_ip": [
+                "VCHAR:40",
+                ""
+            ],
+            "last_login": [
+                "TIMESTAMP",
+                0
+            ]
+        },
+        "PRIMARY_KEY": [
+            "key_id",
+            "user_id"
+        ],
+        "KEYS": {
+            "last_login": [
+                "INDEX",
+                "last_login"
+            ]
+        }
+    },
+    "phpbb_sitelist": {
+        "COLUMNS": {
+            "site_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "site_ip": [
+                "VCHAR:40",
+                ""
+            ],
+            "site_hostname": [
+                "VCHAR",
+                ""
+            ],
+            "ip_exclude": [
+                "BOOL",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "site_id"
+    },
+    "phpbb_smilies": {
+        "COLUMNS": {
+            "smiley_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "code": [
+                "VCHAR_UNI:50",
+                ""
+            ],
+            "emotion": [
+                "VCHAR_UNI:50",
+                ""
+            ],
+            "smiley_url": [
+                "VCHAR:50",
+                ""
+            ],
+            "smiley_width": [
+                "USINT",
+                0
+            ],
+            "smiley_height": [
+                "USINT",
+                0
+            ],
+            "smiley_order": [
+                "UINT",
+                0
+            ],
+            "display_on_posting": [
+                "BOOL",
+                1
+            ]
+        },
+        "PRIMARY_KEY": "smiley_id",
+        "KEYS": {
+            "display_on_post": [
+                "INDEX",
+                "display_on_posting"
+            ]
+        }
+    },
+    "phpbb_styles": {
+        "COLUMNS": {
+            "style_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "style_name": [
+                "VCHAR_UNI:255",
+                ""
+            ],
+            "style_copyright": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "style_active": [
+                "BOOL",
+                1
+            ],
+            "style_path": [
+                "VCHAR:100",
+                ""
+            ],
+            "bbcode_bitfield": [
+                "VCHAR:255",
+                "kNg="
+            ],
+            "style_parent_id": [
+                "UINT:4",
+                0
+            ],
+            "style_parent_tree": [
+                "TEXT",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "style_id",
+        "KEYS": {
+            "style_name": [
+                "UNIQUE",
+                "style_name"
+            ]
+        }
+    },
+    "phpbb_teampage": {
+        "COLUMNS": {
+            "teampage_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "group_id": [
+                "UINT",
+                0
+            ],
+            "teampage_name": [
+                "VCHAR_UNI:255",
+                ""
+            ],
+            "teampage_position": [
+                "UINT",
+                0
+            ],
+            "teampage_parent": [
+                "UINT",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "teampage_id"
+    },
+    "phpbb_topics": {
+        "COLUMNS": {
+            "topic_id": [
+                "ULINT",
+                null,
+                "auto_increment"
+            ],
+            "forum_id": [
+                "UINT",
+                0
+            ],
+            "icon_id": [
+                "UINT",
+                0
+            ],
+            "topic_attachment": [
+                "BOOL",
+                0
+            ],
+            "topic_reported": [
+                "BOOL",
+                0
+            ],
+            "topic_title": [
+                "STEXT_UNI",
+                "",
+                "true_sort"
+            ],
+            "topic_poster": [
+                "ULINT",
+                0
+            ],
+            "topic_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "topic_time_limit": [
+                "TIMESTAMP",
+                0
+            ],
+            "topic_views": [
+                "UINT",
+                0
+            ],
+            "topic_status": [
+                "TINT:3",
+                0
+            ],
+            "topic_type": [
+                "TINT:3",
+                0
+            ],
+            "topic_first_post_id": [
+                "ULINT",
+                0
+            ],
+            "topic_first_poster_name": [
+                "VCHAR_UNI:255",
+                "",
+                "true_sort"
+            ],
+            "topic_first_poster_colour": [
+                "VCHAR:6",
+                ""
+            ],
+            "topic_last_post_id": [
+                "ULINT",
+                0
+            ],
+            "topic_last_poster_id": [
+                "ULINT",
+                0
+            ],
+            "topic_last_poster_name": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "topic_last_poster_colour": [
+                "VCHAR:6",
+                ""
+            ],
+            "topic_last_post_subject": [
+                "STEXT_UNI",
+                ""
+            ],
+            "topic_last_post_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "topic_last_view_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "topic_moved_id": [
+                "ULINT",
+                0
+            ],
+            "topic_bumped": [
+                "BOOL",
+                0
+            ],
+            "topic_bumper": [
+                "UINT",
+                0
+            ],
+            "poll_title": [
+                "STEXT_UNI",
+                ""
+            ],
+            "poll_start": [
+                "TIMESTAMP",
+                0
+            ],
+            "poll_length": [
+                "TIMESTAMP",
+                0
+            ],
+            "poll_max_options": [
+                "TINT:4",
+                1
+            ],
+            "poll_last_vote": [
+                "TIMESTAMP",
+                0
+            ],
+            "poll_vote_change": [
+                "BOOL",
+                0
+            ],
+            "topic_visibility": [
+                "TINT:3",
+                0
+            ],
+            "topic_delete_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "topic_delete_reason": [
+                "STEXT_UNI",
+                ""
+            ],
+            "topic_delete_user": [
+                "ULINT",
+                0
+            ],
+            "topic_posts_approved": [
+                "UINT",
+                0
+            ],
+            "topic_posts_unapproved": [
+                "UINT",
+                0
+            ],
+            "topic_posts_softdeleted": [
+                "UINT",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "topic_id",
+        "KEYS": {
+            "forum_id": [
+                "INDEX",
+                "forum_id"
+            ],
+            "forum_id_type": [
+                "INDEX",
+                [
+                    "forum_id",
+                    "topic_type"
+                ]
+            ],
+            "last_post_time": [
+                "INDEX",
+                "topic_last_post_time"
+            ],
+            "fid_time_moved": [
+                "INDEX",
+                [
+                    "forum_id",
+                    "topic_last_post_time",
+                    "topic_moved_id"
+                ]
+            ],
+            "topic_visibility": [
+                "INDEX",
+                [
+                    "topic_visibility"
+                ]
+            ],
+            "forum_vis_last": [
+                "INDEX",
+                [
+                    "forum_id",
+                    "topic_visibility",
+                    "topic_last_post_id"
+                ]
+            ]
+        }
+    },
+    "phpbb_topics_posted": {
+        "COLUMNS": {
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "topic_id": [
+                "ULINT",
+                0
+            ],
+            "topic_posted": [
+                "BOOL",
+                0
+            ]
+        },
+        "PRIMARY_KEY": [
+            "user_id",
+            "topic_id"
+        ]
+    },
+    "phpbb_topics_track": {
+        "COLUMNS": {
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "topic_id": [
+                "ULINT",
+                0
+            ],
+            "forum_id": [
+                "UINT",
+                0
+            ],
+            "mark_time": [
+                "TIMESTAMP",
+                0
+            ]
+        },
+        "PRIMARY_KEY": [
+            "user_id",
+            "topic_id"
+        ],
+        "KEYS": {
+            "forum_id": [
+                "INDEX",
+                "forum_id"
+            ],
+            "topic_id": [
+                "INDEX",
+                [
+                    "topic_id"
+                ]
+            ]
+        }
+    },
+    "phpbb_topics_watch": {
+        "COLUMNS": {
+            "topic_id": [
+                "ULINT",
+                0
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "notify_status": [
+                "BOOL",
+                0
+            ]
+        },
+        "KEYS": {
+            "topic_id": [
+                "INDEX",
+                "topic_id"
+            ],
+            "user_id": [
+                "INDEX",
+                "user_id"
+            ],
+            "notify_stat": [
+                "INDEX",
+                "notify_status"
+            ]
+        }
+    },
+    "phpbb_user_group": {
+        "COLUMNS": {
+            "group_id": [
+                "UINT",
+                0
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "group_leader": [
+                "BOOL",
+                0
+            ],
+            "user_pending": [
+                "BOOL",
+                1
+            ]
+        },
+        "KEYS": {
+            "group_id": [
+                "INDEX",
+                "group_id"
+            ],
+            "user_id": [
+                "INDEX",
+                "user_id"
+            ],
+            "group_leader": [
+                "INDEX",
+                "group_leader"
+            ]
+        }
+    },
+    "phpbb_user_notifications": {
+        "COLUMNS": {
+            "item_type": [
+                "VCHAR:255",
+                ""
+            ],
+            "item_id": [
+                "ULINT",
+                0
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "method": [
+                "VCHAR:255",
+                ""
+            ],
+            "notify": [
+                "BOOL",
+                1
+            ]
+        }
+    },
+    "phpbb_users": {
+        "COLUMNS": {
+            "user_id": [
+                "ULINT",
+                null,
+                "auto_increment"
+            ],
+            "user_type": [
+                "TINT:2",
+                0
+            ],
+            "group_id": [
+                "UINT",
+                3
+            ],
+            "user_permissions": [
+                "MTEXT",
+                ""
+            ],
+            "user_perm_from": [
+                "UINT",
+                0
+            ],
+            "user_ip": [
+                "VCHAR:40",
+                ""
+            ],
+            "user_regdate": [
+                "TIMESTAMP",
+                0
+            ],
+            "username": [
+                "VCHAR_CI",
+                ""
+            ],
+            "username_clean": [
+                "VCHAR_CI",
+                ""
+            ],
+            "user_password": [
+                "VCHAR:255",
+                ""
+            ],
+            "user_passchg": [
+                "TIMESTAMP",
+                0
+            ],
+            "user_email": [
+                "VCHAR_UNI:100",
+                ""
+            ],
+            "user_email_hash": [
+                "BINT",
+                0
+            ],
+            "user_birthday": [
+                "VCHAR:10",
+                ""
+            ],
+            "user_lastvisit": [
+                "TIMESTAMP",
+                0
+            ],
+            "user_lastmark": [
+                "TIMESTAMP",
+                0
+            ],
+            "user_lastpost_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "user_lastpage": [
+                "VCHAR_UNI:200",
+                ""
+            ],
+            "user_last_confirm_key": [
+                "VCHAR:10",
+                ""
+            ],
+            "user_last_search": [
+                "TIMESTAMP",
+                0
+            ],
+            "user_warnings": [
+                "TINT:4",
+                0
+            ],
+            "user_last_warning": [
+                "TIMESTAMP",
+                0
+            ],
+            "user_login_attempts": [
+                "TINT:4",
+                0
+            ],
+            "user_inactive_reason": [
+                "TINT:2",
+                0
+            ],
+            "user_inactive_time": [
+                "TIMESTAMP",
+                0
+            ],
+            "user_posts": [
+                "UINT",
+                0
+            ],
+            "user_lang": [
+                "VCHAR:30",
+                ""
+            ],
+            "user_timezone": [
+                "VCHAR:100",
+                ""
+            ],
+            "user_dateformat": [
+                "VCHAR_UNI:64",
+                "d M Y H:i"
+            ],
+            "user_style": [
+                "UINT",
+                0
+            ],
+            "user_rank": [
+                "UINT",
+                0
+            ],
+            "user_colour": [
+                "VCHAR:6",
+                ""
+            ],
+            "user_new_privmsg": [
+                "INT:4",
+                0
+            ],
+            "user_unread_privmsg": [
+                "INT:4",
+                0
+            ],
+            "user_last_privmsg": [
+                "TIMESTAMP",
+                0
+            ],
+            "user_message_rules": [
+                "BOOL",
+                0
+            ],
+            "user_full_folder": [
+                "INT:11",
+                -3
+            ],
+            "user_emailtime": [
+                "TIMESTAMP",
+                0
+            ],
+            "user_topic_show_days": [
+                "USINT",
+                0
+            ],
+            "user_topic_sortby_type": [
+                "VCHAR:1",
+                "t"
+            ],
+            "user_topic_sortby_dir": [
+                "VCHAR:1",
+                "d"
+            ],
+            "user_post_show_days": [
+                "USINT",
+                0
+            ],
+            "user_post_sortby_type": [
+                "VCHAR:1",
+                "t"
+            ],
+            "user_post_sortby_dir": [
+                "VCHAR:1",
+                "a"
+            ],
+            "user_notify": [
+                "BOOL",
+                0
+            ],
+            "user_notify_pm": [
+                "BOOL",
+                1
+            ],
+            "user_notify_type": [
+                "TINT:4",
+                0
+            ],
+            "user_allow_pm": [
+                "BOOL",
+                1
+            ],
+            "user_allow_viewonline": [
+                "BOOL",
+                1
+            ],
+            "user_allow_viewemail": [
+                "BOOL",
+                1
+            ],
+            "user_allow_massemail": [
+                "BOOL",
+                1
+            ],
+            "user_options": [
+                "UINT:11",
+                230271
+            ],
+            "user_avatar": [
+                "VCHAR",
+                ""
+            ],
+            "user_avatar_type": [
+                "VCHAR:255",
+                ""
+            ],
+            "user_avatar_width": [
+                "USINT",
+                0
+            ],
+            "user_avatar_height": [
+                "USINT",
+                0
+            ],
+            "user_sig": [
+                "MTEXT_UNI",
+                ""
+            ],
+            "user_sig_bbcode_uid": [
+                "VCHAR:8",
+                ""
+            ],
+            "user_sig_bbcode_bitfield": [
+                "VCHAR:255",
+                ""
+            ],
+            "user_jabber": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "user_actkey": [
+                "VCHAR:32",
+                ""
+            ],
+            "user_newpasswd": [
+                "VCHAR:255",
+                ""
+            ],
+            "user_form_salt": [
+                "VCHAR_UNI:32",
+                ""
+            ],
+            "user_new": [
+                "BOOL",
+                1
+            ],
+            "user_reminded": [
+                "TINT:4",
+                0
+            ],
+            "user_reminded_time": [
+                "TIMESTAMP",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "user_id",
+        "KEYS": {
+            "user_birthday": [
+                "INDEX",
+                "user_birthday"
+            ],
+            "user_email_hash": [
+                "INDEX",
+                "user_email_hash"
+            ],
+            "user_type": [
+                "INDEX",
+                "user_type"
+            ],
+            "username_clean": [
+                "UNIQUE",
+                "username_clean"
+            ]
+        }
+    },
+    "phpbb_warnings": {
+        "COLUMNS": {
+            "warning_id": [
+                "UINT",
+                null,
+                "auto_increment"
+            ],
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "post_id": [
+                "ULINT",
+                0
+            ],
+            "log_id": [
+                "ULINT",
+                0
+            ],
+            "warning_time": [
+                "TIMESTAMP",
+                0
+            ]
+        },
+        "PRIMARY_KEY": "warning_id"
+    },
+    "phpbb_words": {
+        "COLUMNS": {
+            "word_id": [
+                "ULINT",
+                null,
+                "auto_increment"
+            ],
+            "word": [
+                "VCHAR_UNI",
+                ""
+            ],
+            "replacement": [
+                "VCHAR_UNI",
+                ""
+            ]
+        },
+        "PRIMARY_KEY": "word_id"
+    },
+    "phpbb_zebra": {
+        "COLUMNS": {
+            "user_id": [
+                "ULINT",
+                0
+            ],
+            "zebra_id": [
+                "ULINT",
+                0
+            ],
+            "friend": [
+                "BOOL",
+                0
+            ],
+            "foe": [
+                "BOOL",
+                0
+            ]
+        },
+        "PRIMARY_KEY": [
+            "user_id",
+            "zebra_id"
+        ]
+    }
+}
+\ No newline at end of file
diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql
index 6e5cefc624..ede31e53e6 100644
--- a/phpBB/install/schemas/schema_data.sql
+++ b/phpBB/install/schemas/schema_data.sql
@@ -239,6 +239,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('queue_interval', '
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('ranks_path', 'images/ranks');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('read_notification_expire_days', '30');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('read_notification_gc', '86400');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('remote_upload_verify', '0');
 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', '');
@@ -275,7 +276,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('tpl_allow_php', '0
 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 ('version', '3.2.0-a3-dev');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '3.2.0-b2-dev');
 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');
 
diff --git a/phpBB/install/startup.php b/phpBB/install/startup.php
index 927f529b73..711768f9ac 100644
--- a/phpBB/install/startup.php
+++ b/phpBB/install/startup.php
@@ -101,6 +101,8 @@ $phpbb_class_loader_new = new \phpbb\class_loader('phpbb\\', "{$phpbb_root_path}
 $phpbb_class_loader_new->register();
 $phpbb_class_loader = new \phpbb\class_loader('phpbb\\', "{$phpbb_root_path}phpbb/", $phpEx);
 $phpbb_class_loader->register();
+$phpbb_class_loader = new \phpbb\class_loader('phpbb\\convert\\', "{$phpbb_root_path}install/convert/", $phpEx);
+$phpbb_class_loader->register();
 $phpbb_class_loader_ext = new \phpbb\class_loader('\\', "{$phpbb_root_path}ext/", $phpEx);
 $phpbb_class_loader_ext->register();