the-real-sumsome /
subrocks-2012
@@ -25,15 +25,15 @@ discard block |
||
| 25 | 25 | 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; } |
| 26 | 26 | |
| 27 | 27 | if(!isset($error['message'])) { |
| 28 | - $text = $_POST['comment']; |
|
| 28 | + $text = $_POST['comment']; |
|
| 29 | 29 | $stmt = $__db->prepare("INSERT INTO comments (toid, author, comment) VALUES (:v, :username, :comment)"); |
| 30 | 30 | $stmt->bindParam(":v", $_GET['v']); |
| 31 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 32 | - $stmt->bindParam(":comment", $text); |
|
| 31 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 32 | + $stmt->bindParam(":comment", $text); |
|
| 33 | 33 | $stmt->execute(); |
| 34 | 34 | |
| 35 | - $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment"); |
|
| 36 | - $__user_i->send_message($_SESSION['siteusername'], "New comment", $_video['author'], "I commented \"" . $_POST['comment'] . "\" on your video!", $_video['rid'], "nt"); |
|
| 35 | + $__user_u->update_cooldown_time($_SESSION['siteusername'], "cooldown_comment"); |
|
| 36 | + $__user_i->send_message($_SESSION['siteusername'], "New comment", $_video['author'], "I commented \"" . $_POST['comment'] . "\" on your video!", $_video['rid'], "nt"); |
|
| 37 | 37 | } |
| 38 | 38 | } |
| 39 | 39 | ?> |
@@ -65,28 +65,28 @@ discard block |
||
| 65 | 65 | if (window.yt.timing) {yt.timing.tick("ct");} |
| 66 | 66 | </script> |
| 67 | 67 | <?php |
| 68 | - $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1); |
|
| 69 | - $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2); |
|
| 68 | + $_video['dislikes'] = $__video_h->get_video_stars_level($_video['rid'], 1); |
|
| 69 | + $_video['dislikes'] += $__video_h->get_video_stars_level($_video['rid'], 2); |
|
| 70 | 70 | |
| 71 | - $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4); |
|
| 72 | - $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5); |
|
| 71 | + $_video['likes'] = $__video_h->get_video_stars_level($_video['rid'], 4); |
|
| 72 | + $_video['likes'] += $__video_h->get_video_stars_level($_video['rid'], 5); |
|
| 73 | 73 | |
| 74 | - $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false); |
|
| 75 | - $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true); |
|
| 74 | + $_video['dislikes'] += $__video_h->get_video_likes($_video['rid'], false); |
|
| 75 | + $_video['likes'] += $__video_h->get_video_likes($_video['rid'], true); |
|
| 76 | 76 | |
| 77 | - if($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 78 | - $_video['likeswidth'] = 50; |
|
| 79 | - $_video['dislikeswidth'] = 50; |
|
| 80 | - } else { |
|
| 81 | - $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 82 | - $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
|
| 83 | - } |
|
| 77 | + if($_video['likes'] == 0 && $_video['dislikes'] == 0) { |
|
| 78 | + $_video['likeswidth'] = 50; |
|
| 79 | + $_video['dislikeswidth'] = 50; |
|
| 80 | + } else { |
|
| 81 | + $_video['likeswidth'] = $_video['likes'] / ($_video['likes'] + $_video['dislikes']) * 100; |
|
| 82 | + $_video['dislikeswidth'] = 100 - $_video['likeswidth']; |
|
| 83 | + } |
|
| 84 | 84 | |
| 85 | - $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true); |
|
| 86 | - $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false); |
|
| 87 | - $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']); |
|
| 88 | - $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']); |
|
| 89 | - ?> |
|
| 85 | + $_video['liked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], true); |
|
| 86 | + $_video['disliked'] = $__video_h->if_liked(@$_SESSION['siteusername'], $_video['rid'], false); |
|
| 87 | + $_video['author_videos'] = $__video_h->fetch_user_videos($_video['author']); |
|
| 88 | + $_video['subscribed'] = $__user_h->if_subscribed(@$_SESSION['siteusername'], $_video['author']); |
|
| 89 | + ?> |
|
| 90 | 90 | </head> |
| 91 | 91 | <body id="" class="date-20120927 en_US ltr ytg-old-clearfix guide-feed-v2 gecko gecko-15" dir="ltr"> |
| 92 | 92 | <form name="logoutForm" method="POST" action="/logout"> |
@@ -358,10 +358,10 @@ discard block |
||
| 358 | 358 | </div> |
| 359 | 359 | </div> |
| 360 | 360 | <?php |
| 361 | - $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4"); |
|
| 362 | - $stmt->bindParam(":v", $_GET['v']); |
|
| 363 | - $stmt->execute(); |
|
| 364 | - ?> |
|
| 361 | + $stmt = $__db->prepare("SELECT * FROM video_response WHERE toid = :v ORDER BY id DESC LIMIT 4"); |
|
| 362 | + $stmt->bindParam(":v", $_GET['v']); |
|
| 363 | + $stmt->execute(); |
|
| 364 | + ?> |
|
| 365 | 365 | |
| 366 | 366 | <?php if($stmt->rowCount() != 0) { ?> |
| 367 | 367 | <div class="comments-section"> |
@@ -371,16 +371,16 @@ discard block |
||
| 371 | 371 | <h4>Video Responses</h4> |
| 372 | 372 | <ul class="video-list"> |
| 373 | 373 | <?php |
| 374 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 375 | - if($__video_h->video_exists($video['video'])) { |
|
| 376 | - $video = $__video_h->fetch_video_rid($video['video']); |
|
| 377 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 378 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 379 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 380 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 381 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 382 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 383 | - ?> |
|
| 374 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 375 | + if($__video_h->video_exists($video['video'])) { |
|
| 376 | + $video = $__video_h->fetch_video_rid($video['video']); |
|
| 377 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 378 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 379 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 380 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 381 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 382 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 383 | + ?> |
|
| 384 | 384 | <li class="video-list-item yt-tile-default"> |
| 385 | 385 | <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> |
| 386 | 386 | <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"> |
@@ -462,31 +462,31 @@ discard block |
||
| 462 | 462 | </div> |
| 463 | 463 | <ul class="comment-list" id="live_comments"> |
| 464 | 464 | <?php |
| 465 | - $results_per_page = 20; |
|
| 465 | + $results_per_page = 20; |
|
| 466 | 466 | |
| 467 | - $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC"); |
|
| 468 | - $stmt->bindParam(":rid", $_video['rid']); |
|
| 469 | - $stmt->execute(); |
|
| 467 | + $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC"); |
|
| 468 | + $stmt->bindParam(":rid", $_video['rid']); |
|
| 469 | + $stmt->execute(); |
|
| 470 | 470 | |
| 471 | - $number_of_result = $stmt->rowCount(); |
|
| 472 | - $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 471 | + $number_of_result = $stmt->rowCount(); |
|
| 472 | + $number_of_page = ceil ($number_of_result / $results_per_page); |
|
| 473 | 473 | |
| 474 | - if (!isset ($_GET['page']) ) { |
|
| 475 | - $page = 1; |
|
| 476 | - } else { |
|
| 477 | - $page = (int)$_GET['page']; |
|
| 478 | - } |
|
| 474 | + if (!isset ($_GET['page']) ) { |
|
| 475 | + $page = 1; |
|
| 476 | + } else { |
|
| 477 | + $page = (int)$_GET['page']; |
|
| 478 | + } |
|
| 479 | 479 | |
| 480 | - $page_first_result = ($page - 1) * $results_per_page; |
|
| 480 | + $page_first_result = ($page - 1) * $results_per_page; |
|
| 481 | 481 | |
| 482 | - $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 483 | - $stmt->bindParam(":rid", $_video['rid']); |
|
| 484 | - $stmt->bindParam(":pfirst", $page_first_result); |
|
| 485 | - $stmt->bindParam(":pper", $results_per_page); |
|
| 486 | - $stmt->execute(); |
|
| 482 | + $stmt = $__db->prepare("SELECT * FROM comments WHERE toid = :rid ORDER BY id DESC LIMIT :pfirst, :pper"); |
|
| 483 | + $stmt->bindParam(":rid", $_video['rid']); |
|
| 484 | + $stmt->bindParam(":pfirst", $page_first_result); |
|
| 485 | + $stmt->bindParam(":pper", $results_per_page); |
|
| 486 | + $stmt->execute(); |
|
| 487 | 487 | |
| 488 | - while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 489 | - ?> |
|
| 488 | + while($comment = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 489 | + ?> |
|
| 490 | 490 | |
| 491 | 491 | <li class="comment yt-tile-default " data-author-viewing="" data-author-id="-uD01K8FQTeOSS5sniRFzQ" data-id="HdQrMeklJ_5hd_uPDRcvtdaMk2pMVS8d9sufcfiGx0U" data-score="0"> |
| 492 | 492 | <div class="comment-body"> |
@@ -565,16 +565,16 @@ discard block |
||
| 565 | 565 | <ul id="watch-related" class="video-list"> |
| 566 | 566 | <div id="ppv-container" class="hid"></div> |
| 567 | 567 | <?php |
| 568 | - $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20"); |
|
| 569 | - $stmt->execute(); |
|
| 570 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 571 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 572 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 573 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 574 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 575 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 576 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 577 | - ?> |
|
| 568 | + $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 20"); |
|
| 569 | + $stmt->execute(); |
|
| 570 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 571 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 572 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 573 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 574 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 575 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 576 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 577 | + ?> |
|
| 578 | 578 | <li class="video-list-item"><a href="/watch?v=<?php echo $video['rid']; ?>" class="related-video yt-uix-contextlink yt-uix-sessionlink" data-sessionlink="ved=CAIQzRooAA%3D%3D&<?php echo htmlspecialchars($_video['author']); ?>&feature=relmfu"><span class="ux-thumb-wrap contains-addto "><span class="video-thumb ux-thumb yt-thumb-default-120 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo $video['title']; ?>" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="120"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 579 | 579 | <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"> |
| 580 | 580 | </span><img class="yt-uix-button-arrow" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt=""></button> |
@@ -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"> |
