Added WizardBot V2 cookies leaderboard

author: LinuxWizard42 <linuxwizard@voidnet.dy.fi> 2022-12-01 22:00:45 +0200
committer: LinuxWizard42 <linuxwizard@voidnet.dy.fi> 2022-12-01 22:00:45 +0200
commit: 58eb6467bf81ba4cced837e42b38f6c08d4aaf26 (patch)
tree: 71cb4b80097d28a4cceebe528a27946e59ed26fe
parent: 514ae3bf94470b367f63372d06779e42db650d3e (diff)
download: VoidNet_Site-58eb6467bf81ba4cced837e42b38f6c08d4aaf26.tar.gz
VoidNet_Site-58eb6467bf81ba4cced837e42b38f6c08d4aaf26.tar.zst
5 files changed, 101 insertions, 3 deletions
diff --git a/.gitignore b/.gitignore
new file mode 100644
index 0000000..e157f50
--- /dev/null
+++ b/.gitignore
@@ -0,0 +1 @@
+inc/*
+\ No newline at end of file
diff --git a/flashrunner/index.html b/flashrunner/index.html
index 7203072..ef790f0 100644
--- a/flashrunner/index.html
+++ b/flashrunner/index.html
@@ -42,7 +42,7 @@
 <center>
 <br/>
 <div class="container-fluid">
-<img src="../img/flashrunner.png" class="img-thumbnail img-fluid"></img>
+<img src="/img/flashrunner.png" class="img-thumbnail img-fluid"></img>
 </div>
 <br/>
 <h1 class="wtext content_title">FlashRunner</h1>
diff --git a/wizardbot/index.html b/wizardbot/index.html
index 7fcfdfb..0aa672b 100644
--- a/wizardbot/index.html
+++ b/wizardbot/index.html
@@ -15,7 +15,7 @@
 <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>
+<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">
diff --git a/wizardbotv2/index.html b/wizardbotv2/index.html
index 47d0193..304db40 100644
--- a/wizardbotv2/index.html
+++ b/wizardbotv2/index.html
@@ -15,7 +15,7 @@
 <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>
+<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">
@@ -47,6 +47,9 @@ WizardBot V2 is the second version of twitch bot made by VoidNet owner.
 Programming language the bot is written in: C
 <br/>
 <br/>
+<a href="/wizardbotv2/leaderboard" target="_blank">WizardBot V2 Cookies Leaderboard</a>
+<br/>
+<br/>
 <b>List of WizardBot V2 commands</b>
 <hr width="90%"></hr>
 <br/>
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>
author	LinuxWizard42 <linuxwizard@voidnet.dy.fi>	2022-12-01 22:00:45 +0200
committer	LinuxWizard42 <linuxwizard@voidnet.dy.fi>	2022-12-01 22:00:45 +0200
commit	58eb6467bf81ba4cced837e42b38f6c08d4aaf26 (patch)
tree	71cb4b80097d28a4cceebe528a27946e59ed26fe
parent	514ae3bf94470b367f63372d06779e42db650d3e (diff)
download	VoidNet_Site-58eb6467bf81ba4cced837e42b38f6c08d4aaf26.tar.gz VoidNet_Site-58eb6467bf81ba4cced837e42b38f6c08d4aaf26.tar.zst