$1

')\n // Inline code: `text`\n .replace(/`([^`]+)`/g, '$1')\n // Strikethrough: ~~text~~\n .replace(/~~(.*?)~~/g, '$1')\n // Links: [text](url)\n .replace(/\\[([^\\]]+)\\]\$([^)]+)\$/g, '$1')\n // Headers: # text\n .replace(/^#+ (.*?)$/gm, '$1')\n // Bullet points\n .replace(/^(\\s*)[-*+]\\s+(.*)$/gm, '$1• $2');\n}\n\nexport async function sendTelegramMessage(chatId: string, text: string, messageThreadId?: number) {\n const token = Deno.env.get(\"TELEGRAM_TOKEN\");\n if (!token) return;\n \n const formattedText = formatToTelegramHTML(text);\n const payload: any = { \n chat_id: chatId, \n text: formattedText,\n parse_mode: \"HTML\"\n };\n if (messageThreadId) {\n payload.message_thread_id = messageThreadId;\n }\n\n await fetch(`https://api.telegram.org/bot${token}/sendMessage`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(payload),\n });\n}\n",[],[155,184],["D",1785170009508],[],[155,63],"9fe24555-0d94-4a8a-a52e-c078cafbbb6e","db.ts","e7565698-89d8-11f1-84e0-1607ee4eb77e",["D",1785170011223],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface WhitelistedGroup {\n chat_id: string;\n name: string;\n environment_id: string | null;\n last_interaction_id: string | null;\n}\n\nexport interface UsageStat {\n date: string;\n messages_processed: number;\n}\n\nexport async function ensureSchema() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS whitelisted_groups (\n chat_id TEXT PRIMARY KEY,\n name TEXT,\n environment_id TEXT\n )\n `);\n try {\n await sqlite.execute(\"ALTER TABLE whitelisted_groups ADD COLUMN last_interaction_id TEXT\");\n } catch (e) {\n // Ignore if column already exists\n }\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS usage_stats (\n date TEXT PRIMARY KEY,\n messages_processed INTEGER DEFAULT 0\n )\n `);\n}\n\nexport async function getWhitelistedGroups(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM whitelisted_groups\");\n return result.rows as unknown as WhitelistedGroup[];\n}\n\nexport async function addWhitelistedGroup(chatId: string, name: string) {\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO whitelisted_groups (chat_id, name) VALUES (?, ?)\",\n args: [chatId, name]\n });\n}\n\nexport async function removeWhitelistedGroup(chatId: string) {\n await sqlite.execute({\n sql: \"DELETE FROM whitelisted_groups WHERE chat_id = ?\",\n args: [chatId]\n });\n}\n\nexport async function getGroup(chatId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM whitelisted_groups WHERE chat_id = ?\",\n args: [chatId]\n });\n if (result.rows.length === 0) return null;\n return result.rows[0] as unknown as WhitelistedGroup;\n}\n\nexport async function updateGroupInteraction(chatId: string, envId?: string | null, interactionId?: string | null) {\n await sqlite.execute({\n sql: \"UPDATE whitelisted_groups SET environment_id = ?, last_interaction_id = ? WHERE chat_id = ?\",\n args: [envId || null, interactionId || null, chatId]\n });\n}\n\nexport async function getRecentStats(limit: number = 5): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM usage_stats ORDER BY date DESC LIMIT ?\",\n args: [limit]\n });\n return result.rows as unknown as UsageStat[];\n}\n",[],[155,195],"004c0ece-9d4a-4697-b52d-d3e2cd6b6ef7",["D",1785170009508],"directory",[169,170,171],[155],["D",1785073665166],["D",1789473745358],{"_11":12,"_124":69},{"_11":12,"_119":120,"_68":69,"_30":67,"_121":122,"_123":24},{"_38":110,"_13":16,"_32":35,"_111":71,"_112":-5,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":14,"_118":12},"ctx",{"_51":-5,"_143":244,"_245":246,"_247":248,"_249":24,"_250":24,"_251":24,"_252":84,"_253":-5,"_254":-7,"_255":-7,"_256":26,"_257":24,"_258":24,"_259":-5,"_260":24,"_261":24,"_262":24,"_263":-5},"ENV",{"_215":216,"_217":218,"_219":16,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243},"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"]

History · gemini.ts