@@ -11,8 +11,8 @@ discard block |
||
| 11 | 11 | <?php $__db_h = new db_helper(); ?> |
| 12 | 12 | <?php $__time_h = new time_helper(); ?> |
| 13 | 13 | <?php |
| 14 | - if(!isset($_SESSION['siteusername'])) { die(); } |
|
| 15 | - if(!$__user_h->if_admin($_SESSION['siteusername'])) { die(); } |
|
| 14 | + if (!isset($_SESSION['siteusername'])) { die(); } |
|
| 15 | + if (!$__user_h->if_admin($_SESSION['siteusername'])) { die(); } |
|
| 16 | 16 | |
| 17 | 17 | $request = (object) [ |
| 18 | 18 | "action" => $_GET['action'], |
@@ -49,8 +49,8 @@ discard block |
||
| 49 | 49 | ); |
| 50 | 50 | $request->tables_increment = 0; |
| 51 | 51 | |
| 52 | - if($request->action == "ban_users") { |
|
| 53 | - foreach($request->users as $username) { |
|
| 52 | + if ($request->action == "ban_users") { |
|
| 53 | + foreach ($request->users as $username) { |
|
| 54 | 54 | $stmt = $__db->prepare("DELETE FROM users WHERE username=:username"); |
| 55 | 55 | $stmt->execute(array( |
| 56 | 56 | ':username' => $username, |
@@ -133,8 +133,8 @@ discard block |
||
| 133 | 133 | |
| 134 | 134 | header("Location: /admin/bans"); |
| 135 | 135 | } |
| 136 | - } else if($request->action == "delete_videos") { |
|
| 137 | - foreach($request->videos as $video) { |
|
| 136 | + } else if ($request->action == "delete_videos") { |
|
| 137 | + foreach ($request->videos as $video) { |
|
| 138 | 138 | $stmt = $__db->prepare("DELETE FROM videos WHERE rid=:video"); |
| 139 | 139 | $stmt->execute(array( |
| 140 | 140 | ':video' => $video, |
@@ -142,7 +142,7 @@ discard block |
||
| 142 | 142 | |
| 143 | 143 | header("Location: /admin/bans"); |
| 144 | 144 | } |
| 145 | - } else if($request->action == "actually_just_ban") { |
|
| 145 | + } else if ($request->action == "actually_just_ban") { |
|
| 146 | 146 | /* |
| 147 | 147 | foreach($request->users as $user) { |
| 148 | 148 | $stmt = $__db->prepare("UPDATE videos SET visibility = :visibility WHERE author = :username"); |
@@ -1,10 +1,10 @@ |
||
| 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 | 8 | ?> |
| 9 | 9 | <!-- begin masthead --> |
| 10 | 10 | <div id="masthead" class="" dir="ltr"> |
@@ -1,8 +1,8 @@ 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 | 8 | ?> |
@@ -11,7 +11,7 @@ discard block |
||
| 11 | 11 | <a id="logo-container" href="/" title="SubRocks home"> |
| 12 | 12 | <img id="logo" src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" alt="SubRocks home"> |
| 13 | 13 | </a> |
| 14 | - <?php if(!isset($_SESSION['siteusername'])) { ?> |
|
| 14 | + <?php if (!isset($_SESSION['siteusername'])) { ?> |
|
| 15 | 15 | <div id="yt-masthead-signin"> |
| 16 | 16 | <div id="masthead-user-display"><span id="masthead-user-wrapper"><button href="/sign_in" type="button" id="masthead-user-button" onclick=";window.location.href=this.getAttribute('href');return false;" class=" yt-uix-button yt-uix-button-text" role="button"><span class="yt-uix-button-content"> <span id="masthead-user-image"> |
| 17 | 17 | <span class="clip"> |
@@ -29,7 +29,7 @@ discard block |
||
| 29 | 29 | <span id="yt-masthead-user-displayname" dir="ltr" class="yt-valign-container" onclick="yt.www.masthead.toggleExpandedMasthead();"> |
| 30 | 30 | <?php echo htmlspecialchars($_SESSION['siteusername']); ?> |
| 31 | 31 | </span> |
| 32 | - <?php if($__user_h->fetch_unread_pms($_SESSION['siteusername']) != 0) { ?> |
|
| 32 | + <?php if ($__user_h->fetch_unread_pms($_SESSION['siteusername']) != 0) { ?> |
|
| 33 | 33 | <a style="border-radius:2px;font-weight:bold;border:1px solid #CE4D34;position:relative;top:1px;color: white;text-decoration: none;background-color: #E26148;padding: 7px;padding-left: 10px;margin-right: 12px;display: inline;" href="/inbox/"> |
| 34 | 34 | <?php echo $__user_h->fetch_unread_pms($_SESSION['siteusername']); ?> |
| 35 | 35 | </a> |
@@ -51,7 +51,7 @@ discard block |
||
| 51 | 51 | </form> |
| 52 | 52 | </div> |
| 53 | 53 | </div></div> |
| 54 | -<?php if(isset($_SESSION['siteusername'])) { ?> |
|
| 54 | +<?php if (isset($_SESSION['siteusername'])) { ?> |
|
| 55 | 55 | <div id="masthead-expanded" class="hid" style="display: none;"> |
| 56 | 56 | <div id="masthead-expanded-container" class="with-sandbar"> |
| 57 | 57 | <div class="yt-uix-slider yt-rounded" id="watch-channel-discoverbox" data-slider-slide-selected="3" data-slider-slides="4" |
@@ -72,7 +72,7 @@ discard block |
||
| 72 | 72 | $stmt = $__db->prepare("SELECT * FROM videos WHERE author = :username ORDER BY id DESC LIMIT 20"); |
| 73 | 73 | $stmt->bindParam(":username", $_SESSION['siteusername']); |
| 74 | 74 | $stmt->execute(); |
| 75 | - while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 75 | + while ($video = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 76 | 76 | $video['age'] = $__time_h->time_elapsed_string($video['publish']); |
| 77 | 77 | $video['duration'] = $__time_h->timestamp($video['duration']); |
| 78 | 78 | $video['views'] = $__video_h->fetch_video_views($video['rid']); |
@@ -216,7 +216,7 @@ discard block |
||
| 216 | 216 | <?php } ?> |
| 217 | 217 | </div> |
| 218 | 218 | <div id="alerts"> |
| 219 | - <?php if(isset($error['status'])) { ?> |
|
| 219 | + <?php if (isset($error['status'])) { ?> |
|
| 220 | 220 | <div id="masthead_child_div"><div class="yt-alert yt-alert-default yt-alert-error yt-alert-player"> <div class="yt-alert-icon"> |
| 221 | 221 | <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" class="icon master-sprite" alt="Alert icon"> |
| 222 | 222 | </div> |
@@ -226,7 +226,7 @@ discard block |
||
| 226 | 226 | </div> |
| 227 | 227 | </div></div></div> |
| 228 | 228 | <?php } ?> |
| 229 | - <?php if(isset($_GET['error'])) { ?> |
|
| 229 | + <?php if (isset($_GET['error'])) { ?> |
|
| 230 | 230 | <div id="masthead_child_div"><div class="yt-alert yt-alert-default yt-alert-error "> <div class="yt-alert-icon"> |
| 231 | 231 | <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" class="icon master-sprite" alt="Alert icon"> |
| 232 | 232 | </div> |
@@ -236,7 +236,7 @@ discard block |
||
| 236 | 236 | </div> |
| 237 | 237 | </div></div></div> |
| 238 | 238 | <?php } ?> |
| 239 | - <?php if(isset($_GET['success'])) { ?> |
|
| 239 | + <?php if (isset($_GET['success'])) { ?> |
|
| 240 | 240 | <div id="masthead_child_div"><div class="yt-alert yt-alert-default yt-alert-success "> <div class="yt-alert-icon"> |
| 241 | 241 | <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" class="icon master-sprite" alt="Alert icon"> |
| 242 | 242 | </div> |
@@ -246,7 +246,7 @@ discard block |
||
| 246 | 246 | </div> |
| 247 | 247 | </div></div></div> |
| 248 | 248 | <?php } ?> |
| 249 | - <?php if(isset($_SESSION['error'])) { ?> |
|
| 249 | + <?php if (isset($_SESSION['error'])) { ?> |
|
| 250 | 250 | <div id="masthead_child_div"><div class="yt-alert yt-alert-default yt-alert-error"> <div class="yt-alert-icon"> |
| 251 | 251 | <img src="//s.ytimg.com/yt/img/pixel-vfl3z5WfW.gif" class="icon master-sprite" alt="Alert icon"> |
| 252 | 252 | </div> |
@@ -45,20 +45,20 @@ discard block |
||
| 45 | 45 | ORDER BY |
| 46 | 46 | `date` DESC;"); |
| 47 | 47 | $stmt->bindParam(":comment_username", $_user['username']); |
| 48 | - $stmt->bindParam(":videos_username", $_user['username']); |
|
| 48 | + $stmt->bindParam(":videos_username", $_user['username']); |
|
| 49 | 49 | $stmt->execute(); |
| 50 | - if($stmt->rowCount() == 0) { echo "<br><span style='color:grey;font-size:11px;'>This user has not done anything yet.</span>"; } |
|
| 50 | + if($stmt->rowCount() == 0) { echo "<br><span style='color:grey;font-size:11px;'>This user has not done anything yet.</span>"; } |
|
| 51 | 51 | while($content = $stmt->fetch(PDO::FETCH_ASSOC)) { |
| 52 | - if((int)$content['id']) { |
|
| 53 | - $content = $__video_h->fetch_comment_id($content['id']); |
|
| 54 | - $content['video'] = $__video_h->fetch_video_rid($content['toid']); |
|
| 55 | - $content['type'] = "comment"; |
|
| 56 | - } else { |
|
| 57 | - $content = $__video_h->fetch_video_rid($content['id']); |
|
| 58 | - $content['type'] = "video"; |
|
| 59 | - } |
|
| 52 | + if((int)$content['id']) { |
|
| 53 | + $content = $__video_h->fetch_comment_id($content['id']); |
|
| 54 | + $content['video'] = $__video_h->fetch_video_rid($content['toid']); |
|
| 55 | + $content['type'] = "comment"; |
|
| 56 | + } else { |
|
| 57 | + $content = $__video_h->fetch_video_rid($content['id']); |
|
| 58 | + $content['type'] = "video"; |
|
| 59 | + } |
|
| 60 | 60 | |
| 61 | - if($content['type'] == "video") { |
|
| 61 | + if($content['type'] == "video") { |
|
| 62 | 62 | ?> |
| 63 | 63 | <div class="feed-item-container" data-channel-key="UCc6W7efUSkd9YYoxOnctlFg"> |
| 64 | 64 | <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"> |
@@ -130,7 +130,7 @@ discard block |
||
| 130 | 130 | </div> |
| 131 | 131 | </div> |
| 132 | 132 | <?php } else { |
| 133 | - if($__video_h->video_exists($content['video']['rid'])) { ?> |
|
| 133 | + if($__video_h->video_exists($content['video']['rid'])) { ?> |
|
| 134 | 134 | <div class="feed-item-container" data-channel-key="UCXf1X2u5gsmuqcuTQlpOGhw"> |
| 135 | 135 | <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 | 136 | <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> |
@@ -301,13 +301,13 @@ discard block |
||
| 301 | 301 | <div class="module-view other-channels-view"> |
| 302 | 302 | <h2 <?php if(@$_SESSION['siteusername'] == $_user['username']) { ?>style="display: inline-block;position: relative;bottom: 10px;"<?php } ?>>Featured Channels</h2> |
| 303 | 303 | <?php if(@$_SESSION['siteusername'] == $_user['username']) { |
| 304 | - echo "<a href='#' style='float:right;font-size:11px;color:black;' onclick=';open_featured_channels();return false;'>edit</a>"; |
|
| 305 | - } ?> |
|
| 304 | + echo "<a href='#' style='float:right;font-size:11px;color:black;' onclick=';open_featured_channels();return false;'>edit</a>"; |
|
| 305 | + } ?> |
|
| 306 | 306 | <ul class="channel-summary-list "> |
| 307 | 307 | <?php |
| 308 | - foreach($_user['featured_channels'] as $user) { |
|
| 309 | - if($__user_h->user_exists($user)) { |
|
| 310 | - ?> |
|
| 308 | + foreach($_user['featured_channels'] as $user) { |
|
| 309 | + if($__user_h->user_exists($user)) { |
|
| 310 | + ?> |
|
| 311 | 311 | <li class="yt-tile-visible yt-uix-tile"> |
| 312 | 312 | <div class="channel-summary clearfix channel-summary-compact"> |
| 313 | 313 | <div class="channel-summary-thumb"> |
@@ -331,19 +331,19 @@ discard block |
||
| 331 | 331 | </div> |
| 332 | 332 | |
| 333 | 333 | <?php |
| 334 | - $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :search ORDER BY id DESC LIMIT 10"); |
|
| 335 | - $stmt->bindParam(":search", $_user['username']); |
|
| 336 | - $stmt->execute(); |
|
| 334 | + $stmt = $__db->prepare("SELECT * FROM playlists WHERE author = :search ORDER BY id DESC LIMIT 10"); |
|
| 335 | + $stmt->bindParam(":search", $_user['username']); |
|
| 336 | + $stmt->execute(); |
|
| 337 | 337 | |
| 338 | - if($stmt->rowCount() != 0) { |
|
| 339 | - ?> |
|
| 338 | + if($stmt->rowCount() != 0) { |
|
| 339 | + ?> |
|
| 340 | 340 | <div class="playlists-narrow channel-module yt-uix-c3-module-container"> |
| 341 | 341 | <div class="module-view gh-featured"> |
| 342 | 342 | <h2>Featured Playlists</h2> |
| 343 | 343 | <?php |
| 344 | - while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 345 | - $playlist['videos'] = json_decode($playlist['videos']); |
|
| 346 | - ?> |
|
| 344 | + while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 345 | + $playlist['videos'] = json_decode($playlist['videos']); |
|
| 346 | + ?> |
|
| 347 | 347 | <div class="playlist yt-tile-visible yt-uix-tile"> |
| 348 | 348 | <a href="/view_playlist?v=<?php echo $playlist['rid']; ?>"> |
| 349 | 349 | <span class="playlist-thumb-strip playlist-thumb-strip-252"><span class="videos videos-4 horizontal-cutoff"><span class="clip"><span class="centering-offset"><span class="centering"> |
@@ -47,9 +47,9 @@ discard block |
||
| 47 | 47 | $stmt->bindParam(":comment_username", $_user['username']); |
| 48 | 48 | $stmt->bindParam(":videos_username", $_user['username']); |
| 49 | 49 | $stmt->execute(); |
| 50 | - if($stmt->rowCount() == 0) { echo "<br><span style='color:grey;font-size:11px;'>This user has not done anything yet.</span>"; } |
|
| 51 | - while($content = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 52 | - if((int)$content['id']) { |
|
| 50 | + if ($stmt->rowCount() == 0) { echo "<br><span style='color:grey;font-size:11px;'>This user has not done anything yet.</span>"; } |
|
| 51 | + while ($content = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 52 | + if ((int) $content['id']) { |
|
| 53 | 53 | $content = $__video_h->fetch_comment_id($content['id']); |
| 54 | 54 | $content['video'] = $__video_h->fetch_video_rid($content['toid']); |
| 55 | 55 | $content['type'] = "comment"; |
@@ -58,7 +58,7 @@ discard block |
||
| 58 | 58 | $content['type'] = "video"; |
| 59 | 59 | } |
| 60 | 60 | |
| 61 | - if($content['type'] == "video") { |
|
| 61 | + if ($content['type'] == "video") { |
|
| 62 | 62 | ?> |
| 63 | 63 | <div class="feed-item-container" data-channel-key="UCc6W7efUSkd9YYoxOnctlFg"> |
| 64 | 64 | <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"> |
@@ -130,7 +130,7 @@ discard block |
||
| 130 | 130 | </div> |
| 131 | 131 | </div> |
| 132 | 132 | <?php } else { |
| 133 | - if($__video_h->video_exists($content['video']['rid'])) { ?> |
|
| 133 | + if ($__video_h->video_exists($content['video']['rid'])) { ?> |
|
| 134 | 134 | <div class="feed-item-container" data-channel-key="UCXf1X2u5gsmuqcuTQlpOGhw"> |
| 135 | 135 | <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 | 136 | <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> |
@@ -236,7 +236,7 @@ discard block |
||
| 236 | 236 | </div> |
| 237 | 237 | <hr class="yt-horizontal-rule "> |
| 238 | 238 | </div> |
| 239 | - <?php if(!empty($_user['website'])) { ?> |
|
| 239 | + <?php if (!empty($_user['website'])) { ?> |
|
| 240 | 240 | <div class="user-profile-item"> |
| 241 | 241 | <div class="yt-c3-profile-custom-url field-container "> |
| 242 | 242 | <a href="<?php echo addhttp(htmlspecialchars($_user['website'])); ?>" rel="me nofollow" target="_blank" title="<?php echo htmlspecialchars($_user['website']); ?>" class="yt-uix-redirect-link"> |
@@ -285,7 +285,7 @@ discard block |
||
| 285 | 285 | <h5>Country</h5> |
| 286 | 286 | <span class="value"><?php echo htmlspecialchars($_user['country']); ?></span> |
| 287 | 287 | </div> |
| 288 | - <?php if($_user['genre'] != "none") { ?> |
|
| 288 | + <?php if ($_user['genre'] != "none") { ?> |
|
| 289 | 289 | <div class="user-profile-item "> |
| 290 | 290 | <h5>Channel Genre</h5> |
| 291 | 291 | <span class="value"><?php echo htmlspecialchars(ucfirst($_user['genre'])); ?></span> |
@@ -297,16 +297,16 @@ discard block |
||
| 297 | 297 | </div> |
| 298 | 298 | <div class="channel-module other-channels yt-uix-c3-module-container other-channels-compact"> |
| 299 | 299 | <?php $_user['featured_channels'] = explode(",", $_user['featured_channels']); ?> |
| 300 | - <?php if(count($_user['featured_channels']) != 0) { ?> |
|
| 300 | + <?php if (count($_user['featured_channels']) != 0) { ?> |
|
| 301 | 301 | <div class="module-view other-channels-view"> |
| 302 | - <h2 <?php if(@$_SESSION['siteusername'] == $_user['username']) { ?>style="display: inline-block;position: relative;bottom: 10px;"<?php } ?>>Featured Channels</h2> |
|
| 303 | - <?php if(@$_SESSION['siteusername'] == $_user['username']) { |
|
| 302 | + <h2 <?php if (@$_SESSION['siteusername'] == $_user['username']) { ?>style="display: inline-block;position: relative;bottom: 10px;"<?php } ?>>Featured Channels</h2> |
|
| 303 | + <?php if (@$_SESSION['siteusername'] == $_user['username']) { |
|
| 304 | 304 | echo "<a href='#' style='float:right;font-size:11px;color:black;' onclick=';open_featured_channels();return false;'>edit</a>"; |
| 305 | 305 | } ?> |
| 306 | 306 | <ul class="channel-summary-list "> |
| 307 | 307 | <?php |
| 308 | - foreach($_user['featured_channels'] as $user) { |
|
| 309 | - if($__user_h->user_exists($user)) { |
|
| 308 | + foreach ($_user['featured_channels'] as $user) { |
|
| 309 | + if ($__user_h->user_exists($user)) { |
|
| 310 | 310 | ?> |
| 311 | 311 | <li class="yt-tile-visible yt-uix-tile"> |
| 312 | 312 | <div class="channel-summary clearfix channel-summary-compact"> |
@@ -335,13 +335,13 @@ discard block |
||
| 335 | 335 | $stmt->bindParam(":search", $_user['username']); |
| 336 | 336 | $stmt->execute(); |
| 337 | 337 | |
| 338 | - if($stmt->rowCount() != 0) { |
|
| 338 | + if ($stmt->rowCount() != 0) { |
|
| 339 | 339 | ?> |
| 340 | 340 | <div class="playlists-narrow channel-module yt-uix-c3-module-container"> |
| 341 | 341 | <div class="module-view gh-featured"> |
| 342 | 342 | <h2>Featured Playlists</h2> |
| 343 | 343 | <?php |
| 344 | - while($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 344 | + while ($playlist = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 345 | 345 | $playlist['videos'] = json_decode($playlist['videos']); |
| 346 | 346 | ?> |
| 347 | 347 | <div class="playlist yt-tile-visible yt-uix-tile"> |
@@ -50,12 +50,12 @@ |
||
| 50 | 50 | |
| 51 | 51 | /* put tis in a better spot */ |
| 52 | 52 | $stmt = $__db->prepare("SELECT * FROM bans WHERE username = :username ORDER BY id DESC"); |
| 53 | - $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 54 | - $stmt->execute(); |
|
| 53 | + $stmt->bindParam(":username", $_SESSION['siteusername']); |
|
| 54 | + $stmt->execute(); |
|
| 55 | 55 | |
| 56 | - while($ban = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 56 | + while($ban = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 57 | 57 | $ban_info = $ban; |
| 58 | 58 | if($_SERVER['REQUEST_URI'] != "/ban") |
| 59 | - header("Location: /ban"); |
|
| 60 | - } |
|
| 59 | + header("Location: /ban"); |
|
| 60 | + } |
|
| 61 | 61 | ?> |
| 62 | 62 | \ No newline at end of file |
@@ -23,15 +23,15 @@ discard block |
||
| 23 | 23 | "db_connected" => false, |
| 24 | 24 | ], |
| 25 | 25 | |
| 26 | - "video_properties" => (object) [ "status" => "unloaded" ], |
|
| 27 | - "user_properties" => (object) [ "status" => "unloaded" ], |
|
| 28 | - "group_properties" => (object) [ "status" => "unloaded" ], |
|
| 29 | - "forum_properties" => (object) [ "status" => "unloaded" ], |
|
| 26 | + "video_properties" => (object) ["status" => "unloaded"], |
|
| 27 | + "user_properties" => (object) ["status" => "unloaded"], |
|
| 28 | + "group_properties" => (object) ["status" => "unloaded"], |
|
| 29 | + "forum_properties" => (object) ["status" => "unloaded"], |
|
| 30 | 30 | ]; |
| 31 | 31 | |
| 32 | 32 | try |
| 33 | 33 | { |
| 34 | - $__db = new PDO("mysql:host=".$__server->db_properties->db_host.";dbname=".$__server->db_properties->db_database.";charset=utf8mb4", |
|
| 34 | + $__db = new PDO("mysql:host=" . $__server->db_properties->db_host . ";dbname=" . $__server->db_properties->db_database . ";charset=utf8mb4", |
|
| 35 | 35 | $__server->db_properties->db_user, |
| 36 | 36 | $__server->db_properties->db_password, |
| 37 | 37 | [ |
@@ -41,9 +41,9 @@ discard block |
||
| 41 | 41 | ); |
| 42 | 42 | $__server->db_properties->db_connected = true; |
| 43 | 43 | } |
| 44 | - catch(PDOException $e) |
|
| 44 | + catch (PDOException $e) |
|
| 45 | 45 | { |
| 46 | - die("An error occured connecting to the database: ".$e->getMessage()); |
|
| 46 | + die("An error occured connecting to the database: " . $e->getMessage()); |
|
| 47 | 47 | } |
| 48 | 48 | |
| 49 | 49 | session_start(); |
@@ -53,9 +53,9 @@ discard block |
||
| 53 | 53 | $stmt->bindParam(":username", $_SESSION['siteusername']); |
| 54 | 54 | $stmt->execute(); |
| 55 | 55 | |
| 56 | - while($ban = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 56 | + while ($ban = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
| 57 | 57 | $ban_info = $ban; |
| 58 | - if($_SERVER['REQUEST_URI'] != "/ban") |
|
| 58 | + if ($_SERVER['REQUEST_URI'] != "/ban") |
|
| 59 | 59 | header("Location: /ban"); |
| 60 | 60 | } |
| 61 | 61 | ?> |
| 62 | 62 | \ No newline at end of file |
@@ -40,8 +40,7 @@ discard block |
||
| 40 | 40 | ] |
| 41 | 41 | ); |
| 42 | 42 | $__server->db_properties->db_connected = true; |
| 43 | - } |
|
| 44 | - catch(PDOException $e) |
|
| 43 | + } catch(PDOException $e) |
|
| 45 | 44 | { |
| 46 | 45 | die("An error occured connecting to the database: ".$e->getMessage()); |
| 47 | 46 | } |
@@ -55,7 +54,8 @@ discard block |
||
| 55 | 54 | |
| 56 | 55 | while($ban = $stmt->fetch(PDO::FETCH_ASSOC)) { |
| 57 | 56 | $ban_info = $ban; |
| 58 | - if($_SERVER['REQUEST_URI'] != "/ban") |
|
| 59 | - header("Location: /ban"); |
|
| 57 | + if($_SERVER['REQUEST_URI'] != "/ban") { |
|
| 58 | + header("Location: /ban"); |
|
| 59 | + } |
|
| 60 | 60 | } |
| 61 | 61 | ?> |
| 62 | 62 | \ No newline at end of file |
@@ -8,10 +8,10 @@ |
||
| 8 | 8 | <?php $__db_h = new db_helper(); ?> |
| 9 | 9 | <?php $__time_h = new time_helper(); ?> |
| 10 | 10 | <?php |
| 11 | - $__server->page_embeds->page_title = "SubRocks - Replace me"; |
|
| 12 | - $__server->page_embeds->page_description = "SubRocks is a site dedicated to bring back the 2012 layout of YouTube."; |
|
| 13 | - $__server->page_embeds->page_image = "/yt/imgbin/full-size-logo.png"; |
|
| 14 | - $__server->page_embeds->page_url = "https://subrock.rocks/"; |
|
| 11 | + $__server->page_embeds->page_title = "SubRocks - Replace me"; |
|
| 12 | + $__server->page_embeds->page_description = "SubRocks is a site dedicated to bring back the 2012 layout of YouTube."; |
|
| 13 | + $__server->page_embeds->page_image = "/yt/imgbin/full-size-logo.png"; |
|
| 14 | + $__server->page_embeds->page_url = "https://subrock.rocks/"; |
|
| 15 | 15 | ?> |
| 16 | 16 | <!DOCTYPE html> |
| 17 | 17 | <html> |
@@ -14,8 +14,8 @@ discard block |
||
| 14 | 14 | "status" => 201, |
| 15 | 15 | ]; |
| 16 | 16 | |
| 17 | -if(!isset($_GET['u'])) { $response->status = 400; die(json_encode($response)); } |
|
| 18 | -if(!$__user_h->user_exists($_GET['u'])) { $response->status = 400; die(json_encode($response)); } |
|
| 17 | +if (!isset($_GET['u'])) { $response->status = 400; die(json_encode($response)); } |
|
| 18 | +if (!$__user_h->user_exists($_GET['u'])) { $response->status = 400; die(json_encode($response)); } |
|
| 19 | 19 | |
| 20 | 20 | $_user = $__user_h->fetch_user_username($_GET['u']); |
| 21 | 21 | $response = (object) [ |
@@ -40,7 +40,7 @@ discard block |
||
| 40 | 40 | $_user['featured_channels'] = explode($_user['featured_channels'], ","); |
| 41 | 41 | $_user['featured_channels_object'] = (object) []; |
| 42 | 42 | $i = 0; |
| 43 | -foreach($_user['featured_channels'] as $channel) { |
|
| 43 | +foreach ($_user['featured_channels'] as $channel) { |
|
| 44 | 44 | $_user['featured_channels_object']->$i = $channel; |
| 45 | 45 | } |
| 46 | 46 | |