[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_288":289,"_290":291},"routes/_app.x.$handle.$name",{"_98":97,"_32":46,"_106":88,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":124,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",70,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","frontend/admin.tsx","latestPath","fileId","b0d4eaf0-1bc7-11f1-b180-42dde27851f2","name","admin.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\n// ---- Types ----\n\ninterface Manager {\n id: number;\n email: string;\n teamName: string;\n pickCount: number;\n}\n\ninterface ConflictResolution {\n playerAdp: number;\n playerName: string;\n contestants: Array<{ managerId: number; teamName: string }>;\n winnerId: number;\n winnerTeamName: string;\n}\n\ninterface RoundResult {\n roundNumber: number;\n nominations: Array<{\n managerId: number;\n teamName: string;\n nominatedAdp: number;\n playerName: string;\n }>;\n uncontested: Array<{\n managerId: number;\n teamName: string;\n playerAdp: number;\n playerName: string;\n }>;\n conflicts: ConflictResolution[];\n winners: Array<{\n managerId: number;\n teamName: string;\n playerAdp: number;\n playerName: string;\n }>;\n}\n\ninterface DraftSlot {\n slot: number;\n managerId: number;\n teamName: string;\n email: string;\n playerAdp: number;\n playerName: string;\n playerTeam: string;\n playerPosition: string;\n}\n\ninterface DraftResult {\n seed: string;\n managerCount: number;\n rounds: RoundResult[];\n finalSlots: DraftSlot[];\n}\n\n// ---- Derive admin API base from current page URL ----\n// The admin page is at /draft-admin/r8k2p5m9x1 and the API\n// is at /draft-admin/r8k2p5m9x1/api/*. Derive automatically\n// so the obscured path only exists in one place (the server).\nconst ADMIN_API = window.location.pathname.replace(/\\/$/, \"\") + \"/api\";\n\n// ---- API helpers ----\n\nasync function apiGet(path: string) {\n const res = await fetch(path);\n if (!res.ok) throw new Error(await res.text());\n return res.json();\n}\n\nasync function apiPost(path: string, body: unknown) {\n const res = await fetch(path, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n if (!res.ok) throw new Error(await res.text());\n return res.json();\n}\n\n// ---- Manager List ----\n\nfunction ManagerList({ managers }: { managers: Manager[] }) {\n if (managers.length === 0) {\n return (\n

No managers have signed up yet.

\n );\n }\n\n return (\n \n \n \n \n \n \n \n \n \n \n {managers.map((m, i) => (\n \n \n \n \n \n \n ))}\n \n

#	Team Name	Email	Picks Submitted
{i + 1}	{m.teamName}	{m.email}	\n {m.pickCount > 0\n ? (\n \n {m.pickCount} players ranked\n \n )\n : No picks yet}\n

\n );\n}\n\n// ---- Draft Results Display ----\n\nfunction DraftResults({ result }: { result: DraftResult }) {\n return (\n

\n Draft executed with seed: {result.seed} —{\" \"}\n {result.managerCount} manager{result.managerCount !== 1 ? \"s\" : \"\"},\n {\" \"}\n {result.rounds.length} round{result.rounds.length !== 1 ? \"s\" : \"\"}{\" \"}\n to resolve\n

\n\n {/* Final Draft Order */}\n

\n Final First-Round Draft Order\n

\n {result.finalSlots.map((slot) => (\n

\n \n {slot.slot}\n

{slot.teamName}

\n Selected: {slot.playerName} (ADP {slot.playerAdp}) ·{\" \"}\n {slot.playerTeam} · {slot.playerPosition}\n

\n ))}\n

\n\n {/* Round-by-round breakdown */}\n

Round-by-Round Breakdown

\n\n {result.rounds.map((round) => (\n

\n Round {round.roundNumber}\n \n {round.nominations.length}{\" \"}\n manager{round.nominations.length !== 1 ? \"s\" : \"\"}{\" \"}\n nominating — {round.winners.length} picked\n \n

\n {/* Nominations */}\n

Nominations

\n {nom.teamName} nominates{\" \"}\n {nom.playerName} (ADP {nom.nominatedAdp})\n

\n\n {/* Uncontested picks */}\n {round.uncontested.length > 0 && (\n

Uncontested

\n {pick.teamName} gets{\" \"}\n {pick.playerName} (ADP {pick.playerAdp})\n Awarded\n

\n )}\n\n {/* Conflicts */}\n {round.conflicts.length > 0 && (\n

Lottery Drawings

\n {round.conflicts.map((conflict) => (\n

\n {conflict.playerName} (ADP{\" \"}\n {conflict.playerAdp})\n \n {conflict.contestants.length}-way contest\n \n

\n {c.teamName}\n {c.managerId === conflict.winnerId && (\n Winner\n )}\n \n ))}\n

\n ))}\n

\n )}\n

\n ))}\n \n );\n}\n\n// ---- Admin App ----\n\nfunction AdminApp() {\n const [managers, setManagers] = useState([]);\n const [seed, setSeed] = useState(\"\");\n const [executing, setExecuting] = useState(false);\n const [simulating, setSimulating] = useState(false);\n const [error, setError] = useState(\"\");\n const [result, setResult] = useState(null);\n const [loading, setLoading] = useState(true);\n\n const refresh = async () => {\n try {\n const [mgrs, existing] = await Promise.all([\n apiGet(`${ADMIN_API}/managers`),\n apiGet(`${ADMIN_API}/results`),\n ]);\n setManagers(mgrs);\n if (existing) {\n setResult(existing.result as DraftResult);\n setSeed((existing.result as DraftResult).seed);\n }\n } catch (err: any) {\n setError(err.message);\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n refresh();\n }, []);\n\n const runSimulation = async () => {\n if (\n !confirm(\n \"This will DELETE all existing managers, picks, and results, then populate 12 fake managers with test picks.\\n\\nContinue?\",\n )\n ) {\n return;\n }\n setSimulating(true);\n setError(\"\");\n setResult(null);\n try {\n await apiPost(`${ADMIN_API}/simulate`, {});\n await refresh();\n } catch (err: any) {\n setError(err.message);\n } finally {\n setSimulating(false);\n }\n };\n\n const executeDraft = async () => {\n if (!seed.trim()) {\n setError(\"Enter a random seed first\");\n return;\n }\n if (\n !confirm(\n `Execute the draft with seed \"${seed.trim()}\"?\\n\\nThis will determine the first-round order and lock all picks.`,\n )\n ) {\n return;\n }\n setExecuting(true);\n setError(\"\");\n try {\n const data = await apiPost(`${ADMIN_API}/execute`, { seed: seed.trim() });\n setResult(data);\n } catch (err: any) {\n setError(err.message);\n } finally {\n setExecuting(false);\n }\n };\n\n if (loading) return

Loading admin panel...

;\n\n return (\n

\n NPB Draft Admin\n

Commissioner's draft execution panel

\n\n {/* Simulation */}\n \n \n

\n Simulation Mode\n \n Populate 12 fake managers with weighted picks to test the draft\n algorithm. Creates realistic conflicts on top players.\n

\n \n {simulating ? \"Populating...\" : \"Load Test Data\"}\n \n \n \n\n {/* Manager overview */}\n

\n Registered Managers ({managers.length}/12)\n

\n \n\n {/* Seed + Execute */}\n

Execute Draft

\n {result && (\n

\n Draft already executed with seed \"{result.seed}\". Re-executing will\n create a new result and the latest will be shown to managers.\n

\n )}\n

\n setSeed(e.target.value)}\n placeholder=\"Enter random seed (any text)\"\n />\n \n {executing\n ? \"Executing...\"\n : result\n ? \"Re-Execute Draft\"\n : \"Execute Draft\"}\n \n \n Refresh\n \n

\n\n {error &&

{error}

}\n\n {/* Preview reveal link — opens the same step-through UI managers see */}\n {result && (\n

\n \n Preview Step-Through Reveal\n \n \n Opens the same dramatic reveal page that managers will see\n

\n \n )}\n\n {/* Results */}\n {result && }\n \n );\n}\n\n// ---- Mount ----\n\ncreateRoot(document.getElementById(\"root\")!).render();","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\n// ---- Types ----\n\ninterface Manager {\n id: number;\n email: string;\n teamName: string;\n pickCount: number;\n}\n\ninterface ConflictResolution {\n playerAdp: number;\n playerName: string;\n contestants: Array<{ managerId: number; teamName: string }>;\n winnerId: number;\n winnerTeamName: string;\n}\n\ninterface RoundResult {\n roundNumber: number;\n nominations: Array<{\n managerId: number;\n teamName: string;\n nominatedAdp: number;\n playerName: string;\n }>;\n uncontested: Array<{\n managerId: number;\n teamName: string;\n playerAdp: number;\n playerName: string;\n }>;\n conflicts: ConflictResolution[];\n winners: Array<{\n managerId: number;\n teamName: string;\n playerAdp: number;\n playerName: string;\n }>;\n}\n\ninterface DraftSlot {\n slot: number;\n managerId: number;\n teamName: string;\n email: string;\n playerAdp: number;\n playerName: string;\n playerTeam: string;\n playerPosition: string;\n}\n\ninterface DraftResult {\n seed: string;\n managerCount: number;\n rounds: RoundResult[];\n finalSlots: DraftSlot[];\n}\n\n// ---- Derive admin API base from current page URL ----\n// The admin page is at /draft-admin/r8k2p5m9x1 and the API\n// is at /draft-admin/r8k2p5m9x1/api/*. Derive automatically\n// so the obscured path only exists in one place (the server).\nconst ADMIN_API = window.location.pathname.replace(/\\/$/, \"\") + \"/api\";\n\n// ---- API helpers ----\n\nasync function apiGet(path: string) {\n const res = await fetch(path);\n if (!res.ok) throw new Error(await res.text());\n return res.json();\n}\n\nasync function apiPost(path: string, body: unknown) {\n const res = await fetch(path, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n if (!res.ok) throw new Error(await res.text());\n return res.json();\n}\n\n// ---- Manager List ----\n\nfunction ManagerList(\n { managers, onRefresh }: { managers: Manager[]; onRefresh: () => void },\n) {\n const [busy, setBusy] = useState(null);\n\n if (managers.length === 0) {\n return (\n

No managers have signed up yet.

\n );\n }\n\n const clearPicks = async (managerId: number, teamName: string) => {\n if (!confirm(`Clear all picks for ${teamName}?`)) return;\n setBusy(managerId);\n try {\n await apiPost(`${ADMIN_API}/clear-picks/${managerId}`, {});\n await onRefresh();\n } catch (err: any) {\n alert(`Error: ${err.message}`);\n } finally {\n setBusy(null);\n }\n };\n\n const removeManager = async (managerId: number, teamName: string) => {\n if (\n !confirm(\n `Remove ${teamName} entirely? This deletes the manager and all their picks.`,\n )\n ) return;\n setBusy(managerId);\n try {\n await apiPost(`${ADMIN_API}/delete-manager/${managerId}`, {});\n await onRefresh();\n } catch (err: any) {\n alert(`Error: ${err.message}`);\n } finally {\n setBusy(null);\n }\n };\n\n const clearAll = async () => {\n if (\n !confirm(\n `Clear ALL picks for every manager? (Managers stay registered, just their picks are wiped.)`,\n )\n ) return;\n setBusy(\"all\");\n try {\n await apiPost(`${ADMIN_API}/clear-all-picks`, {});\n await onRefresh();\n } catch (err: any) {\n alert(`Error: ${err.message}`);\n } finally {\n setBusy(null);\n }\n };\n\n return (\n

\n \n \n \n \n \n \n \n \n \n \n \n {managers.map((m, i) => (\n \n \n \n \n \n \n \n ))}\n \n

#	Team Name	Email	Picks Submitted	Actions
{i + 1}	{m.teamName}	{m.email}	\n {m.pickCount > 0\n ? (\n \n {m.pickCount} players ranked\n \n )\n : (\n \n No picks yet\n \n )}\n	\n \n {m.pickCount > 0 && (\n clearPicks(m.id, m.teamName)}\n disabled={busy !== null}\n >\n Clear Picks\n \n )}\n removeManager(m.id, m.teamName)}\n disabled={busy !== null}\n >\n Remove\n \n \n

\n \n {busy === \"all\" ? \"Clearing...\" : \"Clear All Picks\"}\n \n

\n );\n}\n\n// ---- Draft Results Display ----\n\nfunction DraftResults({ result }: { result: DraftResult }) {\n return (\n

\n\n {/* Final Draft Order */}\n

\n Final First-Round Draft Order\n

