🏛️ 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",[174],"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",[181],"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 · main.ts