chamilo /
chamilo-lms
| @@ 2910-2939 (lines=30) @@ | ||
| 2907 | user_id = $user_id"; |
|
| 2908 | $res = Database::query($sql); |
|
| 2909 | ||
| 2910 | if (Database::num_rows($res) > 0) { |
|
| 2911 | // The user is already subscribed to the session. Change the |
|
| 2912 | // record so the user is NOT a coach for this course anymore |
|
| 2913 | // and then exit |
|
| 2914 | $sql = "UPDATE $tbl_session_rel_course_rel_user |
|
| 2915 | SET status = 0 |
|
| 2916 | WHERE |
|
| 2917 | session_id = $session_id AND |
|
| 2918 | c_id = $courseId AND |
|
| 2919 | user_id = $user_id "; |
|
| 2920 | $result = Database::query($sql); |
|
| 2921 | if (Database::affected_rows($result) > 0) |
|
| 2922 | return true; |
|
| 2923 | else |
|
| 2924 | return false; |
|
| 2925 | } else { |
|
| 2926 | // The user is not subscribed to the session, so make sure |
|
| 2927 | // he isn't subscribed to a course in this session either |
|
| 2928 | // and then exit |
|
| 2929 | $sql = "DELETE FROM $tbl_session_rel_course_rel_user |
|
| 2930 | WHERE |
|
| 2931 | session_id = $session_id AND |
|
| 2932 | c_id = $courseId AND |
|
| 2933 | user_id = $user_id "; |
|
| 2934 | $result = Database::query($sql); |
|
| 2935 | if (Database::affected_rows($result) > 0) { |
|
| 2936 | return true; |
|
| 2937 | } else { |
|
| 2938 | return false; |
|
| 2939 | } |
|
| 2940 | } |
|
| 2941 | } else { |
|
| 2942 | // Assign user as a coach to course |
|
| @@ 2952-2973 (lines=22) @@ | ||
| 2949 | $rs_check = Database::query($sql); |
|
| 2950 | ||
| 2951 | // Then update or insert. |
|
| 2952 | if (Database::num_rows($rs_check) > 0) { |
|
| 2953 | $sql = "UPDATE $tbl_session_rel_course_rel_user SET status = 2 |
|
| 2954 | WHERE |
|
| 2955 | session_id = $session_id AND |
|
| 2956 | c_id = $courseId AND |
|
| 2957 | user_id = $user_id "; |
|
| 2958 | $result = Database::query($sql); |
|
| 2959 | if (Database::affected_rows($result) > 0) { |
|
| 2960 | return true; |
|
| 2961 | } else { |
|
| 2962 | return false; |
|
| 2963 | } |
|
| 2964 | } else { |
|
| 2965 | $sql = "INSERT INTO $tbl_session_rel_course_rel_user(session_id, c_id, user_id, status) |
|
| 2966 | VALUES($session_id, $courseId, $user_id, 2)"; |
|
| 2967 | $result = Database::query($sql); |
|
| 2968 | if (Database::affected_rows($result) > 0) { |
|
| 2969 | return true; |
|
| 2970 | } else { |
|
| 2971 | return false; |
|
| 2972 | } |
|
| 2973 | } |
|
| 2974 | } |
|
| 2975 | } else { |
|
| 2976 | return false; |
|
