diff options
Diffstat (limited to 'wizardbotv2/leaderboard/index.php')
| -rw-r--r-- | wizardbotv2/leaderboard/index.php | 94 |
1 files changed, 94 insertions, 0 deletions
diff --git a/wizardbotv2/leaderboard/index.php b/wizardbotv2/leaderboard/index.php new file mode 100644 index 0000000..26967b0 --- /dev/null +++ b/wizardbotv2/leaderboard/index.php @@ -0,0 +1,94 @@ +<!DOCTYPE html> +<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> +<meta name="referrer" content="same-origin"/> +<meta name="viewport" content="width=device-width, initial-scale=0.7"/> +<meta name="description" content="VoidNet Server Network"/> +<meta name="og:title" content="VoidNet"/> +<meta name="og:description" content="VoidNet Server Network"/> +<html> +<head> +<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap/5.2.3/js/bootstrap.bundle.min.js" crossorigin="anonymous" referrerpolicy="no-referrer" type="text/javascript"></script> +<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap/5.2.3/css/bootstrap.min.css" crossorigin="anonymous" referrerpolicy="no-referrer" type="text/css"/> +<link rel="stylesheet" href="/css/voidnet.css" type="text/css"/> +<title>WizardBot V2 - VoidNet</title> +</head> +<body> +<nav class="navbar navbar-dark dark_navbar navbar-expand-lg mb-2 shadow"> +<div class="container-fluid"> +<img class="navbar_logo" src="/img/voidnet_logo.png"></img> +<button class="navbar-toggler me-auto" type="button" data-bs-toggle="collapse" data-bs-target="#mnav"><span class="wtext">Menu</span></button> +<div class="collapse navbar-collapse" id="mnav"> +<ul class="navbar-nav me-auto"> +<li class="nav-item"><a class="nav-link navbar_link" href="/index.html">Home</a></li> +<li class="nav-item"><a class="nav-link navbar_link" href="/servers">Servers</a></li> +<li class="nav-item"><a class="nav-link navbar_link" href="/software">Software</a></li> +<li class="nav-item dropdown"> +<a href="#" class="nav-link navbar_link dropdown-toggle" data-bs-toggle="dropdown">Other</a> +<ul class="dropdown-menu dark_navbar"> +<li><a href="/server-status" class="dropdown-item wtext dropdown_item_transition">Server status</a></li> +<li><a class="dropdown-item wtext dropdown_item_transition" href="https://twitter.com/VoidNetServers" target="_blank" rel="noopener noreferer">VoidNet Twitter</a></li> +<li><a class="dropdown-item wtext dropdown_item_transition" href="https://discord.gg/dZ7Kd2RqSv" target="_blank" rel="noopener noreferer">VoidNet Discord</a></li> +<li><a class="dropdown-item wtext dropdown_item_transition" href="/contact">Contact</a></li> +<li><a class="dropdown-item wtext dropdown_item_transition" href="/about">About</a></li> +</ul> +</li> +</ul> +</div> +</div> +</nav> +<div class="container-fluid h-100"> +<div class="container-fluid w-100 mb-4 content_box shadow rounded-2"> +<center> +<h1 class="wtext content_title">WizardBot V2 Cookies Leaderboard</h1> +<br/> +<div class="table-responsive"> +<table class="table table-striped table-bordered table-dark table-hover w-100"> +<thead> +<tr><th><center><span class="h5">#</span></center></th><th><center><span class="h5">User</span></center></th><th><center><span class="h5">Cookies</span></center></th></tr> +</thead> +<tbody> +<?php +require_once( '../../inc/connections.php' ); +require_once( '../../inc/queries.php' ); +$db_conn = new PDO( WIZARDBOTV2 ); +if ( $db_conn !== false ){ + $db_query_prepared = $db_conn->prepare( COOKIES_TOP ); + $query_exec_res = $db_query_prepared->execute(); + if ( $query_exec_res !== false ){ + if ( $db_query_prepared->rowCount() > 0 ){ + $query_res = $db_query_prepared->fetchAll( PDO::FETCH_ASSOC ); + $safe_name = NULL; + $user_position = 1; + foreach ( $query_res as $userdata ){ + $safe_name = htmlspecialchars( $userdata['username'] ); + echo '<tr><td><center><span class="h5">' . $user_position . '</span></center></td><td><a href="https://www.twitch.tv/'. $safe_name . '" rel="noopener noreferrer nofollow" target="_blank">' . $safe_name . '</a></td><td>' . $userdata['user_cookies'] . '</td></tr>'; + $user_position += 1; + } + unset( $query_res, $safe_name, $user_position ); + } + else + { + echo '<tr><td>No users found</td></tr>'; + } + } + else + { + echo '<tr><td>Error: failed to query</td></tr>'; + } + unset( $db_query_prepared, $query_exec_res, $db_conn ); +} +else +{ + unset( $db_conn ); + echo '<tr><td>Error: failed to connect to database.</td></tr>'; +} +?> +</table> +</div> +</span> +</center> +<br/> +</div> +</div> +</body> +</html> |