@@ -8,17 +8,17 @@ |
||
| 8 | 8 | <?php $__db_h = new db_helper(); ?> |
| 9 | 9 | <?php $__time_h = new time_helper(); ?> |
| 10 | 10 | <?php |
| 11 | - if(!$__video_h->video_exists($_GET['v'])) |
|
| 12 | - header("Location: /?error=Your video has not processed correctly. Try reuploading it with a shorter title, description, or tag."); |
|
| 11 | + if(!$__video_h->video_exists($_GET['v'])) |
|
| 12 | + header("Location: /?error=Your video has not processed correctly. Try reuploading it with a shorter title, description, or tag."); |
|
| 13 | 13 | |
| 14 | - $video = $__video_h->fetch_video_rid($_GET['v']); |
|
| 15 | - $video['video_responses'] = $__video_h->get_video_responses($video['rid']); |
|
| 16 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 17 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 18 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 19 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 20 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 21 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 14 | + $video = $__video_h->fetch_video_rid($_GET['v']); |
|
| 15 | + $video['video_responses'] = $__video_h->get_video_responses($video['rid']); |
|
| 16 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 17 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 18 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 19 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 20 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 21 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 22 | 22 | |
| 23 | 23 | if($_SESSION['siteusername'] != $video['author']) |
| 24 | 24 | header("Location: /"); |
@@ -56,8 +56,8 @@ discard block |
||
| 56 | 56 | </div> |
| 57 | 57 | <div class="guide"> |
| 58 | 58 | <?php |
| 59 | - if(isset($_SESSION['siteusername'])) { |
|
| 60 | - ?> |
|
| 59 | + if(isset($_SESSION['siteusername'])) { |
|
| 60 | + ?> |
|
| 61 | 61 | <div style="/*! margin-top: 0px; *//*! margin-left: 10px; *//*! margin-bottom: 13px; */height: 99px;" class="guide-section feed-header channel first"><img alt="" src="/dynamic/pfp/<?php echo $__user_h->fetch_pfp($_SESSION['siteusername']); ?>" style="height: 88px;position: relative;top: 4px;left: 4px;" class="feed-header-thumb channel-thumb" width="88px"><div id="links" style="/*! margin-left: 5px; */position: relative;left: 13px;top: 7px;"><div style="font-size: 11px;margin-bottom: 6px;" class="metadata"> |
| 62 | 62 | <a href="/user/<?php echo htmlspecialchars($_SESSION['siteusername']); ?>" style="color: inherit;">My channel |
| 63 | 63 | <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" class="see-more-arrow" alt=""></a> |
@@ -203,16 +203,16 @@ discard block |
||
| 203 | 203 | </p> |
| 204 | 204 | <ul> |
| 205 | 205 | <?php |
| 206 | - $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4"); |
|
| 207 | - $stmt->execute(); |
|
| 208 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 209 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 210 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 211 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 212 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 213 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 214 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 215 | - ?> |
|
| 206 | + $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4"); |
|
| 207 | + $stmt->execute(); |
|
| 208 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 209 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 210 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 211 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 212 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 213 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 214 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 215 | + ?> |
|
| 216 | 216 | <li class="video-list-item "><a href="/watch?v=<?php echo $video['rid']; ?>" class="video-list-item-link yt-uix-sessionlink" data-sessionlink="ei=CNLr3rbS3rICFSwSIQodSW397Q%3D%3D&feature=g-sptl%26cid%3Dinp-hs-ytg"><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> |
| 217 | 217 | <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="yuTBQ86r8o0" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
| 218 | 218 | </span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button> |
@@ -226,16 +226,16 @@ discard block |
||
| 226 | 226 | </h3> |
| 227 | 227 | <ul> |
| 228 | 228 | <?php |
| 229 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE featured = 'v' ORDER BY id DESC LIMIT 4"); |
|
| 230 | - $stmt->execute(); |
|
| 231 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 232 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 233 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 234 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 235 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 236 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 237 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 238 | - ?> |
|
| 229 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE featured = 'v' ORDER BY id DESC LIMIT 4"); |
|
| 230 | + $stmt->execute(); |
|
| 231 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 232 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 233 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 234 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 235 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 236 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 237 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 238 | + ?> |
|
| 239 | 239 | <li class="video-list-item "><a href="/watch?v=<?php echo $video['rid']; ?>" class="video-list-item-link yt-uix-sessionlink" data-sessionlink="ei=CNLr3rbS3rICFSwSIQodSW397Q%3D%3D&feature=g-sptl%26cid%3Dinp-hs-ytg"><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> |
| 240 | 240 | <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="yuTBQ86r8o0" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
| 241 | 241 | </span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button> |
@@ -259,16 +259,16 @@ discard block |
||
| 259 | 259 | <div class="feed-page"> |
| 260 | 260 | <ul> |
| 261 | 261 | <?php |
| 262 | - $stmt = $__db->prepare("SELECT * FROM videos ORDER BY id DESC LIMIT 20"); |
|
| 263 | - $stmt->execute(); |
|
| 264 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 265 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 266 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 267 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 268 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 269 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 270 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 271 | - ?> |
|
| 262 | + $stmt = $__db->prepare("SELECT * FROM videos ORDER BY id DESC LIMIT 20"); |
|
| 263 | + $stmt->execute(); |
|
| 264 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 265 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 266 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 267 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 268 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 269 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 270 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 271 | + ?> |
|
| 272 | 272 | <li> |
| 273 | 273 | <div class="feed-item-container first " data-channel-key="UCR2A9ZNliJfgC66IvIpe-Zw"> |
| 274 | 274 | <div class="feed-author-bubble-container"> |
@@ -11,17 +11,17 @@ |
||
| 11 | 11 | <?php |
| 12 | 12 | $_video = $__video_h->fetch_video_rid($_GET['v']); |
| 13 | 13 | $_video['video_responses'] = $__video_h->get_video_responses($_video['rid']); |
| 14 | - $_video['age'] = $__time_h->time_elapsed_string($_video['publish']); |
|
| 15 | - $_video['duration'] = $__time_h->timestamp($_video['duration']); |
|
| 16 | - $_video['views'] = $__video_h->fetch_video_views($_video['rid']); |
|
| 17 | - $_video['author'] = htmlspecialchars($_video['author']); |
|
| 18 | - $_video['title'] = htmlspecialchars($_video['title']); |
|
| 19 | - $_video['description'] = $__video_h->shorten_description($_video['description'], 50); |
|
| 14 | + $_video['age'] = $__time_h->time_elapsed_string($_video['publish']); |
|
| 15 | + $_video['duration'] = $__time_h->timestamp($_video['duration']); |
|
| 16 | + $_video['views'] = $__video_h->fetch_video_views($_video['rid']); |
|
| 17 | + $_video['author'] = htmlspecialchars($_video['author']); |
|
| 18 | + $_video['title'] = htmlspecialchars($_video['title']); |
|
| 19 | + $_video['description'] = $__video_h->shorten_description($_video['description'], 50); |
|
| 20 | 20 | |
| 21 | - $__server->page_embeds->page_title = "SubRocks - All Comments"; |
|
| 22 | - $__server->page_embeds->page_description = "SubRocks is a site dedicated to bring back the 2012 layout of YouTube."; |
|
| 23 | - $__server->page_embeds->page_image = "/yt/imgbin/full-size-logo.png"; |
|
| 24 | - $__server->page_embeds->page_url = "https://subrock.rocks/"; |
|
| 21 | + $__server->page_embeds->page_title = "SubRocks - All Comments"; |
|
| 22 | + $__server->page_embeds->page_description = "SubRocks is a site dedicated to bring back the 2012 layout of YouTube."; |
|
| 23 | + $__server->page_embeds->page_image = "/yt/imgbin/full-size-logo.png"; |
|
| 24 | + $__server->page_embeds->page_url = "https://subrock.rocks/"; |
|
| 25 | 25 | ?> |
| 26 | 26 | <?php $_video['comments'] = $__video_h->get_comments_from_video($_video['rid']); ?> |
| 27 | 27 | <!DOCTYPE html> |
@@ -24,33 +24,33 @@ discard block |
||
| 24 | 24 | 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; } |
| 25 | 25 | |
| 26 | 26 | if(!isset($error['message'])) { |
| 27 | - $text = $_POST['comment']; |
|
| 27 | + $text = $_POST['comment']; |
|
| 28 | 28 | $stmt = $__db->prepare("INSERT INTO comments (toid, author, comment) VALUES (:v, :username, :comment)"); |
| 29 | 29 | $stmt->bindParam(":v", $_GET['v']); |
| 30 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 31 | - $stmt->bindParam(":comment", $text); |
|
| 30 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 31 | + $stmt->bindParam(":comment", $text); |
|
| 32 | 32 | $stmt->execute(); |
| 33 | 33 | |
| 34 | - $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment"); |
|
| 35 | - $__user_i->send_message($_SESSION['siteusername'], "New comment", $_video['author'], "I commented \"" . $_POST['comment'] . "\" on your video!", $_video['rid'], "nt"); |
|
| 34 | + $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment"); |
|
| 35 | + $__user_i->send_message($_SESSION['siteusername'], "New comment", $_video['author'], "I commented \"" . $_POST['comment'] . "\" on your video!", $_video['rid'], "nt"); |
|
| 36 | 36 | } |
| 37 | 37 | } |
| 38 | 38 | |
| 39 | - /* |
|
| 39 | + /* |
|
| 40 | 40 | PREPARE EMBEDS CLASS -- function(string $page_title, string $page_description...) |
| 41 | 41 | Returns a list of arrays for compatibility purposes & but downside is ugly for loop codes |
| 42 | 42 | Work on this tomorrow or some shit idk lol |
| 43 | 43 | */ |
| 44 | 44 | |
| 45 | - /* |
|
| 45 | + /* |
|
| 46 | 46 | USE THE GOD DAMN __CONFIG MORE -- idiot |
| 47 | 47 | Work on this tomorrow or some shit |
| 48 | 48 | */ |
| 49 | 49 | |
| 50 | - $__server->page_embeds->page_title = htmlspecialchars($_video['title']); |
|
| 51 | - $__server->page_embeds->page_description = htmlspecialchars($_video['description']); |
|
| 52 | - $__server->page_embeds->page_image = "/dynamic/thumbs/" . $_video['thumbnail']; |
|
| 53 | - $__server->page_embeds->page_url = "https://subrock.rocks/watch?v=" . htmlspecialchars($_video['rid']); |
|
| 50 | + $__server->page_embeds->page_title = htmlspecialchars($_video['title']); |
|
| 51 | + $__server->page_embeds->page_description = htmlspecialchars($_video['description']); |
|
| 52 | + $__server->page_embeds->page_image = "/dynamic/thumbs/" . $_video['thumbnail']; |
|
| 53 | + $__server->page_embeds->page_url = "https://subrock.rocks/watch?v=" . htmlspecialchars($_video['rid']); |
|
| 54 | 54 | ?> |
| 55 | 55 | <!DOCTYPE html> |
| 56 | 56 | <html> |
@@ -80,29 +80,29 @@ discard block |
||
| 80 | 80 | if (window.yt.timing) {yt.timing.tick("ct");} |
| 81 | 81 | </script> |
| 82 | 82 | <?php |
| 83 | - $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1); |
|
| 84 | - $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2); |
|
| 83 | + $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1); |
|
| 84 | + $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2); |
|
| 85 | 85 | |
| 86 | - $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4); |
|
| 87 | - $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5); |
|
| 86 | + $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4); |
|
| 87 | + $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5); |
|
| 88 | 88 | |
| 89 | - $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false); |
|
| 90 | - $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true); |
|
| 89 | + $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false); |
|
| 90 | + $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true); |
|
| 91 | 91 | |
| 92 | - if($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 93 | - $_video['likeswidth'] = 50; |
|
| 94 | - $_video['dislikeswidth'] = 50; |
|
| 95 | - } else { |
|
| 96 | - $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 97 | - $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
|
| 98 | - } |
|
| 92 | + if($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 93 | + $_video['likeswidth'] = 50; |
|
| 94 | + $_video['dislikeswidth'] = 50; |
|
| 95 | + } else { |
|
| 96 | + $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 97 | + $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
|
| 98 | + } |
|
| 99 | 99 | |
| 100 | - $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true); |
|
| 101 | - $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false); |
|
| 102 | - $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']); |
|
| 103 | - $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']); |
|
| 104 | - $_video['favorited'] = $__video_h->if_favorited(@$_SESSION['siteusername'], $_video['rid']); |
|
| 105 | - ?> |
|
| 100 | + $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true); |
|
| 101 | + $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false); |
|
| 102 | + $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']); |
|
| 103 | + $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']); |
|
| 104 | + $_video['favorited'] = $__video_h->if_favorited(@$_SESSION['siteusername'], $_video['rid']); |
|
| 105 | + ?> |
|
| 106 | 106 | </head> |
| 107 | 107 | <body id="" class="date-20120927 en_US ltr ytg-old-clearfix guide-feed-v2 gecko gecko-15" dir="ltr"> |
| 108 | 108 | <form name="logoutForm" method="POST" action="/logout"> |
@@ -324,21 +324,21 @@ discard block |
||
| 324 | 324 | <hr><br> |
| 325 | 325 | <h3>Add to a Playlist</h3> |
| 326 | 326 | <?php |
| 327 | - $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :username ORDER BY id DESC LIMIT 20"); |
|
| 328 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 329 | - $stmt->execute(); |
|
| 330 | - while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 331 | - $buffer = json_decode($playlist['videos']); |
|
| 332 | - @$rid = $buffer[0]; |
|
| 333 | - if(!empty($rid)) { |
|
| 334 | - @$video = $__video_h->fetch_video_rid($rid); |
|
| 335 | - } else { |
|
| 336 | - $video['thumbnail'] = ""; |
|
| 337 | - $video['duration'] = 0; |
|
| 338 | - } |
|
| 327 | + $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :username ORDER BY id DESC LIMIT 20"); |
|
| 328 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 329 | + $stmt->execute(); |
|
| 330 | + while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 331 | + $buffer = json_decode($playlist['videos']); |
|
| 332 | + @$rid = $buffer[0]; |
|
| 333 | + if(!empty($rid)) { |
|
| 334 | + @$video = $__video_h->fetch_video_rid($rid); |
|
| 335 | + } else { |
|
| 336 | + $video['thumbnail'] = ""; |
|
| 337 | + $video['duration'] = 0; |
|
| 338 | + } |
|
| 339 | 339 | |
| 340 | - $videos = count($buffer); |
|
| 341 | - ?> |
|
| 340 | + $videos = count($buffer); |
|
| 341 | + ?> |
|
| 342 | 342 | <a href="/get/add_to_playlist?id=<?php echo $_video['rid']; ?>&playlist=<?php echo $playlist['rid']; ?>">Add to <?php echo htmlspecialchars($playlist['title']); ?></a> |
| 343 | 343 | <?php } ?> |
| 344 | 344 | <?php } ?> |
@@ -603,10 +603,10 @@ discard block |
||
| 603 | 603 | </div> |
| 604 | 604 | </div> |
| 605 | 605 | <?php |
| 606 | - $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4"); |
|
| 607 | - $stmt->bindParam(":v", $_GET['v']); |
|
| 608 | - $stmt->execute(); |
|
| 609 | - ?> |
|
| 606 | + $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4"); |
|
| 607 | + $stmt->bindParam(":v", $_GET['v']); |
|
| 608 | + $stmt->execute(); |
|
| 609 | + ?> |
|
| 610 | 610 | |
| 611 | 611 | <?php if($stmt->rowCount() != 0) { ?> |
| 612 | 612 | <div class="comments-section"> |
@@ -616,16 +616,16 @@ discard block |
||
| 616 | 616 | <h4>Video Responses</h4> |
| 617 | 617 | <ul class="video-list"> |
| 618 | 618 | <?php |
| 619 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 620 | - if($__video_h->video_exists($video['video'])) { |
|
| 621 | - $video = $__video_h->fetch_video_rid($video['video']); |
|
| 622 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 623 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 624 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 625 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 626 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 627 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 628 | - ?> |
|
| 619 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 620 | + if($__video_h->video_exists($video['video'])) { |
|
| 621 | + $video = $__video_h->fetch_video_rid($video['video']); |
|
| 622 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 623 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 624 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 625 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 626 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 627 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 628 | + ?> |
|
| 629 | 629 | <li class="video-list-item yt-tile-default"> |
| 630 | 630 | <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> |
| 631 | 631 | <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"> |
@@ -707,31 +707,31 @@ discard block |
||
| 707 | 707 | </div> |
| 708 | 708 | <ul class="comment-list" id="live_comments"> |
| 709 | 709 | <?php |
| 710 | - $results_per_page = 20; |
|
| 710 | + $results_per_page = 20; |
|
| 711 | 711 | |
| 712 | - $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC"); |
|
| 713 | - $stmt->bindParam(":rid", $_video['rid']); |
|
| 714 | - $stmt->execute(); |
|
| 712 | + $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC"); |
|
| 713 | + $stmt->bindParam(":rid", $_video['rid']); |
|
| 714 | + $stmt->execute(); |
|
| 715 | 715 | |
| 716 | - $number_of_result = $stmt->rowCount(); |
|
| 717 | - $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 716 | + $number_of_result = $stmt->rowCount(); |
|
| 717 | + $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 718 | 718 | |
| 719 | - if (!isset ($_GET['page']) ) { |
|
| 720 | - $page = 1; |
|
| 721 | - } else { |
|
| 722 | - $page = (int)$_GET['page']; |
|
| 723 | - } |
|
| 719 | + if (!isset ($_GET['page']) ) { |
|
| 720 | + $page = 1; |
|
| 721 | + } else { |
|
| 722 | + $page = (int)$_GET['page']; |
|
| 723 | + } |
|
| 724 | 724 | |
| 725 | - $page_first_result = ($page - 1) * $results_per_page; |
|
| 725 | + $page_first_result = ($page - 1) * $results_per_page; |
|
| 726 | 726 | |
| 727 | - $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 728 | - $stmt->bindParam(":rid", $_video['rid']); |
|
| 729 | - $stmt->bindParam(":pfirst", $page_first_result); |
|
| 730 | - $stmt->bindParam(":pper", $results_per_page); |
|
| 731 | - $stmt->execute(); |
|
| 727 | + $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 728 | + $stmt->bindParam(":rid", $_video['rid']); |
|
| 729 | + $stmt->bindParam(":pfirst", $page_first_result); |
|
| 730 | + $stmt->bindParam(":pper", $results_per_page); |
|
| 731 | + $stmt->execute(); |
|
| 732 | 732 | |
| 733 | - while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 734 | - ?> |
|
| 733 | + while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 734 | + ?> |
|
| 735 | 735 | |
| 736 | 736 | <li class="comment yt-tile-default " data-author-viewing="" data-author-id="-uD01K8FQTeOSS5sniRFzQ" data-id="HdQrMeklJ_5hd_uPDRcvtdaMk2pMVS8d9sufcfiGx0U" data-score="0"> |
| 737 | 737 | <div class="comment-body"> |
@@ -810,16 +810,16 @@ discard block |
||
| 810 | 810 | <ul id="watch-related" class="video-list"> |
| 811 | 811 | <div id="ppv-container" class="hid"></div> |
| 812 | 812 | <?php |
| 813 | - $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20"); |
|
| 814 | - $stmt->execute(); |
|
| 815 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 816 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 817 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 818 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 819 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 820 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 821 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 822 | - ?> |
|
| 813 | + $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20"); |
|
| 814 | + $stmt->execute(); |
|
| 815 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 816 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 817 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 818 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 819 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 820 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 821 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 822 | + ?> |
|
| 823 | 823 | <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.onerror=null;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> |
| 824 | 824 | <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"> |
| 825 | 825 | </span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button> |