echo nl2br($e->getTraceAsString()); exit; } } $ext = ''; while ($mysqli->more_results()) { $mysqli->next_result(); if ($mysqli->insert_id > 0) { $ext = $ext . ' ' . $mysqli->insert_id; } } echo "<li>LOADED student_help: " . $ext . "</li>\n"; } $mysqli->commit(); // 01/05/2013 if (!$updater_utils->does_column_exist('users', 'password_expire')) { $updater_utils->execute_query("ALTER TABLE users ADD COLUMN password_expire int(11) unsigned", true); } // 02/05/2013 - Add password expire config file. $new_lines = array("\$cfg_password_expire = 30; // Set in days\n"); $target_line = '$authentication = array'; $updater_utils->add_line($string, '$percent_decimals', $new_lines, 80, $cfg_web_root, $target_line, 7); // 09/05/2013 (brzsw) - Remove $protocol and insert $cfg_secure_connection $lines = array(); $cfg = file($cfg_web_root . 'config/config.inc.php'); $found = false; foreach ($cfg as $line) { if (strpos($line, '$protocol = ') !== false) { $lines[] = "\$cfg_secure_connection = true; // If true site must be accessed via HTTPS\n"; $found = true; } else {
$cfg_db_username = $configObject->get('cfg_db_username'); $cfg_db_external_user = $configObject->get('cfg_db_external_user'); $cfg_db_inv_username = $configObject->get('cfg_db_inv_user'); $cfg_use_ldap = $configObject->get('cfg_use_ldap'); $mysqli->autocommit(false); error_reporting(-1); ob_start(); echo "<div>Starting at " . date("H:i:s") . "</div>"; echo "\n<blockquote>\n<h1>" . $string['startingupdate'] . "</h1>\n<ol>"; // 15/06/2011 // Add index to improve performance for standards setting index page if (!$updater_utils->does_index_exist('ebel', 'SETTER_AND_DATE')) { $updater_utils->execute_query("ALTER TABLE ebel ADD INDEX SETTER_AND_DATE (setterID, date_set)", true); } // 16/06/2011 if ($updater_utils->does_column_exist('log_late', 'year')) { $updater_utils->execute_query("ALTER TABLE log_late DROP COLUMN year", true); $updater_utils->execute_query("ALTER TABLE log_late DROP COLUMN student_grade", true); $updater_utils->execute_query("ALTER TABLE log_late DROP COLUMN ipaddress", true); } // 16/06/2011 if (!$updater_utils->does_column_exist('sys_errors', 'fixed')) { $updater_utils->execute_query("ALTER TABLE sys_errors ADD COLUMN fixed datetime", true); $updater_utils->execute_query("ALTER TABLE sys_errors ADD COLUMN php_self text", true); $updater_utils->execute_query("ALTER TABLE sys_errors ADD COLUMN query_string text", true); $updater_utils->execute_query("ALTER TABLE sys_errors ADD COLUMN request_method enum('GET', 'HEAD', 'POST', 'PUT', 'DELETE')", true); } $mysqli->commit(); // Get a list of reviews where group = 'Yes' $group_reviews = $mysqli->prepare("SELECT DISTINCT paperID FROM standards_setting WHERE group_review = 'Yes' AND paperID > 0"); $group_reviews->execute();