[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_369":370,"_371":372},"routes/_app.x.$handle.$name",{"_97":96,"_32":46,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":59,"_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",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",49,"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","backend/database/queries.ts","latestPath","fileId","7d9c5bbc-487a-11f0-810d-76b3cceeab13","name","queries.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, FACTS_TABLE, VOTES_TABLE, ROUNDS_TABLE } from \"./migrations.ts\";\nimport type { User, Fact, Vote, GameRound } from \"../../shared/types.ts\";\n\nexport async function addUser(user: User): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${USERS_TABLE} (id, name, joined_at, last_seen, is_active, score) \n VALUES (?, ?, ?, ?, ?, ?)`,\n [user.id, user.name, user.joinedAt, Date.now(), 1, user.score || 0]\n );\n}\n\nexport async function removeUser(userId: string): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET is_active = 0 WHERE id = ?`,\n [userId]\n );\n}\n\nexport async function getActiveUsers(): Promise {\n const result = await sqlite.execute(\n `SELECT id, name, joined_at as joinedAt, is_active as isActive, fact, score \n FROM ${USERS_TABLE} \n WHERE is_active = 1 \n ORDER BY joined_at ASC`\n );\n \n return result.rows.map(row => ({\n id: row.id as string,\n name: row.name as string,\n joinedAt: row.joinedAt as number,\n isActive: Boolean(row.isActive),\n fact: row.fact as string || undefined,\n score: (row.score as number) || 0\n }));\n}\n\nexport async function updateUserLastSeen(userId: string): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET last_seen = ? WHERE id = ?`,\n [Date.now(), userId]\n );\n}\n\nexport async function cleanupInactiveUsers(): Promise {\n // Remove users who haven't been seen in 5 minutes\n const fiveMinutesAgo = Date.now() - (5 * 60 * 1000);\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET is_active = 0 WHERE last_seen < ?`,\n [fiveMinutesAgo]\n );\n}\n\n// Fact management\nexport async function submitUserFact(userId: string, fact: string): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET fact = ? WHERE id = ?`,\n [fact, userId]\n );\n \n // Also store in facts table for game rounds\n const factId = crypto.randomUUID();\n await sqlite.execute(\n `INSERT INTO ${FACTS_TABLE} (id, user_id, content, created_at) VALUES (?, ?, ?, ?)`,\n [factId, userId, fact, Date.now()]\n );\n}\n\nexport async function getAllFacts(): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id as userId, content, created_at as createdAt \n FROM ${FACTS_TABLE} \n ORDER BY created_at ASC`\n );\n \n return result.rows.map(row => ({\n id: row.id as string,\n userId: row.userId as string,\n content: row.content as string,\n createdAt: row.createdAt as number\n }));\n}\n\nexport async function getUnusedFacts(): Promise {\n const result = await sqlite.execute(`\n SELECT f.id, f.user_id as userId, f.content, f.created_at as createdAt \n FROM ${FACTS_TABLE} f\n LEFT JOIN ${ROUNDS_TABLE} r ON f.id = r.fact_id\n WHERE r.fact_id IS NULL\n ORDER BY f.created_at ASC\n `);\n \n return result.rows.map(row => ({\n id: row.id as string,\n userId: row.userId as string,\n content: row.content as string,\n createdAt: row.createdAt as number\n }));\n}\n\n// Round management\nexport async function createRound(factId: string): Promise {\n const roundId = crypto.randomUUID();\n await sqlite.execute(\n `INSERT INTO ${ROUNDS_TABLE} (id, fact_id, status, created_at) VALUES (?, ?, ?, ?)`,\n [roundId, factId, 'voting', Date.now()]\n );\n return roundId;\n}\n\nexport async function getCurrentRound(): Promise {\n const result = await sqlite.execute(`\n SELECT r.id, r.fact_id as factId, r.status, r.created_at as createdAt,\n f.content as factContent, f.user_id as factUserId,\n u.name as factOwnerName\n FROM ${ROUNDS_TABLE} r\n JOIN ${FACTS_TABLE} f ON r.fact_id = f.id\n JOIN ${USERS_TABLE} u ON f.user_id = u.id\n WHERE r.status IN ('voting', 'revealed')\n ORDER BY r.created_at DESC\n LIMIT 1\n `);\n \n if (result.rows.length === 0) return null;\n \n const row = result.rows[0];\n const votes = await getVotesForFact(row.factId as string);\n \n return {\n id: row.id as string,\n factId: row.factId as string,\n fact: {\n id: row.factId as string,\n userId: row.factUserId as string,\n content: row.factContent as string,\n createdAt: row.createdAt as number\n },\n factOwner: {\n id: row.factUserId as string,\n name: row.factOwnerName as string,\n joinedAt: 0,\n isActive: true,\n score: 0\n },\n votes,\n status: row.status as 'voting' | 'revealed' | 'skipped',\n createdAt: row.createdAt as number\n };\n}\n\nexport async function updateRoundStatus(roundId: string, status: 'voting' | 'revealed' | 'skipped'): Promise {\n await sqlite.execute(\n `UPDATE ${ROUNDS_TABLE} SET status = ? WHERE id = ?`,\n [status, roundId]\n );\n}\n\n// Voting\nexport async function castVote(factId: string, voterId: string, guessedUserId: string): Promise {\n const voteId = crypto.randomUUID();\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${VOTES_TABLE} (id, fact_id, voter_id, guessed_user_id, created_at) \n VALUES (?, ?, ?, ?, ?)`,\n [voteId, factId, voterId, guessedUserId, Date.now()]\n );\n}\n\nexport async function getVotesForFact(factId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, fact_id as factId, voter_id as voterId, guessed_user_id as guessedUserId, created_at as createdAt\n FROM ${VOTES_TABLE} \n WHERE fact_id = ?`,\n [factId]\n );\n \n return result.rows.map(row => ({\n id: row.id as string,\n factId: row.factId as string,\n voterId: row.voterId as string,\n guessedUserId: row.guessedUserId as string,\n createdAt: row.createdAt as number\n }));\n}\n\nexport async function getUserVoteForFact(factId: string, voterId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, fact_id as factId, voter_id as voterId, guessed_user_id as guessedUserId, created_at as createdAt\n FROM ${VOTES_TABLE} \n WHERE fact_id = ? AND voter_id = ?`,\n [factId, voterId]\n );\n \n if (result.rows.length === 0) return null;\n \n const row = result.rows[0];\n return {\n id: row.id as string,\n factId: row.factId as string,\n voterId: row.voterId as string,\n guessedUserId: row.guessedUserId as string,\n createdAt: row.createdAt as number\n };\n}\n\n// Scoring\nexport async function updateUserScore(userId: string, points: number): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET score = score + ? WHERE id = ?`,\n [points, userId]\n );\n}\n\nexport async function getLeaderboard(): Promise<{ userId: string; name: string; score: number }[]> {\n const result = await sqlite.execute(\n `SELECT id as userId, name, score \n FROM ${USERS_TABLE} \n WHERE is_active = 1 AND score > 0\n ORDER BY score DESC, name ASC`\n );\n \n return result.rows.map(row => ({\n userId: row.userId as string,\n name: row.name as string,\n score: (row.score as number) || 0\n }));\n}","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, FACTS_TABLE, VOTES_TABLE, ROUNDS_TABLE } from \"./migrations.ts\";\nimport type { User, Fact, Vote, GameRound } from \"../../shared/types.ts\";\n\nexport async function addUser(user: User): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${USERS_TABLE} (id, name, joined_at, last_seen, is_active, score) \n VALUES (?, ?, ?, ?, ?, ?)`,\n [user.id, user.name, user.joinedAt, Date.now(), 1, user.score || 0]\n );\n}\n\nexport async function removeUser(userId: string): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET is_active = 0 WHERE id = ?`,\n [userId]\n );\n}\n\nexport async function getActiveUsers(): Promise {\n const result = await sqlite.execute(\n `SELECT id, name, joined_at as joinedAt, is_active as isActive, fact, score \n FROM ${USERS_TABLE} \n WHERE is_active = 1 \n ORDER BY joined_at ASC`\n );\n \n return result.rows.map(row => ({\n id: row.id as string,\n name: row.name as string,\n joinedAt: row.joinedAt as number,\n isActive: Boolean(row.isActive),\n fact: row.fact as string || undefined,\n score: (row.score as number) || 0\n }));\n}\n\nexport async function updateUserLastSeen(userId: string): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET last_seen = ? WHERE id = ?`,\n [Date.now(), userId]\n );\n}\n\nexport async function cleanupInactiveUsers(): Promise {\n // Remove users who haven't been seen in 5 minutes\n const fiveMinutesAgo = Date.now() - (5 * 60 * 1000);\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET is_active = 0 WHERE last_seen < ?`,\n [fiveMinutesAgo]\n );\n}\n\n// Fact management\nexport async function submitUserFact(userId: string, fact: string): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET fact = ? WHERE id = ?`,\n [fact, userId]\n );\n \n // Also store in facts table for game rounds\n const factId = crypto.randomUUID();\n await sqlite.execute(\n `INSERT INTO ${FACTS_TABLE} (id, user_id, content, created_at) VALUES (?, ?, ?, ?)`,\n [factId, userId, fact, Date.now()]\n );\n}\n\nexport async function getAllFacts(): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id as userId, content, created_at as createdAt \n FROM ${FACTS_TABLE} \n ORDER BY created_at ASC`\n );\n \n return result.rows.map(row => ({\n id: row.id as string,\n userId: row.userId as string,\n content: row.content as string,\n createdAt: row.createdAt as number\n }));\n}\n\nexport async function getUnusedFacts(): Promise {\n const result = await sqlite.execute(`\n SELECT f.id, f.user_id as userId, f.content, f.created_at as createdAt \n FROM ${FACTS_TABLE} f\n LEFT JOIN ${ROUNDS_TABLE} r ON f.id = r.fact_id\n WHERE r.fact_id IS NULL\n ORDER BY f.created_at ASC\n `);\n \n return result.rows.map(row => ({\n id: row.id as string,\n userId: row.userId as string,\n content: row.content as string,\n createdAt: row.createdAt as number\n }));\n}\n\n// Round management\nexport async function createRound(factId: string): Promise {\n const roundId = crypto.randomUUID();\n await sqlite.execute(\n `INSERT INTO ${ROUNDS_TABLE} (id, fact_id, status, created_at) VALUES (?, ?, ?, ?)`,\n [roundId, factId, 'voting', Date.now()]\n );\n return roundId;\n}\n\nexport async function getCurrentRound(): Promise {\n const result = await sqlite.execute(`\n SELECT r.id, r.fact_id as factId, r.status, r.created_at as createdAt,\n f.content as factContent, f.user_id as factUserId,\n u.name as factOwnerName\n FROM ${ROUNDS_TABLE} r\n JOIN ${FACTS_TABLE} f ON r.fact_id = f.id\n JOIN ${USERS_TABLE} u ON f.user_id = u.id\n WHERE r.status IN ('voting', 'revealed')\n ORDER BY r.created_at DESC\n LIMIT 1\n `);\n \n if (result.rows.length === 0) return null;\n \n const row = result.rows[0];\n const votes = await getVotesForFact(row.factId as string);\n \n return {\n id: row.id as string,\n factId: row.factId as string,\n fact: {\n id: row.factId as string,\n userId: row.factUserId as string,\n content: row.factContent as string,\n createdAt: row.createdAt as number\n },\n factOwner: {\n id: row.factUserId as string,\n name: row.factOwnerName as string,\n joinedAt: 0,\n isActive: true,\n score: 0\n },\n votes,\n status: row.status as 'voting' | 'revealed' | 'skipped',\n createdAt: row.createdAt as number\n };\n}\n\nexport async function updateRoundStatus(roundId: string, status: 'voting' | 'revealed' | 'skipped'): Promise {\n await sqlite.execute(\n `UPDATE ${ROUNDS_TABLE} SET status = ? WHERE id = ?`,\n [status, roundId]\n );\n}\n\n// Voting\nexport async function castVote(factId: string, voterId: string, guessedUserId: string): Promise {\n const voteId = crypto.randomUUID();\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${VOTES_TABLE} (id, fact_id, voter_id, guessed_user_id, created_at) \n VALUES (?, ?, ?, ?, ?)`,\n [voteId, factId, voterId, guessedUserId, Date.now()]\n );\n}\n\nexport async function getVotesForFact(factId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, fact_id as factId, voter_id as voterId, guessed_user_id as guessedUserId, created_at as createdAt\n FROM ${VOTES_TABLE} \n WHERE fact_id = ?`,\n [factId]\n );\n \n return result.rows.map(row => ({\n id: row.id as string,\n factId: row.factId as string,\n voterId: row.voterId as string,\n guessedUserId: row.guessedUserId as string,\n createdAt: row.createdAt as number\n }));\n}\n\nexport async function getUserVoteForFact(factId: string, voterId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, fact_id as factId, voter_id as voterId, guessed_user_id as guessedUserId, created_at as createdAt\n FROM ${VOTES_TABLE} \n WHERE fact_id = ? AND voter_id = ?`,\n [factId, voterId]\n );\n \n if (result.rows.length === 0) return null;\n \n const row = result.rows[0];\n return {\n id: row.id as string,\n factId: row.factId as string,\n voterId: row.voterId as string,\n guessedUserId: row.guessedUserId as string,\n createdAt: row.createdAt as number\n };\n}\n\n// Scoring\nexport async function updateUserScore(userId: string, points: number): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET score = score + ? WHERE id = ?`,\n [points, userId]\n );\n}\n\nexport async function getLeaderboard(): Promise<{ userId: string; name: string; score: number }[]> {\n const result = await sqlite.execute(\n `SELECT id as userId, name, score \n FROM ${USERS_TABLE} \n WHERE is_active = 1 AND score > 0\n ORDER BY score DESC, name ASC`\n );\n \n return result.rows.map(row => ({\n userId: row.userId as string,\n name: row.name as string,\n score: (row.score as number) || 0\n }));\n}\n\n// Admin functions\nexport async function clearAllGameData(): Promise {\n // Clear all tables in the correct order (respecting foreign key constraints)\n await sqlite.execute(`DELETE FROM ${VOTES_TABLE}`);\n await sqlite.execute(`DELETE FROM ${ROUNDS_TABLE}`);\n await sqlite.execute(`DELETE FROM ${FACTS_TABLE}`);\n await sqlite.execute(`DELETE FROM ${USERS_TABLE}`);\n}","createdAt",["D",1749839365689],"branchVersion","branchId","24d6b1a4-4879-11f0-9b62-76b3cceeab13","id","24d66550-4879-11f0-9b62-76b3cceeab13","factoid-trivia",["D",1749834559473],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","04e56ba7-c54a-427f-8070-67219b83ca20","pinnedFileId","9127face-487a-11f0-8b45-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","2e901eee-3aff-4826-99a0-ea4001a41cef","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"isOwned",96,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","bmitchinson","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybGNycExZSzZneWRkMGZuTGRiSDlsZjNSU3MifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":365,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":366,"_81":367,"_83":368,"_85":25},"tree",[187,194,206,208,209,210],"files",[187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210],"counts",{"_177":63,"_178":162,"_179":63,"_180":181,"_182":183},"contents",[128,129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{"_57":127},"trivia.mitchinson.dev",{"_44":171,"_32":172,"_30":173,"_137":-5,"_42":43,"_41":174,"_139":59,"_39":175,"_13":63,"_34":164,"_36":-5,"_24":25,"_142":-5,"_27":176},{"_44":166,"_32":167,"_30":168,"_137":-5,"_42":43,"_41":149,"_139":59,"_39":169,"_13":63,"_34":164,"_36":-5,"_24":25,"_142":-5,"_27":170},{"_44":159,"_32":160,"_30":161,"_137":-5,"_42":43,"_41":162,"_139":59,"_39":163,"_13":63,"_34":164,"_36":-5,"_24":25,"_142":-5,"_27":165},{"_44":152,"_32":153,"_30":154,"_137":-5,"_42":43,"_41":155,"_139":25,"_39":156,"_13":63,"_34":20,"_36":157,"_24":25,"_142":-5,"_27":158},{"_44":144,"_32":145,"_30":146,"_137":-5,"_42":43,"_41":147,"_139":25,"_39":148,"_13":149,"_34":20,"_36":150,"_24":25,"_142":-5,"_27":151},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":59,"_39":140,"_13":63,"_34":20,"_36":141,"_24":25,"_142":-5,"_27":143},"088f29e4-4884-11f0-85c8-76b3cceeab13","deno.json","088f2aac-4884-11f0-85c8-76b3cceeab13","parentId",46,"latest",["D",1749839236491],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\n \"https://www.val.town/types/valtown.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"files\": {\n \"include\": [\n \"deno:/https/esm.town/**/*\"\n ]\n },\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}","label",[135],"089bbe2a-4884-11f0-9fad-76b3cceeab13","README.md","6db52314-487a-11f0-816c-76b3cceeab13",47,["D",1749839236567],7,"# USPS Trivia Game\n\nA realtime trivia game themed like a USPS post office, supporting up to 30 concurrent users.\n\nhttps://www.val.town/x/bmitchinson/factoid-trivia\n\n## Features\n\n- USPS post office themed design\n- Real-time user presence (see who's online)\n- Name entry and user management\n- Support for up to 30 concurrent players\n- **NEW:** Complete trivia game functionality:\n - Fact submission by each player\n - Random fact selection for rounds\n - Voting system where players guess whose fact it is\n - Real-time vote tracking and display\n - Answer reveal with vote results\n - Scoring system and leaderboard\n - Skip functionality for rounds\n\n## How to Play\n\n1. **Join the Game**: Enter your name to join the post office\n2. **Submit a Fact**: Each player submits an interesting fact about themselves\n3. **Wait for Others**: Game can start when at least 2 players have submitted facts\n4. **Vote on Facts**: When a fact is displayed, guess which player it belongs to\n5. **See Results**: After voting, reveal answers to see who was correct\n6. **Earn Points**: Get 1 point for each correct guess\n7. **Climb the Leaderboard**: Track your score against other players\n\n## Game Flow\n\n```\nJoin Game → All Players Submit Facts → Facts Get Queued → \nVote on Random Facts → See Results → Earn Points → \nNext Round → Repeat Until All Facts Used\n```\n\n## Key Features\n\n- **Everyone Submits Facts**: All players can and should submit facts\n- **Random Queue System**: Facts are randomly selected from the queue for each round\n- **Flexible Start**: Game can start with 2+ facts, or wait for everyone\n- **Real-time Progress**: See who has/hasn't submitted facts yet\n- **Complete Fact Usage**: All submitted facts will eventually be used in rounds\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main Hono server with game API endpoints\n│ ├── database/\n│ │ ├── migrations.ts # SQLite schema for users, facts, votes, rounds\n│ │ └── queries.ts # Database query functions for game logic\n│ └── routes/\n│ └── websocket.ts # WebSocket connection handling (future)\n├── frontend/\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # React frontend entry point\n│ ├── components/\n│ │ ├── App.tsx # Main app component with game state management\n│ │ ├── NameEntry.tsx # Name entry form\n│ │ ├── FactEntry.tsx # Fact submission form\n│ │ ├── GameLobby.tsx # Waiting area showing fact collection progress\n│ │ ├── GameRound.tsx # Active round with voting interface\n│ │ ├── Leaderboard.tsx # Score tracking display\n│ │ └── UserList.tsx # Online users display\n│ └── style.css # USPS-themed styles\n└── shared/\n └── types.ts # Shared TypeScript types for game objects\n```\n\n## Getting Started\n\n1. The backend runs on Hono with WebSocket support for real-time features\n2. Frontend uses React with WebSocket client for real-time updates\n3. SQLite stores user sessions and game state\n4. USPS-themed styling with postal colors and typography\n\n## Current Status\n\n- ✅ User name entry and management\n- ✅ Real-time user presence (up to 30 players)\n- ✅ USPS theming and design\n- ✅ **Fact submission system**\n- ✅ **Random fact selection for rounds**\n- ✅ **Voting system with real-time updates**\n- ✅ **Answer reveal and vote result display**\n- ✅ **Scoring system and leaderboard**\n- ✅ **Skip round functionality**\n- ✅ **Complete game flow from start to finish**\n\n## API Endpoints\n\n- `GET /api/game-state` - Get current game state including users, rounds, leaderboard\n- `POST /api/join` - Join the game with a name\n- `POST /api/leave` - Leave the game\n- `POST /api/submit-fact` - Submit a personal fact\n- `POST /api/start-round` - Start a new round with a random fact\n- `POST /api/vote` - Cast a vote for who you think the fact belongs to\n- `POST /api/reveal` - Reveal the answer and award points\n- `POST /api/skip` - Skip the current round",[145],"08a0785c-4884-11f0-b999-76b3cceeab13",".vtignore","08a07906-4884-11f0-b999-76b3cceeab13",48,["D",1749839236567],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[153],"7205417e-487a-11f0-aed0-76b3cceeab13","shared","871b29af-733c-45f6-a07c-d1731f9bbc70",2,["D",1749835118445],"directory",[160],"95d110ba-487a-11f0-a9ec-76b3cceeab13","frontend","17fa2a23-aa00-4bd0-bfd3-b43b6bc9c778",["D",1749835178513],[167],"76334980-487a-11f0-b784-76b3cceeab13","backend","379e532e-042e-4e9e-8f33-6863d167ea3b",3,["D",1749835125467],[172],"pulls","branches","forks","envVars",{"_184":63,"_186":63},"connections",{"_184":63,"_185":63},"count","unfilledCount","emptyCount",{"_44":171,"_32":172,"_30":173,"_137":-5,"_42":43,"_41":174,"_139":59,"_39":362,"_13":63,"_34":164,"_36":-5,"_24":25,"_142":-5,"_212":363,"_27":364},{"_44":358,"_32":349,"_30":345,"_137":173,"_42":43,"_41":174,"_139":59,"_39":359,"_13":63,"_34":164,"_36":-5,"_24":25,"_142":-5,"_212":360,"_27":361},{"_44":350,"_32":351,"_30":352,"_137":345,"_42":43,"_41":353,"_139":59,"_39":354,"_13":226,"_34":35,"_36":355,"_24":25,"_142":-5,"_212":356,"_27":357},{"_44":344,"_32":33,"_30":31,"_137":345,"_42":43,"_41":14,"_139":59,"_39":346,"_13":162,"_34":35,"_36":38,"_24":25,"_142":-5,"_212":347,"_27":348},{"_44":340,"_32":339,"_30":334,"_137":173,"_42":43,"_41":311,"_139":59,"_39":341,"_13":63,"_34":164,"_36":-5,"_24":25,"_142":-5,"_212":342,"_27":343},{"_44":331,"_32":332,"_30":333,"_137":334,"_42":43,"_41":311,"_139":25,"_39":335,"_13":63,"_34":35,"_36":336,"_24":25,"_142":-5,"_212":337,"_27":338},{"_44":323,"_32":324,"_30":57,"_137":173,"_42":43,"_41":325,"_139":25,"_39":326,"_13":236,"_34":327,"_36":328,"_24":25,"_142":-5,"_212":329,"_27":330},{"_44":166,"_32":167,"_30":168,"_137":-5,"_42":43,"_41":149,"_139":59,"_39":320,"_13":63,"_34":164,"_36":-5,"_24":25,"_142":-5,"_212":321,"_27":322},{"_44":315,"_32":265,"_30":259,"_137":168,"_42":43,"_41":316,"_139":59,"_39":317,"_13":63,"_34":164,"_36":-5,"_24":25,"_142":-5,"_212":318,"_27":319},{"_44":306,"_32":307,"_30":308,"_137":259,"_42":43,"_41":309,"_139":25,"_39":310,"_13":311,"_34":35,"_36":312,"_24":25,"_142":-5,"_212":313,"_27":314},{"_44":298,"_32":299,"_30":300,"_137":259,"_42":43,"_41":301,"_139":25,"_39":302,"_13":63,"_34":35,"_36":303,"_24":25,"_142":-5,"_212":304,"_27":305},{"_44":290,"_32":291,"_30":292,"_137":259,"_42":43,"_41":293,"_139":25,"_39":294,"_13":162,"_34":35,"_36":295,"_24":25,"_142":-5,"_212":296,"_27":297},{"_44":282,"_32":283,"_30":284,"_137":259,"_42":43,"_41":285,"_139":25,"_39":286,"_13":63,"_34":35,"_36":287,"_24":25,"_142":-5,"_212":288,"_27":289},{"_44":274,"_32":275,"_30":276,"_137":259,"_42":43,"_41":277,"_139":25,"_39":278,"_13":63,"_34":35,"_36":279,"_24":25,"_142":-5,"_212":280,"_27":281},{"_44":266,"_32":267,"_30":268,"_137":259,"_42":43,"_41":269,"_139":25,"_39":270,"_13":174,"_34":35,"_36":271,"_24":25,"_142":-5,"_212":272,"_27":273},{"_44":256,"_32":257,"_30":258,"_137":259,"_42":43,"_41":260,"_139":25,"_39":261,"_13":162,"_34":35,"_36":262,"_24":25,"_142":-5,"_212":263,"_27":264},{"_44":249,"_32":250,"_30":251,"_137":168,"_42":43,"_41":149,"_139":25,"_39":252,"_13":63,"_34":20,"_36":253,"_24":25,"_142":-5,"_212":254,"_27":255},{"_44":241,"_32":242,"_30":243,"_137":168,"_42":43,"_41":244,"_139":59,"_39":245,"_13":63,"_34":35,"_36":246,"_24":25,"_142":-5,"_212":247,"_27":248},{"_44":233,"_32":234,"_30":235,"_137":168,"_42":43,"_41":236,"_139":25,"_39":237,"_13":63,"_34":20,"_36":238,"_24":25,"_142":-5,"_212":239,"_27":240},{"_44":159,"_32":160,"_30":161,"_137":-5,"_42":43,"_41":162,"_139":59,"_39":230,"_13":63,"_34":164,"_36":-5,"_24":25,"_142":-5,"_212":231,"_27":232},{"_44":221,"_32":222,"_30":223,"_137":161,"_42":43,"_41":224,"_139":59,"_39":225,"_13":226,"_34":35,"_36":227,"_24":25,"_142":-5,"_212":228,"_27":229},{"_44":152,"_32":153,"_30":154,"_137":-5,"_42":43,"_41":155,"_139":25,"_39":218,"_13":63,"_34":20,"_36":157,"_24":25,"_142":-5,"_212":219,"_27":220},{"_44":144,"_32":145,"_30":146,"_137":-5,"_42":43,"_41":147,"_139":25,"_39":215,"_13":149,"_34":20,"_36":150,"_24":25,"_142":-5,"_212":216,"_27":217},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":59,"_39":211,"_13":63,"_34":20,"_36":141,"_24":25,"_142":-5,"_212":213,"_27":214},["D",1749839236491],"children",[],[135],["D",1749839236567],[],[145],["D",1749839236567],[],[153],"3c65a98e-487d-11f0-8413-76b3cceeab13","types.ts","72053a8a-487a-11f0-aed0-76b3cceeab13",27,["D",1749836316977],1,"// Shared types for USPS Trivia Game\n\nexport interface User {\n id: string;\n name: string;\n joinedAt: number;\n isActive: boolean;\n fact?: string;\n score: number;\n}\n\nexport interface Fact {\n id: string;\n userId: string;\n content: string;\n createdAt: number;\n}\n\nexport interface Vote {\n id: string;\n factId: string;\n voterId: string;\n guessedUserId: string;\n createdAt: number;\n}\n\nexport interface GameRound {\n id: string;\n factId: string;\n fact: Fact;\n factOwner: User;\n votes: Vote[];\n status: 'voting' | 'revealed' | 'skipped';\n createdAt: number;\n}\n\nexport interface GameState {\n users: User[];\n maxUsers: number;\n gameStatus: 'waiting' | 'collecting_facts' | 'playing' | 'finished';\n currentRound?: GameRound;\n leaderboard: { userId: string; name: string; score: number }[];\n}\n\n// WebSocket message types - keeping for future real-time implementation\nexport type WSMessage = \n | { type: 'user_joined'; user: User }\n | { type: 'user_left'; userId: string }\n | { type: 'users_update'; users: User[] }\n | { type: 'game_state'; state: GameState }\n | { type: 'fact_submitted'; userId: string }\n | { type: 'vote_cast'; vote: Vote }\n | { type: 'round_revealed'; round: GameRound }\n | { type: 'error'; message: string };\n\nexport interface WSClientMessage {\n type: 'join' | 'leave' | 'submit_fact' | 'vote' | 'reveal' | 'skip';\n name?: string;\n userId?: string;\n fact?: string;\n guessedUserId?: string;\n}",[],[160,222],["D",1749835118445],[207],[160],"a830b47c-487a-11f0-9dd0-76b3cceeab13","style.css","a830b530-487a-11f0-9dd0-76b3cceeab13",8,["D",1749835209340],"/* USPS Trivia Game Styles */\n\n:root {\n --usps-blue: #004B87;\n --usps-red: #DA020E;\n --usps-light-blue: #0077BE;\n --usps-gray: #5A5A5A;\n --usps-light-gray: #F5F5F5;\n --usps-white: #FFFFFF;\n}\n\n* {\n box-sizing: border-box;\n}\n\nbody {\n font-family: 'Inter', -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, sans-serif;\n margin: 0;\n padding: 0;\n background: linear-gradient(135deg, var(--usps-blue) 0%, var(--usps-light-blue) 100%);\n min-height: 100vh;\n}\n\n.bg-usps-blue {\n background: linear-gradient(135deg, var(--usps-blue) 0%, var(--usps-light-blue) 100%);\n}\n\n.usps-container {\n max-width: 800px;\n margin: 0 auto;\n padding: 2rem;\n}\n\n.usps-header {\n text-align: center;\n margin-bottom: 3rem;\n color: white;\n}\n\n.usps-logo {\n font-size: 2.5rem;\n font-weight: 700;\n margin-bottom: 0.5rem;\n text-shadow: 2px 2px 4px rgba(0, 0, 0, 0.3);\n}\n\n.usps-tagline {\n font-size: 1.1rem;\n opacity: 0.9;\n font-weight: 500;\n}\n\n.usps-card {\n background: white;\n border-radius: 12px;\n padding: 2rem;\n box-shadow: 0 8px 32px rgba(0, 0, 0, 0.1);\n border: 3px solid var(--usps-red);\n margin-bottom: 2rem;\n}\n\n.usps-card-header {\n border-bottom: 2px solid var(--usps-light-gray);\n padding-bottom: 1rem;\n margin-bottom: 1.5rem;\n}\n\n.usps-card-title {\n color: var(--usps-blue);\n font-size: 1.5rem;\n font-weight: 600;\n margin: 0;\n display: flex;\n align-items: center;\n gap: 0.5rem;\n}\n\n.usps-form {\n display: flex;\n flex-direction: column;\n gap: 1rem;\n}\n\n.usps-input {\n padding: 0.75rem 1rem;\n border: 2px solid var(--usps-light-gray);\n border-radius: 6px;\n font-size: 1rem;\n transition: border-color 0.2s;\n}\n\n.usps-input:focus {\n outline: none;\n border-color: var(--usps-blue);\n box-shadow: 0 0 0 3px rgba(0, 75, 135, 0.1);\n}\n\n.usps-button {\n background: var(--usps-red);\n color: white;\n border: none;\n padding: 0.75rem 1.5rem;\n border-radius: 6px;\n font-size: 1rem;\n font-weight: 600;\n cursor: pointer;\n transition: background-color 0.2s;\n}\n\n.usps-button:hover {\n background: #B8001A;\n}\n\n.usps-button:disabled {\n background: var(--usps-gray);\n cursor: not-allowed;\n}\n\n.users-grid {\n display: grid;\n grid-template-columns: repeat(auto-fill, minmax(200px, 1fr));\n gap: 1rem;\n margin-top: 1rem;\n}\n\n.user-badge {\n background: var(--usps-light-blue);\n color: white;\n padding: 0.75rem 1rem;\n border-radius: 8px;\n text-align: center;\n font-weight: 500;\n display: flex;\n align-items: center;\n justify-content: center;\n gap: 0.5rem;\n}\n\n.user-badge.current-user {\n background: var(--usps-red);\n border: 2px solid white;\n box-shadow: 0 0 0 2px var(--usps-red);\n}\n\n.status-indicator {\n width: 8px;\n height: 8px;\n background: #00FF00;\n border-radius: 50%;\n display: inline-block;\n}\n\n.error-message {\n background: #FEE;\n color: var(--usps-red);\n padding: 1rem;\n border-radius: 6px;\n border: 1px solid var(--usps-red);\n margin-bottom: 1rem;\n}\n\n.loading-spinner {\n display: inline-block;\n width: 20px;\n height: 20px;\n border: 2px solid #f3f3f3;\n border-top: 2px solid var(--usps-blue);\n border-radius: 50%;\n animation: spin 1s linear infinite;\n}\n\n@keyframes spin {\n 0% { transform: rotate(0deg); }\n 100% { transform: rotate(360deg); }\n}\n\n.connection-status {\n position: fixed;\n top: 1rem;\n right: 1rem;\n padding: 0.5rem 1rem;\n border-radius: 20px;\n font-size: 0.875rem;\n font-weight: 500;\n display: flex;\n align-items: center;\n gap: 0.5rem;\n}\n\n.connection-status.connected {\n background: #D4EDDA;\n color: #155724;\n border: 1px solid #C3E6CB;\n}\n\n.connection-status.disconnected {\n background: #F8D7DA;\n color: #721C24;\n border: 1px solid #F5C6CB;\n}\n\n.postal-icon {\n font-size: 1.2em;\n}\n\n@media (max-width: 640px) {\n .usps-container {\n padding: 1rem;\n }\n \n .usps-logo {\n font-size: 2rem;\n }\n \n .users-grid {\n grid-template-columns: 1fr;\n }\n}",[],[167,234],"ce99700e-487a-11f0-90fc-76b3cceeab13","index.tsx","ce9970d6-487a-11f0-90fc-76b3cceeab13",12,["D",1749835273779],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from 'https://esm.sh/react@18.2.0';\nimport { createRoot } from 'https://esm.sh/react-dom@18.2.0/client';\nimport { App } from './components/App.tsx';\n\nconst root = createRoot(document.getElementById('root')!);\nroot.render();",[],[167,242],"95d107aa-487a-11f0-a9ec-76b3cceeab13","index.html","95d10886-487a-11f0-a9ec-76b3cceeab13",["D",1749835178513],"\n\n\n \n \n USPS Trivia Challenge\n \n \n \n \n \n \n\n\n

\n \n \n\n",[],[167,250],"abcd66a6-487b-11f0-859d-76b3cceeab13","UserList.tsx","b968f79a-487a-11f0-8aff-76b3cceeab13","5fae50f9-7d03-4f29-a772-7b21c26ce8cd",22,["D",1749835644894],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from 'https://esm.sh/react@18.2.0';\nimport type { User } from '../../shared/types.ts';\n\ninterface UserListProps {\n users: User[];\n currentUserId: string | null;\n}\n\nexport function UserList({ users, currentUserId }: UserListProps) {\n return (\n

\n 👥\n Postal Workers Online ({users.length}/30)\n

\n \n {users.length === 0 ? (\n

\n 📭\n

No postal workers online yet...

Be the first to join!

\n ) : (\n

\n {users.map((user) => (\n \n \n {user.name}\n {user.id === currentUserId && (\n 📍\n )}\n

\n ))}\n

\n )}\n \n

\n {users.length < 30 ? (\n

🚚 Waiting for more postal workers to join... ({30 - users.length} spots available)

\n ) : (\n

📮 Post office is full! Ready to start trivia!

\n )}\n

\n \n );\n}",[],[167,265,257],"components","a425be4e-487b-11f0-b71f-76b3cceeab13","NameEntry.tsx","b070df40-487a-11f0-bbee-76b3cceeab13",20,["D",1749835632051],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from 'https://esm.sh/react@18.2.0';\n\ninterface NameEntryProps {\n onJoin: (name: string) => void;\n isConnecting: boolean;\n error: string | null;\n}\n\nexport function NameEntry({ onJoin, isConnecting, error }: NameEntryProps) {\n const [name, setName] = useState('');\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n if (name.trim() && !isConnecting) {\n onJoin(name.trim());\n }\n };\n\n return (\n

