chamilo /
chamilo-lms
| @@ 4592-4601 (lines=10) @@ | ||
| 4589 | Database::query($sql); |
|
| 4590 | ||
| 4591 | // Delete session-course-user relationships students and coaches. |
|
| 4592 | if ($updateCourseCoaches) { |
|
| 4593 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4594 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4595 | Database::query($sql); |
|
| 4596 | } else { |
|
| 4597 | // Delete session-course-user relation ships *only* for students. |
|
| 4598 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4599 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4600 | Database::query($sql); |
|
| 4601 | } |
|
| 4602 | if ($deleteOnlyCourseCoaches) { |
|
| 4603 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4604 | WHERE session_id = '$session_id' AND status in ('2')"; |
|
| @@ 4687-4696 (lines=10) @@ | ||
| 4684 | Database::query($sql); |
|
| 4685 | ||
| 4686 | // Delete session-course-user relationships students and coaches. |
|
| 4687 | if ($updateCourseCoaches) { |
|
| 4688 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4689 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4690 | Database::query($sql); |
|
| 4691 | } else { |
|
| 4692 | // Delete session-course-user relation ships *only* for students. |
|
| 4693 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4694 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4695 | Database::query($sql); |
|
| 4696 | } |
|
| 4697 | ||
| 4698 | if ($deleteOnlyCourseCoaches) { |
|
| 4699 | $sql = "DELETE FROM $tbl_session_course_user |
|
