\n \n

🎰 КАЗИНО СИМУЛЯТОР 🎰

Испытайте удачу в лучших играх казино!

\n \n

🎲 Загрузка казино...

\n \n

$1000

💰 Баланс

🎯 Всего поставлено

🏆 Всего выиграно

🎮 Игр сыграно

\n \n

\n \n \n

\n \n \n \n \n

\n \n \n

🎰 Слот-машины

🍒

🍋

🍊

\n \n

\n Ставка:\n \n

\n \n \n \n

\n \n \n

🃏 Блэкджек

\n \n

\n Ставка:\n \n

\n \n

Дилер (?)

\n \n

Ваши карты (0)

\n \n

\n \n \n

\n \n

\n \n \n

🎯 Рулетка

\n \n

\n Красное:\n \n

\n Черное:\n \n

\n Четное:\n \n

\n Нечетное:\n \n

\n \n

\n Число (0-36):\n \n \n

\n \n \n \n

\n \n \n

🎲 Кости

\n \n

⚀

\n \n

\n Ставка:\n \n

\n Тип ставки:\n \n

\n Сумма (2-12):\n \n

\n \n \n \n

\n \n \n

📊 История игр

\n \n

\n \n \n\n",[],[232,224],"frontend","4d14132e-3a2c-11f0-b388-9e149126039e","casino.js","4d1413e2-3a2c-11f0-b388-9e149126039e",15,["D",1748262239457],"// Казино симулятор - основная логика\n\nclass CasinoGame {\n constructor() {\n this.player = null;\n this.currentGame = 'slots';\n this.init();\n }\n\n async init() {\n await this.loadPlayer();\n await this.loadDashboard();\n this.setupEventListeners();\n this.showGame('slots');\n \n document.getElementById('loading').classList.add('hidden');\n document.getElementById('casino').classList.remove('hidden');\n }\n\n async loadPlayer() {\n try {\n const response = await fetch('/api/player');\n this.player = await response.json();\n } catch (error) {\n console.error('Ошибка загрузки игрока:', error);\n }\n }\n\n async loadDashboard() {\n try {\n const response = await fetch('/api/dashboard');\n const data = await response.json();\n \n this.updatePlayerStats(data.player);\n this.updateGameHistory(data.gameHistory);\n \n } catch (error) {\n console.error('Ошибка загрузки дашборда:', error);\n }\n }\n\n updatePlayerStats(player) {\n document.getElementById('player-balance').textContent = `$${player.balance}`;\n document.getElementById('total-wagered').textContent = `$${player.total_wagered}`;\n document.getElementById('total-won').textContent = `$${player.total_won}`;\n document.getElementById('games-played').textContent = player.games_played;\n \n // Проверяем доступность ежедневного бонуса\n const today = new Date().toISOString().split('T')[0];\n const bonusBtn = document.getElementById('daily-bonus-btn');\n if (player.last_daily_bonus === today) {\n bonusBtn.disabled = true;\n bonusBtn.textContent = '✅ Бонус получен';\n bonusBtn.classList.add('opacity-50');\n }\n }\n\n updateGameHistory(history) {\n const container = document.getElementById('game-history');\n container.innerHTML = '';\n \n if (history.length === 0) {\n container.innerHTML = '

История игр пуста

';\n return;\n }\n \n history.forEach(game => {\n const gameDiv = document.createElement('div');\n gameDiv.className = 'flex justify-between items-center p-3 bg-black bg-opacity-20 rounded-lg';\n \n const resultColor = game.result === 'win' ? 'text-green-400' : \n game.result === 'lose' ? 'text-red-400' : 'text-yellow-400';\n \n const gameIcon = {\n 'slots': '🎰',\n 'blackjack': '🃏',\n 'roulette': '🎯',\n 'dice': '🎲'\n }[game.game_type] || '🎮';\n \n gameDiv.innerHTML = `\n

\n ${gameIcon}\n

${game.game_type.charAt(0).toUpperCase() + game.game_type.slice(1)}

${new Date(game.created_at).toLocaleString()}

\n ${game.result === 'win' ? '+' : game.result === 'lose' ? '-' : ''}$${game.result === 'win' ? game.payout : game.bet_amount}\n

Ставка: $${game.bet_amount}

