chamilo /
chamilo-lms
| @@ 2172-2178 (lines=7) @@ | ||
| 2169 | $newId = ''; |
|
| 2170 | ||
| 2171 | switch ($item['item_type']) { |
|
| 2172 | case TOOL_LINK: |
|
| 2173 | $sql = "SELECT * FROM c_link WHERE c_id = $courseId AND id = $ref"; |
|
| 2174 | $data = $connection->fetchAssoc($sql); |
|
| 2175 | if ($data) { |
|
| 2176 | $newId = $data['iid']; |
|
| 2177 | } |
|
| 2178 | break; |
|
| 2179 | case TOOL_STUDENTPUBLICATION: |
|
| 2180 | $sql = "SELECT * FROM c_student_publication WHERE c_id = $courseId AND id = $ref"; |
|
| 2181 | $data = $connection->fetchAssoc($sql); |
|
| @@ 2179-2185 (lines=7) @@ | ||
| 2176 | $newId = $data['iid']; |
|
| 2177 | } |
|
| 2178 | break; |
|
| 2179 | case TOOL_STUDENTPUBLICATION: |
|
| 2180 | $sql = "SELECT * FROM c_student_publication WHERE c_id = $courseId AND id = $ref"; |
|
| 2181 | $data = $connection->fetchAssoc($sql); |
|
| 2182 | if ($data) { |
|
| 2183 | $newId = $data['iid']; |
|
| 2184 | } |
|
| 2185 | break; |
|
| 2186 | case TOOL_QUIZ: |
|
| 2187 | $sql = "SELECT * FROM c_quiz WHERE c_id = $courseId AND id = $ref"; |
|
| 2188 | $data = $connection->fetchAssoc($sql); |
|
| @@ 2186-2192 (lines=7) @@ | ||
| 2183 | $newId = $data['iid']; |
|
| 2184 | } |
|
| 2185 | break; |
|
| 2186 | case TOOL_QUIZ: |
|
| 2187 | $sql = "SELECT * FROM c_quiz WHERE c_id = $courseId AND id = $ref"; |
|
| 2188 | $data = $connection->fetchAssoc($sql); |
|
| 2189 | if ($data) { |
|
| 2190 | $newId = $data['iid']; |
|
| 2191 | } |
|
| 2192 | break; |
|
| 2193 | case TOOL_DOCUMENT: |
|
| 2194 | $sql = "SELECT * FROM c_document WHERE c_id = $courseId AND id = $ref"; |
|
| 2195 | $data = $connection->fetchAssoc($sql); |
|
| @@ 2193-2199 (lines=7) @@ | ||
| 2190 | $newId = $data['iid']; |
|
| 2191 | } |
|
| 2192 | break; |
|
| 2193 | case TOOL_DOCUMENT: |
|
| 2194 | $sql = "SELECT * FROM c_document WHERE c_id = $courseId AND id = $ref"; |
|
| 2195 | $data = $connection->fetchAssoc($sql); |
|
| 2196 | if ($data) { |
|
| 2197 | $newId = $data['iid']; |
|
| 2198 | } |
|
| 2199 | break; |
|
| 2200 | case TOOL_FORUM: |
|
| 2201 | $sql = "SELECT * FROM c_forum_forum WHERE c_id = $courseId AND forum_id = $ref"; |
|
| 2202 | $data = $connection->fetchAssoc($sql); |
|
| @@ 2200-2206 (lines=7) @@ | ||
| 2197 | $newId = $data['iid']; |
|
| 2198 | } |
|
| 2199 | break; |
|
| 2200 | case TOOL_FORUM: |
|
| 2201 | $sql = "SELECT * FROM c_forum_forum WHERE c_id = $courseId AND forum_id = $ref"; |
|
| 2202 | $data = $connection->fetchAssoc($sql); |
|
| 2203 | if ($data) { |
|
| 2204 | $newId = $data['iid']; |
|
| 2205 | } |
|
| 2206 | break; |
|
| 2207 | case 'thread': |
|
| 2208 | $sql = "SELECT * FROM c_forum_thread WHERE c_id = $courseId AND thread_id = $ref"; |
|
| 2209 | $data = $connection->fetchAssoc($sql); |
|
| @@ 2207-2213 (lines=7) @@ | ||
| 2204 | $newId = $data['iid']; |
|
| 2205 | } |
|
| 2206 | break; |
|
| 2207 | case 'thread': |
|
| 2208 | $sql = "SELECT * FROM c_forum_thread WHERE c_id = $courseId AND thread_id = $ref"; |
|
| 2209 | $data = $connection->fetchAssoc($sql); |
|
| 2210 | if ($data) { |
|
| 2211 | $newId = $data['iid']; |
|
| 2212 | } |
|
| 2213 | break; |
|
| 2214 | } |
|
| 2215 | ||
| 2216 | if (!empty($sql) && !empty($newId) && !empty($iid)) { |
|
