the-real-sumsome /
subrocks-2012
@@ -15,8 +15,8 @@ discard block |
||
| 15 | 15 | <?php $__db_h = new db_helper(); ?> |
| 16 | 16 | <?php $__time_h = new time_helper(); ?> |
| 17 | 17 | <?php |
| 18 | - if(isset($_SESSION['siteusername'])) |
|
| 19 | - $_user_hp = $__user_h->fetch_user_username($_SESSION['siteusername']); |
|
| 18 | + if(isset($_SESSION['siteusername'])) |
|
| 19 | + $_user_hp = $__user_h->fetch_user_username($_SESSION['siteusername']); |
|
| 20 | 20 | |
| 21 | 21 | if(!$__user_h->user_exists($_GET['n'])) |
| 22 | 22 | header("Location: /?userdoesntexist"); |
@@ -29,21 +29,21 @@ discard block |
||
| 29 | 29 | return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars. |
| 30 | 30 | } |
| 31 | 31 | |
| 32 | - function addhttp($url) { |
|
| 33 | - if (!preg_match("~^(?:f|ht)tps?://~i", $url)) { |
|
| 34 | - $url = "http://" . $url; |
|
| 35 | - } |
|
| 36 | - return $url; |
|
| 37 | - } |
|
| 32 | + function addhttp($url) { |
|
| 33 | + if (!preg_match("~^(?:f|ht)tps?://~i", $url)) { |
|
| 34 | + $url = "http://" . $url; |
|
| 35 | + } |
|
| 36 | + return $url; |
|
| 37 | + } |
|
| 38 | 38 | |
| 39 | 39 | function check_valid_colorhex($colorCode) { |
| 40 | 40 | // If user accidentally passed along the # sign, strip it off |
| 41 | 41 | $colorCode = ltrim($colorCode, '#'); |
| 42 | 42 | |
| 43 | 43 | if ( |
| 44 | - ctype_xdigit($colorCode) && |
|
| 44 | + ctype_xdigit($colorCode) && |
|
| 45 | 45 | (strlen($colorCode) == 6 || strlen($colorCode) == 3)) |
| 46 | - return true; |
|
| 46 | + return true; |
|
| 47 | 47 | |
| 48 | 48 | else return false; |
| 49 | 49 | } |
@@ -77,8 +77,8 @@ discard block |
||
| 77 | 77 | if(!check_valid_colorhex($_user['primary_color_text']) && strlen($_user['primary_color_text']) != 6) { $_user['primary_color_text'] = ""; } |
| 78 | 78 | if(!check_valid_colorhex($_user['2009_bgcolor']) && strlen($_user['2009_bgcolor']) != 6) { $_user['2009_bgcolor'] = ""; } |
| 79 | 79 | |
| 80 | - if(isset($_SESSION['siteusername'])) |
|
| 81 | - $__user_i->check_view_channel($_user['username'], @$_SESSION['siteusername']); |
|
| 80 | + if(isset($_SESSION['siteusername'])) |
|
| 81 | + $__user_i->check_view_channel($_user['username'], @$_SESSION['siteusername']); |
|
| 82 | 82 | |
| 83 | 83 | if($_SERVER['REQUEST_METHOD'] == 'POST') { |
| 84 | 84 | $error = array(); |
@@ -92,11 +92,11 @@ discard block |
||
| 92 | 92 | //if(ifBlocked(@$_SESSION['siteusername'], $user['username'], $__db)) { $error = "This user has blocked you!"; $error['status'] = true; } |
| 93 | 93 | |
| 94 | 94 | if(!isset($error['message'])) { |
| 95 | - $text = $_POST['comment']; |
|
| 95 | + $text = $_POST['comment']; |
|
| 96 | 96 | $stmt = $__db->prepare("INSERT INTO profile_comments (toid, author, comment) VALUES (:id, :username, :comment)"); |
| 97 | - $stmt->bindParam(":id", $_user['username']); |
|
| 98 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 99 | - $stmt->bindParam(":comment", $text); |
|
| 97 | + $stmt->bindParam(":id", $_user['username']); |
|
| 98 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 99 | + $stmt->bindParam(":comment", $text); |
|
| 100 | 100 | $stmt->execute(); |
| 101 | 101 | |
| 102 | 102 | $_user_update_utils->update_comment_cooldown_time($_SESSION['siteusername']); |
@@ -106,7 +106,7 @@ discard block |
||
| 106 | 106 | } |
| 107 | 107 | } |
| 108 | 108 | } |
| 109 | - ?> |
|
| 109 | + ?> |
|
| 110 | 110 | <!DOCTYPE html> |
| 111 | 111 | <html dir="ltr" xmlns:og="http://opengraphprotocol.org/schema/" lang="en"> |
| 112 | 112 | <!-- machid: sNW5tN3Z2SWdXaDRqNGxuNEF5MFBxM1BxWXd0VGo0Rkg3UXNTTTNCUGRDWjR0WGpHR3R1YzFR --> |
@@ -138,16 +138,16 @@ discard block |
||
| 138 | 138 | </div> |
| 139 | 139 | <div class="browse-item-row ytg-box"> |
| 140 | 140 | <?php |
| 141 | - $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4"); |
|
| 142 | - $stmt->execute(); |
|
| 143 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 144 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 145 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 146 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 147 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 148 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 149 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 150 | - ?> |
|
| 141 | + $stmt = $__db->prepare("SELECT * FROM videos ORDER BY rand() LIMIT 4"); |
|
| 142 | + $stmt->execute(); |
|
| 143 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 144 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 145 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 146 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 147 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 148 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 149 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 150 | + ?> |
|
| 151 | 151 | <div class="browse-item yt-tile-default "> |
| 152 | 152 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 153 | 153 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -183,16 +183,16 @@ discard block |
||
| 183 | 183 | </div> |
| 184 | 184 | <div class="browse-item-row ytg-box"> |
| 185 | 185 | <?php |
| 186 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Comedy' ORDER BY rand() LIMIT 4"); |
|
| 187 | - $stmt->execute(); |
|
| 188 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 189 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 190 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 191 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 192 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 193 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 194 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 195 | - ?> |
|
| 186 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Comedy' ORDER BY rand() LIMIT 4"); |
|
| 187 | + $stmt->execute(); |
|
| 188 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 189 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 190 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 191 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 192 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 193 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 194 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 195 | + ?> |
|
| 196 | 196 | <div class="browse-item yt-tile-default "> |
| 197 | 197 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 198 | 198 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -228,16 +228,16 @@ discard block |
||
| 228 | 228 | </div> |
| 229 | 229 | <div class="browse-item-row ytg-box"> |
| 230 | 230 | <?php |
| 231 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4"); |
|
| 232 | - $stmt->execute(); |
|
| 233 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 234 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 235 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 236 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 237 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 238 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 239 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 240 | - ?> |
|
| 231 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Film & Animation' ORDER BY rand() LIMIT 4"); |
|
| 232 | + $stmt->execute(); |
|
| 233 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 234 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 235 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 236 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 237 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 238 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 239 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 240 | + ?> |
|
| 241 | 241 | <div class="browse-item yt-tile-default "> |
| 242 | 242 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 243 | 243 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -277,16 +277,16 @@ discard block |
||
| 277 | 277 | </div> |
| 278 | 278 | <div class="browse-item-row ytg-box"> |
| 279 | 279 | <?php |
| 280 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4"); |
|
| 281 | - $stmt->execute(); |
|
| 282 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 283 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 284 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 285 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 286 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 287 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 288 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 289 | - ?> |
|
| 280 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4"); |
|
| 281 | + $stmt->execute(); |
|
| 282 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 283 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 284 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 285 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 286 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 287 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 288 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 289 | + ?> |
|
| 290 | 290 | <div class="browse-item yt-tile-default "> |
| 291 | 291 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 292 | 292 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -326,16 +326,16 @@ discard block |
||
| 326 | 326 | </div> |
| 327 | 327 | <div class="browse-item-row ytg-box"> |
| 328 | 328 | <?php |
| 329 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Nonprofits & Activism' ORDER BY rand() LIMIT 4"); |
|
| 330 | - $stmt->execute(); |
|
| 331 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 332 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 333 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 334 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 335 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 336 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 337 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 338 | - ?> |
|
| 329 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Nonprofits & Activism' ORDER BY rand() LIMIT 4"); |
|
| 330 | + $stmt->execute(); |
|
| 331 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 332 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 333 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 334 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 335 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 336 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 337 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 338 | + ?> |
|
| 339 | 339 | <div class="browse-item yt-tile-default "> |
| 340 | 340 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 341 | 341 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -375,16 +375,16 @@ discard block |
||
| 375 | 375 | </div> |
| 376 | 376 | <div class="browse-item-row ytg-box"> |
| 377 | 377 | <?php |
| 378 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4"); |
|
| 379 | - $stmt->execute(); |
|
| 380 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 381 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 382 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 383 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 384 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 385 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 386 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 387 | - ?> |
|
| 378 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Pets & Animals' ORDER BY rand() LIMIT 4"); |
|
| 379 | + $stmt->execute(); |
|
| 380 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 381 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 382 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 383 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 384 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 385 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 386 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 387 | + ?> |
|
| 388 | 388 | <div class="browse-item yt-tile-default "> |
| 389 | 389 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 390 | 390 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -424,16 +424,16 @@ discard block |
||
| 424 | 424 | </div> |
| 425 | 425 | <div class="browse-item-row ytg-box"> |
| 426 | 426 | <?php |
| 427 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4"); |
|
| 428 | - $stmt->execute(); |
|
| 429 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 430 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 431 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 432 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 433 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 434 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 435 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 436 | - ?> |
|
| 427 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Science & Technology' ORDER BY rand() LIMIT 4"); |
|
| 428 | + $stmt->execute(); |
|
| 429 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 430 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 431 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 432 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 433 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 434 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 435 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 436 | + ?> |
|
| 437 | 437 | <div class="browse-item yt-tile-default "> |
| 438 | 438 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 439 | 439 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -473,16 +473,16 @@ discard block |
||
| 473 | 473 | </div> |
| 474 | 474 | <div class="browse-item-row ytg-box"> |
| 475 | 475 | <?php |
| 476 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4"); |
|
| 477 | - $stmt->execute(); |
|
| 478 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 479 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 480 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 481 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 482 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 483 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 484 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 485 | - ?> |
|
| 476 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4"); |
|
| 477 | + $stmt->execute(); |
|
| 478 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 479 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 480 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 481 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 482 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 483 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 484 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 485 | + ?> |
|
| 486 | 486 | <div class="browse-item yt-tile-default "> |
| 487 | 487 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 488 | 488 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -138,16 +138,16 @@ discard block |
||
| 138 | 138 | </div> |
| 139 | 139 | <div class="browse-item-row ytg-box"> |
| 140 | 140 | <?php |
| 141 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4"); |
|
| 142 | - $stmt->execute(); |
|
| 143 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 144 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 145 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 146 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 147 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 148 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 149 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 150 | - ?> |
|
| 141 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4"); |
|
| 142 | + $stmt->execute(); |
|
| 143 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 144 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 145 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 146 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 147 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 148 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 149 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 150 | + ?> |
|
| 151 | 151 | <div class="browse-item yt-tile-default "> |
| 152 | 152 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 153 | 153 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -173,16 +173,16 @@ discard block |
||
| 173 | 173 | </div> |
| 174 | 174 | <div class="browse-item-row ytg-box"> |
| 175 | 175 | <?php |
| 176 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4"); |
|
| 177 | - $stmt->execute(); |
|
| 178 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 179 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 180 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 181 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 182 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 183 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 184 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 185 | - ?> |
|
| 176 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4"); |
|
| 177 | + $stmt->execute(); |
|
| 178 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 179 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 180 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 181 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 182 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 183 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 184 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 185 | + ?> |
|
| 186 | 186 | <div class="browse-item yt-tile-default "> |
| 187 | 187 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 188 | 188 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -208,16 +208,16 @@ discard block |
||
| 208 | 208 | </div> |
| 209 | 209 | <div class="browse-item-row ytg-box"> |
| 210 | 210 | <?php |
| 211 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4"); |
|
| 212 | - $stmt->execute(); |
|
| 213 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 214 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 215 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 216 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 217 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 218 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 219 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 220 | - ?> |
|
| 211 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4"); |
|
| 212 | + $stmt->execute(); |
|
| 213 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 214 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 215 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 216 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 217 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 218 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 219 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 220 | + ?> |
|
| 221 | 221 | <div class="browse-item yt-tile-default "> |
| 222 | 222 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 223 | 223 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -243,16 +243,16 @@ discard block |
||
| 243 | 243 | </div> |
| 244 | 244 | <div class="browse-item-row ytg-box"> |
| 245 | 245 | <?php |
| 246 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4"); |
|
| 247 | - $stmt->execute(); |
|
| 248 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 249 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 250 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 251 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 252 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 253 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 254 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 255 | - ?> |
|
| 246 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4"); |
|
| 247 | + $stmt->execute(); |
|
| 248 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 249 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 250 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 251 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 252 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 253 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 254 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 255 | + ?> |
|
| 256 | 256 | <div class="browse-item yt-tile-default "> |
| 257 | 257 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 258 | 258 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -278,16 +278,16 @@ discard block |
||
| 278 | 278 | </div> |
| 279 | 279 | <div class="browse-item-row ytg-box"> |
| 280 | 280 | <?php |
| 281 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4"); |
|
| 282 | - $stmt->execute(); |
|
| 283 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 284 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 285 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 286 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 287 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 288 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 289 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 290 | - ?> |
|
| 281 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Autos & Vehicles' ORDER BY rand() LIMIT 4"); |
|
| 282 | + $stmt->execute(); |
|
| 283 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 284 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 285 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 286 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 287 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 288 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 289 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 290 | + ?> |
|
| 291 | 291 | <div class="browse-item yt-tile-default "> |
| 292 | 292 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 293 | 293 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -175,7 +175,7 @@ discard block |
||
| 175 | 175 | ?> |
| 176 | 176 | <?php |
| 177 | 177 | $stmt6 = $__db->prepare("SELECT * FROM favorite_video WHERE sender = :search ORDER BY id DESC LIMIT :pfirst, :pper"); |
| 178 | - $stmt6->bindParam(":search", $search); |
|
| 178 | + $stmt6->bindParam(":search", $search); |
|
| 179 | 179 | $stmt6->bindParam(":pfirst", $page_first_result); |
| 180 | 180 | $stmt6->bindParam(":pper", $results_per_page); |
| 181 | 181 | $stmt6->execute(); |
@@ -192,32 +192,32 @@ discard block |
||
| 192 | 192 | |
| 193 | 193 | <?php |
| 194 | 194 | while($video = $stmt6->fetch(PDO::FETCH_ASSOC)) { |
| 195 | - if($__video_h->video_exists($video['reciever'])) { |
|
| 196 | - $_video = $__video_h->fetch_video_rid($video['reciever']); |
|
| 197 | - $_video['video_responses'] = $__video_h->get_video_responses($_video['rid']); |
|
| 198 | - $_video['age'] = $__time_h->time_elapsed_string($_video['publish']); |
|
| 199 | - $_video['duration'] = $__time_h->timestamp($_video['duration']); |
|
| 200 | - $_video['views'] = $__video_h->fetch_video_views($_video['rid']); |
|
| 201 | - $_video['author'] = htmlspecialchars($_video['author']); |
|
| 202 | - $_video['title'] = htmlspecialchars($_video['title']); |
|
| 203 | - $_video['description'] = $__video_h->shorten_description($_video['description'], 50); |
|
| 204 | - |
|
| 205 | - if($_video['thumbnail'] == ".png" && $_video['filename'] == ".mp4") { |
|
| 206 | - $status = "Corrupted"; |
|
| 207 | - } else if($_video['visibility'] == "v") { |
|
| 208 | - $status = "Approved"; |
|
| 209 | - } else if($_video['visibility'] == "n") { |
|
| 210 | - $status = "Approved"; |
|
| 211 | - } else if($_video['visibility'] == "o") { |
|
| 212 | - $status = "Disapproved"; |
|
| 213 | - } else { |
|
| 214 | - $status = "Unknown"; |
|
| 215 | - } |
|
| 195 | + if($__video_h->video_exists($video['reciever'])) { |
|
| 196 | + $_video = $__video_h->fetch_video_rid($video['reciever']); |
|
| 197 | + $_video['video_responses'] = $__video_h->get_video_responses($_video['rid']); |
|
| 198 | + $_video['age'] = $__time_h->time_elapsed_string($_video['publish']); |
|
| 199 | + $_video['duration'] = $__time_h->timestamp($_video['duration']); |
|
| 200 | + $_video['views'] = $__video_h->fetch_video_views($_video['rid']); |
|
| 201 | + $_video['author'] = htmlspecialchars($_video['author']); |
|
| 202 | + $_video['title'] = htmlspecialchars($_video['title']); |
|
| 203 | + $_video['description'] = $__video_h->shorten_description($_video['description'], 50); |
|
| 204 | + |
|
| 205 | + if($_video['thumbnail'] == ".png" && $_video['filename'] == ".mp4") { |
|
| 206 | + $status = "Corrupted"; |
|
| 207 | + } else if($_video['visibility'] == "v") { |
|
| 208 | + $status = "Approved"; |
|
| 209 | + } else if($_video['visibility'] == "n") { |
|
| 210 | + $status = "Approved"; |
|
| 211 | + } else if($_video['visibility'] == "o") { |
|
| 212 | + $status = "Disapproved"; |
|
| 213 | + } else { |
|
| 214 | + $status = "Unknown"; |
|
| 215 | + } |
|
| 216 | 216 | |
| 217 | - if($_video['commenting'] == "a") |
|
| 218 | - $_video['commentstatus'] = "Commenting allowed"; |
|
| 219 | - else |
|
| 220 | - $_video['commentstatus'] = "Commenting disallowed"; |
|
| 217 | + if($_video['commenting'] == "a") |
|
| 218 | + $_video['commentstatus'] = "Commenting allowed"; |
|
| 219 | + else |
|
| 220 | + $_video['commentstatus'] = "Commenting disallowed"; |
|
| 221 | 221 | ?> |
| 222 | 222 | <tr style="margin-top: 5px;" id="videoslist"> |
| 223 | 223 | <td class="video-manager-left"> |
@@ -138,16 +138,16 @@ discard block |
||
| 138 | 138 | </div> |
| 139 | 139 | <div class="browse-item-row ytg-box"> |
| 140 | 140 | <?php |
| 141 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Entertainment' ORDER BY rand() LIMIT 4"); |
|
| 142 | - $stmt->execute(); |
|
| 143 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 144 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 145 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 146 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 147 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 148 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 149 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 150 | - ?> |
|
| 141 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Entertainment' ORDER BY rand() LIMIT 4"); |
|
| 142 | + $stmt->execute(); |
|
| 143 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 144 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 145 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 146 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 147 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 148 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 149 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 150 | + ?> |
|
| 151 | 151 | <div class="browse-item yt-tile-default "> |
| 152 | 152 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 153 | 153 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -173,16 +173,16 @@ discard block |
||
| 173 | 173 | </div> |
| 174 | 174 | <div class="browse-item-row ytg-box"> |
| 175 | 175 | <?php |
| 176 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Entertainment' ORDER BY rand() LIMIT 4"); |
|
| 177 | - $stmt->execute(); |
|
| 178 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 179 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 180 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 181 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 182 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 183 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 184 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 185 | - ?> |
|
| 176 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Entertainment' ORDER BY rand() LIMIT 4"); |
|
| 177 | + $stmt->execute(); |
|
| 178 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 179 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 180 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 181 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 182 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 183 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 184 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 185 | + ?> |
|
| 186 | 186 | <div class="browse-item yt-tile-default "> |
| 187 | 187 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 188 | 188 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -208,16 +208,16 @@ discard block |
||
| 208 | 208 | </div> |
| 209 | 209 | <div class="browse-item-row ytg-box"> |
| 210 | 210 | <?php |
| 211 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Entertainment' ORDER BY rand() LIMIT 4"); |
|
| 212 | - $stmt->execute(); |
|
| 213 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 214 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 215 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 216 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 217 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 218 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 219 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 220 | - ?> |
|
| 211 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Entertainment' ORDER BY rand() LIMIT 4"); |
|
| 212 | + $stmt->execute(); |
|
| 213 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 214 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 215 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 216 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 217 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 218 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 219 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 220 | + ?> |
|
| 221 | 221 | <div class="browse-item yt-tile-default "> |
| 222 | 222 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 223 | 223 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -243,16 +243,16 @@ discard block |
||
| 243 | 243 | </div> |
| 244 | 244 | <div class="browse-item-row ytg-box"> |
| 245 | 245 | <?php |
| 246 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Entertainment' ORDER BY rand() LIMIT 4"); |
|
| 247 | - $stmt->execute(); |
|
| 248 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 249 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 250 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 251 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 252 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 253 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 254 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 255 | - ?> |
|
| 246 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Entertainment' ORDER BY rand() LIMIT 4"); |
|
| 247 | + $stmt->execute(); |
|
| 248 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 249 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 250 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 251 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 252 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 253 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 254 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 255 | + ?> |
|
| 256 | 256 | <div class="browse-item yt-tile-default "> |
| 257 | 257 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 258 | 258 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -278,16 +278,16 @@ discard block |
||
| 278 | 278 | </div> |
| 279 | 279 | <div class="browse-item-row ytg-box"> |
| 280 | 280 | <?php |
| 281 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Entertainment' ORDER BY rand() LIMIT 4"); |
|
| 282 | - $stmt->execute(); |
|
| 283 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 284 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 285 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 286 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 287 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 288 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 289 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 290 | - ?> |
|
| 281 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Entertainment' ORDER BY rand() LIMIT 4"); |
|
| 282 | + $stmt->execute(); |
|
| 283 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 284 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 285 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 286 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 287 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 288 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 289 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 290 | + ?> |
|
| 291 | 291 | <div class="browse-item yt-tile-default "> |
| 292 | 292 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 293 | 293 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -138,16 +138,16 @@ discard block |
||
| 138 | 138 | </div> |
| 139 | 139 | <div class="browse-item-row ytg-box"> |
| 140 | 140 | <?php |
| 141 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4"); |
|
| 142 | - $stmt->execute(); |
|
| 143 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 144 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 145 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 146 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 147 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 148 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 149 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 150 | - ?> |
|
| 141 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4"); |
|
| 142 | + $stmt->execute(); |
|
| 143 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 144 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 145 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 146 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 147 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 148 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 149 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 150 | + ?> |
|
| 151 | 151 | <div class="browse-item yt-tile-default "> |
| 152 | 152 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 153 | 153 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -173,16 +173,16 @@ discard block |
||
| 173 | 173 | </div> |
| 174 | 174 | <div class="browse-item-row ytg-box"> |
| 175 | 175 | <?php |
| 176 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4"); |
|
| 177 | - $stmt->execute(); |
|
| 178 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 179 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 180 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 181 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 182 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 183 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 184 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 185 | - ?> |
|
| 176 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4"); |
|
| 177 | + $stmt->execute(); |
|
| 178 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 179 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 180 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 181 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 182 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 183 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 184 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 185 | + ?> |
|
| 186 | 186 | <div class="browse-item yt-tile-default "> |
| 187 | 187 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 188 | 188 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -208,16 +208,16 @@ discard block |
||
| 208 | 208 | </div> |
| 209 | 209 | <div class="browse-item-row ytg-box"> |
| 210 | 210 | <?php |
| 211 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4"); |
|
| 212 | - $stmt->execute(); |
|
| 213 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 214 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 215 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 216 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 217 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 218 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 219 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 220 | - ?> |
|
| 211 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4"); |
|
| 212 | + $stmt->execute(); |
|
| 213 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 214 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 215 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 216 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 217 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 218 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 219 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 220 | + ?> |
|
| 221 | 221 | <div class="browse-item yt-tile-default "> |
| 222 | 222 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 223 | 223 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -243,16 +243,16 @@ discard block |
||
| 243 | 243 | </div> |
| 244 | 244 | <div class="browse-item-row ytg-box"> |
| 245 | 245 | <?php |
| 246 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4"); |
|
| 247 | - $stmt->execute(); |
|
| 248 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 249 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 250 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 251 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 252 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 253 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 254 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 255 | - ?> |
|
| 246 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4"); |
|
| 247 | + $stmt->execute(); |
|
| 248 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 249 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 250 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 251 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 252 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 253 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 254 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 255 | + ?> |
|
| 256 | 256 | <div class="browse-item yt-tile-default "> |
| 257 | 257 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 258 | 258 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -278,16 +278,16 @@ discard block |
||
| 278 | 278 | </div> |
| 279 | 279 | <div class="browse-item-row ytg-box"> |
| 280 | 280 | <?php |
| 281 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4"); |
|
| 282 | - $stmt->execute(); |
|
| 283 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 284 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 285 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 286 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 287 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 288 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 289 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 290 | - ?> |
|
| 281 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Travel & Events' ORDER BY rand() LIMIT 4"); |
|
| 282 | + $stmt->execute(); |
|
| 283 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 284 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 285 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 286 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 287 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 288 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 289 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 290 | + ?> |
|
| 291 | 291 | <div class="browse-item yt-tile-default "> |
| 292 | 292 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 293 | 293 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -59,28 +59,28 @@ |
||
| 59 | 59 | require_once($_SERVER['DOCUMENT_ROOT'] . "/" . $requestedPage[1] . "/" . $requestedPage[2] . ".php"); |
| 60 | 60 | die(); |
| 61 | 61 | break; |
| 62 | - case 'd': |
|
| 63 | - if ($requestedPage[2] == "") { |
|
| 64 | - $requestedPage[2] = "index"; |
|
| 65 | - } |
|
| 66 | - require_once($_SERVER['DOCUMENT_ROOT'] . "/" . $requestedPage[1] . "/" . $requestedPage[2] . ".php"); |
|
| 67 | - die(); |
|
| 68 | - break; |
|
| 62 | + case 'd': |
|
| 63 | + if ($requestedPage[2] == "") { |
|
| 64 | + $requestedPage[2] = "index"; |
|
| 65 | + } |
|
| 66 | + require_once($_SERVER['DOCUMENT_ROOT'] . "/" . $requestedPage[1] . "/" . $requestedPage[2] . ".php"); |
|
| 67 | + die(); |
|
| 68 | + break; |
|
| 69 | 69 | case 'user': |
| 70 | 70 | $_GET['n'] = $requestedPage[2]; |
| 71 | 71 | require_once($_SERVER['DOCUMENT_ROOT'] . "/channel.php"); |
| 72 | 72 | die(); |
| 73 | 73 | break; |
| 74 | 74 | default: |
| 75 | - require_once($_SERVER['DOCUMENT_ROOT'] . "/s/classes/config.inc.php"); |
|
| 76 | - require_once($_SERVER['DOCUMENT_ROOT'] . "/s/classes/db_helper.php"); |
|
| 77 | - require_once($_SERVER['DOCUMENT_ROOT'] . "/s/classes/time_manip.php"); |
|
| 78 | - require_once($_SERVER['DOCUMENT_ROOT'] . "/s/classes/user_helper.php"); |
|
| 79 | - require_once($_SERVER['DOCUMENT_ROOT'] . "/s/classes/video_helper.php"); |
|
| 80 | - $__video_h = new video_helper($__db); |
|
| 81 | - $__user_h = new user_helper($__db); |
|
| 82 | - $__db_h = new db_helper(); |
|
| 83 | - $__time_h = new time_helper(); |
|
| 75 | + require_once($_SERVER['DOCUMENT_ROOT'] . "/s/classes/config.inc.php"); |
|
| 76 | + require_once($_SERVER['DOCUMENT_ROOT'] . "/s/classes/db_helper.php"); |
|
| 77 | + require_once($_SERVER['DOCUMENT_ROOT'] . "/s/classes/time_manip.php"); |
|
| 78 | + require_once($_SERVER['DOCUMENT_ROOT'] . "/s/classes/user_helper.php"); |
|
| 79 | + require_once($_SERVER['DOCUMENT_ROOT'] . "/s/classes/video_helper.php"); |
|
| 80 | + $__video_h = new video_helper($__db); |
|
| 81 | + $__user_h = new user_helper($__db); |
|
| 82 | + $__db_h = new db_helper(); |
|
| 83 | + $__time_h = new time_helper(); |
|
| 84 | 84 | |
| 85 | 85 | if(empty($requestedPage[1])) |
| 86 | 86 | require_once($_SERVER['DOCUMENT_ROOT'] . "/homepage.php"); |
@@ -138,16 +138,16 @@ discard block |
||
| 138 | 138 | </div> |
| 139 | 139 | <div class="browse-item-row ytg-box"> |
| 140 | 140 | <?php |
| 141 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4"); |
|
| 142 | - $stmt->execute(); |
|
| 143 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 144 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 145 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 146 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 147 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 148 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 149 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 150 | - ?> |
|
| 141 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4"); |
|
| 142 | + $stmt->execute(); |
|
| 143 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 144 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 145 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 146 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 147 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 148 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 149 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 150 | + ?> |
|
| 151 | 151 | <div class="browse-item yt-tile-default "> |
| 152 | 152 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 153 | 153 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -173,16 +173,16 @@ discard block |
||
| 173 | 173 | </div> |
| 174 | 174 | <div class="browse-item-row ytg-box"> |
| 175 | 175 | <?php |
| 176 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4"); |
|
| 177 | - $stmt->execute(); |
|
| 178 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 179 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 180 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 181 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 182 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 183 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 184 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 185 | - ?> |
|
| 176 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4"); |
|
| 177 | + $stmt->execute(); |
|
| 178 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 179 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 180 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 181 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 182 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 183 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 184 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 185 | + ?> |
|
| 186 | 186 | <div class="browse-item yt-tile-default "> |
| 187 | 187 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 188 | 188 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -208,16 +208,16 @@ discard block |
||
| 208 | 208 | </div> |
| 209 | 209 | <div class="browse-item-row ytg-box"> |
| 210 | 210 | <?php |
| 211 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4"); |
|
| 212 | - $stmt->execute(); |
|
| 213 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 214 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 215 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 216 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 217 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 218 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 219 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 220 | - ?> |
|
| 211 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4"); |
|
| 212 | + $stmt->execute(); |
|
| 213 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 214 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 215 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 216 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 217 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 218 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 219 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 220 | + ?> |
|
| 221 | 221 | <div class="browse-item yt-tile-default "> |
| 222 | 222 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 223 | 223 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -243,16 +243,16 @@ discard block |
||
| 243 | 243 | </div> |
| 244 | 244 | <div class="browse-item-row ytg-box"> |
| 245 | 245 | <?php |
| 246 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4"); |
|
| 247 | - $stmt->execute(); |
|
| 248 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 249 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 250 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 251 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 252 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 253 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 254 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 255 | - ?> |
|
| 246 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4"); |
|
| 247 | + $stmt->execute(); |
|
| 248 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 249 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 250 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 251 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 252 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 253 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 254 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 255 | + ?> |
|
| 256 | 256 | <div class="browse-item yt-tile-default "> |
| 257 | 257 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 258 | 258 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -278,16 +278,16 @@ discard block |
||
| 278 | 278 | </div> |
| 279 | 279 | <div class="browse-item-row ytg-box"> |
| 280 | 280 | <?php |
| 281 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4"); |
|
| 282 | - $stmt->execute(); |
|
| 283 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 284 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 285 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 286 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 287 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 288 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 289 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 290 | - ?> |
|
| 281 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Gaming' ORDER BY rand() LIMIT 4"); |
|
| 282 | + $stmt->execute(); |
|
| 283 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 284 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 285 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 286 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 287 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 288 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 289 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 290 | + ?> |
|
| 291 | 291 | <div class="browse-item yt-tile-default "> |
| 292 | 292 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 293 | 293 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -138,16 +138,16 @@ discard block |
||
| 138 | 138 | </div> |
| 139 | 139 | <div class="browse-item-row ytg-box"> |
| 140 | 140 | <?php |
| 141 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Howto & Style' ORDER BY rand() LIMIT 4"); |
|
| 142 | - $stmt->execute(); |
|
| 143 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 144 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 145 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 146 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 147 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 148 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 149 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 150 | - ?> |
|
| 141 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Howto & Style' ORDER BY rand() LIMIT 4"); |
|
| 142 | + $stmt->execute(); |
|
| 143 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 144 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 145 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 146 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 147 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 148 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 149 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 150 | + ?> |
|
| 151 | 151 | <div class="browse-item yt-tile-default "> |
| 152 | 152 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 153 | 153 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -173,16 +173,16 @@ discard block |
||
| 173 | 173 | </div> |
| 174 | 174 | <div class="browse-item-row ytg-box"> |
| 175 | 175 | <?php |
| 176 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Howto & Style' ORDER BY rand() LIMIT 4"); |
|
| 177 | - $stmt->execute(); |
|
| 178 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 179 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 180 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 181 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 182 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 183 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 184 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 185 | - ?> |
|
| 176 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Howto & Style' ORDER BY rand() LIMIT 4"); |
|
| 177 | + $stmt->execute(); |
|
| 178 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 179 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 180 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 181 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 182 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 183 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 184 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 185 | + ?> |
|
| 186 | 186 | <div class="browse-item yt-tile-default "> |
| 187 | 187 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 188 | 188 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -208,16 +208,16 @@ discard block |
||
| 208 | 208 | </div> |
| 209 | 209 | <div class="browse-item-row ytg-box"> |
| 210 | 210 | <?php |
| 211 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Howto & Style' ORDER BY rand() LIMIT 4"); |
|
| 212 | - $stmt->execute(); |
|
| 213 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 214 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 215 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 216 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 217 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 218 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 219 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 220 | - ?> |
|
| 211 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Howto & Style' ORDER BY rand() LIMIT 4"); |
|
| 212 | + $stmt->execute(); |
|
| 213 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 214 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 215 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 216 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 217 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 218 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 219 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 220 | + ?> |
|
| 221 | 221 | <div class="browse-item yt-tile-default "> |
| 222 | 222 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 223 | 223 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -243,16 +243,16 @@ discard block |
||
| 243 | 243 | </div> |
| 244 | 244 | <div class="browse-item-row ytg-box"> |
| 245 | 245 | <?php |
| 246 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Howto & Style' ORDER BY rand() LIMIT 4"); |
|
| 247 | - $stmt->execute(); |
|
| 248 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 249 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 250 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 251 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 252 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 253 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 254 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 255 | - ?> |
|
| 246 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Howto & Style' ORDER BY rand() LIMIT 4"); |
|
| 247 | + $stmt->execute(); |
|
| 248 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 249 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 250 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 251 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 252 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 253 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 254 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 255 | + ?> |
|
| 256 | 256 | <div class="browse-item yt-tile-default "> |
| 257 | 257 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 258 | 258 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
@@ -278,16 +278,16 @@ discard block |
||
| 278 | 278 | </div> |
| 279 | 279 | <div class="browse-item-row ytg-box"> |
| 280 | 280 | <?php |
| 281 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Howto & Style' ORDER BY rand() LIMIT 4"); |
|
| 282 | - $stmt->execute(); |
|
| 283 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 284 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 285 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 286 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 287 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 288 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 289 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 290 | - ?> |
|
| 281 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE category = 'Howto & Style' ORDER BY rand() LIMIT 4"); |
|
| 282 | + $stmt->execute(); |
|
| 283 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 284 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 285 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 286 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 287 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 288 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 289 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 290 | + ?> |
|
| 291 | 291 | <div class="browse-item yt-tile-default "> |
| 292 | 292 | <a href="/watch?v=<?php echo $video['rid']; ?>" class="ux-thumb-wrap yt-uix-sessionlink yt-uix-contextlink contains-addto " data-sessionlink="ei=CPjwu5ji3bICFS4RIQod9j-M-A%3D%3D&feature=b-mv"><span class="video-thumb ux-thumb yt-thumb-default-194 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Thumbnail" data-thumb="/dynamic/thumbs/<?php echo $video['thumbnail']; ?>" width="194"><span class="vertical-align"></span></span></span></span><span class="video-time"><?php echo $video['duration']; ?></span> |
| 293 | 293 | <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="rLHU-_OhT8g" role="button"><span class="yt-uix-button-content"> <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="Watch Later"> |
