chamilo /
chamilo-lms
| @@ 3091-3120 (lines=30) @@ | ||
| 3088 | user_id = $user_id"; |
|
| 3089 | $res = Database::query($sql); |
|
| 3090 | ||
| 3091 | if (Database::num_rows($res) > 0) { |
|
| 3092 | // The user is already subscribed to the session. Change the |
|
| 3093 | // record so the user is NOT a coach for this course anymore |
|
| 3094 | // and then exit |
|
| 3095 | $sql = "UPDATE $tbl_session_rel_course_rel_user |
|
| 3096 | SET status = 0 |
|
| 3097 | WHERE |
|
| 3098 | session_id = $session_id AND |
|
| 3099 | c_id = $courseId AND |
|
| 3100 | user_id = $user_id "; |
|
| 3101 | $result = Database::query($sql); |
|
| 3102 | if (Database::affected_rows($result) > 0) |
|
| 3103 | return true; |
|
| 3104 | else |
|
| 3105 | return false; |
|
| 3106 | } else { |
|
| 3107 | // The user is not subscribed to the session, so make sure |
|
| 3108 | // he isn't subscribed to a course in this session either |
|
| 3109 | // and then exit |
|
| 3110 | $sql = "DELETE FROM $tbl_session_rel_course_rel_user |
|
| 3111 | WHERE |
|
| 3112 | session_id = $session_id AND |
|
| 3113 | c_id = $courseId AND |
|
| 3114 | user_id = $user_id "; |
|
| 3115 | $result = Database::query($sql); |
|
| 3116 | if (Database::affected_rows($result) > 0) { |
|
| 3117 | return true; |
|
| 3118 | } else { |
|
| 3119 | return false; |
|
| 3120 | } |
|
| 3121 | } |
|
| 3122 | } else { |
|
| 3123 | // Assign user as a coach to course |
|
| @@ 3133-3154 (lines=22) @@ | ||
| 3130 | $rs_check = Database::query($sql); |
|
| 3131 | ||
| 3132 | // Then update or insert. |
|
| 3133 | if (Database::num_rows($rs_check) > 0) { |
|
| 3134 | $sql = "UPDATE $tbl_session_rel_course_rel_user SET status = 2 |
|
| 3135 | WHERE |
|
| 3136 | session_id = $session_id AND |
|
| 3137 | c_id = $courseId AND |
|
| 3138 | user_id = $user_id "; |
|
| 3139 | $result = Database::query($sql); |
|
| 3140 | if (Database::affected_rows($result) > 0) { |
|
| 3141 | return true; |
|
| 3142 | } else { |
|
| 3143 | return false; |
|
| 3144 | } |
|
| 3145 | } else { |
|
| 3146 | $sql = "INSERT INTO $tbl_session_rel_course_rel_user(session_id, c_id, user_id, status, visibility) |
|
| 3147 | VALUES($session_id, $courseId, $user_id, 2, 1)"; |
|
| 3148 | $result = Database::query($sql); |
|
| 3149 | if (Database::affected_rows($result) > 0) { |
|
| 3150 | return true; |
|
| 3151 | } else { |
|
| 3152 | return false; |
|
| 3153 | } |
|
| 3154 | } |
|
| 3155 | } |
|
| 3156 | } else { |
|
| 3157 | return false; |
|
