[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_236":237,"_238":239},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":59,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",33,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","check.ts","latestPath","fileId","f1983bdc-9bd3-11f1-8fbb-1607ee4eb77e","name","fileType","interval","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initDb, isGem } from \"./db.ts\";\n\nconst API = \"https://apexmanager.rootsxo.studio/api/players/\";\nconst AGE_MS = 24 * 60 * 60 * 1000; // only check listings that are at least 24h old\nconst RE_CHECK_MS = 7 * 24 * 60 * 60 * 1000; // if not retired, re-check weekly\n\nasync function getCard(id: string): Promise {\n const token = Deno.env.get(\"APEX_TOKEN\");\n try {\n const r = await fetch(API + id, { headers: { Authorization: `Bearer ${token}` } });\n return r.ok ? await r.json() : null;\n } catch {\n return null;\n }\n}\n\nexport default async function check(_interval: Interval) {\n await initDb();\n const token = Deno.env.get(\"APEX_TOKEN\");\n if (!token) throw new Error(\"Missing APEX_TOKEN\");\n\n const now = Date.now();\n\n // Distinct players whose listing is >=24h old, not yet resolved, within re-check window.\n const rows = await sqlite.execute(\n `SELECT l.player_id, l.name, MIN(l.first_seen_at) AS first_seen\n FROM listings l\n LEFT JOIN player_checks c ON c.player_id = l.player_id\n WHERE l.first_seen_at <= ?\n AND (c.player_id IS NULL OR c.retired = 0)\n AND (c.player_id IS NULL OR c.last_checked_at < ?)\n GROUP BY l.player_id\n ORDER BY first_seen`,\n [now - AGE_MS, now - RE_CHECK_MS],\n );\n\n let checked = 0;\n let retiredFound = 0;\n for (const r of rows.rows as any[]) {\n const pid = r.player_id;\n const card = await getCard(pid);\n if (!card) continue; // transient failure; will retry on a later run\n\n checked++;\n if (card.isRetired || card.trueRating != null) {\n // Market display = earliest listing for this player.\n const m = await sqlite.execute(\n `SELECT est_rank, est_potential, intel, fog_pct, salary\n FROM listings WHERE player_id = ? ORDER BY first_seen_at ASC LIMIT 1`,\n [pid],\n );\n const d = m.rows[0] as any;\n const gem = isGem(d?.est_potential ?? null, card.estimatedPotential ?? null);\n await sqlite.execute(\n `INSERT INTO retired\n (player_id, name, market_est_rank, market_est_potential, market_intel,\n market_fog_pct, market_salary, true_rating, potential_rating, peak_rating,\n retired_rank, retired_potential, retired_at, checked_at, is_gem, card_url)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n ON CONFLICT(player_id) DO UPDATE SET\n true_rating = excluded.true_rating,\n potential_rating = excluded.potential_rating,\n peak_rating = excluded.peak_rating,\n retired_rank = excluded.retired_rank,\n retired_potential = excluded.retired_potential,\n checked_at = excluded.checked_at,\n is_gem = excluded.is_gem,\n card_url = excluded.card_url`,\n [\n pid, card.name ?? r.name, d?.est_rank ?? null, d?.est_potential ?? null,\n d?.intel ?? null, d?.fog_pct ?? null, d?.salary ?? null,\n card.trueRating ?? null, card.potentialRating ?? null, card.peakRating ?? null,\n card.estimatedRank ?? null, card.estimatedPotential ?? null,\n now, now, gem ? 1 : 0,\n `https://apexmanager.rootsxo.studio/player/${pid}`,\n ],\n );\n await sqlite.execute(\n `INSERT INTO player_checks (player_id, name, last_checked_at, retired)\n VALUES (?,?,?,1)\n ON CONFLICT(player_id) DO UPDATE SET retired = 1, last_checked_at = excluded.last_checked_at`,\n [pid, card.name ?? r.name, now],\n );\n retiredFound++;\n } else {\n await sqlite.execute(\n `INSERT INTO player_checks (player_id, name, last_checked_at, retired)\n VALUES (?,?,?,0)\n ON CONFLICT(player_id) DO UPDATE SET last_checked_at = excluded.last_checked_at`,\n [pid, card.name ?? r.name, now],\n );\n }\n }\n\n console.log(`Check: ${checked} cards checked, ${retiredFound} retired/resolved.`);\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initDb, isGem } from \"./db.ts\";\n\nconst API = \"https://apexmanager.rootsxo.studio/api/players/\";\nconst AGE_MS = 60 * 60 * 1000; // only check listings that are at least 1h old\nconst RE_CHECK_MS = 7 * 24 * 60 * 60 * 1000; // if not retired, re-check weekly\n\nasync function getCard(id: string): Promise {\n const token = Deno.env.get(\"APEX_TOKEN\");\n try {\n const r = await fetch(API + id, {\n headers: { Authorization: `Bearer ${token}` },\n });\n return r.ok ? await r.json() : null;\n } catch {\n return null;\n }\n}\n\nexport default async function check(_interval: Interval) {\n await initDb();\n const token = Deno.env.get(\"APEX_TOKEN\");\n if (!token) throw new Error(\"Missing APEX_TOKEN\");\n\n const now = Date.now();\n\n // Distinct players whose listing is >=24h old, not yet resolved, within re-check window.\n const rows = await sqlite.execute(\n `SELECT l.player_id, l.name, MIN(l.first_seen_at) AS first_seen\n FROM listings l\n LEFT JOIN player_checks c ON c.player_id = l.player_id\n WHERE l.first_seen_at <= ?\n AND (c.player_id IS NULL OR c.retired = 0)\n AND (c.player_id IS NULL OR c.last_checked_at < ?)\n GROUP BY l.player_id\n ORDER BY first_seen`,\n [now - AGE_MS, now - RE_CHECK_MS],\n );\n\n let checked = 0;\n let retiredFound = 0;\n for (const r of rows.rows as any[]) {\n const pid = r.player_id;\n const card = await getCard(pid);\n if (!card) continue; // transient failure; will retry on a later run\n\n checked++;\n if (card.isRetired || card.trueRating != null) {\n // Market display = earliest listing for this player.\n const m = await sqlite.execute(\n `SELECT est_rank, est_potential, intel, fog_pct, salary\n FROM listings WHERE player_id = ? ORDER BY first_seen_at ASC LIMIT 1`,\n [pid],\n );\n const d = m.rows[0] as any;\n const gem = isGem(\n d?.est_potential ?? null,\n card.estimatedPotential ?? null,\n );\n await sqlite.execute(\n `INSERT INTO retired\n (player_id, name, market_est_rank, market_est_potential, market_intel,\n market_fog_pct, market_salary, true_rating, potential_rating, peak_rating,\n retired_rank, retired_potential, retired_at, checked_at, is_gem, card_url)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n ON CONFLICT(player_id) DO UPDATE SET\n true_rating = excluded.true_rating,\n potential_rating = excluded.potential_rating,\n peak_rating = excluded.peak_rating,\n retired_rank = excluded.retired_rank,\n retired_potential = excluded.retired_potential,\n checked_at = excluded.checked_at,\n is_gem = excluded.is_gem,\n card_url = excluded.card_url`,\n [\n pid,\n card.name ?? r.name,\n d?.est_rank ?? null,\n d?.est_potential ?? null,\n d?.intel ?? null,\n d?.fog_pct ?? null,\n d?.salary ?? null,\n card.trueRating ?? null,\n card.potentialRating ?? null,\n card.peakRating ?? null,\n card.estimatedRank ?? null,\n card.estimatedPotential ?? null,\n now,\n now,\n gem ? 1 : 0,\n `https://apexmanager.rootsxo.studio/player/${pid}`,\n ],\n );\n await sqlite.execute(\n `INSERT INTO player_checks (player_id, name, last_checked_at, retired)\n VALUES (?,?,?,1)\n ON CONFLICT(player_id) DO UPDATE SET retired = 1, last_checked_at = excluded.last_checked_at`,\n [pid, card.name ?? r.name, now],\n );\n retiredFound++;\n } else {\n await sqlite.execute(\n `INSERT INTO player_checks (player_id, name, last_checked_at, retired)\n VALUES (?,?,?,0)\n ON CONFLICT(player_id) DO UPDATE SET last_checked_at = excluded.last_checked_at`,\n [pid, card.name ?? r.name, now],\n );\n }\n }\n\n console.log(\n `Check: ${checked} cards checked, ${retiredFound} retired/resolved.`,\n );\n}","createdAt",["D",1787159901997],"branchVersion","branchId","3439b816-bce6-43b4-8219-2a89c70ea329","id","b4ea5955-0efb-41c6-a963-10779cb76bf7","apexGemTracker",["D",1787146151215],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Tracks market players to find fog-hidden A-+ gems on retirement","imageUrl","b71e33f8-d99a-4cff-b095-38f58c0a5236","pinnedFileId","f1a1657c-9bd3-11f1-8fbb-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019fd3a0-5b29-72d9-8429-c2783b92627c","tursoName","b4ea59550efb41c6a96310779cb76bf7","tursoHostname","b4ea59550efb41c6a96310779cb76bf7-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789491713377],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",215,"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",{"_43":44,"_32":45,"_38":231,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":232,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":233,"_84":234,"_86":235,"_88":25},"tree",[202,203,204,205,206,207,208],"files",[202,203,204,205,206,207,208],"counts",{"_192":63,"_193":164,"_194":63,"_195":196,"_197":198},"contents",[131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":185,"_32":186,"_30":187,"_141":-5,"_41":42,"_40":188,"_143":25,"_38":189,"_13":145,"_33":20,"_35":190,"_24":25,"_148":-5,"_27":191},{"_43":182,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":25,"_38":183,"_13":172,"_33":34,"_35":37,"_24":25,"_148":-5,"_27":184},{"_43":175,"_32":176,"_30":177,"_141":-5,"_41":42,"_40":178,"_143":25,"_38":179,"_13":164,"_33":34,"_35":180,"_24":25,"_148":-5,"_27":181},{"_43":167,"_32":168,"_30":169,"_141":-5,"_41":42,"_40":170,"_143":25,"_38":171,"_13":172,"_33":146,"_35":173,"_24":25,"_148":-5,"_27":174},{"_43":159,"_32":160,"_30":161,"_141":-5,"_41":42,"_40":162,"_143":59,"_38":163,"_13":164,"_33":146,"_35":165,"_24":25,"_148":-5,"_27":166},{"_43":150,"_32":151,"_30":57,"_141":-5,"_41":42,"_40":152,"_143":25,"_38":153,"_13":154,"_33":155,"_35":156,"_24":25,"_148":157,"_27":158},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":59,"_38":144,"_13":145,"_33":146,"_35":147,"_24":25,"_148":-5,"_27":149},"8ae0225b-4aae-48d6-8744-0c87083beb24","seed_test.ts","6acdd9de-9bd5-11f1-90a0-1607ee4eb77e","parentId",20,"latest",["D",1787147868661],2,"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initDb, isGem, isBelowAMinus } from \"./db.ts\";\n\nawait initDb();\nconst TOKEN = Deno.env.get(\"APEX_TOKEN\");\n\nasync function api(url: string) {\n const r = await fetch(url, { headers: { Authorization: `Bearer ${TOKEN}` } });\n return r.ok ? await r.json() : null;\n}\n\nconst wl = await api(\"https://apexmanager.rootsxo.studio/api/watchlist\");\nconst arr = Array.isArray(wl) ? wl : (wl.items ?? wl.players ?? []);\n\n// Prefer a retired player who displayed below A- on the market but has A-+ potential (a real gem).\nconst candidates = arr.filter(\n (p: any) => (p.isRetired || p.trueRating != null) && p.potentialRating >= 1800 && isBelowAMinus(p.estimatedPotential),\n);\nconst pick = (candidates[0] as any) ?? (arr.find((p: any) => p.isRetired || p.trueRating != null) as any);\nif (!pick) {\n console.log(\"No retired player found to seed.\");\n} else {\n const c = await api(`https://apexmanager.rootsxo.studio/api/players/${pick.id}`);\n if (!c) {\n console.log(\"Could not fetch player card.\");\n } else {\n const intel = c.fogConfidence ?? 0;\n const fogPct = Math.round((1 - intel) * 100);\n const gem = isGem(c.estimatedPotential, c.estimatedPotential); // market sourced from card here\n const pid = \"test_\" + c.id; // prefix marks this as a manual test row\n await sqlite.execute(\n `INSERT INTO retired\n (player_id, name, market_est_rank, market_est_potential, market_intel,\n market_fog_pct, market_salary, true_rating, potential_rating, peak_rating,\n retired_rank, retired_potential, retired_at, checked_at, is_gem, card_url)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n ON CONFLICT(player_id) DO UPDATE SET\n market_est_potential=excluded.market_est_potential,\n true_rating=excluded.true_rating,\n potential_rating=excluded.potential_rating,\n retired_rank=excluded.retired_rank,\n retired_potential=excluded.retired_potential,\n is_gem=excluded.is_gem,\n card_url=excluded.card_url`,\n [\n pid, c.name, c.estimatedRank, c.estimatedPotential, intel,\n fogPct, c.salary ?? null, c.trueRating ?? null, c.potentialRating ?? null, c.peakRating ?? null,\n c.estimatedRank, c.estimatedPotential,\n Date.now(), Date.now(), gem ? 1 : 0,\n `https://apexmanager.rootsxo.studio/player/${c.id}`,\n ],\n );\n console.log(`Seeded test row: ${c.name} | market ${c.estimatedRank}/${c.estimatedPotential} (fog ${fogPct}%) -> potential ${c.potentialRating} | gem=${gem}`);\n }\n}\n","label",[139],"bd8f5c52-dad7-4ea2-a0e5-6b63e4c8ff37","report.ts",32,["D",1787158678621],5,"http","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initDb } from \"./db.ts\";\n\n// Turns a header string + array-of-rows into CSV text, quoting values that\n// contain commas, quotes, or newlines (so names/urls with commas stay intact).\nfunction toCsv(header: string, rows: any[][]): string {\n const esc = (v: any) => {\n if (v === null || v === undefined) return \"\";\n const s = String(v);\n return /[\",\\n]/.test(s) ? `\"${s.replace(/\"/g, '\"\"')}\"` : s;\n };\n return [header, ...rows.map((r) => r.map(esc).join(\",\"))].join(\"\\n\");\n}\n\nexport default async function handler(req: Request): Promise {\n await initDb();\n const url = new URL(req.url);\n\n // Resolved players: market display vs revealed grade, gems flagged.\n const retiredRows = await sqlite.execute(\n `SELECT name, market_est_rank, market_est_potential, market_fog_pct, market_salary,\n retired_rank, retired_potential, true_rating, potential_rating, peak_rating,\n is_gem, card_url, retired_at\n FROM retired\n ORDER BY is_gem DESC, potential_rating DESC`,\n );\n const retired = retiredRows.rows as any[];\n\n // Active market listings currently up for auction (not yet resolved).\n const listingRows = await sqlite.execute(\n `SELECT name, role, age, growth_class, archetype, est_rank, est_potential,\n fog_pct, salary, starting_bid, current_bid, first_seen_at, last_seen_at\n FROM listings\n WHERE left_at IS NULL\n ORDER BY fog_pct DESC, first_seen_at ASC`,\n );\n const listings = listingRows.rows as any[];\n\n // Every listing ever seen, active or not. left_at is NULL while a listing\n // is still active; it gets set once collect.ts hasn't seen it in 45+ min.\n const allListingRows = await sqlite.execute(\n `SELECT name, role, age, growth_class, archetype, est_rank, est_potential,\n fog_pct, salary, starting_bid, current_bid, first_seen_at, last_seen_at, left_at\n FROM listings\n ORDER BY (left_at IS NULL) DESC, first_seen_at DESC`,\n );\n const allListings = allListingRows.rows as any[];\n\n if (url.pathname.endsWith(\"/csv\") || url.pathname.endsWith(\"/csv/gems\")) {\n const header =\n \"name,market_rank,market_potential,market_fog_pct,market_salary,retired_rank,retired_potential,true_rating,potential_rating,peak_rating,is_gem,card_url,retired_at\";\n const body = toCsv(\n header,\n retired.map((r) => [\n r.name,\n r.market_est_rank,\n r.market_est_potential,\n r.market_fog_pct,\n r.market_salary,\n r.retired_rank,\n r.retired_potential,\n r.true_rating,\n r.potential_rating,\n r.peak_rating,\n r.is_gem,\n r.card_url,\n r.retired_at ? new Date(r.retired_at).toISOString() : \"\",\n ]),\n );\n return new Response(body, {\n headers: { \"Content-Type\": \"text/csv; charset=utf-8\" },\n });\n }\n\n if (url.pathname.endsWith(\"/csv/listings/all\")) {\n const header =\n \"name,role,age,growth_class,archetype,market_rank,market_potential,fog_pct,salary,starting_bid,current_bid,status,first_seen_at,last_seen_at,left_at\";\n const body = toCsv(\n header,\n allListings.map((r) => [\n r.name,\n r.role,\n r.age,\n r.growth_class,\n r.archetype,\n r.est_rank,\n r.est_potential,\n r.fog_pct,\n r.salary,\n r.starting_bid,\n r.current_bid,\n r.left_at ? \"left\" : \"active\",\n r.first_seen_at ? new Date(r.first_seen_at).toISOString() : \"\",\n r.last_seen_at ? new Date(r.last_seen_at).toISOString() : \"\",\n r.left_at ? new Date(r.left_at).toISOString() : \"\",\n ]),\n );\n return new Response(body, {\n headers: { \"Content-Type\": \"text/csv; charset=utf-8\" },\n });\n }\n\n if (url.pathname.endsWith(\"/csv/listings\")) {\n const header =\n \"name,role,age,growth_class,archetype,market_rank,market_potential,fog_pct,salary,starting_bid,current_bid,first_seen_at,last_seen_at\";\n const body = toCsv(\n header,\n listings.map((r) => [\n r.name,\n r.role,\n r.age,\n r.growth_class,\n r.archetype,\n r.est_rank,\n r.est_potential,\n r.fog_pct,\n r.salary,\n r.starting_bid,\n r.current_bid,\n r.first_seen_at ? new Date(r.first_seen_at).toISOString() : \"\",\n r.last_seen_at ? new Date(r.last_seen_at).toISOString() : \"\",\n ]),\n );\n return new Response(body, {\n headers: { \"Content-Type\": \"text/csv; charset=utf-8\" },\n });\n }\n\n if (url.pathname.endsWith(\"/listings/all\")) {\n return Response.json(allListings);\n }\n\n if (url.pathname.endsWith(\"/listings\")) {\n return Response.json(listings);\n }\n\n return Response.json(retired);\n}","apex-gem-tracker",[151],"52f2df96-bed7-44a7-bf25-dbc54e582e4b","main.ts","f693e3b8-9bd1-11f1-bfe0-1607ee4eb77e",6,["D",1787147006802],1,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initDb } from \"./db.ts\";\n\n// Run this once (or any time) to initialize the schema and see current state.\nawait initDb();\n\nconst l = await sqlite.execute(`SELECT COUNT(*) AS c FROM listings`);\nconst r = await sqlite.execute(`SELECT COUNT(*) AS c FROM retired`);\nconst g = await sqlite.execute(`SELECT COUNT(*) AS c FROM retired WHERE is_gem = 1`);\nconst p = await sqlite.execute(`SELECT COUNT(*) AS c FROM player_checks`);\n\nconsole.log(`apexGemTracker status`);\nconsole.log(` listings: ${l.rows[0]?.c ?? 0}`);\nconsole.log(` retired: ${r.rows[0]?.c ?? 0}`);\nconsole.log(` gems found: ${g.rows[0]?.c ?? 0}`);\nconsole.log(` players checked: ${p.rows[0]?.c ?? 0}`);\n",[160],"03f256f1-32a2-4ddb-8a56-249cc9f59fd8","db.ts","e798aad6-9bd3-11f1-89a9-1607ee4eb77e",18,["D",1787147851134],4,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// A \"gem\" = a player who displayed BELOW A- potential on the market, but whose\n// revealed (retired) potential grade is A- or higher. Comparison is by letter\n// grade only — the game's numeric true/potential rating does NOT map to a fixed\n// grade scale we can rely on, so we never infer a grade from a number.\nconst A_MINUS_INDEX = 9;\n\nconst GRADE_INDEX: Record = {\n \"D-\": 0, \"D\": 1, \"D+\": 2, \"C-\": 3, \"C\": 4, \"C+\": 5, \"B-\": 6, \"B\": 7, \"B+\": 8,\n \"A-\": 9, \"A\": 10, \"A+\": 11, \"S-\": 12, \"S\": 13, \"S+\": 14,\n};\n\nexport function gradeIndex(letter?: string | null): number | null {\n if (!letter) return null;\n return GRADE_INDEX[letter] ?? null;\n}\n\n// Was the displayed potential grade strictly below A- ? (i.e. fog hid an A-+ player)\nexport function isBelowAMinus(letter?: string | null): boolean {\n const i = gradeIndex(letter);\n return i !== null && i < A_MINUS_INDEX;\n}\n\nexport function isGem(marketPotential: string | null, retiredPotential: string | null): boolean {\n return isBelowAMinus(marketPotential) && !isBelowAMinus(retiredPotential);\n}\n\nexport async function initDb() {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS listings (\n auction_id TEXT PRIMARY KEY,\n player_id TEXT NOT NULL,\n name TEXT,\n role TEXT,\n age REAL,\n growth_class TEXT,\n archetype TEXT,\n est_rank TEXT,\n est_potential TEXT,\n intel REAL,\n fog_pct INTEGER,\n salary INTEGER,\n starting_bid INTEGER,\n current_bid INTEGER,\n first_seen_at INTEGER,\n last_seen_at INTEGER,\n left_at INTEGER,\n player_json TEXT\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS retired (\n player_id TEXT PRIMARY KEY,\n name TEXT,\n market_est_rank TEXT,\n market_est_potential TEXT,\n market_intel REAL,\n market_fog_pct INTEGER,\n market_salary INTEGER,\n true_rating INTEGER,\n potential_rating INTEGER,\n peak_rating INTEGER,\n retired_at INTEGER,\n checked_at INTEGER,\n is_gem INTEGER DEFAULT 0\n )`,\n );\n try {\n await sqlite.execute(`ALTER TABLE retired ADD COLUMN card_url TEXT`);\n } catch { /* already exists */ }\n try {\n await sqlite.execute(`ALTER TABLE retired ADD COLUMN retired_rank TEXT`);\n } catch { /* already exists */ }\n try {\n await sqlite.execute(`ALTER TABLE retired ADD COLUMN retired_potential TEXT`);\n } catch { /* already exists */ }\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS player_checks (\n player_id TEXT PRIMARY KEY,\n name TEXT,\n last_checked_at INTEGER,\n retired INTEGER DEFAULT 0\n )`,\n );\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_listings_player ON listings(player_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_listings_left ON listings(left_at)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_listings_first ON listings(first_seen_at)`);\n}\n",[168],"f098b115-cc74-47e6-be10-7424e669a800","collect.ts","f18cf222-9bd3-11f1-8fbb-1607ee4eb77e",7,["D",1787147006885],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initDb } from \"./db.ts\";\n\nconst API = \"https://apexmanager.rootsxo.studio/api/auctions\";\nconst GRACE_LEFT_MS = 45 * 60 * 1000; // a listing not seen for 45min is treated as left the market\n\nexport default async function collect(_interval: Interval) {\n await initDb();\n const token = Deno.env.get(\"APEX_TOKEN\");\n if (!token) throw new Error(\"Missing APEX_TOKEN\");\n\n const resp = await fetch(API, { headers: { Authorization: `Bearer ${token}` } });\n if (!resp.ok) throw new Error(`API error: ${resp.status} ${resp.statusText}`);\n const data = await resp.json();\n const auctions = Array.isArray(data) ? data : (data.auctions ?? data.items ?? []);\n const now = Date.now();\n\n for (const a of auctions) {\n if (a.kind !== \"player\" || !a.player) continue;\n const p = a.player;\n const intel = p.fogConfidence ?? 0;\n const fogPct = Math.round((1 - intel) * 100);\n await sqlite.execute(\n `INSERT INTO listings\n (auction_id, player_id, name, role, age, growth_class, archetype,\n est_rank, est_potential, intel, fog_pct, salary, starting_bid, current_bid,\n first_seen_at, last_seen_at, left_at, player_json)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,NULL,?)\n ON CONFLICT(auction_id) DO UPDATE SET\n last_seen_at = excluded.last_seen_at,\n current_bid = excluded.current_bid,\n left_at = NULL,\n player_json = excluded.player_json`,\n [\n a.id, p.id, p.name, p.role, p.age, p.growthClass, p.archetype ?? null,\n p.estimatedRank, p.estimatedPotential, intel, fogPct, p.salary ?? null,\n a.startingBid ?? null, a.currentBid ?? null,\n now, now, JSON.stringify(p),\n ],\n );\n }\n\n // Mark any listing we haven't seen in a while as having left the market.\n await sqlite.execute(\n `UPDATE listings SET left_at = last_seen_at WHERE left_at IS NULL AND last_seen_at < ?`,\n [now - GRACE_LEFT_MS],\n );\n\n const n = await sqlite.execute(`SELECT COUNT(*) AS c FROM listings`);\n const c = n.rows[0]?.c ?? 0;\n console.log(`Collect: ${auctions.length} auctions, ${c} tracked listings.`);\n}\n",[176],"ae2cb0dc-caa6-4ed1-87bf-4083a7481e6b",["D",1787159901997],[28],"1ad8de60-41b4-45c8-8b5e-4e5dbbe1ef27","AGENTS.md","85cb48e2-9bd6-11f1-8663-1607ee4eb77e",31,["D",1787152232560],"# apexGemTracker — context for future edits\n\nTracks Apex Manager market listings to find \"hidden gems\": players who displayed\nBELOW A- potential on the market but actually retired with A- or higher\npotential (i.e. fog hid their true quality). Separate from the alert vals — this\nis a data collection + comparison pipeline, no notifications.\n\n## ⚠️ CRITICAL: compare LETTER GRADES, never numeric ratings\n\nThe game's numeric `trueRating` / `potentialRating` do NOT map to a reliable\ngrade scale — do NOT infer a grade from a number. (Lesson learned: Parker has\n`potentialRating 1986` but retired as C/B; flagging him as A- from 1986 was\nWRONG.) The authoritative \"true\" grade is the **revealed letter grade on the\nretired card** (`estimatedRank` / `estimatedPotential` at fogConfidence=1).\n\n**Gem rule (in `db.ts` `isGem`):**\n`is_gem = isBelowAMinus(marketPotential) && !isBelowAMinus(retiredPotential)`\ni.e. market displayed potential < A- AND retired revealed potential >= A-.\n\n## fog semantics (same as the alert vals)\n\n`fogConfidence` (API) = INTEL. Displayed \"Fog %\" = 100 − fogConfidence·100. High\nintel (low fog) = well-scouted/revealed; low intel (high fog) =\nobscured/lottery.\n\n## Data model\n\n- `listings` — every market listing (keyed by auction_id), first-seen snapshot\n of est rank/potential/intel/fog/salary + full player_json. Upserted each\n collect run (no duplicates); `left_at` set when a listing stops appearing.\n- `retired` — resolved players: market display vs retired revealed grade\n (`retired_rank`/`retired_potential`) + numeric true/potential/peak ratings +\n `is_gem`\n - `card_url`.\n- `player_checks` — dedupe/backoff so we don't re-hit a player card too often.\n\n## Jobs\n\n- `collect.ts` (interval, */15): snapshot all `/api/auctions` listings.\n- `check.ts` (interval, hourly): for listings >=24h old, GET\n `/api/players/{id}`; if retired, record true ratings + market-vs-retired\n comparison; else re-check weekly. (Unsigned players retire immediately, so the\n table fills within ~a day.)\n- `report.ts` (http, https://apex-gem-tracker.val.run/): JSON at `/`, CSV at\n `/csv`.\n- `main.ts`: init schema + status counts.\n\n## Env\n\n- APEX_TOKEN — Apex Manager API bearer token (required).\n\n## Spreadsheet exports\n\n`report.ts` also serves `/listings` and `/csv/listings` for the active market\n(not yet resolved), alongside the original `/` and `/csv` (aka `/csv/gems`) for\nresolved players — `/csv` now also includes `retired_at`. A Google Sheet pulls\nboth CSV endpoints live via `IMPORTDATA()` so the data is easy to read without\nhitting the raw endpoints directly.",[186],"pulls","branches","forks","envVars",{"_199":164,"_201":63},"connections",{"_199":63,"_200":63},"count","unfilledCount","emptyCount",{"_43":185,"_32":186,"_30":187,"_141":-5,"_41":42,"_40":188,"_143":25,"_38":228,"_13":145,"_33":20,"_35":190,"_24":25,"_148":-5,"_210":229,"_27":230},{"_43":182,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":25,"_38":225,"_13":172,"_33":34,"_35":37,"_24":25,"_148":-5,"_210":226,"_27":227},{"_43":175,"_32":176,"_30":177,"_141":-5,"_41":42,"_40":178,"_143":25,"_38":222,"_13":164,"_33":34,"_35":180,"_24":25,"_148":-5,"_210":223,"_27":224},{"_43":167,"_32":168,"_30":169,"_141":-5,"_41":42,"_40":170,"_143":25,"_38":219,"_13":172,"_33":146,"_35":173,"_24":25,"_148":-5,"_210":220,"_27":221},{"_43":159,"_32":160,"_30":161,"_141":-5,"_41":42,"_40":162,"_143":59,"_38":216,"_13":164,"_33":146,"_35":165,"_24":25,"_148":-5,"_210":217,"_27":218},{"_43":150,"_32":151,"_30":57,"_141":-5,"_41":42,"_40":152,"_143":25,"_38":213,"_13":154,"_33":155,"_35":156,"_24":25,"_148":157,"_210":214,"_27":215},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":59,"_38":209,"_13":145,"_33":146,"_35":147,"_24":25,"_148":-5,"_210":211,"_27":212},["D",1787147868661],"children",[],[139],["D",1787158678621],[],[151],["D",1787147006802],[],[160],["D",1787147851134],[],[168],["D",1787147006885],[],[176],["D",1787159901997],[],[28],["D",1787152232560],[],[186],["D",1787146151215],["D",1789491713377],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_128":269,"_270":271,"_272":273,"_274":25,"_275":25,"_276":25,"_277":59,"_278":-5,"_279":-7,"_280":-7,"_281":63,"_282":25,"_283":25,"_284":-5,"_285":25,"_286":25,"_287":25,"_288":-5},"ENV",{"_240":241,"_242":243,"_244":90,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268},"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 · v33