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