[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_151":152,"_153":154},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_114":-5,"_20":115,"_22":116,"_117":118,"_119":120,"_25":121,"_24":-5,"_122":-5,"_123":-5,"_124":53,"_125":126,"_127":44,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","jr7250513","name","poly","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","e2c0a478-36c5-11f1-9473-42b51c65c3df","main.ts","fileId","d97aa7a4-35cd-11f1-8fef-42b51c65c3df","parentId","branchId","d9783bcc-35cd-11f1-8fef-42b51c65c3df","branchVersion",16,"latest",true,"createdAt",["D",1776035896577],15,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst PASSWORD = \"crystalcove2026\";\nconst CATEGORIES = [\"Politics\", \"Finance\", \"Geopolitics\", \"Sports\", \"Weather\"];\nconst MIN_WIN_RATE = 75;\nconst MIN_RECENT_TRADES = 5;\nconst MAX_DAYS_INACTIVE = 3;\nconst MAX_DAYS_OLD = 30;\nconst TOP_N = 30;\nconst DATA_API = \"https://data-api.polymarket.com\";\nconst ANALYTICS_API =\n \"https://polymarketanalytics.com/api/traders-tag-performance\";\n\nconst HEADERS = {\n \"User-Agent\":\n \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36\",\n Accept: \"application/json, text/plain, */*\",\n \"Accept-Language\": \"en-US,en;q=0.9\",\n Referer: \"https://polymarketanalytics.com/traders\",\n Origin: \"https://polymarketanalytics.com\",\n};\n\n// ── DB helper — always use {sql, args} object format! ─────────────────────────\n// Val Town's sqlite.execute(sql, args) SILENTLY IGNORES positional params.\n// Must use sqlite.execute({sql, args}) instead.\n\nasync function db(sql: string, args?: any[]) {\n if (args && args.length > 0) {\n return sqlite.execute({ sql, args } as any);\n }\n return sqlite.execute(sql);\n}\n\nasync function setupDb() {\n await db(`CREATE TABLE IF NOT EXISTS poly_results (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n scan_date TEXT DEFAULT '',\n category TEXT DEFAULT '',\n name TEXT DEFAULT '',\n wallet TEXT DEFAULT '',\n win_rate REAL DEFAULT 0,\n recent_trades INTEGER DEFAULT 0,\n days_since REAL DEFAULT 0,\n overall_pnl REAL DEFAULT 0,\n active_pos INTEGER DEFAULT 0,\n profile_url TEXT DEFAULT ''\n )`);\n}\n\n// ── Helpers ───────────────────────────────────────────────────────────────────\n\nconst sf = (v: any, d = 0): number => {\n const n = parseFloat(v);\n return isNaN(n) ? d : n;\n};\nconst now = () => Date.now() / 1000;\n\nfunction checkRecency(\n trades: any[],\n): { recentCount: number; daysSince: number } {\n const cutoff = now() - MAX_DAYS_OLD * 86400;\n const allTs = trades.map((t) => sf(t.timestamp)).filter(Boolean);\n const recentCount = allTs.filter((ts) => ts >= cutoff).length;\n const daysSince = allTs.length ? (now() - Math.max(...allTs)) / 86400 : 999;\n return { recentCount, daysSince: Math.round(daysSince * 10) / 10 };\n}\n\n// ── API calls ─────────────────────────────────────────────────────────────────\n\nasync function getWallets(\n cat: string,\n): Promise<{ wallets: any[]; error?: string }> {\n const p = new URLSearchParams({\n tag: cat,\n sortDirection: \"DESC\",\n sortColumn: \"win_rate\",\n limit: String(TOP_N),\n offset: \"0\",\n minWinRate: \"0.70\",\n maxWinRate: \"200\",\n minTotalPositions: \"15\",\n maxTotalPositions: \"999999\",\n minActivePositions: \"1\",\n maxActivePositions: \"999999\",\n minCurrentValue: \"0\",\n maxCurrentValue: \"1000000000000\",\n minWinAmount: \"2000\",\n maxWinAmount: \"999999999\",\n minLossAmount: \"-999999999\",\n maxLossAmount: \"0\",\n minPnL: \"200\",\n maxPnL: \"999999999\",\n });\n try {\n const r = await fetch(`${ANALYTICS_API}?${p}`, { headers: HEADERS });\n if (!r.ok) {\n const body = await r.text().catch(() => \"\");\n console.error(\n `[getWallets ${cat}] HTTP ${r.status}: ${body.slice(0, 200)}`,\n );\n return { wallets: [], error: `HTTP ${r.status}` };\n }\n const d = await r.json();\n const raw = Array.isArray(d) ? d : d?.data ?? d?.traders ?? [];\n const wallets = raw.map((t: any) => ({\n wallet: t.trader || t.address || \"\",\n name: t.trader_name || (t.trader || \"anon\").slice(0, 10),\n pnl: sf(t.overall_gain),\n active: parseInt(t.active_positions) || 0,\n winRate: sf(t.win_rate) > 1 ? sf(t.win_rate) : sf(t.win_rate) * 100,\n })).filter((w: any) => w.wallet);\n return { wallets };\n } catch (e: any) {\n console.error(`[getWallets ${cat}] ${e.message}`);\n return { wallets: [], error: e.message };\n }\n}\n\nasync function getTrades(\n wallet: string,\n): Promise<{ trades: any[]; error?: string }> {\n try {\n const r = await fetch(\n `${DATA_API}/activity?user=${wallet}&type=TRADE&sortBy=TIMESTAMP&sortDirection=DESC&limit=60`,\n { headers: HEADERS },\n );\n if (!r.ok) return { trades: [], error: `HTTP ${r.status}` };\n const d = await r.json();\n const recs = Array.isArray(d) ? d : d?.data ?? [];\n return { trades: recs.filter((r: any) => !r.type || r.type === \"TRADE\") };\n } catch (e: any) {\n return { trades: [], error: e.message };\n }\n}\n\n// ── Scan ──────────────────────────────────────────────────────────────────────\n\nasync function runScan(): Promise<{ count: number; log: string[] }> {\n await setupDb();\n // Clean legacy rows\n await db(\n \"DELETE FROM poly_results WHERE scan_date IS NULL OR scan_date = ''\",\n );\n\n const date = new Date().toISOString().slice(0, 10);\n console.log(`[SCAN] Starting scan for ${date}`);\n await db(\"DELETE FROM poly_results WHERE scan_date = ?\", [date]);\n\n const seen = new Set();\n let count = 0;\n const log: string[] = [];\n\n for (const cat of CATEGORIES) {\n const { wallets, error } = await getWallets(cat);\n if (error) {\n log.push(`[${cat}] ERROR: ${error}`);\n continue;\n }\n log.push(`[${cat}] ${wallets.length} wallets fetched`);\n\n let catPass = 0;\n for (const w of wallets) {\n if (!w.wallet || seen.has(w.wallet)) continue;\n if (w.winRate < MIN_WIN_RATE) continue;\n\n const { trades, error: tErr } = await getTrades(w.wallet);\n await new Promise((r) => setTimeout(r, 300));\n if (tErr) continue;\n\n const recency = checkRecency(trades);\n if (recency.daysSince > MAX_DAYS_INACTIVE) continue;\n if (recency.recentCount < MIN_RECENT_TRADES) continue;\n\n seen.add(w.wallet);\n\n try {\n await db(\n `INSERT INTO poly_results (scan_date, category, name, wallet, win_rate, recent_trades, days_since, overall_pnl, active_pos, profile_url)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n date,\n cat,\n w.name,\n w.wallet,\n Math.round(w.winRate * 10) / 10,\n recency.recentCount,\n recency.daysSince,\n Math.round(w.pnl * 100) / 100,\n w.active,\n \"https://polymarket.com/profile/\" + w.wallet,\n ],\n );\n count++;\n catPass++;\n log.push(\n ` PASS: ${w.name} ${\n w.winRate.toFixed(1)\n }% WR, ${recency.recentCount} trades, ${recency.daysSince}d ago`,\n );\n } catch (insertErr: any) {\n log.push(` INSERT ERROR for ${w.name}: ${insertErr.message}`);\n }\n }\n log.push(`[${cat}] done — ${catPass} passed`);\n }\n\n // Verify\n const verify = await db(\n \"SELECT scan_date, COUNT(*) FROM poly_results GROUP BY scan_date ORDER BY scan_date DESC\",\n );\n const dbState = verify.rows.map((r: any) => `${r[0]}: ${r[1]} rows`).join(\n \", \",\n );\n log.push(`[DB VERIFY] ${dbState || \"EMPTY\"}`);\n log.push(`Scan complete: ${count} wallets saved for ${date}`);\n\n return { count, log };\n}\n\n// ── Login page ────────────────────────────────────────────────────────────────\n\nfunction loginPage(err: string): string {\n return `\n\nPolymarket Scanner\n\n

🎯 Polymarket Scanner

Enter password to continue

`;\n}\n\n// ── Scan results page ─────────────────────────────────────────────────────────\n\nfunction scanResultPage(count: number, log: string[]): string {\n const logHtml = log.map((l) => {\n if (l.includes(\"ERROR\")) return `

${l}

`;\n if (l.includes(\"PASS:\")) return `

${l}

`;\n if (l.includes(\"DB VERIFY\")) {\n return `

${l}

`;\n }\n return `

${l}

`;\n }).join(\"\");\n\n return `\n\nScan Complete\n\n

🎯 Scan Complete

0 ? \"#16a34a\" : \"#dc2626\"\n }\">${count} wallets saved

${logHtml}

\n← Back to Dashboard\n`;\n}\n\n// ── Dashboard UI (dark mode, top 5 per category) ─────────────────────────────\n\nconst DISPLAY_PER_CATEGORY = 3;\n\nasync function renderUI(queryDate?: string | null): Promise {\n await setupDb();\n\n const dr = await db(\n \"SELECT DISTINCT scan_date FROM poly_results WHERE scan_date IS NOT NULL AND scan_date != '' ORDER BY scan_date DESC LIMIT 7\",\n );\n const dates = dr.rows.map((r: any) => r[0] as string);\n const latestDate = queryDate ?? (dates[0] ?? null);\n\n let rows: any[] = [];\n if (latestDate) {\n const rr = await db(\n \"SELECT category, name, wallet, win_rate, recent_trades, days_since, overall_pnl, active_pos, profile_url FROM poly_results WHERE scan_date = ? ORDER BY win_rate DESC, overall_pnl DESC, days_since ASC\",\n [latestDate],\n );\n const allRows = rr.rows.map((r: any) => ({\n category: r[0],\n name: r[1],\n wallet: r[2],\n win_rate: r[3],\n trades: r[4],\n days: r[5],\n pnl: r[6],\n active: r[7],\n url: r[8],\n }));\n\n // Top N per category\n const catCounts: Record = {};\n for (const r of allRows) {\n const c = r.category;\n catCounts[c] = catCounts[c] || 0;\n if (catCounts[c] < DISPLAY_PER_CATEGORY) {\n rows.push(r);\n catCounts[c]++;\n }\n }\n }\n\n const colors: Record = {\n Politics: \"#3b82f6\",\n Finance: \"#10b981\",\n Geopolitics: \"#8b5cf6\",\n Sports: \"#f59e0b\",\n Weather: \"#06b6d4\",\n };\n const tableRows = rows.length > 0\n ? rows.map((r) => {\n const c = colors[r.category] || \"#6b7280\";\n const pnl = r.pnl >= 1000\n ? `$${(r.pnl / 1000).toFixed(1)}k`\n : `$${Number(r.pnl).toFixed(0)}`;\n return `\n${r.category}\n${r.name}\n${r.win_rate}%\n${r.trades} recent\n${r.days}d ago\n${pnl}\n${r.active} open\nView →\n`;\n }).join(\"\")\n : `No results yet. Click \"Run Scan\" to start.`;\n\n const histLinks = dates.map((d) =>\n `${d}`\n ).join(\"\");\n\n return `\n\nPolymarket Scanner\n\n

🎯 Polymarket Scanner

Latest scan: ${\n latestDate ?? \"No scans yet\"\n } · Top ${DISPLAY_PER_CATEGORY} per category · ${rows.length} shown

0 ? \"#16a34a\" : \"#dc2626\"\n }\">${rows.length} wallet${rows.length !== 1 ? \"s\" : \"\"}

\n${\n dates.length > 0\n ? `

History:${histLinks}

`\n : \"\"\n }\n

\nClick any row to open wallet profile\nRun Scan ↗\n

\n\n\n${tableRows}\n

Category	Trader	Win Rate	Recent Trades	Last Active	PnL	Open Pos	Profile

Scanner Criteria

${MIN_WIN_RATE}%+ win rate (from Polymarket Analytics)
Traded within the last ${MAX_DAYS_INACTIVE} days
At least ${MIN_RECENT_TRADES} trades in last ${MAX_DAYS_OLD} days
At least 1 active open position · $2,000+ volume
Scans: ${CATEGORIES.join(\" · \")}

\n`;\n}\n\n// ── Handler ───────────────────────────────────────────────────────────────────\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n const action = url.searchParams.get(\"action\");\n const cookie = req.headers.get(\"cookie\") ?? \"\";\n const authed = cookie.includes(`auth=${PASSWORD}`);\n\n // Password form\n if (req.method === \"POST\" && !action) {\n const form = await req.formData();\n const pw = form.get(\"pw\") as string;\n if (pw === PASSWORD) {\n return new Response(null, {\n status: 302,\n headers: {\n Location: \"/\",\n \"Set-Cookie\": `auth=${PASSWORD}; Path=/; HttpOnly; Max-Age=2592000`,\n },\n });\n }\n return new Response(loginPage(\"Wrong password.\"), {\n status: 401,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n // Scan — opens in new tab, shows HTML results\n if (action === \"scan\") {\n try {\n const { count, log } = await runScan();\n return new Response(scanResultPage(count, log), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n } catch (e: any) {\n return new Response(\n scanResultPage(0, [`FATAL ERROR: ${e.message}`, e.stack ?? \"\"]),\n {\n status: 500,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n },\n );\n }\n }\n\n // Auth gate\n if (!authed) {\n return new Response(loginPage(\"\"), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n // Dashboard\n const queryDate = url.searchParams.get(\"date\");\n const html = await renderUI(queryDate);\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1776035896577],"children",[],[35],"d977991a-35cd-11f1-8fef-42b51c65c3df",["D",1775929365825],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","8ba7e804-c257-4cfa-8e42-12d6d72199a8","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019d738d-b90e-705f-acd4-242845609bf1","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_113":19},"org",{"_11":12,"_108":-5,"_109":19,"_70":71,"_110":111,"_112":53},"branch",{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":147,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":148,"_95":149,"_97":150,"_99":53},[144],"files",[144],"counts",{"_134":77,"_135":136,"_137":77,"_31":138,"_139":140},[132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":133},[35],"pulls","branches",1,"forks",{"_141":77,"_143":77},"connections",{"_141":77,"_142":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":145,"_18":146},[],[35],["D",1775929365825],{"_11":12,"_113":19},{"_11":12,"_108":-5,"_109":19,"_70":71,"_110":111,"_112":53},{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_129":184,"_185":186,"_187":188,"_189":53,"_190":53,"_191":53,"_192":44,"_193":-5,"_194":-7,"_195":-7,"_196":77,"_197":53,"_198":53,"_199":-5,"_200":53,"_201":53,"_202":53,"_203":-5},"ENV",{"_155":156,"_157":158,"_159":16,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Code