Inspection of "dockerized" - the-real-sumsome/subrocks-2012 - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed

Push — main ( d9df25...7cc2e0 )

by chief

created 2021-10-04 06:20 UTC

Status

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

@@ -23,14 +23,14 @@  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");
         }
     }
 ?>
@@ -53,23 +53,23 @@  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['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']);
-		?>
+            $_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">
@@ -327,10 +327,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">
@@ -340,16 +340,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">
@@ -431,31 +431,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">
@@ -532,16 +532,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.

web/public/homepage.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="//s.ytimg.com/yt/img/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.

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

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

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

Please login to merge, or discard this patch.

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

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

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

Please login to merge, or discard this patch.

web/public/get/dislike.php 1 patch

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

@@ -4,15 +4,15 @@
 block discarded – undo
 <?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();
-  $_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();
+    $_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);
+    $_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);
 ?>
 <?php
 $name = $_GET['v'];

Please login to merge, or discard this patch.

web/public/get/dislike_comment.php 1 patch

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

@@ -5,17 +5,17 @@
 block discarded – undo
 <?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'];

Please login to merge, or discard this patch.

web/public/get/like_comment.php 1 patch

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

@@ -5,17 +5,17 @@
 block discarded – undo
 <?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'];

Please login to merge, or discard this patch.

web/public/get/delete_video.php 1 patch

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

@@ -16,8 +16,8 @@
 block discarded – undo
 if($video['author'] == $_SESSION['siteusername']) {
     $stmt = $__db->prepare("DELETE FROM videos WHERE rid=:rid AND author=:author");
     $stmt->execute(array(
-      ':author' => $video['author'],
-      ':rid' => $video['rid'],
+        ':author' => $video['author'],
+        ':rid' => $video['rid'],
     ));
 }
 

Please login to merge, or discard this patch.

web/public/get/star.php 1 patch

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

@@ -4,15 +4,15 @@
 block discarded – undo
 <?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();
-  $_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();
+    $_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);
+    $_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);
 ?>
 <?php
 session_start();

Please login to merge, or discard this patch.

		@@ -23,14 +23,14 @@ discard block
		block discarded – undo
23	23	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; }
24	24
25	25	if(!isset($error['message'])) {
26		- $text = $_POST['comment'];
	26	+ $text = $_POST['comment'];
27	27	$stmt = $__db->prepare("INSERT INTO comments (toid, author, comment) VALUES (:v, :username, :comment)");
28	28	$stmt->bindParam(":v", $_GET['v']);
29		- $stmt->bindParam(":username", $_SESSION['siteusername']);
30		- $stmt->bindParam(":comment", $text);
	29	+ $stmt->bindParam(":username", $_SESSION['siteusername']);
	30	+ $stmt->bindParam(":comment", $text);
31	31	$stmt->execute();
32	32
33		- $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment");
	33	+ $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment");
34	34	}
35	35	}
36	36	?>
		@@ -53,23 +53,23 @@ discard block
		block discarded – undo
53	53	if (window.yt.timing) {yt.timing.tick("ct");}
54	54	</script>
55	55	<?php
56		- $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1);
57		- $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2);
	56	+ $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1);
	57	+ $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2);
58	58
59		- $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4);
60		- $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5);
	59	+ $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4);
	60	+ $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5);
61	61
62		- if($_video['likes'] == 0 && $_video['dislikes'] == 0) {
63		- $_video['likeswidth'] = 50;
64		- $_video['dislikeswidth'] = 50;
65		- } else {
66		- $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100;
67		- $_video['dislikeswidth'] = 100 - $_video['likeswidth'];
68		- }
	62	+ if($_video['likes'] == 0 && $_video['dislikes'] == 0) {
	63	+ $_video['likeswidth'] = 50;
	64	+ $_video['dislikeswidth'] = 50;
	65	+ } else {
	66	+ $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100;
	67	+ $_video['dislikeswidth'] = 100 - $_video['likeswidth'];
	68	+ }
69	69
70		- $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']);
71		- $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']);
72		- ?>
	70	+ $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']);
	71	+ $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']);
	72	+ ?>
73	73	</head>
74	74	<body id="" class="date-20120927 en_US ltr ytg-old-clearfix guide-feed-v2 gecko gecko-15" dir="ltr">
75	75	<form name="logoutForm" method="POST" action="/logout">
		@@ -327,10 +327,10 @@ discard block
		block discarded – undo
