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

Passed

Push — main ( 17bea0...d9df25 )

by chief

created 2021-10-04 03:27 UTC

Status

Indentation +50 added lines, -50 removed lines patch added patch discarded remove patch

@@ -138,16 +138,16 @@  discard block
 block discarded – undo
 									</div>
 									<div class="browse-item-row ytg-box">
 										<?php
-											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
-											$stmt->execute();
-											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']);
-												$video['author'] = htmlspecialchars($video['author']);		
-												$video['title'] = htmlspecialchars($video['title']);
-												$video['description'] = $__video_h->shorten_description($video['description'], 50);
-										?>
+                                            $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
+                                            $stmt->execute();
+                                            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']);
+                                                $video['author'] = htmlspecialchars($video['author']);		
+                                                $video['title'] = htmlspecialchars($video['title']);
+                                                $video['description'] = $__video_h->shorten_description($video['description'], 50);
+                                        ?>
 										<div class="browse-item yt-tile-default ">
 											<a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&amp;feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
 											<button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content">  <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
@@ -173,16 +173,16 @@  discard block
 block discarded – undo
 									</div>
                                     <div class="browse-item-row ytg-box">
 										<?php
-											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
-											$stmt->execute();
-											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']);
-												$video['author'] = htmlspecialchars($video['author']);		
-												$video['title'] = htmlspecialchars($video['title']);
-												$video['description'] = $__video_h->shorten_description($video['description'], 50);
-										?>
+                                            $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
+                                            $stmt->execute();
+                                            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']);
+                                                $video['author'] = htmlspecialchars($video['author']);		
+                                                $video['title'] = htmlspecialchars($video['title']);
+                                                $video['description'] = $__video_h->shorten_description($video['description'], 50);
+                                        ?>
 										<div class="browse-item yt-tile-default ">
 											<a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&amp;feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
 											<button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content">  <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
@@ -208,16 +208,16 @@  discard block
 block discarded – undo
 									</div>
                                     <div class="browse-item-row ytg-box">
 										<?php
-											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
-											$stmt->execute();
-											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']);
-												$video['author'] = htmlspecialchars($video['author']);		
-												$video['title'] = htmlspecialchars($video['title']);
-												$video['description'] = $__video_h->shorten_description($video['description'], 50);
-										?>
+                                            $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
+                                            $stmt->execute();
+                                            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']);
+                                                $video['author'] = htmlspecialchars($video['author']);		
+                                                $video['title'] = htmlspecialchars($video['title']);
+                                                $video['description'] = $__video_h->shorten_description($video['description'], 50);
+                                        ?>
 										<div class="browse-item yt-tile-default ">
 											<a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&amp;feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
 											<button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content">  <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
@@ -243,16 +243,16 @@  discard block
 block discarded – undo
 									</div>
                                     <div class="browse-item-row ytg-box">
 										<?php
-											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
-											$stmt->execute();
-											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']);
-												$video['author'] = htmlspecialchars($video['author']);		
-												$video['title'] = htmlspecialchars($video['title']);
-												$video['description'] = $__video_h->shorten_description($video['description'], 50);
-										?>
+                                            $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
+                                            $stmt->execute();
+                                            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']);
+                                                $video['author'] = htmlspecialchars($video['author']);		
+                                                $video['title'] = htmlspecialchars($video['title']);
+                                                $video['description'] = $__video_h->shorten_description($video['description'], 50);
+                                        ?>
 										<div class="browse-item yt-tile-default ">
 											<a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&amp;feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
 											<button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content">  <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
@@ -278,16 +278,16 @@  discard block
 block discarded – undo
 									</div>
                                     <div class="browse-item-row ytg-box">
 										<?php
-											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
-											$stmt->execute();
-											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']);
-												$video['author'] = htmlspecialchars($video['author']);		
-												$video['title'] = htmlspecialchars($video['title']);
-												$video['description'] = $__video_h->shorten_description($video['description'], 50);
-										?>
+                                            $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
+                                            $stmt->execute();
+                                            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']);
+                                                $video['author'] = htmlspecialchars($video['author']);		
+                                                $video['title'] = htmlspecialchars($video['title']);
+                                                $video['description'] = $__video_h->shorten_description($video['description'], 50);
+                                        ?>
 										<div class="browse-item yt-tile-default ">
 											<a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&amp;feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
 											<button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content">  <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">

Please login to merge, or discard this patch.

favorite_videos.php 1 patch

Indentation +26 added lines, -26 removed lines patch added patch discarded remove patch

@@ -175,7 +175,7 @@  discard block
 block discarded – undo
                                 ?>
                                 <?php 
                                     $stmt6 = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :search ORDER BY id DESC LIMIT :pfirst, :pper");