\n `;\n \n container.appendChild(gameDiv);\n });\n }\n\n setupEventListeners() {\n // Переключение игр\n document.querySelectorAll('.game-tab').forEach(tab => {\n tab.addEventListener('click', (e) => {\n const game = e.target.dataset.game;\n this.showGame(game);\n });\n });\n\n // Ежедневный бонус\n document.getElementById('daily-bonus-btn').addEventListener('click', () => {\n this.claimDailyBonus();\n });\n\n // Обновление\n document.getElementById('refresh-btn').addEventListener('click', () => {\n this.loadDashboard();\n });\n\n // Слоты\n this.setupSlotsListeners();\n \n // Блэкджек\n this.setupBlackjackListeners();\n \n // Рулетка\n this.setupRouletteListeners();\n \n // Кости\n this.setupDiceListeners();\n }\n\n showGame(gameType) {\n // Скрываем все игры\n document.querySelectorAll('.game-content').forEach(content => {\n content.classList.add('hidden');\n });\n \n // Убираем активный класс со всех вкладок\n document.querySelectorAll('.game-tab').forEach(tab => {\n tab.classList.remove('active');\n });\n \n // Показываем выбранную игру\n document.getElementById(`${gameType}-game`).classList.remove('hidden');\n document.querySelector(`[data-game=\"${gameType}\"]`).classList.add('active');\n \n this.currentGame = gameType;\n }\n\n async claimDailyBonus() {\n try {\n const response = await fetch('/api/daily-bonus', { method: 'POST' });\n const data = await response.json();\n \n if (data.success) {\n this.showNotification('🎁 Получен ежедневный бонус $200!', 'success');\n await this.loadDashboard();\n } else {\n this.showNotification(data.error, 'error');\n }\n } catch (error) {\n this.showNotification('Ошибка получения бонуса', 'error');\n }\n }\n\n // === СЛОТЫ ===\n setupSlotsListeners() {\n const betInput = document.getElementById('slots-bet');\n const betDisplay = document.getElementById('slots-bet-display');\n \n betInput.addEventListener('input', () => {\n betDisplay.textContent = betInput.value;\n });\n\n document.getElementById('spin-btn').addEventListener('click', () => {\n this.playSlots();\n });\n }\n\n async playSlots() {\n const betAmount = parseInt(document.getElementById('slots-bet').value);\n \n if (betAmount <= 0) {\n this.showNotification('Введите корректную ставку', 'error');\n return;\n }\n\n try {\n // Анимация вращения\n this.animateSlots();\n \n const response = await fetch('/api/slots', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ betAmount })\n });\n \n const data = await response.json();\n \n if (data.error) {\n this.showNotification(data.error, 'error');\n return;\n }\n \n // Показываем результат после анимации\n setTimeout(() => {\n this.showSlotsResult(data.result);\n this.handleAchievements(data.achievements);\n this.loadDashboard();\n }, 1000);\n \n } catch (error) {\n this.showNotification('Ошибка игры в слоты', 'error');\n }\n }\n\n animateSlots() {\n const reels = ['reel1', 'reel2', 'reel3'];\n const symbols = ['🍒', '🍋', '🍊', '🍇', '⭐', '💎', '7️⃣'];\n \n reels.forEach(reelId => {\n const reel = document.getElementById(reelId);\n reel.classList.add('slot-reel');\n \n let spins = 0;\n const interval = setInterval(() => {\n reel.textContent = symbols[Math.floor(Math.random() * symbols.length)];\n spins++;\n if (spins > 10) {\n clearInterval(interval);\n }\n }, 100);\n });\n }\n\n showSlotsResult(result) {\n // Показываем финальный результат\n document.getElementById('reel1').textContent = result.reels[0];\n document.getElementById('reel2').textContent = result.reels[1];\n document.getElementById('reel3').textContent = result.reels[2];\n \n const resultDiv = document.getElementById('slots-result');\n const messageDiv = document.getElementById('slots-message');\n \n if (result.winAmount > 0) {\n if (result.isJackpot) {\n messageDiv.innerHTML = `🎉 ДЖЕКПОТ! Выигрыш: $${result.winAmount}! 🎉`;\n messageDiv.className = 'text-2xl font-bold text-yellow-400 jackpot-animation';\n } else {\n messageDiv.innerHTML = `🎊 Выигрыш: $${result.winAmount}!`;\n messageDiv.className = 'text-xl font-bold text-green-400';\n }\n } else {\n messageDiv.innerHTML = '😔 Не повезло, попробуйте еще раз!';\n messageDiv.className = 'text-xl font-bold text-red-400';\n }\n \n resultDiv.classList.remove('hidden');\n \n // Скрываем результат через 3 секунды\n setTimeout(() => {\n resultDiv.classList.add('hidden');\n }, 3000);\n }\n\n // === БЛЭКДЖЕК ===\n setupBlackjackListeners() {\n const betInput = document.getElementById('blackjack-bet');\n const betDisplay = document.getElementById('blackjack-bet-display');\n \n betInput.addEventListener('input', () => {\n betDisplay.textContent = betInput.value;\n });\n\n document.getElementById('deal-btn').addEventListener('click', () => {\n this.startBlackjack();\n });\n\n document.getElementById('hit-btn').addEventListener('click', () => {\n this.hitBlackjack();\n });\n\n document.getElementById('stand-btn').addEventListener('click', () => {\n this.standBlackjack();\n });\n\n document.getElementById('new-game-btn').addEventListener('click', () => {\n this.resetBlackjack();\n });\n }\n\n async startBlackjack() {\n const betAmount = parseInt(document.getElementById('blackjack-bet').value);\n \n if (betAmount <= 0) {\n this.showNotification('Введите корректную ставку', 'error');\n return;\n }\n\n try {\n const response = await fetch('/api/blackjack/start', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ betAmount })\n });\n \n const data = await response.json();\n \n if (data.error) {\n this.showNotification(data.error, 'error');\n return;\n }\n \n this.showBlackjackTable(data);\n \n } catch (error) {\n this.showNotification('Ошибка начала игры в блэкджек', 'error');\n }\n }\n\n async hitBlackjack() {\n try {\n const response = await fetch('/api/blackjack/hit', { method: 'POST' });\n const data = await response.json();\n \n if (data.error) {\n this.showNotification(data.error, 'error');\n return;\n }\n \n this.updateBlackjackHand('player', data.playerHand, data.playerValue);\n \n if (data.gameOver) {\n this.showBlackjackResult('Перебор! Вы проиграли.', 'lose');\n this.loadDashboard();\n }\n \n } catch (error) {\n this.showNotification('Ошибка взятия карты', 'error');\n }\n }\n\n async standBlackjack() {\n try {\n const response = await fetch('/api/blackjack/stand', { method: 'POST' });\n const data = await response.json();\n \n if (data.error) {\n this.showNotification(data.error, 'error');\n return;\n }\n \n this.updateBlackjackHand('dealer', data.dealerHand, data.dealerValue);\n this.updateBlackjackHand('player', data.playerHand, data.playerValue);\n \n let message = '';\n let resultType = data.result;\n \n if (data.result === 'win') {\n message = `Вы выиграли $${data.payout}!`;\n } else if (data.result === 'lose') {\n message = 'Вы проиграли!';\n } else {\n message = 'Ничья!';\n }\n \n this.showBlackjackResult(message, resultType);\n this.handleAchievements(data.achievements);\n this.loadDashboard();\n \n } catch (error) {\n this.showNotification('Ошибка завершения игры', 'error');\n }\n }\n\n showBlackjackTable(data) {\n document.getElementById('blackjack-setup').classList.add('hidden');\n document.getElementById('blackjack-table').classList.remove('hidden');\n \n this.updateBlackjackHand('dealer', data.dealerHand, data.dealerValue);\n this.updateBlackjackHand('player', data.playerHand, data.playerValue);\n \n // Управление кнопками\n document.getElementById('hit-btn').disabled = !data.canHit;\n document.getElementById('stand-btn').disabled = !data.canStand;\n \n if (data.gameOver) {\n document.getElementById('blackjack-actions').classList.add('hidden');\n // Автоматически завершаем игру если блэкджек\n setTimeout(() => this.standBlackjack(), 1000);\n }\n }\n\n updateBlackjackHand(player, cards, value) {\n const container = document.getElementById(`${player}-cards`);\n const valueSpan = document.getElementById(`${player}-value`);\n \n container.innerHTML = '';\n cards.forEach(card => {\n const cardDiv = document.createElement('div');\n cardDiv.className = `card ${card.suit === 'hearts' || card.suit === 'diamonds' ? 'red' : ''}`;\n cardDiv.textContent = `${card.rank}${this.getSuitSymbol(card.suit)}`;\n container.appendChild(cardDiv);\n });\n \n valueSpan.textContent = value;\n }\n\n getSuitSymbol(suit) {\n const symbols = {\n 'hearts': '♥',\n 'diamonds': '♦',\n 'clubs': '♣',\n 'spades': '♠'\n };\n return symbols[suit] || '';\n }\n\n showBlackjackResult(message, result) {\n document.getElementById('blackjack-actions').classList.add('hidden');\n document.getElementById('blackjack-result').classList.remove('hidden');\n \n const messageDiv = document.getElementById('blackjack-message');\n messageDiv.textContent = message;\n \n if (result === 'win') {\n messageDiv.className = 'text-xl font-bold text-green-400';\n } else if (result === 'lose') {\n messageDiv.className = 'text-xl font-bold text-red-400';\n } else {\n messageDiv.className = 'text-xl font-bold text-yellow-400';\n }\n }\n\n resetBlackjack() {\n document.getElementById('blackjack-setup').classList.remove('hidden');\n document.getElementById('blackjack-table').classList.add('hidden');\n document.getElementById('blackjack-result').classList.add('hidden');\n document.getElementById('blackjack-actions').classList.remove('hidden');\n }\n\n // === РУЛЕТКА ===\n setupRouletteListeners() {\n document.getElementById('spin-roulette-btn').addEventListener('click', () => {\n this.playRoulette();\n });\n }\n\n async playRoulette() {\n const bets = {\n red: parseInt(document.getElementById('bet-red').value) || 0,\n black: parseInt(document.getElementById('bet-black').value) || 0,\n even: parseInt(document.getElementById('bet-even').value) || 0,\n odd: parseInt(document.getElementById('bet-odd').value) || 0\n };\n \n const numberValue = parseInt(document.getElementById('bet-number-value').value);\n const numberAmount = parseInt(document.getElementById('bet-number-amount').value) || 0;\n \n if (numberAmount > 0) {\n bets[numberValue] = numberAmount;\n }\n \n const totalBet = Object.values(bets).reduce((sum, bet) => sum + bet, 0);\n \n if (totalBet <= 0) {\n this.showNotification('Сделайте ставку', 'error');\n return;\n }\n\n try {\n // Анимация рулетки\n this.animateRoulette();\n \n const response = await fetch('/api/roulette', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ bets })\n });\n \n const data = await response.json();\n \n if (data.error) {\n this.showNotification(data.error, 'error');\n return;\n }\n \n setTimeout(() => {\n this.showRouletteResult(data.result, data.totalPayout);\n this.handleAchievements(data.achievements);\n this.loadDashboard();\n }, 3000);\n \n } catch (error) {\n this.showNotification('Ошибка игры в рулетку', 'error');\n }\n }\n\n animateRoulette() {\n const wheel = document.getElementById('roulette-wheel');\n wheel.style.animation = 'none';\n setTimeout(() => {\n wheel.style.animation = 'roulette-spin 3s ease-out';\n }, 10);\n }\n\n showRouletteResult(result, totalPayout) {\n const resultDiv = document.getElementById('roulette-result');\n const messageDiv = document.getElementById('roulette-message');\n \n let message = `Выпало: ${result.number} (${result.color === 'green' ? 'зеленое' : result.color === 'red' ? 'красное' : 'черное'})`;\n \n if (totalPayout > 0) {\n message += `\\n🎊 Выигрыш: $${totalPayout}!`;\n if (result.winningBets.length > 0) {\n message += `\\nВыигрышные ставки: ${result.winningBets.join(', ')}`;\n }\n messageDiv.className = 'text-xl font-bold text-green-400';\n } else {\n message += '\\n😔 Не повезло!';\n messageDiv.className = 'text-xl font-bold text-red-400';\n }\n \n messageDiv.innerHTML = message.replace(/\\n/g, '
');\n resultDiv.classList.remove('hidden');\n \n setTimeout(() => {\n resultDiv.classList.add('hidden');\n // Очищаем ставки\n document.getElementById('bet-red').value = 0;\n document.getElementById('bet-black').value = 0;\n document.getElementById('bet-even').value = 0;\n document.getElementById('bet-odd').value = 0;\n document.getElementById('bet-number-amount').value = 0;\n }, 5000);\n }\n\n // === КОСТИ ===\n setupDiceListeners() {\n document.getElementById('dice-bet-type').addEventListener('change', (e) => {\n const sumInput = document.getElementById('dice-sum-input');\n if (e.target.value === 'sum') {\n sumInput.classList.remove('hidden');\n } else {\n sumInput.classList.add('hidden');\n }\n });\n\n document.getElementById('roll-dice-btn').addEventListener('click', () => {\n this.playDice();\n });\n }\n\n async playDice() {\n const betAmount = parseInt(document.getElementById('dice-bet').value);\n const betType = document.getElementById('dice-bet-type').value;\n const betValue = betType === 'sum' ? parseInt(document.getElementById('dice-sum-value').value) : null;\n \n if (betAmount <= 0) {\n this.showNotification('Введите корректную ставку', 'error');\n return;\n }\n\n try {\n // Анимация костей\n this.animateDice();\n \n const response = await fetch('/api/dice', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ betAmount, betType, betValue })\n });\n \n const data = await response.json();\n \n if (data.error) {\n this.showNotification(data.error, 'error');\n return;\n }\n \n setTimeout(() => {\n this.showDiceResult(data.result, data.won, data.payout);\n this.handleAchievements(data.achievements);\n this.loadDashboard();\n }, 1000);\n \n } catch (error) {\n this.showNotification('Ошибка игры в кости', 'error');\n }\n }\n\n animateDice() {\n const dice1 = document.getElementById('dice1');\n const dice2 = document.getElementById('dice2');\n const diceSymbols = ['⚀', '⚁', '⚂', '⚃', '⚄', '⚅'];\n \n [dice1, dice2].forEach(dice => {\n dice.classList.add('dice');\n let rolls = 0;\n const interval = setInterval(() => {\n dice.textContent = diceSymbols[Math.floor(Math.random() * 6)];\n rolls++;\n if (rolls > 10) {\n clearInterval(interval);\n }\n }, 100);\n });\n }\n\n showDiceResult(result, won, payout) {\n const diceSymbols = ['⚀', '⚁', '⚂', '⚃', '⚄', '⚅'];\n \n document.getElementById('dice1').textContent = diceSymbols[result.dice1 - 1];\n document.getElementById('dice2').textContent = diceSymbols[result.dice2 - 1];\n \n const resultDiv = document.getElementById('dice-result');\n const messageDiv = document.getElementById('dice-message');\n \n let message = `Кости: ${result.dice1} + ${result.dice2} = ${result.sum}`;\n \n if (won) {\n message += `\\n🎊 Выигрыш: $${payout}!`;\n messageDiv.className = 'text-xl font-bold text-green-400';\n } else {\n message += '\\n😔 Не повезло!';\n messageDiv.className = 'text-xl font-bold text-red-400';\n }\n \n messageDiv.innerHTML = message.replace(/\\n/g, '
');\n resultDiv.classList.remove('hidden');\n \n setTimeout(() => {\n resultDiv.classList.add('hidden');\n }, 3000);\n }\n\n // === ОБЩИЕ ФУНКЦИИ ===\n handleAchievements(achievements) {\n if (achievements && achievements.length > 0) {\n achievements.forEach(achievement => {\n this.showAchievement(achievement);\n });\n }\n }\n\n showAchievement(achievementType) {\n const achievements = {\n first_win: { name: 'Первая победа', description: 'Выиграйте свою первую игру', reward: 100 },\n big_winner: { name: 'Крупный выигрыш', description: 'Выиграйте 1000+ за одну игру', reward: 500 },\n high_roller: { name: 'Хайроллер', description: 'Поставьте 500+ за одну игру', reward: 200 },\n lucky_streak: { name: 'Полоса везения', description: 'Выиграйте 5 игр подряд', reward: 300 },\n slots_master: { name: 'Мастер слотов', description: 'Сыграйте 100 игр в слоты', reward: 250 },\n blackjack_pro: { name: 'Профи блэкджека', description: 'Выиграйте 20 игр в блэкджек', reward: 300 },\n roulette_king: { name: 'Король рулетки', description: 'Выиграйте на точном числе в рулетке', reward: 400 },\n dice_champion: { name: 'Чемпион костей', description: 'Выиграйте 10 игр в кости подряд', reward: 350 }\n };\n \n const achievement = achievements[achievementType];\n if (!achievement) return;\n \n const popup = document.createElement('div');\n popup.className = 'achievement-popup';\n popup.innerHTML = `\n

🏆 Достижение разблокировано!

${achievement.name}

${achievement.description}

Награда: $${achievement.reward}

\n `;\n \n document.body.appendChild(popup);\n \n setTimeout(() => {\n popup.remove();\n }, 5000);\n }\n\n showNotification(message, type = 'info') {\n const notification = document.createElement('div');\n notification.className = 'notification';\n notification.textContent = message;\n \n if (type === 'success') {\n notification.style.background = 'rgba(34, 197, 94, 0.9)';\n } else if (type === 'error') {\n notification.style.background = 'rgba(239, 68, 68, 0.9)';\n }\n \n document.body.appendChild(notification);\n \n setTimeout(() => {\n notification.remove();\n }, 3000);\n }\n}\n\n// Запуск игры\ndocument.addEventListener('DOMContentLoaded', () => {\n new CasinoGame();\n});",[],[232,234],"74e4e8c6-3a2a-11f0-8151-9e149126039e",7,["D",1748261447262],[194,195],[232],"4f4920a8-3a2c-11f0-9efd-9e149126039e","index.ts",["D",1748262243153],"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 casinoRoutes from \"./routes/casino.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// Инициализация базы данных\nawait runMigrations();\n\n// API маршруты\napp.route(\"/api\", casinoRoutes);\n\n// Статические файлы\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Главная страница\napp.get(\"/\", async c => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\nexport default app.fetch;",[],[163,247],["D",1748261401392],[],[163,83,65],["D",1748262052822],[],[163,83,81],["D",1748261401392],[190,191],[163,83],"b9a6a44e-3a2b-11f0-b2c8-9e149126039e","queries.ts","45b738d8-3a2a-11f0-8d1f-9e149126039e","cb57c728-aeac-4498-aae5-f9c964836126",11,["D",1748261992114],"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}",[],[163,271,263],"database","a9633700-3a2b-11f0-8a27-9e149126039e","migrations.ts","382c2c14-3a2a-11f0-9d7a-9e149126039e",10,["D",1748261964827],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport async function runMigrations() {\n // Таблица игроков\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS players (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n balance INTEGER DEFAULT 1000,\n total_wagered INTEGER DEFAULT 0,\n total_won INTEGER DEFAULT 0,\n games_played INTEGER DEFAULT 0,\n last_daily_bonus TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Таблица игровых сессий\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS game_sessions (\n id TEXT PRIMARY KEY,\n player_id TEXT NOT NULL,\n game_type TEXT NOT NULL,\n bet_amount INTEGER NOT NULL,\n result TEXT NOT NULL,\n payout INTEGER DEFAULT 0,\n details TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (player_id) REFERENCES players (id)\n )\n `);\n\n // Таблица достижений\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS achievements (\n id TEXT PRIMARY KEY,\n player_id TEXT NOT NULL,\n achievement_type TEXT NOT NULL,\n unlocked_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (player_id) REFERENCES players (id),\n UNIQUE(player_id, achievement_type)\n )\n `);\n\n console.log(\"Casino database migrations completed\");\n}",[],[163,271,273],"382c3614-3a2a-11f0-9d7a-9e149126039e",3,["D",1748261345389],[187,188],[163,271],"382c33ee-3a2a-11f0-9d7a-9e149126039e",["D",1748261345389],[186,189,192],[163],["D",1748261230431],{"_11":12,"_133":71},{"_11":12,"_129":-5,"_70":71,"_31":69,"_130":131,"_132":30},{"_40":120,"_13":16,"_34":37,"_121":86,"_122":-5,"_123":-5,"_124":-5,"_125":-5,"_126":-5,"_127":14,"_128":12},"ctx",{"_53":-5,"_152":326,"_327":328,"_329":330,"_331":30,"_332":30,"_333":30,"_334":24,"_335":-5,"_336":-7,"_337":-7,"_338":26,"_339":30,"_340":30,"_341":-5,"_342":30,"_343":30,"_344":30,"_345":-5},"ENV",{"_297":298,"_299":300,"_301":16,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325},"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"]

History · routes