\n 📮\n Join the Post Office Trivia Challenge\n

\n \n {error && (\n

\n {error}\n

\n )}\n \n

\n );\n}",[],[167,265,267],"a259f1fa-487d-11f0-9a4a-76b3cceeab13","Leaderboard.tsx","a259f3b2-487d-11f0-9a4a-76b3cceeab13",33,["D",1749836488035],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from 'https://esm.sh/react@18.2.0';\n\ninterface LeaderboardProps {\n leaderboard: { userId: string; name: string; score: number }[];\n currentUserId: string;\n}\n\nexport function Leaderboard({ leaderboard, currentUserId }: LeaderboardProps) {\n if (leaderboard.length === 0) {\n return null;\n }\n\n return (\n

\n 🏆\n Leaderboard\n

\n \n

\n {leaderboard.map((entry, index) => {\n const isCurrentUser = entry.userId === currentUserId;\n const position = index + 1;\n \n let positionIcon = '🥉';\n if (position === 1) positionIcon = '🥇';\n else if (position === 2) positionIcon = '🥈';\n \n return (\n \n

\n {positionIcon}\n

\n \n {entry.name}\n {isCurrentUser && (You)}\n \n

\n \n {entry.score} point{entry.score !== 1 ? 's' : ''}\n \n

\n );\n })}\n