-									$stmt6->bindParam(":search", $search);
+                                    $stmt6->bindParam(":search", $search);
                                     $stmt6->bindParam(":pfirst", $page_first_result);
                                     $stmt6->bindParam(":pper", $results_per_page);
                                     $stmt6->execute();
@@ -192,32 +192,32 @@  discard block
 block discarded – undo
                                     
                                     <?php
                                         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']);		
-												$_video['duration'] = $__time_h->timestamp($_video['duration']);
-												$_video['views'] = $__video_h->fetch_video_views($_video['rid']);
-												$_video['author'] = htmlspecialchars($_video['author']);		
-												$_video['title'] = htmlspecialchars($_video['title']);
-												$_video['description'] = $__video_h->shorten_description($_video['description'], 50);
-
-												if($_video['thumbnail'] == ".png" && $_video['filename'] == ".mp4") {
-													$status = "Corrupted";
-												} else if($_video['visibility'] == "v") {
-													$status = "Approved";
-												} else if($_video['visibility'] == "n") {
-													$status = "Approved";
-												} else if($_video['visibility'] == "o") {
-													$status = "Disapproved";
-												} else {
-													$status = "Unknown";
-												}                      
+                                            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']);		
+                                                $_video['duration'] = $__time_h->timestamp($_video['duration']);
+                                                $_video['views'] = $__video_h->fetch_video_views($_video['rid']);
+                                                $_video['author'] = htmlspecialchars($_video['author']);		
+                                                $_video['title'] = htmlspecialchars($_video['title']);
+                                                $_video['description'] = $__video_h->shorten_description($_video['description'], 50);
+
+                                                if($_video['thumbnail'] == ".png" && $_video['filename'] == ".mp4") {
+                                                    $status = "Corrupted";
+                                                } else if($_video['visibility'] == "v") {
+                                                    $status = "Approved";
+                                                } else if($_video['visibility'] == "n") {
+                                                    $status = "Approved";
+                                                } else if($_video['visibility'] == "o") {
+                                                    $status = "Disapproved";
+                                                } else {
+                                                    $status = "Unknown";
+                                                }                      
 												
-												if($_video['commenting'] == "a") 
-													$_video['commentstatus'] = "Commenting allowed";
-												else 
-													$_video['commentstatus'] = "Commenting disallowed";
+                                                if($_video['commenting'] == "a") 
+                                                    $_video['commentstatus'] = "Commenting allowed";
+                                                else 
+                                                    $_video['commentstatus'] = "Commenting disallowed";
                                     ?> 
                                     <tr style="margin-top: 5px;" id="videoslist">
                                         <td class="video-manager-left">

Please login to merge, or discard this patch.

guide_ajax.php 1 patch

Indentation +1 added lines, -1 removed lines patch added patch discarded remove patch

@@ -93,7 +93,7 @@
 block discarded – undo
         $stmt->bindParam(":username", $username);
         $stmt->execute();
     }
