[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_277":278,"_279":280},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":123,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",55,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","index.http.ts","latestPath","fileId","4c966c80-1bc7-11f1-aaf0-42dde27851f2","name","fileType","http","content","// 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 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 { 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// ---- Error handler (stack traces in dev) ----\n\napp.onError((err) => {\n throw err;\n});\n\n// ---- Export ----\n\nexport default app.fetch;","// 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 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// ---- 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;","createdAt",["D",1773073525452],"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",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"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",{"_43":44,"_32":45,"_38":272,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":273,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":274,"_81":275,"_83":276,"_85":25},"tree",[171,174,182,183],"files",[171,172,173,174,175,176,177,178,179,180,181,182,183],"counts",{"_160":60,"_161":162,"_163":60,"_164":165,"_166":167},"contents",[128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":155,"_32":156,"_30":157,"_135":-5,"_41":42,"_40":146,"_137":123,"_38":158,"_13":139,"_33":153,"_35":-5,"_24":25,"_142":-5,"_27":159},{"_43":148,"_32":149,"_30":150,"_135":-5,"_41":42,"_40":151,"_137":123,"_38":152,"_13":139,"_33":153,"_35":-5,"_24":25,"_142":-5,"_27":154},{"_43":144,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_137":25,"_38":145,"_13":146,"_33":34,"_35":37,"_24":25,"_142":-5,"_27":147},{"_43":132,"_32":133,"_30":134,"_135":-5,"_41":42,"_40":136,"_137":123,"_38":138,"_13":139,"_33":140,"_35":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,"script","// 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",[133],"93f733f4-1bd4-11f1-a5f0-42dde27851f2",["D",1773073525452],7,[28],"8080f36c-1bc7-11f1-893d-42dde27851f2","frontend","7859693a-1bc7-11f1-9427-42dde27851f2",6,["D",1773067909348],"directory",[149],"853a17d0-1bc7-11f1-9427-42dde27851f2","backend","7427c5a0-1bc7-11f1-8bec-42dde27851f2",["D",1773067917271],[156],"pulls","branches",1,"forks","envVars",{"_168":60,"_170":60},"connections",{"_168":60,"_169":60},"count","unfilledCount","emptyCount",{"_43":155,"_32":156,"_30":157,"_135":-5,"_41":42,"_40":146,"_137":123,"_38":269,"_13":139,"_33":153,"_35":-5,"_24":25,"_142":-5,"_185":270,"_27":271},{"_43":261,"_32":262,"_30":263,"_135":157,"_41":42,"_40":264,"_137":25,"_38":265,"_13":230,"_33":140,"_35":266,"_24":25,"_142":-5,"_185":267,"_27":268},{"_43":253,"_32":254,"_30":255,"_135":157,"_41":42,"_40":256,"_137":25,"_38":257,"_13":139,"_33":140,"_35":258,"_24":25,"_142":-5,"_185":259,"_27":260},{"_43":148,"_32":149,"_30":150,"_135":-5,"_41":42,"_40":151,"_137":123,"_38":250,"_13":139,"_33":153,"_35":-5,"_24":25,"_142":-5,"_185":251,"_27":252},{"_43":242,"_32":243,"_30":244,"_135":150,"_41":42,"_40":245,"_137":123,"_38":246,"_13":213,"_33":20,"_35":247,"_24":25,"_142":-5,"_185":248,"_27":249},{"_43":234,"_32":235,"_30":236,"_135":150,"_41":42,"_40":237,"_137":25,"_38":238,"_13":213,"_33":140,"_35":239,"_24":25,"_142":-5,"_185":240,"_27":241},{"_43":225,"_32":226,"_30":227,"_135":150,"_41":42,"_40":228,"_137":123,"_38":229,"_13":230,"_33":140,"_35":231,"_24":25,"_142":-5,"_185":232,"_27":233},{"_43":217,"_32":218,"_30":219,"_135":150,"_41":42,"_40":220,"_137":123,"_38":221,"_13":213,"_33":20,"_35":222,"_24":25,"_142":-5,"_185":223,"_27":224},{"_43":208,"_32":209,"_30":210,"_135":150,"_41":42,"_40":211,"_137":123,"_38":212,"_13":213,"_33":20,"_35":214,"_24":25,"_142":-5,"_185":215,"_27":216},{"_43":200,"_32":201,"_30":202,"_135":150,"_41":42,"_40":203,"_137":25,"_38":204,"_13":139,"_33":140,"_35":205,"_24":25,"_142":-5,"_185":206,"_27":207},{"_43":191,"_32":192,"_30":193,"_135":150,"_41":42,"_40":194,"_137":25,"_38":195,"_13":196,"_33":20,"_35":197,"_24":25,"_142":-5,"_185":198,"_27":199},{"_43":144,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_137":25,"_38":188,"_13":146,"_33":34,"_35":37,"_24":25,"_142":-5,"_185":189,"_27":190},{"_43":132,"_32":133,"_30":134,"_135":-5,"_41":42,"_40":136,"_137":123,"_38":184,"_13":139,"_33":140,"_35":141,"_24":25,"_142":-5,"_185":186,"_27":187},["D",1773068165714],"children",[],[133],["D",1773073525452],[],[28],"cf937552-1bcb-11f1-87fd-42dde27851f2","styles.css","cc03b950-1bc7-11f1-be07-42dde27851f2",52,["D",1773069759988],5,"/* 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 --gold: #ffd700;\n --silver: #c0c0c0;\n --bronze: #cd7f32;\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 min-height: 200px;\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 cursor: pointer;\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 border-color: var(--accent);\n}\n\n.player-card.dragging {\n opacity: 0.4;\n}\n\n.player-card.drag-over {\n border-top: 2px solid var(--accent);\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.player-action {\n flex-shrink: 0;\n font-size: 1.1rem;\n color: var(--text-muted);\n transition: color 0.15s;\n}\n\n.player-card:hover .player-action {\n color: var(--accent);\n}\n\n/* Rank number in the right column */\n.player-rank {\n min-width: 24px;\n height: 24px;\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.72rem;\n font-weight: 700;\n flex-shrink: 0;\n}\n\n/* Drag handle for reordering */\n.drag-handle {\n cursor: grab;\n color: var(--text-muted);\n font-size: 1rem;\n flex-shrink: 0;\n padding: 0 4px;\n}\n\n.drag-handle:active {\n cursor: grabbing;\n}\n\n.remove-btn {\n background: none;\n border: none;\n color: var(--text-muted);\n cursor: pointer;\n font-size: 1rem;\n padding: 2px 4px;\n border-radius: 4px;\n transition: color 0.15s, background 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}\n\n/* Reorder buttons */\n.reorder-btns {\n display: flex;\n flex-direction: column;\n gap: 1px;\n flex-shrink: 0;\n}\n\n.reorder-btn {\n background: none;\n border: none;\n color: var(--text-muted);\n cursor: pointer;\n font-size: 0.7rem;\n padding: 1px 4px;\n line-height: 1;\n border-radius: 3px;\n transition: color 0.15s, background 0.15s;\n}\n\n.reorder-btn:hover {\n color: var(--accent);\n background: rgba(77, 166, 255, 0.1);\n}\n\n.reorder-btn:disabled {\n opacity: 0.2;\n cursor: default;\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-number.slot-1 {\n background: var(--gold);\n color: #000;\n}\n.slot-number.slot-2 {\n background: var(--silver);\n color: #000;\n}\n.slot-number.slot-3 {\n background: var(--bronze);\n color: #fff;\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}",[],[149,192],"fe5d7454-1bc7-11f1-b769-42dde27851f2","results.tsx","c6b6a0b6-1bc7-11f1-912e-42dde27851f2",38,["D",1773068120501],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n// Public draft results page — viewable by anyone after the draft is executed.\n// Reuses the same result display as the admin panel but without admin controls.\n// 2026-03-09\n\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 (same as admin.tsx) ----\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// ---- App ----\n\nfunction ResultsApp() {\n const [result, setResult] = useState(null);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(\"\");\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) {\n setResult(data.result as DraftResult);\n }\n })\n .catch((err) => setError(err.message))\n .finally(() => setLoading(false));\n }, []);\n\n if (loading) return

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();",[],[149,201],"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",[],[149,209],"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",[],[149,218],"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();",[],[149,226],"89a561fa-1bd4-11f1-916b-42dde27851f2","admin.tsx","b0d4eaf0-1bc7-11f1-b180-42dde27851f2",54,["D",1773073508134],"/** @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 {/* Results */}\n {result && }\n \n );\n}\n\n// ---- Mount ----\n\ncreateRoot(document.getElementById(\"root\")!).render();",[],[149,235],"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",[],[149,243],["D",1773067909348],[175,176,177,178,179,180,181],[149],"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}",[],[156,254],"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}",[],[156,262],["D",1773067917271],[172,173],[156],["D",1773067822232],["D",1789518676100],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_125":310,"_311":312,"_313":314,"_315":25,"_316":25,"_317":25,"_318":123,"_319":-5,"_320":-7,"_321":-7,"_322":60,"_323":25,"_324":25,"_325":-5,"_326":25,"_327":25,"_328":25,"_329":-5},"ENV",{"_281":282,"_283":284,"_285":87,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309},"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 · v55