@@ -1,18 +1,18 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | - if(isset($_SESSION['siteusername'])) { |
|
| 2 | + if(isset($_SESSION['siteusername'])) { |
|
| 3 | 3 | $stmt = $__db->prepare("UPDATE users SET ip = :ip WHERE username = :username"); |
| 4 | 4 | $stmt->bindParam(":username", $_SESSION['siteusername']); |
| 5 | - $stmt->bindParam(":ip", $_SERVER["HTTP_CF_CONNECTING_IP"]); |
|
| 5 | + $stmt->bindParam(":ip", $_SERVER["HTTP_CF_CONNECTING_IP"]); |
|
| 6 | 6 | $stmt->execute(); |
| 7 | 7 | |
| 8 | - $stmt = $__db->prepare("UPDATE users SET lastlogin = now() WHERE username = :username"); |
|
| 8 | + $stmt = $__db->prepare("UPDATE users SET lastlogin = now() WHERE username = :username"); |
|
| 9 | 9 | $stmt->bindParam(":username", $_SESSION['siteusername']); |
| 10 | 10 | $stmt->execute(); |
| 11 | - } |
|
| 11 | + } |
|
| 12 | 12 | |
| 13 | - if(isset($_SESSION['siteusername']) && !$__user_h->user_exists(@$_SESSION['siteusername'])) { |
|
| 14 | - die("<a href='/logout'>Your user has been deleted. Logout</a>"); |
|
| 15 | - } |
|
| 13 | + if(isset($_SESSION['siteusername']) && !$__user_h->user_exists(@$_SESSION['siteusername'])) { |
|
| 14 | + die("<a href='/logout'>Your user has been deleted. Logout</a>"); |
|
| 15 | + } |
|
| 16 | 16 | ?> |
| 17 | 17 | <!-- begin masthead --> |
| 18 | 18 | <div id="masthead" class="" dir="ltr"> |
@@ -109,10 +109,10 @@ discard block |
||
| 109 | 109 | <div id="masthead-expanded" class="hid" style="display: none;height: 165px;"> |
| 110 | 110 | <div id="masthead-expanded-container" style="height: 142px;" class="with-sandbar"> |
| 111 | 111 | <?php |
| 112 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE author = :username ORDER BY id DESC LIMIT 20"); |
|
| 113 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 114 | - $stmt->execute(); |
|
| 115 | - ?> |
|
| 112 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE author = :username ORDER BY id DESC LIMIT 20"); |
|
| 113 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 114 | + $stmt->execute(); |
|
| 115 | + ?> |
|
| 116 | 116 | <div class="yt-uix-slider yt-rounded" id="watch-channel-discoverbox" data-slider-slide-selected="3" data-slider-slides="<?php echo $stmt->rowCount(); ?>" |
| 117 | 117 | style=" |
| 118 | 118 | width: 580px; |
@@ -127,14 +127,14 @@ discard block |
||
| 127 | 127 | <div class="yt-uix-slider-body" style="width: 525px;"> |
| 128 | 128 | <div class="yt-uix-slider-slides"> |
| 129 | 129 | <?php |
| 130 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 131 | - $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 132 | - $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 133 | - $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 134 | - $video['author'] = htmlspecialchars($video['author']); |
|
| 135 | - $video['title'] = htmlspecialchars($video['title']); |
|
| 136 | - $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 137 | - ?> |
|
| 130 | + while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 131 | + $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
|
| 132 | + $video['duration'] = $__time_h->timestamp($video['duration']); |
|
| 133 | + $video['views'] = $__video_h->fetch_video_views($video['rid']); |
|
| 134 | + $video['author'] = htmlspecialchars($video['author']); |
|
| 135 | + $video['title'] = htmlspecialchars($video['title']); |
|
| 136 | + $video['description'] = $__video_h->shorten_description($video['description'], 50); |
|
| 137 | + ?> |
|
| 138 | 138 | <ul class="yt-uix-slider-slide "> |
| 139 | 139 | <li class="yt-uix-slider-slide-item "> |
| 140 | 140 | <div class="video-list-item yt-tile-default "> |
@@ -51,20 +51,20 @@ discard block |
||
| 51 | 51 | ORDER BY |
| 52 | 52 | `date` DESC LIMIT 10;"); |
| 53 | 53 | $stmt->bindParam(":comment_username", $_user['username']); |
| 54 | - $stmt->bindParam(":videos_username", $_user['username']); |
|
| 54 | + $stmt->bindParam(":videos_username", $_user['username']); |
|
| 55 | 55 | $stmt->execute(); |
| 56 | - if($stmt->rowCount() == 0) { echo "<br><span style='color:grey;font-size:11px;'>This user has not done anything yet.</span>"; } |
|
| 56 | + if($stmt->rowCount() == 0) { echo "<br><span style='color:grey;font-size:11px;'>This user has not done anything yet.</span>"; } |
|
| 57 | 57 | while($content = $stmt->fetch(PDO::FETCH_ASSOC)) { |
| 58 | - if((int)$content['id']) { |
|
| 59 | - $content = $__video_h->fetch_comment_id($content['id']); |
|
| 60 | - $content['video'] = $__video_h->fetch_video_rid($content['toid']); |
|
| 61 | - $content['type'] = "comment"; |
|
| 62 | - } else { |
|
| 63 | - $content = $__video_h->fetch_video_rid($content['id']); |
|
| 64 | - $content['type'] = "video"; |
|
| 65 | - } |
|
| 58 | + if((int)$content['id']) { |
|
| 59 | + $content = $__video_h->fetch_comment_id($content['id']); |
|
| 60 | + $content['video'] = $__video_h->fetch_video_rid($content['toid']); |
|
| 61 | + $content['type'] = "comment"; |
|
| 62 | + } else { |
|
| 63 | + $content = $__video_h->fetch_video_rid($content['id']); |
|
| 64 | + $content['type'] = "video"; |
|
| 65 | + } |
|
| 66 | 66 | |
| 67 | - if($content['type'] == "video") { |
|
| 67 | + if($content['type'] == "video") { |
|
| 68 | 68 | ?> |
| 69 | 69 | <div class="feed-item-container" data-channel-key="UCc6W7efUSkd9YYoxOnctlFg"> |
| 70 | 70 | <a href="/user/<?php echo htmlspecialchars($content['author']); ?>?feature=plcp" class="feed-author-bubble " title="<?php echo htmlspecialchars($content['author']); ?>"> <span class="feed-item-author"> |
@@ -136,7 +136,7 @@ discard block |
||
| 136 | 136 | </div> |
| 137 | 137 | </div> |
| 138 | 138 | <?php } else { |
| 139 | - if($__video_h->video_exists($content['video']['rid'])) { ?> |
|
| 139 | + if($__video_h->video_exists($content['video']['rid'])) { ?> |
|
| 140 | 140 | <div class="feed-item-container" data-channel-key="UCXf1X2u5gsmuqcuTQlpOGhw"> |
| 141 | 141 | <a href="/user/<?php echo htmlspecialchars($content['author']); ?>?feature=plcp" class="feed-author-bubble " title="<?php echo htmlspecialchars($content['author']); ?>"> <span class="feed-item-author"> |
| 142 | 142 | <span class="video-thumb ux-thumb yt-thumb-square-28 "><span class="yt-thumb-clip"><span class="yt-thumb-clip-inner"><img src="http://s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="<?php echo htmlspecialchars($content['author']); ?>" data-thumb="/dynamic/pfp/<?php echo $__user_h->fetch_pfp($content['author']); ?>" width="28"><span class="vertical-align"></span></span></span></span> |
@@ -52,7 +52,7 @@ |
||
| 52 | 52 | $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :search ORDER BY id DESC LIMIT 10"); |
| 53 | 53 | $stmt->bindParam(":search", $_user['username']); |
| 54 | 54 | $stmt->execute(); |
| 55 | - ?> |
|
| 55 | + ?> |
|
| 56 | 56 | <div class="playlist-info"> |
| 57 | 57 | <h2><?php echo htmlspecialchars($_user['username']); ?>'s playlists</h2> |
| 58 | 58 | <?php if($stmt->rowCount() == 0) { echo "<span style='font-size:11px;color:grey;'>This user has no playlists available currently.</span><br><br>"; } ?> |
@@ -57,10 +57,10 @@ |
||
| 57 | 57 | --> |
| 58 | 58 | </div> |
| 59 | 59 | <?php |
| 60 | - $stmt = $__db->prepare("SELECT * FROM videos WHERE author = :username ORDER BY id DESC LIMIT 20"); |
|
| 61 | - $stmt->bindParam(":username", $_user['username']); |
|
| 62 | - $stmt->execute(); |
|
| 63 | - ?> |
|
| 60 | + $stmt = $__db->prepare("SELECT * FROM videos WHERE author = :username ORDER BY id DESC LIMIT 20"); |
|
| 61 | + $stmt->bindParam(":username", $_user['username']); |
|
| 62 | + $stmt->execute(); |
|
| 63 | + ?> |
|
| 64 | 64 | <style> |
| 65 | 65 | .box-gray { |
| 66 | 66 | position: relative; |