<?php
$access = new AccessData();
$user = new StudyPressUserWP();
$tableCat = StudyPressDB::getPrefix() . 'studi_category';
$tableCourse = StudyPressDB::getPrefix() . 'studi_course';
$tableSlides = StudyPressDB::getPrefix() . 'studi_slides';
$tableCategCourse = StudyPressDB::getPrefix() . 'studi_categ_cours';
if ($access->getVar("SHOW TABLES LIKE '{$tableCat}'") == $tableCat) {
if ($access->getVar("SHOW TABLES LIKE '{$tableCourse}'") == $tableCourse) {
$catWPId = wp_create_category('Temporary Category');
$managerCourse = new CourseManager();
$course = new Course(array('name' => 'Temporary Course', 'description' => '', 'authors' => array($user->id()), 'categories' => array($catWPId !== 0 ? $catWPId : 1)));
$courseId = $managerCourse->add($course);
$resultLesson = $access->getResults("SELECT * FROM {$tableCourse}");
$authors = array();
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'])));
}
