{title}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_460":461,"_462":463},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":59,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",174,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","sync.ts","latestPath","fileId","78b38fda-5d46-11f1-bd79-1607ee4eb77e","name","fileType","interval","content","// Two-source sync, runs every 20 minutes:\n// 1. worldcup26.ir → live match scores (status, score1, score2) into matches_v1.\n// Group fixtures key by (stage, {home, away} as a set): each team pair is\n// unique across the tournament, so the pair alone identifies a fixture.\n// Knockout fixtures are seeded with placeholder slots and no team_ids, so\n// they key by id instead (the official FIFA match numbers 73–104 are shared\n// across both feeds) — and the first time the API names a knockout\n// fixture's teams we persist them, after which scores flow as normal.\n// 2. openfootball/worldcup.json → per-player goal tallies into players_v1.\n// Same source seed.ts uses for fixtures, so no new auth or rate limits.\n// Update lag is community-maintained — typically hours behind, not days.\n\nimport {\n allMatches,\n allPlayers,\n allTeams,\n setSyncMetadata,\n sqlite,\n type MatchRow,\n type TeamRow,\n} from \"./db.ts\";\nimport { canonicalTeamName } from \"./lib/team_aliases.ts\";\nimport { canonicalPlayerName } from \"./lib/player_aliases.ts\";\n\nconst FIXTURES_URL = \"https://worldcup26.ir/get/games\";\nconst OPENFOOTBALL_URL =\n \"https://raw.githubusercontent.com/openfootball/worldcup.json/master/2026/worldcup.json\";\n\ntype WCGame = {\n id: string;\n home_team_name_en?: string;\n away_team_name_en?: string;\n home_score: string;\n away_score: string;\n finished: string; // \"TRUE\" / \"FALSE\"\n time_elapsed: string; // \"notstarted\", \"HT\", \"FT\", \"45'\", \"90+2'\", etc.\n type: string; // \"group\", \"r32\", \"r16\", \"qf\", \"sf\", \"third\", \"final\"\n // Knockout fixtures carry no team names until the bracket resolves; instead\n // they expose a slot label, e.g. \"Winner Group H\", \"Runner-up Group J\",\n // \"3rd Group E/F/G/I/J\", \"Winner Match 73\", \"Loser Match 101\".\n home_team_label?: string;\n away_team_label?: string;\n // Penalty-shootout scores, present (and non-\"null\") only for a knockout\n // fixture the feed has recorded as decided on penalties. Absent or the\n // string \"null\" for every other fixture.\n home_penalty_score?: string;\n away_penalty_score?: string;\n};\n\ntype OFGoal = {\n // openfootball encodes the minute as a string, with stoppage time inline,\n // e.g. \"9\", \"67\", \"90+4\", \"45+5\". Older snapshots used a number plus a\n // separate `offset`; both shapes are handled by parseGoalMinute.\n name: string;\n minute: number | string;\n offset?: number;\n penalty?: boolean;\n owngoal?: boolean;\n og?: boolean;\n};\n\ntype OFMatch = {\n date: string;\n time: string;\n team1: string;\n team2: string;\n goals1?: OFGoal[];\n goals2?: OFGoal[];\n};\n\nfunction pairKey(a: string, b: string): string {\n return [a, b].sort().join(\"|\");\n}\n\nfunction parseScore(s: string): number | null {\n if (s == null || s === \"\" || s.toLowerCase() === \"null\") return null;\n const n = parseInt(s, 10);\n return Number.isFinite(n) ? n : null;\n}\n\nfunction mapStatus(g: WCGame): string {\n if (g.finished === \"TRUE\") return \"finished\";\n const te = g.time_elapsed?.toUpperCase() ?? \"\";\n if (te === \"HT\" || te === \"HALF TIME\" || te === \"HALFTIME\") return \"ht\";\n if (te === \"\" || te === \"NOTSTARTED\" || te === \"NS\" || te === \"TBD\") {\n return \"scheduled\";\n }\n return \"live\";\n}\n\nasync function ensureMatchColumns() {\n // Columns added after the original seed schema. Each ALTER throws harmlessly\n // once the column exists, so every run is idempotent.\n for (\n const ddl of [\n \"ALTER TABLE matches_v1 ADD COLUMN external_id TEXT\",\n \"ALTER TABLE matches_v1 ADD COLUMN penalty1 INTEGER\",\n \"ALTER TABLE matches_v1 ADD COLUMN penalty2 INTEGER\",\n ]\n ) {\n try {\n await sqlite.execute(ddl);\n } catch (_e) {\n // already exists\n }\n }\n}\n\nasync function fetchAllFixtures(): Promise {\n const resp = await fetch(FIXTURES_URL, {\n headers: { \"Accept\": \"application/json\" },\n });\n if (!resp.ok) {\n throw new Error(`worldcup26.ir ${resp.status}: ${await resp.text()}`);\n }\n const json = await resp.json() as { games?: WCGame[] };\n return json.games ?? [];\n}\n\n// Translate a worldcup26.ir knockout slot label into our DB placeholder form,\n// so the two can be compared. \"Winner Group H\" → \"1H\", \"Runner-up Group J\" →\n// \"2J\", \"3rd Group E/F/G/I/J\" → \"3E/F/G/I/J\", \"Winner Match 73\" → \"W73\",\n// \"Loser Match 101\" → \"L101\". Returns null for an unrecognised shape.\nfunction normalizeApiLabel(label: string): string | null {\n let m: RegExpExecArray | null;\n if ((m = /^Winner Group ([A-L])$/.exec(label))) return `1${m[1]}`;\n if ((m = /^Runner-up Group ([A-L])$/.exec(label))) return `2${m[1]}`;\n if ((m = /^3rd Group ([A-L/]+)$/.exec(label))) return `3${m[1]}`;\n if ((m = /^Winner Match (\\d+)$/.exec(label))) return `W${m[1]}`;\n if ((m = /^Loser Match (\\d+)$/.exec(label))) return `L${m[1]}`;\n return null;\n}\n\n// True when a normalized API slot and a DB placeholder denote the same slot.\n// Third-place slots (\"3E/F/G/I/J\") are compared as a set so a difference in\n// the group-letter ordering between the two feeds is not flagged.\nfunction slotsAlign(apiSlot: string, dbSlot: string): boolean {\n if (apiSlot === dbSlot) return true;\n const a = /^3(.+)$/.exec(apiSlot);\n const b = /^3(.+)$/.exec(dbSlot);\n if (a && b) {\n return a[1].split(\"/\").sort().join(\"/\") === b[1].split(\"/\").sort().join(\"/\");\n }\n return false;\n}\n\n// Our knockout resolution keys an API fixture to its DB row by id, trusting\n// that the official FIFA match numbers 73–104 are identical across both feeds\n// (group-stage ids are not — the feeds order group fixtures differently). This\n// check guards that trust: while a knockout fixture is still unresolved it\n// carries slot labels, so we can confirm the API's slots match the DB row's\n// placeholders for the same id. It runs every sync through the group stage —\n// exactly the window before any wrong assignment could happen — and returns a\n// list of mismatches for the caller to log loudly. Slot order (home/away vs\n// team1/team2) is ignored; only the pair of slots must match.\nfunction checkKnockoutIdAlignment(\n fixtures: WCGame[],\n matchById: Map,\n): string[] {\n const warnings: string[] = [];\n for (const f of fixtures) {\n if (f.type === \"group\") continue;\n if (!f.home_team_label || !f.away_team_label) continue; // already resolved\n const dbMatch = matchById.get(Number(f.id));\n if (!dbMatch) {\n warnings.push(`api ${f.type} #${f.id} has no DB match with that id`);\n continue;\n }\n const a1 = normalizeApiLabel(f.home_team_label);\n const a2 = normalizeApiLabel(f.away_team_label);\n if (a1 == null || a2 == null) {\n warnings.push(\n `api #${f.id} unparseable label: \"${f.home_team_label}\" / \"${f.away_team_label}\"`,\n );\n continue;\n }\n const p1 = dbMatch.team1_placeholder ?? \"\";\n const p2 = dbMatch.team2_placeholder ?? \"\";\n const direct = slotsAlign(a1, p1) && slotsAlign(a2, p2);\n const swapped = slotsAlign(a1, p2) && slotsAlign(a2, p1);\n if (!direct && !swapped) {\n warnings.push(\n `api #${f.id} (${a1}/${a2}) != db #${dbMatch.id} (${p1}/${p2})`,\n );\n }\n }\n return warnings;\n}\n\n// Which teams may legitimately fill a knockout slot, judged from OUR own data\n// rather than the feed's say-so. A group slot (\"1L\", \"2C\", \"3E/H/I/J/K\") is\n// constrained to teams from the named group(s); a match slot (\"W80\", \"L101\")\n// to the winner/loser of that match once it has a decisive result. Returns a\n// predicate, or null when the slot can't be constrained yet (a match slot whose\n// source is unfinished or went to penalties) — the caller then accepts the\n// feed's name rather than blocking on data we don't have.\nfunction slotEligibility(\n placeholder: string | null,\n teamById: Map,\n matchById: Map,\n): ((teamId: number) => boolean) | null {\n if (!placeholder) return null;\n let m: RegExpExecArray | null;\n if ((m = /^[12]([A-L])$/.exec(placeholder))) {\n const group = m[1];\n return (id) => teamById.get(id)?.group_letter === group;\n }\n if ((m = /^3([A-L/]+)$/.exec(placeholder))) {\n const groups = new Set(m[1].split(\"/\"));\n return (id) => groups.has(teamById.get(id)?.group_letter ?? \"\");\n }\n if ((m = /^([WL])(\\d+)$/.exec(placeholder))) {\n const wantWinner = m[1] === \"W\";\n const src = matchById.get(Number(m[2]));\n if (\n !src || src.status !== \"finished\" ||\n src.score1 == null || src.score2 == null || src.score1 === src.score2 ||\n src.team1_id == null || src.team2_id == null\n ) {\n return null; // undecided or penalties — nothing to constrain against yet\n }\n const winner = src.score1 > src.score2 ? src.team1_id : src.team2_id;\n const want = wantWinner ? winner : (winner === src.team1_id ? src.team2_id : src.team1_id);\n return (id) => id === want;\n }\n return null;\n}\n\ntype Key = string; // `${stage}|${pairKey}`\n\nfunction indexMatches(matches: MatchRow[], teamById: Map): Map {\n const out = new Map();\n for (const m of matches) {\n if (m.team1_id == null || m.team2_id == null) continue;\n const t1 = teamById.get(m.team1_id);\n const t2 = teamById.get(m.team2_id);\n if (!t1 || !t2) continue;\n out.set(`${m.stage}|${pairKey(t1.name, t2.name)}`, m);\n }\n return out;\n}\n\nasync function syncLiveScores() {\n await ensureFixtureIdColumn();\n\n const [teams, matches] = await Promise.all([allTeams(), allMatches()]);\n const teamById = new Map(teams.map((t) => [t.id, t]));\n const teamIdByName = new Map(teams.map((t) => [t.name, t.id]));\n const matchByKey = indexMatches(matches, teamById);\n const matchById = new Map(matches.map((m) => [m.id, m]));\n\n const fixtures = await fetchAllFixtures();\n console.log(`worldcup26.ir returned ${fixtures.length} fixtures.`);\n\n // Loud warning if the knockout id mapping ever drifts. Non-fatal — score\n // sync for live group matches must not break over a label-format change.\n const koWarnings = checkKnockoutIdAlignment(fixtures, matchById);\n if (koWarnings.length) {\n console.error(\n \"KO_ID_ALIGNMENT mismatch — knockout resolution by id is unsafe:\",\n JSON.stringify(koWarnings),\n );\n }\n\n let updated = 0;\n let resolved = 0;\n let corrected = 0;\n let unmatched = 0;\n const unmatchedSamples: string[] = [];\n const unknownTeams = new Set();\n const invalidSlots: string[] = [];\n\n for (const f of fixtures) {\n const homeRaw = f.home_team_name_en;\n const awayRaw = f.away_team_name_en;\n // Unresolved fixtures carry no team names — a knockout slot before its\n // bracket resolves. Nothing to match or score yet.\n if (!homeRaw || !awayRaw) continue;\n\n const home = canonicalTeamName(homeRaw);\n const away = canonicalTeamName(awayRaw);\n const isKnockout = f.type !== \"group\";\n\n // Group fixtures key by team pair (unique across the tournament). Knockout\n // fixtures key by id — the DB row is seeded with placeholder slots and no\n // team_ids, so a pair lookup can't find it. See checkKnockoutIdAlignment\n // for why id keying is sound (and guarded).\n const dbMatch = isKnockout\n ? matchById.get(Number(f.id))\n : matchByKey.get(`${f.type}|${pairKey(home, away)}`);\n\n // Bind the feed's named teams to this knockout slot only if they satisfy the\n // slot's own qualification rule, judged from OUR data — group membership for\n // R32 slots (\"1L\", \"3E/H/I/J/K\"), or the source match's winner/loser later\n // (\"W80\"). This is the front-line guard: it rejects a feed glitch that names\n // the wrong team for a fixture id (e.g. a group-G team handed to the \"Winner\n // Group L\" slot), the failure that otherwise freezes a wrong pairing in and\n // wrongly eliminates a qualified team. The re-resolve-on-mismatch path below\n // is the backstop if a bad pairing ever does land. Stamped on the in-memory\n // row here; persisted by the UPDATE below.\n if (isKnockout && dbMatch) {\n const homeId = teamIdByName.get(home);\n const awayId = teamIdByName.get(away);\n if (homeId && awayId) {\n const fits1 = slotEligibility(dbMatch.team1_placeholder, teamById, matchById);\n const fits2 = slotEligibility(dbMatch.team2_placeholder, teamById, matchById);\n const ok = (fits: ((id: number) => boolean) | null, id: number) =>\n fits == null || fits(id);\n // Assign each named team to the slot it satisfies, so team_id and\n // placeholder stay consistent. An unconstrained slot (null) falls back\n // to feed order (home→team1).\n let t1: number | null = null;\n let t2: number | null = null;\n if (ok(fits1, homeId) && ok(fits2, awayId)) {\n t1 = homeId;\n t2 = awayId;\n } else if (ok(fits1, awayId) && ok(fits2, homeId)) {\n t1 = awayId;\n t2 = homeId;\n }\n\n if (t1 == null || t2 == null) {\n // Neither arrangement satisfies the slot rules — the feed is wrong for\n // this fixture. Skip; leave any prior correct resolution intact.\n invalidSlots.push(\n `#${dbMatch.id} ${home} v ${away} != ${dbMatch.team1_placeholder}/${dbMatch.team2_placeholder}`,\n );\n } else {\n const stored = new Set([dbMatch.team1_id, dbMatch.team2_id]);\n const sameTeams = dbMatch.team1_id != null && stored.size === 2 &&\n stored.has(t1) && stored.has(t2);\n if (dbMatch.team1_id == null) {\n dbMatch.team1_id = t1;\n dbMatch.team2_id = t2;\n resolved++;\n } else if (!sameTeams) {\n // Backstop: a previously-stored pairing disagrees — correct it.\n dbMatch.team1_id = t1;\n dbMatch.team2_id = t2;\n corrected++;\n }\n }\n } else {\n if (!homeId) unknownTeams.add(home);\n if (!awayId) unknownTeams.add(away);\n }\n }\n\n if (!dbMatch || dbMatch.team1_id == null || dbMatch.team2_id == null) {\n unmatched++;\n if (unmatchedSamples.length < 5) {\n unmatchedSamples.push(`${f.type} ${home} v ${away}`);\n }\n continue;\n }\n\n const status = mapStatus(f);\n const apiHomeScore = parseScore(f.home_score);\n const apiAwayScore = parseScore(f.away_score);\n // Map home/away → our team1/team2 (the DB has a canonical order)\n const t1Name = teamById.get(dbMatch.team1_id)!.name;\n const homeIsTeam1 = t1Name === home;\n const score1 = homeIsTeam1 ? apiHomeScore : apiAwayScore;\n const score2 = homeIsTeam1 ? apiAwayScore : apiHomeScore;\n\n await sqlite.execute({\n sql: `UPDATE matches_v1\n SET team1_id = ?, team2_id = ?, score1 = ?, score2 = ?,\n status = ?, external_id = ?\n WHERE id = ?`,\n args: [\n dbMatch.team1_id,\n dbMatch.team2_id,\n score1,\n score2,\n status,\n f.id,\n dbMatch.id,\n ],\n });\n updated++;\n }\n\n // A KO fixture whose feed-named teams don't fit its slot is a feed error we\n // refused to persist — surface it as loudly as an id-alignment mismatch.\n if (invalidSlots.length) {\n console.error(\n \"KO_SLOT_REJECTED — feed named teams that don't fit the slot; skipped:\",\n JSON.stringify(invalidSlots),\n );\n }\n\n return {\n fetched: fixtures.length,\n updated,\n resolved,\n corrected,\n unmatched,\n unmatchedSamples,\n unknownTeams: [...unknownTeams],\n invalidSlots,\n koWarnings,\n };\n}\n\nfunction parseKickoffUtc(date: string, time: string): string {\n const m = /^(\\d{1,2}):(\\d{2})\\s+UTC([+-]\\d+)$/.exec(time);\n if (!m) throw new Error(`bad time format: ${time}`);\n const [, hh, mm, offsetStr] = m;\n const offsetH = parseInt(offsetStr, 10);\n const localH = parseInt(hh, 10);\n const utcH = localH - offsetH;\n const [yyyy, mo, dd] = date.split(\"-\").map(Number);\n return new Date(Date.UTC(yyyy, mo - 1, dd, utcH, parseInt(mm, 10))).toISOString();\n}\n\n// Resolve an openfootball goal minute to a single integer count of minutes\n// from kickoff. Handles a numeric minute (legacy), a plain string (\"67\"), and\n// stoppage time encoded inline (\"90+4\" → 94). Returns null for any shape we\n// can't read, so a feed format drift degrades to \"no timestamp\" rather than\n// crashing the whole goals sync.\nfunction parseGoalMinute(raw: number | string | undefined): number | null {\n if (typeof raw === \"number\") return Number.isFinite(raw) ? raw : null;\n if (typeof raw === \"string\") {\n const m = /^(\\d+)(?:\\+(\\d+))?$/.exec(raw.trim());\n if (!m) return null;\n return parseInt(m[1], 10) + (m[2] ? parseInt(m[2], 10) : 0);\n }\n return null;\n}\n\nfunction goalTimeUtc(kickoffUtc: string, totalMinute: number): string {\n return new Date(new Date(kickoffUtc).getTime() + totalMinute * 60_000)\n .toISOString();\n}\n\nasync function syncPlayerGoals() {\n // 10s cap so a hung fetch throws into the caller's try/catch rather than\n // taking out the whole interval. Score sync has already completed by this\n // point — only the run summary log is at risk.\n const resp = await fetch(OPENFOOTBALL_URL, {\n signal: AbortSignal.timeout(10_000),\n });\n if (!resp.ok) {\n throw new Error(`openfootball ${resp.status}: ${await resp.text()}`);\n }\n const data = (await resp.json()) as { matches: OFMatch[] };\n\n const players = await allPlayers();\n const canonicalNames = new Set(players.map((p) => p.name));\n const playerByName = new Map(players.map((p) => [p.name, p]));\n\n // Aggregate goals per canonical player\n type Tally = { goals: number; firstGoalUtc: string | null };\n const tally = new Map();\n const unknownScorers = new Set();\n let totalGoals = 0;\n let creditedGoals = 0;\n let unparseableMinutes = 0;\n\n for (const m of data.matches) {\n let kickoffUtc: string | null = null;\n const allGoals = [\n ...(m.goals1 ?? []),\n ...(m.goals2 ?? []),\n ];\n for (const g of allGoals) {\n totalGoals++;\n // Own goals don't count for the Golden Boot\n if (g.owngoal || g.og) continue;\n const canonical = canonicalPlayerName(g.name, canonicalNames);\n if (!canonical) {\n unknownScorers.add(g.name);\n continue;\n }\n const t = tally.get(canonical) ?? { goals: 0, firstGoalUtc: null };\n t.goals += 1;\n creditedGoals++;\n // The goal count is the headline number and is always credited. The\n // timestamp only feeds the Golden Boot tiebreaker (earliest first goal),\n // so an unreadable minute drops the timestamp for this goal rather than\n // dropping the goal or failing the sync.\n const total = parseGoalMinute(g.minute);\n if (total != null) {\n kickoffUtc ??= parseKickoffUtc(m.date, m.time);\n const utc = goalTimeUtc(kickoffUtc, total + (g.offset ?? 0));\n if (!t.firstGoalUtc || utc < t.firstGoalUtc) t.firstGoalUtc = utc;\n } else {\n unparseableMinutes++;\n }\n tally.set(canonical, t);\n }\n }\n\n // Reset every player to (goals=0, first_goal_utc=null), then apply tallies.\n // Avoids drift when openfootball corrects a misattributed goal.\n await sqlite.execute(\"UPDATE players_v1 SET goals = 0, first_goal_utc = NULL\");\n if (tally.size > 0) {\n await sqlite.batch(\n [...tally.entries()].map(([name, t]) => {\n const player = playerByName.get(name)!;\n return {\n sql: `UPDATE players_v1 SET goals = ?, first_goal_utc = ?\n WHERE id = ?`,\n args: [t.goals, t.firstGoalUtc, player.id],\n };\n }),\n );\n }\n\n await setSyncMetadata(\"goals_last_updated_utc\", new Date().toISOString());\n\n return {\n totalGoals,\n creditedGoals,\n unparseableMinutes,\n playersScored: tally.size,\n unknownScorers: [...unknownScorers].slice(0, 10),\n };\n}\n\n// Recompute eliminated_at_stage for every team based on current match state.\n//\n// A team is eliminated when either:\n// (a) they lost a knockout match → marked at that stage (first loss wins),\n// (b) all group stage matches are finished AND no knockout fixture features\n// them — they failed to qualify → marked \"group\".\n// A team that has won every knockout match they've played remains alive even\n// after the final; the eventual champion stays unmarked.\nasync function recomputeEliminations(): Promise {\n await sqlite.execute(\"UPDATE teams_v1 SET eliminated_at_stage = NULL\");\n\n // (a) Knockout losers: stage of their first finished KO loss\n await sqlite.execute(`\n UPDATE teams_v1\n SET eliminated_at_stage = (\n SELECT stage FROM matches_v1 m\n WHERE m.stage != 'group' AND m.status = 'finished'\n AND m.score1 IS NOT NULL AND m.score2 IS NOT NULL\n AND m.score1 != m.score2\n AND ((m.team1_id = teams_v1.id AND m.score1 < m.score2)\n OR (m.team2_id = teams_v1.id AND m.score2 < m.score1))\n ORDER BY m.kickoff_utc ASC\n LIMIT 1\n )\n WHERE EXISTS (\n SELECT 1 FROM matches_v1 m\n WHERE m.stage != 'group' AND m.status = 'finished'\n AND m.score1 IS NOT NULL AND m.score2 IS NOT NULL\n AND m.score1 != m.score2\n AND ((m.team1_id = teams_v1.id AND m.score1 < m.score2)\n OR (m.team2_id = teams_v1.id AND m.score2 < m.score1))\n )\n `);\n\n // (b) Group-stage failures: every group match finished AND not in any KO fixture\n const groupDone = await sqlite.execute(\n `SELECT COUNT(*) AS n FROM matches_v1 WHERE stage = 'group' AND status != 'finished'`,\n );\n const groupRemaining = Number((groupDone.rows[0] as Record).n ?? 0);\n\n // Only mark group-stage failures once the Round of 32 is fully resolved (all\n // 16 fixtures have both teams). Between the last group match finishing and\n // the API resolving the bracket, no KO match has team_ids — so \"not in any KO\n // fixture\" would be true for every qualifier and wrongly eliminate them all.\n const r32 = await sqlite.execute(\n `SELECT COUNT(*) AS n FROM matches_v1\n WHERE stage = 'r32' AND team1_id IS NOT NULL AND team2_id IS NOT NULL`,\n );\n const r32Resolved = Number((r32.rows[0] as Record).n ?? 0);\n\n if (groupRemaining === 0 && r32Resolved === 16) {\n await sqlite.execute(`\n UPDATE teams_v1\n SET eliminated_at_stage = 'group'\n WHERE eliminated_at_stage IS NULL\n AND NOT EXISTS (\n SELECT 1 FROM matches_v1 m\n WHERE m.stage != 'group'\n AND (m.team1_id = teams_v1.id OR m.team2_id = teams_v1.id)\n )\n `);\n }\n\n const r = await sqlite.execute(\n \"SELECT COUNT(*) AS n FROM teams_v1 WHERE eliminated_at_stage IS NOT NULL\",\n );\n return Number((r.rows[0] as Record).n ?? 0);\n}\n\nexport default async function sync(_interval: Interval) {\n const scores = await syncLiveScores();\n const eliminated = await recomputeEliminations();\n\n // Goal sync is wrapped so an openfootball outage doesn't break score sync.\n // The Top Scorer prize is a side prize; live scores are the headline.\n let goals: Awaited> | { error: string };\n try {\n goals = await syncPlayerGoals();\n } catch (e) {\n goals = { error: e instanceof Error ? e.message : String(e) };\n }\n\n const summary = { ...scores, eliminated, goals };\n console.log(\"sync complete:\", JSON.stringify(summary));\n return summary;\n}\n","// Two-source sync, runs every 20 minutes:\n// 1. worldcup26.ir → live match scores (status, score1, score2) into matches_v1.\n// Group fixtures key by (stage, {home, away} as a set): each team pair is\n// unique across the tournament, so the pair alone identifies a fixture.\n// Knockout fixtures are seeded with placeholder slots and no team_ids, so\n// they key by id instead (the official FIFA match numbers 73–104 are shared\n// across both feeds) — and the first time the API names a knockout\n// fixture's teams we persist them, after which scores flow as normal.\n// 2. openfootball/worldcup.json → per-player goal tallies into players_v1.\n// Same source seed.ts uses for fixtures, so no new auth or rate limits.\n// Update lag is community-maintained — typically hours behind, not days.\n\nimport {\n allMatches,\n allPlayers,\n allTeams,\n setSyncMetadata,\n sqlite,\n type MatchRow,\n type TeamRow,\n} from \"./db.ts\";\nimport { canonicalTeamName } from \"./lib/team_aliases.ts\";\nimport { canonicalPlayerName } from \"./lib/player_aliases.ts\";\n\nconst FIXTURES_URL = \"https://worldcup26.ir/get/games\";\nconst OPENFOOTBALL_URL =\n \"https://raw.githubusercontent.com/openfootball/worldcup.json/master/2026/worldcup.json\";\n\ntype WCGame = {\n id: string;\n home_team_name_en?: string;\n away_team_name_en?: string;\n home_score: string;\n away_score: string;\n finished: string; // \"TRUE\" / \"FALSE\"\n time_elapsed: string; // \"notstarted\", \"HT\", \"FT\", \"45'\", \"90+2'\", etc.\n type: string; // \"group\", \"r32\", \"r16\", \"qf\", \"sf\", \"third\", \"final\"\n // Knockout fixtures carry no team names until the bracket resolves; instead\n // they expose a slot label, e.g. \"Winner Group H\", \"Runner-up Group J\",\n // \"3rd Group E/F/G/I/J\", \"Winner Match 73\", \"Loser Match 101\".\n home_team_label?: string;\n away_team_label?: string;\n // Penalty-shootout scores, present (and non-\"null\") only for a knockout\n // fixture the feed has recorded as decided on penalties. Absent or the\n // string \"null\" for every other fixture.\n home_penalty_score?: string;\n away_penalty_score?: string;\n};\n\ntype OFGoal = {\n // openfootball encodes the minute as a string, with stoppage time inline,\n // e.g. \"9\", \"67\", \"90+4\", \"45+5\". Older snapshots used a number plus a\n // separate `offset`; both shapes are handled by parseGoalMinute.\n name: string;\n minute: number | string;\n offset?: number;\n penalty?: boolean;\n owngoal?: boolean;\n og?: boolean;\n};\n\ntype OFMatch = {\n date: string;\n time: string;\n team1: string;\n team2: string;\n goals1?: OFGoal[];\n goals2?: OFGoal[];\n};\n\nfunction pairKey(a: string, b: string): string {\n return [a, b].sort().join(\"|\");\n}\n\nfunction parseScore(s: string): number | null {\n if (s == null || s === \"\" || s.toLowerCase() === \"null\") return null;\n const n = parseInt(s, 10);\n return Number.isFinite(n) ? n : null;\n}\n\nfunction mapStatus(g: WCGame): string {\n if (g.finished === \"TRUE\") return \"finished\";\n const te = g.time_elapsed?.toUpperCase() ?? \"\";\n if (te === \"HT\" || te === \"HALF TIME\" || te === \"HALFTIME\") return \"ht\";\n if (te === \"\" || te === \"NOTSTARTED\" || te === \"NS\" || te === \"TBD\") {\n return \"scheduled\";\n }\n return \"live\";\n}\n\nasync function ensureMatchColumns() {\n // Columns added after the original seed schema. Each ALTER throws harmlessly\n // once the column exists, so every run is idempotent.\n for (\n const ddl of [\n \"ALTER TABLE matches_v1 ADD COLUMN external_id TEXT\",\n \"ALTER TABLE matches_v1 ADD COLUMN penalty1 INTEGER\",\n \"ALTER TABLE matches_v1 ADD COLUMN penalty2 INTEGER\",\n ]\n ) {\n try {\n await sqlite.execute(ddl);\n } catch (_e) {\n // already exists\n }\n }\n}\n\nasync function fetchAllFixtures(): Promise {\n const resp = await fetch(FIXTURES_URL, {\n headers: { \"Accept\": \"application/json\" },\n });\n if (!resp.ok) {\n throw new Error(`worldcup26.ir ${resp.status}: ${await resp.text()}`);\n }\n const json = await resp.json() as { games?: WCGame[] };\n return json.games ?? [];\n}\n\n// Translate a worldcup26.ir knockout slot label into our DB placeholder form,\n// so the two can be compared. \"Winner Group H\" → \"1H\", \"Runner-up Group J\" →\n// \"2J\", \"3rd Group E/F/G/I/J\" → \"3E/F/G/I/J\", \"Winner Match 73\" → \"W73\",\n// \"Loser Match 101\" → \"L101\". Returns null for an unrecognised shape.\nfunction normalizeApiLabel(label: string): string | null {\n let m: RegExpExecArray | null;\n if ((m = /^Winner Group ([A-L])$/.exec(label))) return `1${m[1]}`;\n if ((m = /^Runner-up Group ([A-L])$/.exec(label))) return `2${m[1]}`;\n if ((m = /^3rd Group ([A-L/]+)$/.exec(label))) return `3${m[1]}`;\n if ((m = /^Winner Match (\\d+)$/.exec(label))) return `W${m[1]}`;\n if ((m = /^Loser Match (\\d+)$/.exec(label))) return `L${m[1]}`;\n return null;\n}\n\n// True when a normalized API slot and a DB placeholder denote the same slot.\n// Third-place slots (\"3E/F/G/I/J\") are compared as a set so a difference in\n// the group-letter ordering between the two feeds is not flagged.\nfunction slotsAlign(apiSlot: string, dbSlot: string): boolean {\n if (apiSlot === dbSlot) return true;\n const a = /^3(.+)$/.exec(apiSlot);\n const b = /^3(.+)$/.exec(dbSlot);\n if (a && b) {\n return a[1].split(\"/\").sort().join(\"/\") === b[1].split(\"/\").sort().join(\"/\");\n }\n return false;\n}\n\n// Our knockout resolution keys an API fixture to its DB row by id, trusting\n// that the official FIFA match numbers 73–104 are identical across both feeds\n// (group-stage ids are not — the feeds order group fixtures differently). This\n// check guards that trust: while a knockout fixture is still unresolved it\n// carries slot labels, so we can confirm the API's slots match the DB row's\n// placeholders for the same id. It runs every sync through the group stage —\n// exactly the window before any wrong assignment could happen — and returns a\n// list of mismatches for the caller to log loudly. Slot order (home/away vs\n// team1/team2) is ignored; only the pair of slots must match.\nfunction checkKnockoutIdAlignment(\n fixtures: WCGame[],\n matchById: Map,\n): string[] {\n const warnings: string[] = [];\n for (const f of fixtures) {\n if (f.type === \"group\") continue;\n if (!f.home_team_label || !f.away_team_label) continue; // already resolved\n const dbMatch = matchById.get(Number(f.id));\n if (!dbMatch) {\n warnings.push(`api ${f.type} #${f.id} has no DB match with that id`);\n continue;\n }\n const a1 = normalizeApiLabel(f.home_team_label);\n const a2 = normalizeApiLabel(f.away_team_label);\n if (a1 == null || a2 == null) {\n warnings.push(\n `api #${f.id} unparseable label: \"${f.home_team_label}\" / \"${f.away_team_label}\"`,\n );\n continue;\n }\n const p1 = dbMatch.team1_placeholder ?? \"\";\n const p2 = dbMatch.team2_placeholder ?? \"\";\n const direct = slotsAlign(a1, p1) && slotsAlign(a2, p2);\n const swapped = slotsAlign(a1, p2) && slotsAlign(a2, p1);\n if (!direct && !swapped) {\n warnings.push(\n `api #${f.id} (${a1}/${a2}) != db #${dbMatch.id} (${p1}/${p2})`,\n );\n }\n }\n return warnings;\n}\n\n// Which teams may legitimately fill a knockout slot, judged from OUR own data\n// rather than the feed's say-so. A group slot (\"1L\", \"2C\", \"3E/H/I/J/K\") is\n// constrained to teams from the named group(s); a match slot (\"W80\", \"L101\")\n// to the winner/loser of that match once it has a decisive result. Returns a\n// predicate, or null when the slot can't be constrained yet (a match slot whose\n// source is unfinished or went to penalties) — the caller then accepts the\n// feed's name rather than blocking on data we don't have.\nfunction slotEligibility(\n placeholder: string | null,\n teamById: Map,\n matchById: Map,\n): ((teamId: number) => boolean) | null {\n if (!placeholder) return null;\n let m: RegExpExecArray | null;\n if ((m = /^[12]([A-L])$/.exec(placeholder))) {\n const group = m[1];\n return (id) => teamById.get(id)?.group_letter === group;\n }\n if ((m = /^3([A-L/]+)$/.exec(placeholder))) {\n const groups = new Set(m[1].split(\"/\"));\n return (id) => groups.has(teamById.get(id)?.group_letter ?? \"\");\n }\n if ((m = /^([WL])(\\d+)$/.exec(placeholder))) {\n const wantWinner = m[1] === \"W\";\n const src = matchById.get(Number(m[2]));\n if (\n !src || src.status !== \"finished\" ||\n src.score1 == null || src.score2 == null || src.score1 === src.score2 ||\n src.team1_id == null || src.team2_id == null\n ) {\n return null; // undecided or penalties — nothing to constrain against yet\n }\n const winner = src.score1 > src.score2 ? src.team1_id : src.team2_id;\n const want = wantWinner ? winner : (winner === src.team1_id ? src.team2_id : src.team1_id);\n return (id) => id === want;\n }\n return null;\n}\n\ntype Key = string; // `${stage}|${pairKey}`\n\nfunction indexMatches(matches: MatchRow[], teamById: Map): Map {\n const out = new Map();\n for (const m of matches) {\n if (m.team1_id == null || m.team2_id == null) continue;\n const t1 = teamById.get(m.team1_id);\n const t2 = teamById.get(m.team2_id);\n if (!t1 || !t2) continue;\n out.set(`${m.stage}|${pairKey(t1.name, t2.name)}`, m);\n }\n return out;\n}\n\nasync function syncLiveScores() {\n await ensureMatchColumns();\n\n const [teams, matches] = await Promise.all([allTeams(), allMatches()]);\n const teamById = new Map(teams.map((t) => [t.id, t]));\n const teamIdByName = new Map(teams.map((t) => [t.name, t.id]));\n const matchByKey = indexMatches(matches, teamById);\n const matchById = new Map(matches.map((m) => [m.id, m]));\n\n const fixtures = await fetchAllFixtures();\n console.log(`worldcup26.ir returned ${fixtures.length} fixtures.`);\n\n // Loud warning if the knockout id mapping ever drifts. Non-fatal — score\n // sync for live group matches must not break over a label-format change.\n const koWarnings = checkKnockoutIdAlignment(fixtures, matchById);\n if (koWarnings.length) {\n console.error(\n \"KO_ID_ALIGNMENT mismatch — knockout resolution by id is unsafe:\",\n JSON.stringify(koWarnings),\n );\n }\n\n let updated = 0;\n let resolved = 0;\n let corrected = 0;\n let unmatched = 0;\n const unmatchedSamples: string[] = [];\n const unknownTeams = new Set();\n const invalidSlots: string[] = [];\n\n for (const f of fixtures) {\n const homeRaw = f.home_team_name_en;\n const awayRaw = f.away_team_name_en;\n // Unresolved fixtures carry no team names — a knockout slot before its\n // bracket resolves. Nothing to match or score yet.\n if (!homeRaw || !awayRaw) continue;\n\n const home = canonicalTeamName(homeRaw);\n const away = canonicalTeamName(awayRaw);\n const isKnockout = f.type !== \"group\";\n\n // Group fixtures key by team pair (unique across the tournament). Knockout\n // fixtures key by id — the DB row is seeded with placeholder slots and no\n // team_ids, so a pair lookup can't find it. See checkKnockoutIdAlignment\n // for why id keying is sound (and guarded).\n const dbMatch = isKnockout\n ? matchById.get(Number(f.id))\n : matchByKey.get(`${f.type}|${pairKey(home, away)}`);\n\n // Bind the feed's named teams to this knockout slot only if they satisfy the\n // slot's own qualification rule, judged from OUR data — group membership for\n // R32 slots (\"1L\", \"3E/H/I/J/K\"), or the source match's winner/loser later\n // (\"W80\"). This is the front-line guard: it rejects a feed glitch that names\n // the wrong team for a fixture id (e.g. a group-G team handed to the \"Winner\n // Group L\" slot), the failure that otherwise freezes a wrong pairing in and\n // wrongly eliminates a qualified team. The re-resolve-on-mismatch path below\n // is the backstop if a bad pairing ever does land. Stamped on the in-memory\n // row here; persisted by the UPDATE below.\n if (isKnockout && dbMatch) {\n const homeId = teamIdByName.get(home);\n const awayId = teamIdByName.get(away);\n if (homeId && awayId) {\n const fits1 = slotEligibility(dbMatch.team1_placeholder, teamById, matchById);\n const fits2 = slotEligibility(dbMatch.team2_placeholder, teamById, matchById);\n const ok = (fits: ((id: number) => boolean) | null, id: number) =>\n fits == null || fits(id);\n // Assign each named team to the slot it satisfies, so team_id and\n // placeholder stay consistent. An unconstrained slot (null) falls back\n // to feed order (home→team1).\n let t1: number | null = null;\n let t2: number | null = null;\n if (ok(fits1, homeId) && ok(fits2, awayId)) {\n t1 = homeId;\n t2 = awayId;\n } else if (ok(fits1, awayId) && ok(fits2, homeId)) {\n t1 = awayId;\n t2 = homeId;\n }\n\n if (t1 == null || t2 == null) {\n // Neither arrangement satisfies the slot rules — the feed is wrong for\n // this fixture. Skip; leave any prior correct resolution intact.\n invalidSlots.push(\n `#${dbMatch.id} ${home} v ${away} != ${dbMatch.team1_placeholder}/${dbMatch.team2_placeholder}`,\n );\n } else {\n const stored = new Set([dbMatch.team1_id, dbMatch.team2_id]);\n const sameTeams = dbMatch.team1_id != null && stored.size === 2 &&\n stored.has(t1) && stored.has(t2);\n if (dbMatch.team1_id == null) {\n dbMatch.team1_id = t1;\n dbMatch.team2_id = t2;\n resolved++;\n } else if (!sameTeams) {\n // Backstop: a previously-stored pairing disagrees — correct it.\n dbMatch.team1_id = t1;\n dbMatch.team2_id = t2;\n corrected++;\n }\n }\n } else {\n if (!homeId) unknownTeams.add(home);\n if (!awayId) unknownTeams.add(away);\n }\n }\n\n if (!dbMatch || dbMatch.team1_id == null || dbMatch.team2_id == null) {\n unmatched++;\n if (unmatchedSamples.length < 5) {\n unmatchedSamples.push(`${f.type} ${home} v ${away}`);\n }\n continue;\n }\n\n const status = mapStatus(f);\n const apiHomeScore = parseScore(f.home_score);\n const apiAwayScore = parseScore(f.away_score);\n // Map home/away → our team1/team2 (the DB has a canonical order)\n const t1Name = teamById.get(dbMatch.team1_id)!.name;\n const homeIsTeam1 = t1Name === home;\n const score1 = homeIsTeam1 ? apiHomeScore : apiAwayScore;\n const score2 = homeIsTeam1 ? apiAwayScore : apiHomeScore;\n\n await sqlite.execute({\n sql: `UPDATE matches_v1\n SET team1_id = ?, team2_id = ?, score1 = ?, score2 = ?,\n status = ?, external_id = ?\n WHERE id = ?`,\n args: [\n dbMatch.team1_id,\n dbMatch.team2_id,\n score1,\n score2,\n status,\n f.id,\n dbMatch.id,\n ],\n });\n updated++;\n }\n\n // A KO fixture whose feed-named teams don't fit its slot is a feed error we\n // refused to persist — surface it as loudly as an id-alignment mismatch.\n if (invalidSlots.length) {\n console.error(\n \"KO_SLOT_REJECTED — feed named teams that don't fit the slot; skipped:\",\n JSON.stringify(invalidSlots),\n );\n }\n\n return {\n fetched: fixtures.length,\n updated,\n resolved,\n corrected,\n unmatched,\n unmatchedSamples,\n unknownTeams: [...unknownTeams],\n invalidSlots,\n koWarnings,\n };\n}\n\nfunction parseKickoffUtc(date: string, time: string): string {\n const m = /^(\\d{1,2}):(\\d{2})\\s+UTC([+-]\\d+)$/.exec(time);\n if (!m) throw new Error(`bad time format: ${time}`);\n const [, hh, mm, offsetStr] = m;\n const offsetH = parseInt(offsetStr, 10);\n const localH = parseInt(hh, 10);\n const utcH = localH - offsetH;\n const [yyyy, mo, dd] = date.split(\"-\").map(Number);\n return new Date(Date.UTC(yyyy, mo - 1, dd, utcH, parseInt(mm, 10))).toISOString();\n}\n\n// Resolve an openfootball goal minute to a single integer count of minutes\n// from kickoff. Handles a numeric minute (legacy), a plain string (\"67\"), and\n// stoppage time encoded inline (\"90+4\" → 94). Returns null for any shape we\n// can't read, so a feed format drift degrades to \"no timestamp\" rather than\n// crashing the whole goals sync.\nfunction parseGoalMinute(raw: number | string | undefined): number | null {\n if (typeof raw === \"number\") return Number.isFinite(raw) ? raw : null;\n if (typeof raw === \"string\") {\n const m = /^(\\d+)(?:\\+(\\d+))?$/.exec(raw.trim());\n if (!m) return null;\n return parseInt(m[1], 10) + (m[2] ? parseInt(m[2], 10) : 0);\n }\n return null;\n}\n\nfunction goalTimeUtc(kickoffUtc: string, totalMinute: number): string {\n return new Date(new Date(kickoffUtc).getTime() + totalMinute * 60_000)\n .toISOString();\n}\n\nasync function syncPlayerGoals() {\n // 10s cap so a hung fetch throws into the caller's try/catch rather than\n // taking out the whole interval. Score sync has already completed by this\n // point — only the run summary log is at risk.\n const resp = await fetch(OPENFOOTBALL_URL, {\n signal: AbortSignal.timeout(10_000),\n });\n if (!resp.ok) {\n throw new Error(`openfootball ${resp.status}: ${await resp.text()}`);\n }\n const data = (await resp.json()) as { matches: OFMatch[] };\n\n const players = await allPlayers();\n const canonicalNames = new Set(players.map((p) => p.name));\n const playerByName = new Map(players.map((p) => [p.name, p]));\n\n // Aggregate goals per canonical player\n type Tally = { goals: number; firstGoalUtc: string | null };\n const tally = new Map();\n const unknownScorers = new Set();\n let totalGoals = 0;\n let creditedGoals = 0;\n let unparseableMinutes = 0;\n\n for (const m of data.matches) {\n let kickoffUtc: string | null = null;\n const allGoals = [\n ...(m.goals1 ?? []),\n ...(m.goals2 ?? []),\n ];\n for (const g of allGoals) {\n totalGoals++;\n // Own goals don't count for the Golden Boot\n if (g.owngoal || g.og) continue;\n const canonical = canonicalPlayerName(g.name, canonicalNames);\n if (!canonical) {\n unknownScorers.add(g.name);\n continue;\n }\n const t = tally.get(canonical) ?? { goals: 0, firstGoalUtc: null };\n t.goals += 1;\n creditedGoals++;\n // The goal count is the headline number and is always credited. The\n // timestamp only feeds the Golden Boot tiebreaker (earliest first goal),\n // so an unreadable minute drops the timestamp for this goal rather than\n // dropping the goal or failing the sync.\n const total = parseGoalMinute(g.minute);\n if (total != null) {\n kickoffUtc ??= parseKickoffUtc(m.date, m.time);\n const utc = goalTimeUtc(kickoffUtc, total + (g.offset ?? 0));\n if (!t.firstGoalUtc || utc < t.firstGoalUtc) t.firstGoalUtc = utc;\n } else {\n unparseableMinutes++;\n }\n tally.set(canonical, t);\n }\n }\n\n // Reset every player to (goals=0, first_goal_utc=null), then apply tallies.\n // Avoids drift when openfootball corrects a misattributed goal.\n await sqlite.execute(\"UPDATE players_v1 SET goals = 0, first_goal_utc = NULL\");\n if (tally.size > 0) {\n await sqlite.batch(\n [...tally.entries()].map(([name, t]) => {\n const player = playerByName.get(name)!;\n return {\n sql: `UPDATE players_v1 SET goals = ?, first_goal_utc = ?\n WHERE id = ?`,\n args: [t.goals, t.firstGoalUtc, player.id],\n };\n }),\n );\n }\n\n await setSyncMetadata(\"goals_last_updated_utc\", new Date().toISOString());\n\n return {\n totalGoals,\n creditedGoals,\n unparseableMinutes,\n playersScored: tally.size,\n unknownScorers: [...unknownScorers].slice(0, 10),\n };\n}\n\n// Recompute eliminated_at_stage for every team based on current match state.\n//\n// A team is eliminated when either:\n// (a) they lost a knockout match → marked at that stage (first loss wins),\n// (b) all group stage matches are finished AND no knockout fixture features\n// them — they failed to qualify → marked \"group\".\n// A team that has won every knockout match they've played remains alive even\n// after the final; the eventual champion stays unmarked.\nasync function recomputeEliminations(): Promise {\n await sqlite.execute(\"UPDATE teams_v1 SET eliminated_at_stage = NULL\");\n\n // (a) Knockout losers: stage of their first finished KO loss\n await sqlite.execute(`\n UPDATE teams_v1\n SET eliminated_at_stage = (\n SELECT stage FROM matches_v1 m\n WHERE m.stage != 'group' AND m.status = 'finished'\n AND m.score1 IS NOT NULL AND m.score2 IS NOT NULL\n AND m.score1 != m.score2\n AND ((m.team1_id = teams_v1.id AND m.score1 < m.score2)\n OR (m.team2_id = teams_v1.id AND m.score2 < m.score1))\n ORDER BY m.kickoff_utc ASC\n LIMIT 1\n )\n WHERE EXISTS (\n SELECT 1 FROM matches_v1 m\n WHERE m.stage != 'group' AND m.status = 'finished'\n AND m.score1 IS NOT NULL AND m.score2 IS NOT NULL\n AND m.score1 != m.score2\n AND ((m.team1_id = teams_v1.id AND m.score1 < m.score2)\n OR (m.team2_id = teams_v1.id AND m.score2 < m.score1))\n )\n `);\n\n // (b) Group-stage failures: every group match finished AND not in any KO fixture\n const groupDone = await sqlite.execute(\n `SELECT COUNT(*) AS n FROM matches_v1 WHERE stage = 'group' AND status != 'finished'`,\n );\n const groupRemaining = Number((groupDone.rows[0] as Record).n ?? 0);\n\n // Only mark group-stage failures once the Round of 32 is fully resolved (all\n // 16 fixtures have both teams). Between the last group match finishing and\n // the API resolving the bracket, no KO match has team_ids — so \"not in any KO\n // fixture\" would be true for every qualifier and wrongly eliminate them all.\n const r32 = await sqlite.execute(\n `SELECT COUNT(*) AS n FROM matches_v1\n WHERE stage = 'r32' AND team1_id IS NOT NULL AND team2_id IS NOT NULL`,\n );\n const r32Resolved = Number((r32.rows[0] as Record).n ?? 0);\n\n if (groupRemaining === 0 && r32Resolved === 16) {\n await sqlite.execute(`\n UPDATE teams_v1\n SET eliminated_at_stage = 'group'\n WHERE eliminated_at_stage IS NULL\n AND NOT EXISTS (\n SELECT 1 FROM matches_v1 m\n WHERE m.stage != 'group'\n AND (m.team1_id = teams_v1.id OR m.team2_id = teams_v1.id)\n )\n `);\n }\n\n const r = await sqlite.execute(\n \"SELECT COUNT(*) AS n FROM teams_v1 WHERE eliminated_at_stage IS NOT NULL\",\n );\n return Number((r.rows[0] as Record).n ?? 0);\n}\n\nexport default async function sync(_interval: Interval) {\n const scores = await syncLiveScores();\n const eliminated = await recomputeEliminations();\n\n // Goal sync is wrapped so an openfootball outage doesn't break score sync.\n // The Top Scorer prize is a side prize; live scores are the headline.\n let goals: Awaited> | { error: string };\n try {\n goals = await syncPlayerGoals();\n } catch (e) {\n goals = { error: e instanceof Error ? e.message : String(e) };\n }\n\n const summary = { ...scores, eliminated, goals };\n console.log(\"sync complete:\", JSON.stringify(summary));\n return summary;\n}\n","createdAt",["D",1782908802516],"branchVersion","branchId","077238b6-5d42-11f1-b2b0-1607ee4eb77e","id","0770ece0-5d42-11f1-b2b0-1607ee4eb77e","world-cup-pool-2026",["D",1780267359926],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","World Cup 2026 prediction pool","imageUrl","61314000-9c51-4bb0-b866-8391e59324fe","pinnedFileId","ce1fce58-5d45-11f1-ae08-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e4ff0-228a-7335-a829-0af14916ea4a","tursoName","0770ece05d4211f1b2b01607ee4eb77e","tursoHostname","0770ece05d4211f1b2b01607ee4eb77e-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789508444194],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",205,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","fintan","handle","displayName","Fintan Fairmichael","avatar","https://lh3.googleusercontent.com/a/ACg8ocLtUmM-O9wmM41L6CI6njdh06HBl_NG8SlUSIqVGrb9eo9MQoE=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":455,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":456,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":457,"_84":458,"_86":459,"_88":25},"tree",[201,215,228,229,230,231,232],"files",[201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232],"counts",{"_190":63,"_191":192,"_193":63,"_194":195,"_196":197},"contents",[131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":184,"_32":185,"_30":186,"_139":-5,"_41":42,"_40":187,"_140":59,"_38":188,"_13":63,"_33":182,"_35":-5,"_24":25,"_143":-5,"_27":189},{"_43":177,"_32":178,"_30":179,"_139":-5,"_41":42,"_40":180,"_140":59,"_38":181,"_13":63,"_33":182,"_35":-5,"_24":25,"_143":-5,"_27":183},{"_43":169,"_32":170,"_30":171,"_139":-5,"_41":42,"_40":172,"_140":59,"_38":173,"_13":174,"_33":151,"_35":175,"_24":25,"_143":-5,"_27":176},{"_43":162,"_32":163,"_30":57,"_139":-5,"_41":42,"_40":164,"_140":59,"_38":165,"_13":142,"_33":166,"_35":167,"_24":25,"_143":-5,"_27":168},{"_43":154,"_32":155,"_30":156,"_139":-5,"_41":42,"_40":157,"_140":59,"_38":158,"_13":159,"_33":151,"_35":160,"_24":25,"_143":-5,"_27":161},{"_43":145,"_32":146,"_30":147,"_139":-5,"_41":42,"_40":148,"_140":59,"_38":149,"_13":150,"_33":151,"_35":152,"_24":25,"_143":-5,"_27":153},{"_43":138,"_32":28,"_30":31,"_139":-5,"_41":42,"_40":14,"_140":25,"_38":141,"_13":142,"_33":34,"_35":37,"_24":25,"_143":-5,"_27":144},"abdc9f10-1f53-4982-a0a2-2de85035b91d","parentId","latest",["D",1782908802516],23,"label",[28],"ae8b9ae6-d38a-4050-9898-04cb4a1ff706","seed.ts","55eb2432-5d45-11f1-b402-1607ee4eb77e",74,["D",1780563305362],8,"script","// One-shot seed: fetch openfootball fixtures, populate teams + run the draw +\n// load the 104 matches. Idempotent — each pass returns early if its rows\n// already exist.\n//\n// Draw seeds are stored in sync_metadata_v1 — generated randomly on a fresh\n// DB, recorded once, then reused on every subsequent re-seed of the same DB\n// so the draw is reproducible.\n//\n// To re-seed from scratch (new random seeds):\n// 1. Truncate via sqlite_execute: DELETE FROM matches_v1; DELETE FROM\n// team_owners_v1; DELETE FROM player_owners_v1; DELETE FROM players_v1;\n// DELETE FROM teams_v1; DELETE FROM sync_metadata_v1 WHERE key LIKE 'draw_seed_%';\n// 2. Re-run this file via run_file.\n\nimport {\n ensureSchema,\n getSyncMetadata,\n setSyncMetadata,\n sqlite,\n} from \"./db.ts\";\nimport { CONTESTANTS } from \"./lib/contestants.ts\";\nimport { FIFA_RANK } from \"./lib/rankings.ts\";\nimport { FLAG } from \"./lib/flags.ts\";\nimport { runDraw, runForwardsDraw } from \"./lib/allocation.ts\";\nimport { FORWARDS } from \"./lib/forwards.ts\";\n\nconst FIXTURES_URL =\n \"https://raw.githubusercontent.com/openfootball/worldcup.json/master/2026/worldcup.json\";\n\ntype OFMatch = {\n round: string;\n num?: number;\n date: string;\n time: string; // e.g. \"13:00 UTC-6\"\n team1: string;\n team2: string;\n group?: string; // e.g. \"Group A\" — present only for group stage\n ground: string;\n};\n\nfunction parseKickoffUtc(date: string, time: string): string {\n const m = /^(\\d{1,2}):(\\d{2})\\s+UTC([+-]\\d+)$/.exec(time);\n if (!m) throw new Error(`bad time format: ${time}`);\n const [, hh, mm, offsetStr] = m;\n const offsetH = parseInt(offsetStr, 10);\n const localH = parseInt(hh, 10);\n const utcH = localH - offsetH; // 13:00 UTC-6 → 19:00 UTC\n const [yyyy, mo, dd] = date.split(\"-\").map(Number);\n return new Date(Date.UTC(yyyy, mo - 1, dd, utcH, parseInt(mm, 10))).toISOString();\n}\n\nfunction stageFromRound(round: string): string {\n if (round.startsWith(\"Matchday\")) return \"group\";\n if (round === \"Round of 32\") return \"r32\";\n if (round === \"Round of 16\") return \"r16\";\n if (round === \"Quarter-final\") return \"qf\";\n if (round === \"Semi-final\") return \"sf\";\n if (round === \"Match for third place\") return \"third\";\n if (round === \"Final\") return \"final\";\n throw new Error(`unknown round: ${round}`);\n}\n\nasync function countRows(table: string): Promise {\n const r = await sqlite.execute(`SELECT COUNT(*) AS n FROM ${table}`);\n return Number((r.rows[0] as Record).n ?? 0);\n}\n\nfunction randomSeed(): number {\n return crypto.getRandomValues(new Uint32Array(1))[0];\n}\n\n// Read seed from sync_metadata; on absence, write `fallback()` and return it.\n// First-write-wins: idempotent across reruns.\nasync function ensureSeed(key: string, fallback: () => number): Promise {\n const existing = await getSyncMetadata(key);\n if (existing !== null) return parseInt(existing, 10);\n const fresh = fallback();\n await setSyncMetadata(key, String(fresh));\n return fresh;\n}\n\nasync function seedTeams() {\n const count = await countRows(\"teams_v1\");\n const seed = await ensureSeed(\"draw_seed_teams\", randomSeed);\n\n if (count > 0) {\n console.log(`teams_v1 already seeded (${count} rows). Seed: ${seed}. Skipping.`);\n return { skipped: true, teams: count, seed };\n }\n\n console.log(`Fetching openfootball fixtures (teams seed: ${seed})…`);\n const resp = await fetch(FIXTURES_URL);\n if (!resp.ok) throw new Error(`fetch fixtures failed: ${resp.status}`);\n const data = (await resp.json()) as { name: string; matches: OFMatch[] };\n console.log(`Loaded ${data.matches.length} matches from openfootball.`);\n\n // Gather unique teams from the group stage\n const teamNames = new Set();\n for (const m of data.matches) {\n if (m.group) {\n teamNames.add(m.team1);\n teamNames.add(m.team2);\n }\n }\n if (teamNames.size !== 48) {\n throw new Error(`expected 48 teams in group stage, got ${teamNames.size}`);\n }\n\n // Build team rows with rank + flag + group + dropped flag\n const teamData = [...teamNames].map((name) => {\n const rank = FIFA_RANK[name];\n const flag = FLAG[name];\n const groupMatch = data.matches.find(\n (m) => m.group && (m.team1 === name || m.team2 === name),\n );\n const group = groupMatch?.group?.replace(\"Group \", \"\");\n if (!rank || !flag || !group) {\n throw new Error(\n `missing data for ${name}: rank=${rank}, flag=${flag}, group=${group}`,\n );\n }\n return { name, flag, rank, group };\n });\n\n const sortedByRank = [...teamData].sort((a, b) => a.rank - b.rank);\n const droppedNames = new Set(sortedByRank.slice(-4).map((t) => t.name));\n\n // Insert teams in rank order so AUTOINCREMENT ids feel natural\n for (const t of sortedByRank) {\n await sqlite.execute({\n sql: `INSERT INTO teams_v1 (name, flag, fifa_rank, group_letter, dropped)\n VALUES (?, ?, ?, ?, ?)`,\n args: [t.name, t.flag, t.rank, t.group, droppedNames.has(t.name) ? 1 : 0],\n });\n }\n console.log(`Inserted 48 teams (4 dropped: ${[...droppedNames].join(\", \")}).`);\n\n // Run the draw\n const teamRows = (await sqlite.execute(\n \"SELECT id, name, fifa_rank FROM teams_v1\",\n )).rows as Array>;\n const drawTeams = teamRows.map((r) => ({\n id: r.id as number,\n name: r.name as string,\n fifaRank: r.fifa_rank as number,\n }));\n const { allocations } = runDraw(drawTeams, CONTESTANTS, seed);\n\n await sqlite.batch(\n allocations.map((a) => ({\n sql: `INSERT INTO team_owners_v1 (team_id, contestant_id, pot)\n VALUES (?, ?, ?)`,\n args: [a.teamId, a.contestantId, a.pot],\n })),\n );\n console.log(`Inserted ${allocations.length} team ownership rows.`);\n\n // Insert matches — sequential id 1..104 from file order\n const teamIdByName = new Map(\n teamRows.map((r) => [r.name as string, r.id as number]),\n );\n let id = 0;\n for (const m of data.matches) {\n id += 1;\n const t1 = teamIdByName.get(m.team1) ?? null;\n const t2 = teamIdByName.get(m.team2) ?? null;\n await sqlite.execute({\n sql: `INSERT INTO matches_v1\n (id, stage, round, group_letter, kickoff_utc, ground,\n team1_id, team2_id, team1_placeholder, team2_placeholder, status)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'scheduled')`,\n args: [\n id,\n stageFromRound(m.round),\n m.round,\n m.group ? m.group.replace(\"Group \", \"\") : null,\n parseKickoffUtc(m.date, m.time),\n m.ground,\n t1,\n t2,\n t1 ? null : m.team1,\n t2 ? null : m.team2,\n ],\n });\n }\n console.log(`Inserted ${data.matches.length} matches.`);\n\n return {\n skipped: false,\n teams: teamData.length,\n dropped: [...droppedNames],\n owners: allocations.length,\n matches: data.matches.length,\n seed,\n };\n}\n\nasync function seedPlayers() {\n const count = await countRows(\"players_v1\");\n const seed = await ensureSeed(\"draw_seed_forwards\", randomSeed);\n\n if (count > 0) {\n console.log(`players_v1 already seeded (${count} rows). Seed: ${seed}. Skipping.`);\n return { skipped: true, players: count, seed };\n }\n\n // Map openfootball team names → teams_v1.id\n const teamRows = (await sqlite.execute(\n \"SELECT id, name FROM teams_v1\",\n )).rows as Array>;\n const teamIdByName = new Map(\n teamRows.map((r) => [r.name as string, r.id as number]),\n );\n\n // Insert 22 players in consensus_rank order so ids align with rank\n for (const f of FORWARDS) {\n const teamId = teamIdByName.get(f.team);\n if (!teamId) {\n throw new Error(`player ${f.name}: team \"${f.team}\" not in teams_v1`);\n }\n await sqlite.execute({\n sql: `INSERT INTO players_v1 (name, team_id, consensus_rank)\n VALUES (?, ?, ?)`,\n args: [f.name, teamId, f.consensusRank],\n });\n }\n console.log(`Inserted ${FORWARDS.length} players (forwards seed: ${seed}).`);\n\n // Run the forwards draw\n const playerRows = (await sqlite.execute(\n \"SELECT id, consensus_rank FROM players_v1\",\n )).rows as Array>;\n const drawForwards = playerRows.map((r) => ({\n id: r.id as number,\n consensusRank: r.consensus_rank as number,\n }));\n const { allocations } = runForwardsDraw(drawForwards, CONTESTANTS, seed);\n\n await sqlite.batch(\n allocations.map((a) => ({\n sql: `INSERT INTO player_owners_v1 (player_id, contestant_id, pot)\n VALUES (?, ?, ?)`,\n args: [a.playerId, a.contestantId, a.pot],\n })),\n );\n console.log(`Inserted ${allocations.length} player ownership rows.`);\n\n return {\n skipped: false,\n players: FORWARDS.length,\n owners: allocations.length,\n seed,\n };\n}\n\nasync function seed() {\n await ensureSchema();\n const teams = await seedTeams();\n const players = await seedPlayers();\n return { teams, players };\n}\n\nconst result = await seed();\nconsole.log(\"seed complete:\", JSON.stringify(result));\n",[146],"c107afa6-d8cc-4545-8e92-1c637abaff6a","queries.ts","9dee95ac-5d45-11f1-829e-1607ee4eb77e",143,["D",1781689596493],5,"// Read-side queries for the scoreboard. Pure DB → typed objects, no view logic.\n\nimport {\n allMatches,\n allOwners,\n allPlayerOwners,\n allPlayers,\n allPredictions,\n allTeams,\n getSyncMetadata,\n predictionsForMatch,\n type MatchRow,\n type OwnerRow,\n type PlayerOwnerRow,\n type PlayerRow,\n type PredictionRow,\n type TeamRow,\n} from \"./db.ts\";\nimport { predictionsOpen } from \"./lib/predictions.ts\";\n\nexport type PageData = {\n teams: TeamRow[];\n owners: OwnerRow[];\n matches: MatchRow[];\n players: PlayerRow[];\n playerOwners: PlayerOwnerRow[];\n predictions: PredictionRow[];\n teamById: Map;\n ownerByTeamId: Map;\n ownerByPlayerId: Map;\n predictionCountByMatch: Map;\n goalsLastUpdatedUtc: string | null;\n generatedAtUtc: string;\n};\n\nexport async function loadPageData(): Promise {\n const [teams, owners, matches, players, playerOwners, predictions, goalsLastUpdatedUtc] =\n await Promise.all([\n allTeams(),\n allOwners(),\n allMatches(),\n allPlayers(),\n allPlayerOwners(),\n allPredictions(),\n getSyncMetadata(\"goals_last_updated_utc\"),\n ]);\n const predictionCountByMatch = new Map();\n for (const p of predictions) {\n predictionCountByMatch.set(p.match_id, (predictionCountByMatch.get(p.match_id) ?? 0) + 1);\n }\n return {\n teams,\n owners,\n matches,\n players,\n playerOwners,\n predictions,\n teamById: new Map(teams.map((t) => [t.id, t])),\n ownerByTeamId: new Map(owners.map((o) => [o.team_id, o.contestant_id])),\n ownerByPlayerId: new Map(\n playerOwners.map((p) => [p.player_id, p.contestant_id]),\n ),\n predictionCountByMatch,\n goalsLastUpdatedUtc,\n generatedAtUtc: new Date().toISOString(),\n };\n}\n\n// Walk between fixtures still open for a prediction, in kickoff order. When the\n// current match is itself open, prevId/nextId are its neighbours and position\n// is its 1-based place in the sequence. When it isn't (finished/live), position\n// is null but nextId still points at the soonest open fixture after it, so a\n// \"Next →\" works from any match.\nexport type MatchNav = {\n prevId: number | null;\n nextId: number | null;\n position: number | null;\n total: number;\n};\n\nfunction computeMatchNav(matches: MatchRow[], current: MatchRow): MatchNav {\n const open = matches\n .filter((m) => predictionsOpen(m))\n .sort((a, b) => a.kickoff_utc.localeCompare(b.kickoff_utc));\n const total = open.length;\n const idx = open.findIndex((m) => m.id === current.id);\n if (idx !== -1) {\n return {\n prevId: idx > 0 ? open[idx - 1].id : null,\n nextId: idx < open.length - 1 ? open[idx + 1].id : null,\n position: idx + 1,\n total,\n };\n }\n const nextId = open.find((m) => m.kickoff_utc > current.kickoff_utc)?.id ?? null;\n const prevId = [...open].reverse().find((m) => m.kickoff_utc < current.kickoff_utc)?.id ?? null;\n return { prevId, nextId, position: null, total };\n}\n\nexport type MatchPageData = {\n match: MatchRow;\n team1: TeamRow | null;\n team2: TeamRow | null;\n predictions: PredictionRow[];\n ownerByTeamId: Map;\n nav: MatchNav;\n generatedAtUtc: string;\n};\n\nexport async function loadMatchPageData(id: number): Promise {\n const [matches, teams, owners, predictions] = await Promise.all([\n allMatches(),\n allTeams(),\n allOwners(),\n predictionsForMatch(id),\n ]);\n const match = matches.find((m) => m.id === id);\n if (!match) return null;\n const teamById = new Map(teams.map((t) => [t.id, t]));\n return {\n match,\n team1: match.team1_id != null ? teamById.get(match.team1_id) ?? null : null,\n team2: match.team2_id != null ? teamById.get(match.team2_id) ?? null : null,\n predictions,\n ownerByTeamId: new Map(owners.map((o) => [o.team_id, o.contestant_id])),\n nav: computeMatchNav(matches, match),\n generatedAtUtc: new Date().toISOString(),\n };\n}\n\nconst POOL_TZ = \"Europe/Dublin\";\nconst UPCOMING_DAYS = 3;\n\nfunction dublinDateKey(iso: string): string {\n // YYYY-MM-DD in Europe/Dublin (en-CA gives ISO-style date)\n return new Intl.DateTimeFormat(\"en-CA\", {\n timeZone: POOL_TZ,\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n }).format(new Date(iso));\n}\n\nfunction dublinDateLabel(iso: string, todayKey: string, tomorrowKey: string): string {\n const key = dublinDateKey(iso);\n if (key === todayKey) return \"Today\";\n if (key === tomorrowKey) return \"Tomorrow\";\n return new Date(iso).toLocaleDateString(\"en-IE\", {\n timeZone: POOL_TZ,\n weekday: \"long\",\n day: \"numeric\",\n month: \"long\",\n });\n}\n\nexport type UpcomingDay = {\n key: string; // YYYY-MM-DD (Dublin)\n label: string; // \"Today\" / \"Tomorrow\" / \"Thursday 11 June\"\n matches: MatchRow[];\n};\n\nexport function partitionMatches(matches: MatchRow[], now: Date = new Date()) {\n const todayKey = dublinDateKey(now.toISOString());\n const tomorrowKey = dublinDateKey(\n new Date(now.getTime() + 24 * 60 * 60 * 1000).toISOString(),\n );\n\n const live: MatchRow[] = [];\n const finished: MatchRow[] = [];\n const future: MatchRow[] = [];\n\n for (const m of matches) {\n if (m.status === \"live\" || m.status === \"ht\") {\n live.push(m);\n } else if (m.status === \"finished\") {\n finished.push(m);\n } else {\n future.push(m);\n }\n }\n\n finished.sort((a, b) => b.kickoff_utc.localeCompare(a.kickoff_utc));\n future.sort((a, b) => a.kickoff_utc.localeCompare(b.kickoff_utc));\n\n // Group future matches by Dublin calendar date; keep only the next N dates\n const upcomingByDate: UpcomingDay[] = [];\n for (const m of future) {\n const k = dublinDateKey(m.kickoff_utc);\n const existing = upcomingByDate.find((g) => g.key === k);\n if (existing) {\n existing.matches.push(m);\n } else {\n if (upcomingByDate.length >= UPCOMING_DAYS) break;\n upcomingByDate.push({\n key: k,\n label: dublinDateLabel(m.kickoff_utc, todayKey, tomorrowKey),\n matches: [m],\n });\n }\n }\n\n return {\n live,\n upcomingByDate,\n recent: finished.slice(0, 6),\n };\n}\n",[155],"22b606aa-8bbe-4555-b36f-eafa67af2760","main.tsx",158,["D",1781691830930],"http","// HTTP entrypoint. Hono routes + SSR React.\n//\n// / Pool page — leaderboard + prize races (the money view)\n// /matches Matches page — live, upcoming, results, knockout, groups\n// /predictions Predictions page — prediction league + open fixtures\n// /about About page — the pool premise + prize breakdown\n// /draw animated draw reveal (always accessible)\n// /match/:id match page — prediction form pre-kickoff, rankings after\n// /match/:id/predict POST target for the prediction form (PRG, no client JS)\n// /source redirect to val source (val.town convention)\n//\n// The Pool page is gated behind a cookie until the first kick-off (see below).\n//\n// Gate behaviour: before the tournament opens, a fresh visitor to / is bounced\n// to /draw. The /draw page sets the `pool_seen_draw` cookie when the reveal\n// completes (or is skipped), so the next visit to / lands on the scoreboard.\n// Once the first match kicks off the gate retires — scoreboard is open to all.\n\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server?deps=react@18.2.0\";\nimport { Hono } from \"npm:hono\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\nimport { Shell } from \"./components/Shell.tsx\";\nimport { PoolPage } from \"./components/PoolPage.tsx\";\nimport { MatchesPage } from \"./components/MatchesPage.tsx\";\nimport { PredictionsPage } from \"./components/PredictionsPage.tsx\";\nimport { AboutPage } from \"./components/AboutPage.tsx\";\nimport { buildForwardsPots, buildPots, DrawPage } from \"./components/Draw.tsx\";\nimport { MatchPage, predictionsOpen, SCORE_MAX, SCORE_MIN } from \"./components/MatchPage.tsx\";\nimport { loadMatchPageData, loadPageData } from \"./queries.ts\";\nimport { getMatch, getSyncMetadata, upsertPrediction } from \"./db.ts\";\nimport { CONTESTANT_BY_ID } from \"./lib/contestants.ts\";\n\nconst SEEN_COOKIE = \"pool_seen_draw\";\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nconst CONTESTANT_COOKIE = \"pool_contestant\";\n// 180 days — predictions run the length of the tournament; long enough that a\n// contestant only ever picks their name once.\nconst CONTESTANT_COOKIE_MAX_AGE = 180 * 24 * 60 * 60;\n\nfunction readCookie(cookieHeader: string | undefined, name: string): string | null {\n if (!cookieHeader) return null;\n for (const kv of cookieHeader.split(/;\\s*/)) {\n const eq = kv.indexOf(\"=\");\n if (eq === -1) continue;\n if (kv.slice(0, eq) === name) return decodeURIComponent(kv.slice(eq + 1));\n }\n return null;\n}\n\nfunction hasSeenDraw(cookieHeader: string | undefined): boolean {\n return readCookie(cookieHeader, SEEN_COOKIE) === \"1\";\n}\n\napp.get(\"/\", async (c) => {\n const data = await loadPageData();\n const firstKickoff = data.matches[0]?.kickoff_utc;\n const tournamentStarted = firstKickoff != null && Date.now() >= new Date(firstKickoff).getTime();\n if (!tournamentStarted && !hasSeenDraw(c.req.header(\"Cookie\"))) {\n return c.redirect(\"/draw\");\n }\n const html = renderToString(\n \n \n ,\n );\n return c.html(\"\" + html, 200, {\n \"Cache-Control\": \"public, max-age=60\",\n });\n});\n\napp.get(\"/matches\", async (c) => {\n const data = await loadPageData();\n const html = renderToString(\n \n \n ,\n );\n return c.html(\"\" + html, 200, {\n \"Cache-Control\": \"public, max-age=60\",\n });\n});\n\napp.get(\"/predictions\", async (c) => {\n const data = await loadPageData();\n const html = renderToString(\n \n \n ,\n );\n return c.html(\"\" + html, 200, {\n \"Cache-Control\": \"public, max-age=60\",\n });\n});\n\napp.get(\"/about\", (c) => {\n const html = renderToString(\n \n \n ,\n );\n return c.html(\"\" + html, 200, {\n \"Cache-Control\": \"public, max-age=300\",\n });\n});\n\napp.get(\"/draw\", async (c) => {\n const [data, teamsSeedRaw, forwardsSeedRaw] = await Promise.all([\n loadPageData(),\n getSyncMetadata(\"draw_seed_teams\"),\n getSyncMetadata(\"draw_seed_forwards\"),\n ]);\n const teamPots = buildPots(data.teams, data.owners);\n const forwardsPots = buildForwardsPots(data.players, data.playerOwners, data.teams);\n const html = renderToString(\n \n \n ,\n );\n return c.html(\"\" + html);\n});\n\nfunction parseMatchId(raw: string): number | null {\n return /^\\d+$/.test(raw) ? parseInt(raw, 10) : null;\n}\n\n// Served no-store: the form-POST redirect must show the fresh prediction, and\n// live rankings shouldn't lag behind the score by a cache TTL.\napp.get(\"/match/:id\", async (c) => {\n const id = parseMatchId(c.req.param(\"id\"));\n const data = id != null ? await loadMatchPageData(id) : null;\n if (!data) return c.text(\"No such match\", 404);\n const title = data.team1 && data.team2\n ? `${data.team1.name} v ${data.team2.name} · World Cup Pool 2026`\n : `Match ${data.match.id} · World Cup Pool 2026`;\n const cookieYou = readCookie(c.req.header(\"Cookie\"), CONTESTANT_COOKIE);\n const you = cookieYou && CONTESTANT_BY_ID[cookieYou] ? cookieYou : null;\n const html = renderToString(\n \n \n ,\n );\n return c.html(\"\" + html, 200, { \"Cache-Control\": \"no-store\" });\n});\n\n// Read the posted prediction form. It's always urlencoded (contestant + two\n// scores, no file inputs), so parsing the raw body with URLSearchParams is the\n// complete, correct parse — no content-type negotiation needed.\nasync function parseForm(c: { req: { text: () => Promise } }): Promise> {\n return Object.fromEntries(new URLSearchParams(await c.req.text()));\n}\n\nfunction parseScoreField(v: unknown): number | null {\n if (typeof v !== \"string\" || !/^\\d{1,2}$/.test(v.trim())) return null;\n const n = parseInt(v, 10);\n return n >= SCORE_MIN && n <= SCORE_MAX ? n : null;\n}\n\napp.post(\"/match/:id/predict\", async (c) => {\n const id = parseMatchId(c.req.param(\"id\"));\n if (id == null) return c.text(\"No such match\", 404);\n const match = await getMatch(id);\n if (!match) return c.text(\"No such match\", 404);\n\n // The form posts via fetch when JS is on (X-Requested-With), so the page can\n // save in place; without JS it's a plain POST and we fall back to PRG.\n const wantsJson = c.req.header(\"X-Requested-With\") === \"fetch\";\n const fail = (error: string) =>\n wantsJson\n ? c.json({ ok: false, error }, 422)\n : c.redirect(`/match/${id}?error=${error}`, 303);\n\n const body = await parseForm(c);\n const contestantId = typeof body.contestant === \"string\" ? body.contestant : \"\";\n if (!CONTESTANT_BY_ID[contestantId]) return fail(\"contestant\");\n\n // Remember who you are so every later match's form is pre-filled. Set as soon\n // as the contestant is valid — even if the scores aren't — so the pick\n // survives a rejected submit.\n c.header(\n \"Set-Cookie\",\n `${CONTESTANT_COOKIE}=${encodeURIComponent(contestantId)}; Path=/; Max-Age=${CONTESTANT_COOKIE_MAX_AGE}; SameSite=Lax`,\n );\n\n const score1 = parseScoreField(body.score1);\n const score2 = parseScoreField(body.score2);\n if (score1 == null || score2 == null) return fail(\"score\");\n // Same predicate the form render uses, re-checked at submit time so a page\n // opened before kick-off can't sneak a prediction in after it.\n if (!predictionsOpen(match)) return fail(\"locked\");\n\n await upsertPrediction(id, contestantId, score1, score2);\n if (wantsJson) return c.json({ ok: true, contestantId, score1, score2 });\n return c.redirect(`/match/${id}?saved=1`, 303);\n});\n\nexport default app.fetch;\n",[163],"39b7d3e2-01ee-41d6-8cc8-130fa81f9c40","db.ts","06f29c98-5d45-11f1-8fa3-1607ee4eb77e",171,["D",1782908773902],4,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Schema. All tables use _v1 suffix so future migrations can land cleanly\n// alongside the originals without rewriting in place.\n\nexport async function ensureSchema() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS teams_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT UNIQUE NOT NULL,\n flag TEXT NOT NULL,\n fifa_rank INTEGER NOT NULL,\n group_letter TEXT NOT NULL,\n dropped INTEGER NOT NULL DEFAULT 0,\n eliminated_at_stage TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS team_owners_v1 (\n team_id INTEGER PRIMARY KEY REFERENCES teams_v1(id),\n contestant_id TEXT NOT NULL,\n pot INTEGER NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS team_owners_v1_contestant\n ON team_owners_v1(contestant_id)`,\n `CREATE TABLE IF NOT EXISTS matches_v1 (\n id INTEGER PRIMARY KEY,\n stage TEXT NOT NULL,\n round TEXT NOT NULL,\n group_letter TEXT,\n kickoff_utc TEXT NOT NULL,\n ground TEXT NOT NULL,\n team1_id INTEGER REFERENCES teams_v1(id),\n team2_id INTEGER REFERENCES teams_v1(id),\n team1_placeholder TEXT,\n team2_placeholder TEXT,\n score1 INTEGER,\n score2 INTEGER,\n penalty1 INTEGER,\n penalty2 INTEGER,\n status TEXT NOT NULL DEFAULT 'scheduled'\n )`,\n `CREATE INDEX IF NOT EXISTS matches_v1_kickoff ON matches_v1(kickoff_utc)`,\n `CREATE INDEX IF NOT EXISTS matches_v1_stage ON matches_v1(stage)`,\n `CREATE TABLE IF NOT EXISTS players_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT UNIQUE NOT NULL,\n team_id INTEGER NOT NULL REFERENCES teams_v1(id),\n consensus_rank INTEGER UNIQUE NOT NULL,\n goals INTEGER NOT NULL DEFAULT 0,\n matches_played INTEGER NOT NULL DEFAULT 0,\n first_goal_utc TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS player_owners_v1 (\n player_id INTEGER PRIMARY KEY REFERENCES players_v1(id),\n contestant_id TEXT NOT NULL,\n pot INTEGER NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS player_owners_v1_contestant\n ON player_owners_v1(contestant_id)`,\n // Small KV for sync state — currently used for the openfootball\n // goals-last-updated timestamp surfaced in the Golden Boot section.\n `CREATE TABLE IF NOT EXISTS sync_metadata_v1 (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )`,\n PREDICTIONS_TABLE_SQL,\n ]);\n}\n\n// Score predictions, one per contestant per match. Only inputs are stored —\n// outcomes, rankings, and season points are derived at render time from the\n// match's current score, so upstream score corrections self-heal the same way\n// eliminations and goal tallies do (recompute, never materialise).\nconst PREDICTIONS_TABLE_SQL = `CREATE TABLE IF NOT EXISTS predictions_v1 (\n match_id INTEGER NOT NULL REFERENCES matches_v1(id),\n contestant_id TEXT NOT NULL,\n score1 INTEGER NOT NULL,\n score2 INTEGER NOT NULL,\n created_utc TEXT NOT NULL,\n updated_utc TEXT,\n PRIMARY KEY (match_id, contestant_id)\n)`;\n\n// The predictions table postdates the seeded schema, so every helper ensures\n// it lazily (once per isolate) rather than requiring a seed re-run.\nlet predictionsReady: Promise | null = null;\nfunction ensurePredictionsTable(): Promise {\n predictionsReady ??= sqlite.execute(PREDICTIONS_TABLE_SQL);\n return predictionsReady;\n}\n\nexport type TeamRow = {\n id: number;\n name: string;\n flag: string;\n fifa_rank: number;\n group_letter: string;\n dropped: number;\n eliminated_at_stage: string | null;\n};\n\nexport type MatchRow = {\n id: number;\n stage: string;\n round: string;\n group_letter: string | null;\n kickoff_utc: string;\n ground: string;\n team1_id: number | null;\n team2_id: number | null;\n team1_placeholder: string | null;\n team2_placeholder: string | null;\n score1: number | null;\n score2: number | null;\n // Penalty-shootout scores for a knockout match that ended level after\n // regulation/extra time. Null for group games and for KO games decided in\n // normal time. The shootout, not the level score, decides who advances.\n penalty1: number | null;\n penalty2: number | null;\n status: string;\n};\n\nexport type OwnerRow = {\n team_id: number;\n contestant_id: string;\n pot: number;\n};\n\nexport type PlayerRow = {\n id: number;\n name: string;\n team_id: number;\n consensus_rank: number;\n goals: number;\n matches_played: number;\n first_goal_utc: string | null;\n};\n\nexport type PlayerOwnerRow = {\n player_id: number;\n contestant_id: string;\n pot: number;\n};\n\nexport type PredictionRow = {\n match_id: number;\n contestant_id: string;\n score1: number; // predicted score for the match's team1 (canonical DB order)\n score2: number;\n created_utc: string;\n updated_utc: string | null;\n};\n\nexport async function allTeams(): Promise {\n const r = await sqlite.execute(\"SELECT * FROM teams_v1 ORDER BY fifa_rank ASC\");\n return r.rows as unknown as TeamRow[];\n}\n\nexport async function allMatches(): Promise {\n const r = await sqlite.execute(\n \"SELECT * FROM matches_v1 ORDER BY kickoff_utc ASC, id ASC\",\n );\n return r.rows as unknown as MatchRow[];\n}\n\nexport async function getMatch(id: number): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM matches_v1 WHERE id = ?\",\n args: [id],\n });\n return (r.rows[0] as unknown as MatchRow) ?? null;\n}\n\nexport async function allOwners(): Promise {\n const r = await sqlite.execute(\"SELECT * FROM team_owners_v1\");\n return r.rows as unknown as OwnerRow[];\n}\n\nexport async function allPlayers(): Promise {\n const r = await sqlite.execute(\n \"SELECT * FROM players_v1 ORDER BY consensus_rank ASC\",\n );\n return r.rows as unknown as PlayerRow[];\n}\n\nexport async function allPlayerOwners(): Promise {\n const r = await sqlite.execute(\"SELECT * FROM player_owners_v1\");\n return r.rows as unknown as PlayerOwnerRow[];\n}\n\nexport async function allPredictions(): Promise {\n await ensurePredictionsTable();\n const r = await sqlite.execute(\n \"SELECT * FROM predictions_v1 ORDER BY created_utc ASC\",\n );\n return r.rows as unknown as PredictionRow[];\n}\n\nexport async function predictionsForMatch(matchId: number): Promise {\n await ensurePredictionsTable();\n const r = await sqlite.execute({\n sql: \"SELECT * FROM predictions_v1 WHERE match_id = ? ORDER BY created_utc ASC\",\n args: [matchId],\n });\n return r.rows as unknown as PredictionRow[];\n}\n\n// Resubmitting before kickoff overwrites — created_utc keeps the original\n// submission time, updated_utc records the latest change.\nexport async function upsertPrediction(\n matchId: number,\n contestantId: string,\n score1: number,\n score2: number,\n): Promise {\n await ensurePredictionsTable();\n await sqlite.execute({\n sql: `INSERT INTO predictions_v1 (match_id, contestant_id, score1, score2, created_utc)\n VALUES (?, ?, ?, ?, ?)\n ON CONFLICT(match_id, contestant_id) DO UPDATE SET\n score1 = excluded.score1,\n score2 = excluded.score2,\n updated_utc = excluded.created_utc`,\n args: [matchId, contestantId, score1, score2, new Date().toISOString()],\n });\n}\n\nexport async function getSyncMetadata(key: string): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT value FROM sync_metadata_v1 WHERE key = ?\",\n args: [key],\n });\n const row = r.rows[0] as Record | undefined;\n return row ? (row.value as string) : null;\n}\n\nexport async function setSyncMetadata(key: string, value: string): Promise {\n await sqlite.execute({\n sql: `INSERT INTO sync_metadata_v1 (key, value) VALUES (?, ?)\n ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n args: [key, value],\n });\n}\n\nexport { sqlite };\n",[170],"f532486e-5d44-11f1-8dd4-1607ee4eb77e","lib","8bf1bfba-d2fe-4bb4-943d-f0a6d16de91a",1,["D",1780268617793],"directory",[178],"9ecc8a6a-5d45-11f1-829e-1607ee4eb77e","components","59fa7e05-9fd4-4fdb-bbdd-d29d8e3aa11e",11,["D",1780268902344],[185],"pulls","branches",2,"forks","envVars",{"_198":63,"_200":63},"connections",{"_198":63,"_199":63},"count","unfilledCount","emptyCount",{"_43":184,"_32":185,"_30":186,"_139":-5,"_41":42,"_40":187,"_140":59,"_38":452,"_13":63,"_33":182,"_35":-5,"_24":25,"_143":-5,"_234":453,"_27":454},{"_43":444,"_32":445,"_30":446,"_139":186,"_41":42,"_40":447,"_140":59,"_38":448,"_13":63,"_33":151,"_35":449,"_24":25,"_143":-5,"_234":450,"_27":451},{"_43":436,"_32":437,"_30":438,"_139":186,"_41":42,"_40":439,"_140":25,"_38":440,"_13":192,"_33":151,"_35":441,"_24":25,"_143":-5,"_234":442,"_27":443},{"_43":427,"_32":428,"_30":429,"_139":186,"_41":42,"_40":430,"_140":59,"_38":431,"_13":432,"_33":151,"_35":433,"_24":25,"_143":-5,"_234":434,"_27":435},{"_43":419,"_32":420,"_30":421,"_139":186,"_41":42,"_40":422,"_140":59,"_38":423,"_13":192,"_33":151,"_35":424,"_24":25,"_143":-5,"_234":425,"_27":426},{"_43":411,"_32":412,"_30":413,"_139":186,"_41":42,"_40":414,"_140":25,"_38":415,"_13":323,"_33":151,"_35":416,"_24":25,"_143":-5,"_234":417,"_27":418},{"_43":403,"_32":404,"_30":405,"_139":186,"_41":42,"_40":406,"_140":25,"_38":407,"_13":159,"_33":151,"_35":408,"_24":25,"_143":-5,"_234":409,"_27":410},{"_43":395,"_32":396,"_30":397,"_139":186,"_41":42,"_40":398,"_140":25,"_38":399,"_13":174,"_33":151,"_35":400,"_24":25,"_143":-5,"_234":401,"_27":402},{"_43":387,"_32":388,"_30":389,"_139":186,"_41":42,"_40":390,"_140":59,"_38":391,"_13":63,"_33":151,"_35":392,"_24":25,"_143":-5,"_234":393,"_27":394},{"_43":379,"_32":380,"_30":381,"_139":186,"_41":42,"_40":382,"_140":59,"_38":383,"_13":192,"_33":151,"_35":384,"_24":25,"_143":-5,"_234":385,"_27":386},{"_43":371,"_32":372,"_30":373,"_139":186,"_41":42,"_40":374,"_140":59,"_38":375,"_13":174,"_33":151,"_35":376,"_24":25,"_143":-5,"_234":377,"_27":378},{"_43":363,"_32":364,"_30":365,"_139":186,"_41":42,"_40":366,"_140":59,"_38":367,"_13":63,"_33":151,"_35":368,"_24":25,"_143":-5,"_234":369,"_27":370},{"_43":354,"_32":355,"_30":356,"_139":186,"_41":42,"_40":357,"_140":59,"_38":358,"_13":359,"_33":151,"_35":360,"_24":25,"_143":-5,"_234":361,"_27":362},{"_43":346,"_32":347,"_30":348,"_139":186,"_41":42,"_40":349,"_140":25,"_38":350,"_13":63,"_33":151,"_35":351,"_24":25,"_143":-5,"_234":352,"_27":353},{"_43":177,"_32":178,"_30":179,"_139":-5,"_41":42,"_40":180,"_140":59,"_38":343,"_13":63,"_33":182,"_35":-5,"_24":25,"_143":-5,"_234":344,"_27":345},{"_43":335,"_32":336,"_30":337,"_139":179,"_41":42,"_40":338,"_140":59,"_38":339,"_13":174,"_33":151,"_35":340,"_24":25,"_143":-5,"_234":341,"_27":342},{"_43":328,"_32":329,"_30":330,"_139":179,"_41":42,"_40":192,"_140":59,"_38":331,"_13":63,"_33":151,"_35":332,"_24":25,"_143":-5,"_234":333,"_27":334},{"_43":320,"_32":321,"_30":322,"_139":179,"_41":42,"_40":323,"_140":59,"_38":324,"_13":63,"_33":151,"_35":325,"_24":25,"_143":-5,"_234":326,"_27":327},{"_43":312,"_32":313,"_30":314,"_139":179,"_41":42,"_40":315,"_140":59,"_38":316,"_13":63,"_33":151,"_35":317,"_24":25,"_143":-5,"_234":318,"_27":319},{"_43":304,"_32":305,"_30":306,"_139":179,"_41":42,"_40":307,"_140":59,"_38":308,"_13":63,"_33":151,"_35":309,"_24":25,"_143":-5,"_234":310,"_27":311},{"_43":296,"_32":297,"_30":298,"_139":179,"_41":42,"_40":299,"_140":59,"_38":300,"_13":63,"_33":151,"_35":301,"_24":25,"_143":-5,"_234":302,"_27":303},{"_43":288,"_32":289,"_30":290,"_139":179,"_41":42,"_40":291,"_140":59,"_38":292,"_13":63,"_33":151,"_35":293,"_24":25,"_143":-5,"_234":294,"_27":295},{"_43":280,"_32":281,"_30":282,"_139":179,"_41":42,"_40":283,"_140":59,"_38":284,"_13":63,"_33":151,"_35":285,"_24":25,"_143":-5,"_234":286,"_27":287},{"_43":273,"_32":274,"_30":275,"_139":179,"_41":42,"_40":180,"_140":59,"_38":276,"_13":63,"_33":151,"_35":277,"_24":25,"_143":-5,"_234":278,"_27":279},{"_43":265,"_32":266,"_30":267,"_139":179,"_41":42,"_40":268,"_140":25,"_38":269,"_13":63,"_33":151,"_35":270,"_24":25,"_143":-5,"_234":271,"_27":272},{"_43":257,"_32":258,"_30":259,"_139":179,"_41":42,"_40":260,"_140":59,"_38":261,"_13":180,"_33":151,"_35":262,"_24":25,"_143":-5,"_234":263,"_27":264},{"_43":249,"_32":250,"_30":251,"_139":179,"_41":42,"_40":252,"_140":59,"_38":253,"_13":63,"_33":151,"_35":254,"_24":25,"_143":-5,"_234":255,"_27":256},{"_43":169,"_32":170,"_30":171,"_139":-5,"_41":42,"_40":172,"_140":59,"_38":246,"_13":174,"_33":151,"_35":175,"_24":25,"_143":-5,"_234":247,"_27":248},{"_43":162,"_32":163,"_30":57,"_139":-5,"_41":42,"_40":164,"_140":59,"_38":243,"_13":142,"_33":166,"_35":167,"_24":25,"_143":-5,"_234":244,"_27":245},{"_43":154,"_32":155,"_30":156,"_139":-5,"_41":42,"_40":157,"_140":59,"_38":240,"_13":159,"_33":151,"_35":160,"_24":25,"_143":-5,"_234":241,"_27":242},{"_43":145,"_32":146,"_30":147,"_139":-5,"_41":42,"_40":148,"_140":59,"_38":237,"_13":150,"_33":151,"_35":152,"_24":25,"_143":-5,"_234":238,"_27":239},{"_43":138,"_32":28,"_30":31,"_139":-5,"_41":42,"_40":14,"_140":25,"_38":233,"_13":142,"_33":34,"_35":37,"_24":25,"_143":-5,"_234":235,"_27":236},["D",1782908802516],"children",[],[28],["D",1780563305362],[],[146],["D",1781689596493],[],[155],["D",1781691830930],[],[163],["D",1782908773902],[],[170],"472850d4-5d48-11f1-bc72-1607ee4eb77e","time.ts","472851b0-5d48-11f1-bc72-1607ee4eb77e",31,["D",1780270043795],"// Display all dates/times in Irish/British summer time so the audience sees\n// kick-offs in their local zone. June–July 2026 is fully inside BST/IST\n// (UTC+1) — Intl.DateTimeFormat handles the DST flip automatically.\n\nexport const POOL_TZ = \"Europe/Dublin\";\n\nexport function fmtKickoff(iso: string): string {\n const d = new Date(iso);\n const day = d.toLocaleDateString(\"en-IE\", {\n weekday: \"short\",\n day: \"numeric\",\n month: \"short\",\n timeZone: POOL_TZ,\n });\n const time = d.toLocaleTimeString(\"en-IE\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: false,\n timeZone: POOL_TZ,\n });\n return `${day} · ${time}`;\n}\n\nexport function fmtUpdatedAt(iso: string): string {\n return new Date(iso).toLocaleString(\"en-IE\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: false,\n timeZone: POOL_TZ,\n });\n}\n\nexport function fmtCountdownTime(iso: string): string {\n const d = new Date(iso);\n const day = d.toLocaleDateString(\"en-IE\", {\n weekday: \"short\",\n day: \"numeric\",\n month: \"short\",\n year: \"numeric\",\n timeZone: POOL_TZ,\n });\n const time = d.toLocaleTimeString(\"en-IE\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: false,\n timeZone: POOL_TZ,\n });\n return `${day} · ${time} IST`;\n}\n",[],[178,250],"2bf6eb6e-5d47-11f1-8e97-1607ee4eb77e","team_aliases.ts","6a8a06aa-5d46-11f1-aeed-1607ee4eb77e",25,["D",1780269568671],"// External-source team names → our canonical (openfootball) names.\n// Maps every alias we've observed in the live data sources we use.\n\nexport const TEAM_ALIASES: Record = {\n // worldcup26.ir\n \"Bosnia and Herzegovina\": \"Bosnia & Herzegovina\",\n \"Democratic Republic of the Congo\": \"DR Congo\",\n \"United States\": \"USA\",\n // Anticipated variants from other sources\n \"Korea Republic\": \"South Korea\",\n \"Korea, South\": \"South Korea\",\n \"Cote d'Ivoire\": \"Ivory Coast\",\n \"Côte d'Ivoire\": \"Ivory Coast\",\n \"Czechia\": \"Czech Republic\",\n \"Bosnia Herzegovina\": \"Bosnia & Herzegovina\",\n \"Cabo Verde\": \"Cape Verde\",\n \"Cape Verde Islands\": \"Cape Verde\",\n \"Congo DR\": \"DR Congo\",\n \"DRC\": \"DR Congo\",\n \"Türkiye\": \"Turkey\",\n \"Turkiye\": \"Turkey\",\n};\n\nexport function canonicalTeamName(name: string): string {\n return TEAM_ALIASES[name] ?? name;\n}\n",[],[178,258],"23a6891c-5d45-11f1-b3d7-1607ee4eb77e","scoring.ts","23a689e4-5d45-11f1-b3d7-1607ee4eb77e",6,["D",1780268695734],"// Leaderboard computation — pure function over teams, owners, matches.\n//\n// During the tournament we rank contestants by:\n// 1. number of teams still in the competition (DESC)\n// 2. total goals scored by their teams in finished matches (DESC) — tiebreak\n// 3. best (lowest) FIFA rank among their teams (ASC) — final tiebreak\n//\n// The real prize is determined at the end via lib/allocation#resolvePrize.\n\nimport type { MatchRow, OwnerRow, TeamRow } from \"../db.ts\";\n\nexport type ContestantStanding = {\n contestantId: string;\n teamsAlive: number;\n goalsFor: number;\n goalsAgainst: number;\n bestRank: number;\n teams: Array<{\n teamId: number;\n name: string;\n flag: string;\n fifaRank: number;\n eliminatedAtStage: string | null;\n }>;\n};\n\nexport function computeStandings(\n teams: TeamRow[],\n owners: OwnerRow[],\n matches: MatchRow[],\n): ContestantStanding[] {\n const teamById = new Map(teams.map((t) => [t.id, t]));\n const ownersByContestant = new Map();\n for (const o of owners) {\n const arr = ownersByContestant.get(o.contestant_id) ?? [];\n arr.push(o);\n ownersByContestant.set(o.contestant_id, arr);\n }\n\n // Pre-compute goals for/against per team from finished matches\n const goalsFor = new Map();\n const goalsAgainst = new Map();\n for (const m of matches) {\n if (m.status !== \"finished\" && m.status !== \"live\" && m.status !== \"ht\") continue;\n if (m.score1 == null || m.score2 == null) continue;\n if (m.team1_id != null) {\n goalsFor.set(m.team1_id, (goalsFor.get(m.team1_id) ?? 0) + m.score1);\n goalsAgainst.set(m.team1_id, (goalsAgainst.get(m.team1_id) ?? 0) + m.score2);\n }\n if (m.team2_id != null) {\n goalsFor.set(m.team2_id, (goalsFor.get(m.team2_id) ?? 0) + m.score2);\n goalsAgainst.set(m.team2_id, (goalsAgainst.get(m.team2_id) ?? 0) + m.score1);\n }\n }\n\n const standings: ContestantStanding[] = [];\n for (const [contestantId, ownerRows] of ownersByContestant) {\n const teamRows = ownerRows\n .map((o) => teamById.get(o.team_id))\n .filter((t): t is TeamRow => t != null);\n\n let teamsAlive = 0;\n let totalFor = 0;\n let totalAgainst = 0;\n let bestRank = Number.POSITIVE_INFINITY;\n const teamSummaries: ContestantStanding[\"teams\"] = [];\n\n for (const t of teamRows) {\n if (t.eliminated_at_stage == null) teamsAlive++;\n totalFor += goalsFor.get(t.id) ?? 0;\n totalAgainst += goalsAgainst.get(t.id) ?? 0;\n if (t.fifa_rank < bestRank) bestRank = t.fifa_rank;\n teamSummaries.push({\n teamId: t.id,\n name: t.name,\n flag: t.flag,\n fifaRank: t.fifa_rank,\n eliminatedAtStage: t.eliminated_at_stage,\n });\n }\n\n // Display teams best-rank first\n teamSummaries.sort((a, b) => a.fifaRank - b.fifaRank);\n\n standings.push({\n contestantId,\n teamsAlive,\n goalsFor: totalFor,\n goalsAgainst: totalAgainst,\n bestRank: bestRank === Number.POSITIVE_INFINITY ? 999 : bestRank,\n teams: teamSummaries,\n });\n }\n\n standings.sort((a, b) => {\n if (b.teamsAlive !== a.teamsAlive) return b.teamsAlive - a.teamsAlive;\n if (b.goalsFor !== a.goalsFor) return b.goalsFor - a.goalsFor;\n return a.bestRank - b.bestRank;\n });\n\n return standings;\n}\n",[],[178,266],"f5321e7a-5d44-11f1-8dd4-1607ee4eb77e","rankings.ts","f5321f42-5d44-11f1-8dd4-1607ee4eb77e",["D",1780268617793],"// FIFA Men's World Ranking — 01 April 2026 release.\n// Source: https://www.whereig.com/football/fifa-world-rankings.html (cross-checked\n// against ESPN's top-20 article). Rankings don't change during the tournament,\n// so this snapshot is stable for the duration of the pool.\n//\n// Country names match openfootball/worldcup.json verbatim so they can be\n// joined without translation. Only the 48 qualified teams are listed.\n\nexport const FIFA_RANK: Record = {\n \"France\": 1,\n \"Spain\": 2,\n \"Argentina\": 3,\n \"England\": 4,\n \"Portugal\": 5,\n \"Brazil\": 6,\n \"Netherlands\": 7,\n \"Morocco\": 8,\n \"Belgium\": 9,\n \"Germany\": 10,\n \"Croatia\": 11,\n \"Colombia\": 13,\n \"Senegal\": 14,\n \"Mexico\": 15,\n \"USA\": 16,\n \"Uruguay\": 17,\n \"Japan\": 18,\n \"Switzerland\": 19,\n \"Iran\": 21,\n \"Turkey\": 22,\n \"Ecuador\": 23,\n \"Austria\": 24,\n \"South Korea\": 25,\n \"Australia\": 27,\n \"Algeria\": 28,\n \"Egypt\": 29,\n \"Canada\": 30,\n \"Norway\": 31,\n \"Panama\": 33,\n \"Ivory Coast\": 34,\n \"Sweden\": 38,\n \"Paraguay\": 40,\n \"Czech Republic\": 41,\n \"Scotland\": 43,\n \"Tunisia\": 44,\n \"DR Congo\": 46,\n \"Uzbekistan\": 50,\n \"Qatar\": 55,\n \"Iraq\": 57,\n \"South Africa\": 60,\n \"Saudi Arabia\": 61,\n \"Jordan\": 63,\n \"Bosnia & Herzegovina\": 65,\n \"Cape Verde\": 69,\n \"Ghana\": 74,\n \"Curaçao\": 82,\n \"Haiti\": 83,\n \"New Zealand\": 85,\n};\n",[],[178,274],"66dde9ba-c390-4228-a3de-c566d07b9ab7","predictions.ts","503142e4-6a31-11f1-abd1-1607ee4eb77e",140,["D",1781689545638],"// Prediction rules shared by the view, the POST handler, and the read-side\n// fixture-navigation query. Kept in lib (not a component) so queries.ts can\n// import the \"open\" predicate without depending on the view layer.\n\nimport type { MatchRow } from \"../db.ts\";\n\nexport const SCORE_MIN = 0;\nexport const SCORE_MAX = 20;\n\n// Single definition of \"open for predictions\", shared by the form render, the\n// POST handler, and the fixture-navigation query so the three can never\n// disagree about which matches accept a prediction.\nexport function predictionsOpen(match: MatchRow, now: number = Date.now()): boolean {\n return (\n match.team1_id != null &&\n match.team2_id != null &&\n match.status === \"scheduled\" &&\n now < new Date(match.kickoff_utc).getTime()\n );\n}\n",[],[178,281],"16226328-1c96-4400-a6a9-8e618158dd0e","prediction_scoring_test.ts","aa5e22fe-65d2-11f1-9486-1607ee4eb77e",99,["D",1781209090082],"// Executable spec for prediction scoring. Run with val.town's \"run file\" —\n// prints PASS/FAIL per case and throws on any failure so a red run is loud.\n\nimport { assess, computePredictionLeague, rankPredictions } from \"./prediction_scoring.ts\";\nimport type { MatchRow, PredictionRow } from \"../db.ts\";\n\nlet failures = 0;\n\nfunction check(label: string, actual: unknown, expected: unknown) {\n const a = JSON.stringify(actual);\n const e = JSON.stringify(expected);\n if (a === e) {\n console.log(`PASS ${label}`);\n } else {\n failures++;\n console.error(`FAIL ${label}\\n expected ${e}\\n got ${a}`);\n }\n}\n\nfunction pred(\n contestant: string,\n score1: number,\n score2: number,\n matchId = 1,\n createdUtc = \"2026-06-11T00:00:00.000Z\",\n): PredictionRow {\n return {\n match_id: matchId,\n contestant_id: contestant,\n score1,\n score2,\n created_utc: createdUtc,\n updated_utc: null,\n };\n}\n\n// --- assess: points tiers against actual 2-1 ---\ncheck(\"exact 2-1 → 3pts\", assess(2, 1, 2, 1).points, 3);\ncheck(\"GD-correct 3-2 → 2pts\", assess(3, 2, 2, 1).points, 2);\ncheck(\"GD-correct 1-0 → 2pts\", assess(1, 0, 2, 1).points, 2);\ncheck(\"result-only 2-0 → 1pt\", assess(2, 0, 2, 1).points, 1);\ncheck(\"draw predicted, home won → 0pts\", assess(1, 1, 2, 1).points, 0);\ncheck(\"away win predicted, home won → 0pts\", assess(0, 1, 2, 1).points, 0);\n\n// --- assess: draws — any predicted draw on any actual draw is GD-correct ---\ncheck(\"0-0 on actual 2-2 → 2pts\", assess(0, 0, 2, 2).points, 2);\ncheck(\"2-2 on actual 2-2 → 3pts\", assess(2, 2, 2, 2).points, 3);\n\n// --- rankPredictions: actual 2-2 ---\n// 1-1 and 3-3 both GD-correct with totalDiff 2 → shared rank 1;\n// 0-0 GD-correct totalDiff 4 → rank 3;\n// 2-1 wrong result gdDiff 1 → rank 4; 0-2 wrong result gdDiff 2 → rank 5.\nconst drawRanked = rankPredictions(\n [\n pred(\"a\", 1, 1, 1, \"2026-06-11T00:00:01Z\"),\n pred(\"b\", 0, 0),\n pred(\"c\", 3, 3, 1, \"2026-06-11T00:00:02Z\"),\n pred(\"d\", 2, 1),\n pred(\"e\", 0, 2),\n ],\n 2,\n 2,\n);\ncheck(\n \"ranking on 2-2 (order + shared ranks)\",\n drawRanked.map((r) => [r.contestant_id, r.rank]),\n [[\"a\", 1], [\"c\", 1], [\"b\", 3], [\"d\", 4], [\"e\", 5]],\n);\n\n// --- rankPredictions: totalDiff splits GD-correct win predictions, actual 3-1 ---\n// 2-0 (gdDiff 0, totalDiff 2) above 1-0 (gdDiff 1) above 5-1 (gdDiff 2, result ok)\nconst winRanked = rankPredictions(\n [pred(\"a\", 5, 1), pred(\"b\", 2, 0), pred(\"c\", 1, 0)],\n 3,\n 1,\n);\ncheck(\n \"ranking on 3-1\",\n winRanked.map((r) => [r.contestant_id, r.rank]),\n [[\"b\", 1], [\"c\", 2], [\"a\", 3]],\n);\n\n// --- computePredictionLeague across two finished + one unfinished match ---\nconst matches = [\n { id: 1, status: \"finished\", score1: 2, score2: 1 },\n { id: 2, status: \"finished\", score1: 0, score2: 0 },\n { id: 3, status: \"live\", score1: 1, score2: 0 },\n] as MatchRow[];\nconst league = computePredictionLeague(\n [\n pred(\"a\", 2, 1, 1), // exact → 3\n pred(\"a\", 1, 1, 2), // GD → 2\n pred(\"a\", 9, 0, 3), // live match — must not count\n pred(\"b\", 1, 0, 1), // GD → 2\n pred(\"b\", 0, 0, 2), // exact → 3\n pred(\"c\", 0, 1, 1), // wrong → 0\n ],\n matches,\n);\ncheck(\n \"league rows (points, exacts, rank)\",\n league.map((r) => [r.contestantId, r.points, r.exacts, r.scored, r.rank]),\n // a and b both have 5pts + 1 exact → shared rank 1; c rank 3\n [[\"a\", 5, 1, 2, 1], [\"b\", 5, 1, 2, 1], [\"c\", 0, 0, 1, 3]],\n);\n\nif (failures > 0) throw new Error(`${failures} scoring spec(s) failed`);\nconsole.log(\"all prediction scoring specs passed\");\n",[],[178,289],"ae10f90b-0ffd-4fc0-a788-ca91d438d40b","prediction_scoring.ts","9aeb01fc-65d2-11f1-aec4-1607ee4eb77e",98,["D",1781209064160],"// Prediction assessment, per-match ranking, and season points. Pure functions\n// over (prediction, actual score) so the same code path serves the live\n// provisional ranking, the final ranking, and the season league — outcomes are\n// never persisted, so upstream score corrections self-heal on the next render.\n//\n// Per-match order: correct result first, then closest goal difference, then\n// closest total goals. Season points per prediction: exact score 3, correct\n// goal difference 2, correct result 1, else 0 (an exact GD implies the right\n// result, so the tiers nest cleanly).\n\nimport type { MatchRow, PredictionRow } from \"../db.ts\";\n\nexport type Assessment = {\n resultCorrect: boolean;\n gdDiff: number;\n totalDiff: number;\n exact: boolean;\n points: 0 | 1 | 2 | 3;\n};\n\nfunction sign(n: number): -1 | 0 | 1 {\n return n < 0 ? -1 : n > 0 ? 1 : 0;\n}\n\nexport function assess(p1: number, p2: number, a1: number, a2: number): Assessment {\n const resultCorrect = sign(p1 - p2) === sign(a1 - a2);\n const gdDiff = Math.abs((p1 - p2) - (a1 - a2));\n const totalDiff = Math.abs((p1 + p2) - (a1 + a2));\n const exact = p1 === a1 && p2 === a2;\n const points = exact ? 3 : gdDiff === 0 ? 2 : resultCorrect ? 1 : 0;\n return { resultCorrect, gdDiff, totalDiff, exact, points };\n}\n\nexport type RankedPrediction = PredictionRow & {\n assessment: Assessment;\n rank: number; // competition ranking: full ties share a rank (1, 1, 3, …)\n};\n\nexport function rankPredictions(\n predictions: PredictionRow[],\n a1: number,\n a2: number,\n): RankedPrediction[] {\n const assessed = predictions.map((p) => ({\n ...p,\n assessment: assess(p.score1, p.score2, a1, a2),\n }));\n assessed.sort((x, y) => {\n const ax = x.assessment;\n const ay = y.assessment;\n if (ax.resultCorrect !== ay.resultCorrect) return ax.resultCorrect ? -1 : 1;\n if (ax.gdDiff !== ay.gdDiff) return ax.gdDiff - ay.gdDiff;\n if (ax.totalDiff !== ay.totalDiff) return ax.totalDiff - ay.totalDiff;\n // Full tie — earlier submission listed first, but the rank is shared.\n return x.created_utc.localeCompare(y.created_utc);\n });\n let rank = 0;\n let prev: Assessment | null = null;\n return assessed.map((p, i) => {\n const a = p.assessment;\n const tied = prev != null &&\n prev.resultCorrect === a.resultCorrect &&\n prev.gdDiff === a.gdDiff &&\n prev.totalDiff === a.totalDiff;\n if (!tied) rank = i + 1;\n prev = a;\n return { ...p, rank };\n });\n}\n\nexport type LeagueRow = {\n contestantId: string;\n points: number;\n exacts: number; // 3-pointers\n gds: number; // 2-pointers\n results: number; // 1-pointers\n scored: number; // predictions on finished matches\n rank: number; // ties (points + exacts) share a rank\n};\n\nexport function computePredictionLeague(\n predictions: PredictionRow[],\n matches: MatchRow[],\n): LeagueRow[] {\n const finishedById = new Map(\n matches\n .filter((m) => m.status === \"finished\" && m.score1 != null && m.score2 != null)\n .map((m) => [m.id, m]),\n );\n const byContestant = new Map();\n for (const p of predictions) {\n const m = finishedById.get(p.match_id);\n if (!m) continue;\n const a = assess(p.score1, p.score2, m.score1!, m.score2!);\n const row = byContestant.get(p.contestant_id) ?? {\n contestantId: p.contestant_id,\n points: 0,\n exacts: 0,\n gds: 0,\n results: 0,\n scored: 0,\n rank: 0,\n };\n row.points += a.points;\n row.scored += 1;\n if (a.points === 3) row.exacts += 1;\n else if (a.points === 2) row.gds += 1;\n else if (a.points === 1) row.results += 1;\n byContestant.set(p.contestant_id, row);\n }\n const rows = [...byContestant.values()].sort((x, y) =>\n y.points - x.points ||\n y.exacts - x.exacts ||\n x.contestantId.localeCompare(y.contestantId)\n );\n let rank = 0;\n let prev: LeagueRow | null = null;\n rows.forEach((r, i) => {\n if (!prev || prev.points !== r.points || prev.exacts !== r.exacts) rank = i + 1;\n prev = r;\n r.rank = rank;\n });\n return rows;\n}\n",[],[178,297],"c812c4c6-5ed4-11f1-bfbf-1607ee4eb77e","player_aliases.ts","c812c58e-5ed4-11f1-bfbf-1607ee4eb77e",53,["D",1780440340786],"// External-source player names → our canonical players_v1.name. Maps the\n// renderings we expect from openfootball — mostly accent-dropped forms and a\n// few alternate short forms. The canonicalPlayerName resolver also strips\n// accents as a fallback, so most diacritic variants resolve for free even if\n// not listed below.\n\nexport const PLAYER_ALIASES: Record = {\n // Accent-stripped forms openfootball occasionally emits\n \"Kylian Mbappe\": \"Kylian Mbappé\",\n \"Vinicius Junior\": \"Vinícius Júnior\",\n \"Vinicius Jr\": \"Vinícius Júnior\",\n \"Vini Jr.\": \"Vinícius Júnior\",\n \"Vinícius Jr.\": \"Vinícius Júnior\",\n \"Lautaro Martinez\": \"Lautaro Martínez\",\n \"Julian Alvarez\": \"Julián Álvarez\",\n \"Ousmane Dembele\": \"Ousmane Dembélé\",\n \"Luis Diaz\": \"Luis Díaz\",\n // Alternate renderings\n \"Memphis\": \"Memphis Depay\",\n \"Erling Braut Haaland\": \"Erling Haaland\",\n};\n\nfunction stripAccents(s: string): string {\n return s.normalize(\"NFD\").replace(/[̀-ͯ]/g, \"\");\n}\n\n// Resolve an openfootball scorer name to a canonical players_v1.name, or\n// null if the player isn't in our 22. The fallback handles accent variants\n// not enumerated above.\nexport function canonicalPlayerName(\n scorerName: string,\n canonicalNames: Set,\n): string | null {\n if (canonicalNames.has(scorerName)) return scorerName;\n const aliased = PLAYER_ALIASES[scorerName];\n if (aliased && canonicalNames.has(aliased)) return aliased;\n const target = stripAccents(scorerName).toLowerCase();\n for (const c of canonicalNames) {\n if (stripAccents(c).toLowerCase() === target) return c;\n }\n return null;\n}\n",[],[178,305],"58759152-5ed4-11f1-9301-1607ee4eb77e","forwards.ts","58759224-5ed4-11f1-9301-1607ee4eb77e",50,["D",1780440153520],"// The 22 forwards used in the Top Scorer side-prize draw. Curated from\n// cross-referenced Golden Boot odds (RotoWire, FOX Sports, FanDuel, Covers,\n// snapshotted 2 Jun 2026). Pot A = top 11 by consensus mean rank, Pot B =\n// next 11. Three Pot B spots (Havertz, Wirtz, Luis Díaz) are single-source\n// picks — chosen to add national breadth (Colombia) and the credible German\n// playmakers the consensus stopped short of including.\n//\n// consensusRank is the stable input order — the draw partitions on it\n// (1–11 → Pot A, 12–22 → Pot B) before shuffling.\n\nexport type ForwardSeed = {\n consensusRank: number;\n name: string; // canonical display name\n team: string; // must match teams_v1.name\n};\n\nexport const FORWARDS: ForwardSeed[] = [\n // Pot A — top 11 by consensus\n { consensusRank: 1, name: \"Kylian Mbappé\", team: \"France\" },\n { consensusRank: 2, name: \"Harry Kane\", team: \"England\" },\n { consensusRank: 3, name: \"Erling Haaland\", team: \"Norway\" },\n { consensusRank: 4, name: \"Lionel Messi\", team: \"Argentina\" },\n { consensusRank: 5, name: \"Mikel Oyarzabal\", team: \"Spain\" },\n { consensusRank: 6, name: \"Lamine Yamal\", team: \"Spain\" },\n { consensusRank: 7, name: \"Cristiano Ronaldo\", team: \"Portugal\" },\n { consensusRank: 8, name: \"Raphinha\", team: \"Brazil\" },\n { consensusRank: 9, name: \"Vinícius Júnior\", team: \"Brazil\" },\n { consensusRank: 10, name: \"Julián Álvarez\", team: \"Argentina\" },\n { consensusRank: 11, name: \"Ousmane Dembélé\", team: \"France\" },\n\n // Pot B — next 11\n { consensusRank: 12, name: \"Lautaro Martínez\", team: \"Argentina\" },\n { consensusRank: 13, name: \"Ferran Torres\", team: \"Spain\" },\n { consensusRank: 14, name: \"Cody Gakpo\", team: \"Netherlands\" },\n { consensusRank: 15, name: \"Nick Woltemade\", team: \"Germany\" },\n { consensusRank: 16, name: \"Igor Thiago\", team: \"Brazil\" },\n { consensusRank: 17, name: \"Bukayo Saka\", team: \"England\" },\n { consensusRank: 18, name: \"Romelu Lukaku\", team: \"Belgium\" },\n { consensusRank: 19, name: \"Memphis Depay\", team: \"Netherlands\" },\n { consensusRank: 20, name: \"Kai Havertz\", team: \"Germany\" },\n { consensusRank: 21, name: \"Florian Wirtz\", team: \"Germany\" },\n { consensusRank: 22, name: \"Luis Díaz\", team: \"Colombia\" },\n];\n",[],[178,313],"ffb62044-5d44-11f1-9793-1607ee4eb77e","flags.ts","ffb62120-5d44-11f1-9793-1607ee4eb77e",3,["D",1780268635436],"// Country name → flag emoji. Names match openfootball/worldcup.json verbatim.\n// England and Scotland use subdivision-flag emoji (🏴󠁧󠁢󠁥󠁮󠁧󠁿 / 🏴󠁧󠁢󠁳󠁣󠁴󠁿) —\n// these render on macOS/iOS/modern Android and Windows Chrome (since ~2024).\n\nexport const FLAG: Record = {\n \"Algeria\": \"🇩🇿\",\n \"Argentina\": \"🇦🇷\",\n \"Australia\": \"🇦🇺\",\n \"Austria\": \"🇦🇹\",\n \"Belgium\": \"🇧🇪\",\n \"Bosnia & Herzegovina\": \"🇧🇦\",\n \"Brazil\": \"🇧🇷\",\n \"Canada\": \"🇨🇦\",\n \"Cape Verde\": \"🇨🇻\",\n \"Colombia\": \"🇨🇴\",\n \"Croatia\": \"🇭🇷\",\n \"Curaçao\": \"🇨🇼\",\n \"Czech Republic\": \"🇨🇿\",\n \"DR Congo\": \"🇨🇩\",\n \"Ecuador\": \"🇪🇨\",\n \"Egypt\": \"🇪🇬\",\n \"England\": \"🏴󠁧󠁢󠁥󠁮󠁧󠁿\",\n \"France\": \"🇫🇷\",\n \"Germany\": \"🇩🇪\",\n \"Ghana\": \"🇬🇭\",\n \"Haiti\": \"🇭🇹\",\n \"Iran\": \"🇮🇷\",\n \"Iraq\": \"🇮🇶\",\n \"Ivory Coast\": \"🇨🇮\",\n \"Japan\": \"🇯🇵\",\n \"Jordan\": \"🇯🇴\",\n \"Mexico\": \"🇲🇽\",\n \"Morocco\": \"🇲🇦\",\n \"Netherlands\": \"🇳🇱\",\n \"New Zealand\": \"🇳🇿\",\n \"Norway\": \"🇳🇴\",\n \"Panama\": \"🇵🇦\",\n \"Paraguay\": \"🇵🇾\",\n \"Portugal\": \"🇵🇹\",\n \"Qatar\": \"🇶🇦\",\n \"Saudi Arabia\": \"🇸🇦\",\n \"Scotland\": \"🏴󠁧󠁢󠁳󠁣󠁴󠁿\",\n \"Senegal\": \"🇸🇳\",\n \"South Africa\": \"🇿🇦\",\n \"South Korea\": \"🇰🇷\",\n \"Spain\": \"🇪🇸\",\n \"Sweden\": \"🇸🇪\",\n \"Switzerland\": \"🇨🇭\",\n \"Tunisia\": \"🇹🇳\",\n \"Turkey\": \"🇹🇷\",\n \"USA\": \"🇺🇸\",\n \"Uruguay\": \"🇺🇾\",\n \"Uzbekistan\": \"🇺🇿\",\n};\n",[],[178,321],"fa0779c2-5d44-11f1-8686-1607ee4eb77e","contestants.ts","fa077a6c-5d44-11f1-8686-1607ee4eb77e",["D",1780268625901],"// The 11 contestants. Order matters for the draw — each contestant takes the\n// team at their index from each shuffled pot. Order also defines the colour\n// chip used throughout the UI.\n\nexport type Contestant = {\n id: string; // slug, stable, used as foreign key in team_owners\n name: string; // display name\n colour: string; // Tailwind colour token (used as bg-{colour} / text-{colour})\n hex: string; // raw hex for inline styles where Tailwind class isn't enough\n};\n\nexport const CONTESTANTS: Contestant[] = [\n { id: \"fintan\", name: \"Fintan\", colour: \"blue-500\", hex: \"#3b82f6\" },\n { id: \"cait\", name: \"Cáit\", colour: \"pink-500\", hex: \"#ec4899\" },\n { id: \"dee\", name: \"Dee\", colour: \"emerald-500\", hex: \"#10b981\" },\n { id: \"stuart\", name: \"Stuart\", colour: \"indigo-500\", hex: \"#6366f1\" },\n { id: \"brenda\", name: \"Brenda\", colour: \"orange-500\", hex: \"#f97316\" },\n { id: \"paul\", name: \"Paul\", colour: \"cyan-500\", hex: \"#06b6d4\" },\n { id: \"cian\", name: \"Cian\", colour: \"teal-500\", hex: \"#14b8a6\" },\n { id: \"beth\", name: \"Beth\", colour: \"violet-500\", hex: \"#8b5cf6\" },\n { id: \"james\", name: \"James\", colour: \"amber-500\", hex: \"#f59e0b\" },\n { id: \"jim\", name: \"Jim\", colour: \"red-500\", hex: \"#ef4444\" },\n { id: \"eileen\", name: \"Eileen\", colour: \"lime-500\", hex: \"#84cc16\" },\n];\n\nexport const CONTESTANT_BY_ID: Record =\n Object.fromEntries(CONTESTANTS.map((c) => [c.id, c]));\n",[],[178,329],"f770f788-3253-4504-b829-5e296bf12cc9","allocation.ts","1acda24e-5d45-11f1-9efd-1607ee4eb77e",76,["D",1780563345368],"// Pure draw + prize-cascade logic. No DB, no I/O — testable in isolation.\n//\n// Draw rules (agreed upstream):\n// - sort teams by FIFA rank ascending\n// - drop the bottom 4 (the long-shots)\n// - split the remaining 44 into 4 pots of 11 (pot 1 = top 11 by rank, etc.)\n// - shuffle each pot with a fixed PRNG seed (reproducible, auditable)\n// - each contestant takes the team at their index from each shuffled pot\n\nimport type { Contestant } from \"./contestants.ts\";\n\nexport type DrawTeam = { id: number; name: string; fifaRank: number };\nexport type Allocation = { contestantId: string; teamId: number; pot: number };\nexport type DrawResult = {\n allocations: Allocation[];\n droppedTeamIds: number[];\n};\n\n// Mulberry32: small, deterministic, well-distributed enough for a draw of 11.\n// https://en.wikipedia.org/wiki/Pseudorandom_number_generator\nfunction mulberry32(seed: number): () => number {\n let s = seed >>> 0;\n return () => {\n s = (s + 0x6d2b79f5) >>> 0;\n let t = Math.imul(s ^ (s >>> 15), 1 | s);\n t = (t + Math.imul(t ^ (t >>> 7), 61 | t)) ^ t;\n return ((t ^ (t >>> 14)) >>> 0) / 4294967296;\n };\n}\n\nfunction shuffle(arr: T[], rng: () => number): T[] {\n const a = [...arr];\n for (let i = a.length - 1; i > 0; i--) {\n const j = Math.floor(rng() * (i + 1));\n [a[i], a[j]] = [a[j], a[i]];\n }\n return a;\n}\n\nexport function runDraw(\n teams: DrawTeam[],\n contestants: Contestant[],\n seed: number,\n): DrawResult {\n if (contestants.length !== 11) {\n throw new Error(`expected 11 contestants, got ${contestants.length}`);\n }\n if (teams.length !== 48) {\n throw new Error(`expected 48 teams, got ${teams.length}`);\n }\n\n const sorted = [...teams].sort((a, b) => a.fifaRank - b.fifaRank);\n const inPlay = sorted.slice(0, 44);\n const dropped = sorted.slice(44);\n\n const pots = [0, 1, 2, 3].map((p) => inPlay.slice(p * 11, (p + 1) * 11));\n const rng = mulberry32(seed);\n const shuffledPots = pots.map((pot) => shuffle(pot, rng));\n\n const allocations: Allocation[] = [];\n contestants.forEach((c, i) => {\n shuffledPots.forEach((pot, p) => {\n allocations.push({ contestantId: c.id, teamId: pot[i].id, pot: p + 1 });\n });\n });\n\n return { allocations, droppedTeamIds: dropped.map((t) => t.id) };\n}\n\n// Prize cascade — applied after the tournament finishes.\n// Given placings (1st, 2nd, 3rd, ...) and the owner map, finds the first owned\n// team that finishes highest (= prize winner) and the next-highest owned team\n// after them (= runner-up). If a placing belongs to a dropped (unowned) team,\n// the prize \"cascades\" to the next placing down.\n//\n// `placings` is the placement order of teams as the tournament resolves them,\n// best first (winner at index 0).\n\nexport type Prize = {\n winner: { teamId: number; contestantId: string; placement: number } | null;\n runnerUp: { teamId: number; contestantId: string; placement: number } | null;\n};\n\nexport function resolvePrize(\n placings: number[],\n ownerByTeamId: Map,\n): Prize {\n const owned = placings\n .map((teamId, idx) => ({ teamId, placement: idx + 1, owner: ownerByTeamId.get(teamId) }))\n .filter((p) => p.owner !== undefined) as Array<{\n teamId: number;\n placement: number;\n owner: string;\n }>;\n\n const winner = owned[0]\n ? { teamId: owned[0].teamId, contestantId: owned[0].owner, placement: owned[0].placement }\n : null;\n const runnerUp = owned[1]\n ? { teamId: owned[1].teamId, contestantId: owned[1].owner, placement: owned[1].placement }\n : null;\n\n return { winner, runnerUp };\n}\n\n// Forwards draw — Top Scorer side prize. Same shuffle mechanic as runDraw,\n// applied to 22 curated forwards in 2 pots of 11 (consensus rank 1–11 = Pot A,\n// 12–22 = Pot B). Distinct seed so the two draws are visibly independent —\n// owning a team doesn't predict owning its striker.\n\nexport type DrawForward = { id: number; consensusRank: number };\nexport type PlayerAllocation = {\n contestantId: string;\n playerId: number;\n pot: number;\n};\n\nexport function runForwardsDraw(\n forwards: DrawForward[],\n contestants: Contestant[],\n seed: number,\n): { allocations: PlayerAllocation[] } {\n if (contestants.length !== 11) {\n throw new Error(`expected 11 contestants, got ${contestants.length}`);\n }\n if (forwards.length !== 22) {\n throw new Error(`expected 22 forwards, got ${forwards.length}`);\n }\n\n const sorted = [...forwards].sort((a, b) => a.consensusRank - b.consensusRank);\n const pots = [sorted.slice(0, 11), sorted.slice(11, 22)];\n const rng = mulberry32(seed);\n const shuffledPots = pots.map((pot) => shuffle(pot, rng));\n\n const allocations: PlayerAllocation[] = [];\n contestants.forEach((c, i) => {\n shuffledPots.forEach((pot, p) => {\n allocations.push({ contestantId: c.id, playerId: pot[i].id, pot: p + 1 });\n });\n });\n return { allocations };\n}\n\n// Top Scorer resolver — the owner of the highest-scoring player wins. All 22\n// forwards are owned by construction, so no cascade. Tiebreak: earliest\n// first_goal_utc (whoever got to the tally first). Returns null if no goals\n// have been scored yet.\n\nexport type TopScorerPrize = {\n playerId: number;\n contestantId: string;\n goals: number;\n};\n\ntype TopScorerInput = {\n id: number;\n goals: number;\n first_goal_utc: string | null;\n};\n\nexport function resolveTopScorer(\n players: TopScorerInput[],\n ownerByPlayerId: Map,\n): TopScorerPrize | null {\n const scored = players.filter((p) => p.goals > 0);\n if (scored.length === 0) return null;\n scored.sort((a, b) => {\n if (b.goals !== a.goals) return b.goals - a.goals;\n // Earliest first goal wins the tiebreak. Nulls sort last (defensive —\n // shouldn't occur when goals > 0).\n const aT = a.first_goal_utc ?? \"\";\n const bT = b.first_goal_utc ?? \"\";\n return aT < bT ? -1 : aT > bT ? 1 : 0;\n });\n const winner = scored[0];\n const owner = ownerByPlayerId.get(winner.id);\n if (!owner) return null;\n return { playerId: winner.id, contestantId: owner, goals: winner.goals };\n}\n\n// Wooden Spoon resolver — first contestant to have all 4 teams eliminated\n// wins (loses). Tiebreak when multiple bow out together: worst combined goal\n// difference across their 4 teams. Returns null while ≥1 team is still alive\n// for every contestant.\n//\n// \"First out\" = earliest UTC of (their last team's last finished match). For\n// group-stage exits, that's the 3rd group match. For knockout exits, the\n// knockout match they lost.\n\ntype WoodenSpoonTeam = {\n id: number;\n eliminated_at_stage: string | null;\n};\n\ntype WoodenSpoonOwner = { team_id: number; contestant_id: string };\n\ntype WoodenSpoonMatch = {\n kickoff_utc: string;\n status: string;\n team1_id: number | null;\n team2_id: number | null;\n score1: number | null;\n score2: number | null;\n};\n\nexport type WoodenSpoonPrize = {\n contestantId: string;\n outAtUtc: string;\n combinedGoalDiff: number;\n};\n\nexport function resolveWoodenSpoon(\n teams: WoodenSpoonTeam[],\n owners: WoodenSpoonOwner[],\n matches: WoodenSpoonMatch[],\n): WoodenSpoonPrize | null {\n // Per-team: latest finished kickoff_utc + cumulative goal difference\n const teamStats = new Map();\n for (const t of teams) {\n teamStats.set(t.id, { lastUtc: null, gd: 0 });\n }\n for (const m of matches) {\n if (m.status !== \"finished\") continue;\n if (m.score1 == null || m.score2 == null) continue;\n if (m.team1_id != null) {\n const s = teamStats.get(m.team1_id)!;\n s.gd += m.score1 - m.score2;\n if (!s.lastUtc || m.kickoff_utc > s.lastUtc) s.lastUtc = m.kickoff_utc;\n }\n if (m.team2_id != null) {\n const s = teamStats.get(m.team2_id)!;\n s.gd += m.score2 - m.score1;\n if (!s.lastUtc || m.kickoff_utc > s.lastUtc) s.lastUtc = m.kickoff_utc;\n }\n }\n\n const teamById = new Map(teams.map((t) => [t.id, t]));\n const byContestant = new Map();\n for (const o of owners) {\n const arr = byContestant.get(o.contestant_id) ?? [];\n arr.push(o);\n byContestant.set(o.contestant_id, arr);\n }\n\n type Candidate = { contestantId: string; outAtUtc: string; gd: number };\n const candidates: Candidate[] = [];\n for (const [contestantId, teamRows] of byContestant) {\n let allOut = true;\n let latestOutUtc: string | null = null;\n let combinedGd = 0;\n for (const o of teamRows) {\n const t = teamById.get(o.team_id);\n const stats = teamStats.get(o.team_id);\n if (!t || !stats) {\n allOut = false;\n break;\n }\n if (t.eliminated_at_stage == null) {\n allOut = false;\n break;\n }\n combinedGd += stats.gd;\n if (stats.lastUtc && (!latestOutUtc || stats.lastUtc > latestOutUtc)) {\n latestOutUtc = stats.lastUtc;\n }\n }\n if (allOut && latestOutUtc) {\n candidates.push({ contestantId, outAtUtc: latestOutUtc, gd: combinedGd });\n }\n }\n\n if (candidates.length === 0) return null;\n candidates.sort((a, b) => {\n if (a.outAtUtc !== b.outAtUtc) return a.outAtUtc < b.outAtUtc ? -1 : 1;\n return a.gd - b.gd; // most negative GD first\n });\n const w = candidates[0];\n return { contestantId: w.contestantId, outAtUtc: w.outAtUtc, combinedGoalDiff: w.gd };\n}\n",[],[178,336],["D",1780268617793],[216,217,218,219,220,221,222,223,224,225,226,227],[178],"0f0182c7-5216-45f5-ab78-5cf29fe53917","shared.tsx","a3d3e132-6a30-11f1-91e5-1607ee4eb77e",124,["D",1781689256455],"// View helpers shared across the Pool, Matches, and Predictions pages.\n\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { PageData } from \"../queries.ts\";\nimport type { MatchRow } from \"../db.ts\";\nimport { CONTESTANT_BY_ID } from \"../lib/contestants.ts\";\nimport { MatchCard } from \"./MatchCard.tsx\";\n\nexport function Section(\n { title, subtitle, children }: {\n title: React.ReactNode;\n subtitle?: string;\n children: React.ReactNode;\n },\n) {\n return (\n

{title}

\n {subtitle &&

{subtitle}

}\n

\n {children}\n

\n );\n}\n\n// Reveal-on-scroll wrapper. The js-reveal class + IntersectionObserver in\n// Shell.tsx fades sections up as they enter the viewport; reduced-motion users\n// get them instantly (see the base stylesheet in Shell.tsx).\nexport function Reveal({ children }: { children: React.ReactNode }) {\n return

