🏛️ Centuria b15 — Village Dashboard

Live snapshots scraped from b15.playcenturia.com. view source

\n\n

History

\n \n \n \n

Time	Village	Lumber	Clay	Iron	Crop	Gold

\n\n \n\n\n\n\n`;\n\nexport default PAGE;\n","label",[18],"pulls","branches","forks","envVars",{"_173":26,"_175":26},"connections",{"_173":26,"_174":26},"count","unfilledCount","emptyCount",{"_33":201,"_13":202,"_68":203,"_43":-5,"_35":36,"_159":121,"_160":153,"_37":204,"_39":205,"_70":21,"_162":206,"_72":24,"_164":-5,"_187":207,"_17":208},{"_33":193,"_13":194,"_68":195,"_43":-5,"_35":36,"_159":196,"_160":153,"_37":197,"_39":40,"_70":71,"_162":198,"_72":24,"_164":-5,"_187":199,"_17":200},{"_33":158,"_13":18,"_68":69,"_43":-5,"_35":36,"_159":78,"_160":153,"_37":190,"_39":40,"_70":71,"_162":163,"_72":24,"_164":-5,"_187":191,"_17":192},{"_33":180,"_13":181,"_68":182,"_43":-5,"_35":36,"_159":183,"_160":153,"_37":184,"_39":40,"_70":185,"_162":186,"_72":24,"_164":-5,"_187":188,"_17":189},"7dcd25c8-784c-4693-93ce-f6c098b23aaf","site.ts","01a06c3e-3531-7518-8403-c2f126f56030",11,["D",1788522579622],"http","// site.ts — Village Dashboard: live UI + JSON API for centuriaVillageDashboard.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { initDb } from \"./db.ts\";\nimport PAGE from \"./page.ts\";\n\nasync function q(sql: string, args: any[] = []): Promise {\n const res: any = await sqlite.execute(args.length ? { sql, args } : sql);\n const cols: string[] = res.columns || [];\n return (res.rows as any[]).map((row) =>\n Array.isArray(row) ? Object.fromEntries(cols.map((c, i) => [c, row[i]])) : row\n );\n}\n\nconst json = (o: any, status = 200) =>\n new Response(JSON.stringify(o), { status, headers: { \"content-type\": \"application/json\" } });\n\nasync function apiLatest(): Promise {\n const rows = await q(`SELECT * FROM snapshots ORDER BY captured_at DESC LIMIT 1`);\n return json(rows[0] ?? null);\n}\n\nasync function apiHistory(url: URL): Promise {\n const limit = Math.min(200, Math.max(1, parseInt(url.searchParams.get(\"limit\") || \"50\") || 50));\n const rows = await q(`SELECT * FROM snapshots ORDER BY captured_at DESC LIMIT ?`, [limit]);\n return json(rows);\n}\n\nasync function apiLog(): Promise {\n const rows = await q(`SELECT * FROM collect_log ORDER BY at DESC LIMIT 1`);\n return json(rows[0] ?? null);\n}\n\nexport default async function (req: Request): Promise {\n await initDb();\n const url = new URL(req.url);\n const p = url.pathname.replace(/\\/+$/, \"\") || \"/\";\n try {\n if (p === \"/api/latest\") return await apiLatest();\n if (p === \"/api/history\") return await apiHistory(url);\n if (p === \"/api/log\") return await apiLog();\n if (p === \"/source\") return Response.redirect(parseVal().links.self.val, 302);\n } catch (e) {\n return json({ error: String(e) }, 500);\n }\n return new Response(PAGE, { headers: { \"content-type\": \"text/html; charset=utf-8\" } });\n}\n","children",[],[181],["D",1788522570294],[],[18],"3deb33ba-c4f5-44cf-8a18-ace046e88bcf","db.ts","01a06c3e-3531-7518-8403-a875e7bf0d24",8,["D",1788522524123],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS snapshots (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n village_id TEXT,\n village_name TEXT,\n lumber INTEGER,\n clay INTEGER,\n iron INTEGER,\n crop INTEGER,\n lumber_prod INTEGER,\n clay_prod INTEGER,\n iron_prod INTEGER,\n crop_prod INTEGER,\n warehouse_cap INTEGER,\n granary_cap INTEGER,\n gold INTEGER,\n silver INTEGER,\n captured_at INTEGER NOT NULL\n )`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_snapshots_time ON snapshots(captured_at)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_snapshots_village ON snapshots(village_id, captured_at)`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS villages (\n village_id TEXT PRIMARY KEY,\n name TEXT,\n coords TEXT,\n last_seen_at INTEGER\n )`);\n\n // One row per collect.ts run — lets the dashboard show \"last checked\" / \"session expired\"\n // even when a run produces no new snapshot.\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS collect_log (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n status TEXT NOT NULL,\n message TEXT,\n at INTEGER NOT NULL\n )`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_collect_log_at ON collect_log(at)`);\n}\n",[],[194],"62eb5c53-5699-4c46-864d-c1f26d89d774","AGENTS.md","01a06c3e-3531-7518-8403-9ebcc109d10f",["D",1788523655605],2,"# centuriaVillageDashboard — Core Architecture & Context\n\n## ⚠️ STATUS: DISABLED (2026-09-04)\n\n`collect.ts` (the interval that scraped b15 with the CENTURIA_SESSION cookie)\nhas been **deleted** — no automated requests to b15.playcenturia.com are being\nmade anymore. Reason: after building this, Valentino and Claude discussed how\ntraceable this is (see below) and decided the account-detection risk wasn't\nworth it right now. He may revisit later.\n\nWhat's still here: `db.ts`, `site.ts`, `page.ts` — the dashboard UI/API still\nwork and will show whatever was last collected (a few real snapshots from\n2026-09-04, including real resource/production numbers for village \"8low\"),\nbut nothing new comes in until collect.ts is rebuilt and re-scheduled.\n\n**To resume later**: re-create `collect.ts` (its last version is recoverable\nfrom this val's file history / version log even though it's deleted — ask\nVal Town or check `list_files`/version history), get a fresh `PHPSESSID` into\n`CENTURIA_SESSION` (the old one is likely stale by then anyway), and re-add a\ncron via `write_interval_settings`. Read the \"Why this was disabled\" section\nbelow again first — the underlying detection risk hasn't changed.\n\n## Why this was disabled: traceability\n\nThe `PHPSESSID` cookie **is** the account identity at the HTTP layer — any\nrequest bearing it is authenticated as Valentino's account server-side,\nindistinguishable from him personally making the request. Val Town does not\nprovide anonymity; it only changes the network path:\n\n- Requests arrive from a Val Town datacenter IP instead of Valentino's normal\n IP — on the *same* session/account. If the game logs IPs per session, this\n reads as an anomaly (datacenter IP suddenly appearing on a residential\n account's session), not as cover.\n- The site sits behind Cloudflare (confirmed via response headers), which\n fingerprints connections below the HTTP layer (TLS handshake, HTTP/2 frame\n ordering) — this can't be disguised by setting a believable User-Agent.\n- Server-only `fetch()` calls skip all the ~190 subresource requests\n (CSS/JS/images) a real page load triggers, and land on a suspiciously\n regular clock (every 15 min) — both are typical bot signatures.\n\nBottom line: this was always fully attributable to Valentino's account, not\njust \"traceable to Val Town.\" That's the reason it's off.\n\n## Original architecture (for reference / when resuming)\n\nLive resource/production dashboard for Valentino's Centuria (b15.playcenturia.com)\nvillage \"8low\". Centuria has no bearer-token REST API (unlike apexGemTracker,\nwhich this val was originally remixed from) — it's a classic server-rendered\nTravian-engine game gated by a `PHPSESSID` session cookie, treated here as the\n\"token\" equivalent.\n\n### Data model (SQLite) — still present, still queryable\n\n- **`snapshots`**: one row per successful collect run — resource stocks\n (lumber/clay/iron/crop), production/hour, warehouse/granary capacity, gold.\n `village_name` doubles as `village_id` (single-village setup).\n- **`villages`**: reserved for multi-village support — never populated.\n- **`collect_log`**: one row per collect run regardless of outcome\n (`ok` / `error` / `expired`) — drives the dashboard's status banner.\n\n### Scraping details (from the deleted `collect.ts`, for when rebuilding)\n\nFetched `/dorf1.php` with `Cookie: PHPSESSID=`, a realistic\nChrome `User-Agent`/`Accept`/`Accept-Language`, parsed with `deno_dom` (NOT\n`linkedom` — linkedom@0.16.11 pulls in a `canvas` native binding unavailable\nin Val Town's runtime and crashes on import).\n\nSelectors confirmed live on 2026-09-04 against Centuria build v0.6.25, and\nverified working against real data before being disabled:\n- `#l1` / `#l2` / `#l3` / `#l4` — lumber/clay/iron/crop stock\n- `.production tr` — rows of text like `\"Lumber: 24,225\"` (production/hour)\n- `#stockBar` — full resource bar text; warehouse/granary capacity parsed\n **positionally** (`nums[0]` = warehouse cap, `nums[4]` = granary cap) —\n confirmed correct against live data (240,000 / 720,000).\n- `.coinGold` — gold amount (never actually observed non-null in testing —\n worth re-checking selector when resuming)\n- `#villageName input`'s `value` attribute — clean village name. (NOT\n `#villageName`'s textContent — that pulls in population, loyalty, and an\n inline `

History · page.ts