the-real-sumsome /
subrocks-2012
@@ -8,7 +8,7 @@ discard block |
||
| 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 |
||
| 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> |
@@ -10,19 +10,19 @@ discard block |
||
| 10 | 10 | <?php $__user_u = new user_update($__db); ?> |
| 11 | 11 | <?php $__db_h = new db_helper(); ?> |
| 12 | 12 | <?php $__time_h = new time_helper(); ?> |
| 13 | -<?php if(!$__video_h->video_exists($_GET['v'])) { header("Location: /?error=This video doesn't exist!"); } ?> |
|
| 13 | +<?php if (!$__video_h->video_exists($_GET['v'])) { header("Location: /?error=This video doesn't exist!"); } ?> |
|
| 14 | 14 | <?php $_video = $__video_h->fetch_video_rid($_GET['v']); ?> |
| 15 | 15 | <?php $_video['comments'] = $__video_h->get_comments_from_video($_video['rid']); ?> |
| 16 | 16 | <?php |
| 17 | - if($_SERVER['REQUEST_METHOD'] == 'POST') { |
|
| 17 | + if ($_SERVER['REQUEST_METHOD'] == 'POST') { |
|
| 18 | 18 | $error = array(); |
| 19 | 19 | |
| 20 | - if(!isset($_SESSION['siteusername'])){ $error['message'] = "you are not logged in"; $error['status'] = true; } |
|
| 21 | - if(!$_POST['comment']){ $error['message'] = "your comment cannot be blank"; $error['status'] = true; } |
|
| 22 | - if(strlen($_POST['comment']) > 1000){ $error['message'] = "your comment must be shorter than 1000 characters"; $error['status'] = true; } |
|
| 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; } |
|
| 20 | + if (!isset($_SESSION['siteusername'])) { $error['message'] = "you are not logged in"; $error['status'] = true; } |
|
| 21 | + if (!$_POST['comment']) { $error['message'] = "your comment cannot be blank"; $error['status'] = true; } |
|
| 22 | + if (strlen($_POST['comment']) > 1000) { $error['message'] = "your comment must be shorter than 1000 characters"; $error['status'] = true; } |
|
| 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 | - if(!isset($error['message'])) { |
|
| 25 | + if (!isset($error['message'])) { |
|
| 26 | 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']); |
@@ -53,17 +53,17 @@ discard block |
||
| 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); |
|
| 56 | + $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1); |
|
| 57 | 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) { |
|
| 62 | + if ($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 63 | 63 | $_video['likeswidth'] = 50; |
| 64 | 64 | $_video['dislikeswidth'] = 50; |
| 65 | 65 | } else { |
| 66 | - $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 66 | + $_video['likeswidth'] = $_video['likes']/($_video['likes'] + $_video['dislikes'])*100; |
|
| 67 | 67 | $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
| 68 | 68 | } |
| 69 | 69 | |
@@ -94,7 +94,7 @@ discard block |
||
| 94 | 94 | </div> |
| 95 | 95 | <div id="instream_google_companion_ad_div"></div> |
| 96 | 96 | </div> |
| 97 | - <?php if(@$_SESSION['siteusername'] == $_video['author']) { ?> |
|
| 97 | + <?php if (@$_SESSION['siteusername'] == $_video['author']) { ?> |
|
| 98 | 98 | <div id="watch-owner-container"> |
| 99 | 99 | <div id="masthead-subnav" class="yt-nav yt-nav-dark "> |
| 100 | 100 | <ul class="yt-nav-aside"> |
@@ -129,7 +129,7 @@ discard block |
||
| 129 | 129 | title="" |
| 130 | 130 | id="subscribe-button" |
| 131 | 131 | type="button" |
| 132 | - class="<?php if($_video['subscribed']) { echo "subscribed "; } ?>yt-subscription-button yt-uix-button yt-uix-button-subscription yt-uix-tooltip" |
|
| 132 | + class="<?php if ($_video['subscribed']) { echo "subscribed "; } ?>yt-subscription-button yt-uix-button yt-uix-button-subscription yt-uix-tooltip" |
|
| 133 | 133 | role="button"> |
| 134 | 134 | <span class="yt-uix-button-icon-wrapper"> |
| 135 | 135 | <img class="yt-uix-button-icon yt-uix-button-icon-subscribe" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""> |
@@ -332,7 +332,7 @@ discard block |
||
| 332 | 332 | $stmt->execute(); |
| 333 | 333 | ?> |
| 334 | 334 | |
| 335 | - <?php if($stmt->rowCount() != 0) { ?> |
|
| 335 | + <?php if ($stmt->rowCount() != 0) { ?> |
|
| 336 | 336 | <div class="comments-section"> |
| 337 | 337 | <a class="comments-section-see-all" href="/video_response_view_all?v=rLHU-_OhT8g"> |
| 338 | 338 | see all |
@@ -340,8 +340,8 @@ discard block |
||
| 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'])) { |
|
| 343 | + while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 344 | + if ($__video_h->video_exists($video['video'])) { |
|
| 345 | 345 | $video = $__video_h->fetch_video_rid($video['video']); |
| 346 | 346 | $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
| 347 | 347 | $video['duration'] = $__time_h->timestamp($video['duration']); |
@@ -372,19 +372,19 @@ discard block |
||
| 372 | 372 | </h4> |
| 373 | 373 | </div> |
| 374 | 374 | </div> |
| 375 | - <?php if(!isset($_SESSION['siteusername'])) { ?> |
|
| 375 | + <?php if (!isset($_SESSION['siteusername'])) { ?> |
|
| 376 | 376 | <div class="comments-post-container clearfix"> |
| 377 | 377 | <div class="comments-post-alert"> |
| 378 | 378 | <a href="/sign_in">Sign In</a> or <a href="/sign_up">Sign Up</a><span class="comments-post-form-rollover-text"> now to post a comment!</span> |
| 379 | 379 | </div> |
| 380 | 380 | </div> |
| 381 | - <?php } else if($_video['commenting'] == "d") { ?> |
|
| 381 | + <?php } else if ($_video['commenting'] == "d") { ?> |
|
| 382 | 382 | <div class="comments-post-container clearfix"> |
| 383 | 383 | <div class="comments-post-alert"> |
| 384 | 384 | This video has comemnting disabled! |
| 385 | 385 | </div> |
| 386 | 386 | </div> |
| 387 | - <?php } else if($__user_h->if_blocked($_video['author'], $_SESSION['siteusername'])) { ?> |
|
| 387 | + <?php } else if ($__user_h->if_blocked($_video['author'], $_SESSION['siteusername'])) { ?> |
|
| 388 | 388 | <div class="comments-post-container clearfix"> |
| 389 | 389 | <div class="comments-post-alert"> |
| 390 | 390 | This user has blocked you! |
@@ -438,15 +438,15 @@ discard block |
||
| 438 | 438 | $stmt->execute(); |
| 439 | 439 | |
| 440 | 440 | $number_of_result = $stmt->rowCount(); |
| 441 | - $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 441 | + $number_of_page = ceil($number_of_result/$results_per_page); |
|
| 442 | 442 | |
| 443 | - if (!isset ($_GET['page']) ) { |
|
| 443 | + if (!isset ($_GET['page'])) { |
|
| 444 | 444 | $page = 1; |
| 445 | 445 | } else { |
| 446 | - $page = (int)$_GET['page']; |
|
| 446 | + $page = (int) $_GET['page']; |
|
| 447 | 447 | } |
| 448 | 448 | |
| 449 | - $page_first_result = ($page - 1) * $results_per_page; |
|
| 449 | + $page_first_result = ($page - 1)*$results_per_page; |
|
| 450 | 450 | |
| 451 | 451 | $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
| 452 | 452 | $stmt->bindParam(":rid", $_video['rid']); |
@@ -454,7 +454,7 @@ discard block |
||
| 454 | 454 | $stmt->bindParam(":pper", $results_per_page); |
| 455 | 455 | $stmt->execute(); |
| 456 | 456 | |
| 457 | - while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 457 | + while ($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 458 | 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"> |
@@ -534,7 +534,7 @@ discard block |
||
| 534 | 534 | <?php |
| 535 | 535 | $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20"); |
| 536 | 536 | $stmt->execute(); |
| 537 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 537 | + while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 538 | 538 | $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
| 539 | 539 | $video['duration'] = $__time_h->timestamp($video['duration']); |
| 540 | 540 | $video['views'] = $__video_h->fetch_video_views($video['rid']); |
@@ -140,7 +140,7 @@ discard block |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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']); |
@@ -10,7 +10,7 @@ discard block |
||
| 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 |
||
| 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> |
@@ -10,7 +10,7 @@ discard block |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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\"> |
@@ -140,7 +140,7 @@ discard block |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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']); |
@@ -140,7 +140,7 @@ discard block |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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']); |
@@ -11,11 +11,11 @@ discard block |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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"; |
@@ -140,7 +140,7 @@ discard block |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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']); |
