Admin — Diablo IV Hall of Legends

Admin Panel

Manage achievements, players, and seasons

API offline

← View Site

Players

—

Achievements

—

Seasons

—

Total Points

—

⚡ Record Achievement

Player

Achievement Type

Season

Date & Time

Notes (optional)

Admin Password

👤 Add Player

📋 Player List

ID	Name	Class	Discord	Actions
Loading…

🎮 Season Setup Wizard

Configure a new or existing season — set the season details, select which challenges are active, and customise point values. Hit Save Setup when done.

Season Number

Season Name

Slug (for URLs)

Status

Countdown / Start Date

End Date

🏆 Challenge Configuration

✨

Custom Challenges for This Season

Add new challenge types that don't exist in the standard list (e.g. new item types for Season 13). These appear on the Bingo Board alongside the standard challenges.

Challenge Name

Points

📅 Create Season

🗓 Update Season End Date

📋 Recent Achievements

Player	Achievement	Rarity	Pts	Season	Date	Actions
Loading…

⚙ Quick D1 Console Snippets

Copy these SQL commands and run them in the Cloudflare D1 Console.

Leaderboard (all seasons)

SELECT p.name, p.class, COALESCE(SUM(a.points),0) AS total_pts, COUNT(a.id) AS ach_count
FROM players p LEFT JOIN achievements a ON p.id = a.player_id
GROUP BY p.id ORDER BY total_pts DESC;

Season stats

SELECT season, COUNT(DISTINCT player_id) AS players, COUNT(id) AS achievements, SUM(points) AS total_pts
FROM achievements GROUP BY season ORDER BY season DESC;

Recent achievements

SELECT player_name, achievement_type, points, season, timestamp, notes
FROM achievements ORDER BY timestamp DESC LIMIT 20;

Update season end date

UPDATE seasons SET end_date = '2025-07-15 17:00:00', next_season_start = '2025-07-15 17:00:00' WHERE slug = 'season-10';

Delete achievement by ID

DELETE FROM achievements WHERE id = 1;

🔔 Discord Integration

Auto-fires on these events

🏆 Achievement recorded by admin
🎯 Bingo Board self-claim by player
⚔️ Season status set to Active

@mention setup

Players are tagged via their Discord User ID stored in their profile (Players tab).

Get ID: Discord → Settings → Advanced → Developer Mode → right-click user → Copy User ID

Connection status

Loading…

Active webhook: —

🔗 Webhook Settings

The webhook URL is stored in the D1 settings table — updating it here takes effect immediately with no redeployment needed.

Discord Webhook URL

Admin Password

📢 Manual Discord Posts

Send rich formatted posts to your Discord channel on demand.

🎉 Welcome Message

Posts a welcome embed with the portal overview, the site URL, feature list, and current active season info. Perfect for announcing the platform to your group for the first time.

Preview includes: site link · current season · leaderboard overview · how to claim achievements

Admin Password

🏆 Season Leaderboard Update

Posts the current standings for a chosen season — ranked player table with glory points and achievement counts. Great for mid-season hype or end-of-season recap.

Preview includes: 🥇🥈🥉 top 3 podium · full ranked table · total points · season name

Season

Admin Password