[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_235":236,"_237":238},"routes/_app.x.$handle.$name",{"_103":102,"_37":48,"_112":93,"_32":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_26":-5,"_124":-5,"_125":-5,"_126":30,"_127":128,"_129":62,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_46":47,"_37":48,"_41":49,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":30},"version",8,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","08f56900-2ac0-4e34-aab3-73d423d316a0","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":26,"_39":40,"_41":42,"_43":14,"_44":45,"_29":30},"previous","deleted",false,"deletedHere","path","SETUP.md","latestPath","fileId","339b8778-86ee-11f1-a3c0-1607ee4eb77e","name","fileType","content","# 🚀 Abesha Pay Bot — Setup Guide\n\nYour Telegram bot is **live and ready**. Follow these steps to get it working.\n\n## ✅ What's Already Done\n- Bot code deployed to Val Town (serverless Deno)\n- SQLite database auto-created\n- Webhook registered with Telegram\n- All optional env vars set (lookup APIs default to manual verification)\n\n**Status**: ✅ Running at \n\n---\n\n## 📋 Required Setup (3 steps)\n\n### Step 1: Set Your Admin Telegram ID\nYou need to set this so the bot knows who you are (the admin who approves orders).\n\n**Get your numeric ID:**\n1. Message [@userinfobot](https://t.me/userinfobot) on Telegram\n2. Copy the number from the response (e.g., `123456789`)\n\n**Set it here:**\n👉 **https://www.val.town/x/abeniandela/abesha-pay-bot/environment-variables?key=ADMIN_TELEGRAM_ID**\n\n(Replace `0` with your actual numeric ID)\n\n### Step 2: Update Payment Details\nCustomers need to know where to send payment. Update these with your real accounts:\n\n👉 **TELEBIRR_NUMBER** — Your Telebirr phone number\nhttps://www.val.town/x/abeniandela/abesha-pay-bot/environment-variables?key=TELEBIRR_NUMBER\n\n👉 **CBE_ACCOUNT_NUMBER** — Your CBE bank account\nhttps://www.val.town/x/abeniandela/abesha-pay-bot/environment-variables?key=CBE_ACCOUNT_NUMBER\n\n👉 **ACCOUNT_HOLDER_NAME** — Name on your account\nhttps://www.val.town/x/abeniandela/abesha-pay-bot/environment-variables?key=ACCOUNT_HOLDER_NAME\n\n### Step 3: Test the Bot\n1. Find your bot on Telegram (name/handle you set via @BotFather)\n2. Send `/start`\n3. You should see language selection (English 🇬🇧 / Amharic 🇪🇹)\n4. Pick a language and go through the flow to verify everything works\n\n---\n\n## 🎮 How to Use\n\n### Customer Journey\n- **/start** → Pick language → Browse Free Fire / PUBG → Add items (max 2) → Checkout\n- Enter **UID** for each game → **Verified** ✅ or flagged for manual check ⚠️\n- Enter **payer name** + **phone**\n- Upload **payment screenshot**\n- Get **order number** + status tracker\n\n### Admin Panel\nWhen a customer sends a screenshot:\n1. You receive a **photo message** with full order details\n2. Two buttons: **✅ Approve & Complete** / **❌ Reject**\n3. Customer auto-receives notification in their language\n\n### Customer Status Check\nCustomers can tap **🔄 Check Status** on their order message anytime to see:\n- ⏳ Pending review\n- ✅ Completed (items delivered)\n- ❌ Rejected\n\n---\n\n## 📊 Edit Prices Anytime\n\nPrices are in `catalog.ts` — edit them, and changes go live instantly.\n\n**Free Fire Diamonds** — Line 15–22\n**PUBG Mobile UC** — Line 24–31\n\nFormat:\n```typescript\n{ id: \"ff_110\", label: \"💎 110 Diamonds\", am_label: \"💎 110 ዳይመንድ\", etb: 210, usd: 1.02 },\n```\n\nChange `etb` (Ethiopian Birr) — `usd` auto-calculates for display.\n\n---\n\n## 🔐 Optional: Auto-Verify UIDs (Advanced)\n\nIf you have access to a Free Fire or PUBG lookup API, add it to speed up verification:\n\n👉 **FREEFIRE_LOOKUP_URL** — e.g., `https://free-ff-api.example.com/lookup`\n👉 **PUBG_LOOKUP_URL** — e.g., `https://pubg-api.example.com/lookup`\n\nLeave blank = manual verification (bot will flag as ⚠️ unverified, you check in-game).\n\n**Popular options:**\n- Free Fire: `free-ff-api` on GitHub (community project)\n- PUBG: Very limited public APIs; most resellers skip auto-verify\n\n---\n\n## 📱 Database\n\nYour orders, users, and checkout sessions live in **Val Town's SQLite** (project-scoped, encrypted).\n\n**Never** shared across vals, never exposed. You can query it via Val Town's tools if needed.\n\n---\n\n## 🛠️ Files\n\n| File | Purpose |\n|------|---------|\n| **index.ts** | Main bot handler (grammY webhook) |\n| **catalog.ts** | Item prices (Free Fire + PUBG) |\n| **i18n.ts** | English/Amharic translations |\n| **db.ts** | SQLite schema + helpers |\n| **lookupService.ts** | UID verification (optional) |\n| **README.md** | Full technical docs |\n\n---\n\n## ✨ Done!\n\n**You're ready to go.** The bot is live. Just:\n1. ✅ Set ADMIN_TELEGRAM_ID\n2. ✅ Update TELEBIRR_NUMBER, CBE_ACCOUNT_NUMBER, ACCOUNT_HOLDER_NAME\n3. ✅ Test with `/start`\n\nQuestions? Check `README.md` for technical details.\n\n---\n\n**Endpoint:** \n\n**Status:** ✅ Running\n","createdAt",["D",1784849305125],"branchVersion","branchId","b56958e0-788a-4a65-bd2e-eb93be94d547","id","5964c430-0f8c-4928-8d29-731dfcf4b060","abesha-pay-bot",["D",1784848208980],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Telegram bot for selling game top-ups with Telebirr/CBE payment","imageUrl","aa3202d5-439d-4817-9690-e2158323ebc0","pinnedFileId","638757d8-86ed-11f1-b319-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f9139-35fc-7078-96c4-0e4228d0ce6a","tursoName","5964c4300f8c49288d29731dfcf4b060","tursoHostname","5964c4300f8c49288d29731dfcf4b060-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789474235934],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_111":107},"org",{"_103":102,"_104":105,"_106":107,"_19":58,"_108":109,"_110":30},"branch",{"_13":92,"_37":93,"_46":45,"_94":47,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":48,"_101":102},"isOwned",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","abeniandela","handle","displayName","Elnathan Teshale","avatar","https://lh3.googleusercontent.com/a/ACg8ocK5ZKPz5vDyTFKzuhbZX3HxaLn9prK894S1pACgNIinv-remQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_46":47,"_37":48,"_41":230,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":231,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":232,"_87":233,"_89":234,"_91":30},"tree",[201,202,203,204,205,206,207],"files",[201,202,203,204,205,206,207],"counts",{"_190":66,"_191":145,"_192":66,"_193":194,"_195":196},"contents",[134,135,136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_46":183,"_37":184,"_35":185,"_144":-5,"_44":45,"_43":186,"_146":62,"_41":187,"_13":66,"_38":26,"_39":188,"_29":30,"_150":-5,"_32":189},{"_46":180,"_37":33,"_35":36,"_144":-5,"_44":45,"_43":14,"_146":62,"_41":181,"_13":66,"_38":26,"_39":40,"_29":30,"_150":-5,"_32":182},{"_46":173,"_37":174,"_35":175,"_144":-5,"_44":45,"_43":176,"_146":30,"_41":177,"_13":66,"_38":148,"_39":178,"_29":30,"_150":-5,"_32":179},{"_46":166,"_37":167,"_35":168,"_144":-5,"_44":45,"_43":169,"_146":62,"_41":170,"_13":66,"_38":148,"_39":171,"_29":30,"_150":-5,"_32":172},{"_46":159,"_37":160,"_35":161,"_144":-5,"_44":45,"_43":162,"_146":30,"_41":163,"_13":66,"_38":148,"_39":164,"_29":30,"_150":-5,"_32":165},{"_46":152,"_37":153,"_35":60,"_144":-5,"_44":45,"_43":154,"_146":30,"_41":155,"_13":145,"_38":156,"_39":157,"_29":30,"_150":-5,"_32":158},{"_46":141,"_37":142,"_35":143,"_144":-5,"_44":45,"_43":145,"_146":30,"_41":147,"_13":66,"_38":148,"_39":149,"_29":30,"_150":-5,"_32":151},"878dc2f4-b5a3-433a-84d6-a2d19e6a81ef","lookupService.ts","fc2f9b8c-86eb-11f1-9f2d-1607ee4eb77e","parentId",1,"latest",["D",1784848353136],"script","// There is no OFFICIAL Garena or Tencent API for resolving a UID to an\n// in-game name. What exists instead is a market of unofficial,\n// community-built APIs that reverse-engineer each game's internal\n// protocol. They work, and resellers use them, but treat them as\n// best-effort, not guaranteed.\n\nconst FREEFIRE_LOOKUP_URL = Deno.env.get(\"FREEFIRE_LOOKUP_URL\") || \"\";\nconst FREEFIRE_REGION = Deno.env.get(\"FREEFIRE_REGION\") || \"IND\";\nconst FREEFIRE_LOOKUP_API_KEY = Deno.env.get(\"FREEFIRE_LOOKUP_API_KEY\") || \"\";\n\nconst PUBG_LOOKUP_URL = Deno.env.get(\"PUBG_LOOKUP_URL\") || \"\";\nconst PUBG_LOOKUP_API_KEY = Deno.env.get(\"PUBG_LOOKUP_API_KEY\") || \"\";\n\ninterface LookupResult {\n verified: boolean;\n name: string | null;\n reason: string | null;\n error?: string;\n}\n\nfunction parseResponse(data: any): string | null {\n return (\n data?.basicInfo?.nickname ||\n data?.basicinfo?.nickname ||\n data?.data?.nickname ||\n data?.name ||\n data?.nickname ||\n data?.username ||\n null\n );\n}\n\nasync function callLookup(baseUrl: string, uid: string, extraParams: Record = {}): Promise {\n if (!baseUrl) return { verified: false, name: null, reason: \"no_lookup_configured\" };\n\n try {\n const params = new URLSearchParams({ uid, ...extraParams });\n const url = `${baseUrl}${baseUrl.includes(\"?\") ? \"&\" : \"?\"}${params.toString()}`;\n const res = await fetch(url, { signal: AbortSignal.timeout(8000) });\n if (!res.ok) return { verified: false, name: null, reason: `http_${res.status}` };\n\n const data = await res.json();\n if (data?.error) return { verified: false, name: null, reason: String(data.error) };\n\n const name = parseResponse(data);\n if (!name) return { verified: false, name: null, reason: \"name_not_found\" };\n return { verified: true, name, reason: null };\n } catch (err) {\n return { verified: false, name: null, reason: \"lookup_error\", error: (err as Error).message };\n }\n}\n\nasync function lookupFreeFireUID(uid: string): Promise {\n const extra: Record = { region: FREEFIRE_REGION };\n if (FREEFIRE_LOOKUP_API_KEY) extra.key = FREEFIRE_LOOKUP_API_KEY;\n return callLookup(FREEFIRE_LOOKUP_URL, uid, extra);\n}\n\nasync function lookupPubgUID(uid: string): Promise {\n const extra: Record = {};\n if (PUBG_LOOKUP_API_KEY) extra.key = PUBG_LOOKUP_API_KEY;\n return callLookup(PUBG_LOOKUP_URL, uid, extra);\n}\n\nexport async function lookupUID(game: string, uid: string): Promise {\n return game === \"freefire\" ? lookupFreeFireUID(uid) : lookupPubgUID(uid);\n}\n","label",[142],"4ac347fe-bbfa-4702-95e1-70892e0aaca3","index.ts",6,["D",1784848970682],"http","import { Bot, webhookCallback } from \"https://deno.land/x/grammy@v1.35.0/mod.ts\";\nimport { CATALOG, findItem, itemLabel, gameLabel } from \"./catalog.ts\";\nimport { t, SUPPORTED_LANGS } from \"./i18n.ts\";\nimport { lookupUID } from \"./lookupService.ts\";\nimport * as db from \"./db.ts\";\n\nconst TELEGRAM_TOKEN = Deno.env.get(\"TELEGRAM_API_TOKEN\");\nconst ADMIN_ID = Number(Deno.env.get(\"ADMIN_TELEGRAM_ID\") || \"0\");\nconst TELEBIRR_NUMBER = Deno.env.get(\"TELEBIRR_NUMBER\") || \"(not set)\";\nconst CBE_ACCOUNT_NUMBER = Deno.env.get(\"CBE_ACCOUNT_NUMBER\") || \"(not set)\";\nconst ACCOUNT_HOLDER_NAME = Deno.env.get(\"ACCOUNT_HOLDER_NAME\") || \"(not set)\";\n\nif (!TELEGRAM_TOKEN) throw new Error(\"TELEGRAM_API_TOKEN is missing\");\nif (!ADMIN_ID) console.warn(\"⚠️ ADMIN_TELEGRAM_ID not set — admin features disabled. Set it in environment variables.\");\n\nconst bot = new Bot(TELEGRAM_TOKEN);\n\n// Formatters\nconst fmtETB = (n: number) => `${n.toLocaleString(\"en-US\")} ETB`;\nconst fmtUSD = (n: number) => `$${n.toFixed(2)}`;\nconst cartTotal = (cart: any[]) => cart.reduce((sum, i) => sum + i.etb, 0);\n\n// --- Helpers ---\n\nasync function ensureLang(ctx: any): Promise {\n const session = await db.getSession(ctx.chat.id);\n if (!session.lang) {\n const user = await db.getUser(ctx.from.id);\n const lang = user?.language && SUPPORTED_LANGS.includes(user.language) ? user.language : \"en\";\n session.lang = lang;\n await db.updateSession(ctx.chat.id, { lang });\n }\n return session.lang!;\n}\n\nfunction cartText(cart: any[], lang: string): string {\n if (cart.length === 0) return t(\"cart_empty\", lang);\n const lines = cart.map((i, idx) => `${idx + 1}. ${itemLabel(i, lang)} — ${fmtETB(i.etb)}`);\n const total = t(\"cart_total\", lang, {\n etb: fmtETB(cartTotal(cart)),\n usd: fmtUSD(cart.reduce((s, i) => s + i.usd, 0)),\n });\n return `${t(\"cart_title\", lang)}\\n\\n${lines.join(\"\\n\")}\\n\\n${total}`;\n}\n\n// --- Inline buttons ---\n\nfunction languageButtons() {\n return {\n reply_markup: {\n inline_keyboard: [[\n { text: \"English 🇬🇧\", callback_data: \"lang:en\" },\n { text: \"አማርኛ 🇪🇹\", callback_data: \"lang:am\" },\n ]],\n },\n };\n}\n\nfunction categoriesButtons(lang: string) {\n return {\n reply_markup: {\n inline_keyboard: [\n [{ text: t(\"cat_freefire\", lang), callback_data: \"game:freefire\" }],\n [{ text: t(\"cat_pubg\", lang), callback_data: \"game:pubg\" }],\n [{ text: t(\"view_cart_btn\", lang), callback_data: \"cart:view\" }],\n ],\n },\n };\n}\n\nfunction catalogButtons(game: string, lang: string) {\n const rows = CATALOG[game].map((item) => [\n {\n text: `${itemLabel(item, lang)} — ${fmtETB(item.etb)} (${fmtUSD(item.usd)})`,\n callback_data: `add:${item.id}`,\n },\n ]);\n rows.push([{ text: t(\"view_cart_btn\", lang), callback_data: \"cart:view\" }]);\n rows.push([{ text: t(\"back_categories_btn\", lang), callback_data: \"back:categories\" }]);\n return { reply_markup: { inline_keyboard: rows } };\n}\n\nfunction cartButtons(cart: any[], lang: string) {\n const rows: any[] = [];\n if (cart.length > 0) {\n rows.push([{ text: t(\"checkout_btn\", lang), callback_data: \"cart:checkout\" }]);\n rows.push([{ text: t(\"clear_cart_btn\", lang), callback_data: \"cart:clear\" }]);\n }\n rows.push([{ text: t(\"continue_shopping_btn\", lang), callback_data: \"back:categories\" }]);\n return { reply_markup: { inline_keyboard: rows } };\n}\n\n// --- Commands ---\n\nbot.command(\"start\", async (ctx) => {\n await db.upsertUser(ctx.from!.id, ctx.from!.username);\n const user = await db.getUser(ctx.from!.id);\n await db.resetSession(ctx.chat.id, false);\n\n if (!user?.language) {\n return ctx.reply(t(\"choose_language\", \"en\"), languageButtons());\n }\n\n const session = await db.getSession(ctx.chat.id);\n await db.updateSession(ctx.chat.id, { lang: user.language });\n return ctx.replyWithMarkdown(t(\"welcome\", user.language), categoriesButtons(user.language));\n});\n\nbot.command(\"language\", (ctx) => {\n return ctx.reply(t(\"choose_language\", \"en\"), languageButtons());\n});\n\n// --- Callbacks ---\n\nbot.on(\"callback_query\", async (ctx) => {\n const data = ctx.callbackQuery.data || \"\";\n\n // Language selection\n if (data.startsWith(\"lang:\")) {\n const lang = data.split(\":\")[1] as string;\n await db.upsertUser(ctx.from!.id, ctx.from!.username);\n await db.setLanguage(ctx.from!.id, lang);\n await db.updateSession(ctx.chat.id, { lang });\n await ctx.answerCallbackQuery(t(\"lang_changed\", lang));\n await ctx.editMessageText(t(\"lang_changed\", lang));\n return ctx.editMessageReplyMarkup(categoriesButtons(lang));\n }\n\n const lang = await ensureLang(ctx);\n\n // Back to categories\n if (data === \"back:categories\") {\n await ctx.answerCallbackQuery();\n await ctx.editMessageText(t(\"choose_category\", lang), categoriesButtons(lang));\n return;\n }\n\n // Game selection\n if (data.startsWith(\"game:\")) {\n const game = data.split(\":\")[1];\n await ctx.answerCallbackQuery();\n await ctx.editMessageText(\n t(\"catalog_prompt\", lang, { game: gameLabel(game, lang) }),\n catalogButtons(game, lang),\n );\n return;\n }\n\n // Add to cart\n if (data.startsWith(\"add:\")) {\n const itemId = data.split(\":\")[1];\n const item = findItem(itemId);\n const session = await db.getSession(ctx.chat.id);\n\n if (!item) return ctx.answerCallbackQuery(\"Item not found.\");\n if (session.cart.length >= 2) {\n return ctx.answerCallbackQuery(t(\"cart_full\", lang), { show_alert: true });\n }\n\n const game = CATALOG.freefire.some((i) => i.id === itemId) ? \"freefire\" : \"pubg\";\n session.cart.push({ ...item, game });\n await db.updateSession(ctx.chat.id, { cart: session.cart });\n\n await ctx.answerCallbackQuery(t(\"item_added\", lang, { item: itemLabel(item, lang) }));\n await ctx.reply(cartText(session.cart, lang), { parse_mode: \"Markdown\", ...cartButtons(session.cart, lang) });\n return;\n }\n\n // View cart\n if (data === \"cart:view\") {\n const session = await db.getSession(ctx.chat.id);\n await ctx.answerCallbackQuery();\n await ctx.editMessageText(cartText(session.cart, lang), {\n parse_mode: \"Markdown\",\n ...cartButtons(session.cart, lang),\n });\n return;\n }\n\n // Clear cart\n if (data === \"cart:clear\") {\n await db.updateSession(ctx.chat.id, { cart: [] });\n await ctx.answerCallbackQuery(t(\"cart_cleared\", lang));\n await ctx.editMessageText(t(\"cart_empty\", lang), {\n parse_mode: \"Markdown\",\n ...cartButtons([], lang),\n });\n return;\n }\n\n // Checkout\n if (data === \"cart:checkout\") {\n const session = await db.getSession(ctx.chat.id);\n await ctx.answerCallbackQuery();\n\n if (session.cart.length === 0) {\n return ctx.reply(t(\"cart_empty_checkout\", lang));\n }\n\n const pendingGames = [...new Set(session.cart.map((i) => i.game))];\n await db.updateSession(ctx.chat.id, {\n step: \"awaiting_uid\",\n pending_games: pendingGames,\n uid_by_game: {},\n ign_by_game: {},\n });\n\n const nextGame = pendingGames[0];\n return ctx.reply(t(\"ask_uid\", lang, { game: gameLabel(nextGame, lang) }), {\n parse_mode: \"Markdown\",\n });\n }\n\n // Check status\n if (data.startsWith(\"status:check:\")) {\n const orderId = Number(data.split(\":\")[2]);\n const order = await db.getOrder(orderId);\n if (!order) return ctx.answerCallbackQuery(t(\"order_not_found\", lang), { show_alert: true });\n\n const messages: Record = {\n pending: t(\"status_pending\", lang),\n completed: t(\"status_completed\", lang),\n rejected: t(\"status_rejected\", lang),\n };\n return ctx.answerCallbackQuery(messages[order.status as string] || order.status, { show_alert: true });\n }\n\n // Admin approval\n if (data.startsWith(\"admin:approve:\")) {\n if (ctx.from!.id !== ADMIN_ID) return ctx.answerCallbackQuery(t(\"not_authorized\", \"en\"));\n const orderId = Number(data.split(\":\")[2]);\n const order = await db.getOrder(orderId);\n if (!order) return ctx.answerCallbackQuery(t(\"order_not_found\", \"en\"));\n\n await db.setStatus(orderId, \"completed\");\n await ctx.answerCallbackQuery(\"Order marked completed ✅\");\n const caption = `${ctx.callbackQuery.message?.caption || \"\"}\\n\\n✅ *COMPLETED*`;\n await ctx.editMessageCaption(caption, { parse_mode: \"Markdown\" });\n\n const custLang = await ensureLangForUser(order.telegram_id);\n await bot.api.sendMessage(order.telegram_id, t(\"order_completed\", custLang, { orderId }));\n return;\n }\n\n // Admin rejection\n if (data.startsWith(\"admin:reject:\")) {\n if (ctx.from!.id !== ADMIN_ID) return ctx.answerCallbackQuery(t(\"not_authorized\", \"en\"));\n const orderId = Number(data.split(\":\")[2]);\n const order = await db.getOrder(orderId);\n if (!order) return ctx.answerCallbackQuery(t(\"order_not_found\", \"en\"));\n\n await db.setStatus(orderId, \"rejected\");\n await ctx.answerCallbackQuery(\"Order rejected.\");\n const caption = `${ctx.callbackQuery.message?.caption || \"\"}\\n\\n❌ *REJECTED*`;\n await ctx.editMessageCaption(caption, { parse_mode: \"Markdown\" });\n\n const custLang = await ensureLangForUser(order.telegram_id);\n await bot.api.sendMessage(order.telegram_id, t(\"order_rejected\", custLang, { orderId }));\n return;\n }\n});\n\n// --- Text messages ---\n\nbot.on(\"message:text\", async (ctx) => {\n const lang = await ensureLang(ctx);\n const session = await db.getSession(ctx.chat.id);\n const text = ctx.message.text!.trim();\n\n if (session.step === \"awaiting_uid\") {\n const game = session.pending_games[0];\n if (!/^\\d{4,20}$/.test(text)) {\n return ctx.reply(t(\"invalid_uid\", lang));\n }\n\n await ctx.reply(t(\"verifying\", lang));\n const result = await lookupUID(game, text);\n session.uid_by_game[game] = text;\n\n if (result.verified) {\n session.ign_by_game[game] = { name: result.name, verified: true };\n await ctx.replyWithMarkdown(\n t(\"verified_found\", lang, { game: gameLabel(game, lang), name: result.name || \"\", uid: text }),\n );\n } else {\n session.ign_by_game[game] = { name: null, verified: false };\n await ctx.replyWithMarkdown(t(\"verify_failed\", lang, { uid: text }));\n }\n\n session.pending_games.shift();\n await db.updateSession(ctx.chat.id, {\n pending_games: session.pending_games,\n uid_by_game: session.uid_by_game,\n ign_by_game: session.ign_by_game,\n });\n\n if (session.pending_games.length > 0) {\n const next = session.pending_games[0];\n return ctx.reply(t(\"ask_uid\", lang, { game: gameLabel(next, lang) }), {\n parse_mode: \"Markdown\",\n });\n }\n\n await db.updateSession(ctx.chat.id, { step: \"awaiting_payer_name\" });\n return ctx.replyWithMarkdown(t(\"ask_payer_name\", lang));\n }\n\n if (session.step === \"awaiting_payer_name\") {\n await db.updateSession(ctx.chat.id, { payer_name: text, step: \"awaiting_phone\" });\n return ctx.reply(t(\"ask_phone\", lang));\n }\n\n if (session.step === \"awaiting_phone\") {\n await db.updateSession(ctx.chat.id, { phone: text, step: \"awaiting_screenshot\" });\n const total = cartTotal(session.cart);\n return ctx.replyWithMarkdown(\n t(\"payment_details\", lang, {\n telebirr: TELEBIRR_NUMBER,\n cbe: CBE_ACCOUNT_NUMBER,\n accountName: ACCOUNT_HOLDER_NAME,\n total: fmtETB(total),\n }),\n );\n }\n});\n\n// --- Photo (screenshot) ---\n\nbot.on(\"message:photo\", async (ctx) => {\n const lang = await ensureLang(ctx);\n const session = await db.getSession(ctx.chat.id);\n\n if (session.step !== \"awaiting_screenshot\") return;\n\n const fileId = ctx.message.photo![ctx.message.photo!.length - 1].file_id;\n const game = session.cart.length && session.cart.every((i) => i.game === session.cart[0].game)\n ? session.cart[0].game\n : \"mixed\";\n\n const orderId = await db.createOrder({\n telegram_id: ctx.from!.id,\n items_json: JSON.stringify(session.cart),\n total_etb: cartTotal(session.cart),\n total_usd: session.cart.reduce((s, i) => s + i.usd, 0),\n game,\n uid: JSON.stringify(session.uid_by_game),\n ign: JSON.stringify(session.ign_by_game),\n ign_verified: Object.values(session.ign_by_game).every((v: any) => v.verified) ? 1 : 0,\n payer_name: session.payer_name || \"\",\n phone: session.phone || \"\",\n });\n\n await db.attachScreenshot(orderId, fileId);\n\n const statusBtn = {\n reply_markup: {\n inline_keyboard: [[\n { text: t(\"check_status_btn\", lang), callback_data: `status:check:${orderId}` },\n ]],\n },\n };\n\n await ctx.reply(t(\"order_received\", lang, { orderId }), statusBtn);\n await notifyAdmin(ctx, orderId, session);\n await db.resetSession(ctx.chat.id, true);\n});\n\n// --- Admin notification ---\n\nasync function notifyAdmin(ctx: any, orderId: number, session: any) {\n const itemLines = session.cart.map((i: any) => `• ${i.label} — ${fmtETB(i.etb)}`).join(\"\\n\");\n const uidLines = Object.entries(session.uid_by_game)\n .map(([game, uid]: any) => {\n const ign = session.ign_by_game[game];\n const verifiedTag = ign.verified ? `✅ ${ign.name}` : \"⚠️ unverified, please confirm manually\";\n return `${gameLabel(game, \"en\")} UID: \\`${uid}\\` (${verifiedTag})`;\n })\n .join(\"\\n\");\n\n const caption =\n `🆕 *New Order #${orderId}*\\n\\n` +\n `${itemLines}\\n\\n` +\n `${uidLines}\\n\\n` +\n `💰 Total: *${fmtETB(cartTotal(session.cart))}*\\n` +\n `👤 Payer name: ${session.payer_name}\\n` +\n `📱 Phone: ${session.phone}\\n` +\n `👤 Telegram: @${ctx.from!.username || ctx.from!.id}`;\n\n const fileId = ctx.message.photo![ctx.message.photo!.length - 1].file_id;\n\n const sent = await bot.api.sendPhoto(ADMIN_ID, fileId, {\n caption,\n parse_mode: \"Markdown\",\n reply_markup: {\n inline_keyboard: [\n [{ text: \"✅ Approve & Complete Order\", callback_data: `admin:approve:${orderId}` }],\n [{ text: \"❌ Reject Order\", callback_data: `admin:reject:${orderId}` }],\n ],\n },\n });\n\n await db.attachAdminMessage(orderId, ADMIN_ID, sent.message_id);\n}\n\nasync function ensureLangForUser(telegramId: number): Promise {\n const user = await db.getUser(telegramId);\n return user?.language && SUPPORTED_LANGS.includes(user.language) ? user.language : \"en\";\n}\n\n// --- Webhook ---\n\nconst SECRET_TOKEN = TELEGRAM_TOKEN.split(\":\")[1];\nconst handleUpdate = webhookCallback(bot, \"std/http\", undefined, undefined, SECRET_TOKEN);\n\nlet isWebhookSet = false;\n\nexport default async (req: Request): Promise => {\n // Set webhook on first request\n if (!isWebhookSet) {\n const url = new URL(req.url);\n const webhookUrl = `${url.protocol}//${url.host}`;\n await bot.api.setWebhook(webhookUrl, { secret_token: SECRET_TOKEN });\n isWebhookSet = true;\n console.log(`✅ Webhook set to ${webhookUrl}`);\n }\n\n if (req.method === \"POST\") {\n return await handleUpdate(req);\n }\n\n return new Response(\"Abesha Pay Bot is running 🚀\", { status: 200 });\n};\n",[153],"01ad7a8b-9168-4c6d-b9f9-7688aa4cb253","i18n.ts","fc3d54ca-86eb-11f1-afb3-1607ee4eb77e",3,["D",1784848353157],"type StringDict = Record;\n\nconst STRINGS: Record = {\n en: {\n choose_language: \"🌐 Please choose your language:\",\n lang_changed: \"Language set to English 🇬🇧\",\n welcome:\n \"🌟✨💎 *Welcome to Abesha Pay!* 💎✨🌟\\n\\nYour ultimate, trusted destination for instant gaming top-ups right here in Ethiopia! 🇪🇹🔥\\n\\nPick a category below to get started 👇\",\n choose_category: \"Choose a category 👇\",\n cat_freefire: \"🎮 Free Fire Diamonds & Memberships\",\n cat_pubg: \"🎯 PUBG Mobile UC & Memberships\",\n catalog_prompt: \"{{game}} — pick an item to add to your cart 👇\",\n item_added: \"Added {{item}} ✅\",\n cart_full: \"⚠️ You can only choose up to 2 items per order!\",\n cart_empty: \"🛒 Your cart is empty.\",\n cart_title: \"🛒 *Your Cart*\",\n cart_total: \"*Total: {{etb}} ({{usd}})*\",\n cart_empty_checkout: \"Your cart is empty — add an item first! 🛒\",\n ask_uid: \"🔍 Please enter your *{{game}} UID (Player ID)*:\",\n invalid_uid: \"That doesn't look like a valid UID (numbers only). Please try again:\",\n verifying: \"🔎 Verifying your account, one moment...\",\n verified_found:\n \"✅ *{{game}}* account found:\\n👤 In-game name: *{{name}}*\\n🆔 UID: `{{uid}}`\\n\\nIf this is NOT your account, please re-check your UID before continuing.\",\n verify_failed:\n \"⚠️ We couldn't auto-verify this UID right now, so our team will manually confirm it before delivery.\\n🆔 UID on file: `{{uid}}`\\n\\nDouble-check it's correct — deliveries to the wrong UID can't be reversed.\",\n ask_payer_name: \"👤 What name did/will you use to *send the payment* (Telebirr/CBE account holder name)?\",\n ask_phone: \"📱 What phone number can we reach you on for this order?\",\n payment_details:\n \"💳 *Payment Details*\\n\\n📱 Telebirr: `{{telebirr}}`\\n🏦 CBE: `{{cbe}}`\\n👤 Account Name: *{{accountName}}*\\n\\n💰 *Amount to send: {{total}}*\\n\\n📸 Once sent, upload a screenshot of the payment receipt right here in the chat.\",\n order_received: \"🎉 Order #{{orderId}} received! Our team will verify your payment shortly.\",\n check_status_btn: \"🔄 Check Status\",\n order_completed:\n \"🎉🎮🎊 Great news! Your order #{{orderId}} has been delivered — your Diamonds/UC are now in your game account. Thanks for using Abesha Pay! 💎🇪🇹\",\n order_rejected:\n \"⚠️ Your order #{{orderId}} couldn't be verified and was rejected. Please contact support or re-check your payment screenshot.\",\n status_pending: \"⏳ Still pending review by our team.\",\n status_completed: \"✅ Completed! Your items have been delivered.\",\n status_rejected: \"❌ This order was rejected. Contact support for details.\",\n view_cart_btn: \"🛒 View Cart\",\n back_categories_btn: \"⬅️ Back to Categories\",\n continue_shopping_btn: \"⬅️ Continue Shopping\",\n checkout_btn: \"✅ Checkout\",\n clear_cart_btn: \"🗑 Clear Cart\",\n cart_cleared: \"Cart cleared 🗑\",\n order_not_found: \"Order not found.\",\n not_authorized: \"Not authorized.\",\n },\n am: {\n choose_language: \"🌐 እባክዎ ቋንቋ ይምረጡ:\",\n lang_changed: \"ቋንቋ ወደ አማርኛ ተቀናብሯል 🇪🇹\",\n welcome:\n \"🌟✨💎 *እንኳን ወደ አበሻ ፔይ በደህና መጡ!* 💎✨🌟\\n\\nበኢትዮጵያ ውስጥ ቀጥተኛ የጨዋታ ቶፕ-አፕ ለማድረግ የታመነ መዳረሻዎ! 🇪🇹🔥\\n\\nከታች ምድብ ይምረጡ 👇\",\n choose_category: \"ምድብ ይምረጡ 👇\",\n cat_freefire: \"🎮 ፍሪ ፋየር ዳይመንድ እና አባልነት\",\n cat_pubg: \"🎯 ፐብጂ ሞባይል ዩሲ እና አባልነት\",\n catalog_prompt: \"{{game}} — ወደ ጋሪዎ ለማከል ንጥል ይምረጡ 👇\",\n item_added: \"{{item}} ታክሏል ✅\",\n cart_full: \"⚠️ በአንድ ትዕዛዝ እስከ 2 ንጥሎች ብቻ መምረጥ ይችላሉ!\",\n cart_empty: \"🛒 ጋሪዎ ባዶ ነው።\",\n cart_title: \"🛒 *የእርስዎ ጋሪ*\",\n cart_total: \"*ጠቅላላ: {{etb}} ({{usd}})*\",\n cart_empty_checkout: \"ጋሪዎ ባዶ ነው — መጀመሪያ ንጥል ያክሉ! 🛒\",\n ask_uid: \"🔍 እባክዎ የ*{{game}} UID (የተጫዋች መታወቂያ)* ያስገቡ፡\",\n invalid_uid: \"ይህ ትክክለኛ UID አይመስልም (ቁጥሮች ብቻ)። እባክዎ እንደገና ይሞክሩ፡\",\n verifying: \"🔎 መለያዎን በማረጋገጥ ላይ፣ አንድ አፍታ ይጠብቁ...\",\n verified_found:\n \"✅ *{{game}}* መለያ ተገኝቷል፡\\n👤 የጨዋታ ስም፡ *{{name}}*\\n🆔 UID: `{{uid}}`\\n\\nይህ የእርስዎ መለያ ካልሆነ፣ እባክዎ ከመቀጠልዎ በፊት UID ዎን እንደገና ያረጋግጡ።\",\n verify_failed:\n \"⚠️ ይህን UID አሁን በራስ-ሰር ማረጋገጥ አልቻልንም፣ ስለዚህ ቡድናችን ከማድረስ በፊት በእጅ ያረጋግጣል።\\n🆔 የተመዘገበ UID፡ `{{uid}}`\\n\\nትክክል መሆኑን ያረጋግጡ — ወደ ስህተት UID የሚደረግ ማድረስ ሊቀለበስ አይችልም።\",\n ask_payer_name: \"👤 ክፍያውን *ለመላክ* የተጠቀሙበት/የሚጠቀሙበት ስም ማን ነው (የቴሌብር/የCBE መለያ ባለቤት ስም)?\",\n ask_phone: \"📱 ለዚህ ትዕዛዝ በየትኛው ስልክ ቁጥር ልናገኝዎት እንችላለን?\",\n payment_details:\n \"💳 *የክፍያ ዝርዝሮች*\\n\\n📱 ቴሌብር፡ `{{telebirr}}`\\n🏦 CBE፡ `{{cbe}}`\\n👤 የመለያ ስም፡ *{{accountName}}*\\n\\n💰 *የሚላክ መጠን፡ {{total}}*\\n\\n📸 ከላኩ በኋላ፣ የክፍያ ደረሰኝ ስክሪንሾት እዚሁ ቻት ውስጥ ይላኩ።\",\n order_received: \"🎉 ትዕዛዝ #{{orderId}} ደርሷል! ቡድናችን በቅርቡ ክፍያዎን ያረጋግጣል።\",\n check_status_btn: \"🔄 ሁኔታ ይመልከቱ\",\n order_completed:\n \"🎉🎮🎊 መልካም ዜና! ትዕዛዝ #{{orderId}} ደርሷል — ዳይመንዶች/UC አሁን በጨዋታ መለያዎ ውስጥ ናቸው። አበሻ ፔይን ስለተጠቀሙ እናመሰግናለን! 💎🇪🇹\",\n order_rejected:\n \"⚠️ ትዕዛዝ #{{orderId}} ማረጋገጥ አልተቻለም እና ውድቅ ተደርጓል። እባክዎ ድጋፍን ያግኙ ወይም የክፍያ ስክሪንሾትዎን እንደገና ያረጋግጡ።\",\n status_pending: \"⏳ ገና በቡድናችን በመገምገም ላይ ነው።\",\n status_completed: \"✅ ተጠናቅቋል! ንጥሎችዎ ደርሰዋል።\",\n status_rejected: \"❌ ይህ ትዕዛዝ ውድቅ ተደርጓል። ለዝርዝር ድጋፍን ያግኙ።\",\n view_cart_btn: \"🛒 ጋሪ ይመልከቱ\",\n back_categories_btn: \"⬅️ ወደ ምድቦች ተመለስ\",\n continue_shopping_btn: \"⬅️ ግዢ ይቀጥሉ\",\n checkout_btn: \"✅ ይክፈሉ\",\n clear_cart_btn: \"🗑 ጋሪ ያጽዱ\",\n cart_cleared: \"ጋሪ ጸድቷል 🗑\",\n order_not_found: \"ትዕዛዝ አልተገኘም።\",\n not_authorized: \"ፍቃድ የለዎትም።\",\n },\n};\n\nexport const SUPPORTED_LANGS = [\"en\", \"am\"];\n\nexport function t(key: string, lang: string, params: Record = {}): string {\n const dict = STRINGS[lang] || STRINGS.en;\n let str = dict[key] ?? STRINGS.en[key] ?? key;\n for (const [k, v] of Object.entries(params)) {\n str = str.replaceAll(`{{${k}}}`, String(v));\n }\n return str;\n}\n",[160],"ce930292-96e4-4da9-a8ff-990861aa4bca","db.ts","0c247b20-86ec-11f1-a9bc-1607ee4eb77e",4,["D",1784848379917],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Schema setup — idempotent so it's safe to run on every cold start.\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS users (\n telegram_id INTEGER PRIMARY KEY,\n username TEXT,\n language TEXT DEFAULT 'en',\n first_seen_at TEXT DEFAULT (datetime('now'))\n )\n`);\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n telegram_id INTEGER NOT NULL,\n items_json TEXT NOT NULL,\n total_etb REAL NOT NULL,\n total_usd REAL NOT NULL,\n game TEXT NOT NULL,\n uid TEXT,\n ign TEXT,\n ign_verified INTEGER DEFAULT 0,\n payer_name TEXT,\n phone TEXT,\n screenshot_file_id TEXT,\n admin_chat_id INTEGER,\n admin_message_id INTEGER,\n status TEXT NOT NULL DEFAULT 'pending',\n created_at TEXT DEFAULT (datetime('now')),\n updated_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (telegram_id) REFERENCES users(telegram_id)\n )\n`);\n\nawait sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_orders_telegram_id ON orders(telegram_id)`,\n);\nawait sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_orders_status ON orders(status)`,\n);\n\n// Sessions table — replaces the in-memory Map so checkout flow survives\n// across serverless invocations.\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sessions (\n chat_id INTEGER PRIMARY KEY,\n lang TEXT,\n cart TEXT DEFAULT '[]',\n step TEXT DEFAULT 'idle',\n pending_games TEXT DEFAULT '[]',\n uid_by_game TEXT DEFAULT '{}',\n ign_by_game TEXT DEFAULT '{}',\n payer_name TEXT,\n phone TEXT,\n updated_at TEXT DEFAULT (datetime('now'))\n )\n`);\n\n// --- Users ---\n\nexport async function upsertUser(telegramId: number, username: string | undefined) {\n await sqlite.execute({\n sql: `INSERT INTO users (telegram_id, username) VALUES (?, ?)\n ON CONFLICT(telegram_id) DO UPDATE SET username = excluded.username`,\n args: [telegramId, username || null],\n });\n}\n\nexport async function getUser(telegramId: number) {\n const result = await sqlite.execute({\n sql: `SELECT * FROM users WHERE telegram_id = ?`,\n args: [telegramId],\n });\n return result.rows[0] || null;\n}\n\nexport async function setLanguage(telegramId: number, language: string) {\n await sqlite.execute({\n sql: `UPDATE users SET language = ? WHERE telegram_id = ?`,\n args: [language, telegramId],\n });\n}\n\n// --- Orders ---\n\nexport interface OrderInput {\n telegram_id: number;\n items_json: string;\n total_etb: number;\n total_usd: number;\n game: string;\n uid: string;\n ign: string;\n ign_verified: number;\n payer_name: string;\n phone: string;\n}\n\nexport async function createOrder(order: OrderInput): Promise {\n const result = await sqlite.execute({\n sql: `INSERT INTO orders\n (telegram_id, items_json, total_etb, total_usd, game, uid, ign, ign_verified, payer_name, phone)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n order.telegram_id,\n order.items_json,\n order.total_etb,\n order.total_usd,\n order.game,\n order.uid,\n order.ign,\n order.ign_verified,\n order.payer_name,\n order.phone,\n ],\n });\n return Number(result.lastInsertRowid);\n}\n\nexport async function attachScreenshot(orderId: number, fileId: string) {\n await sqlite.execute({\n sql: `UPDATE orders SET screenshot_file_id = ?, updated_at = datetime('now') WHERE id = ?`,\n args: [fileId, orderId],\n });\n}\n\nexport async function attachAdminMessage(orderId: number, adminChatId: number, adminMessageId: number) {\n await sqlite.execute({\n sql: `UPDATE orders SET admin_chat_id = ?, admin_message_id = ?, updated_at = datetime('now') WHERE id = ?`,\n args: [adminChatId, adminMessageId, orderId],\n });\n}\n\nexport async function setStatus(orderId: number, status: string) {\n await sqlite.execute({\n sql: `UPDATE orders SET status = ?, updated_at = datetime('now') WHERE id = ?`,\n args: [status, orderId],\n });\n}\n\nexport async function getOrder(orderId: number) {\n const result = await sqlite.execute({\n sql: `SELECT * FROM orders WHERE id = ?`,\n args: [orderId],\n });\n return result.rows[0] || null;\n}\n\n// --- Sessions ---\n\nexport interface Session {\n chat_id: number;\n lang: string | null;\n cart: any[];\n step: string;\n pending_games: string[];\n uid_by_game: Record;\n ign_by_game: Record;\n payer_name: string | null;\n phone: string | null;\n}\n\nexport async function getSession(chatId: number): Promise {\n const result = await sqlite.execute({\n sql: `SELECT * FROM sessions WHERE chat_id = ?`,\n args: [chatId],\n });\n\n if (result.rows.length === 0) {\n // Create fresh session\n await sqlite.execute({\n sql: `INSERT INTO sessions (chat_id, lang, cart, step, pending_games, uid_by_game, ign_by_game, payer_name, phone)\n VALUES (?, NULL, '[]', 'idle', '[]', '{}', '{}', NULL, NULL)`,\n args: [chatId],\n });\n return {\n chat_id: chatId,\n lang: null,\n cart: [],\n step: \"idle\",\n pending_games: [],\n uid_by_game: {},\n ign_by_game: {},\n payer_name: null,\n phone: null,\n };\n }\n\n const row = result.rows[0] as any;\n return {\n chat_id: row.chat_id,\n lang: row.lang,\n cart: JSON.parse(row.cart || \"[]\"),\n step: row.step || \"idle\",\n pending_games: JSON.parse(row.pending_games || \"[]\"),\n uid_by_game: JSON.parse(row.uid_by_game || \"{}\"),\n ign_by_game: JSON.parse(row.ign_by_game || \"{}\"),\n payer_name: row.payer_name,\n phone: row.phone,\n };\n}\n\nexport async function updateSession(chatId: number, updates: Partial) {\n const fields: string[] = [];\n const args: any[] = [];\n\n const fieldMap: Record [string, any]> = {\n lang: (v) => [\"lang\", v],\n step: (v) => [\"step\", v],\n payer_name: (v) => [\"payer_name\", v],\n phone: (v) => [\"phone\", v],\n cart: (v) => [\"cart\", JSON.stringify(v)],\n pending_games: (v) => [\"pending_games\", JSON.stringify(v)],\n uid_by_game: (v) => [\"uid_by_game\", JSON.stringify(v)],\n ign_by_game: (v) => [\"ign_by_game\", JSON.stringify(v)],\n };\n\n for (const [key, value] of Object.entries(updates)) {\n if (fieldMap[key]) {\n const [col, val] = fieldMap[key](value);\n fields.push(`${col} = ?`);\n args.push(val);\n }\n }\n\n if (fields.length === 0) return;\n\n fields.push(`updated_at = datetime('now')`);\n args.push(chatId);\n\n await sqlite.execute({\n sql: `UPDATE sessions SET ${fields.join(\", \")} WHERE chat_id = ?`,\n args,\n });\n}\n\nexport async function resetSession(chatId: number, keepLang: boolean) {\n const lang = keepLang\n ? (await sqlite.execute({ sql: `SELECT lang FROM sessions WHERE chat_id = ?`, args: [chatId] })).rows[0]?.lang\n : null;\n\n await sqlite.execute({\n sql: `INSERT INTO sessions (chat_id, lang, cart, step, pending_games, uid_by_game, ign_by_game, payer_name, phone)\n VALUES (?, ?, '[]', 'idle', '[]', '{}', '{}', NULL, NULL)\n ON CONFLICT(chat_id) DO UPDATE SET\n lang = excluded.lang, cart = '[]', step = 'idle',\n pending_games = '[]', uid_by_game = '{}', ign_by_game = '{}',\n payer_name = NULL, phone = NULL, updated_at = datetime('now')`,\n args: [chatId, lang],\n });\n}\n",[167],"19fb5917-d5da-477e-9779-613c0718562f","catalog.ts","fc36a396-86eb-11f1-b8ca-1607ee4eb77e",2,["D",1784848353145],"// Catalog is intentionally plain data so prices can be edited without\n// touching bot logic. Amounts are stored in ETB; USD is display-only.\n// `label` is shown in English, `am_label` in Amharic.\n\ninterface CatalogItem {\n id: string;\n label: string;\n am_label: string;\n etb: number;\n usd: number;\n}\n\nconst FREEFIRE: CatalogItem[] = [\n { id: \"ff_110\", label: \"💎 110 Diamonds\", am_label: \"💎 110 ዳይመንድ\", etb: 210, usd: 1.02 },\n { id: \"ff_331\", label: \"💎 331 Diamonds\", am_label: \"💎 331 ዳይመንድ\", etb: 580, usd: 2.59 },\n { id: \"ff_583\", label: \"💎 583 Diamonds\", am_label: \"💎 583 ዳይመንድ\", etb: 970, usd: 4.25 },\n { id: \"ff_1166\", label: \"💎 1,166 Diamonds\", am_label: \"💎 1,166 ዳይመንድ\", etb: 1960, usd: 8.13 },\n { id: \"ff_2218\", label: \"💎 2,218 Diamonds\", am_label: \"💎 2,218 ዳይመንድ\", etb: 3417, usd: 17.03 },\n { id: \"ff_6160\", label: \"💎 6,160 Diamonds\", am_label: \"💎 6,160 ዳይመንድ\", etb: 8000, usd: 40.52 },\n];\n\nconst PUBG: CatalogItem[] = [\n { id: \"pubg_60\", label: \"🪙 60 UC\", am_label: \"🪙 60 ዩሲ\", etb: 166, usd: 0.89 },\n { id: \"pubg_325\", label: \"🪙 325 UC (300 + 25 bonus)\", am_label: \"🪙 325 ዩሲ (300 + 25 ጉርሻ)\", etb: 837, usd: 4.49 },\n { id: \"pubg_660\", label: \"🪙 660 UC (600 + 60 bonus)\", am_label: \"🪙 660 ዩሲ (600 + 60 ጉርሻ)\", etb: 1677, usd: 8.99 },\n { id: \"pubg_1800\", label: \"🪙 1,800 UC (1500 + 300 bonus)\", am_label: \"🪙 1,800 ዩሲ (1500 + 300 ጉርሻ)\", etb: 4194, usd: 22.49 },\n { id: \"pubg_3850\", label: \"🪙 3,850 UC (3000 + 850 bonus)\", am_label: \"🪙 3,850 ዩሲ (3000 + 850 ጉርሻ)\", etb: 8391, usd: 44.99 },\n { id: \"pubg_8100\", label: \"🪙 8,100 UC (6000 + 2100 bonus)\", am_label: \"🪙 8,100 ዩሲ (6000 + 2100 ጉርሻ)\", etb: 16783, usd: 89.99 },\n];\n\nexport const CATALOG: Record = {\n freefire: FREEFIRE,\n pubg: PUBG,\n};\n\nexport function findItem(itemId: string): CatalogItem | null {\n return FREEFIRE.find((i) => i.id === itemId) || PUBG.find((i) => i.id === itemId) || null;\n}\n\nexport function itemLabel(item: CatalogItem, lang: string): string {\n return lang === \"am\" ? item.am_label : item.label;\n}\n\nexport function gameLabel(game: string, lang: string): string {\n if (lang === \"am\") return game === \"freefire\" ? \"🎮 ፍሪ ፋየር\" : \"🎯 ፐብጂ ሞባይል\";\n return game === \"freefire\" ? \"🎮 Free Fire\" : \"🎯 PUBG Mobile\";\n}\n",[174],"0911c7fd-37d5-4bed-9a75-081d7eb8c6ac",["D",1784849305125],[33],"8b5203b4-a821-497d-a2c2-afad3a340a3d","README.md","77a2ad94-86ed-11f1-a647-1607ee4eb77e",7,["D",1784848989757],"# Abesha Pay — Telegram Top-Up Bot (Val Town Edition)\n\nA serverless Telegram bot for selling **Free Fire Diamonds** and **PUBG Mobile UC** to Ethiopian customers via **Telebirr/CBE** payment with manual admin approval.\n\n**Ported from Node.js + Telegraf → Deno + grammY + Val Town's serverless runtime**\n\n## Quick Setup\n\n### 1. Set your Telegram Bot Token\nYou already have `TELEGRAM_API_TOKEN` set. If not:\n\n👉 Add TELEGRAM_API_TOKEN here: \n\nGet it from [@BotFather](https://t.me/BotFather).\n\n### 2. Set your Admin Telegram ID\nYour numeric ID (get from [@userinfobot](https://t.me/userinfobot)):\n\n👉 Add ADMIN_TELEGRAM_ID here: \n\nReplace `0` with your actual ID (e.g., `123456789`).\n\n### 3. Set Payment Details\nUpdate these with your actual accounts:\n\n👉 Add TELEBIRR_NUMBER here: \n\n👉 Add CBE_ACCOUNT_NUMBER here: \n\n👉 Add ACCOUNT_HOLDER_NAME here: \n\n### 4. Optional: UID Verification APIs\nTo auto-verify Free Fire / PUBG UIDs (optional — defaults to manual verification):\n\n👉 Add FREEFIRE_LOOKUP_URL here: \n\n👉 Add PUBG_LOOKUP_URL here: \n\nIf you don't set these, the bot will flag UIDs as \"⚠️ unverified, please confirm manually\" in the admin panel.\n\n## How It Works\n\n### Customer Flow\n1. **Start** → pick language (English 🇬🇧 / Amharic 🇪🇹)\n2. **Category** → Free Fire or PUBG\n3. **Catalog** → add up to 2 items to cart\n4. **Checkout** → enter UID for each game → auto-verified or flagged for manual check\n5. **Payment info** → payer name + phone\n6. **Screenshot** → upload payment receipt\n7. **Order created** → customer gets order #, can check status anytime with `/status`\n\n### Admin Flow\n- Receives every order as a **photo** with full details: items, UIDs, total, payer name, phone\n- **Two buttons**: ✅ Approve & Complete / ❌ Reject\n- Customer receives notification (in their language) when order is completed or rejected\n\n## Database\n\nVal Town's **SQLite** (project-scoped) stores:\n- **users** — Telegram ID, username, language preference\n- **orders** — cart, UIDs, payment details, status\n- **sessions** — checkout state (persists across serverless invocations)\n\nNo persistent in-memory state — all checkout progress is saved to the database so restarts don't interrupt customers.\n\n## Differences from Node.js version\n\n| Node.js (original) | Val Town (Deno) |\n|---|---|\n| Telegraf | grammY |\n| `better-sqlite3` (sync) | `std/sqlite` (async) |\n| Long polling (`bot.launch()`) | Webhook via HTTP handler |\n| In-memory `Map` for sessions | SQLite `sessions` table |\n| `require()` | ES modules + `https://` imports |\n| `.env` file | Deno.env + Val Town UI |\n\n## Files\n\n- **index.ts** — main HTTP handler, all Telegram callbacks, webhook setup\n- **catalog.ts** — Free Fire & PUBG items (prices in ETB)\n- **i18n.ts** — English & Amharic strings, templating\n- **lookupService.ts** — optional UID lookup (Free Fire / PUBG)\n- **db.ts** — SQLite schema + query helpers\n\n## Webhook\n\nOn first request to the HTTP endpoint, the bot automatically sets the Telegram webhook to your val's URL. No manual setup needed — **just save your Telegram token and you're live.**\n\n## Next Steps\n\n- [ ] Set `ADMIN_TELEGRAM_ID` to your numeric ID\n- [ ] Update `TELEBIRR_NUMBER`, `CBE_ACCOUNT_NUMBER`, `ACCOUNT_HOLDER_NAME`\n- [ ] (Optional) Add `FREEFIRE_LOOKUP_URL` and `PUBG_LOOKUP_URL` for auto-verification\n- [ ] Test: message your bot `/start` and go through the flow\n- [ ] Edit prices in `catalog.ts` anytime (live redeployment)\n\n## Docs\n\n- [grammY](https://grammy.dev) — Telegram bot framework for Deno\n- [Val Town SQLite](https://docs.val.town/guide#sqlite)\n- [Telegram Bot API](https://core.telegram.org/bots/api)\n",[184],"pulls","branches","forks","envVars",{"_197":199,"_200":169},"connections",{"_197":66,"_198":66},"count","unfilledCount",10,"emptyCount",{"_46":183,"_37":184,"_35":185,"_144":-5,"_44":45,"_43":186,"_146":62,"_41":227,"_13":66,"_38":26,"_39":188,"_29":30,"_150":-5,"_209":228,"_32":229},{"_46":180,"_37":33,"_35":36,"_144":-5,"_44":45,"_43":14,"_146":62,"_41":224,"_13":66,"_38":26,"_39":40,"_29":30,"_150":-5,"_209":225,"_32":226},{"_46":173,"_37":174,"_35":175,"_144":-5,"_44":45,"_43":176,"_146":30,"_41":221,"_13":66,"_38":148,"_39":178,"_29":30,"_150":-5,"_209":222,"_32":223},{"_46":166,"_37":167,"_35":168,"_144":-5,"_44":45,"_43":169,"_146":62,"_41":218,"_13":66,"_38":148,"_39":171,"_29":30,"_150":-5,"_209":219,"_32":220},{"_46":159,"_37":160,"_35":161,"_144":-5,"_44":45,"_43":162,"_146":30,"_41":215,"_13":66,"_38":148,"_39":164,"_29":30,"_150":-5,"_209":216,"_32":217},{"_46":152,"_37":153,"_35":60,"_144":-5,"_44":45,"_43":154,"_146":30,"_41":212,"_13":145,"_38":156,"_39":157,"_29":30,"_150":-5,"_209":213,"_32":214},{"_46":141,"_37":142,"_35":143,"_144":-5,"_44":45,"_43":145,"_146":30,"_41":208,"_13":66,"_38":148,"_39":149,"_29":30,"_150":-5,"_209":210,"_32":211},["D",1784848353136],"children",[],[142],["D",1784848970682],[],[153],["D",1784848353157],[],[160],["D",1784848379917],[],[167],["D",1784848353145],[],[174],["D",1784849305125],[],[33],["D",1784848989757],[],[184],["D",1784848208980],["D",1789474235934],{"_103":102,"_111":107},{"_103":102,"_104":105,"_106":107,"_19":58,"_108":109,"_110":30},{"_13":92,"_37":93,"_46":45,"_94":47,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":48,"_101":102},"ctx",{"_85":-5,"_131":268,"_269":270,"_271":272,"_273":30,"_274":30,"_275":30,"_276":62,"_277":-5,"_278":-7,"_279":-7,"_280":66,"_281":30,"_282":30,"_283":-5,"_284":30,"_285":30,"_286":30,"_287":-5},"ENV",{"_239":240,"_241":242,"_243":93,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267},"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 · v8