@@ -44,12 +44,12 @@ discard block |
||
| 44 | 44 | |
| 45 | 45 | private function _list_complete_titles() { |
| 46 | 46 | $query = $this->db->select('tracker_titles.id, tracker_sites.site_class, tracker_titles.title, tracker_titles.title_url') |
| 47 | - ->from('tracker_chapters') |
|
| 48 | - ->join('tracker_titles', 'tracker_chapters.title_id = tracker_titles.id', 'left') |
|
| 49 | - ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left') |
|
| 50 | - ->like('tracker_chapters.tags', 'complete') |
|
| 51 | - ->where('tracker_titles.status', 0) |
|
| 52 | - ->get(); |
|
| 47 | + ->from('tracker_chapters') |
|
| 48 | + ->join('tracker_titles', 'tracker_chapters.title_id = tracker_titles.id', 'left') |
|
| 49 | + ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left') |
|
| 50 | + ->like('tracker_chapters.tags', 'complete') |
|
| 51 | + ->where('tracker_titles.status', 0) |
|
| 52 | + ->get(); |
|
| 53 | 53 | |
| 54 | 54 | $completeList = []; |
| 55 | 55 | if($query->num_rows() > 0) { |
@@ -68,10 +68,10 @@ discard block |
||
| 68 | 68 | |
| 69 | 69 | private function _update_mal_id() : void { |
| 70 | 70 | $query = $this->db->select('id, tags') |
| 71 | - ->from('tracker_chapters') |
|
| 72 | - ->where('tags REGEXP "[[:<:]]mal:([0-9]+|none)[[:>:]]"', NULL, FALSE) |
|
| 73 | - ->where('mal_id', NULL) |
|
| 74 | - ->get(); |
|
| 71 | + ->from('tracker_chapters') |
|
| 72 | + ->where('tags REGEXP "[[:<:]]mal:([0-9]+|none)[[:>:]]"', NULL, FALSE) |
|
| 73 | + ->where('mal_id', NULL) |
|
| 74 | + ->get(); |
|
| 75 | 75 | |
| 76 | 76 | |
| 77 | 77 | if($query->num_rows() > 0) { |
@@ -83,8 +83,8 @@ discard block |
||
| 83 | 83 | $new_tags = implode(',', array_diff( explode(',', $row->tags), [$matches[0]])); |
| 84 | 84 | |
| 85 | 85 | $this->db->set(['mal_id' => $malID, 'tags' => $new_tags, 'last_updated' => NULL]) |
| 86 | - ->where('id', $row->id) |
|
| 87 | - ->update('tracker_chapters'); |
|
| 86 | + ->where('id', $row->id) |
|
| 87 | + ->update('tracker_chapters'); |
|
| 88 | 88 | } |
| 89 | 89 | } |
| 90 | 90 | } |
@@ -1,4 +1,4 @@ discard block |
||
| 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 AdminPanel extends Admin_Controller { |
| 4 | 4 | public function __construct() { |
@@ -80,7 +80,7 @@ discard block |
||
| 80 | 80 | |
| 81 | 81 | if(!empty($matches)) { |
| 82 | 82 | $malID = ($matches[1] !== 'none' ? $matches[1] : '0'); |
| 83 | - $new_tags = implode(',', array_diff( explode(',', $row->tags), [$matches[0]])); |
|
| 83 | + $new_tags = implode(',', array_diff(explode(',', $row->tags), [$matches[0]])); |
|
| 84 | 84 | |
| 85 | 85 | $this->db->set(['mal_id' => $malID, 'tags' => $new_tags, 'last_updated' => NULL]) |
| 86 | 86 | ->where('id', $row->id) |