[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_208":209,"_210":211},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",4,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","seed.ts","latestPath","fileId","034e6604-b2bc-11f1-960c-1607ee4eb77e","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst sources = {raptive:\"https://ads.cafemedia.com/sellers.json\",mediavine:\"https://www.mediavine.com/sellers.json\",ezoic:\"https://www.ezoic.com/sellers.json\",journey:\"https://sellers.journeymv.com/sellers.json\"};\nawait sqlite.batch([\n {sql:\"CREATE TABLE IF NOT EXISTS snapshots(network TEXT PRIMARY KEY,url TEXT,fetched_at TEXT,http_status INTEGER,sha256 TEXT,raw_json TEXT)\"},\n {sql:\"CREATE TABLE IF NOT EXISTS sellers(network TEXT,seller_id TEXT,domain TEXT,name TEXT,seller_type TEXT,confidential INTEGER,PRIMARY KEY(network,seller_id,domain))\"},\n {sql:\"CREATE INDEX IF NOT EXISTS sellers_domain ON sellers(domain)\"},\n {sql:\"CREATE TABLE IF NOT EXISTS checks(domain TEXT PRIMARY KEY,checked_at TEXT,status TEXT,final_url TEXT,http_status INTEGER,body_sha256 TEXT,ads_body TEXT,evidence_json TEXT,attempts_json TEXT)\"},\n {sql:\"CREATE TABLE IF NOT EXISTS enrichment(domain TEXT PRIMARY KEY,checked_at TEXT,status TEXT,sitemap_count INTEGER,sitemap_status TEXT,result_json TEXT)\"}\n]);\nfunction domainOf(value:unknown):string {try {let x=String(value||'').trim().toLowerCase(); if(!x || /\\s/.test(x)) return ''; const u=new URL(x.includes('://')?x:'https://'+x); const h=u.hostname.replace(/^www\\./,'').replace(/\\.$/,''); if(!h.includes('.')||/^\\d+(\\.\\d+){3}$/.test(h)||h==='localhost')return ''; return h;}catch{return '';}}\nconst summary=[];\nfor(const [network,url] of Object.entries(sources)){\n try {\n const existing=await sqlite.execute({sql:\"SELECT network FROM snapshots WHERE network=?\",args:[network]});\n if(existing.rows.length){summary.push({network,cached:true});continue;}\n const r=await fetch(url,{signal:AbortSignal.timeout(20000),headers:{'User-Agent':'PublisherNetworkResearch/1.0'}}); const raw=await r.text();\n if(!r.ok) throw Error('HTTP '+r.status); const data=JSON.parse(raw);if(!Array.isArray(data.sellers))throw Error('missing sellers');\n const rows=data.sellers.map((x:any)=>[network,String(x.seller_id??''),domainOf(x.domain),String(x.name??''),String(x.seller_type??'').toUpperCase(),Number(!!x.is_confidential)]);\n const sha=Array.from(new Uint8Array(await crypto.subtle.digest('SHA-256',new TextEncoder().encode(raw))),x=>x.toString(16).padStart(2,'0')).join('');\n await sqlite.execute({sql:\"INSERT OR REPLACE INTO snapshots VALUES (?,?,?,?,?,?)\",args:[network,url,new Date().toISOString(),r.status,sha,raw]});\n for(let i=0;ix[2]).filter(Boolean)).size,missing_domain:rows.filter((x:any)=>!x[2]).length,bytes:raw.length,sha256:sha,examples:rows.slice(0,4)});\n }catch(e){summary.push({network,error:String(e)});}\n}\nconsole.log(JSON.stringify({summary}));","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst sources = {raptive:\"https://ads.cafemedia.com/sellers.json\",mediavine:\"https://www.mediavine.com/sellers.json\",ezoic:\"https://ezoic.ai/sellers.json\",journey:\"https://sellers.journeymv.com/sellers.json\"};\nawait sqlite.batch([\n {sql:\"CREATE TABLE IF NOT EXISTS snapshots(network TEXT PRIMARY KEY,url TEXT,fetched_at TEXT,http_status INTEGER,sha256 TEXT,raw_json TEXT)\"},\n {sql:\"CREATE TABLE IF NOT EXISTS sellers(network TEXT,seller_id TEXT,domain TEXT,name TEXT,seller_type TEXT,confidential INTEGER,PRIMARY KEY(network,seller_id,domain))\"},\n {sql:\"CREATE INDEX IF NOT EXISTS sellers_domain ON sellers(domain)\"},\n {sql:\"CREATE TABLE IF NOT EXISTS checks(domain TEXT PRIMARY KEY,checked_at TEXT,status TEXT,final_url TEXT,http_status INTEGER,body_sha256 TEXT,ads_body TEXT,evidence_json TEXT,attempts_json TEXT)\"},\n {sql:\"CREATE TABLE IF NOT EXISTS enrichment(domain TEXT PRIMARY KEY,checked_at TEXT,status TEXT,sitemap_count INTEGER,sitemap_status TEXT,result_json TEXT)\"}\n]);\nfunction domainOf(value:unknown):string {try {let x=String(value||'').trim().toLowerCase(); if(!x || /\\s/.test(x)) return ''; const u=new URL(x.includes('://')?x:'https://'+x); const h=u.hostname.replace(/^www\\./,'').replace(/\\.$/,''); if(!h.includes('.')||/^\\d+(\\.\\d+){3}$/.test(h)||h==='localhost')return ''; return h;}catch{return '';}}\nconst summary=[];\nfor(const [network,url] of Object.entries(sources)){\n try {\n const existing=await sqlite.execute({sql:\"SELECT network FROM snapshots WHERE network=?\",args:[network]});\n if(existing.rows.length){summary.push({network,cached:true});continue;}\n const r=await fetch(url,{signal:AbortSignal.timeout(20000),headers:{'User-Agent':'PublisherNetworkResearch/1.0'}}); const raw=await r.text();\n if(!r.ok) throw Error('HTTP '+r.status); const data=JSON.parse(raw);if(!Array.isArray(data.sellers))throw Error('missing sellers');\n const rows=data.sellers.map((x:any)=>[network,String(x.seller_id??''),domainOf(x.domain),String(x.name??''),String(x.seller_type??'').toUpperCase(),Number(!!x.is_confidential)]);\n const sha=Array.from(new Uint8Array(await crypto.subtle.digest('SHA-256',new TextEncoder().encode(raw))),x=>x.toString(16).padStart(2,'0')).join('');\n await sqlite.execute({sql:\"INSERT OR REPLACE INTO snapshots VALUES (?,?,?,?,?,?)\",args:[network,url,new Date().toISOString(),r.status,sha,raw]});\n for(let i=0;ix[2]).filter(Boolean)).size,missing_domain:rows.filter((x:any)=>!x[2]).length,bytes:raw.length,sha256:sha,examples:rows.slice(0,4)});\n }catch(e){summary.push({network,error:String(e)});}\n}\nconsole.log(JSON.stringify({summary}));","createdAt",["D",1789665634131],"branchVersion","branchId","cd292256-c961-4ceb-b973-27c236575749","id","7e58a892-b130-4895-9cbc-de82614ff56d","publisher-network-audit",["D",1789665566213],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Browse publishers, directory teardowns and ads.txt evidence.","imageUrl","f5be24e4-c798-4816-91e5-037b60b986f5","pinnedFileId","01a0b061-5e61-74b2-9c7e-7b033afc92fc","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","7f67379d-2d38-49bd-81ac-2c7f92a739e2","tursoName","7e58a892b13048959cbcde82614ff56d","tursoHostname","7e58a892b13048959cbcde82614ff56d-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789665692456],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",59,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","omriluz","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycWxkOWxiOE00SkVtZENmRWM4YWxLWTRVUFMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":203,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":204,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":205,"_84":206,"_86":207,"_88":25},"tree",[170,173,174,175],"files",[170,171,172,173,174,175],"counts",{"_160":63,"_161":143,"_162":63,"_163":164,"_165":166},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":155,"_32":50,"_30":156,"_135":-5,"_41":42,"_40":143,"_136":59,"_38":157,"_13":63,"_33":158,"_35":-5,"_24":25,"_139":-5,"_27":159},{"_43":149,"_32":150,"_30":151,"_135":-5,"_41":42,"_40":143,"_136":59,"_38":152,"_13":63,"_33":20,"_35":153,"_24":25,"_139":-5,"_27":154},{"_43":141,"_32":142,"_30":57,"_135":-5,"_41":42,"_40":143,"_136":25,"_38":144,"_13":63,"_33":145,"_35":146,"_24":25,"_139":147,"_27":148},{"_43":134,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_136":25,"_38":137,"_13":138,"_33":34,"_35":37,"_24":25,"_139":-5,"_27":140},"572da02e-6fd8-41b4-989a-2173c29c3c62","parentId","latest",["D",1789665634131],2,"label",[28],"c05c2462-155e-4a5e-9bc0-278c591951a7","index.tsx",1,["D",1789665566213],"http","/** @jsxImportSource npm:hono@4/jsx */\nimport { Hono } from \"npm:hono@4\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\n// In-memory state. Resets whenever the server restarts.\n// For persistence across restarts, use std/sqlite or std/blob.\nlet count = 0;\n\nconst Layout = ({ title, children }: { title: string; children: any }) => (\n \n \n {title}\n \n \n \n \n \n \n \n {children}\n \n \n);\n\nconst app = new Hono();\n\napp.get(\"/\", (c) =>\n c.html(\n \n

