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); }