+<script type="text/javascript">

+<!--

+installLang = {

+ title: '{LA_TIMEOUT_DETECTED_TITLE}',

+ msg: '{LA_TIMEOUT_DETECTED_MESSAGE}'

+};

+//-->

+</script>

+

+ var transmissionOver = false;

+

+ if (responseObject.hasOwnProperty('over')) {

+ if (responseObject.over) {

+ transmissionOver = true;

+ }

+ }

+ var timeoutDetected = !transmissionOver;

+

+

+ if (timeoutDetected) {

+ addMessage('error',

+ [{

+ title: installLang.title,

+ description: installLang.msg

+ }]

+ );

+ }

+ transmissionOver = false;

+ - '@cache.driver'

+ - '@installer.helper.config'

+ installer.install_database.create_schema_file:

+ class: phpbb\install\module\install_database\task\create_schema_file

+ installer.install_database.set_up_database:

+ class: phpbb\install\module\install_database\task\set_up_database

+ arguments:

+ - '@installer.helper.config'

+ - '@installer.helper.database'

+ - '@filesystem'

+ - '@installer.helper.iohandler'

+ - '%core.root_path%'

+ tags:

+ - { name: install_database_install, order: 20 }

+

+ installer.install_database.add_tables:

+ class: phpbb\install\module\install_database\task\add_tables

+ arguments:

+ - '@installer.helper.config'

+ - '@installer.helper.database'

+ - '@filesystem'

+ - '%core.root_path%'

+ tags:

+ - { name: install_database_install, order: 30 }

+

+ - { name: install_database_install, order: 40 }

+ - { name: install_database_install, order: 50 }

+ - '@installer.helper.config'

+ - '@installer.helper.container_factory'

+ - [set_purge_cache_before, [false]]

+ - [set_purge_cache_before, [true]]

+use phpbb\cache\driver\driver_interface;

+ * @var driver_interface

+ * @var driver_interface

+ */

+ protected $installer_cache;

+

+ /**

+ * @param driver_interface $cache

+ 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->installer_cache->purge();

+ $this->iohandler->send_response(true);

+ $this->iohandler->send_response(true);

+ $this->iohandler->send_response(true);

+ $this->iohandler->send_response(true);

+

+ 'PHPBB_ALREADY_INSTALLED' => 'phpBB is already installed.',

+

+ 'TIMEOUT_DETECTED_TITLE' => 'The installer detected a timeout',

+ 'TIMEOUT_DETECTED_MESSAGE' => 'The installer has detected a timeout, you may try to refresh the page, which may lead to data corruption. We suggest that you either increase your timeout settings or try to use the CLI.',

+ 'INST_SCHEMA_FILE_NOT_WRITABLE' => 'The schema file is not writable',

+ 'TASK_ADD_CONFIG_SETTINGS' => 'Adding configuration settings',

+ 'TASK_ADD_DEFAULT_DATA' => 'Adding default settings to the database',

+ 'TASK_CREATE_DATABASE_SCHEMA_FILE' => 'Creating database schema file',

+ 'TASK_SETUP_DATABASE' => 'Setting up database',

+ 'TASK_CREATE_TABLES' => 'Creating tables',

+ 'last_task_module_index' => 0, // Stores the index of the latest finished module

+ 'last_task_index' => 0, // Stores the index of the latest finished task

+ * @param int $task_service_index Index of the installer task service in the module

+ public function set_finished_task($task_service_index)

+ $this->progress_data['last_task_index'] = $task_service_index;

+ * @param int $module_service_index Index of the installer module service

+ public function set_active_module($module_service_name, $module_service_index)

+ $this->progress_data['last_task_module_index'] = $module_service_index;

+ if (isset($this->navigation_data['finished']) && in_array($nav_path, $this->navigation_data['finished']))

+ {

+ return;

+ }

+

+ if (!$this->container->isFrozen())

+ $this->container->register('request')->setSynthetic(true);

+ $this->container->register('language')->setSynthetic(true);

+ $this->container->set('request', $this->request);

+ $this->container->set('language', $this->language);

+

+ public function send_response($no_more_output = false)

+ $json_data_array = $this->prepare_json_array($no_more_output);

+

+ if (empty($json_data_array))

+ {

+ return;

+ }

+

+ * @param bool $no_more_output Whether or not there will be more output in this response

+ *

+ protected function prepare_json_array($no_more_output = false)

+ $json_array = array();

+

+ if (!empty($this->errors))

+ {

+ $json_array['errors'] = $this->errors;

+ $this->errors = array();

+ }

+

+ if (!empty($this->warnings))

+ {

+ $json_array['warnings'] = $this->warnings;

+ $this->warnings = array();

+ }

+ if (!empty($this->logs))

+ {

+ $json_array['logs'] = $this->logs;

+ $this->logs = array();

+ }

+

+ if (!empty($this->success))

+ {

+ $json_array['success'] = $this->success;

+ $this->success = array();

+ }

+

+ if (!empty($this->download))

+ {

+ $json_array['download'] = $this->download;

+ $this->download = array();

+ }

+ if ($no_more_output)

+ {

+ $json_array['over'] = true;

+ }

+

+ $this->send_response(true);

+ public function send_response($no_more_output = false)

+ *

+ * @param bool $no_more_output Whether or not there will be more output in this output unit

+ public function send_response($no_more_output = false);

+use phpbb\install\exception\cannot_build_container_exception;

+use phpbb\install\helper\container_factory;

+ * @var container_factory

+ */

