/**
* Export lesson
*
* This function is used to export the current lesson's data to
* a file, which can then be imported to other systems. Apart from
* the lesson content, the user may optinally specify additional
* information to export, using the $exportEntities array. If
* $exportEntities is 'all', everything that can be exported, is
* exported
*
* <br/>Example:
* <code>
* $exportedFile = $lesson -> export('all');
* </code>
*
* @param array $exportEntities The additional data to export
* @param boolean $rename Whether to rename the exported file with the same name as the lesson
* @param boolean $exportFiles Whether to export files as well
* @return EfrontFile The object of the exported data file
* @since 3.5.0
* @access public
*/
public function export($exportEntities, $rename = true, $exportFiles = true)
{
if (!$exportEntities) {
$exportEntities = array('export_surveys' => 1, 'export_announcements' => 1, 'export_glossary' => 1, 'export_calendar' => 1, 'export_comments' => 1, 'export_rules' => 1);
}
$data['lessons'] = $this->lesson;
unset($data['lessons']['share_folder']);
unset($data['lessons']['instance_source']);
unset($data['lessons']['originating_course']);
$content = eF_getTableData("content", "*", "lessons_ID=" . $this->lesson['id']);
if (sizeof($content) > 0) {
$contentIds = array();
for ($i = 0; $i < sizeof($content); $i++) {
$content[$i]['data'] = str_replace(G_SERVERNAME, "##SERVERNAME##", $content[$i]['data']);
$content[$i]['data'] = str_replace("content/lessons/" . ($this->lesson['share_folder'] ? $this->lesson['share_folder'] : $this->lesson['id']), "##LESSONSLINK##", $content[$i]['data']);
$contentIds[] = $content[$i]['id'];
}
$content_list = implode(",", array_values($contentIds));
$data['content'] = $content;
$questions = eF_getTableData("questions", "*", "lessons_ID=" . $this->lesson['id']);
if (sizeof($questions) > 0) {
for ($i = 0; $i < sizeof($questions); $i++) {
$questions[$i]['text'] = str_replace(G_SERVERNAME, "##SERVERNAME##", $questions[$i]['text']);
$questions[$i]['text'] = str_replace("content/lessons/" . ($this->lesson['share_folder'] ? $this->lesson['share_folder'] : $this->lesson['id']), "##LESSONSLINK##", $questions[$i]['text']);
}
$data['questions'] = $questions;
}
$tests = eF_getTableData("tests", "*", "lessons_ID=" . $this->lesson['id']);
if (sizeof($tests)) {
$testsIds = array();
foreach ($tests as $key => $value) {
$testsIds[] = $value['id'];
}
$tests_list = implode(",", array_values($testsIds));
$tests_to_questions = eF_getTableData("tests_to_questions", "*", "tests_ID IN ({$tests_list})");
for ($i = 0; $i < sizeof($tests); $i++) {
$tests[$i]['description'] = str_replace(G_SERVERNAME, "##SERVERNAME##", $tests[$i]['description']);
$tests[$i]['description'] = str_replace("content/lessons/" . ($this->lesson['share_folder'] ? $this->lesson['share_folder'] : $this->lesson['id']), "##LESSONSLINK##", $tests[$i]['description']);
}
$data['tests'] = $tests;
$data['tests_to_questions'] = $tests_to_questions;
}
if (isset($exportEntities['export_rules'])) {
$rules = eF_getTableData("rules", "*", "lessons_ID=" . $this->lesson['id']);
if (sizeof($rules) > 0) {
$data['rules'] = $rules;
}
}
if (isset($exportEntities['export_comments'])) {
$comments = eF_getTableData("comments", "*", "content_ID IN ({$content_list})");
if (sizeof($comments) > 0) {
$data['comments'] = $comments;
}
}
}
if (isset($exportEntities['export_calendar'])) {
$calendar = calendar::getLessonCalendarEvents($this);
$calendar = array_values($calendar);
if (sizeof($calendar) > 0) {
$data['calendar'] = $calendar;
}
}
if (isset($exportEntities['export_glossary'])) {
$glossary = eF_getTableData("glossary", "*", "lessons_ID = " . $this->lesson['id']);
if (sizeof($glossary) > 0) {
$data['glossary'] = $glossary;
}
}
if (isset($exportEntities['export_announcements'])) {
$news = eF_getTableData("news", "*", "lessons_ID=" . $this->lesson['id']);
if (sizeof($news) > 0) {
$data['news'] = $news;
}
}
if (isset($exportEntities['export_surveys'])) {
$surveys = eF_getTableData("surveys", "*", "lessons_ID=" . $this->lesson['id']);
//prepei na ginei to lesson_ID -> lessons_ID sti basi (ayto isos to parampsoyme eykola)
if (sizeof($surveys) > 0) {
$data['surveys'] = $surveys;
$surveys_ = array();
foreach ($surveys as $key => $value) {
$surveys_[$value['id']] = $value;
}
$surveys_list = implode(",", array_keys($surveys_));
$questions_to_surveys = eF_getTableData("questions_to_surveys", "*", "surveys_ID IN ({$surveys_list})");
// oposipote omos to survey_ID -> surveys_ID sti basi
if (sizeof($questions_to_surveys) > 0) {
$data['questions_to_surveys'] = $questions_to_surveys;
}
}
}
$lesson_conditions = eF_getTableData("lesson_conditions", "*", "lessons_ID=" . $this->lesson['id']);
if (sizeof($lesson_conditions) > 0) {
$data['lesson_conditions'] = $lesson_conditions;
}
$projects = eF_getTableData("projects", "*", "lessons_ID=" . $this->lesson['id']);
if (sizeof($projects) > 0) {
$data['projects'] = $projects;
}
$lesson_files = eF_getTableData("files", "*", "path like '" . str_replace(G_ROOTPATH, '', EfrontDirectory::normalize($this->getDirectory())) . "%'");
if (sizeof($lesson_files) > 0) {
$data['files'] = $lesson_files;
}
if (G_VERSIONTYPE != 'community') {
#cpp#ifndef COMMUNITY
if (G_VERSIONTYPE != 'standard') {
#cpp#ifndef STANDARD
//Export scorm tables from here over
$scormLessonTables = array('scorm_sequencing_adlseq_map_info', 'scorm_sequencing_content_to_organization', 'scorm_sequencing_maps_info', 'scorm_sequencing_organizations');
foreach ($scormLessonTables as $table) {
$scorm_data = eF_getTableData($table, "*", "lessons_ID=" . $this->lesson['id']);
if (sizeof($scorm_data) > 0) {
$data[$table] = $scorm_data;
}
}
$scormContentTables = array('scorm_sequencing_completion_threshold', 'scorm_sequencing_constrained_choice', 'scorm_sequencing_control_mode', 'scorm_sequencing_delivery_controls', 'scorm_sequencing_hide_lms_ui', 'scorm_sequencing_limit_conditions', 'scorm_sequencing_maps', 'scorm_sequencing_map_info', 'scorm_sequencing_objectives', 'scorm_sequencing_rollup_considerations', 'scorm_sequencing_rollup_controls', 'scorm_sequencing_rollup_rules', 'scorm_sequencing_rules');
if ($content_list) {
foreach ($scormContentTables as $table) {
$scorm_data = eF_getTableData($table, "*", "content_ID IN ({$content_list})");
if (sizeof($scorm_data) > 0) {
$data[$table] = $scorm_data;
}
if ($table == 'scorm_sequencing_rollup_rules' && sizeof($scorm_data) > 0) {
$ids = array();
foreach ($scorm_data as $value) {
$ids[] = $value['id'];
}
$result = eF_getTableData('scorm_sequencing_rollup_rule', "*", "scorm_sequencing_rollup_rules_ID IN (" . implode(",", $ids) . ")");
$data['scorm_sequencing_rollup_rule'] = $result;
}
if ($table == 'scorm_sequencing_rules' && sizeof($scorm_data) > 0) {
$ids = array();
foreach ($scorm_data as $value) {
$ids[] = $value['id'];
}
$result = eF_getTableData('scorm_sequencing_rule', "*", "scorm_sequencing_rules_ID IN (" . implode(",", $ids) . ")");
$data['scorm_sequencing_rule'] = $result;
}
}
}
}
#cpp#endif
}
#cpp#endif
//'scorm_sequencing_rollup_rule', 'scorm_sequencing_rule',
// MODULES - Export module data
// Get all modules (NOT only the ones that have to do with the user type)
$modules = eF_loadAllModules();
foreach ($modules as $module) {
if ($moduleData = $module->onExportLesson($this->lesson['id'])) {
$data[$module->className] = $moduleData;
}
}
file_put_contents($this->directory . '/' . "data.dat", serialize($data));
//Create database dump file
if ($exportFiles) {
$lessonDirectory = new EfrontDirectory($this->directory);
$file = $lessonDirectory->compress($this->lesson['id'] . '_exported.zip', false);
//Compress the lesson files
} else {
$dataFile = new EfrontFile($this->directory . '/' . "data.dat");
$file = $dataFile->compress($this->lesson['id'] . '_exported.zip');
}
$newList = FileSystemTree::importFiles($file['path']);
//Import the file to the database, so we can download it
$file = new EfrontFile(current($newList));
if (empty($GLOBALS['currentUser'])) {
if ($_SESSION['s_login']) {
$GLOBALS['currentUser'] = EfrontUserFactory::factory($_SESSION['s_login']);
$userTempDir = $GLOBALS['currentUser']->user['directory'] . '/temp';
} else {
$userTempDir = sys_get_temp_dir();
}
} else {
$userTempDir = $GLOBALS['currentUser']->user['directory'] . '/temp';
}
if (!is_dir($userTempDir)) {
//If the user's temp directory does not exist, create it
$userTempDir = EfrontDirectory::createDirectory($userTempDir, false);
$userTempDir = $userTempDir['path'];
}
try {
$existingFile = new EfrontFile($userTempDir . '/' . EfrontFile::encode($this->lesson['name']) . '.zip');
//Delete any previous exported files
$existingFile->delete();
} catch (Exception $e) {
}
if ($rename) {
$newName = str_replace(array('"', '>', '<', '*', '?', ':'), array('"', '>', '<', '*', '?', ':'), $this->lesson['name']);
$file->rename($userTempDir . '/' . EfrontFile::encode($newName) . '.zip', true);
}
unlink($this->directory . '/' . "data.dat");
//Delete database dump file
return $file;
}
$fields = array("name" => $values['english_name'], "translation" => $values['translation'], "rtl" => $values['rtl']);
eF_updateTableData("languages", $fields, "name='" . $values['selected_language'] . "'");
EfrontCache::getInstance()->deleteCache('languages');
//include "editor/tiny_mce/langs/language.php";
//$RetValues = file(G_SERVERNAME."/editor/tiny_mce/langs/language.php?langname=".$values['english_name']);
eF_redirect("" . basename($_SERVER['PHP_SELF']) . "?ctg=languages&message=" . urlencode(_SUCCESSFULLYUPDATEDLANGUAGE) . "&message_type=success");
} else {
if ($_FILES['language_upload']['error'] == 0) {
$filesystem = new FileSystemTree(G_ROOTPATH . 'libraries/language');
$uploadedFile = $filesystem->uploadFile('language_upload', G_ROOTPATH . 'libraries/language');
if ($uploadedFile['extension'] == "zip") {
$lang_zip_file_temp = new EfrontFile($uploadedFile['path']);
$lang_zip_file = $lang_zip_file_temp->uncompress(false);
$lang_file_rename = new EfrontFile($lang_zip_file[0]);
if ($values['custom']) {
$lang_file_rename->rename(dirname($uploadedFile['path']) . '/custom-' . $values['english_name'] . '.php.inc', true);
} else {
$lang_file_rename->rename(dirname($uploadedFile['path']) . '/lang-' . $values['english_name'] . '.php.inc', true);
}
} else {
if ($values['custom']) {
$uploadedFile->rename(dirname($uploadedFile['path']) . '/custom-' . $values['english_name'] . '.php.inc', true);
} else {
$uploadedFile->rename(dirname($uploadedFile['path']) . '/lang-' . $values['english_name'] . '.php.inc', true);
}
}
} else {
$file = new EfrontFile(G_ROOTPATH . 'libraries/language/lang-english.php.inc');
$file->copy(G_ROOTPATH . 'libraries/language/lang-' . $values['english_name'] . '.php.inc');
}
$fields = array("name" => $values['english_name'], "translation" => $values['translation'], "active" => 1, "rtl" => $values['rtl']);
/**
* Rename / Move directory
*
* This function is used to rename and/or move the directory. The destinationPath must contain the same name
* if it is going to be moved only, or a new name if it is going to be renamed also
* directory after copying it.
* <br/>Example:
* <code>
* $directory = new EfrontDirectory(43); //Instantiate directory object
* $directory -> rename('/var/www/'); //Move directory to /var/www/
* </code>
*
* @param mixed $destinationPath The destination directory
* @return EfrontDirectory The renamed/moved directory
* @since 3.5.0
* @access public
* @see copy()
*/
public function rename($destinationPath, $overwrite = false)
{
if (eF_checkParameter($destinationPath, 'path') === false) {
throw new EfrontFileException(_ILLEGALFILENAME, EfrontFileException::ILLEGAL_FILE_NAME);
}
$destinationPath = EfrontDirectory::normalize($destinationPath);
$parentDirectory = new EfrontDirectory(dirname($destinationPath));
//This way we check integrity of destination
if (!is_dir($destinationPath)) {
mkdir($destinationPath, 0755);
} elseif (!$overwrite) {
throw new EfrontFileException(_CANNOTCOPYDIRECTORY . ': ' . $destinationPath . ', ' . _FILEALREADYEXISTS, EfrontFileException::DIRECTORY_ALREADY_EXISTS);
}
$old_dirs = array();
$it = new EfrontREFilterIterator(new RecursiveIteratorIterator(new RecursiveDirectoryIterator($this['path']), RecursiveIteratorIterator::SELF_FIRST), array('/.svn/'), false);
foreach ($it as $node => $value) {
if ($value->isDir()) {
$current = str_replace("\\", "/", $node);
$newDir = str_replace($this['path'], $destinationPath, $current);
mkdir($newDir, 0755);
$old_dirs[] = $current;
}
}
foreach ($it as $node => $value) {
if ($value->isFile()) {
$current = str_replace("\\", "/", $node);
$newPath = str_replace($this['path'], $destinationPath, $current);
$file = new EfrontFile($node);
$file->rename($newPath, $overwrite);
}
}
//added to delete firstly any subfolders, otherwise rmdir($this['path']) fails
foreach (array_reverse($old_dirs) as $value) {
rmdir($value);
}
unset($it);
rmdir($this['path']);
$directory = new EfrontDirectory($destinationPath);
$this['name'] = $directory['name'];
$this['path'] = $directory['path'];
$this['directory'] = $directory['directory'];
$this['timestamp'] = $directory['timestamp'];
$this['physical_name'] = $directory['physical_name'];
}
}
}
EfrontTimes::upgradeFromUsersOnline();
}
if (version_compare($dbVersion, '3.6.10') == -1) {
$result = eF_getTableData("users_to_projects", "*");
foreach ($result as $value) {
if (isset($value['filename']) && $value['filename'] != '') {
try {
$file = new EfrontFile($value['filename']);
if ($file['directory'] == G_UPLOADPATH . $value['users_LOGIN'] . '/projects') {
$projectDirectory = G_UPLOADPATH . $value['users_LOGIN'] . '/projects/' . $value['projects_ID'] . '/';
if (!is_dir($projectDirectory)) {
EfrontDirectory::createDirectory($projectDirectory);
}
$file->rename($projectDirectory . $file['physical_name']);
}
} catch (Exception $e) {
}
}
}
//change flv path with offset because of the tinymce 3.4.2
$result = eF_getTableData("content", "*", "data like '%flvToPlay%'");
foreach ($result as $value) {
if (mb_strpos($value['data'], "flvToPlay=../../../../../") !== false) {
$value['data'] = str_replace("flvToPlay=../../../../../", "flvToPlay=##EFRONTEDITOROFFSET##", $value['data']);
eF_updateTableData("content", array('data' => $value['data']), "id=" . $value['id']);
}
}
}
$options = EfrontConfiguration::getValues();
