$cfg_db_inv_username = $configObject->get('cfg_db_inv_user'); $cfg_use_ldap = $configObject->get('cfg_use_ldap'); $cfg_web_host = $configObject->get('cfg_web_host'); if ($cfg_web_host == '') { $cfg_web_host = $cfg_db_host; } error_reporting(-1); ob_start(); echo "\n<blockquote>\n<h1>" . $string['startingupdate'] . "</h1>"; echo "<div>Starting at " . date("H:i:s") . "</div>\n<ol>"; ob_flush(); flush(); $mysqli->autocommit(false); // 01/05/2013 - Update the online help files. if (isset($_POST['update_staff_help'])) { $updater_utils->execute_query("TRUNCATE staff_help", true); $file = file_get_contents('../install/staff_help.sql'); $mysqli->multi_query($file); if ($mysqli->error) { try { throw new Exception("MySQL error {$mysqli->error} <br /> Query:<br /> ", $mysqli->errno); } catch (Exception $e) { echo "Error No: " . $e->getCode() . " - " . $e->getMessage() . "<br />"; echo nl2br($e->getTraceAsString()); exit; } } $ext = ''; while ($mysqli->more_results()) { $mysqli->next_result(); if ($mysqli->insert_id > 0) {
$cfg_db_student_user = $configObject->get('cfg_db_student_user'); $cfg_db_staff_user = $configObject->get('cfg_db_staff_user'); $cfg_db_host = $configObject->get('cfg_db_host'); $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();