\n \n\n",[],[215,222],{"_107":230,"_100":231,"_152":232,"_154":216,"_155":138,"_156":233,"_158":159,"_109":234,"_104":31,"_161":179,"_163":235,"_164":27,"_165":-5,"_166":236,"_103":237},"74408f5e-3fb8-11f0-a7a1-76b3cceeab13","index.tsx","7440906c-3fb8-11f0-a7a1-76b3cceeab13",8,["D",1748872190533],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport type { Player, GameSession, Reward } from \"../shared/types.ts\";\nimport { REWARDS, SCORING } from \"../shared/types.ts\";\n\ninterface AppState {\n players: Player[];\n currentSession: GameSession | null;\n selectedPlayers: string[];\n newPlayerName: string;\n gamePhase: 'setup' | 'playing' | 'finished';\n roundTimer: number;\n foundPlayers: string[];\n playerRewards: Record;\n}\n\nfunction App() {\n const [state, setState] = useState({\n players: (window as any).__INITIAL_DATA__?.players || [],\n currentSession: null,\n selectedPlayers: [],\n newPlayerName: '',\n gamePhase: 'setup',\n roundTimer: 0,\n foundPlayers: [],\n playerRewards: {}\n });\n\n // Load player rewards\n useEffect(() => {\n const loadRewards = async () => {\n const rewards: Record = {};\n for (const player of state.players) {\n try {\n const response = await fetch(`/api/players/${player.id}/rewards`);\n if (response.ok) {\n rewards[player.id] = await response.json();\n }\n } catch (error) {\n console.error('Failed to load rewards for player:', player.id);\n }\n }\n setState(prev => ({ ...prev, playerRewards: rewards }));\n };\n\n if (state.players.length > 0) {\n loadRewards();\n }\n }, [state.players]);\n\n // Timer effect\n useEffect(() => {\n let interval: number;\n \n if (state.currentSession?.gameStatus === 'active' && state.roundTimer > 0) {\n interval = setInterval(() => {\n setState(prev => {\n const newTimer = prev.roundTimer - 1;\n if (newTimer <= 0) {\n // Auto-end round when timer reaches 0\n endRound();\n return { ...prev, roundTimer: 0 };\n }\n return { ...prev, roundTimer: newTimer };\n });\n }, 1000);\n }\n \n return () => {\n if (interval) clearInterval(interval);\n };\n }, [state.currentSession?.gameStatus, state.roundTimer]);\n\n const refreshPlayers = async () => {\n try {\n const response = await fetch('/api/players');\n const players = await response.json();\n setState(prev => ({ ...prev, players }));\n } catch (error) {\n console.error('Failed to refresh players:', error);\n }\n };\n\n const createPlayer = async () => {\n if (!state.newPlayerName.trim()) return;\n \n try {\n const response = await fetch('/api/players', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ name: state.newPlayerName.trim() })\n });\n \n if (response.ok) {\n setState(prev => ({ ...prev, newPlayerName: '' }));\n await refreshPlayers();\n }\n } catch (error) {\n console.error('Failed to create player:', error);\n }\n };\n\n const togglePlayerSelection = (playerId: string) => {\n setState(prev => {\n const selected = prev.selectedPlayers.includes(playerId)\n ? prev.selectedPlayers.filter(id => id !== playerId)\n : prev.selectedPlayers.length < 4\n ? [...prev.selectedPlayers, playerId]\n : prev.selectedPlayers;\n \n return { ...prev, selectedPlayers: selected };\n });\n };\n\n const startGame = async () => {\n if (state.selectedPlayers.length !== 4) return;\n \n try {\n const response = await fetch('/api/sessions', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ playerIds: state.selectedPlayers })\n });\n \n if (response.ok) {\n const session = await response.json();\n setState(prev => ({\n ...prev,\n currentSession: session,\n gamePhase: 'playing',\n foundPlayers: []\n }));\n }\n } catch (error) {\n console.error('Failed to start game:', error);\n }\n };\n\n const startRound = async () => {\n if (!state.currentSession) return;\n \n try {\n const response = await fetch(`/api/sessions/${state.currentSession.id}/start-round`, {\n method: 'POST'\n });\n \n if (response.ok) {\n const session = await response.json();\n setState(prev => ({\n ...prev,\n currentSession: session,\n roundTimer: session.roundDuration,\n foundPlayers: []\n }));\n }\n } catch (error) {\n console.error('Failed to start round:', error);\n }\n };\n\n const toggleFoundPlayer = (playerId: string) => {\n setState(prev => {\n const found = prev.foundPlayers.includes(playerId)\n ? prev.foundPlayers.filter(id => id !== playerId)\n : [...prev.foundPlayers, playerId];\n \n return { ...prev, foundPlayers: found };\n });\n };\n\n const endRound = async () => {\n if (!state.currentSession) return;\n \n try {\n const response = await fetch(`/api/sessions/${state.currentSession.id}/end-round`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ foundPlayers: state.foundPlayers })\n });\n \n if (response.ok) {\n const result = await response.json();\n setState(prev => ({\n ...prev,\n currentSession: result.session,\n roundTimer: 0,\n foundPlayers: [],\n gamePhase: result.session.gameStatus === 'finished' ? 'finished' : 'playing'\n }));\n \n // Refresh players to get updated scores\n await refreshPlayers();\n }\n } catch (error) {\n console.error('Failed to end round:', error);\n }\n };\n\n const resetGame = () => {\n setState(prev => ({\n ...prev,\n currentSession: null,\n selectedPlayers: [],\n gamePhase: 'setup',\n roundTimer: 0,\n foundPlayers: []\n }));\n };\n\n const formatTime = (seconds: number) => {\n const mins = Math.floor(seconds / 60);\n const secs = seconds % 60;\n return `${mins}:${secs.toString().padStart(2, '0')}`;\n };\n\n const getTimerClass = () => {\n if (state.roundTimer <= 10) return 'timer-danger';\n if (state.roundTimer <= 30) return 'timer-warning';\n return '';\n };\n\n const getCurrentSeeker = () => {\n return state.currentSession?.players.find(p => p.id === state.currentSession?.currentSeeker);\n };\n\n const getCurrentHiders = () => {\n return state.currentSession?.players.filter(p => p.id !== state.currentSession?.currentSeeker) || [];\n };\n\n if (state.gamePhase === 'setup') {\n return (\n

\n 🎮 Hide and Sick\n

A thrilling game of hide and seek for 4 players!

\n\n {/* Create Player */}\n

Add New Player

\n setState(prev => ({ ...prev, newPlayerName: e.target.value }))}\n placeholder=\"Enter player name\"\n className=\"flex-1 px-4 py-2 rounded-lg bg-white/10 border border-white/20 text-white placeholder-gray-400\"\n onKeyPress={(e) => e.key === 'Enter' && createPlayer()}\n />\n \n Add\n \n

\n\n {/* Player Selection */}\n

