query("SELECT * FROM habits ORDER BY FIELD(time_of_day, 'morning', 'midday', 'evening')");
$habits = $stmt->fetchAll();
// Get bounties
$stmt = $db->query("SELECT * FROM bounties WHERE completed = FALSE ORDER BY created_at DESC");
$bounties = $stmt->fetchAll();
// Get champion progress
$stmt = $db->prepare("SELECT xp, level FROM champion_progress WHERE champion_id = ?");
$stmt->execute([$currentChampion['id']]);
$progress = $stmt->fetch();
$xp = $progress['xp'] ?? 0;
$level = $progress['level'] ?? 1;
$maxXP = $level * 100;
$xpPercent = ($xp / $maxXP) * 100;
// Get stats
$stmt = $db->query("SELECT COUNT(*) as total FROM habits");
$totalQuests = $stmt->fetch()['total'];
$stmt = $db->prepare("SELECT COUNT(*) as completed FROM completions WHERE completed_date = CURDATE()");
$stmt->execute();
$completedToday = $stmt->fetch()['completed'];
$stmt = $db->query("SELECT SUM(quantity) as total FROM items");
$totalItems = $stmt->fetch()['total'] ?? 0;
// Calculate 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]);
if ($stmt->fetch()['count'] > 0) {
$streak++;
} else if ($i > 0) {
break;
}
}
?>
•
""
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 = $stmt->fetch();
?>