chamilo /
chamilo-lms
| @@ 2092-2098 (lines=7) @@ | ||
| 2089 | $newId = ''; |
|
| 2090 | ||
| 2091 | switch ($item['item_type']) { |
|
| 2092 | case TOOL_LINK: |
|
| 2093 | $sql = "SELECT * FROM c_link WHERE c_id = $courseId AND id = $ref"; |
|
| 2094 | $data = $connection->fetchAssoc($sql); |
|
| 2095 | if ($data) { |
|
| 2096 | $newId = $data['iid']; |
|
| 2097 | } |
|
| 2098 | break; |
|
| 2099 | case TOOL_STUDENTPUBLICATION: |
|
| 2100 | $sql = "SELECT * FROM c_student_publication WHERE c_id = $courseId AND id = $ref"; |
|
| 2101 | $data = $connection->fetchAssoc($sql); |
|
| @@ 2099-2105 (lines=7) @@ | ||
| 2096 | $newId = $data['iid']; |
|
| 2097 | } |
|
| 2098 | break; |
|
| 2099 | case TOOL_STUDENTPUBLICATION: |
|
| 2100 | $sql = "SELECT * FROM c_student_publication WHERE c_id = $courseId AND id = $ref"; |
|
| 2101 | $data = $connection->fetchAssoc($sql); |
|
| 2102 | if ($data) { |
|
| 2103 | $newId = $data['iid']; |
|
| 2104 | } |
|
| 2105 | break; |
|
| 2106 | case TOOL_QUIZ: |
|
| 2107 | $sql = "SELECT * FROM c_quiz WHERE c_id = $courseId AND id = $ref"; |
|
| 2108 | $data = $connection->fetchAssoc($sql); |
|
| @@ 2106-2112 (lines=7) @@ | ||
| 2103 | $newId = $data['iid']; |
|
| 2104 | } |
|
| 2105 | break; |
|
| 2106 | case TOOL_QUIZ: |
|
| 2107 | $sql = "SELECT * FROM c_quiz WHERE c_id = $courseId AND id = $ref"; |
|
| 2108 | $data = $connection->fetchAssoc($sql); |
|
| 2109 | if ($data) { |
|
| 2110 | $newId = $data['iid']; |
|
| 2111 | } |
|
| 2112 | break; |
|
| 2113 | case TOOL_DOCUMENT: |
|
| 2114 | $sql = "SELECT * FROM c_document WHERE c_id = $courseId AND id = $ref"; |
|
| 2115 | $data = $connection->fetchAssoc($sql); |
|
| @@ 2113-2119 (lines=7) @@ | ||
| 2110 | $newId = $data['iid']; |
|
| 2111 | } |
|
| 2112 | break; |
|
| 2113 | case TOOL_DOCUMENT: |
|
| 2114 | $sql = "SELECT * FROM c_document WHERE c_id = $courseId AND id = $ref"; |
|
| 2115 | $data = $connection->fetchAssoc($sql); |
|
| 2116 | if ($data) { |
|
| 2117 | $newId = $data['iid']; |
|
| 2118 | } |
|
| 2119 | break; |
|
| 2120 | case TOOL_FORUM: |
|
| 2121 | $sql = "SELECT * FROM c_forum_forum WHERE c_id = $courseId AND forum_id = $ref"; |
|
| 2122 | $data = $connection->fetchAssoc($sql); |
|
| @@ 2120-2126 (lines=7) @@ | ||
| 2117 | $newId = $data['iid']; |
|
| 2118 | } |
|
| 2119 | break; |
|
| 2120 | case TOOL_FORUM: |
|
| 2121 | $sql = "SELECT * FROM c_forum_forum WHERE c_id = $courseId AND forum_id = $ref"; |
|
| 2122 | $data = $connection->fetchAssoc($sql); |
|
| 2123 | if ($data) { |
|
| 2124 | $newId = $data['iid']; |
|
| 2125 | } |
|
| 2126 | break; |
|
| 2127 | case 'thread': |
|
| 2128 | $sql = "SELECT * FROM c_forum_thread WHERE c_id = $courseId AND thread_id = $ref"; |
|
| 2129 | $data = $connection->fetchAssoc($sql); |
|
| @@ 2127-2133 (lines=7) @@ | ||
| 2124 | $newId = $data['iid']; |
|
| 2125 | } |
|
| 2126 | break; |
|
| 2127 | case 'thread': |
|
| 2128 | $sql = "SELECT * FROM c_forum_thread WHERE c_id = $courseId AND thread_id = $ref"; |
|
| 2129 | $data = $connection->fetchAssoc($sql); |
|
| 2130 | if ($data) { |
|
| 2131 | $newId = $data['iid']; |
|
| 2132 | } |
|
| 2133 | break; |
|
| 2134 | } |
|
| 2135 | ||
| 2136 | if (!empty($sql) && !empty($newId) && !empty($iid)) { |
|
