chamilo /
chamilo-lms
| @@ 6715-6723 (lines=9) @@ | ||
| 6712 | $row[5] = ''; |
|
| 6713 | //@todo Improve this code please |
|
| 6714 | switch ($table_name['table_name']) { |
|
| 6715 | case 'document': |
|
| 6716 | $sql = "SELECT tool.title as title FROM $table_tool tool |
|
| 6717 | WHERE c_id = $course_id AND id = $ref"; |
|
| 6718 | $rs_document = Database::query($sql); |
|
| 6719 | $obj_document = Database::fetch_object($rs_document); |
|
| 6720 | if ($obj_document) { |
|
| 6721 | $row[5] = $obj_document->title; |
|
| 6722 | } |
|
| 6723 | break; |
|
| 6724 | case 'announcement': |
|
| 6725 | $sql = "SELECT title FROM $table_tool |
|
| 6726 | WHERE c_id = $course_id AND id = $ref"; |
|
| @@ 6724-6732 (lines=9) @@ | ||
| 6721 | $row[5] = $obj_document->title; |
|
| 6722 | } |
|
| 6723 | break; |
|
| 6724 | case 'announcement': |
|
| 6725 | $sql = "SELECT title FROM $table_tool |
|
| 6726 | WHERE c_id = $course_id AND id = $ref"; |
|
| 6727 | $rs_document = Database::query($sql); |
|
| 6728 | $obj_document = Database::fetch_object($rs_document); |
|
| 6729 | if ($obj_document) { |
|
| 6730 | $row[5] = $obj_document->title; |
|
| 6731 | } |
|
| 6732 | break; |
|
| 6733 | case 'glossary': |
|
| 6734 | $sql = "SELECT name FROM $table_tool |
|
| 6735 | WHERE c_id = $course_id AND glossary_id = $ref"; |
|
| @@ 6749-6757 (lines=9) @@ | ||
| 6746 | $obj_document = Database::fetch_object($rs_document); |
|
| 6747 | $row[5] = $obj_document->name; |
|
| 6748 | break; |
|
| 6749 | case 'quiz': |
|
| 6750 | $sql = "SELECT title FROM $table_tool |
|
| 6751 | WHERE c_id = $course_id AND id = $ref"; |
|
| 6752 | $rs_document = Database::query($sql); |
|
| 6753 | $obj_document = Database::fetch_object($rs_document); |
|
| 6754 | if ($obj_document) { |
|
| 6755 | $row[5] = $obj_document->title; |
|
| 6756 | } |
|
| 6757 | break; |
|
| 6758 | case 'course_description': |
|
| 6759 | $sql = "SELECT title FROM $table_tool |
|
| 6760 | WHERE c_id = $course_id AND id = $ref"; |
|
| @@ 6758-6766 (lines=9) @@ | ||
| 6755 | $row[5] = $obj_document->title; |
|
| 6756 | } |
|
| 6757 | break; |
|
| 6758 | case 'course_description': |
|
| 6759 | $sql = "SELECT title FROM $table_tool |
|
| 6760 | WHERE c_id = $course_id AND id = $ref"; |
|
| 6761 | $rs_document = Database::query($sql); |
|
| 6762 | $obj_document = Database::fetch_object($rs_document); |
|
| 6763 | if ($obj_document) { |
|
| 6764 | $row[5] = $obj_document->title; |
|
| 6765 | } |
|
| 6766 | break; |
|
| 6767 | case 'thematic': |
|
| 6768 | $rs = Database::query("SELECT title FROM $table_tool WHERE c_id = $course_id AND id = $ref"); |
|
| 6769 | if (Database::num_rows($rs) > 0) { |
|
| @@ 6767-6775 (lines=9) @@ | ||
| 6764 | $row[5] = $obj_document->title; |
|
| 6765 | } |
|
| 6766 | break; |
|
| 6767 | case 'thematic': |
|
| 6768 | $rs = Database::query("SELECT title FROM $table_tool WHERE c_id = $course_id AND id = $ref"); |
|
| 6769 | if (Database::num_rows($rs) > 0) { |
|
| 6770 | $obj = Database::fetch_object($rs); |
|
| 6771 | if ($obj) { |
|
| 6772 | $row[5] = $obj->title; |
|
| 6773 | } |
|
| 6774 | } |
|
| 6775 | break; |
|
| 6776 | case 'thematic_advance': |
|
| 6777 | $rs = Database::query("SELECT content FROM $table_tool WHERE c_id = $course_id AND id = $ref"); |
|
| 6778 | if (Database::num_rows($rs) > 0) { |
|
| @@ 6776-6784 (lines=9) @@ | ||
| 6773 | } |
|
| 6774 | } |
|
| 6775 | break; |
|
| 6776 | case 'thematic_advance': |
|
| 6777 | $rs = Database::query("SELECT content FROM $table_tool WHERE c_id = $course_id AND id = $ref"); |
|
| 6778 | if (Database::num_rows($rs) > 0) { |
|
| 6779 | $obj = Database::fetch_object($rs); |
|
| 6780 | if ($obj) { |
|
| 6781 | $row[5] = $obj->content; |
|
| 6782 | } |
|
| 6783 | } |
|
| 6784 | break; |
|
| 6785 | case 'thematic_plan': |
|
| 6786 | $rs = Database::query("SELECT title FROM $table_tool WHERE c_id = $course_id AND id = $ref"); |
|
| 6787 | if (Database::num_rows($rs) > 0) { |
|
| @@ 6785-6793 (lines=9) @@ | ||
| 6782 | } |
|
| 6783 | } |
|
| 6784 | break; |
|
| 6785 | case 'thematic_plan': |
|
| 6786 | $rs = Database::query("SELECT title FROM $table_tool WHERE c_id = $course_id AND id = $ref"); |
|
| 6787 | if (Database::num_rows($rs) > 0) { |
|
| 6788 | $obj = Database::fetch_object($rs); |
|
| 6789 | if ($obj) { |
|
| 6790 | $row[5] = $obj->title; |
|
| 6791 | } |
|
| 6792 | } |
|
| 6793 | break; |
|
| 6794 | default: |
|
| 6795 | break; |
|
| 6796 | } |
|
