[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_345":346,"_347":348},"routes/_app.x.$handle.$name",{"_95":94,"_32":44,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":57,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",36,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",false,"deletedHere","path","README.md","latestPath","fileId","6db52314-487a-11f0-816c-76b3cceeab13","name","fileType","content","# USPS Trivia Game\n\nA realtime trivia game themed like a USPS post office, supporting up to 30 concurrent users.\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- Prepared for team knowledge trivia functionality\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main Hono server with WebSocket support\n│ ├── database/\n│ │ ├── migrations.ts # SQLite schema setup\n│ │ └── queries.ts # Database query functions\n│ └── routes/\n│ └── websocket.ts # WebSocket connection handling\n├── frontend/\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # React frontend entry point\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── NameEntry.tsx # Name entry form\n│ │ └── UserList.tsx # Online users display\n│ └── style.css # USPS-themed styles\n└── shared/\n └── types.ts # Shared TypeScript types\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\n- ✅ Real-time user presence (up to 30 players)\n- ✅ USPS theming\n- 🚧 Team knowledge trivia functionality (coming next)","# USPS Trivia Game\n\nA realtime trivia game themed like a USPS post office, supporting up to 30 concurrent users.\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**: Share an interesting fact about yourself\n3. **Wait for Others**: Game starts 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 → Submit Fact → Wait for Others → \nVote on Random Facts → See Results → Earn Points → \nNext Round → Repeat\n```\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main Hono server with WebSocket support\n│ ├── database/\n│ │ ├── migrations.ts # SQLite schema setup\n│ │ └── queries.ts # Database query functions\n│ └── routes/\n│ └── websocket.ts # WebSocket connection handling\n├── frontend/\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # React frontend entry point\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── NameEntry.tsx # Name entry form\n│ │ └── UserList.tsx # Online users display\n│ └── style.css # USPS-themed styles\n└── shared/\n └── types.ts # Shared TypeScript types\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\n- ✅ Real-time user presence (up to 30 players)\n- ✅ USPS theming\n- 🚧 Team knowledge trivia functionality (coming next)","createdAt",["D",1749836586315],"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",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"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",{"_42":43,"_32":44,"_37":341,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":342,"_79":343,"_81":344,"_83":25},"tree",[165,172,184,186],"files",[165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186],"counts",{"_155":61,"_156":140,"_157":61,"_158":159,"_160":161},"contents",[126,127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{"_55":125},"trivia.mitchinson.dev",{"_42":150,"_32":151,"_30":152,"_131":-5,"_40":41,"_39":134,"_132":57,"_37":153,"_13":61,"_33":142,"_34":-5,"_24":25,"_135":-5,"_27":154},{"_42":144,"_32":145,"_30":146,"_131":-5,"_40":41,"_39":147,"_132":57,"_37":148,"_13":61,"_33":142,"_34":-5,"_24":25,"_135":-5,"_27":149},{"_42":137,"_32":138,"_30":139,"_131":-5,"_40":41,"_39":140,"_132":57,"_37":141,"_13":61,"_33":142,"_34":-5,"_24":25,"_135":-5,"_27":143},{"_42":130,"_32":28,"_30":31,"_131":-5,"_40":41,"_39":14,"_132":25,"_37":133,"_13":134,"_33":20,"_34":36,"_24":25,"_135":-5,"_27":136},"dcfce9e8-487d-11f0-97c1-76b3cceeab13","parentId","latest",["D",1749836586315],3,"label",[28],"7205417e-487a-11f0-aed0-76b3cceeab13","shared","871b29af-733c-45f6-a07c-d1731f9bbc70",2,["D",1749835118445],"directory",[138],"95d110ba-487a-11f0-a9ec-76b3cceeab13","frontend","17fa2a23-aa00-4bd0-bfd3-b43b6bc9c778",7,["D",1749835178513],[145],"76334980-487a-11f0-b784-76b3cceeab13","backend","379e532e-042e-4e9e-8f33-6863d167ea3b",["D",1749835125467],[151],"pulls","branches","forks","envVars",{"_162":61,"_164":61},"connections",{"_162":61,"_163":61},"count","unfilledCount","emptyCount",{"_42":150,"_32":151,"_30":152,"_131":-5,"_40":41,"_39":134,"_132":57,"_37":338,"_13":61,"_33":142,"_34":-5,"_24":25,"_135":-5,"_188":339,"_27":340},{"_42":334,"_32":325,"_30":319,"_131":152,"_40":41,"_39":134,"_132":57,"_37":335,"_13":61,"_33":142,"_34":-5,"_24":25,"_135":-5,"_188":336,"_27":337},{"_42":326,"_32":327,"_30":328,"_131":319,"_40":41,"_39":329,"_132":57,"_37":330,"_13":196,"_33":197,"_34":331,"_24":25,"_135":-5,"_188":332,"_27":333},{"_42":316,"_32":317,"_30":318,"_131":319,"_40":41,"_39":320,"_132":25,"_37":321,"_13":196,"_33":197,"_34":322,"_24":25,"_135":-5,"_188":323,"_27":324},{"_42":312,"_32":311,"_30":306,"_131":152,"_40":41,"_39":298,"_132":57,"_37":313,"_13":61,"_33":142,"_34":-5,"_24":25,"_135":-5,"_188":314,"_27":315},{"_42":303,"_32":304,"_30":305,"_131":306,"_40":41,"_39":298,"_132":25,"_37":307,"_13":61,"_33":197,"_34":308,"_24":25,"_135":-5,"_188":309,"_27":310},{"_42":294,"_32":295,"_30":55,"_131":152,"_40":41,"_39":296,"_132":25,"_37":297,"_13":298,"_33":299,"_34":300,"_24":25,"_135":-5,"_188":301,"_27":302},{"_42":144,"_32":145,"_30":146,"_131":-5,"_40":41,"_39":147,"_132":57,"_37":291,"_13":61,"_33":142,"_34":-5,"_24":25,"_135":-5,"_188":292,"_27":293},{"_42":286,"_32":236,"_30":230,"_131":146,"_40":41,"_39":287,"_132":57,"_37":288,"_13":61,"_33":142,"_34":-5,"_24":25,"_135":-5,"_188":289,"_27":290},{"_42":277,"_32":278,"_30":279,"_131":230,"_40":41,"_39":280,"_132":25,"_37":281,"_13":282,"_33":197,"_34":283,"_24":25,"_135":-5,"_188":284,"_27":285},{"_42":269,"_32":270,"_30":271,"_131":230,"_40":41,"_39":272,"_132":25,"_37":273,"_13":61,"_33":197,"_34":274,"_24":25,"_135":-5,"_188":275,"_27":276},{"_42":261,"_32":262,"_30":263,"_131":230,"_40":41,"_39":264,"_132":25,"_37":265,"_13":61,"_33":197,"_34":266,"_24":25,"_135":-5,"_188":267,"_27":268},{"_42":253,"_32":254,"_30":255,"_131":230,"_40":41,"_39":256,"_132":25,"_37":257,"_13":61,"_33":197,"_34":258,"_24":25,"_135":-5,"_188":259,"_27":260},{"_42":245,"_32":246,"_30":247,"_131":230,"_40":41,"_39":248,"_132":25,"_37":249,"_13":61,"_33":197,"_34":250,"_24":25,"_135":-5,"_188":251,"_27":252},{"_42":237,"_32":238,"_30":239,"_131":230,"_40":41,"_39":240,"_132":25,"_37":241,"_13":134,"_33":197,"_34":242,"_24":25,"_135":-5,"_188":243,"_27":244},{"_42":227,"_32":228,"_30":229,"_131":230,"_40":41,"_39":231,"_132":25,"_37":232,"_13":140,"_33":197,"_34":233,"_24":25,"_135":-5,"_188":234,"_27":235},{"_42":220,"_32":221,"_30":222,"_131":146,"_40":41,"_39":147,"_132":25,"_37":223,"_13":61,"_33":20,"_34":224,"_24":25,"_135":-5,"_188":225,"_27":226},{"_42":212,"_32":213,"_30":214,"_131":146,"_40":41,"_39":215,"_132":57,"_37":216,"_13":61,"_33":197,"_34":217,"_24":25,"_135":-5,"_188":218,"_27":219},{"_42":204,"_32":205,"_30":206,"_131":146,"_40":41,"_39":207,"_132":25,"_37":208,"_13":61,"_33":20,"_34":209,"_24":25,"_135":-5,"_188":210,"_27":211},{"_42":137,"_32":138,"_30":139,"_131":-5,"_40":41,"_39":140,"_132":57,"_37":201,"_13":61,"_33":142,"_34":-5,"_24":25,"_135":-5,"_188":202,"_27":203},{"_42":191,"_32":192,"_30":193,"_131":139,"_40":41,"_39":194,"_132":57,"_37":195,"_13":196,"_33":197,"_34":198,"_24":25,"_135":-5,"_188":199,"_27":200},{"_42":130,"_32":28,"_30":31,"_131":-5,"_40":41,"_39":14,"_132":25,"_37":187,"_13":134,"_33":20,"_34":36,"_24":25,"_135":-5,"_188":189,"_27":190},["D",1749836586315],"children",[],[28],"3c65a98e-487d-11f0-8413-76b3cceeab13","types.ts","72053a8a-487a-11f0-aed0-76b3cceeab13",27,["D",1749836316977],1,"script","// 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}",[],[138,192],["D",1749835118445],[185],[138],"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}",[],[145,205],"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();",[],[145,213],"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",[],[145,221],"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}",[],[145,236,228],"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}",[],[145,236,238],"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}",[],[145,236,246],"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}",[],[145,236,254],"ad6f2dd0-487d-11f0-aa0a-76b3cceeab13","GameLobby.tsx","ad6f2e84-487d-11f0-aa0a-76b3cceeab13",34,["D",1749836506627],"/** @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;\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 ) : (\n

\n 🚀\n

\n Ready to start the trivia game!\n

\n \n {isStarting ? (\n <>\n \n Starting Round...\n \n ) : (\n <>\n 🎯\n Start First Round\n \n )}\n \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 );\n}",[],[145,236,262],"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}",[],[145,236,270],"cf3d007c-487d-11f0-a427-76b3cceeab13","App.tsx","cb7bb2a6-487a-11f0-a437-76b3cceeab13",35,["D",1749836563334],4,"/** @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' && !currentUser.fact && (\n \n )}\n\n {gameState.gameStatus === 'collecting_facts' && currentUser.fact && (\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}",[],[145,236,278],"b070eefe-487a-11f0-bbee-76b3cceeab13",9,["D",1749835223180],[174,175,176,177,178,179,180],[145,236],["D",1749835178513],[173,181,182,183],[145],"7945a520-487d-11f0-8e49-76b3cceeab13","index.ts",30,["D",1749836419108],5,"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 if (usersWithFacts.length < users.length) {\n gameStatus = 'collecting_facts';\n } else if (currentRound || usersWithFacts.length > 0) {\n gameStatus = 'playing';\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 // 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;",[],[151,295],"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",[],[151,311,304],"routes","89bff9a8-487a-11f0-a94d-76b3cceeab13",["D",1749835158263],[170],[151,311],"5f94bc92-487d-11f0-bd9d-76b3cceeab13","queries.ts","7d9c5bbc-487a-11f0-810d-76b3cceeab13","3b28ec05-0c71-4810-a4d1-e1c4f1963b39",29,["D",1749836376006],"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}",[],[151,325,317],"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 };",[],[151,325,327],"76334b60-487a-11f0-b784-76b3cceeab13",["D",1749835125467],[167,168],[151,325],["D",1749835125467],[166,169,171],[151],["D",1749834559473],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":25},{"_13":84,"_32":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":378,"_379":380,"_381":382,"_383":25,"_384":25,"_385":25,"_386":57,"_387":-5,"_388":-7,"_389":-7,"_390":61,"_391":25,"_392":25,"_393":-5,"_394":25,"_395":25,"_396":25,"_397":-5},"ENV",{"_349":350,"_351":352,"_353":85,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377},"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 · v36