[{"_1":2,"_176":-5,"_177":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","2677517008ad9dd1731fff30f772d80c0e798433","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_150":151,"_173":174,"_175":-5},"handle","zalwangojalia","name","Game","path","backend/database/queries.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","b7bc80cc-3fb7-11f0-8e53-76b3cceeab13","createdAt",["D",1748871874260],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","01947ed0-3fa8-11f0-ad5b-814c56c8abb0","pinnedFileId","3317cfec-3fb8-11f0-8f0c-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","3f623da0-6603-4788-98c6-e7ba2e2e200f","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4eDBVOW94VWxHZ2tsYkE0VlNRSFFKZFRzcyJ9","org",{"_94":95,"_135":132,"_12":112},"avatar","branch",{"_138":139,"_96":44,"_102":140,"_141":103,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":97,"_148":95},"version",15,"b7bce0b2-3fb7-11f0-8e53-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":152,"_96":153,"_154":155,"_156":157,"_158":140,"_159":160,"_161":116,"_104":162,"_138":163,"_164":165,"_166":167,"_168":20,"_169":-5,"_98":170},"945d6a0a-3fb8-11f0-8e46-76b3cceeab13","queries.ts","fileId","1ab3168c-3fb8-11f0-9988-76b3cceeab13","parentId","67757f87-f3e0-496d-9705-e2d51ea339db","branchId","branchVersion",13,"latest",["D",1748872244404],4,"fileType","script","content","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 if (!Array.isArray(result)) {\n return [];\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}","deleted","label",[171,172,153],"backend","database","permalink","https://www.val.town/x/zalwangojalia/Game/code/backend/database/queries.ts","extension","actionData","errors"]