query("
SELECT c.*, COALESCE(cp.level, 1) AS level, COALESCE(cp.xp, 0) AS xp
FROM champions c
LEFT JOIN champion_progress cp ON c.id = cp.champion_id
ORDER BY level DESC, xp DESC
");
$champions = $stmt->fetchAll();
/**
* Load completed bounties as "badges" grouped by champion
* Requires: bounties.completed_by_champion_id column
*/
$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) {
// If migration not done, badges will just not show
$badgeMap = [];
}
function fmtDate(?string $ymd): string {
if (!$ymd) return 'Unknown';
$ts = strtotime($ymd);
return $ts ? date('d M Y', $ts) : htmlspecialchars($ymd);
}
?>