// along with Rogō. If not, see <http://www.gnu.org/licenses/>. /** * * @author Simon Wilkinson * @version 1.0 * @copyright Copyright (c) 2014 The University of Nottingham * @package */ require '../include/sysadmin_auth.inc'; require_once '../classes/schoolutils.class.php'; $school = ''; $faculty = ''; if (isset($_POST['submit'])) { $school = trim($_POST['school']); $faculty = trim($_POST['facultyID']); if (SchoolUtils::school_exists_in_faculty($faculty, $school, $mysqli)) { $error = 'duplicate'; } else { $insert_id = SchoolUtils::add_school($faculty, $school, $mysqli); header("location: list_schools.php"); exit; } } $faculties = 0; $faculty_list = array(); $result = $mysqli->prepare("SELECT id, name FROM faculty WHERE deleted IS NULL ORDER BY name"); $result->execute(); $result->bind_result($facultyID, $name); while ($result->fetch()) { $faculty_list[] = array($facultyID, $name); $faculties++;
$result->bind_param('i', $schoolid); $result->execute(); $result->store_result(); $result->bind_result($school, $curr_faculty); $result->fetch(); if ($result->num_rows == 0) { $result->close(); $msg = sprintf($string['furtherassistance'], $configObject->get('support_email'), $configObject->get('support_email')); $notice->display_notice_and_exit($mysqli, $string['pagenotfound'], $msg, $string['pagenotfound'], '../artwork/page_not_found.png', '#C00000', true, true); } $result->close(); if (isset($_POST['submit'])) { $school_tmp = trim($_POST['school']); $faculty = trim($_POST['faculty']); $changed = ($curr_faculty != $faculty or $school != $school_tmp); if ($changed and SchoolUtils::school_exists_in_faculty($faculty, $school_tmp, $mysqli)) { $error = 'duplicate'; $school = $school_tmp; $curr_faculty = $faculty; } else { if ($changed) { $result = $mysqli->prepare("UPDATE schools SET facultyID = ?, school = ? WHERE id = ?"); $result->bind_param('isi', $faculty, $school_tmp, $schoolid); $result->execute(); $result->close(); $logger = new Logger($mysqli); if ($school != $school_tmp) { $logger->track_change('School', $schoolid, $userObject->get_user_ID(), $school, $school_tmp, $string['name']); } if ($curr_faculty != $faculty) { $logger->track_change('School', $schoolid, $userObject->get_user_ID(), $curr_faculty, $faculty, $string['faculty']);
/* ***** NOW UPDATE THE INSTALLER SCRIPT ***** */ $configObj = Config::get_instance(); $cfg_web_root = $configObj->get('cfg_web_root'); // 15/08/2012 - cczsa1 adding unknown school and faculty require_once $cfg_web_root . 'classes/facultyutils.class.php'; require_once $cfg_web_root . 'classes/schoolutils.class.php'; $facultystatus = FacultyUtils::facultyname_exists('UNKNOWN Faculty', $mysqli); if (!FacultyUtils::facultyname_exists('UNKNOWN Faculty', $mysqli)) { $facultyID = FacultyUtils::add_faculty('UNKNOWN Faculty', $mysqli); echo "<li>Adding Unknown Faculty</li>\n"; } else { $facultyID = FacultyUtils::facultyid_by_name('UNKNOWN Faculty', $mysqli); } if (!SchoolUtils::school_exists_in_faculty($facultyID, 'UNKNOWN School', $mysqli) and $facultyID !== false) { $schoolID = SchoolUtils::add_school($facultyID, 'UNKNOWN School', $mysqli); echo "<li>Adding Unknown School</li>\n"; } $result = $mysqli->prepare("SELECT id FROM " . $cfg_db_database . ".`schools` WHERE school='UNKNOWN School'"); $result->execute(); $result->store_result(); $result->bind_result($id1); $result->fetch(); $rows = $result->num_rows(); $result->free_result(); $result->close(); if ($rows == 0) { $schoolID = SchoolUtils::add_school($facultyID, 'UNKNOWN School', $mysqli); echo "<li>Adding Unknown School</li>\n"; }