die(show_error1() . ' Show Error 1');
} else {
unlink($dummyFile);
}
fclose($fpt);
$date_time = date("m-d-Y");
$Export_FileName = $mysql_database . '_' . $date_time . '.sql';
$myFile = "UpgradeInc.sql";
executeSQL($myFile);
exec("mysqldump -n -t -c --skip-add-locks --skip-disable-keys --skip-triggers --user {$dbUser} --password='******' {$mysql_database} > {$Export_FileName}");
$res_student_field = 'SHOW COLUMNS FROM ' . table_to_upper('students', $version) . ' WHERE FIELD LIKE "CUSTOM_%"';
$objCustomStudents = new custom($mysql_database);
$objCustomStudents->set($res_student_field, 'students');
$res_staff_field = 'SHOW COLUMNS FROM ' . table_to_upper('staff', $version) . ' WHERE FIELD LIKE "CUSTOM_%"';
$objCustomStaff = new custom($mysql_database);
$objCustomStaff->set($res_staff_field, 'staff');
mysql_query("drop database {$mysql_database}");
mysql_query("CREATE DATABASE {$mysql_database} CHARACTER SET utf8 COLLATE utf8_general_ci");
mysql_select_db($mysql_database);
$myFile = "OpensisSchemaMysqlInc.sql";
executeSQL($myFile);
//execute custome field for student
foreach ($objCustomStudents->customQueryString as $query) {
mysql_query($query);
}
//execute custome field for satff
foreach ($objCustomStaff->customQueryString as $query) {
mysql_query($query);
}
$myFile = "OpensisProcsMysqlInc.sql";
executeSQL($myFile);
$dbconn = mysql_connect($_SESSION['server'], $_SESSION['username'], $_SESSION['password']) or die;
mysql_select_db($mysql_database);
$proceed = mysql_query("SELECT name\r\nFROM APP\r\nWHERE value LIKE '4.6%' OR value LIKE '4.7%'");
$proceed = mysql_fetch_assoc($proceed);
if ($proceed['name']) {
$date_time = date("m-d-Y");
$Export_FileName = $mysql_database . '_' . $date_time . '.sql';
$myFile = "upgrade.sql";
executeSQL($myFile);
backup_db($mysql_database, $Export_FileName);
$res_student_field = 'SHOW COLUMNS FROM STUDENTS WHERE FIELD LIKE "CUSTOM_%"';
$objCustomStudents = new custom($mysql_database);
$objCustomStudents->set($res_student_field, 'STUDENTS');
$res_staff_field = 'SHOW COLUMNS FROM STAFF WHERE FIELD LIKE "CUSTOM_%"';
$objCustomStaff = new custom($mysql_database);
$objCustomStaff->set($res_staff_field, 'STAFF');
mysql_query("drop database {$mysql_database}");
mysql_query("create database {$mysql_database}");
mysql_select_db($mysql_database);
#$myFile = "opensis-4.5-schema-mysql.sql";
#$myFile = "opensis-4.7-schema-mysql.sql";
$myFile = "opensis-4.8-schema-mysql.sql";
executeSQL($myFile);
//execute custome field for student
foreach ($objCustomStudents->customQueryString as $query) {
mysql_query($query);
}
//execute custome field for satff
foreach ($objCustomStaff->customQueryString as $query) {
mysql_query($query);
}
