query(" SELECT c.*, COALESCE(cp.level, 1) AS level, COALESCE(cp.xp, 0) AS xp, ( SELECT COUNT(*) FROM bounties b WHERE b.completed = TRUE AND b.completed_by_champion_id = c.id ) AS bounty_count FROM champions c LEFT JOIN champion_progress cp ON c.id = cp.champion_id ORDER BY level DESC, xp DESC "); $champions = $stmt->fetchAll(); /** * Load badges (completed bounties) for all champions and group them */ $badgeMap = []; try { $stmt = $db->query(" SELECT id, name, description, xp_reward, image_path, completed_date, completed_by_champion_id FROM bounties WHERE completed = TRUE AND completed_by_champion_id IS NOT NULL ORDER BY completed_date DESC, id DESC "); $badges = $stmt->fetchAll(); foreach ($badges as $b) { $cid = (int)$b['completed_by_champion_id']; if (!isset($badgeMap[$cid])) $badgeMap[$cid] = []; $badgeMap[$cid][] = $b; } } catch (Throwable $e) { $badgeMap = []; } function fmtDate(?string $ymd): string { if (!$ymd) return 'Unknown'; $ts = strtotime($ymd); return $ts ? date('d M Y', $ts) : $ymd; } ?>

🏆 Champion Ladder 🏆

All-Time Legend Rankings

Name
Level
Bounties Collected
Overall XP
Next playable date
$champ): ?>
#
<?php echo esc($champ['name']); ?>
Level
—
<?php echo esc($b['name']); ?>
🏅
<?php echo esc($b['name']); ?>
Achieved:
XP:
7): ?>
+
total
XP