[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_279":280,"_281":282},"routes/_app.x.$handle.$name",{"_97":96,"_31":44,"_105":87,"_26":99,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":122,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_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":24},"version",11,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","src/games/roulette.ts","latestPath","fileId","cec5d264-5505-11f1-a3cc-ee650bb23af1","name","roulette.ts","fileType","script","content","// European single-zero roulette. Pure logic — no I/O.\n// Numbers 0..36. 0 is green; everything else is red or black per RED_NUMBERS.\n\nimport type { ActionResult, Game, ResolveResult } from \"./game.ts\";\n\nexport type Color = \"red\" | \"black\" | \"green\";\n\nexport type RouletteBet =\n | { kind: \"straight\"; number: number; amount: number }\n | { kind: \"color\"; color: \"red\" | \"black\"; amount: number }\n | { kind: \"parity\"; parity: \"even\" | \"odd\"; amount: number }\n | { kind: \"range\"; range: \"low\" | \"high\"; amount: number }\n | { kind: \"dozen\"; dozen: 1 | 2 | 3; amount: number }\n | { kind: \"column\"; column: 1 | 2 | 3; amount: number };\n\nexport type RoulettePhase = \"betting\" | \"resolved\";\n\nexport interface RouletteResult {\n number: number;\n color: Color;\n}\n\nexport interface RouletteState {\n phase: RoulettePhase;\n hostId: number;\n bets: Record;\n lastResult?: RouletteResult;\n}\n\nexport type RouletteAction =\n | { type: \"place_bet\"; bet: RouletteBet }\n | { type: \"clear_bets\" }\n | { type: \"spin\" }\n | { type: \"new_round\" };\n\nconst RED_NUMBERS: ReadonlySet = new Set([\n 1, 3, 5, 7, 9, 12, 14, 16, 18, 19, 21, 23, 25, 27, 30, 32, 34, 36,\n]);\n\nexport function colorOf(n: number): Color {\n if (n === 0) return \"green\";\n return RED_NUMBERS.has(n) ? \"red\" : \"black\";\n}\n\nexport const MIN_BET = 1;\nexport const MAX_BET_PER_USER = 1000;\n\nfunction isValidBet(bet: RouletteBet): boolean {\n if (!Number.isInteger(bet.amount) || bet.amount < MIN_BET) return false;\n switch (bet.kind) {\n case \"straight\":\n return Number.isInteger(bet.number) && bet.number >= 0 && bet.number <= 36;\n case \"color\":\n return bet.color === \"red\" || bet.color === \"black\";\n case \"parity\":\n return bet.parity === \"even\" || bet.parity === \"odd\";\n case \"range\":\n return bet.range === \"low\" || bet.range === \"high\";\n case \"dozen\":\n return bet.dozen === 1 || bet.dozen === 2 || bet.dozen === 3;\n case \"column\":\n return bet.column === 1 || bet.column === 2 || bet.column === 3;\n }\n}\n\n// Returns total chips the bet returns if it wins (including original stake).\n// 0 means the bet lost.\nfunction payoutFor(bet: RouletteBet, n: number): number {\n if (n === 0) {\n return bet.kind === \"straight\" && bet.number === 0\n ? bet.amount * 36\n : 0;\n }\n const c = colorOf(n);\n switch (bet.kind) {\n case \"straight\":\n return bet.number === n ? bet.amount * 36 : 0;\n case \"color\":\n return bet.color === c ? bet.amount * 2 : 0;\n case \"parity\": {\n const isEven = n % 2 === 0;\n const win = bet.parity === \"even\" ? isEven : !isEven;\n return win ? bet.amount * 2 : 0;\n }\n case \"range\": {\n const isLow = n >= 1 && n <= 18;\n const win = bet.range === \"low\" ? isLow : !isLow;\n return win ? bet.amount * 2 : 0;\n }\n case \"dozen\": {\n const which = n <= 12 ? 1 : n <= 24 ? 2 : 3;\n return which === bet.dozen ? bet.amount * 3 : 0;\n }\n case \"column\": {\n const which = (n % 3 === 1 ? 1 : n % 3 === 2 ? 2 : 3) as 1 | 2 | 3;\n return which === bet.column ? bet.amount * 3 : 0;\n }\n }\n}\n\nfunction sumBets(bets: RouletteBet[]): number {\n return bets.reduce((s, b) => s + b.amount, 0);\n}\n\nfunction spinNumber(): number {\n // Cryptographically random 0..36 inclusive, rejection-sampled to remove modulo bias.\n const buf = new Uint32Array(1);\n const max = 0xffffffff - (0xffffffff % 37);\n while (true) {\n crypto.getRandomValues(buf);\n if (buf[0] <= max) return buf[0] % 37;\n }\n}\n\nexport const roulette: Game = {\n type: \"roulette\",\n\n initialState(hostId) {\n return {\n phase: \"betting\",\n hostId,\n bets: {},\n };\n },\n\n applyAction(state, userId, action): ActionResult {\n switch (action.type) {\n case \"place_bet\": {\n if (state.phase !== \"betting\") {\n throw new Error(\"not in betting phase\");\n }\n if (!isValidBet(action.bet)) {\n throw new Error(\"invalid bet\");\n }\n const userBets = state.bets[userId] ?? [];\n const newTotal = sumBets(userBets) + action.bet.amount;\n if (newTotal > MAX_BET_PER_USER) {\n throw new Error(\"over per-round bet cap\");\n }\n const next: RouletteState = {\n ...state,\n bets: {\n ...state.bets,\n [userId]: [...userBets, action.bet],\n },\n };\n return {\n state: next,\n events: [{\n type: \"bet.placed\",\n payload: { userId, bet: action.bet },\n }],\n balanceDeltas: { [userId]: -action.bet.amount },\n };\n }\n case \"clear_bets\": {\n if (state.phase !== \"betting\") {\n throw new Error(\"not in betting phase\");\n }\n const userBets = state.bets[userId] ?? [];\n const refund = sumBets(userBets);\n const next = { ...state, bets: { ...state.bets } };\n delete next.bets[userId];\n return {\n state: next,\n events: [{\n type: \"bet.cleared\",\n payload: { userId, refund },\n }],\n balanceDeltas: refund > 0 ? { [userId]: refund } : {},\n };\n }\n case \"spin\": {\n if (userId !== state.hostId) throw new Error(\"only host can spin\");\n if (state.phase !== \"betting\") {\n throw new Error(\"not in betting phase\");\n }\n const n = spinNumber();\n const c = colorOf(n);\n const payouts: Record = {};\n for (const [uidStr, userBets] of Object.entries(state.bets)) {\n const uid = Number(uidStr);\n const total = userBets.reduce((s, b) => s + payoutFor(b, n), 0);\n if (total > 0) payouts[uid] = total;\n }\n const next: RouletteState = {\n ...state,\n phase: \"resolved\",\n lastResult: { number: n, color: c },\n };\n const events = [\n { type: \"spin.result\", payload: { number: n, color: c } },\n { type: \"round.payouts\", payload: { payouts } },\n ];\n return { state: next, events, balanceDeltas: payouts };\n }\n case \"new_round\": {\n if (userId !== state.hostId) throw new Error(\"only host can start round\");\n if (state.phase !== \"resolved\") {\n throw new Error(\"can only start new round after resolved\");\n }\n const next: RouletteState = {\n phase: \"betting\",\n hostId: state.hostId,\n bets: {},\n lastResult: state.lastResult,\n };\n return {\n state: next,\n events: [{ type: \"round.new\", payload: {} }],\n balanceDeltas: {},\n };\n }\n }\n },\n\n resolveRound(state): ResolveResult {\n return { state, events: [], payouts: {} };\n },\n};\n","createdAt",["D",1779361885725],"branchVersion","branchId","f271ad2e-5504-11f1-8d02-ee650bb23af1","id","f270f12c-5504-11f1-8d02-ee650bb23af1","grimbucks",["D",1779361516091],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Play-money multiplayer roulette for you and your friends.","imageUrl","bf1ab65a-0279-420f-9c6a-ea12f493f97b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e4a12-e65b-716a-84f7-2b4d6198cd25","tursoName","f270f12c550411f18d02ee650bb23af1","tursoHostname","f270f12c550411f18d02ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789489305251],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":99},"org",{"_97":96,"_98":99,"_100":99,"_18":54,"_101":102,"_103":24},"branch",{"_13":86,"_31":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"isOwned",74,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","grimsalabim","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_31":44,"_37":274,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":275,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":276,"_81":277,"_83":278,"_85":24},"tree",[166,179,180],"files",[166,167,168,169,170,171,172,173,174,175,176,177,178,179,180],"counts",{"_156":60,"_157":137,"_158":60,"_159":160,"_161":162},"contents",[127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_42":149,"_31":150,"_29":151,"_133":-5,"_40":41,"_39":152,"_135":122,"_37":153,"_13":60,"_33":154,"_35":-5,"_23":24,"_140":-5,"_26":155},{"_42":142,"_31":143,"_29":144,"_133":-5,"_40":41,"_39":145,"_135":122,"_37":146,"_13":60,"_33":20,"_35":147,"_23":24,"_140":-5,"_26":148},{"_42":130,"_31":131,"_29":132,"_133":-5,"_40":41,"_39":134,"_135":122,"_37":136,"_13":137,"_33":138,"_35":139,"_23":24,"_140":44,"_26":141},"66cc3f4a-5505-11f1-aaa7-ee650bb23af1","main.tsx","f277b26e-5504-11f1-8d02-ee650bb23af1","parentId",2,"latest",["D",1779361711293],1,"http","// HTTP entry. Actual app lives in src/index.ts.\nexport { default } from \"./src/index.ts\";\n","label",[131],"7be7f270-5505-11f1-a1d1-ee650bb23af1","deno.json","7be7f324-5505-11f1-a1d1-ee650bb23af1",3,["D",1779361746705],"{\n \"imports\": {\n \"hono\": \"npm:hono@^4.6.0\",\n \"hono/cookie\": \"npm:hono@^4.6.0/cookie\",\n \"hono/streaming\": \"npm:hono@^4.6.0/streaming\",\n \"bcryptjs\": \"npm:bcryptjs@^2.4.3\",\n \"valtown/sqlite\": \"https://esm.town/v/std/sqlite\"\n }\n}\n",[143],"80cbe13e-5505-11f1-8113-ee650bb23af1","src","e2afea23-9cf1-4c46-ad89-983464fe99aa",4,["D",1779361754893],"directory",[150],"pulls","branches","forks","envVars",{"_163":60,"_165":60},"connections",{"_163":60,"_164":60},"count","unfilledCount","emptyCount",{"_42":149,"_31":150,"_29":151,"_133":-5,"_40":41,"_39":152,"_135":122,"_37":271,"_13":60,"_33":154,"_35":-5,"_23":24,"_140":-5,"_182":272,"_26":273},{"_42":267,"_31":258,"_29":252,"_133":151,"_40":41,"_39":253,"_135":122,"_37":268,"_13":60,"_33":154,"_35":-5,"_23":24,"_140":-5,"_182":269,"_26":270},{"_42":259,"_31":260,"_29":261,"_133":252,"_40":41,"_39":262,"_135":24,"_37":263,"_13":60,"_33":34,"_35":264,"_23":24,"_140":-5,"_182":265,"_26":266},{"_42":249,"_31":250,"_29":251,"_133":252,"_40":41,"_39":253,"_135":24,"_37":254,"_13":60,"_33":34,"_35":255,"_23":24,"_140":-5,"_182":256,"_26":257},{"_42":245,"_31":244,"_29":238,"_133":151,"_40":41,"_39":239,"_135":122,"_37":246,"_13":60,"_33":154,"_35":-5,"_23":24,"_140":-5,"_182":247,"_26":248},{"_42":235,"_31":236,"_29":237,"_133":238,"_40":41,"_39":239,"_135":122,"_37":240,"_13":60,"_33":34,"_35":241,"_23":24,"_140":-5,"_182":242,"_26":243},{"_42":231,"_31":222,"_29":216,"_133":151,"_40":41,"_39":226,"_135":122,"_37":232,"_13":60,"_33":154,"_35":-5,"_23":24,"_140":-5,"_182":233,"_26":234},{"_42":223,"_31":224,"_29":225,"_133":216,"_40":41,"_39":226,"_135":24,"_37":227,"_13":60,"_33":34,"_35":228,"_23":24,"_140":-5,"_182":229,"_26":230},{"_42":213,"_31":214,"_29":215,"_133":216,"_40":41,"_39":217,"_135":24,"_37":218,"_13":60,"_33":34,"_35":219,"_23":24,"_140":-5,"_182":220,"_26":221},{"_42":209,"_31":200,"_29":196,"_133":151,"_40":41,"_39":204,"_135":122,"_37":210,"_13":60,"_33":154,"_35":-5,"_23":24,"_140":-5,"_182":211,"_26":212},{"_42":201,"_31":202,"_29":203,"_133":196,"_40":41,"_39":204,"_135":122,"_37":205,"_13":60,"_33":34,"_35":206,"_23":24,"_140":-5,"_182":207,"_26":208},{"_42":195,"_31":32,"_29":30,"_133":196,"_40":41,"_39":14,"_135":122,"_37":197,"_13":60,"_33":34,"_35":36,"_23":24,"_140":-5,"_182":198,"_26":199},{"_42":188,"_31":189,"_29":190,"_133":151,"_40":41,"_39":152,"_135":24,"_37":191,"_13":60,"_33":34,"_35":192,"_23":24,"_140":-5,"_182":193,"_26":194},{"_42":142,"_31":143,"_29":144,"_133":-5,"_40":41,"_39":145,"_135":122,"_37":185,"_13":60,"_33":20,"_35":147,"_23":24,"_140":-5,"_182":186,"_26":187},{"_42":130,"_31":131,"_29":132,"_133":-5,"_40":41,"_39":134,"_135":122,"_37":181,"_13":137,"_33":138,"_35":139,"_23":24,"_140":44,"_182":183,"_26":184},["D",1779361711293],"children",[],[131],["D",1779361746705],[],[143],"80cbbec0-5505-11f1-8113-ee650bb23af1","index.ts","80cbbf6a-5505-11f1-8113-ee650bb23af1",["D",1779361754893],"import { Hono } from \"hono\";\nimport { migrate } from \"./db/migrate.ts\";\nimport { authRoutes } from \"./auth/routes.ts\";\nimport { friendsRoutes } from \"./friends/routes.ts\";\nimport { roomsRoutes } from \"./rooms/routes.ts\";\nimport { sseHandler } from \"./rooms/sse.ts\";\nimport { landingPage } from \"./ui/pages/landing.ts\";\nimport { homePage } from \"./ui/pages/home.ts\";\nimport { getSession } from \"./auth/session.ts\";\nimport { CLIENT_BUNDLE } from \"./static/client/bundle.ts\";\n\nawait migrate();\n\nconst app = new Hono();\n\napp.get(\"/static/client/roulette.js\", (c) => {\n c.header(\"Content-Type\", \"application/javascript\");\n c.header(\"Cache-Control\", \"public, max-age=300\");\n return c.body(CLIENT_BUNDLE);\n});\n\napp.get(\"/\", async (c) => {\n const session = await getSession(c);\n if (session) return c.redirect(\"/home\");\n return c.html(landingPage());\n});\n\napp.route(\"/auth\", authRoutes);\napp.route(\"/friends\", friendsRoutes);\napp.route(\"/rooms\", roomsRoutes);\n\napp.get(\"/home\", async (c) => {\n const session = await getSession(c);\n if (!session) return c.redirect(\"/\");\n return c.html(await homePage(session.user));\n});\n\napp.get(\"/api/sse/:roomId\", sseHandler);\n\nexport default app.fetch;\n",[],[150,189],"cec5d192-5505-11f1-a3cc-ee650bb23af1","8ee6e4ce-0a84-45ce-83f1-b6d71b7461d8",["D",1779361885725],[],[150,200,32],"games","bb8492d0-5505-11f1-af15-ee650bb23af1","game.ts","bb8493ac-5505-11f1-af15-ee650bb23af1",10,["D",1779361853425],"// Shared Game abstraction so additional games (blackjack, etc.)\n// can slot into the room/SSE/action plumbing without changes there.\n\nexport interface GameEvent {\n type: string;\n payload: unknown;\n}\n\nexport interface ActionResult {\n state: S;\n events: GameEvent[];\n balanceDeltas: Record;\n}\n\nexport interface ResolveResult {\n state: S;\n events: GameEvent[];\n payouts: Record;\n}\n\nexport interface Game {\n type: string;\n initialState(hostId: number): S;\n applyAction(state: S, userId: number, action: A): ActionResult;\n resolveRound(state: S): ResolveResult;\n}\n",[],[150,200,202],"bb84b5bc-5505-11f1-af15-ee650bb23af1",["D",1779361853425],[176,177],[150,200],"a4fa0c02-5505-11f1-a8cf-ee650bb23af1","queries.ts","a4fa0ca2-5505-11f1-a8cf-ee650bb23af1","b63de110-65d6-4da5-a757-980369fb0498",6,["D",1779361815618],"import { sqlite } from \"valtown/sqlite\";\n\n// Val Town sqlite returns { columns, rows } with rows as arrays.\n// rowsAs maps them into plain objects keyed by column name.\ntype ExecuteResult = { columns: string[]; rows: unknown[][] };\n\ntype SqlArg = string | number | boolean | null;\n\nasync function rowsAs(\n sql: string,\n args: SqlArg[] = [],\n): Promise {\n const res = (await sqlite.execute({ sql, args })) as ExecuteResult;\n return res.rows.map(\n (row) =>\n Object.fromEntries(res.columns.map((c, i) => [c, row[i]])) as T,\n );\n}\n\nasync function rowAs(sql: string, args: SqlArg[] = []): Promise {\n const rows = await rowsAs(sql, args);\n return rows[0] ?? null;\n}\n\nasync function exec(sql: string, args: SqlArg[] = []): Promise {\n await sqlite.execute({ sql, args });\n}\n\n// -------- users --------\n\nexport interface User {\n id: number;\n username: string;\n password_hash: string;\n balance: number;\n last_topup_at: string | null;\n created_at: string;\n}\n\nexport const findUserByUsername = (username: string) =>\n rowAs(\"SELECT * FROM users WHERE username = ?\", [username]);\n\nexport const findUserById = (id: number) =>\n rowAs(\"SELECT * FROM users WHERE id = ?\", [id]);\n\nexport async function createUser(\n username: string,\n passwordHash: string,\n): Promise {\n await exec(\n \"INSERT INTO users (username, password_hash) VALUES (?, ?)\",\n [username, passwordHash],\n );\n const u = await findUserByUsername(username);\n if (!u) throw new Error(\"user not found after insert\");\n return u;\n}\n\nexport async function adjustBalance(\n userId: number,\n delta: number,\n reason: string,\n): Promise {\n await exec(\n \"UPDATE users SET balance = balance + ? WHERE id = ?\",\n [delta, userId],\n );\n // Audit row in the events log uses room_id = 0 for global / cross-room events.\n await exec(\n \"INSERT INTO events (room_id, type, payload) VALUES (?, ?, ?)\",\n [0, \"balance.adjust\", JSON.stringify({ userId, delta, reason })],\n );\n const u = await findUserById(userId);\n return u?.balance ?? 0;\n}\n\nexport const setLastTopupAt = (userId: number, isoDate: string) =>\n exec(\"UPDATE users SET last_topup_at = ?, balance = 1000 WHERE id = ?\", [\n isoDate,\n userId,\n ]);\n\n// -------- sessions --------\n\nexport interface Session {\n token: string;\n user_id: number;\n expires_at: string;\n}\n\nexport const createSession = (\n token: string,\n userId: number,\n expiresAt: string,\n) =>\n exec(\n \"INSERT INTO sessions (token, user_id, expires_at) VALUES (?, ?, ?)\",\n [token, userId, expiresAt],\n );\n\nexport const findSessionByToken = (token: string) =>\n rowAs(\n \"SELECT * FROM sessions WHERE token = ? AND expires_at > datetime('now')\",\n [token],\n );\n\nexport const deleteSession = (token: string) =>\n exec(\"DELETE FROM sessions WHERE token = ?\", [token]);\n\n// -------- friendships --------\n\nexport interface Friendship {\n user_a: number;\n user_b: number;\n status: \"pending\" | \"accepted\";\n created_at: string;\n}\n\nexport const findFriendshipPair = (a: number, b: number) =>\n rowAs(\n `SELECT * FROM friendships\n WHERE (user_a = ? AND user_b = ?) OR (user_a = ? AND user_b = ?)`,\n [a, b, b, a],\n );\n\nexport const createFriendRequest = (requesterId: number, addresseeId: number) =>\n exec(\n \"INSERT INTO friendships (user_a, user_b, status) VALUES (?, ?, 'pending')\",\n [requesterId, addresseeId],\n );\n\nexport const acceptFriendRequest = (requesterId: number, addresseeId: number) =>\n exec(\n `UPDATE friendships SET status = 'accepted'\n WHERE user_a = ? AND user_b = ? AND status = 'pending'`,\n [requesterId, addresseeId],\n );\n\nexport const listFriends = (userId: number) =>\n rowsAs<{ id: number; username: string }>(\n `SELECT u.id, u.username FROM users u\n JOIN friendships f ON (f.user_a = u.id AND f.user_b = ?)\n OR (f.user_b = u.id AND f.user_a = ?)\n WHERE f.status = 'accepted'`,\n [userId, userId],\n );\n\nexport const listPendingIncoming = (userId: number) =>\n rowsAs<{ id: number; username: string }>(\n `SELECT u.id, u.username FROM users u\n JOIN friendships f ON f.user_a = u.id\n WHERE f.user_b = ? AND f.status = 'pending'`,\n [userId],\n );\n\n// -------- rooms --------\n\nexport interface Room {\n id: number;\n game_type: string;\n host_id: number;\n status: \"open\" | \"round_active\" | \"closed\";\n state_json: string;\n created_at: string;\n}\n\nexport async function createRoom(\n gameType: string,\n hostId: number,\n stateJson: string,\n): Promise {\n const res = (await sqlite.execute({\n sql:\n \"INSERT INTO rooms (game_type, host_id, status, state_json) VALUES (?, ?, 'open', ?) RETURNING *\",\n args: [gameType, hostId, stateJson],\n })) as ExecuteResult;\n const row = res.rows[0];\n return Object.fromEntries(\n res.columns.map((c, i) => [c, row[i]]),\n ) as unknown as Room;\n}\n\nexport const findRoomById = (id: number) =>\n rowAs(\"SELECT * FROM rooms WHERE id = ?\", [id]);\n\nexport const updateRoomState = (\n id: number,\n status: Room[\"status\"],\n stateJson: string,\n) =>\n exec(\"UPDATE rooms SET status = ?, state_json = ? WHERE id = ?\", [\n status,\n stateJson,\n id,\n ]);\n\nexport async function addRoomMember(\n roomId: number,\n userId: number,\n): Promise {\n const seat = await rowAs<{ next_seat: number }>(\n \"SELECT COALESCE(MAX(seat), -1) + 1 AS next_seat FROM room_members WHERE room_id = ?\",\n [roomId],\n );\n const s = seat?.next_seat ?? 0;\n await exec(\n \"INSERT OR IGNORE INTO room_members (room_id, user_id, seat) VALUES (?, ?, ?)\",\n [roomId, userId, s],\n );\n return s;\n}\n\nexport const listRoomMembers = (roomId: number) =>\n rowsAs<{ user_id: number; seat: number; username: string }>(\n `SELECT rm.user_id, rm.seat, u.username\n FROM room_members rm\n JOIN users u ON u.id = rm.user_id\n WHERE rm.room_id = ?\n ORDER BY rm.seat`,\n [roomId],\n );\n\nexport const isRoomMember = async (roomId: number, userId: number) => {\n const r = await rowAs<{ n: number }>(\n \"SELECT COUNT(*) AS n FROM room_members WHERE room_id = ? AND user_id = ?\",\n [roomId, userId],\n );\n return (r?.n ?? 0) > 0;\n};\n\n// -------- invites --------\n\nexport interface Invite {\n id: number;\n room_id: number;\n from_user: number;\n to_user: number;\n status: \"pending\" | \"accepted\" | \"declined\" | \"expired\";\n created_at: string;\n}\n\nexport const createInvite = (\n roomId: number,\n fromUser: number,\n toUser: number,\n) =>\n exec(\n \"INSERT INTO invites (room_id, from_user, to_user, status) VALUES (?, ?, ?, 'pending')\",\n [roomId, fromUser, toUser],\n );\n\nexport const listPendingInvitesFor = (userId: number) =>\n rowsAs(\n `SELECT i.*, u.username AS from_username, r.game_type\n FROM invites i\n JOIN users u ON u.id = i.from_user\n JOIN rooms r ON r.id = i.room_id\n WHERE i.to_user = ? AND i.status = 'pending'\n ORDER BY i.created_at DESC`,\n [userId],\n );\n\nexport const acceptInviteById = (id: number, toUser: number) =>\n exec(\n `UPDATE invites SET status = 'accepted'\n WHERE id = ? AND to_user = ? AND status = 'pending'`,\n [id, toUser],\n );\n\nexport const findInviteById = (id: number) =>\n rowAs(\"SELECT * FROM invites WHERE id = ?\", [id]);\n\n// -------- events --------\n\nexport interface EventRow {\n id: number;\n room_id: number;\n type: string;\n payload: string;\n created_at: string;\n}\n\nexport async function appendEvent(\n roomId: number,\n type: string,\n payload: unknown,\n): Promise {\n const res = (await sqlite.execute({\n sql:\n \"INSERT INTO events (room_id, type, payload) VALUES (?, ?, ?) RETURNING *\",\n args: [roomId, type, JSON.stringify(payload)],\n })) as ExecuteResult;\n return Object.fromEntries(\n res.columns.map((c, i) => [c, res.rows[0][i]]),\n ) as unknown as EventRow;\n}\n\nexport const readEventsSince = (roomId: number, sinceId: number) =>\n rowsAs(\n \"SELECT * FROM events WHERE room_id = ? AND id > ? ORDER BY id ASC LIMIT 500\",\n [roomId, sinceId],\n );\n\nexport const latestEventId = async (roomId: number) => {\n const r = await rowAs<{ max_id: number | null }>(\n \"SELECT MAX(id) AS max_id FROM events WHERE room_id = ?\",\n [roomId],\n );\n return r?.max_id ?? 0;\n};\n",[],[150,222,214],"db","8b9110e4-5505-11f1-9c88-ee650bb23af1","migrate.ts","8b9111ca-5505-11f1-9c88-ee650bb23af1",5,["D",1779361772979],"import { sqlite } from \"valtown/sqlite\";\n\n// Schema kept inline (rather than reading schema.sql at runtime) so it works\n// inside Val Town's sandboxed Deno runtime without filesystem access.\n// schema.sql in this directory mirrors this for human reference.\nconst SCHEMA: readonly string[] = [\n `CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL UNIQUE,\n password_hash TEXT NOT NULL,\n balance INTEGER NOT NULL DEFAULT 1000,\n last_topup_at TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS sessions (\n token TEXT PRIMARY KEY,\n user_id INTEGER NOT NULL,\n expires_at TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE INDEX IF NOT EXISTS idx_sessions_user ON sessions(user_id)`,\n `CREATE TABLE IF NOT EXISTS friendships (\n user_a INTEGER NOT NULL,\n user_b INTEGER NOT NULL,\n status TEXT NOT NULL CHECK (status IN ('pending','accepted')),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE UNIQUE INDEX IF NOT EXISTS uq_friendships_pair ON friendships(user_a, user_b)`,\n `CREATE INDEX IF NOT EXISTS idx_friendships_user_b ON friendships(user_b)`,\n `CREATE TABLE IF NOT EXISTS rooms (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n game_type TEXT NOT NULL,\n host_id INTEGER NOT NULL,\n status TEXT NOT NULL CHECK (status IN ('open','round_active','closed')),\n state_json TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS invites (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n room_id INTEGER NOT NULL,\n from_user INTEGER NOT NULL,\n to_user INTEGER NOT NULL,\n status TEXT NOT NULL CHECK (status IN ('pending','accepted','declined','expired')),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE INDEX IF NOT EXISTS idx_invites_to_user ON invites(to_user, status)`,\n `CREATE TABLE IF NOT EXISTS room_members (\n room_id INTEGER NOT NULL,\n user_id INTEGER NOT NULL,\n seat INTEGER NOT NULL,\n joined_at TEXT NOT NULL DEFAULT (datetime('now')),\n PRIMARY KEY (room_id, user_id)\n )`,\n `CREATE TABLE IF NOT EXISTS events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n room_id INTEGER NOT NULL,\n type TEXT NOT NULL,\n payload TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE INDEX IF NOT EXISTS idx_events_room ON events(room_id, id)`,\n];\n\nlet migrated = false;\n\nexport async function migrate(): Promise {\n if (migrated) return;\n for (const stmt of SCHEMA) {\n await sqlite.execute(stmt);\n }\n migrated = true;\n}\n",[],[150,222,224],"8b912c5a-5505-11f1-9c88-ee650bb23af1",["D",1779361772979],[173,174],[150,222],"b6657e86-5505-11f1-a774-ee650bb23af1","economy.ts","b6657f58-5505-11f1-a774-ee650bb23af1","8bef8c6b-58e1-4bb8-bc1e-6c7f544f00fd",9,["D",1779361844836],"import {\n findUserById,\n setLastTopupAt,\n type User,\n} from \"../db/queries.ts\";\n\nconst DAILY_TOPUP_AMOUNT = 1000;\nconst DAILY_TOPUP_THRESHOLD = 100;\n\nconst todayIso = () => new Date().toISOString().slice(0, 10);\n\n// Called on login. If the user is broke and hasn't topped up today,\n// restore them to 1000 chips and stamp last_topup_at.\nexport async function maybeDailyTopup(userId: number): Promise {\n const user = await findUserById(userId);\n if (!user) return null;\n const today = todayIso();\n if (user.balance < DAILY_TOPUP_THRESHOLD && user.last_topup_at !== today) {\n await setLastTopupAt(userId, today);\n return await findUserById(userId);\n }\n return user;\n}\n\nexport { DAILY_TOPUP_AMOUNT, DAILY_TOPUP_THRESHOLD };\n",[],[150,244,236],"chips","b6658dcc-5505-11f1-a774-ee650bb23af1",["D",1779361844836],[171],[150,244],"ab0bfc22-5505-11f1-a7f7-ee650bb23af1","session.ts","ab0bfd08-5505-11f1-a7f7-ee650bb23af1","0e48d6ca-54f7-4624-ab37-00a23d56ad37",7,["D",1779361825793],"import type { Context } from \"hono\";\nimport { getCookie, setCookie, deleteCookie } from \"hono/cookie\";\nimport {\n createSession as dbCreateSession,\n deleteSession as dbDeleteSession,\n findSessionByToken,\n findUserById,\n type User,\n} from \"../db/queries.ts\";\n\nconst COOKIE_NAME = \"gb_session\";\nconst SESSION_TTL_SECONDS = 60 * 60 * 24 * 30; // 30 days\n\nfunction randomToken(): string {\n const bytes = new Uint8Array(32);\n crypto.getRandomValues(bytes);\n return Array.from(bytes, (b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nexport async function startSession(c: Context, userId: number): Promise {\n const token = randomToken();\n const expiresAt = new Date(Date.now() + SESSION_TTL_SECONDS * 1000)\n .toISOString();\n await dbCreateSession(token, userId, expiresAt);\n setCookie(c, COOKIE_NAME, token, {\n httpOnly: true,\n sameSite: \"Lax\",\n secure: true,\n path: \"/\",\n maxAge: SESSION_TTL_SECONDS,\n });\n}\n\nexport async function endSession(c: Context): Promise {\n const token = getCookie(c, COOKIE_NAME);\n if (token) await dbDeleteSession(token);\n deleteCookie(c, COOKIE_NAME, { path: \"/\" });\n}\n\nexport interface ActiveSession {\n token: string;\n user: User;\n}\n\n// Returns the active session or null. Caller decides whether to redirect.\nexport async function getSession(c: Context): Promise {\n const token = getCookie(c, COOKIE_NAME);\n if (!token) return null;\n const row = await findSessionByToken(token);\n if (!row) return null;\n const user = await findUserById(row.user_id);\n if (!user) return null;\n return { token, user };\n}\n",[],[150,258,250],"auth","b22bb362-5505-11f1-a774-ee650bb23af1","routes.ts","b22bb40c-5505-11f1-a774-ee650bb23af1",8,["D",1779361837749],"import { Hono } from \"hono\";\nimport bcrypt from \"bcryptjs\";\nimport {\n createUser,\n findUserByUsername,\n} from \"../db/queries.ts\";\nimport { endSession, startSession } from \"./session.ts\";\nimport { maybeDailyTopup } from \"../chips/economy.ts\";\n\nconst USERNAME_RE = /^[a-zA-Z0-9_]{3,20}$/;\nconst MIN_PASSWORD = 6;\n\nexport const authRoutes = new Hono();\n\nauthRoutes.post(\"/signup\", async (c) => {\n const form = await c.req.formData();\n const username = String(form.get(\"username\") ?? \"\").trim();\n const password = String(form.get(\"password\") ?? \"\");\n if (!USERNAME_RE.test(username)) {\n return c.html(errorPage(\"Username must be 3–20 letters, numbers or _\"), 400);\n }\n if (password.length < MIN_PASSWORD) {\n return c.html(errorPage(\"Password must be at least 6 characters\"), 400);\n }\n const existing = await findUserByUsername(username);\n if (existing) {\n return c.html(errorPage(\"Username taken\"), 400);\n }\n const hash = await bcrypt.hash(password, 10);\n const user = await createUser(username, hash);\n await startSession(c, user.id);\n return c.redirect(\"/home\");\n});\n\nauthRoutes.post(\"/login\", async (c) => {\n const form = await c.req.formData();\n const username = String(form.get(\"username\") ?? \"\").trim();\n const password = String(form.get(\"password\") ?? \"\");\n const user = await findUserByUsername(username);\n if (!user) {\n return c.html(errorPage(\"Invalid username or password\"), 400);\n }\n const ok = await bcrypt.compare(password, user.password_hash);\n if (!ok) {\n return c.html(errorPage(\"Invalid username or password\"), 400);\n }\n await maybeDailyTopup(user.id);\n await startSession(c, user.id);\n return c.redirect(\"/home\");\n});\n\nauthRoutes.post(\"/logout\", async (c) => {\n await endSession(c);\n return c.redirect(\"/\");\n});\n\nfunction errorPage(message: string): string {\n return `\n
${escapeHtml(message)}
\n
Back
\n `;\n}\n\nfunction escapeHtml(s: string): string {\n return s\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n",[],[150,258,260],"ab0c3318-5505-11f1-a7f7-ee650bb23af1",["D",1779361825793],[168,169],[150,258],["D",1779361754893],[167,170,172,175,178],[150],["D",1779361516091],["D",1789489305251],{"_97":96,"_104":99},{"_97":96,"_98":99,"_100":99,"_18":54,"_101":102,"_103":24},{"_13":86,"_31":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"ctx",{"_79":-5,"_124":312,"_313":314,"_315":316,"_317":24,"_318":24,"_319":24,"_320":122,"_321":-5,"_322":-7,"_323":-7,"_324":60,"_325":24,"_326":24,"_327":-5,"_328":24,"_329":24,"_330":24,"_331":-5},"ENV",{"_283":284,"_285":286,"_287":87,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311},"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 · v11