| @@ 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 | } |
|
| @@ 157-172 (lines=16) @@ | ||
| 154 | ->where('description', $desc) |
|
| 155 | ->get(); |
|
| 156 | ||
| 157 | if($exists->num_rows() < 1) |
|
| 158 | { |
|
| 159 | //Insert the item |
|
| 160 | $this->db->set('task_id', $task_id) |
|
| 161 | ->set('description', $desc) |
|
| 162 | ->insert('checklist'); |
|
| 163 | ||
| 164 | //Return the row |
|
| 165 | $return = $this->db->select('id, task_id, description, is_checked') |
|
| 166 | ->from('checklist') |
|
| 167 | ->where('task_id', $task_id) |
|
| 168 | ->where('description', $desc) |
|
| 169 | ->get(); |
|
| 170 | ||
| 171 | return $return->row_array(); |
|
| 172 | } |
|
| 173 | ||
| 174 | return FALSE; |
|
| 175 | } |
|
| @@ 1306-1320 (lines=15) @@ | ||
| 1303 | ->get(); |
|
| 1304 | ||
| 1305 | //Check if there is an existing reminder for this task |
|
| 1306 | if($query->num_rows() < 1) |
|
| 1307 | { |
|
| 1308 | $this->db->set('task_id', $task_id) |
|
| 1309 | ->set('reminder_time', $reminder_time) |
|
| 1310 | ->set('user_id', $user_id) |
|
| 1311 | ->insert('reminder'); |
|
| 1312 | } |
|
| 1313 | else //If there is, update it. |
|
| 1314 | { |
|
| 1315 | ||
| 1316 | $this->db->set('reminder_time', $reminder_time) |
|
| 1317 | ->where('task_id', $task_id) |
|
| 1318 | ->where('user_id', $user_id) |
|
| 1319 | ->update('reminder'); |
|
| 1320 | } |
|
| 1321 | } |
|
| 1322 | ||
| 1323 | // -------------------------------------------------------------------------- |
|