Inspection of "Merge pull request #3 from biggerbraintime/pdo" - the-real-sumsome/subrocks-2012 - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — main ( b78c1f...17bea0 )

by chief

created 2021-10-03 21:46 UTC

Status

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

@@ -19,7 +19,7 @@
 block discarded – undo
     $_user_update_utils->initialize_db_var($conn);
 
 
-  $_base_utils->initialize_page_compass("post/upload");
+    $_base_utils->initialize_page_compass("post/upload");
 ?>
 <?php
     $characters = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz-_';

Please login to merge, or discard this patch.

s/classes/db_helper.php 1 patch

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

@@ -10,13 +10,13 @@
 block discarded – undo
 *
 **/
 class db_helper {
-	public function __construct(){
+    public function __construct(){
       
-	}
+    }
 
-  function fetch(string $table, array $where, string $extra) {
+    function fetch(string $table, array $where, string $extra) {
 
-  }
+    }
 }
 
 ?>
\ No newline at end of file

Please login to merge, or discard this patch.

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.

gaming.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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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.

channel.php 1 patch

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

@@ -15,8 +15,8 @@  discard block
 block discarded – undo
 <?php $__db_h = new db_helper(); ?>
 <?php $__time_h = new time_helper(); ?>
 <?php
-	if(isset($_SESSION['siteusername']))
-	    $_user_hp = $__user_h->fetch_user_username($_SESSION['siteusername']);
+    if(isset($_SESSION['siteusername']))
+        $_user_hp = $__user_h->fetch_user_username($_SESSION['siteusername']);
 
     if(!$__user_h->user_exists($_GET['n']))
         header("Location: /?userdoesntexist");
@@ -29,21 +29,21 @@  discard block
 block discarded – undo
         return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars.
     }
 
-	function addhttp($url) {
-		if (!preg_match("~^(?:f|ht)tps?://~i", $url)) {
-			$url = "http://" . $url;
-		}
-		return $url;
-	}
+    function addhttp($url) {
+        if (!preg_match("~^(?:f|ht)tps?://~i", $url)) {
+            $url = "http://" . $url;
+        }
+        return $url;
+    }
 
     function check_valid_colorhex($colorCode) {
         // If user accidentally passed along the # sign, strip it off
         $colorCode = ltrim($colorCode, '#');
     
         if (
-              ctype_xdigit($colorCode) &&
+                ctype_xdigit($colorCode) &&
               (strlen($colorCode) == 6 || strlen($colorCode) == 3))
-                   return true;
+                    return true;
     
         else return false;
     }
@@ -77,8 +77,8 @@  discard block
 block discarded – undo
     if(!check_valid_colorhex($_user['primary_color_text']) && strlen($_user['primary_color_text']) != 6) { $_user['primary_color_text'] = ""; }
     if(!check_valid_colorhex($_user['2009_bgcolor']) && strlen($_user['2009_bgcolor']) != 6) { $_user['2009_bgcolor'] = ""; }
 
-	if(isset($_SESSION['siteusername']))
-    	$__user_i->check_view_channel($_user['username'], @$_SESSION['siteusername']);
+    if(isset($_SESSION['siteusername']))
+        $__user_i->check_view_channel($_user['username'], @$_SESSION['siteusername']);
 
     if($_SERVER['REQUEST_METHOD'] == 'POST') {
         $error = array();
@@ -92,11 +92,11 @@  discard block
 block discarded – undo
         //if(ifBlocked(@$_SESSION['siteusername'], $user['username'], $__db)) { $error = "This user has blocked you!"; $error['status'] = true; } 
 
         if(!isset($error['message'])) {
-			$text = $_POST['comment'];
+            $text = $_POST['comment'];
             $stmt = $__db->prepare("INSERT INTO profile_comments (toid, author, comment) VALUES (:id, :username, :comment)");
-			$stmt->bindParam(":id", $_user['username']);
-			$stmt->bindParam(":username", $_SESSION['siteusername']);
-			$stmt->bindParam(":comment", $text);
+            $stmt->bindParam(":id", $_user['username']);
+            $stmt->bindParam(":username", $_SESSION['siteusername']);
+            $stmt->bindParam(":comment", $text);
             $stmt->execute();
 
             $_user_update_utils->update_comment_cooldown_time($_SESSION['siteusername']);
@@ -106,7 +106,7 @@  discard block
 block discarded – undo
             }
         }
     }
