@@ -29,8 +29,8 @@ discard block |
||
| 29 | 29 | |
| 30 | 30 | // Resetting the images of the slideshow = destroying the slideshow |
| 31 | 31 | if (isset($_GET['action']) && $_GET['action'] == 'exit_slideshow') { |
| 32 | - $_SESSION['image_files_only'] = null; |
|
| 33 | - unset($image_files_only); |
|
| 32 | + $_SESSION['image_files_only'] = null; |
|
| 33 | + unset($image_files_only); |
|
| 34 | 34 | } |
| 35 | 35 | |
| 36 | 36 | // We check if there are images in this folder by searching the extensions for .jpg, .gif, .png |
@@ -39,10 +39,10 @@ discard block |
||
| 39 | 39 | $array_to_search = !empty($documentAndFolders) && is_array($documentAndFolders) ? $documentAndFolders : array(); |
| 40 | 40 | |
| 41 | 41 | if (count($array_to_search) > 0) { |
| 42 | - while (list($key) = each($array_to_search)) { |
|
| 43 | - $all_files[] = basename($array_to_search[$key]['path']); |
|
| 44 | - //echo basename($array_to_search[$key]['path']).'<br />'; |
|
| 45 | - } |
|
| 42 | + while (list($key) = each($array_to_search)) { |
|
| 43 | + $all_files[] = basename($array_to_search[$key]['path']); |
|
| 44 | + //echo basename($array_to_search[$key]['path']).'<br />'; |
|
| 45 | + } |
|
| 46 | 46 | } |
| 47 | 47 | |
| 48 | 48 | // Always show gallery. |
@@ -62,9 +62,9 @@ discard block |
||
| 62 | 62 | |
| 63 | 63 | $tablename_column = isset($_GET['tablename_column']) ? Security::remove_XSS($_GET['tablename_column']) : 0; |
| 64 | 64 | if ($tablename_column == 0) { |
| 65 | - $tablename_column = 1; |
|
| 65 | + $tablename_column = 1; |
|
| 66 | 66 | } else { |
| 67 | - $tablename_column = intval($tablename_column) - 1; |
|
| 67 | + $tablename_column = intval($tablename_column) - 1; |
|
| 68 | 68 | } |
| 69 | 69 | $tablename_direction = isset($_GET['tablename_direction']) ? Security::remove_XSS($_GET['tablename_direction']) : 'ASC'; |
| 70 | 70 | |
@@ -98,15 +98,15 @@ discard block |
||
| 98 | 98 | $final_array[] = $file_array[1]; |
| 99 | 99 | } |
| 100 | 100 | |
| 101 | - return $final_array; |
|
| 101 | + return $final_array; |
|
| 102 | 102 | } |
| 103 | 103 | |
| 104 | 104 | function sort_table($a, $b) { |
| 105 | - global $tablename_column; |
|
| 106 | - return strnatcmp($a[$tablename_column], $b[$tablename_column]); |
|
| 105 | + global $tablename_column; |
|
| 106 | + return strnatcmp($a[$tablename_column], $b[$tablename_column]); |
|
| 107 | 107 | } |
| 108 | 108 | |
| 109 | 109 | function rsort_table($a, $b) { |
| 110 | - global $tablename_column; |
|
| 111 | - return strnatcmp($b[$tablename_column], $a[$tablename_column]); |
|
| 110 | + global $tablename_column; |
|
| 111 | + return strnatcmp($b[$tablename_column], $a[$tablename_column]); |
|
| 112 | 112 | } |
@@ -77,7 +77,7 @@ discard block |
||
| 77 | 77 | if ($image_resizing == 'noresizing' || $image_resizing == '') { |
| 78 | 78 | echo ' checked'; |
| 79 | 79 | } |
| 80 | - ?>> |
|
| 80 | + ?>> |
|
| 81 | 81 | </label> |
| 82 | 82 | <?php echo '<b>'. get_lang('NoResizing') . '</b>, ' . get_lang('NoResizingComment') ;?> |
| 83 | 83 | </div> |
@@ -87,7 +87,7 @@ discard block |
||
| 87 | 87 | if ($image_resizing == 'resizing_auto' || $image_resizing == '') { |
| 88 | 88 | echo ' checked'; |
| 89 | 89 | } |
| 90 | - ?>> |
|
| 90 | + ?>> |
|
| 91 | 91 | </label> |
| 92 | 92 | <?php echo '<b>'. get_lang('ResizingAuto') . '</b>, ' . get_lang('ResizingAutoComment');?> |
| 93 | 93 | </div> |
@@ -99,7 +99,7 @@ discard block |
||
| 99 | 99 | $width = $_SESSION['image_resizing_width']; |
| 100 | 100 | $height = $_SESSION['image_resizing_height']; |
| 101 | 101 | } |
| 102 | - ?>> |
|
| 102 | + ?>> |
|
| 103 | 103 | </label> |
| 104 | 104 | <?php echo '<b>'. get_lang('Resizing') . '</b>, ' . get_lang('ResizingComment'); ?> |
| 105 | 105 | </div> |
@@ -107,13 +107,13 @@ discard block |
||
| 107 | 107 | <label class="col-sm-1 control-label"><?php echo get_lang('Width'); ?></label> |
| 108 | 108 | <div class="col-sm-3"> |
| 109 | 109 | <input class="form-control" name="width" type="text" id="width" <?php |
| 110 | - if ($image_resizing == 'resizing') { |
|
| 111 | - echo ' value="'.$width.'"'; |
|
| 112 | - echo ' class="enabled_input"'; |
|
| 110 | + if ($image_resizing == 'resizing') { |
|
| 111 | + echo ' value="'.$width.'"'; |
|
| 112 | + echo ' class="enabled_input"'; |
|
| 113 | 113 | } else { |
| 114 | 114 | echo ' class="disabled_input"'; |
| 115 | 115 | } |
| 116 | - ?> > |
|
| 116 | + ?> > |
|
| 117 | 117 | </div> |
| 118 | 118 | <div class="col-sm-8"></div> |
| 119 | 119 | </div> |
@@ -121,13 +121,13 @@ discard block |
||
| 121 | 121 | <label class="col-sm-1 control-label"><?php echo get_lang('Height'); ?></label> |
| 122 | 122 | <div class="col-sm-3"> |
| 123 | 123 | <input class="form-control" name="height" type="text" id="height" <?php |
| 124 | - if ($image_resizing == 'resizing') { |
|
| 125 | - echo ' value="'.$height.'"'; |
|
| 126 | - echo ' class="enabled_input"'; |
|
| 127 | - } else { |
|
| 124 | + if ($image_resizing == 'resizing') { |
|
| 125 | + echo ' value="'.$height.'"'; |
|
| 126 | + echo ' class="enabled_input"'; |
|
| 127 | + } else { |
|
| 128 | 128 | echo ' class="disabled_input"'; |
| 129 | 129 | } |
| 130 | - ?> > |
|
| 130 | + ?> > |
|
| 131 | 131 | </div> |
| 132 | 132 | <div class="col-sm-8"></div> |
| 133 | 133 | </div> |
@@ -23,11 +23,11 @@ discard block |
||
| 23 | 23 | $document_data = array(); |
| 24 | 24 | |
| 25 | 25 | if (isset($_GET['id'])) { |
| 26 | - $document_data = DocumentManager::get_document_data_by_id( |
|
| 27 | - $_GET['id'], |
|
| 28 | - api_get_course_id(), |
|
| 29 | - true |
|
| 30 | - ); |
|
| 26 | + $document_data = DocumentManager::get_document_data_by_id( |
|
| 27 | + $_GET['id'], |
|
| 28 | + api_get_course_id(), |
|
| 29 | + true |
|
| 30 | + ); |
|
| 31 | 31 | } |
| 32 | 32 | |
| 33 | 33 | if (empty($document_data)) { |
@@ -46,46 +46,46 @@ discard block |
||
| 46 | 46 | // Please, do not modify this dirname formatting |
| 47 | 47 | |
| 48 | 48 | if (strstr($dir, '..')) { |
| 49 | - $dir = '/'; |
|
| 49 | + $dir = '/'; |
|
| 50 | 50 | } |
| 51 | 51 | |
| 52 | 52 | if ($dir[0] == '.') { |
| 53 | - $dir = substr($dir, 1); |
|
| 53 | + $dir = substr($dir, 1); |
|
| 54 | 54 | } |
| 55 | 55 | |
| 56 | 56 | if ($dir[0] != '/') { |
| 57 | - $dir = '/'.$dir; |
|
| 57 | + $dir = '/'.$dir; |
|
| 58 | 58 | } |
| 59 | 59 | |
| 60 | 60 | if ($dir[strlen($dir) - 1] != '/') { |
| 61 | - $dir .= '/'; |
|
| 61 | + $dir .= '/'; |
|
| 62 | 62 | } |
| 63 | 63 | |
| 64 | 64 | $filepath = api_get_path(SYS_COURSE_PATH).$_course['path'].'/document'.$dir; |
| 65 | 65 | |
| 66 | 66 | if (!is_dir($filepath)) { |
| 67 | - $filepath = api_get_path(SYS_COURSE_PATH).$_course['path'].'/document/'; |
|
| 68 | - $dir = '/'; |
|
| 67 | + $filepath = api_get_path(SYS_COURSE_PATH).$_course['path'].'/document/'; |
|
| 68 | + $dir = '/'; |
|
| 69 | 69 | } |
| 70 | 70 | |
| 71 | 71 | if (!empty($groupId)) { |
| 72 | - $interbreadcrumb[] = array ("url" => "../group/group_space.php?".api_get_cidreq(), "name" => get_lang('GroupSpace')); |
|
| 73 | - $group = GroupManager :: get_group_properties($groupId); |
|
| 74 | - $path = explode('/', $dir); |
|
| 75 | - if ('/'.$path[1] != $group['directory']) { |
|
| 76 | - api_not_allowed(true); |
|
| 77 | - } |
|
| 72 | + $interbreadcrumb[] = array ("url" => "../group/group_space.php?".api_get_cidreq(), "name" => get_lang('GroupSpace')); |
|
| 73 | + $group = GroupManager :: get_group_properties($groupId); |
|
| 74 | + $path = explode('/', $dir); |
|
| 75 | + if ('/'.$path[1] != $group['directory']) { |
|
| 76 | + api_not_allowed(true); |
|
| 77 | + } |
|
| 78 | 78 | } |
| 79 | 79 | |
| 80 | 80 | $interbreadcrumb[] = array("url" => "./document.php?id=".$document_id.'&'.api_get_cidreq(), "name" => get_lang('Documents')); |
| 81 | 81 | |
| 82 | 82 | if (!$is_allowed_in_course) { |
| 83 | - api_not_allowed(true); |
|
| 83 | + api_not_allowed(true); |
|
| 84 | 84 | } |
| 85 | 85 | |
| 86 | 86 | if (!($is_allowed_to_edit || $_SESSION['group_member_with_upload_rights'] || |
| 87 | - DocumentManager::is_my_shared_folder(api_get_user_id(), Security::remove_XSS($dir),api_get_session_id()))) { |
|
| 88 | - api_not_allowed(true); |
|
| 87 | + DocumentManager::is_my_shared_folder(api_get_user_id(), Security::remove_XSS($dir),api_get_session_id()))) { |
|
| 88 | + api_not_allowed(true); |
|
| 89 | 89 | } |
| 90 | 90 | |
| 91 | 91 | /* Header */ |
@@ -93,10 +93,10 @@ discard block |
||
| 93 | 93 | |
| 94 | 94 | $display_dir = $dir; |
| 95 | 95 | if (isset ($group)) { |
| 96 | - $display_dir = explode('/', $dir); |
|
| 97 | - unset ($display_dir[0]); |
|
| 98 | - unset ($display_dir[1]); |
|
| 99 | - $display_dir = implode('/', $display_dir); |
|
| 96 | + $display_dir = explode('/', $dir); |
|
| 97 | + unset ($display_dir[0]); |
|
| 98 | + unset ($display_dir[1]); |
|
| 99 | + $display_dir = implode('/', $display_dir); |
|
| 100 | 100 | } |
| 101 | 101 | |
| 102 | 102 | // Interbreadcrumb for the current directory root path |
@@ -117,7 +117,7 @@ discard block |
||
| 117 | 117 | Display :: display_header($nameTools, 'Doc'); |
| 118 | 118 | |
| 119 | 119 | echo '<div class="actions">'; |
| 120 | - echo '<a href="document.php?'.api_get_cidreq().'&id='.$document_id.'">'.Display::return_icon('back.png',get_lang('BackTo').' '.get_lang('DocumentsOverview'),'',ICON_SIZE_MEDIUM).'</a>'; |
|
| 120 | + echo '<a href="document.php?'.api_get_cidreq().'&id='.$document_id.'">'.Display::return_icon('back.png',get_lang('BackTo').' '.get_lang('DocumentsOverview'),'',ICON_SIZE_MEDIUM).'</a>'; |
|
| 121 | 121 | echo '</div>'; |
| 122 | 122 | |
| 123 | 123 | ?> |
@@ -178,24 +178,24 @@ discard block |
||
| 178 | 178 | Display::display_icon('microphone.png', get_lang('PressRecordButton'),'','128'); |
| 179 | 179 | echo '<br/>'; |
| 180 | 180 | echo '<applet id="nanogong" archive="'.api_get_path(WEB_LIBRARY_PATH).'nanogong/nanogong.jar" code="gong.NanoGong" width="250" height="95" ALIGN="middle">'; |
| 181 | - //echo '<param name="ShowRecordButton" value="false" />'; // default true |
|
| 182 | - // echo '<param name="ShowSaveButton" value="false" />'; //you can save in local computer | (default true) |
|
| 183 | - //echo '<param name="ShowSpeedButton" value="false" />'; // default true |
|
| 184 | - //echo '<param name="ShowAudioLevel" value="false" />'; // it displays the audiometer | (default true) |
|
| 185 | - echo '<param name="ShowTime" value="true" />'; // default false |
|
| 186 | - //echo '<param name="Color" value="#C0E0FF" />'; // default #FFFFFF |
|
| 187 | - //echo '<param name="StartTime" value="10.5" />'; |
|
| 188 | - //echo '<param name="EndTime" value="65" />'; |
|
| 189 | - echo '<param name="AudioFormat" value="ImaADPCM" />';// ImaADPCM (more speed), Speex (more compression)|(default Speex) |
|
| 190 | - //echo '<param name="SamplingRate" value="32000" />';//Quality for ImaADPCM (low 8000, medium 11025, normal 22050, hight 44100) OR Quality for Speex (low 8000, medium 16000, normal 32000, hight 44100) | (default 44100) |
|
| 191 | - //echo '<param name="MaxDuration" value="60" />'; |
|
| 192 | - //echo '<param name="SoundFileURL" value="http://somewhere.com/mysoundfile.wav" />';//load a file |(default "") |
|
| 181 | + //echo '<param name="ShowRecordButton" value="false" />'; // default true |
|
| 182 | + // echo '<param name="ShowSaveButton" value="false" />'; //you can save in local computer | (default true) |
|
| 183 | + //echo '<param name="ShowSpeedButton" value="false" />'; // default true |
|
| 184 | + //echo '<param name="ShowAudioLevel" value="false" />'; // it displays the audiometer | (default true) |
|
| 185 | + echo '<param name="ShowTime" value="true" />'; // default false |
|
| 186 | + //echo '<param name="Color" value="#C0E0FF" />'; // default #FFFFFF |
|
| 187 | + //echo '<param name="StartTime" value="10.5" />'; |
|
| 188 | + //echo '<param name="EndTime" value="65" />'; |
|
| 189 | + echo '<param name="AudioFormat" value="ImaADPCM" />';// ImaADPCM (more speed), Speex (more compression)|(default Speex) |
|
| 190 | + //echo '<param name="SamplingRate" value="32000" />';//Quality for ImaADPCM (low 8000, medium 11025, normal 22050, hight 44100) OR Quality for Speex (low 8000, medium 16000, normal 32000, hight 44100) | (default 44100) |
|
| 191 | + //echo '<param name="MaxDuration" value="60" />'; |
|
| 192 | + //echo '<param name="SoundFileURL" value="http://somewhere.com/mysoundfile.wav" />';//load a file |(default "") |
|
| 193 | 193 | echo '</applet>'; |
| 194 | 194 | |
| 195 | 195 | echo '<form name="form_nanogong">'; |
| 196 | - echo '<input placeholder="'.get_lang('InputNameHere').'" type="text" id="audio_title">'; |
|
| 197 | - echo '<input id="status" type="hidden" name="status" value="0">'; |
|
| 198 | - echo '<button class="upload" type="submit" value="'.get_lang('Send').'" onClick="submitVoice()" />'.get_lang('Send').'</button>'; |
|
| 196 | + echo '<input placeholder="'.get_lang('InputNameHere').'" type="text" id="audio_title">'; |
|
| 197 | + echo '<input id="status" type="hidden" name="status" value="0">'; |
|
| 198 | + echo '<button class="upload" type="submit" value="'.get_lang('Send').'" onClick="submitVoice()" />'.get_lang('Send').'</button>'; |
|
| 199 | 199 | echo '</form>'; |
| 200 | 200 | |
| 201 | 201 | echo '</div>'; |
@@ -24,12 +24,12 @@ |
||
| 24 | 24 | unset($_SESSION['temp_realpath_image']); |
| 25 | 25 | |
| 26 | 26 | if (!isset($_SESSION['exit_pixlr'])){ |
| 27 | - $location=api_get_path(WEB_CODE_PATH).'document/document.php'; |
|
| 28 | - echo '<script>window.parent.location.href="'.$location.'"</script>'; |
|
| 29 | - api_not_allowed(true); |
|
| 27 | + $location=api_get_path(WEB_CODE_PATH).'document/document.php'; |
|
| 28 | + echo '<script>window.parent.location.href="'.$location.'"</script>'; |
|
| 29 | + api_not_allowed(true); |
|
| 30 | 30 | } else { |
| 31 | - echo '<div align="center" style="padding-top:150; font-family:Arial, Helvetica, Sans-serif;font-size:25px;color:#aaa;font-weight:bold;">'.get_lang('PleaseStandBy').'</div>'; |
|
| 32 | - $location=api_get_path(WEB_CODE_PATH).'document/document.php?id='.Security::remove_XSS($_SESSION['exit_pixlr']); |
|
| 33 | - echo '<script>window.parent.location.href="'.$location.'"</script>'; |
|
| 34 | - unset($_SESSION['exit_pixlr']); |
|
| 31 | + echo '<div align="center" style="padding-top:150; font-family:Arial, Helvetica, Sans-serif;font-size:25px;color:#aaa;font-weight:bold;">'.get_lang('PleaseStandBy').'</div>'; |
|
| 32 | + $location=api_get_path(WEB_CODE_PATH).'document/document.php?id='.Security::remove_XSS($_SESSION['exit_pixlr']); |
|
| 33 | + echo '<script>window.parent.location.href="'.$location.'"</script>'; |
|
| 34 | + unset($_SESSION['exit_pixlr']); |
|
| 35 | 35 | } |
@@ -15,8 +15,6 @@ discard block |
||
| 15 | 15 | This file has two large sections. |
| 16 | 16 | 1. code that belongs in document.php, but to avoid clutter I put the code here |
| 17 | 17 | 2. the function resize_image that handles the image resizing |
| 18 | - |
|
| 19 | - |
|
| 20 | 18 | * @author Patrick Cool |
| 21 | 19 | * @package chamilo.document |
| 22 | 20 | * @todo convert comments to be understandable to phpDocumentor |
@@ -34,16 +32,16 @@ discard block |
||
| 34 | 32 | * view is also possible when you choose not to resize the source images |
| 35 | 33 | */ |
| 36 | 34 | function resize_image($image, $target_width, $target_height, $slideshow = 0) { |
| 37 | - // Modifications by Ivan Tcholakov, 04-MAY-2009. |
|
| 38 | - $result = array(); |
|
| 39 | - if ( (isset($_SESSION['image_resizing']) && $_SESSION['image_resizing']== 'resizing') or $slideshow == 1) { |
|
| 40 | - $new_sizes = api_resize_image($image, $target_width, $target_height); |
|
| 41 | - $result[] = $new_sizes['height']; |
|
| 42 | - $result[] = $new_sizes['width']; |
|
| 43 | - } else { |
|
| 35 | + // Modifications by Ivan Tcholakov, 04-MAY-2009. |
|
| 36 | + $result = array(); |
|
| 37 | + if ( (isset($_SESSION['image_resizing']) && $_SESSION['image_resizing']== 'resizing') or $slideshow == 1) { |
|
| 38 | + $new_sizes = api_resize_image($image, $target_width, $target_height); |
|
| 39 | + $result[] = $new_sizes['height']; |
|
| 40 | + $result[] = $new_sizes['width']; |
|
| 41 | + } else { |
|
| 44 | 42 | $size = api_getimagesize($image); |
| 45 | - $result[] = $size['height']; |
|
| 46 | - $result[] = $size['width']; |
|
| 47 | - } |
|
| 48 | - return $result; |
|
| 43 | + $result[] = $size['height']; |
|
| 44 | + $result[] = $size['width']; |
|
| 45 | + } |
|
| 46 | + return $result; |
|
| 49 | 47 | } |
@@ -79,81 +79,81 @@ discard block |
||
| 79 | 79 | */ |
| 80 | 80 | if ($from_learnpath == 'yes') |
| 81 | 81 | { |
| 82 | - //start from clear every time in LearnPath Builder |
|
| 83 | - $_SESSION['addedresource'] = null; |
|
| 84 | - $_SESSION['addedresourceid'] = null; |
|
| 85 | - $_SESSION['addedresourceassigned'] = null; |
|
| 86 | - unset ($_SESSION['addedresource']); |
|
| 87 | - unset ($_SESSION['addedresourceid']); |
|
| 88 | - unset ($_SESSION['addedresourceassigned']); |
|
| 82 | + //start from clear every time in LearnPath Builder |
|
| 83 | + $_SESSION['addedresource'] = null; |
|
| 84 | + $_SESSION['addedresourceid'] = null; |
|
| 85 | + $_SESSION['addedresourceassigned'] = null; |
|
| 86 | + unset ($_SESSION['addedresource']); |
|
| 87 | + unset ($_SESSION['addedresourceid']); |
|
| 88 | + unset ($_SESSION['addedresourceassigned']); |
|
| 89 | 89 | } |
| 90 | 90 | |
| 91 | 91 | // Process a new chapter? |
| 92 | 92 | if (!empty ($_POST['add_chapter']) && !empty ($_POST['title'])) |
| 93 | 93 | { |
| 94 | - $title = $_POST['title']; |
|
| 95 | - $description = ''; |
|
| 96 | - if (!empty ($_POST['description'])) |
|
| 97 | - { |
|
| 98 | - $description = $_POST['description']; |
|
| 99 | - } |
|
| 100 | - |
|
| 101 | - // get max display_order so far in this parent chapter |
|
| 102 | - $sql = "SELECT MAX(display_order) FROM $tbl_learnpath_chapter WHERE learnpath_id = $learnpath_id "." AND parent_chapter_id = $chapter_id"; |
|
| 103 | - $res = Database::query($sql); |
|
| 104 | - $row = Database::fetch_array($res); |
|
| 105 | - $max_temp = $row[0]; |
|
| 106 | - |
|
| 107 | - $sql = "SELECT MAX(display_order) FROM $tbl_learnpath_item WHERE "." chapter_id = $chapter_id"; |
|
| 108 | - $res = Database::query($sql); |
|
| 109 | - $row = Database::fetch_array($res); |
|
| 110 | - $max_temp2 = $row[0]; |
|
| 111 | - if ($max_temp2 > $max_temp) |
|
| 112 | - { |
|
| 113 | - $order = $max_temp2 +1; |
|
| 114 | - } |
|
| 115 | - else |
|
| 116 | - { |
|
| 117 | - $order = $max_temp +1; |
|
| 118 | - } |
|
| 119 | - |
|
| 120 | - $sql = "INSERT INTO $tbl_learnpath_chapter "."(learnpath_id,chapter_name,chapter_description,parent_chapter_id,display_order) "." VALUES "."($learnpath_id, '$title', '$description', $chapter_id, $order )"; |
|
| 121 | - $res = Database::query($sql); |
|
| 122 | - if ($res !== false) |
|
| 123 | - { |
|
| 124 | - $title = ''; |
|
| 125 | - $description = ''; |
|
| 126 | - } |
|
| 94 | + $title = $_POST['title']; |
|
| 95 | + $description = ''; |
|
| 96 | + if (!empty ($_POST['description'])) |
|
| 97 | + { |
|
| 98 | + $description = $_POST['description']; |
|
| 99 | + } |
|
| 100 | + |
|
| 101 | + // get max display_order so far in this parent chapter |
|
| 102 | + $sql = "SELECT MAX(display_order) FROM $tbl_learnpath_chapter WHERE learnpath_id = $learnpath_id "." AND parent_chapter_id = $chapter_id"; |
|
| 103 | + $res = Database::query($sql); |
|
| 104 | + $row = Database::fetch_array($res); |
|
| 105 | + $max_temp = $row[0]; |
|
| 106 | + |
|
| 107 | + $sql = "SELECT MAX(display_order) FROM $tbl_learnpath_item WHERE "." chapter_id = $chapter_id"; |
|
| 108 | + $res = Database::query($sql); |
|
| 109 | + $row = Database::fetch_array($res); |
|
| 110 | + $max_temp2 = $row[0]; |
|
| 111 | + if ($max_temp2 > $max_temp) |
|
| 112 | + { |
|
| 113 | + $order = $max_temp2 +1; |
|
| 114 | + } |
|
| 115 | + else |
|
| 116 | + { |
|
| 117 | + $order = $max_temp +1; |
|
| 118 | + } |
|
| 119 | + |
|
| 120 | + $sql = "INSERT INTO $tbl_learnpath_chapter "."(learnpath_id,chapter_name,chapter_description,parent_chapter_id,display_order) "." VALUES "."($learnpath_id, '$title', '$description', $chapter_id, $order )"; |
|
| 121 | + $res = Database::query($sql); |
|
| 122 | + if ($res !== false) |
|
| 123 | + { |
|
| 124 | + $title = ''; |
|
| 125 | + $description = ''; |
|
| 126 | + } |
|
| 127 | 127 | } |
| 128 | 128 | |
| 129 | 129 | // This if when a external link is submitted |
| 130 | 130 | if (!empty ($_POST['external_link_submit'])) |
| 131 | 131 | { |
| 132 | - $add = true; |
|
| 133 | - if ($add_2_links != "niet toevoegen") |
|
| 134 | - { |
|
| 135 | - // add external link to the links table. |
|
| 136 | - $pos = strpos($external_link, 'ttp:'); |
|
| 137 | - if ($pos == '') |
|
| 138 | - { |
|
| 139 | - $external_link = 'http://'.$external_link; |
|
| 140 | - } |
|
| 141 | - |
|
| 142 | - $sql = "INSERT INTO $link_table (url, title, category_id) VALUES ('$external_link','$external_link','$add_2_links')"; |
|
| 143 | - $result = Database::query($sql); |
|
| 144 | - $addedresource[] = "Link"; |
|
| 145 | - $addedresourceid[] = Database::insert_id(); |
|
| 146 | - $_SESSION['addedresource'] = $addedresource; |
|
| 147 | - $_SESSION['addedresourceid'] = $addedresourceid; |
|
| 148 | - } |
|
| 149 | - else |
|
| 150 | - { |
|
| 151 | - // do not add external link to the links table |
|
| 152 | - $addedresource[] = "Externallink"; |
|
| 153 | - $addedresourceid[] = $external_link; |
|
| 154 | - $_SESSION['addedresource'] = $addedresource; |
|
| 155 | - $_SESSION['addedresourceid'] = $addedresourceid; |
|
| 156 | - } |
|
| 132 | + $add = true; |
|
| 133 | + if ($add_2_links != "niet toevoegen") |
|
| 134 | + { |
|
| 135 | + // add external link to the links table. |
|
| 136 | + $pos = strpos($external_link, 'ttp:'); |
|
| 137 | + if ($pos == '') |
|
| 138 | + { |
|
| 139 | + $external_link = 'http://'.$external_link; |
|
| 140 | + } |
|
| 141 | + |
|
| 142 | + $sql = "INSERT INTO $link_table (url, title, category_id) VALUES ('$external_link','$external_link','$add_2_links')"; |
|
| 143 | + $result = Database::query($sql); |
|
| 144 | + $addedresource[] = "Link"; |
|
| 145 | + $addedresourceid[] = Database::insert_id(); |
|
| 146 | + $_SESSION['addedresource'] = $addedresource; |
|
| 147 | + $_SESSION['addedresourceid'] = $addedresourceid; |
|
| 148 | + } |
|
| 149 | + else |
|
| 150 | + { |
|
| 151 | + // do not add external link to the links table |
|
| 152 | + $addedresource[] = "Externallink"; |
|
| 153 | + $addedresourceid[] = $external_link; |
|
| 154 | + $_SESSION['addedresource'] = $addedresource; |
|
| 155 | + $_SESSION['addedresourceid'] = $addedresourceid; |
|
| 156 | + } |
|
| 157 | 157 | } |
| 158 | 158 | |
| 159 | 159 | // loading the session variables into local array |
@@ -163,107 +163,107 @@ discard block |
||
| 163 | 163 | // This is when a resource was added to the session |
| 164 | 164 | if ($add) |
| 165 | 165 | { |
| 166 | - // adding the new variable to the local array |
|
| 167 | - if (empty ($_POST['external_link_submit'])) |
|
| 168 | - { |
|
| 169 | - //that case is already arranged, see upwards |
|
| 170 | - $addedresource[] = $content; |
|
| 171 | - $addedresourceid[] = $add; |
|
| 172 | - } |
|
| 173 | - $addedresourceassigned[] = 0; |
|
| 174 | - |
|
| 175 | - // loading the local array into the session variable |
|
| 176 | - $_SESSION['addedresource'] = $addedresource; |
|
| 177 | - $_SESSION['addedresourceid'] = $addedresourceid; |
|
| 166 | + // adding the new variable to the local array |
|
| 167 | + if (empty ($_POST['external_link_submit'])) |
|
| 168 | + { |
|
| 169 | + //that case is already arranged, see upwards |
|
| 170 | + $addedresource[] = $content; |
|
| 171 | + $addedresourceid[] = $add; |
|
| 172 | + } |
|
| 173 | + $addedresourceassigned[] = 0; |
|
| 174 | + |
|
| 175 | + // loading the local array into the session variable |
|
| 176 | + $_SESSION['addedresource'] = $addedresource; |
|
| 177 | + $_SESSION['addedresourceid'] = $addedresourceid; |
|
| 178 | + |
|
| 179 | + //--------------------------------------- |
|
| 180 | + //we assign to chapters immediately ! |
|
| 181 | + //--------------------------------------- |
|
| 182 | + $resource_added = false; |
|
| 183 | + if ($from_learnpath == 'yes') |
|
| 184 | + { |
|
| 185 | + $i = 0; |
|
| 186 | + //calculating the last order of the items of this chapter |
|
| 187 | + $sql = "SELECT MAX(display_order) FROM $tbl_learnpath_item WHERE chapter_id=$chapter_id"; |
|
| 188 | + $result = Database::query($sql); |
|
| 189 | + if(Database::num_rows($result)==0){ |
|
| 190 | + $lastorder_item = 0; |
|
| 191 | + }else{ |
|
| 192 | + $row = Database::fetch_array($result); |
|
| 193 | + $lastorder_item = ($row[0]); |
|
| 194 | + } |
|
| 195 | + $sql = "SELECT MAX(display_order) FROM $tbl_learnpath_chapter WHERE parent_chapter_id=$chapter_id"; |
|
| 196 | + $result = Database::query($sql); |
|
| 197 | + if(Database::num_rows($result)==0){ |
|
| 198 | + $lastorder_chapter = 0; |
|
| 199 | + }else{ |
|
| 200 | + $row = Database::fetch_array($result); |
|
| 201 | + $lastorder_chapter = ($row[0]); |
|
| 202 | + } |
|
| 203 | + $lastorder = ($lastorder_chapter>$lastorder_item?$lastorder_chapter+1:$lastorder_item+1); |
|
| 178 | 204 | |
| 179 | - //--------------------------------------- |
|
| 180 | - //we assign to chapters immediately ! |
|
| 181 | - //--------------------------------------- |
|
| 182 | - $resource_added = false; |
|
| 183 | - if ($from_learnpath == 'yes') |
|
| 184 | - { |
|
| 185 | - $i = 0; |
|
| 186 | - //calculating the last order of the items of this chapter |
|
| 187 | - $sql = "SELECT MAX(display_order) FROM $tbl_learnpath_item WHERE chapter_id=$chapter_id"; |
|
| 188 | - $result = Database::query($sql); |
|
| 189 | - if(Database::num_rows($result)==0){ |
|
| 190 | - $lastorder_item = 0; |
|
| 191 | - }else{ |
|
| 192 | - $row = Database::fetch_array($result); |
|
| 193 | - $lastorder_item = ($row[0]); |
|
| 194 | - } |
|
| 195 | - $sql = "SELECT MAX(display_order) FROM $tbl_learnpath_chapter WHERE parent_chapter_id=$chapter_id"; |
|
| 196 | - $result = Database::query($sql); |
|
| 197 | - if(Database::num_rows($result)==0){ |
|
| 198 | - $lastorder_chapter = 0; |
|
| 199 | - }else{ |
|
| 200 | - $row = Database::fetch_array($result); |
|
| 201 | - $lastorder_chapter = ($row[0]); |
|
| 202 | - } |
|
| 203 | - $lastorder = ($lastorder_chapter>$lastorder_item?$lastorder_chapter+1:$lastorder_item+1); |
|
| 204 | - |
|
| 205 | - foreach ($addedresource as $addedresource_item) |
|
| 206 | - { |
|
| 207 | - // in the case we added a chapter, add this into the chapters list with the correct parent_id |
|
| 208 | - if ($addedresource_item == "Chap") |
|
| 209 | - { |
|
| 210 | - $sql = "INSERT INTO $tbl_learnpath_chapter ("."'learnpath_id','chapter_name','chapter_description','parent_chapter_id','display_order'".") VALUES (".$learnpath_id.",'".$learnpath_chapter_name."','".$learnpath_chapter_description."',".$chapter_id.",".$lastorder.")"; |
|
| 211 | - Database::query($sql); |
|
| 212 | - } |
|
| 213 | - |
|
| 214 | - if (!$addedresourceassigned[$i]) |
|
| 215 | - { |
|
| 216 | - //not to assign it twice |
|
| 217 | - if ($addedresource_item == "Ass") |
|
| 218 | - { |
|
| 219 | - $addedresource_item = "Assignments"; |
|
| 220 | - } |
|
| 221 | - if ($addedresource_item == "Drop") |
|
| 222 | - { |
|
| 223 | - $addedresource_item = "Dropbox"; |
|
| 224 | - } |
|
| 225 | - if ($addedresource_item == "Intro") |
|
| 226 | - { |
|
| 227 | - $addedresource_item = "Introduction_text"; |
|
| 228 | - } |
|
| 229 | - if ($addedresource_item == "Course_desc") |
|
| 230 | - { |
|
| 231 | - $addedresource_item = "Course_description"; |
|
| 232 | - } |
|
| 233 | - if ($addedresource_item == "Group") |
|
| 234 | - { |
|
| 235 | - $addedresource_item = "Groups"; |
|
| 236 | - } |
|
| 237 | - if ($addedresource_item == "User") |
|
| 238 | - { |
|
| 239 | - $addedresource_item = "Users"; |
|
| 240 | - } |
|
| 241 | - if ($target == '') |
|
| 242 | - { |
|
| 243 | - $target = '_self'; |
|
| 244 | - } |
|
| 245 | - if ($addedresource_item == 'Link') |
|
| 246 | - { |
|
| 247 | - $addedresource_item .= ' '.$target; |
|
| 248 | - } |
|
| 249 | - $sql = "INSERT INTO $tbl_learnpath_item (id, chapter_id, item_type, item_id, display_order) VALUES ( '$autoid', '$chapter_id', '$addedresource_item','$addedresourceid[$i]','".$lastorder."')"; |
|
| 250 | - $result = Database::query($sql); |
|
| 251 | - $addedresourceassigned[$i] = 1; |
|
| 252 | - $resource_added = true; |
|
| 253 | - } |
|
| 254 | - $i ++; |
|
| 255 | - $lastorder ++; |
|
| 256 | - } |
|
| 257 | - //$_SESSION['addedresource']=null; |
|
| 258 | - //$_SESSION['addedresourceid']=null; |
|
| 259 | - // cleaning up the session once again |
|
| 260 | - $_SESSION['addedresource'] = null; |
|
| 261 | - $_SESSION['addedresourceid'] = null; |
|
| 262 | - $_SESSION['addedresourceassigned'] = null; |
|
| 263 | - unset ($_SESSION['addedresource']); |
|
| 264 | - unset ($_SESSION['addedresourceid']); |
|
| 265 | - unset ($_SESSION['addedresourceassigned']); |
|
| 266 | - } |
|
| 205 | + foreach ($addedresource as $addedresource_item) |
|
| 206 | + { |
|
| 207 | + // in the case we added a chapter, add this into the chapters list with the correct parent_id |
|
| 208 | + if ($addedresource_item == "Chap") |
|
| 209 | + { |
|
| 210 | + $sql = "INSERT INTO $tbl_learnpath_chapter ("."'learnpath_id','chapter_name','chapter_description','parent_chapter_id','display_order'".") VALUES (".$learnpath_id.",'".$learnpath_chapter_name."','".$learnpath_chapter_description."',".$chapter_id.",".$lastorder.")"; |
|
| 211 | + Database::query($sql); |
|
| 212 | + } |
|
| 213 | + |
|
| 214 | + if (!$addedresourceassigned[$i]) |
|
| 215 | + { |
|
| 216 | + //not to assign it twice |
|
| 217 | + if ($addedresource_item == "Ass") |
|
| 218 | + { |
|
| 219 | + $addedresource_item = "Assignments"; |
|
| 220 | + } |
|
| 221 | + if ($addedresource_item == "Drop") |
|
| 222 | + { |
|
| 223 | + $addedresource_item = "Dropbox"; |
|
| 224 | + } |
|
| 225 | + if ($addedresource_item == "Intro") |
|
| 226 | + { |
|
| 227 | + $addedresource_item = "Introduction_text"; |
|
| 228 | + } |
|
| 229 | + if ($addedresource_item == "Course_desc") |
|
| 230 | + { |
|
| 231 | + $addedresource_item = "Course_description"; |
|
| 232 | + } |
|
| 233 | + if ($addedresource_item == "Group") |
|
| 234 | + { |
|
| 235 | + $addedresource_item = "Groups"; |
|
| 236 | + } |
|
| 237 | + if ($addedresource_item == "User") |
|
| 238 | + { |
|
| 239 | + $addedresource_item = "Users"; |
|
| 240 | + } |
|
| 241 | + if ($target == '') |
|
| 242 | + { |
|
| 243 | + $target = '_self'; |
|
| 244 | + } |
|
| 245 | + if ($addedresource_item == 'Link') |
|
| 246 | + { |
|
| 247 | + $addedresource_item .= ' '.$target; |
|
| 248 | + } |
|
| 249 | + $sql = "INSERT INTO $tbl_learnpath_item (id, chapter_id, item_type, item_id, display_order) VALUES ( '$autoid', '$chapter_id', '$addedresource_item','$addedresourceid[$i]','".$lastorder."')"; |
|
| 250 | + $result = Database::query($sql); |
|
| 251 | + $addedresourceassigned[$i] = 1; |
|
| 252 | + $resource_added = true; |
|
| 253 | + } |
|
| 254 | + $i ++; |
|
| 255 | + $lastorder ++; |
|
| 256 | + } |
|
| 257 | + //$_SESSION['addedresource']=null; |
|
| 258 | + //$_SESSION['addedresourceid']=null; |
|
| 259 | + // cleaning up the session once again |
|
| 260 | + $_SESSION['addedresource'] = null; |
|
| 261 | + $_SESSION['addedresourceid'] = null; |
|
| 262 | + $_SESSION['addedresourceassigned'] = null; |
|
| 263 | + unset ($_SESSION['addedresource']); |
|
| 264 | + unset ($_SESSION['addedresourceid']); |
|
| 265 | + unset ($_SESSION['addedresourceassigned']); |
|
| 266 | + } |
|
| 267 | 267 | } |
| 268 | 268 | |
| 269 | 269 | /* |
@@ -278,64 +278,64 @@ discard block |
||
| 278 | 278 | */ |
| 279 | 279 | if ($_GET["source_id"]) |
| 280 | 280 | { |
| 281 | - switch ($_GET["source_id"]) |
|
| 282 | - { |
|
| 283 | - case "1" : // coming from Agenda |
|
| 284 | - if ($action == "edit") |
|
| 285 | - { |
|
| 286 | - $url = "../calendar/agenda.php?action=edit&id=49&originalresource=$originalresource"; |
|
| 287 | - } |
|
| 288 | - elseif ($action == "add") |
|
| 289 | - { |
|
| 290 | - $url = "../calendar/agenda.php?action=add&originalresource=$originalresource"; |
|
| 291 | - } |
|
| 292 | - else |
|
| 293 | - { |
|
| 294 | - $url = "../calendar/agenda.php?action=add"; |
|
| 295 | - } |
|
| 296 | - $originaltoolname = get_lang("Agenda"); |
|
| 297 | - $breadcrumbelement = array ("url" => $url, "name" => $originaltoolname); |
|
| 298 | - session_unregister('from_learnpath'); |
|
| 299 | - unset ($from_learnpath); |
|
| 300 | - break; |
|
| 301 | - case "2" : // coming from forum: new topic |
|
| 302 | - $url = "../phpbb/newtopic.php?forum=$source_forum&md5=$md5"; |
|
| 303 | - $originaltoolname = get_lang("ForumAddNewTopic"); |
|
| 304 | - $breadcrumbelement = array ("url" => $url, "name" => $originaltoolname); |
|
| 305 | - session_unregister('from_learnpath'); |
|
| 306 | - unset ($from_learnpath); |
|
| 307 | - break; |
|
| 308 | - case "3" : // coming from forum: edit topic |
|
| 309 | - $url = "../phpbb/editpost.php?post_id=$post_id&topic=$topic&forum=$forum&md5=$md5&originalresource=no"; |
|
| 310 | - $originaltoolname = get_lang("ForumEditTopic"); |
|
| 311 | - $breadcrumbelement = array ("url" => $url, "name" => $originaltoolname); |
|
| 312 | - session_unregister('from_learnpath'); |
|
| 313 | - unset ($from_learnpath); |
|
| 314 | - break; |
|
| 315 | - case "4" : // coming from exercises: edit topic |
|
| 316 | - $url = "../exercice/admin.php?modifyAnswers=$modifyAnswers"; |
|
| 317 | - $originaltoolname = get_lang("ExerciseAnswers"); |
|
| 318 | - $breadcrumbelement = array ("url" => $url, "name" => $originaltoolname); |
|
| 319 | - session_unregister('from_learnpath'); |
|
| 320 | - unset ($from_learnpath); |
|
| 321 | - break; |
|
| 322 | - case "5" : // coming from learning path |
|
| 323 | - $from_learnpath = 'yes'; |
|
| 324 | - Session::write('from_learnpath',$from_learnpath); |
|
| 325 | - break; |
|
| 326 | - /*************************************** end add [email protected] *********************************/ |
|
| 327 | - |
|
| 328 | - } |
|
| 329 | - // We do not come from the learning path. We store the name of the tool & url in a session. |
|
| 330 | - if ($from_learnpath != 'yes') |
|
| 331 | - { |
|
| 332 | - if (!$_SESSION["origintoolurl"] OR $_SESSION["origintoolurl"]<>$interbreadcrumb["url"]) |
|
| 333 | - { |
|
| 334 | - $_SESSION["origintoolurl"] = $breadcrumbelement["url"]; |
|
| 335 | - $_SESSION["origintoolname"] = $breadcrumbelement["name"]; |
|
| 336 | - $interbreadcrumb = ""; |
|
| 337 | - } |
|
| 338 | - } |
|
| 281 | + switch ($_GET["source_id"]) |
|
| 282 | + { |
|
| 283 | + case "1" : // coming from Agenda |
|
| 284 | + if ($action == "edit") |
|
| 285 | + { |
|
| 286 | + $url = "../calendar/agenda.php?action=edit&id=49&originalresource=$originalresource"; |
|
| 287 | + } |
|
| 288 | + elseif ($action == "add") |
|
| 289 | + { |
|
| 290 | + $url = "../calendar/agenda.php?action=add&originalresource=$originalresource"; |
|
| 291 | + } |
|
| 292 | + else |
|
| 293 | + { |
|
| 294 | + $url = "../calendar/agenda.php?action=add"; |
|
| 295 | + } |
|
| 296 | + $originaltoolname = get_lang("Agenda"); |
|
| 297 | + $breadcrumbelement = array ("url" => $url, "name" => $originaltoolname); |
|
| 298 | + session_unregister('from_learnpath'); |
|
| 299 | + unset ($from_learnpath); |
|
| 300 | + break; |
|
| 301 | + case "2" : // coming from forum: new topic |
|
| 302 | + $url = "../phpbb/newtopic.php?forum=$source_forum&md5=$md5"; |
|
| 303 | + $originaltoolname = get_lang("ForumAddNewTopic"); |
|
| 304 | + $breadcrumbelement = array ("url" => $url, "name" => $originaltoolname); |
|
| 305 | + session_unregister('from_learnpath'); |
|
| 306 | + unset ($from_learnpath); |
|
| 307 | + break; |
|
| 308 | + case "3" : // coming from forum: edit topic |
|
| 309 | + $url = "../phpbb/editpost.php?post_id=$post_id&topic=$topic&forum=$forum&md5=$md5&originalresource=no"; |
|
| 310 | + $originaltoolname = get_lang("ForumEditTopic"); |
|
| 311 | + $breadcrumbelement = array ("url" => $url, "name" => $originaltoolname); |
|
| 312 | + session_unregister('from_learnpath'); |
|
| 313 | + unset ($from_learnpath); |
|
| 314 | + break; |
|
| 315 | + case "4" : // coming from exercises: edit topic |
|
| 316 | + $url = "../exercice/admin.php?modifyAnswers=$modifyAnswers"; |
|
| 317 | + $originaltoolname = get_lang("ExerciseAnswers"); |
|
| 318 | + $breadcrumbelement = array ("url" => $url, "name" => $originaltoolname); |
|
| 319 | + session_unregister('from_learnpath'); |
|
| 320 | + unset ($from_learnpath); |
|
| 321 | + break; |
|
| 322 | + case "5" : // coming from learning path |
|
| 323 | + $from_learnpath = 'yes'; |
|
| 324 | + Session::write('from_learnpath',$from_learnpath); |
|
| 325 | + break; |
|
| 326 | + /*************************************** end add [email protected] *********************************/ |
|
| 327 | + |
|
| 328 | + } |
|
| 329 | + // We do not come from the learning path. We store the name of the tool & url in a session. |
|
| 330 | + if ($from_learnpath != 'yes') |
|
| 331 | + { |
|
| 332 | + if (!$_SESSION["origintoolurl"] OR $_SESSION["origintoolurl"]<>$interbreadcrumb["url"]) |
|
| 333 | + { |
|
| 334 | + $_SESSION["origintoolurl"] = $breadcrumbelement["url"]; |
|
| 335 | + $_SESSION["origintoolname"] = $breadcrumbelement["name"]; |
|
| 336 | + $interbreadcrumb = ""; |
|
| 337 | + } |
|
| 338 | + } |
|
| 339 | 339 | |
| 340 | 340 | } |
| 341 | 341 | |
@@ -343,26 +343,26 @@ discard block |
||
| 343 | 343 | // the information from the session. Else we use the information of the learningpath itself. |
| 344 | 344 | if ($from_learnpath != 'yes') |
| 345 | 345 | { |
| 346 | - $nameTools = get_lang('AddResource'); |
|
| 347 | - $interbreadcrumb[] = array ("url" => $_SESSION["origintoolurl"], "name" => $_SESSION["origintoolname"]); |
|
| 346 | + $nameTools = get_lang('AddResource'); |
|
| 347 | + $interbreadcrumb[] = array ("url" => $_SESSION["origintoolurl"], "name" => $_SESSION["origintoolname"]); |
|
| 348 | 348 | } |
| 349 | 349 | else |
| 350 | 350 | { |
| 351 | - $learnpath_select_query = " SELECT * FROM $tbl_learnpath_main |
|
| 351 | + $learnpath_select_query = " SELECT * FROM $tbl_learnpath_main |
|
| 352 | 352 | WHERE learnpath_id=$learnpath_id"; |
| 353 | - $sql_result = Database::query($learnpath_select_query); |
|
| 354 | - $therow = Database::fetch_array($sql_result); |
|
| 353 | + $sql_result = Database::query($learnpath_select_query); |
|
| 354 | + $therow = Database::fetch_array($sql_result); |
|
| 355 | 355 | |
| 356 | - $learnpath_chapter_query = " SELECT * FROM $tbl_learnpath_chapter |
|
| 356 | + $learnpath_chapter_query = " SELECT * FROM $tbl_learnpath_chapter |
|
| 357 | 357 | WHERE (learnpath_id = '$learnpath_id' and id = '$chapter_id')"; |
| 358 | - $sql_result = Database::query($learnpath_chapter_query); |
|
| 359 | - $therow2 = Database::fetch_array($sql_result); |
|
| 358 | + $sql_result = Database::query($learnpath_chapter_query); |
|
| 359 | + $therow2 = Database::fetch_array($sql_result); |
|
| 360 | 360 | |
| 361 | - $from_learnpath = 'yes'; |
|
| 362 | - session_register('from_learnpath'); |
|
| 363 | - $interbreadcrumb[] = array ("url" => "../scorm/scormdocument.php", "name" => get_lang('LearningPath')); |
|
| 364 | - $interbreadcrumb[] = array ("url" => "../learnpath/learnpath_handler.php?learnpath_id=$learnpath_id", "name" => "{$therow['learnpath_name']}"); |
|
| 365 | - $interbreadcrumb[] = array ("url" => api_get_self()."?action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no", "name" => "{$therow2['chapter_name']}"); |
|
| 361 | + $from_learnpath = 'yes'; |
|
| 362 | + session_register('from_learnpath'); |
|
| 363 | + $interbreadcrumb[] = array ("url" => "../scorm/scormdocument.php", "name" => get_lang('LearningPath')); |
|
| 364 | + $interbreadcrumb[] = array ("url" => "../learnpath/learnpath_handler.php?learnpath_id=$learnpath_id", "name" => "{$therow['learnpath_name']}"); |
|
| 365 | + $interbreadcrumb[] = array ("url" => api_get_self()."?action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no", "name" => "{$therow2['chapter_name']}"); |
|
| 366 | 366 | |
| 367 | 367 | } |
| 368 | 368 | |
@@ -380,7 +380,7 @@ discard block |
||
| 380 | 380 | echo "<h3>".$nameTools; |
| 381 | 381 | if ($from_learnpath == 'yes') |
| 382 | 382 | { |
| 383 | - echo get_lang("AddResource")." - {$therow2['chapter_name']}"; |
|
| 383 | + echo get_lang("AddResource")." - {$therow2['chapter_name']}"; |
|
| 384 | 384 | } |
| 385 | 385 | echo "</h3>"; |
| 386 | 386 | |
@@ -393,7 +393,7 @@ discard block |
||
| 393 | 393 | $result_select_active=Database::query($sql_select_active); |
| 394 | 394 | while ($row=Database::fetch_array($result_select_active)) |
| 395 | 395 | { |
| 396 | - $active_modules[]=$row['name']; |
|
| 396 | + $active_modules[]=$row['name']; |
|
| 397 | 397 | } |
| 398 | 398 | |
| 399 | 399 | |
@@ -536,12 +536,12 @@ discard block |
||
| 536 | 536 | |
| 537 | 537 | if ($from_learnpath != 'yes') |
| 538 | 538 | { |
| 539 | - echo "<tr><td> </td></tr>"; |
|
| 540 | - echo "<tr><td><b>".get_lang('ResourcesAdded')." ("; |
|
| 541 | - echo count($addedresource); |
|
| 542 | - echo ")</b></td></tr>"; |
|
| 543 | - echo "<tr><td nowrap><a href=\"".api_get_self()."?showresources=true&action=$action&id=$id&learnpath_id=$learnpath_id&chapter_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang('ShowDelete')."</a>"; |
|
| 544 | - echo "</td></tr>"; |
|
| 539 | + echo "<tr><td> </td></tr>"; |
|
| 540 | + echo "<tr><td><b>".get_lang('ResourcesAdded')." ("; |
|
| 541 | + echo count($addedresource); |
|
| 542 | + echo ")</b></td></tr>"; |
|
| 543 | + echo "<tr><td nowrap><a href=\"".api_get_self()."?showresources=true&action=$action&id=$id&learnpath_id=$learnpath_id&chapter_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang('ShowDelete')."</a>"; |
|
| 544 | + echo "</td></tr>"; |
|
| 545 | 545 | } |
| 546 | 546 | ?> |
| 547 | 547 | <tr> |
@@ -557,11 +557,11 @@ discard block |
||
| 557 | 557 | |
| 558 | 558 | if ($from_learnpath != 'yes') |
| 559 | 559 | { |
| 560 | - echo "<form method=\"post\" action=\"{$_SESSION['origintoolurl']}\" style=\"margin: 0px;\"><input type=\"submit\" value=\"".get_lang('Ok')."\"></form>"; |
|
| 560 | + echo "<form method=\"post\" action=\"{$_SESSION['origintoolurl']}\" style=\"margin: 0px;\"><input type=\"submit\" value=\"".get_lang('Ok')."\"></form>"; |
|
| 561 | 561 | } |
| 562 | 562 | else |
| 563 | 563 | { |
| 564 | - echo "<form method=\"get\" action=\"../learnpath/learnpath_handler.php\" style=\"margin: 0px;\"><input type=\"hidden\" name=\"learnpath_id\" value=\"".htmlentities($learnpath_id)."\"><input type=\"submit\" value=\"".' '.get_lang('Ok').' '."\"></form>"; |
|
| 564 | + echo "<form method=\"get\" action=\"../learnpath/learnpath_handler.php\" style=\"margin: 0px;\"><input type=\"hidden\" name=\"learnpath_id\" value=\"".htmlentities($learnpath_id)."\"><input type=\"submit\" value=\"".' '.get_lang('Ok').' '."\"></form>"; |
|
| 565 | 565 | } |
| 566 | 566 | ?> |
| 567 | 567 | |
@@ -577,40 +577,40 @@ discard block |
||
| 577 | 577 | |
| 578 | 578 | if ($resource_added) |
| 579 | 579 | { |
| 580 | - Display :: display_normal_message(get_lang("ResourceAdded")); |
|
| 580 | + Display :: display_normal_message(get_lang("ResourceAdded")); |
|
| 581 | 581 | } |
| 582 | 582 | |
| 583 | 583 | if ($from_learnpath != 'yes') |
| 584 | 584 | { |
| 585 | - echo count($addedresource)." ".api_strtolower(get_lang('ResourcesAdded'))."<br/>"; |
|
| 585 | + echo count($addedresource)." ".api_strtolower(get_lang('ResourcesAdded'))."<br/>"; |
|
| 586 | 586 | } |
| 587 | 587 | //echo "<hr>"; |
| 588 | 588 | |
| 589 | 589 | // Agenda items --> |
| 590 | 590 | if ($content == "Agenda") |
| 591 | 591 | { |
| 592 | - $TABLEAGENDA = Database::get_course_table(TABLE_AGENDA); |
|
| 593 | - $TABLE_ITEM_PROPERTY = Database::get_course_table(TABLE_ITEM_PROPERTY); |
|
| 592 | + $TABLEAGENDA = Database::get_course_table(TABLE_AGENDA); |
|
| 593 | + $TABLE_ITEM_PROPERTY = Database::get_course_table(TABLE_ITEM_PROPERTY); |
|
| 594 | 594 | |
| 595 | - $sql="SELECT agenda.*, toolitemproperties.* |
|
| 595 | + $sql="SELECT agenda.*, toolitemproperties.* |
|
| 596 | 596 | FROM ".$TABLEAGENDA." agenda, ".$TABLE_ITEM_PROPERTY." toolitemproperties |
| 597 | 597 | WHERE agenda.id = toolitemproperties.ref |
| 598 | 598 | AND toolitemproperties.tool='".TOOL_CALENDAR_EVENT."' |
| 599 | 599 | AND (toolitemproperties.to_group_id='0' OR toolitemproperties.to_group_id IS NULL) |
| 600 | 600 | AND toolitemproperties.visibility='1'"; |
| 601 | 601 | |
| 602 | - $result = Database::query($sql); |
|
| 603 | - |
|
| 604 | - while ($myrow = Database::fetch_array($result)) |
|
| 605 | - { |
|
| 606 | - echo "<table width=\"100%\"><tr><td bgcolor=\"#E6E6E6\">"; |
|
| 607 | - echo "<img src='../img/agenda.gif' alt='agenda'>"; |
|
| 608 | - echo api_convert_and_format_date($myrow["start_date"], null, date_default_timezone_get())."<br />"; |
|
| 609 | - echo "<b>".$myrow["title"]."</b></td></tr><tr><td>"; |
|
| 610 | - echo $myrow["content"]."<br />"; |
|
| 611 | - showorhide_addresourcelink($content, $myrow["id"]); |
|
| 612 | - echo "</td></tr></table><br />"; |
|
| 613 | - } |
|
| 602 | + $result = Database::query($sql); |
|
| 603 | + |
|
| 604 | + while ($myrow = Database::fetch_array($result)) |
|
| 605 | + { |
|
| 606 | + echo "<table width=\"100%\"><tr><td bgcolor=\"#E6E6E6\">"; |
|
| 607 | + echo "<img src='../img/agenda.gif' alt='agenda'>"; |
|
| 608 | + echo api_convert_and_format_date($myrow["start_date"], null, date_default_timezone_get())."<br />"; |
|
| 609 | + echo "<b>".$myrow["title"]."</b></td></tr><tr><td>"; |
|
| 610 | + echo $myrow["content"]."<br />"; |
|
| 611 | + showorhide_addresourcelink($content, $myrow["id"]); |
|
| 612 | + echo "</td></tr></table><br />"; |
|
| 613 | + } |
|
| 614 | 614 | } // end if ($_GET["resource"]=="Agenda") |
| 615 | 615 | |
| 616 | 616 | /* |
@@ -620,12 +620,12 @@ discard block |
||
| 620 | 620 | */ |
| 621 | 621 | if ($content == "chapter") |
| 622 | 622 | { |
| 623 | - echo '<table><form name="add_chapter" action="'.'" method="POST">'."\n"; |
|
| 624 | - echo ' <tr><td>'.get_lang('Title').'</td><td><input type="text" name="title" value="'.$title.'"></input></td></tr>'."\n"; |
|
| 625 | - echo ' <tr><td>'.get_lang('Description').'</td><td><input type="text" name="description" value="'.$description.'"></input></td></tr>'."\n"; |
|
| 626 | - echo ' <tr><td></td><td><input type="submit" name="add_chapter" value="'.get_lang('AddIt').'"/></td></tr>'."\n"; |
|
| 627 | - echo '</form></table>'."\n"; |
|
| 628 | - //echo "<hr>"; |
|
| 623 | + echo '<table><form name="add_chapter" action="'.'" method="POST">'."\n"; |
|
| 624 | + echo ' <tr><td>'.get_lang('Title').'</td><td><input type="text" name="title" value="'.$title.'"></input></td></tr>'."\n"; |
|
| 625 | + echo ' <tr><td>'.get_lang('Description').'</td><td><input type="text" name="description" value="'.$description.'"></input></td></tr>'."\n"; |
|
| 626 | + echo ' <tr><td></td><td><input type="submit" name="add_chapter" value="'.get_lang('AddIt').'"/></td></tr>'."\n"; |
|
| 627 | + echo '</form></table>'."\n"; |
|
| 628 | + //echo "<hr>"; |
|
| 629 | 629 | } |
| 630 | 630 | |
| 631 | 631 | /* |
@@ -640,23 +640,23 @@ discard block |
||
| 640 | 640 | // b. one is a student AND the documents tool is active. Student cannot add documents if the documents tool is inactive (teacher can do this) |
| 641 | 641 | if ($content == "Document" OR (empty($content) AND (api_is_allowed_to_edit() OR in_array(TOOL_DOCUMENT,$active_modules))) AND !$_GET['showresources']) |
| 642 | 642 | { |
| 643 | - // setting variables for file locations |
|
| 644 | - $baseServDir = $_configuration['root_sys']; |
|
| 645 | - $courseDir = $_course['path']."/document"; |
|
| 646 | - $baseWorkDir = $baseServDir.$courseDir; |
|
| 647 | - // showing the link to move one folder up (when not in the root folder) |
|
| 648 | - show_folder_up(); |
|
| 649 | - // showing the blue bar with the path in it when we are not in the root |
|
| 650 | - if (get_levels($folder)) |
|
| 651 | - { |
|
| 652 | - echo "<table width=\"100%\"><tr><td bgcolor=\"#4171B5\">"; |
|
| 653 | - echo "<img src=\"../img/opendir.gif\" alt='directory'><font color=\"#ffffff\"><b>"; |
|
| 654 | - echo $folder."</b></font></td></tr></table>"; |
|
| 655 | - } |
|
| 656 | - |
|
| 657 | - // showing the documents and subfolders of the folder we are in. |
|
| 658 | - show_documents($folder); |
|
| 659 | - //echo "<hr>"; |
|
| 643 | + // setting variables for file locations |
|
| 644 | + $baseServDir = $_configuration['root_sys']; |
|
| 645 | + $courseDir = $_course['path']."/document"; |
|
| 646 | + $baseWorkDir = $baseServDir.$courseDir; |
|
| 647 | + // showing the link to move one folder up (when not in the root folder) |
|
| 648 | + show_folder_up(); |
|
| 649 | + // showing the blue bar with the path in it when we are not in the root |
|
| 650 | + if (get_levels($folder)) |
|
| 651 | + { |
|
| 652 | + echo "<table width=\"100%\"><tr><td bgcolor=\"#4171B5\">"; |
|
| 653 | + echo "<img src=\"../img/opendir.gif\" alt='directory'><font color=\"#ffffff\"><b>"; |
|
| 654 | + echo $folder."</b></font></td></tr></table>"; |
|
| 655 | + } |
|
| 656 | + |
|
| 657 | + // showing the documents and subfolders of the folder we are in. |
|
| 658 | + show_documents($folder); |
|
| 659 | + //echo "<hr>"; |
|
| 660 | 660 | } |
| 661 | 661 | |
| 662 | 662 | /* |
@@ -666,8 +666,8 @@ discard block |
||
| 666 | 666 | */ |
| 667 | 667 | if ($content == "Ad_Valvas") |
| 668 | 668 | { |
| 669 | - $tbl_announcement = Database :: get_course_table(TABLE_ANNOUNCEMENT); |
|
| 670 | - $sql = "SELECT * FROM ".$tbl_announcement." a, ".$item_property_table." i |
|
| 669 | + $tbl_announcement = Database :: get_course_table(TABLE_ANNOUNCEMENT); |
|
| 670 | + $sql = "SELECT * FROM ".$tbl_announcement." a, ".$item_property_table." i |
|
| 671 | 671 | WHERE |
| 672 | 672 | i.tool = '".TOOL_ANNOUNCEMENT."' AND |
| 673 | 673 | a.id=i.ref AND |
@@ -676,17 +676,17 @@ discard block |
||
| 676 | 676 | i.to_user_id IS NULL |
| 677 | 677 | ORDER BY a.display_order ASC"; |
| 678 | 678 | |
| 679 | - $result = Database::query($sql); |
|
| 680 | - while ($myrow = Database::fetch_array($result)) |
|
| 681 | - { |
|
| 682 | - echo "<table width=\"100%\"><tr><td>"; |
|
| 683 | - echo "<img src='../img/valves.gif' alt='advalvas'>"; |
|
| 684 | - echo api_convert_and_format_date($myrow["end_date"], DATE_FORMAT_LONG, date_default_timezone_get()); |
|
| 685 | - echo "</td></tr><tr><td>"; |
|
| 686 | - echo $myrow["title"]."<br />"; |
|
| 687 | - showorhide_addresourcelink($content, $myrow["id"]); |
|
| 688 | - echo "</td></tr></table>"; |
|
| 689 | - } |
|
| 679 | + $result = Database::query($sql); |
|
| 680 | + while ($myrow = Database::fetch_array($result)) |
|
| 681 | + { |
|
| 682 | + echo "<table width=\"100%\"><tr><td>"; |
|
| 683 | + echo "<img src='../img/valves.gif' alt='advalvas'>"; |
|
| 684 | + echo api_convert_and_format_date($myrow["end_date"], DATE_FORMAT_LONG, date_default_timezone_get()); |
|
| 685 | + echo "</td></tr><tr><td>"; |
|
| 686 | + echo $myrow["title"]."<br />"; |
|
| 687 | + showorhide_addresourcelink($content, $myrow["id"]); |
|
| 688 | + echo "</td></tr></table>"; |
|
| 689 | + } |
|
| 690 | 690 | } |
| 691 | 691 | |
| 692 | 692 | /* |
@@ -696,75 +696,75 @@ discard block |
||
| 696 | 696 | */ |
| 697 | 697 | if ($content == "Forum") |
| 698 | 698 | { |
| 699 | - $TBL_FORUMS = Database::get_course_table(TABLE_FORUM); |
|
| 700 | - $TBL_CATAGORIES = Database::get_course_table(TABLE_FORUM_CATEGORY); |
|
| 701 | - $TBL_FORUMTOPICS = Database::get_course_table(TABLE_FORUM_POST); |
|
| 702 | - $tbl_posts = Database::get_course_table(TABLE_FORUM_POST); |
|
| 703 | - $tbl_posts_text = Database::get_course_table(TOOL_FORUM_POST_TEXT_TABLE); |
|
| 704 | - |
|
| 705 | - echo "<table width='100%'>"; |
|
| 699 | + $TBL_FORUMS = Database::get_course_table(TABLE_FORUM); |
|
| 700 | + $TBL_CATAGORIES = Database::get_course_table(TABLE_FORUM_CATEGORY); |
|
| 701 | + $TBL_FORUMTOPICS = Database::get_course_table(TABLE_FORUM_POST); |
|
| 702 | + $tbl_posts = Database::get_course_table(TABLE_FORUM_POST); |
|
| 703 | + $tbl_posts_text = Database::get_course_table(TOOL_FORUM_POST_TEXT_TABLE); |
|
| 704 | + |
|
| 705 | + echo "<table width='100%'>"; |
|
| 706 | + |
|
| 707 | + // displaying the categories and the forums |
|
| 708 | + if (!$forum and !$thread) |
|
| 709 | + { |
|
| 710 | + $sql = "SELECT * FROM ".$TBL_FORUMS." forums, ".$TBL_CATAGORIES." categories WHERE forums.cat_id=categories.cat_id ORDER BY forums.cat_id DESC"; |
|
| 711 | + $result = Database::query($sql); |
|
| 712 | + while ($myrow = Database::fetch_array($result)) |
|
| 713 | + { |
|
| 714 | + if ($myrow["cat_title"] !== $old_cat_title) |
|
| 715 | + { |
|
| 716 | + echo "<tr><td bgcolor='#4171B5' colspan='2'><font color='white'><b>".$myrow["cat_title"]."</b></font></td></tr>"; |
|
| 717 | + } |
|
| 718 | + $old_cat_title = $myrow["cat_title"]; |
|
| 719 | + echo "<tr><td><img src='../img/forum.gif'><a href='".api_get_self()."?content=Forum&category=".$myrow["cat_id"]."&forum=".$myrow["forum_id"]."&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".$myrow["forum_name"]."</td><td>"; |
|
| 720 | + showorhide_addresourcelink("Forum", $myrow["forum_id"]); |
|
| 721 | + echo "</td></tr>"; |
|
| 722 | + } |
|
| 723 | + } |
|
| 724 | + //displaying all the threads of one forum |
|
| 725 | + if ($forum) |
|
| 726 | + { |
|
| 727 | + // displaying the category title |
|
| 728 | + $sql = "SELECT * FROM ".$TBL_CATAGORIES." WHERE cat_id=$category"; |
|
| 729 | + $result = Database::query($sql); |
|
| 730 | + $myrow = Database::fetch_array($result); |
|
| 731 | + echo "<tr><td bgcolor='#4171B5' colspan='2'><font color='white'><b>".$myrow["cat_title"]."</b></font></td></tr>"; |
|
| 732 | + |
|
| 733 | + // displaying the forum title |
|
| 734 | + $sql = "SELECT * FROM ".$TBL_FORUMS." forums, ".$TBL_FORUMTOPICS." topics WHERE forums.forum_id=topics.forum_id"; |
|
| 735 | + $result = Database::query($sql); |
|
| 736 | + $myrow = Database::fetch_array($result); |
|
| 737 | + echo "<tr><td bgcolor='#cccccc' colspan='2'><b>".$myrow["forum_name"]."</b></td></tr>"; |
|
| 738 | + |
|
| 739 | + if (!$thread) |
|
| 740 | + { |
|
| 741 | + // displaying all the threads of this forum |
|
| 742 | + $sql = "SELECT * FROM ".$TBL_FORUMTOPICS." WHERE forum_id=$forum"; |
|
| 743 | + $result = Database::query($sql); |
|
| 744 | + while ($myrow = Database::fetch_array($result)) |
|
| 745 | + { |
|
| 746 | + echo "<tr><td><a href='".api_get_self()."?content=Forum&category=$category&forum=1&thread=".$myrow["topic_id"]."&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".$myrow["topic_title"]."</a> (".$myrow["prenom"]." ".$myrow["nom"].")</td><td>"; |
|
| 747 | + showorhide_addresourcelink("Thread", $myrow["topic_id"]); |
|
| 748 | + echo "</td></tr>"; |
|
| 749 | + } |
|
| 750 | + } |
|
| 751 | + else |
|
| 752 | + { |
|
| 753 | + // displaying all the replies |
|
| 754 | + $sql = "SELECT * FROM ".$tbl_posts." post, ".$tbl_posts_text." post_text WHERE post_text.post_id=post.post_id and post.topic_id=$thread ORDER BY post_text.post_id ASC"; |
|
| 755 | + $result = Database::query($sql); |
|
| 756 | + while ($myrow = Database::fetch_array($result)) |
|
| 757 | + { |
|
| 758 | + echo "<tr><td><b>".$myrow["post_title"]."</b><br>"; |
|
| 759 | + echo $myrow["post_text"]."</td>"; |
|
| 760 | + echo "<td>"; |
|
| 761 | + showorhide_addresourcelink("Post", $myrow["post_id"]); |
|
| 762 | + echo "</td></tr><tr><td colspan='2'><hr noshade></td></tr>"; |
|
| 763 | + } |
|
| 706 | 764 | |
| 707 | - // displaying the categories and the forums |
|
| 708 | - if (!$forum and !$thread) |
|
| 709 | - { |
|
| 710 | - $sql = "SELECT * FROM ".$TBL_FORUMS." forums, ".$TBL_CATAGORIES." categories WHERE forums.cat_id=categories.cat_id ORDER BY forums.cat_id DESC"; |
|
| 711 | - $result = Database::query($sql); |
|
| 712 | - while ($myrow = Database::fetch_array($result)) |
|
| 713 | - { |
|
| 714 | - if ($myrow["cat_title"] !== $old_cat_title) |
|
| 715 | - { |
|
| 716 | - echo "<tr><td bgcolor='#4171B5' colspan='2'><font color='white'><b>".$myrow["cat_title"]."</b></font></td></tr>"; |
|
| 717 | - } |
|
| 718 | - $old_cat_title = $myrow["cat_title"]; |
|
| 719 | - echo "<tr><td><img src='../img/forum.gif'><a href='".api_get_self()."?content=Forum&category=".$myrow["cat_id"]."&forum=".$myrow["forum_id"]."&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".$myrow["forum_name"]."</td><td>"; |
|
| 720 | - showorhide_addresourcelink("Forum", $myrow["forum_id"]); |
|
| 721 | - echo "</td></tr>"; |
|
| 722 | - } |
|
| 723 | - } |
|
| 724 | - //displaying all the threads of one forum |
|
| 725 | - if ($forum) |
|
| 726 | - { |
|
| 727 | - // displaying the category title |
|
| 728 | - $sql = "SELECT * FROM ".$TBL_CATAGORIES." WHERE cat_id=$category"; |
|
| 729 | - $result = Database::query($sql); |
|
| 730 | - $myrow = Database::fetch_array($result); |
|
| 731 | - echo "<tr><td bgcolor='#4171B5' colspan='2'><font color='white'><b>".$myrow["cat_title"]."</b></font></td></tr>"; |
|
| 732 | - |
|
| 733 | - // displaying the forum title |
|
| 734 | - $sql = "SELECT * FROM ".$TBL_FORUMS." forums, ".$TBL_FORUMTOPICS." topics WHERE forums.forum_id=topics.forum_id"; |
|
| 735 | - $result = Database::query($sql); |
|
| 736 | - $myrow = Database::fetch_array($result); |
|
| 737 | - echo "<tr><td bgcolor='#cccccc' colspan='2'><b>".$myrow["forum_name"]."</b></td></tr>"; |
|
| 738 | - |
|
| 739 | - if (!$thread) |
|
| 740 | - { |
|
| 741 | - // displaying all the threads of this forum |
|
| 742 | - $sql = "SELECT * FROM ".$TBL_FORUMTOPICS." WHERE forum_id=$forum"; |
|
| 743 | - $result = Database::query($sql); |
|
| 744 | - while ($myrow = Database::fetch_array($result)) |
|
| 745 | - { |
|
| 746 | - echo "<tr><td><a href='".api_get_self()."?content=Forum&category=$category&forum=1&thread=".$myrow["topic_id"]."&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".$myrow["topic_title"]."</a> (".$myrow["prenom"]." ".$myrow["nom"].")</td><td>"; |
|
| 747 | - showorhide_addresourcelink("Thread", $myrow["topic_id"]); |
|
| 748 | - echo "</td></tr>"; |
|
| 749 | - } |
|
| 750 | - } |
|
| 751 | - else |
|
| 752 | - { |
|
| 753 | - // displaying all the replies |
|
| 754 | - $sql = "SELECT * FROM ".$tbl_posts." post, ".$tbl_posts_text." post_text WHERE post_text.post_id=post.post_id and post.topic_id=$thread ORDER BY post_text.post_id ASC"; |
|
| 755 | - $result = Database::query($sql); |
|
| 756 | - while ($myrow = Database::fetch_array($result)) |
|
| 757 | - { |
|
| 758 | - echo "<tr><td><b>".$myrow["post_title"]."</b><br>"; |
|
| 759 | - echo $myrow["post_text"]."</td>"; |
|
| 760 | - echo "<td>"; |
|
| 761 | - showorhide_addresourcelink("Post", $myrow["post_id"]); |
|
| 762 | - echo "</td></tr><tr><td colspan='2'><hr noshade></td></tr>"; |
|
| 763 | - } |
|
| 764 | - |
|
| 765 | - } |
|
| 766 | - } |
|
| 767 | - echo "</table>"; |
|
| 765 | + } |
|
| 766 | + } |
|
| 767 | + echo "</table>"; |
|
| 768 | 768 | } |
| 769 | 769 | |
| 770 | 770 | /* |
@@ -774,57 +774,57 @@ discard block |
||
| 774 | 774 | */ |
| 775 | 775 | if ($content == "Link") |
| 776 | 776 | { |
| 777 | - // including the links language file |
|
| 778 | - include ("../lang/$language/link.inc.php"); |
|
| 779 | - |
|
| 780 | - $tbl_categories = Database::get_course_table(TABLE_LINK_CATEGORY); |
|
| 781 | - if (($learnpath_id != '') and ($content == 'Link')) |
|
| 782 | - { |
|
| 783 | - echo "<form name='learnpath_link'><table>"; |
|
| 784 | - echo "<tr></td><td align='left'>".get_lang('LinkTarget')." :</td><td align='left'><select name='target' onchange='targetfunc()'><option value='_self' "; |
|
| 785 | - if ($target == '_self') |
|
| 786 | - { |
|
| 787 | - echo "selected"; |
|
| 788 | - } |
|
| 789 | - echo ">".get_lang('SameWindow')."</option><option value='_blank'"; |
|
| 790 | - if ($target == '_blank') |
|
| 791 | - { |
|
| 792 | - echo "selected"; |
|
| 793 | - } |
|
| 794 | - echo ">".get_lang('NewWindow')."</option></select></td></tr></table></form>"; |
|
| 795 | - } |
|
| 796 | - |
|
| 797 | - // showing the links that are in the root (having no category) |
|
| 798 | - $sql = "SELECT * FROM ".$link_table." l, ".$item_property_table." ip WHERE (l.category_id=0 or l.category_id IS NULL) AND ip.tool = '".TOOL_LINK."' AND l.id=ip.ref AND ip.visibility='1'"; |
|
| 799 | - $result = Database::query($sql); |
|
| 800 | - if (Database::num_rows($result) > 0) |
|
| 801 | - { |
|
| 802 | - echo "<table width=\"100%\"><tr><td bgcolor=\"#E6E6E6\"><i>".get_lang('NoCategory')."</i></td></tr></table>"; |
|
| 803 | - while ($myrow = Database::fetch_array($result)) |
|
| 804 | - { |
|
| 805 | - echo "<img src='../img/links.gif'>".$myrow["title"]; |
|
| 806 | - echo "<br>"; |
|
| 807 | - showorhide_addresourcelink($content, $myrow["id"]); |
|
| 808 | - echo "<br><br>"; |
|
| 809 | - } |
|
| 810 | - } |
|
| 811 | - |
|
| 812 | - // showing the categories and the links in it. |
|
| 813 | - $sqlcategories = "SELECT * FROM ".$tbl_categories." ORDER by display_order DESC"; |
|
| 814 | - $resultcategories = Database::query($sqlcategories) or die; |
|
| 815 | - while ($myrow = @ Database::fetch_array($resultcategories)) |
|
| 816 | - { |
|
| 817 | - $sql_links = "SELECT * FROM ".$link_table." l, ".$item_property_table." ip WHERE l.category_id='".$myrow["id"]."' AND ip.tool = '".TOOL_LINK."' AND l.id=ip.ref AND ip.visibility='1' ORDER BY l.display_order DESC"; |
|
| 818 | - echo "<table width=\"100%\"><tr><td bgcolor=\"#E6E6E6\"><i>".$myrow["category_title"]."</i></td></tr></table>"; |
|
| 819 | - $result_links = Database::query($sql_links); |
|
| 820 | - while ($myrow = Database::fetch_array($result_links)) |
|
| 821 | - { |
|
| 822 | - echo "<img src='../img/links.gif' />".$myrow["title"]; |
|
| 823 | - echo "<br>"; |
|
| 824 | - showorhide_addresourcelink($content, $myrow["id"]); |
|
| 825 | - echo "<br><br>"; |
|
| 826 | - } |
|
| 827 | - } |
|
| 777 | + // including the links language file |
|
| 778 | + include ("../lang/$language/link.inc.php"); |
|
| 779 | + |
|
| 780 | + $tbl_categories = Database::get_course_table(TABLE_LINK_CATEGORY); |
|
| 781 | + if (($learnpath_id != '') and ($content == 'Link')) |
|
| 782 | + { |
|
| 783 | + echo "<form name='learnpath_link'><table>"; |
|
| 784 | + echo "<tr></td><td align='left'>".get_lang('LinkTarget')." :</td><td align='left'><select name='target' onchange='targetfunc()'><option value='_self' "; |
|
| 785 | + if ($target == '_self') |
|
| 786 | + { |
|
| 787 | + echo "selected"; |
|
| 788 | + } |
|
| 789 | + echo ">".get_lang('SameWindow')."</option><option value='_blank'"; |
|
| 790 | + if ($target == '_blank') |
|
| 791 | + { |
|
| 792 | + echo "selected"; |
|
| 793 | + } |
|
| 794 | + echo ">".get_lang('NewWindow')."</option></select></td></tr></table></form>"; |
|
| 795 | + } |
|
| 796 | + |
|
| 797 | + // showing the links that are in the root (having no category) |
|
| 798 | + $sql = "SELECT * FROM ".$link_table." l, ".$item_property_table." ip WHERE (l.category_id=0 or l.category_id IS NULL) AND ip.tool = '".TOOL_LINK."' AND l.id=ip.ref AND ip.visibility='1'"; |
|
| 799 | + $result = Database::query($sql); |
|
| 800 | + if (Database::num_rows($result) > 0) |
|
| 801 | + { |
|
| 802 | + echo "<table width=\"100%\"><tr><td bgcolor=\"#E6E6E6\"><i>".get_lang('NoCategory')."</i></td></tr></table>"; |
|
| 803 | + while ($myrow = Database::fetch_array($result)) |
|
| 804 | + { |
|
| 805 | + echo "<img src='../img/links.gif'>".$myrow["title"]; |
|
| 806 | + echo "<br>"; |
|
| 807 | + showorhide_addresourcelink($content, $myrow["id"]); |
|
| 808 | + echo "<br><br>"; |
|
| 809 | + } |
|
| 810 | + } |
|
| 811 | + |
|
| 812 | + // showing the categories and the links in it. |
|
| 813 | + $sqlcategories = "SELECT * FROM ".$tbl_categories." ORDER by display_order DESC"; |
|
| 814 | + $resultcategories = Database::query($sqlcategories) or die; |
|
| 815 | + while ($myrow = @ Database::fetch_array($resultcategories)) |
|
| 816 | + { |
|
| 817 | + $sql_links = "SELECT * FROM ".$link_table." l, ".$item_property_table." ip WHERE l.category_id='".$myrow["id"]."' AND ip.tool = '".TOOL_LINK."' AND l.id=ip.ref AND ip.visibility='1' ORDER BY l.display_order DESC"; |
|
| 818 | + echo "<table width=\"100%\"><tr><td bgcolor=\"#E6E6E6\"><i>".$myrow["category_title"]."</i></td></tr></table>"; |
|
| 819 | + $result_links = Database::query($sql_links); |
|
| 820 | + while ($myrow = Database::fetch_array($result_links)) |
|
| 821 | + { |
|
| 822 | + echo "<img src='../img/links.gif' />".$myrow["title"]; |
|
| 823 | + echo "<br>"; |
|
| 824 | + showorhide_addresourcelink($content, $myrow["id"]); |
|
| 825 | + echo "<br><br>"; |
|
| 826 | + } |
|
| 827 | + } |
|
| 828 | 828 | } |
| 829 | 829 | |
| 830 | 830 | /* |
@@ -834,31 +834,31 @@ discard block |
||
| 834 | 834 | */ |
| 835 | 835 | if (($content == "Exercise") or ($content == "HotPotatoes")) |
| 836 | 836 | { |
| 837 | - $TBL_EXERCICES = Database::get_course_table(TABLE_QUIZ_TEST); |
|
| 838 | - $result = Database::query("SELECT * FROM ".$TBL_EXERCICES." WHERE active='1' ORDER BY id ASC"); |
|
| 839 | - while ($myrow = Database::fetch_array($result)) |
|
| 840 | - { |
|
| 841 | - echo "<img src='../img/quiz.gif'>".$myrow["title"]."<br>"; |
|
| 842 | - showorhide_addresourcelink($content, $myrow["id"]); |
|
| 843 | - echo "<br><br>"; |
|
| 844 | - } |
|
| 837 | + $TBL_EXERCICES = Database::get_course_table(TABLE_QUIZ_TEST); |
|
| 838 | + $result = Database::query("SELECT * FROM ".$TBL_EXERCICES." WHERE active='1' ORDER BY id ASC"); |
|
| 839 | + while ($myrow = Database::fetch_array($result)) |
|
| 840 | + { |
|
| 841 | + echo "<img src='../img/quiz.gif'>".$myrow["title"]."<br>"; |
|
| 842 | + showorhide_addresourcelink($content, $myrow["id"]); |
|
| 843 | + echo "<br><br>"; |
|
| 844 | + } |
|
| 845 | + |
|
| 846 | + if ($from_learnpath == 'yes') |
|
| 847 | + { |
|
| 848 | + $uploadPath = "/HotPotatoes_files"; |
|
| 849 | + $TBL_DOCUMENT = Database::get_course_table(TABLE_DOCUMENT); |
|
| 850 | + $documentPath = api_get_path(SYS_COURSE_PATH).$_course['path'].'/document'; |
|
| 851 | + $sql = "SELECT * FROM ".$TBL_DOCUMENT." WHERE (path LIKE '%htm%' OR path LIKE '%html%') AND path LIKE '".$uploadPath."/%/%' ORDER BY id ASC"; |
|
| 852 | + $result = Database::query($sql); |
|
| 853 | + while ($myrow = Database::fetch_array($result)) |
|
| 854 | + { |
|
| 855 | + $path = $myrow["path"]; |
|
| 856 | + echo "<img src='../img/jqz.gif'>".GetQuizName($path, $documentPath)."<br>"; |
|
| 857 | + showorhide_addresourcelink("HotPotatoes", $myrow["id"]); |
|
| 858 | + echo "<br><br>"; |
|
| 845 | 859 | |
| 846 | - if ($from_learnpath == 'yes') |
|
| 847 | - { |
|
| 848 | - $uploadPath = "/HotPotatoes_files"; |
|
| 849 | - $TBL_DOCUMENT = Database::get_course_table(TABLE_DOCUMENT); |
|
| 850 | - $documentPath = api_get_path(SYS_COURSE_PATH).$_course['path'].'/document'; |
|
| 851 | - $sql = "SELECT * FROM ".$TBL_DOCUMENT." WHERE (path LIKE '%htm%' OR path LIKE '%html%') AND path LIKE '".$uploadPath."/%/%' ORDER BY id ASC"; |
|
| 852 | - $result = Database::query($sql); |
|
| 853 | - while ($myrow = Database::fetch_array($result)) |
|
| 854 | - { |
|
| 855 | - $path = $myrow["path"]; |
|
| 856 | - echo "<img src='../img/jqz.gif'>".GetQuizName($path, $documentPath)."<br>"; |
|
| 857 | - showorhide_addresourcelink("HotPotatoes", $myrow["id"]); |
|
| 858 | - echo "<br><br>"; |
|
| 859 | - |
|
| 860 | - } |
|
| 861 | - } |
|
| 860 | + } |
|
| 861 | + } |
|
| 862 | 862 | } |
| 863 | 863 | |
| 864 | 864 | /* |
@@ -876,10 +876,10 @@ discard block |
||
| 876 | 876 | <td align="left"><input name="external_link" type="text" id="external_link" value="http://"></td> |
| 877 | 877 | <?php |
| 878 | 878 | |
| 879 | - if ($learnpath_id != '') |
|
| 880 | - { |
|
| 881 | - echo "</tr><tr><td align='right'>".get_lang('LinkTarget')." :</td><td align='left'><select name='target'><option value='_self'>".get_lang('SameWindow')."</option><option value='_blank'>".get_lang('NewWindow')."</option></select></td>"; |
|
| 882 | - } |
|
| 879 | + if ($learnpath_id != '') |
|
| 880 | + { |
|
| 881 | + echo "</tr><tr><td align='right'>".get_lang('LinkTarget')." :</td><td align='left'><select name='target'><option value='_self'>".get_lang('SameWindow')."</option><option value='_blank'>".get_lang('NewWindow')."</option></select></td>"; |
|
| 882 | + } |
|
| 883 | 883 | ?> |
| 884 | 884 | </tr> |
| 885 | 885 | <tr> |
@@ -891,14 +891,14 @@ discard block |
||
| 891 | 891 | <option value="0"><?php echo get_lang('MainCategory'); ?></option> |
| 892 | 892 | <?php |
| 893 | 893 | |
| 894 | - $tbl_categories = Database::get_course_table(TABLE_LINK_CATEGORY); |
|
| 895 | - $sql = "SELECT * FROM $tbl_categories ORDER BY display_order ASC"; |
|
| 896 | - echo $sql; |
|
| 897 | - $result = Database::query($sql); |
|
| 898 | - while ($row = Database::fetch_array($result)) |
|
| 899 | - { |
|
| 900 | - echo "<option value='".$row["id"]."'>".$row["category_title"]."</option>"; |
|
| 901 | - } |
|
| 894 | + $tbl_categories = Database::get_course_table(TABLE_LINK_CATEGORY); |
|
| 895 | + $sql = "SELECT * FROM $tbl_categories ORDER BY display_order ASC"; |
|
| 896 | + echo $sql; |
|
| 897 | + $result = Database::query($sql); |
|
| 898 | + while ($row = Database::fetch_array($result)) |
|
| 899 | + { |
|
| 900 | + echo "<option value='".$row["id"]."'>".$row["category_title"]."</option>"; |
|
| 901 | + } |
|
| 902 | 902 | ?> |
| 903 | 903 | |
| 904 | 904 | </select><?php } ?></td> |
@@ -927,7 +927,7 @@ discard block |
||
| 927 | 927 | */ |
| 928 | 928 | if ($content == "Assignment") |
| 929 | 929 | { |
| 930 | - echo "<a href=".api_get_self()."?content=Ass&add=Ass&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no>".get_lang('AddAssignmentPage')."</a>"; |
|
| 930 | + echo "<a href=".api_get_self()."?content=Ass&add=Ass&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no>".get_lang('AddAssignmentPage')."</a>"; |
|
| 931 | 931 | } |
| 932 | 932 | |
| 933 | 933 | /* |
@@ -937,7 +937,7 @@ discard block |
||
| 937 | 937 | */ |
| 938 | 938 | if ($content == "Dropbox") |
| 939 | 939 | { |
| 940 | - echo "<a href='".api_get_self()."?content=Drop&add=Drop&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".get_lang('DropboxAdd')."</a>"; |
|
| 940 | + echo "<a href='".api_get_self()."?content=Drop&add=Drop&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".get_lang('DropboxAdd')."</a>"; |
|
| 941 | 941 | } |
| 942 | 942 | |
| 943 | 943 | /* |
@@ -947,7 +947,7 @@ discard block |
||
| 947 | 947 | */ |
| 948 | 948 | if ($content == "Introduction_text") |
| 949 | 949 | { |
| 950 | - echo "<a href='".api_get_self()."?content=Intro&add=Intro&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".get_lang('IntroductionTextAdd')."</a>"; |
|
| 950 | + echo "<a href='".api_get_self()."?content=Intro&add=Intro&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".get_lang('IntroductionTextAdd')."</a>"; |
|
| 951 | 951 | } |
| 952 | 952 | |
| 953 | 953 | /* |
@@ -957,7 +957,7 @@ discard block |
||
| 957 | 957 | */ |
| 958 | 958 | if ($content == "Course_description") |
| 959 | 959 | { |
| 960 | - echo "<a href='".api_get_self()."?content=Course_desc&add=Course_desc&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".get_lang('CourseDescriptionAdd')."</a>"; |
|
| 960 | + echo "<a href='".api_get_self()."?content=Course_desc&add=Course_desc&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".get_lang('CourseDescriptionAdd')."</a>"; |
|
| 961 | 961 | } |
| 962 | 962 | |
| 963 | 963 | /* |
@@ -967,7 +967,7 @@ discard block |
||
| 967 | 967 | */ |
| 968 | 968 | if ($content == "Groups") |
| 969 | 969 | { |
| 970 | - echo "<a href='".api_get_self()."?content=Group&add=Group&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".get_lang('$GroupsAdd')."</a>"; |
|
| 970 | + echo "<a href='".api_get_self()."?content=Group&add=Group&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".get_lang('$GroupsAdd')."</a>"; |
|
| 971 | 971 | } |
| 972 | 972 | |
| 973 | 973 | /* |
@@ -977,13 +977,13 @@ discard block |
||
| 977 | 977 | */ |
| 978 | 978 | if ($content == "Users") |
| 979 | 979 | { |
| 980 | - echo "<a href='".api_get_self()."?content=User&add=User&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".get_lang('UsersAdd')."</a>"; |
|
| 980 | + echo "<a href='".api_get_self()."?content=User&add=User&action=$action&learnpath_id=$learnpath_id&chapter_id=$chapter_id&originalresource=no'>".get_lang('UsersAdd')."</a>"; |
|
| 981 | 981 | } |
| 982 | 982 | |
| 983 | 983 | if ($showresources) |
| 984 | 984 | { |
| 985 | - //echo "<h4>".get_lang('ResourceAdded')."</h4>"; |
|
| 986 | - display_resources(1); |
|
| 985 | + //echo "<h4>".get_lang('ResourceAdded')."</h4>"; |
|
| 986 | + display_resources(1); |
|
| 987 | 987 | } |
| 988 | 988 | |
| 989 | 989 | echo "</td></tr></table>"; |
@@ -28,11 +28,11 @@ discard block |
||
| 28 | 28 | |
| 29 | 29 | // COURSES WITH CATEGORIES |
| 30 | 30 | if (!empty($user_course_categories)) { |
| 31 | - foreach ($user_course_categories as $row) { |
|
| 32 | - echo Display::page_subheader($row['title']); |
|
| 33 | - echo '<a name="category'.$row['id'].'"></a>'; |
|
| 31 | + foreach ($user_course_categories as $row) { |
|
| 32 | + echo Display::page_subheader($row['title']); |
|
| 33 | + echo '<a name="category'.$row['id'].'"></a>'; |
|
| 34 | 34 | |
| 35 | - if (isset($_GET['categoryid']) && $_GET['categoryid'] == $row['id']) { ?> |
|
| 35 | + if (isset($_GET['categoryid']) && $_GET['categoryid'] == $row['id']) { ?> |
|
| 36 | 36 | <!-- We display the edit form for the category --> |
| 37 | 37 | |
| 38 | 38 | <form name="edit_course_category" method="post" action="courses.php?action=<?php echo $action; ?>"> |
@@ -243,15 +243,15 @@ discard block |
||
| 243 | 243 | </a> |
| 244 | 244 | <?php } else { |
| 245 | 245 | echo Display::display_icon('up_na.png', get_lang('Up'),'',22); |
| 246 | - } |
|
| 246 | + } |
|
| 247 | 247 | |
| 248 | - if ($key < $number_of_courses - 1) { ?> |
|
| 248 | + if ($key < $number_of_courses - 1) { ?> |
|
| 249 | 249 | <a href="courses.php?action=<?php echo $action; ?>&move=down&course=<?php echo $course['code']; ?>&category=<?php echo $course['user_course_cat']; ?>&sec_token=<?php echo $stok; ?>"> |
| 250 | 250 | <?php echo Display::display_icon('down.png', get_lang('Down'),'',22); ?> |
| 251 | 251 | </a> |
| 252 | 252 | <?php } else { |
| 253 | 253 | echo Display::display_icon('down_na.png', get_lang('Down'),'',22); |
| 254 | - }?> |
|
| 254 | + }?> |
|
| 255 | 255 | </div> |
| 256 | 256 | <div style="float:left; margin-right:10px;"> |
| 257 | 257 | <!-- cancel subscrioption--> |
@@ -269,7 +269,7 @@ discard block |
||
| 269 | 269 | </div> |
| 270 | 270 | <?php } |
| 271 | 271 | } |
| 272 | - ?> |
|
| 272 | + ?> |
|
| 273 | 273 | </td> |
| 274 | 274 | </tr> |
| 275 | 275 | <?php |
@@ -60,7 +60,7 @@ |
||
| 60 | 60 | break; |
| 61 | 61 | } |
| 62 | 62 | break; |
| 63 | - } |
|
| 63 | + } |
|
| 64 | 64 | } |
| 65 | 65 | |
| 66 | 66 | /* Header */ |
@@ -3,7 +3,7 @@ |
||
| 3 | 3 | |
| 4 | 4 | /** |
| 5 | 5 | * This script displays an area where teachers can edit the group properties and member list. |
| 6 | - * |
|
| 6 | + * |
|
| 7 | 7 | * @author various contributors |
| 8 | 8 | * @author Roan Embrechts (VUB), partial code cleanup, initial virtual course support |
| 9 | 9 | * @package chamilo.group |