[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_353":354,"_355":356},"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",31,"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","lib/time.ts","latestPath","fileId","472851b0-5d48-11f1-bc72-1607ee4eb77e","name","time.ts","fileType","script","content","// 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","createdAt",["D",1780270043795],"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":348,"_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":349,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":350,"_83":351,"_85":352,"_87":24},"tree",[200,208,216,217,218,219,220],"files",[200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220],"counts",{"_190":62,"_191":144,"_192":62,"_193":194,"_195":196},"contents",[130,131,132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":184,"_31":185,"_29":186,"_140":-5,"_40":41,"_39":187,"_142":58,"_37":188,"_13":62,"_33":182,"_35":-5,"_23":24,"_147":-5,"_26":189},{"_42":177,"_31":178,"_29":179,"_140":-5,"_40":41,"_39":180,"_142":58,"_37":181,"_13":62,"_33":182,"_35":-5,"_23":24,"_147":-5,"_26":183},{"_42":170,"_31":171,"_29":172,"_140":-5,"_40":41,"_39":173,"_142":24,"_37":174,"_13":62,"_33":34,"_35":175,"_23":24,"_147":-5,"_26":176},{"_42":163,"_31":164,"_29":56,"_140":-5,"_40":41,"_39":165,"_142":24,"_37":166,"_13":144,"_33":167,"_35":168,"_23":24,"_147":-5,"_26":169},{"_42":156,"_31":157,"_29":158,"_140":-5,"_40":41,"_39":159,"_142":24,"_37":160,"_13":62,"_33":34,"_35":161,"_23":24,"_147":-5,"_26":162},{"_42":149,"_31":150,"_29":151,"_140":-5,"_40":41,"_39":152,"_142":24,"_37":153,"_13":144,"_33":34,"_35":154,"_23":24,"_147":-5,"_26":155},{"_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},"73183ef8-5d47-11f1-b12f-1607ee4eb77e","sync.ts","78b38fda-5d46-11f1-bd79-1607ee4eb77e","parentId",27,"latest",["D",1780269687994],2,"interval","// Poll worldcup26.ir every 20 minutes for World Cup 2026 fixtures and write\n// scores back to matches_v1. No API key required; endpoint is public.\n//\n// Match keying: (stage, {home_team, away_team} as a set). Each team pair is\n// unique across the entire tournament (groups + knockouts), so the pair alone\n// identifies a fixture — no timezone conversion needed.\n\nimport { allMatches, allTeams, sqlite, type MatchRow, type TeamRow } from \"./db.ts\";\nimport { canonicalTeamName } from \"./lib/team_aliases.ts\";\n\nconst FIXTURES_URL = \"https://worldcup26.ir/get/games\";\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};\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\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\nexport default async function sync(_interval: Interval) {\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 teamByName = new Map(teams.map((t) => [t.name, t]));\n const matchByKey = indexMatches(matches, teamById);\n\n const fixtures = await fetchAllFixtures();\n console.log(`worldcup26.ir returned ${fixtures.length} fixtures.`);\n\n let updated = 0;\n let unmatched = 0;\n const unmatchedSamples: string[] = [];\n\n for (const f of fixtures) {\n const homeRaw = f.home_team_name_en;\n const awayRaw = f.away_team_name_en;\n // Knockout fixtures pre-bracket have null team names — skip until resolved\n if (!homeRaw || !awayRaw) continue;\n\n const home = canonicalTeamName(homeRaw);\n const away = canonicalTeamName(awayRaw);\n const key = `${f.type}|${pairKey(home, away)}`;\n const dbMatch = matchByKey.get(key);\n if (!dbMatch) {\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 score1 = ?, score2 = ?, status = ?, external_id = ?\n WHERE id = ?`,\n args: [score1, score2, status, f.id, dbMatch.id],\n });\n updated++;\n }\n\n const eliminated = await recomputeEliminations();\n\n const summary = { fetched: fixtures.length, updated, unmatched, unmatchedSamples, eliminated };\n console.log(\"sync complete:\", JSON.stringify(summary));\n return summary;\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 if (groupRemaining === 0) {\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","label",[138],"6bffa04a-5d45-11f1-897f-1607ee4eb77e","seed.ts","55eb2432-5d45-11f1-b402-1607ee4eb77e",9,["D",1780268817108],"// One-shot seed: fetch openfootball fixtures, populate teams + run the draw +\n// load the 104 matches. Idempotent — returns early if already seeded.\n//\n// To re-seed from scratch:\n// 1. Truncate via sqlite_execute: DELETE FROM matches_v1; DELETE FROM\n// team_owners_v1; DELETE FROM teams_v1;\n// 2. Re-run this file via run_file.\n\nimport { ensureSchema, sqlite } from \"./db.ts\";\nimport { CONTESTANTS } from \"./lib/contestants.ts\";\nimport { FIFA_RANK } from \"./lib/rankings.ts\";\nimport { FLAG } from \"./lib/flags.ts\";\nimport { DRAW_SEED, runDraw } from \"./lib/allocation.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 seed() {\n await ensureSchema();\n\n const existing = await sqlite.execute(\"SELECT COUNT(*) AS n FROM teams_v1\");\n const count = Number((existing.rows[0] as Record).n ?? 0);\n if (count > 0) {\n console.log(`Already seeded (${count} teams). Skipping.`);\n return { skipped: true, teams: count };\n }\n\n console.log(\"Fetching openfootball fixtures…\");\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, DRAW_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} 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 };\n}\n\nconst result = await seed();\nconsole.log(\"seed complete:\", JSON.stringify(result));\n",[150],"9dee94bc-5d45-11f1-829e-1607ee4eb77e","queries.ts","9dee95ac-5d45-11f1-829e-1607ee4eb77e",10,["D",1780268900892],"// Read-side queries for the scoreboard. Pure DB → typed objects, no view logic.\n\nimport { allMatches, allOwners, allTeams, type MatchRow, type OwnerRow, type TeamRow } from \"./db.ts\";\n\nexport type PageData = {\n teams: TeamRow[];\n owners: OwnerRow[];\n matches: MatchRow[];\n teamById: Map;\n ownerByTeamId: Map;\n generatedAtUtc: string;\n};\n\nexport async function loadPageData(): Promise {\n const [teams, owners, matches] = await Promise.all([\n allTeams(),\n allOwners(),\n allMatches(),\n ]);\n return {\n teams,\n owners,\n matches,\n teamById: new Map(teams.map((t) => [t.id, t])),\n ownerByTeamId: new Map(owners.map((o) => [o.team_id, o.contestant_id])),\n generatedAtUtc: new Date().toISOString(),\n };\n}\n\nexport function partitionMatches(matches: MatchRow[], now: Date = new Date()) {\n const nowMs = now.getTime();\n const dayMs = 24 * 60 * 60 * 1000;\n\n const live: MatchRow[] = [];\n const today: MatchRow[] = [];\n const upcoming: MatchRow[] = [];\n const recent: MatchRow[] = [];\n\n // \"Today\" = matches kicking off within ±18h of now — covers the football day\n // regardless of time zone (US matches stretch from 12:00 ET to 21:00 PT).\n const todayWindowStart = nowMs - 6 * 60 * 60 * 1000;\n const todayWindowEnd = nowMs + 18 * 60 * 60 * 1000;\n\n for (const m of matches) {\n const kickoff = new Date(m.kickoff_utc).getTime();\n if (m.status === \"live\" || m.status === \"ht\") {\n live.push(m);\n } else if (m.status === \"finished\") {\n recent.push(m);\n } else if (kickoff >= todayWindowStart && kickoff <= todayWindowEnd) {\n today.push(m);\n } else if (kickoff > todayWindowEnd) {\n upcoming.push(m);\n }\n }\n\n recent.sort((a, b) => b.kickoff_utc.localeCompare(a.kickoff_utc));\n upcoming.sort((a, b) => a.kickoff_utc.localeCompare(b.kickoff_utc));\n today.sort((a, b) => a.kickoff_utc.localeCompare(b.kickoff_utc));\n\n return {\n live,\n today,\n upcoming: upcoming.slice(0, 6),\n recent: recent.slice(0, 6),\n };\n}\n",[157],"40f0dbe8-5d46-11f1-ae9f-1607ee4eb77e","main.tsx",19,["D",1780269174310],"http","// HTTP entrypoint. Hono routes + SSR React.\n//\n// / scoreboard (public)\n// /draw animated draw reveal\n// /source redirect to val source (val.town convention)\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 { Scoreboard } from \"./components/Scoreboard.tsx\";\nimport { buildPots, DrawPage } from \"./components/Draw.tsx\";\nimport { loadPageData } from \"./queries.ts\";\n\nconst app = new Hono();\n\n// Full stack traces on errors\napp.onError((err) => Promise.reject(err));\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.get(\"/\", 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 = await loadPageData();\n const pots = buildPots(data.teams, data.owners);\n const html = renderToString(\n \n \n ,\n );\n return c.html(\"\" + html);\n});\n\nexport default app.fetch;\n",[164],"06f29bc6-5d45-11f1-8fa3-1607ee4eb77e","db.ts","06f29c98-5d45-11f1-8fa3-1607ee4eb77e",4,["D",1780268647574],"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 ]);\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 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 allOwners(): Promise {\n const r = await sqlite.execute(\"SELECT * FROM team_owners_v1\");\n return r.rows as unknown as OwnerRow[];\n}\n\nexport { sqlite };\n",[171],"f532486e-5d44-11f1-8dd4-1607ee4eb77e","lib","8bf1bfba-d2fe-4bb4-943d-f0a6d16de91a",1,["D",1780268617793],"directory",[178],"9ecc8a6a-5d45-11f1-829e-1607ee4eb77e","components","59fa7e05-9fd4-4fdb-bbdd-d29d8e3aa11e",11,["D",1780268902344],[185],"pulls","branches","forks","envVars",{"_197":62,"_199":62},"connections",{"_197":62,"_198":62},"count","unfilledCount","emptyCount",{"_42":184,"_31":185,"_29":186,"_140":-5,"_40":41,"_39":187,"_142":58,"_37":345,"_13":62,"_33":182,"_35":-5,"_23":24,"_147":-5,"_222":346,"_26":347},{"_42":337,"_31":338,"_29":339,"_140":186,"_40":41,"_39":340,"_142":24,"_37":341,"_13":62,"_33":34,"_35":342,"_23":24,"_147":-5,"_222":343,"_26":344},{"_42":329,"_31":330,"_29":331,"_140":186,"_40":41,"_39":332,"_142":24,"_37":333,"_13":62,"_33":34,"_35":334,"_23":24,"_147":-5,"_222":335,"_26":336},{"_42":321,"_31":322,"_29":323,"_140":186,"_40":41,"_39":324,"_142":24,"_37":325,"_13":62,"_33":34,"_35":326,"_23":24,"_147":-5,"_222":327,"_26":328},{"_42":313,"_31":314,"_29":315,"_140":186,"_40":41,"_39":316,"_142":24,"_37":317,"_13":62,"_33":34,"_35":318,"_23":24,"_147":-5,"_222":319,"_26":320},{"_42":305,"_31":306,"_29":307,"_140":186,"_40":41,"_39":308,"_142":24,"_37":309,"_13":62,"_33":34,"_35":310,"_23":24,"_147":-5,"_222":311,"_26":312},{"_42":297,"_31":298,"_29":299,"_140":186,"_40":41,"_39":300,"_142":24,"_37":301,"_13":282,"_33":34,"_35":302,"_23":24,"_147":-5,"_222":303,"_26":304},{"_42":290,"_31":291,"_29":292,"_140":186,"_40":41,"_39":187,"_142":24,"_37":293,"_13":62,"_33":34,"_35":294,"_23":24,"_147":-5,"_222":295,"_26":296},{"_42":177,"_31":178,"_29":179,"_140":-5,"_40":41,"_39":180,"_142":58,"_37":287,"_13":62,"_33":182,"_35":-5,"_23":24,"_147":-5,"_222":288,"_26":289},{"_42":279,"_31":280,"_29":281,"_140":179,"_40":41,"_39":282,"_142":24,"_37":283,"_13":62,"_33":34,"_35":284,"_23":24,"_147":-5,"_222":285,"_26":286},{"_42":272,"_31":273,"_29":274,"_140":179,"_40":41,"_39":144,"_142":58,"_37":275,"_13":62,"_33":34,"_35":276,"_23":24,"_147":-5,"_222":277,"_26":278},{"_42":264,"_31":265,"_29":266,"_140":179,"_40":41,"_39":267,"_142":58,"_37":268,"_13":62,"_33":34,"_35":269,"_23":24,"_147":-5,"_222":270,"_26":271},{"_42":257,"_31":258,"_29":259,"_140":179,"_40":41,"_39":180,"_142":58,"_37":260,"_13":62,"_33":34,"_35":261,"_23":24,"_147":-5,"_222":262,"_26":263},{"_42":249,"_31":250,"_29":251,"_140":179,"_40":41,"_39":252,"_142":24,"_37":253,"_13":62,"_33":34,"_35":254,"_23":24,"_147":-5,"_222":255,"_26":256},{"_42":241,"_31":242,"_29":243,"_140":179,"_40":41,"_39":244,"_142":58,"_37":245,"_13":180,"_33":34,"_35":246,"_23":24,"_147":-5,"_222":247,"_26":248},{"_42":237,"_31":32,"_29":30,"_140":179,"_40":41,"_39":14,"_142":58,"_37":238,"_13":62,"_33":34,"_35":36,"_23":24,"_147":-5,"_222":239,"_26":240},{"_42":170,"_31":171,"_29":172,"_140":-5,"_40":41,"_39":173,"_142":24,"_37":234,"_13":62,"_33":34,"_35":175,"_23":24,"_147":-5,"_222":235,"_26":236},{"_42":163,"_31":164,"_29":56,"_140":-5,"_40":41,"_39":165,"_142":24,"_37":231,"_13":144,"_33":167,"_35":168,"_23":24,"_147":-5,"_222":232,"_26":233},{"_42":156,"_31":157,"_29":158,"_140":-5,"_40":41,"_39":159,"_142":24,"_37":228,"_13":62,"_33":34,"_35":161,"_23":24,"_147":-5,"_222":229,"_26":230},{"_42":149,"_31":150,"_29":151,"_140":-5,"_40":41,"_39":152,"_142":24,"_37":225,"_13":144,"_33":34,"_35":154,"_23":24,"_147":-5,"_222":226,"_26":227},{"_42":137,"_31":138,"_29":139,"_140":-5,"_40":41,"_39":141,"_142":24,"_37":221,"_13":144,"_33":145,"_35":146,"_23":24,"_147":-5,"_222":223,"_26":224},["D",1780269687994],"children",[],[138],["D",1780268817108],[],[150],["D",1780268900892],[],[157],["D",1780269174310],[],[164],["D",1780268647574],[],[171],"472850d4-5d48-11f1-bc72-1607ee4eb77e",["D",1780270043795],[],[178,32],"2bf6eb6e-5d47-11f1-8e97-1607ee4eb77e","team_aliases.ts","6a8a06aa-5d46-11f1-aeed-1607ee4eb77e",25,["D",1780269568671],"// External-source team names → our canonical (openfootball) names.\n// Maps every alias we've observed in the live data sources we use.\n\nexport const TEAM_ALIASES: Record = {\n // worldcup26.ir\n \"Bosnia and Herzegovina\": \"Bosnia & Herzegovina\",\n \"Democratic Republic of the Congo\": \"DR Congo\",\n \"United States\": \"USA\",\n // Anticipated variants from other sources\n \"Korea Republic\": \"South Korea\",\n \"Korea, South\": \"South Korea\",\n \"Cote d'Ivoire\": \"Ivory Coast\",\n \"Côte d'Ivoire\": \"Ivory Coast\",\n \"Czechia\": \"Czech Republic\",\n \"Bosnia Herzegovina\": \"Bosnia & Herzegovina\",\n \"Cabo Verde\": \"Cape Verde\",\n \"Cape Verde Islands\": \"Cape Verde\",\n \"Congo DR\": \"DR Congo\",\n \"DRC\": \"DR Congo\",\n \"Türkiye\": \"Turkey\",\n \"Turkiye\": \"Turkey\",\n};\n\nexport function canonicalTeamName(name: string): string {\n return TEAM_ALIASES[name] ?? name;\n}\n",[],[178,242],"23a6891c-5d45-11f1-b3d7-1607ee4eb77e","scoring.ts","23a689e4-5d45-11f1-b3d7-1607ee4eb77e",6,["D",1780268695734],"// Leaderboard computation — pure function over teams, owners, matches.\n//\n// During the tournament we rank contestants by:\n// 1. number of teams still in the competition (DESC)\n// 2. total goals scored by their teams in finished matches (DESC) — tiebreak\n// 3. best (lowest) FIFA rank among their teams (ASC) — final tiebreak\n//\n// The real prize is determined at the end via lib/allocation#resolvePrize.\n\nimport type { MatchRow, OwnerRow, TeamRow } from \"../db.ts\";\n\nexport type ContestantStanding = {\n contestantId: string;\n teamsAlive: number;\n goalsFor: number;\n goalsAgainst: number;\n bestRank: number;\n teams: Array<{\n teamId: number;\n name: string;\n flag: string;\n fifaRank: number;\n eliminatedAtStage: string | null;\n }>;\n};\n\nexport function computeStandings(\n teams: TeamRow[],\n owners: OwnerRow[],\n matches: MatchRow[],\n): ContestantStanding[] {\n const teamById = new Map(teams.map((t) => [t.id, t]));\n const ownersByContestant = new Map();\n for (const o of owners) {\n const arr = ownersByContestant.get(o.contestant_id) ?? [];\n arr.push(o);\n ownersByContestant.set(o.contestant_id, arr);\n }\n\n // Pre-compute goals for/against per team from finished matches\n const goalsFor = new Map();\n const goalsAgainst = new Map();\n for (const m of matches) {\n if (m.status !== \"finished\" && m.status !== \"live\" && m.status !== \"ht\") continue;\n if (m.score1 == null || m.score2 == null) continue;\n if (m.team1_id != null) {\n goalsFor.set(m.team1_id, (goalsFor.get(m.team1_id) ?? 0) + m.score1);\n goalsAgainst.set(m.team1_id, (goalsAgainst.get(m.team1_id) ?? 0) + m.score2);\n }\n if (m.team2_id != null) {\n goalsFor.set(m.team2_id, (goalsFor.get(m.team2_id) ?? 0) + m.score2);\n goalsAgainst.set(m.team2_id, (goalsAgainst.get(m.team2_id) ?? 0) + m.score1);\n }\n }\n\n const standings: ContestantStanding[] = [];\n for (const [contestantId, ownerRows] of ownersByContestant) {\n const teamRows = ownerRows\n .map((o) => teamById.get(o.team_id))\n .filter((t): t is TeamRow => t != null);\n\n let teamsAlive = 0;\n let totalFor = 0;\n let totalAgainst = 0;\n let bestRank = Number.POSITIVE_INFINITY;\n const teamSummaries: ContestantStanding[\"teams\"] = [];\n\n for (const t of teamRows) {\n if (t.eliminated_at_stage == null) teamsAlive++;\n totalFor += goalsFor.get(t.id) ?? 0;\n totalAgainst += goalsAgainst.get(t.id) ?? 0;\n if (t.fifa_rank < bestRank) bestRank = t.fifa_rank;\n teamSummaries.push({\n teamId: t.id,\n name: t.name,\n flag: t.flag,\n fifaRank: t.fifa_rank,\n eliminatedAtStage: t.eliminated_at_stage,\n });\n }\n\n // Display teams best-rank first\n teamSummaries.sort((a, b) => a.fifaRank - b.fifaRank);\n\n standings.push({\n contestantId,\n teamsAlive,\n goalsFor: totalFor,\n goalsAgainst: totalAgainst,\n bestRank: bestRank === Number.POSITIVE_INFINITY ? 999 : bestRank,\n teams: teamSummaries,\n });\n }\n\n standings.sort((a, b) => {\n if (b.teamsAlive !== a.teamsAlive) return b.teamsAlive - a.teamsAlive;\n if (b.goalsFor !== a.goalsFor) return b.goalsFor - a.goalsFor;\n return a.bestRank - b.bestRank;\n });\n\n return standings;\n}\n",[],[178,250],"f5321e7a-5d44-11f1-8dd4-1607ee4eb77e","rankings.ts","f5321f42-5d44-11f1-8dd4-1607ee4eb77e",["D",1780268617793],"// FIFA Men's World Ranking — 01 April 2026 release.\n// Source: https://www.whereig.com/football/fifa-world-rankings.html (cross-checked\n// against ESPN's top-20 article). Rankings don't change during the tournament,\n// so this snapshot is stable for the duration of the pool.\n//\n// Country names match openfootball/worldcup.json verbatim so they can be\n// joined without translation. Only the 48 qualified teams are listed.\n\nexport const FIFA_RANK: Record = {\n \"France\": 1,\n \"Spain\": 2,\n \"Argentina\": 3,\n \"England\": 4,\n \"Portugal\": 5,\n \"Brazil\": 6,\n \"Netherlands\": 7,\n \"Morocco\": 8,\n \"Belgium\": 9,\n \"Germany\": 10,\n \"Croatia\": 11,\n \"Colombia\": 13,\n \"Senegal\": 14,\n \"Mexico\": 15,\n \"USA\": 16,\n \"Uruguay\": 17,\n \"Japan\": 18,\n \"Switzerland\": 19,\n \"Iran\": 21,\n \"Turkey\": 22,\n \"Ecuador\": 23,\n \"Austria\": 24,\n \"South Korea\": 25,\n \"Australia\": 27,\n \"Algeria\": 28,\n \"Egypt\": 29,\n \"Canada\": 30,\n \"Norway\": 31,\n \"Panama\": 33,\n \"Ivory Coast\": 34,\n \"Sweden\": 38,\n \"Paraguay\": 40,\n \"Czech Republic\": 41,\n \"Scotland\": 43,\n \"Tunisia\": 44,\n \"DR Congo\": 46,\n \"Uzbekistan\": 50,\n \"Qatar\": 55,\n \"Iraq\": 57,\n \"South Africa\": 60,\n \"Saudi Arabia\": 61,\n \"Jordan\": 63,\n \"Bosnia & Herzegovina\": 65,\n \"Cape Verde\": 69,\n \"Ghana\": 74,\n \"Curaçao\": 82,\n \"Haiti\": 83,\n \"New Zealand\": 85,\n};\n",[],[178,258],"ffb62044-5d44-11f1-9793-1607ee4eb77e","flags.ts","ffb62120-5d44-11f1-9793-1607ee4eb77e",3,["D",1780268635436],"// Country name → flag emoji. Names match openfootball/worldcup.json verbatim.\n// England and Scotland use subdivision-flag emoji (🏴󠁧󠁢󠁥󠁮󠁧󠁿 / 🏴󠁧󠁢󠁳󠁣󠁴󠁿) —\n// these render on macOS/iOS/modern Android and Windows Chrome (since ~2024).\n\nexport const FLAG: Record = {\n \"Algeria\": \"🇩🇿\",\n \"Argentina\": \"🇦🇷\",\n \"Australia\": \"🇦🇺\",\n \"Austria\": \"🇦🇹\",\n \"Belgium\": \"🇧🇪\",\n \"Bosnia & Herzegovina\": \"🇧🇦\",\n \"Brazil\": \"🇧🇷\",\n \"Canada\": \"🇨🇦\",\n \"Cape Verde\": \"🇨🇻\",\n \"Colombia\": \"🇨🇴\",\n \"Croatia\": \"🇭🇷\",\n \"Curaçao\": \"🇨🇼\",\n \"Czech Republic\": \"🇨🇿\",\n \"DR Congo\": \"🇨🇩\",\n \"Ecuador\": \"🇪🇨\",\n \"Egypt\": \"🇪🇬\",\n \"England\": \"🏴󠁧󠁢󠁥󠁮󠁧󠁿\",\n \"France\": \"🇫🇷\",\n \"Germany\": \"🇩🇪\",\n \"Ghana\": \"🇬🇭\",\n \"Haiti\": \"🇭🇹\",\n \"Iran\": \"🇮🇷\",\n \"Iraq\": \"🇮🇶\",\n \"Ivory Coast\": \"🇨🇮\",\n \"Japan\": \"🇯🇵\",\n \"Jordan\": \"🇯🇴\",\n \"Mexico\": \"🇲🇽\",\n \"Morocco\": \"🇲🇦\",\n \"Netherlands\": \"🇳🇱\",\n \"New Zealand\": \"🇳🇿\",\n \"Norway\": \"🇳🇴\",\n \"Panama\": \"🇵🇦\",\n \"Paraguay\": \"🇵🇾\",\n \"Portugal\": \"🇵🇹\",\n \"Qatar\": \"🇶🇦\",\n \"Saudi Arabia\": \"🇸🇦\",\n \"Scotland\": \"🏴󠁧󠁢󠁳󠁣󠁴󠁿\",\n \"Senegal\": \"🇸🇳\",\n \"South Africa\": \"🇿🇦\",\n \"South Korea\": \"🇰🇷\",\n \"Spain\": \"🇪🇸\",\n \"Sweden\": \"🇸🇪\",\n \"Switzerland\": \"🇨🇭\",\n \"Tunisia\": \"🇹🇳\",\n \"Turkey\": \"🇹🇷\",\n \"USA\": \"🇺🇸\",\n \"Uruguay\": \"🇺🇾\",\n \"Uzbekistan\": \"🇺🇿\",\n};\n",[],[178,265],"fa0779c2-5d44-11f1-8686-1607ee4eb77e","contestants.ts","fa077a6c-5d44-11f1-8686-1607ee4eb77e",["D",1780268625901],"// The 11 contestants. Order matters for the draw — each contestant takes the\n// team at their index from each shuffled pot. Order also defines the colour\n// chip used throughout the UI.\n\nexport type Contestant = {\n id: string; // slug, stable, used as foreign key in team_owners\n name: string; // display name\n colour: string; // Tailwind colour token (used as bg-{colour} / text-{colour})\n hex: string; // raw hex for inline styles where Tailwind class isn't enough\n};\n\nexport const CONTESTANTS: Contestant[] = [\n { id: \"fintan\", name: \"Fintan\", colour: \"blue-500\", hex: \"#3b82f6\" },\n { id: \"cait\", name: \"Cáit\", colour: \"pink-500\", hex: \"#ec4899\" },\n { id: \"dee\", name: \"Dee\", colour: \"emerald-500\", hex: \"#10b981\" },\n { id: \"stuart\", name: \"Stuart\", colour: \"indigo-500\", hex: \"#6366f1\" },\n { id: \"brenda\", name: \"Brenda\", colour: \"orange-500\", hex: \"#f97316\" },\n { id: \"paul\", name: \"Paul\", colour: \"cyan-500\", hex: \"#06b6d4\" },\n { id: \"cian\", name: \"Cian\", colour: \"teal-500\", hex: \"#14b8a6\" },\n { id: \"beth\", name: \"Beth\", colour: \"violet-500\", hex: \"#8b5cf6\" },\n { id: \"james\", name: \"James\", colour: \"amber-500\", hex: \"#f59e0b\" },\n { id: \"jim\", name: \"Jim\", colour: \"red-500\", hex: \"#ef4444\" },\n { id: \"eileen\", name: \"Eileen\", colour: \"lime-500\", hex: \"#84cc16\" },\n];\n\nexport const CONTESTANT_BY_ID: Record =\n Object.fromEntries(CONTESTANTS.map((c) => [c.id, c]));\n",[],[178,273],"1acda1a4-5d45-11f1-9efd-1607ee4eb77e","allocation.ts","1acda24e-5d45-11f1-9efd-1607ee4eb77e",5,["D",1780268680890],"// 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// Seed used for the live draw — World Cup 2026 opening day, deterministic.\nexport const DRAW_SEED = 20260611;\n",[],[178,280],["D",1780268617793],[209,210,211,212,213,214,215],[178],"9ecc6652-5d45-11f1-829e-1607ee4eb77e","Shell.tsx","9ecc66fc-5d45-11f1-829e-1607ee4eb77e",["D",1780268902344],"// HTML shell — Twind for Tailwind, std/catch for client error logging.\n// React 18.2 pinned everywhere to avoid hook-state version conflicts.\n\nimport React from \"https://esm.sh/react@18.2.0\";\n\ntype Props = {\n title: string;\n children: React.ReactNode;\n};\n\nexport function Shell({ title, children }: Props) {\n return (\n \n \n \n \n {title}\n \n \n \n \n \n \n \n \n {children}\n \n \n );\n}\n",[],[185,291],"897eceaa-5d47-11f1-9d7c-1607ee4eb77e","Scoreboard.tsx","c94b1a68-5d45-11f1-8238-1607ee4eb77e",30,["D",1780269725588],"// Main scoreboard page composition.\n\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { PageData } from \"../queries.ts\";\nimport { partitionMatches } from \"../queries.ts\";\nimport { computeStandings } from \"../lib/scoring.ts\";\nimport { MatchCard } from \"./MatchCard.tsx\";\nimport { ContestantRow } from \"./ContestantRow.tsx\";\nimport { computeGroupStandings, GroupTable } from \"./GroupTable.tsx\";\nimport { KnockoutSchedule } from \"./KnockoutSchedule.tsx\";\nimport type { MatchRow } from \"../db.ts\";\n\nfunction Section({ title, subtitle, children }: { title: string; subtitle?: string; children: React.ReactNode }) {\n return (\n

{title}

\n {subtitle &&

{subtitle}

}\n

\n {children}\n

\n );\n}\n\nfunction 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 Scoreboard({ data }: { data: PageData }) {\n const { live, today, upcoming, recent } = partitionMatches(data.matches);\n const standings = computeStandings(data.teams, data.owners, data.matches);\n const groupStandings = computeGroupStandings(data.teams, data.matches, data.owners);\n\n const droppedTeams = data.teams.filter((t) => t.dropped === 1);\n const finishedMatches = data.matches.filter((m) => m.status === \"finished\").length;\n const totalMatches = data.matches.length;\n const firstKickoff = new Date(data.matches[0]?.kickoff_utc ?? Date.now()).getTime();\n const msToOpener = firstKickoff - Date.now();\n const daysToOpener = Math.ceil(msToOpener / (1000 * 60 * 60 * 24));\n const tournamentStarted = msToOpener <= 0;\n\n // Knockout bracket \"resolved\" once any KO match has real team_ids\n const knockoutHasRealTeams = data.matches.some(\n (m) => m.stage !== \"group\" && (m.team1_id != null || m.team2_id != null),\n );\n\n return (\n

\n 🏆\n

\n World Cup Pool 2026\n

\n 11 contestants · €20 buy-in · €200 to the winner, €20 back to the runner-up.\n Teams allocated by seeded random draw from FIFA-ranked pots.\n {\" \"}\n Watch the draw →\n \n

\n {finishedMatches}/{totalMatches} matches played · Last updated {new Date(data.generatedAtUtc).toLocaleString(\"en-IE\", { hour12: false })}\n

\n\n {!tournamentStarted && (\n

Kick-off in

\n {daysToOpener} day{daysToOpener === 1 ? \"\" : \"s\"}\n

\n 🇲🇽 Mexico v South Africa 🇿🇦 · Thu 11 Jun 2026 · 19:00 UTC · Estadio Azteca\n

\n )}\n\n {live.length > 0 && (\n

\n \n

\n )}\n\n \n

\n {standings.map((s, i) => (\n \n ))}\n

\n \n\n {today.length > 0 && (\n

\n \n

\n )}\n\n {recent.length > 0 && (\n

\n \n

\n )}\n\n {upcoming.length > 0 && (\n

\n \n

\n )}\n\n

\n {knockoutHasRealTeams\n ? \n : (\n

\n Group stage runs 11–27 June. The 32-team\n knockout bracket — Round of 32 through Final — locks in once the last group\n match wraps. Check back then.\n

\n )}\n

\n\n

\n {[...groupStandings.entries()]\n .sort(([a], [b]) => a.localeCompare(b))\n .map(([letter, rows]) => )}\n

\n\n {droppedTeams.length > 0 && (\n

\n {droppedTeams.map((t) => (\n

\n {t.flag}\n {t.name}\n FIFA #{t.fifa_rank}\n

\n ))}\n

\n If a dropped team finishes 1st or 2nd, the prize cascades to the next owned team in the placings.\n

\n )}\n\n \n

\n );\n}\n",[],[185,298],"a4cbfcfc-5d45-11f1-b572-1607ee4eb77e","MatchCard.tsx","a4cbfd92-5d45-11f1-b572-1607ee4eb77e",12,["D",1780268912405],"// Scoreboard-style match card. Used in live, today, upcoming, recent sections.\n\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { MatchRow } from \"../db.ts\";\nimport { CONTESTANT_BY_ID } from \"../lib/contestants.ts\";\n\ntype TeamRender = {\n flag: string;\n name: string;\n ownerId: string | null;\n};\n\ntype Props = {\n match: MatchRow;\n team1: TeamRender;\n team2: TeamRender;\n};\n\nfunction fmtKickoff(iso: string): string {\n const d = new Date(iso);\n // Display in user-local-ish format with day + time\n const day = d.toLocaleDateString(\"en-IE\", {\n weekday: \"short\",\n day: \"numeric\",\n month: \"short\",\n });\n const time = d.toLocaleTimeString(\"en-IE\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: false,\n });\n return `${day} · ${time}`;\n}\n\nfunction StatusPill({ status, score1, score2 }: { status: string; score1: number | null; score2: number | null }) {\n if (status === \"live\") {\n return (\n \n \n LIVE\n \n );\n }\n if (status === \"ht\") {\n return (\n \n HALF-TIME\n \n );\n }\n if (status === \"finished\") {\n return (\n \n FT\n \n );\n }\n return null;\n}\n\nfunction OwnerChip({ ownerId }: { ownerId: string | null }) {\n if (!ownerId) {\n return unowned;\n }\n const c = CONTESTANT_BY_ID[ownerId];\n if (!c) return null;\n return (\n \n {c.name}\n \n );\n}\n\nexport function MatchCard({ match, team1, team2 }: Props) {\n const hasScore = match.score1 != null && match.score2 != null;\n const showStatus = match.status !== \"scheduled\";\n return (\n

\n \n {match.group_letter ? `Group ${match.group_letter}` : match.round}\n \n {showStatus\n ? \n : {fmtKickoff(match.kickoff_utc)}}\n

\n {team1.flag}\n

{team1.name}

\n \n

\n {hasScore ? `${match.score1} – ${match.score2}` : vs}\n

{team2.name}

\n {team2.flag}\n

{match.ground}

\n );\n}\n",[],[185,306],"9d76f6f4-5d46-11f1-af15-1607ee4eb77e","KnockoutSchedule.tsx","9d76f7c6-5d46-11f1-af15-1607ee4eb77e",22,["D",1780269329600],"// Knockout-stage overview. Lists every R32 → Final fixture grouped by stage.\n// Before group stage ends, most matches have placeholder team names (W74,\n// L101 etc.). Once teams resolve, real flags appear.\n\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { MatchRow, TeamRow } from \"../db.ts\";\nimport { CONTESTANT_BY_ID } from \"../lib/contestants.ts\";\n\nconst STAGE_LABEL: Record = {\n r32: \"Round of 32\",\n r16: \"Round of 16\",\n qf: \"Quarter-finals\",\n sf: \"Semi-finals\",\n third: \"Third-place play-off\",\n final: \"Final\",\n};\n\nconst STAGE_ORDER = [\"r32\", \"r16\", \"qf\", \"sf\", \"third\", \"final\"] as const;\n\nfunction fmtKickoff(iso: string): string {\n const d = new Date(iso);\n return d.toLocaleDateString(\"en-IE\", { weekday: \"short\", day: \"numeric\", month: \"short\" }) +\n \" · \" +\n d.toLocaleTimeString(\"en-IE\", { hour: \"2-digit\", minute: \"2-digit\", hour12: false });\n}\n\nfunction Side({ flag, name, ownerId, score, isWinner }: {\n flag: string; name: string; ownerId: string | null; score: number | null; isWinner: boolean;\n}) {\n const owner = ownerId ? CONTESTANT_BY_ID[ownerId] : null;\n return (\n

\n {flag}\n {name}\n {owner && (\n \n )}\n

\n \n {score ?? \"\"}\n \n

\n );\n}\n\nexport function KnockoutSchedule({\n matches,\n teamById,\n ownerByTeamId,\n}: {\n matches: MatchRow[];\n teamById: Map;\n ownerByTeamId: Map;\n}) {\n const ko = matches.filter((m) => m.stage !== \"group\");\n if (ko.length === 0) return null;\n\n const byStage = new Map();\n for (const m of ko) {\n const arr = byStage.get(m.stage) ?? [];\n arr.push(m);\n byStage.set(m.stage, arr);\n }\n for (const arr of byStage.values()) {\n arr.sort((a, b) => a.kickoff_utc.localeCompare(b.kickoff_utc));\n }\n\n return (\n

\n {STAGE_ORDER.map((stage) => {\n const stageMatches = byStage.get(stage);\n if (!stageMatches?.length) return null;\n return (\n

\n {STAGE_LABEL[stage]}\n

\n {stageMatches.map((m) => {\n const t1 = m.team1_id ? teamById.get(m.team1_id) : null;\n const t2 = m.team2_id ? teamById.get(m.team2_id) : null;\n const flag1 = t1?.flag ?? \"❓\";\n const name1 = t1?.name ?? m.team1_placeholder ?? \"TBD\";\n const flag2 = t2?.flag ?? \"❓\";\n const name2 = t2?.name ?? m.team2_placeholder ?? \"TBD\";\n const owner1 = m.team1_id ? ownerByTeamId.get(m.team1_id) ?? null : null;\n const owner2 = m.team2_id ? ownerByTeamId.get(m.team2_id) ?? null : null;\n const decided = m.status === \"finished\" && m.score1 != null && m.score2 != null;\n const winner1 = decided && m.score1! > m.score2!;\n const winner2 = decided && m.score2! > m.score1!;\n return (\n

\n {fmtKickoff(m.kickoff_utc)}\n {m.ground}\n

\n \n \n

\n );\n })}\n

\n );\n}\n",[],[185,314],"b60c26b8-5d45-11f1-a24f-1607ee4eb77e","GroupTable.tsx","b60c278a-5d45-11f1-a24f-1607ee4eb77e",14,["D",1780268941343],"// Mini group standings — P W D L GF GA Pts. Computed from finished group matches.\n\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { MatchRow, OwnerRow, TeamRow } from \"../db.ts\";\nimport { CONTESTANT_BY_ID } from \"../lib/contestants.ts\";\n\ntype GroupRow = {\n team: TeamRow;\n p: number; w: number; d: number; l: number;\n gf: number; ga: number; pts: number;\n ownerId: string | null;\n};\n\nexport function computeGroupStandings(\n teams: TeamRow[],\n matches: MatchRow[],\n owners: OwnerRow[],\n): Map {\n const ownerByTeamId = new Map(owners.map((o) => [o.team_id, o.contestant_id]));\n const teamsByGroup = new Map();\n for (const t of teams) {\n const arr = teamsByGroup.get(t.group_letter) ?? [];\n arr.push(t);\n teamsByGroup.set(t.group_letter, arr);\n }\n\n const out = new Map();\n for (const [letter, groupTeams] of teamsByGroup) {\n const rowByTeamId = new Map();\n for (const t of groupTeams) {\n rowByTeamId.set(t.id, {\n team: t,\n p: 0, w: 0, d: 0, l: 0,\n gf: 0, ga: 0, pts: 0,\n ownerId: ownerByTeamId.get(t.id) ?? null,\n });\n }\n const groupMatches = matches.filter(\n (m) => m.stage === \"group\" && m.group_letter === letter &&\n m.status === \"finished\" &&\n m.score1 != null && m.score2 != null,\n );\n for (const m of groupMatches) {\n if (m.team1_id == null || m.team2_id == null) continue;\n const r1 = rowByTeamId.get(m.team1_id);\n const r2 = rowByTeamId.get(m.team2_id);\n if (!r1 || !r2) continue;\n r1.p++; r2.p++;\n r1.gf += m.score1!; r1.ga += m.score2!;\n r2.gf += m.score2!; r2.ga += m.score1!;\n if (m.score1! > m.score2!) { r1.w++; r1.pts += 3; r2.l++; }\n else if (m.score1! < m.score2!) { r2.w++; r2.pts += 3; r1.l++; }\n else { r1.d++; r1.pts++; r2.d++; r2.pts++; }\n }\n const rows = [...rowByTeamId.values()];\n rows.sort((a, b) => {\n if (b.pts !== a.pts) return b.pts - a.pts;\n const gdA = a.gf - a.ga;\n const gdB = b.gf - b.ga;\n if (gdB !== gdA) return gdB - gdA;\n if (b.gf !== a.gf) return b.gf - a.gf;\n return a.team.fifa_rank - b.team.fifa_rank;\n });\n out.set(letter, rows);\n }\n return out;\n}\n\nexport function GroupTable({ letter, rows }: { letter: string; rows: GroupRow[] }) {\n return (\n

Group {letter}

\n \n \n \n \n \n \n \n \n \n \n \n \n \n {rows.map((r, i) => {\n const owner = r.ownerId ? CONTESTANT_BY_ID[r.ownerId] : null;\n const qualifying = i < 2;\n return (\n \n \n \n \n \n \n \n \n \n );\n })}\n \n

Team	P	W	D	L	GD	Pts
\n \n {r.team.flag}\n {r.team.name}\n {owner && (\n \n )}\n \n	{r.p}	{r.w}	{r.d}	{r.l}	{r.gf - r.ga > 0 ? \"+\" : \"\"}{r.gf - r.ga}	{r.pts}

\n );\n}\n",[],[185,322],"3c482d8a-5d46-11f1-9c61-1607ee4eb77e","Draw.tsx","3c482e34-5d46-11f1-9c61-1607ee4eb77e",17,["D",1780269166551],"// Draw reveal page. The allocation is fixed in the DB (seeded RNG, immutable).\n// This page is purely theatre: the server ships the data, the client paces a\n// pot-by-pot, contestant-by-contestant reveal that feels like a live broadcast.\n//\n// Contestants are revealed in the order defined in lib/contestants.ts so anyone\n// watching knows roughly when their turn is up.\n\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { OwnerRow, TeamRow } from \"../db.ts\";\nimport { CONTESTANT_BY_ID, CONTESTANTS } from \"../lib/contestants.ts\";\n\ntype Card = {\n contestantId: string;\n contestantName: string;\n hex: string;\n flag: string;\n teamName: string;\n fifaRank: number;\n};\n\ntype Pot = {\n number: number;\n label: string;\n rankRange: string;\n cards: Card[];\n};\n\nexport function buildPots(teams: TeamRow[], owners: OwnerRow[]): Pot[] {\n const teamById = new Map(teams.map((t) => [t.id, t]));\n const contestantIdx = new Map(CONTESTANTS.map((c, i) => [c.id, i]));\n\n const pots: Pot[] = [1, 2, 3, 4].map((n) => ({\n number: n,\n label: `Pot ${n}`,\n rankRange: \"\",\n cards: [],\n }));\n\n for (const o of owners) {\n const t = teamById.get(o.team_id);\n const c = CONTESTANT_BY_ID[o.contestant_id];\n if (!t || !c) continue;\n pots[o.pot - 1].cards.push({\n contestantId: o.contestant_id,\n contestantName: c.name,\n hex: c.hex,\n flag: t.flag,\n teamName: t.name,\n fifaRank: t.fifa_rank,\n });\n }\n\n for (const p of pots) {\n p.cards.sort(\n (a, b) =>\n (contestantIdx.get(a.contestantId) ?? 0) -\n (contestantIdx.get(b.contestantId) ?? 0),\n );\n const ranks = p.cards.map((c) => c.fifaRank);\n p.rankRange = ranks.length\n ? `FIFA #${Math.min(...ranks)}–${Math.max(...ranks)}`\n : \"\";\n }\n\n return pots;\n}\n\n// Inline script that drives the reveal. Pure DOM — no React on the client.\nconst DRAW_SCRIPT = `\n(function() {\n var REVEAL_ANTICIPATION_MS = 1100;\n var REVEAL_HOLD_MS = 700;\n var POT_INTRO_MS = 1600;\n var BETWEEN_POTS_MS = 600;\n\n var cancelled = false;\n var playing = false;\n\n var startBtn = document.getElementById('draw-play');\n var skipBtn = document.getElementById('draw-skip');\n var statusEl = document.getElementById('draw-status');\n\n function sleep(ms) { return new Promise(function(r) { setTimeout(r, ms); }); }\n\n function setStatus(text) { if (statusEl) statusEl.textContent = text; }\n\n async function revealCard(card) {\n card.classList.add('drawing');\n setStatus(card.dataset.contestantName + ' — Pot ' + card.dataset.pot + '…');\n await sleep(REVEAL_ANTICIPATION_MS);\n if (cancelled) return;\n card.classList.remove('drawing');\n card.classList.add('revealed');\n await sleep(REVEAL_HOLD_MS);\n }\n\n async function revealAll() {\n if (playing) return;\n playing = true;\n cancelled = false;\n startBtn.disabled = true;\n startBtn.textContent = 'Drawing…';\n\n for (var p = 1; p <= 4; p++) {\n if (cancelled) break;\n var intro = document.getElementById('pot-intro-' + p);\n if (intro) {\n intro.classList.add('active');\n setStatus('Pot ' + p);\n await sleep(POT_INTRO_MS);\n intro.classList.remove('active');\n }\n var cards = document.querySelectorAll('[data-pot=\"' + p + '\"].card');\n for (var i = 0; i < cards.length; i++) {\n if (cancelled) break;\n await revealCard(cards[i]);\n }\n if (!cancelled) await sleep(BETWEEN_POTS_MS);\n }\n\n playing = false;\n startBtn.disabled = false;\n startBtn.textContent = '↻ Replay';\n setStatus('Draw complete');\n }\n\n function skip() {\n cancelled = true;\n document.querySelectorAll('.card').forEach(function(c) {\n c.classList.remove('drawing');\n c.classList.add('revealed');\n });\n playing = false;\n startBtn.disabled = false;\n startBtn.textContent = '↻ Replay';\n setStatus('All teams revealed');\n }\n\n function resetCards() {\n cancelled = true;\n document.querySelectorAll('.card').forEach(function(c) {\n c.classList.remove('revealed');\n c.classList.remove('drawing');\n });\n }\n\n startBtn.addEventListener('click', function() {\n if (playing) return;\n resetCards();\n setTimeout(revealAll, 100);\n });\n skipBtn.addEventListener('click', skip);\n})();\n`.trim();\n\nconst DRAW_STYLES = `\n .card {\n position: relative;\n transition: transform 0.4s ease, box-shadow 0.4s ease;\n }\n .card .face-back { opacity: 1; transition: opacity 0.3s; }\n .card .face-front { opacity: 0; transform: scale(0.85); transition: opacity 0.45s ease, transform 0.45s ease; pointer-events: none; }\n .card.drawing {\n transform: scale(1.06);\n box-shadow: 0 12px 36px -8px rgba(15, 23, 42, 0.25);\n animation: drawPulse 0.55s ease-in-out infinite alternate;\n }\n .card.revealed .face-back { opacity: 0; pointer-events: none; }\n .card.revealed .face-front { opacity: 1; transform: scale(1); position: relative; }\n .card.revealed { animation: none; transform: scale(1); }\n @keyframes drawPulse {\n from { box-shadow: 0 6px 20px -4px rgba(15, 23, 42, 0.15); }\n to { box-shadow: 0 16px 40px -6px rgba(15, 23, 42, 0.35); }\n }\n .pot-intro {\n opacity: 0; transform: translateY(-8px); pointer-events: none;\n transition: opacity 0.4s ease, transform 0.4s ease;\n }\n .pot-intro.active { opacity: 1; transform: translateY(0); }\n`.trim();\n\nexport function DrawPage({ pots }: { pots: Pot[] }) {\n return (\n

Diff · v31