[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_229":230,"_231":232},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_171":-5,"_20":172,"_22":173,"_174":175,"_176":177,"_25":178,"_24":-5,"_179":-5,"_180":-5,"_181":57,"_182":183,"_184":48,"_185":-5,"_186":-5,"_187":188},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","egoistar","name","discord-counter-bot","branchName","main","version","path","","project",{"_37":112,"_13":14,"_49":113,"_114":-5,"_115":57,"_116":117,"_118":117,"_119":120,"_121":-5,"_122":123,"_124":62,"_125":48,"_126":-5,"_127":-5,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":-5,"_139":140,"_141":140,"_142":143,"_144":143,"_145":143,"_146":140,"_147":140,"_148":149,"_150":151,"_152":153,"_154":57},"tree",[91,92,93,94,95],"file","contents",[32,33,34,35,36],"upstream","pull","ahead","behind","envVars",{"_37":83,"_13":84,"_40":85,"_42":-5,"_43":44,"_45":86,"_47":48,"_49":87,"_17":88,"_52":53,"_54":89,"_56":57,"_58":-5,"_18":90},{"_37":76,"_13":77,"_40":78,"_42":-5,"_43":44,"_45":79,"_47":48,"_49":80,"_17":73,"_52":53,"_54":81,"_56":57,"_58":-5,"_18":82},{"_37":68,"_13":69,"_40":70,"_42":-5,"_43":44,"_45":71,"_47":48,"_49":72,"_17":73,"_52":53,"_54":74,"_56":57,"_58":-5,"_18":75},{"_37":60,"_13":61,"_40":62,"_42":-5,"_43":44,"_45":63,"_47":48,"_49":64,"_17":51,"_52":65,"_54":66,"_56":57,"_58":-5,"_18":67},{"_37":38,"_13":39,"_40":41,"_42":-5,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":59},"id","4cd7a28f-265b-47ce-bb94-4d44993b108f","register.ts","fileId","61f8b996-87fd-11f1-8b42-1607ee4eb77e","parentId","branchId","29d46573-46dd-433e-b50a-f3cfad019727","branchVersion",19,"latest",true,"createdAt",["D",1785066605381],4,"fileType","script","content","// Run this once (and again whenever commands change) to (re)register the\n// bot's slash commands with Discord.\n// Requires BOT_TOKEN and DISCORD_CLIENT_ID env vars.\n\nconst token = Deno.env.get(\"BOT_TOKEN\");\nconst appId = Deno.env.get(\"DISCORD_CLIENT_ID\");\n\nif (!token || !appId) {\n console.error(\"❌ Please set BOT_TOKEN and DISCORD_CLIENT_ID env vars first.\");\n Deno.exit(1);\n}\n\n// Application command option types.\nconst STRING = 3;\nconst INTEGER = 4;\nconst USER = 6; // Discord native user picker\n\nconst commands = [\n {\n name: \"mesaj\",\n description: \"Aktif sohbet ederek ekonomi havuzundan coin kazanırsın.\",\n },\n {\n name: \"profil\",\n description: \"Mevcut coin bakiyeni ve üyelik (Premium) durumunu gösterir.\",\n },\n {\n name: \"sıralama\",\n description: \"Sunucudaki en zengin ilk 10 oyuncuyu listeler.\",\n },\n {\n name: \"market\",\n description: \"5,000 Coin karşılığında sohbet ödüllerini 5x yapacak Premium üyeliği satın alırsın.\",\n },\n {\n name: \"zar\",\n description: \"50/50 Şansla coinlerini ikiye katlamanı sağlayan casino oyunu.\",\n options: [\n {\n name: \"miktar\",\n description: \"Bahse yatırmak istediğin coin miktarı\",\n type: INTEGER,\n required: true,\n min_value: 1,\n },\n ],\n },\n {\n name: \"transfer\",\n description: \"Başka bir kullanıcıya cüzdanından coin gönderirsin.\",\n options: [\n {\n name: \"kullanici\",\n description: \"Coin göndermek istediğin kişi\",\n type: USER,\n required: true,\n },\n {\n name: \"miktar\",\n description: \"Gönderilecek coin miktarı\",\n type: INTEGER,\n required: true,\n min_value: 1,\n },\n ],\n },\n {\n name: \"admin_set\",\n description: \"👑 [Sadece Kurucu Admin] Bir kullanıcının bakiyesini doğrudan düzenler.\",\n options: [\n {\n name: \"kullanici\",\n description: \"Bakiyesi güncellenecek kişi\",\n type: USER,\n required: true,\n },\n {\n name: \"hedef_ad\",\n description: \"Kullanıcının Discord adı (Veritabanı senkronizasyonu için)\",\n type: STRING,\n required: true,\n },\n {\n name: \"miktar\",\n description: \"Tanımlanacak yeni bakiye miktarı\",\n type: INTEGER,\n required: true,\n min_value: 0,\n },\n ],\n },\n];\n\nconst res = await fetch(\n `https://discord.com/api/v10/applications/${appId}/commands`,\n {\n method: \"PUT\", // PUT overwrites the full command set (removes old ones)\n headers: {\n Authorization: `Bot ${token}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(commands),\n },\n);\n\nif (res.ok) {\n console.log(\"✅ New economy commands registered successfully!\");\n const data = await res.json();\n console.log(\"Registered commands:\", data.map((c: any) => `/${c.name}`).join(\", \"));\n} else {\n console.error(\"❌ Failed to register commands:\", await res.text());\n}","deleted",false,"label",[39],"a6417138-5c4f-4af6-9c8a-c3b7689c5f7d","main.ts","61f3de3a-87fd-11f1-9063-1607ee4eb77e",17,["D",1785066552993],"http","import nacl from \"npm:tweetnacl@1.0.3\";\nimport { db } from \"./db.ts\";\nimport { processChatEarn, processBet, processTransfer, ADMIN_ID } from \"./game.ts\";\nimport { coin, COLORS, embedResponse, premiumLabel, textResponse } from \"./embeds.ts\";\n\nexport default async function (req: Request): Promise {\n const publicKey = Deno.env.get(\"DISCORD_PUBLIC_KEY\")?.trim();\n if (!publicKey) return new Response(\"DISCORD_PUBLIC_KEY not set\", { status: 500 });\n\n const signature = req.headers.get(\"X-Signature-Ed25519\");\n const timestamp = req.headers.get(\"X-Signature-Timestamp\");\n if (!signature || !timestamp) {\n return new Response(\"Missing signature headers\", { status: 401 });\n }\n\n const body = await req.text();\n\n let isValid: boolean;\n try {\n isValid = nacl.sign.detached.verify(\n new TextEncoder().encode(timestamp + body),\n hexToUint8Array(signature),\n hexToUint8Array(publicKey),\n );\n } catch (err) {\n console.error(\"Signature verification error:\", err);\n return new Response(\"Invalid public key\", { status: 401 });\n }\n if (!isValid) return new Response(\"Invalid request signature\", { status: 401 });\n\n const interaction = JSON.parse(body);\n\n // PING (Discord webhooks doğrulama)\n if (interaction.type === 1) return Response.json({ type: 1 });\n\n // Slash commands yönlendirici\n if (interaction.type === 2) {\n try {\n return await handleCommand(interaction);\n } catch (err) {\n console.error(\"handleCommand error:\", err);\n return textResponse(\"❌ Komut çalıştırılırken bir hata oluştu.\");\n }\n }\n\n return Response.json({ type: 6 });\n}\n\n// ---------------------------------------------------------------------------\n// Command Router\n// ---------------------------------------------------------------------------\nasync function handleCommand(interaction: any): Promise {\n const name: string = interaction.data.name;\n const userId: string = interaction.member?.user?.id ?? interaction.user?.id;\n const username: string =\n interaction.member?.user?.global_name ??\n interaction.member?.user?.username ??\n interaction.user?.username ??\n \"unknown\";\n const opts: any[] = interaction.data.options ?? [];\n const opt = (n: string) => opts.find((o) => o.name === n)?.value;\n\n switch (name) {\n case \"mesaj\":\n return handleMesaj(userId, username);\n case \"profil\":\n return handleProfil(interaction, userId, username);\n case \"sıralama\":\n return handleSiralama();\n case \"zar\":\n return handleZar(userId, username, Number(opt(\"miktar\")));\n case \"transfer\":\n return handleTransfer(interaction, userId, username, String(opt(\"kullanici\")), Number(opt(\"miktar\")));\n case \"market\":\n return handleMarket(userId, username);\n case \"admin_set\":\n return handleAdminSet(userId, String(opt(\"kullanici\")), String(opt(\"hedef_ad\")), Number(opt(\"miktar\")));\n default:\n return textResponse(\"Bilinmeyen komut.\");\n }\n}\n\n// ---------------------------------------------------------------------------\n// /mesaj (Chat-to-Earn Tetikleyici)\n// ---------------------------------------------------------------------------\nasync function handleMesaj(userId: string, username: string): Promise {\n const r = await processChatEarn(userId, username);\n\n if (!r.earned) {\n if (r.reason === \"admin\") {\n return embedResponse({\n title: \"👑 Admin Ayrıcalığı\",\n description: `Selam **${username}**! Sen kurucu adminsin. Cüzdanın zaten **Sınırsız Coin** ile dolu!`,\n color: COLORS.admin,\n });\n }\n return textResponse(\"⏳ Çok hızlı mesaj atıyorsun! Spam yapma, birkaç saniye bekle.\", true);\n }\n\n return embedResponse({\n title: \"💰 Coin Kazanıldı!\",\n description: `**${username}** aktif sohbet ettiği için ödüllendirildi!`,\n color: COLORS.success,\n fields: [\n { name: \"Kazanılan\", value: coin(r.amount), inline: true },\n { name: \"Yeni Bakiye\", value: coin(r.newBalance), inline: true },\n ],\n });\n}\n\n// ---------------------------------------------------------------------------\n// /profil\n// ---------------------------------------------------------------------------\nasync function handleProfil(interaction: any, userId: string, username: string): Promise {\n await db.ensureUser(userId, username);\n const u = await db.getUser(userId);\n\n const rawUser = interaction.member?.user ?? interaction.user;\n const avatar = rawUser?.avatar\n ? `https://cdn.discordapp.com/avatars/${rawUser.id}/${rawUser.avatar}.png`\n : undefined;\n\n const isAdmin = userId === ADMIN_ID;\n const displayCoins = isAdmin ? \"Sınırsız Coin 👑\" : (u?.coins ?? 0);\n const isPremium = u?.isPremium ?? false;\n\n return embedResponse({\n title: `👤 ${u?.username || username} İstatistikleri`,\n color: isPremium ? COLORS.premium : (isAdmin ? COLORS.admin : COLORS.gold),\n ...(avatar ? { thumbnail: { url: avatar } } : {}),\n fields: [\n { name: \"🪙 Bakiye\", value: `**${typeof displayCoins === \"string\" ? displayCoins : displayCoins.toLocaleString(\"en-US\")}**`, inline: true },\n { name: \"💎 Üyelik Türü\", value: `**${premiumLabel(isPremium)}**`, inline: true },\n ],\n footer: { text: \"Sohbet ederek veya zar oynayarak coin kazanabilirsin!\" },\n });\n}\n\n// ---------------------------------------------------------------------------\n// /sıralama\n// ---------------------------------------------------------------------------\nasync function handleSiralama(): Promise {\n const leaders = await db.getLeaderboard(10);\n const globalState = await db.getState();\n\n if (leaders.length === 0) {\n return embedResponse({\n title: \"🏆 En Zenginler Sıralaması\",\n description: \"Henüz cüzdanı aktif olan kimse yok! `/mesaj` yazarak ilk coini sen kazan.\",\n color: COLORS.gold,\n });\n }\n\n const medals = [\"🥇\", \"🥈\", \"🥉\"];\n const lines = leaders.map((u, i) => {\n const rank = medals[i] ?? `**${i + 1}.**`;\n const tag = u.isPremium ? \" ✨\" : \"\";\n return `${rank} **${u.username}**${tag} — ${coin(u.coins)}`;\n });\n\n return embedResponse({\n title: \"🏆 En Zenginler Sıralaması\",\n description: lines.join(\"\\n\"),\n color: COLORS.gold,\n fields: [\n { name: \"📊 Ekonomi Özeti\", value: `Toplam Kullanıcı: \\`${globalState.totalUsers}\\`\\nPremium Üye: \\`${globalState.totalPremiumUsers}\\``, inline: false }\n ],\n footer: { text: \"Sıralama Coin miktarına göre yapılmıştır.\" },\n });\n}\n\n// ---------------------------------------------------------------------------\n// /zar (50/50 Katlama Oyunu)\n// ---------------------------------------------------------------------------\nasync function handleZar(userId: string, username: string, amount: number): Promise {\n if (!Number.isInteger(amount) || amount <= 0) {\n return textResponse(\"❌ Geçersiz miktar! Lütfen pozitif bir tam sayı girin.\");\n }\n\n const r = await processBet(userId, username, amount);\n\n if (!r.success) {\n return textResponse(r.msg);\n }\n\n return embedResponse({\n title: r.won ? \"🎰 Kumarhane — Kazandın!\" : \"📉 Kumarhane — Kaybettin!\",\n description: r.msg,\n color: r.won ? COLORS.bet : COLORS.fail,\n fields: [\n { name: \"Net Değişim\", value: coin(r.payout ?? 0), inline: true },\n { name: \"Yeni Bakiye\", value: coin(r.newBalance ?? 0), inline: true },\n ],\n });\n}\n\n// ---------------------------------------------------------------------------\n// /transfer (Para Gönderme)\n// ---------------------------------------------------------------------------\nasync function handleTransfer(\n interaction: any,\n senderId: string,\n senderUsername: string,\n targetId: string,\n targetAmount: number\n): Promise {\n if (!Number.isInteger(targetAmount) || targetAmount <= 0) {\n return textResponse(\"❌ Gönderilecek miktar pozitif bir tam sayı olmalıdır.\");\n }\n\n // Discord option resolve işleminde target username çekmek için fallback:\n const resolvedUsers = interaction.data.resolved?.users ?? {};\n const targetUsername = resolvedUsers[targetId]?.username ?? \"Bilinmeyen Kullanıcı\";\n\n const res = await processTransfer(senderId, senderUsername, targetId, targetUsername, targetAmount);\n\n if (!res.success) {\n return textResponse(`❌ Hata: ${res.msg}`);\n }\n\n return embedResponse({\n title: \"💸 Transfer Başarılı!\",\n description: `**${senderUsername}** kullanıcısı, <@${targetId}> kullanıcısına coin gönderdi.`,\n color: COLORS.info,\n fields: [\n { name: \"Gönderilen Tutar\", value: coin(targetAmount), inline: true }\n ],\n });\n}\n\n// ---------------------------------------------------------------------------\n// /market (Premium Üyelik Satın Alımı)\n// ---------------------------------------------------------------------------\nasync function handleMarket(userId: string, username: string): Promise {\n const cost = 5000; // Premium üyelik bedeli: 5000 Coin\n const isAdmin = userId === ADMIN_ID;\n \n await db.ensureUser(userId, username);\n const u = await db.getUser(userId);\n\n if (u?.isPremium) {\n return textResponse(\"✨ Zaten harika bir Premium üyesiniz! Avantajlarınız aktif.\", true);\n }\n\n if (!isAdmin && (u?.coins ?? 0) < cost) {\n return textResponse(`❌ Bakiyeniz yetersiz! Premium üyelik **${coin(cost)}** gerektirir. Sizin bakiyeniz: ${coin(u?.coins ?? 0)}`, true);\n }\n\n if (!isAdmin && u) {\n await db.updateCoins(userId, username, u.coins - cost);\n }\n \n await db.setPremiumStatus(userId, username, true);\n\n return embedResponse({\n title: \"🎉 Tebrikler, Premium Oldunuz!\",\n description: `**${username}** başarıyla **5,000 Coin** karşılığında hesabını yükseltti!`,\n color: COLORS.premium,\n fields: [\n { name: \"Kazanılan Avantaj\", value: \"Sohbet ödüllerinde kalıcı **5x Çarpan** aktifleştirildi! 🚀\", inline: false }\n ],\n });\n}\n\n// ---------------------------------------------------------------------------\n// /admin_set (Sadece Adminin Kullanabileceği Bakiye Ayarlama)\n// ---------------------------------------------------------------------------\nasync function handleAdminSet(userId: string, targetId: string, targetName: string, amount: number): Promise {\n if (userId !== ADMIN_ID) {\n return textResponse(\"🛑 Bu komutu kullanmak için yetkiniz yok!\", true);\n }\n\n if (amount < 0) return textResponse(\"❌ Tutar negatif olamaz.\");\n\n await db.ensureUser(targetId, targetName);\n await db.updateCoins(targetId, targetName, amount);\n\n return embedResponse({\n title: \"🛠️ Admin Müdahalesi\",\n description: `<@${targetId}> adlı kullanıcının cüzdanı güncellendi.`,\n color: COLORS.admin,\n fields: [\n { name: \"Yeni Belirlenen Bakiye\", value: coin(amount), inline: true }\n ],\n });\n}\n\n// ---------------------------------------------------------------------------\n// Hex Yardımcı Fonksiyonu\n// ---------------------------------------------------------------------------\nfunction hexToUint8Array(hex: string): Uint8Array {\n return new Uint8Array(hex.match(/.{1,2}/g)!.map((b) => parseInt(b, 16)));\n}",[61],"aa1f7b86-b8a2-407f-9943-cd561d3d82d2","game.ts","9f62fbd8-88e4-11f1-b70a-1607ee4eb77e",14,["D",1785066497115],1,"import { db } from \"./db.ts\";\n\n// Ayarlar (Tunables) --------------------------------------------------------\nexport const BASE_CHAT_REWARD = 10; // Normal üyelerin mesaj başına kazanacağı coin\nexport const PREMIUM_MULTIPLIER = 5; // Premium üyelerin çarpanı (5x -> 50 Coin)\nexport const CHAT_COOLDOWN_MS = 3000; // Mesaj başına spam koruması (3 saniye)\n\n// 👑 KENDİ DISCORD USER ID'Nİ BURAYA YAZ!\nexport const ADMIN_ID = \"1192180166462558208\"; \n\nexport interface ChatEarnResult {\n earned: boolean;\n amount: number;\n newBalance: number | string; // Admin ise \"Sınırsız\" dönecek\n reason?: \"cooldown\" | \"admin\";\n}\n\nexport interface BetResult {\n success: boolean;\n msg: string;\n won?: boolean;\n payout?: number;\n newBalance?: number | string;\n}\n\n/**\n * Kullanıcı sohbet ettikçe tetiklenecek Chat-to-Earn motoru.\n * Spam korumasını denetler, rütbeye göre ödülü hesaplar ve veritabanını günceller.\n */\nexport async function processChatEarn(userId: string, username: string): Promise {\n // Eğer admin sen isen coin eklemiyoruz, zaten sınırsız gücün var\n if (userId === ADMIN_ID) {\n return { earned: false, amount: 0, newBalance: \"Sınırsız Coin 👑\", reason: \"admin\" };\n }\n\n const user = await db.ensureUser(userId, username);\n const now = Date.now();\n\n // 3 saniyelik spam koruması kontrolü\n if (now - user.lastMessageAt < CHAT_COOLDOWN_MS) {\n return { earned: false, amount: 0, newBalance: user.coins, reason: \"cooldown\" };\n }\n\n // Premium kontrolü ve ödül hesaplama\n const amount = user.isPremium ? (BASE_CHAT_REWARD * PREMIUM_MULTIPLIER) : BASE_CHAT_REWARD;\n const newBalance = user.coins + amount;\n\n // Veritabanına işle\n await db.addChatCoins(userId, username, amount, now);\n\n return {\n earned: true,\n amount,\n newBalance,\n };\n}\n\n/**\n * 50/50 Şansa dayalı yazı-tura tarzı bahis/casino motoru.\n * Adminlerin coini hiç azalmaz, normal üyelerin bakiyesi kontrol edilir.\n */\nexport async function processBet(userId: string, username: string, amount: number): Promise {\n const isAdmin = userId === ADMIN_ID;\n const user = await db.ensureUser(userId, username);\n\n if (amount <= 0) {\n return { success: false, msg: \"Lütfen 0'dan büyük geçerli bir bahis miktarı girin!\" };\n }\n\n // Bakiye kontrolü (Admin hariç)\n if (!isAdmin && user.coins < amount) {\n return { success: false, msg: `❌ Yetersiz bakiye! Bahis oynamak için cüzdanında yeterli coin yok.` };\n }\n\n // 50/50 Kazanma şansı\n const won = Math.random() < 0.5;\n \n if (won) {\n // Kazandı: Yatırdığı kadar coin eklenir (2 katına katlar)\n const newBalance = isAdmin ? \"Sınırsız Coin 👑\" : user.coins + amount;\n if (!isAdmin) {\n await db.updateCoins(userId, username, user.coins + amount);\n }\n return {\n success: true,\n won: true,\n payout: amount,\n newBalance,\n msg: `🎰 **Kazandın!** Şans yüzüne güldü ve \\`${amount}\\` coin kazandın!`,\n };\n } else {\n // Kaybetti: Yatırdığı coin bakiyesinden düşer (Adminin eksilmez)\n const newBalance = isAdmin ? \"Sınırsız Coin 👑\" : user.coins - amount;\n if (!isAdmin) {\n await db.updateCoins(userId, username, user.coins - amount);\n }\n return {\n success: true,\n won: false,\n payout: -amount,\n newBalance,\n msg: `📉 **Kaybettin!** Kasa kazandı. \\`${amount}\\` coin cüzdanından uçtu gitti.`,\n };\n }\n}\n\n/**\n * Kullanıcılar arası coin transfer motoru.\n */\nexport async function processTransfer(\n senderId: string,\n senderUsername: string,\n targetId: string,\n targetUsername: string,\n amount: number\n): Promise<{ success: boolean; msg: string }> {\n const isSenderAdmin = senderId === ADMIN_ID;\n const sender = await db.ensureUser(senderId, senderUsername);\n \n if (amount <= 0) return { success: false, msg: \"Geçersiz miktar!\" };\n if (senderId === targetId) return { success: false, msg: \"Kendine coin gönderemezsin!\" };\n\n // Gönderenin bakiyesi yeterli mi? (Admin hariç)\n if (!isSenderAdmin && sender.coins < amount) {\n return { success: false, msg: \"Hesabında bu kadar coin bulunmuyor!\" };\n }\n\n // Alıcıyı veritabanında doğrula\n const target = await db.ensureUser(targetId, targetUsername);\n\n // Parayı transfer et\n if (!isSenderAdmin) {\n await db.updateCoins(senderId, senderUsername, sender.coins - amount);\n }\n await db.updateCoins(targetId, targetUsername, target.coins + amount);\n\n return { success: true, msg: \"Transfer işlemi başarıyla tamamlandı!\" };\n}",[69],"e26d586e-0307-4b33-ab02-715891e5ba59","embeds.ts","905ad5e8-88e4-11f1-a8fe-1607ee4eb77e",15,["D",1785066501562],"// Shared Discord embed helpers + colors for a consistent rich UI.\n\nexport const COLORS = {\n success: 0x2ecc71, // Yeşil -> Başarılı işlemler\n fail: 0xe74c3c, // Kırmızı -> Hatalar / Bahis kayıpları\n info: 0x3498db, // Mavi -> Genel durum bilgisi\n gold: 0xf1c40f, // Sarı -> Coin işlemleri / Standart profil\n premium: 0x9b59b6, // Mor -> Premium üyeler ve Market işlemleri\n admin: 0xe67e22, // Turuncu -> Admin arayüzü ve Sınırsız güç\n bet: 0x1abc9c, // Turkuaz -> Kumar / Bahis ekranı\n} as const;\n\nexport interface Embed {\n title?: string;\n description?: string;\n color?: number;\n fields?: { name: string; value: string; inline?: boolean }[];\n footer?: { text: string };\n thumbnail?: { url: string };\n timestamp?: string;\n}\n\n/** Wrap one or more embeds into an interaction response (type 4). */\nexport function embedResponse(embeds: Embed | Embed[], ephemeral = false) {\n return Response.json({\n type: 4,\n data: {\n embeds: Array.isArray(embeds) ? embeds : [embeds],\n ...(ephemeral ? { flags: 1 << 6 } : {}),\n },\n });\n}\n\n/** A quick text/ephemeral reply for validation errors. */\nexport function textResponse(content: string, ephemeral = true) {\n return Response.json({\n type: 4,\n data: { content, ...(ephemeral ? { flags: 1 << 6 } : {}) },\n });\n}\n\n/** Coin miktarını emojili ve admin durumuna göre formatlar */\nexport function coin(n: number | string): string {\n if (typeof n === \"string\") return `🪙 ${n}`;\n return `🪙 ${n.toLocaleString(\"en-US\")}`;\n}\n\n/** Premium durumuna göre şık bir etiket döner */\nexport function premiumLabel(isPremium: boolean): string {\n return isPremium ? \"✨ PREMIUM (5x Kazanma!)\" : \"❌ Standart Üye\";\n}",[77],"d9bc6f6a-1a29-469a-9ad4-95334886d5ee","db.ts","62012fea-87fd-11f1-a046-1607ee4eb77e",16,["D",1785066506200],2,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ---------------------------------------------------------------------------\n// Schema (Geliştirilmiş Ekonomi & Premium Tabloları)\n// ---------------------------------------------------------------------------\nawait sqlite.batch([\n // Sunucu genel istatistiklerini tutan tablo\n `CREATE TABLE IF NOT EXISTS eco_state (\n id INTEGER PRIMARY KEY DEFAULT 1,\n total_users INTEGER NOT NULL DEFAULT 0,\n total_premium_users INTEGER NOT NULL DEFAULT 0,\n total_coins_minted INTEGER NOT NULL DEFAULT 0\n )`,\n // Kullanıcıların coin, premium ve spam koruma (cooldown) verilerini tutan tablo\n `CREATE TABLE IF NOT EXISTS eco_users (\n user_id TEXT PRIMARY KEY,\n username TEXT NOT NULL,\n coins INTEGER NOT NULL DEFAULT 0,\n is_premium INTEGER NOT NULL DEFAULT 0, -- 0 = Normal, 1 = Premium (5x)\n last_message_at INTEGER NOT NULL DEFAULT 0 -- Spam engellemek için unix ms timestamp\n )`,\n // Aktif bahisleri tutan tablo (50/50 Katlama Oyunu için)\n `CREATE TABLE IF NOT EXISTS eco_bets (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id TEXT NOT NULL,\n username TEXT NOT NULL,\n amount INTEGER NOT NULL,\n created_at INTEGER NOT NULL\n )`,\n // İlk açılışta genel durum satırını ekle\n `INSERT OR IGNORE INTO eco_state (id, total_users, total_premium_users, total_coins_minted)\n VALUES (1, 0, 0, 0)`,\n]);\n\n// ---------------------------------------------------------------------------\n// Types & Interfaces\n// ---------------------------------------------------------------------------\nexport interface EconomyState {\n totalUsers: number;\n totalPremiumUsers: number;\n totalCoinsMinted: number;\n}\n\nexport interface UserRow {\n userId: string;\n username: string;\n coins: number;\n isPremium: boolean;\n lastMessageAt: number;\n}\n\nexport interface BetRow {\n id: number;\n userId: string;\n username: string;\n amount: number;\n}\n\n// ---------------------------------------------------------------------------\n// Mappers (Veritabanı Satırlarını Nesneye Dönüştürücüler)\n// ---------------------------------------------------------------------------\nfunction mapState(row: any): EconomyState {\n return {\n totalUsers: Number(row?.total_users ?? 0),\n totalPremiumUsers: Number(row?.total_premium_users ?? 0),\n totalCoinsMinted: Number(row?.total_coins_minted ?? 0),\n };\n}\n\nfunction mapUser(row: any): UserRow {\n return {\n userId: row.user_id as string,\n username: row.username as string,\n coins: Number(row.coins ?? 0),\n isPremium: Number(row.is_premium ?? 0) === 1,\n lastMessageAt: Number(row.last_message_at ?? 0),\n };\n}\n\n// ---------------------------------------------------------------------------\n// Public API (Geliştirilmiş Metotlar)\n// ---------------------------------------------------------------------------\nexport const db = {\n // --- Global State --------------------------------------------------------\n async getState(): Promise {\n const res = await sqlite.execute(`SELECT * FROM eco_state WHERE id = 1`);\n return mapState(res.rows[0]);\n },\n\n async updateGlobalStats(): Promise {\n await sqlite.execute(`\n UPDATE eco_state \n SET total_users = (SELECT COUNT(*) FROM eco_users),\n total_premium_users = (SELECT COUNT(*) FROM eco_users WHERE is_premium = 1),\n total_coins_minted = (SELECT SUM(coins) FROM eco_users)\n WHERE id = 1\n `);\n },\n\n // --- Users & Chat-to-Earn ------------------------------------------------\n async getUser(userId: string): Promise {\n const res = await sqlite.execute({\n sql: `SELECT * FROM eco_users WHERE user_id = ?`,\n args: [userId],\n });\n return res.rows[0] ? mapUser(res.rows[0]) : null;\n },\n\n // Kullanıcıyı doğrular veya yoksa oluşturur\n async ensureUser(userId: string, username: string): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO eco_users (user_id, username, coins, is_premium, last_message_at)\n VALUES (?, ?, 0, 0, 0)\n ON CONFLICT(user_id) DO UPDATE SET username = excluded.username`,\n args: [userId, username],\n });\n const user = await this.getUser(userId);\n return user!;\n },\n\n // Sohbet ettikçe coin ekleyen fonksiyon (Spam süresini ana dosyada kontrol edeceğiz)\n async addChatCoins(\n userId: string,\n username: string,\n amount: number,\n timestamp: number,\n ): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO eco_users (user_id, username, coins, is_premium, last_message_at)\n VALUES (?, ?, ?, 0, ?)\n ON CONFLICT(user_id) DO UPDATE SET\n coins = coins + ?,\n last_message_at = ?,\n username = excluded.username`,\n args: [userId, username, amount, timestamp, amount, timestamp],\n });\n await this.updateGlobalStats();\n },\n\n // Bakiye güncelleme (Bahis kayıpları, transferler veya admin müdahaleleri için)\n async updateCoins(\n userId: string,\n username: string,\n newBalance: number,\n ): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO eco_users (user_id, username, coins, is_premium, last_message_at)\n VALUES (?, ?, ?, 0, 0)\n ON CONFLICT(user_id) DO UPDATE SET\n coins = ?,\n username = excluded.username`,\n args: [userId, username, newBalance, newBalance],\n });\n await this.updateGlobalStats();\n },\n\n // Kullanıcıyı Premium yapar veya siler (Market sistemi için)\n async setPremiumStatus(\n userId: string,\n username: string,\n status: boolean,\n ): Promise {\n const premiumVal = status ? 1 : 0;\n await sqlite.execute({\n sql:\n `INSERT INTO eco_users (user_id, username, coins, is_premium, last_message_at)\n VALUES (?, ?, 0, ?, 0)\n ON CONFLICT(user_id) DO UPDATE SET\n is_premium = ?,\n username = excluded.username`,\n args: [userId, username, premiumVal, premiumVal],\n });\n await this.updateGlobalStats();\n },\n\n // --- Leaderboard ---------------------------------------------------------\n async getLeaderboard(limit = 10): Promise {\n const res = await sqlite.execute({\n sql: `SELECT * FROM eco_users ORDER BY coins DESC LIMIT ?`,\n args: [limit],\n });\n return res.rows.map(mapUser);\n },\n\n // --- Bets (Bahis İşlemleri) -----------------------------------------------\n async placeBet(\n userId: string,\n username: string,\n amount: number,\n ): Promise {\n await sqlite.execute({\n sql: `INSERT INTO eco_bets (user_id, username, amount, created_at)\n VALUES (?, ?, ?, ?)`,\n args: [userId, username, amount, Date.now()],\n });\n },\n\n async getUserBet(userId: string): Promise {\n const res = await sqlite.execute({\n sql: `SELECT * FROM eco_bets WHERE user_id = ? LIMIT 1`,\n args: [userId],\n });\n const row: any = res.rows[0];\n if (!row) return null;\n return {\n id: Number(row.id),\n userId: row.user_id,\n username: row.username,\n amount: Number(row.amount),\n };\n },\n\n async clearUserBet(userId: string): Promise {\n await sqlite.execute({\n sql: `DELETE FROM eco_bets WHERE user_id = ?`,\n args: [userId],\n });\n },\n};",[84],{"_37":83,"_13":84,"_40":85,"_42":-5,"_43":44,"_45":86,"_47":48,"_49":109,"_17":88,"_52":53,"_54":89,"_56":57,"_58":-5,"_97":110,"_18":111},{"_37":76,"_13":77,"_40":78,"_42":-5,"_43":44,"_45":79,"_47":48,"_49":106,"_17":73,"_52":53,"_54":81,"_56":57,"_58":-5,"_97":107,"_18":108},{"_37":68,"_13":69,"_40":70,"_42":-5,"_43":44,"_45":71,"_47":48,"_49":103,"_17":73,"_52":53,"_54":74,"_56":57,"_58":-5,"_97":104,"_18":105},{"_37":60,"_13":61,"_40":62,"_42":-5,"_43":44,"_45":63,"_47":48,"_49":100,"_17":51,"_52":65,"_54":66,"_56":57,"_58":-5,"_97":101,"_18":102},{"_37":38,"_13":39,"_40":41,"_42":-5,"_43":44,"_45":46,"_47":48,"_49":96,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_97":98,"_18":99},["D",1785066605381],"children",[],[39],["D",1785066552993],[],[61],["D",1785066497115],[],[69],["D",1785066501562],[],[77],["D",1785066506200],[],[84],"69f0e3f4-ecb4-4474-8124-5c2e1ab091e3",["D",1784965762766],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Discord counter bot with slash commands and SQLite tracking","imageUrl","userId","5974b9ef-85b0-45f5-9298-31864fd2d482","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f983e-4c93-708e-a30d-ba0c45379ac4","tursoName","69f0e3f4ecb4447481245c2e1ab091e3","tursoHostname","69f0e3f4ecb4447481245c2e1ab091e3-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789479081816],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_170":166},"org",{"_11":12,"_163":164,"_165":166,"_122":123,"_167":168,"_169":57},"branch",{"_17":46,"_13":16,"_37":44,"_155":112,"_156":-5,"_157":-5,"_158":-5,"_159":-5,"_160":-5,"_161":14,"_162":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","EgoistAR","avatar","https://avatars.githubusercontent.com/u/220046337?v=4","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_37":112,"_13":14,"_49":224,"_114":-5,"_115":57,"_116":117,"_118":117,"_119":120,"_121":-5,"_122":123,"_124":62,"_125":48,"_126":-5,"_127":-5,"_128":129,"_130":131,"_132":133,"_134":135,"_136":225,"_138":-5,"_139":140,"_141":140,"_142":143,"_144":143,"_145":143,"_146":140,"_147":140,"_148":226,"_150":227,"_152":228,"_154":57},[209,210,211,212,213],"files",[209,210,211,212,213],"counts",{"_199":129,"_200":73,"_201":129,"_31":202,"_203":204},[189,190,191,192,193],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_37":83,"_13":84,"_40":85,"_42":-5,"_43":44,"_45":86,"_47":48,"_49":87,"_17":88,"_52":53,"_54":89,"_56":57,"_58":-5,"_18":198},{"_37":76,"_13":77,"_40":78,"_42":-5,"_43":44,"_45":79,"_47":48,"_49":80,"_17":73,"_52":53,"_54":81,"_56":57,"_58":-5,"_18":197},{"_37":68,"_13":69,"_40":70,"_42":-5,"_43":44,"_45":71,"_47":48,"_49":72,"_17":73,"_52":53,"_54":74,"_56":57,"_58":-5,"_18":196},{"_37":60,"_13":61,"_40":62,"_42":-5,"_43":44,"_45":63,"_47":48,"_49":64,"_17":51,"_52":65,"_54":66,"_56":57,"_58":-5,"_18":195},{"_37":38,"_13":39,"_40":41,"_42":-5,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":194},[39],[61],[69],[77],[84],"pulls","branches","forks",{"_205":207,"_208":129},"connections",{"_205":129,"_206":129},"count","unfilledCount",3,"emptyCount",{"_37":83,"_13":84,"_40":85,"_42":-5,"_43":44,"_45":86,"_47":48,"_49":109,"_17":88,"_52":53,"_54":89,"_56":57,"_58":-5,"_97":222,"_18":223},{"_37":76,"_13":77,"_40":78,"_42":-5,"_43":44,"_45":79,"_47":48,"_49":106,"_17":73,"_52":53,"_54":81,"_56":57,"_58":-5,"_97":220,"_18":221},{"_37":68,"_13":69,"_40":70,"_42":-5,"_43":44,"_45":71,"_47":48,"_49":103,"_17":73,"_52":53,"_54":74,"_56":57,"_58":-5,"_97":218,"_18":219},{"_37":60,"_13":61,"_40":62,"_42":-5,"_43":44,"_45":63,"_47":48,"_49":100,"_17":51,"_52":65,"_54":66,"_56":57,"_58":-5,"_97":216,"_18":217},{"_37":38,"_13":39,"_40":41,"_42":-5,"_43":44,"_45":46,"_47":48,"_49":96,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_97":214,"_18":215},[],[39],[],[61],[],[69],[],[77],[],[84],["D",1784965762766],["D",1789479081816],{"_11":12,"_170":166},{"_11":12,"_163":164,"_165":166,"_122":123,"_167":168,"_169":57},{"_17":46,"_13":16,"_37":44,"_155":112,"_156":-5,"_157":-5,"_158":-5,"_159":-5,"_160":-5,"_161":14,"_162":12},"ctx",{"_148":-5,"_186":262,"_263":264,"_265":266,"_267":57,"_268":57,"_269":57,"_270":48,"_271":-5,"_272":-7,"_273":-7,"_274":129,"_275":57,"_276":57,"_277":-5,"_278":57,"_279":57,"_280":57,"_281":-5},"ENV",{"_233":234,"_235":236,"_237":16,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261},"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"]

Code