0) { $stmt = $db->prepare("SELECT level, xp FROM champion_progress WHERE champion_id = ? LIMIT 1"); $stmt->execute([$todayChampionId]); $p = $stmt->fetch(); $level = (int)($p['level'] ?? 1); $xp = (int)($p['xp'] ?? 0); } $level = max(1, $level); $maxXP = $level * 100; $xpPercent = $maxXP > 0 ? min(100, ($xp / $maxXP) * 100) : 0; // Bounties collected by this champion $bountiesCollected = 0; try { $stmt = $db->prepare("SELECT COUNT(*) AS c FROM bounties WHERE completed = TRUE AND completed_by_champion_id = ?"); $stmt->execute([$todayChampionId]); $bountiesCollected = (int)($stmt->fetch()['c'] ?? 0); } catch (Throwable $e) { $bountiesCollected = 0; } // Last 5 completed quests for this champion's day (Option A) $last5 = []; try { $stmt = $db->prepare(" SELECT c.completed_date, h.name, h.xp_reward FROM completions c JOIN habits h ON h.id = c.habit_id WHERE c.champion_day = ? ORDER BY c.completed_date DESC, c.id DESC LIMIT 5 "); $stmt->execute([$todayDayIndex]); $last5 = $stmt->fetchAll(); } catch (Throwable $e) { $last5 = []; } // Bottom champions tiles $stmt = $db->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 c.day_index ASC "); $allChampions = $stmt->fetchAll(); // Flyer + emoji fallback poster (never blank) $flyerUrl = getChampionImage($currentChampion['name'], 'flyer'); $emoji = $currentChampion['emoji'] ?? '⭐'; $emojiSvg = " {$emoji} "; $flyerFallback = "data:image/svg+xml;charset=utf-8," . rawurlencode($emojiSvg); ?>
<?php echo esc($currentChampion['name']); ?>

•
""
Level — / XP
Bounties
Level
XP

Last 5 completed quests ( days)

No completions recorded yet.
✓
• + XP
Lvl
XP: