[{"_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",{"_99":98,"_33":46,"_108":89,"_28":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":27,"_123":124,"_125":25,"_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",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":-5,"_58":27,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":27},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":29,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":27},"previous",{"_31":32,"_33":29,"_34":35,"_36":37},"deleted",true,"deletedHere",false,"path","collect.ts","latestPath","fileId","01a06c3e-3531-7518-8403-a70bcae040f2","name","fileType","interval","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { parseHTML } from \"https://esm.sh/linkedom@0.16.11\";\nimport { initDb } from \"./db.ts\";\n\nconst BASE = \"https://b15.playcenturia.com\";\n\nfunction parseNum(s: string | null | undefined): number | null {\n if (!s) return null;\n const cleaned = s.replace(/[^\\d-]/g, \"\");\n return cleaned ? parseInt(cleaned, 10) : null;\n}\n\nasync function log(status: string, message: string) {\n await sqlite.execute(\n `INSERT INTO collect_log (status, message, at) VALUES (?, ?, ?)`,\n [status, message, Date.now()],\n );\n}\n\n// Fetches an authenticated page from b15 using the PHPSESSID cookie stored in\n// CENTURIA_SESSION. Throws \"SESSION_EXPIRED\" if the cookie is dead — the game\n// either 30x-redirects to a login page, or serves a page containing a login form.\nasync function fetchAuthed(path: string, cookie: string): Promise {\n const resp = await fetch(`${BASE}${path}`, {\n headers: {\n Cookie: `PHPSESSID=${cookie}`,\n \"User-Agent\": \"Mozilla/5.0 (compatible; VillageDashboard/1.0; personal use)\",\n },\n redirect: \"manual\",\n });\n if (resp.status >= 300 && resp.status < 400) {\n throw new Error(\"SESSION_EXPIRED\");\n }\n if (!resp.ok) {\n throw new Error(`HTTP_${resp.status}`);\n }\n const html = await resp.text();\n if (/id=[\"']?loginForm[\"']?|name=[\"']?login[\"']?/i.test(html)) {\n throw new Error(\"SESSION_EXPIRED\");\n }\n return html;\n}\n\n// Best-effort DOM scraping of dorf1.php (resource overview). Selectors were\n// confirmed live on 2026-09-04 against Centuria build v0.6.25 — if the game\n// updates its markup, these may need re-checking (compare against a fresh\n// page load in the browser).\nfunction extractSnapshot(html: string) {\n const { document } = parseHTML(html);\n const getText = (id: string) => document.getElementById(id)?.textContent?.trim() ?? null;\n\n const lumber = parseNum(getText(\"l1\"));\n const clay = parseNum(getText(\"l2\"));\n const iron = parseNum(getText(\"l3\"));\n const crop = parseNum(getText(\"l4\"));\n\n const prodRows = Array.from(document.querySelectorAll(\".production tr\"))\n .map((el: any) => (el.textContent ?? \"\").trim());\n const findProd = (name: string) => {\n const row = prodRows.find((r) => r.toLowerCase().startsWith(name.toLowerCase()));\n return row ? parseNum(row.split(\":\")[1] ?? null) : null;\n };\n const lumberProd = findProd(\"Lumber\");\n const clayProd = findProd(\"Clay\");\n const ironProd = findProd(\"Iron\");\n const cropProd = findProd(\"Crop\");\n\n // Warehouse/granary capacity: derived positionally from the resource bar's\n // full text (\" \"). Fragile —\n // flagged for verification against the first few real collect.ts runs.\n const stockBarText = document.getElementById(\"stockBar\")?.textContent?.replace(/\\s+/g, \" \").trim() ?? \"\";\n const nums = (stockBarText.match(/[\\d.,]+/g) ?? []).map((n) => parseNum(n));\n const warehouseCap = nums[0] ?? null;\n const granaryCap = nums[4] ?? null;\n\n const gold = parseNum(\n Array.from(document.querySelectorAll(\".coinGold\"))\n .map((el: any) => el.textContent)\n .find((t: string) => /\\d/.test(t ?? \"\")) ?? null,\n );\n\n const villageName = document.getElementById(\"villageName\")?.textContent?.trim()\n ?? document.getElementById(\"sidebarBoxActiveVillage\")?.textContent?.trim()\n ?? null;\n\n return {\n villageName,\n lumber, clay, iron, crop,\n lumberProd, clayProd, ironProd, cropProd,\n warehouseCap, granaryCap, gold,\n };\n}\n\nexport default async function collect(_interval: Interval) {\n await initDb();\n\n const cookie = Deno.env.get(\"CENTURIA_SESSION\");\n if (!cookie) {\n console.log(\"Missing CENTURIA_SESSION — skipping run. Add it in this val's env vars.\");\n return;\n }\n\n let html: string;\n try {\n html = await fetchAuthed(\"/dorf1.php\", cookie);\n } catch (e) {\n const msg = String((e as Error)?.message ?? e);\n if (msg === \"SESSION_EXPIRED\") {\n await log(\"expired\", \"PHPSESSID cookie is no longer valid — grab a fresh one from Chrome DevTools and update CENTURIA_SESSION.\");\n console.log(\"Session expired — update CENTURIA_SESSION.\");\n } else {\n await log(\"error\", msg);\n console.error(\"Collect fetch failed:\", msg);\n }\n return;\n }\n\n const snap = extractSnapshot(html);\n if (snap.lumber === null && snap.clay === null && snap.iron === null && snap.crop === null) {\n await log(\"error\", \"Fetched dorf1.php but found no resource values — page markup may have changed.\");\n console.error(\"Parsed 0 resource fields — markup likely changed, check selectors in collect.ts.\");\n return;\n }\n\n await sqlite.execute(\n `INSERT INTO snapshots\n (village_id, village_name, lumber, clay, iron, crop,\n lumber_prod, clay_prod, iron_prod, crop_prod,\n warehouse_cap, granary_cap, gold, silver, captured_at)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n [\n snap.villageName, snap.villageName,\n snap.lumber, snap.clay, snap.iron, snap.crop,\n snap.lumberProd, snap.clayProd, snap.ironProd, snap.cropProd,\n snap.warehouseCap, snap.granaryCap, snap.gold, null,\n Date.now(),\n ],\n );\n await log(\"ok\", `${snap.villageName ?? \"village\"}: L${snap.lumber} C${snap.clay} I${snap.iron} Cr${snap.crop}`);\n console.log(`Collected snapshot for ${snap.villageName ?? \"(unknown village)\"}`);\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { DOMParser } from \"https://deno.land/x/deno_dom@v0.1.45/deno-dom-wasm.ts\";\nimport { initDb } from \"./db.ts\";\n\nconst BASE = \"https://b15.playcenturia.com\";\n\nfunction parseNum(s: string | null | undefined): number | null {\n if (!s) return null;\n const cleaned = s.replace(/[^\\d-]/g, \"\");\n return cleaned ? parseInt(cleaned, 10) : null;\n}\n\nasync function log(status: string, message: string) {\n await sqlite.execute(\n `INSERT INTO collect_log (status, message, at) VALUES (?, ?, ?)`,\n [status, message, Date.now()],\n );\n}\n\n// Fetches an authenticated page from b15 using the PHPSESSID cookie stored in\n// CENTURIA_SESSION. Throws \"SESSION_EXPIRED\" if the cookie is dead — the game\n// either 30x-redirects to a login page, or serves a page containing a login form.\nasync function fetchAuthed(path: string, cookie: string): Promise {\n const resp = await fetch(`${BASE}${path}`, {\n headers: {\n Cookie: `PHPSESSID=${cookie}`,\n \"User-Agent\": \"Mozilla/5.0 (compatible; VillageDashboard/1.0; personal use)\",\n },\n redirect: \"manual\",\n });\n if (resp.status >= 300 && resp.status < 400) {\n throw new Error(\"SESSION_EXPIRED\");\n }\n if (!resp.ok) {\n throw new Error(`HTTP_${resp.status}`);\n }\n const html = await resp.text();\n if (/id=[\"']?loginForm[\"']?|name=[\"']?login[\"']?/i.test(html)) {\n throw new Error(\"SESSION_EXPIRED\");\n }\n return html;\n}\n\n// Best-effort DOM scraping of dorf1.php (resource overview). Selectors were\n// confirmed live on 2026-09-04 against Centuria build v0.6.25 — if the game\n// updates its markup, these may need re-checking (compare against a fresh\n// page load in the browser).\nfunction extractSnapshot(html: string) {\n const { document } = parseHTML(html);\n const getText = (id: string) => document.getElementById(id)?.textContent?.trim() ?? null;\n\n const lumber = parseNum(getText(\"l1\"));\n const clay = parseNum(getText(\"l2\"));\n const iron = parseNum(getText(\"l3\"));\n const crop = parseNum(getText(\"l4\"));\n\n const prodRows = Array.from(document.querySelectorAll(\".production tr\"))\n .map((el: any) => (el.textContent ?? \"\").trim());\n const findProd = (name: string) => {\n const row = prodRows.find((r) => r.toLowerCase().startsWith(name.toLowerCase()));\n return row ? parseNum(row.split(\":\")[1] ?? null) : null;\n };\n const lumberProd = findProd(\"Lumber\");\n const clayProd = findProd(\"Clay\");\n const ironProd = findProd(\"Iron\");\n const cropProd = findProd(\"Crop\");\n\n // Warehouse/granary capacity: derived positionally from the resource bar's\n // full text (\" \"). Fragile —\n // flagged for verification against the first few real collect.ts runs.\n const stockBarText = document.getElementById(\"stockBar\")?.textContent?.replace(/\\s+/g, \" \").trim() ?? \"\";\n const nums = (stockBarText.match(/[\\d.,]+/g) ?? []).map((n) => parseNum(n));\n const warehouseCap = nums[0] ?? null;\n const granaryCap = nums[4] ?? null;\n\n const gold = parseNum(\n Array.from(document.querySelectorAll(\".coinGold\"))\n .map((el: any) => el.textContent)\n .find((t: string) => /\\d/.test(t ?? \"\")) ?? null,\n );\n\n const villageName = document.getElementById(\"villageName\")?.textContent?.trim()\n ?? document.getElementById(\"sidebarBoxActiveVillage\")?.textContent?.trim()\n ?? null;\n\n return {\n villageName,\n lumber, clay, iron, crop,\n lumberProd, clayProd, ironProd, cropProd,\n warehouseCap, granaryCap, gold,\n };\n}\n\nexport default async function collect(_interval: Interval) {\n await initDb();\n\n const cookie = Deno.env.get(\"CENTURIA_SESSION\");\n if (!cookie) {\n console.log(\"Missing CENTURIA_SESSION — skipping run. Add it in this val's env vars.\");\n return;\n }\n\n let html: string;\n try {\n html = await fetchAuthed(\"/dorf1.php\", cookie);\n } catch (e) {\n const msg = String((e as Error)?.message ?? e);\n if (msg === \"SESSION_EXPIRED\") {\n await log(\"expired\", \"PHPSESSID cookie is no longer valid — grab a fresh one from Chrome DevTools and update CENTURIA_SESSION.\");\n console.log(\"Session expired — update CENTURIA_SESSION.\");\n } else {\n await log(\"error\", msg);\n console.error(\"Collect fetch failed:\", msg);\n }\n return;\n }\n\n const snap = extractSnapshot(html);\n if (snap.lumber === null && snap.clay === null && snap.iron === null && snap.crop === null) {\n await log(\"error\", \"Fetched dorf1.php but found no resource values — page markup may have changed.\");\n console.error(\"Parsed 0 resource fields — markup likely changed, check selectors in collect.ts.\");\n return;\n }\n\n await sqlite.execute(\n `INSERT INTO snapshots\n (village_id, village_name, lumber, clay, iron, crop,\n lumber_prod, clay_prod, iron_prod, crop_prod,\n warehouse_cap, granary_cap, gold, silver, captured_at)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n [\n snap.villageName, snap.villageName,\n snap.lumber, snap.clay, snap.iron, snap.crop,\n snap.lumberProd, snap.clayProd, snap.ironProd, snap.cropProd,\n snap.warehouseCap, snap.granaryCap, snap.gold, null,\n Date.now(),\n ],\n );\n await log(\"ok\", `${snap.villageName ?? \"village\"}: L${snap.lumber} C${snap.clay} I${snap.iron} Cr${snap.crop}`);\n console.log(`Collected snapshot for ${snap.villageName ?? \"(unknown village)\"}`);\n}\n","createdAt",["D",1788522595847],"branchVersion","branchId","63086719-d96c-41ff-8e16-4e84b4540a2c","id","3e806cc7-ffa7-4f5a-8f6f-a23db6d75082","centuriaVillageDashboard",["D",1788522411148],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Live village dashboard for Centuria b15 (village 8low)","imageUrl","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",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":56,"_104":105,"_106":27},"branch",{"_13":88,"_33":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"isOwned",19,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kubeniz","handle","displayName","Valentino Rodrigues","avatar","https://lh3.googleusercontent.com/a/ACg8ocLUTO6MzdqeXpcs4pmDUIuBGqLrhsGH0xN-uIFC_LP0kPooCA=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_33":46,"_39":203,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":-5,"_58":27,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":204,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":205,"_83":206,"_85":207,"_87":27},"tree",[182,183,184,185,186],"files",[182,183,184,185,186],"counts",{"_172":62,"_173":142,"_174":62,"_175":176,"_177":178},"contents",[130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":166,"_33":167,"_31":168,"_138":-5,"_42":43,"_41":142,"_140":27,"_39":169,"_13":62,"_34":20,"_36":170,"_24":27,"_145":-5,"_28":171},{"_44":162,"_33":29,"_31":32,"_138":-5,"_42":43,"_41":14,"_140":27,"_39":163,"_13":164,"_34":35,"_36":38,"_24":27,"_145":-5,"_28":165},{"_44":155,"_33":156,"_31":157,"_138":-5,"_42":43,"_41":158,"_140":25,"_39":159,"_13":142,"_34":152,"_36":160,"_24":27,"_145":-5,"_28":161},{"_44":147,"_33":148,"_31":149,"_138":-5,"_42":43,"_41":150,"_140":25,"_39":151,"_13":142,"_34":152,"_36":153,"_24":27,"_145":-5,"_28":154},{"_44":135,"_33":136,"_31":137,"_138":-5,"_42":43,"_41":139,"_140":25,"_39":141,"_13":142,"_34":143,"_36":144,"_24":27,"_145":-5,"_28":146},"7dcd25c8-784c-4693-93ce-f6c098b23aaf","site.ts","01a06c3e-3531-7518-8403-c2f126f56030","parentId",11,"latest",["D",1788522579622],1,"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","label",[136],"e492857d-7f73-4c73-877b-a108ad36929d","page.ts","01a06c3e-3531-7518-8403-b35c09d098e2",10,["D",1788522570294],"script","const PAGE = `\n\n\n\n\nCenturia b15 — Village Dashboard\n\n\n\n

🏛️ 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",[148],"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",[156],"72e063cf-5b9a-4513-9474-eac2be112436",["D",1788522595847],2,[29],"c97e2158-3782-4d64-8145-241447a4bc5c","AGENTS.md","01a06c3e-3531-7518-8403-9ebcc109d10f",["D",1788522411148],"# apexGemTracker — Core Architecture & Context\n\nThis Val tracks Apex Manager market listings to find \"hidden gems\": players who displayed BELOW A- potential on the market but actually retired with A- or higher potential (i.e., fog hid their true quality)[cite: 1]. This is strictly a data collection and comparison pipeline with a web dashboard, entirely separate from notification/alert Vals[cite: 1].\n\n## ⚠️ Core Business Logic\n\n1. **The Gem Rule (`db.ts`)**\n `is_gem = isBelowAMinus(marketPotential) && !isBelowAMinus(retiredPotential)`[cite: 1, 4]\n *CRITICAL:* Always compare LETTER GRADES (`estimatedRank` / `estimatedPotential`), never the numeric `trueRating` or `potentialRating`[cite: 1]. The game's numeric ratings do not map to a reliable letter grade scale (e.g., a potential rating of 1986 might retire as a C/B, not an A)[cite: 1]. The authoritative \"true\" grade is the revealed letter grade on the retired card at 100% confidence[cite: 1].\n\n2. **Fog Semantics**\n `fogConfidence` (API) = INTEL[cite: 1]. Displayed \"Fog %\" = 100 - (fogConfidence * 100)[cite: 3]. High intel (low fog) = well-scouted; low intel (high fog) = obscured/lottery[cite: 1].\n\n## Data Model (SQLite)\n\n* **`listings`**: Snapshot of every market listing (keyed by `auction_id`)[cite: 1]. Captures the first-seen state (est rank/potential, intel, fog, salary, full `player_json`)[cite: 1, 3]. Upserted every run[cite: 1]. `left_at` is set when a listing stops appearing in the active auctions API[cite: 1, 3].\n* **`retired`**: Resolved players[cite: 1]. Compares market display vs. retired revealed grade (`retired_rank` / `retired_potential`)[cite: 1]. Stores market age/salary snapshot + true numeric ratings + `is_gem` flag + `card_url`[cite: 1, 2].\n* **`player_checks`**: Dedupe and backoff tracking table (checked every 10 minutes) so we don't spam the API for unresolved players[cite: 1, 2].\n\n## Scheduled Jobs (Cron)\n\n* **`collect.ts` (*/15 mins)**: Snapshots all `/api/auctions` listings[cite: 1]. Inserts new listings and updates `left_at` for expired auctions[cite: 3].\n* **`check.ts` (Hourly)**: Looks at listings that left the market >=1h ago[cite: 1]. Fetches `/api/players/{id}`[cite: 1]. If retired, calculates gem status and moves to `retired` table[cite: 1, 2]. If still active, backs off and checks again later[cite: 1]. \n\n## Web & API Endpoints (HTTP)\n\n* **`site.ts`**: The main frontend UI and API router[cite: 9]. Serves a rich HTML/JS dashboard at the root (`/`) with tabs for Live Market, Retired Players, and Advanced Analytics charts[cite: 6, 9]. Serves JSON endpoints at `/api/stats`, `/api/live`, `/api/retired`, and `/api/analytics`[cite: 9].\n* **`report.ts`**: Spreadsheet export router[cite: 1, 7]. Serves raw JSON and CSVs (e.g., `/csv` for gems, `/csv/listings` for active market)[cite: 1, 7]. Designed to be ingested directly by Google Sheets using the `IMPORTDATA()` function[cite: 1].\n* **`main.ts`**: A utility script to initialize the DB schema and print current table row counts[cite: 1, 5]. \n\n## Environment\n\n* `APEX_TOKEN`: The bearer token required to authenticate against the Apex Manager API[cite: 1]. All scripts will fail if this is missing or expired[cite: 1, 2, 3].",[167],"pulls","branches","forks","envVars",{"_179":62,"_181":62},"connections",{"_179":62,"_180":62},"count","unfilledCount","emptyCount",{"_44":166,"_33":167,"_31":168,"_138":-5,"_42":43,"_41":142,"_140":27,"_39":200,"_13":62,"_34":20,"_36":170,"_24":27,"_145":-5,"_188":201,"_28":202},{"_44":162,"_33":29,"_31":32,"_138":-5,"_42":43,"_41":14,"_140":27,"_39":197,"_13":164,"_34":35,"_36":38,"_24":27,"_145":-5,"_188":198,"_28":199},{"_44":155,"_33":156,"_31":157,"_138":-5,"_42":43,"_41":158,"_140":25,"_39":194,"_13":142,"_34":152,"_36":160,"_24":27,"_145":-5,"_188":195,"_28":196},{"_44":147,"_33":148,"_31":149,"_138":-5,"_42":43,"_41":150,"_140":25,"_39":191,"_13":142,"_34":152,"_36":153,"_24":27,"_145":-5,"_188":192,"_28":193},{"_44":135,"_33":136,"_31":137,"_138":-5,"_42":43,"_41":139,"_140":25,"_39":187,"_13":142,"_34":143,"_36":144,"_24":27,"_145":-5,"_188":189,"_28":190},["D",1788522579622],"children",[],[136],["D",1788522570294],[],[148],["D",1788522524123],[],[156],["D",1788522595847],[],[29],["D",1788522411148],[],[167],["D",1788522411148],["D",1789477862254],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":56,"_104":105,"_106":27},{"_13":88,"_33":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"ctx",{"_81":-5,"_127":241,"_242":243,"_244":245,"_246":27,"_247":27,"_248":27,"_249":25,"_250":-5,"_251":-7,"_252":-7,"_253":62,"_254":27,"_255":27,"_256":-5,"_257":27,"_258":27,"_259":27,"_260":-5},"ENV",{"_212":213,"_214":215,"_216":89,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240},"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"]

Diff · v12