| @@ 4281-4290 (lines=10) @@ | ||
| 4278 | Database::query($sql); |
|
| 4279 | ||
| 4280 | // Delete session-course-user relationships students and coaches. |
|
| 4281 | if ($updateCourseCoaches) { |
|
| 4282 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4283 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4284 | Database::query($sql); |
|
| 4285 | } else { |
|
| 4286 | // Delete session-course-user relation ships *only* for students. |
|
| 4287 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4288 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4289 | Database::query($sql); |
|
| 4290 | } |
|
| 4291 | } |
|
| 4292 | } else { |
|
| 4293 | if ($debug) { |
|
| @@ 4369-4378 (lines=10) @@ | ||
| 4366 | Database::query($sql); |
|
| 4367 | ||
| 4368 | // Delete session-course-user relationships students and coaches. |
|
| 4369 | if ($updateCourseCoaches) { |
|
| 4370 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4371 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4372 | Database::query($sql); |
|
| 4373 | } else { |
|
| 4374 | // Delete session-course-user relation ships *only* for students. |
|
| 4375 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4376 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4377 | Database::query($sql); |
|
| 4378 | } |
|
| 4379 | } else { |
|
| 4380 | if ($debug) { |
|
| 4381 | $logger->addError( |
|