Loading results...

;\n\n return (\n

\n NPB Draft 2026\n

First-round lottery results

\n\n {error &&

{error}

}\n\n {!result\n ? (\n

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

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

\n )\n : (\n

\n \n Draft completed with seed: {result.seed} —\n {\" \"}\n {result.managerCount} managers, {result.rounds.length} round\n {result.rounds.length !== 1 ? \"s\" : \"\"}\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{\" \"}\n {slot.playerAdp}) · {slot.playerTeam} ·{\" \"}\n {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

Nominations

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

\n\n {round.uncontested.length > 0 && (\n

Uncontested

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

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

Lottery Drawings

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

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

\n \n {conflict.contestants.map((c) => (\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 \n );\n}\n\n// ---- Mount ----\n\ncreateRoot(document.getElementById(\"root\")!).render();",[],[138,188],"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",[],[138,196],"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",[],[138,205],"f217875c-1bc7-11f1-b7fa-42dde27851f2","app.tsx","b7316ee6-1bc7-11f1-a3bb-42dde27851f2",35,["D",1773068099910],"/** @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\n// Player data injected server-side into window.__PLAYERS__ to avoid duplication.\n// Falls back to empty array if injection fails (should never happen).\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 const dragItem = useRef(null);\n const dragOverItem = useRef(null);\n const [draggingIndex, setDraggingIndex] = useState(null);\n const [dragOverIndex, setDragOverIndex] = useState(null);\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) => {\n if (isLocked) return;\n setRanked((prev) => [...prev, adp]);\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-to-reorder within ranked list.\n // Fix from review: adjust target index when dragging downward to compensate\n // for the array shrinking after splice-remove.\n const handleDragStart = (index: number) => {\n dragItem.current = index;\n setDraggingIndex(index);\n };\n\n const handleDragEnter = (index: number) => {\n dragOverItem.current = index;\n setDragOverIndex(index);\n };\n\n const handleDragEnd = () => {\n if (isLocked) return;\n const from = dragItem.current;\n const to = dragOverItem.current;\n\n if (from === null || to === null || from === to) {\n setDraggingIndex(null);\n setDragOverIndex(null);\n dragItem.current = null;\n dragOverItem.current = null;\n return;\n }\n\n setRanked((prev) => {\n const next = [...prev];\n const [removed] = next.splice(from, 1);\n // When dragging downward, the target index shifted left by 1\n // because we removed an element before it. Compensate.\n const adjustedTo = to > from ? to - 1 : to;\n next.splice(adjustedTo, 0, removed);\n return next;\n });\n\n setSaveStatus(\"idle\");\n setDraggingIndex(null);\n setDragOverIndex(null);\n dragItem.current = null;\n dragOverItem.current = 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 Click players on the left to add them to your rankings on the right.\n Reorder with the arrow buttons or drag to reorder. 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 style={isLocked\n ? { opacity: 0.5, cursor: \"not-allowed\" }\n : {}}\n >\n

{p.adp}

{p.name}

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

\n {!isLocked &&

›

}\n

\n ))\n )}\n

\n\n {/* Right: ranked picks */}\n

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

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

\n {isLocked\n ? \"No players were ranked\"\n : \"Click players on the left to add them here\"}\n

\n )\n : (\n ranked.map((adp, index) => {\n const p = playerMap.get(adp)!;\n const isDragging = draggingIndex === index;\n const isDragOver = dragOverIndex === index &&\n draggingIndex !== null && draggingIndex !== index;\n return (\n handleDragStart(index)}\n onDragEnter={() => handleDragEnter(index)}\n onDragEnd={handleDragEnd}\n onDragOver={(e) => e.preventDefault()}\n >\n {!isLocked && (\n

\n ⋮⋮\n

\n )}\n

{index + 1}

{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 {/* 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 // Check for existing session on mount\n useEffect(() => {\n apiGet(\"/api/me\")\n .then((data) => {\n if (data) setUser(data);\n })\n .catch(() => {\n // No session — show login\n })\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();",[],[138,213],"ea6bbf3c-1bc7-11f1-a7d0-42dde27851f2","admin.tsx","b0d4eaf0-1bc7-11f1-b180-42dde27851f2",33,["D",1773068087040],"/** @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 [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 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 {/* 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 {/* Results */}\n {result && }\n

\n );\n}\n\n// ---- Mount ----\n\ncreateRoot(document.getElementById(\"root\")!).render();",[],[138,221],"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",[],[138,229],["D",1773067909348],[166,167,168,169,170,171,172],[138],"df6adc3a-1bc7-11f1-8dcd-42dde27851f2","draft.ts","9daa628e-1bc7-11f1-86bd-42dde27851f2",31,["D",1773068068576],"// 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 RoundNomination {\n managerId: number;\n teamName: string;\n nominatedAdp: number;\n playerName: string;\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 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 const nominatedAdp = rankings.find((adp) => !takenPlayers.has(adp));\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 });\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 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 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}",[],[147,240],"d89a17f4-1bc7-11f1-b5cf-42dde27851f2","db.ts","9958478c-1bc7-11f1-b77a-42dde27851f2",30,["D",1773068057147],"// Database layer for NPB Draft app — Val Town SQLite\n// 2026-03-09\n//\n// Fixes applied from adversarial review:\n// - savePicks uses sqlite.batch() for atomicity (was DELETE + N INSERTs without txn)\n// - findOrCreateManager uses ON CONFLICT to avoid TOCTOU race\n// - isDraftExecuted() added so picks can be locked post-draft\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 // INSERT OR IGNORE avoids the TOCTOU race between SELECT and INSERT.\n // If email already exists, the INSERT is a no-op (IGNORE), and we UPDATE below.\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 // Always UPDATE to set the new session token and (possibly changed) team name.\n // This covers both the \"new row inserted\" and \"existing row, INSERT was ignored\" cases.\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 return { id: result.rows[0][0] 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 [id, email, teamName] = result.rows[0];\n return {\n id: id as number,\n email: email as string,\n teamName: teamName as string,\n };\n}\n\n// --- Picks ---\n\nexport async function savePicks(managerId: number, playerAdps: number[]) {\n // Atomic batch: wipe old picks + insert new ones in a single transaction.\n // Prevents partial state if the function times out mid-operation.\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) => r[0] 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) => ({\n id: r[0] as number,\n email: r[1] as string,\n teamName: r[2] as string,\n pickCount: r[3] 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 mid = row[0] as number;\n const adp = row[1] 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(\"SELECT COUNT(*) FROM draft_results\");\n return (result.rows[0][0] 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 return {\n seed: result.rows[0][0] as string,\n result: JSON.parse(result.rows[0][1] as string),\n executedAt: result.rows[0][2] as string,\n };\n}",[],[147,248],["D",1773067917271],[163,164],[147],["D",1773067822232],["D",1789518676100],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":55,"_102":103,"_104":25},{"_13":87,"_33":88,"_44":43,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":46,"_96":97},"ctx",{"_80":-5,"_124":296,"_297":298,"_299":300,"_301":25,"_302":25,"_303":25,"_304":141,"_305":-5,"_306":-7,"_307":-7,"_308":61,"_309":25,"_310":25,"_311":-5,"_312":25,"_313":25,"_314":25,"_315":-5},"ENV",{"_267":268,"_269":270,"_271":88,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295},"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 · v41