+ protected $container_factory;

+

+ /**

+ * @var ordered_service_collection

+ * @var bool

+ */

+ protected $purge_cache_before;

+

+ /**

+ * @param container_factory $container Container

+ public function __construct(driver_interface $cache, config $config, path_helper $path_helper, container_factory $container)

+ $this->container_factory = $container;

+ $this->purge_cache_before = false;

+ * Sets whether to purge cache before the installation process

+ *

+ * @param bool $purge_cache_before

+ */

+ public function set_purge_cache_before($purge_cache_before)

+ {

+ $this->purge_cache_before = $purge_cache_before;

+ }

+

+ /**

+ if (!$this->install_config->get('cache_purged_before', false) && $this->purge_cache_before)

+ {

+ /** @var \phpbb\cache\driver\driver_interface $cache */

+ $cache = $this->container_factory->get('cache.driver');

+ $cache->purge();

+ $this->install_config->set('cache_purged_before', true);

+ }

+

+ $module_index = $this->recover_progress();

+ $iterator = $this->installer_modules->getIterator();

+ $iterator->seek($module_index);

+ while ($iterator->valid())

+ {

+ $module = $iterator->current();

+ $name = $iterator->key();

+ }

+ else

+ {

+ // Set the correct stage in the navigation bar

+ $this->install_config->set_active_navigation_stage($module->get_navigation_stage_path());

+ $this->iohandler->set_active_stage_menu($module->get_navigation_stage_path());

+

+ $this->iohandler->send_response();

+

+ $module->run();

+

+ $this->install_config->set_finished_navigation_stage($module->get_navigation_stage_path());

+ $this->iohandler->set_finished_stage_menu($module->get_navigation_stage_path());

+ $module_index++;

+ $iterator->next();

+ // Save progress

+ $this->install_config->set_active_module($name, $module_index);

+ if ($iterator->valid() && ($this->install_config->get_time_remaining() <= 0 || $this->install_config->get_memory_remaining() <= 0))

+ {

+ throw new resource_limit_reached_exception();

+ }

+ $this->iohandler->send_response(true);

+ $this->iohandler->send_response(true);

+ $this->iohandler->send_response(true);

+ $this->iohandler->send_response(true);

+

+ try

+ {

+ /** @var \phpbb\cache\driver\driver_interface $cache */

+ $cache = $this->container_factory->get('cache.driver');

+ $cache->purge();

+ }

+ catch (cannot_build_container_exception $e)

+ {

+ // Do not do anything, this just means there is no config.php yet

+ }

+ return $progress_array['last_task_module_index'];

+use phpbb\install\exception\resource_limit_reached_exception;

+

+ $i = $this->install_config->get('add_bot_index', 0);

+ $bot_list = array_slice($this->bot_list, $i);

+

+ foreach ($bot_list as $bot_name => $bot_ary)

+

+ $i++;

+

+ // Stop execution if resource limit is reached

+ if ($this->install_config->get_time_remaining() <= 0 || $this->install_config->get_memory_remaining() <= 0)

+ {

+ break;

+ }

+ }