\n {result.finalSlots.map((slot) => (\n

{slot.slot}

{slot.teamName}

\n Selected: {slot.playerName} (ADP {slot.playerAdp}) ·{\" \"}\n {slot.playerTeam} · {slot.playerPosition}\n

\n ))}\n

\n\n {/* Round-by-round breakdown */}\n

Round-by-Round Breakdown

\n\n {result.rounds.map((round) => (\n

\n Round {round.roundNumber}\n \n {round.nominations.length}{\" \"}\n manager{round.nominations.length !== 1 ? \"s\" : \"\"}{\" \"}\n nominating — {round.winners.length} picked\n \n

\n {/* Nominations */}\n

Nominations

\n {nom.teamName} nominates{\" \"}\n {nom.playerName} (ADP {nom.nominatedAdp})\n

\n\n {/* Uncontested picks */}\n {round.uncontested.length > 0 && (\n

Uncontested

\n {pick.teamName} gets{\" \"}\n {pick.playerName} (ADP {pick.playerAdp})\n Awarded\n

\n )}\n\n {/* Conflicts */}\n {round.conflicts.length > 0 && (\n

Lottery Drawings

\n {round.conflicts.map((conflict) => (\n

\n {conflict.playerName} (ADP{\" \"}\n {conflict.playerAdp})\n \n {conflict.contestants.length}-way contest\n \n

\n {c.teamName}\n {c.managerId === conflict.winnerId && (\n Winner\n )}\n \n ))}\n

\n ))}\n

\n )}\n

\n ))}\n

\n );\n}\n\n// ---- Admin App ----\n\nfunction AdminApp() {\n const [managers, setManagers] = useState([]);\n const [seed, setSeed] = useState(\"\");\n const [executing, setExecuting] = useState(false);\n const [simulating, setSimulating] = useState(false);\n const [error, setError] = useState(\"\");\n const [result, setResult] = useState(null);\n const [loading, setLoading] = useState(true);\n\n const refresh = async () => {\n try {\n const [mgrs, existing] = await Promise.all([\n apiGet(`${ADMIN_API}/managers`),\n apiGet(`${ADMIN_API}/results`),\n ]);\n setManagers(mgrs);\n if (existing) {\n setResult(existing.result as DraftResult);\n setSeed((existing.result as DraftResult).seed);\n }\n } catch (err: any) {\n setError(err.message);\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n refresh();\n }, []);\n\n const runSimulation = async () => {\n if (\n !confirm(\n \"This will DELETE all existing managers, picks, and results, then populate 12 fake managers with test picks.\\n\\nContinue?\",\n )\n ) {\n return;\n }\n setSimulating(true);\n setError(\"\");\n setResult(null);\n try {\n await apiPost(`${ADMIN_API}/simulate`, {});\n await refresh();\n } catch (err: any) {\n setError(err.message);\n } finally {\n setSimulating(false);\n }\n };\n\n const executeDraft = async () => {\n if (!seed.trim()) {\n setError(\"Enter a random seed first\");\n return;\n }\n if (\n !confirm(\n `Execute the draft with seed \"${seed.trim()}\"?\\n\\nThis will determine the first-round order and lock all picks.`,\n )\n ) {\n return;\n }\n setExecuting(true);\n setError(\"\");\n try {\n const data = await apiPost(`${ADMIN_API}/execute`, { seed: seed.trim() });\n setResult(data);\n } catch (err: any) {\n setError(err.message);\n } finally {\n setExecuting(false);\n }\n };\n\n if (loading) return

Loading admin panel...

;\n\n return (\n

\n NPB Draft Admin\n

Commissioner's draft execution panel

\n\n {/* Simulation */}\n \n \n

\n Simulation Mode\n \n Populate 12 fake managers with weighted picks to test the draft\n algorithm. Creates realistic conflicts on top players.\n

\n \n {simulating ? \"Populating...\" : \"Load Test Data\"}\n \n \n \n\n {/* Manager overview */}\n

\n Registered Managers ({managers.length}/12)\n

\n \n\n {/* Seed + Execute */}\n

Execute Draft

\n {result && (\n

\n Draft already executed with seed \"{result.seed}\". Re-executing will\n create a new result and the latest will be shown to managers.\n

\n )}\n

\n setSeed(e.target.value)}\n placeholder=\"Enter random seed (any text)\"\n />\n \n {executing\n ? \"Executing...\"\n : result\n ? \"Re-Execute Draft\"\n : \"Execute Draft\"}\n \n \n Refresh\n \n

\n\n {error &&

{error}

}\n\n {/* Preview reveal link — opens the same step-through UI managers see */}\n {result && (\n

\n \n Preview Step-Through Reveal\n \n \n Opens the same dramatic reveal page that managers will see\n

\n \n )}\n\n {/* Results */}\n {result && }\n \n );\n}\n\n// ---- Mount ----\n\ncreateRoot(document.getElementById(\"root\")!).render();","createdAt",["D",1773151276849],"branchVersion","branchId","4c93c020-1bc7-11f1-aaf0-42dde27851f2","id","4c935dd8-1bc7-11f1-aaf0-42dde27851f2","npb-draft",["D",1773067822232],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","019ca01c-a52c-7496-b132-461e941e09a1","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019ca01c-a52c-7496-b132-485cb9878fcf","tursoName","4c935dd81bc711f1aaf042dde27851f2","tursoHostname","4c935dd81bc711f1aaf042dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789518676100],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":55,"_102":103,"_104":25},"branch",{"_13":87,"_32":88,"_44":43,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":46,"_96":97},"isOwned",71,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","clintr","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNBR0owU1VPWkdOd0ZST1RYWGpUR3gyUUZuRSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":283,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":284,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":285,"_82":286,"_84":287,"_86":25},"tree",[177,181,189,190],"files",[177,178,179,180,181,182,183,184,185,186,187,188,189,190],"counts",{"_166":61,"_167":168,"_169":61,"_170":171,"_172":173},"contents",[129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_44":160,"_32":161,"_30":162,"_136":-5,"_42":43,"_41":163,"_138":124,"_39":164,"_13":140,"_34":158,"_36":-5,"_24":25,"_142":-5,"_27":165},{"_44":153,"_32":154,"_30":155,"_136":-5,"_42":43,"_41":156,"_138":124,"_39":157,"_13":140,"_34":158,"_36":-5,"_24":25,"_142":-5,"_27":159},{"_44":144,"_32":145,"_30":146,"_136":-5,"_42":43,"_41":147,"_138":124,"_39":148,"_13":149,"_34":150,"_36":151,"_24":25,"_142":-5,"_27":152},{"_44":133,"_32":134,"_30":135,"_136":-5,"_42":43,"_41":137,"_138":124,"_39":139,"_13":140,"_34":35,"_36":141,"_24":25,"_142":-5,"_27":143},"1950b992-1bc8-11f1-bbf8-42dde27851f2","players.ts","1403ce2a-1bc8-11f1-8e01-42dde27851f2","parentId",46,"latest",["D",1773068165714],2,"// NPB Draft 2026 — Top 30 by Yahoo ADP (locked for draft week)\n// Last updated: 2026-03-09\n\nexport interface Player {\n adp: number;\n name: string;\n team: string;\n position: string;\n}\n\nexport const PLAYERS: Player[] = [\n { adp: 1, name: \"Aaron Judge\", team: \"NYY\", position: \"OF\" },\n { adp: 2, name: \"Shohei Ohtani (Batter)\", team: \"LAD\", position: \"Util\" },\n { adp: 3, name: \"Bobby Witt Jr.\", team: \"KC\", position: \"SS\" },\n { adp: 4, name: \"Juan Soto\", team: \"NYM\", position: \"OF\" },\n { adp: 5, name: \"Tarik Skubal\", team: \"DET\", position: \"SP\" },\n { adp: 6, name: \"Jose Ramirez\", team: \"CLE\", position: \"3B\" },\n { adp: 7, name: \"Elly De La Cruz\", team: \"CIN\", position: \"SS\" },\n { adp: 8, name: \"Paul Skenes\", team: \"PIT\", position: \"SP\" },\n { adp: 9, name: \"Ronald Acuna Jr.\", team: \"ATL\", position: \"OF\" },\n { adp: 10, name: \"Julio Rodriguez\", team: \"SEA\", position: \"OF\" },\n { adp: 11, name: \"Kyle Tucker\", team: \"LAD\", position: \"OF\" },\n { adp: 12, name: \"Garrett Crochet\", team: \"BOS\", position: \"SP\" },\n { adp: 13, name: \"Cal Raleigh\", team: \"SEA\", position: \"C\" },\n { adp: 14, name: \"Gunnar Henderson\", team: \"BAL\", position: \"SS\" },\n { adp: 15, name: \"Junior Caminero\", team: \"TB\", position: \"3B\" },\n { adp: 16, name: \"Kyle Schwarber\", team: \"PHI\", position: \"OF\" },\n { adp: 17, name: \"Vladimir Guerrero Jr.\", team: \"TOR\", position: \"1B\" },\n { adp: 18, name: \"Corbin Carroll\", team: \"AZ\", position: \"OF\" },\n { adp: 19, name: \"Fernando Tatis Jr.\", team: \"SD\", position: \"OF\" },\n { adp: 20, name: \"Nick Kurtz\", team: \"ATH\", position: \"1B\" },\n { adp: 21, name: \"Pete Alonso\", team: \"BAL\", position: \"1B\" },\n { adp: 22, name: \"Jackson Chourio\", team: \"MIL\", position: \"OF\" },\n { adp: 23, name: \"Yoshinobu Yamamoto\", team: \"LAD\", position: \"SP\" },\n { adp: 24, name: \"Jazz Chisholm Jr.\", team: \"NYY\", position: \"2B/3B\" },\n { adp: 25, name: \"Francisco Lindor\", team: \"NYM\", position: \"SS\" },\n { adp: 26, name: \"Cristopher Sanchez\", team: \"PHI\", position: \"SP\" },\n { adp: 27, name: \"Ketel Marte\", team: \"AZ\", position: \"2B\" },\n { adp: 28, name: \"Trea Turner\", team: \"PHI\", position: \"SS\" },\n { adp: 29, name: \"Manny Machado\", team: \"SD\", position: \"3B\" },\n { adp: 30, name: \"Zach Neto\", team: \"LAA\", position: \"SS\" },\n];","label",[134],"91a23422-1c89-11f1-9716-42dde27851f2","index.http.ts","4c966c80-1bc7-11f1-aaf0-42dde27851f2",69,["D",1773151260451],8,"http","// NPB Draft App — Val Town entry point\n// 2026-03-09\n//\n// Hono server serving:\n// / — Pick submission UI\n// /results — Public draft results (after execution)\n// /draft-admin/r8k2p5m9x1 — Admin panel (obscured URL)\n// /draft-admin/r8k2p5m9x1/api/* — Admin API (under obscured prefix)\n// /api/* — Public API endpoints\n// /frontend/* — Static assets\n//\n// Fixes from adversarial review:\n// - Admin API moved under obscured path (was at predictable /api/admin/*)\n// - Picks locked after draft execution (was modifiable forever)\n// - Registration blocked after draft execution\n// - Public results endpoint added (managers had no way to see results)\n// - Player data injected server-side into HTML (eliminates frontend duplication)\n\nimport { Hono } from \"npm:hono\";\nimport { deleteCookie, getCookie, setCookie } from \"npm:hono/cookie\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport {\n clearAllPicks,\n clearPicksForManager,\n deleteManager,\n findOrCreateManager,\n getAllManagers,\n getAllManagersWithPicks,\n getLatestDraftResult,\n getManagerByToken,\n getPicks,\n initDb,\n isDraftExecuted,\n saveDraftResult,\n savePicks,\n} from \"./backend/db.ts\";\nimport { executeDraft } from \"./backend/draft.ts\";\nimport { populateSimulation } from \"./backend/simulate.ts\";\nimport { PLAYERS } from \"./players.ts\";\n\nconst app = new Hono();\nconst COOKIE_NAME = \"npb_session\";\nconst ADMIN_PATH = \"/draft-admin/r8k2p5m9x1\";\n\n// ---- Init DB on first request ----\n\nlet dbReady = false;\napp.use(\"*\", async (c, next) => {\n if (!dbReady) {\n await initDb();\n dbReady = true;\n }\n await next();\n});\n\n// ---- Auth middleware helper ----\n\nasync function getAuthManager(c: any) {\n const token = getCookie(c, COOKIE_NAME);\n if (!token) return null;\n return getManagerByToken(token);\n}\n\n// ---- Page routes ----\n\n// Inject player data and draft status into HTML server-side to eliminate\n// frontend data duplication and avoid an extra API round-trip on page load.\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n const drafted = await isDraftExecuted();\n const injection = ``;\n html = html.replace(\"\", `${injection}`);\n return c.html(html);\n});\n\napp.get(\"/results\", async (c) => {\n let html = await readFile(\"/frontend/results.html\", import.meta.url);\n return c.html(html);\n});\n\napp.get(ADMIN_PATH, async (c) => {\n const html = await readFile(\"/frontend/admin.html\", import.meta.url);\n return c.html(html);\n});\n\n// ---- Static file serving ----\n// Val Town Projects transpile TSX files via serveFile automatically.\n\napp.get(\"/frontend/*\", (c) => {\n return serveFile(c.req.path, import.meta.url);\n});\n\n// ---- Auth API ----\n\napp.post(\"/api/auth\", async (c) => {\n const body = await c.req.json();\n const { email, teamName } = body;\n\n if (!email || typeof email !== \"string\" || !email.includes(\"@\")) {\n return c.text(\"Valid email required\", 400);\n }\n if (\n !teamName || typeof teamName !== \"string\" || teamName.trim().length === 0\n ) {\n return c.text(\"Team name required\", 400);\n }\n\n // Block new registrations after draft has been executed\n const drafted = await isDraftExecuted();\n if (drafted) {\n // Allow re-login for existing managers (so they can view their picks)\n const normalizedEmail = email.toLowerCase().trim();\n const { id, sessionToken } = await findOrCreateManager(\n normalizedEmail,\n teamName,\n );\n setCookie(c, COOKIE_NAME, sessionToken, {\n path: \"/\",\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\",\n maxAge: 60 * 60 * 24 * 30,\n });\n return c.json({\n email: normalizedEmail,\n teamName: teamName.trim(),\n draftExecuted: true,\n });\n }\n\n const { id, sessionToken } = await findOrCreateManager(email, teamName);\n setCookie(c, COOKIE_NAME, sessionToken, {\n path: \"/\",\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\",\n maxAge: 60 * 60 * 24 * 30, // 30 days\n });\n\n return c.json({\n email: email.toLowerCase().trim(),\n teamName: teamName.trim(),\n draftExecuted: false,\n });\n});\n\napp.get(\"/api/me\", async (c) => {\n const manager = await getAuthManager(c);\n if (!manager) return c.json(null, 401);\n const drafted = await isDraftExecuted();\n return c.json({\n email: manager.email,\n teamName: manager.teamName,\n draftExecuted: drafted,\n });\n});\n\napp.post(\"/api/logout\", async (c) => {\n deleteCookie(c, COOKIE_NAME, { path: \"/\" });\n return c.json({ ok: true });\n});\n\n// ---- Picks API ----\n\napp.get(\"/api/picks\", async (c) => {\n const manager = await getAuthManager(c);\n if (!manager) return c.json(null, 401);\n const picks = await getPicks(manager.id);\n return c.json({ picks });\n});\n\napp.post(\"/api/picks\", async (c) => {\n const manager = await getAuthManager(c);\n if (!manager) return c.text(\"Not authenticated\", 401);\n\n // Block pick changes after draft execution\n const drafted = await isDraftExecuted();\n if (drafted) {\n return c.text(\"Draft has already been executed — picks are locked\", 403);\n }\n\n const body = await c.req.json();\n const { picks } = body;\n\n if (!Array.isArray(picks)) return c.text(\"picks must be an array\", 400);\n if (picks.length > 30) return c.text(\"Cannot rank more than 30 players\", 400);\n\n // Validate all ADPs are valid and unique\n const seen = new Set();\n for (const adp of picks) {\n if (typeof adp !== \"number\" || adp < 1 || adp > 30) {\n return c.text(`Invalid player ADP: ${adp}`, 400);\n }\n if (seen.has(adp)) return c.text(`Duplicate player ADP: ${adp}`, 400);\n seen.add(adp);\n }\n\n await savePicks(manager.id, picks);\n return c.json({ ok: true, count: picks.length });\n});\n\n// ---- Public results API ----\n// Anyone can see results after the draft is executed — no auth required.\n\napp.get(\"/api/results\", async (c) => {\n const result = await getLatestDraftResult();\n if (!result) return c.json(null);\n return c.json(result);\n});\n\n// ---- Admin API (under obscured path) ----\n// These endpoints are only accessible if you know the admin URL.\n// No additional auth — security by URL obscurity (appropriate for a 12-person draft).\n\napp.get(`${ADMIN_PATH}/api/managers`, async (c) => {\n const managers = await getAllManagers();\n return c.json(managers);\n});\n\napp.get(`${ADMIN_PATH}/api/results`, async (c) => {\n const result = await getLatestDraftResult();\n return c.json(result);\n});\n\napp.post(`${ADMIN_PATH}/api/execute`, async (c) => {\n const body = await c.req.json();\n const { seed } = body;\n\n if (!seed || typeof seed !== \"string\" || seed.trim().length === 0) {\n return c.text(\"Random seed is required\", 400);\n }\n\n const managersWithPicks = await getAllManagersWithPicks();\n\n if (managersWithPicks.length === 0) {\n return c.text(\"No managers have registered yet\", 400);\n }\n\n // Execute the draft algorithm\n const result = executeDraft(\n managersWithPicks.map((m) => ({\n managerId: m.id,\n email: m.email,\n teamName: m.teamName,\n rankings: m.rankings,\n })),\n seed.trim(),\n );\n\n // Persist result\n await saveDraftResult(seed.trim(), JSON.stringify(result));\n\n return c.json(result);\n});\n\n// ---- Admin: clear picks / remove managers ----\n\napp.post(`${ADMIN_PATH}/api/clear-picks/:managerId`, async (c) => {\n const managerId = parseInt(c.req.param(\"managerId\"), 10);\n if (isNaN(managerId)) return c.text(\"Invalid manager ID\", 400);\n const deleted = await clearPicksForManager(managerId);\n return c.json({ ok: true, deletedPicks: deleted });\n});\n\napp.post(`${ADMIN_PATH}/api/clear-all-picks`, async (c) => {\n const deleted = await clearAllPicks();\n return c.json({ ok: true, deletedPicks: deleted });\n});\n\napp.post(`${ADMIN_PATH}/api/delete-manager/:managerId`, async (c) => {\n const managerId = parseInt(c.req.param(\"managerId\"), 10);\n if (isNaN(managerId)) return c.text(\"Invalid manager ID\", 400);\n await deleteManager(managerId);\n return c.json({ ok: true });\n});\n\n// ---- Simulation (admin only) ----\n// Populates 12 fake managers with weighted picks for testing.\n// Clears all existing data first.\n\napp.post(`${ADMIN_PATH}/api/simulate`, async (c) => {\n const result = await populateSimulation();\n return c.json(result);\n});\n\n// ---- Error handler (stack traces in dev) ----\n\napp.onError((err) => {\n throw err;\n});\n\n// ---- Export ----\n\nexport default app.fetch;",[145],"8080f36c-1bc7-11f1-893d-42dde27851f2","frontend","7859693a-1bc7-11f1-9427-42dde27851f2",6,["D",1773067909348],"directory",[154],"853a17d0-1bc7-11f1-9427-42dde27851f2","backend","7427c5a0-1bc7-11f1-8bec-42dde27851f2",7,["D",1773067917271],[161],"pulls","branches",1,"forks","envVars",{"_174":61,"_176":61},"connections",{"_174":61,"_175":61},"count","unfilledCount","emptyCount",{"_44":160,"_32":161,"_30":162,"_136":-5,"_42":43,"_41":163,"_138":124,"_39":280,"_13":140,"_34":158,"_36":-5,"_24":25,"_142":-5,"_192":281,"_27":282},{"_44":272,"_32":273,"_30":274,"_136":162,"_42":43,"_41":275,"_138":25,"_39":276,"_13":237,"_34":35,"_36":277,"_24":25,"_142":-5,"_192":278,"_27":279},{"_44":264,"_32":265,"_30":266,"_136":162,"_42":43,"_41":267,"_138":124,"_39":268,"_13":220,"_34":35,"_36":269,"_24":25,"_142":-5,"_192":270,"_27":271},{"_44":256,"_32":257,"_30":258,"_136":162,"_42":43,"_41":259,"_138":124,"_39":260,"_13":237,"_34":35,"_36":261,"_24":25,"_142":-5,"_192":262,"_27":263},{"_44":153,"_32":154,"_30":155,"_136":-5,"_42":43,"_41":156,"_138":124,"_39":253,"_13":140,"_34":158,"_36":-5,"_24":25,"_142":-5,"_192":254,"_27":255},{"_44":245,"_32":246,"_30":247,"_136":155,"_42":43,"_41":248,"_138":124,"_39":249,"_13":220,"_34":20,"_36":250,"_24":25,"_142":-5,"_192":251,"_27":252},{"_44":241,"_32":33,"_30":31,"_136":155,"_42":43,"_41":14,"_138":124,"_39":242,"_13":211,"_34":35,"_36":38,"_24":25,"_142":-5,"_192":243,"_27":244},{"_44":232,"_32":233,"_30":234,"_136":155,"_42":43,"_41":235,"_138":124,"_39":236,"_13":237,"_34":35,"_36":238,"_24":25,"_142":-5,"_192":239,"_27":240},{"_44":224,"_32":225,"_30":226,"_136":155,"_42":43,"_41":227,"_138":124,"_39":228,"_13":220,"_34":20,"_36":229,"_24":25,"_142":-5,"_192":230,"_27":231},{"_44":215,"_32":216,"_30":217,"_136":155,"_42":43,"_41":218,"_138":124,"_39":219,"_13":220,"_34":20,"_36":221,"_24":25,"_142":-5,"_192":222,"_27":223},{"_44":206,"_32":207,"_30":208,"_136":155,"_42":43,"_41":209,"_138":124,"_39":210,"_13":211,"_34":35,"_36":212,"_24":25,"_142":-5,"_192":213,"_27":214},{"_44":198,"_32":199,"_30":200,"_136":155,"_42":43,"_41":201,"_138":124,"_39":202,"_13":149,"_34":20,"_36":203,"_24":25,"_142":-5,"_192":204,"_27":205},{"_44":144,"_32":145,"_30":146,"_136":-5,"_42":43,"_41":147,"_138":124,"_39":195,"_13":149,"_34":150,"_36":151,"_24":25,"_142":-5,"_192":196,"_27":197},{"_44":133,"_32":134,"_30":135,"_136":-5,"_42":43,"_41":137,"_138":124,"_39":191,"_13":140,"_34":35,"_36":141,"_24":25,"_142":-5,"_192":193,"_27":194},["D",1773068165714],"children",[],[134],["D",1773151260451],[],[145],"051a10d2-1be0-11f1-a3d2-42dde27851f2","styles.css","cc03b950-1bc7-11f1-be07-42dde27851f2",68,["D",1773078439731],"/* NPB Draft App — 2026-03-09 */\n\n:root {\n --bg: #0f1923;\n --surface: #1a2634;\n --surface-hover: #223344;\n --border: #2a3f55;\n --text: #e8edf2;\n --text-muted: #8899aa;\n --accent: #4da6ff;\n --accent-hover: #66b3ff;\n --success: #4caf50;\n --warning: #ff9800;\n --danger: #f44336;\n --radius: 8px;\n --shadow: 0 2px 8px rgba(0, 0, 0, 0.3);\n}\n\n* {\n box-sizing: border-box;\n margin: 0;\n padding: 0;\n}\n\nbody {\n font-family:\n -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, sans-serif;\n background: var(--bg);\n color: var(--text);\n min-height: 100vh;\n}\n\n/* --- Layout --- */\n\n.container {\n max-width: 1100px;\n margin: 0 auto;\n padding: 20px;\n}\n\nheader {\n text-align: center;\n padding: 24px 0 16px;\n border-bottom: 1px solid var(--border);\n margin-bottom: 24px;\n}\n\nheader h1 {\n font-size: 1.8rem;\n font-weight: 700;\n letter-spacing: -0.02em;\n}\n\nheader h1 span {\n color: var(--accent);\n}\n\nheader p {\n color: var(--text-muted);\n margin-top: 6px;\n font-size: 0.9rem;\n}\n\n/* --- Login Form --- */\n\n.login-card {\n max-width: 420px;\n margin: 60px auto;\n background: var(--surface);\n border: 1px solid var(--border);\n border-radius: var(--radius);\n padding: 32px;\n box-shadow: var(--shadow);\n}\n\n.login-card h2 {\n margin-bottom: 20px;\n font-size: 1.3rem;\n}\n\n.form-group {\n margin-bottom: 16px;\n}\n\n.form-group label {\n display: block;\n font-size: 0.85rem;\n color: var(--text-muted);\n margin-bottom: 6px;\n font-weight: 500;\n}\n\n.form-group input {\n width: 100%;\n padding: 10px 12px;\n background: var(--bg);\n border: 1px solid var(--border);\n border-radius: var(--radius);\n color: var(--text);\n font-size: 0.95rem;\n outline: none;\n transition: border-color 0.2s;\n}\n\n.form-group input:focus {\n border-color: var(--accent);\n}\n\n/* --- Buttons --- */\n\n.btn {\n display: inline-flex;\n align-items: center;\n justify-content: center;\n padding: 10px 20px;\n border: none;\n border-radius: var(--radius);\n font-size: 0.9rem;\n font-weight: 600;\n cursor: pointer;\n transition: background 0.2s, opacity 0.2s;\n}\n\n.btn:disabled {\n opacity: 0.5;\n cursor: not-allowed;\n}\n\n.btn-primary {\n background: var(--accent);\n color: #000;\n width: 100%;\n}\n\n.btn-primary:hover:not(:disabled) {\n background: var(--accent-hover);\n}\n\n.btn-success {\n background: var(--success);\n color: #fff;\n}\n\n.btn-success:hover:not(:disabled) {\n background: #5cb85c;\n}\n\n.btn-danger {\n background: var(--danger);\n color: #fff;\n}\n\n.btn-small {\n padding: 4px 10px;\n font-size: 0.78rem;\n}\n\n/* --- Two-Column Pick Layout --- */\n\n.pick-layout {\n display: grid;\n grid-template-columns: 1fr 1fr;\n gap: 20px;\n margin-top: 16px;\n}\n\n@media (max-width: 700px) {\n .pick-layout {\n grid-template-columns: 1fr;\n }\n}\n\n.column {\n background: var(--surface);\n border: 1px solid var(--border);\n border-radius: var(--radius);\n overflow: hidden;\n}\n\n.column-header {\n padding: 14px 16px;\n background: var(--surface-hover);\n border-bottom: 1px solid var(--border);\n font-weight: 600;\n font-size: 0.9rem;\n display: flex;\n justify-content: space-between;\n align-items: center;\n}\n\n.column-header .count {\n color: var(--text-muted);\n font-weight: 400;\n font-size: 0.82rem;\n}\n\n.column-body {\n padding: 8px;\n max-height: 70vh;\n overflow-y: auto;\n}\n\n/* --- Player Cards --- */\n\n.player-card {\n display: flex;\n align-items: center;\n gap: 10px;\n padding: 10px 12px;\n margin: 4px 0;\n background: var(--bg);\n border: 1px solid var(--border);\n border-radius: 6px;\n transition: background 0.15s, border-color 0.15s;\n user-select: none;\n}\n\n.player-card:hover {\n background: var(--surface-hover);\n}\n\n.player-adp {\n min-width: 48px;\n padding: 4px 6px;\n display: flex;\n align-items: center;\n justify-content: center;\n background: var(--surface-hover);\n border-radius: 4px;\n font-size: 0.7rem;\n font-weight: 700;\n color: var(--text-muted);\n flex-shrink: 0;\n white-space: nowrap;\n}\n\n.player-info {\n flex: 1;\n min-width: 0;\n}\n\n.player-name {\n font-weight: 600;\n font-size: 0.88rem;\n white-space: nowrap;\n overflow: hidden;\n text-overflow: ellipsis;\n}\n\n.player-meta {\n font-size: 0.75rem;\n color: var(--text-muted);\n margin-top: 1px;\n}\n\n/* Rank number in the right column */\n.player-rank {\n min-width: 26px;\n height: 26px;\n display: flex;\n align-items: center;\n justify-content: center;\n background: var(--accent);\n color: #000;\n border-radius: 50%;\n font-size: 0.75rem;\n font-weight: 700;\n flex-shrink: 0;\n}\n\n/* --- Add button (left column) --- */\n.add-btn {\n width: 36px;\n height: 36px;\n display: flex;\n align-items: center;\n justify-content: center;\n background: var(--accent);\n color: #000;\n border: none;\n border-radius: 50%;\n font-size: 1.3rem;\n font-weight: 700;\n cursor: pointer;\n flex-shrink: 0;\n transition: background 0.15s, transform 0.1s;\n line-height: 1;\n}\n\n.add-btn:hover {\n background: var(--accent-hover);\n transform: scale(1.1);\n}\n\n.add-btn:active {\n transform: scale(0.95);\n}\n\n/* --- Card controls (right column: arrows + remove) --- */\n.card-controls {\n display: flex;\n align-items: center;\n gap: 4px;\n flex-shrink: 0;\n}\n\n.arrow-btn {\n width: 56px;\n height: 32px;\n display: flex;\n align-items: center;\n justify-content: center;\n background: var(--surface-hover);\n border: 1px solid var(--border);\n border-radius: 6px;\n color: var(--text);\n cursor: pointer;\n font-size: 0.75rem;\n transition: background 0.15s, border-color 0.15s;\n}\n\n.arrow-btn:hover:not(:disabled) {\n background: rgba(77, 166, 255, 0.15);\n border-color: var(--accent);\n color: var(--accent);\n}\n\n.arrow-btn:active:not(:disabled) {\n background: rgba(77, 166, 255, 0.25);\n}\n\n.arrow-btn:disabled {\n opacity: 0.2;\n cursor: default;\n}\n\n.remove-btn {\n width: 32px;\n height: 32px;\n display: flex;\n align-items: center;\n justify-content: center;\n background: none;\n border: 1px solid var(--border);\n color: var(--text-muted);\n cursor: pointer;\n font-size: 1.1rem;\n border-radius: 6px;\n transition: color 0.15s, background 0.15s, border-color 0.15s;\n flex-shrink: 0;\n}\n\n.remove-btn:hover {\n color: var(--danger);\n background: rgba(244, 67, 54, 0.1);\n border-color: var(--danger);\n}\n\n/* --- Save Bar --- */\n\n.save-bar {\n display: flex;\n align-items: center;\n justify-content: space-between;\n gap: 16px;\n margin-top: 20px;\n padding: 16px;\n background: var(--surface);\n border: 1px solid var(--border);\n border-radius: var(--radius);\n}\n\n.save-bar .status {\n font-size: 0.85rem;\n color: var(--text-muted);\n}\n\n.save-bar .status.saved {\n color: var(--success);\n}\n\n.save-bar .status.error {\n color: var(--danger);\n}\n\n/* --- User Info Bar --- */\n\n.user-bar {\n display: flex;\n align-items: center;\n justify-content: space-between;\n padding: 12px 16px;\n background: var(--surface);\n border: 1px solid var(--border);\n border-radius: var(--radius);\n margin-bottom: 16px;\n}\n\n.user-bar .user-info {\n font-size: 0.85rem;\n}\n\n.user-bar .team-name {\n font-weight: 600;\n}\n\n.user-bar .email {\n color: var(--text-muted);\n margin-left: 8px;\n}\n\n.logout-btn {\n background: none;\n border: 1px solid var(--border);\n color: var(--text-muted);\n cursor: pointer;\n padding: 6px 12px;\n border-radius: var(--radius);\n font-size: 0.8rem;\n transition: border-color 0.15s, color 0.15s;\n}\n\n.logout-btn:hover {\n border-color: var(--text-muted);\n color: var(--text);\n}\n\n/* --- Admin Styles --- */\n\n.admin-table {\n width: 100%;\n border-collapse: collapse;\n margin: 16px 0;\n}\n\n.admin-table th,\n.admin-table td {\n padding: 10px 14px;\n text-align: left;\n border-bottom: 1px solid var(--border);\n}\n\n.admin-table th {\n font-size: 0.8rem;\n color: var(--text-muted);\n text-transform: uppercase;\n letter-spacing: 0.04em;\n font-weight: 600;\n}\n\n.admin-table td {\n font-size: 0.9rem;\n}\n\n.seed-input-row {\n display: flex;\n gap: 12px;\n align-items: center;\n margin: 20px 0;\n}\n\n.seed-input-row input {\n flex: 1;\n max-width: 300px;\n padding: 10px 12px;\n background: var(--bg);\n border: 1px solid var(--border);\n border-radius: var(--radius);\n color: var(--text);\n font-size: 0.95rem;\n outline: none;\n}\n\n.seed-input-row input:focus {\n border-color: var(--accent);\n}\n\n/* --- Draft Results --- */\n\n.round-card {\n background: var(--surface);\n border: 1px solid var(--border);\n border-radius: var(--radius);\n margin: 16px 0;\n overflow: hidden;\n}\n\n.round-header {\n padding: 12px 16px;\n background: var(--surface-hover);\n border-bottom: 1px solid var(--border);\n font-weight: 600;\n font-size: 0.95rem;\n}\n\n.round-body {\n padding: 12px 16px;\n}\n\n.round-section {\n margin: 10px 0;\n}\n\n.round-section h4 {\n font-size: 0.8rem;\n text-transform: uppercase;\n letter-spacing: 0.04em;\n color: var(--text-muted);\n margin-bottom: 6px;\n}\n\n.nomination-list {\n list-style: none;\n padding: 0;\n}\n\n.nomination-list li {\n padding: 6px 0;\n font-size: 0.88rem;\n border-bottom: 1px solid rgba(42, 63, 85, 0.4);\n}\n\n.nomination-list li:last-child {\n border-bottom: none;\n}\n\n.conflict-badge {\n display: inline-block;\n padding: 2px 8px;\n background: rgba(255, 152, 0, 0.15);\n color: var(--warning);\n border-radius: 4px;\n font-size: 0.78rem;\n font-weight: 600;\n margin-left: 6px;\n}\n\n.winner-badge {\n display: inline-block;\n padding: 2px 8px;\n background: rgba(76, 175, 80, 0.15);\n color: var(--success);\n border-radius: 4px;\n font-size: 0.78rem;\n font-weight: 600;\n margin-left: 6px;\n}\n\n.final-results {\n background: var(--surface);\n border: 2px solid var(--accent);\n border-radius: var(--radius);\n margin: 24px 0;\n overflow: hidden;\n}\n\n.final-results-header {\n padding: 16px;\n background: rgba(77, 166, 255, 0.1);\n border-bottom: 1px solid var(--accent);\n font-weight: 700;\n font-size: 1.1rem;\n text-align: center;\n}\n\n.slot-row {\n display: flex;\n align-items: center;\n gap: 12px;\n padding: 12px 16px;\n border-bottom: 1px solid var(--border);\n}\n\n.slot-row:last-child {\n border-bottom: none;\n}\n\n.slot-number {\n min-width: 36px;\n height: 36px;\n display: flex;\n align-items: center;\n justify-content: center;\n border-radius: 50%;\n font-weight: 700;\n font-size: 0.9rem;\n flex-shrink: 0;\n background: var(--surface-hover);\n color: var(--text);\n}\n\n.slot-details {\n flex: 1;\n}\n\n.slot-team {\n font-weight: 600;\n font-size: 0.95rem;\n}\n\n.slot-player {\n font-size: 0.82rem;\n color: var(--text-muted);\n margin-top: 2px;\n}\n\n/* --- Misc --- */\n\n.empty-state {\n text-align: center;\n padding: 40px 20px;\n color: var(--text-muted);\n}\n\n.empty-state p {\n font-size: 0.9rem;\n}\n\n.loading {\n text-align: center;\n padding: 40px;\n color: var(--text-muted);\n}\n\n.alert {\n padding: 12px 16px;\n border-radius: var(--radius);\n font-size: 0.88rem;\n margin: 12px 0;\n}\n\n.alert-error {\n background: rgba(244, 67, 54, 0.1);\n border: 1px solid var(--danger);\n color: var(--danger);\n}\n\n.alert-success {\n background: rgba(76, 175, 80, 0.1);\n border: 1px solid var(--success);\n color: var(--success);\n}\n\n.section-title {\n font-size: 1.1rem;\n font-weight: 600;\n margin: 24px 0 12px;\n padding-bottom: 8px;\n border-bottom: 1px solid var(--border);\n}\n\n.instructions {\n background: var(--surface);\n border: 1px solid var(--border);\n border-radius: var(--radius);\n padding: 16px;\n margin-bottom: 16px;\n font-size: 0.85rem;\n line-height: 1.5;\n color: var(--text-muted);\n}\n\n.instructions strong {\n color: var(--text);\n}\n\n/* ========================================\n Step-Through Reveal (results page)\n ======================================== */\n\n.reveal-timeline {\n display: flex;\n flex-direction: column;\n gap: 16px;\n}\n\n.reveal-step {\n animation: revealFadeIn 0.4s ease-out;\n}\n\n@keyframes revealFadeIn {\n from {\n opacity: 0;\n transform: translateY(12px);\n }\n to {\n opacity: 1;\n transform: translateY(0);\n }\n}\n\n/* Dim previous steps slightly so the current one pops */\n.reveal-step:not(.reveal-step-current) {\n opacity: 0.6;\n}\n\n.reveal-card {\n background: var(--surface);\n border: 1px solid var(--border);\n border-radius: var(--radius);\n padding: 20px;\n overflow: hidden;\n}\n\n.reveal-card-title {\n font-weight: 700;\n font-size: 0.95rem;\n margin-bottom: 14px;\n display: flex;\n align-items: center;\n gap: 10px;\n}\n\n/* Round intro — big centered title */\n.reveal-intro {\n text-align: center;\n padding: 32px 20px;\n border: 2px solid var(--accent);\n background: rgba(77, 166, 255, 0.05);\n}\n\n.reveal-round-number {\n font-size: 1.6rem;\n font-weight: 800;\n letter-spacing: -0.02em;\n color: var(--accent);\n}\n\n.reveal-subtitle {\n color: var(--text-muted);\n font-size: 0.9rem;\n margin-top: 6px;\n}\n\n/* Nomination rows */\n.reveal-nomination {\n padding: 10px 0;\n border-bottom: 1px solid rgba(42, 63, 85, 0.4);\n}\n\n.reveal-nomination:last-child {\n border-bottom: none;\n}\n\n.reveal-nom-team {\n font-weight: 700;\n font-size: 0.95rem;\n margin-bottom: 2px;\n}\n\n.reveal-nom-pick {\n font-size: 0.88rem;\n color: var(--text-muted);\n}\n\n.reveal-nom-pick strong {\n color: var(--text);\n}\n\n/* Skipped picks — the narrative \"originally wanted X, taken by Y\" */\n.reveal-skipped {\n margin-top: 4px;\n display: flex;\n flex-wrap: wrap;\n gap: 6px;\n}\n\n.reveal-skipped-tag {\n display: inline-block;\n padding: 2px 8px;\n background: rgba(244, 67, 54, 0.08);\n border: 1px solid rgba(244, 67, 54, 0.2);\n color: var(--text-muted);\n border-radius: 4px;\n font-size: 0.72rem;\n line-height: 1.4;\n}\n\n/* Uncontested awards */\n.reveal-awarded {\n padding: 10px 0;\n font-size: 0.9rem;\n border-bottom: 1px solid rgba(42, 63, 85, 0.4);\n}\n\n.reveal-awarded:last-child {\n border-bottom: none;\n}\n\n/* Conflict card */\n.reveal-conflict {\n border-color: var(--warning);\n background: rgba(255, 152, 0, 0.04);\n}\n\n.reveal-contestants {\n display: flex;\n flex-direction: column;\n gap: 6px;\n}\n\n.reveal-contestant {\n display: flex;\n align-items: center;\n padding: 10px 14px;\n background: var(--bg);\n border: 1px solid var(--border);\n border-radius: 6px;\n font-weight: 600;\n font-size: 0.9rem;\n transition: opacity 0.3s ease, background 0.3s ease, border-color 0.3s ease;\n}\n\n.reveal-contestant-name {\n flex: 1;\n}\n\n.reveal-winner {\n background: rgba(76, 175, 80, 0.12);\n border-color: var(--success);\n color: var(--success);\n animation: winnerReveal 0.6s ease-out;\n}\n\n@keyframes winnerReveal {\n 0% {\n transform: scale(1);\n }\n 40% {\n transform: scale(1.04);\n }\n 100% {\n transform: scale(1);\n }\n}\n\n/* Eliminated contestant — dimmed, struck through, red accent (2026-03-09) */\n.reveal-eliminated {\n opacity: 0.35;\n border-color: var(--danger);\n background: rgba(244, 67, 54, 0.05);\n}\n\n.reveal-eliminated .reveal-contestant-name {\n text-decoration: line-through;\n color: var(--text-muted);\n}\n\n/* Flash animation for the contestant JUST eliminated this step */\n.reveal-just-eliminated {\n animation: eliminateFlash 0.6s ease-out;\n}\n\n@keyframes eliminateFlash {\n 0% {\n background: rgba(244, 67, 54, 0.3);\n transform: translateX(0);\n }\n 15% {\n transform: translateX(-4px);\n }\n 30% {\n transform: translateX(4px);\n }\n 45% {\n transform: translateX(-2px);\n }\n 60% {\n transform: translateX(0);\n }\n 100% {\n background: rgba(244, 67, 54, 0.05);\n }\n}\n\n.eliminated-badge {\n display: inline-block;\n padding: 2px 8px;\n background: rgba(244, 67, 54, 0.15);\n color: var(--danger);\n border-radius: 4px;\n font-size: 0.78rem;\n font-weight: 600;\n margin-left: 6px;\n flex-shrink: 0;\n}\n\n.reveal-suspense {\n text-align: center;\n padding: 16px;\n color: var(--warning);\n font-weight: 600;\n font-size: 1rem;\n animation: suspensePulse 1s ease-in-out infinite;\n}\n\n@keyframes suspensePulse {\n 0%, 100% {\n opacity: 0.5;\n }\n 50% {\n opacity: 1;\n }\n}\n\n/* Next button — big and centered */\n.reveal-controls {\n padding: 24px 0;\n text-align: center;\n}\n\n.reveal-next-btn {\n min-width: 200px;\n padding: 14px 32px;\n font-size: 1rem;\n}",[],[154,199],"9de386e2-1bde-11f1-bc71-42dde27851f2","results.tsx","c6b6a0b6-1bc7-11f1-912e-42dde27851f2",65,["D",1773077837066],5,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n// Step-through draft reveal — dramatic, one stage at a time.\n// 2026-03-09\n//\n// Flow per round:\n// 1. \"Round N\" title card\n// 2. Nominations (who wants who, with \"skipped\" narrative for bumped picks)\n// 3. Uncontested awards (if any)\n// 4. Each conflict: show contestants, then X out losers one by one, then reveal winner\n// After all rounds:\n// 5. Final first-round draft order\n//\n// \"Next\" button advances through each stage. Previous stages stay visible.\n// Lottery elimination (2026-03-09): losers are crossed out one at a time\n// until only the winner remains. Purely presentational — the algorithm\n// itself resolves all at once.\n\nimport React, {\n useEffect,\n useRef,\n useState,\n} from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\n// ---- Types ----\n\ninterface SkippedPlayer {\n adp: number;\n name: string;\n takenInRound: number;\n takenBy: string;\n}\n\ninterface RoundNomination {\n managerId: number;\n teamName: string;\n nominatedAdp: number;\n playerName: string;\n skippedPlayers: SkippedPlayer[];\n}\n\ninterface ConflictResolution {\n playerAdp: number;\n playerName: string;\n contestants: Array<{ managerId: number; teamName: string }>;\n winnerId: number;\n winnerTeamName: string;\n}\n\ninterface RoundResult {\n roundNumber: number;\n nominations: RoundNomination[];\n uncontested: Array<\n {\n managerId: number;\n teamName: string;\n playerAdp: number;\n playerName: string;\n }\n >;\n conflicts: ConflictResolution[];\n winners: Array<\n {\n managerId: number;\n teamName: string;\n playerAdp: number;\n playerName: string;\n }\n >;\n}\n\ninterface DraftSlot {\n slot: number;\n managerId: number;\n teamName: string;\n email: string;\n playerAdp: number;\n playerName: string;\n playerTeam: string;\n playerPosition: string;\n}\n\ninterface DraftResult {\n seed: string;\n managerCount: number;\n rounds: RoundResult[];\n finalSlots: DraftSlot[];\n}\n\n// ---- Build step sequence from result data ----\n\ntype Step =\n | { type: \"round-intro\"; roundNumber: number; managerCount: number }\n | { type: \"nominations\"; roundNumber: number; nominations: RoundNomination[] }\n | {\n type: \"uncontested\";\n roundNumber: number;\n picks: Array<{ teamName: string; playerName: string; playerAdp: number }>;\n }\n | {\n type: \"conflict-contestants\";\n roundNumber: number;\n conflict: ConflictResolution;\n }\n | {\n type: \"conflict-eliminate\";\n roundNumber: number;\n conflict: ConflictResolution;\n eliminatedIds: number[]; // manager IDs eliminated so far (cumulative)\n latestEliminatedId: number; // the one just X'd out this step\n }\n | {\n type: \"conflict-winner\";\n roundNumber: number;\n conflict: ConflictResolution;\n allLoserIds: number[];\n }\n | { type: \"final\"; slots: DraftSlot[]; seed: string; roundCount: number };\n\nfunction buildSteps(result: DraftResult): Step[] {\n const steps: Step[] = [];\n\n for (const round of result.rounds) {\n steps.push({\n type: \"round-intro\",\n roundNumber: round.roundNumber,\n managerCount: round.nominations.length,\n });\n\n steps.push({\n type: \"nominations\",\n roundNumber: round.roundNumber,\n nominations: round.nominations,\n });\n\n if (round.uncontested.length > 0) {\n steps.push({\n type: \"uncontested\",\n roundNumber: round.roundNumber,\n picks: round.uncontested,\n });\n }\n\n for (const conflict of round.conflicts) {\n const losers = conflict.contestants.filter((c) =>\n c.managerId !== conflict.winnerId\n );\n\n // Step 1: show all contestants + \"Drawing...\"\n steps.push({\n type: \"conflict-contestants\",\n roundNumber: conflict.playerAdp,\n conflict,\n });\n\n // Steps 2..N-1: eliminate losers one at a time (skip for 2-way — go straight to winner)\n const eliminatedSoFar: number[] = [];\n for (let i = 0; i < losers.length - 1; i++) {\n eliminatedSoFar.push(losers[i].managerId);\n steps.push({\n type: \"conflict-eliminate\",\n roundNumber: conflict.playerAdp,\n conflict,\n eliminatedIds: [...eliminatedSoFar],\n latestEliminatedId: losers[i].managerId,\n });\n }\n\n // Final step: X out last loser + celebrate winner\n steps.push({\n type: \"conflict-winner\",\n roundNumber: conflict.playerAdp,\n conflict,\n allLoserIds: losers.map((l) => l.managerId),\n });\n }\n }\n\n steps.push({\n type: \"final\",\n slots: result.finalSlots,\n seed: result.seed,\n roundCount: result.rounds.length,\n });\n\n return steps;\n}\n\n// ---- Step renderers ----\n\nfunction RoundIntro(\n { step }: { step: Extract },\n) {\n return (\n