\n \n );\n}",[],[167,265,275],"9aee4f7e-487d-11f0-932a-76b3cceeab13","GameRound.tsx","9aee5046-487d-11f0-932a-76b3cceeab13",32,["D",1749836475583],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from 'https://esm.sh/react@18.2.0';\nimport type { GameRound, User, Vote } from '../../shared/types.ts';\n\ninterface GameRoundProps {\n round: GameRound;\n users: User[];\n currentUserId: string;\n userVote: Vote | null;\n onVote: (guessedUserId: string) => void;\n onReveal: () => void;\n onSkip: () => void;\n isVoting: boolean;\n}\n\nexport function GameRoundComponent({ \n round, \n users, \n currentUserId, \n userVote, \n onVote, \n onReveal, \n onSkip, \n isVoting \n}: GameRoundProps) {\n const [selectedUserId, setSelectedUserId] = useState('');\n \n // Filter out the fact owner from voting options\n const votingOptions = users.filter(u => u.id !== round.fact.userId && u.id !== currentUserId);\n \n const handleVote = () => {\n if (selectedUserId && !userVote && !isVoting) {\n onVote(selectedUserId);\n }\n };\n\n const getVoteCount = (userId: string) => {\n return round.votes.filter(vote => vote.guessedUserId === userId).length;\n };\n\n const getVoterNames = (userId: string) => {\n const voters = round.votes\n .filter(vote => vote.guessedUserId === userId)\n .map(vote => users.find(u => u.id === vote.voterId)?.name)\n .filter(Boolean);\n return voters;\n };\n\n const isFactOwner = round.fact.userId === currentUserId;\n const hasVoted = !!userVote;\n const canReveal = round.votes.length > 0 && round.status === 'voting';\n\n return (\n

