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>';
