Files
.gitignore
main.py
README.md
requirements.txt
Code
4 435
main.py
import logging
import os
import sqlite3
from pathlib import Path
import discord
from discord import app_commands
from discord.ext import commands
from dotenv import load_dotenv
KITS = (
"Crystal",
"Sword",
"Axe",
"Mace",
"NethOP",
"UHC",
"Creeper",
"DiaSMP",
"Speed",
)
TIERS = ("HT1", "LT1", "HT2", "LT2", "HT3", "LT3", "HT4", "LT4", "HT5", "LT5")
KIT_CHOICES = tuple(app_commands.Choice(name=kit, value=kit) for kit in KITS)
TIER_CHOICES = tuple(app_commands.Choice(name=tier, value=tier) for tier in TIERS)
DATABASE_PATH = Path("pvp_tiers.sqlite3")
logging.basicConfig(
level=logging.INFO,
format="%(asctime)s %(levelname)s %(name)s: %(message)s",
)
logger = logging.getLogger("rebornvanilla-tier-test")
class TierDatabase:
def __init__(self, path: Path) -> None:
self.path = path
def initialize(self) -> None:
with sqlite3.connect(self.path) as connection:
connection.executescript(
"""
CREATE TABLE IF NOT EXISTS queue_entries (
id INTEGER PRIMARY KEY AUTOINCREMENT,
guild_id INTEGER NOT NULL,
kit TEXT NOT NULL,
user_id INTEGER NOT NULL,
username TEXT NOT NULL,
UNIQUE(guild_id, kit, user_id)
);
CREATE TABLE IF NOT EXISTS test_results (
id INTEGER PRIMARY KEY AUTOINCREMENT,
guild_id INTEGER NOT NULL,
player_id INTEGER NOT NULL,
player_name TEXT NOT NULL,
kit TEXT NOT NULL,
tier TEXT NOT NULL,
tester_id INTEGER NOT NULL,
tester_name TEXT NOT NULL,
notes TEXT NOT NULL DEFAULT '',
recorded_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP
);
CREATE INDEX IF NOT EXISTS test_results_lookup
ON test_results(guild_id, player_id, kit, id);
CREATE TABLE IF NOT EXISTS tester_roles (
guild_id INTEGER PRIMARY KEY,
role_id INTEGER NOT NULL
);
"""
)
def join_queue(self, guild_id: int, kit: str, user_id: int, username: str) -> bool:
with sqlite3.connect(self.path) as connection:
cursor = connection.execute(
"INSERT OR IGNORE INTO queue_entries (guild_id, kit, user_id, username) VALUES (?, ?, ?, ?)",
(guild_id, kit, user_id, username),
)
return cursor.rowcount == 1
def leave_queue(self, guild_id: int, kit: str, user_id: int) -> bool:
with sqlite3.connect(self.path) as connection:
cursor = connection.execute(
"DELETE FROM queue_entries WHERE guild_id = ? AND kit = ? AND user_id = ?",
(guild_id, kit, user_id),
)
return cursor.rowcount == 1
def queued_users(self, guild_id: int, kit: str) -> list[int]:
with sqlite3.connect(self.path) as connection:
rows = connection.execute(
"SELECT user_id FROM queue_entries WHERE guild_id = ? AND kit = ? ORDER BY id",
(guild_id, kit),
).fetchall()
return [row[0] for row in rows]
def set_tester_role(self, guild_id: int, role_id: int) -> None:
with sqlite3.connect(self.path) as connection:
connection.execute(
"INSERT INTO tester_roles (guild_id, role_id) VALUES (?, ?) "
"ON CONFLICT(guild_id) DO UPDATE SET role_id = excluded.role_id",
(guild_id, role_id),
)
def tester_role(self, guild_id: int) -> int | None:
with sqlite3.connect(self.path) as connection:
row = connection.execute(
"SELECT role_id FROM tester_roles WHERE guild_id = ?",
(guild_id,),
).fetchone()
return row[0] if row else None
def record_result(
self,
guild_id: int,
player: discord.Member,
kit: str,
tier: str,
tester: discord.Member,
notes: str,
) -> None:
with sqlite3.connect(self.path) as connection:
connection.execute(
"INSERT INTO test_results "
"(guild_id, player_id, player_name, kit, tier, tester_id, tester_name, notes) "
"VALUES (?, ?, ?, ?, ?, ?, ?, ?)",
(
guild_id,
player.id,
player.display_name,
kit,
tier,
tester.id,
tester.display_name,
notes,
),
)
def latest_result(self, guild_id: int, player_id: int, kit: str) -> sqlite3.Row | None:
with sqlite3.connect(self.path) as connection:
connection.row_factory = sqlite3.Row
return connection.execute(
"SELECT tier, tester_id, tester_name, notes, recorded_at "
"FROM test_results WHERE guild_id = ? AND player_id = ? AND kit = ? "
"ORDER BY id DESC LIMIT 1",
(guild_id, player_id, kit),
).fetchone()
class TierTestingBot(commands.Bot):
def __init__(self) -> None:
intents = discord.Intents.none()
intents.guilds = True
super().__init__(command_prefix=commands.when_mentioned, intents=intents)
self.db = TierDatabase(DATABASE_PATH)
async def setup_hook(self) -> None:
self.db.initialize()
for kit in KITS:
self.add_view(QueueView(self, kit))
await self.tree.sync()
logger.info("Slash commands synced; persistent queue buttons registered")
async def on_ready(self) -> None:
logger.info("Connected as %s", self.user)
print("KODARI_READY", flush=True)
def queue_embed(self, guild_id: int, kit: str) -> discord.Embed:
users = self.db.queued_users(guild_id, kit)
embed = discord.Embed(
title=f"{kit} Testing Queue",
description="Join the queue below when you are ready for a tier test.",
color=discord.Color.from_rgb(0, 220, 230),
)
if users:
displayed = [f"**{index}.** <@{user_id}>" for index, user_id in enumerate(users[:20], 1)]
if len(users) > 20:
displayed.append(f"…and {len(users) - 20} more")
embed.add_field(name=f"Players ({len(users)})", value="\n".join(displayed), inline=False)
else:
embed.add_field(name="Players (0)", value="The queue is empty.", inline=False)
embed.set_footer(text="Queue positions are saved between bot restarts.")
return embed
class QueueView(discord.ui.View):
def __init__(self, bot: TierTestingBot, kit: str) -> None:
super().__init__(timeout=None)
self.bot = bot
self.kit = kit
kit_id = kit.lower()
join_button = discord.ui.Button(
label="Join Queue",
style=discord.ButtonStyle.success,
custom_id=f"tier-queue:join:{kit_id}",
)
join_button.callback = self.join_queue
self.add_item(join_button)
leave_button = discord.ui.Button(