[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_156":157,"_158":159},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_118":-5,"_20":119,"_22":120,"_121":122,"_123":124,"_25":125,"_24":-5,"_126":-5,"_127":-5,"_128":53,"_129":130,"_131":44,"_132":-5,"_133":-5,"_134":135},"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","mud2monarch","name","banteg-demo","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":81,"_82":83,"_84":85,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":97,"_98":99,"_100":101,"_102":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","f2caee16-3029-11f1-8022-42dde27851f2","main.ts","fileId","ec0f0e7c-3029-11f1-80f5-42dde27851f2","parentId","branchId","2e738788-3026-11f1-b09a-42dde27851f2","branchVersion",29,"latest",true,"createdAt",["D",1775309215025],3,"fileType","http","content","/**\n * Curve/Yearn vesting escrow tracker — single HTTP val\n *\n * On each page load:\n * 1. Get current block number (race 4 random RPCs)\n * 2. Fetch logs for the last 500 blocks from veCRV + veYFI\n * 3. Write any new events to SQLite\n * 4. Render the last 500 events from DB\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// ─── Config ───────────────────────────────────────────────────────────────────\n\nconst CONTRACTS = {\n veCRV: \"0x5f3b5DfEb7B28CDbD7FAba78963EE202a494e2A2\",\n veYFI: \"0x90c1f9220d90d3966FbeE24045EDd73E1d588aD5\",\n} as const;\n\n// keccak256(\"Deposit(address,uint256,uint256,int128,uint256)\")\nconst DEPOSIT_TOPIC =\n \"0x4566dfc29f6f11d13a418c26a02bef7c28bae749d4de47e4e6a7cddea6730d59\";\n\nconst RPCS = [\n \"https://eth.llamarpc.com\",\n \"https://eth.drpc.org\",\n \"https://singapore.rpc.blxrbdn.com\",\n \"https://uk.rpc.blxrbdn.com\",\n \"https://virginia.rpc.blxrbdn.com\",\n \"https://eth.rpc.blxrbdn.com\",\n \"https://eth.blockrazor.xyz\",\n \"https://eth-mainnet.public.blastapi.io\",\n \"https://eth-mainnet.nodereal.io\",\n \"https://eth.merkle.io\",\n \"https://gateway.tenderly.co/public/mainnet\",\n \"https://mainnet.gateway.tenderly.co\",\n \"https://eth.api.onfinality.io/public\",\n \"https://public-eth.nownodes.io\",\n \"https://rpc.fullsend.to\",\n \"https://rpc.flashbots.net\",\n \"https://rpc.flashbots.net/fast\",\n \"https://ethereum.public.blockpi.network\",\n \"https://0xrpc.io/eth\",\n \"https://rpc.sentio.xyz/mainnet\",\n \"https://eth.meowrpc.com\",\n \"https://rpc.owlracle.info\",\n \"https://ethereum-json-rpc.stakely.io\",\n \"https://eth.api.pocket.network\",\n \"https://eth1.lava.build\",\n \"https://rpc.eth.gateway.fm\",\n \"https://rpc.mevblocker.io\",\n \"https://rpc.mevblocker.io/fast\",\n \"https://api-ethereum-mainnet-reth.n.dwellir.com\",\n \"https://ethereum-rpc.publicnode.com\",\n];\n\nconst LOOKBACK = 500; // blocks to scan per request\n\n// ─── DB ───────────────────────────────────────────────────────────────────────\n\nasync function initDb() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS escrow_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n contract TEXT NOT NULL,\n provider TEXT NOT NULL,\n value TEXT NOT NULL,\n locktime INTEGER NOT NULL,\n type INTEGER NOT NULL,\n block INTEGER NOT NULL,\n tx_hash TEXT NOT NULL,\n log_index INTEGER NOT NULL,\n ts INTEGER NOT NULL,\n UNIQUE(tx_hash, log_index)\n )\n `);\n}\n\n// ─── RPC ──────────────────────────────────────────────────────────────────────\n\nfunction callRpc(method: string, params: unknown[]): Promise {\n const shuffled = [...RPCS].sort(() => Math.random() - 0.5);\n return Promise.any(\n shuffled.slice(0, 4).map((url) =>\n fetch(url, {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({ jsonrpc: \"2.0\", id: 1, method, params }),\n })\n .then((r) => r.json())\n .then((j: any) => {\n if (j.error) throw new Error(j.error.message);\n return j.result;\n })\n ),\n );\n}\n\n// ─── Decode ───────────────────────────────────────────────────────────────────\n\n/**\n * Deposit(address indexed provider, uint256 value, uint256 indexed locktime, int128 type, uint256 ts)\n * topics: [sig, provider, locktime]\n * data: [value, type, ts]\n */\nfunction decodeDeposit(log: any) {\n const provider = \"0x\" + log.topics[1].slice(26);\n const locktime = parseInt(log.topics[2], 16);\n const data = log.data.slice(2);\n return {\n provider,\n value: BigInt(\"0x\" + data.slice(0, 64)).toString(),\n locktime,\n type: parseInt(data.slice(64, 128), 16),\n ts: parseInt(data.slice(128, 192), 16),\n };\n}\n\n// ─── Sync last N blocks ───────────────────────────────────────────────────────\n\nasync function syncRecent() {\n const hex = (await callRpc(\"eth_blockNumber\", [])) as string;\n const head = parseInt(hex, 16);\n const from = head - LOOKBACK;\n\n for (const [name, addr] of Object.entries(CONTRACTS)) {\n const logs = (await callRpc(\"eth_getLogs\", [\n {\n address: addr,\n topics: [DEPOSIT_TOPIC],\n fromBlock: \"0x\" + from.toString(16),\n toBlock: \"0x\" + head.toString(16),\n },\n ])) as any[];\n\n for (const log of logs) {\n const d = decodeDeposit(log);\n await sqlite.execute(\n `INSERT OR IGNORE INTO escrow_events\n (contract, provider, value, locktime, type, block, tx_hash, log_index, ts)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n addr,\n d.provider,\n d.value,\n d.locktime,\n d.type,\n parseInt(log.blockNumber, 16),\n log.transactionHash,\n parseInt(log.logIndex, 16),\n d.ts,\n ],\n );\n }\n }\n\n return head;\n}\n\n// ─── Query ────────────────────────────────────────────────────────────────────\n\nasync function queryEvents() {\n const addrToName: Record = {};\n for (const [name, addr] of Object.entries(CONTRACTS)) {\n addrToName[addr.toLowerCase()] = name;\n }\n\n const { rows } = await sqlite.execute(`\n SELECT contract, provider, value, locktime, type, block, tx_hash, ts\n FROM escrow_events ORDER BY block DESC LIMIT 500\n `);\n\n return rows.map((\n [contract, provider, value, locktime, type_, block, tx_hash, ts],\n ) => ({\n contract: addrToName[String(contract).toLowerCase()] ?? contract,\n provider: String(provider),\n value: (BigInt(value as string) / 10n ** 18n).toString(),\n locktime: Number(locktime),\n type: Number(type_),\n block: Number(block),\n tx_hash: String(tx_hash),\n ts: Number(ts),\n }));\n}\n\n// ─── HTML ─────────────────────────────────────────────────────────────────────\n\nfunction renderHtml(\n events: Awaited>,\n head: number,\n) {\n const fmt = (ts: number) => new Date(ts * 1000).toISOString().slice(0, 10);\n const short = (a: string) => a.slice(0, 6) + \"…\" + a.slice(-4);\n\n const rows = events\n .map(\n (e) =>\n `\n ${e.contract}\n ${\n short(e.provider)\n }\n ${Number(e.value).toLocaleString()}\n ${fmt(e.locktime)}\n ${fmt(e.ts)}\n ${e.block.toLocaleString()}\n ${\n e.tx_hash.slice(0, 10)\n }…\n `,\n )\n .join(\"\");\n\n return `\n\n\n\n\nVesting escrows — veCRV / veYFI\n\n\n\n

