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']; // Prev/Next links $prevYear = ($month == 1) ? $year - 1 : $year; $prevMonth = ($month == 1) ? 12 : $month - 1; $nextYear = ($month == 12) ? $year + 1 : $year; $nextMonth = ($month == 12) ? 1 : $month + 1; ?>

📅 Quest Log

< Prev Next >

0); // Champion for that day $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 image for calendar (small icon) $avatarUrl = getChampionImage($champName, 'avatar'); // Emoji fallback (data URI) $emojiSvg = ""; $fallbackUri = "data:image/svg+xml;charset=utf-8," . rawurlencode($emojiSvg); ?>