prepare("
SELECT c.*, cs.total_xp, cs.level
FROM champions c
LEFT JOIN champion_stats cs ON cs.champion_id = c.id
WHERE c.id = ?
");
$stmt->execute([$champion_id]);
$champion = $stmt->fetch();
if (!$champion) {
die("Champion not found.");
}
// Fetch XP progression (group by date)
$xpStmt = $pdo->prepare("
SELECT completion_date, SUM(xp_earned) AS xp
FROM habit_completions
WHERE champion_id = ?
GROUP BY completion_date
ORDER BY completion_date ASC
");
$xpStmt->execute([$champion_id]);
$xpData = $xpStmt->fetchAll();
// Fetch recent completions
$recentStmt = $pdo->prepare("
SELECT
hc.completion_date,
h.title,
h.frequency,
h.is_bounty,
hc.xp_earned
FROM habit_completions hc
JOIN habits h ON h.id = hc.habit_id
WHERE hc.champion_id = ?
ORDER BY hc.completion_date DESC
LIMIT 20
");
$recentStmt->execute([$champion_id]);
$recent = $recentStmt->fetchAll();
// Breakdown stats
$breakdownStmt = $pdo->prepare("
SELECT
h.frequency,
h.is_bounty,
COUNT(*) AS total
FROM habit_completions hc
JOIN habits h ON h.id = hc.habit_id
WHERE hc.champion_id = ?
GROUP BY h.frequency, h.is_bounty
");
$breakdownStmt->execute([$champion_id]);
$breakdown = $breakdownStmt->fetchAll();
?>
<?= $champion['name'] ?> — Champion Detail