-	?>
+    ?>
 <!DOCTYPE html>
 <html dir="ltr" xmlns:og="http://opengraphprotocol.org/schema/" lang="en">
 	<!-- machid: sNW5tN3Z2SWdXaDRqNGxuNEF5MFBxM1BxWXd0VGo0Rkg3UXNTTTNCUGRDWjR0WGpHR3R1YzFR -->

Please login to merge, or discard this patch.

travel.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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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.

watch.php 1 patch

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

@@ -24,16 +24,16 @@  discard block
 block discarded – undo
         if($__user_h->if_cooldown($_SESSION['siteusername'])) { $error['message'] = "You are on a cooldown! Wait for a minute before posting another comment."; $error['status'] = true; }
 
         if(!isset($error['message'])) {
-			$text = $_POST['comment'];
+            $text = $_POST['comment'];
             $stmt = $__db->prepare("INSERT INTO comments (toid, author, comment) VALUES (:v, :username, :comment)");
             $stmt->bindParam(":v", $_GET['v']);
-			$stmt->bindParam(":username", $_SESSION['siteusername']);
-			$stmt->bindParam(":comment", $text);
+            $stmt->bindParam(":username", $_SESSION['siteusername']);
+            $stmt->bindParam(":comment", $text);
             $stmt->execute();
 
-			$__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment")
+            $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment")
 
-			/*
+            /*
             if(@$_SESSION['siteusername'] != $_video['author']) { 
                 $_user_insert_utils->send_message($_video['author'], "New comment", 'I commented "' . $_POST['comment'] . '" on your video "' . $_video['title'] . '"', $_SESSION['siteusername']);
             }
@@ -58,22 +58,22 @@  discard block
 block discarded – undo
 			if (window.yt.timing) {yt.timing.tick("ct");}    
 		</script>
 		<?php
-			$_video['dislikes'] =  $__video_h->get_video_stars_level($_video['rid'], 1);
-			$_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2);
+            $_video['dislikes'] =  $__video_h->get_video_stars_level($_video['rid'], 1);
+            $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2);
 
-			$_video['likes'] =     $__video_h->get_video_stars_level($_video['rid'], 4);
-			$_video['likes'] +=    $__video_h->get_video_stars_level($_video['rid'], 5);
+            $_video['likes'] =     $__video_h->get_video_stars_level($_video['rid'], 4);
+            $_video['likes'] +=    $__video_h->get_video_stars_level($_video['rid'], 5);
 
-			if($_video['likes'] == 0 && $_video['dislikes'] == 0) {
-				$_video['likeswidth'] = 50;
-				$_video['dislikeswidth'] = 50;
-			} else {
-				$_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100;
-				$_video['dislikeswidth'] = 100 - $_video['likeswidth'];
-			}
+            if($_video['likes'] == 0 && $_video['dislikes'] == 0) {
+                $_video['likeswidth'] = 50;
+                $_video['dislikeswidth'] = 50;
+            } else {
+                $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100;
+                $_video['dislikeswidth'] = 100 - $_video['likeswidth'];
+            }
 
-			$_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']);
-		?>
+            $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']);
+        ?>
 	</head>
 	<body id="" class="date-20120927 en_US ltr   ytg-old-clearfix guide-feed-v2 gecko gecko-15" dir="ltr">
 		<form name="logoutForm" method="POST" action="/logout">
@@ -296,10 +296,10 @@  discard block
 block discarded – undo
 												</div>
 											</div>
 											<?php 
-												$stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4");
-												$stmt->bindParam(":v", $_GET['v']);
-												$stmt->execute();
-											?>
+                                                $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4");
+                                                $stmt->bindParam(":v", $_GET['v']);
+                                                $stmt->execute();
+                                            ?>
 
 											<?php if($stmt->rowCount() != 0) { ?>
 												<div class="comments-section">
@@ -309,16 +309,16 @@  discard block
 block discarded – undo
 													<h4>Video Responses</h4>
 													<ul class="video-list">
 													<?php 
-														while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { 
-															if($__video_h->video_exists($video['video'])) { 
-																$video = $__video_h->fetch_video_rid($video['video']);
-																$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);
-													?>
+                                                        while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { 
+                                                            if($__video_h->video_exists($video['video'])) { 
+                                                                $video = $__video_h->fetch_video_rid($video['video']);
+                                                                $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);
+                                                    ?>
 														<li class="video-list-item yt-tile-default">
 															<a href="/watch?v=<?php echo $video['rid']; ?>" class="related-video yt-uix-contextlink  yt-uix-sessionlink" data-sessionlink="<?php echo htmlspecialchars($_video['author']); ?>&amp;feature=watch_response"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><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="cjls0QsHOBE" role="button"><span class="yt-uix-button-content">  <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
@@ -400,31 +400,31 @@  discard block
 block discarded – undo
 												</div>
 												<ul class="comment-list" id="live_comments">
 														<?php
-														$results_per_page = 20;
+                                                        $results_per_page = 20;
 
-														$stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC");
-														$stmt->bindParam(":rid", $_video['rid']);
-														$stmt->execute();
+                                                        $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC");
+                                                        $stmt->bindParam(":rid", $_video['rid']);
+                                                        $stmt->execute();
 
-														$number_of_result = $stmt->rowCount();
-														$number_of_page = ceil ($number_of_result / $results_per_page);  
+                                                        $number_of_result = $stmt->rowCount();
+                                                        $number_of_page = ceil ($number_of_result / $results_per_page);  
 
-														if (!isset ($_GET['page']) ) {  
-															$page = 1;  
-														} else {  
-															$page = (int)$_GET['page'];  
-														}  
+                                                        if (!isset ($_GET['page']) ) {  
+                                                            $page = 1;  
+                                                        } else {  
+                                                            $page = (int)$_GET['page'];  
+                                                        }  
 
-														$page_first_result = ($page - 1) * $results_per_page;  
+                                                        $page_first_result = ($page - 1) * $results_per_page;  
 
-														$stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper");
-														$stmt->bindParam(":rid", $_video['rid']);
-														$stmt->bindParam(":pfirst", $page_first_result);
-														$stmt->bindParam(":pper", $results_per_page);
-														$stmt->execute();
+                                                        $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper");
+                                                        $stmt->bindParam(":rid", $_video['rid']);
+                                                        $stmt->bindParam(":pfirst", $page_first_result);
+                                                        $stmt->bindParam(":pper", $results_per_page);
+                                                        $stmt->execute();
 
-														while($comment = $stmt->fetch(PDO::FETCH_ASSOC))) { 
-													?>
+                                                        while($comment = $stmt->fetch(PDO::FETCH_ASSOC))) { 
+                                                    ?>
 
 													<li class="comment yt-tile-default " data-author-viewing="" data-author-id="-uD01K8FQTeOSS5sniRFzQ" data-id="HdQrMeklJ_5hd_uPDRcvtdaMk2pMVS8d9sufcfiGx0U" data-score="0">
 														<div class="comment-body">
@@ -501,16 +501,16 @@  discard block
 block discarded – undo
 											<ul id="watch-related" class="video-list">
 												<div id="ppv-container" class="hid"></div>
 												<?php
-													$stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20");
-													$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 20");
+                                                    $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);
+                                                ?>
 												<li class="video-list-item"><a href="/watch?v=<?php echo $video['rid']; ?>" class="related-video yt-uix-contextlink  yt-uix-sessionlink" data-sessionlink="ved=CAIQzRooAA%3D%3D&amp;<?php echo htmlspecialchars($_video['author']); ?>&amp;feature=relmfu"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><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="gyAaIKF6tSQ" role="button"><span class="yt-uix-button-content">  <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
 													</span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button>

Please login to merge, or discard this patch.

index.php 1 patch

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

@@ -56,8 +56,8 @@  discard block
 block discarded – undo
 							</div>
 							<div class="guide">
 							<?php 
-								if(isset($_SESSION['siteusername'])) {
-								?>
+                                if(isset($_SESSION['siteusername'])) {
+                                ?>
 								<div style="/*! margin-top: 0px; *//*! margin-left: 10px; *//*! margin-bottom: 13px; */height: 99px;" class="guide-section feed-header channel first"><img alt="" src="/dynamic/pfp/<?php echo $__user_h->fetch_pfp($_SESSION['siteusername']); ?>" style="height: 88px;position: relative;top: 4px;left: 4px;" class="feed-header-thumb channel-thumb" width="88px"><div id="links" style="/*! margin-left: 5px; */position: relative;left: 13px;top: 7px;"><div style="font-size: 11px;margin-bottom: 6px;" class="metadata">
 							<a href="/user/<?php echo htmlspecialchars($_SESSION['siteusername']); ?>" style="color: inherit;">My channel
 							<img src="/static/pixel-vfl3z5WfW.gif" class="see-more-arrow" alt=""></a>        
@@ -210,16 +210,16 @@  discard block
 block discarded – undo
 							</p>
 							<ul>
 								<?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);
