| @@ 4469-4478 (lines=10) @@ | ||
| 4466 | Database::query($sql); |
|
| 4467 | ||
| 4468 | // Delete session-course-user relationships students and coaches. |
|
| 4469 | if ($updateCourseCoaches) { |
|
| 4470 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4471 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4472 | Database::query($sql); |
|
| 4473 | } else { |
|
| 4474 | // Delete session-course-user relation ships *only* for students. |
|
| 4475 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4476 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4477 | Database::query($sql); |
|
| 4478 | } |
|
| 4479 | } |
|
| 4480 | } else { |
|
| 4481 | // Updating the session. |
|
| @@ 4560-4569 (lines=10) @@ | ||
| 4557 | Database::query($sql); |
|
| 4558 | ||
| 4559 | // Delete session-course-user relationships students and coaches. |
|
| 4560 | if ($updateCourseCoaches) { |
|
| 4561 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4562 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4563 | Database::query($sql); |
|
| 4564 | } else { |
|
| 4565 | // Delete session-course-user relation ships *only* for students. |
|
| 4566 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4567 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4568 | Database::query($sql); |
|
| 4569 | } |
|
| 4570 | } else { |
|
| 4571 | if ($debug) { |
|
| 4572 | $logger->addError( |
|