@@ -626,7 +626,6 @@ discard block |
||
626 | 626 | * Also, this function provides conversion between path types, in this case the input path points inside the Chamilo area too. |
627 | 627 | * |
628 | 628 | * See $_configuration['course_folder'] in the configuration.php to alter the WEB_COURSE_PATH and SYS_COURSE_PATH parameters. |
629 | - |
|
630 | 629 | * @param string $path (optional) A path which type is to be converted. Also, it may be a defined constant for a path. |
631 | 630 | * This parameter has meaning when $type parameter has one of the following values: TO_WEB, TO_SYS, TO_REL. Otherwise it is ignored. |
632 | 631 | * @return string The requested path or the converted path. |
@@ -1733,7 +1732,6 @@ discard block |
||
1733 | 1732 | |
1734 | 1733 | /** |
1735 | 1734 | * Returns the current course info array. |
1736 | - |
|
1737 | 1735 | * Now if the course_code is given, the returned array gives info about that |
1738 | 1736 | * particular course, not specially the current one. |
1739 | 1737 | * @param int $id Numeric ID of the course |
@@ -6210,7 +6208,7 @@ discard block |
||
6210 | 6208 | function api_get_jquery_ui_js($include_jqgrid = false) { |
6211 | 6209 | $libraries = array(); |
6212 | 6210 | if ($include_jqgrid) { |
6213 | - $libraries[]='jqgrid'; |
|
6211 | + $libraries[]='jqgrid'; |
|
6214 | 6212 | } |
6215 | 6213 | return api_get_jquery_libraries_js($libraries); |
6216 | 6214 | } |
@@ -1464,7 +1464,7 @@ discard block |
||
1464 | 1464 | ]; |
1465 | 1465 | Database::update($table, $newParams, ['id = ? ' => $ticketId]); |
1466 | 1466 | |
1467 | - self::sendNotification( |
|
1467 | + self::sendNotification( |
|
1468 | 1468 | $ticketId, |
1469 | 1469 | $userId, |
1470 | 1470 | get_lang('TicketUpdated'), |
@@ -1926,9 +1926,9 @@ discard block |
||
1926 | 1926 | return 0; |
1927 | 1927 | } |
1928 | 1928 | |
1929 | - /** |
|
1930 | - * @return array |
|
1931 | - */ |
|
1929 | + /** |
|
1930 | + * @return array |
|
1931 | + */ |
|
1932 | 1932 | public static function getPriorityList() |
1933 | 1933 | { |
1934 | 1934 | $projects = Database::getManager()->getRepository('ChamiloTicketBundle:Priority')->findAll(); |
@@ -2343,8 +2343,8 @@ discard block |
||
2343 | 2343 | } |
2344 | 2344 | |
2345 | 2345 | /** |
2346 | - * @return array |
|
2347 | - */ |
|
2346 | + * @return array |
|
2347 | + */ |
|
2348 | 2348 | public static function getDefaultPriorityList() { |
2349 | 2349 | return [ |
2350 | 2350 | self::PRIORITY_NORMAL, |
@@ -38,12 +38,12 @@ discard block |
||
38 | 38 | |
39 | 39 | // Tool name |
40 | 40 | if ($action === 'addnote') { |
41 | - $tool = 'NoteAddNew'; |
|
42 | - $interbreadcrumb[] = array('url' => 'index.php?'.api_get_cidreq(), 'name' => get_lang('ToolNotebook')); |
|
41 | + $tool = 'NoteAddNew'; |
|
42 | + $interbreadcrumb[] = array('url' => 'index.php?'.api_get_cidreq(), 'name' => get_lang('ToolNotebook')); |
|
43 | 43 | } |
44 | 44 | if ($action === 'editnote') { |
45 | - $tool = 'ModifyNote'; |
|
46 | - $interbreadcrumb[] = array('url' => 'index.php?'.api_get_cidreq(), 'name' => get_lang('ToolNotebook')); |
|
45 | + $tool = 'ModifyNote'; |
|
46 | + $interbreadcrumb[] = array('url' => 'index.php?'.api_get_cidreq(), 'name' => get_lang('ToolNotebook')); |
|
47 | 47 | } |
48 | 48 | |
49 | 49 | // Displaying the header |
@@ -63,7 +63,7 @@ discard block |
||
63 | 63 | exit; |
64 | 64 | } |
65 | 65 | |
66 | - $_SESSION['notebook_view'] = 'creation_date'; |
|
66 | + $_SESSION['notebook_view'] = 'creation_date'; |
|
67 | 67 | |
68 | 68 | $form = new FormValidator( |
69 | 69 | 'note', |
@@ -20,7 +20,7 @@ discard block |
||
20 | 20 | 'changeable', |
21 | 21 | 'filter', |
22 | 22 | 'extra_field_type', |
23 | - /* Enable this when field_loggeable is introduced as a table field (2.0) |
|
23 | + /* Enable this when field_loggeable is introduced as a table field (2.0) |
|
24 | 24 | 'field_loggeable', |
25 | 25 | */ |
26 | 26 | 'created_at' |
@@ -2041,7 +2041,7 @@ discard block |
||
2041 | 2041 | 'align' => 'left', |
2042 | 2042 | 'sortable' => 'true', |
2043 | 2043 | ), |
2044 | - array( |
|
2044 | + array( |
|
2045 | 2045 | 'name' => 'visible_to_others', |
2046 | 2046 | 'index' => 'visible_to_others', |
2047 | 2047 | 'width' => '40', |
@@ -6038,8 +6038,8 @@ discard block |
||
6038 | 6038 | $course_id = api_get_course_int_id(); |
6039 | 6039 | } |
6040 | 6040 | |
6041 | - $creatorId = empty($creatorId) ? api_get_user_id() : $creatorId; |
|
6042 | - $sessionId = api_get_session_id(); |
|
6041 | + $creatorId = empty($creatorId) ? api_get_user_id() : $creatorId; |
|
6042 | + $sessionId = api_get_session_id(); |
|
6043 | 6043 | |
6044 | 6044 | // Generates folder |
6045 | 6045 | $result = $this->generate_lp_folder($courseInfo); |
@@ -11114,7 +11114,7 @@ discard block |
||
11114 | 11114 | $lpItemId = []; |
11115 | 11115 | $typeListNotToVerify = self::getChapterTypes(); |
11116 | 11116 | |
11117 | - // Using get_toc() function instead $this->items because returns the correct order of the items |
|
11117 | + // Using get_toc() function instead $this->items because returns the correct order of the items |
|
11118 | 11118 | foreach ($this->get_toc() as $item) { |
11119 | 11119 | if (!in_array($item['type'], $typeListNotToVerify)) { |
11120 | 11120 | $lpItemId[] = $item['id']; |
@@ -15,15 +15,15 @@ discard block |
||
15 | 15 | { |
16 | 16 | } |
17 | 17 | |
18 | - /** |
|
19 | - * Add a new Term and Condition |
|
20 | - * @param int $language language id |
|
21 | - * @param string $content content |
|
22 | - * @param int $type term and condition type (0 or 1) |
|
23 | - * @param string $changes explain changes |
|
24 | - * @return boolean success |
|
25 | - */ |
|
26 | - public static function add($language, $content, $type, $changes) |
|
18 | + /** |
|
19 | + * Add a new Term and Condition |
|
20 | + * @param int $language language id |
|
21 | + * @param string $content content |
|
22 | + * @param int $type term and condition type (0 or 1) |
|
23 | + * @param string $changes explain changes |
|
24 | + * @return boolean success |
|
25 | + */ |
|
26 | + public static function add($language, $content, $type, $changes) |
|
27 | 27 | { |
28 | 28 | $legal_table = Database::get_main_table(TABLE_MAIN_LEGAL); |
29 | 29 | $last = self::get_last_condition($language); |
@@ -93,27 +93,27 @@ discard block |
||
93 | 93 | } |
94 | 94 | } |
95 | 95 | |
96 | - /** |
|
97 | - * Gets the data of a Term and condition by language |
|
98 | - * @param int $language language id |
|
99 | - * @return array all the info of a Term and condition |
|
100 | - */ |
|
101 | - public static function get_last_condition($language) |
|
96 | + /** |
|
97 | + * Gets the data of a Term and condition by language |
|
98 | + * @param int $language language id |
|
99 | + * @return array all the info of a Term and condition |
|
100 | + */ |
|
101 | + public static function get_last_condition($language) |
|
102 | 102 | { |
103 | - $legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL); |
|
104 | - $language= Database::escape_string($language); |
|
105 | - $sql = "SELECT * FROM $legal_conditions_table |
|
103 | + $legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL); |
|
104 | + $language= Database::escape_string($language); |
|
105 | + $sql = "SELECT * FROM $legal_conditions_table |
|
106 | 106 | WHERE language_id = '".$language."' |
107 | 107 | ORDER BY version DESC |
108 | 108 | LIMIT 1 "; |
109 | - $result = Database::query($sql); |
|
110 | - $result = Database::fetch_array($result, 'ASSOC'); |
|
109 | + $result = Database::query($sql); |
|
110 | + $result = Database::fetch_array($result, 'ASSOC'); |
|
111 | 111 | |
112 | 112 | if (isset($result['content'])) { |
113 | 113 | $result['content'] = self::replaceTags($result['content']); |
114 | 114 | } |
115 | 115 | return $result; |
116 | - } |
|
116 | + } |
|
117 | 117 | |
118 | 118 | /** |
119 | 119 | * @param string $content |
@@ -137,12 +137,12 @@ discard block |
||
137 | 137 | return $content; |
138 | 138 | } |
139 | 139 | |
140 | - /** |
|
141 | - * Gets the last version of a Term and condition by language |
|
142 | - * @param int $language language id |
|
143 | - * @return boolean | int the version or false if does not exist |
|
144 | - */ |
|
145 | - public static function get_last_version($language) |
|
140 | + /** |
|
141 | + * Gets the last version of a Term and condition by language |
|
142 | + * @param int $language language id |
|
143 | + * @return boolean | int the version or false if does not exist |
|
144 | + */ |
|
145 | + public static function get_last_version($language) |
|
146 | 146 | { |
147 | 147 | $legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL); |
148 | 148 | $language = intval($language); |
@@ -160,15 +160,15 @@ discard block |
||
160 | 160 | |
161 | 161 | return false; |
162 | 162 | } |
163 | - } |
|
163 | + } |
|
164 | 164 | |
165 | - /** |
|
166 | - * Show the last condition |
|
167 | - * @param array $term_preview with type and content i.e array('type'=>'1', 'content'=>'hola'); |
|
165 | + /** |
|
166 | + * Show the last condition |
|
167 | + * @param array $term_preview with type and content i.e array('type'=>'1', 'content'=>'hola'); |
|
168 | 168 | * |
169 | - * @return string html preview |
|
170 | - */ |
|
171 | - public static function show_last_condition($term_preview) |
|
169 | + * @return string html preview |
|
170 | + */ |
|
171 | + public static function show_last_condition($term_preview) |
|
172 | 172 | { |
173 | 173 | $preview = ''; |
174 | 174 | switch ($term_preview['type']) { |
@@ -199,34 +199,34 @@ discard block |
||
199 | 199 | break; |
200 | 200 | } |
201 | 201 | |
202 | - return $preview; |
|
203 | - } |
|
202 | + return $preview; |
|
203 | + } |
|
204 | 204 | |
205 | - /** |
|
206 | - * Get the terms and condition table (only for maintenance) |
|
207 | - * @param int $from |
|
208 | - * @param int $number_of_items |
|
209 | - * @param int $column |
|
210 | - * @return array |
|
211 | - */ |
|
212 | - public static function get_legal_data($from, $number_of_items, $column) |
|
205 | + /** |
|
206 | + * Get the terms and condition table (only for maintenance) |
|
207 | + * @param int $from |
|
208 | + * @param int $number_of_items |
|
209 | + * @param int $column |
|
210 | + * @return array |
|
211 | + */ |
|
212 | + public static function get_legal_data($from, $number_of_items, $column) |
|
213 | 213 | { |
214 | - $legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL); |
|
215 | - $lang_table = Database::get_main_table(TABLE_MAIN_LANGUAGE); |
|
216 | - $from = intval($from); |
|
217 | - $number_of_items = intval($number_of_items); |
|
218 | - $column = intval($column); |
|
214 | + $legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL); |
|
215 | + $lang_table = Database::get_main_table(TABLE_MAIN_LANGUAGE); |
|
216 | + $from = intval($from); |
|
217 | + $number_of_items = intval($number_of_items); |
|
218 | + $column = intval($column); |
|
219 | 219 | |
220 | - $sql = "SELECT version, original_name as language, content, changes, type, FROM_UNIXTIME(date) |
|
220 | + $sql = "SELECT version, original_name as language, content, changes, type, FROM_UNIXTIME(date) |
|
221 | 221 | FROM $legal_conditions_table inner join $lang_table l on(language_id = l.id) "; |
222 | - $sql .= "ORDER BY language, version ASC "; |
|
223 | - $sql .= "LIMIT $from, $number_of_items "; |
|
222 | + $sql .= "ORDER BY language, version ASC "; |
|
223 | + $sql .= "LIMIT $from, $number_of_items "; |
|
224 | 224 | |
225 | - $result = Database::query($sql); |
|
226 | - $legals = array(); |
|
227 | - while ($legal = Database::fetch_array($result)) { |
|
228 | - // max 2000 chars |
|
229 | - $languages[] = $legal[1]; |
|
225 | + $result = Database::query($sql); |
|
226 | + $legals = array(); |
|
227 | + while ($legal = Database::fetch_array($result)) { |
|
228 | + // max 2000 chars |
|
229 | + $languages[] = $legal[1]; |
|
230 | 230 | if (strlen($legal[2]) > 2000) { |
231 | 231 | $legal[2] = substr($legal[2], 0, 2000).' ... '; |
232 | 232 | } |
@@ -235,51 +235,51 @@ discard block |
||
235 | 235 | } elseif ($legal[4] == 1) { |
236 | 236 | $legal[4] = get_lang('PageLink'); |
237 | 237 | } |
238 | - $legals[] = $legal; |
|
239 | - } |
|
238 | + $legals[] = $legal; |
|
239 | + } |
|
240 | 240 | |
241 | - return $legals; |
|
242 | - } |
|
241 | + return $legals; |
|
242 | + } |
|
243 | 243 | |
244 | - /** |
|
245 | - * Gets the number of terms and conditions available |
|
246 | - * @return int |
|
247 | - */ |
|
248 | - public static function count() |
|
244 | + /** |
|
245 | + * Gets the number of terms and conditions available |
|
246 | + * @return int |
|
247 | + */ |
|
248 | + public static function count() |
|
249 | 249 | { |
250 | - $legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL); |
|
251 | - $sql = "SELECT count(*) as count_result |
|
250 | + $legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL); |
|
251 | + $sql = "SELECT count(*) as count_result |
|
252 | 252 | FROM $legal_conditions_table |
253 | 253 | ORDER BY id DESC "; |
254 | - $result = Database::query($sql); |
|
255 | - $url = Database::fetch_array($result,'ASSOC'); |
|
256 | - $result = $url['count_result']; |
|
254 | + $result = Database::query($sql); |
|
255 | + $url = Database::fetch_array($result,'ASSOC'); |
|
256 | + $result = $url['count_result']; |
|
257 | 257 | |
258 | - return $result; |
|
259 | - } |
|
258 | + return $result; |
|
259 | + } |
|
260 | 260 | |
261 | - /** |
|
262 | - * Get type of terms and conditions |
|
263 | - * @param int $legal_id |
|
264 | - * @param int $language_id |
|
265 | - * @return int The current type of terms and conditions |
|
266 | - */ |
|
267 | - public static function get_type_of_terms_and_conditions($legal_id, $language_id) |
|
261 | + /** |
|
262 | + * Get type of terms and conditions |
|
263 | + * @param int $legal_id |
|
264 | + * @param int $language_id |
|
265 | + * @return int The current type of terms and conditions |
|
266 | + */ |
|
267 | + public static function get_type_of_terms_and_conditions($legal_id, $language_id) |
|
268 | 268 | { |
269 | - $legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL); |
|
270 | - $legal_id = intval($legal_id); |
|
271 | - $language_id = intval($language_id); |
|
272 | - $sql = 'SELECT type FROM '.$legal_conditions_table.' |
|
269 | + $legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL); |
|
270 | + $legal_id = intval($legal_id); |
|
271 | + $language_id = intval($language_id); |
|
272 | + $sql = 'SELECT type FROM '.$legal_conditions_table.' |
|
273 | 273 | WHERE id = "'.$legal_id.'" AND language_id="'.$language_id.'"'; |
274 | - $rs = Database::query($sql); |
|
274 | + $rs = Database::query($sql); |
|
275 | 275 | |
276 | - return Database::result($rs,0,'type'); |
|
277 | - } |
|
276 | + return Database::result($rs,0,'type'); |
|
277 | + } |
|
278 | 278 | |
279 | 279 | /** |
280 | 280 | * @param int $userId |
281 | 281 | */ |
282 | - public static function sendLegal($userId) |
|
282 | + public static function sendLegal($userId) |
|
283 | 283 | { |
284 | 284 | $subject = get_lang('SendTermsSubject'); |
285 | 285 | $content = sprintf( |
@@ -216,7 +216,7 @@ discard block |
||
216 | 216 | $javascript .= "'".$dropbox_person->sentWork[$i]->title."'"; |
217 | 217 | } |
218 | 218 | } |
219 | - $javascript .= "); |
|
219 | + $javascript .= "); |
|
220 | 220 | |
221 | 221 | function checkfile(str) |
222 | 222 | { |
@@ -326,15 +326,15 @@ discard block |
||
326 | 326 | 'url' => api_get_path(WEB_CODE_PATH).'dropbox/index.php?'.api_get_cidreq(), |
327 | 327 | 'name' => get_lang('Dropbox', ''), |
328 | 328 | ); |
329 | - $nameTools = get_lang('ReceivedFiles'); |
|
329 | + $nameTools = get_lang('ReceivedFiles'); |
|
330 | 330 | |
331 | - if ($action == 'addreceivedcategory') { |
|
331 | + if ($action == 'addreceivedcategory') { |
|
332 | 332 | $interbreadcrumb[] = array( |
333 | 333 | 'url' => api_get_path(WEB_CODE_PATH).'dropbox/index.php?view=received&'.api_get_cidreq(), |
334 | 334 | 'name' => get_lang('ReceivedFiles'), |
335 | 335 | ); |
336 | - $nameTools = get_lang('AddNewCategory'); |
|
337 | - } |
|
336 | + $nameTools = get_lang('AddNewCategory'); |
|
337 | + } |
|
338 | 338 | } |
339 | 339 | |
340 | 340 | if ($view == 'sent' || empty($view)) { |
@@ -6,7 +6,6 @@ discard block |
||
6 | 6 | * |
7 | 7 | * Contains several functions dealing with displaying, |
8 | 8 | * editing,... of a blog |
9 | - |
|
10 | 9 | * @package chamilo.blogs |
11 | 10 | * @author Toon Keppens <[email protected]> |
12 | 11 | * @author Julio Montoya - Cleaning code |
@@ -335,7 +334,7 @@ discard block |
||
335 | 334 | // Storing the attachments if any |
336 | 335 | if ($result) { |
337 | 336 | $sql = 'INSERT INTO '.$blog_table_attachment.'(c_id, filename,comment, path, post_id,size, blog_id,comment_id) '. |
338 | - "VALUES ($course_id, '".Database::escape_string($file_name)."', '".$comment."', '".Database::escape_string($new_file_name)."' , '".$last_post_id."', '".intval($_FILES['user_upload']['size'])."', '".$blog_id."', '0' )"; |
|
337 | + "VALUES ($course_id, '".Database::escape_string($file_name)."', '".$comment."', '".Database::escape_string($new_file_name)."' , '".$last_post_id."', '".intval($_FILES['user_upload']['size'])."', '".$blog_id."', '0' )"; |
|
339 | 338 | Database::query($sql); |
340 | 339 | $id = Database::insert_id(); |
341 | 340 | if ($id) { |
@@ -479,7 +478,7 @@ discard block |
||
479 | 478 | // Storing the attachments if any |
480 | 479 | if ($result) { |
481 | 480 | $sql='INSERT INTO '.$blog_table_attachment.'(c_id, filename,comment, path, post_id,size,blog_id,comment_id) '. |
482 | - "VALUES ($course_id, '".Database::escape_string($file_name)."', '".$comment."', '".Database::escape_string($new_file_name)."' , '".$post_id."', '".$_FILES['user_upload']['size']."', '".$blog_id."', '".$last_id."' )"; |
|
481 | + "VALUES ($course_id, '".Database::escape_string($file_name)."', '".$comment."', '".Database::escape_string($new_file_name)."' , '".$post_id."', '".$_FILES['user_upload']['size']."', '".$blog_id."', '".$last_id."' )"; |
|
483 | 482 | Database::query($sql); |
484 | 483 | |
485 | 484 | $id = Database::insert_id(); |
@@ -1398,10 +1397,10 @@ discard block |
||
1398 | 1397 | echo '<span class="blogpost_title">' . get_lang('TaskList') . '</span><br />'; |
1399 | 1398 | echo "<table class=\"data_table\">"; |
1400 | 1399 | echo "<tr bgcolor=\"$color2\" align=\"center\" valign=\"top\">", |
1401 | - "<th width='240'><b>",get_lang('Title'),"</b></th>", |
|
1402 | - "<th><b>",get_lang('Description'),"</b></th>", |
|
1403 | - "<th><b>",get_lang('Color'),"</b></th>", |
|
1404 | - "<th width='50'><b>",get_lang('Modify'),"</b></th>", |
|
1400 | + "<th width='240'><b>",get_lang('Title'),"</b></th>", |
|
1401 | + "<th><b>",get_lang('Description'),"</b></th>", |
|
1402 | + "<th><b>",get_lang('Color'),"</b></th>", |
|
1403 | + "<th width='50'><b>",get_lang('Modify'),"</b></th>", |
|
1405 | 1404 | "</tr>"; |
1406 | 1405 | |
1407 | 1406 | |
@@ -1433,14 +1432,14 @@ discard block |
||
1433 | 1432 | echo '<td width="50">'; |
1434 | 1433 | echo '<a href="'.api_get_self().'?action=manage_tasks&blog_id='.$task['blog_id'].'&do=edit&task_id='.$task['task_id'].'">'; |
1435 | 1434 | echo Display::return_icon('edit.png', get_lang('EditTask')); |
1436 | - echo "</a>"; |
|
1437 | - echo '<a href="'.$delete_link.'"'; |
|
1438 | - echo $delete_confirm; |
|
1439 | - echo '>'; |
|
1435 | + echo "</a>"; |
|
1436 | + echo '<a href="'.$delete_link.'"'; |
|
1437 | + echo $delete_confirm; |
|
1438 | + echo '>'; |
|
1440 | 1439 | echo Display::return_icon($delete_icon, $delete_title); |
1441 | - echo "</a>"; |
|
1442 | - echo '</td>'; |
|
1443 | - echo '</tr>'; |
|
1440 | + echo "</a>"; |
|
1441 | + echo '</td>'; |
|
1442 | + echo '</tr>'; |
|
1444 | 1443 | } |
1445 | 1444 | echo "</table>"; |
1446 | 1445 | } |
@@ -1464,11 +1463,11 @@ discard block |
||
1464 | 1463 | echo '<span class="blogpost_title">' . get_lang('AssignedTasks') . '</span><br />'; |
1465 | 1464 | echo "<table class=\"data_table\">"; |
1466 | 1465 | echo "<tr bgcolor=\"$color2\" align=\"center\" valign=\"top\">", |
1467 | - "<th width='240'><b>",get_lang('Member'),"</b></th>", |
|
1468 | - "<th><b>",get_lang('Task'),"</b></th>", |
|
1469 | - "<th><b>",get_lang('Description'),"</b></th>", |
|
1470 | - "<th><b>",get_lang('TargetDate'),"</b></th>", |
|
1471 | - "<th width='50'><b>",get_lang('Modify'),"</b></th>", |
|
1466 | + "<th width='240'><b>",get_lang('Member'),"</b></th>", |
|
1467 | + "<th><b>",get_lang('Task'),"</b></th>", |
|
1468 | + "<th><b>",get_lang('Description'),"</b></th>", |
|
1469 | + "<th><b>",get_lang('TargetDate'),"</b></th>", |
|
1470 | + "<th width='50'><b>",get_lang('Modify'),"</b></th>", |
|
1472 | 1471 | "</tr>"; |
1473 | 1472 | |
1474 | 1473 | $course_id = api_get_course_int_id(); |
@@ -2316,7 +2315,7 @@ discard block |
||
2316 | 2315 | * @param Integer $year: the 4-digit year indication e.g. 2005 |
2317 | 2316 | * |
2318 | 2317 | * @return html code |
2319 | - */ |
|
2318 | + */ |
|
2320 | 2319 | public static function display_minimonthcalendar($month, $year, $blog_id) |
2321 | 2320 | { |
2322 | 2321 | // Init |
@@ -2609,34 +2608,34 @@ discard block |
||
2609 | 2608 | */ |
2610 | 2609 | function get_blog_attachment($blog_id, $post_id=null,$comment_id=null) |
2611 | 2610 | { |
2612 | - $blog_table_attachment = Database::get_course_table(TABLE_BLOGS_ATTACHMENT); |
|
2613 | - |
|
2614 | - $blog_id = intval($blog_id); |
|
2615 | - $comment_id = intval($comment_id); |
|
2616 | - $post_id = intval($post_id); |
|
2617 | - $row=array(); |
|
2618 | - $where=''; |
|
2619 | - if (!empty ($post_id) && is_numeric($post_id)) { |
|
2620 | - $where.=' AND post_id ="'.$post_id.'" '; |
|
2621 | - } |
|
2622 | - |
|
2623 | - if (!empty ($comment_id) && is_numeric($comment_id)) { |
|
2624 | - if (!empty ($post_id)) { |
|
2625 | - $where.= ' AND '; |
|
2626 | - } |
|
2627 | - $where.=' comment_id ="'.$comment_id.'" '; |
|
2628 | - } |
|
2611 | + $blog_table_attachment = Database::get_course_table(TABLE_BLOGS_ATTACHMENT); |
|
2612 | + |
|
2613 | + $blog_id = intval($blog_id); |
|
2614 | + $comment_id = intval($comment_id); |
|
2615 | + $post_id = intval($post_id); |
|
2616 | + $row=array(); |
|
2617 | + $where=''; |
|
2618 | + if (!empty ($post_id) && is_numeric($post_id)) { |
|
2619 | + $where.=' AND post_id ="'.$post_id.'" '; |
|
2620 | + } |
|
2621 | + |
|
2622 | + if (!empty ($comment_id) && is_numeric($comment_id)) { |
|
2623 | + if (!empty ($post_id)) { |
|
2624 | + $where.= ' AND '; |
|
2625 | + } |
|
2626 | + $where.=' comment_id ="'.$comment_id.'" '; |
|
2627 | + } |
|
2629 | 2628 | |
2630 | 2629 | $course_id = api_get_course_int_id(); |
2631 | 2630 | |
2632 | - $sql = 'SELECT path, filename, comment FROM '. $blog_table_attachment.' |
|
2631 | + $sql = 'SELECT path, filename, comment FROM '. $blog_table_attachment.' |
|
2633 | 2632 | WHERE c_id = '.$course_id.' AND blog_id ="'.intval($blog_id).'" '.$where; |
2634 | 2633 | |
2635 | - $result=Database::query($sql); |
|
2636 | - if (Database::num_rows($result)!=0) { |
|
2637 | - $row=Database::fetch_array($result); |
|
2638 | - } |
|
2639 | - return $row; |
|
2634 | + $result=Database::query($sql); |
|
2635 | + if (Database::num_rows($result)!=0) { |
|
2636 | + $row=Database::fetch_array($result); |
|
2637 | + } |
|
2638 | + return $row; |
|
2640 | 2639 | } |
2641 | 2640 | |
2642 | 2641 | /** |
@@ -2652,16 +2651,16 @@ discard block |
||
2652 | 2651 | $post_id = null, |
2653 | 2652 | $comment_id = null |
2654 | 2653 | ) { |
2655 | - $_course = api_get_course_info(); |
|
2656 | - $blog_table_attachment = Database::get_course_table(TABLE_BLOGS_ATTACHMENT); |
|
2657 | - $blog_id = intval($blog_id); |
|
2658 | - $comment_id = intval($comment_id); |
|
2659 | - $post_id = intval($post_id); |
|
2654 | + $_course = api_get_course_info(); |
|
2655 | + $blog_table_attachment = Database::get_course_table(TABLE_BLOGS_ATTACHMENT); |
|
2656 | + $blog_id = intval($blog_id); |
|
2657 | + $comment_id = intval($comment_id); |
|
2658 | + $post_id = intval($post_id); |
|
2660 | 2659 | |
2661 | 2660 | $course_id = api_get_course_int_id(); |
2662 | - $where = null; |
|
2661 | + $where = null; |
|
2663 | 2662 | |
2664 | - // delete files in DB |
|
2663 | + // delete files in DB |
|
2665 | 2664 | if (!empty ($post_id) && is_numeric($post_id)) { |
2666 | 2665 | $where .= ' AND post_id ="'.$post_id.'" '; |
2667 | 2666 | } |
@@ -2673,25 +2672,25 @@ discard block |
||
2673 | 2672 | $where .= ' comment_id ="'.$comment_id.'" '; |
2674 | 2673 | } |
2675 | 2674 | |
2676 | - // delete all files in directory |
|
2677 | - $courseDir = $_course['path'].'/upload/blog'; |
|
2678 | - $sys_course_path = api_get_path(SYS_COURSE_PATH); |
|
2679 | - $updir = $sys_course_path.$courseDir; |
|
2675 | + // delete all files in directory |
|
2676 | + $courseDir = $_course['path'].'/upload/blog'; |
|
2677 | + $sys_course_path = api_get_path(SYS_COURSE_PATH); |
|
2678 | + $updir = $sys_course_path.$courseDir; |
|
2680 | 2679 | |
2681 | - $sql = 'SELECT path FROM '.$blog_table_attachment.' |
|
2680 | + $sql = 'SELECT path FROM '.$blog_table_attachment.' |
|
2682 | 2681 | WHERE c_id = '.$course_id.' AND blog_id ="'.intval($blog_id).'" '.$where; |
2683 | - $result=Database::query($sql); |
|
2684 | - |
|
2685 | - while ($row=Database::fetch_row($result)) { |
|
2686 | - $file=$updir.'/'.$row[0]; |
|
2687 | - if (Security::check_abs_path($file,$updir) ) |
|
2688 | - { |
|
2689 | - @ unlink($file); |
|
2690 | - } |
|
2691 | - } |
|
2692 | - $sql = 'DELETE FROM '. $blog_table_attachment.' |
|
2682 | + $result=Database::query($sql); |
|
2683 | + |
|
2684 | + while ($row=Database::fetch_row($result)) { |
|
2685 | + $file=$updir.'/'.$row[0]; |
|
2686 | + if (Security::check_abs_path($file,$updir) ) |
|
2687 | + { |
|
2688 | + @ unlink($file); |
|
2689 | + } |
|
2690 | + } |
|
2691 | + $sql = 'DELETE FROM '. $blog_table_attachment.' |
|
2693 | 2692 | WHERE c_id = '.$course_id.' AND blog_id ="'.intval($blog_id).'" '.$where; |
2694 | - Database::query($sql); |
|
2693 | + Database::query($sql); |
|
2695 | 2694 | } |
2696 | 2695 | |
2697 | 2696 | /** |
@@ -2707,7 +2706,7 @@ discard block |
||
2707 | 2706 | $course_id = $course_info['real_id']; |
2708 | 2707 | $user_id = intval($user_id); |
2709 | 2708 | |
2710 | - $sql = "SELECT DISTINCT blog.blog_id, post_id, title, full_text, post.date_creation |
|
2709 | + $sql = "SELECT DISTINCT blog.blog_id, post_id, title, full_text, post.date_creation |
|
2711 | 2710 | FROM $tbl_blogs blog |
2712 | 2711 | INNER JOIN $tbl_blog_post post |
2713 | 2712 | ON (blog.blog_id = post.blog_id) |
@@ -2716,19 +2715,19 @@ discard block |
||
2716 | 2715 | post.c_id = $course_id AND |
2717 | 2716 | author_id = $user_id AND visibility = 1 |
2718 | 2717 | ORDER BY post.date_creation DESC "; |
2719 | - $result = Database::query($sql); |
|
2720 | - $return_data = ''; |
|
2721 | - |
|
2722 | - if (Database::num_rows($result)!=0) { |
|
2723 | - while ($row=Database::fetch_array($result)) { |
|
2724 | - $return_data.= '<div class="clear"></div><br />'; |
|
2725 | - $return_data.= '<div class="actions" style="margin-left:5px;margin-right:5px;">'.Display::return_icon('blog_article.png',get_lang('BlogPosts')).' '.$row['title'].' <div style="float:right;margin-top:-18px"><a href="../blog/blog.php?blog_id='.$row['blog_id'].'&gidReq=&cidReq='.$my_course_id.' " >'.get_lang('SeeBlog').'</a></div></div>'; |
|
2726 | - $return_data.= '<br / >'; |
|
2727 | - $return_data.= $row['full_text']; |
|
2728 | - $return_data.= '<br /><br />'; |
|
2729 | - } |
|
2730 | - } |
|
2731 | - return $return_data; |
|
2718 | + $result = Database::query($sql); |
|
2719 | + $return_data = ''; |
|
2720 | + |
|
2721 | + if (Database::num_rows($result)!=0) { |
|
2722 | + while ($row=Database::fetch_array($result)) { |
|
2723 | + $return_data.= '<div class="clear"></div><br />'; |
|
2724 | + $return_data.= '<div class="actions" style="margin-left:5px;margin-right:5px;">'.Display::return_icon('blog_article.png',get_lang('BlogPosts')).' '.$row['title'].' <div style="float:right;margin-top:-18px"><a href="../blog/blog.php?blog_id='.$row['blog_id'].'&gidReq=&cidReq='.$my_course_id.' " >'.get_lang('SeeBlog').'</a></div></div>'; |
|
2725 | + $return_data.= '<br / >'; |
|
2726 | + $return_data.= $row['full_text']; |
|
2727 | + $return_data.= '<br /><br />'; |
|
2728 | + } |
|
2729 | + } |
|
2730 | + return $return_data; |
|
2732 | 2731 | } |
2733 | 2732 | |
2734 | 2733 | /** |
@@ -2745,7 +2744,7 @@ discard block |
||
2745 | 2744 | $course_info = api_get_course_info($course_code); |
2746 | 2745 | $course_id = $course_info['real_id']; |
2747 | 2746 | |
2748 | - $sql = "SELECT DISTINCT blog.blog_id, comment_id, title, comment, comment.date_creation |
|
2747 | + $sql = "SELECT DISTINCT blog.blog_id, comment_id, title, comment, comment.date_creation |
|
2749 | 2748 | FROM $tbl_blogs blog INNER JOIN $tbl_blog_comment comment |
2750 | 2749 | ON (blog.blog_id = comment.blog_id) |
2751 | 2750 | WHERE blog.c_id = $course_id AND |
@@ -2753,17 +2752,17 @@ discard block |
||
2753 | 2752 | author_id = $user_id AND |
2754 | 2753 | visibility = 1 |
2755 | 2754 | ORDER BY blog_name"; |
2756 | - $result = Database::query($sql); |
|
2757 | - $return_data = ''; |
|
2758 | - if (Database::num_rows($result)!=0) { |
|
2759 | - while ($row=Database::fetch_array($result)) { |
|
2760 | - $return_data.= '<div class="clear"></div><br />'; |
|
2761 | - $return_data.= '<div class="actions" style="margin-left:5px;margin-right:5px;">'.$row['title'].' <div style="float:right;margin-top:-18px"><a href="../blog/blog.php?blog_id='.$row['blog_id'].'&gidReq=&cidReq='.Security::remove_XSS($course_code).' " >'.get_lang('SeeBlog').'</a></div></div>'; |
|
2762 | - $return_data.= '<br / >'; |
|
2763 | - $return_data.= $row['comment']; |
|
2764 | - $return_data.= '<br />'; |
|
2765 | - } |
|
2766 | - } |
|
2767 | - return $return_data; |
|
2755 | + $result = Database::query($sql); |
|
2756 | + $return_data = ''; |
|
2757 | + if (Database::num_rows($result)!=0) { |
|
2758 | + while ($row=Database::fetch_array($result)) { |
|
2759 | + $return_data.= '<div class="clear"></div><br />'; |
|
2760 | + $return_data.= '<div class="actions" style="margin-left:5px;margin-right:5px;">'.$row['title'].' <div style="float:right;margin-top:-18px"><a href="../blog/blog.php?blog_id='.$row['blog_id'].'&gidReq=&cidReq='.Security::remove_XSS($course_code).' " >'.get_lang('SeeBlog').'</a></div></div>'; |
|
2761 | + $return_data.= '<br / >'; |
|
2762 | + $return_data.= $row['comment']; |
|
2763 | + $return_data.= '<br />'; |
|
2764 | + } |
|
2765 | + } |
|
2766 | + return $return_data; |
|
2768 | 2767 | } |
2769 | 2768 |
@@ -480,8 +480,8 @@ discard block |
||
480 | 480 | ); |
481 | 481 | |
482 | 482 | if (($counter % $batchSize) === 0) { |
483 | - $em->flush(); |
|
484 | - $em->clear(); |
|
483 | + $em->flush(); |
|
484 | + $em->clear(); |
|
485 | 485 | } |
486 | 486 | $counter++; |
487 | 487 | } |
@@ -502,8 +502,8 @@ discard block |
||
502 | 502 | ); |
503 | 503 | |
504 | 504 | if (($counter % $batchSize) === 0) { |
505 | - $em->flush(); |
|
506 | - $em->clear(); |
|
505 | + $em->flush(); |
|
506 | + $em->clear(); |
|
507 | 507 | } |
508 | 508 | $counter++; |
509 | 509 | } |
@@ -1406,7 +1406,7 @@ discard block |
||
1406 | 1406 | ip.to_user_id = $user_id AND (ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".implode(", ", $group_memberships).")) |
1407 | 1407 | ) "; |
1408 | 1408 | } else { |
1409 | - $cond_user_id = " AND ( |
|
1409 | + $cond_user_id = " AND ( |
|
1410 | 1410 | ip.to_user_id = $user_id AND (ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".$group_id.")) |
1411 | 1411 | )"; |
1412 | 1412 | } |