(?:<!\\[CDATA\\[)?([\\s\\S]*?)(?:\\]\\]>)?<\\/title>/)?.[1]?.trim() ?? \"\";\n const link = block.match(/<link>([\\s\\S]*?)<\\/link>/)?.[1]?.trim() ?? \"\";\n const pubDateStr = block.match(/<pubDate>([\\s\\S]*?)<\\/pubDate>/)?.[1]?.trim() ?? \"\";\n const sourceName = block.match(/<source[^>]*>([\\s\\S]*?)<\\/source>/)?.[1]?.trim() ?? \"\";\n const description = block.match(/<description>(?:<!\\[CDATA\\[)?([\\s\\S]*?)(?:\\]\\]>)?<\\/description>/)?.[1]?.trim() ?? \"\";\n\n // Strip HTML from description\n const snippet = description.replace(/<[^>]+>/g, \"\").trim();\n\n const pubDate = pubDateStr ? new Date(pubDateStr) : new Date();\n\n if (title && link) {\n items.push({\n title: decodeEntities(title),\n url: link,\n source: sourceName || \"Google News\",\n pubDate,\n snippet: decodeEntities(snippet).slice(0, 300),\n });\n }\n }\n\n return items;\n}\n\nfunction decodeEntities(text: string): string {\n return text\n .replace(/&/g, \"&\")\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/"/g, '\"')\n .replace(/'/g, \"'\")\n .replace(/'/g, \"'\");\n}\n\n/** Build Google News RSS query for UAE disasters */\nfunction buildRSSUrl(): string {\n const location = encodeURIComponent(\n '(\"Dubai\" OR \"UAE\" OR \"United Arab Emirates\" OR \"Abu Dhabi\" OR \"Sharjah\" OR \"Al Ain\")',\n );\n const disasters = encodeURIComponent(\n '(disaster OR emergency OR crisis OR outbreak OR epidemic OR pandemic OR attack OR explosion OR earthquake OR flood OR fire OR evacuation OR \"security alert\" OR \"security warning\" OR war OR missile OR conflict OR bombing OR \"chemical spill\" OR contamination OR casualties OR killed OR injured OR \"state of emergency\" OR lockdown OR curfew OR \"air strike\" OR \"drone strike\" OR shelling OR rocket OR terror OR kidnapping OR hostage)',\n );\n const exclude = encodeURIComponent(\n \"-sports -football -cricket -golf -tennis -movie -film -celebrity -entertainment -fashion -restaurant -recipe -travel -tourism -property -\" +\n '\"real estate\" -\"stock market\" -crypto -bitcoin -gaming -esports -concert -festival -exhibition',\n );\n\n return `https://news.google.com/rss/search?q=${location}+AND+${disasters}+${exclude}&hl=en&gl=AE&ceid=AE:en`;\n}\n\n/** Fetch latest disaster news for Dubai/UAE */\nexport async function fetchDisasterNews(): Promise<NewsItem[]> {\n const url = buildRSSUrl();\n console.log(`Fetching news from: ${url}`);\n\n const res = await fetch(url, {\n headers: { \"User-Agent\": \"DubaiDisasterAlerts/1.0\" },\n });\n\n if (!res.ok) {\n console.error(`RSS fetch failed: ${res.status}`);\n return [];\n }\n\n const xml = await res.text();\n const items = parseXML(xml);\n console.log(`Parsed ${items.length} RSS items`);\n\n // Filter to only relevant disaster alerts\n const relevant = items.filter(isRelevantAlert);\n\n // Sort by severity (highest first)\n relevant.sort((a, b) => getSeverity(b) - getSeverity(a));\n\n console.log(`${relevant.length} items passed relevance filter`);\n return relevant;\n}\n",[],[155,200],"51302463-47dd-40a1-a604-038bba9daf95","db.ts","89c484e4-85ca-11f1-9ed2-1607ee4eb77e",["D",1784724036590],"// SQLite helpers for deduplication and settings\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface SentAlert {\n url: string;\n title: string;\n sent_at: string;\n}\n\nexport async function initDB() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sent_alerts (\n url TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n source TEXT,\n sent_at TEXT NOT NULL\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS settings (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )\n `);\n}\n\n/** Check if we've already sent an alert for this URL */\nexport async function isAlreadySent(url: string): Promise<boolean> {\n const result = await sqlite.execute({\n sql: \"SELECT 1 FROM sent_alerts WHERE url = ?\",\n args: [url],\n });\n return result.rows.length > 0;\n}\n\n/** Record a sent alert */\nexport async function recordAlert(\n url: string,\n title: string,\n source: string,\n): Promise<void> {\n await sqlite.execute({\n sql:\n \"INSERT OR IGNORE INTO sent_alerts (url, title, source, sent_at) VALUES (?, ?, ?, ?)\",\n args: [url, title, source, new Date().toISOString()],\n });\n}\n\n/** Get a setting value */\nexport async function getSetting(key: string): Promise<string | null> {\n const result = await sqlite.execute({\n sql: \"SELECT value FROM settings WHERE key = ?\",\n args: [key],\n });\n return result.rows[0]?.value ?? null;\n}\n\n/** Set a setting value */\nexport async function setSetting(key: string, value: string): Promise<void> {\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO settings (key, value) VALUES (?, ?)\",\n args: [key, value],\n });\n}\n\n/** Get the Telegram chat ID (stored when user first messages the bot) */\nexport async function getChatId(): Promise<string | null> {\n return await getSetting(\"telegram_chat_id\");\n}\n\n/** Clean up alerts older than 30 days */\nexport async function cleanupOldAlerts(): Promise<void> {\n const cutoff = new Date();\n cutoff.setDate(cutoff.getDate() - 30);\n await sqlite.execute({\n sql: \"DELETE FROM sent_alerts WHERE sent_at < ?\",\n args: [cutoff.toISOString()],\n });\n}\n",[],[155,208],["D",1784723989388],[172,173,174],[155],["D",1784723916048],["D",1789473046147],{"_16":17,"_86":81},{"_16":17,"_80":81,"_82":81,"_33":34,"_83":84,"_85":26},{"_68":69,"_20":70,"_18":71,"_72":19,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":-5,"_78":21,"_79":17},"ctx",{"_61":-5,"_106":255,"_256":257,"_258":259,"_260":26,"_261":26,"_262":26,"_263":38,"_264":-5,"_265":-7,"_266":-7,"_267":42,"_268":26,"_269":26,"_270":-5,"_271":26,"_272":26,"_273":26,"_274":-5},"ENV",{"_226":227,"_228":229,"_230":70,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"] </article></body></html>

Search