Vesting escrows

veCRV & veYFI · last 500 events · head block ${head.toLocaleString()}

\n\n \n \n \n \n ${rows}\n

Contract	Provider	Amount	Unlock	Event date	Block	Tx

\n\n`;\n}\n\n// ─── Handler ──────────────────────────────────────────────────────────────────\n\nexport default async function handler(req: Request): Promise {\n await initDb();\n\n // 3 RPC calls total: 1 eth_blockNumber + 2 eth_getLogs\n const head = await syncRecent();\n const events = await queryEvents();\n\n return new Response(renderHtml(events, head), {\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",1775309215025],"children",[],[35],"2e72e08a-3026-11f1-b09a-42dde27851f2",["D",1775307597135],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","019d5893-f4ab-70ab-aed3-3e998c8b0313","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019d5893-f4ab-70ab-aed3-435519a2c1dc","tursoName","2e72e08a302611f1b09a42dde27851f2","tursoHostname","2e72e08a302611f1b09a42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789500689328],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_117":113},"org",{"_11":12,"_111":-5,"_112":113,"_70":71,"_114":115,"_116":53},"branch",{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNCdFR0RWg2WUk2YUx0bTdHYkJCMlpXWEIwaSJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":151,"_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":81,"_82":83,"_84":152,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":153,"_98":154,"_100":155,"_102":53},[148],"files",[148],"counts",{"_138":77,"_139":140,"_141":77,"_31":142,"_143":144},[136],"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":137},[35],"pulls","branches",1,"forks",{"_145":77,"_147":77},"connections",{"_145":77,"_146":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":149,"_18":150},[],[35],["D",1775307597135],["D",1789500689328],{"_11":12,"_117":113},{"_11":12,"_111":-5,"_112":113,"_70":71,"_114":115,"_116":53},{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"ctx",{"_96":-5,"_133":189,"_190":191,"_192":193,"_194":53,"_195":53,"_196":53,"_197":44,"_198":-5,"_199":-7,"_200":-7,"_201":77,"_202":53,"_203":53,"_204":-5,"_205":53,"_206":53,"_207":53,"_208":-5},"ENV",{"_160":161,"_162":163,"_164":16,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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