Hello from Hono JSX

\n A minimal Val Town starter.{\" \"}\n \n Remix this val.\n \n

\n Server count:{\" \"}\n {count}\n

\n \n Increment\n \n

\n Lives in memory on the server. Resets when the val restarts.\n

\n \n ,\n ));\n\napp.get(\"/about\", (c) =>\n c.html(\n \n

About

Server-rendered with Hono JSX on Val Town.

\n ,\n ));\n\n// API routes\napp.post(\"/api/increment\", (c) => c.json({ count: ++count }));\n\n// Serve static files\napp.get(\"/public/*\", (c) => serveFile(c.req.path));\n\n// View source on Val Town\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;","publisher-explorer-omri",[142],"af49aca0-800e-4cdb-a656-605cafe7a1cb","README.md","01a0b061-5e61-74b2-9c7e-77e87e2983ad",["D",1789665566213],"# hono-jsx-starter\n\nA minimal [Hono](https://hono.dev) + Hono JSX starter for Val Town.\nServer-rendered HTML, no build step, no React.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| **[`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter)** *(you're here)* | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| [`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter) | Client-side React SPA with a Hono API backend. |\n\n## What's here\n\n```\nindex.tsx Hono app, Layout, routes\npublic/\n favicon.svg Static asset\n counter.ts Tiny client-side script\n```\n\nThe whole app fits in one file. As you grow it, the natural next moves are:\n\n- Pull `Layout` into its own `.tsx` file once you have 3+ pages.\n- Split routes with `app.route(\"/api\", api)` if `/api/*` grows.\n- Add more files under `public/` — they're served by a single\n `app.get(\"/public/*\", ...)` route.\n\n## Patterns worth knowing\n\n**JSX pragma.** Every `.tsx` file that uses JSX needs this at the top:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\n```\n\n**Server state.** The counter on `/` is `let count = 0` at module scope. It\nlives in memory on the Val Town server and survives across requests — but resets\nwhenever the val restarts (deploys, idle timeouts, etc.). For persistent state,\nswap it for [`std/sqlite`](https://www.val.town/x/std/sqlite) or\n[`std/blob`](https://www.val.town/x/std/blob).\n\n**API routes.** The `Increment` button POSTs to `/api/increment`, which returns\nJSON. Mix server-rendered pages and JSON endpoints in the same Hono app:\n\n```ts\napp.post(\"/api/increment\", (c) => c.json({ count: ++count }));\n```\n\n**Static files.** `serveFile` reads the file by path and serves it with the\nright content-type. `.ts` files are transpiled to JS on request by Val Town — so\nyou can write `public/counter.ts` and reference it as\n`

Diff · v4