[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_415":416,"_417":418},"routes/_app.x.$handle.$name",{"_99":98,"_32":46,"_107":89,"_27":101,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":124,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":-5,"_58":25,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",27,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","src/db/queries.ts","latestPath","fileId","a4fa0ca2-5505-11f1-a8cf-ee650bb23af1","name","queries.ts","fileType","script","content","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","import { sqlite } from \"https://esm.town/v/std/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","createdAt",["D",1779362915182],"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",{"_99":98,"_106":101},"org",{"_99":98,"_100":101,"_102":101,"_18":56,"_103":104,"_105":25},"branch",{"_13":88,"_32":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"isOwned",74,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","grimsalabim","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_44":45,"_32":46,"_39":410,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":-5,"_58":25,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":411,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":412,"_83":413,"_85":414,"_87":25},"tree",[168,197,198],"files",[168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198],"counts",{"_158":62,"_159":139,"_160":62,"_161":162,"_163":164},"contents",[129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_44":151,"_32":152,"_30":153,"_135":-5,"_42":43,"_41":154,"_137":124,"_39":155,"_13":62,"_34":156,"_36":-5,"_24":25,"_142":-5,"_27":157},{"_44":144,"_32":145,"_30":146,"_135":-5,"_42":43,"_41":147,"_137":124,"_39":148,"_13":62,"_34":20,"_36":149,"_24":25,"_142":-5,"_27":150},{"_44":132,"_32":133,"_30":134,"_135":-5,"_42":43,"_41":136,"_137":124,"_39":138,"_13":139,"_34":140,"_36":141,"_24":25,"_142":46,"_27":143},"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",[133],"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",[145],"80cbe13e-5505-11f1-8113-ee650bb23af1","src","e2afea23-9cf1-4c46-ad89-983464fe99aa",4,["D",1779361754893],"directory",[152],"pulls","branches","forks","envVars",{"_165":62,"_167":62},"connections",{"_165":62,"_166":62},"count","unfilledCount","emptyCount",{"_44":151,"_32":152,"_30":153,"_135":-5,"_42":43,"_41":154,"_137":124,"_39":407,"_13":62,"_34":156,"_36":-5,"_24":25,"_142":-5,"_200":408,"_27":409},{"_44":403,"_32":395,"_30":389,"_135":153,"_42":43,"_41":390,"_137":124,"_39":404,"_13":62,"_34":156,"_36":-5,"_24":25,"_142":-5,"_200":405,"_27":406},{"_44":396,"_32":289,"_30":397,"_135":389,"_42":43,"_41":398,"_137":25,"_39":399,"_13":62,"_34":35,"_36":400,"_24":25,"_142":-5,"_200":401,"_27":402},{"_44":386,"_32":387,"_30":388,"_135":389,"_42":43,"_41":390,"_137":25,"_39":391,"_13":62,"_34":35,"_36":392,"_24":25,"_142":-5,"_200":393,"_27":394},{"_44":382,"_32":381,"_30":375,"_135":153,"_42":43,"_41":376,"_137":124,"_39":383,"_13":62,"_34":156,"_36":-5,"_24":25,"_142":-5,"_200":384,"_27":385},{"_44":372,"_32":373,"_30":374,"_135":375,"_42":43,"_41":376,"_137":124,"_39":377,"_13":62,"_34":35,"_36":378,"_24":25,"_142":-5,"_200":379,"_27":380},{"_44":367,"_32":358,"_30":354,"_135":153,"_42":43,"_41":368,"_137":124,"_39":369,"_13":62,"_34":156,"_36":-5,"_24":25,"_142":-5,"_200":370,"_27":371},{"_44":359,"_32":360,"_30":361,"_135":354,"_42":43,"_41":362,"_137":25,"_39":363,"_13":139,"_34":35,"_36":364,"_24":25,"_142":-5,"_200":365,"_27":366},{"_44":353,"_32":33,"_30":31,"_135":354,"_42":43,"_41":14,"_137":25,"_39":355,"_13":139,"_34":35,"_36":38,"_24":25,"_142":-5,"_200":356,"_27":357},{"_44":348,"_32":347,"_30":341,"_135":153,"_42":43,"_41":349,"_137":124,"_39":350,"_13":62,"_34":156,"_36":-5,"_24":25,"_142":-5,"_200":351,"_27":352},{"_44":339,"_32":289,"_30":340,"_135":341,"_42":43,"_41":342,"_137":25,"_39":343,"_13":139,"_34":35,"_36":344,"_24":25,"_142":-5,"_200":345,"_27":346},{"_44":335,"_32":318,"_30":312,"_135":153,"_42":43,"_41":330,"_137":124,"_39":336,"_13":62,"_34":156,"_36":-5,"_24":25,"_142":-5,"_200":337,"_27":338},{"_44":327,"_32":328,"_30":329,"_135":312,"_42":43,"_41":330,"_137":124,"_39":331,"_13":62,"_34":35,"_36":332,"_24":25,"_142":-5,"_200":333,"_27":334},{"_44":319,"_32":320,"_30":321,"_135":312,"_42":43,"_41":322,"_137":124,"_39":323,"_13":62,"_34":35,"_36":324,"_24":25,"_142":-5,"_200":325,"_27":326},{"_44":309,"_32":310,"_30":311,"_135":312,"_42":43,"_41":313,"_137":124,"_39":314,"_13":62,"_34":35,"_36":315,"_24":25,"_142":-5,"_200":316,"_27":317},{"_44":304,"_32":287,"_30":281,"_135":153,"_42":43,"_41":305,"_137":124,"_39":306,"_13":62,"_34":156,"_36":-5,"_24":25,"_142":-5,"_200":307,"_27":308},{"_44":296,"_32":297,"_30":298,"_135":281,"_42":43,"_41":299,"_137":124,"_39":300,"_13":139,"_34":35,"_36":301,"_24":25,"_142":-5,"_200":302,"_27":303},{"_44":288,"_32":289,"_30":290,"_135":281,"_42":43,"_41":291,"_137":25,"_39":292,"_13":139,"_34":35,"_36":293,"_24":25,"_142":-5,"_200":294,"_27":295},{"_44":278,"_32":279,"_30":280,"_135":281,"_42":43,"_41":282,"_137":25,"_39":283,"_13":62,"_34":35,"_36":284,"_24":25,"_142":-5,"_200":285,"_27":286},{"_44":274,"_32":267,"_30":270,"_135":153,"_42":43,"_41":262,"_137":124,"_39":275,"_13":62,"_34":156,"_36":-5,"_24":25,"_142":-5,"_200":276,"_27":277},{"_44":269,"_32":268,"_30":261,"_135":270,"_42":43,"_41":262,"_137":124,"_39":271,"_13":62,"_34":156,"_36":-5,"_24":25,"_142":-5,"_200":272,"_27":273},{"_44":258,"_32":259,"_30":260,"_135":261,"_42":43,"_41":262,"_137":25,"_39":263,"_13":62,"_34":35,"_36":264,"_24":25,"_142":-5,"_200":265,"_27":266},{"_44":254,"_32":223,"_30":217,"_135":153,"_42":43,"_41":218,"_137":124,"_39":255,"_13":62,"_34":156,"_36":-5,"_24":25,"_142":-5,"_200":256,"_27":257},{"_44":250,"_32":233,"_30":227,"_135":217,"_42":43,"_41":237,"_137":124,"_39":251,"_13":62,"_34":156,"_36":-5,"_24":25,"_142":-5,"_200":252,"_27":253},{"_44":242,"_32":243,"_30":244,"_135":227,"_42":43,"_41":245,"_137":25,"_39":246,"_13":62,"_34":35,"_36":247,"_24":25,"_142":-5,"_200":248,"_27":249},{"_44":234,"_32":235,"_30":236,"_135":227,"_42":43,"_41":237,"_137":124,"_39":238,"_13":62,"_34":35,"_36":239,"_24":25,"_142":-5,"_200":240,"_27":241},{"_44":224,"_32":225,"_30":226,"_135":227,"_42":43,"_41":228,"_137":25,"_39":229,"_13":62,"_34":35,"_36":230,"_24":25,"_142":-5,"_200":231,"_27":232},{"_44":214,"_32":215,"_30":216,"_135":217,"_42":43,"_41":218,"_137":25,"_39":219,"_13":62,"_34":35,"_36":220,"_24":25,"_142":-5,"_200":221,"_27":222},{"_44":206,"_32":207,"_30":208,"_135":153,"_42":43,"_41":209,"_137":25,"_39":210,"_13":139,"_34":35,"_36":211,"_24":25,"_142":-5,"_200":212,"_27":213},{"_44":144,"_32":145,"_30":146,"_135":-5,"_42":43,"_41":147,"_137":124,"_39":203,"_13":62,"_34":20,"_36":149,"_24":25,"_142":-5,"_200":204,"_27":205},{"_44":132,"_32":133,"_30":134,"_135":-5,"_42":43,"_41":136,"_137":124,"_39":199,"_13":139,"_34":140,"_36":141,"_24":25,"_142":46,"_200":201,"_27":202},["D",1779361711293],"children",[],[133],["D",1779361746705],[],[145],"2769448a-5508-11f1-8966-ee650bb23af1","index.ts","80cbbf6a-5505-11f1-8113-ee650bb23af1",22,["D",1779362893433],"import { Hono } from \"npm:hono@^4.6.0\";\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",[],[152,207],"fff15d54-5505-11f1-a554-ee650bb23af1","layout.ts","fff15e1c-5505-11f1-a554-ee650bb23af1","2da62fa6-8f85-4a45-a76e-210cd378c0d8",17,["D",1779361968229],"export interface LayoutProps {\n title: string;\n body: string;\n balance?: number;\n username?: string;\n}\n\nexport function layout({ title, body, balance, username }: LayoutProps): string {\n const header = username !== undefined\n ? `

\n grimbucks\n

\n @${escapeHtml(username)}\n 🪙 ${balance ?? 0}\n \n

`\n : \"\";\n\n return `\n\n\n\n\n${escapeHtml(title)} · grimbucks\n\n\n\n\n${header}\n

\n${body}\n

\n\n`;\n}\n\nexport function escapeHtml(s: string | number): string {\n return String(s)\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n",[],[152,223,215],"ui","208590c6-5506-11f1-a1d1-ee650bb23af1","room.ts","20859166-5506-11f1-a1d1-ee650bb23af1","a7c2974e-e88e-40e8-97f8-9dd92cc62ea9",20,["D",1779362022891],"import { escapeHtml, layout } from \"../layout.ts\";\nimport type { User } from \"../../db/queries.ts\";\nimport type { RouletteState } from \"../../games/roulette.ts\";\n\nexport interface RoomPageProps {\n user: User;\n roomId: number;\n hostId: number;\n members: { user_id: number; seat: number; username: string }[];\n friends: { id: number; username: string }[];\n state: RouletteState;\n latestEventId: number;\n}\n\nexport function roomPage(props: RoomPageProps): string {\n const { user, roomId, hostId, members, friends, state, latestEventId } = props;\n\n const isHost = user.id === hostId;\n const invitableFriends = friends.filter(\n (f) => !members.some((m) => m.user_id === f.id),\n );\n\n const memberList = members.map((m) => `\n

\n @${escapeHtml(m.username)}${\n m.user_id === hostId ? ' host' : \"\"\n }\n seat ${m.seat}\n

`).join(\"\");\n\n const inviteForm = invitableFriends.length === 0\n ? \"\"\n : ``;\n\n const lastResultHtml = state.lastResult\n ? `

last spin

${state.lastResult.number}

${state.lastResult.color}

`\n : \"\";\n\n const body = `\n

\n ← home\n\n

room #${roomId}

Roulette

phase

${state.phase}

\n\n ${lastResultHtml}\n\n \n

\n\n

Players

\n ${memberList}\n

\n\n ${inviteForm}\n

\n\n\n`;\n\n return layout({\n title: `room #${roomId}`,\n body,\n balance: user.balance,\n username: user.username,\n });\n}\n\nfunction colorCss(c: \"red\" | \"black\" | \"green\"): string {\n return c === \"red\" ? \"#ef4444\" : c === \"black\" ? \"#e7e5e4\" : \"#10b981\";\n}\n",[],[152,223,233,225],"pages","07b52c32-5506-11f1-9912-ee650bb23af1","landing.ts","07b52cd2-5506-11f1-9912-ee650bb23af1",18,["D",1779361981258],"import { layout } from \"../layout.ts\";\n\nexport function landingPage(): string {\n const body = `\n

grimbucks

play-money roulette with your friends

\n\n

\n \n\n \n

\n`;\n return layout({ title: \"welcome\", body });\n}\n",[],[152,223,233,235],"13901f9e-5506-11f1-8c41-ee650bb23af1","home.ts","13902052-5506-11f1-8c41-ee650bb23af1",19,["D",1779362001142],"import { escapeHtml, layout } from \"../layout.ts\";\nimport {\n listFriends,\n listPendingIncoming,\n listPendingInvitesFor,\n type User,\n} from \"../../db/queries.ts\";\n\nexport async function homePage(user: User): Promise {\n const [friends, pendingFriends, invites] = await Promise.all([\n listFriends(user.id),\n listPendingIncoming(user.id),\n listPendingInvitesFor(user.id),\n ]);\n\n const inviteList = invites.length === 0\n ? `

No room invites.

`\n : invites.map((inv) =>\n ``\n ).join(\"\");\n\n const pendingFriendList = pendingFriends.length === 0\n ? \"\"\n : `

Pending friend requests

\n ${\n pendingFriends.map((p) =>\n ``\n ).join(\"\")\n }\n

`;\n\n const friendsList = friends.length === 0\n ? `

No friends yet. Add some.

`\n : friends.map((f) =>\n `

\n @${escapeHtml(f.username)}\n

`\n ).join(\"\");\n\n const body = `\n

\n\n

balance

🪙 ${user.balance}

\n \n

\n\n

Invites

\n ${inviteList}\n

\n\n ${pendingFriendList}\n\n

Friends

\n manage →\n

\n ${friendsList}\n

\n\n

\n`;\n return layout({\n title: \"home\",\n body,\n balance: user.balance,\n username: user.username,\n });\n}\n",[],[152,223,233,243],"07b5575c-5506-11f1-9912-ee650bb23af1",["D",1779361981258],[192,193,194],[152,223,233],"fff191b6-5505-11f1-a554-ee650bb23af1",["D",1779361968229],[191,195],[152,223],"47b249a0-5506-11f1-82b6-ee650bb23af1","bundle.ts","47b24a5e-5506-11f1-82b6-ee650bb23af1","fdb50a95-278e-455c-bfdc-5b1763c94624",21,["D",1779362088608],"// Concatenated, transpiled-already (plain JS) client bundle served at\n// /static/client/roulette.js. Kept as a TS string export so it works in\n// Val Town's Deno runtime without filesystem reads or unstable text imports.\n\nexport const CLIENT_BUNDLE = String.raw`\n\"use strict\";\n(function () {\n const RED_NUMBERS = new Set([\n 1, 3, 5, 7, 9, 12, 14, 16, 18, 19, 21, 23, 25, 27, 30, 32, 34, 36,\n ]);\n\n function colorOf(n) {\n if (n === 0) return \"green\";\n return RED_NUMBERS.has(n) ? \"red\" : \"black\";\n }\n\n const WHEEL_ORDER = [\n 0, 32, 15, 19, 4, 21, 2, 25, 17, 34, 6, 27, 13, 36, 11, 30, 8, 23, 10, 5,\n 24, 16, 33, 1, 20, 14, 31, 9, 22, 18, 29, 7, 28, 12, 35, 3, 26,\n ];\n\n function connectSse(url, initialEventId, onEvent) {\n const target = initialEventId > 0\n ? url + (url.includes(\"?\") ? \"&\" : \"?\") + \"since=\" + initialEventId\n : url;\n const es = new EventSource(target);\n const types = [\n \"open\", \"state.snapshot\", \"bet.placed\", \"bet.cleared\",\n \"spin.result\", \"round.payouts\", \"round.new\",\n ];\n for (const type of types) {\n es.addEventListener(type, (ev) => {\n try {\n const data = ev.data ? JSON.parse(ev.data) : null;\n onEvent({ type, data });\n } catch (e) { /* ignore */ }\n });\n }\n return { close: () => es.close() };\n }\n\n function mount(root) {\n const data = {\n roomId: Number(root.dataset.roomId),\n userId: Number(root.dataset.userId),\n isHost: root.dataset.isHost === \"true\",\n };\n const initialEventId = Number(root.dataset.lastEventId || 0);\n const ui = renderUI(root, data);\n let pendingAmount = 10;\n\n ui.amountButtons.forEach((b) => {\n b.addEventListener(\"click\", () => {\n pendingAmount = Number(b.dataset.amount);\n ui.amountButtons.forEach((x) => x.classList.toggle(\"ring-2\", x === b));\n });\n });\n ui.amountButtons[1] && ui.amountButtons[1].classList.add(\"ring-2\");\n\n ui.betButtons.forEach((b) => {\n b.addEventListener(\"click\", async () => {\n const bet = parseBet(b, pendingAmount);\n if (!bet) return;\n await postAction(data.roomId, { type: \"place_bet\", bet });\n });\n });\n\n if (ui.clearBtn) {\n ui.clearBtn.addEventListener(\"click\", async () => {\n await postAction(data.roomId, { type: \"clear_bets\" });\n });\n }\n\n if (ui.spinBtn) {\n ui.spinBtn.addEventListener(\"click\", async () => {\n ui.spinBtn.disabled = true;\n try { await postAction(data.roomId, { type: \"spin\" }); }\n finally {\n setTimeout(() => { if (ui.spinBtn) ui.spinBtn.disabled = false; }, 5000);\n }\n });\n }\n\n if (ui.newRoundBtn) {\n ui.newRoundBtn.addEventListener(\"click\", async () => {\n await postAction(data.roomId, { type: \"new_round\" });\n });\n }\n\n connectSse(\"/api/sse/\" + data.roomId, initialEventId, (ev) => handleEvent(ev, ui, data));\n }\n\n function renderUI(root, data) {\n const rouletteRoot = document.getElementById(\"roulette-root\");\n const amounts = [1, 10, 50, 100, 500];\n const amountHtml = amounts.map((v) =>\n ''\n ).join(\"\");\n\n const straightHtml = [];\n for (let n = 0; n <= 36; n++) {\n const c = colorOf(n);\n const bg = c === \"red\" ? \"bg-red-600\" : c === \"black\" ? \"bg-stone-700\" : \"bg-emerald-600\";\n straightHtml.push('');\n }\n\n rouletteRoot.innerHTML = [\n '

',\n '

',\n ' ',\n '

place your bets

',\n '

', amountHtml, '

',\n '

',\n ' ',\n ' ',\n ' ',\n ' ',\n ' ',\n ' ',\n ' ',\n ' ',\n ' ',\n ' ',\n ' ',\n ' ',\n '

',\n '

Bet on a single number (35:1)

',\n '

', straightHtml.join(\"\"), '

',\n '

',\n ' ',\n data.isHost\n ? ' '\n : '

Waiting for host…

',\n '

',\n data.isHost\n ? '

'\n : '',\n '

'\n ].join(\"\");\n\n drawWheel(document.getElementById(\"wheel\"), null);\n\n return {\n betButtons: Array.from(rouletteRoot.querySelectorAll(\".bet-btn\")),\n amountButtons: Array.from(rouletteRoot.querySelectorAll(\".amount-btn\")),\n clearBtn: rouletteRoot.querySelector(\"#clear-btn\"),\n spinBtn: rouletteRoot.querySelector(\"#spin-btn\"),\n newRoundBtn: rouletteRoot.querySelector(\"#new-round-btn\"),\n resultEl: rouletteRoot.querySelector(\"#result-display\"),\n betSummaryEl: rouletteRoot.querySelector(\"#bet-summary\"),\n phaseEl: root.querySelector(\"[data-phase]\"),\n };\n }\n\n function parseBet(b, amount) {\n const kind = b.dataset.betKind;\n if (!kind) return null;\n switch (kind) {\n case \"color\": return { kind, color: b.dataset.betColor, amount };\n case \"parity\": return { kind, parity: b.dataset.betParity, amount };\n case \"range\": return { kind, range: b.dataset.betRange, amount };\n case \"dozen\": return { kind, dozen: Number(b.dataset.betDozen), amount };\n case \"column\": return { kind, column: Number(b.dataset.betColumn), amount };\n case \"straight\": return { kind, number: Number(b.dataset.betNumber), amount };\n }\n return null;\n }\n\n async function postAction(roomId, action) {\n const r = await fetch(\"/rooms/\" + roomId + \"/action\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(action),\n });\n if (!r.ok) {\n const text = await r.text().catch(() => \"\");\n console.warn(\"action failed:\", r.status, text);\n flashError(text || (\"request failed (\" + r.status + \")\"));\n }\n }\n\n function flashError(msg) {\n const el = document.createElement(\"div\");\n el.className = \"fixed bottom-4 left-4 right-4 bg-red-900/95 text-red-100 rounded-xl px-3 py-2 text-sm shadow-lg\";\n el.textContent = String(msg).slice(0, 200);\n document.body.appendChild(el);\n setTimeout(() => el.remove(), 2500);\n }\n\n function drawWheel(svg, highlight) {\n svg.innerHTML = \"\";\n const ns = \"http://www.w3.org/2000/svg\";\n const slice = (2 * Math.PI) / 37;\n for (let i = 0; i < 37; i++) {\n const n = WHEEL_ORDER[i];\n const a0 = -Math.PI / 2 + i * slice;\n const a1 = a0 + slice;\n const r = 95;\n const x0 = Math.cos(a0) * r;\n const y0 = Math.sin(a0) * r;\n const x1 = Math.cos(a1) * r;\n const y1 = Math.sin(a1) * r;\n const path = document.createElementNS(ns, \"path\");\n path.setAttribute(\"d\", \"M 0 0 L \" + x0.toFixed(2) + \" \" + y0.toFixed(2) + \" A \" + r + \" \" + r + \" 0 0 1 \" + x1.toFixed(2) + \" \" + y1.toFixed(2) + \" Z\");\n const c = colorOf(n);\n path.setAttribute(\"fill\", c === \"red\" ? \"#dc2626\" : c === \"black\" ? \"#1c1917\" : \"#059669\");\n path.setAttribute(\"stroke\", \"#44403c\");\n path.setAttribute(\"stroke-width\", \"0.5\");\n svg.appendChild(path);\n const labelAngle = a0 + slice / 2;\n const lx = Math.cos(labelAngle) * (r - 12);\n const ly = Math.sin(labelAngle) * (r - 12);\n const t = document.createElementNS(ns, \"text\");\n t.setAttribute(\"x\", lx.toFixed(2));\n t.setAttribute(\"y\", ly.toFixed(2));\n t.setAttribute(\"fill\", \"white\");\n t.setAttribute(\"font-size\", \"8\");\n t.setAttribute(\"text-anchor\", \"middle\");\n t.setAttribute(\"dominant-baseline\", \"middle\");\n t.textContent = String(n);\n svg.appendChild(t);\n }\n const c = document.createElementNS(ns, \"circle\");\n c.setAttribute(\"r\", \"12\");\n c.setAttribute(\"fill\", \"#1c1917\");\n c.setAttribute(\"stroke\", \"#a8a29e\");\n svg.appendChild(c);\n if (highlight !== null) {\n const idx = WHEEL_ORDER.indexOf(highlight);\n if (idx >= 0) {\n const angle = -Math.PI / 2 + (idx + 0.5) * slice;\n const ax = Math.cos(angle) * 100;\n const ay = Math.sin(angle) * 100;\n const m = document.createElementNS(ns, \"circle\");\n m.setAttribute(\"cx\", ax.toFixed(2));\n m.setAttribute(\"cy\", ay.toFixed(2));\n m.setAttribute(\"r\", \"6\");\n m.setAttribute(\"fill\", \"#fbbf24\");\n svg.appendChild(m);\n }\n }\n }\n\n function handleEvent(ev, ui, data) {\n const payload = (ev.data && typeof ev.data === \"object\" && \"payload\" in ev.data)\n ? ev.data.payload : null;\n switch (ev.type) {\n case \"bet.placed\":\n case \"bet.cleared\": {\n ui.betSummaryEl.textContent = ev.type === \"bet.placed\" ? \"bet placed.\" : \"bets cleared.\";\n setTimeout(() => { ui.betSummaryEl.textContent = \"\"; }, 1500);\n break;\n }\n case \"spin.result\": {\n animateSpin(payload.number);\n ui.resultEl.textContent = \"🎲 \" + payload.number + \" (\" + payload.color + \")\";\n if (ui.phaseEl) ui.phaseEl.textContent = \"resolved\";\n if (data.isHost && ui.newRoundBtn) ui.newRoundBtn.classList.remove(\"hidden\");\n if (ui.spinBtn) ui.spinBtn.disabled = true;\n break;\n }\n case \"round.payouts\": {\n const mine = payload.payouts[String(data.userId)] || 0;\n if (mine > 0) ui.resultEl.textContent += \" — you won \" + mine + \" 🪙!\";\n setTimeout(() => location.reload(), 3500);\n break;\n }\n case \"round.new\": {\n ui.resultEl.textContent = \"place your bets\";\n if (ui.phaseEl) ui.phaseEl.textContent = \"betting\";\n if (ui.newRoundBtn) ui.newRoundBtn.classList.add(\"hidden\");\n if (ui.spinBtn) ui.spinBtn.disabled = false;\n break;\n }\n }\n }\n\n function animateSpin(finalNumber) {\n const svg = document.getElementById(\"wheel\");\n if (!svg) return;\n const idx = WHEEL_ORDER.indexOf(finalNumber);\n const slice = 360 / 37;\n const target = -idx * slice - slice / 2;\n const totalRotation = 360 * 5 + target;\n svg.style.transition = \"transform 4s cubic-bezier(0.16, 1, 0.3, 1)\";\n svg.style.transform = \"rotate(\" + totalRotation + \"deg)\";\n setTimeout(() => {\n svg.style.transition = \"none\";\n drawWheel(svg, finalNumber);\n svg.style.transform = \"rotate(0deg)\";\n }, 4200);\n }\n\n function init() {\n const root = document.querySelector(\"[data-room-id]\");\n if (root) mount(root);\n }\n if (document.readyState === \"loading\") {\n document.addEventListener(\"DOMContentLoaded\", init);\n } else {\n init();\n }\n})();\n`;\n",[],[152,267,268,259],"static","client","47b2ded8-5506-11f1-82b6-ee650bb23af1","ee2752f7-e516-4df8-a0a5-60da32ce9b42",["D",1779362088608],[189],[152,267,268],"47b2d83e-5506-11f1-82b6-ee650bb23af1",["D",1779362088608],[188],[152,267],"ef42775e-5505-11f1-af15-ee650bb23af1","sse.ts","ef4278d0-5505-11f1-af15-ee650bb23af1","eb3b9e4d-4b1e-4f9e-87ee-0d09964d8485",15,["D",1779361940239],"import type { Context } from \"hono\";\nimport { streamSSE } from \"hono/streaming\";\nimport { getSession } from \"../auth/session.ts\";\nimport { isRoomMember, readEventsSince } from \"../db/queries.ts\";\n\n// Val Town caps a single request at ~60s. Close just under that so the client\n// reconnects cleanly with Last-Event-ID instead of being killed mid-flush.\nconst SSE_BUDGET_MS = 55_000;\nconst POLL_INTERVAL_MS = 500;\n\nexport async function sseHandler(c: Context): Promise {\n const session = await getSession(c);\n if (!session) return c.text(\"Unauthorized\", 401);\n\n const roomId = Number(c.req.param(\"roomId\"));\n if (!Number.isInteger(roomId)) return c.text(\"Bad room id\", 400);\n if (!(await isRoomMember(roomId, session.user.id))) {\n return c.text(\"Not a room member\", 403);\n }\n\n const lastEventHeader = c.req.header(\"Last-Event-ID\");\n const sinceQuery = c.req.query(\"since\");\n let cursor = Number(lastEventHeader ?? sinceQuery ?? 0);\n if (!Number.isFinite(cursor) || cursor < 0) cursor = 0;\n\n return streamSSE(c, async (stream) => {\n const startedAt = Date.now();\n // Initial flush so the browser opens the connection promptly.\n await stream.writeSSE({ event: \"open\", data: \"\" });\n\n while (Date.now() - startedAt < SSE_BUDGET_MS) {\n const events = await readEventsSince(roomId, cursor);\n for (const ev of events) {\n await stream.writeSSE({\n id: String(ev.id),\n event: ev.type,\n data: JSON.stringify({\n type: ev.type,\n payload: JSON.parse(ev.payload),\n createdAt: ev.created_at,\n }),\n });\n cursor = ev.id;\n }\n await stream.sleep(POLL_INTERVAL_MS);\n }\n // Graceful close: client EventSource will reconnect with Last-Event-ID = cursor.\n });\n}\n",[],[152,287,279],"rooms","2f30cd64-5508-11f1-b9b2-ee650bb23af1","routes.ts","e8fd4450-5505-11f1-a891-ee650bb23af1",25,["D",1779362906490],"import { Hono } from \"npm:hono@^4.6.0\";\nimport { getSession } from \"../auth/session.ts\";\nimport {\n acceptInviteById,\n addRoomMember,\n createInvite,\n createRoom,\n findInviteById,\n findRoomById,\n findUserById,\n isRoomMember,\n latestEventId,\n listFriends,\n listRoomMembers,\n} from \"../db/queries.ts\";\nimport { gameForType } from \"../games/registry.ts\";\nimport { roomPage } from \"../ui/pages/room.ts\";\nimport type { RouletteState } from \"../games/roulette.ts\";\nimport { actionsRoutes } from \"./actions.ts\";\n\nexport const roomsRoutes = new Hono();\nroomsRoutes.route(\"/\", actionsRoutes);\n\nroomsRoutes.post(\"/\", async (c) => {\n const session = await getSession(c);\n if (!session) return c.redirect(\"/\");\n const form = await c.req.formData();\n const gameType = String(form.get(\"game_type\") ?? \"roulette\");\n const game = gameForType(gameType);\n const initial = game.initialState(session.user.id);\n const room = await createRoom(gameType, session.user.id, JSON.stringify(initial));\n await addRoomMember(room.id, session.user.id);\n return c.redirect(`/rooms/${room.id}`);\n});\n\nroomsRoutes.get(\"/:id\", async (c) => {\n const session = await getSession(c);\n if (!session) return c.redirect(\"/\");\n const roomId = Number(c.req.param(\"id\"));\n if (!Number.isInteger(roomId)) return c.redirect(\"/home\");\n const room = await findRoomById(roomId);\n if (!room) return c.text(\"Room not found\", 404);\n const member = await isRoomMember(roomId, session.user.id);\n if (!member) return c.text(\"Not a member of this room\", 403);\n\n const [members, friends, lastEvId] = await Promise.all([\n listRoomMembers(roomId),\n listFriends(session.user.id),\n latestEventId(roomId),\n ]);\n\n // Ensure the persisted user record is fresh (balance may have changed via bets).\n const user = await findUserById(session.user.id);\n if (!user) return c.redirect(\"/\");\n\n return c.html(roomPage({\n user,\n roomId,\n hostId: room.host_id,\n members,\n friends,\n state: JSON.parse(room.state_json) as RouletteState,\n latestEventId: lastEvId,\n }));\n});\n\nroomsRoutes.post(\"/:id/invite\", async (c) => {\n const session = await getSession(c);\n if (!session) return c.redirect(\"/\");\n const roomId = Number(c.req.param(\"id\"));\n if (!Number.isInteger(roomId)) return c.redirect(\"/home\");\n const room = await findRoomById(roomId);\n if (!room) return c.redirect(\"/home\");\n if (!(await isRoomMember(roomId, session.user.id))) {\n return c.text(\"Not a member of this room\", 403);\n }\n const form = await c.req.formData();\n const friendId = Number(form.get(\"friend_id\"));\n if (!Number.isInteger(friendId)) return c.redirect(`/rooms/${roomId}`);\n\n // Confirm they're actually friends before sending an invite.\n const friends = await listFriends(session.user.id);\n if (!friends.some((f) => f.id === friendId)) {\n return c.redirect(`/rooms/${roomId}`);\n }\n if (await isRoomMember(roomId, friendId)) {\n return c.redirect(`/rooms/${roomId}`);\n }\n await createInvite(roomId, session.user.id, friendId);\n return c.redirect(`/rooms/${roomId}`);\n});\n\nroomsRoutes.post(\"/:id/join\", async (c) => {\n const session = await getSession(c);\n if (!session) return c.redirect(\"/\");\n const roomId = Number(c.req.param(\"id\"));\n if (!Number.isInteger(roomId)) return c.redirect(\"/home\");\n const form = await c.req.formData();\n const inviteId = Number(form.get(\"invite_id\"));\n\n // Joining requires either an active invite or already being a member.\n if (await isRoomMember(roomId, session.user.id)) {\n return c.redirect(`/rooms/${roomId}`);\n }\n if (!Number.isInteger(inviteId)) return c.redirect(\"/home\");\n const invite = await findInviteById(inviteId);\n if (!invite || invite.status !== \"pending\" || invite.to_user !== session.user.id ||\n invite.room_id !== roomId) {\n return c.text(\"Invite not valid\", 403);\n }\n await acceptInviteById(inviteId, session.user.id);\n await addRoomMember(roomId, session.user.id);\n return c.redirect(`/rooms/${roomId}`);\n});\n",[],[152,287,289],"2cd59ee6-5508-11f1-8d5c-ee650bb23af1","actions.ts","f7d93eb6-5505-11f1-bb35-ee650bb23af1",24,["D",1779362902528],"import { Hono } from \"npm:hono@^4.6.0\";\nimport { getSession } from \"../auth/session.ts\";\nimport {\n adjustBalance,\n appendEvent,\n findRoomById,\n findUserById,\n isRoomMember,\n updateRoomState,\n} from \"../db/queries.ts\";\nimport { gameForType } from \"../games/registry.ts\";\n\nexport const actionsRoutes = new Hono();\n\nactionsRoutes.post(\"/:id/action\", async (c) => {\n const session = await getSession(c);\n if (!session) return c.json({ error: \"unauthorized\" }, 401);\n\n const roomId = Number(c.req.param(\"id\"));\n if (!Number.isInteger(roomId)) return c.json({ error: \"bad room id\" }, 400);\n\n const room = await findRoomById(roomId);\n if (!room) return c.json({ error: \"room not found\" }, 404);\n if (!(await isRoomMember(roomId, session.user.id))) {\n return c.json({ error: \"not a member\" }, 403);\n }\n\n let action: unknown;\n try {\n action = await c.req.json();\n } catch {\n return c.json({ error: \"invalid json\" }, 400);\n }\n\n const game = gameForType(room.game_type);\n const state = JSON.parse(room.state_json);\n\n let result;\n try {\n result = game.applyAction(state, session.user.id, action);\n } catch (e) {\n return c.json({ error: e instanceof Error ? e.message : \"action failed\" }, 400);\n }\n\n // For bets: deduct stake first (already encoded in balanceDeltas as a negative).\n // Refuse the action if any user would go negative; for v1, only the acting\n // user incurs a negative delta on place_bet, so check just that one.\n for (const [uidStr, delta] of Object.entries(result.balanceDeltas)) {\n const uid = Number(uidStr);\n if (delta < 0) {\n const u = await findUserById(uid);\n if (!u || u.balance + delta < 0) {\n return c.json({ error: \"insufficient balance\" }, 400);\n }\n }\n }\n\n // Apply balance deltas. (No real transactions in Val Town SQLite; for v1's\n // low concurrency we accept the tiny window where state could diverge.)\n for (const [uidStr, delta] of Object.entries(result.balanceDeltas)) {\n if (delta !== 0) {\n await adjustBalance(Number(uidStr), delta, `room:${roomId}`);\n }\n }\n\n // Determine new room status from any phase change.\n const newStatus = result.state.phase === \"betting\"\n ? \"open\"\n : result.state.phase === \"spinning\"\n ? \"round_active\"\n : \"open\";\n await updateRoomState(roomId, newStatus, JSON.stringify(result.state));\n\n // Append game events plus a state-snapshot event so reconnecting clients\n // can rebuild even if they miss intermediate events.\n for (const ev of result.events) {\n await appendEvent(roomId, ev.type, ev.payload);\n }\n await appendEvent(roomId, \"state.snapshot\", { state: result.state });\n\n return c.json({ ok: true, state: result.state });\n});\n",[],[152,287,297],"e8fd80dc-5505-11f1-a891-ee650bb23af1",14,["D",1779361929706],[184,185,186],[152,287],"cec5d192-5505-11f1-a3cc-ee650bb23af1","roulette.ts","cec5d264-5505-11f1-a3cc-ee650bb23af1","8ee6e4ce-0a84-45ce-83f1-b6d71b7461d8",11,["D",1779361885725],"// 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",[],[152,318,310],"games","d1fee83a-5505-11f1-8ccf-ee650bb23af1","registry.ts","d1fee8ee-5505-11f1-8ccf-ee650bb23af1",12,["D",1779361891145],"import type { Game } from \"./game.ts\";\nimport { roulette } from \"./roulette.ts\";\n\n// deno-lint-ignore no-explicit-any\nconst REGISTRY: Record> = {\n [roulette.type]: roulette,\n};\n\n// deno-lint-ignore no-explicit-any\nexport function gameForType(type: string): Game {\n const g = REGISTRY[type];\n if (!g) throw new Error(`unknown game type: ${type}`);\n return g;\n}\n",[],[152,318,320],"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",[],[152,318,328],"bb84b5bc-5505-11f1-af15-ee650bb23af1",["D",1779361853425],[180,181,182],[152,318],"29f45654-5508-11f1-941b-ee650bb23af1","dcbe047c-5505-11f1-a3cc-ee650bb23af1","88f6fcc0-777d-44d3-921d-2a934814938b",23,["D",1779362897529],"import { Hono } from \"npm:hono@^4.6.0\";\nimport { getSession } from \"../auth/session.ts\";\nimport {\n acceptFriendRequest,\n createFriendRequest,\n findFriendshipPair,\n findUserByUsername,\n listFriends,\n listPendingIncoming,\n} from \"../db/queries.ts\";\nimport { escapeHtml, layout } from \"../ui/layout.ts\";\n\nexport const friendsRoutes = new Hono();\n\nfriendsRoutes.get(\"/\", async (c) => {\n const session = await getSession(c);\n if (!session) return c.redirect(\"/\");\n const [friends, pending] = await Promise.all([\n listFriends(session.user.id),\n listPendingIncoming(session.user.id),\n ]);\n\n const friendList = friends.length === 0\n ? `
No friends yet.
`\n : friends.map((f) =>\n `
@${\n escapeHtml(f.username)\n }
`\n ).join(\"\");\n\n const pendingList = pending.length === 0\n ? \"\"\n : `
\n
Pending requests
\n ${\n pending.map((p) =>\n `
\n @${escapeHtml(p.username)}\n \n
`\n ).join(\"\")\n }\n
`;\n\n const body = `\n
\n ← home\n\n
\n
Add friend
\n \n \n
\n\n ${pendingList}\n\n
\n
Friends
\n ${friendList}\n
\n
\n`;\n return c.html(layout({\n title: \"friends\",\n body,\n balance: session.user.balance,\n username: session.user.username,\n }));\n});\n\nfriendsRoutes.post(\"/add\", async (c) => {\n const session = await getSession(c);\n if (!session) return c.redirect(\"/\");\n const form = await c.req.formData();\n const username = String(form.get(\"username\") ?? \"\").trim();\n if (!username || username === session.user.username) {\n return c.redirect(\"/friends\");\n }\n const target = await findUserByUsername(username);\n if (!target) return c.redirect(\"/friends\");\n const existing = await findFriendshipPair(session.user.id, target.id);\n if (existing) return c.redirect(\"/friends\");\n await createFriendRequest(session.user.id, target.id);\n return c.redirect(\"/friends\");\n});\n\nfriendsRoutes.post(\"/accept/:requesterId\", async (c) => {\n const session = await getSession(c);\n if (!session) return c.redirect(\"/\");\n const requesterId = Number(c.req.param(\"requesterId\"));\n if (!Number.isInteger(requesterId)) return c.redirect(\"/home\");\n // The current user is the addressee (user_b); requester is user_a.\n await acceptFriendRequest(requesterId, session.user.id);\n return c.redirect(\"/home\");\n});\n",[],[152,347,289],"friends","dcbe1d4a-5505-11f1-a3cc-ee650bb23af1",13,["D",1779361909170],[178],[152,347],"3462fa1e-5508-11f1-921b-ee650bb23af1","b63de110-65d6-4da5-a757-980369fb0498",["D",1779362915182],[],[152,358,33],"db","31ee2aba-5508-11f1-8f71-ee650bb23af1","migrate.ts","8b9111ca-5505-11f1-9c88-ee650bb23af1",26,["D",1779362911089],"import { sqlite } from \"https://esm.town/v/std/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",[],[152,358,360],"8b912c5a-5505-11f1-9c88-ee650bb23af1",5,["D",1779361772979],[175,176],[152,358],"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",[],[152,381,373],"chips","b6658dcc-5505-11f1-a774-ee650bb23af1",["D",1779361844836],[173],[152,381],"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",[],[152,395,387],"auth","b22bb362-5505-11f1-a774-ee650bb23af1","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",[],[152,395,289],"ab0c3318-5505-11f1-a7f7-ee650bb23af1",["D",1779361825793],[170,171],[152,395],["D",1779361754893],[169,172,174,177,179,183,187,190,196],[152],["D",1779361516091],["D",1789489305251],{"_99":98,"_106":101},{"_99":98,"_100":101,"_102":101,"_18":56,"_103":104,"_105":25},{"_13":88,"_32":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"ctx",{"_81":-5,"_126":448,"_449":450,"_451":452,"_453":25,"_454":25,"_455":25,"_456":124,"_457":-5,"_458":-7,"_459":-7,"_460":62,"_461":25,"_462":25,"_463":-5,"_464":25,"_465":25,"_466":25,"_467":-5},"ENV",{"_419":420,"_421":422,"_423":89,"_424":425,"_426":427,"_428":429,"_430":431,"_432":433,"_434":435,"_436":437,"_438":439,"_440":441,"_442":443,"_444":445,"_446":447},"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"]

grimbucks

Log in

Sign up

Add friend

Diff · v27