[{"_1":2,"_173":-5,"_174":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":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","ENV",{"_36":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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","7037b4412b49b7328160fa57e59f17dfe8779fc7","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",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":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",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_146":147,"_170":171,"_172":-5},"handle","Tamaev","name","Berserk","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_145":20},"id","f3a6ce14-3a29-11f0-88ae-9e149126039e","createdAt",["D",1748261230431],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","b7882560-35ae-11f0-9d2e-07e67e88adb2","pinnedFileId","pinPreview","screenshotVersion","likeCount","34175af4-5745-43f9-bee0-4b08f3d1a44b","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4TkI2bXppRzN1OWxyaEIxZFBFMVR3NXdEdSJ9","org",{"_93":94,"_131":128,"_12":111},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},"version",16,"f3a6fe98-3a29-11f0-88ae-9e149126039e","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":148,"_95":149,"_150":151,"_152":153,"_154":136,"_155":156,"_157":158,"_103":159,"_134":160,"_161":162,"_163":164,"_165":20,"_166":-5,"_97":167},"b9a6a44e-3a2b-11f0-b2c8-9e149126039e","queries.ts","fileId","45b738d8-3a2a-11f0-8d1f-9e149126039e","parentId","cb57c728-aeac-4498-aae5-f9c964836126","branchId","branchVersion",11,"latest",true,["D",1748261992114],1,"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { Player, GameSession, Achievement, GameType, AchievementType } from \"../../shared/types.ts\";\nimport { ACHIEVEMENTS, DAILY_BONUS } from \"../../shared/types.ts\";\n\n// Игроки\nexport async function createPlayer(name: string): Promise {\n const id = crypto.randomUUID();\n await sqlite.execute(\n `INSERT INTO players (id, name) VALUES (?, ?)`,\n [id, name]\n );\n \n const result = await sqlite.execute(\n `SELECT * FROM players WHERE id = ?`,\n [id]\n );\n \n return result.rows[0] as Player;\n}\n\nexport async function getPlayer(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM players WHERE id = ?`,\n [id]\n );\n \n return result.rows[0] as Player || null;\n}\n\nexport async function updatePlayer(id: string, updates: Partial): Promise {\n const fields = Object.keys(updates).map(key => `${key} = ?`).join(', ');\n const values = Object.values(updates);\n \n await sqlite.execute(\n `UPDATE players SET ${fields} WHERE id = ?`,\n [...values, id]\n );\n}\n\nexport async function updateBalance(playerId: string, amount: number): Promise {\n const player = await getPlayer(playerId);\n if (!player) return false;\n \n const newBalance = player.balance + amount;\n if (newBalance < 0) return false;\n \n await updatePlayer(playerId, { balance: newBalance });\n return true;\n}\n\nexport async function canAffordBet(playerId: string, amount: number): Promise {\n const player = await getPlayer(playerId);\n return player ? player.balance >= amount : false;\n}\n\n// Игровые сессии\nexport async function createGameSession(\n playerId: string,\n gameType: GameType,\n betAmount: number,\n result: 'win' | 'lose' | 'push',\n payout: number,\n details: any\n): Promise {\n const id = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO game_sessions (id, player_id, game_type, bet_amount, result, payout, details) \n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [id, playerId, gameType, betAmount, result, payout, JSON.stringify(details)]\n );\n \n // Обновляем статистику игрока\n const player = await getPlayer(playerId);\n if (player) {\n await updatePlayer(playerId, {\n total_wagered: player.total_wagered + betAmount,\n total_won: player.total_won + payout,\n games_played: player.games_played + 1\n });\n }\n \n const sessionResult = await sqlite.execute(\n `SELECT * FROM game_sessions WHERE id = ?`,\n [id]\n );\n \n return sessionResult.rows[0] as GameSession;\n}\n\nexport async function getPlayerGameHistory(playerId: string, limit: number = 10): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM game_sessions WHERE player_id = ? ORDER BY created_at DESC LIMIT ?`,\n [playerId, limit]\n );\n \n return result.rows as GameSession[];\n}\n\nexport async function getPlayerStats(playerId: string): Promise {\n const result = await sqlite.execute(`\n SELECT \n game_type,\n COUNT(*) as games_count,\n SUM(bet_amount) as total_bet,\n SUM(payout) as total_payout,\n SUM(CASE WHEN result = 'win' THEN 1 ELSE 0 END) as wins\n FROM game_sessions \n WHERE player_id = ? \n GROUP BY game_type\n `, [playerId]);\n \n return result.rows;\n}\n\n// Достижения\nexport async function unlockAchievement(playerId: string, achievementType: AchievementType): Promise {\n try {\n const id = crypto.randomUUID();\n await sqlite.execute(\n `INSERT INTO achievements (id, player_id, achievement_type) VALUES (?, ?, ?)`,\n [id, playerId, achievementType]\n );\n \n // Добавляем награду\n const reward = ACHIEVEMENTS[achievementType].reward;\n await updateBalance(playerId, reward);\n \n return true;\n } catch (error) {\n // Достижение уже разблокировано\n return false;\n }\n}\n\nexport async function getPlayerAchievements(playerId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM achievements WHERE player_id = ? ORDER BY unlocked_at DESC`,\n [playerId]\n );\n \n return result.rows as Achievement[];\n}\n\nexport async function checkAchievements(playerId: string, gameType: GameType, result: 'win' | 'lose' | 'push', payout: number, betAmount: number): Promise {\n const unlockedAchievements: string[] = [];\n \n // Первая победа\n if (result === 'win') {\n const firstWin = await unlockAchievement(playerId, 'first_win');\n if (firstWin) unlockedAchievements.push('first_win');\n }\n \n // Крупный выигрыш\n if (payout >= 1000) {\n const bigWinner = await unlockAchievement(playerId, 'big_winner');\n if (bigWinner) unlockedAchievements.push('big_winner');\n }\n \n // Хайроллер\n if (betAmount >= 500) {\n const highRoller = await unlockAchievement(playerId, 'high_roller');\n if (highRoller) unlockedAchievements.push('high_roller');\n }\n \n // Мастер слотов\n if (gameType === 'slots') {\n const slotsCount = await sqlite.execute(\n `SELECT COUNT(*) as count FROM game_sessions WHERE player_id = ? AND game_type = 'slots'`,\n [playerId]\n );\n if (slotsCount.rows[0].count >= 100) {\n const slotsMaster = await unlockAchievement(playerId, 'slots_master');\n if (slotsMaster) unlockedAchievements.push('slots_master');\n }\n }\n \n // Профи блэкджека\n if (gameType === 'blackjack' && result === 'win') {\n const blackjackWins = await sqlite.execute(\n `SELECT COUNT(*) as count FROM game_sessions WHERE player_id = ? AND game_type = 'blackjack' AND result = 'win'`,\n [playerId]\n );\n if (blackjackWins.rows[0].count >= 20) {\n const blackjackPro = await unlockAchievement(playerId, 'blackjack_pro');\n if (blackjackPro) unlockedAchievements.push('blackjack_pro');\n }\n }\n \n return unlockedAchievements;\n}\n\n// Ежедневный бонус\nexport async function claimDailyBonus(playerId: string): Promise {\n const player = await getPlayer(playerId);\n if (!player) return false;\n \n const today = new Date().toISOString().split('T')[0];\n \n if (player.last_daily_bonus === today) {\n return false; // Уже получен сегодня\n }\n \n await updatePlayer(playerId, {\n balance: player.balance + DAILY_BONUS,\n last_daily_bonus: today\n });\n \n return true;\n}","deleted","label",[168,169,149],"backend","database","permalink","https://www.val.town/x/Tamaev/Berserk/code/backend/database/queries.ts","extension","actionData","errors"]