327	327	</div>
328	328	</div>
329	329	<?php
330		- $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4");
331		- $stmt->bindParam(":v", $_GET['v']);
332		- $stmt->execute();
333		- ?>
	330	+ $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4");
	331	+ $stmt->bindParam(":v", $_GET['v']);
	332	+ $stmt->execute();
	333	+ ?>
334	334
335	335	<?php if($stmt->rowCount() != 0) { ?>
336	336	<div class="comments-section">
		@@ -340,16 +340,16 @@ discard block
		block discarded – undo
340	340	<h4>Video Responses</h4>
341	341	<ul class="video-list">
342	342	<?php
343		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
344		- if($__video_h->video_exists($video['video'])) {
345		- $video = $__video_h->fetch_video_rid($video['video']);
346		- $video['age'] = $__time_h->time_elapsed_string($video['publish']);
347		- $video['duration'] = $__time_h->timestamp($video['duration']);
348		- $video['views'] = $__video_h->fetch_video_views($video['rid']);
349		- $video['author'] = htmlspecialchars($video['author']);
350		- $video['title'] = htmlspecialchars($video['title']);
351		- $video['description'] = $__video_h->shorten_description($video['description'], 50);
352		- ?>
	343	+ while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	344	+ if($__video_h->video_exists($video['video'])) {
	345	+ $video = $__video_h->fetch_video_rid($video['video']);
	346	+ $video['age'] = $__time_h->time_elapsed_string($video['publish']);
	347	+ $video['duration'] = $__time_h->timestamp($video['duration']);
	348	+ $video['views'] = $__video_h->fetch_video_views($video['rid']);
	349	+ $video['author'] = htmlspecialchars($video['author']);
	350	+ $video['title'] = htmlspecialchars($video['title']);
	351	+ $video['description'] = $__video_h->shorten_description($video['description'], 50);
	352	+ ?>
353	353	<li class="video-list-item yt-tile-default">
354	354	<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>
355	355	<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">
		@@ -431,31 +431,31 @@ discard block
		block discarded – undo
431	431	</div>
432	432	<ul class="comment-list" id="live_comments">
433	433	<?php
434		- $results_per_page = 20;
	434	+ $results_per_page = 20;
435	435
436		- $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC");
437		- $stmt->bindParam(":rid", $_video['rid']);
438		- $stmt->execute();
	436	+ $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC");
	437	+ $stmt->bindParam(":rid", $_video['rid']);
	438	+ $stmt->execute();
439	439
440		- $number_of_result = $stmt->rowCount();
441		- $number_of_page = ceil ($number_of_result / $results_per_page);
	440	+ $number_of_result = $stmt->rowCount();
	441	+ $number_of_page = ceil ($number_of_result / $results_per_page);
442	442
443		- if (!isset ($_GET['page']) ) {
444		- $page = 1;
445		- } else {
446		- $page = (int)$_GET['page'];
447		- }
	443	+ if (!isset ($_GET['page']) ) {
	444	+ $page = 1;
	445	+ } else {
	446	+ $page = (int)$_GET['page'];
	447	+ }
448	448
449		- $page_first_result = ($page - 1) * $results_per_page;
	449	+ $page_first_result = ($page - 1) * $results_per_page;
450	450
451		- $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper");
452		- $stmt->bindParam(":rid", $_video['rid']);
453		- $stmt->bindParam(":pfirst", $page_first_result);
454		- $stmt->bindParam(":pper", $results_per_page);
455		- $stmt->execute();
	451	+ $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper");
	452	+ $stmt->bindParam(":rid", $_video['rid']);
	453	+ $stmt->bindParam(":pfirst", $page_first_result);
	454	+ $stmt->bindParam(":pper", $results_per_page);
	455	+ $stmt->execute();
456	456
457		- while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) {
458		- ?>
	457	+ while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) {
	458	+ ?>
459	459
460	460	<li class="comment yt-tile-default " data-author-viewing="" data-author-id="-uD01K8FQTeOSS5sniRFzQ" data-id="HdQrMeklJ_5hd_uPDRcvtdaMk2pMVS8d9sufcfiGx0U" data-score="0">
461	461	<div class="comment-body">
		@@ -532,16 +532,16 @@ discard block
		block discarded – undo
532	532	<ul id="watch-related" class="video-list">
533	533	<div id="ppv-container" class="hid"></div>
534	534	<?php
535		- $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20");
536		- $stmt->execute();
537		- while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
538		- $video['age'] = $__time_h->time_elapsed_string($video['publish']);
539		- $video['duration'] = $__time_h->timestamp($video['duration']);
540		- $video['views'] = $__video_h->fetch_video_views($video['rid']);
541		- $video['author'] = htmlspecialchars($video['author']);
542		- $video['title'] = htmlspecialchars($video['title']);
543		- $video['description'] = $__video_h->shorten_description($video['description'], 50);
544		- ?>
	535	+ $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20");
	536	+ $stmt->execute();
	537	+ while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
	538	+ $video['age'] = $__time_h->time_elapsed_string($video['publish']);
	539	+ $video['duration'] = $__time_h->timestamp($video['duration']);
	540	+ $video['views'] = $__video_h->fetch_video_views($video['rid']);
	541	+ $video['author'] = htmlspecialchars($video['author']);
	542	+ $video['title'] = htmlspecialchars($video['title']);
	543	+ $video['description'] = $__video_h->shorten_description($video['description'], 50);
	544	+ ?>
545	545	<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>
546	546	<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">
547	547	</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="//s.ytimg.com/yt/img/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">

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

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

		@@ -4,15 +4,15 @@
		block discarded – undo
4	4	<?php require_once($_SERVER['DOCUMENT_ROOT'] . "/static/lib/new/fetch.php"); ?>
5	5	<?php require_once($_SERVER['DOCUMENT_ROOT'] . "/static/lib/new/insert.php"); ?>
6	6	<?php
7		- $_user_fetch_utils = new user_fetch_utils();
8		- $_user_insert_utils = new user_insert_utils();
9		- $_video_fetch_utils = new video_fetch_utils();
10		- $_base_utils = new config_setup();
	7	+ $_user_fetch_utils = new user_fetch_utils();
	8	+ $_user_insert_utils = new user_insert_utils();
	9	+ $_video_fetch_utils = new video_fetch_utils();
	10	+ $_base_utils = new config_setup();
11	11
12		- $_base_utils->initialize_db_var($conn);
13		- $_video_fetch_utils->initialize_db_var($conn);
14		- $_user_insert_utils->initialize_db_var($conn);
15		- $_user_fetch_utils->initialize_db_var($conn);
	12	+ $_base_utils->initialize_db_var($conn);
	13	+ $_video_fetch_utils->initialize_db_var($conn);
	14	+ $_user_insert_utils->initialize_db_var($conn);
	15	+ $_user_fetch_utils->initialize_db_var($conn);
16	16	?>
17	17	<?php
18	18	$name = $_GET['v'];

		@@ -5,17 +5,17 @@
		block discarded – undo
5	5	<?php require_once($_SERVER['DOCUMENT_ROOT'] . "/static/lib/new/fetch.php"); ?>
6	6	<?php require_once($_SERVER['DOCUMENT_ROOT'] . "/static/lib/new/insert.php"); ?>
7	7	<?php
8		- $_user_fetch_utils = new user_fetch_utils();
9		- $_user_insert_utils = new user_insert_utils();
10		- $_video_fetch_utils = new video_fetch_utils();
11		- $_user_delete_utils = new user_delete_utils();
12		- $_base_utils = new config_setup();
	8	+ $_user_fetch_utils = new user_fetch_utils();
	9	+ $_user_insert_utils = new user_insert_utils();
	10	+ $_video_fetch_utils = new video_fetch_utils();
	11	+ $_user_delete_utils = new user_delete_utils();
	12	+ $_base_utils = new config_setup();
13	13
14		- $_base_utils->initialize_db_var($conn);
15		- $_video_fetch_utils->initialize_db_var($conn);
16		- $_user_insert_utils->initialize_db_var($conn);
17		- $_user_fetch_utils->initialize_db_var($conn);
18		- $_user_delete_utils->initialize_db_var($conn);
	14	+ $_base_utils->initialize_db_var($conn);
	15	+ $_video_fetch_utils->initialize_db_var($conn);
	16	+ $_user_insert_utils->initialize_db_var($conn);
	17	+ $_user_fetch_utils->initialize_db_var($conn);
	18	+ $_user_delete_utils->initialize_db_var($conn);
19	19	?>
20	20	<?php
21	21	$name = $_GET['id'];

		@@ -16,8 +16,8 @@
		block discarded – undo
16	16	if($video['author'] == $_SESSION['siteusername']) {
17	17	$stmt = $__db->prepare("DELETE FROM videos WHERE rid=:rid AND author=:author");
18	18	$stmt->execute(array(
19		- ':author' => $video['author'],
20		- ':rid' => $video['rid'],
	19	+ ':author' => $video['author'],
	20	+ ':rid' => $video['rid'],
21	21	));
22	22	}
23	23

the-real-sumsome / subrocks-2012

Push — main ( d9df25...7cc2e0 )

Status

Category

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

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

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

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

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

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

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