'.get_lang('Error').' ! Chamilo '.get_lang('HasNotBeenFound').'.

'.get_lang('PleasGoBackToStep1').'.

'; exit(); } $_configuration['db_glue'] = get_config_param('dbGlu'); if ($singleDbForm) { $_configuration['table_prefix'] = get_config_param('courseTablePrefix'); $_configuration['main_database'] = get_config_param('mainDbName'); $_configuration['db_prefix'] = get_config_param('dbNamePrefix'); } $dbScormForm = preg_replace('/[^a-zA-Z0-9_\-]/', '', $dbScormForm); if (!empty($dbPrefixForm) && strpos($dbScormForm, $dbPrefixForm) !== 0) { $dbScormForm = $dbPrefixForm.$dbScormForm; } if (empty($dbScormForm) || $dbScormForm == 'mysql' || $dbScormForm == $dbPrefixForm) { $dbScormForm = $dbPrefixForm.'scorm'; } /* Normal upgrade procedure: start by updating main, statistic, user databases */ // If this script has been included by index.php, not update_courses.php, so // that we want to change the main databases as well... $only_test = false; if (defined('SYSTEM_INSTALLATION')) { if ($singleDbForm) { $dbStatsForm = $dbNameForm; $dbScormForm = $dbNameForm; $dbUserForm = $dbNameForm; } /** * Update the databases "pre" migration */ include '../lang/english/create_course.inc.php'; if ($languageForm != 'english') { // languageForm has been escaped in index.php include '../lang/'.$languageForm.'/create_course.inc.php'; } // Get the main queries list (m_q_list) $m_q_list = get_sql_file_contents($new_file_version.'/migrate-db-'.$old_file_version.'-'.$new_file_version.'-pre.sql', 'main'); if (count($m_q_list) > 0) { // Now use the $m_q_list /** * We connect to the right DB first to make sure we can use the queries * without a database name */ if (strlen($dbNameForm) > 40) { $app['monolog']->addError('Database name '.$dbNameForm.' is too long, skipping'); } elseif (!in_array($dbNameForm, $dblist)) { $app['monolog']->addError('Database '.$dbNameForm.' was not found, skipping'); } else { iDatabase::select_db($dbNameForm); foreach ($m_q_list as $query) { if ($only_test) { $app['monolog']->addInfo("iDatabase::query($dbNameForm,$query)"); } else { $res = iDatabase::query($query); if ($res === false) { $app['monolog']->addError('Error in '.$query.': '.iDatabase::error()); } } } } } if (INSTALL_TYPE_UPDATE == 'update') { $session_table = "$dbNameForm.session"; $session_rel_course_table = "$dbNameForm.session_rel_course"; $session_rel_course_rel_user_table = "$dbNameForm.session_rel_course_rel_user"; $course_table = "$dbNameForm.course"; //Fixes new changes in sessions $sql = "SELECT id, date_start, date_end, nb_days_access_before_beginning, nb_days_access_after_end FROM $session_table "; $result = iDatabase::query($sql); while ($session = Database::fetch_array($result)) { $session_id = $session['id']; //Fixing date_start if (isset($session['date_start']) && !empty($session['date_start']) && $session['date_start'] != '0000-00-00') { $datetime = $session['date_start'].' 00:00:00'; $update_sql = "UPDATE $session_table SET display_start_date = '$datetime' , access_start_date = '$datetime' WHERE id = $session_id"; iDatabase::query($update_sql); //Fixing nb_days_access_before_beginning if (!empty($session['nb_days_access_before_beginning'])) { $datetime = api_strtotime($datetime, 'UTC') - (86400 * $session['nb_days_access_before_beginning']); $datetime = api_get_utc_datetime($datetime); $update_sql = "UPDATE $session_table SET coach_access_start_date = '$datetime' WHERE id = $session_id"; iDatabase::query($update_sql); } } //Fixing end_date if (isset($session['date_end']) && !empty($session['date_end']) && $session['date_end'] != '0000-00-00') { $datetime = $session['date_end'].' 00:00:00'; $update_sql = "UPDATE $session_table SET display_end_date = '$datetime', access_end_date = '$datetime' WHERE id = $session_id"; iDatabase::query($update_sql); //Fixing nb_days_access_before_beginning if (!empty($session['nb_days_access_after_end'])) { $datetime = api_strtotime($datetime, 'UTC') + (86400 * $session['nb_days_access_after_end']); $datetime = api_get_utc_datetime($datetime); $update_sql = "UPDATE $session_table SET coach_access_end_date = '$datetime' WHERE id = $session_id"; iDatabase::query($update_sql); } } } //Fixes new changes session_rel_course $sql = "SELECT id_session, sc.course_code, c.id FROM $course_table c INNER JOIN $session_rel_course_table sc ON sc.course_code = c.code"; $result = iDatabase::query($sql); while ($row = Database::fetch_array($result)) { $sql = "UPDATE $session_rel_course_table SET course_id = {$row['id']} WHERE course_code = '{$row['course_code']}' AND id_session = {$row['id_session']} "; iDatabase::query($sql); } //Fixes new changes in session_rel_course_rel_user $sql = "SELECT id_session, sc.course_code, c.id FROM $course_table c INNER JOIN $session_rel_course_rel_user_table sc ON sc.course_code = c.code"; $result = iDatabase::query($sql); while ($row = Database::fetch_array($result)) { $sql = "UPDATE $session_rel_course_rel_user_table SET course_id = {$row['id']} WHERE course_code = '{$row['course_code']}' AND id_session = {$row['id_session']} "; iDatabase::query($sql); } //Updating c_quiz_order $teq = "$dbNameForm.c_quiz"; $seq = "SELECT c_id, session_id, id FROM $teq ORDER BY c_id, session_id, id"; $req = iDatabase::query($seq); $to = "$dbNameForm.c_quiz_order"; $do = "DELETE FROM $to"; Database::query($do); $cid = 0; $temp_session_id = 0; $order = 1; while ($row = Database::fetch_assoc($req)) { if ($row['c_id'] != $cid) { $cid = $row['c_id']; $temp_session_id = $row['session_id']; $order = 1; } elseif ($row['session_id'] != $temp_session_id) { $temp_session_id = $row['session_id']; $order = 1; } $ins = "INSERT INTO $to (c_id, session_id, exercise_id, exercise_order)". " VALUES ($cid, $temp_session_id, {$row['id']}, $order)"; $rins = iDatabase::query($ins); $order++; } $sql = "SELECT id FROM $dbNameForm.course_field WHERE field_variable = 'special_course'"; $result = Database::query($sql); $fieldData = Database::fetch_array($result, 'ASSOC'); $id = $fieldData['id']; $sql = "INSERT INTO $dbNameForm.course_field_options (field_id, option_value, option_display_text, option_order) VALUES ('$id', '1', '".get_lang('Yes')."', '1')"; $result = Database::query($sql); $sql = "INSERT INTO $dbNameForm.course_field_options (field_id, option_value, option_display_text, option_order) VALUES ('$id', '0', '".get_lang('No')."', '2')"; Database::query($sql); } } }