DakuTree / manga-tracker

public/index.php

Indentation +4 added lines, -4 removed lines

@@ -210,10 +210,10 @@
 {
 	// Ensure there's a trailing slash
 	$system_path = strtr(
-		               rtrim($system_path, '/\\'),
-		               '/\\',
-		               DIRECTORY_SEPARATOR.DIRECTORY_SEPARATOR
-	               ).DIRECTORY_SEPARATOR;
+					   rtrim($system_path, '/\\'),
+					   '/\\',
+					   DIRECTORY_SEPARATOR.DIRECTORY_SEPARATOR
+				   ).DIRECTORY_SEPARATOR;
 }
 
 // Is the system path correct?

application/models/Auth_Model.php

Indentation +3 added lines, -3 removed lines

@@ -77,9 +77,9 @@
 	public function verification_check(string $verificationCode) {
 		//user is trying to validate their email for signup, check if verification code is still valid/exists
 		$query = $this->db->select('email, verification_code_time')
-		                  ->from('auth_signup_verification')
-		                  ->where(array('verification_code' => $verificationCode))
-		                  ->get();
+						  ->from('auth_signup_verification')
+						  ->where(array('verification_code' => $verificationCode))
+						  ->get();
 
 		$return = FALSE;
 		if($query->num_rows() > 0) {

application/models/User_Model.php

Indentation +12 added lines, -12 removed lines

@@ -40,9 +40,9 @@ 
 		$this->load->database();
 
 		$query = $this->db->select('*')
-		                  ->from('auth_users')
-		                  ->where('username', $username)
-		                  ->get();
+						  ->from('auth_users')
+						  ->where('username', $username)
+						  ->get();
 
 		return (bool) $query->num_rows();
 	}
@@ -64,9 +64,9 @@ 
 			$this->load->database();
 
 			$query = $this->db->select('email')
-			                  ->from('auth_users')
-			                  ->where('username', $identity)
-			                  ->get();
+							  ->from('auth_users')
+							  ->where('username', $identity)
+							  ->get();
 
 			if($query->num_rows() > 0) {
 				//username exists, grab email
@@ -84,9 +84,9 @@ 
 		$user = NULL;
 
 		$query = $this->db->select('*')
-		                  ->from('auth_users')
-		                  ->where('username', $username)
-		                  ->get();
+						  ->from('auth_users')
+						  ->where('username', $username)
+						  ->get();
 
 		if($query->num_rows() > 0) {
 			$user = $query->row();
@@ -114,9 +114,9 @@ 
 	
 	public function get_id_from_api_key(string $api_key) {
 		$query = $this->db->select('id')
-		                  ->from('auth_users')
-		                  ->where('api_key', $api_key)
-		                  ->get();
+						  ->from('auth_users')
+						  ->where('api_key', $api_key)
+						  ->get();
 
 		if($query->num_rows() > 0) {
 			$userID = $query->row('id');

application/tests_codeception/_support/UnitTester.php

Indentation +1 added lines, -1 removed lines

@@ -18,7 +18,7 @@
 */
 class UnitTester extends \Codeception\Actor
 {
-    use _generated\UnitTesterActions;
+	use _generated\UnitTesterActions;
 
    /**
     * Define custom actions here

application/tests_codeception/_support/AcceptanceTester.php

Indentation +1 added lines, -1 removed lines

@@ -18,7 +18,7 @@
 */
 class AcceptanceTester extends \Codeception\Actor
 {
-    use _generated\AcceptanceTesterActions;
+	use _generated\AcceptanceTesterActions;
 
    /**
     * Define custom actions here

application/tests_codeception/_support/FunctionalTester.php

Indentation +1 added lines, -1 removed lines

@@ -18,7 +18,7 @@
 */
 class FunctionalTester extends \Codeception\Actor
 {
-    use _generated\FunctionalTesterActions;
+	use _generated\FunctionalTesterActions;
 
    /**
     * Define custom actions here

application/models/Tracker_Model.php

Indentation +94 added lines, -94 removed lines

@@ -155,9 +155,9 @@ 
 
 	public function getSiteDataFromURL(string $site_url) {
 		$query = $this->db->select('id, site_class')
-		                  ->from('tracker_sites')
-		                  ->where('site', $site_url)
-		                  ->get();
+						  ->from('tracker_sites')
+						  ->where('site', $site_url)
+						  ->get();
 
 		if($query->num_rows() > 0) {
 			$siteData = $query->row();
@@ -168,11 +168,11 @@ 
 
 	public function getTitleID(string $titleURL, int $siteID) {
 		$query = $this->db->select('tracker_titles.id, tracker_titles.title, tracker_titles.title_url, tracker_titles.complete, tracker_sites.site_class, (tracker_titles.last_checked > DATE_SUB(NOW(), INTERVAL 3 DAY)) AS active', FALSE)
-		                  ->from('tracker_titles')
-		                  ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left')
-		                  ->where('tracker_titles.title_url', $titleURL)
-		                  ->where('tracker_titles.site_id', $siteID)
-		                  ->get();
+						  ->from('tracker_titles')
+						  ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left')
+						  ->where('tracker_titles.title_url', $titleURL)
+						  ->where('tracker_titles.site_id', $siteID)
+						  ->get();
 
 		if($query->num_rows() > 0) {
 			$id = (int) $query->row('id');
@@ -185,8 +185,8 @@ 
 						//Make sure last_checked is always updated on successful run.
 						//CHECK: Is there a reason we aren't just doing this in updateTitleById?
 						$this->db->set('last_checked', 'CURRENT_TIMESTAMP', FALSE)
-						         ->where('id', $id)
-						         ->update('tracker_titles');
+								 ->where('id', $id)
+								 ->update('tracker_titles');
 					}
 				} else {
 					log_message('error', "{$query->row('title')} failed to update successfully");
@@ -224,14 +224,14 @@ 
 			}
 
 			$idQuery = $this->db->select('id')
-			                    ->where('user_id', $userID)
-			                    ->where('title_id', $titleID)
-			                    ->get('tracker_chapters');
+								->where('user_id', $userID)
+								->where('title_id', $titleID)
+								->get('tracker_chapters');
 			if($idQuery->num_rows() > 0) {
 				$success = (bool) $this->db->set(['current_chapter' => $chapter, 'active' => 'Y', 'last_updated' => NULL])
-				                    ->where('user_id', $userID)
-				                    ->where('title_id', $titleID)
-				                    ->update('tracker_chapters');
+									->where('user_id', $userID)
+									->where('title_id', $titleID)
+									->update('tracker_chapters');
 
 				if($success) {
 					$idQueryRow = $idQuery->row();
@@ -256,9 +256,9 @@ 
 
 	public function updateTrackerByID(int $userID, int $chapterID, string $chapter) : bool {
 		$success = (bool) $this->db->set(['current_chapter' => $chapter, 'active' => 'Y', 'last_updated' => NULL])
-		                    ->where('user_id', $userID)
-		                    ->where('id', $chapterID)
-		                    ->update('tracker_chapters');
+							->where('user_id', $userID)
+							->where('id', $chapterID)
+							->update('tracker_chapters');
 
 		if($success) {
 			$this->History->userUpdateTitle($chapterID, $chapter);
@@ -271,23 +271,23 @@ 
 		//This is to allow user history to function properly.
 
 		$success = $this->db->set(['active' => 'N', 'last_updated' => NULL])
-		                    ->where('user_id', $userID)
-		                    ->where('id', $chapterID)
-		                    ->update('tracker_chapters');
+							->where('user_id', $userID)
+							->where('id', $chapterID)
+							->update('tracker_chapters');
 
 		return (bool) $success;
 	}
 	private function updateTitleById(int $id, string $latestChapter) {
 		//FIXME: Really not too happy with how we're doing history stuff here, it just feels messy.
 		$query = $this->db->select('latest_chapter AS current_chapter')
-		                  ->from('tracker_titles')
-		                  ->where('id', $id)
-		                  ->get();
+						  ->from('tracker_titles')
+						  ->where('id', $id)
+						  ->get();
 		$row = $query->row();
 
 		$success = $this->db->set(['latest_chapter' => $latestChapter]) //last_updated gets updated via a trigger if something changes
-		                    ->where('id', $id)
-		                    ->update('tracker_titles');
+							->where('id', $id)
+							->update('tracker_titles');
 
 		//Update History
 		//NOTE: To avoid doing another query to grab the last_updated time, we just use time() which <should> get the same thing.
@@ -298,16 +298,16 @@ 
 	}
 	private function updateTitleDataById(int $id, array $titleData) {
 		$success = $this->db->set($titleData)
-		                    ->where('id', $id)
-		                    ->update('tracker_titles');
+							->where('id', $id)
+							->update('tracker_titles');
 
 		return (bool) $success;
 	}
 	private function addTitle(string $titleURL, int $siteID) {
 		$query = $this->db->select('site, site_class')
-		                  ->from('tracker_sites')
-		                  ->where('id', $siteID)
-		                  ->get();
+						  ->from('tracker_sites')
+						  ->where('id', $siteID)
+						  ->get();
 
 		$titleData = $this->sites->{$query->row()->site_class}->getTitleData($titleURL);
 		//FIXME: getTitleData can fail, which will in turn cause the below to fail aswell, we should try and account for that
@@ -359,8 +359,8 @@ 
 						//Make sure last_checked is always updated on successful run.
 						//CHECK: Is there a reason we aren't just doing this in updateTitleById?
 						$this->db->set('last_checked', 'CURRENT_TIMESTAMP', FALSE)
-						         ->where('id', $row->id)
-						         ->update('tracker_titles');
+								 ->where('id', $row->id)
+								 ->update('tracker_titles');
 
 						print " - ({$titleData['latest_chapter']})\n";
 					}
@@ -477,9 +477,9 @@ 
 	}
 	public function setCategoryTrackerByID(int $userID, int $chapterID, string $category) : bool {
 		$success = $this->db->set(['category' => $category, 'active' => 'Y', 'last_updated' => NULL])
-		                    ->where('user_id', $userID)
-		                    ->where('id', $chapterID)
-		                    ->update('tracker_chapters');
+							->where('user_id', $userID)
+							->where('id', $chapterID)
+							->update('tracker_chapters');
 
 		return (bool) $success;
 	}
@@ -489,9 +489,9 @@ 
 		$success = FALSE;
 		if(preg_match("/^[a-z0-9-_,]{0,255}$/", $tag_string)) {
 			$success = (bool) $this->db->set(['tags' => $tag_string, 'active' => 'Y', 'last_updated' => NULL])
-			                           ->where('user_id', $userID)
-			                           ->where('id', $chapterID)
-			                           ->update('tracker_chapters');
+									   ->where('user_id', $userID)
+									   ->where('id', $chapterID)
+									   ->update('tracker_chapters');
 		}
 
 		if($success) {
@@ -529,23 +529,23 @@ 
 
 			//We need the series to be tracked
 			$idCQuery = $this->db->select('id')
-			                    ->where('user_id', $userID)
-			                    ->where('title_id', $titleID)
-			                    ->get('tracker_chapters');
+								->where('user_id', $userID)
+								->where('title_id', $titleID)
+								->get('tracker_chapters');
 			if($idCQuery->num_rows() > 0) {
 				$idCQueryRow = $idCQuery->row();
 
 				//Check if it is already favourited
 				$idFQuery = $this->db->select('id')
-				                    ->where('chapter_id', $idCQueryRow->id)
-				                    ->where('chapter', $chapter)
-				                    ->get('tracker_favourites');
+									->where('chapter_id', $idCQueryRow->id)
+									->where('chapter', $chapter)
+									->get('tracker_favourites');
 				if($idFQuery->num_rows() > 0) {
 					//Chapter is already favourited, so remove it from DB
 					$idFQueryRow = $idFQuery->row();
 
 					$isSuccess = (bool) $this->db->where('id', $idFQueryRow->id)
-					                           ->delete('tracker_favourites');
+											   ->delete('tracker_favourites');
 
 					if($isSuccess) {
 						$success = array(
@@ -616,11 +616,11 @@ 
 
 	public function getUsedCategories(int $userID) : array {
 		$query = $this->db->distinct()
-		                  ->select('category')
-		                  ->from('tracker_chapters')
-		                  ->where('tracker_chapters.active', 'Y')
-		                  ->where('user_id', $userID)
-		                  ->get();
+						  ->select('category')
+						  ->from('tracker_chapters')
+						  ->where('tracker_chapters.active', 'Y')
+						  ->where('user_id', $userID)
+						  ->get();
 
 		return array_column($query->result_array(), 'category');
 	}
@@ -631,51 +631,51 @@ 
 
 			//CHECK: Is it possible to merge some of these queries?
 			$queryUsers = $this->db->select([
-			                            'COUNT(*) AS total_users',
-			                            'SUM(CASE WHEN api_key IS NOT NULL THEN 1 ELSE 0 END) AS validated_users',
-			                            'SUM(CASE WHEN (api_key IS NOT NULL AND from_unixtime(last_login) > DATE_SUB(NOW(), INTERVAL 7 DAY)) THEN 1 ELSE 0 END) AS active_users'
-			                       ], FALSE)
-			                       ->from('auth_users')
-			                       ->get();
+										'COUNT(*) AS total_users',
+										'SUM(CASE WHEN api_key IS NOT NULL THEN 1 ELSE 0 END) AS validated_users',
+										'SUM(CASE WHEN (api_key IS NOT NULL AND from_unixtime(last_login) > DATE_SUB(NOW(), INTERVAL 7 DAY)) THEN 1 ELSE 0 END) AS active_users'
+								   ], FALSE)
+								   ->from('auth_users')
+								   ->get();
 			$stats = array_merge($stats, $queryUsers->result_array()[0]);
 
 			$queryCounts = $this->db->select([
-			                             'tracker_titles.title',
-			                             'COUNT(tracker_chapters.title_id) AS count'
-			                        ], FALSE)
-			                        ->from('tracker_chapters')
-			                        ->join('tracker_titles', 'tracker_titles.id = tracker_chapters.title_id', 'left')
-			                        ->group_by('tracker_chapters.title_id')
-			                        ->having('count > 1')
-			                        ->order_by('count DESC')
-			                        ->get();
+										 'tracker_titles.title',
+										 'COUNT(tracker_chapters.title_id) AS count'
+									], FALSE)
+									->from('tracker_chapters')
+									->join('tracker_titles', 'tracker_titles.id = tracker_chapters.title_id', 'left')
+									->group_by('tracker_chapters.title_id')
+									->having('count > 1')
+									->order_by('count DESC')
+									->get();
 			$stats['titles_tracked_more'] = count($queryCounts->result_array());
 			$stats['top_title_name']  = $queryCounts->result_array()[0]['title'] ?? 'N/A';
 			$stats['top_title_count'] = $queryCounts->result_array()[0]['count'] ?? 'N/A';
 
 			$queryTitles = $this->db->select([
-			                             'COUNT(DISTINCT tracker_titles.id) AS total_titles',
-			                             'COUNT(DISTINCT tracker_titles.site_id) AS total_sites',
-			                             'SUM(CASE WHEN from_unixtime(auth_users.last_login) > DATE_SUB(NOW(), INTERVAL 120 HOUR) IS NOT NULL THEN 0 ELSE 1 END) AS inactive_titles',
-			                             'SUM(CASE WHEN (tracker_titles.last_updated > DATE_SUB(NOW(), INTERVAL 24 HOUR)) THEN 1 ELSE 0 END) AS updated_titles'
-			                        ], FALSE)
-			                        ->from('tracker_titles')
-			                        ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left')
-			                        ->join('tracker_chapters', 'tracker_titles.id = tracker_chapters.title_id', 'left')
-			                        ->join('auth_users', 'tracker_chapters.user_id = auth_users.id', 'left')
-			                        ->get();
+										 'COUNT(DISTINCT tracker_titles.id) AS total_titles',
+										 'COUNT(DISTINCT tracker_titles.site_id) AS total_sites',
+										 'SUM(CASE WHEN from_unixtime(auth_users.last_login) > DATE_SUB(NOW(), INTERVAL 120 HOUR) IS NOT NULL THEN 0 ELSE 1 END) AS inactive_titles',
+										 'SUM(CASE WHEN (tracker_titles.last_updated > DATE_SUB(NOW(), INTERVAL 24 HOUR)) THEN 1 ELSE 0 END) AS updated_titles'
+									], FALSE)
+									->from('tracker_titles')
+									->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left')
+									->join('tracker_chapters', 'tracker_titles.id = tracker_chapters.title_id', 'left')
+									->join('auth_users', 'tracker_chapters.user_id = auth_users.id', 'left')
+									->get();
 			$stats = array_merge($stats, $queryTitles->result_array()[0]);
 
 			$querySites = $this->db->select([
-			                           'tracker_sites.site',
-			                           'COUNT(*) AS count'
-			                       ], FALSE)
-			                       ->from('tracker_titles')
-			                       ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left')
-			                       ->group_by('tracker_titles.site_id')
-			                       ->order_by('count DESC')
-			                       ->limit(3)
-			                       ->get();
+									   'tracker_sites.site',
+									   'COUNT(*) AS count'
+								   ], FALSE)
+								   ->from('tracker_titles')
+								   ->join('tracker_sites', 'tracker_sites.id = tracker_titles.site_id', 'left')
+								   ->group_by('tracker_titles.site_id')
+								   ->order_by('count DESC')
+								   ->limit(3)
+								   ->get();
 			$querySitesResult = $querySites->result_array();
 			$stats['rank1_site']       = $querySitesResult[0]['site'];
 			$stats['rank1_site_count'] = $querySitesResult[0]['count'];
@@ -685,17 +685,17 @@ 
 			$stats['rank3_site_count'] = $querySitesResult[2]['count'];
 
 			$queryTitlesU = $this->db->select([
-			                             'COUNT(*) AS title_updated_count'
-			                         ], FALSE)
-			                         ->from('tracker_titles_history')
-			                         ->get();
+										 'COUNT(*) AS title_updated_count'
+									 ], FALSE)
+									 ->from('tracker_titles_history')
+									 ->get();
 			$stats = array_merge($stats, $queryTitlesU->result_array()[0]);
 
 			$queryUsersU = $this->db->select([
-			                            'COUNT(*) AS user_updated_count'
-			                        ], FALSE)
-			                        ->from('tracker_user_history')
-			                        ->get();
+										'COUNT(*) AS user_updated_count'
+									], FALSE)
+									->from('tracker_user_history')
+									->get();
 			$stats = array_merge($stats, $queryUsersU->result_array()[0]);
 
 			$stats['live_time'] = timespan(/*2016-09-10T03:17:19*/ 1473477439, time(), 2);

application/models/User_Options_Model.php

Indentation +4 added lines, -4 removed lines

@@ -170,10 +170,10 @@
 		//This function assumes we've already done some basic validation.
 		if(!($data = $this->session->tempdata("option_{$option}"))) {
 			$query = $this->db->select('value_str, value_int')
-			                  ->from('user_options')
-			                  ->where('user_id', $userID)
-			                  ->where('name',    $option)
-			                  ->limit(1);
+							  ->from('user_options')
+							  ->where('user_id', $userID)
+							  ->where('name',    $option)
+							  ->limit(1);
 			$data = $query->get()->row_array();
 			$this->session->set_tempdata("option_{$option}", $data, 3600);
 		}