{children}

;\n}\n\nexport function PrizePill(\n { amount, label, accent }: { amount: string; label: string; accent?: boolean },\n) {\n return (\n \n {amount}\n {label}\n \n );\n}\n\nexport function MatchGrid({ matches, data }: { matches: MatchRow[]; data: PageData }) {\n if (matches.length === 0) return null;\n return (\n

\n {matches.map((m) => {\n const t1 = m.team1_id ? data.teamById.get(m.team1_id) : null;\n const t2 = m.team2_id ? data.teamById.get(m.team2_id) : null;\n return (\n \n );\n })}\n

\n );\n}\n\nexport function OwnerChip({ contestantId }: { contestantId: string | undefined }) {\n if (!contestantId) return null;\n const c = CONTESTANT_BY_ID[contestantId];\n if (!c) return null;\n return (\n \n {c.name}\n \n );\n}\n",[],[185,347],"db791c74-b49e-433d-9d42-e40b9f2ba07b","Shell.tsx","9ecc66fc-5d45-11f1-829e-1607ee4eb77e",134,["D",1781689441358],7,"// HTML shell — Twind for Tailwind, std/catch for client error logging.\n// React 18.2 pinned everywhere to avoid hook-state version conflicts.\n//\n// Type system (taste refresh): Geist for UI/display, Geist Mono for every\n// number (scores, ranks, countdown, GD) via the .num helper — a scoreboard\n// reads better when figures are tabular and monospaced. One locked accent\n// (emerald) is exposed as --accent for the few places that need an inline\n// brand color; everywhere else uses Twind emerald utilities.\n\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { NavBar, type NavTab } from \"./NavBar.tsx\";\n\ntype Props = {\n title: string;\n children: React.ReactNode;\n // Which primary tab to highlight. Pass null to show the nav with no tab\n // active (e.g. the match page). Omit entirely on standalone pages like the\n // draw reveal that shouldn't carry the main nav at all.\n nav?: NavTab | null;\n};\n\nconst BASE_STYLES = `\n :root {\n --accent: #059669; /* emerald-600 : the one locked brand accent */\n --accent-strong: #047857; /* emerald-700 : hover / pressed */\n font-family: 'Geist', system-ui, -apple-system, sans-serif;\n -webkit-font-smoothing: antialiased;\n text-rendering: optimizeLegibility;\n }\n body { font-family: 'Geist', system-ui, -apple-system, sans-serif; }\n\n /* Tabular monospaced figures: apply to any run of numbers. */\n .num, code, .font-mono {\n font-family: 'Geist Mono', ui-monospace, SFMono-Regular, monospace;\n }\n .num { font-variant-numeric: tabular-nums; font-feature-settings: 'tnum' 1; }\n\n ::selection { background: rgba(5, 150, 105, 0.18); }\n\n /* Scroll-reveal. The hidden state ONLY applies once JS adds .reveal-ready to\n (and only when motion is allowed + IntersectionObserver exists), so\n no-JS / reduced-motion / old browsers always render content visible. */\n .reveal-ready .js-reveal {\n opacity: 0;\n transform: translateY(14px);\n transition: opacity 0.6s cubic-bezier(0.16, 1, 0.3, 1),\n transform 0.6s cubic-bezier(0.16, 1, 0.3, 1);\n }\n .reveal-ready .js-reveal.in { opacity: 1; transform: none; }\n\n /* Reduced-motion safety net for the CSS-driven reveals added in the refresh. */\n @media (prefers-reduced-motion: reduce) {\n *, *::before, *::after {\n animation-duration: 0.001ms !important;\n animation-iteration-count: 1 !important;\n transition-duration: 0.001ms !important;\n scroll-behavior: auto !important;\n }\n }\n`;\n\n// Enables the hidden reveal state before first paint — but only when motion is\n// allowed and IntersectionObserver exists, so it can never strand content.\nconst REVEAL_ENABLE = `\n(function () {\n try {\n var m = window.matchMedia;\n var reduce = m && m('(prefers-reduced-motion: reduce)').matches;\n if (!reduce && 'IntersectionObserver' in window) {\n document.documentElement.classList.add('reveal-ready');\n }\n } catch (e) {}\n})();\n`.trim();\n\n// Observes .js-reveal blocks and fades them up as they enter the viewport.\n// A 2.5s timer force-reveals anything still hidden, so an observer edge case\n// can never leave a section invisible.\nconst REVEAL_OBSERVE = `\n(function () {\n var els = document.querySelectorAll('.js-reveal');\n if (!els.length) return;\n if (!document.documentElement.classList.contains('reveal-ready')) return;\n var io = new IntersectionObserver(function (entries) {\n entries.forEach(function (e) {\n if (e.isIntersecting) { e.target.classList.add('in'); io.unobserve(e.target); }\n });\n }, { rootMargin: '0px 0px -8% 0px', threshold: 0.08 });\n els.forEach(function (el) { io.observe(el); });\n setTimeout(function () {\n els.forEach(function (el) { el.classList.add('in'); });\n }, 2500);\n})();\n`.trim();\n\nexport function Shell({ title, children, nav }: Props) {\n const showNav = nav !== undefined;\n return (\n \n \n \n \n \n {title}\n \n \n \n \n \n

Diff · v174