chamilo /
chamilo-lms
| @@ 1105-1125 (lines=21) @@ | ||
| 1102 | ) { |
|
| 1103 | $table = Database:: get_course_table(TABLE_COURSE_DESCRIPTION); |
|
| 1104 | ||
| 1105 | if (!empty($session_id) && !empty($courseId)) { |
|
| 1106 | $session_id = intval($session_id); |
|
| 1107 | if ($with_base_content) { |
|
| 1108 | $session_condition = api_get_session_condition( |
|
| 1109 | $session_id, |
|
| 1110 | true, |
|
| 1111 | true |
|
| 1112 | ); |
|
| 1113 | } else { |
|
| 1114 | $session_condition = api_get_session_condition( |
|
| 1115 | $session_id, |
|
| 1116 | true |
|
| 1117 | ); |
|
| 1118 | } |
|
| 1119 | $sql = 'SELECT * FROM '.$table.' |
|
| 1120 | WHERE c_id = '.$courseId.' '.$session_condition; |
|
| 1121 | } else { |
|
| 1122 | $table = Database:: get_course_table(TABLE_COURSE_DESCRIPTION); |
|
| 1123 | $sql = 'SELECT * FROM '.$table.' |
|
| 1124 | WHERE c_id = '.$courseId.' AND session_id = 0'; |
|
| 1125 | } |
|
| 1126 | ||
| 1127 | $db_result = Database::query($sql); |
|
| 1128 | while ($obj = Database::fetch_object($db_result)) { |
|
| @@ 1156-1175 (lines=20) @@ | ||
| 1153 | $table_item = Database::get_course_table(TABLE_LP_ITEM); |
|
| 1154 | $table_tool = Database::get_course_table(TABLE_TOOL_LIST); |
|
| 1155 | ||
| 1156 | if (!empty($session_id) && !empty($courseId)) { |
|
| 1157 | $session_id = intval($session_id); |
|
| 1158 | if ($with_base_content) { |
|
| 1159 | $session_condition = api_get_session_condition( |
|
| 1160 | $session_id, |
|
| 1161 | true, |
|
| 1162 | true |
|
| 1163 | ); |
|
| 1164 | } else { |
|
| 1165 | $session_condition = api_get_session_condition( |
|
| 1166 | $session_id, |
|
| 1167 | true |
|
| 1168 | ); |
|
| 1169 | } |
|
| 1170 | $sql = 'SELECT * FROM '.$table_main.' |
|
| 1171 | WHERE c_id = '.$courseId.' '.$session_condition; |
|
| 1172 | } else { |
|
| 1173 | $sql = 'SELECT * FROM '.$table_main.' |
|
| 1174 | WHERE c_id = '.$courseId.' AND (session_id = 0 OR session_id IS NULL)'; |
|
| 1175 | } |
|
| 1176 | ||
| 1177 | if (!empty($id_list)) { |
|
| 1178 | $id_list = array_map('intval', $id_list); |
|
| @@ 1383-1403 (lines=21) @@ | ||
| 1380 | ) { |
|
| 1381 | $tbl_wiki = Database::get_course_table(TABLE_WIKI); |
|
| 1382 | ||
| 1383 | if (!empty($session_id) && !empty($courseId)) { |
|
| 1384 | $session_id = intval($session_id); |
|
| 1385 | if ($with_base_content) { |
|
| 1386 | $session_condition = api_get_session_condition( |
|
| 1387 | $session_id, |
|
| 1388 | true, |
|
| 1389 | true |
|
| 1390 | ); |
|
| 1391 | } else { |
|
| 1392 | $session_condition = api_get_session_condition( |
|
| 1393 | $session_id, |
|
| 1394 | true |
|
| 1395 | ); |
|
| 1396 | } |
|
| 1397 | $sql = 'SELECT * FROM '.$tbl_wiki.' |
|
| 1398 | WHERE c_id = '.$courseId.' '.$session_condition; |
|
| 1399 | } else { |
|
| 1400 | $tbl_wiki = Database::get_course_table(TABLE_WIKI); |
|
| 1401 | $sql = 'SELECT * FROM '.$tbl_wiki.' |
|
| 1402 | WHERE c_id = '.$courseId.' AND (session_id = 0 OR session_id IS NULL)'; |
|
| 1403 | } |
|
| 1404 | $db_result = Database::query($sql); |
|
| 1405 | while ($obj = Database::fetch_object($db_result)) { |
|
| 1406 | $wiki = new Wiki( |
|
