<?php $access = new AccessData(); $access->query("ALTER TABLE " . StudyPressDB::getTableNameCourse() . " ADD " . StudyPressDB::COL_PICTURE_COURSE . " VARCHAR(255)"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameActivity() . " ADD " . StudyPressDB::COL_ORDER_ACTIVITY . " INT NOT NULL"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameActivity() . " CHANGE notes " . StudyPressDB::COL_TAGS_ACTIVITY . " longtext"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameVisite() . " CHANGE lesson_id " . StudyPressDB::COL_ID_ACTIVITY_VISITE . " BIGINT UNSIGNED"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameVisite() . " CHANGE user_visite " . StudyPressDB::COL_ID_USER_VISITE . " BIGINT UNSIGNED"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameQuestions() . " CHANGE col " . StudyPressDB::COL_TYPE_QUESTION . " VARCHAR(25)"); $access->query("UPDATE " . StudyPressDB::getTableNameQuestions() . " SET " . StudyPressDB::COL_TYPE_QUESTION . " = 'multiple'"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameActivity() . " CHANGE picture_url " . StudyPressDB::COL_PICTURE_ACTIVITY . " text"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameActivity() . " CHANGE activity_id " . StudyPressDB::COL_ID_ACTIVITY . " BIGINT UNSIGNED AUTO_INCREMENT"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameSlide() . " CHANGE slide_id " . StudyPressDB::COL_ID_SLIDE . " BIGINT UNSIGNED AUTO_INCREMENT"); $access->query("ALTER TABLE " . StudyPressDB::getTableName_CourseUsers() . " CHANGE ID " . StudyPressDB::COL_ID_USERS_USERS_N_COURSE . " BIGINT UNSIGNED"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameVisite() . " CHANGE visite_id " . StudyPressDB::COL_ID_VISITE . " BIGINT UNSIGNED AUTO_INCREMENT"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameDomain() . " CHANGE domain_id " . StudyPressDB::COL_ID_DOMAIN . " BIGINT UNSIGNED AUTO_INCREMENT"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameRateQuality() . " CHANGE ID " . StudyPressDB::COL_ID_USER_RATE_QUALITY . " BIGINT UNSIGNED"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameRateQuality() . " CHANGE rate_id " . StudyPressDB::COL_ID_RATE_QUALITY . " BIGINT UNSIGNED AUTO_INCREMENT"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameRateDomain() . " CHANGE ID " . StudyPressDB::COL_ID_USER_RATE_DOMAIN . " BIGINT UNSIGNED"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameRateDomain() . " CHANGE rate_domain_id " . StudyPressDB::COL_ID_RATE_DOMAIN . " BIGINT UNSIGNED AUTO_INCREMENT"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameQuestions() . " CHANGE question_id " . StudyPressDB::COL_ID_QUESTION . " BIGINT UNSIGNED AUTO_INCREMENT"); $access->query("ALTER TABLE " . StudyPressDB::getTableNamePropositions() . " CHANGE proposition_id " . StudyPressDB::COL_ID_PROPOSITION . " BIGINT UNSIGNED AUTO_INCREMENT"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameResultQuiz() . " CHANGE ID " . StudyPressDB::COL_ID_USER_RESULT . " BIGINT UNSIGNED"); $access->query("ALTER TABLE " . StudyPressDB::getTableNameResultQuiz() . " CHANGE result_id " . StudyPressDB::COL_ID_RESULT . " BIGINT UNSIGNED AUTO_INCREMENT"); $manager = new CourseManager(); $courses = $manager->getAll(); foreach ($courses as $course) { $manager->update($course->getId(), $course); }
foreach ($resultLesson as $lesson) { $managerLesson = new LessonManager(); if ($a = get_user_by('login', $lesson['author'])) { $authors[] = $a->ID; } $lessonId = $managerLesson->add(new Lesson(array('name' => $lesson['nom'] != "" ? $lesson['nom'] : "Course", 'author' => $a ? $a->display_name : $user->displayName(), 'authorId' => $a ? $a->ID : $user->id(), 'description' => $lesson['cours_des'], 'duration' => $lesson['duration'], 'courseId' => $courseId))); if (!in_array($user->id(), $authors)) { $authors[] = $user->id(); } if ($access->getVar("SHOW TABLES LIKE '{$tableSlides}'") == $tableSlides) { $slidesResult = $access->getResults("SELECT * FROM {$tableSlides} WHERE course_id = '" . $lesson['course_id'] . "'"); $managerSlide = new SlideManager(); foreach ($slidesResult as $slide) { $managerSlide->add(new Slide(array('courseId' => $lessonId, 'name' => $slide['slides_name'] != "" ? $slide['slides_name'] : "Slide", 'content' => $slide['slides_content'], 'order' => $slide['slides_order']))); } } } $course->setAuthors($authors); $managerCourse->update($courseId, $course); add_action('admin_init', 'sp_notice_warning_migrate'); function sp_notice_warning_migrate() { $sp_user = new StudyPressUserWP(); add_user_meta($sp_user->id(), 'sp_menu_add_warning_migrate', true, true); } } } $access->query("DROP TABLE IF EXISTS {$tableSlides}"); $access->query("DROP TABLE IF EXISTS {$tableCategCourse} "); $access->query("DROP TABLE IF EXISTS {$tableCat} "); $access->query("DROP TABLE IF EXISTS {$tableCourse} ");
static function transaction_7($data, $web_service_details) { $uidCursoId = $data['item_id']; $course_code = self::get_real_course_code($uidCursoId); if (!empty($course_code)) { $course_info = api_get_course_info($course_code, true); $data_to_update = Migration::soap_call($web_service_details, 'cursoDetalles', array('intIdSede' => $data['branch_id'], 'uididcurso' => $uidCursoId)); if ($data_to_update['error'] == false) { //do some cleaning $data_to_update['code'] = $course_info['code']; unset($data_to_update['error']); CourseManager::update($data_to_update); $course_info_after = api_get_course_info($course_code, true); return array('entity' => 'course', 'before' => $course_info, 'after' => $course_info_after, 'message' => "Course with code: {$course_code} was updated with this data: " . print_r($data_to_update, 1), 'status_id' => self::TRANSACTION_STATUS_SUCCESSFUL); } else { return $data_to_update; } } else { return array('message' => "couCoursese_code does not exists {$course_code} ", 'status_id' => self::TRANSACTION_STATUS_FAILED); } }
}); </script>'; $form->addElement('style_submit_button', 'button', get_lang('ModifyCourseInfo'), 'onclick="valide()"; class="save"'); // Set some default values //$course['disk_quota'] = round($course['disk_quota']/1024/1024, 1); $course['disk_quota'] = round(DocumentManager::get_course_quota($course_code) / 1024 / 1024, 1); $course['title'] = api_html_entity_decode($course['title'], ENT_QUOTES, $charset); $course['real_code'] = $course['code']; $form->setDefaults($course); // Validate form if ($form->validate()) { $course = $form->getSubmitValues(); $visual_code = CourseManager::generate_course_code($course['visual_code']); // make sure to rebase the disk quota (shown in MB but stored in bytes) $course['disk_quota'] = $course['disk_quota'] * 1024 * 1024; CourseManager::update($course); // Check if the visual code is already used by *another* course $visual_code_is_used = false; $warn = get_lang('TheFollowingCoursesAlreadyUseThisVisualCode') . ':'; if (!empty($visual_code)) { $list = CourseManager::get_courses_info_from_visual_code($visual_code); foreach ($list as $course_temp) { if ($course_temp['code'] != $course_code) { $visual_code_is_used = true; $warn .= ' ' . $course_temp['title'] . ' (' . $course_temp['code'] . '),'; } } $warn = substr($warn, 0, -1); } if ($visual_code_is_used) { header('Location: course_list.php?action=show_msg&warn=' . urlencode($warn));