| @@ 4490-4499 (lines=10) @@ | ||
| 4487 | Database::query($sql); |
|
| 4488 | ||
| 4489 | // Delete session-course-user relationships students and coaches. |
|
| 4490 | if ($updateCourseCoaches) { |
|
| 4491 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4492 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4493 | Database::query($sql); |
|
| 4494 | } else { |
|
| 4495 | // Delete session-course-user relation ships *only* for students. |
|
| 4496 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4497 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4498 | Database::query($sql); |
|
| 4499 | } |
|
| 4500 | } |
|
| 4501 | } else { |
|
| 4502 | // Updating the session. |
|
| @@ 4581-4590 (lines=10) @@ | ||
| 4578 | Database::query($sql); |
|
| 4579 | ||
| 4580 | // Delete session-course-user relationships students and coaches. |
|
| 4581 | if ($updateCourseCoaches) { |
|
| 4582 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4583 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4584 | Database::query($sql); |
|
| 4585 | } else { |
|
| 4586 | // Delete session-course-user relation ships *only* for students. |
|
| 4587 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4588 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4589 | Database::query($sql); |
|
| 4590 | } |
|
| 4591 | } else { |
|
| 4592 | if ($debug) { |
|
| 4593 | $logger->addError( |
|