@@ -17,11 +17,11 @@ discard block |
||
17 | 17 | */ |
18 | 18 | public function getID(string $titleURL, int $siteID, bool $create = TRUE, bool $returnData = FALSE) { |
19 | 19 | $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) |
20 | - ->from('tracker_titles') |
|
21 | - ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left') |
|
22 | - ->where('tracker_titles.title_url', $titleURL) |
|
23 | - ->where('tracker_titles.site_id', $siteID) |
|
24 | - ->get(); |
|
20 | + ->from('tracker_titles') |
|
21 | + ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left') |
|
22 | + ->where('tracker_titles.title_url', $titleURL) |
|
23 | + ->where('tracker_titles.site_id', $siteID) |
|
24 | + ->get(); |
|
25 | 25 | |
26 | 26 | if($query->num_rows() > 0) { |
27 | 27 | $id = (int) $query->row('id'); |
@@ -35,8 +35,8 @@ discard block |
||
35 | 35 | //Make sure last_checked is always updated on successful run. |
36 | 36 | //CHECK: Is there a reason we aren't just doing this in updateTitleById? |
37 | 37 | $this->db->set('last_checked', 'CURRENT_TIMESTAMP', FALSE) |
38 | - ->where('id', $id) |
|
39 | - ->update('tracker_titles'); |
|
38 | + ->where('id', $id) |
|
39 | + ->update('tracker_titles'); |
|
40 | 40 | } |
41 | 41 | } else { |
42 | 42 | log_message('error', "{$siteClass} | {$query->row('title')} ({$query->row('title_url')}) | Failed to update."); |
@@ -76,9 +76,9 @@ discard block |
||
76 | 76 | */ |
77 | 77 | private function addTitle(string $titleURL, int $siteID) : int { |
78 | 78 | $query = $this->db->select('site, site_class') |
79 | - ->from('tracker_sites') |
|
80 | - ->where('id', $siteID) |
|
81 | - ->get(); |
|
79 | + ->from('tracker_sites') |
|
80 | + ->where('id', $siteID) |
|
81 | + ->get(); |
|
82 | 82 | |
83 | 83 | $titleData = $this->sites->{$query->row()->site_class}->getTitleData($titleURL, TRUE); |
84 | 84 | |
@@ -104,21 +104,21 @@ discard block |
||
104 | 104 | public function updateByID(int $titleID, ?string $latestChapter) : bool { |
105 | 105 | //FIXME: Really not too happy with how we're doing history stuff here, it just feels messy. |
106 | 106 | $query = $this->db->select('latest_chapter AS current_chapter') |
107 | - ->from('tracker_titles') |
|
108 | - ->where('id', $titleID) |
|
109 | - ->get(); |
|
107 | + ->from('tracker_titles') |
|
108 | + ->where('id', $titleID) |
|
109 | + ->get(); |
|
110 | 110 | $row = $query->row(); |
111 | 111 | |
112 | 112 | //TODO (CHECK): If failed_checks changes won't that trigger affected_rows? |
113 | 113 | $success = $this->db->set(['latest_chapter' => $latestChapter, 'failed_checks' => 0]) //last_updated gets updated via a trigger if something changes |
114 | - ->where('id', $titleID) |
|
115 | - ->update('tracker_titles'); |
|
114 | + ->where('id', $titleID) |
|
115 | + ->update('tracker_titles'); |
|
116 | 116 | |
117 | 117 | if($this->db->affected_rows() > 0) { |
118 | 118 | //Clear hidden latest chapter |
119 | 119 | $this->db->set(['ignore_chapter' => 'NULL', 'last_updated' => 'last_updated'], NULL, FALSE) |
120 | - ->where('title_id', $titleID) |
|
121 | - ->update('tracker_chapters'); |
|
120 | + ->where('title_id', $titleID) |
|
121 | + ->update('tracker_chapters'); |
|
122 | 122 | } |
123 | 123 | |
124 | 124 | //Update History |
@@ -135,20 +135,20 @@ discard block |
||
135 | 135 | if(!array_diff(array_keys($data), TITLEDATA_COLUMNS)) { |
136 | 136 | $newData = array_merge($data, ['failed_checks' => 0]); |
137 | 137 | $oldData = $this->db->select('latest_chapter AS current_chapter') |
138 | - ->from('tracker_titles') |
|
139 | - ->where('id', $titleID) |
|
140 | - ->get()->row_array(); |
|
138 | + ->from('tracker_titles') |
|
139 | + ->where('id', $titleID) |
|
140 | + ->get()->row_array(); |
|
141 | 141 | |
142 | 142 | |
143 | 143 | $success = $this->db->set($newData) //last_updated gets updated via a trigger if something changes |
144 | - ->set('last_checked', 'CURRENT_TIMESTAMP', FALSE) |
|
145 | - ->where('id', $titleID) |
|
146 | - ->update('tracker_titles'); |
|
144 | + ->set('last_checked', 'CURRENT_TIMESTAMP', FALSE) |
|
145 | + ->where('id', $titleID) |
|
146 | + ->update('tracker_titles'); |
|
147 | 147 | if(in_array('latest_chapter', $newData, TRUE) && $newData['latest_chapter'] !== $oldData['current_chapter'] && $this->db->affected_rows() > 0) { |
148 | 148 | //Clear hidden latest chapter |
149 | 149 | $this->db->set(['ignore_chapter' => 'NULL', 'last_updated' => 'last_updated'], NULL, FALSE) |
150 | - ->where('title_id', $titleID) |
|
151 | - ->update('tracker_chapters'); |
|
150 | + ->where('title_id', $titleID) |
|
151 | + ->update('tracker_chapters'); |
|
152 | 152 | } |
153 | 153 | |
154 | 154 | //Update History |
@@ -164,8 +164,8 @@ discard block |
||
164 | 164 | |
165 | 165 | public function updateFailedChecksByID(int $titleID) : bool { |
166 | 166 | $success = $this->db->set('failed_checks', 'failed_checks + 1', FALSE) |
167 | - ->where('id', $titleID) |
|
168 | - ->update('tracker_titles'); |
|
167 | + ->where('id', $titleID) |
|
168 | + ->update('tracker_titles'); |
|
169 | 169 | |
170 | 170 | return $success; |
171 | 171 | } |
@@ -177,9 +177,9 @@ discard block |
||
177 | 177 | */ |
178 | 178 | public function getSiteDataFromURL(string $site_url) { |
179 | 179 | $query = $this->db->select('*') |
180 | - ->from('tracker_sites') |
|
181 | - ->where('site', $site_url) |
|
182 | - ->get(); |
|
180 | + ->from('tracker_sites') |
|
181 | + ->where('site', $site_url) |
|
182 | + ->get(); |
|
183 | 183 | |
184 | 184 | return $query->row(); |
185 | 185 | } |
@@ -223,10 +223,10 @@ discard block |
||
223 | 223 | */ |
224 | 224 | public function updateCustom() { |
225 | 225 | $query = $this->db->select('*') |
226 | - ->from('tracker_sites') |
|
227 | - ->where('tracker_sites.status', 'enabled') |
|
228 | - ->where('tracker_sites.use_custom', 'Y') |
|
229 | - ->get(); |
|
226 | + ->from('tracker_sites') |
|
227 | + ->where('tracker_sites.status', 'enabled') |
|
228 | + ->where('tracker_sites.use_custom', 'Y') |
|
229 | + ->get(); |
|
230 | 230 | |
231 | 231 | $sites = $query->result_array(); |
232 | 232 | foreach ($sites as $site) { |
@@ -243,8 +243,8 @@ discard block |
||
243 | 243 | //Make sure last_checked is always updated on successful run. |
244 | 244 | //CHECK: Is there a reason we aren't just doing this in updateByID? |
245 | 245 | $this->db->set('last_checked', 'CURRENT_TIMESTAMP', FALSE) |
246 | - ->where('id', $titleID) |
|
247 | - ->update('tracker_titles'); |
|
246 | + ->where('id', $titleID) |
|
247 | + ->update('tracker_titles'); |
|
248 | 248 | |
249 | 249 | print " - ({$titleData['latest_chapter']})\n"; |
250 | 250 | } else { |
@@ -273,13 +273,13 @@ discard block |
||
273 | 273 | |
274 | 274 | public function refollowCustom() { |
275 | 275 | $query = $this->db->select('tracker_titles.id, tracker_titles.title_url, tracker_sites.site_class') |
276 | - ->from('tracker_titles') |
|
277 | - ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left') |
|
278 | - ->where('tracker_titles.followed','N') |
|
279 | - ->where('tracker_titles !=', '255') |
|
280 | - ->where('tracker_sites.status', 'enabled') |
|
281 | - ->where('tracker_sites.use_custom', 'Y') |
|
282 | - ->get(); |
|
276 | + ->from('tracker_titles') |
|
277 | + ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left') |
|
278 | + ->where('tracker_titles.followed','N') |
|
279 | + ->where('tracker_titles !=', '255') |
|
280 | + ->where('tracker_sites.status', 'enabled') |
|
281 | + ->where('tracker_sites.use_custom', 'Y') |
|
282 | + ->get(); |
|
283 | 283 | |
284 | 284 | if($query->num_rows() > 0) { |
285 | 285 | foreach($query->result() as $row) { |
@@ -290,8 +290,8 @@ discard block |
||
290 | 290 | |
291 | 291 | if(!empty($titleData)) { |
292 | 292 | $this->db->set($titleData) |
293 | - ->where('id', $row->id) |
|
294 | - ->update('tracker_titles'); |
|
293 | + ->where('id', $row->id) |
|
294 | + ->update('tracker_titles'); |
|
295 | 295 | |
296 | 296 | print "> {$row->site_class}:{$row->id}:{$row->title_url} FOLLOWED\n"; |
297 | 297 | } else { |
@@ -311,14 +311,14 @@ discard block |
||
311 | 311 | $date = $temp_now->format('Y-m-d'); |
312 | 312 | |
313 | 313 | $query = $this->db->select('1') |
314 | - ->from('site_stats') |
|
315 | - ->where('date', $date) |
|
316 | - ->get(); |
|
314 | + ->from('site_stats') |
|
315 | + ->where('date', $date) |
|
316 | + ->get(); |
|
317 | 317 | |
318 | 318 | if($query->num_rows() > 0) { |
319 | 319 | $this->db->set('total_requests', 'total_requests+1', FALSE) |
320 | - ->where('date', $date) |
|
321 | - ->update('site_stats'); |
|
320 | + ->where('date', $date) |
|
321 | + ->update('site_stats'); |
|
322 | 322 | } else { |
323 | 323 | $this->db->insert('site_stats', [ |
324 | 324 | 'date' => $date, |