Inspection of "Update header.php" - the-real-sumsome/subrocks-2012 - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed

Push — main ( 241bcb...01cf0c )

by chief

created 2021-11-24 02:05 UTC

Status

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

@@ -140,7 +140,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -175,7 +175,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -210,7 +210,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -245,7 +245,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -280,7 +280,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);

Please login to merge, or discard this patch.

web/public/film.php 1 patch

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

@@ -140,7 +140,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -175,7 +175,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -210,7 +210,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -245,7 +245,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -280,7 +280,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);

Please login to merge, or discard this patch.

web/public/pets.php 1 patch

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

@@ -140,7 +140,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -175,7 +175,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -210,7 +210,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -245,7 +245,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -280,7 +280,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);

Please login to merge, or discard this patch.

web/public/favorite_ajax.php 1 patch

Spacing +15 added lines, -15 removed lines patch added patch discarded remove patch

@@ -11,11 +11,11 @@  discard block
 block discarded – undo
 <?php
     $search = $_SESSION['siteusername'];
 
-    if($_GET['filter'] == "time") {
+    if ($_GET['filter'] == "time") {
         $stmt = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :username ORDER BY id DESC");
         $stmt->bindParam(":username", $_SESSION['siteusername']);
         $stmt->execute();
-    } else if($_GET['filter'] == "title") {
+    } else if ($_GET['filter'] == "title") {
         $stmt = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :username ORDER BY title DESC");
         $stmt->bindParam(":username", $_SESSION['siteusername']);
         $stmt->execute();
@@ -23,23 +23,23 @@  discard block
 block discarded – undo
 
     $results_per_page = 12;
     $number_of_result = $stmt->rowCount();
-    $number_of_page = ceil ($number_of_result / $results_per_page);  
+    $number_of_page = ceil($number_of_result/$results_per_page);  
 
-    if (!isset ($_GET['page']) ) {  
+    if (!isset ($_GET['page'])) {  
         $page = 1;  
     } else {  
-        $page = (int)$_GET['page'];  
+        $page = (int) $_GET['page'];  
     }  
 
-    $page_first_result = ($page - 1) * $results_per_page;
+    $page_first_result = ($page - 1)*$results_per_page;
 
-    if($_GET['filter'] == "time") {
+    if ($_GET['filter'] == "time") {
         $stmt6 = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :search ORDER BY id DESC LIMIT :pfirst, :pper");
         $stmt6->bindParam(":search", $search);
         $stmt6->bindParam(":pfirst", $page_first_result);
         $stmt6->bindParam(":pper", $results_per_page);
         $stmt6->execute();
-    } else if($_GET['filter'] == "title") {
+    } else if ($_GET['filter'] == "title") {
         $stmt6 = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :search ORDER BY title LIMIT :pfirst, :pper");
         $stmt6->bindParam(":search", $search);
         $stmt6->bindParam(":pfirst", $page_first_result);
@@ -56,8 +56,8 @@  discard block
 block discarded – undo
     </tr>
     
     <?php
-        while($video = $stmt6->fetch(PDO::FETCH_ASSOC)) { 
-            if($__video_h->video_exists($video['reciever'])) {
+        while ($video = $stmt6->fetch(PDO::FETCH_ASSOC)) { 
+            if ($__video_h->video_exists($video['reciever'])) {
                 $_video = $__video_h->fetch_video_rid($video['reciever']);
                 $_video['video_responses'] = $__video_h->get_video_responses($_video['rid']);
                 $_video['age'] = $__time_h->time_elapsed_string($_video['publish']);		
@@ -67,19 +67,19 @@  discard block
 block discarded – undo
                 $_video['title'] = htmlspecialchars($_video['title']);
                 $_video['description'] = $__video_h->shorten_description($_video['description'], 50);
 
-                if($_video['thumbnail'] == ".png" && $_video['filename'] == ".mp4") {
+                if ($_video['thumbnail'] == ".png" && $_video['filename'] == ".mp4") {
                     $status = "Corrupted";
-                } else if($_video['visibility'] == "v") {
+                } else if ($_video['visibility'] == "v") {
                     $status = "Approved";
-                } else if($_video['visibility'] == "n") {
+                } else if ($_video['visibility'] == "n") {
                     $status = "Approved";
-                } else if($_video['visibility'] == "o") {
+                } else if ($_video['visibility'] == "o") {
                     $status = "Disapproved";
                 } else {
                     $status = "Unknown";
                 }                      
                 
-                if($_video['commenting'] == "a") 
+                if ($_video['commenting'] == "a") 
                     $_video['commentstatus'] = "Commenting allowed";
                 else 
                     $_video['commentstatus'] = "Commenting disallowed";

Please login to merge, or discard this patch.

web/public/recommended.php 1 patch

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

@@ -140,7 +140,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -175,7 +175,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -210,7 +210,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -245,7 +245,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
@@ -280,7 +280,7 @@  discard block
 block discarded – undo
 										<?php
 											$stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4");
 											$stmt->execute();
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);		
 												$video['duration'] = $__time_h->timestamp($video['duration']);
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);

Please login to merge, or discard this patch.

web/public/guide_ajax.php 1 patch

Spacing +4 added lines, -4 removed lines patch added patch discarded remove patch

@@ -11,8 +11,8 @@  discard block
 block discarded – undo
 <?php $__time_h = new time_helper(); ?>
 <?php header('Content-Type: application/json'); ?>
 <?php
-    if(!isset($_GET['action_load_user_feed'])) {
-        switch(@$_GET['chart_name']) {
+    if (!isset($_GET['action_load_user_feed'])) {
+        switch (@$_GET['chart_name']) {
         case "trending":
             $category = 'Trending';
             $diviconn = 'trending';
@@ -47,7 +47,7 @@  discard block
 block discarded – undo
             break;
         }
         
-        switch(@$_GET['feed_name']) {
+        switch (@$_GET['feed_name']) {
         case "trending":
             $category = 'Trending';
             $diviconn = 'trending';
@@ -107,7 +107,7 @@  discard block
 block discarded – undo
 <div class=\'feed-page\'>
 	<ul>
         <?php
-            while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
+            while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {	
                 $video['age'] = $__time_h->time_elapsed_string($video['publish']);		
                 $video['duration'] = $__time_h->timestamp($video['duration']);
                 $video['views'] = $__video_h->fetch_video_views($video['rid']);

Please login to merge, or discard this patch.

web/public/d/login.php 1 patch

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

@@ -9,7 +9,7 @@  discard block
 block discarded – undo
 <?php $__db_h = new db_helper(); ?>
 <?php $__time_h = new time_helper(); ?>
 <?php
-    if($_SERVER['REQUEST_METHOD'] == 'POST' && $_POST['password'] && $_POST['username']) {
+    if ($_SERVER['REQUEST_METHOD'] == 'POST' && $_POST['password'] && $_POST['username']) {
         $request = (object) [
             "username" => $_POST['username'],
             "password" => $_POST['password'],
@@ -26,19 +26,19 @@  discard block
 block discarded – undo
         $stmt->bindParam(":username", $request->username);
         $stmt->execute();
 
-        if(!$stmt->rowCount()){ 
+        if (!$stmt->rowCount()) { 
             { $request->error->message = "Incorrect username or password!"; $request->error->status = ""; } }
 
         $row = $stmt->fetch(PDO::FETCH_ASSOC);
-        if(!isset($row['password'])) 
+        if (!isset($row['password'])) 
             { $request->error->message = "Incorrect username or password!"; $request->error->status = ""; } 
         else 
             { $request->returned_password = $row['password']; }
 
-        if(!password_verify($request->password, $request->returned_password)) 
+        if (!password_verify($request->password, $request->returned_password)) 
             { $request->error->message = "Incorrect username or password!"; $request->error->status = ""; }
         
-        if($request->error->status == "OK") {
+        if ($request->error->status == "OK") {
             $_SESSION['siteusername'] = $request->username;
             header("Location: /");
         } else {

Please login to merge, or discard this patch.

web/public/s/classes/user_insert.php 1 patch

Spacing +2 added lines, -2 removed lines patch added patch discarded remove patch

@@ -10,7 +10,7 @@  discard block
 block discarded – undo
 class user_insert {
     public $__db;
 
-	public function __construct($conn){
+	public function __construct($conn) {
         $this->__db = $conn;
 	}
 
@@ -19,7 +19,7 @@  discard block
 block discarded – undo
         $stmt->bindParam(":user", $user);
         $stmt->bindParam(":vidid", $vidid);
         $stmt->execute();
-        if($stmt->rowCount() === 0) {
+        if ($stmt->rowCount() === 0) {
             $this->add_view_channel($vidid, $user);
         }
     }

Please login to merge, or discard this patch.

web/public/s/classes/user_update.php 1 patch

Spacing +3 added lines, -3 removed lines patch added patch discarded remove patch

@@ -10,20 +10,20 @@
 block discarded – undo
 class user_update {
     public $__db;
 
-	public function __construct($conn){
+	public function __construct($conn) {
         $this->__db = $conn;
 	}
 
     // fuck this, this can be compressed into 2 functions
 
     function update_cooldown_time($username, $rowName) {
-        $stmt = $this->__db->prepare("UPDATE users SET ".$rowName." = now() WHERE username = :username");
+        $stmt = $this->__db->prepare("UPDATE users SET " . $rowName . " = now() WHERE username = :username");
         $stmt->bindParam(":username", $username);
         $stmt->execute();
     }
 
     function update_row($username, $rowName, $new) {
-        $stmt = $this->__db->prepare("UPDATE users SET ".$rowName." = :new WHERE username = :username");
+        $stmt = $this->__db->prepare("UPDATE users SET " . $rowName . " = :new WHERE username = :username");
         $stmt->bindParam(":new", $new);
         $stmt->bindParam(":username", $username);
         $stmt->execute();

Please login to merge, or discard this patch.

		@@ -140,7 +140,7 @@ discard block
		block discarded – undo
140	140	<?php
141	141	$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
142	142	$stmt->execute();
143		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	143	+ while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
144	144	$video['age'] = $__time_h->time_elapsed_string($video['publish']);
145	145	$video['duration'] = $__time_h->timestamp($video['duration']);
146	146	$video['views'] = $__video_h->fetch_video_views($video['rid']);
		@@ -175,7 +175,7 @@ discard block
		block discarded – undo
175	175	<?php
176	176	$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
177	177	$stmt->execute();
178		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	178	+ while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
179	179	$video['age'] = $__time_h->time_elapsed_string($video['publish']);
180	180	$video['duration'] = $__time_h->timestamp($video['duration']);
181	181	$video['views'] = $__video_h->fetch_video_views($video['rid']);
		@@ -210,7 +210,7 @@ discard block
		block discarded – undo
210	210	<?php
211	211	$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
212	212	$stmt->execute();
213		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	213	+ while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
214	214	$video['age'] = $__time_h->time_elapsed_string($video['publish']);
215	215	$video['duration'] = $__time_h->timestamp($video['duration']);
216	216	$video['views'] = $__video_h->fetch_video_views($video['rid']);
		@@ -245,7 +245,7 @@ discard block
		block discarded – undo
245	245	<?php
246	246	$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
247	247	$stmt->execute();
248		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	248	+ while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
249	249	$video['age'] = $__time_h->time_elapsed_string($video['publish']);
250	250	$video['duration'] = $__time_h->timestamp($video['duration']);
251	251	$video['views'] = $__video_h->fetch_video_views($video['rid']);
		@@ -280,7 +280,7 @@ discard block
		block discarded – undo
280	280	<?php
281	281	$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
282	282	$stmt->execute();
283		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	283	+ while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
284	284	$video['age'] = $__time_h->time_elapsed_string($video['publish']);
285	285	$video['duration'] = $__time_h->timestamp($video['duration']);
286	286	$video['views'] = $__video_h->fetch_video_views($video['rid']);

		@@ -11,11 +11,11 @@ discard block
		block discarded – undo
11	11	<?php
12	12	$search = $_SESSION['siteusername'];
13	13
14		- if($_GET['filter'] == "time") {
	14	+ if ($_GET['filter'] == "time") {
15	15	$stmt = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :username ORDER BY id DESC");
16	16	$stmt->bindParam(":username", $_SESSION['siteusername']);
17	17	$stmt->execute();
18		- } else if($_GET['filter'] == "title") {
	18	+ } else if ($_GET['filter'] == "title") {
19	19	$stmt = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :username ORDER BY title DESC");
20	20	$stmt->bindParam(":username", $_SESSION['siteusername']);
21	21	$stmt->execute();
		@@ -23,23 +23,23 @@ discard block
		block discarded – undo
23	23
24	24	$results_per_page = 12;
25	25	$number_of_result = $stmt->rowCount();
26		- $number_of_page = ceil ($number_of_result / $results_per_page);
	26	+ $number_of_page = ceil($number_of_result/$results_per_page);
27	27
28		- if (!isset ($_GET['page']) ) {
	28	+ if (!isset ($_GET['page'])) {
29	29	$page = 1;
30	30	} else {
31		- $page = (int)$_GET['page'];
	31	+ $page = (int) $_GET['page'];
32	32	}
33	33
34		- $page_first_result = ($page - 1) * $results_per_page;
	34	+ $page_first_result = ($page - 1)*$results_per_page;
35	35
36		- if($_GET['filter'] == "time") {
	36	+ if ($_GET['filter'] == "time") {
37	37	$stmt6 = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :search ORDER BY id DESC LIMIT :pfirst, :pper");
38	38	$stmt6->bindParam(":search", $search);
39	39	$stmt6->bindParam(":pfirst", $page_first_result);
40	40	$stmt6->bindParam(":pper", $results_per_page);
41	41	$stmt6->execute();
42		- } else if($_GET['filter'] == "title") {
	42	+ } else if ($_GET['filter'] == "title") {
43	43	$stmt6 = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :search ORDER BY title LIMIT :pfirst, :pper");
44	44	$stmt6->bindParam(":search", $search);
45	45	$stmt6->bindParam(":pfirst", $page_first_result);
		@@ -56,8 +56,8 @@ discard block
		block discarded – undo
56	56	</tr>
57	57
58	58	<?php
59		- while($video = $stmt6->fetch(PDO::FETCH_ASSOC)) {
60		- if($__video_h->video_exists($video['reciever'])) {
	59	+ while ($video = $stmt6->fetch(PDO::FETCH_ASSOC)) {
	60	+ if ($__video_h->video_exists($video['reciever'])) {
61	61	$_video = $__video_h->fetch_video_rid($video['reciever']);
62	62	$_video['video_responses'] = $__video_h->get_video_responses($_video['rid']);
63	63	$_video['age'] = $__time_h->time_elapsed_string($_video['publish']);
		@@ -67,19 +67,19 @@ discard block
		block discarded – undo
67	67	$_video['title'] = htmlspecialchars($_video['title']);
68	68	$_video['description'] = $__video_h->shorten_description($_video['description'], 50);
69	69
70		- if($_video['thumbnail'] == ".png" && $_video['filename'] == ".mp4") {
	70	+ if ($_video['thumbnail'] == ".png" && $_video['filename'] == ".mp4") {
71	71	$status = "Corrupted";
72		- } else if($_video['visibility'] == "v") {
	72	+ } else if ($_video['visibility'] == "v") {
73	73	$status = "Approved";
74		- } else if($_video['visibility'] == "n") {
	74	+ } else if ($_video['visibility'] == "n") {
75	75	$status = "Approved";
76		- } else if($_video['visibility'] == "o") {
	76	+ } else if ($_video['visibility'] == "o") {
77	77	$status = "Disapproved";
78	78	} else {
79	79	$status = "Unknown";
80	80	}
81	81
82		- if($_video['commenting'] == "a")
	82	+ if ($_video['commenting'] == "a")
83	83	$_video['commentstatus'] = "Commenting allowed";
84	84	else
85	85	$_video['commentstatus'] = "Commenting disallowed";

		@@ -11,8 +11,8 @@ discard block
		block discarded – undo
11	11	<?php $__time_h = new time_helper(); ?>
12	12	<?php header('Content-Type: application/json'); ?>
13	13	<?php
14		- if(!isset($_GET['action_load_user_feed'])) {
15		- switch(@$_GET['chart_name']) {
	14	+ if (!isset($_GET['action_load_user_feed'])) {
	15	+ switch (@$_GET['chart_name']) {
16	16	case "trending":
17	17	$category = 'Trending';
18	18	$diviconn = 'trending';
		@@ -47,7 +47,7 @@ discard block
		block discarded – undo
47	47	break;
48	48	}
49	49
50		- switch(@$_GET['feed_name']) {
	50	+ switch (@$_GET['feed_name']) {
51	51	case "trending":
52	52	$category = 'Trending';
53	53	$diviconn = 'trending';
		@@ -107,7 +107,7 @@ discard block
		block discarded – undo
107	107	<div class=\'feed-page\'>
108	108	<ul>
109	109	<?php
110		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	110	+ while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
111	111	$video['age'] = $__time_h->time_elapsed_string($video['publish']);
112	112	$video['duration'] = $__time_h->timestamp($video['duration']);
113	113	$video['views'] = $__video_h->fetch_video_views($video['rid']);

		@@ -9,7 +9,7 @@ discard block
		block discarded – undo
9	9	<?php $__db_h = new db_helper(); ?>
10	10	<?php $__time_h = new time_helper(); ?>
11	11	<?php
12		- if($_SERVER['REQUEST_METHOD'] == 'POST' && $_POST['password'] && $_POST['username']) {
	12	+ if ($_SERVER['REQUEST_METHOD'] == 'POST' && $_POST['password'] && $_POST['username']) {
13	13	$request = (object) [
14	14	"username" => $_POST['username'],
15	15	"password" => $_POST['password'],
		@@ -26,19 +26,19 @@ discard block
		block discarded – undo
26	26	$stmt->bindParam(":username", $request->username);
27	27	$stmt->execute();
28	28
29		- if(!$stmt->rowCount()){
	29	+ if (!$stmt->rowCount()) {
30	30	{ $request->error->message = "Incorrect username or password!"; $request->error->status = ""; } }
31	31
32	32	$row = $stmt->fetch(PDO::FETCH_ASSOC);
33		- if(!isset($row['password']))
	33	+ if (!isset($row['password']))
34	34	{ $request->error->message = "Incorrect username or password!"; $request->error->status = ""; }
35	35	else
36	36	{ $request->returned_password = $row['password']; }
37	37
38		- if(!password_verify($request->password, $request->returned_password))
	38	+ if (!password_verify($request->password, $request->returned_password))
39	39	{ $request->error->message = "Incorrect username or password!"; $request->error->status = ""; }
40	40
41		- if($request->error->status == "OK") {
	41	+ if ($request->error->status == "OK") {
42	42	$_SESSION['siteusername'] = $request->username;
43	43	header("Location: /");
44	44	} else {

		@@ -10,7 +10,7 @@ discard block
		block discarded – undo
10	10	class user_insert {
11	11	public $__db;
12	12
13		- public function __construct($conn){
	13	+ public function __construct($conn) {
14	14	$this->__db = $conn;
15	15	}
16	16
		@@ -19,7 +19,7 @@ discard block
		block discarded – undo
19	19	$stmt->bindParam(":user", $user);
20	20	$stmt->bindParam(":vidid", $vidid);
21	21	$stmt->execute();
22		- if($stmt->rowCount() === 0) {
	22	+ if ($stmt->rowCount() === 0) {
23	23	$this->add_view_channel($vidid, $user);
24	24	}
25	25	}

		@@ -10,20 +10,20 @@
		block discarded – undo
10	10	class user_update {
11	11	public $__db;
12	12
13		- public function __construct($conn){
	13	+ public function __construct($conn) {
14	14	$this->__db = $conn;
15	15	}
16	16
17	17	// fuck this, this can be compressed into 2 functions
18	18
19	19	function update_cooldown_time($username, $rowName) {
20		- $stmt = $this->__db->prepare("UPDATE users SET ".$rowName." = now() WHERE username = :username");
	20	+ $stmt = $this->__db->prepare("UPDATE users SET " . $rowName . " = now() WHERE username = :username");
21	21	$stmt->bindParam(":username", $username);
22	22	$stmt->execute();
23	23	}
24	24
25	25	function update_row($username, $rowName, $new) {
26		- $stmt = $this->__db->prepare("UPDATE users SET ".$rowName." = :new WHERE username = :username");
	26	+ $stmt = $this->__db->prepare("UPDATE users SET " . $rowName . " = :new WHERE username = :username");
27	27	$stmt->bindParam(":new", $new);
28	28	$stmt->bindParam(":username", $username);
29	29	$stmt->execute();

the-real-sumsome / subrocks-2012

Push — main ( 241bcb...01cf0c )

Status

Category

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

Spacing +15 added lines, -15 removed lines patch added patch discarded remove patch

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

Spacing +4 added lines, -4 removed lines patch added patch discarded remove patch

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

Spacing +2 added lines, -2 removed lines patch added patch discarded remove patch

Spacing +3 added lines, -3 removed lines patch added patch discarded remove patch