chamilo /
chamilo-lms
| @@ 4711-4720 (lines=10) @@ | ||
| 4708 | Database::query($sql); |
|
| 4709 | ||
| 4710 | // Delete session-course-user relationships students and coaches. |
|
| 4711 | if ($updateCourseCoaches) { |
|
| 4712 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4713 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4714 | Database::query($sql); |
|
| 4715 | } else { |
|
| 4716 | // Delete session-course-user relation ships *only* for students. |
|
| 4717 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4718 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4719 | Database::query($sql); |
|
| 4720 | } |
|
| 4721 | if ($deleteOnlyCourseCoaches) { |
|
| 4722 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4723 | WHERE session_id = '$session_id' AND status in ('2')"; |
|
| @@ 4806-4815 (lines=10) @@ | ||
| 4803 | Database::query($sql); |
|
| 4804 | ||
| 4805 | // Delete session-course-user relationships students and coaches. |
|
| 4806 | if ($updateCourseCoaches) { |
|
| 4807 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4808 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4809 | Database::query($sql); |
|
| 4810 | } else { |
|
| 4811 | // Delete session-course-user relation ships *only* for students. |
|
| 4812 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4813 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4814 | Database::query($sql); |
|
| 4815 | } |
|
| 4816 | ||
| 4817 | if ($deleteOnlyCourseCoaches) { |
|
| 4818 | $sql = "DELETE FROM $tbl_session_course_user |
|
