| @@ 4509-4518 (lines=10) @@ | ||
| 4506 | Database::query($sql); |
|
| 4507 | ||
| 4508 | // Delete session-course-user relationships students and coaches. |
|
| 4509 | if ($updateCourseCoaches) { |
|
| 4510 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4511 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4512 | Database::query($sql); |
|
| 4513 | } else { |
|
| 4514 | // Delete session-course-user relation ships *only* for students. |
|
| 4515 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4516 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4517 | Database::query($sql); |
|
| 4518 | } |
|
| 4519 | } |
|
| 4520 | } else { |
|
| 4521 | // Updating the session. |
|
| @@ 4600-4609 (lines=10) @@ | ||
| 4597 | Database::query($sql); |
|
| 4598 | ||
| 4599 | // Delete session-course-user relationships students and coaches. |
|
| 4600 | if ($updateCourseCoaches) { |
|
| 4601 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4602 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4603 | Database::query($sql); |
|
| 4604 | } else { |
|
| 4605 | // Delete session-course-user relation ships *only* for students. |
|
| 4606 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4607 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4608 | Database::query($sql); |
|
| 4609 | } |
|
| 4610 | } else { |
|
| 4611 | if ($debug) { |
|
| 4612 | $logger->addError( |
|