+                                ?>
 								<li class="video-list-item "><a href="/watch?v=<?php echo $video['rid']; ?>" class="video-list-item-link yt-uix-sessionlink" data-sessionlink="ei=CNLr3rbS3rICFSwSIQodSW397Q%3D%3D&amp;feature=g-sptl%26cid%3Dinp-hs-ytg"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><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="yuTBQ86r8o0" role="button"><span class="yt-uix-button-content">  <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
 									</span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button>
@@ -233,16 +233,16 @@  discard block
 block discarded – undo
 							</h3>
 							<ul>
 								<?php
-									$stmt = $__db->prepare("SELECT * FROM videos WHERE featured = 'v' ORDER BY id DESC 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 featured = 'v' ORDER BY id DESC 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);
+                                ?>
 								<li class="video-list-item "><a href="/watch?v=<?php echo $video['rid']; ?>" class="video-list-item-link yt-uix-sessionlink" data-sessionlink="ei=CNLr3rbS3rICFSwSIQodSW397Q%3D%3D&amp;feature=g-sptl%26cid%3Dinp-hs-ytg"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><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="yuTBQ86r8o0" role="button"><span class="yt-uix-button-content">  <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
 									</span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button>
@@ -266,16 +266,16 @@  discard block
 block discarded – undo
 									<div class="feed-page">
 										<ul>
 											<?php
-												$stmt = $__db->prepare("SELECT * FROM videos ORDER BY id DESC LIMIT 20");
-												$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 id DESC LIMIT 20");
+                                                $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);
+                                            ?>
 											<li>
 												<div class="feed-item-container first " data-channel-key="UCR2A9ZNliJfgC66IvIpe-Zw">
 													<div class="feed-author-bubble-container">

