chamilo /
chamilo-lms
| @@ 2987-3016 (lines=30) @@ | ||
| 2984 | user_id = $user_id"; |
|
| 2985 | $res = Database::query($sql); |
|
| 2986 | ||
| 2987 | if (Database::num_rows($res) > 0) { |
|
| 2988 | // The user is already subscribed to the session. Change the |
|
| 2989 | // record so the user is NOT a coach for this course anymore |
|
| 2990 | // and then exit |
|
| 2991 | $sql = "UPDATE $tbl_session_rel_course_rel_user |
|
| 2992 | SET status = 0 |
|
| 2993 | WHERE |
|
| 2994 | session_id = $session_id AND |
|
| 2995 | c_id = $courseId AND |
|
| 2996 | user_id = $user_id "; |
|
| 2997 | $result = Database::query($sql); |
|
| 2998 | if (Database::affected_rows($result) > 0) |
|
| 2999 | return true; |
|
| 3000 | else |
|
| 3001 | return false; |
|
| 3002 | } else { |
|
| 3003 | // The user is not subscribed to the session, so make sure |
|
| 3004 | // he isn't subscribed to a course in this session either |
|
| 3005 | // and then exit |
|
| 3006 | $sql = "DELETE FROM $tbl_session_rel_course_rel_user |
|
| 3007 | WHERE |
|
| 3008 | session_id = $session_id AND |
|
| 3009 | c_id = $courseId AND |
|
| 3010 | user_id = $user_id "; |
|
| 3011 | $result = Database::query($sql); |
|
| 3012 | if (Database::affected_rows($result) > 0) { |
|
| 3013 | return true; |
|
| 3014 | } else { |
|
| 3015 | return false; |
|
| 3016 | } |
|
| 3017 | } |
|
| 3018 | } else { |
|
| 3019 | // Assign user as a coach to course |
|
| @@ 3029-3050 (lines=22) @@ | ||
| 3026 | $rs_check = Database::query($sql); |
|
| 3027 | ||
| 3028 | // Then update or insert. |
|
| 3029 | if (Database::num_rows($rs_check) > 0) { |
|
| 3030 | $sql = "UPDATE $tbl_session_rel_course_rel_user SET status = 2 |
|
| 3031 | WHERE |
|
| 3032 | session_id = $session_id AND |
|
| 3033 | c_id = $courseId AND |
|
| 3034 | user_id = $user_id "; |
|
| 3035 | $result = Database::query($sql); |
|
| 3036 | if (Database::affected_rows($result) > 0) { |
|
| 3037 | return true; |
|
| 3038 | } else { |
|
| 3039 | return false; |
|
| 3040 | } |
|
| 3041 | } else { |
|
| 3042 | $sql = "INSERT INTO $tbl_session_rel_course_rel_user(session_id, c_id, user_id, status, visibility) |
|
| 3043 | VALUES($session_id, $courseId, $user_id, 2, 1)"; |
|
| 3044 | $result = Database::query($sql); |
|
| 3045 | if (Database::affected_rows($result) > 0) { |
|
| 3046 | return true; |
|
| 3047 | } else { |
|
| 3048 | return false; |
|
| 3049 | } |
|
| 3050 | } |
|
| 3051 | } |
|
| 3052 | } else { |
|
| 3053 | return false; |
|
