[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_459":460,"_461":462},"routes/_app.x.$handle.$name",{"_99":98,"_31":44,"_108":89,"_26":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":24,"_123":124,"_125":58,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":24},"version",153,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","components/AboutPage.tsx","latestPath","fileId","83909e50-6a36-11f1-903b-1607ee4eb77e","name","AboutPage.tsx","fileType","script","content","// About page (\"/about\"): what the pool is and how the €220 pot is split. Pulled\n// off the Pool home so that page leads straight with live football and standings.\n\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Section } from \"./shared.tsx\";\n\nconst PRIZES: { amount: string; name: string; desc: string; accent?: boolean }[] = [\n {\n amount: \"€150\",\n name: \"Winner\",\n accent: true,\n desc: \"The owner whose four teams last the longest — top of the leaderboard.\",\n },\n {\n amount: \"€30\",\n name: \"Top scorer\",\n desc: \"The owner of the tournament's Golden Boot winner, one of the 22 drawn forwards.\",\n },\n {\n amount: \"€20\",\n name: \"Runner-up\",\n desc: \"Second place on the leaderboard.\",\n },\n {\n amount: \"€20\",\n name: \"Wooden spoon\",\n desc: \"The first contestant to have all four of their teams eliminated.\",\n },\n];\n\nexport function AboutPage() {\n return (\n

About the pool

\n Eleven friends, €20 each, a €220 pot. Each contestant is assigned four\n teams and two forwards by seeded, reproducible draws.{\" \"}\n \n Watch the draw →\n \n

\n\n

\n {PRIZES.map((p) => (\n \n \n {p.amount}\n

{p.name}

{p.desc}

\n ))}\n \n

\n Winner and runner-up cascade to the next owned team if a dropped team\n finishes top two. Top scorer (all 22 forwards owned) and wooden spoon\n do not cascade. The leaderboard ranks by teams remaining, then total\n goals scored, then best FIFA rank.\n

\n \n \n );\n}\n","createdAt",["D",1781691779312],"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",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":24},"branch",{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"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",{"_42":43,"_31":44,"_37":454,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":455,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":456,"_83":457,"_85":458,"_87":24},"tree",[204,218,231,232,233,234,235],"files",[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,233,234,235],"counts",{"_194":62,"_195":178,"_196":62,"_197":198,"_199":200},"contents",[130,131,132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":188,"_31":189,"_29":190,"_140":-5,"_40":41,"_39":191,"_142":58,"_37":192,"_13":62,"_33":186,"_35":-5,"_23":24,"_147":-5,"_26":193},{"_42":181,"_31":182,"_29":183,"_140":-5,"_40":41,"_39":184,"_142":58,"_37":185,"_13":62,"_33":186,"_35":-5,"_23":24,"_147":-5,"_26":187},{"_42":173,"_31":174,"_29":175,"_140":-5,"_40":41,"_39":176,"_142":24,"_37":177,"_13":178,"_33":34,"_35":179,"_23":24,"_147":-5,"_26":180},{"_42":165,"_31":166,"_29":56,"_140":-5,"_40":41,"_39":167,"_142":24,"_37":168,"_13":169,"_33":170,"_35":171,"_23":24,"_147":-5,"_26":172},{"_42":157,"_31":158,"_29":159,"_140":-5,"_40":41,"_39":160,"_142":58,"_37":161,"_13":162,"_33":34,"_35":163,"_23":24,"_147":-5,"_26":164},{"_42":149,"_31":150,"_29":151,"_140":-5,"_40":41,"_39":152,"_142":58,"_37":153,"_13":154,"_33":34,"_35":155,"_23":24,"_147":-5,"_26":156},{"_42":137,"_31":138,"_29":139,"_140":-5,"_40":41,"_39":141,"_142":24,"_37":143,"_13":144,"_33":145,"_35":146,"_23":24,"_147":-5,"_26":148},"1e4cb461-2179-41bd-95ee-dfc56604d95c","sync.ts","78b38fda-5d46-11f1-bd79-1607ee4eb77e","parentId",121,"latest",["D",1781646485014],13,"interval","// 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};\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 ensureFixtureIdColumn() {\n try {\n await sqlite.execute(\"ALTER TABLE matches_v1 ADD COLUMN external_id TEXT\");\n } catch (_e) {\n // already exists\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\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 unmatched = 0;\n const unmatchedSamples: string[] = [];\n const unknownTeams = new Set();\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 // First time the API names a knockout fixture's teams, persist them so the\n // row joins the normal score/elimination paths. Done in the unified UPDATE\n // below; here we just resolve the names and stamp the in-memory row.\n if (isKnockout && dbMatch && dbMatch.team1_id == null) {\n const homeId = teamIdByName.get(home);\n const awayId = teamIdByName.get(away);\n if (homeId && awayId) {\n // A knockout slot has no pre-existing canonical order, so home→team1.\n dbMatch.team1_id = homeId;\n dbMatch.team2_id = awayId;\n resolved++;\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 return {\n fetched: fixtures.length,\n updated,\n resolved,\n unmatched,\n unmatchedSamples,\n unknownTeams: [...unknownTeams],\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","label",[138],"ae8b9ae6-d38a-4050-9898-04cb4a1ff706","seed.ts","55eb2432-5d45-11f1-b402-1607ee4eb77e",74,["D",1780563305362],8,"// 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",[150],"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",[158],"534189a3-9c97-4cca-88cc-faf7f50ac0b1","main.tsx",151,["D",1781690071295],20,"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// /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 { 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(\"/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",[166],"d6382ab8-5ddd-489d-abf8-12bb7521a36b","db.ts","06f29c98-5d45-11f1-8fa3-1607ee4eb77e",97,["D",1781209039757],2,"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 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 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",[174],"f532486e-5d44-11f1-8dd4-1607ee4eb77e","lib","8bf1bfba-d2fe-4bb4-943d-f0a6d16de91a",1,["D",1780268617793],"directory",[182],"9ecc8a6a-5d45-11f1-829e-1607ee4eb77e","components","59fa7e05-9fd4-4fdb-bbdd-d29d8e3aa11e",11,["D",1780268902344],[189],"pulls","branches","forks","envVars",{"_201":62,"_203":62},"connections",{"_201":62,"_202":62},"count","unfilledCount","emptyCount",{"_42":188,"_31":189,"_29":190,"_140":-5,"_40":41,"_39":191,"_142":58,"_37":451,"_13":62,"_33":186,"_35":-5,"_23":24,"_147":-5,"_237":452,"_26":453},{"_42":447,"_31":32,"_29":30,"_140":190,"_40":41,"_39":14,"_142":58,"_37":448,"_13":62,"_33":34,"_35":36,"_23":24,"_147":-5,"_237":449,"_26":450},{"_42":439,"_31":440,"_29":441,"_140":190,"_40":41,"_39":442,"_142":24,"_37":443,"_13":178,"_33":34,"_35":444,"_23":24,"_147":-5,"_237":445,"_26":446},{"_42":431,"_31":432,"_29":433,"_140":190,"_40":41,"_39":434,"_142":58,"_37":435,"_13":169,"_33":34,"_35":436,"_23":24,"_147":-5,"_237":437,"_26":438},{"_42":423,"_31":424,"_29":425,"_140":190,"_40":41,"_39":426,"_142":58,"_37":427,"_13":178,"_33":34,"_35":428,"_23":24,"_147":-5,"_237":429,"_26":430},{"_42":415,"_31":416,"_29":417,"_140":190,"_40":41,"_39":418,"_142":24,"_37":419,"_13":326,"_33":34,"_35":420,"_23":24,"_147":-5,"_237":421,"_26":422},{"_42":407,"_31":408,"_29":409,"_140":190,"_40":41,"_39":410,"_142":24,"_37":411,"_13":162,"_33":34,"_35":412,"_23":24,"_147":-5,"_237":413,"_26":414},{"_42":399,"_31":400,"_29":401,"_140":190,"_40":41,"_39":402,"_142":24,"_37":403,"_13":343,"_33":34,"_35":404,"_23":24,"_147":-5,"_237":405,"_26":406},{"_42":391,"_31":392,"_29":393,"_140":190,"_40":41,"_39":394,"_142":58,"_37":395,"_13":62,"_33":34,"_35":396,"_23":24,"_147":-5,"_237":397,"_26":398},{"_42":383,"_31":384,"_29":385,"_140":190,"_40":41,"_39":386,"_142":24,"_37":387,"_13":62,"_33":34,"_35":388,"_23":24,"_147":-5,"_237":389,"_26":390},{"_42":375,"_31":376,"_29":377,"_140":190,"_40":41,"_39":378,"_142":24,"_37":379,"_13":62,"_33":34,"_35":380,"_23":24,"_147":-5,"_237":381,"_26":382},{"_42":367,"_31":368,"_29":369,"_140":190,"_40":41,"_39":370,"_142":58,"_37":371,"_13":62,"_33":34,"_35":372,"_23":24,"_147":-5,"_237":373,"_26":374},{"_42":358,"_31":359,"_29":360,"_140":190,"_40":41,"_39":361,"_142":58,"_37":362,"_13":363,"_33":34,"_35":364,"_23":24,"_147":-5,"_237":365,"_26":366},{"_42":350,"_31":351,"_29":352,"_140":190,"_40":41,"_39":353,"_142":24,"_37":354,"_13":62,"_33":34,"_35":355,"_23":24,"_147":-5,"_237":356,"_26":357},{"_42":181,"_31":182,"_29":183,"_140":-5,"_40":41,"_39":184,"_142":58,"_37":347,"_13":62,"_33":186,"_35":-5,"_23":24,"_147":-5,"_237":348,"_26":349},{"_42":338,"_31":339,"_29":340,"_140":183,"_40":41,"_39":341,"_142":58,"_37":342,"_13":343,"_33":34,"_35":344,"_23":24,"_147":-5,"_237":345,"_26":346},{"_42":331,"_31":332,"_29":333,"_140":183,"_40":41,"_39":178,"_142":58,"_37":334,"_13":62,"_33":34,"_35":335,"_23":24,"_147":-5,"_237":336,"_26":337},{"_42":323,"_31":324,"_29":325,"_140":183,"_40":41,"_39":326,"_142":58,"_37":327,"_13":62,"_33":34,"_35":328,"_23":24,"_147":-5,"_237":329,"_26":330},{"_42":315,"_31":316,"_29":317,"_140":183,"_40":41,"_39":318,"_142":58,"_37":319,"_13":62,"_33":34,"_35":320,"_23":24,"_147":-5,"_237":321,"_26":322},{"_42":307,"_31":308,"_29":309,"_140":183,"_40":41,"_39":310,"_142":58,"_37":311,"_13":62,"_33":34,"_35":312,"_23":24,"_147":-5,"_237":313,"_26":314},{"_42":299,"_31":300,"_29":301,"_140":183,"_40":41,"_39":302,"_142":58,"_37":303,"_13":62,"_33":34,"_35":304,"_23":24,"_147":-5,"_237":305,"_26":306},{"_42":291,"_31":292,"_29":293,"_140":183,"_40":41,"_39":294,"_142":58,"_37":295,"_13":62,"_33":34,"_35":296,"_23":24,"_147":-5,"_237":297,"_26":298},{"_42":283,"_31":284,"_29":285,"_140":183,"_40":41,"_39":286,"_142":58,"_37":287,"_13":62,"_33":34,"_35":288,"_23":24,"_147":-5,"_237":289,"_26":290},{"_42":276,"_31":277,"_29":278,"_140":183,"_40":41,"_39":184,"_142":58,"_37":279,"_13":62,"_33":34,"_35":280,"_23":24,"_147":-5,"_237":281,"_26":282},{"_42":268,"_31":269,"_29":270,"_140":183,"_40":41,"_39":271,"_142":24,"_37":272,"_13":62,"_33":34,"_35":273,"_23":24,"_147":-5,"_237":274,"_26":275},{"_42":260,"_31":261,"_29":262,"_140":183,"_40":41,"_39":263,"_142":58,"_37":264,"_13":184,"_33":34,"_35":265,"_23":24,"_147":-5,"_237":266,"_26":267},{"_42":252,"_31":253,"_29":254,"_140":183,"_40":41,"_39":255,"_142":58,"_37":256,"_13":62,"_33":34,"_35":257,"_23":24,"_147":-5,"_237":258,"_26":259},{"_42":173,"_31":174,"_29":175,"_140":-5,"_40":41,"_39":176,"_142":24,"_37":249,"_13":178,"_33":34,"_35":179,"_23":24,"_147":-5,"_237":250,"_26":251},{"_42":165,"_31":166,"_29":56,"_140":-5,"_40":41,"_39":167,"_142":24,"_37":246,"_13":169,"_33":170,"_35":171,"_23":24,"_147":-5,"_237":247,"_26":248},{"_42":157,"_31":158,"_29":159,"_140":-5,"_40":41,"_39":160,"_142":58,"_37":243,"_13":162,"_33":34,"_35":163,"_23":24,"_147":-5,"_237":244,"_26":245},{"_42":149,"_31":150,"_29":151,"_140":-5,"_40":41,"_39":152,"_142":58,"_37":240,"_13":154,"_33":34,"_35":155,"_23":24,"_147":-5,"_237":241,"_26":242},{"_42":137,"_31":138,"_29":139,"_140":-5,"_40":41,"_39":141,"_142":24,"_37":236,"_13":144,"_33":145,"_35":146,"_23":24,"_147":-5,"_237":238,"_26":239},["D",1781646485014],"children",[],[138],["D",1780563305362],[],[150],["D",1781689596493],[],[158],["D",1781690071295],[],[166],["D",1781209039757],[],[174],"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",[],[182,253],"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",[],[182,261],"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",[],[182,269],"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",[],[182,277],"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",[],[182,284],"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",[],[182,292],"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",[],[182,300],"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",[],[182,308],"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",[],[182,316],"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",[],[182,324],"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",[],[182,332],"f770f788-3253-4504-b829-5e296bf12cc9","allocation.ts","1acda24e-5d45-11f1-9efd-1607ee4eb77e",76,["D",1780563345368],4,"// 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",[],[182,339],["D",1780268617793],[219,220,221,222,223,224,225,226,227,228,229,230],[182],"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",[],[189,351],"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 · v153