@@ -1,5 +1,5 @@ |
||
| 1 | 1 | <?php |
| 2 | -defined('BASEPATH') OR exit('No direct script access allowed'); |
|
| 2 | +defined('BASEPATH') or exit('No direct script access allowed'); |
|
| 3 | 3 | |
| 4 | 4 | /* |
| 5 | 5 | | ------------------------------------------------------------------------- |
@@ -1,4 +1,4 @@ |
||
| 1 | -<?php defined('BASEPATH') OR exit('No direct script access allowed'); |
|
| 1 | +<?php defined('BASEPATH') or exit('No direct script access allowed'); |
|
| 2 | 2 | |
| 3 | 3 | /** |
| 4 | 4 | * Rate Limiter Configuration |
@@ -1,4 +1,4 @@ |
||
| 1 | -<?php defined('BASEPATH') OR exit('No direct script access allowed'); |
|
| 1 | +<?php defined('BASEPATH') or exit('No direct script access allowed'); |
|
| 2 | 2 | |
| 3 | 3 | /** |
| 4 | 4 | * Rate Limiter Configuration |
@@ -90,9 +90,9 @@ discard block |
||
| 90 | 90 | |
| 91 | 91 | public function getSiteDataFromURL(string $site_url) { |
| 92 | 92 | $query = $this->db->select('id, site_class') |
| 93 | - ->from('tracker_sites') |
|
| 94 | - ->where('site', $site_url) |
|
| 95 | - ->get(); |
|
| 93 | + ->from('tracker_sites') |
|
| 94 | + ->where('site', $site_url) |
|
| 95 | + ->get(); |
|
| 96 | 96 | |
| 97 | 97 | if($query->num_rows() > 0) { |
| 98 | 98 | $siteData = $query->row(); |
@@ -103,10 +103,10 @@ discard block |
||
| 103 | 103 | |
| 104 | 104 | public function getTitleID(string $titleURL, int $siteID) { |
| 105 | 105 | $query = $this->db->select('id') |
| 106 | - ->from('tracker_titles') |
|
| 107 | - ->where('title_url', $titleURL) |
|
| 108 | - ->where('site_id', $siteID) |
|
| 109 | - ->get(); |
|
| 106 | + ->from('tracker_titles') |
|
| 107 | + ->where('title_url', $titleURL) |
|
| 108 | + ->where('site_id', $siteID) |
|
| 109 | + ->get(); |
|
| 110 | 110 | |
| 111 | 111 | if($query->num_rows() > 0) { |
| 112 | 112 | $titleID = $query->row('id'); |
@@ -140,9 +140,9 @@ discard block |
||
| 140 | 140 | } |
| 141 | 141 | if($this->db->select('*')->where('user_id', $userID)->where('title_id', $titleID)->get('tracker_chapters')->num_rows() > 0) { |
| 142 | 142 | $success = $this->db->set(['current_chapter' => $chapter, 'last_updated' => NULL]) |
| 143 | - ->where('user_id', $userID) |
|
| 144 | - ->where('title_id', $titleID) |
|
| 145 | - ->update('tracker_chapters'); |
|
| 143 | + ->where('user_id', $userID) |
|
| 144 | + ->where('title_id', $titleID) |
|
| 145 | + ->update('tracker_chapters'); |
|
| 146 | 146 | } else { |
| 147 | 147 | $success = $this->db->insert('tracker_chapters', [ |
| 148 | 148 | 'user_id' => $userID, |
@@ -157,31 +157,31 @@ discard block |
||
| 157 | 157 | |
| 158 | 158 | public function updateTrackerByID(int $userID, int $chapterID, string $chapter) : bool { |
| 159 | 159 | $success = $this->db->set(['current_chapter' => $chapter, 'last_updated' => NULL]) |
| 160 | - ->where('user_id', $userID) |
|
| 161 | - ->where('id', $chapterID) |
|
| 162 | - ->update('tracker_chapters'); |
|
| 160 | + ->where('user_id', $userID) |
|
| 161 | + ->where('id', $chapterID) |
|
| 162 | + ->update('tracker_chapters'); |
|
| 163 | 163 | |
| 164 | 164 | return (bool) $success; |
| 165 | 165 | } |
| 166 | 166 | |
| 167 | 167 | public function deleteTrackerByID(int $userID, int $chapterID) { |
| 168 | 168 | $success = $this->db->where('user_id', $userID) |
| 169 | - ->where('id', $chapterID) |
|
| 170 | - ->delete('tracker_chapters'); |
|
| 169 | + ->where('id', $chapterID) |
|
| 170 | + ->delete('tracker_chapters'); |
|
| 171 | 171 | |
| 172 | 172 | return (bool) $success; |
| 173 | 173 | } |
| 174 | 174 | private function updateTitleById(int $id, string $latestChapter) { |
| 175 | 175 | //FIXME: Really not too happy with how we're doing history stuff here, it just feels messy. |
| 176 | 176 | $query = $this->db->select('latest_chapter, last_updated') |
| 177 | - ->from('tracker_titles') |
|
| 178 | - ->where('id', $id) |
|
| 179 | - ->get(); |
|
| 177 | + ->from('tracker_titles') |
|
| 178 | + ->where('id', $id) |
|
| 179 | + ->get(); |
|
| 180 | 180 | $row = $query->row(); |
| 181 | 181 | |
| 182 | 182 | $success = $this->db->set(['latest_chapter' => $latestChapter]) //last_updated gets updated via a trigger if something changes |
| 183 | - ->where('id', $id) |
|
| 184 | - ->update('tracker_titles'); |
|
| 183 | + ->where('id', $id) |
|
| 184 | + ->update('tracker_titles'); |
|
| 185 | 185 | |
| 186 | 186 | //Update History |
| 187 | 187 | $this->History->updateTitleHistory($id, $row->latest_chapter, $row->last_updated); |
@@ -190,16 +190,16 @@ discard block |
||
| 190 | 190 | } |
| 191 | 191 | private function updateTitleDataById(int $id, array $titleData) { |
| 192 | 192 | $success = $this->db->set($titleData) |
| 193 | - ->where('id', $id) |
|
| 194 | - ->update('tracker_titles'); |
|
| 193 | + ->where('id', $id) |
|
| 194 | + ->update('tracker_titles'); |
|
| 195 | 195 | |
| 196 | 196 | return (bool) $success; |
| 197 | 197 | } |
| 198 | 198 | private function addTitle(string $titleURL, int $siteID) { |
| 199 | 199 | $query = $this->db->select('site, site_class') |
| 200 | - ->from('tracker_sites') |
|
| 201 | - ->where('id', $siteID) |
|
| 202 | - ->get(); |
|
| 200 | + ->from('tracker_sites') |
|
| 201 | + ->where('id', $siteID) |
|
| 202 | + ->get(); |
|
| 203 | 203 | |
| 204 | 204 | $titleData = $this->sites->{$query->row()->site_class}->getTitleData($titleURL); |
| 205 | 205 | $this->db->insert('tracker_titles', array_merge($titleData, ['title_url' => $titleURL, 'site_id' => $siteID])); |
@@ -224,18 +224,18 @@ discard block |
||
| 224 | 224 | tracker_titles.last_updated, |
| 225 | 225 | from_unixtime(MAX(auth_users.last_login)) AS timestamp |
| 226 | 226 | ') |
| 227 | - ->from('tracker_titles') |
|
| 228 | - ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left') |
|
| 229 | - ->join('tracker_chapters', 'tracker_titles.id = tracker_chapters.title_id', 'left') |
|
| 230 | - ->join('auth_users', 'tracker_chapters.user_id = auth_users.id', 'left') |
|
| 231 | - ->where('tracker_sites.status = "enabled"') |
|
| 232 | - ->where('(`complete` = "N" AND (`latest_chapter` = NULL OR `last_checked` < DATE_SUB(NOW(), INTERVAL 12 HOUR)))', NULL, FALSE) //TODO: Each title should have specific interval time? |
|
| 233 | - ->or_where('(`complete` = "Y" AND `last_checked` < DATE_SUB(NOW(), INTERVAL 1 WEEK))', NULL, FALSE) |
|
| 234 | - ->group_by('tracker_titles.id') |
|
| 235 | - ->having('timestamp IS NOT NULL') |
|
| 236 | - ->having('timestamp > DATE_SUB(NOW(), INTERVAL 120 HOUR)') |
|
| 237 | - ->order_by('tracker_titles.title', 'ASC') |
|
| 238 | - ->get(); |
|
| 227 | + ->from('tracker_titles') |
|
| 228 | + ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left') |
|
| 229 | + ->join('tracker_chapters', 'tracker_titles.id = tracker_chapters.title_id', 'left') |
|
| 230 | + ->join('auth_users', 'tracker_chapters.user_id = auth_users.id', 'left') |
|
| 231 | + ->where('tracker_sites.status = "enabled"') |
|
| 232 | + ->where('(`complete` = "N" AND (`latest_chapter` = NULL OR `last_checked` < DATE_SUB(NOW(), INTERVAL 12 HOUR)))', NULL, FALSE) //TODO: Each title should have specific interval time? |
|
| 233 | + ->or_where('(`complete` = "Y" AND `last_checked` < DATE_SUB(NOW(), INTERVAL 1 WEEK))', NULL, FALSE) |
|
| 234 | + ->group_by('tracker_titles.id') |
|
| 235 | + ->having('timestamp IS NOT NULL') |
|
| 236 | + ->having('timestamp > DATE_SUB(NOW(), INTERVAL 120 HOUR)') |
|
| 237 | + ->order_by('tracker_titles.title', 'ASC') |
|
| 238 | + ->get(); |
|
| 239 | 239 | |
| 240 | 240 | if($query->num_rows() > 0) { |
| 241 | 241 | foreach ($query->result() as $row) { |
@@ -248,8 +248,8 @@ discard block |
||
| 248 | 248 | //Make sure last_checked is always updated on successful run. |
| 249 | 249 | //CHECK: Is there a reason we aren't just doing this in updateTitleById? |
| 250 | 250 | $this->db->set('last_checked', 'CURRENT_TIMESTAMP', FALSE) |
| 251 | - ->where('id', $row->id) |
|
| 252 | - ->update('tracker_titles'); |
|
| 251 | + ->where('id', $row->id) |
|
| 252 | + ->update('tracker_titles'); |
|
| 253 | 253 | |
| 254 | 254 | //Update History |
| 255 | 255 | $this->History->updateTitleHistory((int) $row->id, $titleData['latest_chapter'], $titleData['last_updated']); |
@@ -362,9 +362,9 @@ discard block |
||
| 362 | 362 | } |
| 363 | 363 | public function setCategoryTrackerByID(int $userID, int $chapterID, string $category) : bool { |
| 364 | 364 | $success = $this->db->set(['category' => $category, 'last_updated' => NULL]) |
| 365 | - ->where('user_id', $userID) |
|
| 366 | - ->where('id', $chapterID) |
|
| 367 | - ->update('tracker_chapters'); |
|
| 365 | + ->where('user_id', $userID) |
|
| 366 | + ->where('id', $chapterID) |
|
| 367 | + ->update('tracker_chapters'); |
|
| 368 | 368 | |
| 369 | 369 | return (bool) $success; |
| 370 | 370 | } |
@@ -374,9 +374,9 @@ discard block |
||
| 374 | 374 | $success = FALSE; |
| 375 | 375 | if(preg_match("/^[a-z0-9-_,]{0,255}$/", $tag_string)) { |
| 376 | 376 | $success = $this->db->set(['tags' => $tag_string, 'last_updated' => NULL]) |
| 377 | - ->where('user_id', $userID) |
|
| 378 | - ->where('id', $chapterID) |
|
| 379 | - ->update('tracker_chapters'); |
|
| 377 | + ->where('user_id', $userID) |
|
| 378 | + ->where('id', $chapterID) |
|
| 379 | + ->update('tracker_chapters'); |
|
| 380 | 380 | } |
| 381 | 381 | |
| 382 | 382 | return (bool) $success; |
@@ -386,9 +386,9 @@ discard block |
||
| 386 | 386 | $usedCategories = []; |
| 387 | 387 | |
| 388 | 388 | $query = $this->db->distinct() |
| 389 | - ->select('category') |
|
| 390 | - ->from('tracker_chapters') |
|
| 391 | - ->get(); |
|
| 389 | + ->select('category') |
|
| 390 | + ->from('tracker_chapters') |
|
| 391 | + ->get(); |
|
| 392 | 392 | |
| 393 | 393 | return array_column($query->result_array(), 'category'); |
| 394 | 394 | } |
@@ -1,4 +1,4 @@ |
||
| 1 | -<?php declare(strict_types=1); defined('BASEPATH') OR exit('No direct script access allowed'); |
|
| 1 | +<?php declare(strict_types=1); defined('BASEPATH') or exit('No direct script access allowed'); |
|
| 2 | 2 | |
| 3 | 3 | class User_Model extends CI_Model { |
| 4 | 4 | public $id; |
@@ -11,9 +11,9 @@ discard block |
||
| 11 | 11 | $oldChapter = NULL; |
| 12 | 12 | if(!$isNewTitle) { |
| 13 | 13 | $query = $this->db->select('latest_chapter') |
| 14 | - ->from('tracker_titles') |
|
| 15 | - ->where('id', $titleID) |
|
| 16 | - ->get(); |
|
| 14 | + ->from('tracker_titles') |
|
| 15 | + ->where('id', $titleID) |
|
| 16 | + ->get(); |
|
| 17 | 17 | |
| 18 | 18 | $oldChapter = $query->row()->latest_chapter; |
| 19 | 19 | } |
@@ -34,9 +34,9 @@ discard block |
||
| 34 | 34 | |
| 35 | 35 | public function getCurrentChapter(int $titleID) : string { |
| 36 | 36 | $query = $this->db->select('latest_chapter') |
| 37 | - ->from('tracker_titles') |
|
| 38 | - ->where('id', $titleID) |
|
| 39 | - ->get(); |
|
| 37 | + ->from('tracker_titles') |
|
| 38 | + ->where('id', $titleID) |
|
| 39 | + ->get(); |
|
| 40 | 40 | |
| 41 | 41 | return $query->row()->latest_chapter; |
| 42 | 42 | } |
@@ -1,4 +1,4 @@ |
||
| 1 | -<?php declare(strict_types=1); defined('BASEPATH') OR exit('No direct script access allowed'); |
|
| 1 | +<?php declare(strict_types = 1); defined('BASEPATH') OR exit('No direct script access allowed'); |
|
| 2 | 2 | |
| 3 | 3 | class History_Model extends CI_Model { |
| 4 | 4 | public function __construct() { |
@@ -1,4 +1,4 @@ |
||
| 1 | -<?php declare(strict_types=1); defined('BASEPATH') OR exit('No direct script access allowed'); |
|
| 1 | +<?php declare(strict_types=1); defined('BASEPATH') or exit('No direct script access allowed'); |
|
| 2 | 2 | |
| 3 | 3 | class User_Model extends CI_Model { |
| 4 | 4 | public $id; |