# -*- coding: utf-8 -*- """ APMC DISCORD BOT - THE ULTIMATE EDITION (v11.0 - QUEUE + WAITLIST + TESTER PANELS) ====================================================================================== """ import discord from discord import app_commands from discord.ext import tasks from discord.ui import Modal, TextInput, View, Select, Button import datetime import random import asyncio import io import difflib import os import sys import traceback import aiohttp from typing import Optional, List, Dict, Any, Union from supabase import create_client, Client as SupabaseClient # ========================================================================= # SECTION 1: SYSTEM CONFIGURATION & CONSTANTS # ========================================================================= SUPABASE_URL = "https://uofqutzrympeaamcdpbg.supabase.co" SUPABASE_KEY = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6InVvZnF1dHpyeW1wZWFhbWNkcGJnIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImlhdCI6MTc2ODY1NDI3NCwiZXhwIjoyMDg0MjMwMjc0fQ.CeNJ4TtwyF552pkfKmsmlj3mgTu7zeNjRFcGAm7X99Q" BOT_TOKEN = "MTQ1NzgxMzk5NTQyNjgxMjAyNg.GbaESO.R6a3jw0Cf5MiUHWNQXSsnuqjnoBL63z5VUuqT4" ID_ROLE_OWNER = 1428410174791483515 ID_ROLE_CO_FOUNDER = 1464311663539781694 ID_ROLE_ADMIN = 1428414388615905290 ID_ROLE_MOD = 1452134215494668369 ID_ROLE_DEV = 1428414630354616320 ROLE_TESTER = "TIER TESTER" ROLE_VERIFIED = "verified Member" ROLE_UNVERIFIED = "Unverified" ROLE_NUKE_SHELTER = "nuke shelter" ROLE_ANTI_NUKE = "Anti nuke (DO NOT TO TOUCH THIS ROLE)" ROLE_PRIME = "Prime Member" CHANNEL_RESULTS = "📝┃results" CHANNEL_TICKET_PANEL = "🎟️┃create-ticket" CHANNEL_WELCOME = "🫂┃welcome" CHANNEL_PARTICIPATION = "🙌┃participation" CHANNEL_NEW_EVENT = "📩┃new-event" CHANNEL_NEW_TOURNEY = "📩┃new-tournaments" CHANNEL_LOGS = "server-logs" CHANNEL_GENERAL = "💬┃general" CATEGORY_NATIVE = "Tickets for NATIVE" CATEGORY_CROSS = "Tickets for CROSS" CATEGORY_SUPPORT = "✨➢ Support" CATEGORY_STAFF = "Staff application ticket" CATEGORY_PRIORITY = "Priority Testes" WELCOME_IMAGE_URL = "https://i.ibb.co/Jj2XsBK0/Video-Guru-20260112-162632603.gif" VERIFY_IMAGE_URL = "https://i.ibb.co/99pnjrV8/Video-Generation-Loop-Completed-1.gif" SERVER_INVITE_LINK = "https://discord.gg/2szBXm4JvP" STEVE_SKIN_URL = "https://minotar.net/armor/bust/MHF_Steve/150.png" def mc_skin_url(username: str) -> str: if not username or username.strip().lower() in ("", "unknown", "n/a"): return STEVE_SKIN_URL clean = username.strip() return f"https://minotar.net/armor/bust/{clean}/150.png" WELCOME_MESSAGES = [ "It is an absolute honor to have you join our ranks. Welcome to the elite community of APMC.", "A new chapter begins! We are thrilled to welcome you to the APMC family.", "The arena awaits! Welcome, challenger, to the official APMC server.", "Step in and prepare yourself. The APMC community extends its warmest regards." ] GAMEMODE_ROLES = { "CRYSTAL": "CRYSTAL TESTER", "MACE": "MACE TESTER", "AXE": "AXE TESTER", "TANK": "TANK TESTER", "CART": "CART TESTER", "SMP": "SMP TESTER", "DIA": "DIA SMP TESTER", "NETHPOT": "NETHPOT TESTER", "UHC": "UHC TESTER", "SKYWARS": "SKYWARS TESTER", "BOXING": "BOXING TESTER", "SUMO": "SUMO TESTER", "SPEAR": "SPEAR TESTER", "OTHER": None } GAME_MODES = list(GAMEMODE_ROLES.keys()) WAITLIST_ROLE_PREFIX = "WL-" TIER_POINTS_MAP = { "HT1": 50, "LT1": 42, "HT2": 32, "LT2": 24, "HT3": 17, "LT3": 12, "HT4": 8, "LT4": 4, "HT5": 2, "LT5": 1 } TIER_TESTING_RULES = """**📊 Tier Testing Rules** ───────────────────────────────────── • You can schedule another test in **1 week** prior to your last. • You must use the **preset assigned** for each gamemode. • **No cheats** of any kind are allowed (e.g., Auto-Totem, autoclicking, etc.). • The use of **alternate accounts (alts)** is not permitted unless the identity is known. • Every **playstyle** is allowed in any gamemode, unless it's counted as a cheat. • There is **no rule** that java players cannot test bedrock ones — they will adjust the tier accordingly. • The **preferred server** is selected by the player, not the tester. • **Low tier tests** are based on a player's skills, not scores. • The **maximum tier** a player can get in a low tier test is **LT3**. • **FT3 is optional**. It can be more or less, according to the gamemode. • **High tier tests** are only taken if the player is **LT3 or above**. • A tester **cannot test the same person** multiple times in a single gamemode. 🚫 *Failure to follow these rules will result in a ban from tier testing until further notice.* -# Rules are subject to common sense. Attempting to find loopholes or bypass these rules will lead to disqualification from the tier test.""" # ========================================================================= # SECTION 2: DATABASE CONNECTION & HELPERS # ========================================================================= try: print("⏳ [SYSTEM] Initializing Supabase Connection...") supabase: SupabaseClient = create_client(SUPABASE_URL, SUPABASE_KEY) print("✅ [SYSTEM] Supabase Client Initialized Successfully.") except Exception as e: print(f"❌ [CRITICAL ERROR] Failed to initialize Supabase: {e}") def get_combat_rank(points: int) -> str: if points >= 350: return "COMBAT GRANDMASTER" if points >= 300: return "COMBAT MASTER" if points >= 220: return "COMBAT ACE" if points >= 120: return "COMBAT SPECIALIST" if points >= 60: return "COMBAT CADET" if points >= 21: return "COMBAT NOVICE" return "ROOKIE" def calculate_auto_points(role_name: str) -> int: role_upper = role_name.upper() for key, points in TIER_POINTS_MAP.items(): if key in role_upper: return points return 0 def get_leaderboard_rank(user_id: int) -> str: try: response = supabase.table("user_profiles").select("user_id").order("points", desc=True).execute() all_ids = [row['user_id'] for row in response.data] if user_id in all_ids: return f"#{all_ids.index(user_id) + 1}" return "Unranked" except Exception as e: print(f"Leaderboard Calculation Error: {e}") return "Unranked" async def send_log(guild: discord.Guild, title: str, description: str, color=discord.Color.dark_grey(), file=None): log_channel = discord.utils.get(guild.text_channels, name=CHANNEL_LOGS) if log_channel: embed = discord.Embed(title=title, description=description, color=color, timestamp=discord.utils.utcnow()) embed.set_footer(text="APMC Security & Logging System") embed.set_thumbnail(url=guild.icon.url if guild.icon else None) try: if file: await log_channel.send(embed=embed, file=file) else: await log_channel.send(embed=embed) except Exception as e: print(f"Failed to send log to {CHANNEL_LOGS}: {e}") async def alert_admins(guild: discord.Guild, title: str, description: str): embed = discord.Embed(title=f"🚨 CRITICAL ALERT: {title}", description=description, color=discord.Color.red()) embed.set_footer(text=f"Server: {guild.name} | Timestamp: {datetime.datetime.now()}") target_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_DEV, ID_ROLE_CO_FOUNDER] count = 0 for member in guild.members: if member.bot: continue if any(role.id in target_ids for role in member.roles): try: await member.send(embed=embed) count += 1 except: pass print(f"Alerted {count} admins via DM.") def log_event_to_db(event_name, action, details): try: supabase.table("event_logs").insert({ "event_name": event_name, "action": action, "details": details, "timestamp": datetime.datetime.now().isoformat() }).execute() except Exception as e: print(f"DB Log Error: {e}") def get_waitlist_role_name(gamemode: str) -> str: return f"{WAITLIST_ROLE_PREFIX}{gamemode.upper()}" async def ensure_waitlist_role(guild: discord.Guild, gamemode: str) -> discord.Role: role_name = get_waitlist_role_name(gamemode) role = discord.utils.get(guild.roles, name=role_name) if not role: role = await guild.create_role(name=role_name, mentionable=False, reason="Auto-created waitlist role") return role async def get_queue_channel(guild: discord.Guild, gamemode: str) -> Optional[discord.TextChannel]: chan_name = f"queue-{gamemode.lower()}" return discord.utils.get(guild.text_channels, name=chan_name) async def get_tester_panel_channel(guild: discord.Guild, gamemode: str) -> Optional[discord.TextChannel]: chan_name = f"tester-panel-{gamemode.lower()}" return discord.utils.get(guild.text_channels, name=chan_name) def build_queue_embed(gamemode: str, queue_data: list, active_testers: list, is_open: bool, last_refresh: str) -> discord.Embed: if not is_open: embed = discord.Embed( title=f"🔒 {gamemode} Queue Closed", description="This testing session has ended. You will be notified here when a new queue opens.", color=discord.Color.dark_grey() ) embed.add_field(name="📋 Reason", value="Queue manually ended by command", inline=False) embed.add_field(name="🕐 Session Ended", value=datetime.datetime.now().strftime("%d %B %Y at %I:%M %p"), inline=False) embed.set_footer(text="Thank you for testing!") return embed embed = discord.Embed( title=f"✅ {gamemode} Tester Available!", description=f"**@here** a **{gamemode}** queue is open!\n\nThe queue is now open and updates in real-time.", color=discord.Color.green() ) queue_text = "" if queue_data: for idx, entry in enumerate(queue_data): prime_tag = " 👑" if entry.get("is_prime") else "" queue_text += f"{idx+1}. <@{entry['user_id']}>{prime_tag}\n" else: queue_text = "*No players in queue yet.*" embed.add_field(name="📋 Queue", value=queue_text, inline=True) tester_text = "" if active_testers: for t in active_testers: tester_text += f"• <@{t['tester_id']}>\n" else: tester_text = "*No active testers*" embed.add_field(name="⚔️ Active Testers", value=tester_text, inline=True) embed.set_footer(text=f"🌐 Region: Global | 🕐 Last Refresh: {last_refresh}") return embed def build_tester_control_embed(gamemode: str, queue_data: list, is_open: bool, active_testers: list) -> discord.Embed: embed = discord.Embed( title=f"🎮 {gamemode} Tester Control Panel", description=f"Manage the **{gamemode}** testing queue from this panel.", color=discord.Color.blurple() ) status = "🟢 **OPEN**" if is_open else "🔴 **CLOSED**" embed.add_field(name="Queue Status", value=status, inline=True) embed.add_field(name="Players in Queue", value=str(len(queue_data)), inline=True) embed.add_field(name="Active Testers", value=str(len(active_testers)), inline=True) if queue_data: next_entry = queue_data[0] embed.add_field( name="▶️ Next Player", value=f"<@{next_entry['user_id']}> | Joined: {next_entry.get('joined_at', 'Unknown')}", inline=False ) else: embed.add_field(name="▶️ Next Player", value="*Queue is empty*", inline=False) embed.set_footer(text="Use the buttons below to manage this session.") return embed # ========================================================================= # SECTION 3: FEEDBACK SYSTEM # ========================================================================= class FeedbackModal(Modal, title="Rate Your Experience"): comment = TextInput( label="Comments (Optional)", style=discord.TextStyle.paragraph, placeholder="How was the tester's service? Leave blank if you prefer.", required=False, max_length=500 ) def __init__(self, tester_id, stars): super().__init__() self.tester_id = tester_id self.stars = stars async def on_submit(self, interaction: discord.Interaction): try: supabase.table("tester_reviews").insert({ "tester_id": self.tester_id, "reviewer_id": interaction.user.id, "stars": self.stars, "comment": self.comment.value if self.comment.value else "No comment provided." }).execute() except Exception as e: print(f"DB Error on Review: {e}") try: tester = interaction.client.get_user(self.tester_id) if not tester: tester = await interaction.client.fetch_user(self.tester_id) if tester: embed = discord.Embed(title="🌟 New Review Received!", description="You have received feedback for a recent ticket.", color=discord.Color.gold()) embed.add_field(name="Rating", value=f"{'⭐' * self.stars} ({self.stars}/5)") embed.add_field(name="Reviewer", value=interaction.user.name) embed.add_field(name="Comment", value=f"_{self.comment.value if self.comment.value else 'No written comment'}_", inline=False) embed.set_footer(text="Keep up the good work!") await tester.send(embed=embed) except: pass await interaction.response.send_message("✅ **Feedback Received:** Thank you for helping us improve APMC! Your review has been logged.", ephemeral=True) class FeedbackView(View): def __init__(self, tester_id): super().__init__(timeout=None) self.tester_id = tester_id async def launch_modal(self, interaction: discord.Interaction, stars: int): await interaction.response.send_modal(FeedbackModal(self.tester_id, stars)) @discord.ui.button(label="1⭐", style=discord.ButtonStyle.danger) async def s1(self, i, b): await self.launch_modal(i, 1) @discord.ui.button(label="2⭐", style=discord.ButtonStyle.secondary) async def s2(self, i, b): await self.launch_modal(i, 2) @discord.ui.button(label="3⭐", style=discord.ButtonStyle.secondary) async def s3(self, i, b): await self.launch_modal(i, 3) @discord.ui.button(label="4⭐", style=discord.ButtonStyle.primary) async def s4(self, i, b): await self.launch_modal(i, 4) @discord.ui.button(label="5⭐", style=discord.ButtonStyle.success) async def s5(self, i, b): await self.launch_modal(i, 5) # ========================================================================= # SECTION 4: SKIP REPORT SYSTEM # ========================================================================= class SkipReasonModal(Modal, title="Skip Player — Reason Required"): reason = TextInput( label="Reason for Skipping", style=discord.TextStyle.paragraph, placeholder="Explain why you are skipping this player...", max_length=400, required=True ) def __init__(self, gamemode: str, skipped_user_id: int, tester_id: int): super().__init__() self.gamemode = gamemode self.skipped_user_id = skipped_user_id self.tester_id = tester_id async def on_submit(self, interaction: discord.Interaction): await interaction.response.defer(ephemeral=True) try: supabase.table("skip_logs").insert({ "tester_id": self.tester_id, "skipped_user_id": self.skipped_user_id, "gamemode": self.gamemode, "reason": self.reason.value, "timestamp": datetime.datetime.now().isoformat() }).execute() except Exception as e: print(f"Skip log DB error: {e}") queue_res = supabase.table("waitlist_queue").select("*").eq("gamemode", self.gamemode).order("position").execute() queue_data = queue_res.data if queue_res.data else [] new_queue = [e for e in queue_data if e['user_id'] != self.skipped_user_id] for idx, entry in enumerate(new_queue): supabase.table("waitlist_queue").update({"position": idx + 1}).eq("id", entry['id']).execute() skipped_entry = next((e for e in queue_data if e['user_id'] == self.skipped_user_id), None) if skipped_entry: supabase.table("waitlist_queue").update({"position": len(new_queue) + 1}).eq("id", skipped_entry['id']).execute() try: skipped_user = interaction.client.get_user(self.skipped_user_id) or await interaction.client.fetch_user(self.skipped_user_id) if skipped_user: skip_embed = discord.Embed( title="⏭️ You Were Skipped in Queue", description=f"You were skipped in the **{self.gamemode}** queue.", color=discord.Color.orange() ) skip_embed.add_field(name="Reason", value=self.reason.value, inline=False) skip_embed.add_field(name="Do you think this is unfair?", value="You can report this action using the button below.", inline=False) skip_embed.set_footer(text="APMC Tier Testing System") await skipped_user.send(embed=skip_embed, view=SkipReportView(self.tester_id, self.gamemode, self.reason.value)) except: pass await send_log( interaction.guild, "⏭️ Player Skipped in Queue", f"Tester: <@{self.tester_id}>\nSkipped: <@{self.skipped_user_id}>\nGamemode: {self.gamemode}\nReason: {self.reason.value}", discord.Color.orange() ) await interaction.followup.send("✅ Player skipped and moved to end of queue. They have been notified.", ephemeral=True) await refresh_queue_panel(interaction.guild, self.gamemode, interaction.client) await refresh_tester_panel(interaction.guild, self.gamemode, interaction.client) class SkipReportView(View): def __init__(self, tester_id: int, gamemode: str, skip_reason: str): super().__init__(timeout=None) self.tester_id = tester_id self.gamemode = gamemode self.skip_reason = skip_reason @discord.ui.button(label="Report This Skip", style=discord.ButtonStyle.danger, emoji="🚨") async def report_skip(self, interaction: discord.Interaction, button: discord.ui.Button): await interaction.response.send_modal(SkipReportDetailModal(self.tester_id, self.gamemode, self.skip_reason)) class SkipReportDetailModal(Modal, title="Report Unfair Skip"): extra = TextInput( label="Additional Details", style=discord.TextStyle.paragraph, placeholder="Provide any extra context...", required=False, max_length=400 ) def __init__(self, tester_id: int, gamemode: str, skip_reason: str): super().__init__() self.tester_id = tester_id self.gamemode = gamemode self.skip_reason = skip_reason async def on_submit(self, interaction: discord.Interaction): await interaction.response.send_message("✅ Your report has been submitted to staff.", ephemeral=True) guild = interaction.guild if not guild: for g in interaction.client.guilds: m = g.get_member(interaction.user.id) if m: guild = g break if not guild: return embed = discord.Embed(title="🚨 Skip Report Filed", description="A player has reported an unfair skip.", color=discord.Color.dark_red()) embed.add_field(name="Reporter", value=interaction.user.mention, inline=True) embed.add_field(name="Tester Accused", value=f"<@{self.tester_id}>", inline=True) embed.add_field(name="Gamemode", value=self.gamemode, inline=True) embed.add_field(name="Original Skip Reason", value=self.skip_reason, inline=False) embed.add_field(name="Reporter's Statement", value=self.extra.value if self.extra.value else "No extra details.", inline=False) high_command_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_CO_FOUNDER] for m in guild.members: if not m.bot and any(r.id in high_command_ids for r in m.roles): try: await m.send(embed=embed) except: pass await send_log(guild, "🚨 Skip Report", f"Reporter: {interaction.user.name}\nTester: <@{self.tester_id}>\nGamemode: {self.gamemode}", discord.Color.dark_red()) # ========================================================================= # SECTION 5: QUEUE REFRESH HELPERS # ========================================================================= async def refresh_queue_panel(guild: discord.Guild, gamemode: str, bot_client=None): chan = await get_queue_channel(guild, gamemode) if not chan: return queue_res = supabase.table("waitlist_queue").select("*").eq("gamemode", gamemode).order("position").execute() queue_data = queue_res.data if queue_res.data else [] prime_data = [e for e in queue_data if e.get("is_prime")] normal_data = [e for e in queue_data if not e.get("is_prime")] ordered_queue = prime_data + normal_data session_res = supabase.table("queue_sessions").select("*").eq("gamemode", gamemode).eq("guild_id", guild.id).execute() is_open = bool(session_res.data) active_testers = session_res.data if session_res.data else [] last_refresh = datetime.datetime.now().strftime("%I:%M:%S %p") embed = build_queue_embed(gamemode, ordered_queue, active_testers, is_open, last_refresh) session_msg_res = supabase.table("queue_panel_messages").select("*").eq("gamemode", gamemode).eq("guild_id", guild.id).execute() if session_msg_res.data: msg_id = session_msg_res.data[0]['message_id'] try: msg = await chan.fetch_message(msg_id) view = QueueJoinView(gamemode) if is_open else View() await msg.edit(embed=embed, view=view) return except: pass view = QueueJoinView(gamemode) if is_open else View() if is_open: sent = await chan.send(content="@here", embed=embed, view=view) else: sent = await chan.send(embed=embed, view=view) try: supabase.table("queue_panel_messages").upsert({ "gamemode": gamemode, "guild_id": guild.id, "message_id": sent.id }).execute() except: pass async def refresh_tester_panel(guild: discord.Guild, gamemode: str, bot_client=None): chan = await get_tester_panel_channel(guild, gamemode) if not chan: return queue_res = supabase.table("waitlist_queue").select("*").eq("gamemode", gamemode).order("position").execute() queue_data = queue_res.data if queue_res.data else [] prime_data = [e for e in queue_data if e.get("is_prime")] normal_data = [e for e in queue_data if not e.get("is_prime")] ordered_queue = prime_data + normal_data session_res = supabase.table("queue_sessions").select("*").eq("gamemode", gamemode).eq("guild_id", guild.id).execute() is_open = bool(session_res.data) active_testers = session_res.data if session_res.data else [] embed = build_tester_control_embed(gamemode, ordered_queue, is_open, active_testers) panel_msg_res = supabase.table("tester_panel_messages").select("*").eq("gamemode", gamemode).eq("guild_id", guild.id).execute() if panel_msg_res.data: msg_id = panel_msg_res.data[0]['message_id'] try: msg = await chan.fetch_message(msg_id) await msg.edit(embed=embed, view=TesterControlView(gamemode)) return except: pass sent = await chan.send(embed=embed, view=TesterControlView(gamemode)) try: supabase.table("tester_panel_messages").upsert({ "gamemode": gamemode, "guild_id": guild.id, "message_id": sent.id }).execute() except: pass # ========================================================================= # SECTION 6: QUEUE JOIN/LEAVE VIEW (PUBLIC CHANNEL) # ========================================================================= class QueueJoinView(View): def __init__(self, gamemode: str): super().__init__(timeout=None) self.gamemode = gamemode self.custom_id_prefix = gamemode.lower() @discord.ui.button(label="Join Queue", style=discord.ButtonStyle.success, emoji="📝") async def join_queue(self, interaction: discord.Interaction, button: discord.ui.Button): gamemode = self.gamemode wl_role_name = get_waitlist_role_name(gamemode) wl_role = discord.utils.get(interaction.guild.roles, name=wl_role_name) if not wl_role or wl_role not in interaction.user.roles: await interaction.response.send_message( f"❌ You need the **{wl_role_name}** role to join this queue. Please open a tier ticket for this gamemode first.", ephemeral=True ) return existing = supabase.table("waitlist_queue").select("*").eq("user_id", interaction.user.id).eq("gamemode", gamemode).execute() if existing.data: await interaction.response.send_message("⚠️ You are already in this queue.", ephemeral=True) return session_res = supabase.table("queue_sessions").select("*").eq("gamemode", gamemode).eq("guild_id", interaction.guild.id).execute() if not session_res.data: await interaction.response.send_message("❌ The queue is not currently open.", ephemeral=True) return is_prime = any(r.name == ROLE_PRIME for r in interaction.user.roles) all_queue = supabase.table("waitlist_queue").select("*").eq("gamemode", gamemode).order("position", desc=True).execute() next_pos = (all_queue.data[0]['position'] + 1) if all_queue.data else 1 supabase.table("waitlist_queue").insert({ "user_id": interaction.user.id, "gamemode": gamemode, "guild_id": interaction.guild.id, "position": next_pos, "is_prime": is_prime, "joined_at": datetime.datetime.now().isoformat() }).execute() await interaction.response.send_message(f"✅ You joined the **{gamemode}** queue! Prime: {'👑 Yes' if is_prime else 'No'}", ephemeral=True) await refresh_queue_panel(interaction.guild, gamemode, interaction.client) await refresh_tester_panel(interaction.guild, gamemode, interaction.client) @discord.ui.button(label="Leave Queue", style=discord.ButtonStyle.danger, emoji="✖️") async def leave_queue(self, interaction: discord.Interaction, button: discord.ui.Button): gamemode = self.gamemode existing = supabase.table("waitlist_queue").select("*").eq("user_id", interaction.user.id).eq("gamemode", gamemode).execute() if not existing.data: await interaction.response.send_message("⚠️ You are not in this queue.", ephemeral=True) return supabase.table("waitlist_queue").delete().eq("user_id", interaction.user.id).eq("gamemode", gamemode).execute() remaining = supabase.table("waitlist_queue").select("*").eq("gamemode", gamemode).order("position").execute() for idx, entry in enumerate(remaining.data if remaining.data else []): supabase.table("waitlist_queue").update({"position": idx + 1}).eq("id", entry['id']).execute() await interaction.response.send_message(f"✅ You have left the **{gamemode}** queue.", ephemeral=True) await refresh_queue_panel(interaction.guild, gamemode, interaction.client) await refresh_tester_panel(interaction.guild, gamemode, interaction.client) # ========================================================================= # SECTION 7: TESTER CONTROL PANEL VIEW # ========================================================================= class TesterControlView(View): def __init__(self, gamemode: str): super().__init__(timeout=None) self.gamemode = gamemode def is_gamemode_tester(self, member: discord.Member) -> bool: tester_role_name = GAMEMODE_ROLES.get(self.gamemode.upper()) allowed_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_CO_FOUNDER, ID_ROLE_MOD] if any(r.id in allowed_ids for r in member.roles): return True if tester_role_name and any(r.name == tester_role_name for r in member.roles): return True if any(r.name == ROLE_TESTER for r in member.roles): return True return False @discord.ui.button(label="▶️ Start Queue", style=discord.ButtonStyle.success, custom_id="tcp_start", row=0) async def start_queue(self, interaction: discord.Interaction, button: discord.ui.Button): if not self.is_gamemode_tester(interaction.user): await interaction.response.send_message("⛔ Access Denied.", ephemeral=True) return existing = supabase.table("queue_sessions").select("*").eq("gamemode", self.gamemode).eq("guild_id", interaction.guild.id).execute() if existing.data: already_tester = any(e['tester_id'] == interaction.user.id for e in existing.data) if already_tester: await interaction.response.send_message("⚠️ Queue is already open and you are already in it.", ephemeral=True) return supabase.table("queue_sessions").insert({ "gamemode": self.gamemode, "guild_id": interaction.guild.id, "tester_id": interaction.user.id, "started_at": datetime.datetime.now().isoformat() }).execute() await interaction.response.send_message(f"✅ You joined the active **{self.gamemode}** queue session as a tester.", ephemeral=True) else: supabase.table("queue_sessions").insert({ "gamemode": self.gamemode, "guild_id": interaction.guild.id, "tester_id": interaction.user.id, "started_at": datetime.datetime.now().isoformat() }).execute() await interaction.response.send_message(f"✅ **{self.gamemode}** queue opened! Players can now join.", ephemeral=True) await refresh_queue_panel(interaction.guild, self.gamemode, interaction.client) await refresh_tester_panel(interaction.guild, self.gamemode, interaction.client) await send_log(interaction.guild, "▶️ Queue Started", f"Gamemode: {self.gamemode}\nTester: {interaction.user.name}", discord.Color.green()) @discord.ui.button(label="⏹️ End Queue", style=discord.ButtonStyle.danger, custom_id="tcp_end", row=0) async def end_queue(self, interaction: discord.Interaction, button: discord.ui.Button): if not self.is_gamemode_tester(interaction.user): await interaction.response.send_message("⛔ Access Denied.", ephemeral=True) return supabase.table("queue_sessions").delete().eq("gamemode", self.gamemode).eq("guild_id", interaction.guild.id).execute() supabase.table("waitlist_queue").delete().eq("gamemode", self.gamemode).eq("guild_id", interaction.guild.id).execute() await interaction.response.send_message(f"✅ **{self.gamemode}** queue has been ended and cleared.", ephemeral=True) await refresh_queue_panel(interaction.guild, self.gamemode, interaction.client) await refresh_tester_panel(interaction.guild, self.gamemode, interaction.client) await send_log(interaction.guild, "⏹️ Queue Ended", f"Gamemode: {self.gamemode}\nTester: {interaction.user.name}", discord.Color.red()) @discord.ui.button(label="➕ Join as Tester", style=discord.ButtonStyle.primary, custom_id="tcp_join_tester", row=0) async def join_as_tester(self, interaction: discord.Interaction, button: discord.ui.Button): if not self.is_gamemode_tester(interaction.user): await interaction.response.send_message("⛔ Access Denied.", ephemeral=True) return existing = supabase.table("queue_sessions").select("*").eq("gamemode", self.gamemode).eq("guild_id", interaction.guild.id).execute() if not existing.data: await interaction.response.send_message("❌ No active queue to join. Start one first.", ephemeral=True) return already = any(e['tester_id'] == interaction.user.id for e in existing.data) if already: await interaction.response.send_message("⚠️ You are already in this queue session.", ephemeral=True) return supabase.table("queue_sessions").insert({ "gamemode": self.gamemode, "guild_id": interaction.guild.id, "tester_id": interaction.user.id, "started_at": datetime.datetime.now().isoformat() }).execute() await interaction.response.send_message(f"✅ You joined as an additional tester for **{self.gamemode}**.", ephemeral=True) await refresh_queue_panel(interaction.guild, self.gamemode, interaction.client) await refresh_tester_panel(interaction.guild, self.gamemode, interaction.client) @discord.ui.button(label="⏭️ Next Player", style=discord.ButtonStyle.secondary, custom_id="tcp_next", row=1) async def next_player(self, interaction: discord.Interaction, button: discord.ui.Button): if not self.is_gamemode_tester(interaction.user): await interaction.response.send_message("⛔ Access Denied.", ephemeral=True) return await interaction.response.defer(ephemeral=True) queue_res = supabase.table("waitlist_queue").select("*").eq("gamemode", self.gamemode).eq("guild_id", interaction.guild.id).order("position").execute() queue_data = queue_res.data if queue_res.data else [] prime_data = [e for e in queue_data if e.get("is_prime")] normal_data = [e for e in queue_data if not e.get("is_prime")] ordered_queue = prime_data + normal_data if not ordered_queue: await interaction.followup.send("📭 The queue is empty.", ephemeral=True) return next_entry = ordered_queue[0] user_id = next_entry['user_id'] joined_at = next_entry.get('joined_at', 'Unknown') is_prime = next_entry.get('is_prime', False) profile_res = supabase.table("user_profiles").select("*").eq("user_id", user_id).execute() profile = profile_res.data[0] if profile_res.data else {} ign = profile.get('ign') or 'Unknown' platform = profile.get('platform', 'N/A') region = profile.get('region', 'N/A') points = profile.get('points', 0) rank = get_combat_rank(points) history_res = supabase.table("tier_history").select("*").eq("user_id", user_id).order("id", desc=True).limit(1).execute() last_tier = history_res.data[0]['new_tier'] if history_res.data else "No previous tier" gamemode_history = supabase.table("tier_history").select("*").eq("user_id", user_id).order("id", desc=True).execute() gm_tier = "No tier in this gamemode" for h in (gamemode_history.data or []): if self.gamemode.upper() in h.get('new_tier', '').upper() or self.gamemode.upper() in h.get('old_tier', '').upper(): gm_tier = h['new_tier'] break reviews_res = supabase.table("tester_reviews").select("*").eq("reviewer_id", user_id).execute() reviews = reviews_res.data or [] avg_given = sum(r['stars'] for r in reviews) / len(reviews) if reviews else 0 ticket_chan_res = supabase.table("active_tickets").select("*").eq("user_id", user_id).execute() ticket_link = "" if ticket_chan_res.data: ticket_link = f"\n🎫 [Go to Ticket](https://discord.com/channels/{interaction.guild.id}/{ticket_chan_res.data[-1].get('channel_id', '')})" embed = discord.Embed( title=f"⏭️ Next Player: {ign}", description=f"<@{user_id}> | {'👑 PRIME' if is_prime else 'Standard'}{ticket_link}", color=discord.Color.gold() if is_prime else discord.Color.blurple() ) embed.set_thumbnail(url=mc_skin_url(ign)) embed.add_field(name="🎮 Platform", value=platform, inline=True) embed.add_field(name="🌐 Region", value=region, inline=True) embed.add_field(name="🏆 Points / Rank", value=f"{points} pts | {rank}", inline=True) embed.add_field(name=f"📋 {self.gamemode} Tier", value=gm_tier, inline=True) embed.add_field(name="📜 Last Tier Overall", value=last_tier, inline=True) embed.add_field(name="⭐ Avg Rating Given", value=f"{avg_given:.1f}/5", inline=True) embed.add_field(name="🕐 Joined Queue", value=joined_at[:19] if len(joined_at) > 10 else joined_at, inline=False) embed.set_footer(text=f"Queue Position: #1 | APMC Tier Testing") await interaction.followup.send(embed=embed, view=NextPlayerActionView(self.gamemode, user_id), ephemeral=True) @discord.ui.button(label="⏭️ Skip Player", style=discord.ButtonStyle.secondary, custom_id="tcp_skip", row=1) async def skip_player(self, interaction: discord.Interaction, button: discord.ui.Button): if not self.is_gamemode_tester(interaction.user): await interaction.response.send_message("⛔ Access Denied.", ephemeral=True) return queue_res = supabase.table("waitlist_queue").select("*").eq("gamemode", self.gamemode).eq("guild_id", interaction.guild.id).order("position").execute() queue_data = queue_res.data if queue_res.data else [] prime_data = [e for e in queue_data if e.get("is_prime")] normal_data = [e for e in queue_data if not e.get("is_prime")] ordered_queue = prime_data + normal_data if not ordered_queue: await interaction.response.send_message("📭 Queue is empty.", ephemeral=True) return next_entry = ordered_queue[0] await interaction.response.send_modal( SkipReasonModal(self.gamemode, next_entry['user_id'], interaction.user.id) ) @discord.ui.button(label="📖 Rules", style=discord.ButtonStyle.secondary, custom_id="tcp_rules", row=2) async def show_rules(self, interaction: discord.Interaction, button: discord.ui.Button): embed = discord.Embed(title="📊 Tier Testing Rules", description=TIER_TESTING_RULES, color=discord.Color.blue()) await interaction.response.send_message(embed=embed, ephemeral=True) @discord.ui.button(label="❓ Help", style=discord.ButtonStyle.secondary, custom_id="tcp_help", row=2) async def show_help(self, interaction: discord.Interaction, button: discord.ui.Button): embed = discord.Embed(title="❓ Tester Panel Guide", color=discord.Color.teal()) embed.add_field(name="▶️ Start Queue", value="Opens the queue. Players in the waitlist channel can now join.", inline=False) embed.add_field(name="⏹️ End Queue", value="Closes the queue and clears all players. Sends a closed message to the queue channel.", inline=False) embed.add_field(name="➕ Join as Tester", value="Lets additional testers join an already-open queue session.", inline=False) embed.add_field(name="⏭️ Next Player", value="Shows full details of the next player in queue — their ticket, tier history, and profile.", inline=False) embed.add_field(name="⏭️ Skip Player", value="Moves the first player to the end of queue. Requires a reason which is logged and DM'd to the player.", inline=False) embed.add_field(name="👑 Prime Priority", value="Prime Members are always shown first in queue regardless of join time.", inline=False) embed.set_footer(text="APMC Tier Testing System") await interaction.response.send_message(embed=embed, ephemeral=True) class NextPlayerActionView(View): def __init__(self, gamemode: str, user_id: int): super().__init__(timeout=300) self.gamemode = gamemode self.user_id = user_id @discord.ui.button(label="✅ Mark as Tested (Remove from Queue)", style=discord.ButtonStyle.success) async def mark_tested(self, interaction: discord.Interaction, button: discord.ui.Button): supabase.table("waitlist_queue").delete().eq("user_id", self.user_id).eq("gamemode", self.gamemode).execute() remaining = supabase.table("waitlist_queue").select("*").eq("gamemode", self.gamemode).order("position").execute() for idx, entry in enumerate(remaining.data if remaining.data else []): supabase.table("waitlist_queue").update({"position": idx + 1}).eq("id", entry['id']).execute() await interaction.response.send_message(f"✅ <@{self.user_id}> removed from **{self.gamemode}** queue.", ephemeral=True) await refresh_queue_panel(interaction.guild, self.gamemode, interaction.client) await refresh_tester_panel(interaction.guild, self.gamemode, interaction.client) # ========================================================================= # SECTION 8: TICKET WAITLIST PANEL (NEW DESIGN) # ========================================================================= class WaitlistRegisterView(View): def __init__(self): super().__init__(timeout=None) @discord.ui.button(label="Register / Update Profile", style=discord.ButtonStyle.success, custom_id="wl_register_btn", emoji="📝") async def register_btn(self, interaction: discord.Interaction, button: discord.ui.Button): await interaction.response.send_modal(ProfileModal(title="Register / Update Profile")) class WaitlistGamemodeSelect(Select): def __init__(self): options = [] for gm in GAME_MODES: if gm != "OTHER": options.append(discord.SelectOption(label=gm, value=gm, emoji="🎮")) options.append(discord.SelectOption(label="OTHER / CUSTOM", value="OTHER", emoji="❓")) super().__init__( placeholder="Select a gamemode to get the waitlist role", options=options, custom_id="wl_gm_select" ) async def callback(self, interaction: discord.Interaction): gamemode = self.values[0] wl_role = await ensure_waitlist_role(interaction.guild, gamemode) if wl_role in interaction.user.roles: await interaction.response.send_message(f"⚠️ You already have the **{wl_role.name}** role.", ephemeral=True) return await interaction.user.add_roles(wl_role) queue_chan = await get_queue_channel(interaction.guild, gamemode) chan_mention = queue_chan.mention if queue_chan else f"#queue-{gamemode.lower()}" embed = discord.Embed( title=f"✅ Waitlist Role Assigned: {gamemode}", description=f"You have been given the **{wl_role.name}** role.\n\nYou can now access and join the queue in {chan_mention} when a tester opens a session.", color=discord.Color.green() ) await interaction.response.send_message(embed=embed, ephemeral=True) await send_log(interaction.guild, "🎮 Waitlist Role Given", f"User: {interaction.user.name}\nGamemode: {gamemode}", discord.Color.teal()) class WaitlistPanelView(View): def __init__(self): super().__init__(timeout=None) self.add_item(WaitlistGamemodeSelect()) @discord.ui.button(label="Register / Update Profile", style=discord.ButtonStyle.success, custom_id="wl_reg_top", emoji="📝", row=1) async def register_btn(self, interaction: discord.Interaction, button: discord.ui.Button): await interaction.response.send_modal(ProfileModal(title="Register / Update Profile")) # ========================================================================= # SECTION 9: TICKET CLOSE LOGIC # ========================================================================= async def close_ticket_logic(interaction: discord.Interaction, channel: discord.TextChannel, reason: str): messages = [message async for message in channel.history(limit=None, oldest_first=True)] transcript_text = f"APMC TICKET TRANSCRIPT\n========================================\n" transcript_text += f"Server: {interaction.guild.name}\nChannel: {channel.name}\n" transcript_text += f"Closed By: {interaction.user.name} ({interaction.user.id})\n" transcript_text += f"Reason: {reason}\n" transcript_text += f"Date: {datetime.datetime.now()}\n========================================\n\n" for m in messages: timestamp = m.created_at.strftime('%Y-%m-%d %H:%M:%S') transcript_text += f"[{timestamp}] {m.author.name}: {m.content}\n" if m.attachments: for att in m.attachments: transcript_text += f"[{timestamp}] {m.author.name} [ATTACHMENT]: {att.url}\n" transcript_file_log = discord.File(io.StringIO(transcript_text), filename=f"transcript-{channel.name}.txt") transcript_file_dm = discord.File(io.StringIO(transcript_text), filename=f"transcript-{channel.name}.txt") ticket_owner = None try: for target in channel.overwrites: if isinstance(target, discord.Member) and not target.bot and target != interaction.user: ticket_owner = target break except: pass try: is_tester = any(r.name == ROLE_TESTER for r in interaction.user.roles) if is_tester: data = supabase.table("tester_stats").select("*").eq("tester_id", interaction.user.id).execute() if not data.data: supabase.table("tester_stats").insert({"tester_id": interaction.user.id, "tickets_closed": 1}).execute() else: current = data.data[0]['tickets_closed'] supabase.table("tester_stats").update({"tickets_closed": current + 1}).eq("tester_id", interaction.user.id).execute() if ticket_owner: fb_embed = discord.Embed( title="🌟 Rate Your Tester", description=f"Your ticket has been handled by **{interaction.user.name}**.\nPlease rate their service.", color=discord.Color.gold() ) try: await ticket_owner.send(embed=fb_embed, view=FeedbackView(interaction.user.id)) except: pass except Exception as e: print(f"Stats/Feedback Error: {e}") try: channel_name_lower = channel.name.lower() inferred_gm = None for gm in GAME_MODES: if gm.lower() in channel_name_lower: inferred_gm = gm break if inferred_gm and ticket_owner: wl_role_name = get_waitlist_role_name(inferred_gm) wl_role = discord.utils.get(interaction.guild.roles, name=wl_role_name) if wl_role and wl_role in ticket_owner.roles: await ticket_owner.remove_roles(wl_role, reason="Ticket closed — waitlist role removed") except Exception as e: print(f"Waitlist role removal error: {e}") try: supabase.table("active_tickets").delete().eq("channel_id", channel.id).execute() except: pass if ticket_owner: try: embed = discord.Embed(title="🎫 Ticket Formal Closure", description=f"Your ticket in **{interaction.guild.name}** has been formally closed.", color=discord.Color.red()) embed.add_field(name="📝 Closing Reason", value=f"```\n{reason}\n```", inline=False) embed.add_field(name="👮 Actioned By", value=interaction.user.mention, inline=True) embed.set_footer(text="A full transcript is attached for your records.") await ticket_owner.send(embed=embed, file=transcript_file_dm) except: pass await send_log( interaction.guild, "🗑️ Ticket Closed", f"**Channel:** {channel.name}\n**Actioned By:** {interaction.user.mention}\n**Reason:** {reason}\n**Owner:** {ticket_owner.mention if ticket_owner else 'Unknown'}", discord.Color.red(), file=transcript_file_log ) await channel.delete() # ========================================================================= # SECTION 10: MODALS # ========================================================================= class CloseTicketModal(Modal, title="Close Ticket Protocol"): reason = TextInput(label="Reason for Closing", placeholder="e.g. Issue Resolved, Inactive, Denied...", max_length=200, required=True) async def on_submit(self, interaction: discord.Interaction): await interaction.response.defer() await close_ticket_logic(interaction, interaction.channel, self.reason.value) class AnnouncementModal(Modal, title="Broadcast Announcement"): title_input = TextInput(label="Announcement Title", placeholder="Header Text...", max_length=100) content_input = TextInput(label="Message Content", style=discord.TextStyle.paragraph, placeholder="Type your message...", max_length=2000) async def on_submit(self, interaction: discord.Interaction): embed = discord.Embed(title=self.title_input.value, description=self.content_input.value, color=discord.Color.gold(), timestamp=discord.utils.utcnow()) embed.set_author(name=f"Announcement by {interaction.user.display_name}", icon_url=interaction.user.avatar.url if interaction.user.avatar else None) await interaction.channel.send(embed=embed) await interaction.response.send_message("✅ **Announcement Successfully Broadcasted.**", ephemeral=True) class EventModal(Modal, title="Initialize New Event"): name = TextInput(label="Event Name", placeholder="e.g. Winter Cup 2026", max_length=100) details = TextInput(label="Event Overview", style=discord.TextStyle.paragraph, placeholder="Detailed description...") def __init__(self, event_type): super().__init__(title=f"Initialize New {event_type}") self.event_type = event_type async def on_submit(self, interaction: discord.Interaction): c_name = CHANNEL_NEW_TOURNEY if self.event_type == "Tournament" else CHANNEL_NEW_EVENT chan = discord.utils.get(interaction.guild.text_channels, name=c_name) p_chan = discord.utils.get(interaction.guild.channels, name=CHANNEL_PARTICIPATION) if not chan or not p_chan: await interaction.response.send_message("❌ **Configuration Error:** Necessary system channels are missing.", ephemeral=True) return await interaction.response.defer(ephemeral=True) new_role = await interaction.guild.create_role(name=self.name.value, mentionable=True) if isinstance(p_chan, discord.ForumChannel): thread_with_msg = await p_chan.create_thread(name=self.name.value, content=f"# 📢 {self.name.value}\n\n{self.details.value}") thread = thread_with_msg.thread else: msg = await p_chan.send(f"**{self.name.value}**") thread = await msg.create_thread(name=self.name.value) await thread.send(self.details.value) embed = discord.Embed(title=f"🚨 New {self.event_type}: {self.name.value}", description=self.details.value, color=discord.Color.red()) embed.add_field(name="🔰 Participant Role", value=new_role.mention) embed.set_footer(text="Official APMC Event System") sent_msg = await chan.send(content="@everyone", embed=embed, view=EventParticipationView()) supabase.table("event_threads").insert({ "message_id": sent_msg.id, "thread_id": thread.id, "role_id": new_role.id, "event_name": self.name.value, "description": self.details.value }).execute() log_event_to_db(self.name.value, "CREATED", f"By {interaction.user.name} | Desc: {self.details.value}") await interaction.followup.send("✅ **Success:** Event created.") await send_log(interaction.guild, f"📅 {self.event_type} Created", f"Admin: {interaction.user.name}\nTitle: {self.name.value}", discord.Color.blue()) class ResultModal(Modal, title="Submit Official Tier Result"): old_tier = TextInput(label="Old Tier", placeholder="e.g. 'NO TIER' or 'LT1'") new_tier = TextInput(label="New Tier", placeholder="e.g. HT1 (Auto-calculated)") rec = TextInput(label="Tester Remarks", style=discord.TextStyle.paragraph, placeholder="Detailed feedback...") def __init__(self, target): super().__init__() self.target = target async def on_submit(self, interaction: discord.Interaction): await interaction.response.defer(ephemeral=True) all_roles = interaction.guild.roles target_name = self.new_tier.value role = None for r in all_roles: if r.name.lower() == target_name.lower(): role = r break if not role: role_names = [r.name for r in all_roles] matches = difflib.get_close_matches(target_name, role_names, n=1, cutoff=0.8) if matches: role = discord.utils.get(all_roles, name=matches[0]) if not role: await interaction.followup.send(f"❌ **Error:** No role found matching `{self.new_tier.value}`. Please check spelling.") return tester = discord.utils.get(interaction.guild.roles, name=ROLE_TESTER) if tester and role.position >= tester.position: await interaction.followup.send("⛔ **Security:** Cannot assign a role higher than or equal to Tester.") return points_val = calculate_auto_points(role.name) try: if self.old_tier.value.strip().upper() != "NO TIER": old_role = None for r in all_roles: if r.name.lower() == self.old_tier.value.lower(): old_role = r break if not old_role: m = difflib.get_close_matches(self.old_tier.value, [r.name for r in all_roles], n=1, cutoff=0.7) if m: old_role = discord.utils.get(all_roles, name=m[0]) if old_role: await self.target.remove_roles(old_role) await self.target.add_roles(role) except: await interaction.followup.send("❌ **Permission Error:** Check bot hierarchy.") return supabase.table("tier_history").insert({ "user_id": self.target.id, "tester_id": interaction.user.id, "old_tier": self.old_tier.value, "new_tier": role.name, "recommendation": self.rec.value, "points_given": points_val }).execute() res = supabase.table("user_profiles").select("points", "ign").eq("user_id", self.target.id).execute() cur_points = res.data[0]['points'] if res.data else 0 ign = res.data[0].get('ign') or self.target.name if res.data else self.target.name supabase.table("user_profiles").upsert({ "user_id": self.target.id, "ign": ign if ign and ign.strip().lower() not in ("", "unknown") else self.target.name, "points": cur_points + points_val }).execute() tester_ign_res = supabase.table("user_profiles").select("ign").eq("user_id", interaction.user.id).execute() tester_ign = tester_ign_res.data[0].get('ign') or interaction.user.name if tester_ign_res.data else interaction.user.name embed = discord.Embed(title="📋 Official Tier Test Result", color=discord.Color.green(), timestamp=discord.utils.utcnow()) embed.set_thumbnail(url=mc_skin_url(ign)) embed.set_author(name=f"Tester: {tester_ign}", icon_url=mc_skin_url(tester_ign)) embed.add_field(name="👤 Player", value=self.target.mention, inline=True) embed.add_field(name="👮 Tester", value=interaction.user.mention, inline=True) embed.add_field(name="🏅 Points Earned", value=f"**+{points_val}**", inline=True) embed.add_field(name="⏩ Result", value=f"**{self.old_tier.value}** ➔ **{role.name}**", inline=False) embed.add_field(name="📝 Remarks", value=f"```{self.rec.value}```", inline=False) embed.set_footer(text="APMC Tiering System") res_chan = discord.utils.get(interaction.guild.text_channels, name=CHANNEL_RESULTS) if res_chan: await res_chan.send(embed=embed) try: await self.target.send(embed=embed) except: pass await interaction.followup.send(f"✅ **Success:** Processed {self.target.display_name}.") await send_log(interaction.guild, "📈 Test Result Logged", f"Tester: {interaction.user.name}\nPlayer: {self.target.name}\nTier: {role.name}\nPoints: {points_val}", discord.Color.green()) class ProfileModal(Modal, title="Edit Player Profile"): ign = TextInput(label="In-Game Name (IGN)") platform = TextInput(label="Platform") region = TextInput(label="Region") tagline = TextInput(label="Tagline (Max 10 Words)", required=False) async def on_submit(self, i): if self.tagline.value and len(self.tagline.value.split()) > 10: await i.response.send_message("❌ **Error:** Tagline cannot exceed 10 words.", ephemeral=True) return ign_val = self.ign.value.strip() if not ign_val or ign_val.lower() in ("unknown", "n/a", ""): await i.response.send_message("❌ **Error:** Please provide a valid IGN.", ephemeral=True) return res = supabase.table("user_profiles").select("points").eq("user_id", i.user.id).execute() pts = res.data[0]['points'] if res.data else 0 supabase.table("user_profiles").upsert({ "user_id": i.user.id, "ign": ign_val, "platform": self.platform.value, "region": self.region.value, "tagline": self.tagline.value, "points": pts }).execute() await i.response.send_message("✅ **Profile Successfully Updated.**", ephemeral=True) class ReportModal(Modal, title="Report Incident"): details = TextInput(label="Incident Details", style=discord.TextStyle.paragraph, placeholder="Describe the issue in detail...") async def on_submit(self, i): await i.response.send_message("✅ **Report Received.** Staff have been notified.", ephemeral=True) e = discord.Embed(title="🚨 High Priority: User Report", description=self.details.value, color=discord.Color.dark_red()) e.set_author(name=f"Reporter: {i.user.name}", icon_url=i.user.avatar.url if i.user.avatar else None) e.set_footer(text=f"User ID: {i.user.id}") high_command_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_CO_FOUNDER] for m in i.guild.members: if not m.bot and any(r.id in high_command_ids for r in m.roles): try: await m.send(embed=e) except: pass await send_log(i.guild, "🚨 Report Filed", f"Reporter: {i.user.name}", discord.Color.dark_red()) # ========================================================================= # SECTION 11: TICKET VIEWS # ========================================================================= class SupportTicketView(View): def __init__(self): super().__init__(timeout=None) @discord.ui.button(label="Close Ticket", style=discord.ButtonStyle.danger, custom_id="tk_supp_close", emoji="🗑️") async def close(self, i, b): allowed_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_MOD, ID_ROLE_CO_FOUNDER] has_perm = any(r.id in allowed_ids for r in i.user.roles) or any(r.name == ROLE_TESTER for r in i.user.roles) if not has_perm: await i.response.send_message("⛔ **Permission Denied.**", ephemeral=True) return await i.response.send_modal(CloseTicketModal()) class UnclaimedTicketView(View): def __init__(self): super().__init__(timeout=None) @discord.ui.button(label="Claim Ticket", style=discord.ButtonStyle.success, custom_id="tk_un_claim", emoji="🙋‍♂️") async def claim(self, i, b): allowed_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_MOD, ID_ROLE_CO_FOUNDER] has_perm = any(r.id in allowed_ids for r in i.user.roles) or any(r.name == ROLE_TESTER for r in i.user.roles) if not has_perm: await i.response.send_message("⛔ **Access Denied.**", ephemeral=True) return count = 0 for t, o in i.channel.overwrites.items(): if isinstance(t, discord.Member) and o.send_messages and not t.bot: count += 1 if count >= 4: await i.response.send_message("⛔ **Limit Reached:** 3 testers already present.", ephemeral=True) return await i.channel.set_permissions(i.user, send_messages=True, read_messages=True) try: await i.channel.edit(name=f"claimed-{i.user.name}-{i.channel.name.split('-')[-1]}"[:90]) except: pass d = supabase.table("tester_stats").select("*").eq("tester_id", i.user.id).execute() if not d.data: supabase.table("tester_stats").insert({"tester_id": i.user.id, "tickets_claimed": 1}).execute() else: supabase.table("tester_stats").update({"tickets_claimed": d.data[0]['tickets_claimed'] + 1}).eq("tester_id", i.user.id).execute() embed = i.message.embeds[0] cur = "None" for f in embed.fields: if f.name == "Handler": cur = f.value new_val = f"✅ {i.user.mention}" if "None" in cur else f"{cur}, {i.user.mention}" embed.clear_fields() embed.add_field(name="Handler", value=new_val, inline=False) embed.color = discord.Color.green() await i.message.edit(embed=embed, view=TierActiveTicketView()) creator = None for t in i.channel.overwrites: if isinstance(t, discord.Member) and not t.bot and t != i.user: creator = t await i.channel.send( f"{creator.mention if creator else ''}", embed=discord.Embed(description=f"✅ {i.user.mention} claimed your ticket. They are your tester.", color=discord.Color.gold()) ) await i.response.send_message("✅ **Ticket Claimed.**", ephemeral=True) class TierActiveTicketView(View): def __init__(self): super().__init__(timeout=None) @discord.ui.button(label="Claim (+)", style=discord.ButtonStyle.secondary, custom_id="tk_tier_add", emoji="➕") async def add(self, i, b): allowed_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_MOD, ID_ROLE_CO_FOUNDER] has_perm = any(r.id in allowed_ids for r in i.user.roles) or any(r.name == ROLE_TESTER for r in i.user.roles) if not has_perm: await i.response.send_message("⛔ **Access Denied.**", ephemeral=True) return count = 0 for t, o in i.channel.overwrites.items(): if isinstance(t, discord.Member) and o.send_messages and not t.bot: count += 1 if count >= 4: await i.response.send_message("⛔ **Limit Reached.**", ephemeral=True) return await i.channel.set_permissions(i.user, send_messages=True, read_messages=True) d = supabase.table("tester_stats").select("*").eq("tester_id", i.user.id).execute() if not d.data: supabase.table("tester_stats").insert({"tester_id": i.user.id, "tickets_claimed": 1}).execute() else: supabase.table("tester_stats").update({"tickets_claimed": d.data[0]['tickets_claimed'] + 1}).eq("tester_id", i.user.id).execute() await i.channel.send(f"✅ {i.user.mention} also claimed this ticket.") await i.response.send_message("✅ **Added to ticket.**", ephemeral=True) @discord.ui.button(label="Close Ticket", style=discord.ButtonStyle.danger, custom_id="tk_tier_close", emoji="🗑️") async def close(self, i, b): allowed_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_MOD, ID_ROLE_CO_FOUNDER] has_perm = any(r.id in allowed_ids for r in i.user.roles) or any(r.name == ROLE_TESTER for r in i.user.roles) if not has_perm: await i.response.send_message("⛔ **Denied.**", ephemeral=True) return await i.response.send_modal(CloseTicketModal()) @discord.ui.button(label="Set Priority", style=discord.ButtonStyle.primary, custom_id="tk_tier_prio", emoji="⭐") async def prio(self, i, b): allowed_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_MOD, ID_ROLE_CO_FOUNDER] if not any(r.id in allowed_ids for r in i.user.roles): await i.response.send_message("⛔ **Admin Only.**", ephemeral=True) return c = discord.utils.get(i.guild.categories, name=CATEGORY_PRIORITY) if c: await i.channel.edit(category=c) await i.response.send_message("🚀 **Escalated to Priority Queue.**") # ========================================================================= # SECTION 12: TICKET CREATION # ========================================================================= async def create_ticket(i, cat_name, type, tier=False, ign=None): await i.response.defer(ephemeral=True) cat = discord.utils.get(i.guild.categories, name=cat_name) if not cat: await i.followup.send("❌ **System Error:** Category missing.", ephemeral=True) return if tier: gm = type.split("-")[1] res = supabase.table("ticket_cooldowns").select("*").eq("user_id", i.user.id).eq("gamemode", gm).execute() is_prime = i.user.premium_since is not None or any(r.name == ROLE_PRIME for r in i.user.roles) cooldown_days = 2 if is_prime else 6 if res.data and not is_prime: last = datetime.datetime.fromisoformat(res.data[0]['last_ticket_time']) diff = datetime.datetime.now().replace(tzinfo=None) - last.replace(tzinfo=None) if diff < datetime.timedelta(days=cooldown_days): remaining_days = (datetime.timedelta(days=cooldown_days) - diff).days await i.followup.send( f"⏳ **Cooldown Active:** Wait **{remaining_days}** more day(s) for a **{gm}** ticket.\n👑 *Prime Members have a 2-day cooldown!*", ephemeral=True ) return elif res.data and is_prime: last = datetime.datetime.fromisoformat(res.data[0]['last_ticket_time']) diff = datetime.datetime.now().replace(tzinfo=None) - last.replace(tzinfo=None) if diff < datetime.timedelta(days=cooldown_days): remaining_days = (datetime.timedelta(days=cooldown_days) - diff).days await i.followup.send(f"⏳ **Cooldown Active (Prime):** Wait **{remaining_days}** more day(s).", ephemeral=True) return supabase.table("ticket_cooldowns").upsert({ "user_id": i.user.id, "gamemode": gm, "last_ticket_time": datetime.datetime.now().isoformat() }).execute() wl_role = await ensure_waitlist_role(i.guild, gm) if wl_role not in i.user.roles: await i.user.add_roles(wl_role, reason="Tier ticket opened — waitlist role granted") c_name = f"ticket-{i.user.name}-{type}"[:90] ow = {i.guild.default_role: discord.PermissionOverwrite(read_messages=False)} ow[i.user] = discord.PermissionOverwrite(read_messages=True, send_messages=True) high_staff_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_CO_FOUNDER] if cat_name != CATEGORY_SUPPORT: high_staff_ids.append(ID_ROLE_MOD) for rid in high_staff_ids: r = i.guild.get_role(rid) if r: ow[r] = discord.PermissionOverwrite(read_messages=True, send_messages=True) if tier: tr = discord.utils.get(i.guild.roles, name=ROLE_TESTER) if tr: ow[tr] = discord.PermissionOverwrite(read_messages=True, send_messages=False) gm_key = type.split("-")[1] s_role_name = GAMEMODE_ROLES.get(gm_key) sp_ping = "" if s_role_name: r = discord.utils.get(i.guild.roles, name=s_role_name) if r: sp_ping = r.mention ow[r] = discord.PermissionOverwrite(read_messages=True, send_messages=True) ping = f"{i.user.mention} {tr.mention if tr else ''} {sp_ping}" title = "🎟️ Official Tier Testing Request" desc = f"**Applicant:** {i.user.mention}\n**IGN:** {ign}\n**Request Type:** {type}\n\nℹ️ *Please wait patiently. A qualified Tester will claim this ticket shortly.*" view = UnclaimedTicketView() else: ping = f"{i.user.mention} @here" title = "📜 APMC Support & Operations" desc = f"**User:** {i.user.mention}\n**Category:** {type}\n\nℹ️ *Please describe your inquiry in detail below. Staff will respond shortly.*" view = SupportTicketView() chan = await i.guild.create_text_channel(name=c_name, category=cat, overwrites=ow) try: supabase.table("active_tickets").insert({ "user_id": i.user.id, "channel_id": chan.id, "gamemode": type.split("-")[1] if tier and "-" in type else "SUPPORT", "created_at": datetime.datetime.now().isoformat() }).execute() except: pass await i.followup.send(f"✅ **Ticket Initialized:** {chan.mention}", ephemeral=True) await asyncio.sleep(1) embed = discord.Embed(title=title, description=desc, color=discord.Color.blue()) embed.add_field(name="Handler", value="None") embed.set_footer(text="APMC Ticket System • Secure Channel") await chan.send(content=ping, embed=embed, view=view) if tier: await chan.send(f"👋 Greetings {i.user.mention}! We also offer specialized **Spear Tier Tests**.") await send_log(i.guild, "🎫 Ticket Generated", f"Type: {type}\nUser: {i.user.name}", discord.Color.blue()) # ========================================================================= # SECTION 13: TICKET UI FLOWS # ========================================================================= class IGNModal(Modal, title="Final Step: Identification"): ign = TextInput(label="In-Game Username (IGN)") def __init__(self, p, g, t): super().__init__() self.p = p self.g = g self.t = t async def on_submit(self, i): res = supabase.table("user_profiles").select("*").eq("user_id", i.user.id).execute() if not res.data: await i.response.send_message( "❌ **Access Denied:** You must register your profile first using `/register` before requesting a tier test.", ephemeral=True ) return await create_ticket(i, CATEGORY_NATIVE if self.p == "Native" else CATEGORY_CROSS, f"{self.p}-{self.g}-{self.t}", True, self.ign.value) class TierSelect(View): def __init__(self, p, g): super().__init__(timeout=None) self.p = p self.g = g @discord.ui.button(label="High Tier Assessment", style=discord.ButtonStyle.danger, emoji="📈") async def h(self, i, b): await i.response.send_modal(IGNModal(self.p, self.g, "High")) @discord.ui.button(label="Low Tier Assessment", style=discord.ButtonStyle.primary, emoji="📉") async def l(self, i, b): await i.response.send_modal(IGNModal(self.p, self.g, "Low")) class GMSelect(Select): def __init__(self, p): self.p = p opts = [discord.SelectOption(label="OTHER / CUSTOM", value="OTHER", emoji="❓")] for m in GAME_MODES: if m != "OTHER": opts.append(discord.SelectOption(label=m, value=m, emoji="🎮")) super().__init__(placeholder="Select the Game Mode you wish to be tested in...", options=opts) async def callback(self, i): await i.response.send_message( f"✅ **Mode Confirmed:** {self.values[0]}.\n\nPlease select the intensity level of the test:", view=TierSelect(self.p, self.values[0]), ephemeral=True ) class PlatSelect(Select): def __init__(self): super().__init__( placeholder="▶️ Click to Select Your Platform...", options=[ discord.SelectOption(label="Native Client", emoji="📱", description="Mobile/Handheld"), discord.SelectOption(label="Crossplay / PC", emoji="💻", description="PC/Emulator") ], custom_id="tk_plat_sel" ) async def callback(self, i): v = View() v.add_item(GMSelect(self.values[0])) await i.response.send_message( f"✅ **Platform Confirmed:** {self.values[0]}.\n\nNext, please choose the Game Mode:", view=v, ephemeral=True ) class TicketPanel(View): def __init__(self): super().__init__(timeout=None) self.add_item(PlatSelect()) class ContractView(View): def __init__(self): super().__init__(timeout=None) @discord.ui.button(label="Request Support", style=discord.ButtonStyle.primary, custom_id="c_supp", emoji="🆘") async def s(self, i, b): await create_ticket(i, CATEGORY_SUPPORT, "Support", False) @discord.ui.button(label="Partnership Inquiry", style=discord.ButtonStyle.secondary, custom_id="c_part", emoji="🤝") async def p(self, i, b): await create_ticket(i, CATEGORY_SUPPORT, "Partnership", False) @discord.ui.button(label="Purchase/Store", style=discord.ButtonStyle.success, custom_id="c_buy", emoji="🛒") async def b(self, i, b): await create_ticket(i, CATEGORY_SUPPORT, "Purchase", False) class StaffView(View): def __init__(self): super().__init__(timeout=None) @discord.ui.button(label="Submit Staff Application", style=discord.ButtonStyle.blurple, custom_id="s_apply", emoji="📝") async def a(self, i, b): await create_ticket(i, CATEGORY_STAFF, "Staff-App", False) class VerifyView(View): def __init__(self): super().__init__(timeout=None) @discord.ui.button(label="Verify Access", style=discord.ButtonStyle.green, custom_id="v_verify", emoji="✅") async def v(self, i, b): r = discord.utils.get(i.guild.roles, name=ROLE_VERIFIED) u = discord.utils.get(i.guild.roles, name=ROLE_UNVERIFIED) if r: await i.user.add_roles(r) if u: try: await i.user.remove_roles(u) except: pass await i.response.send_message("✅ **Verification Complete:** Welcome to the server.", ephemeral=True) await send_log(i.guild, "✅ Member Verified", f"{i.user.name} completed verification.", discord.Color.green()) else: await i.response.send_message("❌ **Error:** Verification role missing.", ephemeral=True) # ========================================================================= # SECTION 14: EVENT VIEWS # ========================================================================= class DMConfirmView(View): def __init__(self, guild_id, thread_id, role_id, event_name): super().__init__(timeout=180) self.guild_id = guild_id self.thread_id = thread_id self.role_id = role_id self.event_name = event_name @discord.ui.button(label="Confirm Registration", style=discord.ButtonStyle.success, emoji="✅") async def confirm_btn(self, interaction: discord.Interaction, button: discord.ui.Button): guild = interaction.client.get_guild(self.guild_id) if not guild: return member = guild.get_member(interaction.user.id) if not member: return role = guild.get_role(self.role_id) if role: try: await member.add_roles(role) except: pass thread = guild.get_thread(self.thread_id) if thread: embed = discord.Embed(description=f"✅ **Registration Confirmed:** {member.mention} has officially joined the roster for **{self.event_name}**.", color=discord.Color.green()) await thread.send(embed=embed) button.disabled = True button.label = "Registered" embed = discord.Embed(title="🎉 Registration Successful", description=f"You have been successfully registered for **{self.event_name}**.", color=discord.Color.green()) await interaction.response.edit_message(embed=embed, view=self) await send_log(guild, "📅 Event Registration", f"{member.name} registered for: {self.event_name}", discord.Color.green()) class EventParticipationView(View): def __init__(self): super().__init__(timeout=None) @discord.ui.button(label="Sign Up Now", style=discord.ButtonStyle.success, custom_id="event_register_btn", emoji="📝") async def register_btn(self, interaction: discord.Interaction, button: discord.ui.Button): res = supabase.table("event_threads").select("*").eq("message_id", interaction.message.id).execute() if not res.data: await interaction.response.send_message("❌ **System Error:** Event data could not be retrieved.", ephemeral=True) return data = res.data[0] try: embed = discord.Embed(title=f"📋 Confirm Registration: {data['event_name']}", description="Click the button below to confirm your participation.", color=discord.Color.blue()) view = DMConfirmView(interaction.guild.id, data['thread_id'], data['role_id'], data['event_name']) await interaction.user.send(embed=embed, view=view) await interaction.response.send_message("📨 **Action Required:** Please check your DMs to finalize registration.", ephemeral=True) except discord.Forbidden: await interaction.response.send_message("❌ **Delivery Failed:** I cannot send you DMs. Please enable them.", ephemeral=True) @discord.ui.button(label="Not Interested", style=discord.ButtonStyle.secondary, custom_id="event_ignore_btn", emoji="✖️") async def ignore_btn(self, interaction: discord.Interaction, button: discord.ui.Button): await interaction.response.send_message("✅ Preference noted. You will not be registered.", ephemeral=True) class EventTypeSelect(View): @discord.ui.select( placeholder="Select Event Category...", options=[ discord.SelectOption(label="Competitive Tournament", emoji="🏆"), discord.SelectOption(label="Community Event", emoji="🎉") ] ) async def select_callback(self, interaction: discord.Interaction, select: discord.ui.Select): await interaction.response.send_modal(EventModal(select.values[0])) # ========================================================================= # SECTION 15: INVITE TRACKER # ========================================================================= class InviteTracker: def __init__(self, bot): self.bot = bot self.invites = {} async def update(self, g): try: self.invites[g.id] = {i.code: i.uses for i in await g.invites()} except: pass async def find(self, g): if g.id not in self.invites: return None old = self.invites[g.id] new = await g.invites() inviter = None for i in new: if i.code in old and i.uses > old[i.code]: inviter = i.inviter break self.invites[g.id] = {i.code: i.uses for i in new} return inviter # ========================================================================= # SECTION 16: BOT CLIENT # ========================================================================= class Client(discord.Client): def __init__(self): super().__init__(intents=discord.Intents.all()) self.tree = app_commands.CommandTree(self) self.tracker = InviteTracker(self) async def setup_hook(self): self.add_view(TicketPanel()) self.add_view(VerifyView()) self.add_view(UnclaimedTicketView()) self.add_view(SupportTicketView()) self.add_view(TierActiveTicketView()) self.add_view(EventParticipationView()) self.add_view(ContractView()) self.add_view(StaffView()) self.add_view(WaitlistPanelView()) self.add_view(QueueJoinView("CRYSTAL")) self.add_view(QueueJoinView("MACE")) self.add_view(QueueJoinView("AXE")) self.add_view(QueueJoinView("TANK")) self.add_view(QueueJoinView("CART")) self.add_view(QueueJoinView("SMP")) self.add_view(QueueJoinView("DIA")) self.add_view(QueueJoinView("NETHPOT")) self.add_view(QueueJoinView("UHC")) self.add_view(QueueJoinView("SKYWARS")) self.add_view(QueueJoinView("BOXING")) self.add_view(QueueJoinView("SUMO")) self.add_view(QueueJoinView("SPEAR")) for gm in GAME_MODES: self.add_view(TesterControlView(gm)) self.sync_tiers_task.start() self.sync_bans_task.start() self.refresh_queues_task.start() await self.tree.sync() print("✅ APMC Bot is fully operational (Supabase Connected).") async def on_ready(self): print(f"Logged in as {self.user}") for guild in self.guilds: await self.tracker.update(guild) @tasks.loop(minutes=10) async def refresh_queues_task(self): for guild in self.guilds: for gm in GAME_MODES: if gm == "OTHER": continue try: session_res = supabase.table("queue_sessions").select("*").eq("gamemode", gm).eq("guild_id", guild.id).execute() if session_res.data: await refresh_queue_panel(guild, gm, self) await refresh_tester_panel(guild, gm, self) except Exception as e: print(f"Queue refresh error for {gm}: {e}") @tasks.loop(minutes=30) async def sync_tiers_task(self): print("🔄 [TASK] Syncing Active Tiers to Supabase...") for guild in self.guilds: for member in guild.members: if member.bot: continue active_roles = [] for role in member.roles: if any(k in role.name.upper() for k in TIER_POINTS_MAP): active_roles.append(role.name) display_name = member.display_name or member.name name_to_store = display_name if display_name and display_name.strip() else member.name if active_roles: try: existing = supabase.table("user_profiles").select("ign", "user_id").eq("user_id", member.id).execute() current_ign = existing.data[0].get("ign") if existing.data else None upsert_data = { "user_id": member.id, "active_tiers": ", ".join(active_roles) } if not current_ign or current_ign.strip().lower() in ("", "unknown", "n/a"): pass supabase.table("user_profiles").upsert(upsert_data).execute() except Exception as e: print(f"Tier sync error for {member.id}: {e}") print("✅ [TASK] Tier Sync Complete.") @tasks.loop(hours=1) async def sync_bans_task(self): print("🔄 [TASK] Syncing Ban List...") for guild in self.guilds: try: bans = [entry async for entry in guild.bans()] for ban in bans: supabase.table("banned_users").upsert({ "user_id": ban.user.id, "username": ban.user.name, "reason": ban.reason, "banned_at": datetime.datetime.now().isoformat() }).execute() except: pass async def on_invite_create(self, invite): await self.tracker.update(invite.guild) async def on_invite_delete(self, invite): await self.tracker.update(invite.guild) async def on_member_update(self, b, a): pass async def on_member_remove(self, m): try: await m.send(embed=discord.Embed( title="We will miss you! 😢", description=f"We will be happy to see you again.\n\n🔗 **Join Back:** {SERVER_INVITE_LINK}", color=discord.Color.gold() )) except: pass await send_log(m.guild, "📤 Member Left", f"{m.name} ({m.id})", discord.Color.red()) async def on_member_join(self, m): c = discord.utils.get(m.guild.text_channels, name=CHANNEL_WELCOME) inviter = await self.tracker.find(m.guild) if c: e = discord.Embed( title=f"Welcome to APMC, {m.display_name}!", description=f"{random.choice(WELCOME_MESSAGES)}\n\n⚠️ **ATTENTION:** To unlock full server access, please complete the verification process.", color=discord.Color.purple() ) e.set_author(name=m.name, icon_url=m.display_avatar.url) e.set_image(url=WELCOME_IMAGE_URL) e.set_thumbnail(url=m.display_avatar.url) ticket_chan = discord.utils.get(m.guild.text_channels, name=CHANNEL_TICKET_PANEL) ticket_mention = ticket_chan.mention if ticket_chan else "#create-ticket" e.add_field( name="📘 New Member Handbook", value=f"**__Command Directory:__**\n👤 **Profile:** `/register`, `/profile-edit`\n🛡️ **Safety:** `/report`\n⚔️ **Testing:** Visit {ticket_mention}", inline=False ) inv_text = f"Invited by: {inviter.mention}" if inviter else "Invited by: Unknown" e.set_footer(text=f"User ID: {m.id} | Member Count: #{len(m.guild.members)} | {inv_text}") await c.send(content=m.mention, embed=e) await send_log(m.guild, "📥 Member Joined", f"{m.name}. Inviter: {inviter.name if inviter else 'Unknown'}", discord.Color.teal()) async def on_guild_channel_delete(self, c): await asyncio.sleep(1) async for e in c.guild.audit_logs(limit=1, action=discord.AuditLogAction.channel_delete): if e.target.id == c.id and not e.user.bot: await self.nuke(e.user, "channel", c.name, c.guild) async def on_guild_role_delete(self, r): await asyncio.sleep(1) async for e in r.guild.audit_logs(limit=1, action=discord.AuditLogAction.role_delete): if e.target.id == r.id and not e.user.bot: await self.nuke(e.user, "role", r.name, r.guild) async def nuke(self, u, t, name, guild): has_immunity = False if any(r.name in [ROLE_NUKE_SHELTER, ROLE_ANTI_NUKE] for r in u.roles): has_immunity = True if u.id == guild.owner_id: has_immunity = True if has_immunity: return res = supabase.table("nuke_warnings").select("*").eq("user_id", u.id).execute() w = res.data[0]['warnings'] if res.data else 0 if w == 0: supabase.table("nuke_warnings").upsert({"user_id": u.id, "warnings": 1}).execute() try: await u.send(embed=discord.Embed( title="⚠️ SECURITY WARNING", description="Unauthorized deletion detected. One more attempt will result in role stripping.", color=discord.Color.orange() )) except: pass await send_log(guild, "⚠️ Anti-Nuke Warning", f"User: {u.name}\nDeleted {t}: {name}", discord.Color.orange()) await alert_admins(guild, "Anti-Nuke Warning", f"User {u.mention} deleted a {t} ({name}). They have been warned.") else: supabase.table("nuke_warnings").update({"warnings": w + 1}).eq("user_id", u.id).execute() roles_to_remove = [r for r in u.roles if r.name != "@everyone" and r.position < guild.me.top_role.position] if roles_to_remove: try: await u.remove_roles(*roles_to_remove) except: pass await send_log(guild, "🛑 Anti-Nuke Action", f"Roles stripped from {u.name} for repeated deletion.", discord.Color.red()) await alert_admins(guild, "Anti-Nuke Triggered", f"User {u.mention} persisted in deleting {t}s. Their roles have been stripped.") client = Client() # ========================================================================= # SECTION 17: SLASH COMMANDS # ========================================================================= @client.tree.command(name="leaderboard", description="View Top 10 Players by Points") async def lb(i): await i.response.defer() try: data = supabase.table("user_profiles").select("*").order("points", desc=True).limit(10).execute() embed = discord.Embed(title="🏆 APMC Global Leaderboard", color=discord.Color.gold()) desc = "" for idx, user in enumerate(data.data): medal = "🥇" if idx == 0 else "🥈" if idx == 1 else "🥉" if idx == 2 else f"**#{idx+1}**" ign = user.get('ign') or 'Unknown' pts = user.get('points', 0) desc += f"{medal} **{ign}** — `{pts} Points`\n" embed.description = desc if desc else "No data available yet." embed.set_footer(text="Updates in real-time.") await i.followup.send(embed=embed) except Exception as e: await i.followup.send(f"❌ Error fetching leaderboard: {e}") @client.tree.command(name="tester-profile", description="View detailed statistics for a Tester (Public)") async def tprof(i, m: discord.Member): if not any(r.name == ROLE_TESTER for r in m.roles): await i.response.send_message("❌ **Error:** That user is not a TIER TESTER.", ephemeral=True) return s = supabase.table("tester_stats").select("*").eq("tester_id", m.id).execute().data r = supabase.table("tester_reviews").select("*").eq("tester_id", m.id).execute().data cl = s[0]['tickets_claimed'] if s else 0 clo = s[0]['tickets_closed'] if s else 0 avg = sum([x['stars'] for x in r]) / len(r) if r else 0 trend = "📈" if avg > 4 else "📉" if avg < 3 else "➖" profile_res = supabase.table("user_profiles").select("ign").eq("user_id", m.id).execute() ign = profile_res.data[0].get('ign') or m.name if profile_res.data else m.name e = discord.Embed(title=f"🛡️ Tester Profile: {m.display_name}", color=discord.Color.blue()) e.set_thumbnail(url=mc_skin_url(ign)) e.add_field(name="📊 Performance Stats", value=f"**Tickets Claimed:** {cl}\n**Tickets Closed:** {clo}\n**Efficiency:** {int(clo/cl*100) if cl > 0 else 0}%", inline=False) e.add_field(name="🌟 Reputation", value=f"**Average Rating:** {avg:.1f}⭐ {trend}\n**Total Reviews:** {len(r)}", inline=False) if r: e.add_field(name="🗨️ Most Recent Review", value=f"\"{r[-1]['comment']}\" - **{r[-1]['stars']}⭐**", inline=False) await i.response.send_message(embed=e) @client.tree.command(name="user-edit", description="Admin: Manually edit a user's profile details") @app_commands.describe(points="Set exact points", tier="Force Set Tier Role", ign="Set IGN", platform="Set Platform", region="Set Region") async def uedit(i, user: discord.Member, points: int = None, tier: str = None, ign: str = None, platform: str = None, region: str = None): allowed_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_CO_FOUNDER] if not any(r.id in allowed_ids for r in i.user.roles): await i.response.send_message("⛔ **Access Denied.**", ephemeral=True) return supabase.table("user_profiles").upsert({"user_id": user.id}).execute() data = {} logs = [] if points is not None: data["points"] = points logs.append(f"Points set to {points}") if ign: clean_ign = ign.strip() if clean_ign and clean_ign.lower() not in ("unknown", "n/a", ""): data["ign"] = clean_ign logs.append(f"IGN set to {clean_ign}") if platform: data["platform"] = platform if region: data["region"] = region if data: supabase.table("user_profiles").update(data).eq("user_id", user.id).execute() if tier: m = difflib.get_close_matches(tier, [r.name for r in i.guild.roles], n=1, cutoff=0.5) if m: r = discord.utils.get(i.guild.roles, name=m[0]) to_rem = [x for x in user.roles if any(k in x.name.upper() for k in TIER_POINTS_MAP) or "TIER" in x.name.upper()] await user.remove_roles(*to_rem) await user.add_roles(r) logs.append(f"Tier set to {r.name}") supabase.table("tier_history").insert({ "user_id": user.id, "tester_id": i.user.id, "old_tier": "Admin Override", "new_tier": r.name, "recommendation": "Force Edit", "points_given": 0 }).execute() if not logs: await i.response.send_message("⚠️ No changes specified.", ephemeral=True) return await i.response.send_message(f"✅ **Profile Updated** for {user.mention}.", ephemeral=True) await send_log(i.guild, "✍️ Admin User Edit", f"Target: {user.name}\nEditor: {i.user.name}\nChanges:\n" + "\n".join(logs), discord.Color.orange()) @client.tree.command(name="profile", description="View a player's statistics and rank") async def prof(i, user: discord.Member): res = supabase.table("user_profiles").select("*").eq("user_id", user.id).execute() h = supabase.table("tier_history").select("*").eq("user_id", user.id).order("id", desc=True).limit(5).execute() if not res.data: await i.response.send_message("❌ **Error:** No profile found. Use `/register` to create one.", ephemeral=True) return p = res.data[0] pts = p.get('points', 0) rank = get_combat_rank(pts) l_rank = get_leaderboard_rank(user.id) ign = p.get('ign') or user.name active = [f"**{r.name}**" for r in user.roles if any(k in r.name.upper() for k in TIER_POINTS_MAP)] e = discord.Embed(title=f"👤 Player Dossier: {user.display_name}", color=discord.Color.gold()) e.set_thumbnail(url=mc_skin_url(ign)) e.add_field(name="🎮 Identity", value=f"**IGN:** `{ign}`\n**Platform:** `{p.get('platform', 'N/A')}`\n**Region:** `{p.get('region', 'N/A')}`", inline=True) e.add_field(name="🏆 Combat Stats", value=f"**Points:** `{pts}`\n**Rank:** `{rank}`\n**Server Rank:** `{l_rank}`", inline=True) e.add_field(name="🔰 Active Tiers", value=" • ".join(active) if active else "*None*", inline=False) if p.get('tagline'): e.add_field(name="📝 Tagline", value=f"*{p['tagline']}*", inline=False) hist_txt = "" if h.data: for r in h.data: t = i.guild.get_member(r['tester_id']) t_name = t.name if t else "Unknown" hist_txt += f"• **{r['new_tier']}** by {t_name}\n" if hist_txt: e.add_field(name="📜 Recent History", value=hist_txt, inline=False) await i.response.send_message(embed=e) @client.tree.command(name="result", description="Submit Official Tier Result (Tester Only)") async def res_cmd(i, user: discord.Member): is_tester = any(r.name == ROLE_TESTER for r in i.user.roles) is_admin = any(r.id == ID_ROLE_ADMIN for r in i.user.roles) if not (is_tester or is_admin): await i.response.send_message("⛔ **Access Denied.**", ephemeral=True) return await i.response.send_modal(ResultModal(user)) @client.tree.command(name="register", description="Create your player profile") async def reg(i): await i.response.send_modal(ProfileModal(title="Register Profile")) @client.tree.command(name="profile-edit", description="Update your player profile") async def ped(i): await i.response.send_modal(ProfileModal(title="Edit Profile")) @client.tree.command(name="report", description="File a confidential report") async def rep(i): await i.response.send_modal(ReportModal()) @client.tree.command(name="create-ticket-panel", description="ADMIN: Deploy Tier Testing Panel") async def tp(i): if not i.user.guild_permissions.administrator: await i.response.send_message("⛔ Admin only.", ephemeral=True) return embed = discord.Embed( title="🎟️ APMC Tier Testing & Waitlist", description=( "**Step 1: Register Your Profile**\n" "Click the **Register / Update Profile** button to set your in-game details.\n\n" "**Step 2: Get a Waitlist Role**\n" "After registering, select any gamemode below to get the corresponding waitlist role. Each role has a **6-day cooldown** (Prime: **2 days**).\n\n" "• **Region:** The server region you wish to test on (NA, EU, AS/AU).\n" "• **Username:** The name of the account you will be testing on.\n\n" "🔥 Failure to provide authentic information will result in a denied test." ), color=discord.Color.gold() ) embed.set_footer(text="APMC Official Tier Testing System") await i.channel.send(embed=embed, view=WaitlistPanelView()) await i.response.send_message("✅ Panel Deployed.", ephemeral=True) @client.tree.command(name="create-contract-panel", description="ADMIN: Deploy Support Panel") async def cp(i): if i.user.guild_permissions.administrator: await i.channel.send(embed=discord.Embed(title="📜 APMC Contracts & Support", description="Select a service category below to initiate a private consultation ticket.", color=discord.Color.gold()), view=ContractView()) await i.response.send_message("✅ Panel Deployed.", ephemeral=True) @client.tree.command(name="create-verify-panel", description="ADMIN: Deploy Verify Panel") async def vp(i): if i.user.guild_permissions.administrator: e = discord.Embed(title="✅ Official Server Verification", description="Security Checkpoint. Click the button below to verify your account status and unlock the server.", color=discord.Color.green()) e.set_image(url=VERIFY_IMAGE_URL) await i.channel.send(embed=e, view=VerifyView()) await i.response.send_message("✅ Panel Deployed.", ephemeral=True) @client.tree.command(name="create-event", description="Initialize a new event") async def ce(i): if i.user.guild_permissions.manage_events: await i.response.send_message("Select Event Classification:", view=EventTypeSelect(), ephemeral=True) @client.tree.command(name="end-event", description="Conclude an event (Deletes Role & Thread)") @app_commands.describe(event_name="Exact name of the event to end") async def end_ev(i, event_name: str): if not i.user.guild_permissions.manage_events: await i.response.send_message("⛔ **Permission Denied.**", ephemeral=True) return await i.response.defer(ephemeral=True) res = supabase.table("event_threads").select("*").eq("event_name", event_name).execute() if not res.data: await i.followup.send(f"❌ **Error:** Active event '{event_name}' not found.") return data = res.data[0] role_id = data['role_id'] thread_id = data['thread_id'] role = i.guild.get_role(role_id) if role: try: await role.delete(reason="Event Ended") except: pass thread = i.guild.get_thread(thread_id) if thread: try: await thread.send(embed=discord.Embed(title="🛑 Event Concluded", description="This event has officially ended. Thank you for participating.", color=discord.Color.red())) await thread.edit(locked=True, archived=True) except: pass supabase.table("event_threads").delete().eq("event_name", event_name).execute() log_event_to_db(event_name, "ENDED", f"Ended by {i.user.name}") await i.followup.send(f"✅ **Success:** Event '{event_name}' concluded.") await send_log(i.guild, "🏁 Event Ended", f"Event: {event_name}\nAdmin: {i.user.name}", discord.Color.red()) @client.tree.command(name="ban", description="Permanently ban a member") async def ban(i, u: discord.Member, reason: str = "Violation of Terms"): if not i.user.guild_permissions.ban_members: return await i.response.defer() embed = discord.Embed(title="🛑 ACCOUNT SUSPENSION NOTICE", color=discord.Color.dark_red()) embed.description = f"You have been permanently banned from **{i.guild.name}**." embed.add_field(name="Reason", value=reason, inline=False) embed.add_field(name="Appeal Process", value="Contact us via email:\n📧 **support@apmc.fun**\n\nInclude your Discord ID and Username.", inline=False) embed.set_footer(text=f"Banned by Administration | {datetime.datetime.now().strftime('%Y-%m-%d')}") try: await u.send(embed=embed) except: pass await u.ban(reason=reason) supabase.table("banned_users").insert({ "user_id": u.id, "username": u.name, "reason": reason, "banned_at": datetime.datetime.now().isoformat(), "banned_by": i.user.name }).execute() await i.followup.send(f"🔨 **Ban Executed:** {u.mention} has been removed.") await send_log(i.guild, "🔨 Ban Executed", f"Target: {u.name}\nAdmin: {i.user.name}\nReason: {reason}", discord.Color.red()) @client.tree.command(name="timeout", description="Temporarily timeout a user") async def to_cmd(i, u: discord.Member, m: int): if not i.user.guild_permissions.moderate_members: return await u.timeout(datetime.timedelta(minutes=m)) await i.response.send_message(f"⏳ **Timeout Applied:** {u.mention} muted for {m} minutes.") await send_log(i.guild, "⏳ User Timed Out", f"Target: {u.name}\nDuration: {m}m\nAdmin: {i.user.name}", discord.Color.orange()) @client.tree.command(name="purge", description="Bulk delete messages") async def pg(i, a: int): if not i.user.guild_permissions.manage_messages: return await i.response.defer(ephemeral=True) await i.channel.purge(limit=a) await i.followup.send(f"✅ **Clean Sweep:** Removed {a} messages.") @client.tree.command(name="announce", description="Broadcast announcement") async def ann(i): if i.user.guild_permissions.administrator: await i.response.send_modal(AnnouncementModal()) @client.tree.command(name="dm-user", description="DM a specific user") async def dmu(i, u: discord.Member, m: str): if i.user.guild_permissions.administrator: await u.send(f"{u.mention}\n**📨 Staff Message from {i.guild.name}:**\n\n{m}") await i.response.send_message("✅ **Message Sent.**", ephemeral=True) @client.tree.command(name="dm-role", description="Mass DM by Role") async def dmr(i, r: discord.Role, m: str): if not i.user.guild_permissions.administrator: return await i.response.send_message("⏳ **Processing:** Dispatching messages...", ephemeral=True) c = 0 for u in r.members: if not u.bot: try: await u.send(f"{u.mention}\n**📢 Official Announcement from {i.guild.name}:**\n\n{m}") c += 1 except: pass await i.followup.send(f"✅ **Dispatch Complete:** Sent to {c} members.") @client.tree.command(name="setup-gamemode-channels", description="ADMIN: Auto-create queue & tester panel channels for all gamemodes") async def setup_channels(i: discord.Interaction): if not i.user.guild_permissions.administrator: await i.response.send_message("⛔ Admin only.", ephemeral=True) return await i.response.defer(ephemeral=True) guild = i.guild queue_category_name = "🎮 Tier Queues" tester_category_name = "🛡️ Tester Panels" queue_category = discord.utils.get(guild.categories, name=queue_category_name) tester_category = discord.utils.get(guild.categories, name=tester_category_name) if not queue_category: queue_category = await guild.create_category(queue_category_name) if not tester_category: tester_category = await guild.create_category(tester_category_name) created = [] for gm in GAME_MODES: if gm == "OTHER": continue wl_role = await ensure_waitlist_role(guild, gm) tester_role_name = GAMEMODE_ROLES.get(gm) tester_role = discord.utils.get(guild.roles, name=tester_role_name) if tester_role_name else None global_tester = discord.utils.get(guild.roles, name=ROLE_TESTER) admin_role = guild.get_role(ID_ROLE_ADMIN) owner_role = guild.get_role(ID_ROLE_OWNER) mod_role = guild.get_role(ID_ROLE_MOD) co_role = guild.get_role(ID_ROLE_CO_FOUNDER) queue_chan_name = f"queue-{gm.lower()}" if not discord.utils.get(guild.text_channels, name=queue_chan_name): queue_ow = { guild.default_role: discord.PermissionOverwrite(read_messages=False, send_messages=False), guild.me: discord.PermissionOverwrite(read_messages=True, send_messages=True), wl_role: discord.PermissionOverwrite(read_messages=True, send_messages=False), } for r in [admin_role, owner_role, mod_role, co_role, global_tester, tester_role]: if r: queue_ow[r] = discord.PermissionOverwrite(read_messages=True, send_messages=True) queue_chan = await guild.create_text_channel(name=queue_chan_name, category=queue_category, overwrites=queue_ow) created.append(queue_chan.mention) tester_chan_name = f"tester-panel-{gm.lower()}" if not discord.utils.get(guild.text_channels, name=tester_chan_name): tester_ow = { guild.default_role: discord.PermissionOverwrite(read_messages=False, send_messages=False), guild.me: discord.PermissionOverwrite(read_messages=True, send_messages=True), } for r in [admin_role, owner_role, mod_role, co_role, global_tester, tester_role]: if r: tester_ow[r] = discord.PermissionOverwrite(read_messages=True, send_messages=True) tester_chan = await guild.create_text_channel(name=tester_chan_name, category=tester_category, overwrites=tester_ow) embed = discord.Embed( title=f"🎮 {gm} Tester Control Panel", description=f"Use the buttons below to manage the **{gm}** testing queue.", color=discord.Color.blurple() ) embed.set_footer(text="APMC Tester Management System") sent = await tester_chan.send(embed=embed, view=TesterControlView(gm)) try: supabase.table("tester_panel_messages").upsert({ "gamemode": gm, "guild_id": guild.id, "message_id": sent.id }).execute() except: pass created.append(tester_chan.mention) await asyncio.sleep(0.5) result_text = f"✅ Setup complete!\n\nCreated **{len(created)}** channels:\n" + "\n".join(created[:20]) await i.followup.send(result_text, ephemeral=True) @client.tree.command(name="queue-status", description="View current queue status for a gamemode") @app_commands.describe(gamemode="The gamemode to check") @app_commands.choices(gamemode=[app_commands.Choice(name=gm, value=gm) for gm in GAME_MODES if gm != "OTHER"]) async def queue_status(i: discord.Interaction, gamemode: str): await i.response.defer() queue_res = supabase.table("waitlist_queue").select("*").eq("gamemode", gamemode).order("position").execute() session_res = supabase.table("queue_sessions").select("*").eq("gamemode", gamemode).eq("guild_id", i.guild.id).execute() queue_data = queue_res.data or [] prime_data = [e for e in queue_data if e.get("is_prime")] normal_data = [e for e in queue_data if not e.get("is_prime")] ordered_queue = prime_data + normal_data is_open = bool(session_res.data) active_testers = session_res.data or [] last_refresh = datetime.datetime.now().strftime("%I:%M:%S %p") embed = build_queue_embed(gamemode, ordered_queue, active_testers, is_open, last_refresh) await i.followup.send(embed=embed) @client.tree.command(name="force-refresh-queue", description="ADMIN: Force refresh queue panel for a gamemode") @app_commands.describe(gamemode="The gamemode to refresh") @app_commands.choices(gamemode=[app_commands.Choice(name=gm, value=gm) for gm in GAME_MODES if gm != "OTHER"]) async def force_refresh(i: discord.Interaction, gamemode: str): if not i.user.guild_permissions.administrator: await i.response.send_message("⛔ Admin only.", ephemeral=True) return await i.response.defer(ephemeral=True) await refresh_queue_panel(i.guild, gamemode, i.client) await refresh_tester_panel(i.guild, gamemode, i.client) await i.followup.send(f"✅ Refreshed queue and tester panel for **{gamemode}**.", ephemeral=True) @client.tree.command(name="remove-from-queue", description="ADMIN: Remove a player from a gamemode queue") @app_commands.describe(user="The user to remove", gamemode="The gamemode queue") @app_commands.choices(gamemode=[app_commands.Choice(name=gm, value=gm) for gm in GAME_MODES if gm != "OTHER"]) async def remove_from_queue(i: discord.Interaction, user: discord.Member, gamemode: str): allowed_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_CO_FOUNDER, ID_ROLE_MOD] if not any(r.id in allowed_ids for r in i.user.roles): await i.response.send_message("⛔ Access Denied.", ephemeral=True) return existing = supabase.table("waitlist_queue").select("*").eq("user_id", user.id).eq("gamemode", gamemode).execute() if not existing.data: await i.response.send_message(f"⚠️ {user.mention} is not in the **{gamemode}** queue.", ephemeral=True) return supabase.table("waitlist_queue").delete().eq("user_id", user.id).eq("gamemode", gamemode).execute() remaining = supabase.table("waitlist_queue").select("*").eq("gamemode", gamemode).order("position").execute() for idx, entry in enumerate(remaining.data or []): supabase.table("waitlist_queue").update({"position": idx + 1}).eq("id", entry['id']).execute() await i.response.send_message(f"✅ {user.mention} removed from **{gamemode}** queue.", ephemeral=True) await refresh_queue_panel(i.guild, gamemode, i.client) await refresh_tester_panel(i.guild, gamemode, i.client) @client.tree.command(name="assign-waitlist-role", description="ADMIN: Manually assign waitlist role to a user") @app_commands.describe(user="Target user", gamemode="Gamemode to assign") @app_commands.choices(gamemode=[app_commands.Choice(name=gm, value=gm) for gm in GAME_MODES if gm != "OTHER"]) async def assign_wl_role(i: discord.Interaction, user: discord.Member, gamemode: str): allowed_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_CO_FOUNDER, ID_ROLE_MOD] if not any(r.id in allowed_ids for r in i.user.roles): await i.response.send_message("⛔ Access Denied.", ephemeral=True) return wl_role = await ensure_waitlist_role(i.guild, gamemode) await user.add_roles(wl_role) await i.response.send_message(f"✅ Assigned **{wl_role.name}** to {user.mention}.", ephemeral=True) @client.tree.command(name="remove-waitlist-role", description="ADMIN: Remove waitlist role from a user") @app_commands.describe(user="Target user", gamemode="Gamemode to remove") @app_commands.choices(gamemode=[app_commands.Choice(name=gm, value=gm) for gm in GAME_MODES if gm != "OTHER"]) async def remove_wl_role(i: discord.Interaction, user: discord.Member, gamemode: str): allowed_ids = [ID_ROLE_ADMIN, ID_ROLE_OWNER, ID_ROLE_CO_FOUNDER, ID_ROLE_MOD] if not any(r.id in allowed_ids for r in i.user.roles): await i.response.send_message("⛔ Access Denied.", ephemeral=True) return wl_role = discord.utils.get(i.guild.roles, name=get_waitlist_role_name(gamemode)) if wl_role and wl_role in user.roles: await user.remove_roles(wl_role) await i.response.send_message(f"✅ Removed **{wl_role.name}** from {user.mention}.", ephemeral=True) else: await i.response.send_message(f"⚠️ {user.mention} does not have the **{get_waitlist_role_name(gamemode)}** role.", ephemeral=True) @client.tree.command(name="sync-points", description="ADMIN: Force sync all user points from their tier roles") async def sync_points(i: discord.Interaction): if not i.user.guild_permissions.administrator: await i.response.send_message("⛔ Admin only.", ephemeral=True) return await i.response.defer(ephemeral=True) count = 0 for member in i.guild.members: if member.bot: continue total_points = 0 for role in member.roles: total_points += calculate_auto_points(role.name) if total_points > 0: existing = supabase.table("user_profiles").select("ign", "points").eq("user_id", member.id).execute() current_ign = "Unknown" if existing.data: stored_ign = existing.data[0].get("ign") if stored_ign and stored_ign.strip().lower() not in ("", "unknown", "n/a"): current_ign = stored_ign else: current_ign = member.name else: current_ign = member.name supabase.table("user_profiles").upsert({ "user_id": member.id, "ign": current_ign, "points": total_points }).execute() count += 1 await i.followup.send(f"✅ Synced points for **{count}** members.", ephemeral=True) @client.tree.command(name="tier-history", description="View tier testing history for a user") @app_commands.describe(user="The user to check") async def tier_history(i: discord.Interaction, user: discord.Member): await i.response.defer() h = supabase.table("tier_history").select("*").eq("user_id", user.id).order("id", desc=True).limit(10).execute() profile_res = supabase.table("user_profiles").select("ign").eq("user_id", user.id).execute() ign = profile_res.data[0].get('ign') or user.name if profile_res.data else user.name embed = discord.Embed(title=f"📜 Tier History: {user.display_name}", color=discord.Color.blue()) embed.set_thumbnail(url=mc_skin_url(ign)) if not h.data: embed.description = "*No tier history found.*" else: for entry in h.data: tester_member = i.guild.get_member(entry['tester_id']) tester_name = tester_member.name if tester_member else "Unknown" embed.add_field( name=f"{entry['old_tier']} ➔ {entry['new_tier']}", value=f"Tester: **{tester_name}** | Points: +{entry['points_given']}\n_{entry.get('recommendation', 'No remarks')[:80]}_", inline=False ) await i.followup.send(embed=embed) @client.tree.command(name="active-queues", description="View all active queue sessions across gamemodes") async def active_queues(i: discord.Interaction): await i.response.defer() sessions = supabase.table("queue_sessions").select("*").eq("guild_id", i.guild.id).execute() embed = discord.Embed(title="🎮 Active Queue Sessions", color=discord.Color.green(), timestamp=discord.utils.utcnow()) if not sessions.data: embed.description = "*No active queue sessions right now.*" else: gm_sessions: Dict[str, list] = {} for s in sessions.data: gm = s['gamemode'] if gm not in gm_sessions: gm_sessions[gm] = [] gm_sessions[gm].append(s) for gm, testers in gm_sessions.items(): queue_res = supabase.table("waitlist_queue").select("*").eq("gamemode", gm).execute() q_count = len(queue_res.data) if queue_res.data else 0 t_list = ", ".join([f"<@{t['tester_id']}>" for t in testers]) embed.add_field(name=f"🎮 {gm}", value=f"**Testers:** {t_list}\n**Queue:** {q_count} players", inline=False) embed.set_footer(text="APMC Queue System") await i.followup.send(embed=embed) # ========================================================================= # ENTRY POINT # ========================================================================= client.run(BOT_TOKEN)