@@ 186-200 (lines=15) @@ | ||
183 | ->where('confirmed', FRIEND_NOT_CONFIRMED) |
|
184 | ->update('user_friend_link'); |
|
185 | } |
|
186 | else |
|
187 | { |
|
188 | //Check if the request already exists |
|
189 | $request_check = $this->db->from('user_friend_link') |
|
190 | ->where('user_friend_id', $friend_id) |
|
191 | ->where('user_id', $user_id) |
|
192 | ->get(); |
|
193 | ||
194 | if($request_check->num_rows() > 0) return -1; |
|
195 | ||
196 | //Add a friend request only if it doesn't already exist |
|
197 | $this->db->set('user_id', $user_id) |
|
198 | ->set('user_friend_id', $friend_id) |
|
199 | ->insert('user_friend_link'); |
|
200 | } |
|
201 | ||
202 | return $this->db->affected_rows(); |
|
203 | } |
@@ 150-165 (lines=16) @@ | ||
147 | ->where('description', $desc) |
|
148 | ->get(); |
|
149 | ||
150 | if($exists->num_rows() < 1) |
|
151 | { |
|
152 | //Insert the item |
|
153 | $this->db->set('task_id', $task_id) |
|
154 | ->set('description', $desc) |
|
155 | ->insert('checklist'); |
|
156 | ||
157 | //Return the row |
|
158 | $return = $this->db->select('id, task_id, description, is_checked') |
|
159 | ->from('checklist') |
|
160 | ->where('task_id', $task_id) |
|
161 | ->where('description', $desc) |
|
162 | ->get(); |
|
163 | ||
164 | return $return->row_array(); |
|
165 | } |
|
166 | ||
167 | return FALSE; |
|
168 | } |
|
@@ 1293-1307 (lines=15) @@ | ||
1290 | ->get(); |
|
1291 | ||
1292 | //Check if there is an existing reminder for this task |
|
1293 | if($query->num_rows() < 1) |
|
1294 | { |
|
1295 | $this->db->set('task_id', $task_id) |
|
1296 | ->set('reminder_time', $reminder_time) |
|
1297 | ->set('user_id', $user_id) |
|
1298 | ->insert('reminder'); |
|
1299 | } |
|
1300 | else //If there is, update it. |
|
1301 | { |
|
1302 | ||
1303 | $this->db->set('reminder_time', $reminder_time) |
|
1304 | ->where('task_id', $task_id) |
|
1305 | ->where('user_id', $user_id) |
|
1306 | ->update('reminder'); |
|
1307 | } |
|
1308 | } |
|
1309 | ||
1310 | // -------------------------------------------------------------------------- |