🌍 Global Affiliate Deal Finder

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_234":235,"_236":237},"routes/_app.x.$handle.$name",{"_104":103,"_37":49,"_112":94,"_32":106,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_26":-5,"_123":-5,"_124":-5,"_125":30,"_126":127,"_128":63,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":30},"version",8,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","ddc088b2-6671-42ee-820b-3c015788b096","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","crypto-scrapers.ts","latestPath","fileId","de6ecc68-878f-11f1-a1f9-1607ee4eb77e","name","fileType","script","content","// 💰 Crypto Opportunity Finder — Free Airdrops, Faucets, Bounties\n// بغیر API کے — RSS اور Public Data سے\n\nexport interface CryptoOpportunity {\n title: string;\n description: string;\n url: string;\n source: string;\n type: string; // airdrop, faucet, bounty, staking, learn-to-earn\n reward: string;\n token: string; // USDT, BNB, ETH, etc.\n status: string;\n deadline: string;\n}\n\n// Crypto RSS/Feed Sources — بغیر API Key\nexport const CRYPTO_SOURCES = [\n {\n name: \"AirdropAlert\",\n url: \"https://airdropalert.com/feed/\",\n category: \"airdrop\",\n },\n {\n name: \"CoinMarketCap Blog\",\n url: \"https://blog.coinmarketcap.com/feed/\",\n category: \"crypto-news\",\n },\n {\n name: \"Binance Blog\",\n url: \"https://www.binance.com/en/blog/rss\",\n category: \"exchange\",\n },\n {\n name: \"CoinTelegraph\",\n url: \"https://cointelegraph.com/rss\",\n category: \"crypto-news\",\n },\n {\n name: \"CryptoSlate\",\n url: \"https://cryptoslate.com/feed/\",\n category: \"crypto-news\",\n },\n {\n name: \"Decrypt\",\n url: \"https://decrypt.co/feed\",\n category: \"crypto-news\",\n },\n {\n name: \"The Defiant\",\n url: \"https://thedefiant.io/api/feed\",\n category: \"defi\",\n },\n {\n name: \"Airdrops.io\",\n url: \"https://airdrops.io/feed/\",\n category: \"airdrop\",\n },\n];\n\nfunction parseCryptoFeed(xml: string, sourceName: string, category: string): CryptoOpportunity[] {\n const opportunities: CryptoOpportunity[] = [];\n let items = xml.match(//gi) || [];\n if (items.length === 0) {\n items = xml.match(//gi) || [];\n }\n\n for (const item of items.slice(0, 15)) {\n const title = extractTag(item, \"title\");\n let link = extractTag(item, \"link\");\n if (!link) {\n const linkMatch = item.match(/]*href=\"([^\"]+)\"/i);\n link = linkMatch ? linkMatch[1] : \"\";\n }\n const description = stripHtml(\n extractTag(item, \"description\") ||\n extractTag(item, \"summary\") ||\n extractTag(item, \"content\")\n );\n\n // Reward extract\n const rewardMatch = description.match(/\\$[\\d,.]+|[\\d,.]+\\s*(USDT|BNB|ETH|BTC|SOL|USDC|MATIC)/i);\n const reward = rewardMatch ? rewardMatch[0] : \"\";\n\n // Token type detect\n let token = \"Unknown\";\n const tokenMatch = description.match(/USDT|BNB|ETH|BTC|SOL|USDC|MATIC|ADA|DOT|AVAX/i);\n if (tokenMatch) token = tokenMatch[0].toUpperCase();\n if (title.match(/USDT/i)) token = \"USDT\";\n if (title.match(/BNB/i)) token = \"BNB\";\n\n // Type detect\n let type = category;\n if (title.match(/airdrop/i)) type = \"airdrop\";\n else if (title.match(/faucet|free/i)) type = \"faucet\";\n else if (title.match(/bounty|campaign/i)) type = \"bounty\";\n else if (title.match(/staking|yield/i)) type = \"staking\";\n else if (title.match(/learn|earn/i)) type = \"learn-to-earn\";\n else if (title.match(/referral|affiliate/i)) type = \"referral\";\n\n if (title && link) {\n opportunities.push({\n title: decodeEntities(title.trim()),\n description: decodeEntities(description.substring(0, 500)),\n url: link.trim(),\n source: sourceName,\n type,\n reward,\n token,\n status: \"active\",\n deadline: \"\",\n });\n }\n }\n\n return opportunities;\n}\n\nfunction extractTag(xml: string, tag: string): string {\n const regex = new RegExp(`<${tag}[^>]*>([\\\\s\\\\S]*?)`, \"i\");\n const match = xml.match(regex);\n return match ? match[1].trim() : \"\";\n}\n\nfunction stripHtml(html: string): string {\n return html.replace(/<[^>]*>/g, \"\").trim();\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 .replace(/’/g, \"'\")\n .replace(/–/g, \"-\")\n .replace(/—/g, \"—\")\n .replace(/…/g, \"...\")\n .replace(//g, \"$1\");\n}\n\nexport async function scrapeCryptoOpportunities(): Promise<{\n opportunities: CryptoOpportunity[];\n errors: number;\n sourcesChecked: number;\n}> {\n const allOps: CryptoOpportunity[] = [];\n let errors = 0;\n let sourcesChecked = 0;\n\n for (const source of CRYPTO_SOURCES) {\n try {\n console.log(`📡 Crypto Scraping: ${source.name}...`);\n const response = await fetch(source.url, {\n headers: {\n \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36\",\n \"Accept\": \"application/rss+xml, application/xml, text/xml, */*\",\n },\n signal: AbortSignal.timeout(15000),\n });\n\n if (!response.ok) {\n console.log(`❌ ${source.name}: HTTP ${response.status}`);\n errors++;\n continue;\n }\n\n const xml = await response.text();\n const ops = parseCryptoFeed(xml, source.name, source.category);\n console.log(`✅ ${source.name}: ${ops.length} opportunities found`);\n allOps.push(...ops);\n sourcesChecked++;\n\n await new Promise((r) => setTimeout(r, 500));\n } catch (err) {\n console.log(`❌ ${source.name}: ${err.message}`);\n errors++;\n }\n }\n\n return { opportunities: allOps, errors, sourcesChecked };\n}\n\n// 💰 Wallet Balance Checker — BNB Smart Chain (BSC)\n// BSC Public RPC — بغیر API Key کے\nexport async function checkWalletBalance(walletAddress: string): Promise<{\n bnb: string;\n usdt: string;\n rawBnb: string;\n rawUsdt: string;\n}> {\n const BSC_RPC = \"https://bsc-dataseed.binance.org/\";\n // USDT BEP-20 contract on BSC\n const USDT_CONTRACT = \"0x55d398326f99059fF775485246999027B3197955\";\n\n try {\n // Get BNB balance\n const bnbResponse = await fetch(BSC_RPC, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n jsonrpc: \"2.0\",\n id: 1,\n method: \"eth_getBalance\",\n params: [walletAddress, \"latest\"],\n }),\n signal: AbortSignal.timeout(10000),\n });\n\n const bnbData = await bnbResponse.json();\n const bnbBalanceWei = BigInt(bnbData.result || \"0x0\");\n const bnbBalance = Number(bnbBalanceWei) / 1e18;\n\n // Get USDT balance (BEP-20)\n // balanceOf(address) function selector = 0x70a08231\n const paddedAddress = walletAddress.slice(2).padStart(64, \"0\");\n const data = \"0x70a08231\" + paddedAddress;\n\n const usdtResponse = await fetch(BSC_RPC, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n jsonrpc: \"2.0\",\n id: 2,\n method: \"eth_call\",\n params: [{ to: USDT_CONTRACT, data: data }, \"latest\"],\n }),\n signal: AbortSignal.timeout(10000),\n });\n\n const usdtData = await usdtResponse.json();\n const usdtBalanceRaw = BigInt(usdtData.result || \"0x0\");\n // USDT BEP-20 has 18 decimals on BSC\n const usdtBalance = Number(usdtBalanceRaw) / 1e18;\n\n return {\n bnb: bnbBalance.toFixed(6),\n usdt: usdtBalance.toFixed(2),\n rawBnb: bnbBalanceWei.toString(),\n rawUsdt: usdtBalanceRaw.toString(),\n };\n } catch (err) {\n console.log(`❌ Wallet check error: ${err.message}`);\n return { bnb: \"0\", usdt: \"0\", rawBnb: \"0\", rawUsdt: \"0\" };\n }\n}\n","createdAt",["D",1784918740695],"branchVersion","branchId","6b8332b7-117d-4c25-bf60-8c48b69ffc60","id","c806ed07-faf1-4af9-9e30-6b79e0dc614b","global-affiliate-deal-finder",["D",1784917989098],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Auto-scraper for global deals + AI content + affiliate links","imageUrl","373cd038-b8d7-4eb5-ae04-9f65f34aee8d","pinnedFileId","9d9c396a-878e-11f1-af20-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f9558-4591-760c-9e10-b75a1c16178a","tursoName","c806ed07faf14af99e306b79e0dc614b","tursoHostname","c806ed07faf14af99e306b79e0dc614b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789473046147],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_111":106},"org",{"_104":103,"_105":106,"_107":106,"_19":59,"_108":109,"_110":30},"branch",{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"isOwned",22,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","niyib14872","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_47":48,"_37":49,"_42":229,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":230,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":231,"_88":232,"_90":233,"_92":30},"tree",[200,201,202,203,204,205,206],"files",[200,201,202,203,204,205,206],"counts",{"_190":67,"_191":147,"_192":67,"_193":194,"_195":196},"contents",[133,134,135,136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":183,"_37":184,"_35":185,"_143":-5,"_45":46,"_44":186,"_145":63,"_42":187,"_13":67,"_38":26,"_40":188,"_29":30,"_149":-5,"_32":189},{"_47":176,"_37":177,"_35":178,"_143":-5,"_45":46,"_44":179,"_145":63,"_42":180,"_13":67,"_38":39,"_40":181,"_29":30,"_149":-5,"_32":182},{"_47":168,"_37":169,"_35":170,"_143":-5,"_45":46,"_44":171,"_145":30,"_42":172,"_13":67,"_38":173,"_40":174,"_29":30,"_149":-5,"_32":175},{"_47":165,"_37":33,"_35":36,"_143":-5,"_45":46,"_44":14,"_145":63,"_42":166,"_13":67,"_38":39,"_40":41,"_29":30,"_149":-5,"_32":167},{"_47":158,"_37":159,"_35":61,"_143":-5,"_45":46,"_44":160,"_145":30,"_42":161,"_13":67,"_38":162,"_40":163,"_29":30,"_149":-5,"_32":164},{"_47":151,"_37":152,"_35":153,"_143":-5,"_45":46,"_44":154,"_145":30,"_42":155,"_13":67,"_38":39,"_40":156,"_29":30,"_149":-5,"_32":157},{"_47":140,"_37":141,"_35":142,"_143":-5,"_45":46,"_44":144,"_145":63,"_42":146,"_13":147,"_38":39,"_40":148,"_29":30,"_149":-5,"_32":150},"b14999c0-9e98-4802-aa4a-5cbe524ea875","scrapers.ts","8ba0c2b2-878e-11f1-af20-1607ee4eb77e","parentId",6,"latest",["D",1784918245463],1,"// RSS Feed Scrapers — بغیر API Key کے، مفت، globally\n// Updated: Better RSS sources that don't rate-limit\n\nexport interface Deal {\n title: string;\n description: string;\n price: string;\n original_price: string;\n discount: string;\n url: string;\n source: string;\n category: string;\n image_url: string;\n}\n\n// RSS Feed Sources — تمام دنیا سے، بغیر API کے\n// Reddit کے بجائے دوسرے sources استعمال کیے جو rate-limit نہیں کرتے\nexport const RSS_SOURCES = [\n {\n name: \"9to5Toys Deals\",\n url: \"https://9to5toys.com/feed/\",\n category: \"tech-deals\",\n region: \"global\",\n },\n {\n name: \"XDA Developers\",\n url: \"https://www.xda-developers.com/feed/\",\n category: \"tech\",\n region: \"global\",\n },\n {\n name: \"Hacker News\",\n url: \"https://hnrss.org/frontpage\",\n category: \"tech\",\n region: \"global\",\n },\n {\n name: \"TechBargains\",\n url: \"https://www.techbargains.com/rss.xml\",\n category: \"deals\",\n region: \"US\",\n },\n {\n name: \"DealNews\",\n url: \"https://www.dealnews.com/rss/latest.xml\",\n category: \"deals\",\n region: \"US\",\n },\n {\n name: \"BradsDeals\",\n url: \"https://blog.bradsdeals.com/feed/\",\n category: \"deals\",\n region: \"US\",\n },\n {\n name: \"BleepingComputer Deals\",\n url: \"https://www.bleepingcomputer.com/feed/\",\n category: \"tech\",\n region: \"global\",\n },\n {\n name: \"AndroidAuthority Deals\",\n url: \"https://www.androidauthority.com/feed/\",\n category: \"tech\",\n region: \"global\",\n },\n {\n name: \"CNET Deals\",\n url: \"https://www.cnet.com/rss/deals/\",\n category: \"deals\",\n region: \"global\",\n },\n {\n name: \"Android Police\",\n url: \"https://www.androidpolice.com/feed/\",\n category: \"tech\",\n region: \"global\",\n },\n];\n\n// Simple XML/RSS parser (Atom + RSS support)\nfunction parseRSS(xml: string, sourceName: string, category: string): Deal[] {\n const deals: Deal[] = [];\n\n // RSS format\n let items = xml.match(//gi) || [];\n\n // Atom format\n if (items.length === 0) {\n items = xml.match(//gi) || [];\n }\n\n for (const item of items.slice(0, 10)) {\n const title = extractTag(item, \"title\");\n let link = extractTag(item, \"link\");\n\n // Atom format: link is in href attribute\n if (!link) {\n const linkMatch = item.match(/]*href=\"([^\"]+)\"/i);\n link = linkMatch ? linkMatch[1] : \"\";\n }\n\n const description = stripHtml(extractTag(item, \"description\") || extractTag(item, \"summary\") || extractTag(item, \"content\"));\n\n // Price extract\n const priceMatch = description.match(/\\$[\\d,.]+/g) || title.match(/\\$[\\d,.]+/g);\n const price = priceMatch ? priceMatch[0] : \"\";\n\n // Discount extract\n const discountMatch = title.match(/(\\d+%|OFF|SAVE|DEAL|HOT|CHEAP)/i);\n const discount = discountMatch ? discountMatch[0] : \"\";\n\n if (title && link) {\n deals.push({\n title: decodeEntities(title.trim()),\n description: decodeEntities(description.substring(0, 500)),\n price,\n original_price: \"\",\n discount,\n url: link.trim(),\n source: sourceName,\n category,\n image_url: extractImage(item),\n });\n }\n }\n\n return deals;\n}\n\nfunction extractTag(xml: string, tag: string): string {\n const regex = new RegExp(`<${tag}[^>]*>([\\\\s\\\\S]*?)`, \"i\");\n const match = xml.match(regex);\n return match ? match[1].trim() : \"\";\n}\n\nfunction extractImage(xml: string): string {\n const match = xml.match(/]*url=\"([^\"]+)\"/i) ||\n xml.match(/]*url=\"([^\"]+)\"/i) ||\n xml.match(/]*url=\"([^\"]+)\"/i) ||\n xml.match(/]*src=\"([^\"]+)\"/i);\n return match ? match[1] : \"\";\n}\n\nfunction stripHtml(html: string): string {\n return html.replace(/<[^>]*>/g, \"\").trim();\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 .replace(/’/g, \"'\")\n .replace(/–/g, \"-\")\n .replace(/—/g, \"—\")\n .replace(/…/g, \"...\")\n .replace(//g, \"$1\");\n}\n\n// Main scraper function — تمام sources سے deals لائے\nexport async function scrapeAllSources(): Promise<{ deals: Deal[]; errors: number; sourcesChecked: number }> {\n const allDeals: Deal[] = [];\n let errors = 0;\n let sourcesChecked = 0;\n\n for (const source of RSS_SOURCES) {\n try {\n console.log(`📡 Scraping: ${source.name}...`);\n const response = await fetch(source.url, {\n headers: {\n \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\",\n \"Accept\": \"application/rss+xml, application/xml, text/xml, */*\",\n },\n signal: AbortSignal.timeout(15000),\n });\n\n if (!response.ok) {\n console.log(`❌ ${source.name}: HTTP ${response.status}`);\n errors++;\n continue;\n }\n\n const xml = await response.text();\n const deals = parseRSS(xml, source.name, source.category);\n console.log(`✅ ${source.name}: ${deals.length} deals found`);\n allDeals.push(...deals);\n sourcesChecked++;\n\n // چھوٹا delay تاکہ rate-limit نہ ہو\n await new Promise((r) => setTimeout(r, 500));\n } catch (err) {\n console.log(`❌ ${source.name}: ${err.message}`);\n errors++;\n }\n }\n\n return { deals: allDeals, errors, sourcesChecked };\n}\n","label",[141],"97634f14-ecb2-417e-8dd2-040ab130ffb0","db.ts","8bec333c-878e-11f1-983f-1607ee4eb77e",3,["D",1784918172314],"// Database setup — SQLite (free, built into Val Town)\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initDB() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS deals (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n price TEXT,\n original_price TEXT,\n discount TEXT,\n url TEXT,\n source TEXT,\n category TEXT,\n image_url TEXT,\n content_post TEXT,\n affiliate_url TEXT,\n status TEXT DEFAULT 'new',\n created_at TEXT DEFAULT (datetime('now')),\n posted_at TEXT\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS stats (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n run_at TEXT DEFAULT (datetime('now')),\n deals_found INTEGER DEFAULT 0,\n deals_new INTEGER DEFAULT 0,\n errors INTEGER DEFAULT 0,\n sources_checked INTEGER DEFAULT 0\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS settings (\n key TEXT PRIMARY KEY,\n value TEXT\n )\n `);\n\n console.log(\"✅ Database initialized\");\n}\n\n// Check if deal already exists (by URL)\nexport async function dealExists(url: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT id FROM deals WHERE url = ?\",\n args: [url],\n });\n return result.rows.length > 0;\n}\n\n// Save new deal\nexport async function saveDeal(deal: any) {\n await sqlite.execute({\n sql: `INSERT INTO deals (title, description, price, original_price, discount, url, source, category, image_url, content_post, affiliate_url, status)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n deal.title,\n deal.description || \"\",\n deal.price || \"\",\n deal.original_price || \"\",\n deal.discount || \"\",\n deal.url,\n deal.source,\n deal.category || \"general\",\n deal.image_url || \"\",\n deal.content_post || \"\",\n deal.affiliate_url || \"\",\n \"new\",\n ],\n });\n}\n\n// Save run stats\nexport async function saveStats(found: number, newDeals: number, errors: number, sources: number) {\n await sqlite.execute({\n sql: \"INSERT INTO stats (deals_found, deals_new, errors, sources_checked) VALUES (?, ?, ?, ?)\",\n args: [found, newDeals, errors, sources],\n });\n}\n\n// Get all deals\nexport async function getAllDeals(limit = 50) {\n return await sqlite.execute({\n sql: \"SELECT * FROM deals ORDER BY created_at DESC LIMIT ?\",\n args: [limit],\n });\n}\n\n// Get new deals (not yet posted)\nexport async function getNewDeals() {\n return await sqlite.execute({\n sql: \"SELECT * FROM deals WHERE status = 'new' ORDER BY created_at DESC\",\n });\n}\n\n// Mark deal as posted\nexport async function markPosted(id: number) {\n await sqlite.execute({\n sql: \"UPDATE deals SET status = 'posted', posted_at = datetime('now') WHERE id = ?\",\n args: [id],\n });\n}\n\n// Get stats\nexport async function getStats() {\n const totalDeals = await sqlite.execute(\"SELECT COUNT(*) as count FROM deals\");\n const newDeals = await sqlite.execute(\"SELECT COUNT(*) as count FROM deals WHERE status = 'new'\");\n const postedDeals = await sqlite.execute(\"SELECT COUNT(*) as count FROM deals WHERE status = 'posted'\");\n const lastRuns = await sqlite.execute(\"SELECT * FROM stats ORDER BY run_at DESC LIMIT 5\");\n const bySource = await sqlite.execute(\"SELECT source, COUNT(*) as count FROM deals GROUP BY source ORDER BY count DESC\");\n\n return {\n total: totalDeals.rows[0]?.count || 0,\n new: newDeals.rows[0]?.count || 0,\n posted: postedDeals.rows[0]?.count || 0,\n lastRuns: lastRuns.rows,\n bySource: bySource.rows,\n };\n}\n",[152],"7fd0829c-106d-4013-9213-449cec648164","dashboard.tsx",5,["D",1784918202405],"http","// 🖥️ Dashboard — Deals اور Stats دیکھنے کے لیے\n// یہ HTTP endpoint ہے جو آپ browser میں کھول سکتے ہیں\n\nimport { initDB, getAllDeals, getStats, getNewDeals } from \"./db.ts\";\n\nexport default async function (req: Request): Promise {\n await initDB();\n\n const url = new URL(req.url);\n const filter = url.searchParams.get(\"filter\") || \"all\";\n const stats = await getStats();\n\n let dealsResult;\n if (filter === \"new\") {\n dealsResult = await getNewDeals();\n } else {\n dealsResult = await getAllDeals(100);\n }\n const deals = dealsResult.rows as any[];\n\n const html = `\n\n\n \n \n 🌍 Global Affiliate Deal Finder\n \n\n\n

\n \n\n

${stats.total}

Total Deals

${stats.new}

New (Ready)

${stats.posted}

Posted

Global Sources

\n\n

\n All Deals\n New Only\n

\n\n ${stats.lastRuns.length > 0 ? `\n

📅 Last ${stats.lastRuns.length} Cron Runs

\n ${stats.lastRuns.map((r: any) => `\n

\n 🕐 ${r.run_at}\n Found: ${r.deals_found} | New: ${r.deals_new} | Sources: ${r.sources_checked} | Errors: ${r.errors}\n

\n `).join('')}\n

\n ` : ''}\n\n ${deals.length === 0 ? `\n

⏳ Abhi tak koi deals nahi mili

Cron job ka intezar karein — har 15 minutes mein deals automatically scan honge!

\n ` : `\n

\n ${deals.map((d: any) => `\n

${escapeHtml(d.title)}

\n ${d.source}\n ${d.category}\n ${d.price ? `💰 ${d.price}` : ''}\n ${d.discount ? `🔥 ${d.discount}` : ''}\n ${d.status}\n

\n ${d.description ? `

${escapeHtml(d.description.substring(0, 150))}...

` : ''}\n ${d.content_post ? `\n

${escapeHtml(d.content_post)}

\n \n ` : ''}\n

\n 🔗 Open Deal\n 💸 Affiliate Link\n

\n `).join('')}\n

\n `}\n\n \n

\n\n

Copied!

\n\n \n\n`;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction escapeHtml(text: string): string {\n return text\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n",[159],"93f8d1e8-9549-43ce-bf25-6025d1aaa209",["D",1784918740695],[33],"da257a9e-894a-447a-82b1-7974367b96b9","cron.ts","9d955082-878e-11f1-af85-1607ee4eb77e",4,["D",1784918202396],"interval","// 🚀 Main Cron Job — یہ 24/7 خود بخود چلے گا\n// ہر 15 منٹ بعد یہ خود بخود:\n// 1. تمام sources سے deals scrape کرے\n// 2. AI content بنائے\n// 3. Database میں save کرے\n// 4. Stats record کرے\n\nimport { initDB, dealExists, saveDeal, saveStats } from \"./db.ts\";\nimport { scrapeAllSources } from \"./scrapers.ts\";\nimport { generateContent } from \"./content.ts\";\n\nexport default async function (interval: Interval) {\n console.log(\"⏰ Cron started at:\", new Date().toISOString());\n console.log(\"📍 Last run:\", interval.lastRunAt);\n\n // 1. Database initialize\n await initDB();\n\n // 2. Scrape تمام sources سے\n console.log(\"📡 Starting to scrape all sources...\");\n const { deals, errors, sourcesChecked } = await scrapeAllSources();\n console.log(`📊 Total deals found: ${deals.length}`);\n\n // 3. Process ہر deal — content generate + save\n let newDeals = 0;\n for (const deal of deals) {\n // Check اگر پہلے سے موجود ہے\n const exists = await dealExists(deal.url);\n if (exists) continue;\n\n // AI Content generate کرنا\n const { post, affiliateUrl } = generateContent(deal);\n\n // Database میں save\n await saveDeal({\n ...deal,\n content_post: post,\n affiliate_url: affiliateUrl,\n });\n newDeals++;\n console.log(`✨ New deal saved: ${deal.title.substring(0, 50)}...`);\n }\n\n // 4. Stats save\n await saveStats(deals.length, newDeals, errors, sourcesChecked);\n\n console.log(\"━━━━━━━━━━━━━━━━━━━━━━━━━━━\");\n console.log(`✅ CRON COMPLETE`);\n console.log(`📊 Deals found: ${deals.length}`);\n console.log(`🆕 New deals: ${newDeals}`);\n console.log(`❌ Errors: ${errors}`);\n console.log(`📡 Sources checked: ${sourcesChecked}`);\n console.log(\"━━━━━━━━━━━━━━━━━━━━━━━━━━━\");\n}\n",[169],"2219f8ca-c525-40aa-894a-e36cc4951477","content.ts","8bb15442-878e-11f1-b452-1607ee4eb77e",2,["D",1784918172266],"// AI Content Generator — Template-based (بغیر API Key کے)\n// یہ System خود بخود Promotional Content بناتا ہے\n\nimport type { Deal } from \"./scrapers.ts\";\n\n// Affiliate ID — آپ یہاں اپنا Amazon/eBay Affiliate ID ڈالیں\n// فی الوقت خالی ہے، بعد میں اپنے Affiliate ID کو Deno.env.get سے لے سکتے ہیں\nconst AFFILIATE_ID = Deno.env.get(\"AFFILIATE_ID\") || \"\";\n\n// Amazon Affiliate Link بنانا\nexport function makeAmazonAffiliate(url: string): string {\n if (!AFFILIATE_ID) return url;\n // Amazon affiliate tag add کرنا\n const separator = url.includes(\"?\") ? \"&\" : \"?\";\n return `${url}${separator}tag=${AFFILIATE_ID}`;\n}\n\n// Content Templates — مختلف styles میں posts\nconst TEMPLATES = [\n // Style 1: Exciting Deal\n (deal: Deal) => `🔥🔥 MEGA DEAL ALERT! 🔥🔥\n\n${deal.title}\n\n${deal.discount ? `💰 SAVE: ${deal.discount}` : \"\"}\n${deal.price ? `💵 Price: ${deal.price}` : \"\"}\n\n${deal.description.substring(0, 200)}...\n\n🛒 Get it NOW: ${deal.url}\n\n#${deal.category} #deal #discount #savemoney #shopping`,\n\n // Style 2: Quick Share\n (deal: Deal) => `⚡ FLASH DEAL! ${deal.title}\n\n${deal.discount ? `🎯 ${deal.discount} OFF!` : \"\"}\n${deal.price ? `💰 Only ${deal.price}` : \"\"}\n\nDon't miss out! 👉 ${deal.url}\n\n#${deal.category} #flashsale #deal`,\n\n // Style 3: Detailed\n (deal: Deal) => `🛍️ Today's Best Deal from ${deal.source}!\n\n📌 ${deal.title}\n\n${deal.discount ? `✂️ Discount: ${deal.discount}` : \"✨ Special Offer Available\"}\n${deal.price ? `💵 Current Price: ${deal.price}` : \"\"}\n\n📝 ${deal.description.substring(0, 250)}...\n\n🔗 Shop here: ${deal.url}\n\n#${deal.category} #bestdeal #offer #shoppingdeals #bargain`,\n\n // Style 4: Urgency\n (deal: Deal) => `⏰ LIMITED TIME DEAL! ⏰\n\n${deal.title}\n\n${deal.discount ? `🔥 ${deal.discount} OFF!` : \"\"}\n${deal.price ? `💰 Price: ${deal.price}` : \"\"}\n\nHurry before it's gone! 🏃‍♂️💨\n👉 ${deal.url}\n\n#${deal.category} #limitedtime #deal #hurry`,\n\n // Style 5: Social Media Style\n (deal: Deal) => `✅ Found an amazing deal!\n\n${deal.title}\n${deal.discount ? `🎁 ${deal.discount}` : \"\"}\n${deal.price ? `💵 ${deal.price}` : \"\"}\n\nLink: ${deal.url}\n\n#${deal.category} #deal #discount #offer`,\n];\n\n// Content generate کرنا — ہر deal کے لیے random style\nexport function generateContent(deal: Deal): { post: string; affiliateUrl: string } {\n const templateIndex = Math.floor(Math.random() * TEMPLATES.length);\n const template = TEMPLATES[templateIndex];\n const post = template(deal);\n const affiliateUrl = makeAmazonAffiliate(deal.url);\n\n return { post, affiliateUrl };\n}\n\n// Bulk content generation\nexport function generateBulkContent(deals: Deal[]): Array {\n return deals.map((deal) => {\n const { post, affiliateUrl } = generateContent(deal);\n return {\n ...deal,\n content_post: post,\n affiliate_url: affiliateUrl,\n };\n });\n}\n",[177],"a7f078b5-4f73-4326-a80a-78be43e11695","README.md","c99ad800-878e-11f1-9cc7-1607ee4eb77e",7,["D",1784918276252],"# 🌍 Global Affiliate Deal Finder\n\n**100% Free | 24/7 Automatic | No API Keys | Globally**\n\n## 🚀 یہ System کیا کرتا ہے\n\nیہ ایک **مکمل Automatic** System ہے جو:\n1. 📡 **RSS Feeds** سے پوری دنیا کے Deals/Trends خود بخود scrape کرتا ہے (بغیر API کے)\n2. 🤖 **AI Content Generator** ہر Deal کے لیے Promotional Post بناتا ہے\n3. 💾 **SQLite Database** میں سب Deals محفوظ کرتا ہے\n4. ⏰ **Cron Job** ہر 15 منٹ بعد خود بخود چلتا ہے — 24/7\n5. 🖥️ **Dashboard** پر سب کچھ دیکھ سکتے ہیں\n\n## 📡 Sources (بغیر API کے — تمام مفت)\n\n| Source | Category | Region |\n|--------|----------|--------|\n| 9to5Toys | Tech Deals | Global |\n| XDA Developers | Tech | Global |\n| Hacker News | Tech | Global |\n| TechBargains | Deals | US |\n| BleepingComputer | Tech | Global |\n| AndroidAuthority | Tech | Global |\n| CNET Deals | Deals | Global |\n| Android Police | Tech | Global |\n\n## 📂 Files\n\n| File | Type | کام |\n|------|------|-----|\n| `cron.ts` | Interval | 24/7 Main Engine — ہر 15 منٹ بعد خود بخود چلے |\n| `scrapers.ts` | Script | RSS Feeds سے Deals scrape کرنا |\n| `content.ts` | Script | AI Content/Post Generation |\n| `db.ts` | Script | SQLite Database Management |\n| `dashboard.tsx` | HTTP | Deals دیکھنے کا Web Interface |\n\n## 💰 پیسے کمانے کا طریقہ\n\n1. **Amazon Associates Account** بنائیں (مفت) → https://affiliate-program.amazon.com\n2. اپنا Affiliate ID Environment Variable میں ڈالیں:\n 👉 Add AFFILIATE_ID here: https://www.val.town/x/niyib14872/global-affiliate-deal-finder/environment-variables?key=AFFILIATE_ID\n3. System خود بخود Affiliate Links بنائے گا\n4. Dashboard سے Posts Copy کریں → Social Media/Blog پر Share کریں\n5. جب کوئی خریدے → آپ کو Commission ملے\n\n## 🔧 Technical Details\n\n- **Platform:** Val Town (Free Tier)\n- **Runtime:** Deno\n- **Database:** SQLite (built-in)\n- **Schedule:** Every 15 minutes (free tier minimum)\n- **No API Keys Required** — تمام Sources Public RSS Feeds ہیں\n",[184],"pulls","branches","forks","envVars",{"_197":67,"_199":67},"connections",{"_197":67,"_198":67},"count","unfilledCount","emptyCount",{"_47":183,"_37":184,"_35":185,"_143":-5,"_45":46,"_44":186,"_145":63,"_42":226,"_13":67,"_38":26,"_40":188,"_29":30,"_149":-5,"_208":227,"_32":228},{"_47":176,"_37":177,"_35":178,"_143":-5,"_45":46,"_44":179,"_145":63,"_42":223,"_13":67,"_38":39,"_40":181,"_29":30,"_149":-5,"_208":224,"_32":225},{"_47":168,"_37":169,"_35":170,"_143":-5,"_45":46,"_44":171,"_145":30,"_42":220,"_13":67,"_38":173,"_40":174,"_29":30,"_149":-5,"_208":221,"_32":222},{"_47":165,"_37":33,"_35":36,"_143":-5,"_45":46,"_44":14,"_145":63,"_42":217,"_13":67,"_38":39,"_40":41,"_29":30,"_149":-5,"_208":218,"_32":219},{"_47":158,"_37":159,"_35":61,"_143":-5,"_45":46,"_44":160,"_145":30,"_42":214,"_13":67,"_38":162,"_40":163,"_29":30,"_149":-5,"_208":215,"_32":216},{"_47":151,"_37":152,"_35":153,"_143":-5,"_45":46,"_44":154,"_145":30,"_42":211,"_13":67,"_38":39,"_40":156,"_29":30,"_149":-5,"_208":212,"_32":213},{"_47":140,"_37":141,"_35":142,"_143":-5,"_45":46,"_44":144,"_145":63,"_42":207,"_13":147,"_38":39,"_40":148,"_29":30,"_149":-5,"_208":209,"_32":210},["D",1784918245463],"children",[],[141],["D",1784918172314],[],[152],["D",1784918202405],[],[159],["D",1784918740695],[],[33],["D",1784918202396],[],[169],["D",1784918172266],[],[177],["D",1784918276252],[],[184],["D",1784917989098],["D",1789473046147],{"_104":103,"_111":106},{"_104":103,"_105":106,"_107":106,"_19":59,"_108":109,"_110":30},{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"ctx",{"_86":-5,"_130":267,"_268":269,"_270":271,"_272":30,"_273":30,"_274":30,"_275":63,"_276":-5,"_277":-7,"_278":-7,"_279":67,"_280":30,"_281":30,"_282":-5,"_283":30,"_284":30,"_285":30,"_286":-5},"ENV",{"_238":239,"_240":241,"_242":94,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266},"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