\n Select 4 Players ({state.selectedPlayers.length}/4)\n

\n \n

\n {state.players.map(player => (\n togglePlayerSelection(player.id)}\n className={`player-card rounded-lg p-4 cursor-pointer transition-all ${\n state.selectedPlayers.includes(player.id) ? 'ring-2 ring-purple-400 pulse-glow' : ''\n }`}\n >\n

{player.name}

\n {player.score} pts\n

\n \n

Games: {player.gamesPlayed}

Hides: {player.successfulHides}/{player.timesHidden}

Seeks: {player.successfulSeeks}/{player.timesSeeker}

\n \n {/* Player Rewards */}\n {state.playerRewards[player.id]?.length > 0 && (\n

\n {state.playerRewards[player.id].slice(0, 3).map(reward => (\n \n {reward.icon}\n \n ))}\n {state.playerRewards[player.id].length > 3 && (\n \n +{state.playerRewards[player.id].length - 3}\n \n )}\n

\n )}\n

\n ))}\n

\n\n {state.selectedPlayers.length === 4 && (\n

\n \n 🚀 Start Game!\n \n

\n )}\n

\n\n {/* Leaderboard */}\n

🏆 Leaderboard

\n {state.players\n .sort((a, b) => b.score - a.score)\n .slice(0, 10)\n .map((player, index) => (\n

\n \n {index === 0 ? '🥇' : index === 1 ? '🥈' : index === 2 ? '🥉' : `#${index + 1}`}\n \n {player.name}\n

\n \n {player.score} pts\n \n

\n ))}\n

