public function process() { global $wpdb; if ($_SERVER['REQUEST_METHOD'] == "POST" && isset($_POST['ManualDb'])) { wpsqt_main_install(); update_option('wpsqt_manual', '1'); } if ($_SERVER['REQUEST_METHOD'] == "POST" && isset($_POST['ResetSession'])) { $_SESSION['wpsqt'] = array(); echo '<pre>'; var_dump($_SESSION); echo '</pre>'; } if ($_SERVER['REQUEST_METHOD'] == "POST" && isset($_POST['AllUpgrades'])) { print "<h3>Running all upgrades</h3>" . PHP_EOL; require_once WPSQT_DIR . 'lib/Wpsqt/Upgrade.php'; $objUpgrade = new Wpsqt_Upgrade(); $objUpgrade->getUpdate(0); $objUpgrade->execute(); $needUpdate = 1; $oldVersion = '2.4.3'; require_once WPSQT_DIR . 'lib/Wpsqt/Page/Maintenance/upgradeScript.php'; echo '<p>You are up to date.</p>'; exit; } $this->_pageView = "admin/maintenance/debug.php"; }
<?php /** * Handles the upgrading of the plugin. * * @author Iain Cambridge * @copyright Fubra Limited 2010-2011, all rights reserved. * @license http://www.gnu.org/licenses/gpl.html GPL v3 * @package WPSQT */ if ($needUpdate == '1') { if (version_compare($oldVersion, '2.1') <= 0) { $objUpgrade = new Wpsqt_Upgrade(); $objUpgrade->getUpdate(0); $objUpgrade->execute(); } switch ($oldVersion) { case '2.4.3': echo '<h4>Updating to 2.5</h4>'; $wpdb->query("ALTER TABLE `" . WPSQT_TABLE_RESULTS . "` ADD `pass` BOOLEAN NOT NULL"); echo '<p>Added the `pass` column</p>'; case '2.5': echo '<h4>Updating to 2.5.1</h4>'; $wpdb->query("ALTER TABLE `" . WPSQT_TABLE_QUIZ_SURVEYS . "` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"); $wpdb->query("ALTER TABLE `" . WPSQT_TABLE_SECTIONS . "` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"); $wpdb->query("ALTER TABLE `" . WPSQT_TABLE_QUESTIONS . "` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"); $wpdb->query("ALTER TABLE `" . WPSQT_TABLE_FORMS . "` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"); $wpdb->query("ALTER TABLE `" . WPSQT_TABLE_RESULTS . "` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"); $wpdb->query("ALTER TABLE `" . WPSQT_TABLE_SURVEY_CACHE . "` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"); $wpdb->query("ALTER TABLE `" . WPSQT_TABLE_QUIZ_SURVEYS . "` CHANGE `name` `name` VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL"); echo '<p>Updated all columns to use UTF8</p>';