12) $month = 12; $firstDay = (int)date('w', strtotime("$year-$month-1")); $daysInMonth = cal_days_in_month(CAL_GREGORIAN, $month, $year); $startDate = sprintf("%04d-%02d-01", $year, $month); $endDate = sprintf("%04d-%02d-%02d", $year, $month, $daysInMonth); // Completions for month: date => count $stmt = $db->prepare(" SELECT completed_date, COUNT(*) as count FROM completions WHERE completed_date BETWEEN ? AND ? GROUP BY completed_date "); $stmt->execute([$startDate, $endDate]); $completions = $stmt->fetchAll(PDO::FETCH_KEY_PAIR); $days = ['Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat']; $prevYear = ($month == 1) ? $year - 1 : $year; $prevMonth = ($month == 1) ? 12 : $month - 1; $nextYear = ($month == 12) ? $year + 1 : $year; $nextMonth = ($month == 12) ? 1 : $month + 1; function _e($v): string { return htmlspecialchars((string)$v, ENT_QUOTES, 'UTF-8'); } function emojiDataUriLocal(string $emoji): string { $emoji = $emoji ?: '⭐'; $svg = ""; return "data:image/svg+xml;charset=utf-8," . rawurlencode($svg); } ?>

📅 Quest Log

< Prev Next >

0); // Champion for that weekday $stmt = $db->prepare("SELECT name, emoji FROM champions WHERE day_index = ? LIMIT 1"); $stmt->execute([$dayOfWeek]); $dayChampion = $stmt->fetch() ?: []; $champName = $dayChampion['name'] ?? 'Unknown'; $champEmoji = $dayChampion['emoji'] ?? '⭐'; // ✅ Use AVATAR icon in calendar $avatarUrl = getChampionImage($champName, 'avatar'); // Fallback emoji circle if avatar missing $fallback = emojiDataUriLocal($champEmoji); ?>