\n \n );\n }\n\n if (state.gamePhase === 'playing') {\n const seeker = getCurrentSeeker();\n const hiders = getCurrentHiders();\n const isRoundActive = state.currentSession?.gameStatus === 'active';\n\n return (\n

Round {state.currentSession?.currentRound}/4

\n {isRoundActive && (\n

\n {formatTime(state.roundTimer)}\n

\n )}\n

\n\n {/* Current Seeker */}\n {seeker && (\n

🔍 Current Seeker

{seeker.name}

Find the hidden players!

\n )}\n\n {/* Hiders */}\n

👻 Hiders

\n {hiders.map(hider => (\n isRoundActive && toggleFoundPlayer(hider.id)}\n className={`p-4 rounded-lg cursor-pointer transition-all ${\n state.foundPlayers.includes(hider.id)\n ? 'bg-red-500/30 border-2 border-red-400'\n : 'bg-green-500/20 border-2 border-green-400'\n } ${isRoundActive ? 'hover:scale-105' : 'cursor-not-allowed opacity-50'}`}\n >\n

\n {state.foundPlayers.includes(hider.id) ? '😵' : '🫥'}\n

{hider.name}

\n {state.foundPlayers.includes(hider.id) ? 'FOUND!' : 'HIDING'}\n

\n ))}\n

\n\n {/* Game Controls */}\n

\n {!isRoundActive ? (\n \n ▶️ Start Round\n \n ) : (\n \n ⏹️ End Round\n \n )}\n \n

\n \n 🏠 Back to Setup\n \n

\n\n {/* Scoring Info */}\n

📊 Scoring System

Hider Rewards:

• Successful Hide: +{SCORING.SUCCESSFUL_HIDE} pts

Seeker Rewards:

• Find Player: +{SCORING.FIND_PLAYER} pts

• Being Seeker: +{SCORING.SEEKER_BONUS} pts

• Perfect Round: +{SCORING.PERFECT_ROUND_BONUS} pts

\n \n );\n }\n\n if (state.gamePhase === 'finished') {\n const finalPlayers = state.currentSession?.players.sort((a, b) => b.score - a.score) || [];\n\n return (\n

\n 🎉 Game Complete!\n

\n\n {/* Final Results */}\n

🏆 Final Results

\n {finalPlayers.map((player, index) => (\n \n

\n \n {index === 0 ? '🥇' : index === 1 ? '🥈' : index === 2 ? '🥉' : `#${index + 1}`}\n \n

{player.name}

\n Games: {player.gamesPlayed} | Hides: {player.successfulHides}/{player.timesHidden} | Seeks: {player.successfulSeeks}/{player.timesSeeker}\n

\n {player.score} pts\n

\n ))}\n

\n\n {/* Play Again */}\n

\n \n 🔄 Play Again\n \n

\n \n );\n }\n\n return null;\n}\n\n// Initialize the app\nconst root = createRoot(document.getElementById('root')!);\nroot.render();",[],[215,231],{"_107":239,"_100":240,"_152":241,"_154":216,"_155":138,"_156":242,"_158":159,"_109":243,"_104":31,"_161":225,"_163":244,"_164":27,"_165":-5,"_166":245,"_103":246},"44e8bbd2-3fb8-11f0-9204-76b3cceeab13","style.css","44e8bdf8-3fb8-11f0-9204-76b3cceeab13",7,["D",1748872111033],"/* Custom animations and styles for Hide and Sick game */\n\n@keyframes pulse-glow {\n 0%, 100% {\n box-shadow: 0 0 20px rgba(139, 92, 246, 0.5);\n }\n 50% {\n box-shadow: 0 0 30px rgba(139, 92, 246, 0.8);\n }\n}\n\n@keyframes bounce-in {\n 0% {\n transform: scale(0.3);\n opacity: 0;\n }\n 50% {\n transform: scale(1.05);\n }\n 70% {\n transform: scale(0.9);\n }\n 100% {\n transform: scale(1);\n opacity: 1;\n }\n}\n\n@keyframes slide-up {\n from {\n transform: translateY(20px);\n opacity: 0;\n }\n to {\n transform: translateY(0);\n opacity: 1;\n }\n}\n\n.pulse-glow {\n animation: pulse-glow 2s infinite;\n}\n\n.bounce-in {\n animation: bounce-in 0.6s ease-out;\n}\n\n.slide-up {\n animation: slide-up 0.4s ease-out;\n}\n\n.game-card {\n background: rgba(255, 255, 255, 0.1);\n backdrop-filter: blur(10px);\n border: 1px solid rgba(255, 255, 255, 0.2);\n}\n\n.player-card {\n background: linear-gradient(135deg, rgba(139, 92, 246, 0.2), rgba(59, 130, 246, 0.2));\n border: 1px solid rgba(139, 92, 246, 0.3);\n transition: all 0.3s ease;\n}\n\n.player-card:hover {\n transform: translateY(-2px);\n box-shadow: 0 10px 25px rgba(139, 92, 246, 0.3);\n}\n\n.seeker-card {\n background: linear-gradient(135deg, rgba(239, 68, 68, 0.3), rgba(220, 38, 127, 0.3));\n border: 2px solid rgba(239, 68, 68, 0.5);\n}\n\n.hider-card {\n background: linear-gradient(135deg, rgba(34, 197, 94, 0.3), rgba(16, 185, 129, 0.3));\n border: 2px solid rgba(34, 197, 94, 0.5);\n}\n\n.reward-badge {\n background: linear-gradient(135deg, #fbbf24, #f59e0b);\n color: #1f2937;\n font-weight: bold;\n text-shadow: none;\n}\n\n.score-display {\n background: linear-gradient(135deg, rgba(168, 85, 247, 0.4), rgba(139, 92, 246, 0.4));\n border: 2px solid rgba(168, 85, 247, 0.6);\n}\n\n.btn-primary {\n background: linear-gradient(135deg, #8b5cf6, #7c3aed);\n border: none;\n transition: all 0.3s ease;\n}\n\n.btn-primary:hover {\n background: linear-gradient(135deg, #7c3aed, #6d28d9);\n transform: translateY(-1px);\n box-shadow: 0 5px 15px rgba(139, 92, 246, 0.4);\n}\n\n.btn-secondary {\n background: linear-gradient(135deg, #6b7280, #4b5563);\n border: none;\n transition: all 0.3s ease;\n}\n\n.btn-secondary:hover {\n background: linear-gradient(135deg, #4b5563, #374151);\n transform: translateY(-1px);\n}\n\n.btn-danger {\n background: linear-gradient(135deg, #ef4444, #dc2626);\n border: none;\n transition: all 0.3s ease;\n}\n\n.btn-danger:hover {\n background: linear-gradient(135deg, #dc2626, #b91c1c);\n transform: translateY(-1px);\n box-shadow: 0 5px 15px rgba(239, 68, 68, 0.4);\n}\n\n.btn-success {\n background: linear-gradient(135deg, #10b981, #059669);\n border: none;\n transition: all 0.3s ease;\n}\n\n.btn-success:hover {\n background: linear-gradient(135deg, #059669, #047857);\n transform: translateY(-1px);\n box-shadow: 0 5px 15px rgba(16, 185, 129, 0.4);\n}\n\n.timer-display {\n font-family: 'Courier New', monospace;\n font-size: 2rem;\n font-weight: bold;\n text-shadow: 2px 2px 4px rgba(0, 0, 0, 0.5);\n}\n\n.timer-warning {\n color: #fbbf24;\n animation: pulse 1s infinite;\n}\n\n.timer-danger {\n color: #ef4444;\n animation: pulse 0.5s infinite;\n}\n\n@keyframes pulse {\n 0%, 100% { opacity: 1; }\n 50% { opacity: 0.5; }\n}",[],[215,240],[215],{"_107":249,"_100":250,"_152":251,"_154":-5,"_155":138,"_156":252,"_158":159,"_109":253,"_104":31,"_161":162,"_163":-5,"_164":27,"_165":-5,"_166":254,"_103":263},"00f1cb12-3fb8-11f0-a72c-76b3cceeab13","shared","ff0e5315-95ab-450f-be16-bade16ace25b",2,["D",1748871997076],[255],{"_107":256,"_100":257,"_152":258,"_154":251,"_155":138,"_156":252,"_158":159,"_109":259,"_104":31,"_161":179,"_163":260,"_164":27,"_165":-5,"_166":261,"_103":262},"00f1acfe-3fb8-11f0-a72c-76b3cceeab13","types.ts","00f1ada8-3fb8-11f0-a72c-76b3cceeab13",["D",1748871997076],"export interface Player {\n id: string;\n name: string;\n score: number;\n gamesPlayed: number;\n timesSeeker: number;\n timesHidden: number;\n successfulHides: number;\n successfulSeeks: number;\n}\n\nexport interface GameSession {\n id: string;\n players: Player[];\n currentRound: number;\n currentSeeker: string;\n gameStatus: 'waiting' | 'active' | 'finished';\n roundStartTime?: number;\n roundDuration: number; // in seconds\n}\n\nexport interface GameRound {\n id: string;\n sessionId: string;\n roundNumber: number;\n seekerId: string;\n hiderIds: string[];\n foundPlayers: string[];\n roundScore: Record;\n startTime: number;\n endTime?: number;\n}\n\nexport interface Reward {\n id: string;\n name: string;\n description: string;\n icon: string;\n requirement: {\n type: 'score' | 'games' | 'streak' | 'ratio';\n value: number;\n };\n}\n\nexport const REWARDS: Reward[] = [\n {\n id: 'first_game',\n name: 'First Timer',\n description: 'Played your first game',\n icon: '🎮',\n requirement: { type: 'games', value: 1 }\n },\n {\n id: 'score_100',\n name: 'Century Club',\n description: 'Reached 100 points',\n icon: '💯',\n requirement: { type: 'score', value: 100 }\n },\n {\n id: 'score_500',\n name: 'High Scorer',\n description: 'Reached 500 points',\n icon: '🏆',\n requirement: { type: 'score', value: 500 }\n },\n {\n id: 'games_10',\n name: 'Veteran',\n description: 'Played 10 games',\n icon: '⭐',\n requirement: { type: 'games', value: 10 }\n },\n {\n id: 'perfect_seeker',\n name: 'Perfect Seeker',\n description: 'Found all hiders in a round',\n icon: '🔍',\n requirement: { type: 'ratio', value: 1 }\n },\n {\n id: 'master_hider',\n name: 'Master Hider',\n description: 'Successfully hid 20 times',\n icon: '👻',\n requirement: { type: 'streak', value: 20 }\n }\n];\n\nexport const SCORING = {\n SUCCESSFUL_HIDE: 10,\n FIND_PLAYER: 15,\n SEEKER_BONUS: 5, // bonus for being seeker\n TIME_BONUS: 1, // per second remaining when found as seeker\n PERFECT_ROUND_BONUS: 25 // bonus for finding all players\n};",[],[250,257],[250],{"_107":265,"_100":266,"_152":267,"_154":-5,"_155":138,"_156":199,"_158":159,"_109":268,"_104":31,"_161":225,"_163":269,"_164":27,"_165":-5,"_166":270,"_103":271},"f93731dc-3fb7-11f0-84ed-76b3cceeab13","README.md","f93732cc-3fb7-11f0-84ed-76b3cceeab13",["D",1748871984111],"# Hide and Sick Game\n\nA multiplayer game for 4 players where players take turns being \"sick\" (the seeker) while others hide. Points are awarded for successful hiding and seeking.\n\n## Game Rules\n\n- 4 players take turns being the \"sick\" player (seeker)\n- Other 3 players are \"hiders\"\n- Hiders get points for staying hidden\n- Seeker gets points for finding hiders\n- Game tracks scores and awards rewards based on performance\n\n## Project Structure\n\n```\n├── frontend/\n│ ├── index.html # Main game interface\n│ ├── index.tsx # React game logic\n│ └── style.css # Game styling\n├── backend/\n│ ├── index.ts # API server\n│ └── database/\n│ ├── migrations.ts # Database setup\n│ └── queries.ts # Game data queries\n└── shared/\n └── types.ts # Shared game types\n```\n\n## Features\n\n- Real-time score tracking\n- Player management\n- Reward system based on performance\n- Game session management\n- Responsive design\n\n## Getting Started\n\nThe game runs as an HTTP val. Players can join, play rounds, and track their progress through the web interface.",[],[266],"files",[149,168,174,183,194,202,213,220,229,238,248,255,264],"counts",{"_276":31,"_277":199,"_278":31,"_279":31},"pulls","branches","forks","envVars","contents",[282,285,288,291],{"_107":150,"_100":151,"_152":153,"_154":-5,"_155":138,"_156":157,"_158":159,"_109":283,"_104":31,"_161":162,"_163":-5,"_164":27,"_165":-5,"_103":284},["D",1748872009316],[151],{"_107":214,"_100":215,"_152":216,"_154":-5,"_155":138,"_156":217,"_158":159,"_109":286,"_104":31,"_161":162,"_163":-5,"_164":27,"_165":-5,"_103":287},["D",1748872087528],[215],{"_107":249,"_100":250,"_152":251,"_154":-5,"_155":138,"_156":252,"_158":159,"_109":289,"_104":31,"_161":162,"_163":-5,"_164":27,"_165":-5,"_103":290},["D",1748871997076],[250],{"_107":265,"_100":266,"_152":267,"_154":-5,"_155":138,"_156":199,"_158":159,"_109":292,"_104":31,"_161":225,"_163":269,"_164":27,"_165":-5,"_103":293},["D",1748871984111],[266],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.branch.$branch.history",{"_98":99,"_100":101,"_102":42,"_105":300,"_304":305,"_408":31,"_409":27},{"_107":108,"_100":101,"_109":301,"_111":-5,"_112":27,"_113":114,"_115":-5,"_116":-5,"_12":117,"_118":-5,"_119":27,"_120":-5,"_121":31,"_14":122,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_21":302,"_135":303,"_146":27},["D",1748871874260],{"_98":99,"_133":134},{"_104":137,"_100":42,"_107":138,"_139":108,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":101,"_145":99},"history",[306,311,318,323,331,339,347,352,357,362,370,377,384,395,403],{"_152":197,"_104":137,"_109":307,"_155":138,"_272":308},["D",1748935644901],[309],{"_107":195,"_155":138,"_152":197,"_100":196,"_163":-5,"_161":162,"_104":199,"_154":153,"_109":307,"_156":137,"_165":-5,"_158":159,"_164":27,"_103":310},[151,196],{"_152":197,"_104":312,"_109":313,"_155":138,"_272":314},14,["D",1748935637529],[315],{"_107":316,"_155":138,"_152":197,"_100":196,"_163":-5,"_161":162,"_104":31,"_154":153,"_109":313,"_156":312,"_165":-5,"_158":27,"_164":27,"_103":317},"2d9bf608-404c-11f0-aaa6-76b3cceeab13",[151,196],{"_152":186,"_104":187,"_109":319,"_155":138,"_272":320},["D",1748872244404],[321],{"_107":184,"_155":138,"_152":186,"_100":185,"_163":190,"_161":179,"_104":189,"_154":171,"_109":319,"_156":187,"_165":-5,"_158":159,"_164":27,"_103":322},[151,170,185],{"_152":186,"_104":324,"_109":325,"_155":138,"_272":326},12,["D",1748872235971],[327],{"_107":328,"_155":138,"_152":186,"_100":185,"_163":329,"_161":179,"_104":157,"_154":171,"_109":325,"_156":324,"_165":-5,"_158":27,"_164":27,"_103":330},"8f5696c6-3fb8-11f0-aef4-76b3cceeab13","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { PLAYERS_TABLE, SESSIONS_TABLE, ROUNDS_TABLE, PLAYER_REWARDS_TABLE } from \"./migrations.ts\";\nimport type { Player, GameSession, GameRound } from \"../../shared/types.ts\";\n\nexport async function createPlayer(name: string): Promise {\n const id = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${PLAYERS_TABLE} (id, name) VALUES (?, ?)`,\n [id, name]\n );\n \n return {\n id,\n name,\n score: 0,\n gamesPlayed: 0,\n timesSeeker: 0,\n timesHidden: 0,\n successfulHides: 0,\n successfulSeeks: 0\n };\n}\n\nexport async function getPlayer(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${PLAYERS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (!Array.isArray(result) || result.length === 0) return null;\n \n const row = result[0];\n return {\n id: row.id,\n name: row.name,\n score: row.score || 0,\n gamesPlayed: row.games_played || 0,\n timesSeeker: row.times_seeker || 0,\n timesHidden: row.times_hidden || 0,\n successfulHides: row.successful_hides || 0,\n successfulSeeks: row.successful_seeks || 0\n };\n}\n\nexport async function getAllPlayers(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${PLAYERS_TABLE} ORDER BY score DESC`);\n \n if (!Array.isArray(result)) {\n return [];\n }\n \n return result.map(row => ({\n id: row.id,\n name: row.name,\n score: row.score || 0,\n gamesPlayed: row.games_played || 0,\n timesSeeker: row.times_seeker || 0,\n timesHidden: row.times_hidden || 0,\n successfulHides: row.successful_hides || 0,\n successfulSeeks: row.successful_seeks || 0\n }));\n}\n\nexport async function updatePlayerStats(playerId: string, updates: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (updates.score !== undefined) {\n fields.push('score = ?');\n values.push(updates.score);\n }\n if (updates.gamesPlayed !== undefined) {\n fields.push('games_played = ?');\n values.push(updates.gamesPlayed);\n }\n if (updates.timesSeeker !== undefined) {\n fields.push('times_seeker = ?');\n values.push(updates.timesSeeker);\n }\n if (updates.timesHidden !== undefined) {\n fields.push('times_hidden = ?');\n values.push(updates.timesHidden);\n }\n if (updates.successfulHides !== undefined) {\n fields.push('successful_hides = ?');\n values.push(updates.successfulHides);\n }\n if (updates.successfulSeeks !== undefined) {\n fields.push('successful_seeks = ?');\n values.push(updates.successfulSeeks);\n }\n \n if (fields.length === 0) return;\n \n values.push(playerId);\n \n await sqlite.execute(\n `UPDATE ${PLAYERS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n values\n );\n}\n\nexport async function createGameSession(playerIds: string[]): Promise {\n const id = crypto.randomUUID();\n const players = await Promise.all(playerIds.map(id => getPlayer(id)));\n const validPlayers = players.filter(p => p !== null) as Player[];\n \n if (validPlayers.length !== 4) {\n throw new Error('Game requires exactly 4 players');\n }\n \n await sqlite.execute(\n `INSERT INTO ${SESSIONS_TABLE} (id, player_ids, current_seeker) VALUES (?, ?, ?)`,\n [id, JSON.stringify(playerIds), playerIds[0]]\n );\n \n return {\n id,\n players: validPlayers,\n currentRound: 1,\n currentSeeker: playerIds[0],\n gameStatus: 'waiting',\n roundDuration: 120\n };\n}\n\nexport async function getGameSession(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${SESSIONS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (!Array.isArray(result) || result.length === 0) return null;\n \n const row = result[0];\n const playerIds = JSON.parse(row.player_ids);\n const players = await Promise.all(playerIds.map((id: string) => getPlayer(id)));\n const validPlayers = players.filter(p => p !== null) as Player[];\n \n return {\n id: row.id,\n players: validPlayers,\n currentRound: row.current_round || 1,\n currentSeeker: row.current_seeker,\n gameStatus: row.game_status || 'waiting',\n roundStartTime: row.round_start_time,\n roundDuration: row.round_duration || 120\n };\n}\n\nexport async function updateGameSession(id: string, updates: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (updates.currentRound !== undefined) {\n fields.push('current_round = ?');\n values.push(updates.currentRound);\n }\n if (updates.currentSeeker !== undefined) {\n fields.push('current_seeker = ?');\n values.push(updates.currentSeeker);\n }\n if (updates.gameStatus !== undefined) {\n fields.push('game_status = ?');\n values.push(updates.gameStatus);\n }\n if (updates.roundStartTime !== undefined) {\n fields.push('round_start_time = ?');\n values.push(updates.roundStartTime);\n }\n \n if (fields.length === 0) return;\n \n values.push(id);\n \n await sqlite.execute(\n `UPDATE ${SESSIONS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n values\n );\n}\n\nexport async function createGameRound(round: Omit): Promise {\n const id = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${ROUNDS_TABLE} (id, session_id, round_number, seeker_id, hider_ids, start_time) VALUES (?, ?, ?, ?, ?, ?)`,\n [id, round.sessionId, round.roundNumber, round.seekerId, JSON.stringify(round.hiderIds), round.startTime]\n );\n \n return { id, ...round };\n}\n\nexport async function updateGameRound(id: string, updates: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (updates.foundPlayers !== undefined) {\n fields.push('found_players = ?');\n values.push(JSON.stringify(updates.foundPlayers));\n }\n if (updates.roundScore !== undefined) {\n fields.push('round_score = ?');\n values.push(JSON.stringify(updates.roundScore));\n }\n if (updates.endTime !== undefined) {\n fields.push('end_time = ?');\n values.push(updates.endTime);\n }\n \n if (fields.length === 0) return;\n \n values.push(id);\n \n await sqlite.execute(\n `UPDATE ${ROUNDS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n values\n );\n}\n\nexport async function getPlayerRewards(playerId: string): Promise {\n const result = await sqlite.execute(\n `SELECT reward_id FROM ${PLAYER_REWARDS_TABLE} WHERE player_id = ?`,\n [playerId]\n );\n \n return result.map(row => row.reward_id);\n}\n\nexport async function awardReward(playerId: string, rewardId: string): Promise {\n try {\n await sqlite.execute(\n `INSERT INTO ${PLAYER_REWARDS_TABLE} (player_id, reward_id) VALUES (?, ?)`,\n [playerId, rewardId]\n );\n } catch (error) {\n // Ignore duplicate key errors (reward already earned)\n if (!error.message.includes('UNIQUE constraint failed')) {\n throw error;\n }\n }\n}",[151,170,185],{"_152":186,"_104":332,"_109":333,"_155":138,"_272":334},11,["D",1748872226580],[335],{"_107":336,"_155":138,"_152":186,"_100":185,"_163":337,"_161":179,"_104":252,"_154":171,"_109":333,"_156":332,"_165":-5,"_158":27,"_164":27,"_103":338},"89bda86c-3fb8-11f0-8c3b-76b3cceeab13","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { PLAYERS_TABLE, SESSIONS_TABLE, ROUNDS_TABLE, PLAYER_REWARDS_TABLE } from \"./migrations.ts\";\nimport type { Player, GameSession, GameRound } from \"../../shared/types.ts\";\n\nexport async function createPlayer(name: string): Promise {\n const id = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${PLAYERS_TABLE} (id, name) VALUES (?, ?)`,\n [id, name]\n );\n \n return {\n id,\n name,\n score: 0,\n gamesPlayed: 0,\n timesSeeker: 0,\n timesHidden: 0,\n successfulHides: 0,\n successfulSeeks: 0\n };\n}\n\nexport async function getPlayer(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${PLAYERS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (!Array.isArray(result) || result.length === 0) return null;\n \n const row = result[0];\n return {\n id: row.id,\n name: row.name,\n score: row.score || 0,\n gamesPlayed: row.games_played || 0,\n timesSeeker: row.times_seeker || 0,\n timesHidden: row.times_hidden || 0,\n successfulHides: row.successful_hides || 0,\n successfulSeeks: row.successful_seeks || 0\n };\n}\n\nexport async function getAllPlayers(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${PLAYERS_TABLE} ORDER BY score DESC`);\n \n if (!Array.isArray(result)) {\n return [];\n }\n \n return result.map(row => ({\n id: row.id,\n name: row.name,\n score: row.score || 0,\n gamesPlayed: row.games_played || 0,\n timesSeeker: row.times_seeker || 0,\n timesHidden: row.times_hidden || 0,\n successfulHides: row.successful_hides || 0,\n successfulSeeks: row.successful_seeks || 0\n }));\n}\n\nexport async function updatePlayerStats(playerId: string, updates: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (updates.score !== undefined) {\n fields.push('score = ?');\n values.push(updates.score);\n }\n if (updates.gamesPlayed !== undefined) {\n fields.push('games_played = ?');\n values.push(updates.gamesPlayed);\n }\n if (updates.timesSeeker !== undefined) {\n fields.push('times_seeker = ?');\n values.push(updates.timesSeeker);\n }\n if (updates.timesHidden !== undefined) {\n fields.push('times_hidden = ?');\n values.push(updates.timesHidden);\n }\n if (updates.successfulHides !== undefined) {\n fields.push('successful_hides = ?');\n values.push(updates.successfulHides);\n }\n if (updates.successfulSeeks !== undefined) {\n fields.push('successful_seeks = ?');\n values.push(updates.successfulSeeks);\n }\n \n if (fields.length === 0) return;\n \n values.push(playerId);\n \n await sqlite.execute(\n `UPDATE ${PLAYERS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n values\n );\n}\n\nexport async function createGameSession(playerIds: string[]): Promise {\n const id = crypto.randomUUID();\n const players = await Promise.all(playerIds.map(id => getPlayer(id)));\n const validPlayers = players.filter(p => p !== null) as Player[];\n \n if (validPlayers.length !== 4) {\n throw new Error('Game requires exactly 4 players');\n }\n \n await sqlite.execute(\n `INSERT INTO ${SESSIONS_TABLE} (id, player_ids, current_seeker) VALUES (?, ?, ?)`,\n [id, JSON.stringify(playerIds), playerIds[0]]\n );\n \n return {\n id,\n players: validPlayers,\n currentRound: 1,\n currentSeeker: playerIds[0],\n gameStatus: 'waiting',\n roundDuration: 120\n };\n}\n\nexport async function getGameSession(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${SESSIONS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.length === 0) return null;\n \n const row = result[0];\n const playerIds = JSON.parse(row.player_ids);\n const players = await Promise.all(playerIds.map((id: string) => getPlayer(id)));\n const validPlayers = players.filter(p => p !== null) as Player[];\n \n return {\n id: row.id,\n players: validPlayers,\n currentRound: row.current_round,\n currentSeeker: row.current_seeker,\n gameStatus: row.game_status,\n roundStartTime: row.round_start_time,\n roundDuration: row.round_duration\n };\n}\n\nexport async function updateGameSession(id: string, updates: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (updates.currentRound !== undefined) {\n fields.push('current_round = ?');\n values.push(updates.currentRound);\n }\n if (updates.currentSeeker !== undefined) {\n fields.push('current_seeker = ?');\n values.push(updates.currentSeeker);\n }\n if (updates.gameStatus !== undefined) {\n fields.push('game_status = ?');\n values.push(updates.gameStatus);\n }\n if (updates.roundStartTime !== undefined) {\n fields.push('round_start_time = ?');\n values.push(updates.roundStartTime);\n }\n \n if (fields.length === 0) return;\n \n values.push(id);\n \n await sqlite.execute(\n `UPDATE ${SESSIONS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n values\n );\n}\n\nexport async function createGameRound(round: Omit): Promise {\n const id = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${ROUNDS_TABLE} (id, session_id, round_number, seeker_id, hider_ids, start_time) VALUES (?, ?, ?, ?, ?, ?)`,\n [id, round.sessionId, round.roundNumber, round.seekerId, JSON.stringify(round.hiderIds), round.startTime]\n );\n \n return { id, ...round };\n}\n\nexport async function updateGameRound(id: string, updates: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (updates.foundPlayers !== undefined) {\n fields.push('found_players = ?');\n values.push(JSON.stringify(updates.foundPlayers));\n }\n if (updates.roundScore !== undefined) {\n fields.push('round_score = ?');\n values.push(JSON.stringify(updates.roundScore));\n }\n if (updates.endTime !== undefined) {\n fields.push('end_time = ?');\n values.push(updates.endTime);\n }\n \n if (fields.length === 0) return;\n \n values.push(id);\n \n await sqlite.execute(\n `UPDATE ${ROUNDS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n values\n );\n}\n\nexport async function getPlayerRewards(playerId: string): Promise {\n const result = await sqlite.execute(\n `SELECT reward_id FROM ${PLAYER_REWARDS_TABLE} WHERE player_id = ?`,\n [playerId]\n );\n \n return result.map(row => row.reward_id);\n}\n\nexport async function awardReward(playerId: string, rewardId: string): Promise {\n try {\n await sqlite.execute(\n `INSERT INTO ${PLAYER_REWARDS_TABLE} (player_id, reward_id) VALUES (?, ?)`,\n [playerId, rewardId]\n );\n } catch (error) {\n // Ignore duplicate key errors (reward already earned)\n if (!error.message.includes('UNIQUE constraint failed')) {\n throw error;\n }\n }\n}",[151,170,185],{"_152":186,"_104":340,"_109":341,"_155":138,"_272":342},10,["D",1748872215717],[343],{"_107":344,"_155":138,"_152":186,"_100":185,"_163":345,"_161":179,"_104":199,"_154":171,"_109":341,"_156":340,"_165":-5,"_158":27,"_164":27,"_103":346},"83442790-3fb8-11f0-8eb4-76b3cceeab13","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { PLAYERS_TABLE, SESSIONS_TABLE, ROUNDS_TABLE, PLAYER_REWARDS_TABLE } from \"./migrations.ts\";\nimport type { Player, GameSession, GameRound } from \"../../shared/types.ts\";\n\nexport async function createPlayer(name: string): Promise {\n const id = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${PLAYERS_TABLE} (id, name) VALUES (?, ?)`,\n [id, name]\n );\n \n return {\n id,\n name,\n score: 0,\n gamesPlayed: 0,\n timesSeeker: 0,\n timesHidden: 0,\n successfulHides: 0,\n successfulSeeks: 0\n };\n}\n\nexport async function getPlayer(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${PLAYERS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.length === 0) return null;\n \n const row = result[0];\n return {\n id: row.id,\n name: row.name,\n score: row.score,\n gamesPlayed: row.games_played,\n timesSeeker: row.times_seeker,\n timesHidden: row.times_hidden,\n successfulHides: row.successful_hides,\n successfulSeeks: row.successful_seeks\n };\n}\n\nexport async function getAllPlayers(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${PLAYERS_TABLE} ORDER BY score DESC`);\n \n if (!Array.isArray(result)) {\n return [];\n }\n \n return result.map(row => ({\n id: row.id,\n name: row.name,\n score: row.score || 0,\n gamesPlayed: row.games_played || 0,\n timesSeeker: row.times_seeker || 0,\n timesHidden: row.times_hidden || 0,\n successfulHides: row.successful_hides || 0,\n successfulSeeks: row.successful_seeks || 0\n }));\n}\n\nexport async function updatePlayerStats(playerId: string, updates: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (updates.score !== undefined) {\n fields.push('score = ?');\n values.push(updates.score);\n }\n if (updates.gamesPlayed !== undefined) {\n fields.push('games_played = ?');\n values.push(updates.gamesPlayed);\n }\n if (updates.timesSeeker !== undefined) {\n fields.push('times_seeker = ?');\n values.push(updates.timesSeeker);\n }\n if (updates.timesHidden !== undefined) {\n fields.push('times_hidden = ?');\n values.push(updates.timesHidden);\n }\n if (updates.successfulHides !== undefined) {\n fields.push('successful_hides = ?');\n values.push(updates.successfulHides);\n }\n if (updates.successfulSeeks !== undefined) {\n fields.push('successful_seeks = ?');\n values.push(updates.successfulSeeks);\n }\n \n if (fields.length === 0) return;\n \n values.push(playerId);\n \n await sqlite.execute(\n `UPDATE ${PLAYERS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n values\n );\n}\n\nexport async function createGameSession(playerIds: string[]): Promise {\n const id = crypto.randomUUID();\n const players = await Promise.all(playerIds.map(id => getPlayer(id)));\n const validPlayers = players.filter(p => p !== null) as Player[];\n \n if (validPlayers.length !== 4) {\n throw new Error('Game requires exactly 4 players');\n }\n \n await sqlite.execute(\n `INSERT INTO ${SESSIONS_TABLE} (id, player_ids, current_seeker) VALUES (?, ?, ?)`,\n [id, JSON.stringify(playerIds), playerIds[0]]\n );\n \n return {\n id,\n players: validPlayers,\n currentRound: 1,\n currentSeeker: playerIds[0],\n gameStatus: 'waiting',\n roundDuration: 120\n };\n}\n\nexport async function getGameSession(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${SESSIONS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.length === 0) return null;\n \n const row = result[0];\n const playerIds = JSON.parse(row.player_ids);\n const players = await Promise.all(playerIds.map((id: string) => getPlayer(id)));\n const validPlayers = players.filter(p => p !== null) as Player[];\n \n return {\n id: row.id,\n players: validPlayers,\n currentRound: row.current_round,\n currentSeeker: row.current_seeker,\n gameStatus: row.game_status,\n roundStartTime: row.round_start_time,\n roundDuration: row.round_duration\n };\n}\n\nexport async function updateGameSession(id: string, updates: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (updates.currentRound !== undefined) {\n fields.push('current_round = ?');\n values.push(updates.currentRound);\n }\n if (updates.currentSeeker !== undefined) {\n fields.push('current_seeker = ?');\n values.push(updates.currentSeeker);\n }\n if (updates.gameStatus !== undefined) {\n fields.push('game_status = ?');\n values.push(updates.gameStatus);\n }\n if (updates.roundStartTime !== undefined) {\n fields.push('round_start_time = ?');\n values.push(updates.roundStartTime);\n }\n \n if (fields.length === 0) return;\n \n values.push(id);\n \n await sqlite.execute(\n `UPDATE ${SESSIONS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n values\n );\n}\n\nexport async function createGameRound(round: Omit): Promise {\n const id = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${ROUNDS_TABLE} (id, session_id, round_number, seeker_id, hider_ids, start_time) VALUES (?, ?, ?, ?, ?, ?)`,\n [id, round.sessionId, round.roundNumber, round.seekerId, JSON.stringify(round.hiderIds), round.startTime]\n );\n \n return { id, ...round };\n}\n\nexport async function updateGameRound(id: string, updates: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (updates.foundPlayers !== undefined) {\n fields.push('found_players = ?');\n values.push(JSON.stringify(updates.foundPlayers));\n }\n if (updates.roundScore !== undefined) {\n fields.push('round_score = ?');\n values.push(JSON.stringify(updates.roundScore));\n }\n if (updates.endTime !== undefined) {\n fields.push('end_time = ?');\n values.push(updates.endTime);\n }\n \n if (fields.length === 0) return;\n \n values.push(id);\n \n await sqlite.execute(\n `UPDATE ${ROUNDS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n values\n );\n}\n\nexport async function getPlayerRewards(playerId: string): Promise {\n const result = await sqlite.execute(\n `SELECT reward_id FROM ${PLAYER_REWARDS_TABLE} WHERE player_id = ?`,\n [playerId]\n );\n \n return result.map(row => row.reward_id);\n}\n\nexport async function awardReward(playerId: string, rewardId: string): Promise {\n try {\n await sqlite.execute(\n `INSERT INTO ${PLAYER_REWARDS_TABLE} (player_id, reward_id) VALUES (?, ?)`,\n [playerId, rewardId]\n );\n } catch (error) {\n // Ignore duplicate key errors (reward already earned)\n if (!error.message.includes('UNIQUE constraint failed')) {\n throw error;\n }\n }\n}",[151,170,185],{"_152":205,"_104":206,"_109":348,"_155":138,"_272":349},["D",1748872193249],[350],{"_107":203,"_155":138,"_152":205,"_100":204,"_163":209,"_161":208,"_104":199,"_154":153,"_109":348,"_156":206,"_165":-5,"_158":159,"_164":27,"_103":351},[151,204],{"_152":232,"_104":233,"_109":353,"_155":138,"_272":354},["D",1748872190533],[355],{"_107":230,"_155":138,"_152":232,"_100":231,"_163":235,"_161":179,"_104":31,"_154":216,"_109":353,"_156":233,"_165":-5,"_158":159,"_164":27,"_103":356},[215,231],{"_152":241,"_104":242,"_109":358,"_155":138,"_272":359},["D",1748872111033],[360],{"_107":239,"_155":138,"_152":241,"_100":240,"_163":244,"_161":225,"_104":31,"_154":216,"_109":358,"_156":242,"_165":-5,"_158":159,"_164":27,"_103":361},[215,240],{"_152":223,"_104":217,"_109":363,"_155":138,"_272":364},["D",1748872087528],[365,367],{"_107":221,"_155":138,"_152":223,"_100":222,"_163":226,"_161":225,"_104":31,"_154":216,"_109":363,"_156":217,"_165":-5,"_158":159,"_164":27,"_103":366},[215,222],{"_107":214,"_155":138,"_152":216,"_100":215,"_163":-5,"_161":162,"_104":31,"_154":-5,"_109":368,"_156":217,"_165":-5,"_158":159,"_164":27,"_103":369},["D",1748872087528],[215],{"_152":205,"_104":371,"_109":372,"_155":138,"_272":373},5,["D",1748872081214],[374],{"_107":375,"_155":138,"_152":205,"_100":204,"_163":209,"_161":179,"_104":31,"_154":153,"_109":372,"_156":371,"_165":-5,"_158":27,"_164":27,"_103":376},"3317cf1a-3fb8-11f0-8f0c-76b3cceeab13",[151,204],{"_152":186,"_104":189,"_109":378,"_155":138,"_272":379},["D",1748872040289],[380],{"_107":381,"_155":138,"_152":186,"_100":185,"_163":382,"_161":179,"_104":31,"_154":171,"_109":378,"_156":189,"_165":-5,"_158":27,"_164":27,"_103":383},"1ab31574-3fb8-11f0-9988-76b3cceeab13","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { PLAYERS_TABLE, SESSIONS_TABLE, ROUNDS_TABLE, PLAYER_REWARDS_TABLE } from \"./migrations.ts\";\nimport type { Player, GameSession, GameRound } from \"../../shared/types.ts\";\n\nexport async function createPlayer(name: string): Promise {\n const id = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${PLAYERS_TABLE} (id, name) VALUES (?, ?)`,\n [id, name]\n );\n \n return {\n id,\n name,\n score: 0,\n gamesPlayed: 0,\n timesSeeker: 0,\n timesHidden: 0,\n successfulHides: 0,\n successfulSeeks: 0\n };\n}\n\nexport async function getPlayer(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${PLAYERS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.length === 0) return null;\n \n const row = result[0];\n return {\n id: row.id,\n name: row.name,\n score: row.score,\n gamesPlayed: row.games_played,\n timesSeeker: row.times_seeker,\n timesHidden: row.times_hidden,\n successfulHides: row.successful_hides,\n successfulSeeks: row.successful_seeks\n };\n}\n\nexport async function getAllPlayers(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${PLAYERS_TABLE} ORDER BY score DESC`);\n \n return result.map(row => ({\n id: row.id,\n name: row.name,\n score: row.score,\n gamesPlayed: row.games_played,\n timesSeeker: row.times_seeker,\n timesHidden: row.times_hidden,\n successfulHides: row.successful_hides,\n successfulSeeks: row.successful_seeks\n }));\n}\n\nexport async function updatePlayerStats(playerId: string, updates: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (updates.score !== undefined) {\n fields.push('score = ?');\n values.push(updates.score);\n }\n if (updates.gamesPlayed !== undefined) {\n fields.push('games_played = ?');\n values.push(updates.gamesPlayed);\n }\n if (updates.timesSeeker !== undefined) {\n fields.push('times_seeker = ?');\n values.push(updates.timesSeeker);\n }\n if (updates.timesHidden !== undefined) {\n fields.push('times_hidden = ?');\n values.push(updates.timesHidden);\n }\n if (updates.successfulHides !== undefined) {\n fields.push('successful_hides = ?');\n values.push(updates.successfulHides);\n }\n if (updates.successfulSeeks !== undefined) {\n fields.push('successful_seeks = ?');\n values.push(updates.successfulSeeks);\n }\n \n if (fields.length === 0) return;\n \n values.push(playerId);\n \n await sqlite.execute(\n `UPDATE ${PLAYERS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n values\n );\n}\n\nexport async function createGameSession(playerIds: string[]): Promise {\n const id = crypto.randomUUID();\n const players = await Promise.all(playerIds.map(id => getPlayer(id)));\n const validPlayers = players.filter(p => p !== null) as Player[];\n \n if (validPlayers.length !== 4) {\n throw new Error('Game requires exactly 4 players');\n }\n \n await sqlite.execute(\n `INSERT INTO ${SESSIONS_TABLE} (id, player_ids, current_seeker) VALUES (?, ?, ?)`,\n [id, JSON.stringify(playerIds), playerIds[0]]\n );\n \n return {\n id,\n players: validPlayers,\n currentRound: 1,\n currentSeeker: playerIds[0],\n gameStatus: 'waiting',\n roundDuration: 120\n };\n}\n\nexport async function getGameSession(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${SESSIONS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.length === 0) return null;\n \n const row = result[0];\n const playerIds = JSON.parse(row.player_ids);\n const players = await Promise.all(playerIds.map((id: string) => getPlayer(id)));\n const validPlayers = players.filter(p => p !== null) as Player[];\n \n return {\n id: row.id,\n players: validPlayers,\n currentRound: row.current_round,\n currentSeeker: row.current_seeker,\n gameStatus: row.game_status,\n roundStartTime: row.round_start_time,\n roundDuration: row.round_duration\n };\n}\n\nexport async function updateGameSession(id: string, updates: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (updates.currentRound !== undefined) {\n fields.push('current_round = ?');\n values.push(updates.currentRound);\n }\n if (updates.currentSeeker !== undefined) {\n fields.push('current_seeker = ?');\n values.push(updates.currentSeeker);\n }\n if (updates.gameStatus !== undefined) {\n fields.push('game_status = ?');\n values.push(updates.gameStatus);\n }\n if (updates.roundStartTime !== undefined) {\n fields.push('round_start_time = ?');\n values.push(updates.roundStartTime);\n }\n \n if (fields.length === 0) return;\n \n values.push(id);\n \n await sqlite.execute(\n `UPDATE ${SESSIONS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n values\n );\n}\n\nexport async function createGameRound(round: Omit): Promise {\n const id = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${ROUNDS_TABLE} (id, session_id, round_number, seeker_id, hider_ids, start_time) VALUES (?, ?, ?, ?, ?, ?)`,\n [id, round.sessionId, round.roundNumber, round.seekerId, JSON.stringify(round.hiderIds), round.startTime]\n );\n \n return { id, ...round };\n}\n\nexport async function updateGameRound(id: string, updates: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (updates.foundPlayers !== undefined) {\n fields.push('found_players = ?');\n values.push(JSON.stringify(updates.foundPlayers));\n }\n if (updates.roundScore !== undefined) {\n fields.push('round_score = ?');\n values.push(JSON.stringify(updates.roundScore));\n }\n if (updates.endTime !== undefined) {\n fields.push('end_time = ?');\n values.push(updates.endTime);\n }\n \n if (fields.length === 0) return;\n \n values.push(id);\n \n await sqlite.execute(\n `UPDATE ${ROUNDS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n values\n );\n}\n\nexport async function getPlayerRewards(playerId: string): Promise {\n const result = await sqlite.execute(\n `SELECT reward_id FROM ${PLAYER_REWARDS_TABLE} WHERE player_id = ?`,\n [playerId]\n );\n \n return result.map(row => row.reward_id);\n}\n\nexport async function awardReward(playerId: string, rewardId: string): Promise {\n try {\n await sqlite.execute(\n `INSERT INTO ${PLAYER_REWARDS_TABLE} (player_id, reward_id) VALUES (?, ?)`,\n [playerId, rewardId]\n );\n } catch (error) {\n // Ignore duplicate key errors (reward already earned)\n if (!error.message.includes('UNIQUE constraint failed')) {\n throw error;\n }\n }\n}",[151,170,185],{"_152":153,"_104":157,"_109":385,"_155":138,"_272":386},["D",1748872009316],[387,389,392],{"_107":150,"_155":138,"_152":153,"_100":151,"_163":-5,"_161":162,"_104":31,"_154":-5,"_109":385,"_156":157,"_165":-5,"_158":159,"_164":27,"_103":388},[151],{"_107":175,"_155":138,"_152":177,"_100":176,"_163":180,"_161":179,"_104":31,"_154":171,"_109":390,"_156":157,"_165":-5,"_158":159,"_164":27,"_103":391},["D",1748872009316],[151,170,176],{"_107":169,"_155":138,"_152":171,"_100":170,"_163":-5,"_161":162,"_104":31,"_154":153,"_109":393,"_156":157,"_165":-5,"_158":159,"_164":27,"_103":394},["D",1748872009316],[151,170],{"_152":258,"_104":252,"_109":396,"_155":138,"_272":397},["D",1748871997076],[398,400],{"_107":256,"_155":138,"_152":258,"_100":257,"_163":260,"_161":179,"_104":31,"_154":251,"_109":396,"_156":252,"_165":-5,"_158":159,"_164":27,"_103":399},[250,257],{"_107":249,"_155":138,"_152":251,"_100":250,"_163":-5,"_161":162,"_104":31,"_154":-5,"_109":401,"_156":252,"_165":-5,"_158":159,"_164":27,"_103":402},["D",1748871997076],[250],{"_152":267,"_104":199,"_109":404,"_155":138,"_272":405},["D",1748871984111],[406],{"_107":265,"_155":138,"_152":267,"_100":266,"_163":269,"_161":225,"_104":31,"_154":-5,"_109":404,"_156":199,"_165":-5,"_158":159,"_164":27,"_103":407},[266],"page","hasNext","routes/_app","actionData","errors"]

History