the-real-sumsome /
subrocks-2012
@@ -14,11 +14,11 @@ |
||
| 14 | 14 | <?php |
| 15 | 15 | |
| 16 | 16 | if($video['author'] == $_SESSION['siteusername']) { |
| 17 | - $stmt = $__db->prepare("DELETE FROM videos WHERE rid=:rid AND author=:author"); |
|
| 18 | - $stmt->execute(array( |
|
| 17 | + $stmt = $__db->prepare("DELETE FROM videos WHERE rid=:rid AND author=:author"); |
|
| 18 | + $stmt->execute(array( |
|
| 19 | 19 | ':author' => $video['author'], |
| 20 | 20 | ':rid' => $video['rid'], |
| 21 | - )); |
|
| 21 | + )); |
|
| 22 | 22 | } |
| 23 | 23 | |
| 24 | 24 | header('Location: /video_manager'); |
@@ -13,7 +13,7 @@ |
||
| 13 | 13 | $_video = $__video_h->fetch_video_rid($_GET['v']); |
| 14 | 14 | |
| 15 | 15 | if(isset($_GET["v"])) {
|
| 16 | - $vid = $_video['filename']; |
|
| 16 | + $vid = $_video['filename']; |
|
| 17 | 17 | } |
| 18 | 18 | |
| 19 | 19 | //if $vid is null then dont show anything |
@@ -13,8 +13,8 @@ discard block |
||
| 13 | 13 | <?php $__db_h = new db_helper(); ?> |
| 14 | 14 | <?php $__time_h = new time_helper(); ?> |
| 15 | 15 | <?php |
| 16 | - if(isset($_SESSION['siteusername'])) |
|
| 17 | - $_user_hp = $__user_h->fetch_user_username($_SESSION['siteusername']); |
|
| 16 | + if(isset($_SESSION['siteusername'])) |
|
| 17 | + $_user_hp = $__user_h->fetch_user_username($_SESSION['siteusername']); |
|
| 18 | 18 | |
| 19 | 19 | if(!$__user_h->user_exists($_GET['n'])) |
| 20 | 20 | header("Location: /?userdoesntexist"); |
@@ -27,21 +27,21 @@ discard block |
||
| 27 | 27 | return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars. |
| 28 | 28 | } |
| 29 | 29 | |
| 30 | - function addhttp($url) { |
|
| 31 | - if (!preg_match("~^(?:f|ht)tps?://~i", $url)) { |
|
| 32 | - $url = "http://" . $url; |
|
| 33 | - } |
|
| 34 | - return $url; |
|
| 35 | - } |
|
| 30 | + function addhttp($url) { |
|
| 31 | + if (!preg_match("~^(?:f|ht)tps?://~i", $url)) { |
|
| 32 | + $url = "http://" . $url; |
|
| 33 | + } |
|
| 34 | + return $url; |
|
| 35 | + } |
|
| 36 | 36 | |
| 37 | 37 | function check_valid_colorhex($colorCode) { |
| 38 | 38 | // If user accidentally passed along the # sign, strip it off |
| 39 | 39 | $colorCode = ltrim($colorCode, '#'); |
| 40 | 40 | |
| 41 | 41 | if ( |
| 42 | - ctype_xdigit($colorCode) && |
|
| 42 | + ctype_xdigit($colorCode) && |
|
| 43 | 43 | (strlen($colorCode) == 6 || strlen($colorCode) == 3)) |
| 44 | - return true; |
|
| 44 | + return true; |
|
| 45 | 45 | |
| 46 | 46 | else return false; |
| 47 | 47 | } |
@@ -76,8 +76,8 @@ discard block |
||
| 76 | 76 | if(!check_valid_colorhex($_user['primary_color_text']) && strlen($_user['primary_color_text']) != 6) { $_user['primary_color_text'] = ""; } |
| 77 | 77 | if(!check_valid_colorhex($_user['2009_bgcolor']) && strlen($_user['2009_bgcolor']) != 6) { $_user['2009_bgcolor'] = ""; } |
| 78 | 78 | |
| 79 | - if(isset($_SESSION['siteusername'])) |
|
| 80 | - $__user_i->check_view_channel($_user['username'], @$_SESSION['siteusername']); |
|
| 79 | + if(isset($_SESSION['siteusername'])) |
|
| 80 | + $__user_i->check_view_channel($_user['username'], @$_SESSION['siteusername']); |
|
| 81 | 81 | |
| 82 | 82 | if($_SERVER['REQUEST_METHOD'] == 'POST') { |
| 83 | 83 | $error = array(); |
@@ -91,11 +91,11 @@ discard block |
||
| 91 | 91 | //if(ifBlocked(@$_SESSION['siteusername'], $user['username'], $__db)) { $error = "This user has blocked you!"; $error['status'] = true; } |
| 92 | 92 | |
| 93 | 93 | if(!isset($error['message'])) { |
| 94 | - $text = $_POST['comment']; |
|
| 94 | + $text = $_POST['comment']; |
|
| 95 | 95 | $stmt = $__db->prepare("INSERT INTO profile_comments (toid, author, comment) VALUES (:id, :username, :comment)"); |
| 96 | - $stmt->bindParam(":id", $_user['username']); |
|
| 97 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 98 | - $stmt->bindParam(":comment", $text); |
|
| 96 | + $stmt->bindParam(":id", $_user['username']); |
|
| 97 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 98 | + $stmt->bindParam(":comment", $text); |
|
| 99 | 99 | $stmt->execute(); |
| 100 | 100 | |
| 101 | 101 | $_user_update_utils->update_comment_cooldown_time($_SESSION['siteusername']); |
@@ -105,7 +105,7 @@ discard block |
||
| 105 | 105 | } |
| 106 | 106 | } |
| 107 | 107 | } |
| 108 | - ?> |
|
| 108 | + ?> |
|
| 109 | 109 | <!DOCTYPE html> |
| 110 | 110 | <html dir="ltr" xmlns:og="http://opengraphprotocol.org/schema/" lang="en"> |
| 111 | 111 | <!-- machid: sNW5tN3Z2SWdXaDRqNGxuNEF5MFBxM1BxWXd0VGo0Rkg3UXNTTTNCUGRDWjR0WGpHR3R1YzFR --> |
@@ -294,17 +294,17 @@ discard block |
||
| 294 | 294 | <div class="channel-filtered-content"> |
| 295 | 295 | <ol class="channel-videos-list"> |
| 296 | 296 | <?php |
| 297 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE author = :username ORDER BY id DESC"); |
|
| 298 | - $stmt->bindParam(":username", $_user['username']); |
|
| 299 | - $stmt->execute(); |
|
| 300 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 301 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 302 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 303 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 304 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 305 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 306 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 307 | - ?> |
|
| 297 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE author = :username ORDER BY id DESC"); |
|
| 298 | + $stmt->bindParam(":username", $_user['username']); |
|
| 299 | + $stmt->execute(); |
|
| 300 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 301 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 302 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 303 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 304 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 305 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 306 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 307 | + ?> |
|
| 308 | 308 | <li class="yt-c3-grid-item"> |
| 309 | 309 | <a href="/watch?v=<?php echo htmlspecialchars($video['rid']); ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="feature=plcp&context=C4e80d7cVDvjVQa1PpcFPHxNkhfeSQg8_nJHnhVurQf82C2OenNiw%3D"><span class="video-thumb ux-thumb yt-thumb-default-234 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" alt="Thumbnail" width="234"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 310 | 310 | <button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="yBlvNSfqAj0" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -26,14 +26,14 @@ |
||
| 26 | 26 | 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; } |
| 27 | 27 | |
| 28 | 28 | if(!isset($error['message'])) { |
| 29 | - $text = $_POST['comment']; |
|
| 29 | + $text = $_POST['comment']; |
|
| 30 | 30 | $stmt = $__db->prepare("INSERT INTO comments (toid, author, comment) VALUES (:v, :username, :comment)"); |
| 31 | 31 | $stmt->bindParam(":v", $_GET['v']); |
| 32 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 33 | - $stmt->bindParam(":comment", $text); |
|
| 32 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 33 | + $stmt->bindParam(":comment", $text); |
|
| 34 | 34 | $stmt->execute(); |
| 35 | 35 | |
| 36 | - $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment"); |
|
| 36 | + $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment"); |
|
| 37 | 37 | } |
| 38 | 38 | |
| 39 | 39 | die(json_encode($request)); |
@@ -18,8 +18,8 @@ |
||
| 18 | 18 | $video['title'] = htmlspecialchars($video['title']); |
| 19 | 19 | $video['description'] = $__video_h->shorten_description($video['description'], 50); |
| 20 | 20 | |
| 21 | - if(!$__video_h->video_exists($_GET['v'])) |
|
| 22 | - header("Location: /?error=Your video has not processed correctly. Try reuploading it with a shorter title, description, or tag."); |
|
| 21 | + if(!$__video_h->video_exists($_GET['v'])) |
|
| 22 | + header("Location: /?error=Your video has not processed correctly. Try reuploading it with a shorter title, description, or tag."); |
|
| 23 | 23 | |
| 24 | 24 | if($_SESSION['siteusername'] != $video['author']) |
| 25 | 25 | header("Location: /"); |
@@ -13,8 +13,8 @@ discard block |
||
| 13 | 13 | <?php $__db_h = new db_helper(); ?> |
| 14 | 14 | <?php $__time_h = new time_helper(); ?> |
| 15 | 15 | <?php |
| 16 | - if(isset($_SESSION['siteusername'])) |
|
| 17 | - $_user_hp = $__user_h->fetch_user_username($_SESSION['siteusername']); |
|
| 16 | + if(isset($_SESSION['siteusername'])) |
|
| 17 | + $_user_hp = $__user_h->fetch_user_username($_SESSION['siteusername']); |
|
| 18 | 18 | |
| 19 | 19 | if(!$__user_h->user_exists($_GET['n'])) |
| 20 | 20 | header("Location: /?userdoesntexist"); |
@@ -27,21 +27,21 @@ discard block |
||
| 27 | 27 | return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars. |
| 28 | 28 | } |
| 29 | 29 | |
| 30 | - function addhttp($url) { |
|
| 31 | - if (!preg_match("~^(?:f|ht)tps?://~i", $url)) { |
|
| 32 | - $url = "http://" . $url; |
|
| 33 | - } |
|
| 34 | - return $url; |
|
| 35 | - } |
|
| 30 | + function addhttp($url) { |
|
| 31 | + if (!preg_match("~^(?:f|ht)tps?://~i", $url)) { |
|
| 32 | + $url = "http://" . $url; |
|
| 33 | + } |
|
| 34 | + return $url; |
|
| 35 | + } |
|
| 36 | 36 | |
| 37 | 37 | function check_valid_colorhex($colorCode) { |
| 38 | 38 | // If user accidentally passed along the # sign, strip it off |
| 39 | 39 | $colorCode = ltrim($colorCode, '#'); |
| 40 | 40 | |
| 41 | 41 | if ( |
| 42 | - ctype_xdigit($colorCode) && |
|
| 42 | + ctype_xdigit($colorCode) && |
|
| 43 | 43 | (strlen($colorCode) == 6 || strlen($colorCode) == 3)) |
| 44 | - return true; |
|
| 44 | + return true; |
|
| 45 | 45 | |
| 46 | 46 | else return false; |
| 47 | 47 | } |
@@ -66,7 +66,7 @@ discard block |
||
| 66 | 66 | $_user['2009_bgcolor'] = substr($_user['2009_bgcolor'], 0, 7); |
| 67 | 67 | |
| 68 | 68 | $_user['genre'] = strtolower($_user['genre']); |
| 69 | - $_user['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_user['username']); |
|
| 69 | + $_user['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_user['username']); |
|
| 70 | 70 | |
| 71 | 71 | if(!check_valid_colorhex($_user['primary_color']) && strlen($_user['primary_color']) != 6) { $_user['primary_color'] = ""; } |
| 72 | 72 | if(!check_valid_colorhex($_user['secondary_color']) && strlen($_user['secondary_color']) != 6) { $_user['secondary_color'] = ""; } |
@@ -75,8 +75,8 @@ discard block |
||
| 75 | 75 | if(!check_valid_colorhex($_user['primary_color_text']) && strlen($_user['primary_color_text']) != 6) { $_user['primary_color_text'] = ""; } |
| 76 | 76 | if(!check_valid_colorhex($_user['2009_bgcolor']) && strlen($_user['2009_bgcolor']) != 6) { $_user['2009_bgcolor'] = ""; } |
| 77 | 77 | |
| 78 | - if(isset($_SESSION['siteusername'])) |
|
| 79 | - $__user_i->check_view_channel($_user['username'], @$_SESSION['siteusername']); |
|
| 78 | + if(isset($_SESSION['siteusername'])) |
|
| 79 | + $__user_i->check_view_channel($_user['username'], @$_SESSION['siteusername']); |
|
| 80 | 80 | |
| 81 | 81 | if($_SERVER['REQUEST_METHOD'] == 'POST') { |
| 82 | 82 | $error = array(); |
@@ -90,11 +90,11 @@ discard block |
||
| 90 | 90 | //if(ifBlocked(@$_SESSION['siteusername'], $user['username'], $__db)) { $error = "This user has blocked you!"; $error['status'] = true; } |
| 91 | 91 | |
| 92 | 92 | if(!isset($error['message'])) { |
| 93 | - $text = $_POST['comment']; |
|
| 93 | + $text = $_POST['comment']; |
|
| 94 | 94 | $stmt = $__db->prepare("INSERT INTO profile_comments (toid, author, comment) VALUES (:id, :username, :comment)"); |
| 95 | - $stmt->bindParam(":id", $_user['username']); |
|
| 96 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 97 | - $stmt->bindParam(":comment", $text); |
|
| 95 | + $stmt->bindParam(":id", $_user['username']); |
|
| 96 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 97 | + $stmt->bindParam(":comment", $text); |
|
| 98 | 98 | $stmt->execute(); |
| 99 | 99 | |
| 100 | 100 | $_user_update_utils->update_comment_cooldown_time($_SESSION['siteusername']); |
@@ -104,7 +104,7 @@ discard block |
||
| 104 | 104 | } |
| 105 | 105 | } |
| 106 | 106 | } |
| 107 | - ?> |
|
| 107 | + ?> |
|
| 108 | 108 | <!DOCTYPE html> |
| 109 | 109 | <html dir="ltr" xmlns:og="http://opengraphprotocol.org/schema/" lang="en"> |
| 110 | 110 | <!-- machid: sNW5tN3Z2SWdXaDRqNGxuNEF5MFBxM1BxWXd0VGo0Rkg3UXNTTTNCUGRDWjR0WGpHR3R1YzFR --> |
@@ -146,9 +146,9 @@ discard block |
||
| 146 | 146 | <div class="channel_customization"><?php echo require($_SERVER['DOCUMENT_ROOT'] . "/s/mod/channel_customization.php"); ?></div> |
| 147 | 147 | <?php } ?> |
| 148 | 148 | <?php |
| 149 | - if(empty(trim($_user['bio']))) |
|
| 150 | - $_user['bio'] = "This user has no description."; |
|
| 151 | - ?> |
|
| 149 | + if(empty(trim($_user['bio']))) |
|
| 150 | + $_user['bio'] = "This user has no description."; |
|
| 151 | + ?> |
|
| 152 | 152 | <div id="content"> |
| 153 | 153 | <div class="subscription-menu-expandable subscription-menu-expandable-channels3 yt-rounded ytg-wide hid"> |
| 154 | 154 | <div class="content" id="recommended-channels-list"></div> |
@@ -477,9 +477,9 @@ discard block |
||
| 477 | 477 | <h2>Featured Channels</h2> |
| 478 | 478 | <ul class="channel-summary-list "> |
| 479 | 479 | <?php |
| 480 | - foreach($_user['featured_channels'] as $user) { |
|
| 481 | - if($__user_h->user_exists($user)) { |
|
| 482 | - ?> |
|
| 480 | + foreach($_user['featured_channels'] as $user) { |
|
| 481 | + if($__user_h->user_exists($user)) { |
|
| 482 | + ?> |
|
| 483 | 483 | <li class="yt-tile-visible yt-uix-tile"> |
| 484 | 484 | <div class="channel-summary clearfix channel-summary-compact"> |
| 485 | 485 | <div class="channel-summary-thumb"> |
@@ -503,19 +503,19 @@ discard block |
||
| 503 | 503 | </div> |
| 504 | 504 | |
| 505 | 505 | <?php |
| 506 | - $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :search ORDER BY id DESC LIMIT 10"); |
|
| 507 | - $stmt->bindParam(":search", $_user['username']); |
|
| 508 | - $stmt->execute(); |
|
| 506 | + $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :search ORDER BY id DESC LIMIT 10"); |
|
| 507 | + $stmt->bindParam(":search", $_user['username']); |
|
| 508 | + $stmt->execute(); |
|
| 509 | 509 | |
| 510 | - if($stmt->rowCount() != 0) { |
|
| 511 | - ?> |
|
| 510 | + if($stmt->rowCount() != 0) { |
|
| 511 | + ?> |
|
| 512 | 512 | <div class="playlists-narrow channel-module yt-uix-c3-module-container"> |
| 513 | 513 | <div class="module-view gh-featured"> |
| 514 | 514 | <h2>Featured Playlists</h2> |
| 515 | 515 | <?php |
| 516 | - while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 517 | - $playlist['videos'] = json_decode($playlist['videos']); |
|
| 518 | - ?> |
|
| 516 | + while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 517 | + $playlist['videos'] = json_decode($playlist['videos']); |
|
| 518 | + ?> |
|
| 519 | 519 | <div class="playlist yt-tile-visible yt-uix-tile"> |
| 520 | 520 | <a href="/view_playlist?v=<?php echo $playlist['rid']; ?>"> |
| 521 | 521 | <span class="playlist-thumb-strip playlist-thumb-strip-252"><span class="videos videos-4 horizontal-cutoff"><span class="clip"><span class="centering-offset"><span class="centering"> |
@@ -23,14 +23,14 @@ discard block |
||
| 23 | 23 | if($__user_h->if_cooldown($_SESSION['siteusername'])) { $error['message'] = "You are on a cooldown! Wait for a minute before posting another comment."; $error['status'] = true; } |
| 24 | 24 | |
| 25 | 25 | if(!isset($error['message'])) { |
| 26 | - $text = $_POST['comment']; |
|
| 26 | + $text = $_POST['comment']; |
|
| 27 | 27 | $stmt = $__db->prepare("INSERT INTO comments (toid, author, comment) VALUES (:v, :username, :comment)"); |
| 28 | 28 | $stmt->bindParam(":v", $_GET['v']); |
| 29 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 30 | - $stmt->bindParam(":comment", $text); |
|
| 29 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 30 | + $stmt->bindParam(":comment", $text); |
|
| 31 | 31 | $stmt->execute(); |
| 32 | 32 | |
| 33 | - $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment"); |
|
| 33 | + $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment"); |
|
| 34 | 34 | } |
| 35 | 35 | } |
| 36 | 36 | ?> |
@@ -62,28 +62,28 @@ discard block |
||
| 62 | 62 | if (window.yt.timing) {yt.timing.tick("ct");} |
| 63 | 63 | </script> |
| 64 | 64 | <?php |
| 65 | - $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1); |
|
| 66 | - $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2); |
|
| 65 | + $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1); |
|
| 66 | + $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2); |
|
| 67 | 67 | |
| 68 | - $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4); |
|
| 69 | - $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5); |
|
| 68 | + $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4); |
|
| 69 | + $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5); |
|
| 70 | 70 | |
| 71 | - $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false); |
|
| 72 | - $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true); |
|
| 71 | + $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false); |
|
| 72 | + $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true); |
|
| 73 | 73 | |
| 74 | - if($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 75 | - $_video['likeswidth'] = 50; |
|
| 76 | - $_video['dislikeswidth'] = 50; |
|
| 77 | - } else { |
|
| 78 | - $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 79 | - $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
|
| 80 | - } |
|
| 74 | + if($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 75 | + $_video['likeswidth'] = 50; |
|
| 76 | + $_video['dislikeswidth'] = 50; |
|
| 77 | + } else { |
|
| 78 | + $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 79 | + $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
|
| 80 | + } |
|
| 81 | 81 | |
| 82 | - $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true); |
|
| 83 | - $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false); |
|
| 84 | - $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']); |
|
| 85 | - $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']); |
|
| 86 | - ?> |
|
| 82 | + $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true); |
|
| 83 | + $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false); |
|
| 84 | + $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']); |
|
| 85 | + $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']); |
|
| 86 | + ?> |
|
| 87 | 87 | </head> |
| 88 | 88 | <body id="" class="date-20120927 en_US ltr ytg-old-clearfix guide-feed-v2 gecko gecko-15" dir="ltr"> |
| 89 | 89 | <form name="logoutForm" method="POST" action="/logout"> |
@@ -355,10 +355,10 @@ discard block |
||
| 355 | 355 | </div> |
| 356 | 356 | </div> |
| 357 | 357 | <?php |
| 358 | - $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4"); |
|
| 359 | - $stmt->bindParam(":v", $_GET['v']); |
|
| 360 | - $stmt->execute(); |
|
| 361 | - ?> |
|
| 358 | + $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4"); |
|
| 359 | + $stmt->bindParam(":v", $_GET['v']); |
|
| 360 | + $stmt->execute(); |
|
| 361 | + ?> |
|
| 362 | 362 | |
| 363 | 363 | <?php if($stmt->rowCount() != 0) { ?> |
| 364 | 364 | <div class="comments-section"> |
@@ -368,16 +368,16 @@ discard block |
||
| 368 | 368 | <h4>Video Responses</h4> |
| 369 | 369 | <ul class="video-list"> |
| 370 | 370 | <?php |
| 371 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 372 | - if($__video_h->video_exists($video['video'])) { |
|
| 373 | - $video = $__video_h->fetch_video_rid($video['video']); |
|
| 374 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 375 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 376 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 377 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 378 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 379 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 380 | - ?> |
|
| 371 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 372 | + if($__video_h->video_exists($video['video'])) { |
|
| 373 | + $video = $__video_h->fetch_video_rid($video['video']); |
|
| 374 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 375 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 376 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 377 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 378 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 379 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 380 | + ?> |
|
| 381 | 381 | <li class="video-list-item yt-tile-default"> |
| 382 | 382 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="related-video yt-uix-contextlink yt-uix-sessionlink" data-sessionlink="<?php echo htmlspecialchars($_video['author']); ?>&feature=watch_response"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 383 | 383 | <button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="cjls0QsHOBE" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -459,31 +459,31 @@ discard block |
||
| 459 | 459 | </div> |
| 460 | 460 | <ul class="comment-list" id="live_comments"> |
| 461 | 461 | <?php |
| 462 | - $results_per_page = 20; |
|
| 462 | + $results_per_page = 20; |
|
| 463 | 463 | |
| 464 | - $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC"); |
|
| 465 | - $stmt->bindParam(":rid", $_video['rid']); |
|
| 466 | - $stmt->execute(); |
|
| 464 | + $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC"); |
|
| 465 | + $stmt->bindParam(":rid", $_video['rid']); |
|
| 466 | + $stmt->execute(); |
|
| 467 | 467 | |
| 468 | - $number_of_result = $stmt->rowCount(); |
|
| 469 | - $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 468 | + $number_of_result = $stmt->rowCount(); |
|
| 469 | + $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 470 | 470 | |
| 471 | - if (!isset ($_GET['page']) ) { |
|
| 472 | - $page = 1; |
|
| 473 | - } else { |
|
| 474 | - $page = (int)$_GET['page']; |
|
| 475 | - } |
|
| 471 | + if (!isset ($_GET['page']) ) { |
|
| 472 | + $page = 1; |
|
| 473 | + } else { |
|
| 474 | + $page = (int)$_GET['page']; |
|
| 475 | + } |
|
| 476 | 476 | |
| 477 | - $page_first_result = ($page - 1) * $results_per_page; |
|
| 477 | + $page_first_result = ($page - 1) * $results_per_page; |
|
| 478 | 478 | |
| 479 | - $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 480 | - $stmt->bindParam(":rid", $_video['rid']); |
|
| 481 | - $stmt->bindParam(":pfirst", $page_first_result); |
|
| 482 | - $stmt->bindParam(":pper", $results_per_page); |
|
| 483 | - $stmt->execute(); |
|
| 479 | + $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 480 | + $stmt->bindParam(":rid", $_video['rid']); |
|
| 481 | + $stmt->bindParam(":pfirst", $page_first_result); |
|
| 482 | + $stmt->bindParam(":pper", $results_per_page); |
|
| 483 | + $stmt->execute(); |
|
| 484 | 484 | |
| 485 | - while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 486 | - ?> |
|
| 485 | + while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 486 | + ?> |
|
| 487 | 487 | |
| 488 | 488 | <li class="comment yt-tile-default " data-author-viewing="" data-author-id="-uD01K8FQTeOSS5sniRFzQ" data-id="HdQrMeklJ_5hd_uPDRcvtdaMk2pMVS8d9sufcfiGx0U" data-score="0"> |
| 489 | 489 | <div class="comment-body"> |
@@ -562,16 +562,16 @@ discard block |
||
| 562 | 562 | <ul id="watch-related" class="video-list"> |
| 563 | 563 | <div id="ppv-container" class="hid"></div> |
| 564 | 564 | <?php |
| 565 | - $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20"); |
|
| 566 | - $stmt->execute(); |
|
| 567 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 568 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 569 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 570 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 571 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 572 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 573 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 574 | - ?> |
|
| 565 | + $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20"); |
|
| 566 | + $stmt->execute(); |
|
| 567 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 568 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 569 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 570 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 571 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 572 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 573 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 574 | + ?> |
|
| 575 | 575 | <li class="video-list-item"><a href="/watch?v=<?php echo $video['rid']; ?>" class="related-video yt-uix-contextlink yt-uix-sessionlink" data-sessionlink="ved=CAIQzRooAA%3D%3D&<?php echo htmlspecialchars($_video['author']); ?>&feature=relmfu"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 576 | 576 | <button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="gyAaIKF6tSQ" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
| 577 | 577 | </span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button> |
@@ -37,14 +37,14 @@ discard block |
||
| 37 | 37 | |
| 38 | 38 | // these are all the videos, with their settings, and formats |
| 39 | 39 | $fmt_stream_map = [ |
| 40 | - [ |
|
| 41 | - "itag" => "43", |
|
| 40 | + [ |
|
| 41 | + "itag" => "43", |
|
| 42 | 42 | "url" => $_video['fmtPath'], |
| 43 | 43 | "sig" => "aintnothinggonnabreakmystrideaintnothinggonnaslowmedownnooigottakeeponmovin", |
| 44 | 44 | "fallback_host" => "tc.v14.cache3.c.youtube.com", |
| 45 | 45 | "quality" => "hd720", |
| 46 | 46 | "type" => "video/webm; codecs=\"vp8.0, vorbis\"" |
| 47 | - ], |
|
| 47 | + ], |
|
| 48 | 48 | ]; |
| 49 | 49 | |
| 50 | 50 | $count = 0; |
@@ -69,7 +69,7 @@ discard block |
||
| 69 | 69 | "avg_rating" => "5.0", |
| 70 | 70 | "ttsurl" => "http://www.youtube.com/api/timedtext?signature=E949556D4478C57B95F0E4268F8D85D460D27DF6.1EC1679B0E1466625B2A029D836BE9C135A0B300&hl=en_US&caps=asr&expire=1361228889&sparams=asr_langs%2Ccaps%2Cv%2Cexpire&v=LHdA7Yc-8Rg&key=yttt1&asr_langs=ko%2Cde%2Cpt%2Cen%2Cnl%2Cja%2Cru%2Ces%2Cfr%2Cit", |
| 71 | 71 | "url_encoded_fmt_stream_map" => $url_encoded_fmt_stream_map, |
| 72 | - "plid" => "AATWAe5iQ_FjAV-I", |
|
| 72 | + "plid" => "AATWAe5iQ_FjAV-I", |
|
| 73 | 73 | "view_count" => "24465", |
| 74 | 74 | "cc_asr" => "1", |
| 75 | 75 | "token" => "vjVQa1PpcFPQw_h19VxFJZdJZbKkh5-obrhC9M93j-E=", |
@@ -23,14 +23,14 @@ discard block |
||
| 23 | 23 | if($__user_h->if_cooldown($_SESSION['siteusername'])) { $error['message'] = "You are on a cooldown! Wait for a minute before posting another comment."; $error['status'] = true; } |
| 24 | 24 | |
| 25 | 25 | if(!isset($error['message'])) { |
| 26 | - $text = $_POST['comment']; |
|
| 26 | + $text = $_POST['comment']; |
|
| 27 | 27 | $stmt = $__db->prepare("INSERT INTO comments (toid, author, comment) VALUES (:v, :username, :comment)"); |
| 28 | 28 | $stmt->bindParam(":v", $_GET['v']); |
| 29 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 30 | - $stmt->bindParam(":comment", $text); |
|
| 29 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 30 | + $stmt->bindParam(":comment", $text); |
|
| 31 | 31 | $stmt->execute(); |
| 32 | 32 | |
| 33 | - $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment"); |
|
| 33 | + $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment"); |
|
| 34 | 34 | } |
| 35 | 35 | } |
| 36 | 36 | ?> |
@@ -53,28 +53,28 @@ 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); |
|
| 57 | - $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2); |
|
| 56 | + $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1); |
|
| 57 | + $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2); |
|
| 58 | 58 | |
| 59 | - $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4); |
|
| 60 | - $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5); |
|
| 59 | + $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4); |
|
| 60 | + $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5); |
|
| 61 | 61 | |
| 62 | - $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false); |
|
| 63 | - $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true); |
|
| 62 | + $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false); |
|
| 63 | + $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true); |
|
| 64 | 64 | |
| 65 | - if($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 66 | - $_video['likeswidth'] = 50; |
|
| 67 | - $_video['dislikeswidth'] = 50; |
|
| 68 | - } else { |
|
| 69 | - $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 70 | - $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
|
| 71 | - } |
|
| 65 | + if($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 66 | + $_video['likeswidth'] = 50; |
|
| 67 | + $_video['dislikeswidth'] = 50; |
|
| 68 | + } else { |
|
| 69 | + $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 70 | + $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
|
| 71 | + } |
|
| 72 | 72 | |
| 73 | - $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true); |
|
| 74 | - $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false); |
|
| 75 | - $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']); |
|
| 76 | - $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']); |
|
| 77 | - ?> |
|
| 73 | + $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true); |
|
| 74 | + $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false); |
|
| 75 | + $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']); |
|
| 76 | + $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']); |
|
| 77 | + ?> |
|
| 78 | 78 | </head> |
| 79 | 79 | <body id="" class="date-20120927 en_US ltr ytg-old-clearfix guide-feed-v2 gecko gecko-15" dir="ltr"> |
| 80 | 80 | <form name="logoutForm" method="POST" action="/logout"> |
@@ -360,10 +360,10 @@ discard block |
||
| 360 | 360 | </div> |
| 361 | 361 | </div> |
| 362 | 362 | <?php |
| 363 | - $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4"); |
|
| 364 | - $stmt->bindParam(":v", $_GET['v']); |
|
| 365 | - $stmt->execute(); |
|
| 366 | - ?> |
|
| 363 | + $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4"); |
|
| 364 | + $stmt->bindParam(":v", $_GET['v']); |
|
| 365 | + $stmt->execute(); |
|
| 366 | + ?> |
|
| 367 | 367 | |
| 368 | 368 | <?php if($stmt->rowCount() != 0) { ?> |
| 369 | 369 | <div class="comments-section"> |
@@ -373,16 +373,16 @@ discard block |
||
| 373 | 373 | <h4>Video Responses</h4> |
| 374 | 374 | <ul class="video-list"> |
| 375 | 375 | <?php |
| 376 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 377 | - if($__video_h->video_exists($video['video'])) { |
|
| 378 | - $video = $__video_h->fetch_video_rid($video['video']); |
|
| 379 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 380 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 381 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 382 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 383 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 384 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 385 | - ?> |
|
| 376 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 377 | + if($__video_h->video_exists($video['video'])) { |
|
| 378 | + $video = $__video_h->fetch_video_rid($video['video']); |
|
| 379 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 380 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 381 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 382 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 383 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 384 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 385 | + ?> |
|
| 386 | 386 | <li class="video-list-item yt-tile-default"> |
| 387 | 387 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="related-video yt-uix-contextlink yt-uix-sessionlink" data-sessionlink="<?php echo htmlspecialchars($_video['author']); ?>&feature=watch_response"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 388 | 388 | <button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="cjls0QsHOBE" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -464,31 +464,31 @@ discard block |
||
| 464 | 464 | </div> |
| 465 | 465 | <ul class="comment-list" id="live_comments"> |
| 466 | 466 | <?php |
| 467 | - $results_per_page = 20; |
|
| 467 | + $results_per_page = 20; |
|
| 468 | 468 | |
| 469 | - $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC"); |
|
| 470 | - $stmt->bindParam(":rid", $_video['rid']); |
|
| 471 | - $stmt->execute(); |
|
| 469 | + $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC"); |
|
| 470 | + $stmt->bindParam(":rid", $_video['rid']); |
|
| 471 | + $stmt->execute(); |
|
| 472 | 472 | |
| 473 | - $number_of_result = $stmt->rowCount(); |
|
| 474 | - $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 473 | + $number_of_result = $stmt->rowCount(); |
|
| 474 | + $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 475 | 475 | |
| 476 | - if (!isset ($_GET['page']) ) { |
|
| 477 | - $page = 1; |
|
| 478 | - } else { |
|
| 479 | - $page = (int)$_GET['page']; |
|
| 480 | - } |
|
| 476 | + if (!isset ($_GET['page']) ) { |
|
| 477 | + $page = 1; |
|
| 478 | + } else { |
|
| 479 | + $page = (int)$_GET['page']; |
|
| 480 | + } |
|
| 481 | 481 | |
| 482 | - $page_first_result = ($page - 1) * $results_per_page; |
|
| 482 | + $page_first_result = ($page - 1) * $results_per_page; |
|
| 483 | 483 | |
| 484 | - $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 485 | - $stmt->bindParam(":rid", $_video['rid']); |
|
| 486 | - $stmt->bindParam(":pfirst", $page_first_result); |
|
| 487 | - $stmt->bindParam(":pper", $results_per_page); |
|
| 488 | - $stmt->execute(); |
|
| 484 | + $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 485 | + $stmt->bindParam(":rid", $_video['rid']); |
|
| 486 | + $stmt->bindParam(":pfirst", $page_first_result); |
|
| 487 | + $stmt->bindParam(":pper", $results_per_page); |
|
| 488 | + $stmt->execute(); |
|
| 489 | 489 | |
| 490 | - while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 491 | - ?> |
|
| 490 | + while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 491 | + ?> |
|
| 492 | 492 | |
| 493 | 493 | <li class="comment yt-tile-default " data-author-viewing="" data-author-id="-uD01K8FQTeOSS5sniRFzQ" data-id="HdQrMeklJ_5hd_uPDRcvtdaMk2pMVS8d9sufcfiGx0U" data-score="0"> |
| 494 | 494 | <div class="comment-body"> |
@@ -567,16 +567,16 @@ discard block |
||
| 567 | 567 | <ul id="watch-related" class="video-list"> |
| 568 | 568 | <div id="ppv-container" class="hid"></div> |
| 569 | 569 | <?php |
| 570 | - $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20"); |
|
| 571 | - $stmt->execute(); |
|
| 572 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 573 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 574 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 575 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 576 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 577 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 578 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 579 | - ?> |
|
| 570 | + $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20"); |
|
| 571 | + $stmt->execute(); |
|
| 572 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 573 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 574 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 575 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 576 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 577 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 578 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 579 | + ?> |
|
| 580 | 580 | <li class="video-list-item"><a href="/watch?v=<?php echo $video['rid']; ?>" class="related-video yt-uix-contextlink yt-uix-sessionlink" data-sessionlink="ved=CAIQzRooAA%3D%3D&<?php echo htmlspecialchars($_video['author']); ?>&feature=relmfu"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 581 | 581 | <button onclick=";return false;" title="Watch Later" type="button" class="addto-button video-actions addto-watch-later-button-sign-in yt-uix-button yt-uix-button-default yt-uix-button-short yt-uix-tooltip" data-button-menu-id="shared-addto-watch-later-login" data-video-ids="gyAaIKF6tSQ" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
| 582 | 582 | </span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button> |
