View GitHub Repository subrocks-2012

Schedule Inspection
Subscribe
Passed
Push — main ( b78c1f...17bea0 )
by chief
34s queued 12s
created
Status
Category
Toggle Patches
howto.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 = 'Howto & Style' 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 = 'Howto & Style' 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 = 'Howto & Style' 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 = 'Howto & Style' 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 = 'Howto & Style' 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.
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.
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.
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.
videos.php 1 patch
Spacing   +8 added lines, -8 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']);
 
@@ -185,7 +185,7 @@  discard block
 
 block discarded – undo
185 185 
 										<?php
186 186 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Comedy' ORDER BY rand() LIMIT 4");
187 187 
 											$stmt->execute();
188 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
188 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
189 189 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
190 190 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
191 191 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -230,7 +230,7 @@  discard block
 
 block discarded – undo
230 230 
 										<?php
231 231 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4");
232 232 
 											$stmt->execute();
233 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
233 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
234 234 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
235 235 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
236 236 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -279,7 +279,7 @@  discard block
 
 block discarded – undo
279 279 
 										<?php
280 280 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4");
281 281 
 											$stmt->execute();
282 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
282 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
283 283 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
284 284 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
285 285 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -328,7 +328,7 @@  discard block
 
 block discarded – undo
328 328 
 										<?php
329 329 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Nonprofits & Activism' ORDER BY rand() LIMIT 4");
330 330 
 											$stmt->execute();
331 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
331 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
332 332 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
333 333 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
334 334 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -377,7 +377,7 @@  discard block
 
 block discarded – undo
377 377 
 										<?php
378 378 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4");
379 379 
 											$stmt->execute();
380 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
380 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
381 381 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
382 382 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
383 383 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -426,7 +426,7 @@  discard block
 
 block discarded – undo
426 426 
 										<?php
427 427 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4");
428 428 
 											$stmt->execute();
429 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
429 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
430 430 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
431 431 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
432 432 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
 
@@ -475,7 +475,7 @@  discard block
 
 block discarded – undo
475 475 
 										<?php
476 476 
 											$stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4");
477 477 
 											$stmt->execute();
478 
-											while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
478 
+											while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
479 479 
 												$video['age'] = $__time_h->time_elapsed_string($video['publish']);
480 480 
 												$video['duration'] = $__time_h->timestamp($video['duration']);
481 481 
 												$video['views'] = $__video_h->fetch_video_views($video['rid']);
Please login to merge, or discard this patch.
entertainment.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 = 'Entertainment' 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 = 'Entertainment' 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 = 'Entertainment' 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 = 'Entertainment' 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 = 'Entertainment' 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.
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.
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.
activism.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 = 'Nonprofits & Activism' 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 = 'Nonprofits & Activism' 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 = 'Nonprofits & Activism' 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 = 'Nonprofits & Activism' 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 = 'Nonprofits & Activism' 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.