[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_188":189,"_190":191},"routes/_app.x.$handle.$name",{"_107":106,"_38":55,"_116":97,"_33":117,"_13":14,"_118":-5,"_11":119,"_120":121,"_122":123,"_124":125,"_126":127,"_27":-5,"_128":-5,"_129":-5,"_130":31,"_131":132,"_133":69,"_134":-5,"_135":-5,"_136":137},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_53":54,"_38":55,"_43":56,"_57":-5,"_58":31,"_59":60,"_61":60,"_62":63,"_64":-5,"_19":65,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":73,"_74":75,"_76":-5,"_77":-5,"_78":-5,"_79":-5,"_80":81,"_82":81,"_83":84,"_85":84,"_86":84,"_87":81,"_88":81,"_89":90,"_91":92,"_93":94,"_95":31},"version",2,"changes",[25,26],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","7fe0db1a-fcde-439f-87da-6bebf1321445","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_27":48,"_29":-7,"_30":31,"_32":31,"_33":49,"_35":49},{"_27":28,"_29":-7,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":39,"_40":27,"_41":42,"_43":44,"_45":14,"_46":47,"_30":31},"previous","deleted",false,"deletedHere","path","frontend/index.html","latestPath","fileId","74eeffec-5be8-11f1-bb46-ee650bb23af1","name","index.html","fileType","content","\n\n\n \n \n 🏈 Gameday Squares\n \n\n\n

🏈 Gameday Squares

Pick your squares, draw the numbers, win the pool.

\n\n

\n \n \n

\n\n \n\n

\n\n

\n Open\n Taken\n Yours\n

\n\n

\n \n \n

\n\n

\n \n\n\n","createdAt",["D",1780118937735],"branchVersion","branchId","5bba3708-5be8-11f1-baa9-ee650bb23af1",{"_36":50,"_38":49,"_40":51,"_41":-5,"_43":52,"_45":14,"_46":47,"_30":31},"frontend","543cb3a3-1040-4bb1-bce8-ba04b64195a4","directory",["D",1780118937735],"id","5bb963fa-5be8-11f1-baa9-ee650bb23af1","gameday-squares",["D",1780118895460],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Football squares pool game grid","imageUrl","82e4e894-7768-49c7-9a60-138c502ee79a","pinnedFileId","6807c11a-5be8-11f1-84d7-ee650bb23af1","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e7759-e2d4-727d-9886-151e47d314d3","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_107":106,"_115":111},"org",{"_107":106,"_108":109,"_110":111,"_19":65,"_112":113,"_114":31},"branch",{"_13":96,"_38":97,"_53":47,"_98":54,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":55,"_105":106},"isOwned",11,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","smash","handle","displayName","nicholastotaro","avatar","https://avatars.githubusercontent.com/u/245603800?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_53":54,"_38":55,"_43":184,"_57":-5,"_58":31,"_59":60,"_61":60,"_62":63,"_64":-5,"_19":65,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":73,"_74":75,"_76":-5,"_77":-5,"_78":-5,"_79":-5,"_80":81,"_82":81,"_83":84,"_85":84,"_86":84,"_87":81,"_88":81,"_89":185,"_91":186,"_93":187,"_95":31},"tree",[162,164],"files",[162,163,164,165],"counts",{"_152":73,"_153":149,"_154":73,"_155":156,"_157":158},"contents",[138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_53":146,"_38":147,"_36":148,"_141":-5,"_46":47,"_45":149,"_142":69,"_43":150,"_13":73,"_40":51,"_41":-5,"_30":31,"_144":-5,"_33":151},{"_53":140,"_38":49,"_36":50,"_141":-5,"_46":47,"_45":14,"_142":69,"_43":143,"_13":73,"_40":51,"_41":-5,"_30":31,"_144":-5,"_33":145},"74ef3be2-5be8-11f1-bb46-ee650bb23af1","parentId","latest",["D",1780118937735],"label",[49],"6807f96e-5be8-11f1-84d7-ee650bb23af1","backend","a8b44d52-6eee-4b44-b78f-e99f8945f6e9",1,["D",1780118916090],[147],"pulls","branches","forks","envVars",{"_159":73,"_161":73},"connections",{"_159":73,"_160":73},"count","unfilledCount","emptyCount",{"_53":146,"_38":147,"_36":148,"_141":-5,"_46":47,"_45":149,"_142":69,"_43":181,"_13":73,"_40":51,"_41":-5,"_30":31,"_144":-5,"_168":182,"_33":183},{"_53":174,"_38":175,"_36":67,"_141":148,"_46":47,"_45":149,"_142":31,"_43":176,"_13":73,"_40":177,"_41":178,"_30":31,"_144":-5,"_168":179,"_33":180},{"_53":140,"_38":49,"_36":50,"_141":-5,"_46":47,"_45":14,"_142":69,"_43":171,"_13":73,"_40":51,"_41":-5,"_30":31,"_144":-5,"_168":172,"_33":173},{"_53":166,"_38":39,"_36":37,"_141":50,"_46":47,"_45":14,"_142":31,"_43":167,"_13":73,"_40":27,"_41":42,"_30":31,"_144":-5,"_168":169,"_33":170},"74eefee8-5be8-11f1-bb46-ee650bb23af1",["D",1780118937735],"children",[],[49,39],["D",1780118937735],[165],[49],"6807c052-5be8-11f1-84d7-ee650bb23af1","index.ts",["D",1780118916090],"http","import { Hono } from \"npm:hono@4\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst app = new Hono();\nconst TABLE = \"squares_v1\";\n\n// --- DB setup ---\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE} (\n pos INTEGER PRIMARY KEY,\n name TEXT NOT NULL,\n claimed_at TEXT NOT NULL\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE}_meta (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n)`);\n\nasync function getMeta(key: string): Promise {\n const r = await sqlite.execute({\n sql: `SELECT value FROM ${TABLE}_meta WHERE key = ?`,\n args: [key],\n });\n return r.rows.length ? String(r.rows[0][0]) : null;\n}\n\n// --- API ---\napp.get(\"/api/state\", async (c) => {\n const r = await sqlite.execute(`SELECT pos, name FROM ${TABLE}`);\n const squares = r.rows.map((row) => ({ pos: row[0], name: row[1] }));\n const rowNums = await getMeta(\"rowNums\");\n const colNums = await getMeta(\"colNums\");\n return c.json({\n squares,\n rowNums: rowNums ? JSON.parse(rowNums) : null,\n colNums: colNums ? JSON.parse(colNums) : null,\n rowTeam: (await getMeta(\"rowTeam\")) ?? \"Home\",\n colTeam: (await getMeta(\"colTeam\")) ?? \"Away\",\n });\n});\n\napp.post(\"/api/claim\", async (c) => {\n const { pos, name } = await c.req.json();\n if (typeof pos !== \"number\" || pos < 0 || pos > 99 || !name?.trim()) {\n return c.json({ error: \"Invalid input\" }, 400);\n }\n if (await getMeta(\"rowNums\")) {\n return c.json({ error: \"Numbers already drawn — board is locked.\" }, 403);\n }\n try {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (pos, name, claimed_at) VALUES (?, ?, ?)`,\n args: [pos, name.trim().slice(0, 24), new Date().toISOString()],\n });\n } catch {\n return c.json({ error: \"Square already taken!\" }, 409);\n }\n return c.json({ ok: true });\n});\n\napp.post(\"/api/unclaim\", async (c) => {\n const { pos } = await c.req.json();\n if (await getMeta(\"rowNums\")) {\n return c.json({ error: \"Board is locked.\" }, 403);\n }\n await sqlite.execute({ sql: `DELETE FROM ${TABLE} WHERE pos = ?`, args: [pos] });\n return c.json({ ok: true });\n});\n\napp.post(\"/api/teams\", async (c) => {\n const { rowTeam, colTeam } = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE}_meta (key, value) VALUES ('rowTeam', ?)\n ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n args: [String(rowTeam ?? \"Home\").slice(0, 20)],\n });\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE}_meta (key, value) VALUES ('colTeam', ?)\n ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n args: [String(colTeam ?? \"Away\").slice(0, 20)],\n });\n return c.json({ ok: true });\n});\n\nfunction shuffle(): number[] {\n const a = [0, 1, 2, 3, 4, 5, 6, 7, 8, 9];\n for (let i = a.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [a[i], a[j]] = [a[j], a[i]];\n }\n return a;\n}\n\napp.post(\"/api/draw\", async (c) => {\n if (await getMeta(\"rowNums\")) return c.json({ error: \"Already drawn.\" }, 403);\n const rowNums = shuffle();\n const colNums = shuffle();\n for (const [k, v] of [[\"rowNums\", rowNums], [\"colNums\", colNums]]) {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE}_meta (key, value) VALUES (?, ?)`,\n args: [k as string, JSON.stringify(v)],\n });\n }\n return c.json({ rowNums, colNums });\n});\n\napp.post(\"/api/reset\", async (c) => {\n await sqlite.execute(`DELETE FROM ${TABLE}`);\n await sqlite.execute(`DELETE FROM ${TABLE}_meta`);\n return c.json({ ok: true });\n});\n\n// --- Static frontend ---\napp.get(\"/\", async (c) => {\n return c.html(await readFile(\"/frontend/index.html\", import.meta.url));\n});\napp.get(\"/frontend/app.js\", (c) => serveFile(\"/frontend/app.js\", import.meta.url));\n\nexport default app.fetch;\n",[],[147,175],["D",1780118916090],[163],[147],["D",1780118895460],{"_107":106,"_115":111},{"_107":106,"_108":109,"_110":111,"_19":65,"_112":113,"_114":31},{"_13":96,"_38":97,"_53":47,"_98":54,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":55,"_105":106},"ctx",{"_89":-5,"_135":221,"_222":223,"_224":225,"_226":31,"_227":31,"_228":31,"_229":69,"_230":-5,"_231":-7,"_232":-7,"_233":73,"_234":31,"_235":31,"_236":-5,"_237":31,"_238":31,"_239":31,"_240":-5},"ENV",{"_192":193,"_194":195,"_196":97,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220},"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 · v2