query("SELECT * FROM habits ORDER BY FIELD(time_of_day, 'morning', 'midday', 'evening')");
$habits = $stmt->fetchAll();
// Active bounties
$stmt = $db->query("SELECT * FROM bounties WHERE completed = FALSE ORDER BY created_at DESC");
$bounties = $stmt->fetchAll();
// Champion progress
$xp = 0;
$level = 1;
if (!empty($currentChampion['id'])) {
$stmt = $db->prepare("SELECT xp, level FROM champion_progress WHERE champion_id = ? LIMIT 1");
$stmt->execute([$currentChampion['id']]);
$progress = $stmt->fetch();
$xp = (int)($progress['xp'] ?? 0);
$level = (int)($progress['level'] ?? 1);
}
$level = max(1, $level);
$maxXP = $level * 100;
$xpPercent = $maxXP > 0 ? min(100, ($xp / $maxXP) * 100) : 0;
// Stats
$stmt = $db->query("SELECT COUNT(*) as total FROM habits");
$totalQuests = (int)($stmt->fetch()['total'] ?? 0);
$stmt = $db->prepare("SELECT COUNT(*) as completed FROM completions WHERE completed_date = CURDATE()");
$stmt->execute();
$completedToday = (int)($stmt->fetch()['completed'] ?? 0);
$stmt = $db->query("SELECT COALESCE(SUM(quantity),0) as total FROM items");
$totalItems = (int)($stmt->fetch()['total'] ?? 0);
// Streak
$streak = 0;
for ($i = 0; $i < 365; $i++) {
$date = date('Y-m-d', strtotime("-$i days"));
$stmt = $db->prepare("SELECT COUNT(*) as count FROM completions WHERE completed_date = ?");
$stmt->execute([$date]);
$count = (int)($stmt->fetch()['count'] ?? 0);
if ($count > 0) $streak++;
else if ($i > 0) break;
}
// Flyer + emoji fallback poster
$emoji = $currentChampion['emoji'] ?? '⭐';
$emojiSvg = "";
$emojiDataUri = "data:image/svg+xml;charset=utf-8," . rawurlencode($emojiSvg);
$flyerUrl = getChampionImage($currentChampion['name'], 'flyer');
?>
•
""
Level - / XP
Total Quests
Completed
Streak
Items
Quests
No quests available
prepare("SELECT id FROM completions WHERE habit_id = ? AND completed_date = CURDATE()");
$stmt->execute([$habit['id']]);
$isCompleted = (bool)$stmt->fetch();
?>