@@ -8,10 +8,10 @@ discard block |
||
8 | 8 | <?php $__db_h = new db_helper(); ?> |
9 | 9 | <?php $__time_h = new time_helper(); ?> |
10 | 10 | <?php |
11 | - $__server->page_embeds->page_title = "SubRocks - Homepage"; |
|
12 | - $__server->page_embeds->page_description = "SubRocks is a site dedicated to bring back the 2012 layout of YouTube."; |
|
13 | - $__server->page_embeds->page_image = "/yt/imgbin/full-size-logo.png"; |
|
14 | - $__server->page_embeds->page_url = "https://subrock.rocks/"; |
|
11 | + $__server->page_embeds->page_title = "SubRocks - Homepage"; |
|
12 | + $__server->page_embeds->page_description = "SubRocks is a site dedicated to bring back the 2012 layout of YouTube."; |
|
13 | + $__server->page_embeds->page_image = "/yt/imgbin/full-size-logo.png"; |
|
14 | + $__server->page_embeds->page_url = "https://subrock.rocks/"; |
|
15 | 15 | ?> |
16 | 16 | <!DOCTYPE html> |
17 | 17 | <html> |
@@ -61,8 +61,8 @@ discard block |
||
61 | 61 | </div> |
62 | 62 | <div class="guide"> |
63 | 63 | <?php |
64 | - if(isset($_SESSION['siteusername'])) { |
|
65 | - ?> |
|
64 | + if(isset($_SESSION['siteusername'])) { |
|
65 | + ?> |
|
66 | 66 | <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"> |
67 | 67 | <a href="/user/<?php echo htmlspecialchars($_SESSION['siteusername']); ?>" style="color: inherit;">My channel |
68 | 68 | <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" class="see-more-arrow" alt=""></a> |
@@ -225,16 +225,16 @@ discard block |
||
225 | 225 | </p> |
226 | 226 | <ul> |
227 | 227 | <?php |
228 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE visibility = 'n' ORDER BY rand() LIMIT 4"); |
|
229 | - $stmt->execute(); |
|
230 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
231 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
232 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
233 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
234 | - $video['author'] = htmlspecialchars($video['author']); |
|
235 | - $video['title'] = htmlspecialchars($video['title']); |
|
236 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
237 | - ?> |
|
228 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE visibility = 'n' ORDER BY rand() LIMIT 4"); |
|
229 | + $stmt->execute(); |
|
230 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
231 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
232 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
233 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
234 | + $video['author'] = htmlspecialchars($video['author']); |
|
235 | + $video['title'] = htmlspecialchars($video['title']); |
|
236 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
237 | + ?> |
|
238 | 238 | <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> |
239 | 239 | <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"> |
240 | 240 | </span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button> |
@@ -248,16 +248,16 @@ discard block |
||
248 | 248 | </h3> |
249 | 249 | <ul> |
250 | 250 | <?php |
251 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE featured = 'v' AND visibility = 'n' ORDER BY id DESC LIMIT 4"); |
|
252 | - $stmt->execute(); |
|
253 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
254 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
255 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
256 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
257 | - $video['author'] = htmlspecialchars($video['author']); |
|
258 | - $video['title'] = htmlspecialchars($video['title']); |
|
259 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
260 | - ?> |
|
251 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE featured = 'v' AND visibility = 'n' ORDER BY id DESC LIMIT 4"); |
|
252 | + $stmt->execute(); |
|
253 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
254 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
255 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
256 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
257 | + $video['author'] = htmlspecialchars($video['author']); |
|
258 | + $video['title'] = htmlspecialchars($video['title']); |
|
259 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
260 | + ?> |
|
261 | 261 | <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> |
262 | 262 | <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"> |
263 | 263 | </span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button> |
@@ -281,16 +281,16 @@ discard block |
||
281 | 281 | <div class="feed-page"> |
282 | 282 | <ul> |
283 | 283 | <?php |
284 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE visibility = 'n' ORDER BY id DESC LIMIT 20"); |
|
285 | - $stmt->execute(); |
|
286 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
287 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
288 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
289 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
290 | - $video['author'] = htmlspecialchars($video['author']); |
|
291 | - $video['title'] = htmlspecialchars($video['title']); |
|
292 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
293 | - ?> |
|
284 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE visibility = 'n' ORDER BY id DESC LIMIT 20"); |
|
285 | + $stmt->execute(); |
|
286 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
287 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
288 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
289 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
290 | + $video['author'] = htmlspecialchars($video['author']); |
|
291 | + $video['title'] = htmlspecialchars($video['title']); |
|
292 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
293 | + ?> |
|
294 | 294 | <li> |
295 | 295 | <div class="feed-item-container first " data-channel-key="UCR2A9ZNliJfgC66IvIpe-Zw"> |
296 | 296 | <div class="feed-author-bubble-container"> |
@@ -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> |