View GitHub Repository subrocks-2012

Schedule Inspection
Subscribe
Test Failed
Push — main ( 9649cc...8d70f0 )
by chief
42s queued 12s
created
Status
Category
Toggle Patches
web/public/upload_video.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch 
@@ -8,7 +8,7 @@  discard block
 
 block discarded – undo
8 8 
 <?php $__user_h = new user_helper($__db); ?>
9 9 
 <?php $__db_h = new db_helper(); ?>
10 10 
 <?php $__time_h = new time_helper(); ?>
11 
-<?php if(!isset($_SESSION['siteusername'])) { header("Location: /sign_in"); } ?>
11 
+<?php if (!isset($_SESSION['siteusername'])) { header("Location: /sign_in"); } ?>
12 12 
 <!DOCTYPE html>
13 13 
 <html>
14 14 
 	<head>
 
@@ -90,7 +90,7 @@  discard block
 
 block discarded – undo
90 90 
                                 <b>Category</b> <br>
91 91 
                                 <select style="margin-top:5px;" name="category" class="yt-uix-button yt-uix-button-default">
92 92 
                                     <?php $categories = ["None", "Film & Animation", "Autos & Vehicles", "Music", "Pets & Animals", "Sports", "Travel & Events", "Gaming", "People & Blogs", "Comedy", "Entertainment", "News & Politics", "Howto & Style", "Education", "Science & Technology", "Nonprofits & Activism"]; ?>
