the-real-sumsome / subrocks-2012

web/public/get/like_comment.php

Indentation +10 added lines, -10 removed lines

@@ -5,17 +5,17 @@
 <?php require_once($_SERVER['DOCUMENT_ROOT'] . "/static/lib/new/fetch.php"); ?>
 <?php require_once($_SERVER['DOCUMENT_ROOT'] . "/static/lib/new/insert.php"); ?>
 <?php
-  $_user_fetch_utils = new user_fetch_utils();
-  $_user_insert_utils = new user_insert_utils();
-  $_video_fetch_utils = new video_fetch_utils();
-  $_user_delete_utils = new user_delete_utils();
-  $_base_utils = new config_setup();
+    $_user_fetch_utils = new user_fetch_utils();
+    $_user_insert_utils = new user_insert_utils();
+    $_video_fetch_utils = new video_fetch_utils();
+    $_user_delete_utils = new user_delete_utils();
+    $_base_utils = new config_setup();
  
-  $_base_utils->initialize_db_var($conn);
-  $_video_fetch_utils->initialize_db_var($conn);
-  $_user_insert_utils->initialize_db_var($conn);
-  $_user_fetch_utils->initialize_db_var($conn);
-  $_user_delete_utils->initialize_db_var($conn);
+    $_base_utils->initialize_db_var($conn);
+    $_video_fetch_utils->initialize_db_var($conn);
+    $_user_insert_utils->initialize_db_var($conn);
+    $_user_fetch_utils->initialize_db_var($conn);
+    $_user_delete_utils->initialize_db_var($conn);
 ?>
 <?php
 $name = $_GET['id'];

web/public/s/classes/video_helper.php

Indentation +2 added lines, -2 removed lines

@@ -43,9 +43,9 @@
         return true;
     }
 
-	public function __construct($conn){
+    public function __construct($conn){
         $this->__db = $conn;
-	}
+    }
 
     function fetch_video_views(string $id) {
         $stmt = $this->__db->prepare("SELECT * FROM views WHERE videoid = :id");

web/public/get/like_video.php

Indentation +4 added lines, -4 removed lines

@@ -20,8 +20,8 @@ 
 while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { 
     $stmt = $__db->prepare("DELETE FROM likes WHERE sender = :username AND reciever = :reciever");
     $stmt->execute(array(
-      ':username' => $_SESSION['siteusername'],
-      ':reciever' => $name,
+        ':username' => $_SESSION['siteusername'],
+        ':reciever' => $name,
     ));
     header('Location: ' . $_SERVER['HTTP_REFERER']);
 }
@@ -33,8 +33,8 @@ 
 while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { 
     $stmt = $__db->prepare("DELETE FROM likes WHERE sender = :username AND reciever = :reciever");
     $stmt->execute(array(
-      ':username' => $_SESSION['siteusername'],
-      ':reciever' => $name,
+        ':username' => $_SESSION['siteusername'],
+        ':reciever' => $name,
     ));
     header('Location: ' . $_SERVER['HTTP_REFERER']);
 }

web/public/get/delete_video.php

Indentation +3 added lines, -3 removed lines

@@ -14,11 +14,11 @@
 <?php
 
 if($video['author'] == $_SESSION['siteusername']) {
-  $stmt = $__db->prepare("DELETE FROM videos WHERE rid=:rid AND author=:author");
-  $stmt->execute(array(
+    $stmt = $__db->prepare("DELETE FROM videos WHERE rid=:rid AND author=:author");
+    $stmt->execute(array(
     ':author' => $video['author'],
     ':rid' => $video['rid'],
-  ));
+    ));
 }
 
 header('Location: /video_manager');

web/public/comment_ajax.php

Indentation +4 added lines, -4 removed lines

@@ -26,14 +26,14 @@
         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");
         }
 
         die(json_encode($request));

web/public/get_video_info.php

Indentation +4 added lines, -4 removed lines

@@ -37,14 +37,14 @@ 
 

 // these are all the videos, with their settings, and formats

 $fmt_stream_map = [

-	[

-	"itag" => "43",

+    [

+    "itag" => "43",

     "url" => $_video['fmtPath'],

     "sig" => "aintnothinggonnabreakmystrideaintnothinggonnaslowmedownnooigottakeeponmovin",

     "fallback_host" => "tc.v14.cache3.c.youtube.com",

     "quality" => "hd720",

     "type" => "video/webm; codecs=\"vp8.0, vorbis\""

-	],

+    ],

 ];

 

 $count = 0;

@@ -69,7 +69,7 @@ 
     "avg_rating" => "5.0",

     "ttsurl" => "http://www.youtube.com/api/timedtext?signature=E949556D4478C57B95F0E4268F8D85D460D27DF6.1EC1679B0E1466625B2A029D836BE9C135A0B300&hl=en_US&caps=asr&expire=1361228889&sparams=asr_langs%2Ccaps%2Cv%2Cexpire&v=LHdA7Yc-8Rg&key=yttt1&asr_langs=ko%2Cde%2Cpt%2Cen%2Cnl%2Cja%2Cru%2Ces%2Cfr%2Cit",

     "url_encoded_fmt_stream_map" => $url_encoded_fmt_stream_map,

-	"plid" => "AATWAe5iQ_FjAV-I",

+    "plid" => "AATWAe5iQ_FjAV-I",

     "view_count" => "24465",

     "cc_asr" => "1",

     "token" => "vjVQa1PpcFPQw_h19VxFJZdJZbKkh5-obrhC9M93j-E=",

web/public/watch_2.php

Indentation +65 added lines, -65 removed lines

@@ -23,14 +23,14 @@ 
         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");
         }
     }
 ?>
@@ -53,28 +53,28 @@ 
 			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);
 
-			$_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false);
-			$_video['likes'] += $__video_h->get_video_likes($_video['rid'], true);
+            $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false);
+            $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true);
 
-			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['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true);
-			$_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false);
-			$_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']);
-			$_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']);
-		?>
+            $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true);
+            $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false);
+            $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']);
+            $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_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">
@@ -360,10 +360,10 @@ 
 												</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">
@@ -373,16 +373,16 @@ 
 													<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">
@@ -464,31 +464,31 @@ 
 												</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">
@@ -567,16 +567,16 @@ 
 											<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>

web/public/get/dislike_video.php

Indentation +4 added lines, -4 removed lines

@@ -20,8 +20,8 @@ 
 while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { 
     $stmt = $__db->prepare("DELETE FROM likes WHERE sender = :username AND reciever = :reciever");
     $stmt->execute(array(
-      ':username' => $_SESSION['siteusername'],
-      ':reciever' => $name,
+        ':username' => $_SESSION['siteusername'],
+        ':reciever' => $name,
     ));
     header('Location: ' . $_SERVER['HTTP_REFERER']);
 }
@@ -33,8 +33,8 @@ 
 while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { 
     $stmt = $__db->prepare("DELETE FROM likes WHERE sender = :username AND reciever = :reciever");
     $stmt->execute(array(
-      ':username' => $_SESSION['siteusername'],
-      ':reciever' => $name,
+        ':username' => $_SESSION['siteusername'],
+        ':reciever' => $name,
     ));
     header('Location: ' . $_SERVER['HTTP_REFERER']);
 }

web/public/homepage.php

Indentation +32 added lines, -32 removed lines

@@ -56,8 +56,8 @@ 
 							</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="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" class="see-more-arrow" alt=""></a>        
@@ -203,16 +203,16 @@ 
 							</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>
@@ -226,16 +226,16 @@ 
 							</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>
@@ -259,16 +259,16 @@ 
 									<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">