prepare(" SELECT total_xp, level FROM champion_stats WHERE champion_id = ? "); $stmt->execute([$championId]); $stats = $stmt->fetch(); // Fetch today's habits $sql = " SELECT * FROM habits WHERE frequency = 'daily' OR (frequency = 'weekly' AND WEEKDAY(CURDATE()) = WEEKDAY(CURDATE())) OR (frequency = 'fortnightly' AND (WEEK(CURDATE()) % 2) = (WEEK(created_at) % 2)) OR (frequency = 'monthly' AND DAY(CURDATE()) = DAY(created_at)) OR (frequency = 'one_off' AND specific_date = CURDATE()) "; $habits = $pdo->query($sql)->fetchAll(); // Fetch today's completions $today = date('Y-m-d'); $completedStmt = $pdo->prepare(" SELECT COUNT(*) AS total FROM habit_completions WHERE champion_id = ? AND completion_date = ? "); $completedStmt->execute([$championId, $today]); $completedToday = $completedStmt->fetchColumn(); // Fetch total bounties completed today $bountyStmt = $pdo->prepare(" SELECT COUNT(*) AS total FROM habit_completions hc JOIN habits h ON h.id = hc.habit_id WHERE hc.champion_id = ? AND hc.completion_date = ? AND h.is_bounty = 1 "); $bountyStmt->execute([$championId, $today]); $bountiesToday = $bountyStmt->fetchColumn(); // Latest 5 items $latestItems = $pdo->query(" SELECT title, image_path, rarity FROM items ORDER BY id DESC LIMIT 5 ")->fetchAll(); // Depleted items (<20% remaining, only where quantity + max exist) $depletedStmt = $pdo->query(" SELECT title, image_path, quantity, quantity_max FROM items WHERE quantity_max IS NOT NULL AND quantity_max > 0 AND quantity IS NOT NULL AND (quantity / quantity_max) <= 0.2 ORDER BY (quantity / quantity_max) ASC "); $depletedItems = $depletedStmt->fetchAll(); ?> Dashboard

Today's Champion

Level

XP

Quick Stats

Habits Today:

Completed Today:

Bounties Completed:

Remaining:

Mini Calendar

$d) { $class = $i == $todayIndex ? "mini-day mini-today" : "mini-day"; echo "
$d
"; } ?>

Latest Items

No items yet.

Depleted Items (<= 20%)

Nothing low right now.

— / (%)

Today's Habits & Bounties

No habits today.

BOUNTY