if (!$updater_utils->does_column_exist('modules', 'map_level')) {
$updater_utils->execute_query("ALTER TABLE modules ADD COLUMN map_level smallint(2) NOT NULL DEFAULT 0", true);
}
if (!$updater_utils->does_column_exist('relationships', 'map_level')) {
$updater_utils->execute_query("ALTER TABLE relationships ADD COLUMN map_level smallint(2) NOT NULL DEFAULT 0", true);
}
// 03/06/2013 - nazrji - Add VLE APIs to config file.
if ($configObject->get('cfg_company') == 'University of Nottingham') {
$new_lines = array("\n// Objectives mapping\n", "\$vle_apis = array('UoNCM' => '', 'NLE' => '');\n");
} else {
$new_lines = array("\n// Objectives mapping\n", "\$vle_apis = array();\n");
}
$target_line = '$cfg_password_expire';
$updater_utils->add_line($string, '$vle_apis', $new_lines, 80, $cfg_web_root, $target_line, 1);
// 24/06/2013 - nazrji - add new calculation question type to enum
if (!$updater_utils->does_column_type_value_exist('questions', 'q_type', "enum('blank','calculation','dichotomous','flash','hotspot','labelling','likert','matrix','mcq','mrq','rank','textbox','info','extmatch','random','sct','keyword_based','true_false','area','enhancedcalc')")) {
$updater_utils->execute_query("ALTER TABLE questions CHANGE q_type q_type enum('blank','calculation','dichotomous','flash','hotspot','labelling','likert','matrix','mcq','mrq','rank','textbox','info','extmatch','random','sct','keyword_based','true_false','area','enhancedcalc') DEFAULT NULL", true);
}
// 25/06/2013 (brzsw) - add adjmark field to log tables.
if (!$updater_utils->does_column_exist('log0', 'adjmark')) {
$updater_utils->execute_query("ALTER TABLE log0 ADD COLUMN adjmark float AFTER mark", true);
$updater_utils->execute_query("UPDATE log0 SET adjmark = mark", false);
}
if (!$updater_utils->does_column_exist('log0_deleted', 'adjmark')) {
$updater_utils->execute_query("ALTER TABLE log0_deleted ADD COLUMN adjmark float AFTER mark", true);
$updater_utils->execute_query("UPDATE log0_deleted SET adjmark = mark", false);
}
if (!$updater_utils->does_column_exist('log1', 'adjmark')) {
$updater_utils->execute_query("ALTER TABLE log1 ADD COLUMN adjmark float AFTER mark", true);
$updater_utils->execute_query("UPDATE log1 SET adjmark = mark", false);
}
while ($result2->fetch()) {
$hash = $property_id . $created . $paper_ownerID;
$updater_utils->execute_query("UPDATE properties SET crypt_name='{$hash}' WHERE property_id={$property_id}", false);
}
$result2->free_result();
$result2->close();
}
$mysqli->commit();
// 18/10/2011 - Add type to feedback_release.
if (!$updater_utils->does_column_exist('feedback_release', 'type')) {
$updater_utils->execute_query("ALTER TABLE feedback_release ADD COLUMN type enum('objectives','questions')", true);
$updater_utils->execute_query("UPDATE feedback_release SET type='objectives'", false);
}
$mysqli->commit();
// 24/10/2011
if (!$updater_utils->does_column_type_value_exist('log4_overall', 'year', 'tinyint(4)')) {
$updater_utils->execute_query("ALTER TABLE log4_overall ADD COLUMN yearofstudy tinyint", true);
$convert_years = array('year1' => 1, 'year2' => 2, 'year3' => 3, 'year4' => 4, 'year5' => 5, 'year6' => 6, 'cp1' => 3, 'cp2' => 4, 'cp3' => 5, 'f1' => 5, 'graduate' => 6);
foreach ($convert_years as $old_year => $new_year) {
$updater_utils->execute_query("UPDATE log4_overall SET yearofstudy={$new_year} WHERE year='{$old_year}'", false);
}
$mysqli->commit();
$updater_utils->execute_query("ALTER TABLE log4_overall DROP COLUMN year", true);
$updater_utils->execute_query("ALTER TABLE log4_overall CHANGE COLUMN yearofstudy year tinyint(4)", true);
}
// 27/10/2011
if (!$updater_utils->does_column_type_value_exist('users', 'title', 'varchar(30)')) {
$updater_utils->execute_query("ALTER TABLE users CHANGE COLUMN title title varchar(30)", true);
}
if (floatval($old_version) < 4.2) {
// 18/10/2011 - Add type to feedback_release.
