the-real-sumsome /
subrocks-2012
@@ -12,8 +12,8 @@ discard block |
||
| 12 | 12 | <?php $__db_h = new db_helper(); ?> |
| 13 | 13 | <?php $__time_h = new time_helper(); ?> |
| 14 | 14 | <?php |
| 15 | - if(isset($_SESSION['siteusername'])) |
|
| 16 | - $_user_hp = $__user_h->fetch_user_username($_SESSION['siteusername']); |
|
| 15 | + if(isset($_SESSION['siteusername'])) |
|
| 16 | + $_user_hp = $__user_h->fetch_user_username($_SESSION['siteusername']); |
|
| 17 | 17 | |
| 18 | 18 | if(!$__user_h->user_exists($_GET['n'])) |
| 19 | 19 | header("Location: /?userdoesntexist"); |
@@ -26,21 +26,21 @@ discard block |
||
| 26 | 26 | return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars. |
| 27 | 27 | } |
| 28 | 28 | |
| 29 | - function addhttp($url) { |
|
| 30 | - if (!preg_match("~^(?:f|ht)tps?://~i", $url)) { |
|
| 31 | - $url = "http://" . $url; |
|
| 32 | - } |
|
| 33 | - return $url; |
|
| 34 | - } |
|
| 29 | + function addhttp($url) { |
|
| 30 | + if (!preg_match("~^(?:f|ht)tps?://~i", $url)) { |
|
| 31 | + $url = "http://" . $url; |
|
| 32 | + } |
|
| 33 | + return $url; |
|
| 34 | + } |
|
| 35 | 35 | |
| 36 | 36 | function check_valid_colorhex($colorCode) { |
| 37 | 37 | // If user accidentally passed along the # sign, strip it off |
| 38 | 38 | $colorCode = ltrim($colorCode, '#'); |
| 39 | 39 | |
| 40 | 40 | if ( |
| 41 | - ctype_xdigit($colorCode) && |
|
| 41 | + ctype_xdigit($colorCode) && |
|
| 42 | 42 | (strlen($colorCode) == 6 || strlen($colorCode) == 3)) |
| 43 | - return true; |
|
| 43 | + return true; |
|
| 44 | 44 | |
| 45 | 45 | else return false; |
| 46 | 46 | } |
@@ -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']); |
@@ -106,10 +106,10 @@ discard block |
||
| 106 | 106 | } |
| 107 | 107 | ?> |
| 108 | 108 | <?php |
| 109 | - $__server->page_embeds->page_title = "SubRocks - " . htmlspecialchars($_user['username']); |
|
| 110 | - $__server->page_embeds->page_description = htmlspecialchars($_user['bio']); |
|
| 111 | - $__server->page_embeds->page_image = "/dynamic/pfp/" . htmlspecialchars($_user['pfp']); |
|
| 112 | - $__server->page_embeds->page_url = "https://subrock.rocks/"; |
|
| 109 | + $__server->page_embeds->page_title = "SubRocks - " . htmlspecialchars($_user['username']); |
|
| 110 | + $__server->page_embeds->page_description = htmlspecialchars($_user['bio']); |
|
| 111 | + $__server->page_embeds->page_image = "/dynamic/pfp/" . htmlspecialchars($_user['pfp']); |
|
| 112 | + $__server->page_embeds->page_url = "https://subrock.rocks/"; |
|
| 113 | 113 | ?> |
| 114 | 114 | <!DOCTYPE html> |
| 115 | 115 | <html dir="ltr" xmlns:og="http://opengraphprotocol.org/schema/" lang="en"> |
@@ -137,27 +137,27 @@ discard block |
||
| 137 | 137 | background-image: url(/dynamic/banners/<?php echo $_user['2012_bg']; ?>); |
| 138 | 138 | background-repeat: repeat; |
| 139 | 139 | <?php |
| 140 | - switch($_user['2012_bgoption']) { |
|
| 141 | - case "stretch": |
|
| 142 | - echo "background-size: cover;"; |
|
| 143 | - break; |
|
| 144 | - case "solid": |
|
| 145 | - echo ""; |
|
| 146 | - break; |
|
| 147 | - case "norepeat": |
|
| 148 | - echo "background-repeat: no-repeat !important;"; |
|
| 149 | - break; |
|
| 150 | - case "repeatxy": |
|
| 151 | - echo "background-repeat: repeat;"; |
|
| 152 | - break; |
|
| 153 | - case "repeaty": |
|
| 154 | - echo "background-repeat: repeat-y;"; |
|
| 155 | - break; |
|
| 156 | - case "repeatx": |
|
| 157 | - echo "background-repeat: repeat-x;"; |
|
| 158 | - break; |
|
| 159 | - } |
|
| 160 | - ?> |
|
| 140 | + switch($_user['2012_bgoption']) { |
|
| 141 | + case "stretch": |
|
| 142 | + echo "background-size: cover;"; |
|
| 143 | + break; |
|
| 144 | + case "solid": |
|
| 145 | + echo ""; |
|
| 146 | + break; |
|
| 147 | + case "norepeat": |
|
| 148 | + echo "background-repeat: no-repeat !important;"; |
|
| 149 | + break; |
|
| 150 | + case "repeatxy": |
|
| 151 | + echo "background-repeat: repeat;"; |
|
| 152 | + break; |
|
| 153 | + case "repeaty": |
|
| 154 | + echo "background-repeat: repeat-y;"; |
|
| 155 | + break; |
|
| 156 | + case "repeatx": |
|
| 157 | + echo "background-repeat: repeat-x;"; |
|
| 158 | + break; |
|
| 159 | + } |
|
| 160 | + ?> |
|
| 161 | 161 | } |
| 162 | 162 | </style> |
| 163 | 163 | </head> |
@@ -330,17 +330,17 @@ discard block |
||
| 330 | 330 | <div class="channel-filtered-content"> |
| 331 | 331 | <ol class="channel-videos-list"> |
| 332 | 332 | <?php |
| 333 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE author = :username ORDER BY id DESC"); |
|
| 334 | - $stmt->bindParam(":username", $_user['username']); |
|
| 335 | - $stmt->execute(); |
|
| 336 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 337 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 338 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 339 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 340 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 341 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 342 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 343 | - ?> |
|
| 333 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE author = :username ORDER BY id DESC"); |
|
| 334 | + $stmt->bindParam(":username", $_user['username']); |
|
| 335 | + $stmt->execute(); |
|
| 336 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 337 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 338 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 339 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 340 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 341 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 342 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 343 | + ?> |
|
| 344 | 344 | <li class="yt-c3-grid-item"> |
| 345 | 345 | <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" onerror="this.onerror=null;this.src='/dynamic/thumbs/default.jpg';" width="234"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 346 | 346 | <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"> |
@@ -15,29 +15,29 @@ discard block |
||
| 15 | 15 | <?php $_video = $__video_h->fetch_video_rid($_GET['v']); ?> |
| 16 | 16 | <?php $_video['comments'] = $__video_h->get_comments_from_video($_video['rid']); ?> |
| 17 | 17 | <?php |
| 18 | - if($_video['visibility'] == "v" && @$_SESSION['siteusername'] != $_video['author']) |
|
| 19 | - header("Location: /"); |
|
| 18 | + if($_video['visibility'] == "v" && @$_SESSION['siteusername'] != $_video['author']) |
|
| 19 | + header("Location: /"); |
|
| 20 | 20 | |
| 21 | - if(isset($_SESSION['siteusername'])) |
|
| 22 | - $__video_h->check_view($_GET['v'], @$_SESSION['siteusername']); |
|
| 21 | + if(isset($_SESSION['siteusername'])) |
|
| 22 | + $__video_h->check_view($_GET['v'], @$_SESSION['siteusername']); |
|
| 23 | 23 | |
| 24 | - $_SESSION['current_video'] = $_video['rid']; |
|
| 24 | + $_SESSION['current_video'] = $_video['rid']; |
|
| 25 | 25 | |
| 26 | - /* |
|
| 26 | + /* |
|
| 27 | 27 | PREPARE EMBEDS CLASS -- function(string $page_title, string $page_description...) |
| 28 | 28 | Returns a list of arrays for compatibility purposes & but downside is ugly for loop codes |
| 29 | 29 | Work on this tomorrow or some shit idk lol |
| 30 | 30 | */ |
| 31 | 31 | |
| 32 | - /* |
|
| 32 | + /* |
|
| 33 | 33 | USE THE GOD DAMN __CONFIG MORE -- idiot |
| 34 | 34 | Work on this tomorrow or some shit |
| 35 | 35 | */ |
| 36 | 36 | |
| 37 | - $__server->page_embeds->page_title = htmlspecialchars($_video['title']); |
|
| 38 | - $__server->page_embeds->page_description = htmlspecialchars($_video['description']); |
|
| 39 | - $__server->page_embeds->page_image = "/dynamic/thumbs/" . $_video['thumbnail']; |
|
| 40 | - $__server->page_embeds->page_url = "https://subrock.rocks/watch?v=" . htmlspecialchars($_video['rid']); |
|
| 37 | + $__server->page_embeds->page_title = htmlspecialchars($_video['title']); |
|
| 38 | + $__server->page_embeds->page_description = htmlspecialchars($_video['description']); |
|
| 39 | + $__server->page_embeds->page_image = "/dynamic/thumbs/" . $_video['thumbnail']; |
|
| 40 | + $__server->page_embeds->page_url = "https://subrock.rocks/watch?v=" . htmlspecialchars($_video['rid']); |
|
| 41 | 41 | ?> |
| 42 | 42 | <!DOCTYPE html> |
| 43 | 43 | <html> |
@@ -67,29 +67,29 @@ discard block |
||
| 67 | 67 | if (window.yt.timing) {yt.timing.tick("ct");} |
| 68 | 68 | </script> |
| 69 | 69 | <?php |
| 70 | - $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1); |
|
| 71 | - $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2); |
|
| 70 | + $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1); |
|
| 71 | + $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2); |
|
| 72 | 72 | |
| 73 | - $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4); |
|
| 74 | - $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5); |
|
| 73 | + $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4); |
|
| 74 | + $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5); |
|
| 75 | 75 | |
| 76 | - $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false); |
|
| 77 | - $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true); |
|
| 76 | + $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false); |
|
| 77 | + $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true); |
|
| 78 | 78 | |
| 79 | - if($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 80 | - $_video['likeswidth'] = 0; |
|
| 81 | - $_video['dislikeswidth'] = 0; |
|
| 82 | - } else { |
|
| 83 | - $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 84 | - $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
|
| 85 | - } |
|
| 79 | + if($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 80 | + $_video['likeswidth'] = 0; |
|
| 81 | + $_video['dislikeswidth'] = 0; |
|
| 82 | + } else { |
|
| 83 | + $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 84 | + $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
|
| 85 | + } |
|
| 86 | 86 | |
| 87 | - $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true); |
|
| 88 | - $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false); |
|
| 89 | - $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']); |
|
| 90 | - $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']); |
|
| 91 | - $_video['favorited'] = $__video_h->if_favorited(@$_SESSION['siteusername'], $_video['rid']); |
|
| 92 | - ?> |
|
| 87 | + $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true); |
|
| 88 | + $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false); |
|
| 89 | + $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']); |
|
| 90 | + $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']); |
|
| 91 | + $_video['favorited'] = $__video_h->if_favorited(@$_SESSION['siteusername'], $_video['rid']); |
|
| 92 | + ?> |
|
| 93 | 93 | </head> |
| 94 | 94 | <body id="" class="date-20120927 en_US ltr ytg-old-clearfix guide-feed-v2 gecko gecko-15" dir="ltr"> |
| 95 | 95 | <form name="logoutForm" method="POST" action="/logout"> |
@@ -333,21 +333,21 @@ discard block |
||
| 333 | 333 | <hr><br> |
| 334 | 334 | <h3>Add to a Playlist</h3> |
| 335 | 335 | <?php |
| 336 | - $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :username ORDER BY id DESC LIMIT 20"); |
|
| 337 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 338 | - $stmt->execute(); |
|
| 339 | - while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 340 | - $buffer = json_decode($playlist['videos']); |
|
| 341 | - @$rid = $buffer[0]; |
|
| 342 | - if(!empty($rid)) { |
|
| 343 | - @$video = $__video_h->fetch_video_rid($rid); |
|
| 344 | - } else { |
|
| 345 | - $video['thumbnail'] = ""; |
|
| 346 | - $video['duration'] = 0; |
|
| 347 | - } |
|
| 336 | + $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :username ORDER BY id DESC LIMIT 20"); |
|
| 337 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 338 | + $stmt->execute(); |
|
| 339 | + while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 340 | + $buffer = json_decode($playlist['videos']); |
|
| 341 | + @$rid = $buffer[0]; |
|
| 342 | + if(!empty($rid)) { |
|
| 343 | + @$video = $__video_h->fetch_video_rid($rid); |
|
| 344 | + } else { |
|
| 345 | + $video['thumbnail'] = ""; |
|
| 346 | + $video['duration'] = 0; |
|
| 347 | + } |
|
| 348 | 348 | |
| 349 | - $videos = count($buffer); |
|
| 350 | - ?> |
|
| 349 | + $videos = count($buffer); |
|
| 350 | + ?> |
|
| 351 | 351 | <a href="/get/add_to_playlist?id=<?php echo $_video['rid']; ?>&playlist=<?php echo $playlist['rid']; ?>">Add to <?php echo htmlspecialchars($playlist['title']); ?></a><br> |
| 352 | 352 | <?php } ?> |
| 353 | 353 | <?php } ?> |
@@ -612,10 +612,10 @@ discard block |
||
| 612 | 612 | </div> |
| 613 | 613 | </div> |
| 614 | 614 | <?php |
| 615 | - $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4"); |
|
| 616 | - $stmt->bindParam(":v", $_GET['v']); |
|
| 617 | - $stmt->execute(); |
|
| 618 | - ?> |
|
| 615 | + $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4"); |
|
| 616 | + $stmt->bindParam(":v", $_GET['v']); |
|
| 617 | + $stmt->execute(); |
|
| 618 | + ?> |
|
| 619 | 619 | |
| 620 | 620 | <?php if($stmt->rowCount() != 0) { ?> |
| 621 | 621 | <div class="comments-section"> |
@@ -625,16 +625,16 @@ discard block |
||
| 625 | 625 | <h4>Video Responses</h4> |
| 626 | 626 | <ul class="video-list"> |
| 627 | 627 | <?php |
| 628 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 629 | - if($__video_h->video_exists($video['video'])) { |
|
| 630 | - $video = $__video_h->fetch_video_rid($video['video']); |
|
| 631 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 632 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 633 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 634 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 635 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 636 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 637 | - ?> |
|
| 628 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 629 | + if($__video_h->video_exists($video['video'])) { |
|
| 630 | + $video = $__video_h->fetch_video_rid($video['video']); |
|
| 631 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 632 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 633 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 634 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 635 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 636 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 637 | + ?> |
|
| 638 | 638 | <li class="video-list-item yt-tile-default"> |
| 639 | 639 | <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> |
| 640 | 640 | <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"> |
@@ -715,38 +715,38 @@ discard block |
||
| 715 | 715 | </div> |
| 716 | 716 | <ul class="comment-list" id="live_comments"> |
| 717 | 717 | <?php |
| 718 | - $results_per_page = 20; |
|
| 718 | + $results_per_page = 20; |
|
| 719 | 719 | |
| 720 | - $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC"); |
|
| 721 | - $stmt->bindParam(":rid", $_video['rid']); |
|
| 722 | - $stmt->execute(); |
|
| 720 | + $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC"); |
|
| 721 | + $stmt->bindParam(":rid", $_video['rid']); |
|
| 722 | + $stmt->execute(); |
|
| 723 | 723 | |
| 724 | - $number_of_result = $stmt->rowCount(); |
|
| 725 | - $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 724 | + $number_of_result = $stmt->rowCount(); |
|
| 725 | + $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 726 | 726 | |
| 727 | - if (!isset ($_GET['page']) ) { |
|
| 728 | - $page = 1; |
|
| 729 | - } else { |
|
| 730 | - $page = (int)$_GET['page']; |
|
| 731 | - } |
|
| 727 | + if (!isset ($_GET['page']) ) { |
|
| 728 | + $page = 1; |
|
| 729 | + } else { |
|
| 730 | + $page = (int)$_GET['page']; |
|
| 731 | + } |
|
| 732 | 732 | |
| 733 | - $page_first_result = ($page - 1) * $results_per_page; |
|
| 733 | + $page_first_result = ($page - 1) * $results_per_page; |
|
| 734 | 734 | |
| 735 | - $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 736 | - $stmt->bindParam(":rid", $_video['rid']); |
|
| 737 | - $stmt->bindParam(":pfirst", $page_first_result); |
|
| 738 | - $stmt->bindParam(":pper", $results_per_page); |
|
| 739 | - $stmt->execute(); |
|
| 735 | + $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 736 | + $stmt->bindParam(":rid", $_video['rid']); |
|
| 737 | + $stmt->bindParam(":pfirst", $page_first_result); |
|
| 738 | + $stmt->bindParam(":pper", $results_per_page); |
|
| 739 | + $stmt->execute(); |
|
| 740 | 740 | |
| 741 | - while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 742 | - if($__video_h->if_comment_liked($comment['id'], $_SESSION['siteusername'], true)) |
|
| 743 | - $comment['liked'] = true; |
|
| 744 | - else if($__video_h->if_comment_liked($comment['id'], $_SESSION['siteusername'], false)) |
|
| 745 | - $comment['disliked'] = true; |
|
| 741 | + while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 742 | + if($__video_h->if_comment_liked($comment['id'], $_SESSION['siteusername'], true)) |
|
| 743 | + $comment['liked'] = true; |
|
| 744 | + else if($__video_h->if_comment_liked($comment['id'], $_SESSION['siteusername'], false)) |
|
| 745 | + $comment['disliked'] = true; |
|
| 746 | 746 | |
| 747 | - $comment['likes'] = $__video_h->get_comment_likes($comment['id'], true); |
|
| 748 | - $comment['likes'] -= $__video_h->get_comment_likes($comment['id'], false); |
|
| 749 | - ?> |
|
| 747 | + $comment['likes'] = $__video_h->get_comment_likes($comment['id'], true); |
|
| 748 | + $comment['likes'] -= $__video_h->get_comment_likes($comment['id'], false); |
|
| 749 | + ?> |
|
| 750 | 750 | |
| 751 | 751 | <li class="comment yt-tile-default " data-author-viewing="" data-author-id="-uD01K8FQTeOSS5sniRFzQ" data-id="<?php echo $comment['id']; ?>" data-score="0"> |
| 752 | 752 | <div class="comment-body"> |
@@ -812,12 +812,12 @@ discard block |
||
| 812 | 812 | </div> |
| 813 | 813 | </li> |
| 814 | 814 | <?php |
| 815 | - $stmt2 = $__db->prepare("SELECT * FROM comment_reply WHERE toid = :rid ORDER BY id DESC"); |
|
| 816 | - $stmt2->bindParam(":rid", $comment['id']); |
|
| 817 | - $stmt2->execute(); |
|
| 815 | + $stmt2 = $__db->prepare("SELECT * FROM comment_reply WHERE toid = :rid ORDER BY id DESC"); |
|
| 816 | + $stmt2->bindParam(":rid", $comment['id']); |
|
| 817 | + $stmt2->execute(); |
|
| 818 | 818 | |
| 819 | - while($reply = $stmt2->fetch(PDO::FETCH_ASSOC)) { |
|
| 820 | - ?> |
|
| 819 | + while($reply = $stmt2->fetch(PDO::FETCH_ASSOC)) { |
|
| 820 | + ?> |
|
| 821 | 821 | <li class="comment yt-tile-default " style="margin-left: 30px;" data-author-viewing="" data-author-id="-uD01K8FQTeOSS5sniRFzQ" data-id="<?php echo $reply['id']; ?>" data-score="0"> |
| 822 | 822 | <div class="comment-body"> |
| 823 | 823 | <div class="content-container"> |
@@ -897,19 +897,19 @@ discard block |
||
| 897 | 897 | <div id="watch-related-container" class="watch-sidebar-body"> |
| 898 | 898 | <ul id="watch-related" class="video-list"> |
| 899 | 899 | <?php |
| 900 | - $stmt = $__db->prepare("SELECT * FROM playlists ORDER BY rand() LIMIT 2"); |
|
| 901 | - $stmt->execute(); |
|
| 902 | - while($_playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 903 | - $_playlist['videos'] = json_decode($_playlist['videos']); |
|
| 904 | - $_playlist['count'] = 1; |
|
| 900 | + $stmt = $__db->prepare("SELECT * FROM playlists ORDER BY rand() LIMIT 2"); |
|
| 901 | + $stmt->execute(); |
|
| 902 | + while($_playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 903 | + $_playlist['videos'] = json_decode($_playlist['videos']); |
|
| 904 | + $_playlist['count'] = 1; |
|
| 905 | 905 | |
| 906 | - if($__video_h->video_exists($_playlist['videos'][0])) { |
|
| 907 | - $video = $__video_h->fetch_video_rid($_playlist['videos'][0]); |
|
| 908 | - } else { |
|
| 909 | - $video = []; |
|
| 910 | - $video['thumbnail'] = "default.jpg"; |
|
| 911 | - } |
|
| 912 | - ?> |
|
| 906 | + if($__video_h->video_exists($_playlist['videos'][0])) { |
|
| 907 | + $video = $__video_h->fetch_video_rid($_playlist['videos'][0]); |
|
| 908 | + } else { |
|
| 909 | + $video = []; |
|
| 910 | + $video['thumbnail'] = "default.jpg"; |
|
| 911 | + } |
|
| 912 | + ?> |
|
| 913 | 913 | <li class="video-list-item"> |
| 914 | 914 | <a href="/view_playlist?v=<?php echo $_playlist['rid']; ?>" class="related-playlist yt-uix-contextlink yt-uix-sessionlink" data-sessionlink="ved=CAMQzhooAA%3D%3D&ei=CKf4md_r7rMCFYMfRAodLGlRiA%3D%3D&feature=list_other"> |
| 915 | 915 | <span class="ux-thumb-wrap"> |
@@ -956,16 +956,16 @@ discard block |
||
| 956 | 956 | <?php } ?> |
| 957 | 957 | <div id="ppv-container" class="hid"></div> |
| 958 | 958 | <?php |
| 959 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE visibility = 'n' ORDER BY rand() LIMIT 20"); |
|
| 960 | - $stmt->execute(); |
|
| 961 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 962 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 963 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 964 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 965 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 966 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 967 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 968 | - ?> |
|
| 959 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE visibility = 'n' ORDER BY rand() LIMIT 20"); |
|
| 960 | + $stmt->execute(); |
|
| 961 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 962 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 963 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 964 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 965 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 966 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 967 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 968 | + ?> |
|
| 969 | 969 | <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']; ?>" onerror=";this.src='/dynamic/thumbs/default.jpg';" 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> |
| 970 | 970 | <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"> |
| 971 | 971 | </span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button> |
