- cleaning and update for new SCORM tool * @package chamilo.learnpath */ $this_section = SECTION_COURSES; api_protect_course_script(); $is_allowed_to_edit = api_is_allowed_to_edit(null, true); $tbl_lp = Database::get_course_table(TABLE_LP_MAIN); $tbl_lp_item = Database::get_course_table(TABLE_LP_ITEM); $isStudentView = isset($_REQUEST['isStudentView']) ? (int) $_REQUEST['isStudentView'] : null; $learnpath_id = (int) $_REQUEST['lp_id']; $submit = isset($_POST['submit_button']) ? $_POST['submit_button'] : null; $_course = api_get_course_info(); if ((!$is_allowed_to_edit) || ($isStudentView)) { error_log('New LP - User not authorized in lp_admin_view.php'); header('location:lp_controller.php?action=view&lp_id='.$learnpath_id); } // From here on, we are admin because of the previous condition, so don't check anymore. $course_id = api_get_course_int_id(); $sql_query = "SELECT * FROM $tbl_lp WHERE c_id = $course_id AND id = $learnpath_id"; $result = Database::query($sql_query); $therow = Database::fetch_array($result); /* SHOWING THE ADMIN TOOLS */ if (isset($_SESSION['gradebook'])) { $gradebook = $_SESSION['gradebook']; } if (!empty($gradebook) && $gradebook == 'view') { $interbreadcrumb[] = array( 'url' => '../gradebook/'.$_SESSION['gradebook_dest'], 'name' => get_lang('ToolGradebook') ); } $interbreadcrumb[] = array('url' => 'lp_controller.php?action=list', 'name' => get_lang('LearningPaths')); $interbreadcrumb[] = array( 'url' => api_get_self()."?action=build&lp_id=$learnpath_id", "name" => stripslashes("{$therow['name']}"), ); $interbreadcrumb[] = array( 'url' => api_get_self()."?action=add_item&type=step&lp_id=$learnpath_id&".api_get_cidreq(), 'name' => get_lang('NewStep'), ); if (isset($_REQUEST['updateaudio'])) { $interbreadcrumb[] = array('url' => '#', 'name' => get_lang('UpdateAllAudioFragments')); } else { $interbreadcrumb[] = array('url' => '#', 'name' => get_lang('BasicOverview')); } // Theme calls. $show_learn_path = true; $lp_theme_css = $_SESSION['oLP']->get_theme(); // POST action handling (uploading mp3, deleting mp3) if (isset($_POST['save_audio'])) { //Updating the lp.modified_on $_SESSION['oLP']->set_modified_on(); // Deleting the audio fragments. foreach ($_POST as $key => $value) { if (substr($key, 0, 9) == 'removemp3') { $lp_items_to_remove_audio[] = str_ireplace('removemp3', '', $key); // Removing the audio from the learning path item. $tbl_lp_item = Database::get_course_table(TABLE_LP_ITEM); $in = implode(',', $lp_items_to_remove_audio); } } if (count($lp_items_to_remove_audio) > 0) { $sql = "UPDATE $tbl_lp_item SET audio = '' WHERE c_id = $course_id AND id IN (".$in.")"; $result = Database::query($sql); } // Uploading the audio files. foreach ($_FILES as $key => $value) { if (substr($key, 0, 7) == 'mp3file' && !empty($_FILES[$key]['tmp_name'])) { // The id of the learning path item. $lp_item_id = str_ireplace('mp3file', '', $key); // Create the audio folder if it does not exist yet. DocumentManager::createDefaultAudioFolder($_course); // Check if file already exits into document/audio/ $file_name = $_FILES[$key]['name']; $file_name = stripslashes($file_name); // Add extension to files without one (if possible). $file_name = add_ext_on_mime($file_name, $_FILES[$key]['type']); $clean_name = api_replace_dangerous_char($file_name); // No "dangerous" files. $clean_name = disable_dangerous_file($clean_name); $check_file_path = api_get_path(SYS_COURSE_PATH).$_course['path'].'/document/audio/'.$clean_name; // If the file exists we generate a new name. if (file_exists($check_file_path)) { $filename_components = explode('.', $clean_name); // Gettting the extension of the file. $file_extension = $filename_components[count($filename_components) - 1]; // Adding something random to prevent overwriting. $filename_components[count($filename_components) - 1] = time(); // Reconstructing the new filename. $clean_name = implode($filename_components).'.'.$file_extension; // Using the new name in the $_FILES superglobal. $_FILES[$key]['name'] = $clean_name; } // Upload the file in the documents tool. $file_path = handle_uploaded_document( $_course, $_FILES[$key], api_get_path(SYS_COURSE_PATH).$_course['path'].'/document', '/audio', api_get_user_id(), '', '', '', '', false ); // Getting the filename only. $file_components = explode('/', $file_path); $file = $file_components[count($file_components) - 1]; // Store the mp3 file in the lp_item table. $tbl_lp_item = Database::get_course_table(TABLE_LP_ITEM); $sql_insert_audio = "UPDATE $tbl_lp_item SET audio = '".Database::escape_string($file)."' WHERE c_id = $course_id AND id = '".Database::escape_string($lp_item_id)."'"; Database::query($sql_insert_audio); } } //Display::display_confirmation_message(get_lang('ItemUpdated')); $url = api_get_self().'?action=add_item&type=step&lp_id='.intval($_SESSION['oLP']->lp_id).'&'.api_get_cidreq(); header('Location: '.$url); exit; } Display::display_header(null, 'Path'); $suredel = trim(get_lang('AreYouSureToDeleteJS')); ?> build_action_menu(); echo '
'; echo '
'; echo $_SESSION['oLP']->return_new_tree(null, true); echo '
'; echo '
'; switch ($_GET['action']) { case 'edit_item': if (isset($is_success) && $is_success === true) { Display::display_confirmation_message(get_lang('LearnpathItemEdited')); } else { echo $_SESSION['oLP']->display_edit_item($_GET['id']); } break; case 'delete_item': if (isset($is_success) && $is_success === true) { Display::display_confirmation_message(get_lang('LearnpathItemDeleted')); } break; } if (!empty($_GET['updateaudio'])) { // list of items to add audio files echo $_SESSION['oLP']->overview(); } echo '
'; echo '
'; /* FOOTER */ Display::display_footer();