[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_334":335,"_336":337},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_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,"_31":44,"_37":45,"_46":-5,"_47":24,"_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":24},"version",33,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/Leaderboard.tsx","latestPath","fileId","a259f3b2-487d-11f0-9a4a-76b3cceeab13","name","Leaderboard.tsx","fileType","script","content","/** @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}","createdAt",["D",1749836488035],"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":24},"branch",{"_13":84,"_31":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,"_31":44,"_37":330,"_46":-5,"_47":24,"_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":331,"_79":332,"_81":333,"_83":24},"tree",[169,176,187,189],"files",[169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189],"counts",{"_159":61,"_160":137,"_161":61,"_162":163,"_164":165},"contents",[126,127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{"_55":125},"trivia.mitchinson.dev",{"_42":153,"_31":154,"_29":155,"_133":-5,"_40":41,"_39":156,"_135":57,"_37":157,"_13":61,"_33":145,"_35":-5,"_23":24,"_139":-5,"_26":158},{"_42":147,"_31":148,"_29":149,"_133":-5,"_40":41,"_39":150,"_135":57,"_37":151,"_13":61,"_33":145,"_35":-5,"_23":24,"_139":-5,"_26":152},{"_42":141,"_31":142,"_29":143,"_133":-5,"_40":41,"_39":137,"_135":57,"_37":144,"_13":61,"_33":145,"_35":-5,"_23":24,"_139":-5,"_26":146},{"_42":130,"_31":131,"_29":132,"_133":-5,"_40":41,"_39":134,"_135":24,"_37":136,"_13":137,"_33":20,"_35":138,"_23":24,"_139":-5,"_26":140},"be63d700-487b-11f0-9445-76b3cceeab13","README.md","6db52314-487a-11f0-816c-76b3cceeab13","parentId",26,"latest",["D",1749835676075],2,"# 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)","label",[131],"7205417e-487a-11f0-aed0-76b3cceeab13","shared","871b29af-733c-45f6-a07c-d1731f9bbc70",["D",1749835118445],"directory",[142],"95d110ba-487a-11f0-a9ec-76b3cceeab13","frontend","17fa2a23-aa00-4bd0-bfd3-b43b6bc9c778",7,["D",1749835178513],[148],"76334980-487a-11f0-b784-76b3cceeab13","backend","379e532e-042e-4e9e-8f33-6863d167ea3b",3,["D",1749835125467],[154],"pulls","branches","forks","envVars",{"_166":61,"_168":61},"connections",{"_166":61,"_167":61},"count","unfilledCount","emptyCount",{"_42":153,"_31":154,"_29":155,"_133":-5,"_40":41,"_39":156,"_135":57,"_37":327,"_13":61,"_33":145,"_35":-5,"_23":24,"_139":-5,"_191":328,"_26":329},{"_42":323,"_31":314,"_29":308,"_133":155,"_40":41,"_39":156,"_135":57,"_37":324,"_13":61,"_33":145,"_35":-5,"_23":24,"_139":-5,"_191":325,"_26":326},{"_42":315,"_31":316,"_29":317,"_133":308,"_40":41,"_39":318,"_135":57,"_37":319,"_13":199,"_33":34,"_35":320,"_23":24,"_139":-5,"_191":321,"_26":322},{"_42":305,"_31":306,"_29":307,"_133":308,"_40":41,"_39":309,"_135":24,"_37":310,"_13":199,"_33":34,"_35":311,"_23":24,"_139":-5,"_191":312,"_26":313},{"_42":301,"_31":300,"_29":295,"_133":155,"_40":41,"_39":287,"_135":57,"_37":302,"_13":61,"_33":145,"_35":-5,"_23":24,"_139":-5,"_191":303,"_26":304},{"_42":292,"_31":293,"_29":294,"_133":295,"_40":41,"_39":287,"_135":24,"_37":296,"_13":61,"_33":34,"_35":297,"_23":24,"_139":-5,"_191":298,"_26":299},{"_42":283,"_31":284,"_29":55,"_133":155,"_40":41,"_39":285,"_135":24,"_37":286,"_13":287,"_33":288,"_35":289,"_23":24,"_139":-5,"_191":290,"_26":291},{"_42":147,"_31":148,"_29":149,"_133":-5,"_40":41,"_39":150,"_135":57,"_37":280,"_13":61,"_33":145,"_35":-5,"_23":24,"_139":-5,"_191":281,"_26":282},{"_42":275,"_31":238,"_29":232,"_133":149,"_40":41,"_39":276,"_135":57,"_37":277,"_13":61,"_33":145,"_35":-5,"_23":24,"_139":-5,"_191":278,"_26":279},{"_42":267,"_31":268,"_29":269,"_133":232,"_40":41,"_39":270,"_135":24,"_37":271,"_13":156,"_33":34,"_35":272,"_23":24,"_139":-5,"_191":273,"_26":274},{"_42":259,"_31":260,"_29":261,"_133":232,"_40":41,"_39":262,"_135":24,"_37":263,"_13":61,"_33":34,"_35":264,"_23":24,"_139":-5,"_191":265,"_26":266},{"_42":251,"_31":252,"_29":253,"_133":232,"_40":41,"_39":254,"_135":24,"_37":255,"_13":61,"_33":34,"_35":256,"_23":24,"_139":-5,"_191":257,"_26":258},{"_42":247,"_31":32,"_29":30,"_133":232,"_40":41,"_39":14,"_135":24,"_37":248,"_13":61,"_33":34,"_35":36,"_23":24,"_139":-5,"_191":249,"_26":250},{"_42":239,"_31":240,"_29":241,"_133":232,"_40":41,"_39":242,"_135":24,"_37":243,"_13":156,"_33":34,"_35":244,"_23":24,"_139":-5,"_191":245,"_26":246},{"_42":229,"_31":230,"_29":231,"_133":232,"_40":41,"_39":233,"_135":24,"_37":234,"_13":137,"_33":34,"_35":235,"_23":24,"_139":-5,"_191":236,"_26":237},{"_42":222,"_31":223,"_29":224,"_133":149,"_40":41,"_39":150,"_135":24,"_37":225,"_13":61,"_33":20,"_35":226,"_23":24,"_139":-5,"_191":227,"_26":228},{"_42":214,"_31":215,"_29":216,"_133":149,"_40":41,"_39":217,"_135":57,"_37":218,"_13":61,"_33":34,"_35":219,"_23":24,"_139":-5,"_191":220,"_26":221},{"_42":206,"_31":207,"_29":208,"_133":149,"_40":41,"_39":209,"_135":24,"_37":210,"_13":61,"_33":20,"_35":211,"_23":24,"_139":-5,"_191":212,"_26":213},{"_42":141,"_31":142,"_29":143,"_133":-5,"_40":41,"_39":137,"_135":57,"_37":203,"_13":61,"_33":145,"_35":-5,"_23":24,"_139":-5,"_191":204,"_26":205},{"_42":194,"_31":195,"_29":196,"_133":143,"_40":41,"_39":197,"_135":57,"_37":198,"_13":199,"_33":34,"_35":200,"_23":24,"_139":-5,"_191":201,"_26":202},{"_42":130,"_31":131,"_29":132,"_133":-5,"_40":41,"_39":134,"_135":24,"_37":190,"_13":137,"_33":20,"_35":138,"_23":24,"_139":-5,"_191":192,"_26":193},["D",1749835676075],"children",[],[131],"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}",[],[142,195],["D",1749835118445],[188],[142],"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}",[],[148,207],"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();",[],[148,215],"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",[],[148,223],"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}",[],[148,238,230],"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}",[],[148,238,240],"a259f1fa-487d-11f0-9a4a-76b3cceeab13",["D",1749836488035],[],[148,238,32],"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}",[],[148,238,252],"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}",[],[148,238,260],"b2a75586-487b-11f0-8dd3-76b3cceeab13","App.tsx","cb7bb2a6-487a-11f0-a437-76b3cceeab13",24,["D",1749835656388],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useRef } from 'https://esm.sh/react@18.2.0';\nimport type { User } from '../../shared/types.ts';\nimport { NameEntry } from './NameEntry.tsx';\nimport { UserList } from './UserList.tsx';\n\ndeclare global {\n interface Window {\n __INITIAL_DATA__?: {\n users: User[];\n };\n }\n}\n\nexport function App() {\n const [users, setUsers] = useState([]);\n const [currentUserId, setCurrentUserId] = useState(null);\n const [isConnecting, setIsConnecting] = useState(false);\n const [error, setError] = useState(null);\n const pollIntervalRef = useRef(null);\n\n // Load initial data\n useEffect(() => {\n if (window.__INITIAL_DATA__) {\n setUsers(window.__INITIAL_DATA__.users);\n }\n }, []);\n\n const fetchUsers = async () => {\n try {\n const response = await fetch('/api/users');\n if (response.ok) {\n const data = await response.json();\n setUsers(data.users);\n }\n } catch (err) {\n console.error('Failed to fetch users:', err);\n }\n };\n\n const startPolling = () => {\n if (pollIntervalRef.current) return;\n \n pollIntervalRef.current = setInterval(fetchUsers, 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: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ name }),\n });\n \n const data = await response.json();\n \n if (response.ok) {\n setCurrentUserId(data.user.id);\n setUsers(prev => [...prev, data.user]);\n startPolling(); // Start polling for updates\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 handleLeave = async () => {\n if (!currentUserId) return;\n \n try {\n await fetch('/api/leave', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ userId: currentUserId }),\n });\n \n setCurrentUserId(null);\n stopPolling();\n await fetchUsers(); // Refresh user list\n } catch (err) {\n console.error('Leave error:', err);\n }\n };\n\n // Start polling when component mounts if user is already joined\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 // Use sendBeacon for reliable cleanup on page unload\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 = 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 {/* Main Content */}\n {!currentUser ? (\n \n ) : (\n <>\n

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

🎯 You're now in the post office!

Trivia questions coming soon...

\n \n

\n \n \n \n )}\n

\n );\n}",[],[148,238,268],"b070eefe-487a-11f0-bbee-76b3cceeab13",9,["D",1749835223180],[178,179,180,181,182,183],[148,238],["D",1749835178513],[177,184,185,186],[148],"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;",[],[154,284],"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",[],[154,300,293],"routes","89bff9a8-487a-11f0-a94d-76b3cceeab13",["D",1749835158263],[174],[154,300],"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}",[],[154,314,306],"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 };",[],[154,314,316],"76334b60-487a-11f0-b784-76b3cceeab13",["D",1749835125467],[171,172],[154,314],["D",1749835125467],[170,173,175],[154],["D",1749834559473],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":367,"_368":369,"_370":371,"_372":24,"_373":24,"_374":24,"_375":57,"_376":-5,"_377":-7,"_378":-7,"_379":61,"_380":24,"_381":24,"_382":-5,"_383":24,"_384":24,"_385":24,"_386":-5},"ENV",{"_338":339,"_340":341,"_342":85,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366},"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 · v33