Round {step.roundNumber}

\n {step.managerCount} manager{step.managerCount !== 1 ? \"s\" : \"\"}{\" \"}\n still seeking a pick\n

\n );\n}\n\nfunction Nominations(\n { step }: { step: Extract },\n) {\n return (\n

Nominations

\n {step.nominations.map((nom) => (\n

{nom.teamName}

\n nominates {nom.playerName} (ADP {nom.nominatedAdp})\n

\n {nom.skippedPlayers.length > 0 && (\n

\n {nom.skippedPlayers.map((sp) => (\n \n {sp.name} taken R{sp.takenInRound} by {sp.takenBy}\n \n ))}\n

\n )}\n

\n ))}\n

\n );\n}\n\nfunction Uncontested(\n { step }: { step: Extract },\n) {\n return (\n

Uncontested

\n {step.picks.map((pick) => (\n

\n {pick.teamName} gets{\" \"}\n {pick.playerName} (ADP {pick.playerAdp})\n Awarded\n

\n ))}\n

\n );\n}\n\nfunction ConflictContestants(\n { step }: { step: Extract },\n) {\n const c = step.conflict;\n return (\n

\n Lottery for {c.playerName}\n \n {c.contestants.length}-way contest\n \n

\n {c.contestants.map((ct) => (\n

\n {ct.teamName}\n

\n ))}\n

Drawing...

\n );\n}\n\n// Intermediate elimination step — one more loser X'd out each click.\n// Shows \"Drawing...\" to signal more eliminations are coming.\nfunction ConflictEliminate(\n { step }: { step: Extract },\n) {\n const c = step.conflict;\n const eliminatedSet = new Set(step.eliminatedIds);\n return (\n

\n Lottery for {c.playerName}\n \n {c.contestants.length}-way contest\n \n

\n {c.contestants.map((ct) => {\n const isEliminated = eliminatedSet.has(ct.managerId);\n const isJustEliminated = ct.managerId === step.latestEliminatedId;\n return (\n \n {ct.teamName}\n {isEliminated && Out}\n

\n );\n })}\n

Drawing...

\n \n );\n}\n\n// Final reveal — last loser eliminated, winner celebrated.\nfunction ConflictWinner(\n { step }: { step: Extract },\n) {\n const c = step.conflict;\n const loserSet = new Set(step.allLoserIds);\n // The last loser is the one not previously eliminated (in the prior eliminate steps)\n // For a 2-way contest there are no prior eliminate steps, so the single loser is \"just\" eliminated here.\n const lastLoserId = step.allLoserIds[step.allLoserIds.length - 1];\n return (\n

