chamilo /
chamilo-lms
| @@ 2790-2819 (lines=30) @@ | ||
| 2787 | user_id = $user_id"; |
|
| 2788 | $res = Database::query($sql); |
|
| 2789 | ||
| 2790 | if (Database::num_rows($res) > 0) { |
|
| 2791 | // The user is already subscribed to the session. Change the |
|
| 2792 | // record so the user is NOT a coach for this course anymore |
|
| 2793 | // and then exit |
|
| 2794 | $sql = "UPDATE $tbl_session_rel_course_rel_user |
|
| 2795 | SET status = 0 |
|
| 2796 | WHERE |
|
| 2797 | session_id = $session_id AND |
|
| 2798 | c_id = $courseId AND |
|
| 2799 | user_id = $user_id "; |
|
| 2800 | $result = Database::query($sql); |
|
| 2801 | if (Database::affected_rows($result) > 0) |
|
| 2802 | return true; |
|
| 2803 | else |
|
| 2804 | return false; |
|
| 2805 | } else { |
|
| 2806 | // The user is not subscribed to the session, so make sure |
|
| 2807 | // he isn't subscribed to a course in this session either |
|
| 2808 | // and then exit |
|
| 2809 | $sql = "DELETE FROM $tbl_session_rel_course_rel_user |
|
| 2810 | WHERE |
|
| 2811 | session_id = $session_id AND |
|
| 2812 | c_id = $courseId AND |
|
| 2813 | user_id = $user_id "; |
|
| 2814 | $result = Database::query($sql); |
|
| 2815 | if (Database::affected_rows($result) > 0) |
|
| 2816 | return true; |
|
| 2817 | else |
|
| 2818 | return false; |
|
| 2819 | } |
|
| 2820 | } else { |
|
| 2821 | // Assign user as a coach to course |
|
| 2822 | // First check if the user is registered to the course |
|
| @@ 2831-2852 (lines=22) @@ | ||
| 2828 | $rs_check = Database::query($sql); |
|
| 2829 | ||
| 2830 | // Then update or insert. |
|
| 2831 | if (Database::num_rows($rs_check) > 0) { |
|
| 2832 | $sql = "UPDATE $tbl_session_rel_course_rel_user SET status = 2 |
|
| 2833 | WHERE |
|
| 2834 | session_id = $session_id AND |
|
| 2835 | c_id = $courseId AND |
|
| 2836 | user_id = $user_id "; |
|
| 2837 | $result = Database::query($sql); |
|
| 2838 | if (Database::affected_rows($result) > 0) { |
|
| 2839 | return true; |
|
| 2840 | } else { |
|
| 2841 | return false; |
|
| 2842 | } |
|
| 2843 | } else { |
|
| 2844 | $sql = "INSERT INTO $tbl_session_rel_course_rel_user(session_id, c_id, user_id, status) |
|
| 2845 | VALUES($session_id, $courseId, $user_id, 2)"; |
|
| 2846 | $result = Database::query($sql); |
|
| 2847 | if (Database::affected_rows($result) > 0) { |
|
| 2848 | return true; |
|
| 2849 | } else { |
|
| 2850 | return false; |
|
| 2851 | } |
|
| 2852 | } |
|
| 2853 | } |
|
| 2854 | } else { |
|
| 2855 | return false; |
|
