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();",[],[146,198],"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",[],[146,207],"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",[],[146,216],"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();",[],[146,224],"9b695ee0-1c89-11f1-b2db-42dde27851f2","admin.tsx","b0d4eaf0-1bc7-11f1-b180-42dde27851f2",70,["D",1773151276849],"/** @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 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

{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();",[],[146,233],"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",[],[146,241],["D",1773067909348],[173,174,175,176,177,178,179],[146],"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}",[],[153,252],"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}",[],[153,260],"a8b58c68-1c89-11f1-9716-42dde27851f2","db.ts","9958478c-1bc7-11f1-b77a-42dde27851f2",["D",1773151299166],"// 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// --- Admin: clear picks ---\n\nexport async function clearPicksForManager(managerId: number): Promise {\n const result = await sqlite.execute({\n sql: \"DELETE FROM picks WHERE manager_id = ?\",\n args: [managerId],\n });\n return result.rowsAffected;\n}\n\nexport async function clearAllPicks(): Promise {\n const result = await sqlite.execute(\"DELETE FROM picks\");\n return result.rowsAffected;\n}\n\nexport async function deleteManager(managerId: number): Promise {\n await sqlite.batch([\n { sql: \"DELETE FROM picks WHERE manager_id = ?\", args: [managerId] },\n { sql: \"DELETE FROM managers WHERE id = ?\", args: [managerId] },\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}",[],[153,268],["D",1773067917271],[169,170,171],[153],["D",1773067822232],["D",1789518676100],{"_11":12,"_88":84},{"_11":12,"_82":-5,"_83":84,"_44":45,"_85":86,"_87":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_77":-5,"_78":-5,"_79":-5,"_80":14,"_81":12},"ctx",{"_70":-5,"_111":315,"_316":317,"_318":319,"_320":38,"_321":38,"_322":38,"_323":109,"_324":-5,"_325":-7,"_326":-7,"_327":51,"_328":38,"_329":38,"_330":-5,"_331":38,"_332":38,"_333":38,"_334":-5},"ENV",{"_286":287,"_288":289,"_290":26,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314},"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"]

Branches1

Branches
1