Inspection of "and he said to the man running the stand" - the-real-sumsome/subrocks-2012 - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed

Push — main ( 71a77e...4a5de7 )

by chief

created 2021-10-16 05:39 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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.

web/public/film.php 1 patch

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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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.

web/public/pets.php 1 patch

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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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.

web/public/recommended.php 1 patch

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 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 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 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 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 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 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 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 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 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 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.

web/public/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.

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

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

@@ -10,9 +10,9 @@
 block discarded – undo
 class user_insert {
     public $__db;
 
-	public function __construct($conn){
+    public function __construct($conn){
         $this->__db = $conn;
-	}
+    }
 
     function check_view_channel($vidid, $user) {
         $stmt = $this->__db->prepare("SELECT * FROM channel_views WHERE viewer = :user AND channel = :vidid");

Please login to merge, or discard this patch.

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

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

@@ -11,9 +11,9 @@
 block discarded – undo
 class user_helper {
     public $__db;
 
-	public function __construct($conn){
+    public function __construct($conn){
         $this->__db = $conn;
-	}
+    }
 
     function fetch_pfp($username) {
         $stmt = $this->__db->prepare("SELECT pfp FROM users WHERE username = :username");

Please login to merge, or discard this patch.

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

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

@@ -10,9 +10,9 @@
 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
 

Please login to merge, or discard this patch.

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

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

@@ -10,9 +10,9 @@
 block discarded – undo
 class video_updater {
     public $__db;
 
-	public function __construct($conn){
+    public function __construct($conn){
         $this->__db = $conn;
-	}
+    }
 
     function update_row($video, $rowName, $new) {
         $stmt = $this->__db->prepare("UPDATE videos SET ".$rowName." = :new WHERE rid = :rid");

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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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 = 'Science & Technology' 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">

		@@ -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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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 = 'Film & Animation' 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">

		@@ -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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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 = 'Pets & Animals' 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">

		@@ -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 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 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 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 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 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 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 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 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 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 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">

		@@ -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\'>

		@@ -10,9 +10,9 @@
		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
17	17	function check_view_channel($vidid, $user) {
18	18	$stmt = $this->__db->prepare("SELECT * FROM channel_views WHERE viewer = :user AND channel = :vidid");

		@@ -11,9 +11,9 @@
		block discarded – undo
11	11	class user_helper {
12	12	public $__db;
13	13
14		- public function __construct($conn){
	14	+ public function __construct($conn){
15	15	$this->__db = $conn;
16		- }
	16	+ }
17	17
18	18	function fetch_pfp($username) {
19	19	$stmt = $this->__db->prepare("SELECT pfp FROM users WHERE username = :username");

		@@ -10,9 +10,9 @@
		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

		@@ -10,9 +10,9 @@
		block discarded – undo
10	10	class video_updater {
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	function update_row($video, $rowName, $new) {
18	18	$stmt = $this->__db->prepare("UPDATE videos SET ".$rowName." = :new WHERE rid = :rid");

the-real-sumsome / subrocks-2012

Push — main ( 71a77e...4a5de7 )

Status

Category

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

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

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

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

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

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

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

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

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