[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_237":238,"_239":240},"routes/_app.x.$handle.$name",{"_105":104,"_37":50,"_114":95,"_32":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":30,"_129":130,"_131":30,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":30},"version",7,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","1e8274fd-035a-47e7-a282-89539b6ef870","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","handlers/roulette.ts","latestPath","fileId","9521de70-543a-11f1-afc6-ee650bb23af1","name","roulette.ts","fileType","script","content","import { Bot } from \"npm:grammy@1.30.0\";\nimport * as db from \"../db.ts\";\nimport { RED_NUMBERS, BLACK_NUMBERS } from \"../config.ts\";\nimport { fmt, userLink, parseBet, randInt } from \"../utils.ts\";\nimport { validateBet, deductBet, creditPayout } from \"../game-logic.ts\";\n\ninterface RouletteBet {\n userId: number;\n userName: string;\n amount: number;\n type: \"red\" | \"black\" | \"zero\" | \"number\";\n number?: number; // for number bets\n}\n\n// Store roulette bets per chat\nconst rouletteBets = new Map();\n\nexport function registerRouletteHandlers(bot: Bot) {\n // Roulette bet pattern\n // \"1500 к\", \"1500 ч\", \"1500 з\", \"1500 0\", \"1500 17\", \"1500 red\", etc.\n const betRegex =\n /^(\\d[\\d\\s]*[kmкм]?)\\s+(к|красное|red|r|ч|черное|чёрное|black|b|з|зеро|zero|0|[1-9]|[12]\\d|3[0-6])$/i;\n\n bot.hears(betRegex, async (ctx) => {\n const user = await db.ensureUser(ctx.from!.id, ctx.from!.username || \"\", ctx.from!.first_name || \"\");\n if (Number(user.banned)) return;\n\n const match = ctx.match as RegExpMatchArray;\n const amount = parseBet(match[1]);\n if (!amount) return;\n\n const balance = Number(user.balance);\n const err = validateBet(balance, amount);\n if (err) return ctx.reply(err);\n\n let betType: RouletteBet[\"type\"];\n let betNumber: number | undefined;\n const typeStr = match[2].toLowerCase();\n\n if ([\"к\", \"красное\", \"red\", \"r\"].includes(typeStr)) {\n betType = \"red\";\n } else if ([\"ч\", \"черное\", \"чёрное\", \"black\", \"b\"].includes(typeStr)) {\n betType = \"black\";\n } else if ([\"з\", \"зеро\", \"zero\"].includes(typeStr)) {\n betType = \"zero\";\n } else if (typeStr === \"0\") {\n betType = \"zero\";\n } else {\n const num = parseInt(typeStr, 10);\n if (num >= 0 && num <= 36) {\n betType = \"number\";\n betNumber = num;\n } else {\n return;\n }\n }\n\n // Deduct bet\n await deductBet(ctx.from!.id, amount);\n\n const chatId = ctx.chat.id;\n if (!rouletteBets.has(chatId)) rouletteBets.set(chatId, []);\n rouletteBets.get(chatId)!.push({\n userId: ctx.from!.id,\n userName: ctx.from!.first_name || String(user.username) || \"Игрок\",\n amount,\n type: betType,\n number: betNumber,\n });\n\n const betLabel = betType === \"red\"\n ? \"RED 🔴\"\n : betType === \"black\"\n ? \"BLACK ⚫\"\n : betType === \"zero\"\n ? \"ZERO 🟢\"\n : `число ${betNumber}`;\n\n await ctx.reply(\n `🎰 Ставка принята: ${userLink(ctx.from!.id, ctx.from!.first_name || \"\")} ${fmt(amount)} GRAM на ${betLabel}`,\n { parse_mode: \"HTML\" },\n );\n });\n\n // Spin: \"го\"\n bot.hears(/^го$/i, async (ctx) => {\n const chatId = ctx.chat.id;\n const bets = rouletteBets.get(chatId);\n if (!bets || bets.length === 0) {\n return ctx.reply(\"❌ Нет ставок! Сделайте ставку: 1000 к\", { parse_mode: \"HTML\" });\n }\n\n const result = randInt(0, 36);\n let color: string;\n let colorEmoji: string;\n\n if (result === 0) {\n color = \"zero\";\n colorEmoji = \"🟢 ZERO\";\n } else if (RED_NUMBERS.includes(result)) {\n color = \"red\";\n colorEmoji = \"🔴 RED\";\n } else {\n color = \"black\";\n colorEmoji = \"⚫ BLACK\";\n }\n\n let resultText = `🎰 Рулетка крутится...\\n\\n🔢 Выпало: ${result} ${colorEmoji}\\n\\n`;\n\n for (const bet of bets) {\n let payout = 0;\n\n if (bet.type === \"number\" && bet.number === result) {\n payout = bet.amount * 36;\n } else if (bet.type === \"zero\" && result === 0) {\n payout = bet.amount * 36;\n } else if (bet.type === \"red\" && color === \"red\") {\n payout = bet.amount * 2;\n } else if (bet.type === \"black\" && color === \"black\") {\n payout = bet.amount * 2;\n }\n\n await creditPayout(bet.userId, bet.amount, payout);\n\n if (payout > 0) {\n resultText += `✅ ${userLink(bet.userId, bet.userName)} выиграл ${fmt(payout)} GRAM!\\n`;\n } else {\n resultText += `❌ ${userLink(bet.userId, bet.userName)} проиграл ${fmt(bet.amount)} GRAM\\n`;\n }\n }\n\n rouletteBets.delete(chatId);\n await ctx.reply(resultText, { parse_mode: \"HTML\" });\n });\n\n // Help for roulette\n bot.hears(/^(🎰 Рулетка|рулетка)$/i, async (ctx) => {\n await ctx.reply(\n `🎰 Рулетка\\n\\n` +\n `Ставки:\\n` +\n `1000 к — красное (x2)\\n` +\n `1000 ч — чёрное (x2)\\n` +\n `1000 з — зеро (x36)\\n` +\n `1000 17 — число (x36)\\n\\n` +\n `Запуск: го`,\n { parse_mode: \"HTML\" },\n );\n });\n}\n","createdAt",["D",1779274601196],"branchVersion","branchId","36ebb920-543a-11f1-b122-ee650bb23af1","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",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":30},"branch",{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"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",{"_48":49,"_37":50,"_43":232,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":233,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":234,"_89":235,"_91":236,"_93":30},"tree",[189,193,194,195,196],"files",[189,190,191,192,193,194,195,196],"counts",{"_179":68,"_180":168,"_181":168,"_182":183,"_184":185},"contents",[136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":172,"_37":173,"_35":174,"_144":-5,"_46":47,"_45":175,"_146":64,"_43":176,"_13":68,"_39":177,"_41":-5,"_29":30,"_149":-5,"_32":178},{"_48":165,"_37":166,"_35":167,"_144":-5,"_46":47,"_45":168,"_146":64,"_43":169,"_13":68,"_39":40,"_41":170,"_29":30,"_149":-5,"_32":171},{"_48":158,"_37":159,"_35":160,"_144":-5,"_46":47,"_45":161,"_146":64,"_43":162,"_13":68,"_39":40,"_41":163,"_29":30,"_149":-5,"_32":164},{"_48":151,"_37":152,"_35":153,"_144":-5,"_46":47,"_45":154,"_146":64,"_43":155,"_13":68,"_39":40,"_41":156,"_29":30,"_149":-5,"_32":157},{"_48":141,"_37":142,"_35":143,"_144":-5,"_46":47,"_45":145,"_146":64,"_43":147,"_13":68,"_39":40,"_41":148,"_29":30,"_149":-5,"_32":150},"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",[142],"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",[152],"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",[159],"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",[166],"7eca9edc-543a-11f1-8299-ee650bb23af1","handlers","ec79cdad-cca3-4c05-a4b6-46a4e78c22e2",5,["D",1779274563704],"directory",[173],"pulls","branches","forks","envVars",{"_186":68,"_188":68},"connections",{"_186":68,"_187":68},"count","unfilledCount","emptyCount",{"_48":172,"_37":173,"_35":174,"_144":-5,"_46":47,"_45":175,"_146":64,"_43":229,"_13":68,"_39":177,"_41":-5,"_29":30,"_149":-5,"_198":230,"_32":231},{"_48":225,"_37":38,"_35":36,"_144":174,"_46":47,"_45":14,"_146":64,"_43":226,"_13":68,"_39":40,"_41":42,"_29":30,"_149":-5,"_198":227,"_32":228},{"_48":218,"_37":219,"_35":220,"_144":174,"_46":47,"_45":175,"_146":64,"_43":221,"_13":68,"_39":40,"_41":222,"_29":30,"_149":-5,"_198":223,"_32":224},{"_48":210,"_37":211,"_35":212,"_144":174,"_46":47,"_45":213,"_146":64,"_43":214,"_13":68,"_39":40,"_41":215,"_29":30,"_149":-5,"_198":216,"_32":217},{"_48":165,"_37":166,"_35":167,"_144":-5,"_46":47,"_45":168,"_146":64,"_43":207,"_13":68,"_39":40,"_41":170,"_29":30,"_149":-5,"_198":208,"_32":209},{"_48":158,"_37":159,"_35":160,"_144":-5,"_46":47,"_45":161,"_146":64,"_43":204,"_13":68,"_39":40,"_41":163,"_29":30,"_149":-5,"_198":205,"_32":206},{"_48":151,"_37":152,"_35":153,"_144":-5,"_46":47,"_45":154,"_146":64,"_43":201,"_13":68,"_39":40,"_41":156,"_29":30,"_149":-5,"_198":202,"_32":203},{"_48":141,"_37":142,"_35":143,"_144":-5,"_46":47,"_45":145,"_146":64,"_43":197,"_13":68,"_39":40,"_41":148,"_29":30,"_149":-5,"_198":199,"_32":200},["D",1779274516568],"children",[],[142],["D",1779274533201],[],[152],["D",1779274505454],[],[159],["D",1779274464729],[],[166],"874cebaa-543a-11f1-9d17-ee650bb23af1","transfer.ts","874cec68-543a-11f1-9d17-ee650bb23af1",6,["D",1779274577988],"import { Bot } from \"npm:grammy@1.30.0\";\nimport * as db from \"../db.ts\";\nimport { fmt, userLink, parseBet } from \"../utils.ts\";\nimport { MIN_BET } from \"../config.ts\";\n\nexport function registerTransferHandlers(bot: Bot) {\n // Transfer: \"перевод 1000 @username\", \"п 1000 @username\", \"дать 1000 @username\"\n // Or reply: \"перевод 1000\", \"п 1000\", \"дать 1000\"\n const transferRegex = /^(перевод|п|дать)\\s+(\\d[\\d\\s]*[kmкм]?)\\s*(@\\w+)?$/i;\n\n bot.hears(transferRegex, 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 match = ctx.match as RegExpMatchArray;\n const amount = parseBet(match[2]);\n if (!amount || amount < MIN_BET) {\n return ctx.reply(`❌ Некорректная сумма. Минимум: ${fmt(MIN_BET)} GRAM`);\n }\n\n if (amount > Number(user.balance)) {\n return ctx.reply(`❌ Недостаточно средств! Баланс: ${fmt(Number(user.balance))} GRAM`);\n }\n\n let targetUser: Record | undefined;\n\n if (match[3]) {\n // By @username\n targetUser = await db.getUserByUsername(match[3]);\n } else if (ctx.message?.reply_to_message?.from) {\n // By reply\n const replyFrom = ctx.message.reply_to_message.from;\n targetUser = await db.getUserById(replyFrom.id);\n }\n\n if (!targetUser) {\n return ctx.reply(\"❌ Получатель не найден. Он должен сначала написать боту.\");\n }\n\n if (Number(targetUser.id) === ctx.from!.id) {\n return ctx.reply(\"❌ Нельзя переводить самому себе!\");\n }\n\n await db.updateBalance(ctx.from!.id, -amount);\n await db.updateBalance(Number(targetUser.id), amount);\n\n await ctx.reply(\n `💸 Перевод выполнен!\\n\\n` +\n `${userLink(ctx.from!.id, String(user.first_name))} ➡️ ` +\n `${userLink(Number(targetUser.id), String(targetUser.first_name))}\\n` +\n `💰 Сумма: ${fmt(amount)} GRAM`,\n { parse_mode: \"HTML\" },\n );\n });\n}\n",[],[173,211],"7eca6a8e-543a-11f1-8299-ee650bb23af1","start-menu.ts","7eca6b74-543a-11f1-8299-ee650bb23af1",["D",1779274563704],"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",[],[173,219],"9521dd8a-543a-11f1-afc6-ee650bb23af1",["D",1779274601196],[],[173,38],["D",1779274563704],[190,191,192],[173],["D",1779274443138],["D",1789489305251],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":30},{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_133":270,"_271":272,"_273":274,"_275":30,"_276":30,"_277":30,"_278":64,"_279":-5,"_280":-7,"_281":-7,"_282":68,"_283":30,"_284":30,"_285":-5,"_286":30,"_287":30,"_288":30,"_289":-5},"ENV",{"_241":242,"_243":244,"_245":95,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269},"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 · v7