| @@ 4272-4281 (lines=10) @@ | ||
| 4269 | Database::query($sql); |
|
| 4270 | ||
| 4271 | // Delete session-course-user relationships students and coaches. |
|
| 4272 | if ($updateCourseCoaches) { |
|
| 4273 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4274 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4275 | Database::query($sql); |
|
| 4276 | } else { |
|
| 4277 | // Delete session-course-user relation ships *only* for students. |
|
| 4278 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4279 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4280 | Database::query($sql); |
|
| 4281 | } |
|
| 4282 | } |
|
| 4283 | } else { |
|
| 4284 | if ($debug) { |
|
| @@ 4360-4369 (lines=10) @@ | ||
| 4357 | Database::query($sql); |
|
| 4358 | ||
| 4359 | // Delete session-course-user relationships students and coaches. |
|
| 4360 | if ($updateCourseCoaches) { |
|
| 4361 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4362 | WHERE session_id = '$session_id' AND status in ('0', '2')"; |
|
| 4363 | Database::query($sql); |
|
| 4364 | } else { |
|
| 4365 | // Delete session-course-user relation ships *only* for students. |
|
| 4366 | $sql = "DELETE FROM $tbl_session_course_user |
|
| 4367 | WHERE session_id = '$session_id' AND status <> 2"; |
|
| 4368 | Database::query($sql); |
|
| 4369 | } |
|
| 4370 | } else { |
|
| 4371 | if ($debug) { |
|
| 4372 | $logger->addError( |
|