Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` MODIFY `ssl_ca_file` mediumtext NOT NULL"); Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` MODIFY `ssl_cert_chainfile` mediumtext NOT NULL"); lastStepStatus(0); updateToVersion('0.9.34-dev2'); } if (isFroxlorVersion('0.9.34-dev2')) { showUpdateStep("Updating from 0.9.34-dev2 to 0.9.34-dev3", false); $do_update = true; showUpdateStep("Checking for required PHP mbstring-extension"); if (!extension_loaded('mbstring')) { $do_update = false; lastStepStatus(2, 'not installed'); } else { lastStepStatus(0); } if ($do_update) { updateToVersion('0.9.34-dev3'); } } if (isFroxlorVersion('0.9.34-dev3')) { showUpdateStep("Updating from 0.9.34-dev3 to 0.9.34-dev4", false); showUpdateStep("Adding field umask to phpconfig table"); Database::query("ALTER TABLE `" . TABLE_PANEL_PHPCONFIGS . "` ADD `mod_fcgid_umask` varchar(15) NOT NULL DEFAULT '022' AFTER `mod_fcgid_maxrequests`"); lastStepStatus(0); updateToVersion('0.9.34-dev4'); } if (isFroxlorVersion('0.9.34-dev4')) { showUpdateStep("Updating from 0.9.34-dev4 to 0.9.34 final"); lastStepStatus(0); updateToVersion('0.9.34'); }
$db->query("INSERT INTO `panel_settings` (`settinggroup`, `varname`, `value`) VALUES ('system', 'mod_fcgid_idle_timeout', '30');"); } // Get FastCGI timeout setting if available $handle = $db->query("SELECT `value` FROM `panel_settings` WHERE `settinggroup` = 'phpfpm' AND `varname` = 'idle_timeout';"); // If timeout is set then skip if ($db->num_rows($handle) < 1) { $db->query("INSERT INTO `panel_settings` (`settinggroup`, `varname`, `value`) VALUES ('phpfpm', 'idle_timeout', '30');"); } updateToVersion('0.9.27-svn2'); } if (isFroxlorVersion('0.9.27-svn2')) { showUpdateStep("Updating from 0.9.27-svn2 to 0.9.27-rc1"); lastStepStatus(0); updateToVersion('0.9.27-rc1'); } if (isFroxlorVersion('0.9.27-rc1')) { showUpdateStep("Updating from 0.9.27-rc1 to 0.9.27"); lastStepStatus(0); updateToVersion('0.9.27'); } if (isFroxlorVersion('0.9.27')) { showUpdateStep("Updating from 0.9.27 to 0.9.28-svn1"); lastStepStatus(0); // Get AliasconfigDir setting if available $handle = $db->query("SELECT `value` FROM `panel_settings` WHERE `settinggroup` = 'phpfpm' AND `varname` = 'aliasconfigdir';"); // If AliasconfigDir is set then skip if ($db->num_rows($handle) < 1) { $db->query("INSERT INTO `panel_settings` (`settinggroup`, `varname`, `value`) VALUES ('phpfpm', 'aliasconfigdir', '/var/www/php-fpm/');"); } updateToVersion('0.9.28-svn1'); }
lastStepStatus(0); // Get FastCGI timeout setting if available $handle = $db->query("SELECT `value` FROM `panel_settings` WHERE `settinggroup` = 'system' AND `varname` = 'mod_fcgid_idle_timeout';"); // If timeout is set then skip if ($db->num_rows($handle) < 1) { $db->query("INSERT INTO `panel_settings` (`settinggroup`, `varname`, `value`) VALUES ('system', 'mod_fcgid_idle_timeout', '30');"); } // Get FastCGI timeout setting if available $handle = $db->query("SELECT `value` FROM `panel_settings` WHERE `settinggroup` = 'phpfpm' AND `varname` = 'idle_timeout';"); // If timeout is set then skip if ($db->num_rows($handle) < 1) { $db->query("INSERT INTO `panel_settings` (`settinggroup`, `varname`, `value`) VALUES ('phpfpm', 'idle_timeout', '30');"); } updateToVersion('0.9.27-svn2'); } if (isFroxlorVersion('0.9.27-svn2')) { showUpdateStep("Updating from 0.9.27-svn2 to 0.9.27-rc1"); lastStepStatus(0); updateToVersion('0.9.27-rc1'); } if (isFroxlorVersion('0.9.27-rc1')) { showUpdateStep("Updating from 0.9.27-rc1 to 0.9.27"); lastStepStatus(0); // Add the external access column (see ticket #814); $db->query('ALTER TABLE froxlor.panel_databases ADD allow_external_access INT(1) DEFAULT 0'); $db->query('ALTER TABLE froxlor.panel_domains ADD special_phpsettings TEXT DEFAULT ""'); // Add php versions $db->query('ALTER TABLE froxlor.panel_domains ADD php_version VARCHAR(100) DEFAULT "5.3.22"'); $db->query('ALTER TABLE froxlor.panel_customers ADD nitrado_service_type VARCHAR(50) DEFAULT "beginner"'); updateToVersion('0.9.27'); }
updateToVersion('0.9.32'); } if (isFroxlorVersion('0.9.32')) { showUpdateStep("Updating from 0.9.32 to 0.9.33-dev1", false); showUpdateStep("Adding settings for custom newsfeed on customer-dashboard"); Settings::AddNew("customer.show_news_feed", isset($_POST['customer_show_news_feed']) ? (int) $_POST['customer_show_news_feed'] : '0'); Settings::AddNew("customer.news_feed_url", isset($_POST['customer_news_feed_url']) ? $_POST['customer_news_feed_url'] : ''); lastStepStatus(0); updateToVersion('0.9.33-dev1'); } if (isFroxlorVersion('0.9.33-dev1')) { showUpdateStep("Updating from 0.9.33-dev1 to 0.9.33-dev2", false); showUpdateStep("Adding settings for hostname-dns-entry"); Settings::AddNew("system.dns_createhostnameentry", isset($_POST['dns_createhostnameentry']) ? (int) $_POST['dns_createhostnameentry'] : '0'); lastStepStatus(0); updateToVersion('0.9.33-dev2'); } if (isFroxlorVersion('0.9.33-dev2')) { showUpdateStep("Updating from 0.9.33-dev2 to 0.9.33-dev3", false); showUpdateStep("Adding settings for password-generation options"); Settings::AddNew("panel.password_alpha_lower", '1'); Settings::AddNew("panel.password_alpha_upper", '1'); Settings::AddNew("panel.password_numeric", '0'); Settings::AddNew("panel.password_special_char_required", '0'); Settings::AddNew("panel.password_special_char", '!?<>§$%&+#=@'); lastStepStatus(0); showUpdateStep("Adding settings for fpm-apache2.4-mod_proxy integration"); Settings::AddNew("phpfpm.use_mod_proxy", '0'); lastStepStatus(0); updateToVersion('0.9.33-dev3'); }
} if (isFroxlorVersion('0.9.35')) { showUpdateStep("Updating from 0.9.35 to 0.9.35.1"); lastStepStatus(0); updateToVersion('0.9.35.1'); } if (isFroxlorVersion('0.9.35.1') && isDatabaseVersion('201603150')) { showUpdateStep("Adding new backup settings and cron"); $enable_backup = isset($_POST['enable_backup']) ? (int) $_POST['enable_backup'] : "0"; Settings::AddNew("system.backupenabled", $enable_backup); $stmt = Database::prepare("\n\t\tINSERT INTO `" . TABLE_PANEL_CRONRUNS . "` SET\n\t\t`module` = 'froxlor/backup',\n\t\t`cronfile` = 'backup',\n\t\t`interval` = '1 DAY',\n\t\t`desc_lng_key` = 'cron_backup',\n\t\t`lastrun` = 0,\n\t\t`isactive` = :isactive"); Database::pexecute($stmt, array('isactive' => $enable_backup)); lastStepStatus(0); updateToDbVersion('201604270'); } if (isFroxlorVersion('0.9.35.1')) { showUpdateStep("Updating from 0.9.35.1 to 0.9.36 final"); lastStepStatus(0); updateToVersion('0.9.36'); } if (isDatabaseVersion('201604270')) { showUpdateStep("Adding new dns related tables and settings"); $enable_dns = isset($_POST['enable_dns']) ? (int) $_POST['enable_dns'] : "0"; Settings::AddNew("system.dnsenabled", $enable_dns); Database::query("DROP TABLE IF EXISTS `domain_dns_entries`;"); $sql = "CREATE TABLE `domain_dns_entries` (\n\t\t`id` int(20) NOT NULL auto_increment,\n\t\t`domain_id` int(15) NOT NULL,\n\t\t`record` varchar(255) NOT NULL,\n\t\t`type` varchar(10) NOT NULL DEFAULT 'A',\n\t\t`content` text NOT NULL,\n\t\t`ttl` int(11) NOT NULL DEFAULT '18000',\n\t\t`prio` int(11) DEFAULT NULL,\n\t\tPRIMARY KEY (`id`)\n\t\t) DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;"; Database::query($sql); lastStepStatus(0); updateToDbVersion('201605090'); } if (isDatabaseVersion('201605090')) {