+

+ $this->install_config->set('add_bot_index', $i);

+

+ if ($i < sizeof($this->bot_list))

+ {

+ throw new resource_limit_reached_exception();

+use phpbb\install\exception\resource_limit_reached_exception;

+use phpbb\install\helper\config;

+use phpbb\install\helper\container_factory;

+use phpbb\install\helper\iohandler\iohandler_interface;

+

+ * @var config

+ */

+ protected $config;

+

+ /**

+ * @parma config $config Installer's config

+ * @param iohandler_interface $iohandler Installer's input-output handler

+ * @param container_factory $container Installer's DI container

+ public function __construct(config $config, iohandler_interface $iohandler, container_factory $container)

+ $this->config = $config;

+ $total = sizeof($module_classes);

+ $i = $this->config->get('module_class_index', 0);

+ $module_classes = array_slice($module_classes, $i);

+

+ $categories = $this->config->get('module_categories_array', array());

+

+ $k = $this->config->get('module_categories_index', 0);

+ $module_categories = array_slice($this->module_categories[$module_class], $k);

+ $timed_out = false;

+ foreach ($module_categories as $cat_name => $subs)

+

+ $k++;

+

+ // Stop execution if resource limit is reached

+ if ($this->config->get_time_remaining() <= 0 || $this->config->get_memory_remaining() <= 0)

+ {

+ $timed_out = true;

+ break;

+ }

+ }

+

+ $this->config->set('module_categories_array', $categories);

+ $this->config->set('module_categories_index', $k);

+

+ if ($timed_out)

+ {

+ throw new resource_limit_reached_exception();

+ $k = $this->config->get('module_info_index', 0);

+ $module_info = array_slice($module_info, $k);

+

+ $k++;

+ // Stop execution if resource limit is reached

+ if ($this->config->get_time_remaining() <= 0 || $this->config->get_memory_remaining() <= 0)

+ {

+ $timed_out = true;

+ break;

+ }

+ }

+ $this->config->set('module_info_index', $k);

+ // Stop execution if resource limit is reached

+ if ($timed_out)

+ {

+ throw new resource_limit_reached_exception();

+ }

+ // Move some of the modules around since the code above will put them in the wrong place

+ if (!$this->config->get('modules_ordered', false))

+ {

+ $this->order_modules($module_class);

+ $this->config->set('modules_ordered', true);

+ // Stop execution if resource limit is reached

+ if ($this->config->get_time_remaining() <= 0 || $this->config->get_memory_remaining() <= 0)

+ {

+ throw new resource_limit_reached_exception();

+ }

+ // And now for the special ones

+ // (these are modules which appear in multiple categories and thus get added manually

+ // to some for more control)

+ if (isset($this->module_extras[$module_class]))

+ $this->add_module_extras($module_class);

+ }

+ $this->module_manager->remove_cache_file($module_class);

+ $i++;

+ $this->config->set('module_class_index', $i);

+ $this->config->set('module_categories_index', 0);

+ $this->config->set('module_info_index', 0);

+ $this->config->set('added_extra_modules', false);

+ $this->config->set('modules_ordered', false);

+ $this->config->set('module_categories_array', array());

+ // Stop execution if resource limit is reached

+ if ($this->config->get_time_remaining() <= 0 || $this->config->get_memory_remaining() <= 0)

+ {

+ break;

+ }

+ if ($i < $total)

+ {

+ throw new resource_limit_reached_exception();

+ }

+ }

+ /**

+ * Move modules to their correct place

+ *

+ * @param string $module_class

+ */

+ protected function order_modules($module_class)

+ {

+ if ($module_class == 'acp')

+ {

+ // Move main module 4 up...

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_basename = 'acp_main'

+ AND module_class = 'acp'

+ AND module_mode = 'main'";

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

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

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

+

+ $this->module_manager->move_module_by($row, 'acp', 'move_up', 4);

+

+ // Move permissions intro screen module 4 up...

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_basename = 'acp_permissions'

+ AND module_class = 'acp'

+ AND module_mode = 'intro'";

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

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

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

+

+ $this->module_manager->move_module_by($row, 'acp', 'move_up', 4);

+

+ // Move manage users screen module 5 up...

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_basename = 'acp_users'

+ AND module_class = 'acp'

+ AND module_mode = 'overview'";

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

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

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

+

+ $this->module_manager->move_module_by($row, 'acp', 'move_up', 5);

+

+ // Move extension management module 1 up...

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_langname = 'ACP_EXTENSION_MANAGEMENT'

+ AND module_class = 'acp'

+ AND module_mode = ''

+ AND module_basename = ''";

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

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

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

+

+ $this->module_manager->move_module_by($row, 'acp', 'move_up', 1);

+ }

+ if ($module_class == 'mcp')

+ {

+ // Move pm report details module 3 down...

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_basename = 'mcp_pm_reports'

+ AND module_class = 'mcp'

+ AND module_mode = 'pm_report_details'";

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

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

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

+

+ $this->module_manager->move_module_by($row, 'mcp', 'move_down', 3);

+

+ // Move closed pm reports module 3 down...

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_basename = 'mcp_pm_reports'

+ AND module_class = 'mcp'

+ AND module_mode = 'pm_reports_closed'";

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

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

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

+

+ $this->module_manager->move_module_by($row, 'mcp', 'move_down', 3);

+

+ // Move open pm reports module 3 down...

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_basename = 'mcp_pm_reports'

+ AND module_class = 'mcp'

+ AND module_mode = 'pm_reports'";

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

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

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

+

+ $this->module_manager->move_module_by($row, 'mcp', 'move_down', 3);

+ }

+ if ($module_class == 'ucp')

+ {

+ // Move attachment module 4 down...

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_basename = 'ucp_attachments'

+ AND module_class = 'ucp'

+ AND module_mode = 'attachments'";

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

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

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

+

+ $this->module_manager->move_module_by($row, 'ucp', 'move_down', 4);

+

+ // Move notification options module 4 down...

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_basename = 'ucp_notifications'

+ AND module_class = 'ucp'

+ AND module_mode = 'notification_options'";

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

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

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

+

+ $this->module_manager->move_module_by($row, 'ucp', 'move_down', 4);

+

+ // Move OAuth module 5 down...

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_basename = 'ucp_auth_link'

+ AND module_class = 'ucp'

+ AND module_mode = 'auth_link'";

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

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

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

+

+ $this->module_manager->move_module_by($row, 'ucp', 'move_down', 5);

+ }

+ }

+ /**

+ * Add extra modules

+ *

+ * @param string $module_class

+ */

+ protected function add_module_extras($module_class)

+ {

+ foreach ($this->module_extras[$module_class] as $cat_name => $mods)

+ {

+ $sql = 'SELECT module_id, left_id, right_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_langname = '" . $this->db->sql_escape($cat_name) . "'

+ AND module_class = '" . $this->db->sql_escape($module_class) . "'";

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

+ $row2 = $this->db->sql_fetchrow($result);

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

+

+ foreach ($mods as $mod_name)

+ {

+ WHERE module_langname = '" . $this->db->sql_escape($mod_name) . "'

+ AND module_class = '" . $this->db->sql_escape($module_class) . "'

+ AND module_basename <> ''";

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

+ $module_data = array(

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

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

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

+ 'parent_id' => (int) $row2['module_id'],

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

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

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

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

+ );

+ $this->module_manager->update_module_data($module_data);

+ // Check for last sql error happened

+ if ($this->db->get_sql_error_triggered())

+ {

+ $error = $this->db->sql_error($this->db->get_sql_error_sql());

+ $this->iohandler->add_error_message('INST_ERR_DB', $error['message']);

+use phpbb\install\exception\resource_limit_reached_exception;

+

+ $i = $this->install_config->get('add_config_settings_index', 0);

+ $total = sizeof($sql_ary);

+ $sql_ary = array_slice($sql_ary, $i);

+

+

+ $i++;

+

+ // Stop execution if resource limit is reached

+ if ($this->install_config->get_time_remaining() <= 0 || $this->install_config->get_memory_remaining() <= 0)

+ {

+ break;

+ }

+ }

+

+ if ($i < $total)

+ {

+ $this->install_config->set('add_config_settings_index', $i);

+ throw new resource_limit_reached_exception();

+use phpbb\install\exception\resource_limit_reached_exception;

+

+ $i = $this->config->get('add_default_data_index', 0);

+ $total = sizeof($sql_query);

+ $sql_query = array_slice($sql_query, $i);

+

+

+ $i++;

+

+ // Stop execution if resource limit is reached

+ if ($this->config->get_time_remaining() <= 0 || $this->config->get_memory_remaining() <= 0)

+ {

+ break;

+ }

+ }

+

+ $this->config->set('add_default_data_index', $i);

+

+ if ($i < $total)

+ {

+ throw new resource_limit_reached_exception();

+<?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\install\module\install_database\task;

+

+use phpbb\install\exception\resource_limit_reached_exception;

+

+/**

+ * Create tables

+ */

+class add_tables extends \phpbb\install\task_base

+{

+ /**

+ * @var \phpbb\install\helper\config

+ */

+ protected $config;

+

+ /**

+ * @var \phpbb\db\driver\driver_interface

+ */

+ protected $db;

+

+ /**

+ * @var \phpbb\db\tools\tools_interface

+ */

+ protected $db_tools;

+

+ /**

+ * @var \phpbb\filesystem\filesystem_interface

+ */

+ protected $filesystem;

+

+ /**

+ * @var string

+ */

+ protected $schema_file_path;

+

+ /**

+ * Constructor

+ *

+ * @param \phpbb\install\helper\config $config

+ * @param \phpbb\install\helper\database $db_helper

+ * @param \phpbb\filesystem\filesystem_interface $filesystem

+ * @param string $phpbb_root_path

+ */

+ public function __construct(\phpbb\install\helper\config $config,

+ \phpbb\install\helper\database $db_helper,

+ \phpbb\filesystem\filesystem_interface $filesystem,

+ $phpbb_root_path)

+ {

+ $dbms = $db_helper->get_available_dbms($config->get('dbms'));

+ $dbms = $dbms[$config->get('dbms')]['DRIVER'];

+ $factory = new \phpbb\db\tools\factory();

+

+ $this->db = new $dbms();

+ $this->db->sql_connect(

+ $config->get('dbhost'),

+ $config->get('dbuser'),

+ $config->get('dbpasswd'),

+ $config->get('dbname'),

+ $config->get('dbport'),

+ false,

+ false

+ );

+

+ $this->config = $config;

+ $this->db_tools = $factory->get($this->db);

+ $this->filesystem = $filesystem;

+ $this->schema_file_path = $phpbb_root_path . 'store/schema.json';

+

+ parent::__construct(true);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function run()

+ {

+ $this->db->sql_return_on_error(true);

+

+ $table_prefix = $this->config->get('table_prefix');

+ $change_prefix = $this->config->get('change_table_prefix', true);

+

+ if (!defined('CONFIG_TABLE'))

+ {

+ // CONFIG_TABLE is required by sql_create_index() to check the

+ // length of index names. However table_prefix is not defined

+ // here yet, so we need to create the constant ourselves.

+ define('CONFIG_TABLE', $table_prefix . 'config');

+ }

+

+ $db_table_schema = @file_get_contents($this->schema_file_path);

+ $db_table_schema = json_decode($db_table_schema, true);

+ $total = sizeof($db_table_schema);

+ $i = $this->config->get('add_table_index', 0);

+ $db_table_schema = array_slice($db_table_schema, $i);

+

+ foreach ($db_table_schema as $table_name => $table_data)

+ {

+ $i++;

+

+ $this->db_tools->sql_create_table(

+ ( ($change_prefix) ? ($table_prefix . substr($table_name, 6)) : $table_name ),

+ $table_data

+ );

+

+ // Stop execution if resource limit is reached

+ if ($this->config->get_time_remaining() <= 0 || $this->config->get_memory_remaining() <= 0)

+ {

+ break;

+ }

+ }

+

+ $this->config->set('add_table_index', $i);

+

+ if ($i < $total)

+ {

+ throw new resource_limit_reached_exception();

+ }

+ else

+ {

+ @unlink($this->schema_file_path);

+ }

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ static public function get_step_count()

+ {

+ return 1;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_task_lang_name()

+ {

+ return 'TASK_CREATE_TABLES';

+ }

+}

+<?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\install\module\install_database\task;

+

+use phpbb\install\exception\resource_limit_reached_exception;

+

+/**

+ * Create database schema

+ */

+class create_schema_file extends \phpbb\install\task_base

+{

+ /**

+ * @var \phpbb\install\helper\config

+ */

+ protected $config;

+

+ /**

+ * @var \phpbb\db\driver\driver_interface

+ */

+ protected $db;

+

+ /**

+ * @var \phpbb\filesystem\filesystem_interface

+ */

+ protected $filesystem;

+

+ /**

+ * @var string

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * @var string

+ */

+ protected $php_ext;

+

+ /**

+ * Constructor

+ *

+ * @param \phpbb\install\helper\config $config Installer's config provider

+ * @param \phpbb\install\helper\database $db_helper Installer's database helper

+ * @param \phpbb\filesystem\filesystem_interface $filesystem Filesystem service

+ * @param string $phpbb_root_path Path phpBB's root

+ * @param string $php_ext Extension of PHP files

+ */

+ public function __construct(\phpbb\install\helper\config $config,

+ \phpbb\install\helper\database $db_helper,

+ \phpbb\filesystem\filesystem_interface $filesystem,

+ $phpbb_root_path,

+ $php_ext)

+ {

+ $dbms = $db_helper->get_available_dbms($config->get('dbms'));

+ $dbms = $dbms[$config->get('dbms')]['DRIVER'];

+

+ $this->db = new $dbms();

+ $this->db->sql_connect(

+ $config->get('dbhost'),

+ $config->get('dbuser'),

+ $config->get('dbpasswd'),

+ $config->get('dbname'),

+ $config->get('dbport'),

+ false,

+ false

+ );

+

+ $this->config = $config;

+ $this->filesystem = $filesystem;

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+

+ parent::__construct(true);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function run()

+ {

+ // Generate database schema

+ if ($this->filesystem->exists($this->phpbb_root_path . 'install/schemas/schema.json'))

+ {

+ $db_table_schema = @file_get_contents($this->phpbb_root_path . 'install/schemas/schema.json');

+ $this->config->set('change_table_prefix', true);

+ }

+ else

+ {

+ global $table_prefix;

+

+ // As this task may take a large amount of time to complete refreshing the page might be necessary for some

+ // server configurations with limited resources

+ if (!$this->config->get('pre_schema_forced_refresh', false))

+ {

+ if ($this->config->get_time_remaining() < 5)

+ {

+ $this->config->set('pre_schema_forced_refresh', true);

+ throw new resource_limit_reached_exception();

+ }

+ }

+

+ $table_prefix = $this->config->get('table_prefix');

+

+ if (!defined('CONFIG_TABLE'))

+ {

+ // We need to include the constants file for the table constants

+ // when we generate the schema from the migration files.

+ include ($this->phpbb_root_path . 'includes/constants.' . $this->php_ext);

+ }

+

+ $finder = new \phpbb\finder($this->filesystem, $this->phpbb_root_path, null, $this->php_ext);

+ $migrator_classes = $finder->core_path('phpbb/db/migration/data/')->get_classes();

+ $factory = new \phpbb\db\tools\factory();

+ $db_tools = $factory->get($this->db, true);

+ $schema_generator = new \phpbb\db\migration\schema_generator(

+ $migrator_classes,

+ new \phpbb\config\config(array()),

+ $this->db,

+ $db_tools,

+ $this->phpbb_root_path,

+ $this->php_ext,

+ $table_prefix

+ );

+ $db_table_schema = $schema_generator->get_schema();

+ $db_table_schema = json_encode($db_table_schema, JSON_PRETTY_PRINT);

+

+ $this->config->set('change_table_prefix', false);

+ }

+

+ $fp = @fopen($this->phpbb_root_path . 'store/schema.json', 'wb');

+ if (!$fp)

+ {

+ throw new \Exception('INST_SCHEMA_FILE_NOT_WRITABLE');

+ }

+

+ fwrite($fp, $db_table_schema);

+ fclose($fp);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ static public function get_step_count()

+ {

+ return 1;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_task_lang_name()

+ {

+ return 'TASK_CREATE_DATABASE_SCHEMA_FILE';

+ }

+}

+<?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\install\module\install_database\task;

+

+/**

+ * Set up database for table generation

+ */

+class set_up_database extends \phpbb\install\task_base

+{

+ /**

+ * @var \phpbb\install\helper\config

+ */

+ protected $config;

+

+ /**

+ * @var \phpbb\db\driver\driver_interface

+ */

+ protected $db;

+

+ /**

+ * @var \phpbb\install\helper\database

+ */

+ protected $database_helper;

+

+ /**

+ * @var \phpbb\filesystem\filesystem_interface

+ */

+ protected $filesystem;

+

+ /**

+ * @var \phpbb\install\helper\iohandler\iohandler_interface

+ */

+ protected $iohandler;

+

+ /**

+ * @var string

+ */

+ protected $schema_file_path;

+

+ /**

+ * @var string

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * Constructor

+ *

+ * @param \phpbb\install\helper\config $config

+ * @param \phpbb\install\helper\database $db_helper

+ * @param \phpbb\filesystem\filesystem_interface $filesystem

+ * @param \phpbb\install\helper\iohandler\iohandler_interface $iohandler

+ * @param string $phpbb_root_path

+ */

+ public function __construct(\phpbb\install\helper\config $config,

+ \phpbb\install\helper\database $db_helper,

+ \phpbb\filesystem\filesystem_interface $filesystem,

+ \phpbb\install\helper\iohandler\iohandler_interface $iohandler,

+ $phpbb_root_path)

+ {

+ $dbms = $db_helper->get_available_dbms($config->get('dbms'));

+ $dbms = $dbms[$config->get('dbms')]['DRIVER'];

+

+ $this->db = new $dbms();

+ $this->db->sql_connect(

+ $config->get('dbhost'),

+ $config->get('dbuser'),

+ $config->get('dbpasswd'),

+ $config->get('dbname'),

+ $config->get('dbport'),

+ false,

+ false

+ );

+

+ $this->config = $config;

+ $this->database_helper = $db_helper;

+ $this->filesystem = $filesystem;

+ $this->iohandler = $iohandler;

+ $this->phpbb_root_path = $phpbb_root_path;

+

+ parent::__construct(false);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function check_requirements()

+ {

+ $dbms = $this->config->get('dbms');

+ $dbms_info = $this->database_helper->get_available_dbms($dbms);

+ $schema_name = $dbms_info[$dbms]['SCHEMA'];

+

+ if ($dbms === 'mysql')

+ {

+ if (version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

+ {

+ $schema_name .= '_41';

+ }

+ else

+ {

+ $schema_name .= '_40';

+ }

+ }

+

+ $this->schema_file_path = $this->phpbb_root_path . 'install/schemas/' . $schema_name . '_schema.sql';

+

+ return $this->filesystem->exists($this->schema_file_path);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function run()

+ {

+ $this->db->sql_return_on_error(true);

+

+ $dbms = $this->config->get('dbms');

+ $dbms_info = $this->database_helper->get_available_dbms($dbms);

+ $delimiter = $dbms_info[$dbms]['DELIM'];

+ $table_prefix = $this->config->get('table_prefix');

+

+ $sql_query = @file_get_contents($this->schema_file_path);

+ $sql_query = preg_replace('#phpbb_#i', $table_prefix, $sql_query);

+ $sql_query = $this->database_helper->remove_comments($sql_query);

+ $sql_query = $this->database_helper->split_sql_file($sql_query, $delimiter);

+

+ foreach ($sql_query as $sql)

+ {

+ if (!$this->db->sql_query($sql))

+ {

+ $error = $this->db->sql_error($this->db->get_sql_error_sql());

+ $this->iohandler->add_error_message('INST_ERR_DB', $error['message']);

+ }

+ }

+

+ unset($sql_query);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ static public function get_step_count()

+ {

+ return 1;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_task_lang_name()

+ {

+ return 'TASK_SETUP_DATABASE';

+ }

+}

+ /** @var \phpbb\cache\driver\driver_interface $cache */

+ $cache = $container->get('cache.driver');

+ $cache->destroy('config');

+

+ $cache,

+use phpbb\install\exception\resource_limit_reached_exception;

+use phpbb\install\helper\config;

+use phpbb\install\helper\container_factory;

+

+ * @var config

+ */

+ protected $config;

+

+ /**

+ * @param config $config Installer's config

+ * @param container_factory $container phpBB's DI contianer

+ public function __construct(config $config, container_factory $container)

+ $this->config = $config;

+ if (!$this->config->get('populate_migration_refresh_before', false))

+ {

+ if ($this->config->get_time_remaining() < 1)

+ {

+ $this->config->set('populate_migration_refresh_before', true);

+ throw new resource_limit_reached_exception();

+ }

+ }

+

+ $this->install_config->set_finished_task(0);

+ $task_index = $this->recover_progress();

+ $iterator = $this->task_collection->getIterator();

+ if ($task_index < $iterator->count())

+ {

+ $iterator->seek($task_index);

+ }

+ else

+ {

+ $this->install_config->set_finished_task(0);

+ return;

+ }

+ while ($iterator->valid())

+ {

+ $task = $iterator->current();

+ $name = $iterator->key();

+ else

+ // Send progress information

+ if ($this->allow_progress_bar)

+ {

+ $this->iohandler->set_progress(

+ $task->get_task_lang_name(),

+ $this->install_config->get_current_task_progress()

+ );

+

+ $this->iohandler->send_response();

+ }

+

+ $task->run();

+ if ($this->allow_progress_bar)

+ {

+ // Only increment progress by one, as if a task has more than one steps

+ // then that should be incremented in the task itself

+ $this->install_config->increment_current_task_progress();

+ }

+ }

+ $task_index++;

+ $this->install_config->set_finished_task($task_index);

+ $iterator->next();

+

+ // Stop execution if resource limit is reached

+ if ($this->install_config->get_time_remaining() <= 0 || $this->install_config->get_memory_remaining() <= 0)

+ {

+ throw new resource_limit_reached_exception();

+ }

+ $this->install_config->set_finished_task(0);

+ return $progress_array['last_task_index'];

+ $this->config->set_finished_task(0);

+ $this->config->set_active_module('bar', 5);

+ 'last_task_module_index' => 5,

+ 'last_task_index' => 0,

+ static protected $install_success = false;

+ if (!self::$install_success)

+ {

+ $this->fail('Installing phpBB has failed.');

+ }

+

+ $installer->run();

+ self::$install_success = true;

+

+ if (file_exists($phpbb_root_path . 'store/install_config.php'))

+ {

+ self::$install_success = false;

+ @unlink($phpbb_root_path . 'store/install_config.php');

+ }

+

+ @unlink($phpbb_root_path . 'cache/install_lock');

+ static protected $install_success = false;

+ static protected $db;

+ public function setUp()

+ {

+ if (!self::$install_success)

+ {

+ $this->fail('Installing phpBB has failed.');

+ }

+ }

+

+ protected function tearDown()

+ {

+ parent::tearDown();

+

+ if (self::$db instanceof \phpbb\db\driver\driver_interface)

+ {

+ // Close the database connections again this test

+ self::$db->sql_close();

+ }

+ }

+

+ global $phpbb_root_path, $phpEx, $db;

+ $db = self::get_db();

+

+ $installer->run();

+ self::$install_success = true;

+

+ if (file_exists($phpbb_root_path . 'store/install_config.php'))

+ {

+ self::$install_success = false;

+ @unlink($phpbb_root_path . 'store/install_config.php');

+ }

+

+ @unlink($phpbb_root_path . 'cache/install_lock');

+

+ static protected function get_db()

+ {

+ global $phpbb_root_path, $phpEx;

+ // so we don't reopen an open connection

+ if (!(self::$db instanceof \phpbb\db\driver\driver_interface))

+ {

+ $dbms = self::$config['dbms'];

+ /** @var \phpbb\db\driver\driver_interface $db */

+ $db = new $dbms();

+ $db->sql_connect(self::$config['dbhost'], self::$config['dbuser'], self::$config['dbpasswd'], self::$config['dbname'], self::$config['dbport']);

+ self::$db = $db;

+ }

+ return self::$db;

+ }