Please login to merge, or discard this patch.

people.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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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.

		@@ -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 WHERE category = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Gaming' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'Travel & Events' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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 = 'People & Blogs' 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">

		@@ -19,7 +19,7 @@
		block discarded – undo
19	19	$_user_update_utils->initialize_db_var($conn);
20	20
21	21
22		- $_base_utils->initialize_page_compass("post/upload");
	22	+ $_base_utils->initialize_page_compass("post/upload");
23	23	?>
24	24	<?php
25	25	$characters = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz-_';

		@@ -10,13 +10,13 @@
		block discarded – undo
10	10	*
11	11	**/
12	12	class db_helper {
13		- public function __construct(){
	13	+ public function __construct(){
14	14
15		- }
	15	+ }
16	16
17		- function fetch(string $table, array $where, string $extra) {
	17	+ function fetch(string $table, array $where, string $extra) {
18	18
19		- }
	19	+ }
20	20	}
21	21
22	22	?>
23	23	\ No newline at end of file

		@@ -15,8 +15,8 @@ discard block
		block discarded – undo
15	15	<?php $__db_h = new db_helper(); ?>
16	16	<?php $__time_h = new time_helper(); ?>
17	17	<?php
18		- if(isset($_SESSION['siteusername']))
19		- $_user_hp = $__user_h->fetch_user_username($_SESSION['siteusername']);
	18	+ if(isset($_SESSION['siteusername']))
	19	+ $_user_hp = $__user_h->fetch_user_username($_SESSION['siteusername']);
20	20
21	21	if(!$__user_h->user_exists($_GET['n']))
22	22	header("Location: /?userdoesntexist");
		@@ -29,21 +29,21 @@ discard block
		block discarded – undo
29	29	return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars.
30	30	}
31	31
32		- function addhttp($url) {
33		- if (!preg_match("~^(?:f\|ht)tps?://~i", $url)) {
34		- $url = "http://" . $url;
35		- }
36		- return $url;
37		- }
	32	+ function addhttp($url) {
	33	+ if (!preg_match("~^(?:f\|ht)tps?://~i", $url)) {
	34	+ $url = "http://" . $url;
	35	+ }
	36	+ return $url;
	37	+ }
38	38
39	39	function check_valid_colorhex($colorCode) {
40	40	// If user accidentally passed along the # sign, strip it off
41	41	$colorCode = ltrim($colorCode, '#');
42	42
43	43	if (
44		- ctype_xdigit($colorCode) &&
	44	+ ctype_xdigit($colorCode) &&
45	45	(strlen($colorCode) == 6 \|\| strlen($colorCode) == 3))
46		- return true;
	46	+ return true;
47	47
48	48	else return false;
49	49	}
		@@ -77,8 +77,8 @@ discard block
		block discarded – undo
