chamilo /
chamilo-lms
| @@ 1305-1316 (lines=12) @@ | ||
| 1302 | AND question_id = ".intval($id)." |
|
| 1303 | AND exercice_id = " . intval($exerciseId); |
|
| 1304 | $res = Database::query($sql); |
|
| 1305 | if (Database::num_rows($res) > 0) { |
|
| 1306 | $row = Database::fetch_array($res); |
|
| 1307 | if (!empty($row['question_order'])) { |
|
| 1308 | $sql = "UPDATE $TBL_EXERCISE_QUESTION |
|
| 1309 | SET question_order = question_order-1 |
|
| 1310 | WHERE |
|
| 1311 | c_id = $course_id |
|
| 1312 | AND exercice_id = ".intval($exerciseId)." |
|
| 1313 | AND question_order > " . $row['question_order']; |
|
| 1314 | Database::query($sql); |
|
| 1315 | } |
|
| 1316 | } |
|
| 1317 | ||
| 1318 | $sql = "DELETE FROM $TBL_EXERCISE_QUESTION |
|
| 1319 | WHERE |
|
| @@ 1355-1367 (lines=13) @@ | ||
| 1352 | WHERE c_id = $course_id AND question_id = ".intval($id).""; |
|
| 1353 | ||
| 1354 | $res = Database::query($sql); |
|
| 1355 | if (Database::num_rows($res) > 0) { |
|
| 1356 | while ($row = Database::fetch_array($res)) { |
|
| 1357 | if (!empty($row['question_order'])) { |
|
| 1358 | $sql = "UPDATE $TBL_EXERCISE_QUESTION |
|
| 1359 | SET question_order = question_order-1 |
|
| 1360 | WHERE |
|
| 1361 | c_id= $course_id |
|
| 1362 | AND exercice_id = ".intval($row['exercice_id'])." |
|
| 1363 | AND question_order > " . $row['question_order']; |
|
| 1364 | Database::query($sql); |
|
| 1365 | } |
|
| 1366 | } |
|
| 1367 | } |
|
| 1368 | ||
| 1369 | $sql = "DELETE FROM $TBL_EXERCISE_QUESTION |
|
| 1370 | WHERE c_id = $course_id AND question_id = ".$id; |
|