-	?>
+    ?>
 {'paging': null, 'feed_html': `
 <div class=\'feed-header no-metadata\'>
 	<div class=\'feed-header-thumb\'>

Please login to merge, or discard this patch.

		@@ -138,16 +138,16 @@ discard block
		block discarded – undo
138	138	</div>
139	139	<div class="browse-item-row ytg-box">
140	140	<?php
141		- $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
142		- $stmt->execute();
143		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
144		- $video['age'] = $__time_h->time_elapsed_string($video['publish']);
145		- $video['duration'] = $__time_h->timestamp($video['duration']);
146		- $video['views'] = $__video_h->fetch_video_views($video['rid']);
147		- $video['author'] = htmlspecialchars($video['author']);
148		- $video['title'] = htmlspecialchars($video['title']);
149		- $video['description'] = $__video_h->shorten_description($video['description'], 50);
150		- ?>
	141	+ $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
	142	+ $stmt->execute();
	143	+ while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	144	+ $video['age'] = $__time_h->time_elapsed_string($video['publish']);
	145	+ $video['duration'] = $__time_h->timestamp($video['duration']);
	146	+ $video['views'] = $__video_h->fetch_video_views($video['rid']);
	147	+ $video['author'] = htmlspecialchars($video['author']);
	148	+ $video['title'] = htmlspecialchars($video['title']);
	149	+ $video['description'] = $__video_h->shorten_description($video['description'], 50);
	150	+ ?>
151	151	<div class="browse-item yt-tile-default ">
152	152	<a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
153	153	<button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
		@@ -173,16 +173,16 @@ discard block
		block discarded – undo
173	173	</div>
174	174	<div class="browse-item-row ytg-box">
175	175	<?php
176		- $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
177		- $stmt->execute();
178		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
179		- $video['age'] = $__time_h->time_elapsed_string($video['publish']);
180		- $video['duration'] = $__time_h->timestamp($video['duration']);
181		- $video['views'] = $__video_h->fetch_video_views($video['rid']);
182		- $video['author'] = htmlspecialchars($video['author']);
183		- $video['title'] = htmlspecialchars($video['title']);
184		- $video['description'] = $__video_h->shorten_description($video['description'], 50);
185		- ?>
	176	+ $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
	177	+ $stmt->execute();
	178	+ while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	179	+ $video['age'] = $__time_h->time_elapsed_string($video['publish']);
	180	+ $video['duration'] = $__time_h->timestamp($video['duration']);
	181	+ $video['views'] = $__video_h->fetch_video_views($video['rid']);
	182	+ $video['author'] = htmlspecialchars($video['author']);
	183	+ $video['title'] = htmlspecialchars($video['title']);
	184	+ $video['description'] = $__video_h->shorten_description($video['description'], 50);
	185	+ ?>
186	186	<div class="browse-item yt-tile-default ">
187	187	<a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
188	188	<button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
		@@ -208,16 +208,16 @@ discard block
		block discarded – undo
208	208	</div>
209	209	<div class="browse-item-row ytg-box">
210	210	<?php
211		- $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
212		- $stmt->execute();
213		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
214		- $video['age'] = $__time_h->time_elapsed_string($video['publish']);
215		- $video['duration'] = $__time_h->timestamp($video['duration']);
216		- $video['views'] = $__video_h->fetch_video_views($video['rid']);
217		- $video['author'] = htmlspecialchars($video['author']);
218		- $video['title'] = htmlspecialchars($video['title']);
219		- $video['description'] = $__video_h->shorten_description($video['description'], 50);
220		- ?>
	211	+ $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
	212	+ $stmt->execute();
	213	+ while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	214	+ $video['age'] = $__time_h->time_elapsed_string($video['publish']);
	215	+ $video['duration'] = $__time_h->timestamp($video['duration']);
	216	+ $video['views'] = $__video_h->fetch_video_views($video['rid']);
	217	+ $video['author'] = htmlspecialchars($video['author']);
	218	+ $video['title'] = htmlspecialchars($video['title']);
	219	+ $video['description'] = $__video_h->shorten_description($video['description'], 50);
	220	+ ?>
221	221	<div class="browse-item yt-tile-default ">
222	222	<a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
223	223	<button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
		@@ -243,16 +243,16 @@ discard block
		block discarded – undo
243	243	</div>
244	244	<div class="browse-item-row ytg-box">
245	245	<?php
246		- $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
247		- $stmt->execute();
248		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
249		- $video['age'] = $__time_h->time_elapsed_string($video['publish']);
250		- $video['duration'] = $__time_h->timestamp($video['duration']);
251		- $video['views'] = $__video_h->fetch_video_views($video['rid']);
252		- $video['author'] = htmlspecialchars($video['author']);
253		- $video['title'] = htmlspecialchars($video['title']);
254		- $video['description'] = $__video_h->shorten_description($video['description'], 50);
255		- ?>
	246	+ $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
	247	+ $stmt->execute();
	248	+ while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	249	+ $video['age'] = $__time_h->time_elapsed_string($video['publish']);
	250	+ $video['duration'] = $__time_h->timestamp($video['duration']);
	251	+ $video['views'] = $__video_h->fetch_video_views($video['rid']);
	252	+ $video['author'] = htmlspecialchars($video['author']);
	253	+ $video['title'] = htmlspecialchars($video['title']);
	254	+ $video['description'] = $__video_h->shorten_description($video['description'], 50);
	255	+ ?>
256	256	<div class="browse-item yt-tile-default ">
257	257	<a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
258	258	<button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
		@@ -278,16 +278,16 @@ discard block
		block discarded – undo
278	278	</div>
279	279	<div class="browse-item-row ytg-box">
280	280	<?php
281		- $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
282		- $stmt->execute();
283		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
284		- $video['age'] = $__time_h->time_elapsed_string($video['publish']);
285		- $video['duration'] = $__time_h->timestamp($video['duration']);
286		- $video['views'] = $__video_h->fetch_video_views($video['rid']);
287		- $video['author'] = htmlspecialchars($video['author']);
288		- $video['title'] = htmlspecialchars($video['title']);
289		- $video['description'] = $__video_h->shorten_description($video['description'], 50);
290		- ?>
	281	+ $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4");
	282	+ $stmt->execute();
	283	+ while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	284	+ $video['age'] = $__time_h->time_elapsed_string($video['publish']);
	285	+ $video['duration'] = $__time_h->timestamp($video['duration']);
	286	+ $video['views'] = $__video_h->fetch_video_views($video['rid']);
	287	+ $video['author'] = htmlspecialchars($video['author']);
	288	+ $video['title'] = htmlspecialchars($video['title']);
	289	+ $video['description'] = $__video_h->shorten_description($video['description'], 50);
	290	+ ?>
291	291	<div class="browse-item yt-tile-default ">
292	292	<a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
293	293	<button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">

		@@ -175,7 +175,7 @@ discard block
		block discarded – undo
175	175	?>
176	176	<?php
177	177	$stmt6 = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :search ORDER BY id DESC LIMIT :pfirst, :pper");
178		- $stmt6->bindParam(":search", $search);
	178	+ $stmt6->bindParam(":search", $search);
179	179	$stmt6->bindParam(":pfirst", $page_first_result);
180	180	$stmt6->bindParam(":pper", $results_per_page);
181	181	$stmt6->execute();
		@@ -192,32 +192,32 @@ discard block
		block discarded – undo
192	192
193	193	<?php
194	194	while($video = $stmt6->fetch(PDO::FETCH_ASSOC)) {
195		- if($__video_h->video_exists($video['reciever'])) {
196		- $_video = $__video_h->fetch_video_rid($video['reciever']);
197		- $_video['video_responses'] = $__video_h->get_video_responses($_video['rid']);
198		- $_video['age'] = $__time_h->time_elapsed_string($_video['publish']);
199		- $_video['duration'] = $__time_h->timestamp($_video['duration']);
200		- $_video['views'] = $__video_h->fetch_video_views($_video['rid']);
201		- $_video['author'] = htmlspecialchars($_video['author']);
202		- $_video['title'] = htmlspecialchars($_video['title']);
203		- $_video['description'] = $__video_h->shorten_description($_video['description'], 50);
204		-
205		- if($_video['thumbnail'] == ".png" && $_video['filename'] == ".mp4") {
206		- $status = "Corrupted";
207		- } else if($_video['visibility'] == "v") {
208		- $status = "Approved";
209		- } else if($_video['visibility'] == "n") {
210		- $status = "Approved";
211		- } else if($_video['visibility'] == "o") {
212		- $status = "Disapproved";
213		- } else {
214		- $status = "Unknown";
215		- }
	195	+ if($__video_h->video_exists($video['reciever'])) {
	196	+ $_video = $__video_h->fetch_video_rid($video['reciever']);
	197	+ $_video['video_responses'] = $__video_h->get_video_responses($_video['rid']);
	198	+ $_video['age'] = $__time_h->time_elapsed_string($_video['publish']);
	199	+ $_video['duration'] = $__time_h->timestamp($_video['duration']);
	200	+ $_video['views'] = $__video_h->fetch_video_views($_video['rid']);
	201	+ $_video['author'] = htmlspecialchars($_video['author']);
	202	+ $_video['title'] = htmlspecialchars($_video['title']);
	203	+ $_video['description'] = $__video_h->shorten_description($_video['description'], 50);
	204	+
	205	+ if($_video['thumbnail'] == ".png" && $_video['filename'] == ".mp4") {
	206	+ $status = "Corrupted";
	207	+ } else if($_video['visibility'] == "v") {
	208	+ $status = "Approved";
	209	+ } else if($_video['visibility'] == "n") {
	210	+ $status = "Approved";
	211	+ } else if($_video['visibility'] == "o") {
	212	+ $status = "Disapproved";
	213	+ } else {
	214	+ $status = "Unknown";
	215	+ }
216	216
217		- if($_video['commenting'] == "a")
218		- $_video['commentstatus'] = "Commenting allowed";
219		- else
220		- $_video['commentstatus'] = "Commenting disallowed";
	217	+ if($_video['commenting'] == "a")
	218	+ $_video['commentstatus'] = "Commenting allowed";
	219	+ else
	220	+ $_video['commentstatus'] = "Commenting disallowed";
221	221	?>
222	222	<tr style="margin-top: 5px;" id="videoslist">
223	223	<td class="video-manager-left">

		@@ -93,7 +93,7 @@
		block discarded – undo
93	93	$stmt->bindParam(":username", $username);
94	94	$stmt->execute();
95	95	}
96		- ?>
	96	+ ?>
97	97	{'paging': null, 'feed_html': `
98	98	<div class=\'feed-header no-metadata\'>
99	99	<div class=\'feed-header-thumb\'>

the-real-sumsome / subrocks-2012

Push — main ( 17bea0...d9df25 )

Status

Category

Indentation +50 added lines, -50 removed lines patch added patch discarded remove patch

Indentation +26 added lines, -26 removed lines patch added patch discarded remove patch

Indentation +1 added lines, -1 removed lines patch added patch discarded remove patch