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