77	77	if(!check_valid_colorhex($_user['primary_color_text']) && strlen($_user['primary_color_text']) != 6) { $_user['primary_color_text'] = ""; }
78	78	if(!check_valid_colorhex($_user['2009_bgcolor']) && strlen($_user['2009_bgcolor']) != 6) { $_user['2009_bgcolor'] = ""; }
79	79
80		- if(isset($_SESSION['siteusername']))
81		- $__user_i->check_view_channel($_user['username'], @$_SESSION['siteusername']);
	80	+ if(isset($_SESSION['siteusername']))
	81	+ $__user_i->check_view_channel($_user['username'], @$_SESSION['siteusername']);
82	82
83	83	if($_SERVER['REQUEST_METHOD'] == 'POST') {
84	84	$error = array();
		@@ -92,11 +92,11 @@ discard block
		block discarded – undo
92	92	//if(ifBlocked(@$_SESSION['siteusername'], $user['username'], $__db)) { $error = "This user has blocked you!"; $error['status'] = true; }
93	93
94	94	if(!isset($error['message'])) {
95		- $text = $_POST['comment'];
	95	+ $text = $_POST['comment'];
96	96	$stmt = $__db->prepare("INSERT INTO profile_comments (toid, author, comment) VALUES (:id, :username, :comment)");
97		- $stmt->bindParam(":id", $_user['username']);
98		- $stmt->bindParam(":username", $_SESSION['siteusername']);
99		- $stmt->bindParam(":comment", $text);
	97	+ $stmt->bindParam(":id", $_user['username']);
	98	+ $stmt->bindParam(":username", $_SESSION['siteusername']);
	99	+ $stmt->bindParam(":comment", $text);
100	100	$stmt->execute();
101	101
102	102	$_user_update_utils->update_comment_cooldown_time($_SESSION['siteusername']);
		@@ -106,7 +106,7 @@ discard block
		block discarded – undo
106	106	}
107	107	}
108	108	}
109		- ?>
	109	+ ?>
110	110	<!DOCTYPE html>
111	111	<html dir="ltr" xmlns:og="http://opengraphprotocol.org/schema/" lang="en">
112	112	<!-- machid: sNW5tN3Z2SWdXaDRqNGxuNEF5MFBxM1BxWXd0VGo0Rkg3UXNTTTNCUGRDWjR0WGpHR3R1YzFR -->

		@@ -24,16 +24,16 @@ discard block
		block discarded – undo