\n Lottery for {c.playerName}\n \n {c.contestants.length}-way contest\n \n

\n {c.contestants.map((ct) => {\n const isWinner = ct.managerId === c.winnerId;\n const isLoser = loserSet.has(ct.managerId);\n const isLastLoser = ct.managerId === lastLoserId;\n return (\n \n {ct.teamName}\n {isWinner && Winner!}\n {isLoser && Out}\n

\n );\n })}\n

\n \n );\n}\n\nfunction FinalReveal({ step }: { step: Extract }) {\n return (\n

Final Draft Order

\n Resolved in {step.roundCount} round{step.roundCount !== 1 ? \"s\" : \"\"}\n {\" \"}\n · Seed: {step.seed}\n

First-Round Draft Order

\n {step.slots.map((slot) => (\n

\n \n {slot.slot}\n

{slot.teamName}

\n Selected: {slot.playerName} (ADP {slot.playerAdp}) ·{\" \"}\n {slot.playerTeam} · {slot.playerPosition}\n

\n ))}\n

\n \n );\n}\n\n// ---- Main App ----\n\nfunction ResultsApp() {\n const [result, setResult] = useState(null);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(\"\");\n const [currentStep, setCurrentStep] = useState(0);\n const bottomRef = useRef(null);\n\n useEffect(() => {\n fetch(\"/api/results\")\n .then((res) => {\n if (!res.ok) throw new Error(\"Failed to load results\");\n return res.json();\n })\n .then((data) => {\n if (data?.result) setResult(data.result as DraftResult);\n })\n .catch((err) => setError(err.message))\n .finally(() => setLoading(false));\n }, []);\n\n // Scroll to bottom when step advances\n useEffect(() => {\n if (currentStep > 0) {\n setTimeout(\n () => bottomRef.current?.scrollIntoView({ behavior: \"smooth\" }),\n 100,\n );\n }\n }, [currentStep]);\n\n if (loading) return

Loading results...

;\n\n if (!result) {\n return (\n

\n NPB Draft 2026\n

First-round lottery results

\n {error &&

{error}

}\n

The draft hasn't been executed yet. Check back later!

\n \n Go to pick submission\n \n

\n );\n }\n\n const steps = buildSteps(result);\n const visibleSteps = steps.slice(0, currentStep + 1);\n const isComplete = currentStep >= steps.length - 1;\n\n return (\n

\n NPB Draft 2026\n

First-round lottery reveal

\n\n

\n {visibleSteps.map((step, i) => (\n \n {step.type === \"round-intro\" && }\n {step.type === \"nominations\" && }\n {step.type === \"uncontested\" && }\n {step.type === \"conflict-contestants\" && (\n \n )}\n {step.type === \"conflict-eliminate\" && (\n \n )}\n {step.type === \"conflict-winner\" && }\n {step.type === \"final\" && }\n

\n ))}\n

\n\n

\n {!isComplete\n ? (\n \n setCurrentStep((s) => s + 1)}\n >\n {currentStep === 0 ? \"Begin Reveal\" : \"Next\"}\n \n )\n : (\n \n Draft complete. Good luck this season!\n

\n )}\n \n \n );\n}\n\ncreateRoot(document.getElementById(\"root\")!).render();",[],[154,207],"fa3a144a-1bc7-11f1-8dcd-42dde27851f2","results.html","c0b59e2e-1bc7-11f1-8303-42dde27851f2",37,["D",1773068113558],3,"\n\n \n \n \n NPB Draft — Results\n \n \n \n \n

\n \n \n",[],[154,216],"f60403ae-1bc7-11f1-906b-42dde27851f2","index.html","bb6ad592-1bc7-11f1-a3bb-42dde27851f2",36,["D",1773068106500],"\n\n \n \n \n NPB Draft — Submit Your Rankings\n \n \n \n \n

\n \n \n",[],[154,225],"c6b46400-1bcb-11f1-a8d0-42dde27851f2","app.tsx","b7316ee6-1bc7-11f1-a3bb-42dde27851f2",51,["D",1773069745106],4,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, {\n useCallback,\n useEffect,\n useRef,\n useState,\n} from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\n// ---- Types ----\n\ninterface Player {\n adp: number;\n name: string;\n team: string;\n position: string;\n}\n\ninterface UserInfo {\n email: string;\n teamName: string;\n draftExecuted: boolean;\n}\n\ndeclare global {\n interface Window {\n __PLAYERS__: Player[];\n __DRAFT_EXECUTED__: boolean;\n }\n}\n\nconst PLAYERS: Player[] = window.__PLAYERS__ || [];\nconst playerMap = new Map(PLAYERS.map((p) => [p.adp, p]));\n\n// ---- API helpers ----\n\nasync function apiPost(path: string, body: unknown) {\n const res = await fetch(path, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n if (!res.ok) {\n const text = await res.text();\n throw new Error(text || res.statusText);\n }\n return res.json();\n}\n\nasync function apiGet(path: string) {\n const res = await fetch(path);\n if (!res.ok) {\n if (res.status === 401) return null;\n throw new Error(await res.text());\n }\n return res.json();\n}\n\n// ---- Login Form ----\n\nfunction LoginForm({ onLogin }: { onLogin: (user: UserInfo) => void }) {\n const [email, setEmail] = useState(\"\");\n const [teamName, setTeamName] = useState(\"\");\n const [error, setError] = useState(\"\");\n const [loading, setLoading] = useState(false);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!email.trim() || !teamName.trim()) return;\n setLoading(true);\n setError(\"\");\n try {\n const result = await apiPost(\"/api/auth\", {\n email: email.trim(),\n teamName: teamName.trim(),\n });\n onLogin(result);\n } catch (err: any) {\n setError(err.message || \"Login failed\");\n } finally {\n setLoading(false);\n }\n };\n\n return (\n

Sign In to Submit Picks

\n \n

\n );\n}\n\n// ---- Draft Locked Banner ----\n\nfunction DraftLockedBanner() {\n return (\n \n The draft has been executed — your picks are locked.{\" \"}\n \n View Results\n \n \n );\n}\n\n// ---- Pick Interface ----\n\nfunction PickInterface(\n { user, onLogout }: { user: UserInfo; onLogout: () => void },\n) {\n const [ranked, setRanked] = useState([]); // ADPs in ranked order\n const [saveStatus, setSaveStatus] = useState<\n \"idle\" | \"saving\" | \"saved\" | \"error\"\n >(\"idle\");\n const [saveMessage, setSaveMessage] = useState(\"\");\n const [loaded, setLoaded] = useState(false);\n const [loadError, setLoadError] = useState(\"\");\n\n // Drag state — supports both reorder within right column AND drag from left to right.\n // dragSource: \"left\" means dragging a new player from available list,\n // \"right\" means reordering within ranked list.\n const dragSource = useRef<\"left\" | \"right\" | null>(null);\n const dragAdp = useRef(null); // ADP of player being dragged (for left→right)\n const dragFromIndex = useRef(null); // index in ranked list (for reorder)\n const dragOverIndex = useRef(null);\n const [draggingIdx, setDraggingIdx] = useState(null);\n const [dragOverIdx, setDragOverIdx] = useState(null);\n const [draggingFromLeft, setDraggingFromLeft] = useState(null); // ADP being dragged from left\n\n const isLocked = user.draftExecuted || window.__DRAFT_EXECUTED__;\n\n // Load existing picks on mount\n useEffect(() => {\n apiGet(\"/api/picks\")\n .then((data) => {\n if (data?.picks) setRanked(data.picks);\n setLoaded(true);\n })\n .catch((err) => {\n setLoadError(err.message || \"Failed to load picks\");\n setLoaded(true);\n });\n }, []);\n\n const rankedSet = new Set(ranked);\n const available = PLAYERS.filter((p) => !rankedSet.has(p.adp));\n\n const addPlayer = (adp: number, atIndex?: number) => {\n if (isLocked) return;\n setRanked((prev) => {\n if (prev.includes(adp)) return prev;\n if (atIndex !== undefined && atIndex >= 0) {\n const next = [...prev];\n next.splice(atIndex, 0, adp);\n return next;\n }\n return [...prev, adp];\n });\n setSaveStatus(\"idle\");\n };\n\n const removePlayer = (adp: number) => {\n if (isLocked) return;\n setRanked((prev) => prev.filter((a) => a !== adp));\n setSaveStatus(\"idle\");\n };\n\n const moveUp = (index: number) => {\n if (isLocked || index === 0) return;\n setRanked((prev) => {\n const next = [...prev];\n [next[index - 1], next[index]] = [next[index], next[index - 1]];\n return next;\n });\n setSaveStatus(\"idle\");\n };\n\n const moveDown = (index: number) => {\n if (isLocked) return;\n setRanked((prev) => {\n if (index >= prev.length - 1) return prev;\n const next = [...prev];\n [next[index], next[index + 1]] = [next[index + 1], next[index]];\n return next;\n });\n setSaveStatus(\"idle\");\n };\n\n // --- Drag from LEFT column (add to right at drop position) ---\n const handleLeftDragStart = (adp: number) => {\n if (isLocked) return;\n dragSource.current = \"left\";\n dragAdp.current = adp;\n setDraggingFromLeft(adp);\n };\n\n // --- Drag within RIGHT column (reorder) ---\n const handleRightDragStart = (index: number) => {\n if (isLocked) return;\n dragSource.current = \"right\";\n dragFromIndex.current = index;\n setDraggingIdx(index);\n };\n\n // --- Shared: drag over a ranked item ---\n const handleRankedDragEnter = (index: number) => {\n dragOverIndex.current = index;\n setDragOverIdx(index);\n };\n\n // --- Shared: drop on the right column body (for appending when dropping on empty space) ---\n const handleRightColumnDrop = (e: React.DragEvent) => {\n e.preventDefault();\n if (dragSource.current === \"left\" && dragAdp.current !== null) {\n // Dropped on the column but not on a specific item — append to end\n if (dragOverIndex.current === null) {\n addPlayer(dragAdp.current);\n }\n }\n resetDragState();\n };\n\n // --- Shared: drag end ---\n const handleDragEnd = () => {\n if (isLocked) {\n resetDragState();\n return;\n }\n\n const source = dragSource.current;\n const overIdx = dragOverIndex.current;\n\n if (source === \"left\") {\n // Dragging from available list into ranked list\n const adp = dragAdp.current;\n if (adp !== null && overIdx !== null) {\n addPlayer(adp, overIdx);\n } else if (adp !== null) {\n // Dropped on the column area but not a specific item — append\n addPlayer(adp);\n }\n } else if (source === \"right\") {\n // Reorder within ranked list\n const from = dragFromIndex.current;\n if (from !== null && overIdx !== null && from !== overIdx) {\n setRanked((prev) => {\n const next = [...prev];\n const [removed] = next.splice(from, 1);\n const adjustedTo = overIdx > from ? overIdx - 1 : overIdx;\n next.splice(adjustedTo, 0, removed);\n return next;\n });\n setSaveStatus(\"idle\");\n }\n }\n\n resetDragState();\n };\n\n const resetDragState = () => {\n dragSource.current = null;\n dragAdp.current = null;\n dragFromIndex.current = null;\n dragOverIndex.current = null;\n setDraggingIdx(null);\n setDragOverIdx(null);\n setDraggingFromLeft(null);\n };\n\n const savePicks = async () => {\n setSaveStatus(\"saving\");\n try {\n await apiPost(\"/api/picks\", { picks: ranked });\n setSaveStatus(\"saved\");\n setSaveMessage(\n `Saved ${ranked.length} pick${ranked.length !== 1 ? \"s\" : \"\"}`,\n );\n } catch (err: any) {\n setSaveStatus(\"error\");\n setSaveMessage(err.message || \"Save failed\");\n }\n };\n\n if (!loaded) return

Loading your picks...

;\n\n if (loadError) {\n return (\n

Failed to load picks: {loadError}

\n );\n }\n\n return (\n

\n {/* User bar */}\n

\n {user.teamName}\n {user.email}\n

\n \n

\n\n {/* Draft locked banner */}\n {isLocked && }\n\n {/* Instructions */}\n {!isLocked && (\n

\n How it works:{\" \"}\n Drag players from the left into your rankings on the right, or click\n to add. Reorder with arrow buttons or drag within the list. Your{\" \"}\n #1 ranked player{\" \"}\n is your first-round nomination. If you don't get them (conflict with\n another manager), your #2 becomes your next nomination, and so on.\n
\n
\n Tip:{\" \"}\n You don't have to rank all 30. Unranked players default to ADP order\n as a fallback. But the more you rank, the more control you have — if\n your top picks are all contested, your next nomination will be the\n highest-ADP player you didn't explicitly rank.\n

\n )}\n\n {/* Two-column layout */}\n

\n {/* Left: available players */}\n

\n Available Players\n {available.length} remaining\n

\n {available.length === 0\n ? (\n

All players ranked!

\n )\n : (\n available.map((p) => (\n addPlayer(p.adp)}\n draggable={!isLocked}\n onDragStart={() => handleLeftDragStart(p.adp)}\n onDragEnd={handleDragEnd}\n style={isLocked\n ? { opacity: 0.5, cursor: \"not-allowed\" }\n : {}}\n >\n

ADP {p.adp}

{p.name}

\n {p.team} · {p.position}\n

\n {!isLocked &&

›

}\n

\n ))\n )}\n

\n\n {/* Right: ranked picks */}\n e.preventDefault()}\n onDrop={handleRightColumnDrop}\n >\n

\n My Rankings\n {ranked.length} selected\n

\n {ranked.length === 0\n ? (\n e.preventDefault()}\n onDrop={(e) => {\n e.preventDefault();\n if (\n dragSource.current === \"left\" && dragAdp.current !== null\n ) {\n addPlayer(dragAdp.current);\n }\n resetDragState();\n }}\n >\n

\n {isLocked\n ? \"No players were ranked\"\n : \"Drag players here or click them on the left\"}\n

\n )\n : (\n ranked.map((adp, index) => {\n const p = playerMap.get(adp)!;\n const isDragging = draggingIdx === index;\n const isDragOver = dragOverIdx === index &&\n ((dragSource.current === \"right\" && draggingIdx !== null &&\n draggingIdx !== index) ||\n dragSource.current === \"left\");\n return (\n handleRightDragStart(index)}\n onDragEnter={() => handleRankedDragEnter(index)}\n onDragEnd={handleDragEnd}\n onDragOver={(e) => e.preventDefault()}\n >\n {!isLocked && (\n

\n ⋮⋮\n

\n )}\n

{index + 1}

ADP {p.adp}

{p.name}

\n {p.team} · {p.position}\n

\n {!isLocked && (\n <>\n

\n {\n e.stopPropagation();\n moveUp(index);\n }}\n disabled={index === 0}\n title=\"Move up\"\n >\n ▲\n \n {\n e.stopPropagation();\n moveDown(index);\n }}\n disabled={index === ranked.length - 1}\n title=\"Move down\"\n >\n ▼\n \n

\n {\n e.stopPropagation();\n removePlayer(adp);\n }}\n title=\"Remove\"\n >\n ×\n \n \n )}\n

\n );\n })\n )}\n \n \n \n\n {/* Save bar */}\n {!isLocked && (\n

\n \n {saveStatus === \"idle\" && ranked.length > 0 && \"Unsaved changes\"}\n {saveStatus === \"idle\" && ranked.length === 0 &&\n \"Add players to your rankings\"}\n {saveStatus === \"saving\" && \"Saving...\"}\n {saveStatus === \"saved\" && saveMessage}\n {saveStatus === \"error\" && saveMessage}\n

\n \n Save Rankings\n \n \n )}\n \n );\n}\n\n// ---- App Root ----\n\nfunction App() {\n const [user, setUser] = useState(null);\n const [checking, setChecking] = useState(true);\n\n useEffect(() => {\n apiGet(\"/api/me\")\n .then((data) => {\n if (data) setUser(data);\n })\n .catch(() => {})\n .finally(() => setChecking(false));\n }, []);\n\n const handleLogout = async () => {\n await fetch(\"/api/logout\", { method: \"POST\" });\n setUser(null);\n };\n\n if (checking) return

;\n\n return (\n

\n NPB Draft 2026\n

Rank your player nominations for the first-round lottery

\n {user\n ? \n : }\n

\n );\n}\n\n// ---- Mount ----\n\ncreateRoot(document.getElementById(\"root\")!).render();",[],[154,233],"9b695ee0-1c89-11f1-b2db-42dde27851f2",["D",1773151276849],[],[154,33],"e59fb77e-1bc7-11f1-bfda-42dde27851f2","admin.html","a77e262e-1bc7-11f1-b180-42dde27851f2",32,["D",1773068078985],"\n\n \n \n \n NPB Draft — Admin\n \n \n \n \n

\n \n \n",[],[154,246],["D",1773067909348],[182,183,184,185,186,187,188],[154],"6335b730-1bdf-11f1-aafb-42dde27851f2","simulate.ts","9cd609b4-1bd4-11f1-987a-42dde27851f2",67,["D",1773078168111],"// Simulation data for testing the draft with 12 fake managers.\n// 2026-03-09\n//\n// Picks are weighted realistically:\n// - Most managers have a top-5 guy as #1 (creates conflicts)\n// - Some contrarians reach for mid-round value\n// - Managers rank between 3 and 15 players\n// - Enough overlap on Judge/Ohtani/Witt/Soto to force 2-3 lottery rounds\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\ninterface FakeManager {\n email: string;\n teamName: string;\n picks: number[]; // ADPs in ranked order\n}\n\n// Hand-crafted picks that create dramatic top-heavy conflicts:\n// - 6 managers want Judge (#1) as their top pick → big 6-way lottery\n// - 4 managers want Ohtani (#2) → 4-way lottery\n// - Overlap on Witt (#3) and Soto (#4) in fallback picks → cascading conflicts\n// - Only 1 contrarian skips the top-4 entirely\n// - This produces multi-round resolution with the elimination reveal at its best\nconst FAKE_MANAGERS: FakeManager[] = [\n {\n email: \"alice@example.com\",\n teamName: \"Bronx Bombers\",\n picks: [1, 2, 3, 7, 14, 17], // Judge, Ohtani, Witt, EDLC, Henderson, Vlad\n },\n {\n email: \"bob@example.com\",\n teamName: \"Dodger Dogs\",\n picks: [2, 1, 4, 11, 23], // Ohtani, Judge, Soto, Tucker, Yamamoto\n },\n {\n email: \"carol@example.com\",\n teamName: \"Reds Machine\",\n picks: [1, 2, 4, 6, 9, 15, 22], // Judge, Ohtani, Soto, JRam, Acuna, Caminero, Chourio\n },\n {\n email: \"dan@example.com\",\n teamName: \"Motor City Mashers\",\n picks: [1, 2, 5, 8, 12, 26], // Judge, Ohtani, Skubal, Skenes, Crochet, Sanchez\n },\n {\n email: \"eve@example.com\",\n teamName: \"Queens Chaos\",\n picks: [2, 1, 4, 25, 28], // Ohtani, Judge, Soto, Lindor, Turner\n },\n {\n email: \"frank@example.com\",\n teamName: \"Bay Area Bashers\",\n picks: [1, 3, 2, 10, 13, 18, 20], // Judge, Witt, Ohtani, JRod, Raleigh, Carroll, Kurtz\n },\n {\n email: \"grace@example.com\",\n teamName: \"Philly Specials\",\n picks: [16, 26, 28, 11, 4], // Schwarber, Sanchez, Turner, Tucker, Soto — lone contrarian\n },\n {\n email: \"hank@example.com\",\n teamName: \"Cleveland Steamers\",\n picks: [1, 3, 6, 7, 9, 14], // Judge, Witt, JRam, EDLC, Acuna, Henderson\n },\n {\n email: \"iris@example.com\",\n teamName: \"Prospect Huggers\",\n picks: [3, 1, 2, 7, 15, 22, 30], // Witt, Judge, Ohtani, EDLC, Caminero, Chourio, Neto\n },\n {\n email: \"jake@example.com\",\n teamName: \"Ace Hunters\",\n picks: [2, 1, 5, 8, 12, 23], // Ohtani, Judge, Skubal, Skenes, Crochet, Yamamoto\n },\n {\n email: \"kate@example.com\",\n teamName: \"Power Alley\",\n picks: [1, 4, 3, 17, 21, 16], // Judge, Soto, Witt, Vlad, Alonso, Schwarber\n },\n {\n email: \"leo@example.com\",\n teamName: \"Speed Demons\",\n picks: [3, 1, 10, 7, 19, 30, 27], // Witt, Judge, JRod, EDLC, Tatis, Neto, Marte\n },\n];\n\nexport async function populateSimulation(): Promise<\n { managersCreated: number; summary: string[] }\n> {\n // Clear existing data\n await sqlite.batch([\n \"DELETE FROM draft_results\",\n \"DELETE FROM picks\",\n \"DELETE FROM managers\",\n ]);\n\n const summary: string[] = [];\n\n for (const mgr of FAKE_MANAGERS) {\n const token = crypto.randomUUID();\n\n // Insert manager\n await sqlite.execute({\n sql:\n \"INSERT INTO managers (email, team_name, session_token) VALUES (?, ?, ?)\",\n args: [mgr.email, mgr.teamName, token],\n });\n\n const idResult = await sqlite.execute({\n sql: \"SELECT id FROM managers WHERE email = ?\",\n args: [mgr.email],\n });\n const managerId = (idResult.rows[0] as any).id as number;\n\n // Insert picks\n const pickStatements = mgr.picks.map((adp, i) => ({\n sql:\n \"INSERT INTO picks (manager_id, player_adp, rank_order) VALUES (?, ?, ?)\",\n args: [managerId, adp, i + 1] as unknown[],\n }));\n if (pickStatements.length > 0) {\n await sqlite.batch(pickStatements);\n }\n\n summary.push(\n `${mgr.teamName}: ${mgr.picks.length} picks (top pick: ADP ${\n mgr.picks[0]\n })`,\n );\n }\n\n return { managersCreated: FAKE_MANAGERS.length, summary };\n}",[],[161,257],"20a5dba0-1bd7-11f1-9b4a-42dde27851f2","draft.ts","9daa628e-1bc7-11f1-86bd-42dde27851f2",59,["D",1773074620476],"// NPB Draft Algorithm — seeded deterministic execution\n// 2026-03-09\n//\n// Each round:\n// 1. Every unassigned manager nominates their top-ranked AVAILABLE player\n// 2. Uncontested nominations are awarded immediately\n// 3. Contested nominations (2+ managers want same player) resolved by seeded RNG\n// 4. Winners locked in; losers advance to next round\n// Continues until all managers have a player.\n//\n// Managers who didn't rank enough players fall through to ADP order (1-30).\n//\n// Fixes from adversarial review:\n// - hashSeed uses FNV-1a (better avalanche than djb2) for PRNG seeding\n// - Manager count validated: exactly 12 required, with a flag to override\n\nimport { type Player, PLAYERS } from \"../players.ts\";\n\n// --- Seeded PRNG (Mulberry32) ---\n// Deterministic 32-bit PRNG. Same seed always produces same sequence.\n\nfunction mulberry32(seed: number): () => number {\n return function () {\n seed |= 0;\n seed = (seed + 0x6d2b79f5) | 0;\n let t = Math.imul(seed ^ (seed >>> 15), 1 | seed);\n t = (t + Math.imul(t ^ (t >>> 7), 61 | t)) ^ t;\n return ((t ^ (t >>> 14)) >>> 0) / 4294967296;\n };\n}\n\n// FNV-1a hash — better bit avalanche than djb2 for short strings.\n// Two seeds that differ by a single character produce very different hash values,\n// which is important for PRNG seeding fairness.\nfunction fnv1aHash(s: string): number {\n let hash = 0x811c9dc5; // FNV offset basis\n for (let i = 0; i < s.length; i++) {\n hash ^= s.charCodeAt(i);\n hash = Math.imul(hash, 0x01000193); // FNV prime\n }\n return hash >>> 0; // unsigned 32-bit\n}\n\n// --- Types ---\n\nexport interface ManagerInput {\n managerId: number;\n email: string;\n teamName: string;\n rankings: number[]; // player ADPs in user-ranked order\n}\n\nexport interface SkippedPlayer {\n adp: number;\n name: string;\n takenInRound: number;\n takenBy: string; // team name of who got them\n}\n\nexport interface RoundNomination {\n managerId: number;\n teamName: string;\n nominatedAdp: number;\n playerName: string;\n // Players this manager had ranked higher but were already taken.\n // Empty in round 1 (nothing taken yet). Tells the narrative:\n // \"Originally wanted Judge (taken R1), then Ohtani (taken R1), now nominates Witt\"\n skippedPlayers: SkippedPlayer[];\n}\n\nexport interface ConflictResolution {\n playerAdp: number;\n playerName: string;\n contestants: Array<{ managerId: number; teamName: string }>;\n winnerId: number;\n winnerTeamName: string;\n}\n\nexport interface RoundResult {\n roundNumber: number;\n nominations: RoundNomination[];\n uncontested: Array<{\n managerId: number;\n teamName: string;\n playerAdp: number;\n playerName: string;\n }>;\n conflicts: ConflictResolution[];\n winners: Array<{\n managerId: number;\n teamName: string;\n playerAdp: number;\n playerName: string;\n }>;\n}\n\nexport interface DraftSlot {\n slot: number;\n managerId: number;\n teamName: string;\n email: string;\n playerAdp: number;\n playerName: string;\n playerTeam: string;\n playerPosition: string;\n}\n\nexport interface DraftResult {\n seed: string;\n managerCount: number;\n rounds: RoundResult[];\n finalSlots: DraftSlot[];\n}\n\n// --- Core Algorithm ---\n\nexport function executeDraft(\n managers: ManagerInput[],\n seed: string,\n): DraftResult {\n if (managers.length === 0) {\n throw new Error(\"No managers to draft\");\n }\n if (managers.length > 12) {\n throw new Error(\n `Too many managers (${managers.length}). The NPB draft is designed for exactly 12 managers.`,\n );\n }\n\n const rng = mulberry32(fnv1aHash(seed));\n const playerMap = new Map(PLAYERS.map((p) => [p.adp, p]));\n\n // Build effective rankings: user's ranked players, then all unranked players in ADP order.\n // This guarantees every manager always has a nomination available.\n const effectiveRankings = new Map();\n for (const mgr of managers) {\n const ranked = [...mgr.rankings];\n const rankedSet = new Set(ranked);\n for (const p of PLAYERS) {\n if (!rankedSet.has(p.adp)) ranked.push(p.adp);\n }\n effectiveRankings.set(mgr.managerId, ranked);\n }\n\n const takenPlayers = new Set();\n const assignedManagers = new Map(); // managerId -> playerAdp\n // Track which round each player was taken in and by whom, for the \"skipped\" narrative\n const takenInRound = new Map();\n const rounds: RoundResult[] = [];\n\n let roundNumber = 0;\n while (assignedManagers.size < managers.length) {\n roundNumber++;\n if (roundNumber > 30) {\n throw new Error(\n `Draft did not converge after 30 rounds — bug in algorithm`,\n );\n }\n\n const unassigned = managers.filter((m) =>\n !assignedManagers.has(m.managerId)\n );\n const nominations: RoundNomination[] = [];\n\n for (const mgr of unassigned) {\n const rankings = effectiveRankings.get(mgr.managerId)!;\n\n // Collect skipped players: ones ranked higher than the nomination but already taken\n const skippedPlayers: SkippedPlayer[] = [];\n let nominatedAdp: number | undefined;\n for (const adp of rankings) {\n if (!takenPlayers.has(adp)) {\n nominatedAdp = adp;\n break;\n }\n // This player was taken — record as skipped (only if manager actually ranked them,\n // not the ADP-fallback tail)\n const taken = takenInRound.get(adp);\n if (taken && mgr.rankings.includes(adp)) {\n skippedPlayers.push({\n adp,\n name: playerMap.get(adp)!.name,\n takenInRound: taken.round,\n takenBy: taken.teamName,\n });\n }\n }\n\n if (nominatedAdp === undefined) {\n throw new Error(\n `Manager ${mgr.teamName} has no available players — should be impossible`,\n );\n }\n const player = playerMap.get(nominatedAdp)!;\n nominations.push({\n managerId: mgr.managerId,\n teamName: mgr.teamName,\n nominatedAdp,\n playerName: player.name,\n skippedPlayers,\n });\n }\n\n // Group nominations by player\n const byPlayer = new Map();\n for (const nom of nominations) {\n if (!byPlayer.has(nom.nominatedAdp)) byPlayer.set(nom.nominatedAdp, []);\n byPlayer.get(nom.nominatedAdp)!.push(nom);\n }\n\n const round: RoundResult = {\n roundNumber,\n nominations,\n uncontested: [],\n conflicts: [],\n winners: [],\n };\n\n // Process each nominated player. Sort by ADP for deterministic order.\n // NOTE: The ADP sort order determines which RNG values are consumed by which\n // conflict. This is deterministic and reproducible — same seed, same outcome —\n // but it means the ordering matters. Documented here for transparency.\n const sortedPlayerAdps = [...byPlayer.keys()].sort((a, b) => a - b);\n\n for (const playerAdp of sortedPlayerAdps) {\n const noms = byPlayer.get(playerAdp)!;\n const player = playerMap.get(playerAdp)!;\n\n if (noms.length === 1) {\n // Uncontested\n const winner = noms[0];\n round.uncontested.push({\n managerId: winner.managerId,\n teamName: winner.teamName,\n playerAdp,\n playerName: player.name,\n });\n round.winners.push({\n managerId: winner.managerId,\n teamName: winner.teamName,\n playerAdp,\n playerName: player.name,\n });\n takenPlayers.add(playerAdp);\n takenInRound.set(playerAdp, {\n round: roundNumber,\n teamName: winner.teamName,\n });\n assignedManagers.set(winner.managerId, playerAdp);\n } else {\n // Conflict — seeded RNG lottery\n const winnerIdx = Math.floor(rng() * noms.length);\n const winner = noms[winnerIdx];\n round.conflicts.push({\n playerAdp,\n playerName: player.name,\n contestants: noms.map((n) => ({\n managerId: n.managerId,\n teamName: n.teamName,\n })),\n winnerId: winner.managerId,\n winnerTeamName: winner.teamName,\n });\n round.winners.push({\n managerId: winner.managerId,\n teamName: winner.teamName,\n playerAdp,\n playerName: player.name,\n });\n takenPlayers.add(playerAdp);\n takenInRound.set(playerAdp, {\n round: roundNumber,\n teamName: winner.teamName,\n });\n assignedManagers.set(winner.managerId, playerAdp);\n }\n }\n\n rounds.push(round);\n }\n\n const finalSlots = calculateDraftSlots(managers, assignedManagers, playerMap);\n return { seed, managerCount: managers.length, rounds, finalSlots };\n}\n\n// --- Draft Slot Assignment ---\n// Players ADP 1-12: manager gets that exact draft slot.\n// Players ADP 13+: managers sorted by ADP (ascending) and assigned to remaining\n// open slots (ascending). This is the rule from the league commissioner.\n\nfunction calculateDraftSlots(\n managers: ManagerInput[],\n assignedManagers: Map,\n playerMap: Map,\n): DraftSlot[] {\n const managerMap = new Map(managers.map((m) => [m.managerId, m]));\n const slots: DraftSlot[] = [];\n const outsideTop12: Array<{\n managerId: number;\n teamName: string;\n email: string;\n playerAdp: number;\n player: Player;\n }> = [];\n\n const totalManagers = managers.length;\n\n for (const [managerId, playerAdp] of assignedManagers) {\n const mgr = managerMap.get(managerId)!;\n const player = playerMap.get(playerAdp)!;\n\n if (playerAdp <= totalManagers) {\n // Player's ADP is within the manager count — gets that exact slot\n slots.push({\n slot: playerAdp,\n managerId,\n teamName: mgr.teamName,\n email: mgr.email,\n playerAdp,\n playerName: player.name,\n playerTeam: player.team,\n playerPosition: player.position,\n });\n } else {\n outsideTop12.push({\n managerId,\n teamName: mgr.teamName,\n email: mgr.email,\n playerAdp,\n player,\n });\n }\n }\n\n // Sort outside-top-N by ADP ascending (lower ADP = better remaining slot)\n outsideTop12.sort((a, b) => a.playerAdp - b.playerAdp);\n\n // Find remaining slots among 1-N\n const usedSlots = new Set(slots.map((s) => s.slot));\n const remainingSlots: number[] = [];\n for (let i = 1; i <= totalManagers; i++) {\n if (!usedSlots.has(i)) remainingSlots.push(i);\n }\n remainingSlots.sort((a, b) => a - b);\n\n for (let i = 0; i < outsideTop12.length; i++) {\n const m = outsideTop12[i];\n slots.push({\n slot: remainingSlots[i],\n managerId: m.managerId,\n teamName: m.teamName,\n email: m.email,\n playerAdp: m.playerAdp,\n playerName: m.player.name,\n playerTeam: m.player.team,\n playerPosition: m.player.position,\n });\n }\n\n slots.sort((a, b) => a.slot - b.slot);\n return slots;\n}",[],[161,265],"d77c426c-1bcb-11f1-8abf-42dde27851f2","db.ts","9958478c-1bc7-11f1-b77a-42dde27851f2",53,["D",1773069773256],"// Database layer for NPB Draft app — Val Town SQLite\n// 2026-03-09\n//\n// Val Town SQLite returns rows as objects (keyed by column name), NOT arrays.\n// All row access uses property names like row.id, row.email, etc.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initDb() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS managers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT UNIQUE NOT NULL,\n team_name TEXT NOT NULL,\n session_token TEXT UNIQUE,\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS picks (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n manager_id INTEGER NOT NULL REFERENCES managers(id),\n player_adp INTEGER NOT NULL,\n rank_order INTEGER NOT NULL,\n UNIQUE(manager_id, player_adp),\n UNIQUE(manager_id, rank_order)\n )`,\n `CREATE TABLE IF NOT EXISTS draft_results (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n seed TEXT NOT NULL,\n result_json TEXT NOT NULL,\n executed_at TEXT DEFAULT (datetime('now'))\n )`,\n ]);\n}\n\n// --- Auth ---\n\nexport async function findOrCreateManager(\n email: string,\n teamName: string,\n): Promise<{ id: number; sessionToken: string }> {\n const normalizedEmail = email.toLowerCase().trim();\n const normalizedTeam = teamName.trim();\n const token = crypto.randomUUID();\n\n await sqlite.execute({\n sql:\n \"INSERT OR IGNORE INTO managers (email, team_name, session_token) VALUES (?, ?, ?)\",\n args: [normalizedEmail, normalizedTeam, token],\n });\n\n await sqlite.execute({\n sql: \"UPDATE managers SET team_name = ?, session_token = ? WHERE email = ?\",\n args: [normalizedTeam, token, normalizedEmail],\n });\n\n const result = await sqlite.execute({\n sql: \"SELECT id FROM managers WHERE email = ?\",\n args: [normalizedEmail],\n });\n\n const row: any = result.rows[0];\n return { id: row.id as number, sessionToken: token };\n}\n\nexport async function getManagerByToken(\n token: string,\n): Promise<{ id: number; email: string; teamName: string } | null> {\n const result = await sqlite.execute({\n sql: \"SELECT id, email, team_name FROM managers WHERE session_token = ?\",\n args: [token],\n });\n if (result.rows.length === 0) return null;\n const row: any = result.rows[0];\n return {\n id: row.id as number,\n email: row.email as string,\n teamName: row.team_name as string,\n };\n}\n\n// --- Picks ---\n\nexport async function savePicks(managerId: number, playerAdps: number[]) {\n const statements: Array<{ sql: string; args: unknown[] }> = [\n { sql: \"DELETE FROM picks WHERE manager_id = ?\", args: [managerId] },\n ];\n\n for (let i = 0; i < playerAdps.length; i++) {\n statements.push({\n sql:\n \"INSERT INTO picks (manager_id, player_adp, rank_order) VALUES (?, ?, ?)\",\n args: [managerId, playerAdps[i], i + 1],\n });\n }\n\n await sqlite.batch(statements);\n}\n\nexport async function getPicks(managerId: number): Promise {\n const result = await sqlite.execute({\n sql:\n \"SELECT player_adp FROM picks WHERE manager_id = ? ORDER BY rank_order\",\n args: [managerId],\n });\n return result.rows.map((r: any) => r.player_adp as number);\n}\n\n// --- Admin ---\n\nexport async function getAllManagers(): Promise<\n Array<{ id: number; email: string; teamName: string; pickCount: number }>\n> {\n const result = await sqlite.execute(`\n SELECT m.id, m.email, m.team_name, COUNT(p.id) as pick_count\n FROM managers m\n LEFT JOIN picks p ON m.id = p.manager_id\n GROUP BY m.id\n ORDER BY m.created_at\n `);\n return result.rows.map((r: any) => ({\n id: r.id as number,\n email: r.email as string,\n teamName: r.team_name as string,\n pickCount: r.pick_count as number,\n }));\n}\n\nexport async function getAllManagersWithPicks(): Promise<\n Array<{ id: number; email: string; teamName: string; rankings: number[] }>\n> {\n const managers = await getAllManagers();\n const picksResult = await sqlite.execute(\n \"SELECT manager_id, player_adp FROM picks ORDER BY manager_id, rank_order\",\n );\n\n const picksMap = new Map();\n for (const row of picksResult.rows) {\n const r: any = row;\n const mid = r.manager_id as number;\n const adp = r.player_adp as number;\n if (!picksMap.has(mid)) picksMap.set(mid, []);\n picksMap.get(mid)!.push(adp);\n }\n\n return managers.map((m) => ({\n id: m.id,\n email: m.email,\n teamName: m.teamName,\n rankings: picksMap.get(m.id) ?? [],\n }));\n}\n\n// --- Draft Results ---\n\nexport async function isDraftExecuted(): Promise {\n const result = await sqlite.execute(\n \"SELECT COUNT(*) as cnt FROM draft_results\",\n );\n const row: any = result.rows[0];\n return (row.cnt as number) > 0;\n}\n\nexport async function saveDraftResult(seed: string, resultJson: string) {\n await sqlite.execute({\n sql: \"INSERT INTO draft_results (seed, result_json) VALUES (?, ?)\",\n args: [seed, resultJson],\n });\n}\n\nexport async function getLatestDraftResult(): Promise<\n {\n seed: string;\n result: unknown;\n executedAt: string;\n } | null\n> {\n const result = await sqlite.execute(\n \"SELECT seed, result_json, executed_at FROM draft_results ORDER BY id DESC LIMIT 1\",\n );\n if (result.rows.length === 0) return null;\n const row: any = result.rows[0];\n return {\n seed: row.seed as string,\n result: JSON.parse(row.result_json as string),\n executedAt: row.executed_at as string,\n };\n}",[],[161,273],["D",1773067917271],[178,179,180],[161],["D",1773067822232],["D",1789518676100],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":55,"_102":103,"_104":25},{"_13":87,"_32":88,"_44":43,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":46,"_96":97},"ctx",{"_80":-5,"_126":321,"_322":323,"_324":325,"_326":25,"_327":25,"_328":25,"_329":124,"_330":-5,"_331":-7,"_332":-7,"_333":61,"_334":25,"_335":25,"_336":-5,"_337":25,"_338":25,"_339":25,"_340":-5},"ENV",{"_292":293,"_294":295,"_296":88,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v70