the-real-sumsome /
subrocks-2012
@@ -15,9 +15,9 @@ 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 | - $__video_h->check_view($_GET['v'], @$_SESSION['siteusername']); |
|
| 18 | + $__video_h->check_view($_GET['v'], @$_SESSION['siteusername']); |
|
| 19 | 19 | |
| 20 | - $_SESSION['current_video'] = $_video['rid']; |
|
| 20 | + $_SESSION['current_video'] = $_video['rid']; |
|
| 21 | 21 | if($_SERVER['REQUEST_METHOD'] == 'POST') { |
| 22 | 22 | $error = array(); |
| 23 | 23 | |
@@ -27,33 +27,33 @@ discard block |
||
| 27 | 27 | 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; } |
| 28 | 28 | |
| 29 | 29 | if(!isset($error['message'])) { |
| 30 | - $text = $_POST['comment']; |
|
| 30 | + $text = $_POST['comment']; |
|
| 31 | 31 | $stmt = $__db->prepare("INSERT INTO comments (toid, author, comment) VALUES (:v, :username, :comment)"); |
| 32 | 32 | $stmt->bindParam(":v", $_GET['v']); |
| 33 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 34 | - $stmt->bindParam(":comment", $text); |
|
| 33 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 34 | + $stmt->bindParam(":comment", $text); |
|
| 35 | 35 | $stmt->execute(); |
| 36 | 36 | |
| 37 | - $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment"); |
|
| 38 | - $__user_i->send_message($_SESSION['siteusername'], "New comment", $_video['author'], "I commented \"" . $_POST['comment'] . "\" on your video!", $_video['rid'], "nt"); |
|
| 37 | + $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment"); |
|
| 38 | + $__user_i->send_message($_SESSION['siteusername'], "New comment", $_video['author'], "I commented \"" . $_POST['comment'] . "\" on your video!", $_video['rid'], "nt"); |
|
| 39 | 39 | } |
| 40 | 40 | } |
| 41 | 41 | |
| 42 | - /* |
|
| 42 | + /* |
|
| 43 | 43 | PREPARE EMBEDS CLASS -- function(string $page_title, string $page_description...) |
| 44 | 44 | Returns a list of arrays for compatibility purposes & but downside is ugly for loop codes |
| 45 | 45 | Work on this tomorrow or some shit idk lol |
| 46 | 46 | */ |
| 47 | 47 | |
| 48 | - /* |
|
| 48 | + /* |
|
| 49 | 49 | USE THE GOD DAMN __CONFIG MORE -- idiot |
| 50 | 50 | Work on this tomorrow or some shit |
| 51 | 51 | */ |
| 52 | 52 | |
| 53 | - $__server->page_embeds->page_title = htmlspecialchars($_video['title']); |
|
| 54 | - $__server->page_embeds->page_description = htmlspecialchars($_video['description']); |
|
| 55 | - $__server->page_embeds->page_image = "/dynamic/thumbs/" . $_video['thumbnail']; |
|
| 56 | - $__server->page_embeds->page_url = "https://subrock.rocks/watch?v=" . htmlspecialchars($_video['rid']); |
|
| 53 | + $__server->page_embeds->page_title = htmlspecialchars($_video['title']); |
|
| 54 | + $__server->page_embeds->page_description = htmlspecialchars($_video['description']); |
|
| 55 | + $__server->page_embeds->page_image = "/dynamic/thumbs/" . $_video['thumbnail']; |
|
| 56 | + $__server->page_embeds->page_url = "https://subrock.rocks/watch?v=" . htmlspecialchars($_video['rid']); |
|
| 57 | 57 | ?> |
| 58 | 58 | <!DOCTYPE html> |
| 59 | 59 | <html> |
@@ -83,29 +83,29 @@ discard block |
||
| 83 | 83 | if (window.yt.timing) {yt.timing.tick("ct");} |
| 84 | 84 | </script> |
| 85 | 85 | <?php |
| 86 | - $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1); |
|
| 87 | - $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2); |
|
| 86 | + $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1); |
|
| 87 | + $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2); |
|
| 88 | 88 | |
| 89 | - $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4); |
|
| 90 | - $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5); |
|
| 89 | + $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4); |
|
| 90 | + $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5); |
|
| 91 | 91 | |
| 92 | - $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false); |
|
| 93 | - $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true); |
|
| 92 | + $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false); |
|
| 93 | + $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true); |
|
| 94 | 94 | |
| 95 | - if($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 96 | - $_video['likeswidth'] = 0; |
|
| 97 | - $_video['dislikeswidth'] = 0; |
|
| 98 | - } else { |
|
| 99 | - $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 100 | - $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
|
| 101 | - } |
|
| 95 | + if($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 96 | + $_video['likeswidth'] = 0; |
|
| 97 | + $_video['dislikeswidth'] = 0; |
|
| 98 | + } else { |
|
| 99 | + $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 100 | + $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
|
| 101 | + } |
|
| 102 | 102 | |
| 103 | - $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true); |
|
| 104 | - $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false); |
|
| 105 | - $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']); |
|
| 106 | - $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']); |
|
| 107 | - $_video['favorited'] = $__video_h->if_favorited(@$_SESSION['siteusername'], $_video['rid']); |
|
| 108 | - ?> |
|
| 103 | + $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true); |
|
| 104 | + $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false); |
|
| 105 | + $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']); |
|
| 106 | + $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']); |
|
| 107 | + $_video['favorited'] = $__video_h->if_favorited(@$_SESSION['siteusername'], $_video['rid']); |
|
| 108 | + ?> |
|
| 109 | 109 | </head> |
| 110 | 110 | <body id="" class="date-20120927 en_US ltr ytg-old-clearfix guide-feed-v2 gecko gecko-15" dir="ltr"> |
| 111 | 111 | <form name="logoutForm" method="POST" action="/logout"> |
@@ -327,21 +327,21 @@ discard block |
||
| 327 | 327 | <hr><br> |
| 328 | 328 | <h3>Add to a Playlist</h3> |
| 329 | 329 | <?php |
| 330 | - $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :username ORDER BY id DESC LIMIT 20"); |
|
| 331 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 332 | - $stmt->execute(); |
|
| 333 | - while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 334 | - $buffer = json_decode($playlist['videos']); |
|
| 335 | - @$rid = $buffer[0]; |
|
| 336 | - if(!empty($rid)) { |
|
| 337 | - @$video = $__video_h->fetch_video_rid($rid); |
|
| 338 | - } else { |
|
| 339 | - $video['thumbnail'] = ""; |
|
| 340 | - $video['duration'] = 0; |
|
| 341 | - } |
|
| 330 | + $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :username ORDER BY id DESC LIMIT 20"); |
|
| 331 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 332 | + $stmt->execute(); |
|
| 333 | + while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 334 | + $buffer = json_decode($playlist['videos']); |
|
| 335 | + @$rid = $buffer[0]; |
|
| 336 | + if(!empty($rid)) { |
|
| 337 | + @$video = $__video_h->fetch_video_rid($rid); |
|
| 338 | + } else { |
|
| 339 | + $video['thumbnail'] = ""; |
|
| 340 | + $video['duration'] = 0; |
|
| 341 | + } |
|
| 342 | 342 | |
| 343 | - $videos = count($buffer); |
|
| 344 | - ?> |
|
| 343 | + $videos = count($buffer); |
|
| 344 | + ?> |
|
| 345 | 345 | <a href="/get/add_to_playlist?id=<?php echo $_video['rid']; ?>&playlist=<?php echo $playlist['rid']; ?>">Add to <?php echo htmlspecialchars($playlist['title']); ?></a> |
| 346 | 346 | <?php } ?> |
| 347 | 347 | <?php } ?> |
@@ -606,10 +606,10 @@ discard block |
||
| 606 | 606 | </div> |
| 607 | 607 | </div> |
| 608 | 608 | <?php |
| 609 | - $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4"); |
|
| 610 | - $stmt->bindParam(":v", $_GET['v']); |
|
| 611 | - $stmt->execute(); |
|
| 612 | - ?> |
|
| 609 | + $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4"); |
|
| 610 | + $stmt->bindParam(":v", $_GET['v']); |
|
| 611 | + $stmt->execute(); |
|
| 612 | + ?> |
|
| 613 | 613 | |
| 614 | 614 | <?php if($stmt->rowCount() != 0) { ?> |
| 615 | 615 | <div class="comments-section"> |
@@ -619,16 +619,16 @@ discard block |
||
| 619 | 619 | <h4>Video Responses</h4> |
| 620 | 620 | <ul class="video-list"> |
| 621 | 621 | <?php |
| 622 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 623 | - if($__video_h->video_exists($video['video'])) { |
|
| 624 | - $video = $__video_h->fetch_video_rid($video['video']); |
|
| 625 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 626 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 627 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 628 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 629 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 630 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 631 | - ?> |
|
| 622 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 623 | + if($__video_h->video_exists($video['video'])) { |
|
| 624 | + $video = $__video_h->fetch_video_rid($video['video']); |
|
| 625 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 626 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 627 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 628 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 629 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 630 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 631 | + ?> |
|
| 632 | 632 | <li class="video-list-item yt-tile-default"> |
| 633 | 633 | <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> |
| 634 | 634 | <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"> |
@@ -710,38 +710,38 @@ discard block |
||
| 710 | 710 | </div> |
| 711 | 711 | <ul class="comment-list" id="live_comments"> |
| 712 | 712 | <?php |
| 713 | - $results_per_page = 20; |
|
| 713 | + $results_per_page = 20; |
|
| 714 | 714 | |
| 715 | - $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC"); |
|
| 716 | - $stmt->bindParam(":rid", $_video['rid']); |
|
| 717 | - $stmt->execute(); |
|
| 715 | + $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC"); |
|
| 716 | + $stmt->bindParam(":rid", $_video['rid']); |
|
| 717 | + $stmt->execute(); |
|
| 718 | 718 | |
| 719 | - $number_of_result = $stmt->rowCount(); |
|
| 720 | - $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 719 | + $number_of_result = $stmt->rowCount(); |
|
| 720 | + $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 721 | 721 | |
| 722 | - if (!isset ($_GET['page']) ) { |
|
| 723 | - $page = 1; |
|
| 724 | - } else { |
|
| 725 | - $page = (int)$_GET['page']; |
|
| 726 | - } |
|
| 722 | + if (!isset ($_GET['page']) ) { |
|
| 723 | + $page = 1; |
|
| 724 | + } else { |
|
| 725 | + $page = (int)$_GET['page']; |
|
| 726 | + } |
|
| 727 | 727 | |
| 728 | - $page_first_result = ($page - 1) * $results_per_page; |
|
| 728 | + $page_first_result = ($page - 1) * $results_per_page; |
|
| 729 | 729 | |
| 730 | - $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 731 | - $stmt->bindParam(":rid", $_video['rid']); |
|
| 732 | - $stmt->bindParam(":pfirst", $page_first_result); |
|
| 733 | - $stmt->bindParam(":pper", $results_per_page); |
|
| 734 | - $stmt->execute(); |
|
| 730 | + $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 731 | + $stmt->bindParam(":rid", $_video['rid']); |
|
| 732 | + $stmt->bindParam(":pfirst", $page_first_result); |
|
| 733 | + $stmt->bindParam(":pper", $results_per_page); |
|
| 734 | + $stmt->execute(); |
|
| 735 | 735 | |
| 736 | - while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 737 | - if($__video_h->if_comment_liked($comment['id'], $_SESSION['siteusername'], true)) |
|
| 738 | - $comment['liked'] = true; |
|
| 739 | - else if($__video_h->if_comment_liked($comment['id'], $_SESSION['siteusername'], false)) |
|
| 740 | - $comment['disliked'] = true; |
|
| 736 | + while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 737 | + if($__video_h->if_comment_liked($comment['id'], $_SESSION['siteusername'], true)) |
|
| 738 | + $comment['liked'] = true; |
|
| 739 | + else if($__video_h->if_comment_liked($comment['id'], $_SESSION['siteusername'], false)) |
|
| 740 | + $comment['disliked'] = true; |
|
| 741 | 741 | |
| 742 | - $comment['likes'] = $__video_h->get_comment_likes($comment['id'], true); |
|
| 743 | - $comment['likes'] -= $__video_h->get_comment_likes($comment['id'], false); |
|
| 744 | - ?> |
|
| 742 | + $comment['likes'] = $__video_h->get_comment_likes($comment['id'], true); |
|
| 743 | + $comment['likes'] -= $__video_h->get_comment_likes($comment['id'], false); |
|
| 744 | + ?> |
|
| 745 | 745 | |
| 746 | 746 | <li class="comment yt-tile-default " data-author-viewing="" data-author-id="-uD01K8FQTeOSS5sniRFzQ" data-id="<?php echo $comment['id']; ?>" data-score="0"> |
| 747 | 747 | <div class="comment-body"> |
@@ -826,16 +826,16 @@ discard block |
||
| 826 | 826 | <ul id="watch-related" class="video-list"> |
| 827 | 827 | <div id="ppv-container" class="hid"></div> |
| 828 | 828 | <?php |
| 829 | - $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20"); |
|
| 830 | - $stmt->execute(); |
|
| 831 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 832 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 833 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 834 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 835 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 836 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 837 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 838 | - ?> |
|
| 829 | + $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20"); |
|
| 830 | + $stmt->execute(); |
|
| 831 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 832 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 833 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 834 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 835 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 836 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 837 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 838 | + ?> |
|
| 839 | 839 | <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> |
| 840 | 840 | <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"> |
| 841 | 841 | </span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button> |
@@ -8,36 +8,36 @@ |
||
| 8 | 8 | <?php $__db_h = new db_helper(); ?> |
| 9 | 9 | <?php $__time_h = new time_helper(); ob_start(); ?> |
| 10 | 10 | <?php |
| 11 | - $request = (object) [ |
|
| 12 | - "search_term" => $_SESSION['siteusername'], |
|
| 13 | - "like_search_term" => "%" . $_SESSION['siteusername'] . "%", |
|
| 14 | - "search_amount" => 0 /* [fallback] */ |
|
| 15 | - ]; |
|
| 11 | + $request = (object) [ |
|
| 12 | + "search_term" => $_SESSION['siteusername'], |
|
| 13 | + "like_search_term" => "%" . $_SESSION['siteusername'] . "%", |
|
| 14 | + "search_amount" => 0 /* [fallback] */ |
|
| 15 | + ]; |
|
| 16 | 16 | |
| 17 | - $stmt = $__db->prepare("SELECT * FROM playlists WHERE lower(author) LIKE lower(:search) "); |
|
| 18 | - $stmt->bindParam(":search", $request->like_search_term); |
|
| 19 | - $stmt->execute(); |
|
| 20 | - $request->search_amount = $stmt->rowCount(); |
|
| 17 | + $stmt = $__db->prepare("SELECT * FROM playlists WHERE lower(author) LIKE lower(:search) "); |
|
| 18 | + $stmt->bindParam(":search", $request->like_search_term); |
|
| 19 | + $stmt->execute(); |
|
| 20 | + $request->search_amount = $stmt->rowCount(); |
|
| 21 | 21 | |
| 22 | - $results_per_page = 12; |
|
| 23 | - $number_of_result = $request->search_amount; |
|
| 24 | - $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 22 | + $results_per_page = 12; |
|
| 23 | + $number_of_result = $request->search_amount; |
|
| 24 | + $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 25 | 25 | |
| 26 | - if (!isset ($_GET['page']) ) { |
|
| 27 | - $page = 1; |
|
| 28 | - } else { |
|
| 29 | - $page = (int)$_GET['page']; |
|
| 30 | - } |
|
| 26 | + if (!isset ($_GET['page']) ) { |
|
| 27 | + $page = 1; |
|
| 28 | + } else { |
|
| 29 | + $page = (int)$_GET['page']; |
|
| 30 | + } |
|
| 31 | 31 | |
| 32 | - $page_first_result = ($page - 1) * $results_per_page; |
|
| 32 | + $page_first_result = ($page - 1) * $results_per_page; |
|
| 33 | 33 | |
| 34 | - $stmt6 = $__db->prepare("SELECT * FROM playlists WHERE lower(author) LIKE lower(:search) ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 35 | - $stmt6->bindParam(":search", $request->like_search_term); |
|
| 36 | - $stmt6->bindParam(":pfirst", $page_first_result); |
|
| 37 | - $stmt6->bindParam(":pper", $results_per_page); |
|
| 38 | - $stmt6->execute(); |
|
| 34 | + $stmt6 = $__db->prepare("SELECT * FROM playlists WHERE lower(author) LIKE lower(:search) ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 35 | + $stmt6->bindParam(":search", $request->like_search_term); |
|
| 36 | + $stmt6->bindParam(":pfirst", $page_first_result); |
|
| 37 | + $stmt6->bindParam(":pper", $results_per_page); |
|
| 38 | + $stmt6->execute(); |
|
| 39 | 39 | |
| 40 | - /* TODO :: Easy & Clean Pagination Class PLZ :((( ))) */ |
|
| 40 | + /* TODO :: Easy & Clean Pagination Class PLZ :((( ))) */ |
|
| 41 | 41 | ?> |
| 42 | 42 | <table style="width: 100%;"> |
| 43 | 43 | <tr> |
@@ -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 | } |
@@ -65,7 +65,7 @@ discard block |
||
| 65 | 65 | $_user['2009_bgcolor'] = substr($_user['2009_bgcolor'], 0, 7); |
| 66 | 66 | |
| 67 | 67 | $_user['genre'] = strtolower($_user['genre']); |
| 68 | - $_user['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_user['username']); |
|
| 68 | + $_user['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_user['username']); |
|
| 69 | 69 | |
| 70 | 70 | if(!check_valid_colorhex($_user['primary_color']) && strlen($_user['primary_color']) != 6) { $_user['primary_color'] = ""; } |
| 71 | 71 | if(!check_valid_colorhex($_user['secondary_color']) && strlen($_user['secondary_color']) != 6) { $_user['secondary_color'] = ""; } |
@@ -74,8 +74,8 @@ discard block |
||
| 74 | 74 | if(!check_valid_colorhex($_user['primary_color_text']) && strlen($_user['primary_color_text']) != 6) { $_user['primary_color_text'] = ""; } |
| 75 | 75 | if(!check_valid_colorhex($_user['2009_bgcolor']) && strlen($_user['2009_bgcolor']) != 6) { $_user['2009_bgcolor'] = ""; } |
| 76 | 76 | |
| 77 | - if(isset($_SESSION['siteusername'])) |
|
| 78 | - $__user_i->check_view_channel($_user['username'], @$_SESSION['siteusername']); |
|
| 77 | + if(isset($_SESSION['siteusername'])) |
|
| 78 | + $__user_i->check_view_channel($_user['username'], @$_SESSION['siteusername']); |
|
| 79 | 79 | |
| 80 | 80 | if($_SERVER['REQUEST_METHOD'] == 'POST') { |
| 81 | 81 | $error = array(); |
@@ -89,11 +89,11 @@ discard block |
||
| 89 | 89 | //if(ifBlocked(@$_SESSION['siteusername'], $user['username'], $__db)) { $error = "This user has blocked you!"; $error['status'] = true; } |
| 90 | 90 | |
| 91 | 91 | if(!isset($error['message'])) { |
| 92 | - $text = $_POST['comment']; |
|
| 92 | + $text = $_POST['comment']; |
|
| 93 | 93 | $stmt = $__db->prepare("INSERT INTO profile_comments (toid, author, comment) VALUES (:id, :username, :comment)"); |
| 94 | - $stmt->bindParam(":id", $_user['username']); |
|
| 95 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 96 | - $stmt->bindParam(":comment", $text); |
|
| 94 | + $stmt->bindParam(":id", $_user['username']); |
|
| 95 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 96 | + $stmt->bindParam(":comment", $text); |
|
| 97 | 97 | $stmt->execute(); |
| 98 | 98 | |
| 99 | 99 | $_user_update_utils->update_comment_cooldown_time($_SESSION['siteusername']); |
@@ -105,10 +105,10 @@ discard block |
||
| 105 | 105 | } |
| 106 | 106 | ?> |
| 107 | 107 | <?php |
| 108 | - $__server->page_embeds->page_title = "SubRocks - " . htmlspecialchars($_user['username']); |
|
| 109 | - $__server->page_embeds->page_description = htmlspecialchars($_user['bio']); |
|
| 110 | - $__server->page_embeds->page_image = "/dynamic/pfp/" . htmlspecialchars($_user['pfp']); |
|
| 111 | - $__server->page_embeds->page_url = "https://subrock.rocks/"; |
|
| 108 | + $__server->page_embeds->page_title = "SubRocks - " . htmlspecialchars($_user['username']); |
|
| 109 | + $__server->page_embeds->page_description = htmlspecialchars($_user['bio']); |
|
| 110 | + $__server->page_embeds->page_image = "/dynamic/pfp/" . htmlspecialchars($_user['pfp']); |
|
| 111 | + $__server->page_embeds->page_url = "https://subrock.rocks/"; |
|
| 112 | 112 | ?> |
| 113 | 113 | <!DOCTYPE html> |
| 114 | 114 | <html dir="ltr" xmlns:og="http://opengraphprotocol.org/schema/" lang="en"> |
@@ -140,27 +140,27 @@ discard block |
||
| 140 | 140 | background-image: url(/dynamic/banners/<?php echo $_user['2009_bg']; ?>); |
| 141 | 141 | background-repeat: repeat; |
| 142 | 142 | <?php |
| 143 | - switch($_user['2012_bgoption']) { |
|
| 144 | - case "stretch": |
|
| 145 | - echo "background-size: cover;"; |
|
| 146 | - break; |
|
| 147 | - case "solid": |
|
| 148 | - echo ""; |
|
| 149 | - break; |
|
| 150 | - case "norepeat": |
|
| 151 | - echo ""; |
|
| 152 | - break; |
|
| 153 | - case "repeatxy": |
|
| 154 | - echo "background-repeat: repeat;"; |
|
| 155 | - break; |
|
| 156 | - case "repeaty": |
|
| 157 | - echo "background-repeat: repeat-y;"; |
|
| 158 | - break; |
|
| 159 | - case "repeatx": |
|
| 160 | - echo "background-repeat: repeat-x;"; |
|
| 161 | - break; |
|
| 162 | - } |
|
| 163 | - ?> |
|
| 143 | + switch($_user['2012_bgoption']) { |
|
| 144 | + case "stretch": |
|
| 145 | + echo "background-size: cover;"; |
|
| 146 | + break; |
|
| 147 | + case "solid": |
|
| 148 | + echo ""; |
|
| 149 | + break; |
|
| 150 | + case "norepeat": |
|
| 151 | + echo ""; |
|
| 152 | + break; |
|
| 153 | + case "repeatxy": |
|
| 154 | + echo "background-repeat: repeat;"; |
|
| 155 | + break; |
|
| 156 | + case "repeaty": |
|
| 157 | + echo "background-repeat: repeat-y;"; |
|
| 158 | + break; |
|
| 159 | + case "repeatx": |
|
| 160 | + echo "background-repeat: repeat-x;"; |
|
| 161 | + break; |
|
| 162 | + } |
|
| 163 | + ?> |
|
| 164 | 164 | } |
| 165 | 165 | </style> |
| 166 | 166 | <script> |
@@ -188,9 +188,9 @@ discard block |
||
| 188 | 188 | <div class="channel_customization"><?php require($_SERVER['DOCUMENT_ROOT'] . "/s/mod/channel_customization.php"); ?></div> |
| 189 | 189 | <?php } ?> |
| 190 | 190 | <?php |
| 191 | - if(empty(trim($_user['bio']))) |
|
| 192 | - $_user['bio'] = "This user has no description."; |
|
| 193 | - ?> |
|
| 191 | + if(empty(trim($_user['bio']))) |
|
| 192 | + $_user['bio'] = "This user has no description."; |
|
| 193 | + ?> |
|
| 194 | 194 | <div id="content"> |
| 195 | 195 | <div class="subscription-menu-expandable subscription-menu-expandable-channels3 yt-rounded ytg-wide hid"> |
| 196 | 196 | <div class="content" id="recommended-channels-list"></div> |
@@ -536,9 +536,9 @@ discard block |
||
| 536 | 536 | <h2>Featured Channels</h2> |
| 537 | 537 | <ul class="channel-summary-list "> |
| 538 | 538 | <?php |
| 539 | - foreach($_user['featured_channels'] as $user) { |
|
| 540 | - if($__user_h->user_exists($user)) { |
|
| 541 | - ?> |
|
| 539 | + foreach($_user['featured_channels'] as $user) { |
|
| 540 | + if($__user_h->user_exists($user)) { |
|
| 541 | + ?> |
|
| 542 | 542 | <li class="yt-tile-visible yt-uix-tile"> |
| 543 | 543 | <div class="channel-summary clearfix channel-summary-compact"> |
| 544 | 544 | <div class="channel-summary-thumb"> |
@@ -562,19 +562,19 @@ discard block |
||
| 562 | 562 | </div> |
| 563 | 563 | |
| 564 | 564 | <?php |
| 565 | - $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :search ORDER BY id DESC LIMIT 10"); |
|
| 566 | - $stmt->bindParam(":search", $_user['username']); |
|
| 567 | - $stmt->execute(); |
|
| 565 | + $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :search ORDER BY id DESC LIMIT 10"); |
|
| 566 | + $stmt->bindParam(":search", $_user['username']); |
|
| 567 | + $stmt->execute(); |
|
| 568 | 568 | |
| 569 | - if($stmt->rowCount() != 0) { |
|
| 570 | - ?> |
|
| 569 | + if($stmt->rowCount() != 0) { |
|
| 570 | + ?> |
|
| 571 | 571 | <div class="playlists-narrow channel-module yt-uix-c3-module-container"> |
| 572 | 572 | <div class="module-view gh-featured"> |
| 573 | 573 | <h2>Featured Playlists</h2> |
| 574 | 574 | <?php |
| 575 | - while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 576 | - $playlist['videos'] = json_decode($playlist['videos']); |
|
| 577 | - ?> |
|
| 575 | + while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 576 | + $playlist['videos'] = json_decode($playlist['videos']); |
|
| 577 | + ?> |
|
| 578 | 578 | <div class="playlist yt-tile-visible yt-uix-tile"> |
| 579 | 579 | <a href="/view_playlist?v=<?php echo $playlist['rid']; ?>"> |
| 580 | 580 | <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"> |
