[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_222":223,"_224":225},"routes/_app.x.$handle.$name",{"_111":110,"_38":56,"_120":101,"_33":121,"_13":14,"_122":-5,"_11":123,"_124":125,"_126":127,"_128":129,"_130":131,"_27":-5,"_132":-5,"_133":-5,"_134":31,"_135":136,"_137":31,"_138":-5,"_139":-5,"_140":141},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_54":55,"_38":56,"_42":57,"_58":-5,"_59":31,"_60":61,"_62":61,"_63":64,"_65":-5,"_19":66,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":74,"_75":76,"_77":78,"_79":80,"_81":82,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":31},"version",5,"changes",[25,26],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","1e8274fd-035a-47e7-a282-89539b6ef870","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_27":47,"_29":-7,"_30":31,"_32":31,"_33":48,"_35":48},{"_27":28,"_29":-7,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":-5,"_42":43,"_44":14,"_45":46,"_30":31},"previous","deleted",false,"deletedHere","path","handlers","latestPath","fileId","ec79cdad-cca3-4c05-a4b6-46a4e78c22e2","name","fileType","directory","content","createdAt",["D",1779274563704],"branchVersion","branchId","36ebb920-543a-11f1-b122-ee650bb23af1",{"_36":49,"_38":50,"_39":51,"_41":52,"_42":53,"_44":14,"_45":46,"_30":31},"handlers/start-menu.ts","7eca6b74-543a-11f1-8299-ee650bb23af1","start-menu.ts","script","import { Bot, InlineKeyboard, Keyboard } from \"npm:grammy@1.30.0\";\nimport * as db from \"../db.ts\";\nimport { fmt, userLink, formatTimeLeft } from \"../utils.ts\";\nimport { DAILY_BONUS, ADMIN_IDS } from \"../config.ts\";\n\n// Main menu keyboard (for private chats)\nexport function mainMenuKeyboard() {\n return new Keyboard()\n .text(\"🎮 Игры\").text(\"💰 Баланс\").row()\n .text(\"🎁 Бонус\").text(\"🏦 Банк\").row()\n .text(\"🏆 Турнир\").text(\"⚔️ Кланы\").row()\n .text(\"👤 Профиль\")\n .resized();\n}\n\nexport function gamesKeyboard() {\n return new Keyboard()\n .text(\"🎰 Рулетка\").text(\"💣 Мины\").row()\n .text(\"🎲 Кубики\").text(\"🎡 Колесо\").row()\n .text(\"🦆 Утки\").text(\"🚀 Ракета\").row()\n .text(\"🃏 Блэкджек\").row()\n .text(\"⬅️ Назад\")\n .resized();\n}\n\nexport function registerStartHandlers(bot: Bot) {\n // /start\n bot.command(\"start\", async (ctx) => {\n const user = await db.ensureUser(ctx.from!.id, ctx.from!.username || \"\", ctx.from!.first_name || \"\");\n if (ctx.chat.type === \"private\") {\n await ctx.reply(\n `👋 Добро пожаловать, ${userLink(ctx.from!.id, ctx.from!.first_name || \"\")}!\\n\\n` +\n `Это игровой бот с виртуальной валютой GRAM.\\n` +\n `💰 Ваш баланс: ${fmt(Number(user.balance))} GRAM\\n\\n` +\n `Выберите действие:`,\n { parse_mode: \"HTML\", reply_markup: mainMenuKeyboard() },\n );\n } else {\n await ctx.reply(\n `👋 ${userLink(ctx.from!.id, ctx.from!.first_name || \"\")} зарегистрирован(а)!\\n` +\n `💰 Баланс: ${fmt(Number(user.balance))} GRAM`,\n { parse_mode: \"HTML\" },\n );\n }\n });\n\n // Games menu\n bot.hears(\"🎮 Игры\", async (ctx) => {\n await ctx.reply(\"🎮 Выберите игру:\", { reply_markup: gamesKeyboard() });\n });\n\n // Back to main\n bot.hears(\"⬅️ Назад\", async (ctx) => {\n if (ctx.chat.type === \"private\") {\n await ctx.reply(\"📱 Главное меню:\", { reply_markup: mainMenuKeyboard() });\n }\n });\n\n // Balance\n const balanceRegex = /^(б|Б|баланс|💰 Баланс)$/i;\n bot.hears(balanceRegex, async (ctx) => {\n const user = await db.ensureUser(ctx.from!.id, ctx.from!.username || \"\", ctx.from!.first_name || \"\");\n if (Number(user.banned)) {\n return ctx.reply(\"🚫 Вы заблокированы.\");\n }\n\n const deposit = await db.getActiveDeposit(ctx.from!.id);\n const bankAmount = deposit ? Number(deposit.amount) : 0;\n const clanId = Number(user.clan_id);\n let clanName = \"нет\";\n if (clanId > 0) {\n const clan = await db.getClan(clanId);\n if (clan) clanName = String(clan.name);\n }\n const dailyProfit = await db.getUserDailyProfit(ctx.from!.id);\n\n await ctx.reply(\n `Б\\n` +\n `${userLink(ctx.from!.id, String(user.first_name) || String(user.username))}\\n\\n` +\n `💰 Баланс: ${fmt(Number(user.balance))} GRAM\\n` +\n `🏦 Банк: ${fmt(bankAmount)} GRAM\\n` +\n `⚔️ Клан: ${clanName}\\n` +\n `🏆 Турнир дня: ${dailyProfit >= 0 ? \"+\" : \"\"}${fmt(dailyProfit)} GRAM`,\n { parse_mode: \"HTML\" },\n );\n });\n\n // Bonus\n const bonusRegex = /^(бонус|🎁 Бонус)$/i;\n bot.hears(bonusRegex, async (ctx) => {\n const user = await db.ensureUser(ctx.from!.id, ctx.from!.username || \"\", ctx.from!.first_name || \"\");\n if (Number(user.banned)) return ctx.reply(\"🚫 Вы заблокированы.\");\n\n const now = Date.now();\n const lastBonus = user.last_bonus ? new Date(String(user.last_bonus)).getTime() : 0;\n const diff = now - lastBonus;\n const cooldown = 24 * 3600000;\n\n if (diff < cooldown) {\n const left = cooldown - diff;\n return ctx.reply(`⏳ Бонус уже получен. Следующий через: ${formatTimeLeft(left)}`);\n }\n\n // Calculate clan bonus\n let bonus = DAILY_BONUS;\n let clanBonusText = \"\";\n const clanId = Number(user.clan_id);\n if (clanId > 0) {\n const clan = await db.getClan(clanId);\n if (clan) {\n const bonusLevel = Number(clan.upgrade_bonus_boost) || 0;\n const bonusPercent = bonusLevel * 5; // 5% per level\n if (bonusPercent > 0) {\n const extra = Math.floor(bonus * bonusPercent / 100);\n bonus += extra;\n clanBonusText = `\\n⚔️ Клановый бонус: +${bonusPercent}% (+${fmt(extra)} GRAM)`;\n }\n }\n }\n\n await db.updateBalance(ctx.from!.id, bonus);\n await db.setLastBonus(ctx.from!.id, new Date().toISOString());\n\n await ctx.reply(\n `🎁 Бонус получен!\\n` +\n `+${fmt(bonus)} GRAM${clanBonusText}\\n` +\n `💰 Баланс: ${fmt(Number(user.balance) + bonus)} GRAM`,\n { parse_mode: \"HTML\" },\n );\n });\n\n // Profile\n bot.hears(\"👤 Профиль\", async (ctx) => {\n const user = await db.ensureUser(ctx.from!.id, ctx.from!.username || \"\", ctx.from!.first_name || \"\");\n const clanId = Number(user.clan_id);\n let clanName = \"нет\";\n if (clanId > 0) {\n const clan = await db.getClan(clanId);\n if (clan) clanName = String(clan.name);\n }\n\n await ctx.reply(\n `👤 Профиль\\n\\n` +\n `${userLink(ctx.from!.id, String(user.first_name))}\\n` +\n `🆔 ID: ${ctx.from!.id}\\n` +\n `💰 Баланс: ${fmt(Number(user.balance))} GRAM\\n` +\n `✅ Побед: ${fmt(Number(user.wins))}\\n` +\n `❌ Поражений: ${fmt(Number(user.losses))}\\n` +\n `📈 Выиграно: ${fmt(Number(user.total_won))} GRAM\\n` +\n `📉 Проиграно: ${fmt(Number(user.total_lost))} GRAM\\n` +\n `⚔️ Клан: ${clanName}\\n` +\n `📅 Регистрация: ${String(user.created_at).slice(0, 10)}`,\n { parse_mode: \"HTML\" },\n );\n });\n}\n",["D",1779274563704],"id","36eadbe0-543a-11f1-b122-ee650bb23af1","telegram-gram-bot",["D",1779274443138],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Telegram game bot with GRAM currency, games, clans, tournaments","imageUrl","fdfa5f82-8c65-4494-b47e-7a0953646bde","pinnedFileId","45d95b62-543b-11f1-8de8-ee650bb23af1","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e44f5-239a-7630-a6bd-8fcdb801b128","tursoName","36eadbe0543a11f1b122ee650bb23af1","tursoHostname","36eadbe0543a11f1b122ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789489305251],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_111":110,"_119":115},"org",{"_111":110,"_112":113,"_114":115,"_19":66,"_116":117,"_118":31},"branch",{"_13":100,"_38":101,"_54":46,"_102":55,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":56,"_109":110},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","eblanfoytee","handle","displayName","Я Яьвлалв","avatar","https://lh3.googleusercontent.com/a/ACg8ocLxS00XPv5pIt4IFNSo04ICoRQ55BuOI9bMkwK9aj2Zx4yO_w=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_54":55,"_38":56,"_42":217,"_58":-5,"_59":31,"_60":61,"_62":61,"_63":64,"_65":-5,"_19":66,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":74,"_75":76,"_77":78,"_79":80,"_81":218,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":219,"_95":220,"_97":221,"_99":31},"tree",[191,193,194,195,196],"files",[191,192,193,194,195,196],"counts",{"_181":74,"_182":174,"_183":174,"_184":185,"_186":187},"contents",[142,143,144,145,146],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_54":178,"_38":34,"_36":37,"_150":-5,"_45":46,"_44":14,"_152":70,"_42":179,"_13":74,"_39":40,"_41":-5,"_30":31,"_155":-5,"_33":180},{"_54":171,"_38":172,"_36":173,"_150":-5,"_45":46,"_44":174,"_152":70,"_42":175,"_13":74,"_39":51,"_41":176,"_30":31,"_155":-5,"_33":177},{"_54":164,"_38":165,"_36":166,"_150":-5,"_45":46,"_44":167,"_152":70,"_42":168,"_13":74,"_39":51,"_41":169,"_30":31,"_155":-5,"_33":170},{"_54":157,"_38":158,"_36":159,"_150":-5,"_45":46,"_44":160,"_152":70,"_42":161,"_13":74,"_39":51,"_41":162,"_30":31,"_155":-5,"_33":163},{"_54":147,"_38":148,"_36":149,"_150":-5,"_45":46,"_44":151,"_152":70,"_42":153,"_13":74,"_39":51,"_41":154,"_30":31,"_155":-5,"_33":156},"62b114ec-543a-11f1-aaa0-ee650bb23af1","utils.ts","62b115a0-543a-11f1-aaa0-ee650bb23af1","parentId",3,"latest",["D",1779274516568],"// Форматирование чисел: 1000 -> \"1 000\", 1234567 -> \"1 234 567\"\nexport function fmt(n: number | bigint): string {\n return String(n).replace(/\\B(?=(\\d{3})+(?!\\d))/g, \" \");\n}\n\n// Кликабельная ссылка на пользователя\nexport function userLink(id: number, name: string): string {\n const safeName = name.replace(/[<>&]/g, \"\");\n return `${safeName || \"Игрок\"}`;\n}\n\n// Парсинг ставки из строки\nexport function parseBet(text: string): number | null {\n // support 1k, 1м, 1m etc\n const cleaned = text.trim().toLowerCase()\n .replace(/к|k/g, \"000\")\n .replace(/м|m/g, \"000000\")\n .replace(/\\s/g, \"\");\n const n = parseInt(cleaned, 10);\n if (isNaN(n) || n <= 0) return null;\n return n;\n}\n\n// Случайное число от min до max включительно\nexport function randInt(min: number, max: number): number {\n return Math.floor(Math.random() * (max - min + 1)) + min;\n}\n\n// Взвешенный случайный выбор\nexport function weightedRandom(items: T[]): T {\n const total = items.reduce((s, i) => s + i.weight, 0);\n let r = Math.random() * total;\n for (const item of items) {\n r -= item.weight;\n if (r <= 0) return item;\n }\n return items[items.length - 1];\n}\n\n// Задержка\nexport function sleep(ms: number): Promise {\n return new Promise((r) => setTimeout(r, ms));\n}\n\n// Получение текущей даты ISO\nexport function nowISO(): string {\n return new Date().toISOString();\n}\n\n// Форматирование времени (оставшееся до бонуса)\nexport function formatTimeLeft(ms: number): string {\n if (ms <= 0) return \"0м\";\n const h = Math.floor(ms / 3600000);\n const m = Math.floor((ms % 3600000) / 60000);\n const s = Math.floor((ms % 60000) / 1000);\n const parts: string[] = [];\n if (h > 0) parts.push(`${h}ч`);\n if (m > 0) parts.push(`${m}м`);\n if (parts.length === 0) parts.push(`${s}с`);\n return parts.join(\" \");\n}\n","label",[148],"6c9ae7c6-543a-11f1-8f6f-ee650bb23af1","game-logic.ts","6c9ae8b6-543a-11f1-8f6f-ee650bb23af1",4,["D",1779274533201],"import { MIN_BET, MAX_BET } from \"./config.ts\";\nimport * as db from \"./db.ts\";\nimport { fmt } from \"./utils.ts\";\n\n// Validate bet amount against user balance and limits\nexport function validateBet(balance: number, amount: number): string | null {\n if (amount < MIN_BET) return `❌ Минимальная ставка: ${fmt(MIN_BET)} GRAM`;\n if (amount > MAX_BET) return `❌ Максимальная ставка: ${fmt(MAX_BET)} GRAM`;\n if (amount > balance) return `❌ Недостаточно средств! Баланс: ${fmt(balance)} GRAM`;\n return null;\n}\n\n// After game result: update balance, stats, tournament, clan points\nexport async function processGameResult(\n userId: number,\n bet: number,\n payout: number, // total payout (0 = full loss, bet = draw, >bet = win)\n) {\n const netProfit = payout - bet;\n\n if (payout > bet) {\n // Win\n const winAmount = payout - bet;\n await db.updateBalance(userId, winAmount); // bet was already deducted\n await db.addWin(userId, payout);\n } else if (payout === bet) {\n // Draw - return bet (already deducted)\n // No win/loss stat change\n } else if (payout === 0) {\n // Full loss - bet already deducted\n await db.addLoss(userId, bet);\n } else if (payout < bet) {\n // Partial loss\n await db.addLoss(userId, bet - payout);\n }\n\n // If draw, return money\n if (payout === bet && payout > 0) {\n // bet was deducted, return it\n // balance change is 0, already handled\n } else if (payout > 0 && payout < bet) {\n // partial return already handled above through balance not changing beyond initial deduction\n // Actually need to add back payout since bet was deducted\n await db.updateBalance(userId, payout);\n }\n\n // Update tournament\n await db.updateTournament(userId, netProfit);\n\n // Clan points (10% of positive net profit)\n if (netProfit > 0) {\n const user = await db.getUser(userId);\n if (user && Number(user.clan_id) > 0) {\n const clanPoints = Math.floor(netProfit * 0.1);\n if (clanPoints > 0) {\n await db.addClanPoints(Number(user.clan_id), clanPoints);\n }\n }\n }\n}\n\n// Simplified: deduct bet, then call processGameResult with payout\nexport async function deductBet(userId: number, amount: number) {\n await db.updateBalance(userId, -amount);\n}\n\n// Credit payout (used after bet was already deducted)\nexport async function creditPayout(userId: number, bet: number, payout: number) {\n if (payout > 0) {\n await db.updateBalance(userId, payout);\n }\n\n const netProfit = payout - bet;\n\n if (payout > bet) {\n await db.addWin(userId, payout);\n } else if (payout < bet) {\n await db.addLoss(userId, bet - payout);\n }\n\n await db.updateTournament(userId, netProfit);\n\n if (netProfit > 0) {\n const user = await db.getUser(userId);\n if (user && Number(user.clan_id) > 0) {\n const clanPoints = Math.floor(netProfit * 0.1);\n if (clanPoints > 0) {\n await db.addClanPoints(Number(user.clan_id), clanPoints);\n }\n }\n }\n}\n",[158],"5c10e2a2-543a-11f1-be6f-ee650bb23af1","db.ts","5c10e34c-543a-11f1-be6f-ee650bb23af1",2,["D",1779274505454],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { START_BALANCE } from \"./config.ts\";\n\nexport async function initDB() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY,\n username TEXT DEFAULT '',\n first_name TEXT DEFAULT '',\n balance INTEGER DEFAULT 0,\n wins INTEGER DEFAULT 0,\n losses INTEGER DEFAULT 0,\n total_won INTEGER DEFAULT 0,\n total_lost INTEGER DEFAULT 0,\n last_bonus TEXT DEFAULT '',\n clan_id INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now')),\n banned INTEGER DEFAULT 0\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS bank_deposits (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n amount INTEGER NOT NULL,\n percent INTEGER NOT NULL,\n hours INTEGER NOT NULL,\n created_at TEXT DEFAULT (datetime('now')),\n expires_at TEXT NOT NULL,\n collected INTEGER DEFAULT 0\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS clans (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT UNIQUE NOT NULL,\n leader_id INTEGER NOT NULL,\n description TEXT DEFAULT '',\n treasury INTEGER DEFAULT 0,\n season_points INTEGER DEFAULT 0,\n level INTEGER DEFAULT 1,\n is_open INTEGER DEFAULT 1,\n created_at TEXT DEFAULT (datetime('now')),\n upgrade_max_members INTEGER DEFAULT 0,\n upgrade_bonus_boost INTEGER DEFAULT 0,\n upgrade_tournament_boost INTEGER DEFAULT 0\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS clan_members (\n user_id INTEGER NOT NULL,\n clan_id INTEGER NOT NULL,\n role TEXT DEFAULT 'member',\n joined_at TEXT DEFAULT (datetime('now')),\n PRIMARY KEY (user_id)\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS clan_requests (\n user_id INTEGER NOT NULL,\n clan_id INTEGER NOT NULL,\n created_at TEXT DEFAULT (datetime('now')),\n PRIMARY KEY (user_id, clan_id)\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS tournament_daily (\n user_id INTEGER NOT NULL,\n date TEXT NOT NULL,\n net_profit INTEGER DEFAULT 0,\n PRIMARY KEY (user_id, date)\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS tournament_weekly (\n user_id INTEGER NOT NULL,\n week TEXT NOT NULL,\n net_profit INTEGER DEFAULT 0,\n PRIMARY KEY (user_id, week)\n )`,\n args: [],\n },\n ]);\n}\n\n// ========== USER HELPERS ==========\n\nexport async function getUser(id: number) {\n const res = await sqlite.execute({ sql: \"SELECT * FROM users WHERE id = ?\", args: [id] });\n return res.rows[0] as Record | undefined;\n}\n\nexport async function ensureUser(id: number, username: string, firstName: string) {\n const existing = await getUser(id);\n if (!existing) {\n await sqlite.execute({\n sql: \"INSERT INTO users (id, username, first_name, balance) VALUES (?, ?, ?, ?)\",\n args: [id, username || \"\", firstName || \"\", START_BALANCE],\n });\n return (await getUser(id))!;\n }\n // Update username/first_name\n await sqlite.execute({\n sql: \"UPDATE users SET username = ?, first_name = ? WHERE id = ?\",\n args: [username || existing.username, firstName || existing.first_name, id],\n });\n return (await getUser(id))!;\n}\n\nexport async function getUserById(id: number) {\n return getUser(id);\n}\n\nexport async function getUserByUsername(uname: string) {\n const clean = uname.replace(/^@/, \"\").toLowerCase();\n const res = await sqlite.execute({ sql: \"SELECT * FROM users WHERE LOWER(username) = ?\", args: [clean] });\n return res.rows[0] as Record | undefined;\n}\n\nexport async function updateBalance(id: number, delta: number) {\n await sqlite.execute({ sql: \"UPDATE users SET balance = balance + ? WHERE id = ?\", args: [delta, id] });\n}\n\nexport async function setBalance(id: number, amount: number) {\n await sqlite.execute({ sql: \"UPDATE users SET balance = ? WHERE id = ?\", args: [amount, id] });\n}\n\nexport async function addWin(id: number, amount: number) {\n await sqlite.execute({\n sql: \"UPDATE users SET wins = wins + 1, total_won = total_won + ? WHERE id = ?\",\n args: [amount, id],\n });\n}\n\nexport async function addLoss(id: number, amount: number) {\n await sqlite.execute({\n sql: \"UPDATE users SET losses = losses + 1, total_lost = total_lost + ? WHERE id = ?\",\n args: [amount, id],\n });\n}\n\nexport async function setLastBonus(id: number, time: string) {\n await sqlite.execute({ sql: \"UPDATE users SET last_bonus = ? WHERE id = ?\", args: [time, id] });\n}\n\nexport async function banUser(id: number) {\n await sqlite.execute({ sql: \"UPDATE users SET banned = 1 WHERE id = ?\", args: [id] });\n}\n\nexport async function unbanUser(id: number) {\n await sqlite.execute({ sql: \"UPDATE users SET banned = 0 WHERE id = ?\", args: [id] });\n}\n\nexport async function getAllUsers() {\n const res = await sqlite.execute(\"SELECT * FROM users\");\n return res.rows as Record[];\n}\n\n// ========== BANK ==========\n\nexport async function getActiveDeposit(userId: number) {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM bank_deposits WHERE user_id = ? AND collected = 0 ORDER BY id DESC LIMIT 1\",\n args: [userId],\n });\n return res.rows[0] as Record | undefined;\n}\n\nexport async function createDeposit(userId: number, amount: number, percent: number, hours: number) {\n const now = new Date();\n const expires = new Date(now.getTime() + hours * 3600000);\n await sqlite.execute({\n sql: \"INSERT INTO bank_deposits (user_id, amount, percent, hours, created_at, expires_at) VALUES (?, ?, ?, ?, ?, ?)\",\n args: [userId, amount, percent, hours, now.toISOString(), expires.toISOString()],\n });\n}\n\nexport async function collectDeposit(depositId: number) {\n await sqlite.execute({ sql: \"UPDATE bank_deposits SET collected = 1 WHERE id = ?\", args: [depositId] });\n}\n\n// ========== CLANS ==========\n\nexport async function createClan(name: string, leaderId: number) {\n await sqlite.execute({\n sql: \"INSERT INTO clans (name, leader_id) VALUES (?, ?)\",\n args: [name, leaderId],\n });\n const res = await sqlite.execute({ sql: \"SELECT * FROM clans WHERE name = ?\", args: [name] });\n const clan = res.rows[0] as Record;\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO clan_members (user_id, clan_id, role) VALUES (?, ?, 'leader')\",\n args: [leaderId, clan.id],\n });\n await sqlite.execute({ sql: \"UPDATE users SET clan_id = ? WHERE id = ?\", args: [clan.id, leaderId] });\n return clan;\n}\n\nexport async function getClan(id: number) {\n const res = await sqlite.execute({ sql: \"SELECT * FROM clans WHERE id = ?\", args: [id] });\n return res.rows[0] as Record | undefined;\n}\n\nexport async function getClanByName(name: string) {\n const res = await sqlite.execute({ sql: \"SELECT * FROM clans WHERE LOWER(name) = ?\", args: [name.toLowerCase()] });\n return res.rows[0] as Record | undefined;\n}\n\nexport async function getClanMembers(clanId: number) {\n const res = await sqlite.execute({\n sql: `SELECT u.id, u.username, u.first_name, cm.role FROM clan_members cm\n JOIN users u ON u.id = cm.user_id WHERE cm.clan_id = ?`,\n args: [clanId],\n });\n return res.rows as Record[];\n}\n\nexport async function getClanMember(userId: number) {\n const res = await sqlite.execute({ sql: \"SELECT * FROM clan_members WHERE user_id = ?\", args: [userId] });\n return res.rows[0] as Record | undefined;\n}\n\nexport async function joinClan(userId: number, clanId: number, role = \"member\") {\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO clan_members (user_id, clan_id, role) VALUES (?, ?, ?)\",\n args: [userId, clanId, role],\n });\n await sqlite.execute({ sql: \"UPDATE users SET clan_id = ? WHERE id = ?\", args: [clanId, userId] });\n}\n\nexport async function leaveClan(userId: number) {\n await sqlite.execute({ sql: \"DELETE FROM clan_members WHERE user_id = ?\", args: [userId] });\n await sqlite.execute({ sql: \"UPDATE users SET clan_id = 0 WHERE id = ?\", args: [userId] });\n}\n\nexport async function addToTreasury(clanId: number, amount: number) {\n await sqlite.execute({ sql: \"UPDATE clans SET treasury = treasury + ? WHERE id = ?\", args: [amount, clanId] });\n}\n\nexport async function addClanPoints(clanId: number, points: number) {\n await sqlite.execute({ sql: \"UPDATE clans SET season_points = season_points + ? WHERE id = ?\", args: [points, clanId] });\n}\n\nexport async function getTopClans(limit = 10) {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM clans ORDER BY season_points DESC LIMIT ?\",\n args: [limit],\n });\n return res.rows as Record[];\n}\n\nexport async function searchClans(query: string) {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM clans WHERE LOWER(name) LIKE ? LIMIT 10\",\n args: [`%${query.toLowerCase()}%`],\n });\n return res.rows as Record[];\n}\n\nexport async function updateClanField(clanId: number, field: string, value: unknown) {\n const allowed = [\"description\", \"is_open\", \"leader_id\", \"upgrade_max_members\", \"upgrade_bonus_boost\", \"upgrade_tournament_boost\", \"treasury\", \"level\"];\n if (!allowed.includes(field)) return;\n await sqlite.execute({ sql: `UPDATE clans SET ${field} = ? WHERE id = ?`, args: [value, clanId] });\n}\n\nexport async function updateClanMemberRole(userId: number, role: string) {\n await sqlite.execute({ sql: \"UPDATE clan_members SET role = ? WHERE user_id = ?\", args: [role, userId] });\n}\n\nexport async function removeClanMember(userId: number) {\n await leaveClan(userId);\n}\n\nexport async function addClanRequest(userId: number, clanId: number) {\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO clan_requests (user_id, clan_id) VALUES (?, ?)\",\n args: [userId, clanId],\n });\n}\n\nexport async function getClanRequests(clanId: number) {\n const res = await sqlite.execute({\n sql: `SELECT cr.user_id, u.username, u.first_name FROM clan_requests cr\n JOIN users u ON u.id = cr.user_id WHERE cr.clan_id = ?`,\n args: [clanId],\n });\n return res.rows as Record[];\n}\n\nexport async function removeClanRequest(userId: number, clanId: number) {\n await sqlite.execute({ sql: \"DELETE FROM clan_requests WHERE user_id = ? AND clan_id = ?\", args: [userId, clanId] });\n}\n\n// ========== TOURNAMENTS ==========\n\nexport async function updateTournament(userId: number, netProfit: number) {\n const today = new Date().toISOString().slice(0, 10);\n const weekNum = getWeekKey();\n await sqlite.batch([\n {\n sql: `INSERT INTO tournament_daily (user_id, date, net_profit) VALUES (?, ?, ?)\n ON CONFLICT(user_id, date) DO UPDATE SET net_profit = net_profit + ?`,\n args: [userId, today, netProfit, netProfit],\n },\n {\n sql: `INSERT INTO tournament_weekly (user_id, week, net_profit) VALUES (?, ?, ?)\n ON CONFLICT(user_id, week) DO UPDATE SET net_profit = net_profit + ?`,\n args: [userId, weekNum, netProfit, netProfit],\n },\n ]);\n}\n\nexport async function getDailyTournament(date?: string) {\n const d = date || new Date().toISOString().slice(0, 10);\n const res = await sqlite.execute({\n sql: `SELECT td.user_id, td.net_profit, u.username, u.first_name FROM tournament_daily td\n JOIN users u ON u.id = td.user_id WHERE td.date = ? ORDER BY td.net_profit DESC LIMIT 20`,\n args: [d],\n });\n return res.rows as Record[];\n}\n\nexport async function getWeeklyTournament(week?: string) {\n const w = week || getWeekKey();\n const res = await sqlite.execute({\n sql: `SELECT tw.user_id, tw.net_profit, u.username, u.first_name FROM tournament_weekly tw\n JOIN users u ON u.id = tw.user_id WHERE tw.week = ? ORDER BY tw.net_profit DESC LIMIT 20`,\n args: [w],\n });\n return res.rows as Record[];\n}\n\nexport async function getUserDailyProfit(userId: number) {\n const today = new Date().toISOString().slice(0, 10);\n const res = await sqlite.execute({\n sql: \"SELECT net_profit FROM tournament_daily WHERE user_id = ? AND date = ?\",\n args: [userId, today],\n });\n return (res.rows[0] as Record)?.net_profit as number || 0;\n}\n\nfunction getWeekKey() {\n const now = new Date();\n const start = new Date(now.getFullYear(), 0, 1);\n const diff = now.getTime() - start.getTime();\n const week = Math.ceil((diff / 86400000 + start.getDay() + 1) / 7);\n return `${now.getFullYear()}-W${String(week).padStart(2, \"0\")}`;\n}\n",[165],"43cb1a5a-543a-11f1-9480-ee650bb23af1","config.ts","43cb1b0e-543a-11f1-9480-ee650bb23af1",1,["D",1779274464729],"// Все настройки бота — без .env, всё прямо здесь\nexport const BOT_TOKEN = \"8473397595:AAEFJ4bq_DUohF3_v3quMDMz5n0RYjPbz_4\";\nexport const ADMIN_IDS = [5435916084];\nexport const START_BALANCE = 0;\nexport const MIN_BET = 1;\nexport const MAX_BET = 1000000000000;\nexport const DAILY_BONUS = 500;\nexport const CLAN_CREATE_PRICE = 50000;\n\n// Банковские депозиты\nexport const BANK_DEPOSITS = [\n { hours: 12, percent: 5, label: \"12 часов (+5%)\" },\n { hours: 24, percent: 10, label: \"24 часа (+10%)\" },\n { hours: 48, percent: 18, label: \"48 часов (+18%)\" },\n];\n\n// Призы турниров\nexport const DAILY_PRIZES = [50000, 25000, 10000];\nexport const WEEKLY_PRIZES = [500000, 250000, 100000];\n\n// Рулетка\nexport const RED_NUMBERS = [1, 3, 5, 7, 9, 12, 14, 16, 18, 19, 21, 23, 25, 27, 30, 32, 34, 36];\nexport const BLACK_NUMBERS = [2, 4, 6, 8, 10, 11, 13, 15, 17, 20, 22, 24, 26, 28, 29, 31, 33, 35];\n\n// Мины — множители за каждую открытую клетку (6 мин из 25)\nexport const MINES_MULTIPLIERS = [\n 1.10, 1.25, 1.45, 1.70, 2.00, 2.40, 2.90, 3.50, 4.30, 5.30,\n 6.60, 8.30, 10.50, 13.50, 17.50, 23.00, 30.00, 40.00, 55.00,\n];\n\n// Колесо — множители и веса\nexport const WHEEL_SEGMENTS = [\n { mult: 0, weight: 30 },\n { mult: 0.2, weight: 15 },\n { mult: 0.5, weight: 15 },\n { mult: 1, weight: 15 },\n { mult: 1.5, weight: 10 },\n { mult: 2, weight: 7 },\n { mult: 3, weight: 5 },\n { mult: 5, weight: 2 },\n { mult: 10, weight: 1 },\n];\n\n// Ракета — коэффициенты\nexport const ROCKET_MULTIPLIERS = [1.10, 1.25, 1.45, 1.70, 2.00, 2.40, 3.00, 4.00, 5.50, 8.00, 12.00];\n\n// Клановые улучшения\nexport const CLAN_UPGRADES = {\n max_members: { baseCost: 10000, perLevel: 5000, baseValue: 10, perLevel_value: 5, maxLevel: 10, label: \"👥 Лимит участников\" },\n bonus_boost: { baseCost: 15000, perLevel: 10000, baseValue: 0, perLevel_value: 5, maxLevel: 10, label: \"🎁 Бонус к бонусу (%)\" },\n tournament_boost: { baseCost: 20000, perLevel: 15000, baseValue: 0, perLevel_value: 3, maxLevel: 10, label: \"🏆 Бонус к турнирам (%)\" },\n};\n",[172],"7eca9edc-543a-11f1-8299-ee650bb23af1",["D",1779274563704],[34],"pulls","branches","forks","envVars",{"_188":74,"_190":74},"connections",{"_188":74,"_189":74},"count","unfilledCount","emptyCount",{"_54":178,"_38":34,"_36":37,"_150":-5,"_45":46,"_44":14,"_152":70,"_42":214,"_13":74,"_39":40,"_41":-5,"_30":31,"_155":-5,"_198":215,"_33":216},{"_54":210,"_38":50,"_36":49,"_150":37,"_45":46,"_44":14,"_152":70,"_42":211,"_13":74,"_39":51,"_41":52,"_30":31,"_155":-5,"_198":212,"_33":213},{"_54":171,"_38":172,"_36":173,"_150":-5,"_45":46,"_44":174,"_152":70,"_42":207,"_13":74,"_39":51,"_41":176,"_30":31,"_155":-5,"_198":208,"_33":209},{"_54":164,"_38":165,"_36":166,"_150":-5,"_45":46,"_44":167,"_152":70,"_42":204,"_13":74,"_39":51,"_41":169,"_30":31,"_155":-5,"_198":205,"_33":206},{"_54":157,"_38":158,"_36":159,"_150":-5,"_45":46,"_44":160,"_152":70,"_42":201,"_13":74,"_39":51,"_41":162,"_30":31,"_155":-5,"_198":202,"_33":203},{"_54":147,"_38":148,"_36":149,"_150":-5,"_45":46,"_44":151,"_152":70,"_42":197,"_13":74,"_39":51,"_41":154,"_30":31,"_155":-5,"_198":199,"_33":200},["D",1779274516568],"children",[],[148],["D",1779274533201],[],[158],["D",1779274505454],[],[165],["D",1779274464729],[],[172],"7eca6a8e-543a-11f1-8299-ee650bb23af1",["D",1779274563704],[],[34,50],["D",1779274563704],[192],[34],["D",1779274443138],["D",1789489305251],{"_111":110,"_119":115},{"_111":110,"_112":113,"_114":115,"_19":66,"_116":117,"_118":31},{"_13":100,"_38":101,"_54":46,"_102":55,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":56,"_109":110},"ctx",{"_93":-5,"_139":255,"_256":257,"_258":259,"_260":31,"_261":31,"_262":31,"_263":70,"_264":-5,"_265":-7,"_266":-7,"_267":74,"_268":31,"_269":31,"_270":-5,"_271":31,"_272":31,"_273":31,"_274":-5},"ENV",{"_226":227,"_228":229,"_230":101,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v5