| @@ 4499-4508 (lines=10) @@ | ||
| 4496 | Database::query($sql); |
|
| 4497 | ||
| 4498 | // Delete session-course-user relationships students and coaches. |
|
| 4499 | if ($updateCourseCoaches) { |
|
| 4500 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4501 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4502 | Database::query($sql); |
|
| 4503 | } else { |
|
| 4504 | // Delete session-course-user relation ships *only* for students. |
|
| 4505 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4506 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4507 | Database::query($sql); |
|
| 4508 | } |
|
| 4509 | } |
|
| 4510 | } else { |
|
| 4511 | // Updating the session. |
|
| @@ 4590-4599 (lines=10) @@ | ||
| 4587 | Database::query($sql); |
|
| 4588 | ||
| 4589 | // Delete session-course-user relationships students and coaches. |
|
| 4590 | if ($updateCourseCoaches) { |
|
| 4591 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4592 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4593 | Database::query($sql); |
|
| 4594 | } else { |
|
| 4595 | // Delete session-course-user relation ships *only* for students. |
|
| 4596 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4597 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4598 | Database::query($sql); |
|
| 4599 | } |
|
| 4600 | } else { |
|
| 4601 | if ($debug) { |
|
| 4602 | $logger->addError( |
|