[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_194":195,"_196":197},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_148":-5,"_20":149,"_22":150,"_151":152,"_153":154,"_26":155,"_24":156,"_157":-5,"_158":-5,"_159":51,"_160":161,"_162":43,"_163":-5,"_164":-5,"_165":166},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","kubeniz","name","centuriaVillageDashboard","branchName","main","version","path","AGENTS.md","project",{"_33":89,"_13":14,"_44":90,"_91":-5,"_92":51,"_93":94,"_95":94,"_96":97,"_98":-5,"_99":100,"_101":-5,"_102":51,"_103":-5,"_104":-5,"_105":106,"_107":108,"_109":110,"_111":112,"_113":114,"_115":-5,"_116":117,"_118":117,"_119":120,"_121":120,"_122":120,"_123":117,"_124":117,"_125":126,"_127":128,"_129":130,"_131":51},"tree",[54,55,56,57],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":53},"contents",[],"upstream","pull","ahead","behind","envVars","id","62eb5c53-5699-4c46-864d-c1f26d89d774","fileId","01a06c3e-3531-7518-8403-9ebcc109d10f","parentId","branchId","63086719-d96c-41ff-8e16-4e84b4540a2c","branchVersion",19,"latest",true,"createdAt",["D",1788523655605],2,"fileType","content","# 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 `\n\n\n`;\n\nexport default PAGE;\n",[],[70],"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",[],[79],["D",1788523655605],[],[19],"3e806cc7-ffa7-4f5a-8f6f-a23db6d75082",["D",1788522411148],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Live village dashboard for Centuria b15 (village 8low)","imageUrl","userId","b71e33f8-d99a-4cff-b095-38f58c0a5236","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019fd3a0-5b29-72d9-8429-c2783b92627c","tursoName","3e806cc7ffa74f5a8f6fa23db6d75082","tursoHostname","3e806cc7ffa74f5a8f6fa23db6d75082-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789477862254],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_147":143},"org",{"_11":12,"_140":141,"_142":143,"_99":100,"_144":145,"_146":51},"branch",{"_17":41,"_13":16,"_33":39,"_132":89,"_133":-5,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":14,"_139":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Valentino Rodrigues","avatar","https://lh3.googleusercontent.com/a/ACg8ocLUTO6MzdqeXpcs4pmDUIuBGqLrhsGH0xN-uIFC_LP0kPooCA=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":89,"_13":14,"_44":189,"_91":-5,"_92":51,"_93":94,"_95":94,"_96":97,"_98":-5,"_99":100,"_101":-5,"_102":51,"_103":-5,"_104":-5,"_105":106,"_107":108,"_109":110,"_111":112,"_113":190,"_115":-5,"_116":117,"_118":117,"_119":120,"_121":120,"_122":120,"_123":117,"_124":117,"_125":191,"_127":192,"_129":193,"_131":51},[177,178,179,180],"files",[177,178,179,180],"counts",{"_168":106,"_169":63,"_170":106,"_32":171,"_172":173},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":167},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches","forks",{"_174":106,"_176":106},"connections",{"_174":106,"_175":106},"count","unfilledCount","emptyCount",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":86,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_66":187,"_18":188},{"_33":78,"_13":79,"_35":80,"_37":-5,"_38":39,"_40":81,"_42":43,"_44":82,"_17":63,"_47":74,"_48":83,"_50":51,"_52":-5,"_66":185,"_18":186},{"_33":69,"_13":70,"_35":71,"_37":-5,"_38":39,"_40":72,"_42":43,"_44":73,"_17":63,"_47":74,"_48":75,"_50":51,"_52":-5,"_66":183,"_18":184},{"_33":58,"_13":59,"_35":60,"_37":-5,"_38":39,"_40":61,"_42":43,"_44":62,"_17":63,"_47":64,"_48":65,"_50":51,"_52":-5,"_66":181,"_18":182},[],[59],[],[70],[],[79],[],[19],["D",1788522411148],["D",1789477862254],{"_11":12,"_147":143},{"_11":12,"_140":141,"_142":143,"_99":100,"_144":145,"_146":51},{"_17":41,"_13":16,"_33":39,"_132":89,"_133":-5,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":14,"_139":12},"ctx",{"_125":-5,"_164":227,"_228":229,"_230":231,"_232":51,"_233":51,"_234":51,"_235":43,"_236":-5,"_237":-7,"_238":-7,"_239":106,"_240":51,"_241":51,"_242":-5,"_243":51,"_244":51,"_245":51,"_246":-5},"ENV",{"_198":199,"_200":201,"_202":16,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]