93 
-                                    <?php foreach($categories as $categoryTag) { ?>
93 
+                                    <?php foreach ($categories as $categoryTag) { ?>
94 94 
                                         <option value="<?php echo $categoryTag; ?>"><?php echo $categoryTag; ?></option>
95 95 
                                     <?php } ?>
96 96 
                                 </select><br><br>
Please login to merge, or discard this patch.
web/public/science.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch 
@@ -140,7 +140,7 @@  discard block
 
 block discarded – undo
140 140 
 										<?php
141 141 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
142 142 
 											$stmt->execute();
143 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
143 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
144 144 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
145 145 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
146 146 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -175,7 +175,7 @@  discard block
 
 block discarded – undo
175 175 
 										<?php
176 176 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
177 177 
 											$stmt->execute();
178 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
178 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
179 179 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
180 180 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
181 181 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -210,7 +210,7 @@  discard block
 
 block discarded – undo
210 210 
 										<?php
211 211 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
212 212 
 											$stmt->execute();
213 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
213 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
214 214 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
215 215 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
216 216 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -245,7 +245,7 @@  discard block
 
 block discarded – undo
245 245 
 										<?php
246 246 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
247 247 
 											$stmt->execute();
248 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
248 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
249 249 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
250 250 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
251 251 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -280,7 +280,7 @@  discard block
 
 block discarded – undo
280 280 
 										<?php
281 281 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
282 282 
 											$stmt->execute();
283 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
283 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
284 284 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
285 285 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
286 286 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
Please login to merge, or discard this patch.
web/public/edit_video.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch 
@@ -10,7 +10,7 @@  discard block
 
 block discarded – undo
10 10 
 <?php $__user_h = new user_helper($__db); ?>
11 11 
 <?php $__db_h = new db_helper(); ?>
12 12 
 <?php $__time_h = new time_helper(); ?>
13 
-<?php if(!isset($_SESSION['siteusername'])) { header("Location: /sign_in"); } ?>
13 
+<?php if (!isset($_SESSION['siteusername'])) { header("Location: /sign_in"); } ?>
14 14 
 <?php $_video = $__video_h->fetch_video_rid($_GET['id']); ?>
15 15 
 <!DOCTYPE html>
16 16 
 <html dir="ltr">
 
@@ -174,7 +174,7 @@  discard block
 
 block discarded – undo
174 174 
                                         <b>Category</b> <br>
175 175 
                                         <select style="margin-top:5px;" name="category" class="yt-uix-button yt-uix-button-default">
176 176 
                                             <?php $categories = ["None", "Film & Animation", "Autos & Vehicles", "Music", "Pets & Animals", "Sports", "Travel & Events", "Gaming", "People & Blogs", "Comedy", "Entertainment", "News & Politics", "Howto & Style", "Education", "Science & Technology", "Nonprofits & Activism"]; ?>
177 
-                                            <?php foreach($categories as $categoryTag) { ?>
177 
+                                            <?php foreach ($categories as $categoryTag) { ?>
178 178 
                                                 <option value="<?php echo $categoryTag; ?>"><?php echo $categoryTag; ?></option>
179 179 
                                             <?php } ?>
180 180 
                                         </select><br><br>
Please login to merge, or discard this patch.
web/public/my_videos.php 1 patch
Spacing   +13 added lines, -13 removed lines patch added patch discarded remove patch 
@@ -10,7 +10,7 @@  discard block
 
 block discarded – undo
10 10 
 <?php $__user_h = new user_helper($__db); ?>
11 11 
 <?php $__db_h = new db_helper(); ?>
12 12 
 <?php $__time_h = new time_helper(); ?>
13 
-<?php if(!isset($_SESSION['siteusername'])) { header("Location: /sign_in"); } ?>
13 
+<?php if (!isset($_SESSION['siteusername'])) { header("Location: /sign_in"); } ?>
14 14 
 <!DOCTYPE html>
15 15 
 <html dir="ltr">
16 16 
 	<head>
 
@@ -163,15 +163,15 @@  discard block
 
 block discarded – undo
163 163 
                                     $stmt->execute();
164 164
165 165 
                                     $number_of_result = $stmt->rowCount();
166 
-                                    $number_of_page = ceil ($number_of_result / $results_per_page);
166 
+                                    $number_of_page = ceil($number_of_result/$results_per_page);
167 167
168 
-                                    if (!isset ($_GET['page']) ) {
168 
+                                    if (!isset ($_GET['page'])) {
169 169 
                                         $page = 1;
170 170 
                                     } else {
171 
-                                        $page = (int)$_GET['page'];
171 
+                                        $page = (int) $_GET['page'];
172 172 
                                     }
173 173
174 
-                                    $page_first_result = ($page - 1) * $results_per_page;
174 
+                                    $page_first_result = ($page - 1)*$results_per_page;
175 175 
                                 ?>
176 176 
                                 <?php
177 177 
                                     $stmt6 = $__db->prepare("SELECT * FROM videos WHERE author = :search ORDER BY id DESC LIMIT :pfirst, :pper");
 
@@ -196,7 +196,7 @@  discard block
 
 block discarded – undo
196 196 
                                     </tr>
197 197
198 198 
                                     <?php
199 
-                                        while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
199 
+                                        while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
200 200 
                                             $video['video_responses'] = $__video_h->get_video_responses($video['rid']);
201 201 
                                             $video['age'] = $__time_h->time_elapsed_string($video['publish']);
202 202 
                                             $video['duration'] = $__time_h->timestamp($video['duration']);
 
@@ -205,19 +205,19 @@  discard block
 
 block discarded – undo
205 205 
                                             $video['title'] = htmlspecialchars($video['title']);
206 206 
                                             $video['description'] = $__video_h->shorten_description($video['description'], 50);
207 207
208 
-                                            if($video['thumbnail'] == ".png" && $video['filename'] == ".mp4") {
208 
+                                            if ($video['thumbnail'] == ".png" && $video['filename'] == ".mp4") {
209 209 
                                                 $status = "Corrupted";
210 
-                                            } else if($video['visibility'] == "v") {
210 
+                                            } else if ($video['visibility'] == "v") {
211 211 
                                                 $status = "Approved";
212 
-                                            } else if($video['visibility'] == "n") {
212 
+                                            } else if ($video['visibility'] == "n") {
213 213 
                                                 $status = "Approved";
214 
-                                            } else if($video['visibility'] == "o") {
214 
+                                            } else if ($video['visibility'] == "o") {
215 215 
                                                 $status = "Disapproved";
216 216 
                                             } else {
217 217 
                                                 $status = "Unknown";
218 218 
                                             }
219 219
220 
-                                            if($video['commenting'] == "a")
220 
+                                            if ($video['commenting'] == "a")
221 221 
                                                 $video['commentstatus'] = "Commenting allowed";
222 222 
                                             else
223 223 
                                                 $video['commentstatus'] = "Commenting disallowed";
 
@@ -278,7 +278,7 @@  discard block
 
 block discarded – undo
278 278 
                                     </div>
279 279 
                                 </center>
280 280
281 
-                                <?php for($page = 1; $page<= $number_of_page; $page++) { ?>
281 
+                                <?php for ($page = 1; $page <= $number_of_page; $page++) { ?>
282 282 
                                     <button class="yt-uix-button yt-uix-button-default" onclick="ajax_fetch_videomanager(<?php echo $page; ?>)"><?php echo $page; ?></button>
283 283 
                                 <?php } ?>
284 284 
 
@@ -324,7 +324,7 @@  discard block
 
 block discarded – undo
324 324 
                                 </script>
325 325
326 326 
                                 <?php
327 
-                                    if($stmt6->rowCount() == 0) { echo "
327 
+                                    if ($stmt6->rowCount() == 0) { echo "
328 328 
                                         <br>Welcome to your Video Manager! You can manage your uploaded videos here.<br>
329 329 
                                         <a href=\"upload_video\">
330 330 
                                             <button type=\"button\" class=\" yt-uix-button yt-uix-button-default\" role=\"button\">
Please login to merge, or discard this patch.
web/public/film.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch 
@@ -140,7 +140,7 @@  discard block
 
 block discarded – undo
140 140 
 										<?php
141 141 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4");
142 142 
 											$stmt->execute();
143 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
143 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
144 144 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
145 145 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
146 146 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -175,7 +175,7 @@  discard block
 
 block discarded – undo
175 175 
 										<?php
176 176 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4");
177 177 
 											$stmt->execute();
178 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
178 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
179 179 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
180 180 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
181 181 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -210,7 +210,7 @@  discard block
 
 block discarded – undo
210 210 
 										<?php
211 211 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4");
212 212 
 											$stmt->execute();
213 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
213 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
214 214 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
215 215 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
216 216 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -245,7 +245,7 @@  discard block
 
 block discarded – undo
245 245 
 										<?php
246 246 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4");
247 247 
 											$stmt->execute();
248 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
248 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
249 249 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
250 250 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
251 251 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -280,7 +280,7 @@  discard block
 
 block discarded – undo
280 280 
 										<?php
281 281 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4");
282 282 
 											$stmt->execute();
283 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
283 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
284 284 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
285 285 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
286 286 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
Please login to merge, or discard this patch.
web/public/pets.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch 
@@ -140,7 +140,7 @@  discard block
 
 block discarded – undo
140 140 
 										<?php
141 141 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4");
142 142 
 											$stmt->execute();
143 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
143 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
144 144 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
145 145 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
146 146 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -175,7 +175,7 @@  discard block
 
 block discarded – undo
175 175 
 										<?php
176 176 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4");
177 177 
 											$stmt->execute();
178 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
178 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
179 179 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
180 180 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
181 181 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -210,7 +210,7 @@  discard block
 
 block discarded – undo
210 210 
 										<?php
211 211 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4");
212 212 
 											$stmt->execute();
213 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
213 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
214 214 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
215 215 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
216 216 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -245,7 +245,7 @@  discard block
 
 block discarded – undo
245 245 
 										<?php
246 246 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4");
247 247 
 											$stmt->execute();
248 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
248 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
249 249 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
250 250 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
251 251 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -280,7 +280,7 @@  discard block
 
 block discarded – undo
280 280 
 										<?php
281 281 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4");
282 282 
 											$stmt->execute();
283 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
283 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
284 284 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
285 285 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
286 286 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
Please login to merge, or discard this patch.
web/public/favorite_ajax.php 1 patch
Spacing   +15 added lines, -15 removed lines patch added patch discarded remove patch 
@@ -11,11 +11,11 @@  discard block
 
 block discarded – undo
11 11 
 <?php
12 12 
     $search = $_SESSION['siteusername'];
13 13
14 
-    if($_GET['filter'] == "time") {
14 
+    if ($_GET['filter'] == "time") {
15 15 
         $stmt = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :username ORDER BY id DESC");
16 16 
         $stmt->bindParam(":username", $_SESSION['siteusername']);
17 17 
         $stmt->execute();
18 
-    } else if($_GET['filter'] == "title") {
18 
+    } else if ($_GET['filter'] == "title") {
19 19 
         $stmt = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :username ORDER BY title DESC");
20 20 
         $stmt->bindParam(":username", $_SESSION['siteusername']);
21 21 
         $stmt->execute();
 
@@ -23,23 +23,23 @@  discard block
 
 block discarded – undo
23 23
24 24 
     $results_per_page = 12;
25 25 
     $number_of_result = $stmt->rowCount();
26 
-    $number_of_page = ceil ($number_of_result / $results_per_page);
26 
+    $number_of_page = ceil($number_of_result/$results_per_page);
27 27
28 
-    if (!isset ($_GET['page']) ) {
28 
+    if (!isset ($_GET['page'])) {
29 29 
         $page = 1;
30 30 
     } else {
31 
-        $page = (int)$_GET['page'];
31 
+        $page = (int) $_GET['page'];
32 32 
     }
33 33
34 
-    $page_first_result = ($page - 1) * $results_per_page;
34 
+    $page_first_result = ($page - 1)*$results_per_page;
35 35
36 
-    if($_GET['filter'] == "time") {
36 
+    if ($_GET['filter'] == "time") {
37 37 
         $stmt6 = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :search ORDER BY id DESC LIMIT :pfirst, :pper");
38 38 
         $stmt6->bindParam(":search", $search);
39 39 
         $stmt6->bindParam(":pfirst", $page_first_result);
40 40 
         $stmt6->bindParam(":pper", $results_per_page);
41 41 
         $stmt6->execute();
42 
-    } else if($_GET['filter'] == "title") {
42 
+    } else if ($_GET['filter'] == "title") {
43 43 
         $stmt6 = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :search ORDER BY title LIMIT :pfirst, :pper");
44 44 
         $stmt6->bindParam(":search", $search);
45 45 
         $stmt6->bindParam(":pfirst", $page_first_result);
 
@@ -56,8 +56,8 @@  discard block
 
 block discarded – undo
56 56 
     </tr>
57 57
58 58 
     <?php
59 
-        while($video = $stmt6->fetch(PDO::FETCH_ASSOC)) {
60 
-            if($__video_h->video_exists($video['reciever'])) {
59 
+        while ($video = $stmt6->fetch(PDO::FETCH_ASSOC)) {
60 
+            if ($__video_h->video_exists($video['reciever'])) {
61 61 
                 $_video = $__video_h->fetch_video_rid($video['reciever']);
62 62 
                 $_video['video_responses'] = $__video_h->get_video_responses($_video['rid']);
63 63 
                 $_video['age'] = $__time_h->time_elapsed_string($_video['publish']);		
@@ -67,19 +67,19 @@  discard block
 
 block discarded – undo
67 67 
                 $_video['title'] = htmlspecialchars($_video['title']);
68 68 
                 $_video['description'] = $__video_h->shorten_description($_video['description'], 50);
69 69
70 
-                if($_video['thumbnail'] == ".png" && $_video['filename'] == ".mp4") {
70 
+                if ($_video['thumbnail'] == ".png" && $_video['filename'] == ".mp4") {
71 71 
                     $status = "Corrupted";
72 
-                } else if($_video['visibility'] == "v") {
72 
+                } else if ($_video['visibility'] == "v") {
73 73 
                     $status = "Approved";
74 
-                } else if($_video['visibility'] == "n") {
74 
+                } else if ($_video['visibility'] == "n") {
75 75 
                     $status = "Approved";
76 
-                } else if($_video['visibility'] == "o") {
76 
+                } else if ($_video['visibility'] == "o") {
77 77 
                     $status = "Disapproved";
78 78 
                 } else {
79 79 
                     $status = "Unknown";
80 80 
                 }
81 81
82 
-                if($_video['commenting'] == "a")
82 
+                if ($_video['commenting'] == "a")
83 83 
                     $_video['commentstatus'] = "Commenting allowed";
84 84 
                 else
85 85 
                     $_video['commentstatus'] = "Commenting disallowed";
Please login to merge, or discard this patch.
web/public/recommended.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch 
@@ -140,7 +140,7 @@  discard block
 
 block discarded – undo
140 140 
 										<?php
141 141 
 											$stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4");
142 142 
 											$stmt->execute();
143 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
143 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
144 144 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
145 145 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
146 146 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -175,7 +175,7 @@  discard block
 
 block discarded – undo
175 175 
 										<?php
176 176 
 											$stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4");
177 177 
 											$stmt->execute();
178 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
178 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
179 179 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
180 180 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
181 181 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -210,7 +210,7 @@  discard block
 
 block discarded – undo
210 210 
 										<?php
211 211 
 											$stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4");
212 212 
 											$stmt->execute();
213 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
213 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
214 214 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
215 215 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
216 216 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -245,7 +245,7 @@  discard block
 
 block discarded – undo
245 245 
 										<?php
246 246 
 											$stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4");
247 247 
 											$stmt->execute();
248 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
248 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
249 249 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
250 250 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
251 251 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -280,7 +280,7 @@  discard block
 
 block discarded – undo
280 280 
 										<?php
281 281 
 											$stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4");
282 282 
 											$stmt->execute();
283 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
283 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
284 284 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
285 285 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
286 286 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
Please login to merge, or discard this patch.
web/public/guide_ajax.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch 
@@ -11,8 +11,8 @@  discard block
 
 block discarded – undo
11 11 
 <?php $__time_h = new time_helper(); ?>
12 12 
 <?php header('Content-Type: application/json'); ?>
13 13 
 <?php
14 
-    if(!isset($_GET['action_load_user_feed'])) {
15 
-        switch(@$_GET['chart_name']) {
14 
+    if (!isset($_GET['action_load_user_feed'])) {
15 
+        switch (@$_GET['chart_name']) {
16 16 
         case "trending":
17 17 
             $category = 'Trending';
18 18 
             $diviconn = 'trending';
 
@@ -47,7 +47,7 @@  discard block
 
 block discarded – undo
47 47 
             break;
48 48 
         }
49 49
50 
-        switch(@$_GET['feed_name']) {
50 
+        switch (@$_GET['feed_name']) {
51 51 
         case "trending":
52 52 
             $category = 'Trending';
53 53 
             $diviconn = 'trending';
 
@@ -107,7 +107,7 @@  discard block
 
 block discarded – undo
107 107 
 <div class=\'feed-page\'>
108 108 
 	<ul>
109 109 
         <?php
110 
-            while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
110 
+            while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
111 111 
                 $video['age'] = $__time_h->time_elapsed_string($video['publish']);
112 112 
                 $video['duration'] = $__time_h->timestamp($video['duration']);
113 113 
                 $video['views'] = $__video_h->fetch_video_views($video['rid']);
Please login to merge, or discard this patch.