@@ -88,8 +88,8 @@ discard block |
||
88 | 88 | //Make sure last_checked is always updated on successful run. |
89 | 89 | //CHECK: Is there a reason we aren't just doing this in updateByID? |
90 | 90 | $this->db->set('last_checked', 'CURRENT_TIMESTAMP', FALSE) |
91 | - ->where('id', $row->title_id) |
|
92 | - ->update('tracker_titles'); |
|
91 | + ->where('id', $row->title_id) |
|
92 | + ->update('tracker_titles'); |
|
93 | 93 | |
94 | 94 | print " - ({$titleData['latest_chapter']})\n"; |
95 | 95 | } else { |
@@ -103,8 +103,8 @@ discard block |
||
103 | 103 | //Make sure last_checked is always updated on successful run. |
104 | 104 | //CHECK: Is there a reason we aren't just doing this in updateByID? |
105 | 105 | $this->db->set('last_checked', 'CURRENT_TIMESTAMP', FALSE) |
106 | - ->where('id', $row->title_id) |
|
107 | - ->update('tracker_titles'); |
|
106 | + ->where('id', $row->title_id) |
|
107 | + ->update('tracker_titles'); |
|
108 | 108 | |
109 | 109 | print " - (No chapters found?)\n"; |
110 | 110 | } else { |
@@ -182,8 +182,8 @@ discard block |
||
182 | 182 | //Make sure last_checked is always updated on successful run. |
183 | 183 | //CHECK: Is there a reason we aren't just doing this in updateByID? |
184 | 184 | $this->db->set('last_checked', 'CURRENT_TIMESTAMP', FALSE) |
185 | - ->where('id', $row->title_id) |
|
186 | - ->update('tracker_titles'); |
|
185 | + ->where('id', $row->title_id) |
|
186 | + ->update('tracker_titles'); |
|
187 | 187 | |
188 | 188 | print " - ({$titleData['latest_chapter']})\n"; |
189 | 189 | } else { |
@@ -207,10 +207,10 @@ discard block |
||
207 | 207 | */ |
208 | 208 | public function updateCustom() { |
209 | 209 | $query = $this->db->select('*') |
210 | - ->from('tracker_sites') |
|
211 | - ->where('status', 'enabled') |
|
212 | - ->where('tracker_sites.use_custom', 'Y') |
|
213 | - ->get(); |
|
210 | + ->from('tracker_sites') |
|
211 | + ->where('status', 'enabled') |
|
212 | + ->where('tracker_sites.use_custom', 'Y') |
|
213 | + ->get(); |
|
214 | 214 | |
215 | 215 | $sites = $query->result_array(); |
216 | 216 | foreach ($sites as $site) { |
@@ -227,8 +227,8 @@ discard block |
||
227 | 227 | //Make sure last_checked is always updated on successful run. |
228 | 228 | //CHECK: Is there a reason we aren't just doing this in updateByID? |
229 | 229 | $this->db->set('last_checked', 'CURRENT_TIMESTAMP', FALSE) |
230 | - ->where('id', $titleID) |
|
231 | - ->update('tracker_titles'); |
|
230 | + ->where('id', $titleID) |
|
231 | + ->update('tracker_titles'); |
|
232 | 232 | |
233 | 233 | print " - ({$titleData['latest_chapter']})\n"; |
234 | 234 | } else { |
@@ -257,13 +257,13 @@ discard block |
||
257 | 257 | |
258 | 258 | public function refollowCustom() { |
259 | 259 | $query = $this->db->select('tracker_titles.id, tracker_titles.title_url, tracker_sites.site_class') |
260 | - ->from('tracker_titles') |
|
261 | - ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left') |
|
262 | - ->where('tracker_titles.followed','N') |
|
263 | - ->where('tracker_titles !=', '255') |
|
264 | - ->where('tracker_sites.status', 'enabled') |
|
265 | - ->where('tracker_sites.use_custom', 'Y') |
|
266 | - ->get(); |
|
260 | + ->from('tracker_titles') |
|
261 | + ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left') |
|
262 | + ->where('tracker_titles.followed','N') |
|
263 | + ->where('tracker_titles !=', '255') |
|
264 | + ->where('tracker_sites.status', 'enabled') |
|
265 | + ->where('tracker_sites.use_custom', 'Y') |
|
266 | + ->get(); |
|
267 | 267 | |
268 | 268 | if($query->num_rows() > 0) { |
269 | 269 | foreach($query->result() as $row) { |
@@ -274,8 +274,8 @@ discard block |
||
274 | 274 | |
275 | 275 | if(!empty($titleData)) { |
276 | 276 | $this->db->set($titleData) |
277 | - ->where('id', $row->id) |
|
278 | - ->update('tracker_titles'); |
|
277 | + ->where('id', $row->id) |
|
278 | + ->update('tracker_titles'); |
|
279 | 279 | |
280 | 280 | print "> {$row->site_class}:{$row->id}:{$row->title_url} FOLLOWED\n"; |
281 | 281 | } else { |
@@ -323,8 +323,8 @@ discard block |
||
323 | 323 | if($titleData['title'] && is_array($titleData) && !is_null($titleData['latest_chapter'])) { |
324 | 324 | if($titleData['title'] !== $row->title) { |
325 | 325 | $this->db->set('title', $titleData['title']) |
326 | - ->where('id', $row->id) |
|
327 | - ->update('tracker_titles'); |
|
326 | + ->where('id', $row->id) |
|
327 | + ->update('tracker_titles'); |
|
328 | 328 | //TODO: Add to history somehow? |
329 | 329 | print " - NEW TITLE ({$titleData['title']})\n"; |
330 | 330 | } else { |
@@ -334,8 +334,8 @@ discard block |
||
334 | 334 | //We might as well try to update as well. |
335 | 335 | if($this->Tracker->title->updateByID((int) $row->id, $titleData['latest_chapter'])) { |
336 | 336 | $this->db->set('last_checked', 'CURRENT_TIMESTAMP', FALSE) |
337 | - ->where('id', $row->id) |
|
338 | - ->update('tracker_titles'); |
|
337 | + ->where('id', $row->id) |
|
338 | + ->update('tracker_titles'); |
|
339 | 339 | } |
340 | 340 | } else { |
341 | 341 | log_message('error', "{$row->title} failed to update title successfully"); |
@@ -351,14 +351,14 @@ discard block |
||
351 | 351 | $date = $temp_now->format('Y-m-d'); |
352 | 352 | |
353 | 353 | $query = $this->db->select('1') |
354 | - ->from('site_stats') |
|
355 | - ->where('date', $date) |
|
356 | - ->get(); |
|
354 | + ->from('site_stats') |
|
355 | + ->where('date', $date) |
|
356 | + ->get(); |
|
357 | 357 | |
358 | 358 | if($query->num_rows() > 0) { |
359 | 359 | $this->db->set('total_requests', 'total_requests+1', FALSE) |
360 | - ->where('date', $date) |
|
361 | - ->update('site_stats'); |
|
360 | + ->where('date', $date) |
|
361 | + ->update('site_stats'); |
|
362 | 362 | } else { |
363 | 363 | $this->db->insert('site_stats', [ |
364 | 364 | 'date' => $date, |
@@ -15,11 +15,11 @@ discard block |
||
15 | 15 | */ |
16 | 16 | public function getID(string $titleURL, int $siteID, bool $create = TRUE, bool $returnData = FALSE) { |
17 | 17 | $query = $this->db->select('tracker_titles.id, tracker_titles.title, tracker_titles.title_url, tracker_titles.latest_chapter, tracker_titles.status, tracker_sites.site_class, (tracker_titles.last_checked > DATE_SUB(NOW(), INTERVAL 3 DAY)) AS active', FALSE) |
18 | - ->from('tracker_titles') |
|
19 | - ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left') |
|
20 | - ->where('tracker_titles.title_url', $titleURL) |
|
21 | - ->where('tracker_titles.site_id', $siteID) |
|
22 | - ->get(); |
|
18 | + ->from('tracker_titles') |
|
19 | + ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left') |
|
20 | + ->where('tracker_titles.title_url', $titleURL) |
|
21 | + ->where('tracker_titles.site_id', $siteID) |
|
22 | + ->get(); |
|
23 | 23 | |
24 | 24 | if($query->num_rows() > 0) { |
25 | 25 | $id = (int) $query->row('id'); |
@@ -32,8 +32,8 @@ discard block |
||
32 | 32 | //Make sure last_checked is always updated on successful run. |
33 | 33 | //CHECK: Is there a reason we aren't just doing this in updateTitleById? |
34 | 34 | $this->db->set('last_checked', 'CURRENT_TIMESTAMP', FALSE) |
35 | - ->where('id', $id) |
|
36 | - ->update('tracker_titles'); |
|
35 | + ->where('id', $id) |
|
36 | + ->update('tracker_titles'); |
|
37 | 37 | } |
38 | 38 | } else { |
39 | 39 | log_message('error', "{$query->row('title')} failed to update successfully"); |
@@ -73,9 +73,9 @@ discard block |
||
73 | 73 | */ |
74 | 74 | private function addTitle(string $titleURL, int $siteID) : int { |
75 | 75 | $query = $this->db->select('site, site_class') |
76 | - ->from('tracker_sites') |
|
77 | - ->where('id', $siteID) |
|
78 | - ->get(); |
|
76 | + ->from('tracker_sites') |
|
77 | + ->where('id', $siteID) |
|
78 | + ->get(); |
|
79 | 79 | |
80 | 80 | $titleData = $this->sites->{$query->row()->site_class}->getTitleData($titleURL, TRUE); |
81 | 81 | |
@@ -101,21 +101,21 @@ discard block |
||
101 | 101 | public function updateByID(int $titleID, ?string $latestChapter) : bool { |
102 | 102 | //FIXME: Really not too happy with how we're doing history stuff here, it just feels messy. |
103 | 103 | $query = $this->db->select('latest_chapter AS current_chapter') |
104 | - ->from('tracker_titles') |
|
105 | - ->where('id', $titleID) |
|
106 | - ->get(); |
|
104 | + ->from('tracker_titles') |
|
105 | + ->where('id', $titleID) |
|
106 | + ->get(); |
|
107 | 107 | $row = $query->row(); |
108 | 108 | |
109 | 109 | //TODO (CHECK): If failed_checks changes won't that trigger affected_rows? |
110 | 110 | $success = $this->db->set(['latest_chapter' => $latestChapter, 'failed_checks' => 0]) //last_updated gets updated via a trigger if something changes |
111 | - ->where('id', $titleID) |
|
112 | - ->update('tracker_titles'); |
|
111 | + ->where('id', $titleID) |
|
112 | + ->update('tracker_titles'); |
|
113 | 113 | |
114 | 114 | if($this->db->affected_rows() > 0) { |
115 | 115 | //Clear hidden latest chapter |
116 | 116 | $this->db->set(['ignore_chapter' => 'NULL', 'last_updated' => 'last_updated'], NULL, FALSE) |
117 | - ->where('title_id', $titleID) |
|
118 | - ->update('tracker_chapters'); |
|
117 | + ->where('title_id', $titleID) |
|
118 | + ->update('tracker_chapters'); |
|
119 | 119 | } |
120 | 120 | |
121 | 121 | //Update History |
@@ -128,8 +128,8 @@ discard block |
||
128 | 128 | |
129 | 129 | public function updateFailedChecksByID(int $titleID) : bool { |
130 | 130 | $success = $this->db->set('failed_checks', 'failed_checks + 1', FALSE) |
131 | - ->where('id', $titleID) |
|
132 | - ->update('tracker_titles'); |
|
131 | + ->where('id', $titleID) |
|
132 | + ->update('tracker_titles'); |
|
133 | 133 | |
134 | 134 | return $success; |
135 | 135 | } |
@@ -141,9 +141,9 @@ discard block |
||
141 | 141 | */ |
142 | 142 | public function getSiteDataFromURL(string $site_url) { |
143 | 143 | $query = $this->db->select('*') |
144 | - ->from('tracker_sites') |
|
145 | - ->where('site', $site_url) |
|
146 | - ->get(); |
|
144 | + ->from('tracker_sites') |
|
145 | + ->where('site', $site_url) |
|
146 | + ->get(); |
|
147 | 147 | |
148 | 148 | return $query->row(); |
149 | 149 | } |