function create_restored_course(&$tool_content, $restoreThis, $course_code, $course_lang, $course_title, $course_desc, $course_vis, $course_prof) {
global $webDir, $urlServer, $urlAppend, $langEnter, $langBack, $currentCourseCode;
require_once 'modules/create_course/functions.php';
require_once 'modules/course_info/restorehelper.class.php';
require_once 'include/lib/fileManageLib.inc.php';
$new_course_code = null;
$new_course_id = null;
Database::get()->transaction(function() use (&$new_course_code, &$new_course_id, $restoreThis, $course_code, $course_lang, $course_title, $course_desc, $course_vis, $course_prof, $webDir, &$tool_content, $urlServer, $urlAppend) {
$departments = array();
if (isset($_POST['department'])) {
foreach ($_POST['department'] as $did) {
$departments[] = intval($did);
}
} else {
$minDep = Database::get()->querySingle("SELECT MIN(id) AS min FROM hierarchy");
if ($minDep) {
$departments[0] = $minDep->min;
}
}
$r = $restoreThis . '/html';
list($new_course_code, $new_course_id) = create_course($course_code, $course_lang, $course_title, $course_desc, $departments, $course_vis, $course_prof);
if (!$new_course_code) {
$tool_content = "<div class='alert alert-warning'>" . $GLOBALS['langError'] . "</div>";
draw($tool_content, 3);
exit;
}
if (!file_exists($restoreThis)) {
redirect_to_home_page('modules/course_info/restore_course.php');
}
$config_data = unserialize(file_get_contents($restoreThis . '/config_vars'));
// If old $urlAppend didn't end in /, add it
if (substr($config_data['urlAppend'], -1) !== '/') {
$config_data['urlAppend'] .= '/';
}
$eclass_version = (isset($config_data['version'])) ? $config_data['version'] : null;
$backupData = null;
if (file_exists($restoreThis . '/backup.php')) {
$backupData = parse_backup_php($restoreThis . '/backup.php');
$eclass_version = $backupData['eclass_version'];
}
$restoreHelper = new RestoreHelper($eclass_version);
$course_file = $restoreThis . '/' . $restoreHelper->getFile('course');
if (file_exists($course_file)) {
$course_dataArr = unserialize(file_get_contents($course_file));
$course_data = $course_dataArr[0];
// update course query
$upd_course_sql = "UPDATE course SET keywords = ?s, doc_quota = ?f, video_quota = ?f, "
. " group_quota = ?f, dropbox_quota = ?f, glossary_expand = ?d ";
$upd_course_args = array(
$course_data[$restoreHelper->getField('course', 'keywords')],
floatval($course_data['doc_quota']),
floatval($course_data['video_quota']),
floatval($course_data['group_quota']),
floatval($course_data['dropbox_quota']),
intval($course_data[$restoreHelper->getField('course', 'glossary_expand')])
);
if (isset($course_data['home_layout']) and isset($course_data['course_image'])) {
$upd_course_sql .= ', home_layout = ?d, course_image = ?s ';
$upd_course_args[] = $course_data['home_layout'];
$upd_course_args[] = $course_data['course_image'];
}
// Set keywords to '' if NULL
if (!isset($upd_course_args[0])) {
$upd_course_args[0] = '';
}
// handle course weekly if exists
if (isset($course_data['view_type']) && isset($course_data['start_date']) && isset($course_data['finish_date'])) {
$upd_course_sql .= " , view_type = ?s, start_date = ?t, finish_date = ?t ";
array_push($upd_course_args,
$course_data['view_type'],
$course_data['start_date'],
$course_data['finish_date']
);
}
$upd_course_sql .= " WHERE id = ?d ";
array_push($upd_course_args, intval($new_course_id));
Database::get()->query($upd_course_sql, $upd_course_args);
}
$userid_map = array();
$user_file = $restoreThis . '/user';
if (file_exists($user_file)) {
$cours_user = unserialize(file_get_contents($restoreThis . '/' . $restoreHelper->getFile('course_user')));
$userid_map = restore_users(unserialize(file_get_contents($user_file)), $cours_user, $departments, $restoreHelper);
register_users($new_course_id, $userid_map, $cours_user, $restoreHelper);
}
$userid_map[0] = 0;
$userid_map[-1] = -1;
$coursedir = "${webDir}/courses/$new_course_code";
$videodir = "${webDir}/video/$new_course_code";
move_dir($r, $coursedir);
if (is_dir($restoreThis . '/video_files')) {
move_dir($restoreThis . '/video_files', $videodir);
}
course_index($new_course_code);
$tool_content .= "<div class='alert alert-info'>" . $GLOBALS['langCopyFiles'] . " $coursedir</div>";
require_once 'upgrade/functions.php';
load_global_messages();
$url_prefix_map = array(
$config_data['urlServer'] . 'modules/ebook/show.php/' . $course_data['code'] =>
$urlServer . 'modules/ebook/show.php/' . $new_course_code,
$config_data['urlAppend'] . 'modules/ebook/show.php/' . $course_data['code'] =>
$urlAppend . 'modules/ebook/show.php/' . $new_course_code,
$config_data['urlServer'] . 'modules/document/file.php/' . $course_data['code'] =>
$urlServer . 'modules/document/file.php/' . $new_course_code,
$config_data['urlAppend'] . 'modules/document/file.php/' . $course_data['code'] =>
$urlAppend . 'modules/document/file.php/' . $new_course_code,
$config_data['urlServer'] . 'courses/' . $course_data['code'] =>
$urlServer . 'courses/' . $new_course_code,
$config_data['urlAppend'] . 'courses/' . $course_data['code'] =>
$urlAppend . 'courses/' . $new_course_code,
$course_data['code'] =>
$new_course_code);
if ($restoreHelper->getBackupVersion() === RestoreHelper::STYLE_3X) {
restore_table($restoreThis, 'course_module', array('set' => array('course_id' => $new_course_id), 'delete' => array('id')), $url_prefix_map, $backupData, $restoreHelper);
} else if ($restoreHelper->getBackupVersion() === RestoreHelper::STYLE_2X) {
create_modules($new_course_id);
foreach (get_tabledata_from_parsed('accueil', $backupData, $restoreHelper) as $accueil) {
Database::get()->query('UPDATE course_module SET visible = ?d WHERE course_id = ?d AND module_id = ?d',
$accueil['visible'], $new_course_id, $accueil['id']);
}
}
restore_table($restoreThis, 'announcement', array('set' => array('course_id' => $new_course_id), 'delete' => array('id', 'preview')), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'group_properties', array('set' => array('course_id' => $new_course_id)), $url_prefix_map, $backupData, $restoreHelper);
$group_map = restore_table($restoreThis, 'group', array('set' => array('course_id' => $new_course_id), 'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'group_members', array('map' => array('group_id' => $group_map, 'user_id' => $userid_map)), $url_prefix_map, $backupData, $restoreHelper);
// Forums Restore
$forum_category_map = restore_table($restoreThis, 'forum_category', array('set' => array('course_id' => $new_course_id),
'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
$forum_category_map[0] = 0;
$forum_map = restore_table($restoreThis, 'forum', array('set' => array('course_id' => $new_course_id),
'return_mapping' => 'id', 'map' => array('cat_id' => $forum_category_map)), $url_prefix_map, $backupData, $restoreHelper);
$forum_map[0] = 0;
$forum_topic_map = restore_table($restoreThis, 'forum_topic', array('return_mapping' => 'id',
'map' => array('forum_id' => $forum_map, 'poster_id' => $userid_map)), $url_prefix_map, $backupData, $restoreHelper);
$forum_topic_map[0] = 0;
$forum_post_options = array('return_mapping' => 'id',
'map' => array('topic_id' => $forum_topic_map,
'poster_id' => $userid_map));
if ($restoreHelper->getBackupVersion() === RestoreHelper::STYLE_2X) {
$forum_post_options['set'] = array('post_text' => '');
}
$forum_post_map = restore_table($restoreThis, 'forum_post', $forum_post_options, $url_prefix_map, $backupData, $restoreHelper);
$forum_post_map[0] = 0;
restore_table($restoreThis, 'forum_notify', array('set' => array('course_id' => $new_course_id),
'map' => array('user_id' => $userid_map, 'cat_id' => $forum_category_map, 'forum_id' => $forum_map, 'topic_id' => $forum_topic_map),
'delete' => array('id')), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'forum_user_stats', array('set' => array('course_id' => $new_course_id),
'map' => array('user_id' => $userid_map)), $url_prefix_map, $backupData, $restoreHelper);
if ($restoreHelper->getBackupVersion() === RestoreHelper::STYLE_2X
&& isset($backupData) && is_array($backupData)
&& isset($backupData['query']) && is_array($backupData['query'])) {
$postsText = get_tabledata_from_parsed('posts_text', $backupData, $restoreHelper);
foreach ($postsText as $ptData) {
if (array_key_exists($ptData['post_id'], $forum_post_map)) {
Database::get()->query("UPDATE forum_post SET post_text = ?s WHERE id = ?d", $ptData['post_text'], intval($forum_post_map[$ptData['post_id']]));
}
}
}
$forumLastPosts = Database::get()->queryArray("SELECT DISTINCT last_post_id FROM forum WHERE course_id = ?d ", intval($new_course_id));
if (is_array($forumLastPosts) && count($forumLastPosts) > 0) {
foreach ($forumLastPosts as $lastPost) {
if (isset($forum_post_map[$lastPost->last_post_id])) {
Database::get()->query("UPDATE forum SET last_post_id = ?d WHERE course_id = ?d AND last_post_id = ?d", intval($forum_post_map[$lastPost->last_post_id]), intval($new_course_id), intval($lastPost->last_post_id));
}
}
}
$topicLastPosts = Database::get()->queryArray("SELECT DISTINCT last_post_id FROM forum_topic WHERE forum_id IN (SELECT id FROM forum WHERE course_id = ?d)", intval($new_course_id));
if (is_array($topicLastPosts) && count($topicLastPosts) > 0) {
foreach ($topicLastPosts as $lastPost) {
if (isset($forum_post_map[$lastPost->last_post_id])) {
Database::get()->query("UPDATE forum_topic SET last_post_id = ?d WHERE last_post_id = ?d", intval($forum_post_map[$lastPost->last_post_id]), intval($lastPost->last_post_id));
}
}
}
$parentPosts = Database::get()->queryArray("SELECT DISTINCT parent_post_id FROM forum_post WHERE topic_id IN (SELECT id FROM forum_topic WHERE forum_id IN (SELECT id FROM forum WHERE course_id = ?d))", intval($new_course_id));
if (is_array($parentPosts) && count($parentPosts) > 0) {
foreach ($parentPosts as $parentPost) {
if (isset($forum_post_map[$parentPost->parent_post_id])) {
Database::get()->query("UPDATE forum_post SET parent_post_id = ?d WHERE parent_post_id = ?d", intval($forum_post_map[$parentPost->parent_post_id]), intval($parentPost->parent_post_id));
}
}
}
// Forums Restore End
// Glossary Restore
$glossary_category_map = restore_table($restoreThis, 'glossary_category', array('set' => array('course_id' => $new_course_id),
'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
$glossary_category_map[0] = 0;
restore_table($restoreThis, 'glossary', array('set' => array('course_id' => $new_course_id),
'delete' => array('id'), 'map' => array('category_id' => $glossary_category_map)), $url_prefix_map, $backupData, $restoreHelper);
// Glossary Restore End
$link_category_map = restore_table($restoreThis, 'link_category', array('set' => array('course_id' => $new_course_id),
'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
$link_category_map[0] = 0;
$link_category_map[-1] = -1;
$link_category_map[-2] = -2;
$link_map = restore_table($restoreThis, 'link', array('set' => array('course_id' => $new_course_id),
'map' => array('category' => $link_category_map, 'user_id' => $userid_map), 'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
$ebook_map = restore_table($restoreThis, 'ebook', array('set' => array('course_id' => $new_course_id), 'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
foreach ($ebook_map as $old_id => $new_id) {
// new and old id might overlap as the map contains multiple values!
rename("$coursedir/ebook/$old_id", "$coursedir/ebook/__during_restore__$new_id");
}
foreach ($ebook_map as $old_id => $new_id) {
// better to use an intermediary rename step
rename("$coursedir/ebook/__during_restore__$new_id", "$coursedir/ebook/$new_id");
}
$document_map = restore_table($restoreThis, 'document', array('set' => array('course_id' => $new_course_id),
'map_function' => 'document_map_function',
'map_function_data' => array(1 => $group_map, 2 => $ebook_map),
'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
$ebook_section_map = restore_table($restoreThis, 'ebook_section', array('map' => array('ebook_id' => $ebook_map),
'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
$ebook_subsection_map = restore_table($restoreThis, 'ebook_subsection', array('map' => array('section_id' => $ebook_section_map,
'file_id' => $document_map), 'delete' => array('file'), 'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
// Video
$videocat_map = restore_table($restoreThis, 'video_category', array('set' => array('course_id' => $new_course_id), 'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
$videocat_map[''] = '';
$videocat_map[0] = 0;
$video_map = restore_table($restoreThis, 'video', array(
'map' => array('category' => $videocat_map),
'set' => array('course_id' => $new_course_id),
'return_mapping' => 'id'
), $url_prefix_map, $backupData, $restoreHelper);
$videolink_map = restore_table($restoreThis, 'videolink', array(
'map' => array('category' => $videocat_map),
'set' => array('course_id' => $new_course_id),
'return_mapping' => 'id'
), $url_prefix_map, $backupData, $restoreHelper);
// Dropbox
$dropbox_map = restore_table($restoreThis, 'dropbox_msg', array('set' => array('course_id' => $new_course_id),
'map' => array('author_id' => $userid_map), 'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'dropbox_attachment', array('map' => array('msg_id' => $dropbox_map), 'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'dropbox_index', array('map' => array('msg_id' => $dropbox_map, 'recipient_id' => $userid_map)), $url_prefix_map, $backupData, $restoreHelper);
// Learning Path
$lp_learnPath_map = restore_table($restoreThis, 'lp_learnPath', array('set' => array('course_id' => $new_course_id),
'return_mapping' => 'learnPath_id'), $url_prefix_map, $backupData, $restoreHelper);
$lp_module_map = restore_table($restoreThis, 'lp_module', array('set' => array('course_id' => $new_course_id),
'return_mapping' => 'module_id'), $url_prefix_map, $backupData, $restoreHelper);
$lp_asset_map = restore_table($restoreThis, 'lp_asset', array('map' => array('module_id' => $lp_module_map),
'return_mapping' => 'asset_id'), $url_prefix_map, $backupData, $restoreHelper);
// update lp_module startAsset_id with new asset_id from map
foreach ($lp_asset_map as $key => $value) {
Database::get()->query("UPDATE lp_module SET `startAsset_id` = ?d "
. "WHERE `course_id` = ?d "
. "AND `startAsset_id` = ?d", intval($value), intval($new_course_id), intval($key));
}
$lp_rel_learnPath_module_map = restore_table($restoreThis, 'lp_rel_learnPath_module', array('map' => array('learnPath_id' => $lp_learnPath_map,
'module_id' => $lp_module_map), 'return_mapping' => 'learnPath_module_id'), $url_prefix_map, $backupData, $restoreHelper);
// update parent
foreach ($lp_rel_learnPath_module_map as $key => $value) {
Database::get()->query("UPDATE lp_rel_learnPath_module SET `parent` = ?d "
. "WHERE `learnPath_id` IN (SELECT learnPath_id FROM lp_learnPath WHERE course_id = ?d) "
. "AND `parent` = ?d", intval($value), intval($new_course_id), intval($key));
}
restore_table($restoreThis, 'lp_user_module_progress', array('delete' => array('user_module_progress_id'),
'map' => array('user_id' => $userid_map,
'learnPath_module_id' => $lp_rel_learnPath_module_map,
'learnPath_id' => $lp_learnPath_map)), $url_prefix_map, $backupData, $restoreHelper);
foreach ($lp_learnPath_map as $old_id => $new_id) {
// new and old id might overlap as the map contains multiple values!
$old_dir = "$coursedir/scormPackages/path_$old_id";
if (file_exists($old_dir) && is_dir($old_dir)) {
rename($old_dir, "$coursedir/scormPackages/__during_restore__$new_id");
}
}
foreach ($lp_learnPath_map as $old_id => $new_id) {
// better to use an intermediary rename step
$tempLPDir = "$coursedir/scormPackages/__during_restore__$new_id";
if (file_exists($tempLPDir) && is_dir($tempLPDir)) {
rename($tempLPDir, "$coursedir/scormPackages/path_$new_id");
}
}
// Wiki
$wiki_map = restore_table($restoreThis, 'wiki_properties', array('set' => array('course_id' => $new_course_id),
'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'wiki_acls', array('map' => array('wiki_id' => $wiki_map)), $url_prefix_map, $backupData, $restoreHelper);
$wiki_pages_map = restore_table($restoreThis, 'wiki_pages', array('map' => array('wiki_id' => $wiki_map,
'owner_id' => $userid_map), 'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'wiki_pages_content', array('delete' => array('id'),
'map' => array('pid' => $wiki_pages_map, 'editor_id' => $userid_map)), $url_prefix_map, $backupData, $restoreHelper);
// Blog
if (file_exists("$restoreThis/blog_post")) {
$blog_map = restore_table($restoreThis, 'blog_post', array('set' => array('course_id' => $new_course_id),
'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
}
// Comments
if (file_exists("$restoreThis/comments")) {
$comment_map = restore_table($restoreThis, 'comments', array('delete' => array('id'),
'map' => array('user_id' => $userid_map),
'map_function' => 'comments_map_function',
'map_function_data' => array($blog_map, $new_course_id),
'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
}
//Abuse Report
if (file_exists("$restoreThis/abuse_report")) {
restore_table($restoreThis, 'abuse_report', array('delete' => array('id'),
'set' => array('course_id' => $new_course_id),
'map' => array('user_id' => $userid_map),
'map_function' => 'abuse_report_map_function',
'map_function_data' => array($forum_post_map,
$comment_map, $link_map)), $url_prefix_map, $backupData, $restoreHelper);
}
// Rating
if (file_exists("$restoreThis/rating")) {
restore_table($restoreThis, 'rating', array('delete' => array('rate_id'),
'map' => array('user_id' => $userid_map),
'map_function' => 'ratings_map_function',
'map_function_data' => array($blog_map, $forum_post_map, $link_map,
$new_course_id)), $url_prefix_map, $backupData, $restoreHelper);
}
if (file_exists("$restoreThis/rating_cache")) {
restore_table($restoreThis, 'rating_cache', array('delete' => array('rate_cache_id'),
'map_function' => 'ratings_map_function',
'map_function_data' => array($blog_map, $forum_post_map, $link_map,
$new_course_id)), $url_prefix_map, $backupData, $restoreHelper);
}
// Course_settings
if (file_exists("$restoreThis/course_settings")) {
restore_table($restoreThis, 'course_settings', array('set' => array('course_id' => $new_course_id)), $url_prefix_map, $backupData, $restoreHelper);
}
// Polls
$poll_map = restore_table($restoreThis, 'poll', array('set' => array('course_id' => $new_course_id),
'map' => array('creator_id' => $userid_map), 'return_mapping' => 'pid', 'delete' => array('type')),
$url_prefix_map, $backupData, $restoreHelper);
$poll_question_map = restore_table($restoreThis, 'poll_question', array('map' => array('pid' => $poll_map),
'return_mapping' => 'pqid'), $url_prefix_map, $backupData, $restoreHelper);
$poll_answer_map = restore_table($restoreThis, 'poll_question_answer', array('map' => array('pqid' => $poll_question_map),
'return_mapping' => 'pqaid'), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'poll_answer_record', array('delete' => array('arid'),
'map' => array('pid' => $poll_map,
'qid' => $poll_question_map,
'aid' => $poll_answer_map,
'user_id' => $userid_map)), $url_prefix_map, $backupData, $restoreHelper);
// Assignments
if (!isset($group_map[0])) {
$group_map[0] = 0;
}
$assignments_map = restore_table($restoreThis, 'assignment', array('set' => array('course_id' => $new_course_id),
'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
$assignments_map[0] = 0;
restore_table($restoreThis, 'assignment_submit', array('delete' => array('id'),
'map' => array('uid' => $userid_map, 'assignment_id' => $assignments_map, 'group_id' => $group_map)), $url_prefix_map, $backupData, $restoreHelper);
// Agenda
$agenda_map = restore_table($restoreThis, 'agenda', array(
'return_mapping' => 'id',
'set' => array('course_id' => $new_course_id)
), $url_prefix_map, $backupData, $restoreHelper);
$agenda_map[0] = 0;
// Exercises
$exercise_map = restore_table($restoreThis, 'exercise', array(
'set' => array('course_id' => $new_course_id),
'return_mapping' => 'id'
), $url_prefix_map, $backupData, $restoreHelper);
$exercise_map[0] = 0;
restore_table($restoreThis, 'exercise_user_record', array(
'delete' => array('eurid'),
'map' => array('eid' => $exercise_map, 'uid' => $userid_map)
), $url_prefix_map, $backupData, $restoreHelper);
$question_category_map = restore_table($restoreThis, 'exercise_question_cats', array(
'set' => array('course_id' => $new_course_id),
'return_mapping' => 'question_cat_id'
), $url_prefix_map, $backupData, $restoreHelper);
$question_category_map[0] = 0;
$question_map = restore_table($restoreThis, 'exercise_question', array(
'set' => array('course_id' => $new_course_id),
'init' => array('category' => 0),
'map' => array('category' => $question_category_map),
'return_mapping' => 'id'
), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'exercise_answer', array(
'delete' => array('id'),
'map' => array('question_id' => $question_map)
), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'exercise_answer_record', array(
'delete' => array('answer_record_id'),
'map' => array('question_id' => $question_map,
'eurid' => $userid_map)
), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'exercise_with_questions', array(
'map' => array('question_id' => $question_map, 'exercise_id' => $exercise_map)
), $url_prefix_map, $backupData, $restoreHelper);
$sql = "SELECT asset.asset_id, asset.path FROM `lp_module` AS module, `lp_asset` AS asset
WHERE module.startAsset_id = asset.asset_id
AND course_id = ?d AND contentType = 'EXERCISE' AND path <> '' AND path IS NOT NULL";
$rows = Database::get()->queryArray($sql, intval($new_course_id));
if (is_array($rows) && count($rows) > 0) {
foreach ($rows as $row) {
Database::get()->query("UPDATE `lp_asset` SET path = ?s WHERE asset_id = ?d", $exercise_map[$row->path], intval($row->asset_id));
}
}
// Attendance
$attendance_map = restore_table($restoreThis, 'attendance', array(
'set' => array('course_id' => $new_course_id),
'return_mapping' => 'id'
), $url_prefix_map, $backupData, $restoreHelper);
$attendance_activities_map = restore_table($restoreThis, 'attendance_activities', array(
'map' => array('attendance_id' => $attendance_map),
'map_function' => 'attendance_gradebook_activities_map_function',
'map_function_data' => array($assignments_map, $exercise_map),
'return_mapping' => 'id'
), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'attendance_book', array(
'map' => array(
'attendance_activity_id' => $attendance_activities_map,
'uid' => $userid_map
),
'delete' => array('id')
), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'attendance_users', array(
'map' => array(
'attendance_id' => $attendance_map,
'uid' => $userid_map
),
'delete' => array('id')
), $url_prefix_map, $backupData, $restoreHelper);
// Gradebook
$gradebook_map = restore_table($restoreThis, 'gradebook', array(
'set' => array('course_id' => $new_course_id),
'return_mapping' => 'id'
), $url_prefix_map, $backupData, $restoreHelper);
$gradebook_activities_map = restore_table($restoreThis, 'gradebook_activities', array(
'map' => array('gradebook_id' => $gradebook_map),
'map_function' => 'attendance_gradebook_activities_map_function',
'map_function_data' => array($assignments_map, $exercise_map),
'return_mapping' => 'id'
), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'gradebook_book', array(
'map' => array(
'gradebook_activity_id' => $gradebook_activities_map,
'uid' => $userid_map
),
'delete' => array('id')
), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'gradebook_users', array(
'map' => array(
'gradebook_id' => $gradebook_map,
'uid' => $userid_map
),
'delete' => array('id')
), $url_prefix_map, $backupData, $restoreHelper);
// Notes
restore_table($restoreThis, 'note', array(
'set' => array('reference_obj_course' => $new_course_id),
'map' => array('user_id' => $userid_map),
'map_function' => 'notes_map_function',
'map_function_data' => array($new_course_id, $agenda_map, $document_map, $link_map,
$video_map, $videolink_map, $assignments_map, $exercise_map, $ebook_map,
$lp_learnPath_map),
'delete' => array('id')
), $url_prefix_map, $backupData, $restoreHelper);
// Units
$unit_map = restore_table($restoreThis, 'course_units', array('set' => array('course_id' => $new_course_id), 'return_mapping' => 'id'), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'unit_resources', array('delete' => array('id'),
'map' => array('unit_id' => $unit_map),
'map_function' => 'unit_map_function',
'map_function_data' => array($document_map,
$link_category_map,
$link_map,
$ebook_map,
$ebook_section_map,
$ebook_subsection_map,
$video_map,
$videolink_map,
$lp_learnPath_map,
$wiki_map,
$assignments_map,
$exercise_map,
$forum_map,
$forum_topic_map)
), $url_prefix_map, $backupData, $restoreHelper);
// Weekly
$weekly_map = restore_table($restoreThis, 'course_weekly_view', array(
'set' => array('course_id' => $new_course_id),
'return_mapping' => 'id'
), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'course_weekly_view_activities', array(
'delete' => array('id'),
'map' => array('course_weekly_view_id' => $weekly_map),
'map_function' => 'unit_map_function',
'map_function_data' => array($document_map,
$link_category_map,
$link_map,
$ebook_map,
$ebook_section_map,
$ebook_subsection_map,
$video_map,
$videolink_map,
$lp_learnPath_map,
$wiki_map,
$assignments_map,
$exercise_map,
$forum_map,
$forum_topic_map)
), $url_prefix_map, $backupData, $restoreHelper);
restore_table($restoreThis, 'course_description', array(
'set' => array('course_id' => $new_course_id),
'delete' => array('id')
), $url_prefix_map, $backupData, $restoreHelper);
removeDir($restoreThis);
// index course after restoring
require_once 'modules/search/indexer.class.php';
Indexer::queueAsync(Indexer::REQUEST_REMOVEALLBYCOURSE, Indexer::RESOURCE_IDX, $new_course_id);
Indexer::queueAsync(Indexer::REQUEST_STOREALLBYCOURSE, Indexer::RESOURCE_IDX, $new_course_id);
});
// check/cleanup video files after restore transaction
if ($new_course_code != null && $new_course_id != null) {
$videodir = $webDir . "/video/" . $new_course_code;
$videos = scandir($videodir);
foreach ($videos as $videofile) {
if (is_dir($videofile)) {
continue;
}
$vlike = '/' . $videofile;
if (!isWhitelistAllowed($videofile)) {
unlink($videodir . "/" . $videofile);
Database::get()->query("DELETE FROM `video` WHERE course_id = ?d AND path LIKE ?s", $new_course_id, $vlike);
continue;
}
$vcnt = Database::get()->querySingle("SELECT count(id) AS count FROM `video` WHERE course_id = ?d AND path LIKE ?s", $new_course_id, $vlike)->count;
if ($vcnt <= 0) {
unlink($videodir . "/" . $videofile);
}
}
$backUrl = $urlAppend . (isset($currentCourseCode)? "courses/$currentCourseCode/": 'modules/admin/');
$tool_content .= action_bar(array(
array('title' => $langEnter,
'url' => $urlAppend . "courses/$new_course_code/",
'icon' => 'fa-arrow-right',
'level' => 'primary-label',
'button-class' => 'btn-success'),
array('title' => $langBack,
'url' => $backUrl,
'icon' => 'fa-reply',
'level' => 'primary-label')), false);
}
}
/**
* Validate a given uploaded zip archive contents against the whitelist and error if necessary.
*
* @param array $listContent - The list contents of the zip arhive, preferably by directly wiring PclZip::listContent().
* @param integer $menuTypeID - The menu type to display in case of error.
*/
function validateUploadedZipFile($listContent, $menuTypeID = 2)
{
global $tool_content, $head_content, $langBack, $langUploadedZipFileNotAllowed;
if (!is_array($listContent)) {
return false;
}
foreach ($listContent as $key => $entry) {
if ($entry['folder'] == 1) {
continue;
}
$filename = basename($entry['filename']);
if (!isWhitelistAllowed($filename)) {
$tool_content .= "<div class='alert alert-danger'>{$langUploadedZipFileNotAllowed}<br><a href='javascript:history.go(-1)'>{$langBack}</a></div><br>";
draw($tool_content, $menuTypeID, null, $head_content);
exit;
}
}
}