\n 🎯\n Guess Who: Round {round.id.slice(-4)}\n

\n \n {/* The Fact */}\n

Mystery Fact:

\"{round.fact.content}\"

\n\n {/* Voting Phase */}\n {round.status === 'voting' && (\n <>\n {isFactOwner ? (\n

\n 🤫\n

\n This is your fact! Wait for others to vote...\n

\n {round.votes.length} vote{round.votes.length !== 1 ? 's' : ''} cast so far\n

\n ) : hasVoted ? (\n

\n ✅\n

\n You voted for: {users.find(u => u.id === userVote.guessedUserId)?.name}\n

\n Waiting for others to vote... ({round.votes.length} total votes)\n

\n ) : (\n

Who do you think this fact belongs to?

\n \n

\n {votingOptions.map((user) => (\n \n setSelectedUserId(e.target.value)}\n className=\"sr-only\"\n />\n 👤\n {user.name}\n {round.votes.some(v => v.guessedUserId === user.id) && (\n \n {getVoteCount(user.id)} vote{getVoteCount(user.id) !== 1 ? 's' : ''}\n \n )}\n \n ))}\n

\n \n \n {isVoting ? (\n <>\n \n Casting Vote...\n \n ) : (\n <>\n 🗳️\n Cast Your Vote\n \n )}\n \n

\n )}\n \n )}\n\n {/* Results Phase */}\n {round.status === 'revealed' && (\n

\n 🎉\n Revealed! This fact belongs to:\n

\n {round.factOwner.name}\n

\n\n

Vote Results:

\n {votingOptions.map((user) => {\n const voteCount = getVoteCount(user.id);\n const voterNames = getVoterNames(user.id);\n const isCorrect = user.id === round.fact.userId;\n \n return (\n 0\n ? 'border-gray-300 bg-gray-50'\n : 'border-gray-200'\n }`}\n >\n

\n \n {isCorrect && ✅}\n {user.name}\n \n \n {voteCount} vote{voteCount !== 1 ? 's' : ''}\n \n

\n {voterNames.length > 0 && (\n

\n Voted by: {voterNames.join(', ')}\n

\n )}\n

\n );\n })}\n

\n )}\n\n {/* Action Buttons */}\n {round.status === 'voting' && (\n

\n {canReveal && (\n \n 🎭\n Reveal Answer\n \n )}\n \n ⏭️\n Skip This Round\n \n

\n )}\n \n );\n}",[],[167,265,283],"79e180de-487e-11f0-830a-76b3cceeab13","GameLobby.tsx","ad6f2e84-487d-11f0-aa0a-76b3cceeab13",43,["D",1749836849626],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from 'https://esm.sh/react@18.2.0';\nimport type { User } from '../../shared/types.ts';\n\ninterface GameLobbyProps {\n users: User[];\n currentUserId: string;\n onStartRound: () => void;\n isStarting: boolean;\n}\n\nexport function GameLobby({ users, currentUserId, onStartRound, isStarting }: GameLobbyProps) {\n const usersWithFacts = users.filter(u => u.fact);\n const usersWithoutFacts = users.filter(u => !u.fact);\n const canStartGame = usersWithFacts.length >= 2 && usersWithoutFacts.length === 0;\n const allFactsSubmitted = usersWithoutFacts.length === 0;\n\n return (\n

\n {/* Game Status */}\n

\n 🎮\n Game Status\n

\n \nexport function GameLobby({ users, currentUserId, onStartRound, isStarting }: GameLobbyProps) {\n const usersWithFacts = users.filter(u => u.fact);\n const usersWithoutFacts = users.filter(u => !u.fact);\n const canStartGame = usersWithFacts.length >= 2;\n const allFactsSubmitted = usersWithoutFacts.length === 0;\n\n return (\n

\n {/* Game Status */}\n

\n 🎮\n Game Status\n

\n \n

\n {usersWithFacts.length < 2 ? (\n

\n ⏳\n

\n Waiting for more players to submit facts...\n

\n Need at least 2 players with facts to start playing\n

\n {usersWithFacts.length} of {users.length} players have submitted facts\n

\n ) : (\n

\n 🚀\n

\n {allFactsSubmitted ? 'All facts collected!' : 'Ready to start!'} \n

\n {usersWithFacts.length} facts are queued up for guessing\n {!allFactsSubmitted && ` (${usersWithoutFacts.length} players still submitting)`}\n

\n \n {isStarting ? (\n <>\n \n Starting Round...\n \n ) : (\n <>\n 🎯\n Start First Round\n \n )}\n \n {!allFactsSubmitted && (\n

\n 💡 You can start now or wait for everyone to submit facts\n

\n )}\n

\n\n {/* Facts Status */}\n

\n 📊\n Facts Collection Progress\n

\n \n

\n {/* Progress Bar */}\n

\n Facts Submitted\n {usersWithFacts.length}/{users.length}\n

\n\n {/* Users with facts */}\n {usersWithFacts.length > 0 && (\n

\n ✅ Ready to play ({usersWithFacts.length}):\n

\n {usersWithFacts.map((user) => (\n \n {user.name}\n {user.id === currentUserId && ' (You)'}\n \n ))}\n

\n )}\n\n {/* Users without facts */}\n {usersWithoutFacts.length > 0 && (\n

\n ⏳ Still submitting facts ({usersWithoutFacts.length}):\n

\n {usersWithoutFacts.map((user) => (\n \n {user.name}\n {user.id === currentUserId && ' (You)'}\n \n ))}\n

\n )}\n

\n );\n}",[],[167,265,291],"825a7758-487d-11f0-b602-76b3cceeab13","FactEntry.tsx","825a7820-487d-11f0-b602-76b3cceeab13",31,["D",1749836434350],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from 'https://esm.sh/react@18.2.0';\n\ninterface FactEntryProps {\n onSubmitFact: (fact: string) => void;\n isSubmitting: boolean;\n error: string | null;\n}\n\nexport function FactEntry({ onSubmitFact, isSubmitting, error }: FactEntryProps) {\n const [fact, setFact] = useState('');\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n if (fact.trim() && !isSubmitting) {\n onSubmitFact(fact.trim());\n }\n };\n\n return (\n

\n 📝\n Share a Fun Fact About Yourself\n

\n \n {error && (\n

\n {error}\n

\n )}\n \n

\n \n Enter an interesting fact about yourself:\n \n setFact(e.target.value)}\n placeholder=\"e.g., I once met a celebrity at a coffee shop, I can juggle three balls, I've been to 15 countries...\"\n className=\"usps-input w-full h-24 resize-none\"\n maxLength={200}\n disabled={isSubmitting}\n autoFocus\n />\n

\n {fact.length}/200 characters\n

\n \n \n {isSubmitting ? (\n <>\n \n Submitting...\n \n ) : (\n <>\n 📮\n Submit Fact\n \n )}\n \n \n \n

💡 Make it interesting but not too obvious!

🎯 Other players will try to guess it's yours

\n );\n}",[],[167,265,299],"5fbce554-487e-11f0-b91a-76b3cceeab13","App.tsx","cb7bb2a6-487a-11f0-a437-76b3cceeab13",40,["D",1749836805769],5,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useRef } from 'https://esm.sh/react@18.2.0';\nimport type { User, GameState, Vote } from '../../shared/types.ts';\nimport { NameEntry } from './NameEntry.tsx';\nimport { UserList } from './UserList.tsx';\nimport { FactEntry } from './FactEntry.tsx';\nimport { GameLobby } from './GameLobby.tsx';\nimport { GameRoundComponent } from './GameRound.tsx';\nimport { Leaderboard } from './Leaderboard.tsx';\n\ndeclare global {\n interface Window {\n __INITIAL_DATA__?: GameState;\n }\n}\n\nexport function App() {\n const [gameState, setGameState] = useState({\n users: [],\n maxUsers: 30,\n gameStatus: 'waiting',\n leaderboard: []\n });\n const [currentUserId, setCurrentUserId] = useState(null);\n const [isConnecting, setIsConnecting] = useState(false);\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [isVoting, setIsVoting] = useState(false);\n const [isStarting, setIsStarting] = useState(false);\n const [error, setError] = useState(null);\n const [userVote, setUserVote] = useState(null);\n const pollIntervalRef = useRef(null);\n\n // Load initial data\n useEffect(() => {\n if (window.__INITIAL_DATA__) {\n setGameState(window.__INITIAL_DATA__);\n }\n }, []);\n\n const fetchGameState = async () => {\n try {\n const response = await fetch('/api/game-state');\n if (response.ok) {\n const newGameState = await response.json();\n setGameState(newGameState);\n \n // Update user vote if there's a current round\n if (newGameState.currentRound && currentUserId) {\n const vote = newGameState.currentRound.votes.find(\n (v: Vote) => v.voterId === currentUserId\n );\n setUserVote(vote || null);\n } else {\n setUserVote(null);\n }\n }\n } catch (err) {\n console.error('Failed to fetch game state:', err);\n }\n };\n\n const startPolling = () => {\n if (pollIntervalRef.current) return;\n pollIntervalRef.current = setInterval(fetchGameState, 2000); // Poll every 2 seconds\n };\n\n const stopPolling = () => {\n if (pollIntervalRef.current) {\n clearInterval(pollIntervalRef.current);\n pollIntervalRef.current = null;\n }\n };\n\n const handleJoin = async (name: string) => {\n setError(null);\n setIsConnecting(true);\n \n try {\n const response = await fetch('/api/join', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ name }),\n });\n \n const data = await response.json();\n \n if (response.ok) {\n setCurrentUserId(data.user.id);\n setGameState(prev => ({\n ...prev,\n users: [...prev.users, data.user]\n }));\n startPolling();\n } else {\n setError(data.error || 'Failed to join');\n }\n } catch (err) {\n setError('Connection error. Please try again.');\n console.error('Join error:', err);\n } finally {\n setIsConnecting(false);\n }\n };\n\n const handleSubmitFact = async (fact: string) => {\n if (!currentUserId) return;\n \n setError(null);\n setIsSubmitting(true);\n \n try {\n const response = await fetch('/api/submit-fact', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ userId: currentUserId, fact }),\n });\n \n const data = await response.json();\n \n if (response.ok) {\n await fetchGameState(); // Refresh game state\n } else {\n setError(data.error || 'Failed to submit fact');\n }\n } catch (err) {\n setError('Connection error. Please try again.');\n console.error('Submit fact error:', err);\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleStartRound = async () => {\n setError(null);\n setIsStarting(true);\n \n try {\n const response = await fetch('/api/start-round', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n });\n \n const data = await response.json();\n \n if (response.ok) {\n await fetchGameState(); // Refresh game state\n } else {\n setError(data.error || 'Failed to start round');\n }\n } catch (err) {\n setError('Connection error. Please try again.');\n console.error('Start round error:', err);\n } finally {\n setIsStarting(false);\n }\n };\n\n const handleVote = async (guessedUserId: string) => {\n if (!currentUserId || !gameState.currentRound) return;\n \n setError(null);\n setIsVoting(true);\n \n try {\n const response = await fetch('/api/vote', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n factId: gameState.currentRound.factId,\n voterId: currentUserId,\n guessedUserId\n }),\n });\n \n const data = await response.json();\n \n if (response.ok) {\n await fetchGameState(); // Refresh game state\n } else {\n setError(data.error || 'Failed to cast vote');\n }\n } catch (err) {\n setError('Connection error. Please try again.');\n console.error('Vote error:', err);\n } finally {\n setIsVoting(false);\n }\n };\n\n const handleReveal = async () => {\n setError(null);\n \n try {\n const response = await fetch('/api/reveal', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n });\n \n const data = await response.json();\n \n if (response.ok) {\n await fetchGameState(); // Refresh game state\n } else {\n setError(data.error || 'Failed to reveal answers');\n }\n } catch (err) {\n setError('Connection error. Please try again.');\n console.error('Reveal error:', err);\n }\n };\n\n const handleSkip = async () => {\n setError(null);\n \n try {\n const response = await fetch('/api/skip', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n });\n \n const data = await response.json();\n \n if (response.ok) {\n await fetchGameState(); // Refresh game state\n } else {\n setError(data.error || 'Failed to skip round');\n }\n } catch (err) {\n setError('Connection error. Please try again.');\n console.error('Skip error:', err);\n }\n };\n\n const handleLeave = async () => {\n if (!currentUserId) return;\n \n try {\n await fetch('/api/leave', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ userId: currentUserId }),\n });\n \n setCurrentUserId(null);\n setUserVote(null);\n stopPolling();\n await fetchGameState();\n } catch (err) {\n console.error('Leave error:', err);\n }\n };\n\n // Start polling when user joins\n useEffect(() => {\n if (currentUserId) {\n startPolling();\n }\n \n return () => {\n stopPolling();\n };\n }, [currentUserId]);\n\n // Handle page unload\n useEffect(() => {\n const handleBeforeUnload = () => {\n if (currentUserId) {\n navigator.sendBeacon('/api/leave', JSON.stringify({ userId: currentUserId }));\n }\n };\n\n window.addEventListener('beforeunload', handleBeforeUnload);\n return () => {\n window.removeEventListener('beforeunload', handleBeforeUnload);\n handleBeforeUnload();\n };\n }, [currentUserId]);\n\n const currentUser = gameState.users.find(u => u.id === currentUserId);\n\n return (\n

\n {/* Connection Status */}\n

\n \n Connected to Post Office Trivia\n

\n\n {/* Header */}\n

📮 USPS TRIVIA CHALLENGE

Test Your Team Knowledge

\n\n {/* Error Display */}\n {error && (\n

\n {error}\n

\n )}\n\n {/* Main Content */}\n {!currentUser ? (\n \n ) : (\n

\n {/* Welcome Message */}\n

\n 👋\n Welcome, {currentUser.name}!\n

🎯 You're now in the post office!

\n \n

\n\n {/* Game Content Based on Status */}\n {gameState.gameStatus === 'waiting' && (\n

\n ⏳\n

Waiting for more players...

Need at least 2 players to start collecting facts

\n )}\n\n {gameState.gameStatus === 'collecting_facts' && (\n <>\n {!currentUser.fact ? (\n \n ) : (\n

\n ✅\n Your Fact Submitted!\n

Your fact has been added to the queue:

\"{currentUser.fact}\"

Waiting for other players to submit their facts...

\n )}\n \n \n \n )}\n\n {gameState.gameStatus === 'playing' && gameState.currentRound && (\n \n )}\n\n {gameState.gameStatus === 'playing' && !gameState.currentRound && (\n

\n 🎯\n

Ready for the next round!

\n \n {isStarting ? (\n <>\n \n Starting Round...\n \n ) : (\n <>\n 🚀\n Start Next Round\n \n )}\n \n

\n )}\n\n {/* Leaderboard */}\n \n \n {/* User List */}\n \n

\n )}\n

\n );\n}",[],[167,265,307],"b070eefe-487a-11f0-bbee-76b3cceeab13",9,["D",1749835223180],[196,197,198,199,200,201,202],[167,265],["D",1749835178513],[195,203,204,205],[167],"f73cc9e4-487e-11f0-aecf-76b3cceeab13","index.ts",45,["D",1749837059942],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { \n getActiveUsers, \n addUser, \n removeUser, \n cleanupInactiveUsers,\n submitUserFact,\n getAllFacts,\n getUnusedFacts,\n createRound,\n getCurrentRound,\n updateRoundStatus,\n castVote,\n getVotesForFact,\n getUserVoteForFact,\n updateUserScore,\n getLeaderboard\n} from \"./database/queries.ts\";\nimport type { User, GameState } from \"../shared/types.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database\nawait runMigrations();\n\n// Clean up inactive users periodically\nsetInterval(cleanupInactiveUsers, 60000); // Every minute\n\n// Helper function to determine game status\nasync function getGameState(): Promise {\n const users = await getActiveUsers();\n const currentRound = await getCurrentRound();\n const leaderboard = await getLeaderboard();\n \n let gameStatus: GameState['gameStatus'] = 'waiting';\n \n if (users.length >= 2) {\n const usersWithFacts = users.filter(u => u.fact);\n \n // If there's an active round, we're playing\n if (currentRound && currentRound.status === 'voting') {\n gameStatus = 'playing';\n }\n // If all users have facts and we have at least 2 facts, we can play\n else if (usersWithFacts.length >= 2 && usersWithFacts.length === users.length) {\n gameStatus = 'playing';\n }\n // If we have 2+ users but not everyone has submitted facts, collect facts\n else {\n gameStatus = 'collecting_facts';\n }\n }\n \n return {\n users,\n maxUsers: 30,\n gameStatus,\n currentRound: currentRound || undefined,\n leaderboard\n };\n}\n\n// API endpoints\napp.get('/api/game-state', async (c) => {\n const gameState = await getGameState();\n return c.json(gameState);\n});\n\napp.get('/api/users', async (c) => {\n const users = await getActiveUsers();\n return c.json({ users });\n});\n\napp.post('/api/join', async (c) => {\n const { name } = await c.req.json();\n \n if (!name || typeof name !== 'string' || !name.trim()) {\n return c.json({ error: 'Name is required' }, 400);\n }\n \n // Check if we're at capacity\n const activeUsers = await getActiveUsers();\n if (activeUsers.length >= 30) {\n return c.json({ error: 'Game is full! Maximum 30 players allowed.' }, 400);\n }\n \n const user: User = {\n id: crypto.randomUUID(),\n name: name.trim(),\n joinedAt: Date.now(),\n isActive: true,\n score: 0\n };\n \n await addUser(user);\n return c.json({ user });\n});\n\napp.post('/api/leave', async (c) => {\n const { userId } = await c.req.json();\n \n if (!userId) {\n return c.json({ error: 'User ID is required' }, 400);\n }\n \n await removeUser(userId);\n return c.json({ success: true });\n});\n\napp.post('/api/submit-fact', async (c) => {\n const { userId, fact } = await c.req.json();\n \n if (!userId || !fact || typeof fact !== 'string' || !fact.trim()) {\n return c.json({ error: 'User ID and fact are required' }, 400);\n }\n \n await submitUserFact(userId, fact.trim());\n return c.json({ success: true });\n});\n\napp.post('/api/start-round', async (c) => {\n const unusedFacts = await getUnusedFacts();\n \n if (unusedFacts.length === 0) {\n return c.json({ error: 'No unused facts available' }, 400);\n }\n \n // Check if there's already an active round\n const currentRound = await getCurrentRound();\n if (currentRound && currentRound.status === 'voting') {\n return c.json({ error: 'There is already an active round' }, 400);\n }\n \n // Select a random fact\n const randomFact = unusedFacts[Math.floor(Math.random() * unusedFacts.length)];\n const roundId = await createRound(randomFact.id);\n \n return c.json({ success: true, roundId });\n});\n\napp.post('/api/vote', async (c) => {\n const { factId, voterId, guessedUserId } = await c.req.json();\n \n if (!factId || !voterId || !guessedUserId) {\n return c.json({ error: 'Fact ID, voter ID, and guessed user ID are required' }, 400);\n }\n \n // Check if user is trying to vote for themselves\n const currentRound = await getCurrentRound();\n if (currentRound && currentRound.fact.userId === voterId) {\n return c.json({ error: 'You cannot vote on your own fact' }, 400);\n }\n \n if (voterId === guessedUserId) {\n return c.json({ error: 'You cannot vote for yourself' }, 400);\n }\n \n await castVote(factId, voterId, guessedUserId);\n return c.json({ success: true });\n});\n\napp.post('/api/reveal', async (c) => {\n const currentRound = await getCurrentRound();\n \n if (!currentRound) {\n return c.json({ error: 'No active round' }, 400);\n }\n \n await updateRoundStatus(currentRound.id, 'revealed');\n \n // Award points to users who guessed correctly\n const votes = await getVotesForFact(currentRound.factId);\n const correctVotes = votes.filter(vote => vote.guessedUserId === currentRound.fact.userId);\n \n for (const vote of correctVotes) {\n await updateUserScore(vote.voterId, 1);\n }\n \n return c.json({ success: true });\n});\n\napp.post('/api/skip', async (c) => {\n const currentRound = await getCurrentRound();\n \n if (!currentRound) {\n return c.json({ error: 'No active round' }, 400);\n }\n \n await updateRoundStatus(currentRound.id, 'skipped');\n return c.json({ success: true });\n});\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main page with initial data\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial data\n const gameState = await getGameState();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\nexport default app.fetch;",[],[172,324],"89bfe152-487a-11f0-a94d-76b3cceeab13","websocket.ts","89bfe224-487a-11f0-a94d-76b3cceeab13","6632b6df-bc4c-494c-a4ec-af84ee2c1d2e",["D",1749835158263],"import type { WSMessage, WSClientMessage, User } from \"../../shared/types.ts\";\nimport { addUser, removeUser, getActiveUsers, updateUserLastSeen } from \"../database/queries.ts\";\n\n// Store active WebSocket connections\nconst connections = new Map();\n\nexport function handleWebSocket(ws: WebSocket) {\n let userId: string | null = null;\n \n ws.onopen = () => {\n console.log('WebSocket connection opened');\n };\n \n ws.onmessage = async (event) => {\n try {\n const message: WSClientMessage = JSON.parse(event.data);\n \n switch (message.type) {\n case 'join':\n if (message.name && message.name.trim()) {\n userId = crypto.randomUUID();\n const user: User = {\n id: userId,\n name: message.name.trim(),\n joinedAt: Date.now(),\n isActive: true\n };\n \n // Check if we're at capacity (10 users max)\n const activeUsers = await getActiveUsers();\n if (activeUsers.length >= 10) {\n sendMessage(ws, { type: 'error', message: 'Game is full! Maximum 10 players allowed.' });\n return;\n }\n \n // Add user to database and connections\n await addUser(user);\n connections.set(userId, ws);\n \n // Broadcast user joined to all clients\n const updatedUsers = await getActiveUsers();\n broadcastToAll({ type: 'user_joined', user });\n broadcastToAll({ type: 'users_update', users: updatedUsers });\n \n console.log(`User ${user.name} joined with ID ${userId}`);\n }\n break;\n \n case 'leave':\n if (userId) {\n await handleUserLeave(userId);\n }\n break;\n }\n } catch (error) {\n console.error('WebSocket message error:', error);\n sendMessage(ws, { type: 'error', message: 'Invalid message format' });\n }\n };\n \n ws.onclose = async () => {\n if (userId) {\n await handleUserLeave(userId);\n }\n console.log('WebSocket connection closed');\n };\n \n ws.onerror = (error) => {\n console.error('WebSocket error:', error);\n };\n \n // Send periodic heartbeat to keep connection alive\n const heartbeat = setInterval(() => {\n if (ws.readyState === WebSocket.OPEN && userId) {\n updateUserLastSeen(userId);\n } else {\n clearInterval(heartbeat);\n }\n }, 30000); // 30 seconds\n}\n\nasync function handleUserLeave(userId: string) {\n connections.delete(userId);\n await removeUser(userId);\n \n const updatedUsers = await getActiveUsers();\n broadcastToAll({ type: 'user_left', userId });\n broadcastToAll({ type: 'users_update', users: updatedUsers });\n \n console.log(`User ${userId} left`);\n}\n\nfunction sendMessage(ws: WebSocket, message: WSMessage) {\n if (ws.readyState === WebSocket.OPEN) {\n ws.send(JSON.stringify(message));\n }\n}\n\nfunction broadcastToAll(message: WSMessage) {\n connections.forEach((ws) => {\n sendMessage(ws, message);\n });\n}\n\n// Cleanup inactive users periodically\nsetInterval(async () => {\n const activeUsers = await getActiveUsers();\n const connectedUserIds = new Set(connections.keys());\n \n // Remove users who are in DB but not connected\n for (const user of activeUsers) {\n if (!connectedUserIds.has(user.id)) {\n await removeUser(user.id);\n }\n }\n}, 60000); // Every minute",[],[172,339,332],"routes","89bff9a8-487a-11f0-a94d-76b3cceeab13",["D",1749835158263],[192],[172,339],"5591c92c-4884-11f0-b7a6-76b3cceeab13","3b28ec05-0c71-4810-a4d1-e1c4f1963b39",["D",1749839365689],[],[172,349,33],"database","44f90bb8-487d-11f0-b482-76b3cceeab13","migrations.ts","763340c0-487a-11f0-b784-76b3cceeab13",28,["D",1749836331368],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst USERS_TABLE = 'usps_trivia_users_v2';\nconst FACTS_TABLE = 'usps_trivia_facts_v1';\nconst VOTES_TABLE = 'usps_trivia_votes_v1';\nconst ROUNDS_TABLE = 'usps_trivia_rounds_v1';\n\nexport async function runMigrations() {\n // Create users table for tracking active sessions\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n joined_at INTEGER NOT NULL,\n last_seen INTEGER NOT NULL,\n is_active BOOLEAN DEFAULT 1,\n fact TEXT,\n score INTEGER DEFAULT 0\n )\n `);\n \n // Create facts table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${FACTS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n content TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id)\n )\n `);\n \n // Create votes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${VOTES_TABLE} (\n id TEXT PRIMARY KEY,\n fact_id TEXT NOT NULL,\n voter_id TEXT NOT NULL,\n guessed_user_id TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n FOREIGN KEY (fact_id) REFERENCES ${FACTS_TABLE} (id),\n FOREIGN KEY (voter_id) REFERENCES ${USERS_TABLE} (id),\n FOREIGN KEY (guessed_user_id) REFERENCES ${USERS_TABLE} (id),\n UNIQUE(fact_id, voter_id)\n )\n `);\n \n // Create rounds table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${ROUNDS_TABLE} (\n id TEXT PRIMARY KEY,\n fact_id TEXT NOT NULL,\n status TEXT DEFAULT 'voting',\n created_at INTEGER NOT NULL,\n FOREIGN KEY (fact_id) REFERENCES ${FACTS_TABLE} (id)\n )\n `);\n \n console.log('Database migrations completed');\n}\n\nexport { USERS_TABLE, FACTS_TABLE, VOTES_TABLE, ROUNDS_TABLE };",[],[172,349,351],"76334b60-487a-11f0-b784-76b3cceeab13",["D",1749835125467],[189,190],[172,349],["D",1749835125467],[188,191,193],[172],["D",1749834559473],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"ctx",{"_79":-5,"_124":402,"_403":404,"_405":406,"_407":25,"_408":25,"_409":25,"_410":59,"_411":-5,"_412":-7,"_413":-7,"_414":63,"_415":25,"_416":25,"_417":-5,"_418":25,"_419":25,"_420":25,"_421":-5},"ENV",{"_373":374,"_375":376,"_377":87,"_378":379,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397,"_398":399,"_400":401},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v49