chamilo /
chamilo-lms
| @@ 2889-2918 (lines=30) @@ | ||
| 2886 | user_id = $user_id"; |
|
| 2887 | $res = Database::query($sql); |
|
| 2888 | ||
| 2889 | if (Database::num_rows($res) > 0) { |
|
| 2890 | // The user is already subscribed to the session. Change the |
|
| 2891 | // record so the user is NOT a coach for this course anymore |
|
| 2892 | // and then exit |
|
| 2893 | $sql = "UPDATE $tbl_session_rel_course_rel_user |
|
| 2894 | SET status = 0 |
|
| 2895 | WHERE |
|
| 2896 | session_id = $session_id AND |
|
| 2897 | c_id = $courseId AND |
|
| 2898 | user_id = $user_id "; |
|
| 2899 | $result = Database::query($sql); |
|
| 2900 | if (Database::affected_rows($result) > 0) |
|
| 2901 | return true; |
|
| 2902 | else |
|
| 2903 | return false; |
|
| 2904 | } else { |
|
| 2905 | // The user is not subscribed to the session, so make sure |
|
| 2906 | // he isn't subscribed to a course in this session either |
|
| 2907 | // and then exit |
|
| 2908 | $sql = "DELETE FROM $tbl_session_rel_course_rel_user |
|
| 2909 | WHERE |
|
| 2910 | session_id = $session_id AND |
|
| 2911 | c_id = $courseId AND |
|
| 2912 | user_id = $user_id "; |
|
| 2913 | $result = Database::query($sql); |
|
| 2914 | if (Database::affected_rows($result) > 0) { |
|
| 2915 | return true; |
|
| 2916 | } else { |
|
| 2917 | return false; |
|
| 2918 | } |
|
| 2919 | } |
|
| 2920 | } else { |
|
| 2921 | // Assign user as a coach to course |
|
| @@ 2931-2952 (lines=22) @@ | ||
| 2928 | $rs_check = Database::query($sql); |
|
| 2929 | ||
| 2930 | // Then update or insert. |
|
| 2931 | if (Database::num_rows($rs_check) > 0) { |
|
| 2932 | $sql = "UPDATE $tbl_session_rel_course_rel_user SET status = 2 |
|
| 2933 | WHERE |
|
| 2934 | session_id = $session_id AND |
|
| 2935 | c_id = $courseId AND |
|
| 2936 | user_id = $user_id "; |
|
| 2937 | $result = Database::query($sql); |
|
| 2938 | if (Database::affected_rows($result) > 0) { |
|
| 2939 | return true; |
|
| 2940 | } else { |
|
| 2941 | return false; |
|
| 2942 | } |
|
| 2943 | } else { |
|
| 2944 | $sql = "INSERT INTO $tbl_session_rel_course_rel_user(session_id, c_id, user_id, status) |
|
| 2945 | VALUES($session_id, $courseId, $user_id, 2)"; |
|
| 2946 | $result = Database::query($sql); |
|
| 2947 | if (Database::affected_rows($result) > 0) { |
|
| 2948 | return true; |
|
| 2949 | } else { |
|
| 2950 | return false; |
|
| 2951 | } |
|
| 2952 | } |
|
| 2953 | } |
|
| 2954 | } else { |
|
| 2955 | return false; |
|
