error_log("In $dbUserForm, executed: $query", 0); } else { $res = Database::query($query); } } } } // The SCORM database doesn't need a change in the pre-migrate part - ignore } $prefix = ''; if ($singleDbForm) { $prefix = $_configuration['table_prefix']; } // Get the courses databases queries list (c_q_list) $c_q_list = get_sql_file_contents('migrate-db-1.8.0-1.8.2-pre.sql', 'course'); if (count($c_q_list) > 0) { // Get the courses list if (strlen($dbNameForm) > 40) { error_log('Database name ' . $dbNameForm . ' is too long, skipping', 0); } elseif (!in_array($dbNameForm, $dblist)) { error_log('Database ' . $dbNameForm . ' was not found, skipping', 0); } else { Database::select_db($dbNameForm); $res = Database::query("SELECT code,db_name,directory,course_language FROM course WHERE target_course_code IS NULL"); if ($res === false) { die('Error while querying the courses list in update_db-1.8.0-1.8.2.inc.php'); } if (Database::num_rows($res) > 0) { $i = 0; $list = array();
} else { $res = iDatabase::query($query); } } } } // The SCORM database doesn't need a change in the pre-migrate part - ignore } $prefix = ''; if ($singleDbForm) { $prefix = get_config_param ('table_prefix'); } // Get the courses databases queries list (c_q_list) $c_q_list = get_sql_file_contents('migrate-db-'.$old_file_version.'-'.$new_file_version.'-pre.sql', 'course'); if (count($c_q_list) > 0) { // Get the courses list if (strlen($dbNameForm) > 40) { Log::error('Database name '.$dbNameForm.' is too long, skipping'); } elseif (!in_array($dbNameForm, $dblist)) { Log::error('Database '.$dbNameForm.' was not found, skipping'); } else { iDatabase::select_db($dbNameForm); $res = iDatabase::query("SELECT code,db_name,directory,course_language FROM course WHERE target_course_code IS NULL ORDER BY code"); if ($res === false) { die('Error while querying the courses list in update_db-1.8.6-1.8.6.1.inc.php'); } if (iDatabase::num_rows($res) > 0) { $i = 0;
if ($only_test) { error_log("Database::query($dbUserForm,$query)", 0); } else { $res = Database::query($query); if ($log) { error_log("In $dbUserForm, executed: $query", 0); } } } } } // The SCORM database should need a drop in the post-migrate part. However, we will keep these tables a bit more, just in case... } // Get the courses databases queries list (c_q_list) $c_q_list = get_sql_file_contents('migrate-db-1.6.x-1.8.0-post.sql', 'course'); if (count($c_q_list) > 0) { // Get the courses list if (strlen($dbNameForm) > 40) { error_log('Database name ' . $dbNameForm . ' is too long, skipping', 0); } elseif (!in_array($dbNameForm, $dblist)) { error_log('Database ' . $dbNameForm . ' was not found, skipping', 0); } else { Database::select_db($dbNameForm); $res = Database::query("SELECT code,db_name,directory,course_language FROM course WHERE target_course_code IS NULL"); if ($res === false) { die('Error while querying the courses list in update_db-1.6.x-1.8.0.inc.php'); } if (Database::num_rows($res) > 0) { $i = 0; while ($row = Database::fetch_array($res)) {