123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727 |
- <?php
- /* For licensing terms, see /license.txt */
- use Chamilo\CoreBundle\Component\Utils\ChamiloApi;
- use Symfony\Component\DomCrawler\Crawler;
- /**
- * @copyright (c) 2001-2006 Universite catholique de Louvain (UCL)
- *
- * @package chamilo.exercise
- *
- * @author claro team <cvs@claroline.net>
- * @author Guillaume Lederer <guillaume@claroline.net>
- * @author Yannick Warnier <yannick.warnier@beeznest.com>
- */
- /**
- * Unzip the exercise in the temp folder.
- *
- * @param string $baseWorkDir The path of the temporary directory where the exercise was uploaded and unzipped
- * @param string $uploadPath
- *
- * @return bool
- */
- function get_and_unzip_uploaded_exercise($baseWorkDir, $uploadPath)
- {
- $_course = api_get_course_info();
- $_user = api_get_user_info();
- //Check if the file is valid (not to big and exists)
- if (!isset($_FILES['userFile']) || !is_uploaded_file($_FILES['userFile']['tmp_name'])) {
- // upload failed
- return false;
- }
- if (preg_match('/.zip$/i', $_FILES['userFile']['name'])) {
- $result = handle_uploaded_document(
- $_course,
- $_FILES['userFile'],
- $baseWorkDir,
- $uploadPath,
- $_user['user_id'],
- 0,
- null,
- 1,
- null,
- null,
- true,
- null,
- null,
- false
- );
- return $result;
- }
- return false;
- }
- /**
- * Imports an exercise in QTI format if the XML structure can be found in it.
- *
- * @param array $file
- *
- * @return string|array as a backlog of what was really imported, and error or debug messages to display
- */
- function import_exercise($file)
- {
- global $exerciseInfo;
- global $resourcesLinks;
- $baseWorkDir = api_get_path(SYS_ARCHIVE_PATH).'qti2/';
- if (!is_dir($baseWorkDir)) {
- mkdir($baseWorkDir, api_get_permissions_for_new_directories(), true);
- }
- $uploadPath = api_get_unique_id().'/';
- if (!is_dir($baseWorkDir.$uploadPath)) {
- mkdir($baseWorkDir.$uploadPath, api_get_permissions_for_new_directories(), true);
- }
- // set some default values for the new exercise
- $exerciseInfo = [];
- $exerciseInfo['name'] = preg_replace('/.zip$/i', '', $file);
- $exerciseInfo['question'] = [];
- // if file is not a .zip, then we cancel all
- if (!preg_match('/.zip$/i', $file)) {
- return 'UplZipCorrupt';
- }
- // unzip the uploaded file in a tmp directory
- if (!get_and_unzip_uploaded_exercise($baseWorkDir, $uploadPath)) {
- return 'UplZipCorrupt';
- }
- $baseWorkDir = $baseWorkDir.$uploadPath;
- // find the different manifests for each question and parse them.
- $exerciseHandle = opendir($baseWorkDir);
- $fileFound = false;
- $result = false;
- $filePath = null;
- $resourcesLinks = [];
- // parse every subdirectory to search xml question files and other assets to be imported
- // The assets-related code is a bit fragile as it has to deal with files renamed by Chamilo and it only works if
- // the imsmanifest.xml file is read.
- while (false !== ($file = readdir($exerciseHandle))) {
- if (is_dir($baseWorkDir.'/'.$file) && $file != "." && $file != "..") {
- // Find each manifest for each question repository found
- $questionHandle = opendir($baseWorkDir.'/'.$file);
- // Only analyse one level of subdirectory - no recursivity here
- while (false !== ($questionFile = readdir($questionHandle))) {
- if (preg_match('/.xml$/i', $questionFile)) {
- $isQti = isQtiQuestionBank($baseWorkDir.'/'.$file.'/'.$questionFile);
- if ($isQti) {
- $result = qti_parse_file($baseWorkDir, $file, $questionFile);
- $filePath = $baseWorkDir.$file;
- $fileFound = true;
- } else {
- $isManifest = isQtiManifest($baseWorkDir.'/'.$file.'/'.$questionFile);
- if ($isManifest) {
- $resourcesLinks = qtiProcessManifest($baseWorkDir.'/'.$file.'/'.$questionFile);
- }
- }
- }
- }
- } elseif (preg_match('/.xml$/i', $file)) {
- $isQti = isQtiQuestionBank($baseWorkDir.'/'.$file);
- if ($isQti) {
- $result = qti_parse_file($baseWorkDir, '', $file);
- $filePath = $baseWorkDir.'/'.$file;
- $fileFound = true;
- } else {
- $isManifest = isQtiManifest($baseWorkDir.'/'.$file);
- if ($isManifest) {
- $resourcesLinks = qtiProcessManifest($baseWorkDir.'/'.$file);
- }
- }
- }
- }
- if (!$fileFound) {
- return 'NoXMLFileFoundInTheZip';
- }
- if ($result == false) {
- return false;
- }
- // 1. Create exercise.
- $exercise = new Exercise();
- $exercise->exercise = $exerciseInfo['name'];
- // Random QTI support
- if (isset($exerciseInfo['order_type'])) {
- if ($exerciseInfo['order_type'] == 'Random') {
- $exercise->setQuestionSelectionType(2);
- $exercise->random = -1;
- }
- }
- if (!empty($exerciseInfo['description'])) {
- $exercise->updateDescription(formatText(strip_tags($exerciseInfo['description'])));
- }
- $exercise->save();
- $last_exercise_id = $exercise->selectId();
- $courseId = api_get_course_int_id();
- if (!empty($last_exercise_id)) {
- // For each question found...
- foreach ($exerciseInfo['question'] as $question_array) {
- if (!in_array($question_array['type'], [UNIQUE_ANSWER, MULTIPLE_ANSWER, FREE_ANSWER])) {
- continue;
- }
- //2. Create question
- $question = new Ims2Question();
- $question->type = $question_array['type'];
- if (empty($question->type)) {
- // If the type was not provided, assume this is a multiple choice, unique answer type (the most basic)
- $question->type = MCUA;
- }
- $question->setAnswer();
- $description = '';
- $question->updateTitle(formatText(strip_tags($question_array['title'])));
- if (isset($question_array['category'])) {
- $category = formatText(strip_tags($question_array['category']));
- if (!empty($category)) {
- $categoryId = TestCategory::get_category_id_for_title(
- $category,
- $courseId
- );
- if (empty($categoryId)) {
- $cat = new TestCategory();
- $cat->name = $category;
- $cat->description = '';
- $categoryId = $cat->save($courseId);
- if ($categoryId) {
- $question->category = $categoryId;
- }
- } else {
- $question->category = $categoryId;
- }
- }
- }
- if (!empty($question_array['description'])) {
- $description .= $question_array['description'];
- }
- $question->updateDescription($description);
- $question->save($exercise);
- $last_question_id = $question->selectId();
- //3. Create answer
- $answer = new Answer($last_question_id);
- $answerList = $question_array['answer'];
- $answer->new_nbrAnswers = count($answerList);
- $totalCorrectWeight = 0;
- $j = 1;
- $matchAnswerIds = [];
- if (!empty($answerList)) {
- foreach ($answerList as $key => $answers) {
- if (preg_match('/_/', $key)) {
- $split = explode('_', $key);
- $i = $split[1];
- } else {
- $i = $j;
- $j++;
- $matchAnswerIds[$key] = $j;
- }
- // Answer
- $answer->new_answer[$i] = isset($answers['value']) ? formatText($answers['value']) : '';
- // Comment
- $answer->new_comment[$i] = isset($answers['feedback']) ? formatText($answers['feedback']) : null;
- // Position
- $answer->new_position[$i] = $i;
- // Correct answers
- if (in_array($key, $question_array['correct_answers'])) {
- $answer->new_correct[$i] = 1;
- } else {
- $answer->new_correct[$i] = 0;
- }
- $answer->new_weighting[$i] = 0;
- if (isset($question_array['weighting'][$key])) {
- $answer->new_weighting[$i] = $question_array['weighting'][$key];
- }
- if ($answer->new_correct[$i]) {
- $totalCorrectWeight += $answer->new_weighting[$i];
- }
- }
- }
- if ($question->type == FREE_ANSWER) {
- $totalCorrectWeight = $question_array['weighting'][0];
- }
- $question->updateWeighting($totalCorrectWeight);
- $question->save($exercise);
- $answer->save();
- }
- // delete the temp dir where the exercise was unzipped
- my_delete($baseWorkDir.$uploadPath);
- return $last_exercise_id;
- }
- return false;
- }
- /**
- * We assume the file charset is UTF8.
- */
- function formatText($text)
- {
- return api_html_entity_decode($text);
- }
- /**
- * Parses a given XML file and fills global arrays with the elements.
- *
- * @param string $exercisePath
- * @param string $file
- * @param string $questionFile
- *
- * @return bool
- */
- function qti_parse_file($exercisePath, $file, $questionFile)
- {
- global $record_item_body;
- global $questionTempDir;
- $questionTempDir = $exercisePath.'/'.$file.'/';
- $questionFilePath = $questionTempDir.$questionFile;
- if (!($fp = fopen($questionFilePath, 'r'))) {
- Display::addFlash(Display::return_message(get_lang('Error opening question\'s XML file'), 'error'));
- return false;
- }
- $data = fread($fp, filesize($questionFilePath));
- //close file
- fclose($fp);
- //parse XML question file
- //$data = str_replace(array('<p>', '</p>', '<front>', '</front>'), '', $data);
- $data = ChamiloApi::stripGivenTags($data, ['p', 'front']);
- $qtiVersion = [];
- $match = preg_match('/ims_qtiasiv(\d)p(\d)/', $data, $qtiVersion);
- $qtiMainVersion = 2; //by default, assume QTI version 2
- if ($match) {
- $qtiMainVersion = $qtiVersion[1];
- }
- //used global variable start values declaration:
- $record_item_body = false;
- if ($qtiMainVersion != 2) {
- Display::addFlash(
- Display::return_message(
- get_lang('UnsupportedQtiVersion'),
- 'error'
- )
- );
- return false;
- }
- parseQti2($data);
- return true;
- }
- /**
- * Function used to parser a QTI2 xml file.
- *
- * @param string $xmlData
- */
- function parseQti2($xmlData)
- {
- global $exerciseInfo;
- global $questionTempDir;
- global $resourcesLinks;
- $crawler = new Crawler($xmlData);
- $nodes = $crawler->filter('*');
- $currentQuestionIdent = '';
- $currentAnswerId = '';
- $currentQuestionItemBody = '';
- $cardinality = '';
- $nonHTMLTagToAvoid = [
- 'simpleChoice',
- 'choiceInteraction',
- 'inlineChoiceInteraction',
- 'inlineChoice',
- 'soMPLEMATCHSET',
- 'simpleAssociableChoice',
- 'textEntryInteraction',
- 'feedbackInline',
- 'matchInteraction',
- 'extendedTextInteraction',
- 'itemBody',
- 'br',
- 'img',
- ];
- $currentMatchSet = null;
- /** @var DOMElement $node */
- foreach ($nodes as $node) {
- if ('#text' === $node->nodeName) {
- continue;
- }
- switch ($node->nodeName) {
- case 'assessmentItem':
- $currentQuestionIdent = $node->getAttribute('identifier');
- $exerciseInfo['question'][$currentQuestionIdent] = [
- 'answer' => [],
- 'correct_answers' => [],
- 'title' => $node->getAttribute('title'),
- 'category' => $node->getAttribute('category'),
- 'type' => '',
- 'tempdir' => $questionTempDir,
- ];
- break;
- case 'section':
- $title = $node->getAttribute('title');
- if (!empty($title)) {
- $exerciseInfo['name'] = $title;
- }
- break;
- case 'responseDeclaration':
- if ('multiple' === $node->getAttribute('cardinality')) {
- $exerciseInfo['question'][$currentQuestionIdent]['type'] = MCMA;
- $cardinality = 'multiple';
- }
- if ('single' === $node->getAttribute('cardinality')) {
- $exerciseInfo['question'][$currentQuestionIdent]['type'] = MCUA;
- $cardinality = 'single';
- }
- $currentAnswerId = $node->getAttribute('identifier');
- break;
- case 'inlineChoiceInteraction':
- $exerciseInfo['question'][$currentQuestionIdent]['type'] = FIB;
- $exerciseInfo['question'][$currentQuestionIdent]['subtype'] = 'LISTBOX_FILL';
- $currentAnswerId = $node->getAttribute('responseIdentifier');
- break;
- case 'inlineChoice':
- $answerIdentifier = $exerciseInfo['question'][$currentQuestionIdent]['correct_answers'][$currentAnswerId];
- if ($node->getAttribute('identifier') == $answerIdentifier) {
- $currentQuestionItemBody = str_replace(
- "**claroline_start**".$currentAnswerId."**claroline_end**",
- "[".$node->nodeValue."]",
- $currentQuestionItemBody
- );
- } else {
- if (!isset($exerciseInfo['question'][$currentQuestionIdent]['wrong_answers'])) {
- $exerciseInfo['question'][$currentQuestionIdent]['wrong_answers'] = [];
- }
- $exerciseInfo['question'][$currentQuestionIdent]['wrong_answers'][] = $node->nodeValue;
- }
- break;
- case 'textEntryInteraction':
- $exerciseInfo['question'][$currentQuestionIdent]['type'] = FIB;
- $exerciseInfo['question'][$currentQuestionIdent]['subtype'] = 'TEXTFIELD_FILL';
- $exerciseInfo['question'][$currentQuestionIdent]['response_text'] = $currentQuestionItemBody;
- break;
- case 'matchInteraction':
- $exerciseInfo['question'][$currentQuestionIdent]['type'] = MATCHING;
- break;
- case 'extendedTextInteraction':
- $exerciseInfo['question'][$currentQuestionIdent]['type'] = FREE_ANSWER;
- $exerciseInfo['question'][$currentQuestionIdent]['description'] = $node->nodeValue;
- break;
- case 'simpleMatchSet':
- if (!isset($currentMatchSet)) {
- $currentMatchSet = 1;
- } else {
- $currentMatchSet++;
- }
- $exerciseInfo['question'][$currentQuestionIdent]['answer'][$currentMatchSet] = [];
- break;
- case 'simpleAssociableChoice':
- $currentAssociableChoice = $node->getAttribute('identifier');
- $exerciseInfo['question'][$currentQuestionIdent]['answer'][$currentMatchSet][$currentAssociableChoice] = trim($node->nodeValue);
- break;
- case 'simpleChoice':
- $currentAnswerId = $node->getAttribute('identifier');
- if (!isset($exerciseInfo['question'][$currentQuestionIdent]['answer'][$currentAnswerId])) {
- $exerciseInfo['question'][$currentQuestionIdent]['answer'][$currentAnswerId] = [];
- }
- //$simpleChoiceValue = $node->nodeValue;
- $simpleChoiceValue = '';
- /** @var DOMElement $childNode */
- foreach ($node->childNodes as $childNode) {
- if ('feedbackInline' === $childNode->nodeName) {
- continue;
- }
- $simpleChoiceValue .= $childNode->nodeValue;
- }
- $simpleChoiceValue = trim($simpleChoiceValue);
- if (!isset($exerciseInfo['question'][$currentQuestionIdent]['answer'][$currentAnswerId]['value'])) {
- $exerciseInfo['question'][$currentQuestionIdent]['answer'][$currentAnswerId]['value'] = $simpleChoiceValue;
- } else {
- $exerciseInfo['question'][$currentQuestionIdent]['answer'][$currentAnswerId]['value'] .= $simpleChoiceValue;
- }
- break;
- case 'mapEntry':
- if (in_array($node->parentNode->nodeName, ['mapping', 'mapEntry'])) {
- $answer_id = $node->getAttribute('mapKey');
- if (!isset($exerciseInfo['question'][$currentQuestionIdent]['weighting'])) {
- $exerciseInfo['question'][$currentQuestionIdent]['weighting'] = [];
- }
- $exerciseInfo['question'][$currentQuestionIdent]['weighting'][$answer_id] = $node->getAttribute(
- 'mappedValue'
- );
- }
- break;
- case 'mapping':
- $defaultValue = $node->getAttribute('defaultValue');
- if (!empty($defaultValue)) {
- $exerciseInfo['question'][$currentQuestionIdent]['default_weighting'] = $defaultValue;
- }
- // no break ?
- case 'itemBody':
- $nodeValue = $node->nodeValue;
- $currentQuestionItemBody = '';
- /** @var DOMElement $childNode */
- foreach ($node->childNodes as $childNode) {
- if ('#text' === $childNode->nodeName) {
- continue;
- }
- if (!in_array($childNode->nodeName, $nonHTMLTagToAvoid)) {
- $currentQuestionItemBody .= '<'.$childNode->nodeName;
- if ($childNode->attributes) {
- foreach ($childNode->attributes as $attribute) {
- $currentQuestionItemBody .= ' '.$attribute->nodeName.'="'.$attribute->nodeValue.'"';
- }
- }
- $currentQuestionItemBody .= '>'.$childNode->nodeValue.'</'.$node->nodeName.'>';
- continue;
- }
- if ('inlineChoiceInteraction' === $childNode->nodeName) {
- $currentQuestionItemBody .= "**claroline_start**".$childNode->attr('responseIdentifier')
- ."**claroline_end**";
- continue;
- }
- if ('textEntryInteraction' === $childNode->nodeName) {
- $correct_answer_value = $exerciseInfo['question'][$currentQuestionIdent]['correct_answers'][$currentAnswerId];
- $currentQuestionItemBody .= "[".$correct_answer_value."]";
- continue;
- }
- if ('br' === $childNode->nodeName) {
- $currentQuestionItemBody .= '<br>';
- }
- }
- // Replace relative links by links to the documents in the course
- // $resourcesLinks is only defined by qtiProcessManifest()
- if (isset($resourcesLinks) && isset($resourcesLinks['manifest']) && isset($resourcesLinks['web'])) {
- foreach ($resourcesLinks['manifest'] as $key => $value) {
- $nodeValue = preg_replace('|'.$value.'|', $resourcesLinks['web'][$key], $nodeValue);
- }
- }
- $currentQuestionItemBody .= $node->firstChild->nodeValue;
- if ($exerciseInfo['question'][$currentQuestionIdent]['type'] == FIB) {
- $exerciseInfo['question'][$currentQuestionIdent]['response_text'] = $currentQuestionItemBody;
- } else {
- if ($exerciseInfo['question'][$currentQuestionIdent]['type'] == FREE_ANSWER) {
- $currentQuestionItemBody = trim($currentQuestionItemBody);
- if (!empty($currentQuestionItemBody)) {
- $exerciseInfo['question'][$currentQuestionIdent]['description'] = $currentQuestionItemBody;
- }
- } else {
- $exerciseInfo['question'][$currentQuestionIdent]['statement'] = $currentQuestionItemBody;
- }
- }
- break;
- case 'img':
- $exerciseInfo['question'][$currentQuestionIdent]['attached_file_url'] = $node->getAttribute('src');
- break;
- case 'order':
- $orderType = $node->getAttribute('order_type');
- if (!empty($orderType)) {
- $exerciseInfo['order_type'] = $orderType;
- }
- break;
- case 'feedbackInline':
- if (!isset($exerciseInfo['question'][$currentQuestionIdent]['answer'][$currentAnswerId]['feedback'])) {
- $exerciseInfo['question'][$currentQuestionIdent]['answer'][$currentAnswerId]['feedback'] = trim(
- $node->nodeValue
- );
- } else {
- $exerciseInfo['question'][$currentQuestionIdent]['answer'][$currentAnswerId]['feedback'] .= trim(
- $node->nodeValue
- );
- }
- break;
- case 'value':
- if ('correctResponse' === $node->parentNode->nodeName) {
- $nodeValue = trim($node->nodeValue);
- if ('single' === $cardinality) {
- $exerciseInfo['question'][$currentQuestionIdent]['correct_answers'][$nodeValue] = $nodeValue;
- } else {
- $exerciseInfo['question'][$currentQuestionIdent]['correct_answers'][] = $nodeValue;
- }
- }
- if ('outcomeDeclaration' === $node->parentNode->parentNode->nodeName) {
- $nodeValue = trim($node->nodeValue);
- if (!empty($nodeValue)) {
- $exerciseInfo['question'][$currentQuestionIdent]['weighting'][0] = $nodeValue;
- }
- }
- break;
- case 'mattext':
- if ('flow_mat' === $node->parentNode->parentNode->nodeName &&
- ('presentation_material' === $node->parentNode->parentNode->parentNode->nodeName ||
- 'section' === $node->parentNode->parentNode->parentNode->nodeName
- )
- ) {
- $nodeValue = trim($node->nodeValue);
- if (!empty($nodeValue)) {
- $exerciseInfo['description'] = $node->nodeValue;
- }
- }
- break;
- }
- }
- }
- /**
- * Check if a given file is an IMS/QTI question bank file.
- *
- * @param string $filePath The absolute filepath
- *
- * @return bool Whether it is an IMS/QTI question bank or not
- */
- function isQtiQuestionBank($filePath)
- {
- $data = file_get_contents($filePath);
- if (!empty($data)) {
- $match = preg_match('/ims_qtiasiv(\d)p(\d)/', $data);
- // @todo allow other types
- //$match2 = preg_match('/imsqti_v(\d)p(\d)/', $data);
- if ($match) {
- return true;
- }
- }
- return false;
- }
- /**
- * Check if a given file is an IMS/QTI manifest file (listing of extra files).
- *
- * @param string $filePath The absolute filepath
- *
- * @return bool Whether it is an IMS/QTI manifest file or not
- */
- function isQtiManifest($filePath)
- {
- $data = file_get_contents($filePath);
- if (!empty($data)) {
- $match = preg_match('/imsccv(\d)p(\d)/', $data);
- if ($match) {
- return true;
- }
- }
- return false;
- }
- /**
- * Processes an IMS/QTI manifest file: store links to new files
- * to be able to transform them into the questions text.
- *
- * @param string $filePath The absolute filepath
- * @param array $links List of filepaths changes
- *
- * @return bool
- */
- function qtiProcessManifest($filePath)
- {
- $xml = simplexml_load_file($filePath);
- $course = api_get_course_info();
- $sessionId = api_get_session_id();
- $courseDir = $course['path'];
- $sysPath = api_get_path(SYS_COURSE_PATH);
- $exercisesSysPath = $sysPath.$courseDir.'/document/';
- $webPath = api_get_path(WEB_CODE_PATH);
- $exercisesWebPath = $webPath.'document/document.php?'.api_get_cidreq().'&action=download&id=';
- $links = [
- 'manifest' => [],
- 'system' => [],
- 'web' => [],
- ];
- $tableDocuments = Database::get_course_table(TABLE_DOCUMENT);
- $countResources = count($xml->resources->resource->file);
- for ($i = 0; $i < $countResources; $i++) {
- $file = $xml->resources->resource->file[$i];
- $href = '';
- foreach ($file->attributes() as $key => $value) {
- if ($key == 'href') {
- if (substr($value, -3, 3) != 'xml') {
- $href = $value;
- }
- }
- }
- if (!empty($href)) {
- $links['manifest'][] = (string) $href;
- $links['system'][] = $exercisesSysPath.strtolower($href);
- $specialHref = Database::escape_string(preg_replace('/_/', '-', strtolower($href)));
- $specialHref = preg_replace('/(-){2,8}/', '-', $specialHref);
- $sql = "SELECT iid FROM $tableDocuments
- WHERE
- c_id = ".$course['real_id']." AND
- session_id = $sessionId AND
- path = '/".$specialHref."'";
- $result = Database::query($sql);
- $documentId = 0;
- while ($row = Database::fetch_assoc($result)) {
- $documentId = $row['iid'];
- }
- $links['web'][] = $exercisesWebPath.$documentId;
- }
- }
- return $links;
- }
|