[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_252":253,"_254":255},"routes/_app.x.$handle.$name",{"_100":99,"_32":49,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_21":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_47":48,"_32":49,"_36":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",7,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","frontend","latestPath","fileId","fb1e8bb2-9f34-4a9a-acea-d7b06c63d304","name","fileType","directory","content","createdAt",["D",1748261447262],"branchVersion","branchId","f3a6fe98-3a29-11f0-88ae-9e149126039e",{"_30":43,"_32":44,"_33":21,"_35":45,"_36":46,"_38":14,"_39":40,"_24":25},"frontend/index.html","74e4a6ea-3a2a-11f0-8151-9e149126039e","index.html","\n\n\n \n \n Военная Игра - Military Game\n \n \n \n\n\n

⚔️ ВОЕННАЯ ИГРА ⚔️

Командуй армией, побеждай террористов!

\n \n

🔄 Загрузка...

\n \n

Уровень

500

🪙 Монеты

⭐ Опыт

100

🎖️ Готовность

\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 \n

\n \n \n\n",["D",1748261447262],"id","f3a6ce14-3a29-11f0-88ae-9e149126039e","Berserk",["D",1748261230431],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","b7882560-35ae-11f0-9d2e-07e67e88adb2","pinnedFileId","5e3e21e6-3a2a-11f0-ae64-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","34175af4-5745-43f9-bee0-4b08f3d1a44b","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_47":40,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"isOwned",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Tamaev","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4TkI2bXppRzN1OWxyaEIxZFBFMVR3NXdEdSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_32":49,"_36":248,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":249,"_84":250,"_86":251,"_88":25},"tree",[169,176,178,180],"files",[169,170,171,172,173,174,175,176,177,178,179,180],"counts",{"_159":66,"_160":138,"_161":66,"_162":163,"_164":165},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":153,"_32":154,"_30":155,"_137":-5,"_39":40,"_38":156,"_139":62,"_36":157,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":158},{"_47":150,"_32":28,"_30":31,"_137":-5,"_39":40,"_38":14,"_139":62,"_36":151,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":152},{"_47":144,"_32":145,"_30":146,"_137":-5,"_39":40,"_38":147,"_139":62,"_36":148,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":149},{"_47":134,"_32":135,"_30":136,"_137":-5,"_39":40,"_38":138,"_139":25,"_36":140,"_13":66,"_33":21,"_35":141,"_24":25,"_142":-5,"_27":143},"2b40cac8-3a2a-11f0-abe8-9e149126039e","README.md","2b40cb90-3a2a-11f0-abe8-9e149126039e","parentId",1,"latest",["D",1748261323713],"# Военная Игра - Military Game\n\nМини-игра военной техники с системой прокачки, атаками и игровой валютой.\n\n## Особенности\n\n- 🚁 Получение и улучшение военной техники\n- ⚔️ Система атак против террористов\n- 🎖️ Система уровней и опыта\n- 👨‍✈️ Обучение солдат\n- 🪙 Игровая валюта (монеты)\n- 🎁 Бонусные монеты (500 за старт)\n\n## Структура проекта\n\n- `frontend/` - Клиентская часть игры\n- `backend/` - API и база данных\n- `shared/` - Общие типы и утилиты\n\n## Запуск\n\nОткройте `backend/index.ts` как HTTP val для запуска игры.","label",[135],"33215898-3a2a-11f0-bddd-9e149126039e","shared","d97bedd4-61b9-407d-85b9-333ce8d914bb",2,["D",1748261336929],[145],"74e4e8c6-3a2a-11f0-8151-9e149126039e",["D",1748261447262],[28],"382c33ee-3a2a-11f0-9d7a-9e149126039e","backend","fef6242b-c702-4e51-a05e-67cf79b7d335",3,["D",1748261345389],[154],"pulls","branches","forks","envVars",{"_166":66,"_168":66},"connections",{"_166":66,"_167":66},"count","unfilledCount","emptyCount",{"_47":153,"_32":154,"_30":155,"_137":-5,"_39":40,"_38":156,"_139":62,"_36":245,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_182":246,"_27":247},{"_47":241,"_32":233,"_30":227,"_137":155,"_39":40,"_38":156,"_139":62,"_36":242,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_182":243,"_27":244},{"_47":234,"_32":235,"_30":236,"_137":227,"_39":40,"_38":156,"_139":25,"_36":237,"_13":66,"_33":189,"_35":238,"_24":25,"_142":-5,"_182":239,"_27":240},{"_47":224,"_32":225,"_30":226,"_137":227,"_39":40,"_38":228,"_139":25,"_36":229,"_13":66,"_33":189,"_35":230,"_24":25,"_142":-5,"_182":231,"_27":232},{"_47":220,"_32":219,"_30":213,"_137":155,"_39":40,"_38":214,"_139":62,"_36":221,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_182":222,"_27":223},{"_47":210,"_32":211,"_30":212,"_137":213,"_39":40,"_38":214,"_139":62,"_36":215,"_13":66,"_33":189,"_35":216,"_24":25,"_142":-5,"_182":217,"_27":218},{"_47":203,"_32":204,"_30":60,"_137":155,"_39":40,"_38":205,"_139":25,"_36":206,"_13":66,"_33":189,"_35":207,"_24":25,"_142":-5,"_182":208,"_27":209},{"_47":150,"_32":28,"_30":31,"_137":-5,"_39":40,"_38":14,"_139":62,"_36":200,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_182":201,"_27":202},{"_47":196,"_32":44,"_30":43,"_137":31,"_39":40,"_38":14,"_139":25,"_36":197,"_13":66,"_33":21,"_35":45,"_24":25,"_142":-5,"_182":198,"_27":199},{"_47":144,"_32":145,"_30":146,"_137":-5,"_39":40,"_38":147,"_139":62,"_36":193,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_182":194,"_27":195},{"_47":185,"_32":186,"_30":187,"_137":146,"_39":40,"_38":147,"_139":25,"_36":188,"_13":66,"_33":189,"_35":190,"_24":25,"_142":-5,"_182":191,"_27":192},{"_47":134,"_32":135,"_30":136,"_137":-5,"_39":40,"_38":138,"_139":25,"_36":181,"_13":66,"_33":21,"_35":141,"_24":25,"_142":-5,"_182":183,"_27":184},["D",1748261323713],"children",[],[135],"33214ca4-3a2a-11f0-bddd-9e149126039e","types.ts","33214d8a-3a2a-11f0-bddd-9e149126039e",["D",1748261336929],"script","// Общие типы для игры\n\nexport interface Player {\n id: string;\n name: string;\n level: number;\n experience: number;\n coins: number;\n readiness: number; // боевая готовность 0-100\n created_at: string;\n}\n\nexport interface Vehicle {\n id: string;\n player_id: string;\n type: VehicleType;\n level: number;\n attack_power: number;\n defense: number;\n created_at: string;\n}\n\nexport interface Soldier {\n id: string;\n player_id: string;\n name: string;\n level: number;\n skill: number;\n training_cost: number;\n created_at: string;\n}\n\nexport interface Battle {\n id: string;\n player_id: string;\n enemy_type: string;\n result: 'victory' | 'defeat';\n coins_earned: number;\n experience_earned: number;\n created_at: string;\n}\n\nexport type VehicleType = 'tank' | 'helicopter' | 'fighter_jet' | 'artillery' | 'armored_car';\n\nexport interface VehicleConfig {\n name: string;\n emoji: string;\n base_attack: number;\n base_defense: number;\n cost: number;\n upgrade_cost_multiplier: number;\n}\n\nexport const VEHICLE_CONFIGS: Record = {\n tank: {\n name: 'Танк',\n emoji: '🚗',\n base_attack: 50,\n base_defense: 40,\n cost: 100,\n upgrade_cost_multiplier: 1.5\n },\n helicopter: {\n name: 'Вертолет',\n emoji: '🚁',\n base_attack: 70,\n base_defense: 20,\n cost: 200,\n upgrade_cost_multiplier: 1.6\n },\n fighter_jet: {\n name: 'Истребитель',\n emoji: '✈️',\n base_attack: 90,\n base_defense: 15,\n cost: 400,\n upgrade_cost_multiplier: 1.8\n },\n artillery: {\n name: 'Артиллерия',\n emoji: '🎯',\n base_attack: 80,\n base_defense: 25,\n cost: 300,\n upgrade_cost_multiplier: 1.7\n },\n armored_car: {\n name: 'Бронемашина',\n emoji: '🚙',\n base_attack: 30,\n base_defense: 60,\n cost: 80,\n upgrade_cost_multiplier: 1.4\n }\n};\n\nexport const ENEMY_TYPES = [\n { name: 'Террористы', emoji: '💀', difficulty: 1 },\n { name: 'Боевики', emoji: '🔫', difficulty: 2 },\n { name: 'Наемники', emoji: '⚔️', difficulty: 3 },\n { name: 'Элитные войска', emoji: '🎖️', difficulty: 4 }\n];\n\nexport const EXPERIENCE_PER_LEVEL = 100;\nexport const STARTING_COINS = 500;",[],[145,186],["D",1748261336929],[179],[145],"74e4a60e-3a2a-11f0-8151-9e149126039e",["D",1748261447262],[],[28,44],["D",1748261447262],[177],[28],"5e3e2150-3a2a-11f0-ae64-9e149126039e","index.ts",6,["D",1748261409261],"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 gameRoutes from \"./routes/game.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\", gameRoutes);\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;",[],[154,204],"598d83d0-3a2a-11f0-8666-9e149126039e","game.ts","598d8484-3a2a-11f0-8666-9e149126039e","40a29880-14c0-44ee-b503-bbf245d726ca",5,["D",1748261401392],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getCookie, setCookie } from \"https://esm.sh/hono@3.11.7/cookie\";\nimport * as db from \"../database/queries.ts\";\nimport { VEHICLE_CONFIGS, ENEMY_TYPES, VehicleType } from \"../../shared/types.ts\";\n\nconst game = new Hono();\n\n// Получить или создать игрока\ngame.get(\"/player\", async (c) => {\n let playerId = getCookie(c, \"player_id\");\n \n if (!playerId) {\n // Создаем нового игрока\n const player = await db.createPlayer(\"Командир\");\n playerId = player.id;\n setCookie(c, \"player_id\", playerId, { maxAge: 60 * 60 * 24 * 365 }); // 1 год\n }\n \n const player = await db.getPlayer(playerId);\n if (!player) {\n return c.json({ error: \"Player not found\" }, 404);\n }\n \n return c.json(player);\n});\n\n// Получить данные игрока с техникой и солдатами\ngame.get(\"/dashboard\", async (c) => {\n const playerId = getCookie(c, \"player_id\");\n if (!playerId) {\n return c.json({ error: \"No player found\" }, 401);\n }\n \n const player = await db.getPlayer(playerId);\n const vehicles = await db.getPlayerVehicles(playerId);\n const soldiers = await db.getPlayerSoldiers(playerId);\n const battles = await db.getPlayerBattles(playerId, 5);\n \n return c.json({\n player,\n vehicles,\n soldiers,\n battles,\n vehicleConfigs: VEHICLE_CONFIGS\n });\n});\n\n// Купить технику\ngame.post(\"/buy-vehicle\", async (c) => {\n const playerId = getCookie(c, \"player_id\");\n if (!playerId) {\n return c.json({ error: \"No player found\" }, 401);\n }\n \n const { type } = await c.req.json();\n const config = VEHICLE_CONFIGS[type as VehicleType];\n \n if (!config) {\n return c.json({ error: \"Invalid vehicle type\" }, 400);\n }\n \n const canAfford = await db.spendCoins(playerId, config.cost);\n if (!canAfford) {\n return c.json({ error: \"Недостаточно монет\" }, 400);\n }\n \n const vehicle = await db.createVehicle(playerId, type);\n return c.json(vehicle);\n});\n\n// Улучшить технику\ngame.post(\"/upgrade-vehicle\", async (c) => {\n const playerId = getCookie(c, \"player_id\");\n if (!playerId) {\n return c.json({ error: \"No player found\" }, 401);\n }\n \n const { vehicleId, vehicleType, currentLevel } = await c.req.json();\n const config = VEHICLE_CONFIGS[vehicleType as VehicleType];\n const upgradeCost = Math.floor(config.cost * Math.pow(config.upgrade_cost_multiplier, currentLevel));\n \n const canAfford = await db.spendCoins(playerId, upgradeCost);\n if (!canAfford) {\n return c.json({ error: \"Недостаточно монет для улучшения\" }, 400);\n }\n \n await db.upgradeVehicle(vehicleId);\n return c.json({ success: true });\n});\n\n// Нанять солдата\ngame.post(\"/hire-soldier\", async (c) => {\n const playerId = getCookie(c, \"player_id\");\n if (!playerId) {\n return c.json({ error: \"No player found\" }, 401);\n }\n \n const { name } = await c.req.json();\n const hireCost = 100;\n \n const canAfford = await db.spendCoins(playerId, hireCost);\n if (!canAfford) {\n return c.json({ error: \"Недостаточно монет для найма\" }, 400);\n }\n \n const soldier = await db.createSoldier(playerId, name || \"Солдат\");\n return c.json(soldier);\n});\n\n// Обучить солдата\ngame.post(\"/train-soldier\", async (c) => {\n const playerId = getCookie(c, \"player_id\");\n if (!playerId) {\n return c.json({ error: \"No player found\" }, 401);\n }\n \n const { soldierId, trainingCost } = await c.req.json();\n \n const canAfford = await db.spendCoins(playerId, trainingCost);\n if (!canAfford) {\n return c.json({ error: \"Недостаточно монет для обучения\" }, 400);\n }\n \n await db.trainSoldier(soldierId);\n return c.json({ success: true });\n});\n\n// Атаковать\ngame.post(\"/attack\", async (c) => {\n const playerId = getCookie(c, \"player_id\");\n if (!playerId) {\n return c.json({ error: \"No player found\" }, 401);\n }\n \n const player = await db.getPlayer(playerId);\n if (!player) {\n return c.json({ error: \"Player not found\" }, 404);\n }\n \n if (player.readiness < 20) {\n return c.json({ error: \"Недостаточная боевая готовность! Нужно минимум 20%\" }, 400);\n }\n \n const vehicles = await db.getPlayerVehicles(playerId);\n const soldiers = await db.getPlayerSoldiers(playerId);\n \n if (vehicles.length === 0) {\n return c.json({ error: \"Нужна хотя бы одна единица техники для атаки!\" }, 400);\n }\n \n // Расчет силы атаки\n const vehiclePower = vehicles.reduce((sum, v) => sum + v.attack_power, 0);\n const soldierPower = soldiers.reduce((sum, s) => sum + s.skill, 0);\n const totalPower = vehiclePower + soldierPower + (player.level * 10);\n \n // Выбираем случайного врага\n const enemy = ENEMY_TYPES[Math.floor(Math.random() * ENEMY_TYPES.length)];\n const enemyPower = enemy.difficulty * 50 + Math.random() * 100;\n \n // Определяем результат\n const victory = totalPower > enemyPower;\n const coinsEarned = victory ? enemy.difficulty * 25 + Math.floor(Math.random() * 50) : 0;\n const experienceEarned = victory ? enemy.difficulty * 15 + 10 : 5;\n \n // Снижаем боевую готовность\n const newReadiness = Math.max(0, player.readiness - 15);\n \n // Сохраняем результат\n await db.createBattle(playerId, enemy.name, victory ? 'victory' : 'defeat', coinsEarned, experienceEarned);\n await db.addCoins(playerId, coinsEarned);\n const leveledUp = await db.addExperience(playerId, experienceEarned);\n await db.updatePlayer(playerId, { readiness: newReadiness });\n \n return c.json({\n victory,\n enemy: enemy.name,\n coinsEarned,\n experienceEarned,\n leveledUp,\n newReadiness,\n playerPower: totalPower,\n enemyPower: Math.floor(enemyPower)\n });\n});\n\n// Восстановить боевую готовность\ngame.post(\"/rest\", async (c) => {\n const playerId = getCookie(c, \"player_id\");\n if (!playerId) {\n return c.json({ error: \"No player found\" }, 401);\n }\n \n const player = await db.getPlayer(playerId);\n if (!player) {\n return c.json({ error: \"Player not found\" }, 404);\n }\n \n const restCost = 20;\n const canAfford = await db.spendCoins(playerId, restCost);\n if (!canAfford) {\n return c.json({ error: \"Недостаточно монет для отдыха\" }, 400);\n }\n \n const newReadiness = Math.min(100, player.readiness + 30);\n await db.updatePlayer(playerId, { readiness: newReadiness });\n \n return c.json({ newReadiness });\n});\n\nexport default game;",[],[154,219,211],"routes","598db224-3a2a-11f0-8666-9e149126039e",["D",1748261401392],[174],[154,219],"45b737fc-3a2a-11f0-8d1f-9e149126039e","queries.ts","45b738d8-3a2a-11f0-8d1f-9e149126039e","cb57c728-aeac-4498-aae5-f9c964836126",4,["D",1748261368112],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { Player, Vehicle, Soldier, Battle, VehicleType } from \"../../shared/types.ts\";\nimport { VEHICLE_CONFIGS, EXPERIENCE_PER_LEVEL } 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\n// Техника\nexport async function createVehicle(playerId: string, type: VehicleType): Promise {\n const id = crypto.randomUUID();\n const config = VEHICLE_CONFIGS[type];\n \n await sqlite.execute(\n `INSERT INTO vehicles (id, player_id, type, attack_power, defense) VALUES (?, ?, ?, ?, ?)`,\n [id, playerId, type, config.base_attack, config.base_defense]\n );\n \n const result = await sqlite.execute(\n `SELECT * FROM vehicles WHERE id = ?`,\n [id]\n );\n \n return result.rows[0] as Vehicle;\n}\n\nexport async function getPlayerVehicles(playerId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM vehicles WHERE player_id = ? ORDER BY created_at DESC`,\n [playerId]\n );\n \n return result.rows as Vehicle[];\n}\n\nexport async function upgradeVehicle(vehicleId: string): Promise {\n await sqlite.execute(\n `UPDATE vehicles SET \n level = level + 1,\n attack_power = attack_power * 1.2,\n defense = defense * 1.2\n WHERE id = ?`,\n [vehicleId]\n );\n}\n\n// Солдаты\nexport async function createSoldier(playerId: string, name: string): Promise {\n const id = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO soldiers (id, player_id, name) VALUES (?, ?, ?)`,\n [id, playerId, name]\n );\n \n const result = await sqlite.execute(\n `SELECT * FROM soldiers WHERE id = ?`,\n [id]\n );\n \n return result.rows[0] as Soldier;\n}\n\nexport async function getPlayerSoldiers(playerId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM soldiers WHERE player_id = ? ORDER BY level DESC`,\n [playerId]\n );\n \n return result.rows as Soldier[];\n}\n\nexport async function trainSoldier(soldierId: string): Promise {\n await sqlite.execute(\n `UPDATE soldiers SET \n level = level + 1,\n skill = skill + 5,\n training_cost = training_cost * 1.3\n WHERE id = ?`,\n [soldierId]\n );\n}\n\n// Битвы\nexport async function createBattle(\n playerId: string,\n enemyType: string,\n result: 'victory' | 'defeat',\n coinsEarned: number,\n experienceEarned: number\n): Promise {\n const id = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO battles (id, player_id, enemy_type, result, coins_earned, experience_earned) \n VALUES (?, ?, ?, ?, ?, ?)`,\n [id, playerId, enemyType, result, coinsEarned, experienceEarned]\n );\n \n const result_data = await sqlite.execute(\n `SELECT * FROM battles WHERE id = ?`,\n [id]\n );\n \n return result_data.rows[0] as Battle;\n}\n\nexport async function getPlayerBattles(playerId: string, limit: number = 10): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM battles WHERE player_id = ? ORDER BY created_at DESC LIMIT ?`,\n [playerId, limit]\n );\n \n return result.rows as Battle[];\n}\n\n// Утилиты\nexport async function addExperience(playerId: string, experience: number): Promise {\n const player = await getPlayer(playerId);\n if (!player) return false;\n \n const newExperience = player.experience + experience;\n const newLevel = Math.floor(newExperience / EXPERIENCE_PER_LEVEL) + 1;\n \n await updatePlayer(playerId, {\n experience: newExperience,\n level: newLevel\n });\n \n return newLevel > player.level; // Возвращает true если уровень повысился\n}\n\nexport async function spendCoins(playerId: string, amount: number): Promise {\n const player = await getPlayer(playerId);\n if (!player || player.coins < amount) return false;\n \n await updatePlayer(playerId, {\n coins: player.coins - amount\n });\n \n return true;\n}\n\nexport async function addCoins(playerId: string, amount: number): Promise {\n const player = await getPlayer(playerId);\n if (!player) return;\n \n await updatePlayer(playerId, {\n coins: player.coins + amount\n });\n}",[],[154,233,225],"database","382c2b60-3a2a-11f0-9d7a-9e149126039e","migrations.ts","382c2c14-3a2a-11f0-9d7a-9e149126039e",["D",1748261345389],"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 level INTEGER DEFAULT 1,\n experience INTEGER DEFAULT 0,\n coins INTEGER DEFAULT 500,\n readiness INTEGER DEFAULT 100,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Таблица техники\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS vehicles (\n id TEXT PRIMARY KEY,\n player_id TEXT NOT NULL,\n type TEXT NOT NULL,\n level INTEGER DEFAULT 1,\n attack_power INTEGER NOT NULL,\n defense INTEGER NOT NULL,\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 soldiers (\n id TEXT PRIMARY KEY,\n player_id TEXT NOT NULL,\n name TEXT NOT NULL,\n level INTEGER DEFAULT 1,\n skill INTEGER DEFAULT 10,\n training_cost INTEGER DEFAULT 50,\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 battles (\n id TEXT PRIMARY KEY,\n player_id TEXT NOT NULL,\n enemy_type TEXT NOT NULL,\n result TEXT NOT NULL,\n coins_earned INTEGER DEFAULT 0,\n experience_earned INTEGER DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (player_id) REFERENCES players (id)\n )\n `);\n\n console.log(\"Database migrations completed\");\n}",[],[154,233,235],"382c3614-3a2a-11f0-9d7a-9e149126039e",["D",1748261345389],[171,172],[154,233],["D",1748261345389],[170,173,175],[154],["D",1748261230431],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},{"_13":89,"_32":90,"_47":40,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"ctx",{"_82":-5,"_127":285,"_286":287,"_288":289,"_290":25,"_291":25,"_292":25,"_293":62,"_294":-5,"_295":-7,"_296":-7,"_297":66,"_298":25,"_299":25,"_300":-5,"_301":25,"_302":25,"_303":25,"_304":-5},"ENV",{"_256":257,"_258":259,"_260":90,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v7