[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_364":365,"_366":367},"routes/_app.x.$handle.$name",{"_98":97,"_31":43,"_106":88,"_26":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":24,"_121":122,"_123":57,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",40,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","reconcile_accounts.ts","latestPath","fileId","7f9aac2e-b2c4-11f1-8461-1607ee4eb77e","name","fileType","script","content","import { sqlite } from 'https://esm.town/v/std/sqlite/main.ts';\nimport { gunzipSync } from 'node:zlib';\nimport { Buffer } from 'node:buffer';\nconst SYSTEMS:Record={'cafemedia.com':'raptive','ads.cafemedia.com':'raptive','adthrive.com':'raptive','raptive.com':'raptive','mediavine.com':'mediavine','journeymv.com':'journey','sellers.journeymv.com':'journey','ezoic.ai':'ezoic','ezoic.com':'ezoic'};\nawait sqlite.execute('CREATE TABLE IF NOT EXISTS account_reconciliation(domain TEXT PRIMARY KEY,reconciled_at TEXT,old_status TEXT,new_status TEXT,same_domain_matches INTEGER,other_domain_matches INTEGER,unreconciled_lines_json TEXT)');\nconst sellerRows=(await sqlite.execute('SELECT network,seller_id,domain FROM sellers')).rows;\nconst known=new Map>();for(const r of sellerRows){const k=r.network+':'+r.seller_id;const ds=known.get(k)??new Set();if(r.domain)ds.add(String(r.domain));known.set(k,ds);}\nlet after='',processed=0,recovered=0,cross=0,unresolved=0;\nwhile(true){const q=await sqlite.execute({sql:\"SELECT c.domain,c.checked_at,c.status,c.ads_body,c.evidence_json FROM checks c LEFT JOIN account_reconciliation a ON c.domain=a.domain WHERE c.domain>? AND c.status IN ('confirmed','no_matching_line') AND a.domain IS NULL ORDER BY c.domain LIMIT 250\",args:[after]});if(!q.rows.length)break;\n const changes:any[]=[],audit:any[]=[];\n for(const r of q.rows){let body='';try{const s=String(r.ads_body??'');if(s.startsWith('gzip+base64:'))body=gunzipSync(Buffer.from(s.slice(12),'base64')).toString('utf8');}catch{}\n const ev:any[]=[],other:any[]=[];let sameN=0,otherN=0;\n for(const [i,raw] of body.split(/\\r?\\n/).entries()){const p=raw.split('#')[0].split(',').map(x=>x.trim());const network=SYSTEMS[p[0]?.toLowerCase()];if(!network||p.length<3||p[2].toUpperCase()!=='DIRECT')continue;\n const ds=known.get(network+':'+p[1]);if(!ds){other.push({network,seller_id:p[1],line:raw.trim(),line_number:i+1,reason:'ID_not_found_in_captured_network_sellers_json'});continue;}\n const same=ds.has(String(r.domain));if(same)sameN++;else otherN++;\n ev.push({network,seller_id:p[1],system:p[0].toLowerCase(),relationship:'DIRECT',line:raw.trim(),line_number:i+1,match_scope:same?'same_domain_seller_record':'seller_account_registered_under_other_domain',seller_record_domains:[...ds].sort()});\n }\n const old=JSON.parse(String(r.evidence_json??'[]'));if(!ev.length&&r.status==='confirmed'&&old.length)ev.push(...old);\n const status=ev.length?'confirmed':other.length?'network_line_unreconciled':'no_matching_line';\n changes.push([r.domain,status,JSON.stringify(ev)]);audit.push([r.domain,new Date().toISOString(),r.status,status,sameN,otherN,JSON.stringify(other)]);\n if(r.status!=='confirmed'&&status==='confirmed')recovered++;if(otherN)cross++;if(status==='network_line_unreconciled')unresolved++;\n }\n await sqlite.execute({sql:\"UPDATE checks AS c SET status=json_extract(j.value,'$[1]'),evidence_json=json_extract(j.value,'$[2]') FROM json_each(?) j WHERE c.domain=json_extract(j.value,'$[0]')\",args:[JSON.stringify(changes)]});\n await sqlite.execute({sql:\"INSERT OR REPLACE INTO account_reconciliation SELECT json_extract(value,'$[0]'),json_extract(value,'$[1]'),json_extract(value,'$[2]'),json_extract(value,'$[3]'),json_extract(value,'$[4]'),json_extract(value,'$[5]'),json_extract(value,'$[6]') FROM json_each(?)\",args:[JSON.stringify(audit)]});\n processed+=q.rows.length;after=String(q.rows.at(-1)!.domain);\n}\nconsole.log(JSON.stringify({processed,recovered,cross_domain_account_sites:cross,unreconciled:unresolved,totals:(await sqlite.execute('SELECT status,COUNT(*) n FROM checks GROUP BY status')).rows}));","createdAt",["D",1789669244924],"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",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":53,"_102":103,"_104":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"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",{"_41":42,"_31":43,"_36":359,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":360,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":361,"_82":362,"_84":363,"_86":24},"tree",[274,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292],"files",[274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292],"counts",{"_264":61,"_265":152,"_266":61,"_267":268,"_269":270},"contents",[128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":259,"_31":48,"_29":260,"_148":-5,"_39":40,"_38":152,"_150":57,"_36":261,"_13":61,"_32":262,"_34":-5,"_23":24,"_155":-5,"_26":263},{"_41":253,"_31":254,"_29":255,"_148":-5,"_39":40,"_38":152,"_150":57,"_36":256,"_13":61,"_32":20,"_34":257,"_23":24,"_155":-5,"_26":258},{"_41":246,"_31":247,"_29":248,"_148":-5,"_39":40,"_38":249,"_150":57,"_36":250,"_13":61,"_32":33,"_34":251,"_23":24,"_155":-5,"_26":252},{"_41":239,"_31":240,"_29":241,"_148":-5,"_39":40,"_38":242,"_150":57,"_36":243,"_13":61,"_32":33,"_34":244,"_23":24,"_155":-5,"_26":245},{"_41":231,"_31":232,"_29":233,"_148":-5,"_39":40,"_38":234,"_150":57,"_36":235,"_13":236,"_32":33,"_34":237,"_23":24,"_155":-5,"_26":238},{"_41":224,"_31":225,"_29":226,"_148":-5,"_39":40,"_38":227,"_150":57,"_36":228,"_13":61,"_32":33,"_34":229,"_23":24,"_155":-5,"_26":230},{"_41":217,"_31":218,"_29":219,"_148":-5,"_39":40,"_38":220,"_150":24,"_36":221,"_13":61,"_32":153,"_34":222,"_23":24,"_155":-5,"_26":223},{"_41":210,"_31":211,"_29":212,"_148":-5,"_39":40,"_38":213,"_150":57,"_36":214,"_13":162,"_32":33,"_34":215,"_23":24,"_155":-5,"_26":216},{"_41":203,"_31":204,"_29":205,"_148":-5,"_39":40,"_38":206,"_150":24,"_36":207,"_13":160,"_32":33,"_34":208,"_23":24,"_155":-5,"_26":209},{"_41":197,"_31":198,"_29":55,"_148":-5,"_39":40,"_38":152,"_150":24,"_36":199,"_13":61,"_32":153,"_34":200,"_23":24,"_155":201,"_26":202},{"_41":190,"_31":191,"_29":192,"_148":-5,"_39":40,"_38":193,"_150":57,"_36":194,"_13":61,"_32":33,"_34":195,"_23":24,"_155":-5,"_26":196},{"_41":183,"_31":184,"_29":185,"_148":-5,"_39":40,"_38":186,"_150":57,"_36":187,"_13":61,"_32":33,"_34":188,"_23":24,"_155":-5,"_26":189},{"_41":180,"_31":27,"_29":30,"_148":-5,"_39":40,"_38":14,"_150":57,"_36":181,"_13":61,"_32":33,"_34":35,"_23":24,"_155":-5,"_26":182},{"_41":173,"_31":174,"_29":175,"_148":-5,"_39":40,"_38":176,"_150":57,"_36":177,"_13":160,"_32":33,"_34":178,"_23":24,"_155":-5,"_26":179},{"_41":165,"_31":166,"_29":167,"_148":-5,"_39":40,"_38":168,"_150":57,"_36":169,"_13":170,"_32":33,"_34":171,"_23":24,"_155":-5,"_26":172},{"_41":157,"_31":158,"_29":159,"_148":-5,"_39":40,"_38":160,"_150":57,"_36":161,"_13":162,"_32":33,"_34":163,"_23":24,"_155":-5,"_26":164},{"_41":145,"_31":146,"_29":147,"_148":-5,"_39":40,"_38":149,"_150":57,"_36":151,"_13":152,"_32":153,"_34":154,"_23":24,"_155":-5,"_26":156},"5d55a250-cd87-4eeb-b054-01fd224810e9","worker.ts","0eb0b968-b2bf-11f1-9613-1607ee4eb77e","parentId",36,"latest",["D",1789668488514],1,"http","import { runScan } from './scan_core.ts';\nimport { runEnrich } from './enrich_core.ts';\nexport default async function(req:Request){\n const key=Deno.env.get('AUDIT_JOB_KEY');\n if(!key||req.headers.get('authorization')!=='Bearer '+key)return new Response('Unauthorized',{status:401});\n if(req.method!=='POST')return new Response('POST required',{status:405});\n try {const b=await req.json();const shard=Number(b.shard),shards=Number(b.shards);if(!Number.isInteger(shard)||!Number.isInteger(shards)||shards<1||shards>16||shard<0||shard>=shards)return new Response('Invalid shard',{status:400});\n const result=b.kind==='scan'?await runScan(shard,shards):b.kind==='retry'?await runScan(shard,shards,true):b.kind==='enrich'?await runEnrich(shard,shards):null;\n if(!result)return new Response('Unknown kind',{status:400});return Response.json({kind:b.kind,shard,...result});\n }catch(e){return Response.json({error:String(e)},{status:500});}\n}","label",[146],"2b083803-4ca0-4fff-943d-cefb65802939","seed.ts","034e6604-b2bc-11f1-960c-1607ee4eb77e",5,["D",1789665652151],3,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { gzipSync } from \"node:zlib\";\nimport { Buffer } from \"node:buffer\";\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 {const 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 const packed=JSON.stringify({encoding:'gzip+base64',data:Buffer.from(gzipSync(raw)).toString('base64'),records:data.sellers.length,original_bytes:raw.length});\n for(let i=0;ix[2]).filter(Boolean)).size,missing_domain:rows.filter((x:any)=>!x[2]).length,bytes:raw.length,stored_bytes:packed.length,sha256:sha,examples:rows.slice(0,3)};summary.push(item);console.log(JSON.stringify(item));\n }catch(e){const item={network,error:String(e)};summary.push(item);console.log(JSON.stringify(item));}\n}\nconsole.log(JSON.stringify({summary}));",[158],"0b4e22bc-abdb-41be-ba07-762fb791a2a4","scan_core.ts","01a0b074-c8b8-73d7-bd15-f8089b2fc32b",35,["D",1789668450576],6,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { gzipSync } from \"node:zlib\";\nimport { Buffer } from \"node:buffer\";\nconst SYSTEMS:Record={raptive:['cafemedia.com','ads.cafemedia.com','adthrive.com','raptive.com'],mediavine:['mediavine.com'],journey:['journeymv.com','sellers.journeymv.com'],ezoic:['ezoic.ai','ezoic.com']};\nexport async function runScan(shard=0,shards=1,retryMode=false){\nconst started=Date.now(), LIMIT=2200, WORKERS=retryMode?45:70, BUDGET=18000;\nconst condition=retryMode?\"c.status='unverified' AND c.checked_at < (SELECT value FROM audit_settings WHERE key='retry_cutoff')\":\"c.domain IS NULL\";\nconst selected=await sqlite.execute({sql:\"SELECT DISTINCT s.domain FROM sellers s LEFT JOIN checks c ON s.domain=c.domain WHERE s.domain<>'' AND (\"+condition+\") AND ((unicode(substr(s.domain,1,1))*31+unicode(substr(s.domain,2,1))+length(s.domain)) % ?) = ? ORDER BY CASE WHEN s.domain LIKE '%directory%' OR s.domain LIKE '%locator%' OR s.domain LIKE '%finder%' THEN 0 ELSE 1 END,s.domain LIMIT ?\",args:[shards,shard,LIMIT]});\nconst domains=selected.rows.map(x=>String(x.domain));\nconst records=await sqlite.execute({sql:\"SELECT domain,network,seller_id FROM sellers WHERE domain IN (SELECT value FROM json_each(?))\",args:[JSON.stringify(domains)]});\nconst map=new Map();for(const r of records.rows){const a=map.get(String(r.domain))??[];a.push(r);map.set(String(r.domain),a);}\nasync function limitedText(r:Response,max=1000000){const rd=r.body?.getReader();if(!rd)return '';let n=0;const arr:Uint8Array[]=[];while(true){const a=await rd.read();if(a.done)break;n+=a.value.length;if(n>max){await rd.cancel();throw Error('body_too_large');}arr.push(a.value);}const b=new Uint8Array(n);let p=0;for(const a of arr){b.set(a,p);p+=a.length;}return new TextDecoder().decode(b);}\nasync function check(domain:string){const attempts:any[]=[];const end=Date.now()+(retryMode?25000:12000);\n for(const url of ['https://'+domain+'/ads.txt','https://www.'+domain+'/ads.txt','http://'+domain+'/ads.txt']){if(Date.now()>end-200)break;try{\n const r=await fetch(url,{redirect:'follow',signal:AbortSignal.timeout(Math.max(200,Math.min(retryMode?12000:6000,end-Date.now()))),headers:{'User-Agent':'PublisherNetworkResearch/1.0 (public ads.txt verification)','Accept':'text/plain,*/*;q=0.5'}});const body=await limitedText(r);const a:any={url,status:r.status,final_url:r.url,bytes:body.length};attempts.push(a);\n if(!r.ok)continue;const parsed=body.split(/\\r?\\n/).map((line,i)=>({raw:line.trim(),parts:line.split('#')[0].trim().split(',').map(x=>x.trim()),line_number:i+1})).filter(x=>x.parts.length>=3&&/\\./.test(x.parts[0])&&['DIRECT','RESELLER'].includes(x.parts[2].toUpperCase()));\n if(/<(?:!doctype\\s+html|html|head|body)(?:\\s|>)/i.test(body.slice(0,2000))||(!parsed.length&&!/(text\\/plain|application\\/octet-stream)/i.test(r.headers.get('content-type')??'')&&body.trim()!=='')){a.invalid_body=true;continue;}\n const evidence:any[]=[];for(const record of map.get(domain)??[])for(const line of parsed)if(SYSTEMS[String(record.network)]?.includes(line.parts[0].toLowerCase())&&line.parts[1]===String(record.seller_id))evidence.push({network:record.network,seller_id:record.seller_id,system:line.parts[0].toLowerCase(),relationship:line.parts[2].toUpperCase(),line:line.raw,line_number:line.line_number});\n const sha=Array.from(new Uint8Array(await crypto.subtle.digest('SHA-256',new TextEncoder().encode(body))),x=>x.toString(16).padStart(2,'0')).join('');a.network_lines=parsed.filter(x=>Object.values(SYSTEMS).flat().includes(x.parts[0].toLowerCase())).map(x=>x.raw);a.parsed_lines=parsed.length;\n return [domain,new Date().toISOString(),evidence.length?'confirmed':'no_matching_line',r.url,r.status,sha,'gzip+base64:'+Buffer.from(gzipSync(body)).toString('base64'),JSON.stringify(evidence),JSON.stringify(attempts)];\n }catch(e){attempts.push({url,error:String(e)});}}\n const missing=attempts.length>0&&attempts.every(x=>[404,410].includes(x.status));return [domain,new Date().toISOString(),missing?'ads_txt_missing':'unverified',attempts.at(-1)?.final_url??'',attempts.at(-1)?.status??null,'','','[]',JSON.stringify(attempts)];}\nconst INSERT=\"INSERT OR REPLACE INTO checks SELECT json_extract(value,'$[0]'),json_extract(value,'$[1]'),json_extract(value,'$[2]'),json_extract(value,'$[3]'),json_extract(value,'$[4]'),json_extract(value,'$[5]'),json_extract(value,'$[6]'),json_extract(value,'$[7]'),json_extract(value,'$[8]') FROM json_each(?)\";\nlet next=0,saved=0,failedWrites=0;const counts:Record={};let buf:any[]=[];let bufSize=0;let chain=Promise.resolve();\nfunction enqueue(){if(!buf.length)return;const batch=buf;buf=[];bufSize=0;chain=chain.then(async()=>{for(let attempt=0;attempt<4;attempt++){try{await sqlite.execute({sql:INSERT,args:[JSON.stringify(batch)]});saved+=batch.length;return;}catch(e){if(attempt===3){failedWrites+=batch.length;console.log(JSON.stringify({write_error:String(e),unsaved_domains:batch.map(r=>r[0])}));}else await new Promise(r=>setTimeout(r,400*(attempt+1)));}}});}\nawait Promise.all(Array.from({length:WORKERS},async()=>{while(next120000)enqueue();buf.push(row);bufSize+=size;if(buf.length>=35)enqueue();}}));enqueue();await chain;\nreturn {attempted:next,saved,failedWrites,duration_ms:Date.now()-started,batch_counts:counts};\n}",[166],"594ad361-19be-443c-b029-86a91f941bb9","scan.ts","5a6159ba-b2bc-11f1-b240-1607ee4eb77e",14,["D",1789666546661],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { gzipSync } from \"node:zlib\";\nimport { Buffer } from \"node:buffer\";\nconst SYSTEMS:Record={raptive:['cafemedia.com','ads.cafemedia.com','adthrive.com','raptive.com'],mediavine:['mediavine.com'],journey:['journeymv.com','sellers.journeymv.com'],ezoic:['ezoic.ai','ezoic.com']};\nconst started=Date.now(), LIMIT=7000, WORKERS=300, BUDGET=40000;\nconst selected=await sqlite.execute({sql:\"SELECT DISTINCT s.domain FROM sellers s LEFT JOIN checks c ON s.domain=c.domain WHERE s.domain<>'' AND c.domain IS NULL ORDER BY CASE WHEN s.domain LIKE '%directory%' OR s.domain LIKE '%locator%' OR s.domain LIKE '%finder%' THEN 0 ELSE 1 END,s.domain LIMIT ?\",args:[LIMIT]});\nconst domains=selected.rows.map(x=>String(x.domain));\nconst records=await sqlite.execute({sql:\"SELECT domain,network,seller_id FROM sellers WHERE domain IN (SELECT value FROM json_each(?))\",args:[JSON.stringify(domains)]});\nconst map=new Map();for(const r of records.rows){const a=map.get(String(r.domain))??[];a.push(r);map.set(String(r.domain),a);}\nasync function limitedText(r:Response,max=1000000){const rd=r.body?.getReader();if(!rd)return '';let n=0;const arr:Uint8Array[]=[];while(true){const a=await rd.read();if(a.done)break;n+=a.value.length;if(n>max){await rd.cancel();throw Error('body_too_large');}arr.push(a.value);}const b=new Uint8Array(n);let p=0;for(const a of arr){b.set(a,p);p+=a.length;}return new TextDecoder().decode(b);}\nasync function check(domain:string){const attempts:any[]=[];const end=Date.now()+12000;\n for(const url of ['https://'+domain+'/ads.txt','https://www.'+domain+'/ads.txt','http://'+domain+'/ads.txt']){if(Date.now()>end-200)break;try{\n const r=await fetch(url,{redirect:'follow',signal:AbortSignal.timeout(Math.max(200,Math.min(6000,end-Date.now()))),headers:{'User-Agent':'PublisherNetworkResearch/1.0 (public ads.txt verification)','Accept':'text/plain,*/*;q=0.5'}});const body=await limitedText(r);const a:any={url,status:r.status,final_url:r.url,bytes:body.length};attempts.push(a);\n if(!r.ok)continue;const parsed=body.split(/\\r?\\n/).map((line,i)=>({raw:line.trim(),parts:line.split('#')[0].trim().split(',').map(x=>x.trim()),line_number:i+1})).filter(x=>x.parts.length>=3&&/\\./.test(x.parts[0])&&['DIRECT','RESELLER'].includes(x.parts[2].toUpperCase()));\n if(/<(?:!doctype\\s+html|html|head|body)(?:\\s|>)/i.test(body.slice(0,2000))||(!parsed.length&&!/(text\\/plain|application\\/octet-stream)/i.test(r.headers.get('content-type')??'')&&body.trim()!=='')){a.invalid_body=true;continue;}\n const evidence:any[]=[];for(const record of map.get(domain)??[])for(const line of parsed)if(SYSTEMS[String(record.network)]?.includes(line.parts[0].toLowerCase())&&line.parts[1]===String(record.seller_id))evidence.push({network:record.network,seller_id:record.seller_id,system:line.parts[0].toLowerCase(),relationship:line.parts[2].toUpperCase(),line:line.raw,line_number:line.line_number});\n const sha=Array.from(new Uint8Array(await crypto.subtle.digest('SHA-256',new TextEncoder().encode(body))),x=>x.toString(16).padStart(2,'0')).join('');a.network_lines=parsed.filter(x=>Object.values(SYSTEMS).flat().includes(x.parts[0].toLowerCase())).map(x=>x.raw);a.parsed_lines=parsed.length;\n return [domain,new Date().toISOString(),evidence.length?'confirmed':'no_matching_line',r.url,r.status,sha,'gzip+base64:'+Buffer.from(gzipSync(body)).toString('base64'),JSON.stringify(evidence),JSON.stringify(attempts)];\n }catch(e){attempts.push({url,error:String(e)});}}\n const missing=attempts.length>0&&attempts.every(x=>[404,410].includes(x.status));return [domain,new Date().toISOString(),missing?'ads_txt_missing':'unverified',attempts.at(-1)?.final_url??'',attempts.at(-1)?.status??null,'','','[]',JSON.stringify(attempts)];}\nconst INSERT=\"INSERT OR REPLACE INTO checks SELECT json_extract(value,'$[0]'),json_extract(value,'$[1]'),json_extract(value,'$[2]'),json_extract(value,'$[3]'),json_extract(value,'$[4]'),json_extract(value,'$[5]'),json_extract(value,'$[6]'),json_extract(value,'$[7]'),json_extract(value,'$[8]') FROM json_each(?)\";\nlet next=0,saved=0,failedWrites=0;const counts:Record={};let buf:any[]=[];let bufSize=0;let chain=Promise.resolve();\nfunction enqueue(){if(!buf.length)return;const batch=buf;buf=[];bufSize=0;chain=chain.then(async()=>{for(let attempt=0;attempt<4;attempt++){try{await sqlite.execute({sql:INSERT,args:[JSON.stringify(batch)]});saved+=batch.length;return;}catch(e){if(attempt===3){failedWrites+=batch.length;console.log(JSON.stringify({write_error:String(e),unsaved_domains:batch.map(r=>r[0])}));}else await new Promise(r=>setTimeout(r,400*(attempt+1)));}}});}\nawait Promise.all(Array.from({length:WORKERS},async()=>{while(next120000)enqueue();buf.push(row);bufSize+=size;if(buf.length>=35)enqueue();}}));enqueue();await chain;\nconsole.log(JSON.stringify({attempted:next,saved,failedWrites,duration_ms:Date.now()-started,batch_counts:counts,totals:(await sqlite.execute('SELECT status,COUNT(*) n FROM checks GROUP BY status')).rows}));",[174],"55e7b401-95fe-4e33-bb3e-9c8911f12dea",["D",1789669244924],[27],"f24a1098-71f3-4234-9251-0f37ad2d8fb6","reclassify.ts","baca6510-b2c3-11f1-9291-1607ee4eb77e",39,["D",1789668914727],"import { sqlite } from 'https://esm.town/v/std/sqlite/main.ts';\nimport { classifySite } from './classify.ts';\nlet after='',changed=0;\nwhile(true){const q=await sqlite.execute({sql:\"SELECT domain,json_extract(result_json,'$.homepage') homepage,json_extract(result_json,'$.url_patterns') patterns,json_extract(result_json,'$.sitemap.files') files,json_extract(result_json,'$.sample_urls') samples FROM enrichment WHERE domain>? AND COALESCE(json_extract(result_json,'$.classification.version'),0)<2 ORDER BY domain LIMIT 100\",args:[after]});if(!q.rows.length)break;\n const updates=[];for(const r of q.rows){const meta=JSON.parse(String(r.homepage??'{}')),patterns=JSON.parse(String(r.patterns??'[]')),files=JSON.parse(String(r.files??'[]'));const total=patterns.reduce((n:number,p:any)=>n+p.count,0);let sample:string[]=[];for(const p of patterns){const n=Math.max(1,Math.round(300*p.count/Math.max(total,1)));for(let i=0;i (\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",[198],"425e9061-7962-4f28-a899-b9610e973f4d","enrich_core.ts","01a0b075-429a-70af-87d6-fa93cd9ce0e4",38,["D",1789668770024],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { gunzipSync } from \"node:zlib\";\nimport { XMLParser } from \"npm:fast-xml-parser@4.5.3\";\nimport { classifySite } from './classify.ts';\nexport async function runEnrich(shard=0,shards=1){\n const started=Date.now(),BUDGET=30000,WORKERS=100,LIMIT=3000,SITE_MS=18000;\n const rows=await sqlite.execute({sql:\"SELECT c.domain FROM checks c LEFT JOIN enrichment e ON c.domain=e.domain WHERE c.status='confirmed' AND e.domain IS NULL AND ((unicode(substr(c.domain,1,1))*31+unicode(substr(c.domain,2,1))+length(c.domain)) % ?) = ? ORDER BY CASE WHEN c.domain LIKE '%directory%' OR c.domain LIKE '%locator%' OR c.domain LIKE '%finder%' OR c.domain IN ('worldpopulationreview.com','campsitephotos.com') THEN 0 ELSE 1 END,c.domain LIMIT ?\",args:[shards,shard,LIMIT]});\n const domains=rows.rows.map(x=>String(x.domain));\n const parser=new XMLParser({ignoreAttributes:true,removeNSPrefix:true,parseTagValue:false,processEntities:false,trimValues:true});\n const arr=(x:any)=>x==null?[]:Array.isArray(x)?x:[x];\n const unesc=(s:string)=>s.replace(/&/g,'&').replace(/</g,'<').replace(/>/g,'>').replace(/"/g,'\"').replace(/'/g,\"'\");\n const plain=(s:string)=>unesc(s.replace(/]*>[\\s\\S]*?<\\/script>/gi,' ').replace(/]*>[\\s\\S]*?<\\/style>/gi,' ').replace(/<[^>]+>/g,' ').replace(/\\s+/g,' ')).trim();\n async function get(url:string,end:number,max=7000000):Promise{try{const left=end-Date.now();if(left<300)return {url,error:'site_time_budget'};const r=await fetch(url,{signal:AbortSignal.timeout(Math.min(8000,left)),headers:{'User-Agent':'PublisherNetworkResearch/1.0 (sitemap and public-page research)'}});const rd=r.body?.getReader();const chunks:Uint8Array[]=[];let n=0;if(rd)while(true){const p=await rd.read();if(p.done)break;n+=p.value.length;if(n>max){await rd.cancel();return {url,final_url:r.url,status:r.status,error:'body_size_limit'};}chunks.push(p.value);}let b=new Uint8Array(n);let offset=0;for(const c of chunks){b.set(c,offset);offset+=c.length;}if(b[0]===31&&b[1]===139)b=new Uint8Array(gunzipSync(b,{maxOutputLength:20000000}));return {url,final_url:r.url,status:r.status,body:new TextDecoder().decode(b),bytes:b.length};}catch(e){return {url,error:String(e)};}}\n function links(html:string,base:string){const out:any[]=[];for(const m of html.matchAll(/]*href\\s*=\\s*[\"']([^\"']+)[\"'][^>]*>([\\s\\S]*?)<\\/a>/gi)){try{const u=new URL(unesc(m[1]),base);if(!/^https?:$/.test(u.protocol))continue;out.push({url:u.href,text:plain(m[2]).slice(0,100)});}catch{}}return out;}\n function metadata(body:string){const title=plain(body.match(/]*>([\\s\\S]*?)<\\/title>/i)?.[1]??'');const desc=body.match(/]*name\\s*=\\s*[\"']description[\"'][^>]*content\\s*=\\s*[\"']([^\"']*)/i)?.[1]??body.match(/]*content\\s*=\\s*[\"']([^\"']*)[\"'][^>]*name\\s*=\\s*[\"']description/i)?.[1]??'';const schema=[...body.matchAll(/\"@type\"\\s*:\\s*\"([^\"]+)\"/g)].map(x=>x[1]);return {title,description:unesc(desc),schema_types:[...new Set(schema)],wordpress:/wp-content|wp-includes|wp-json/i.test(body)};}\n function patterns(urls:string[]){const first:Record={};const paths=urls.map(x=>{try{return new URL(x).pathname;}catch{return '';}});for(const p of paths){const s=p.split('/').filter(Boolean);if(s[0])first[s[0]]=(first[s[0]]??0)+1;}const counts=new Map();for(let i=0;i/^\\d{4}$/.test(x)?'{year}':/^\\d+$/.test(x)?'{id}':j===0&&s.length>1&&(first[x]??0)>=3?x:x.endsWith('.html')?'{slug}.html':x.endsWith('.php')?'{slug}.php':'{slug}').join('/')+(p.endsWith('/')&&s.length?'/':'');const c=counts.get(k)??{count:0,examples:[]};c.count++;if(c.examples.length<3)c.examples.push(urls[i]);counts.set(k,c);}return [...counts.entries()].map(([pattern,v])=>({pattern,...v})).sort((a,b)=>b.count-a.count).slice(0,20);}\n async function enrich(domain:string){const end=Date.now()+SITE_MS;const [home,robots]=await Promise.all([get('https://'+domain+'/',end,1500000),get('https://'+domain+'/robots.txt',end,500000)]);const origin=home.final_url?new URL(home.final_url).origin:'https://'+domain;const canonicalHost=new URL(origin).hostname.replace(/^www\\./,'');const meta=metadata(home.status===200?home.body??'':'');const homeText=plain(home.status===200?home.body??'':'');const declared=(robots.status===200&&robots.body)?[...robots.body.matchAll(/^\\s*sitemap\\s*:\\s*(\\S+)\\s*$/gim)].map((m:any)=>unesc(m[1])):[];\n const roots=[...new Set(declared)];const queue:string[]=[...roots],seen=new Set(),pageUrls=new Set(),files:any[]=[];let errors=0,valid=0,offsite=0,assets=0,capped=false;\n async function parseMap(url:string){if(seen.has(url))return;seen.add(url);const f=await get(url,end);const rec:any={url,final_url:f.final_url??'',http_status:f.status??null,bytes:f.bytes??0};files.push(rec);if(f.status!==200||f.error){rec.error=f.error??'HTTP '+f.status;errors++;return;}try{if(!/<(?:[\\w-]+:)?(?:sitemapindex|urlset)\\b/.test(f.body)){rec.error='not_xml_sitemap';errors++;return;}const doc=parser.parse(f.body);if(doc.sitemapindex){const children=arr(doc.sitemapindex.sitemap).map(x=>x?.loc).filter((x:any)=>typeof x==='string');rec.kind='index';rec.child_count=children.length;valid++;for(const x of children){try{const u=new URL(unesc(x),f.final_url||url).href;if(!/^https?:/.test(u))continue;if(!seen.has(u)&&!queue.includes(u))queue.push(u);}catch{errors++;}}}else if(doc.urlset){rec.kind='urlset';let n=0;valid++;for(const item of arr(doc.urlset.url)){if(typeof item?.loc!=='string')continue;let u:URL;try{u=new URL(unesc(item.loc));u.hash='';if(!/^https?:$/.test(u.protocol))continue;}catch{continue;}const h=u.hostname.replace(/^www\\./,'');if(h!==domain&&h!==canonicalHost&&!h.endsWith('.'+domain)){offsite++;continue;}if(/\\.(?:jpg|jpeg|png|gif|webp|svg|pdf|mp4|mp3|css|js|zip|kml|xml|json|csv|txt|xlsx|rss|gz)$/i.test(u.pathname)){assets++;continue;}if(pageUrls.size>=100000){capped=true;break;}pageUrls.add(u.href);n++;}rec.page_url_entries=n;}else{rec.error='unknown_xml_root';errors++;}}catch(e){rec.error=String(e);errors++;}}\n if(!queue.length){for(const name of ['/sitemap.xml','/sitemap_index.xml','/wp-sitemap.xml']){await parseMap(origin+name);if(valid){roots.push(origin+name);errors=0;break;}if(Date.now()>end-1500)break;}}\n while(queue.length&&Date.now()!seen.has(x));await Promise.all(batch.map(parseMap));}\n if(queue.length||capped)capped=true;\n const urls=[...pageUrls],cls=classifySite(domain,meta,homeText,urls,files),homeLinks=links(home.body??'',home.final_url??origin);\n const rank=(u:string)=>/\\/(?:methodology|data-sources?|sources)(?:\\/|$|[?#])/i.test(u)?3:/\\/(?:about(?:-us)?|aboutus)(?:[./]|$)/i.test(u)?2:1;\n const about=[...new Map(homeLinks.filter(x=>{try{return new URL(x.url).hostname.replace(/^www\\./,'')===canonicalHost&&/\\/(?:about(?:-us)?|aboutus|methodology|data-sources?|sources|faq)(?:[./?#]|$)/i.test(x.url);}catch{return false;}}).map(x=>[x.url,x])).values()].sort((a,b)=>rank(b.url)-rank(a.url)).slice(0,5);\n const sourcePages:any[]=[];if(['directory','database_reference'].includes(cls.type)&&about[0]&&Date.now()=10)break;}if(provenance.length>=10)break;}\n const status=valid?(errors||capped?'partial':'complete_discovered_tree'):'unavailable';const result={domain,checked_at:new Date().toISOString(),homepage:{url:home.final_url??origin,http_status:home.status??null,error:home.error??null,...meta,text_excerpt:homeText.slice(0,1800)},classification:cls,sitemap:{status,page_count:valid?urls.length:null,count_definition:'Unique non-asset page URLs in fetched sitemaps; not indexed pages or total site pages',roots,files,remaining_files:queue.length,offsite_urls_skipped:offsite,asset_urls_skipped:assets,limits:{max_files:80,max_unique_urls:100000,site_ms:SITE_MS},robots_status:robots.status??null},url_patterns:patterns(urls),sample_urls:urls.length>60?Array.from({length:60},(_,i)=>urls[Math.floor(i*urls.length/60)]):urls,about_links:about,source_evidence:provenance,data_source_status:provenance.length?'mentions_found_requires_review':home.status===200?'unknown_not_disclosed_in_checked_pages':'unknown_pages_unavailable',source_pages:sourcePages};\n return [domain,result.checked_at,'done',result.sitemap.page_count,status,JSON.stringify(result)];\n }\n const INSERT=\"INSERT OR REPLACE INTO enrichment SELECT json_extract(value,'$[0]'),json_extract(value,'$[1]'),json_extract(value,'$[2]'),json_extract(value,'$[3]'),json_extract(value,'$[4]'),json_extract(value,'$[5]') FROM json_each(?)\";\n let i=0,saved=0,failedWrites=0,buf:any[]=[],bufSize=0,chain=Promise.resolve();\n function enqueue(){if(!buf.length)return;const batch=buf;buf=[];bufSize=0;chain=chain.then(async()=>{for(let a=0;a<3;a++){try{await sqlite.execute({sql:INSERT,args:[JSON.stringify(batch)]});saved+=batch.length;return;}catch(e){if(a===2){failedWrites+=batch.length;console.log(JSON.stringify({write_error:String(e),domains:batch.map(r=>r[0])}));}else await new Promise(r=>setTimeout(r,400*(a+1)));}}});}\n await Promise.all(Array.from({length:WORKERS},async()=>{while(i110000)enqueue();buf.push(row);bufSize+=n;if(buf.length>=12)enqueue();}}));enqueue();await chain;\n return {attempted:i,enriched:saved,failedWrites,duration_ms:Date.now()-started};\n}",[204],"4b6d882c-9f29-4b36-9c98-1022fb8088dd","enrich.ts","11ddbb7e-b2bd-11f1-b912-1607ee4eb77e",15,["D",1789666680342],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { gunzipSync } from \"node:zlib\";\nimport { XMLParser } from \"npm:fast-xml-parser@4.5.3\";\nconst started=Date.now(),BUDGET=50000,WORKERS=160,LIMIT=5000;\nconst rows=await sqlite.execute({sql:\"SELECT c.domain FROM checks c LEFT JOIN enrichment e ON c.domain=e.domain WHERE c.status='confirmed' AND e.domain IS NULL ORDER BY CASE WHEN c.domain LIKE '%directory%' OR c.domain LIKE '%locator%' OR c.domain LIKE '%finder%' OR c.domain IN ('worldpopulationreview.com','campsitephotos.com') THEN 0 ELSE 1 END,c.domain LIMIT ?\",args:[LIMIT]});\nconst domains=rows.rows.map(x=>String(x.domain));\nconst parser=new XMLParser({ignoreAttributes:true,removeNSPrefix:true,parseTagValue:false,processEntities:false,trimValues:true});\nconst arr=(x:any)=>x==null?[]:Array.isArray(x)?x:[x];\nconst unesc=(s:string)=>s.replace(/&/g,'&').replace(/</g,'<').replace(/>/g,'>').replace(/"/g,'\"').replace(/'/g,\"'\");\nconst plain=(s:string)=>unesc(s.replace(/]*>[\\s\\S]*?<\\/script>/gi,' ').replace(/]*>[\\s\\S]*?<\\/style>/gi,' ').replace(/<[^>]+>/g,' ').replace(/\\s+/g,' ')).trim();\nasync function get(url:string,end:number,max=7000000):Promise{try{const left=end-Date.now();if(left<300)return {url,error:'site_time_budget'};const r=await fetch(url,{signal:AbortSignal.timeout(Math.min(6500,left)),headers:{'User-Agent':'PublisherNetworkResearch/1.0 (sitemap and public-page research)'}});const rd=r.body?.getReader();const chunks:Uint8Array[]=[];let n=0;if(rd)while(true){const p=await rd.read();if(p.done)break;n+=p.value.length;if(n>max){await rd.cancel();return {url,final_url:r.url,status:r.status,error:'body_size_limit'};}chunks.push(p.value);}let b=new Uint8Array(n);let offset=0;for(const c of chunks){b.set(c,offset);offset+=c.length;}if(b[0]===31&&b[1]===139)b=new Uint8Array(gunzipSync(b,{maxOutputLength:20000000}));return {url,final_url:r.url,status:r.status,body:new TextDecoder().decode(b),bytes:b.length};}catch(e){return {url,error:String(e)};}}\nfunction links(html:string,base:string){const out:any[]=[];for(const m of html.matchAll(/]*href\\s*=\\s*[\"']([^\"']+)[\"'][^>]*>([\\s\\S]*?)<\\/a>/gi)){try{const u=new URL(unesc(m[1]),base);if(!/^https?:$/.test(u.protocol))continue;out.push({url:u.href,text:plain(m[2]).slice(0,100)});}catch{}}return out;}\nfunction metadata(body:string){const title=plain(body.match(/]*>([\\s\\S]*?)<\\/title>/i)?.[1]??'');const desc=body.match(/]*name\\s*=\\s*[\"']description[\"'][^>]*content\\s*=\\s*[\"']([^\"']*)/i)?.[1]??body.match(/]*content\\s*=\\s*[\"']([^\"']*)[\"'][^>]*name\\s*=\\s*[\"']description/i)?.[1]??'';const schema=[...body.matchAll(/\"@type\"\\s*:\\s*\"([^\"]+)\"/g)].map(x=>x[1]);return {title,description:unesc(desc),schema_types:[...new Set(schema)],wordpress:/wp-content|wp-includes|wp-json/i.test(body)};}\nfunction categorize(domain:string,meta:any,text:string,urls:string[],maps:any[]){const head=(meta.title+' '+meta.description+' '+text.slice(0,500)).toLowerCase();const d=/\\bdirector(?:y|ies)\\b|\\blocator\\b|find (?:a |the |local )?(?:business|clinic|campground|store|boat ramp|toilet|doctor|facility|facilities|dentist)/i.test(head)||/directory|locator/.test(domain);const places=meta.schema_types.some((x:string)=>/LocalBusiness|MedicalClinic|Place|CivicStructure|LodgingBusiness/.test(x));const tool=/calculator|converter|generator|checker|word finder|bpm finder|fare finder|ip location/.test(head);const reference=/population|census|dictionary|encyclopedia|database|surname|lyrics|postal code|zip code/.test(head);const forum=/forum|community forums|discussion board/.test(meta.title.toLowerCase())||urls.some(x=>/\\/(?:threads|forums)\\//.test(x));const posts=maps.some(x=>/post-sitemap|wp-sitemap-posts-post/.test(x.url));const blog=posts||meta.schema_types.some((x:string)=>/BlogPosting|Article|NewsArticle/.test(x))||/\\bblog\\b|recipes|latest articles|latest posts/.test(head);let type='unknown',confidence='low',reason='Insufficient distinctive evidence';if(d){type='directory';confidence=d?'medium':'low';reason='Directory/locator language or place/business schema; automated classification';}else if(tool){type='tool';confidence='medium';reason='Calculator/converter/generator/finder language';}else if(forum){type='forum';confidence='medium';reason='Forum language or thread URL structure';}else if(reference){type='database_reference';confidence='medium';reason='Structured reference/database language';}else if(blog){type='blog';confidence='medium';reason=posts?'Post sitemap discovered':'Article/blog/recipe language or schema';}return {type,confidence,reason,review_status:'automated_not_manually_reviewed',has_editorial_section:blog};}\nfunction patterns(urls:string[]){const first:Record={};const paths=urls.map(x=>{try{return new URL(x).pathname;}catch{return '';}});for(const p of paths){const s=p.split('/').filter(Boolean);if(s[0])first[s[0]]=(first[s[0]]??0)+1;}const counts=new Map();for(let i=0;i/^\\d{4}$/.test(x)?'{year}':/^\\d+$/.test(x)?'{id}':j===0&&s.length>1&&(first[x]??0)>=3?x:x.endsWith('.html')?'{slug}.html':x.endsWith('.php')?'{slug}.php':'{slug}').join('/')+(p.endsWith('/')&&s.length?'/':'');const c=counts.get(k)??{count:0,examples:[]};c.count++;if(c.examples.length<3)c.examples.push(urls[i]);counts.set(k,c);}return [...counts.entries()].map(([pattern,v])=>({pattern,...v})).sort((a,b)=>b.count-a.count).slice(0,15);}\nasync function enrich(domain:string){const end=Date.now()+18000;const [home,robots]=await Promise.all([get('https://'+domain+'/',end,1500000),get('https://'+domain+'/robots.txt',end,500000)]);const origin=home.final_url?new URL(home.final_url).origin:'https://'+domain;const meta=metadata(home.body??'');const homeText=plain(home.body??'');const declared=(robots.status===200&&robots.body)?[...robots.body.matchAll(/^\\s*sitemap\\s*:\\s*(\\S+)\\s*$/gim)].map((m:any)=>unesc(m[1])):[];\n const roots=[...new Set(declared)];const queue:string[]=[...roots],seen=new Set(),pageUrls=new Set(),files:any[]=[];let errors=0,valid=0,offsite=0,assets=0,capped=false;\n async function parseMap(url:string){if(seen.has(url))return;seen.add(url);const f=await get(url,end);const rec:any={url,final_url:f.final_url??'',http_status:f.status??null,bytes:f.bytes??0};files.push(rec);if(f.status!==200||f.error){rec.error=f.error??'HTTP '+f.status;errors++;return;}try{if(!/<(?:[\\w-]+:)?(?:sitemapindex|urlset)\\b/.test(f.body)){rec.error='not_xml_sitemap';errors++;return;}const doc=parser.parse(f.body);if(doc.sitemapindex){const children=arr(doc.sitemapindex.sitemap).map(x=>x?.loc).filter((x:any)=>typeof x==='string');rec.kind='index';rec.child_count=children.length;valid++;for(const x of children){try{const u=new URL(unesc(x),f.final_url||url).href;if(!seen.has(u)&&!queue.includes(u))queue.push(u);}catch{errors++;}}}else if(doc.urlset){rec.kind='urlset';let n=0;valid++;for(const item of arr(doc.urlset.url)){if(typeof item?.loc!=='string')continue;let u:URL;try{u=new URL(unesc(item.loc));u.hash='';}catch{continue;}if(u.hostname.replace(/^www\\./,'')!==domain&&!u.hostname.endsWith('.'+domain)){offsite++;continue;}if(/\\.(?:jpg|jpeg|png|gif|webp|svg|pdf|mp4|mp3|css|js|zip|kml|xml|json|csv|txt|xlsx|rss|gz)$/i.test(u.pathname)){assets++;continue;}pageUrls.add(u.href);n++;if(pageUrls.size>=100000){capped=true;break;}}rec.page_url_entries=n;}else{rec.error='unknown_xml_root';errors++;}}catch(e){rec.error=String(e);errors++;}}\n if(!queue.length){for(const name of ['/sitemap.xml','/sitemap_index.xml','/wp-sitemap.xml']){await parseMap(origin+name);if(valid){roots.push(origin+name);errors=0;break;}if(Date.now()>end-1500)break;}}\n while(queue.length&&Date.now()!seen.has(x));await Promise.all(batch.map(parseMap));}\n if(queue.length||seen.size>=80||capped)capped=true;\n const urls=[...pageUrls];const cls=categorize(domain,meta,homeText,urls,files);const homeLinks=links(home.body??'',home.final_url??origin);const about=homeLinks.filter(x=>{try{return new URL(x.url).hostname.replace(/^www\\./,'')===domain&&/about|methodology|data-source|sources|faq/i.test(x.url+' '+x.text);}catch{return false;}}).sort((a,b)=>Number(/methodology|sources/.test(b.url))-Number(/methodology|sources/.test(a.url))).slice(0,5);\n const sourcePages:any[]=[];if(cls.type==='directory'||cls.type==='database_reference'){if(about[0]&&Date.now()=12)break;}}\n const status=valid?(errors||capped?'partial':'complete_discovered_tree'):'unavailable';const result={domain,checked_at:new Date().toISOString(),homepage:{url:home.final_url??origin,http_status:home.status??null,error:home.error??null,...meta,text_excerpt:homeText.slice(0,1800)},classification:cls,sitemap:{status,page_count:valid?urls.length:null,count_definition:'Unique non-asset page URLs in fetched sitemaps; not indexed pages or total site pages',roots,files,remaining_files:queue.length,offsite_urls_skipped:offsite,asset_urls_skipped:assets,limits:{max_files:80,max_unique_urls:100000,site_ms:18000},robots_status:robots.status??null},url_patterns:patterns(urls),sample_urls:urls.slice(0,12),about_links:about,source_evidence:provenance,data_source_status:provenance.length?'mentions_found_requires_review':'unknown_not_disclosed_in_checked_pages',source_pages:sourcePages};\n return [domain,result.checked_at,'done',result.sitemap.page_count,status,JSON.stringify(result)];}\nlet i=0;const out:any[]=[];await Promise.all(Array.from({length:WORKERS},async()=>{while(i180000)await save();chunk.push(r);size+=n;}await save();console.log(JSON.stringify({enriched:out.length,duration_ms:Date.now()-started,totals:(await sqlite.execute(\"SELECT json_extract(result_json,'$.classification.type') type,sitemap_status,COUNT(*) n FROM enrichment GROUP BY 1,2\")).rows,examples:out.slice(0,4).map(r=>{const d=JSON.parse(r[5]);return {domain:r[0],count:r[3],status:r[4],classification:d.classification};})}));",[211],"6d84623f-0103-42af-8a21-09a56eda2a8d","download.ts","7645eebc-b2c0-11f1-a2dc-1607ee4eb77e",27,["D",1789667511273],"import { sqlite } from 'https://esm.town/v/std/sqlite/main.ts';\n// Read-only export. Credentials are checked but never included in the output.\nconst encoder=new TextEncoder();\nfunction cell(v:unknown){let s=v==null?'':String(v).replace(/[\\r\\n\\t]+/g,' ');if(/^[=+@-]/.test(s))s=\"'\"+s;return '\"'+s.replaceAll('\"','\"\"')+'\"';}\nexport default async function(req:Request){\n const url=new URL(req.url);const expected=Deno.env.get('AUDIT_EXPORT_KEY');const supplied=req.headers.get('authorization')?.replace(/^Bearer /,'')??url.searchParams.get('key');\n if(!expected||supplied!==expected)return new Response('Unauthorized',{status:401});\n if(req.method!=='GET')return new Response('GET required',{status:405});\n const kind=url.searchParams.get('kind')??'confirmed';\n if(!['all','confirmed','directories','excluded','unresolved'].includes(kind))return new Response('Invalid dataset',{status:400});\n const headings=['domain','listed_networks','verification_status','confirmed_networks','matched_seller_ids','matched_ads_txt_lines','ads_txt_source_url','ads_txt_final_url','checked_at_utc','site_type','classification_review','sitemap_page_urls','sitemap_count_status','sitemap_roots','niche','url_patterns_json','data_sources_json','source_status','source_evidence_urls_json','entity_fields_json','notes'];\n const stream=new ReadableStream({async start(controller){try{\n controller.enqueue(encoder.encode('\\ufeff'+headings.map(cell).join(',')+'\\r\\n'));let after='';\n while(true){const result=await sqlite.execute({sql:`WITH d AS (SELECT DISTINCT domain FROM sellers WHERE domain<>'' AND domain>? ORDER BY domain LIMIT 300)\nSELECT d.domain,(SELECT group_concat(DISTINCT network) FROM sellers s WHERE s.domain=d.domain) networks,\nc.status,c.final_url,c.checked_at,c.evidence_json,e.sitemap_count,e.sitemap_status,\njson_extract(e.result_json,'$.classification.type') auto_type,json_extract(e.result_json,'$.classification.review_status') auto_review,\njson_extract(e.result_json,'$.sitemap.roots') roots,json_extract(e.result_json,'$.url_patterns') patterns,json_extract(e.result_json,'$.data_source_status') source_status,\nm.classification reviewed_type,m.review_status,m.niche,m.patterns_json,m.data_sources_json,m.evidence_urls_json,m.entity_fields_json,m.notes\nFROM d LEFT JOIN checks c ON c.domain=d.domain LEFT JOIN enrichment e ON e.domain=d.domain LEFT JOIN manual_reviews m ON m.domain=d.domain ORDER BY d.domain`,args:[after]});\n if(!result.rows.length)break;const lines:string[]=[];\n for(const r of result.rows){const status=String(r.status??'not_checked'),type=String(r.reviewed_type??r.auto_type??'not_evaluated');\n if(kind==='confirmed'&&status!=='confirmed')continue;\n if(kind==='directories'&&(status!=='confirmed'||!['directory','directory_hybrid','database_reference'].includes(type)))continue;\n if(kind==='excluded'&&!['no_matching_line','ads_txt_missing'].includes(status))continue;\n if(kind==='unresolved'&&!['not_checked','unverified'].includes(status))continue;\n const evidence=JSON.parse(String(r.evidence_json??'[]'));\n const values=[r.domain,r.networks,status,[...new Set(evidence.map((x:any)=>x.network))].join(';'),[...new Set(evidence.map((x:any)=>x.network+':'+x.seller_id))].join(';'),evidence.map((x:any)=>x.line).join(' | '),'https://'+r.domain+'/ads.txt',r.final_url,r.checked_at,type,r.review_status??r.auto_review??'not_evaluated',r.sitemap_count,r.sitemap_status??'not_attempted',r.roots,r.niche,r.patterns_json??r.patterns,r.data_sources_json,r.source_status??'not_evaluated',r.evidence_urls_json,r.entity_fields_json,r.notes];\n lines.push(values.map(cell).join(','));\n }\n if(lines.length)controller.enqueue(encoder.encode(lines.join('\\r\\n')+'\\r\\n'));after=String(result.rows.at(-1)!.domain);\n }\n controller.close();\n }catch(e){controller.error(e);}}});\n return new Response(stream,{headers:{'content-type':'text/csv; charset=utf-8','content-disposition':'attachment; filename=\"publisher-audit-'+kind+'.csv\"','cache-control':'private, no-store','referrer-policy':'no-referrer','x-content-type-options':'nosniff','access-control-allow-origin':'*'}});\n}",[218],"558d7440-dd48-40ee-a096-168391b2a1da","classify.ts","aac5576c-b2c1-11f1-bee6-1607ee4eb77e",28,["D",1789668028848],"export function classifySite(domain:string,meta:any,text:string,urls:string[],maps:any[]){\n const title=String(meta.title??'').toLowerCase(),head=(title+' '+String(meta.description??'')).toLowerCase();\n const body=String(text??'').slice(0,1800).toLowerCase();\n const schemas=Array.isArray(meta.schema_types)?meta.schema_types:[];\n const sample=urls.length>300?Array.from({length:300},(_,i)=>urls[Math.floor(i*urls.length/300)]):urls;\n const paths=sample.map(s=>{try{return new URL(s).pathname.toLowerCase();}catch{return '';}});\n const ratio=(r:RegExp)=>paths.length?paths.filter(p=>r.test(p)).length/paths.length:0;\n const articlePaths=ratio(/^\\/(?:blog|blogs|article|articles|posts|news|recipes|recetas|rezepte|guides)\\//);\n const entityPaths=ratio(/^\\/(?:hospital|hospitals|surgery-center|ramps|campgrounds|businesses|clinics|prisons|dentists|nursing-homes|shelters)\\//);\n const geoPaths=ratio(/^\\/(?:states|locations|places|stores|cities)\\/[^/]+\\/[^/]+/);\n const forum=/\\bforums?\\b|\\bforo\\b|discussion board|community discussions/.test(head)||ratio(/^\\/(?:threads|forums|discussions)\\//)>.3;\n const tool=/calculator|converter|generator|word finder|word solver|bpm finder|fare finder|ip location|tracking tool|online tracker/.test(head)||schemas.includes('SoftwareApplication')&&/calculate|convert|generate|track/.test(body);\n const reference=/encyclopedia|encyclopaedia|dictionary|gazetteer|\\bdatabase\\b|\\bwiki\\b|world population|drop sources|postal codes|zip codes/.test(head);\n const directDirectory=/\\bdirector(?:y|ies)\\b|\\blocator\\b|business listings|\\bannuaire\\b|branchenbuch|find.{0,40}(?:near you|near me|business|clinic|campground|boat ramp|dentist|shelter)/.test(head);\n const nameDirectory=/directory|locator|annuaire/.test(domain);\n const postMap=maps.some(m=>/(?:^|\\/)post-sitemap|\\/wp-sitemap-posts-(?:post|recipe)|\\/sitemap-posts(?:[-_.?]|$)|\\/sitemap[._-]post(?:[-_.?]|$)/i.test(String(m.url??'')));\n const editorial=postMap||articlePaths>.35||schemas.some((s:string)=>['Blog','BlogPosting','Article','NewsArticle','Recipe'].includes(s))||/\\bblog\\b|\\brecipes?\\b|recetas|ricette|receitas|recettes|rezepte|przepisy|рецепт|cooking|lifestyle|travel tips|diy projects|gardening tips|latest articles|latest posts/.test(head+' '+body.slice(0,300));\n let type='unknown',confidence='low',reason='Insufficient accessible evidence to assign a primary site type';\n if(forum){type='forum';confidence='medium';reason='Forum title/description or repeated discussion-thread URLs';}\n else if(tool){type='tool';confidence='medium';reason='Title/description or application schema describes an interactive utility';}\n else if(reference&&!directDirectory){type='database_reference';confidence='medium';reason='Reference/database/encyclopedia language in title or description';}\n else if(directDirectory||entityPaths>.4||geoPaths>.5){type='directory';confidence='medium';reason=directDirectory?'Directory or entity-search language in title/description':'Repeated entity or geographic listing URL structure';}\n else if(nameDirectory&&!editorial){type='directory';confidence='low';reason='Domain-name hint only; manual review required';}\n else if(editorial){type='blog';confidence='medium';reason=postMap?'Editorial post sitemap':articlePaths>.35?'Predominantly article/blog/recipe URL structure':'Editorial/recipe language or article schema';}\n return {type,confidence,reason,review_status:'automated_v2_not_manually_reviewed',has_editorial_section:editorial,version:2,evidence:{article_url_ratio:Number(articlePaths.toFixed(3)),entity_url_ratio:Number(entityPaths.toFixed(3)),geographic_url_ratio:Number(geoPaths.toFixed(3)),post_sitemap:postMap}};\n}",[225],"75e758c0-6550-4a8e-a4bf-d244768ed56e","batch_scan.ts","19a948f8-b2bf-11f1-b5e0-1607ee4eb77e",29,["D",1789668108011],2,"import { sqlite } from 'https://esm.town/v/std/sqlite/main.ts';\nconst endpoint='https://omriluz--0eb0b968b2bf11f196131607ee4eb77e.web.val.run';\nconst start=Date.now(),shards=8;\nconst pending=(await sqlite.execute({sql:\"SELECT DISTINCT ((unicode(substr(s.domain,1,1))*31+unicode(substr(s.domain,2,1))+length(s.domain)) % ?) shard FROM sellers s LEFT JOIN checks c ON s.domain=c.domain WHERE s.domain<>'' AND c.domain IS NULL ORDER BY shard\",args:[shards]})).rows.map(r=>Number(r.shard));\nconst results=await Promise.all(pending.map(async shard=>{try{const r=await fetch(endpoint,{method:'POST',headers:{'content-type':'application/json',authorization:'Bearer '+Deno.env.get('AUDIT_JOB_KEY')},body:JSON.stringify({kind:'scan',shard,shards}),signal:AbortSignal.timeout(75000)});const text=await r.text();try{const value=JSON.parse(text);return {shard,status:r.status,...(value&&typeof value==='object'?value:{error:value})};}catch{return {shard,status:r.status,body:text.slice(0,600)};}}catch(e){return {shard,error:String(e)};}}));\nconsole.log(JSON.stringify({duration_ms:Date.now()-start,results,totals:(await sqlite.execute('SELECT status,COUNT(*) n FROM checks GROUP BY status')).rows,remaining:(await sqlite.execute(\"SELECT COUNT(DISTINCT s.domain) n FROM sellers s LEFT JOIN checks c ON s.domain=c.domain WHERE s.domain<>'' AND c.domain IS NULL\")).rows}));",[232],"487510d4-a261-4fb6-9156-e600336de14a","batch_retry.ts","c332e11a-b2c2-11f1-8885-1607ee4eb77e",37,["D",1789668499337],"import { sqlite } from 'https://esm.town/v/std/sqlite/main.ts';\nconst endpoint='https://omriluz--0eb0b968b2bf11f196131607ee4eb77e.web.val.run';\nconst start=Date.now(),shards=8;\nconst pending=(await sqlite.execute({sql:\"SELECT DISTINCT ((unicode(substr(c.domain,1,1))*31+unicode(substr(c.domain,2,1))+length(c.domain)) % ?) shard FROM checks c WHERE c.status='unverified' AND c.checked_at < (SELECT value FROM audit_settings WHERE key='retry_cutoff') ORDER BY shard\",args:[shards]})).rows.map(r=>Number(r.shard));\nconst results=await Promise.all(pending.map(async shard=>{try{const r=await fetch(endpoint,{method:'POST',headers:{'content-type':'application/json',authorization:'Bearer '+Deno.env.get('AUDIT_JOB_KEY')},body:JSON.stringify({kind:'retry',shard,shards}),signal:AbortSignal.timeout(75000)});const text=await r.text();try{const value=JSON.parse(text);return {shard,status:r.status,...(value&&typeof value==='object'?value:{error:value})};}catch{return {shard,status:r.status,body:text.slice(0,400)};}}catch(e){return {shard,error:String(e)};}}));\nconsole.log(JSON.stringify({duration_ms:Date.now()-start,results,totals:(await sqlite.execute('SELECT status,COUNT(*) n FROM checks GROUP BY status')).rows,remaining_retries:(await sqlite.execute(\"SELECT COUNT(*) n FROM checks c WHERE c.status='unverified' AND c.checked_at < (SELECT value FROM audit_settings WHERE key='retry_cutoff')\")).rows}));",[240],"614711a8-16a6-49a3-b849-5b107926bb2d","batch_enrich.ts","6381902c-b2c2-11f1-809f-1607ee4eb77e",31,["D",1789668338773],"import { sqlite } from 'https://esm.town/v/std/sqlite/main.ts';\nconst endpoint='https://omriluz--0eb0b968b2bf11f196131607ee4eb77e.web.val.run';\nconst start=Date.now(),shards=8;\nconst pending=(await sqlite.execute({sql:\"SELECT DISTINCT ((unicode(substr(c.domain,1,1))*31+unicode(substr(c.domain,2,1))+length(c.domain)) % ?) shard FROM checks c LEFT JOIN enrichment e ON c.domain=e.domain WHERE c.status='confirmed' AND e.domain IS NULL ORDER BY shard\",args:[shards]})).rows.map(r=>Number(r.shard));\nconst results=await Promise.all(pending.map(async shard=>{try{const r=await fetch(endpoint,{method:'POST',headers:{'content-type':'application/json',authorization:'Bearer '+Deno.env.get('AUDIT_JOB_KEY')},body:JSON.stringify({kind:'enrich',shard,shards}),signal:AbortSignal.timeout(75000)});const text=await r.text();try{const value=JSON.parse(text);return {shard,status:r.status,...(value&&typeof value==='object'?value:{error:value})};}catch{return {shard,status:r.status,body:text.slice(0,600)};}}catch(e){return {shard,error:String(e)};}}));\nconsole.log(JSON.stringify({duration_ms:Date.now()-start,results,totals:(await sqlite.execute('SELECT sitemap_status,COUNT(*) n FROM enrichment GROUP BY sitemap_status')).rows,remaining:(await sqlite.execute(\"SELECT COUNT(*) n FROM checks c LEFT JOIN enrichment e ON c.domain=e.domain WHERE c.status='confirmed' AND e.domain IS NULL\")).rows}));",[247],"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 · v40