| @@ 655-674 (lines=20) @@ | ||
| 652 | $ic_slide->addValue('content', $link_description); |
|
| 653 | ||
| 654 | // Add category name if set. |
|
| 655 | if (isset($categoryId) && $categoryId > 0) { |
|
| 656 | $table_link_category = Database:: get_course_table( |
|
| 657 | TABLE_LINK_CATEGORY |
|
| 658 | ); |
|
| 659 | $sql_cat = 'SELECT * FROM %s WHERE id=%d and c_id = %d LIMIT 1'; |
|
| 660 | $sql_cat = sprintf( |
|
| 661 | $sql_cat, |
|
| 662 | $table_link_category, |
|
| 663 | $categoryId, |
|
| 664 | $course_int_id |
|
| 665 | ); |
|
| 666 | $result = Database:: query($sql_cat); |
|
| 667 | if (Database:: num_rows($result) == 1) { |
|
| 668 | $row = Database:: fetch_array($result); |
|
| 669 | $ic_slide->addValue( |
|
| 670 | 'category', |
|
| 671 | $row['category_title'] |
|
| 672 | ); |
|
| 673 | } |
|
| 674 | } |
|
| 675 | ||
| 676 | $di = new ChamiloIndexer(); |
|
| 677 | isset ($_POST['language']) ? $lang = Database:: escape_string($_POST['language']) : $lang = 'english'; |
|
| @@ 272-291 (lines=20) @@ | ||
| 269 | $ic_slide->addValue('content', $description); |
|
| 270 | ||
| 271 | // Add category name if set. |
|
| 272 | if (isset($selectcategory) && $selectcategory > 0) { |
|
| 273 | $table_link_category = Database:: get_course_table( |
|
| 274 | TABLE_LINK_CATEGORY |
|
| 275 | ); |
|
| 276 | $sql_cat = 'SELECT * FROM %s WHERE id=%d AND c_id = %d LIMIT 1'; |
|
| 277 | $sql_cat = sprintf( |
|
| 278 | $sql_cat, |
|
| 279 | $table_link_category, |
|
| 280 | (int)$selectcategory, |
|
| 281 | $course_int_id |
|
| 282 | ); |
|
| 283 | $result = Database:: query($sql_cat); |
|
| 284 | if (Database:: num_rows($result) == 1) { |
|
| 285 | $row = Database:: fetch_array($result); |
|
| 286 | $ic_slide->addValue( |
|
| 287 | 'category', |
|
| 288 | $row['category_title'] |
|
| 289 | ); |
|
| 290 | } |
|
| 291 | } |
|
| 292 | ||
| 293 | $di = new ChamiloIndexer(); |
|
| 294 | isset($_POST['language']) ? $lang = Database:: escape_string( |
|