24	24	if($__user_h->if_cooldown($_SESSION['siteusername'])) { $error['message'] = "You are on a cooldown! Wait for a minute before posting another comment."; $error['status'] = true; }
25	25
26	26	if(!isset($error['message'])) {
27		- $text = $_POST['comment'];
	27	+ $text = $_POST['comment'];
28	28	$stmt = $__db->prepare("INSERT INTO comments (toid, author, comment) VALUES (:v, :username, :comment)");
29	29	$stmt->bindParam(":v", $_GET['v']);
30		- $stmt->bindParam(":username", $_SESSION['siteusername']);
31		- $stmt->bindParam(":comment", $text);
	30	+ $stmt->bindParam(":username", $_SESSION['siteusername']);
	31	+ $stmt->bindParam(":comment", $text);
32	32	$stmt->execute();
33	33
34		- $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment")
	34	+ $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment")
35	35
36		- /*
	36	+ /*
37	37	if(@$_SESSION['siteusername'] != $_video['author']) {
38	38	$_user_insert_utils->send_message($_video['author'], "New comment", 'I commented "' . $_POST['comment'] . '" on your video "' . $_video['title'] . '"', $_SESSION['siteusername']);
39	39	}
		@@ -58,22 +58,22 @@ discard block
		block discarded – undo
58	58	if (window.yt.timing) {yt.timing.tick("ct");}
59	59	</script>
60	60	<?php
61		- $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1);
62		- $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2);
	61	+ $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1);
	62	+ $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2);
63	63
64		- $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4);
65		- $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5);
	64	+ $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4);
	65	+ $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5);
66	66
67		- if($_video['likes'] == 0 && $_video['dislikes'] == 0) {
68		- $_video['likeswidth'] = 50;
69		- $_video['dislikeswidth'] = 50;
70		- } else {
71		- $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100;
72		- $_video['dislikeswidth'] = 100 - $_video['likeswidth'];
73		- }
	67	+ if($_video['likes'] == 0 && $_video['dislikes'] == 0) {
	68	+ $_video['likeswidth'] = 50;
	69	+ $_video['dislikeswidth'] = 50;
	70	+ } else {
	71	+ $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100;
	72	+ $_video['dislikeswidth'] = 100 - $_video['likeswidth'];
	73	+ }
74	74
75		- $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']);
76		- ?>
	75	+ $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']);
	76	+ ?>
77	77	</head>
78	78	<body id="" class="date-20120927 en_US ltr ytg-old-clearfix guide-feed-v2 gecko gecko-15" dir="ltr">
79	79	<form name="logoutForm" method="POST" action="/logout">
		@@ -296,10 +296,10 @@ discard block
		block discarded – undo
296	296	</div>
297	297	</div>
298	298	<?php
299		- $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4");
300		- $stmt->bindParam(":v", $_GET['v']);
301		- $stmt->execute();
302		- ?>
	299	+ $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4");
	300	+ $stmt->bindParam(":v", $_GET['v']);
	301	+ $stmt->execute();
	302	+ ?>
303	303
304	304	<?php if($stmt->rowCount() != 0) { ?>
305	305	<div class="comments-section">
		@@ -309,16 +309,16 @@ discard block
		block discarded – undo
309	309	<h4>Video Responses</h4>
310	310	<ul class="video-list">
311	311	<?php
312		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
313		- if($__video_h->video_exists($video['video'])) {
314		- $video = $__video_h->fetch_video_rid($video['video']);
315		- $video['age'] = $__time_h->time_elapsed_string($video['publish']);
316		- $video['duration'] = $__time_h->timestamp($video['duration']);
317		- $video['views'] = $__video_h->fetch_video_views($video['rid']);
318		- $video['author'] = htmlspecialchars($video['author']);
319		- $video['title'] = htmlspecialchars($video['title']);
320		- $video['description'] = $__video_h->shorten_description($video['description'], 50);
321		- ?>
	312	+ while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	313	+ if($__video_h->video_exists($video['video'])) {
	314	+ $video = $__video_h->fetch_video_rid($video['video']);
	315	+ $video['age'] = $__time_h->time_elapsed_string($video['publish']);
	316	+ $video['duration'] = $__time_h->timestamp($video['duration']);
	317	+ $video['views'] = $__video_h->fetch_video_views($video['rid']);
	318	+ $video['author'] = htmlspecialchars($video['author']);
	319	+ $video['title'] = htmlspecialchars($video['title']);
	320	+ $video['description'] = $__video_h->shorten_description($video['description'], 50);
	321	+ ?>
322	322	<li class="video-list-item yt-tile-default">
323	323	<a href="/watch?v=<?php echo $video['rid']; ?>" class="related-video yt-uix-contextlink yt-uix-sessionlink" data-sessionlink="<?php echo htmlspecialchars($_video['author']); ?>&feature=watch_response"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
324	324	<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="cjls0QsHOBE" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
		@@ -400,31 +400,31 @@ discard block
		block discarded – undo
400	400	</div>
401	401	<ul class="comment-list" id="live_comments">
402	402	<?php
403		- $results_per_page = 20;
	403	+ $results_per_page = 20;
404	404
405		- $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC");
406		- $stmt->bindParam(":rid", $_video['rid']);
407		- $stmt->execute();
	405	+ $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC");
	406	+ $stmt->bindParam(":rid", $_video['rid']);
	407	+ $stmt->execute();
408	408
409		- $number_of_result = $stmt->rowCount();
410		- $number_of_page = ceil ($number_of_result / $results_per_page);
	409	+ $number_of_result = $stmt->rowCount();
	410	+ $number_of_page = ceil ($number_of_result / $results_per_page);
411	411
412		- if (!isset ($_GET['page']) ) {
413		- $page = 1;
414		- } else {
415		- $page = (int)$_GET['page'];
416		- }
	412	+ if (!isset ($_GET['page']) ) {
	413	+ $page = 1;
	414	+ } else {
	415	+ $page = (int)$_GET['page'];
	416	+ }
417	417
418		- $page_first_result = ($page - 1) * $results_per_page;
	418	+ $page_first_result = ($page - 1) * $results_per_page;
419	419
420		- $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper");
421		- $stmt->bindParam(":rid", $_video['rid']);
422		- $stmt->bindParam(":pfirst", $page_first_result);
423		- $stmt->bindParam(":pper", $results_per_page);
424		- $stmt->execute();
	420	+ $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper");
	421	+ $stmt->bindParam(":rid", $_video['rid']);
	422	+ $stmt->bindParam(":pfirst", $page_first_result);
	423	+ $stmt->bindParam(":pper", $results_per_page);
	424	+ $stmt->execute();
425	425
426		- while($comment = $stmt->fetch(PDO::FETCH_ASSOC))) {
427		- ?>
	426	+ while($comment = $stmt->fetch(PDO::FETCH_ASSOC))) {
	427	+ ?>
428	428
429	429	<li class="comment yt-tile-default " data-author-viewing="" data-author-id="-uD01K8FQTeOSS5sniRFzQ" data-id="HdQrMeklJ_5hd_uPDRcvtdaMk2pMVS8d9sufcfiGx0U" data-score="0">
430	430	<div class="comment-body">
		@@ -501,16 +501,16 @@ discard block
		block discarded – undo
501	501	<ul id="watch-related" class="video-list">
502	502	<div id="ppv-container" class="hid"></div>
503	503	<?php
504		- $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20");
505		- $stmt->execute();
506		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
507		- $video['age'] = $__time_h->time_elapsed_string($video['publish']);
508		- $video['duration'] = $__time_h->timestamp($video['duration']);
509		- $video['views'] = $__video_h->fetch_video_views($video['rid']);
510		- $video['author'] = htmlspecialchars($video['author']);
511		- $video['title'] = htmlspecialchars($video['title']);
512		- $video['description'] = $__video_h->shorten_description($video['description'], 50);
513		- ?>
	504	+ $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20");
	505	+ $stmt->execute();
	506	+ while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	507	+ $video['age'] = $__time_h->time_elapsed_string($video['publish']);
	508	+ $video['duration'] = $__time_h->timestamp($video['duration']);
	509	+ $video['views'] = $__video_h->fetch_video_views($video['rid']);
	510	+ $video['author'] = htmlspecialchars($video['author']);
	511	+ $video['title'] = htmlspecialchars($video['title']);
	512	+ $video['description'] = $__video_h->shorten_description($video['description'], 50);
	513	+ ?>
514	514	<li class="video-list-item"><a href="/watch?v=<?php echo $video['rid']; ?>" class="related-video yt-uix-contextlink yt-uix-sessionlink" data-sessionlink="ved=CAIQzRooAA%3D%3D&<?php echo htmlspecialchars($_video['author']); ?>&feature=relmfu"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
515	515	<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="gyAaIKF6tSQ" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
516	516	</span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button>

		@@ -56,8 +56,8 @@ discard block
		block discarded – undo
56	56	</div>
57	57	<div class="guide">
58	58	<?php
59		- if(isset($_SESSION['siteusername'])) {
60		- ?>
	59	+ if(isset($_SESSION['siteusername'])) {
	60	+ ?>
61	61	<div style="/! margin-top: 0px; //! margin-left: 10px; //! margin-bottom: 13px; /height: 99px;" class="guide-section feed-header channel first"><img alt="" src="/dynamic/pfp/<?php echo $__user_h->fetch_pfp($_SESSION['siteusername']); ?>" style="height: 88px;position: relative;top: 4px;left: 4px;" class="feed-header-thumb channel-thumb" width="88px"><div id="links" style="/! margin-left: 5px; /position: relative;left: 13px;top: 7px;"><div style="font-size: 11px;margin-bottom: 6px;" class="metadata">
62	62	<a href="/user/<?php echo htmlspecialchars($_SESSION['siteusername']); ?>" style="color: inherit;">My channel
63	63	<img src="/static/pixel-vfl3z5WfW.gif" class="see-more-arrow" alt=""></a>
		@@ -210,16 +210,16 @@ discard block
		block discarded – undo
210	210	</p>
211	211	<ul>
212	212	<?php
213		- $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4");
214		- $stmt->execute();
215		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
216		- $video['age'] = $__time_h->time_elapsed_string($video['publish']);
217		- $video['duration'] = $__time_h->timestamp($video['duration']);
218		- $video['views'] = $__video_h->fetch_video_views($video['rid']);
219		- $video['author'] = htmlspecialchars($video['author']);
220		- $video['title'] = htmlspecialchars($video['title']);
221		- $video['description'] = $__video_h->shorten_description($video['description'], 50);
222		- ?>
	213	+ $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4");
	214	+ $stmt->execute();
	215	+ while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	216	+ $video['age'] = $__time_h->time_elapsed_string($video['publish']);
	217	+ $video['duration'] = $__time_h->timestamp($video['duration']);
	218	+ $video['views'] = $__video_h->fetch_video_views($video['rid']);
	219	+ $video['author'] = htmlspecialchars($video['author']);
	220	+ $video['title'] = htmlspecialchars($video['title']);
	221	+ $video['description'] = $__video_h->shorten_description($video['description'], 50);
	222	+ ?>
223	223	<li class="video-list-item "><a href="/watch?v=<?php echo $video['rid']; ?>" class="video-list-item-link yt-uix-sessionlink" data-sessionlink="ei=CNLr3rbS3rICFSwSIQodSW397Q%3D%3D&feature=g-sptl%26cid%3Dinp-hs-ytg"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
224	224	<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="yuTBQ86r8o0" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
225	225	</span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button>
		@@ -233,16 +233,16 @@ discard block
		block discarded – undo
233	233	</h3>
234	234	<ul>
235	235	<?php
236		- $stmt = $__db->prepare("SELECT * FROM videos WHERE featured = 'v' ORDER BY id DESC LIMIT 4");
237		- $stmt->execute();
238		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
239		- $video['age'] = $__time_h->time_elapsed_string($video['publish']);
240		- $video['duration'] = $__time_h->timestamp($video['duration']);
241		- $video['views'] = $__video_h->fetch_video_views($video['rid']);
242		- $video['author'] = htmlspecialchars($video['author']);
243		- $video['title'] = htmlspecialchars($video['title']);
244		- $video['description'] = $__video_h->shorten_description($video['description'], 50);
245		- ?>
	236	+ $stmt = $__db->prepare("SELECT * FROM videos WHERE featured = 'v' ORDER BY id DESC LIMIT 4");
	237	+ $stmt->execute();
	238	+ while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	239	+ $video['age'] = $__time_h->time_elapsed_string($video['publish']);
	240	+ $video['duration'] = $__time_h->timestamp($video['duration']);
	241	+ $video['views'] = $__video_h->fetch_video_views($video['rid']);
	242	+ $video['author'] = htmlspecialchars($video['author']);
	243	+ $video['title'] = htmlspecialchars($video['title']);
	244	+ $video['description'] = $__video_h->shorten_description($video['description'], 50);
	245	+ ?>
246	246	<li class="video-list-item "><a href="/watch?v=<?php echo $video['rid']; ?>" class="video-list-item-link yt-uix-sessionlink" data-sessionlink="ei=CNLr3rbS3rICFSwSIQodSW397Q%3D%3D&feature=g-sptl%26cid%3Dinp-hs-ytg"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span>
247	247	<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="yuTBQ86r8o0" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later">
248	248	</span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button>
		@@ -266,16 +266,16 @@ discard block
		block discarded – undo
266	266	<div class="feed-page">
267	267	<ul>
268	268	<?php
269		- $stmt = $__db->prepare("SELECT * FROM videos ORDER BY id DESC LIMIT 20");
270		- $stmt->execute();
271		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
272		- $video['age'] = $__time_h->time_elapsed_string($video['publish']);
273		- $video['duration'] = $__time_h->timestamp($video['duration']);
274		- $video['views'] = $__video_h->fetch_video_views($video['rid']);
275		- $video['author'] = htmlspecialchars($video['author']);
276		- $video['title'] = htmlspecialchars($video['title']);
277		- $video['description'] = $__video_h->shorten_description($video['description'], 50);
278		- ?>
	269	+ $stmt = $__db->prepare("SELECT * FROM videos ORDER BY id DESC LIMIT 20");
	270	+ $stmt->execute();
	271	+ while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	272	+ $video['age'] = $__time_h->time_elapsed_string($video['publish']);
	273	+ $video['duration'] = $__time_h->timestamp($video['duration']);
	274	+ $video['views'] = $__video_h->fetch_video_views($video['rid']);
	275	+ $video['author'] = htmlspecialchars($video['author']);
	276	+ $video['title'] = htmlspecialchars($video['title']);
	277	+ $video['description'] = $__video_h->shorten_description($video['description'], 50);
	278	+ ?>
279	279	<li>
280	280	<div class="feed-item-container first " data-channel-key="UCR2A9ZNliJfgC66IvIpe-Zw">
281	281	<div class="feed-author-bubble-container">

the-real-sumsome / subrocks-2012

Push — main ( b78c1f...17bea0 )

Status

Category

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

Indentation +4 added lines, -4 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 +17 added lines, -17 removed lines patch added patch discarded remove patch

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

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

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

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