model_database = new Database(); $this->model_database->setTranslator($this->translator); } /** * {@inheritdoc} */ public function processNextStep(): void { // Save database config $this->session->database_server = trim(Tools::getValue('dbServer')); $this->session->database_name = trim(Tools::getValue('dbName')); $this->session->database_login = trim(Tools::getValue('dbLogin')); $this->session->database_password = trim(Tools::getValue('dbPassword')); $this->session->database_prefix = trim(Tools::getValue('db_prefix')); $this->session->database_clear = Tools::getValue('database_clear'); $this->session->rewrite_engine = Tools::getValue('rewrite_engine'); } /** * {@inheritdoc} */ public function validate(): bool { $this->errors = $this->model_database->testDatabaseSettings( $this->session->database_server, $this->session->database_name, $this->session->database_login, $this->session->database_password, $this->session->database_prefix, // We do not want to validate table prefix if we are already in install process ($this->session->step == 'process') ? true : $this->session->database_clear ); if (count($this->errors)) { return false; } if (!isset($this->session->database_engine)) { $this->session->database_engine = $this->model_database->getBestEngine($this->session->database_server, $this->session->database_name, $this->session->database_login, $this->session->database_password); } return true; } /** * {@inheritdoc} */ public function process(): void { if (Tools::getValue('checkDb')) { $this->processCheckDb(); } elseif (Tools::getValue('createDb')) { $this->processCreateDb(); } } /** * Check if a connection to database is possible with these data */ public function processCheckDb(): void { $server = Tools::getValue('dbServer'); $database = Tools::getValue('dbName'); $login = Tools::getValue('dbLogin'); $password = Tools::getValue('dbPassword'); $prefix = Tools::getValue('db_prefix'); $clear = Tools::getValue('clear'); $errors = $this->model_database->testDatabaseSettings($server, $database, $login, $password, $prefix, $clear); $this->ajaxJsonAnswer( (count($errors)) ? false : true, (count($errors)) ? implode('
', $errors) : $this->translator->trans('Database is connected', [], 'Install') ); } /** * Attempt to create the database */ public function processCreateDb(): void { $server = Tools::getValue('dbServer'); $database = Tools::getValue('dbName'); $login = Tools::getValue('dbLogin'); $password = Tools::getValue('dbPassword'); $success = $this->model_database->createDatabase($server, $database, $login, $password); $this->ajaxJsonAnswer( $success, $success ? $this->translator->trans('Database is created', [], 'Install') : $this->translator->trans('Cannot create the database automatically', [], 'Install') ); } /** * {@inheritdoc} */ public function display(): void { if (!$this->session->database_server) { if (file_exists(_PS_ROOT_DIR_ . '/app/config/parameters.php')) { $parameters = require _PS_ROOT_DIR_ . '/app/config/parameters.php'; } else { $parameters = Yaml::parse(file_get_contents(_PS_ROOT_DIR_ . '/app/config/parameters.yml.dist')); } $this->database_server = $parameters['parameters']['database_host']; if (!empty($parameters['parameters']['database_port'])) { $this->database_server .= ':' . $parameters['parameters']['database_port']; } $this->database_name = $parameters['parameters']['database_name']; $this->database_login = $parameters['parameters']['database_user']; $this->database_password = $parameters['parameters']['database_password']; $this->database_engine = $parameters['parameters']['database_engine']; $this->database_prefix = substr(str_shuffle(str_repeat('0123456789abcdefghijklmnopqrstuvwxyz', mt_rand(1,10))), 0, 5).'_'; $this->database_clear = true; $this->use_smtp = false; $this->smtp_encryption = 'off'; $this->smtp_port = 25; } else { $this->database_server = $this->session->database_server; $this->database_name = $this->session->database_name; $this->database_login = $this->session->database_login; $this->database_password = $this->session->database_password; $this->database_engine = $this->session->database_engine; $this->database_prefix = $this->session->database_prefix; $this->database_clear = $this->session->database_clear; $this->use_smtp = $this->session->use_smtp; $this->smtp_encryption = $this->session->smtp_encryption; $this->smtp_port = $this->session->smtp_port; } $staticPrefix = defined('_PS_INSTALLER_STATIC_DB_PREFIX_') ? _PS_INSTALLER_STATIC_DB_PREFIX_ : null; if (is_string($staticPrefix) && $staticPrefix !== '') { $this->database_prefix = rtrim($staticPrefix, '_') . '_'; } $this->displayContent('database'); } }