Example #1
0
 public static function setupTestDatabase($database, $tablePrefix)
 {
     Model::setInstallationDir(ipFile(''));
     Model::createDatabaseStructure($database, $tablePrefix);
     Model::importData($tablePrefix);
     OptionHelper::import(__DIR__ . '/options.json');
     Model::insertAdmin('test', '*****@*****.**', 'test');
     ipSetOptionLang('Config.websiteTitle', 'TestSite', 'en');
     ipSetOptionLang('Config.websiteEmail', '*****@*****.**', 'en');
 }
 public function createDatabase()
 {
     if (!Helper::isInstallAvailable()) {
         return sprintf(__('Please remove content from %s file.', 'Install', false), 'config.php');
     }
     $db = ipRequest()->getPost('db');
     if (!isset($_SESSION['db_errors'])) {
         $_SESSION['db_errors'] = array();
     }
     foreach (array('hostname', 'username', 'database') as $key) {
         if (empty($db[$key])) {
             $_SESSION['db_errors'][] = 'Required fields';
             return \Ip\Response\JsonRpc::error(__('Please fill in required fields.', 'Install', false));
         }
     }
     if (empty($db['tablePrefix'])) {
         $db['tablePrefix'] = '';
     }
     if (strlen($db['tablePrefix']) > 7) {
         $_SESSION['db_errors'][] = 'Prefix too long';
         return \Ip\Response\JsonRpc::error(__("Prefix can't be longer than 7 symbols.", 'Install', false));
     }
     if ($db['tablePrefix'] != '' && !preg_match('/^([A-Za-z_][A-Za-z0-9_]*)$/', $db['tablePrefix'])) {
         $_SESSION['db_errors'][] = 'Prefix is bad';
         return \Ip\Response\JsonRpc::error(__("Prefix can't contain any special characters and should start with a letter.", 'Install', false));
     }
     $dbConfig = array('hostname' => $db['hostname'], 'username' => $db['username'], 'password' => $db['password'], 'tablePrefix' => $db['tablePrefix'], 'database' => '', 'charset' => 'utf8');
     ipConfig()->set('db', $dbConfig);
     try {
         ipDb()->getConnection();
     } catch (\Exception $e) {
         $_SESSION['db_errors'][] = 'Cannot connect';
         return \Ip\Response\JsonRpc::error(__("Can't connect to database.", 'Install'), false);
     }
     try {
         Model::createAndUseDatabase($db['database']);
     } catch (\Ip\Exception $e) {
         $_SESSION['db_errors'][] = 'DB cannot be created';
         return \Ip\Response\JsonRpc::error(__('Specified database does not exists and cannot be created.', 'Install', false));
     }
     if (Helper::testDBTables($db['tablePrefix']) && empty($db['replaceTables'])) {
         $_SESSION['db_errors'][] = 'Replace tables';
         return \Ip\Response\JsonRpc::error(__('Do you like to replace existing tables in the database?', 'Install', false), 'table_exists');
     }
     $errors = Model::createDatabaseStructure($db['database'], $db['tablePrefix']);
     if (!$errors) {
         $errors = Model::importData($dbConfig['tablePrefix']);
     }
     if ($errors) {
         $_SESSION['db_errors'][] = 'Failed install';
         return \Ip\Response\JsonRpc::error(__('There were errors while executing install queries. ' . serialize($errors), 'Install', false));
     }
     $dbConfig['database'] = $db['database'];
     $_SESSION['db'] = $dbConfig;
     $configToFile = array();
     $configToFile['sessionName'] = 'ses' . rand();
     $configToFile['db'] = $_SESSION['db'];
     $configToFile['timezone'] = $_SESSION['config']['timezone'];
     if (Helper::checkModRewrite() != 'success') {
         $configToFile['rewritesDisabled'] = true;
     }
     $admin = ipRequest()->getPost('admin');
     if ($admin) {
         $adminUsername = $admin['username'];
         $adminEmail = $admin['email'];
         $adminPassword = $admin['password'];
     }
     $cachedBaseUrl = substr(rtrim(ipConfig()->baseUrl(), "/"), 0, -strlen('install'));
     try {
         ipConfig()->set('db', $dbConfig);
         // if admin data is posted then user will be created
         if ($admin) {
             Model::insertAdmin($adminUsername, $adminEmail, $adminPassword);
         }
         ipSetOptionLang('Config.websiteTitle', $_SESSION['config']['websiteName'], 'en');
         ipSetOptionLang('Config.websiteEmail', $_SESSION['config']['websiteEmail'], 'en');
         Model::generateCronPassword();
         ipStorage()->set('Ip', 'cachedBaseUrl', $cachedBaseUrl);
         ipStorage()->set('Ip', 'websiteId', $_SESSION['websiteId']);
         ipStorage()->set('Ip', 'getImpressPagesSupport', $_SESSION['config']['support']);
     } catch (\Exception $e) {
         $_SESSION['db_errors'][] = $e->getTraceAsString();
         return \Ip\Response\JsonRpc::error($e->getTraceAsString());
     }
     try {
         Model::writeConfigFile($configToFile, ipFile('config.php'));
     } catch (\Exception $e) {
         $_SESSION['db_errors'][] = 'Cannot write config file';
         return \Ip\Response\JsonRpc::error(__('Can\'t write configuration "/config.php"', 'Install', false));
     }
     // Send usage statistics
     $usageStatistics = Helper::setUsageStatistics('Install.database', $_SESSION['db_errors']);
     \Ip\Internal\System\Model::sendUsageStatistics($usageStatistics);
     $redirect = $cachedBaseUrl . 'admin';
     return \Ip\Response\JsonRpc::result(array('redirect' => $redirect));
 }