chamilo /
chamilo-lms
| @@ 1161-1172 (lines=12) @@ | ||
| 1158 | AND question_id = " . intval($id) . " |
|
| 1159 | AND exercice_id = " . intval($exerciseId); |
|
| 1160 | $res = Database::query($sql); |
|
| 1161 | if (Database::num_rows($res)>0) { |
|
| 1162 | $row = Database::fetch_array($res); |
|
| 1163 | if (!empty($row['question_order'])) { |
|
| 1164 | $sql = "UPDATE $TBL_EXERCISE_QUESTION |
|
| 1165 | SET question_order = question_order-1 |
|
| 1166 | WHERE |
|
| 1167 | c_id = $course_id |
|
| 1168 | AND exercice_id = " . intval($exerciseId) . " |
|
| 1169 | AND question_order > " . $row['question_order']; |
|
| 1170 | Database::query($sql); |
|
| 1171 | } |
|
| 1172 | } |
|
| 1173 | ||
| 1174 | $sql = "DELETE FROM $TBL_EXERCISE_QUESTION |
|
| 1175 | WHERE |
|
| @@ 1211-1223 (lines=13) @@ | ||
| 1208 | WHERE c_id = $course_id AND question_id = ".intval($id).""; |
|
| 1209 | ||
| 1210 | $res = Database::query($sql); |
|
| 1211 | if (Database::num_rows($res) > 0) { |
|
| 1212 | while ($row = Database::fetch_array($res)) { |
|
| 1213 | if (!empty($row['question_order'])) { |
|
| 1214 | $sql = "UPDATE $TBL_EXERCISE_QUESTION |
|
| 1215 | SET question_order = question_order-1 |
|
| 1216 | WHERE |
|
| 1217 | c_id= $course_id |
|
| 1218 | AND exercice_id = " . intval($row['exercice_id']) . " |
|
| 1219 | AND question_order > " . $row['question_order']; |
|
| 1220 | Database::query($sql); |
|
| 1221 | } |
|
| 1222 | } |
|
| 1223 | } |
|
| 1224 | ||
| 1225 | $sql = "DELETE FROM $TBL_EXERCISE_QUESTION |
|
| 1226 | WHERE c_id = $course_id AND question_id = " . $id; |
|
