[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_184":185,"_186":187},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_61":100,"_16":-7,"_149":-5,"_17":150,"_151":152,"_28":153,"_21":154,"_23":155,"_156":-5,"_157":-5,"_158":-5,"_159":35,"_160":161,"_162":38,"_163":-5,"_164":-5,"_165":166},"routes/_app.x.$handle.$name._index",{"_11":12,"_13":14,"_15":-7,"_16":-7,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-7,"_26":-5,"_27":-5,"_28":29,"_30":31,"_32":-5,"_33":-5,"_34":35,"_36":35,"_37":38},"handle","mattbmyers","name","maptap","branchName","version","project",{"_39":92,"_13":14,"_50":93,"_94":-5,"_95":35,"_96":97,"_98":97,"_99":100,"_101":-5,"_102":103,"_104":43,"_105":38,"_106":-5,"_107":-5,"_108":81,"_109":110,"_111":112,"_113":114,"_115":116,"_117":-5,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_127":128,"_129":130,"_131":132,"_133":35},"tags",[],"counts",{"_80":81,"_82":83,"_84":81,"_85":86,"_87":88},"contents",[74,75],"readme","upstream","pull","files",[63,31],"preview",{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":51,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_59":60,"_61":62},"ahead","behind","showHomeCustomizationHint",false,"showHTTPPreviewSettingsHint","hasHTTPFiles",true,"id","211417d0-93be-4ff3-9264-a0751ee63907","maptap.ts","fileId","e7a768c4-b153-11f1-baee-1607ee4eb77e","parentId","branchId","831c30bd-e871-44fc-bf1b-03b24fad8e4a","branchVersion",17,"latest","createdAt",["D",1789594689547],7,"fileType","http","content","// Val Town HTTP val — name it \"maptap\"\n// Combines the logging endpoint and the leaderboard page into one val so\n// they can share a single val-scoped SQLite database (the current\n// recommended pattern — see https://docs.val.town/reference/std/sqlite).\n//\n// Routes:\n// GET/POST /log?name=Matt&score=87 -> logs a score, returns JSON\n// GET / (anything else) -> public leaderboard page\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst RATE_LIMIT = 20; // max /log requests allowed per window\nconst WINDOW_MS = 60_000; // 1 minute\nconst TIMEZONE = \"America/Denver\"; // Mountain Time; handles MST/MDT automatically\n\nfunction mountainDateString(date: Date): string {\n return new Intl.DateTimeFormat(\"en-CA\", {\n timeZone: TIMEZONE,\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n }).format(date); // \"YYYY-MM-DD\"\n}\n\nasync function ensureTables() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS scores (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n score REAL NOT NULL,\n created_at TEXT NOT NULL,\n is_default INTEGER NOT NULL DEFAULT 0\n )`);\n try {\n // Migration for tables created before is_default existed; no-op if it's already there.\n await sqlite.execute(\n `ALTER TABLE scores ADD COLUMN is_default INTEGER NOT NULL DEFAULT 0`,\n );\n } catch {\n // column already exists\n }\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS rate_limit (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n ts INTEGER NOT NULL\n )`);\n}\n\nconst AUTO_TOOLTIP =\n \"Missed day: backfilled at 80 percent of the lowest real score logged that day\";\nconst AVG_TOOLTIP =\n \"Average of real scores only, backfilled days are not counted\";\n\nfunction escapeHtml(s: string): string {\n return s\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\");\n}\n\nasync function handleLog(req: Request): Promise {\n const now = Date.now();\n\n // Sliding-window rate limit shared by all callers (small trusted friend group).\n await sqlite.execute({\n sql: \"DELETE FROM rate_limit WHERE ts < ?\",\n args: [now - WINDOW_MS],\n });\n const countResult = await sqlite.execute(\n \"SELECT COUNT(*) as count FROM rate_limit\",\n );\n const recentCount = Number(countResult.rows[0].count);\n\n if (recentCount >= RATE_LIMIT) {\n return Response.json(\n { ok: false, error: \"Rate limit exceeded, try again in a minute\" },\n { status: 429 },\n );\n }\n\n await sqlite.execute({\n sql: \"INSERT INTO rate_limit (ts) VALUES (?)\",\n args: [now],\n });\n\n const url = new URL(req.url);\n const name = url.searchParams.get(\"name\")?.trim();\n const scoreRaw = url.searchParams.get(\"score\");\n const score = scoreRaw !== null ? Number(scoreRaw) : NaN;\n\n if (!name || name.length === 0 || !Number.isFinite(score)) {\n return Response.json(\n { ok: false, error: \"Missing or invalid 'name' or 'score' query param\" },\n { status: 400 },\n );\n }\n\n const today = mountainDateString(new Date());\n const existing = await sqlite.execute({\n sql: \"SELECT created_at FROM scores WHERE name = ? AND is_default = 0\",\n args: [name],\n });\n const alreadyLoggedToday = (\n existing.rows as unknown as { created_at: string }[]\n ).some((row) => mountainDateString(new Date(row.created_at)) === today);\n\n if (alreadyLoggedToday) {\n return Response.json(\n { ok: false, error: \"Score already logged for today\" },\n { status: 409 },\n );\n }\n\n await sqlite.execute({\n sql:\n \"INSERT INTO scores (name, score, created_at, is_default) VALUES (?, ?, ?, 0)\",\n args: [name, score, new Date().toISOString()],\n });\n\n return Response.json({ ok: true, name, score });\n}\n\nasync function handleLeaderboard(): Promise {\n const result = await sqlite.execute(\n \"SELECT name, score, created_at, is_default FROM scores ORDER BY created_at DESC\",\n );\n const rows = result.rows as unknown as {\n name: string;\n score: number;\n created_at: string;\n is_default: number;\n }[];\n\n const today = mountainDateString(new Date());\n\n const totals = new Map();\n const gamesPlayed = new Map();\n const realScoreSum = new Map();\n const playedToday = new Set();\n for (const row of rows) {\n totals.set(row.name, (totals.get(row.name) ?? 0) + Number(row.score));\n if (!row.is_default) {\n gamesPlayed.set(row.name, (gamesPlayed.get(row.name) ?? 0) + 1);\n realScoreSum.set(\n row.name,\n (realScoreSum.get(row.name) ?? 0) + Number(row.score),\n );\n if (mountainDateString(new Date(row.created_at)) === today) {\n playedToday.add(row.name);\n }\n }\n }\n const leaderboard = [...totals.entries()]\n .map(([name, total]) => {\n const games = gamesPlayed.get(name) ?? 0;\n const average = games > 0 ? realScoreSum.get(name)! / games : 0;\n return { name, total, average, today: playedToday.has(name) };\n })\n .sort((a, b) => b.total - a.total);\n const recent = rows.slice(0, 25);\n\n const leaderboardRows = leaderboard\n .map(\n (row, i) => `\n \n ${i + 1}\n ${escapeHtml(row.name)}\n ${row.today ? \"✓\" : \"–\"}\n ${row.average.toFixed(1)}\n ${row.total}\n `,\n )\n .join(\"\");\n\n const recentRows = recent\n .map(\n (row) => `\n \n ${new Date(row.created_at).toLocaleDateString()}\n ${escapeHtml(row.name)}${\n row.is_default\n ? ` ^?`\n : \"\"\n }\n ${row.score}\n `,\n )\n .join(\"\");\n\n const html = `\n\n\n\n\nMapTap Leaderboard\n\n\n\n

🗺️ MapTap Leaderboard

Running total score, all-time

\n \n \n ${\n leaderboardRows ||\n ``\n }\n

#	Name	Today	Avg ^?	Total
No scores yet

\n\n

Recent scores

\n \n \n ${\n recentRows || ``\n }\n

Date	Name	Score
No scores yet

\n\n`;\n\n return new Response(html, {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\nexport default async function (req: Request): Promise {\n await ensureTables();\n\n const url = new URL(req.url);\n if (url.pathname.startsWith(\"/log\")) {\n return handleLog(req);\n }\n return handleLeaderboard();\n}","deleted","label","children",[],"path",[41],{"_39":64,"_13":65,"_42":66,"_44":-5,"_45":46,"_47":67,"_49":38,"_50":68,"_16":69,"_53":70,"_55":71,"_57":35,"_58":-5,"_59":72,"_61":73},"eea95c5b-5e71-4eee-97ba-c465574cae39","backfill.ts","d15b1356-b156-11f1-9359-1607ee4eb77e",16,["D",1789514406474],6,"interval","// Val Town CRON val — add this as a SECOND FILE inside the SAME \"maptap\" val\n// (in the maptap val's editor, click \"+\" in the top right -> CRON) so it\n// shares the val-scoped SQLite database with maptap.ts. Do not create this\n// as a separate/standalone val, or it won't see the \"scores\" table.\n// Schedule is set from the Val Town dashboard, not here.\n//\n// What it does: for \"yesterday\" (Mountain time), finds anyone who has ever\n// logged a real score but didn't log one yesterday, and backfills them with\n// 80% of yesterday's lowest real score. If NOBODY logged a real score\n// yesterday, there's no \"lowest score\" to base that on, so everyone gets a\n// flat default instead.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst PENALTY_FACTOR = 0.8;\nconst FLAT_DEFAULT_SCORE = 800; // used only when nobody at all played that day\nconst TIMEZONE = \"America/Denver\"; // Mountain Time; handles MST/MDT automatically\n\nfunction mountainDateString(date: Date): string {\n return new Intl.DateTimeFormat(\"en-CA\", {\n timeZone: TIMEZONE,\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n }).format(date); // \"YYYY-MM-DD\"\n}\n\nexport default async function (_interval: Interval) {\n const yesterday = new Date(Date.now() - 24 * 60 * 60 * 1000);\n const targetDate = mountainDateString(yesterday);\n\n const result = await sqlite.execute(\n \"SELECT name, score, created_at, is_default FROM scores\",\n );\n const rows = result.rows as unknown as {\n name: string;\n score: number;\n created_at: string;\n is_default: number;\n }[];\n\n // Everyone who has ever submitted a real (non-backfilled) score.\n const roster = new Set(rows.filter((r) => !r.is_default).map((r) => r.name));\n\n // Real submissions specifically for the target date.\n const targetDayReal = rows.filter(\n (r) =>\n !r.is_default &&\n mountainDateString(new Date(r.created_at)) === targetDate,\n );\n\n const defaultScore = targetDayReal.length > 0\n ? Math.min(...targetDayReal.map((r) => r.score)) * PENALTY_FACTOR\n : FLAT_DEFAULT_SCORE;\n\n // Anyone who already has ANY row (real or previously backfilled) for this\n // date is skipped — makes re-running the job safe (no double-inserts).\n const alreadyHasRowForDate = new Set(\n rows\n .filter((r) => mountainDateString(new Date(r.created_at)) === targetDate)\n .map((r) => r.name),\n );\n\n // Each person's own anchor: the date of their first-ever real submission.\n // Never backfill a date before someone actually started playing.\n const firstPlayDate = new Map();\n for (const r of rows) {\n if (r.is_default) continue;\n const d = mountainDateString(new Date(r.created_at));\n const earliest = firstPlayDate.get(r.name);\n if (!earliest || d < earliest) firstPlayDate.set(r.name, d);\n }\n\n const missing = [...roster].filter((name) => {\n if (alreadyHasRowForDate.has(name)) return false;\n const anchor = firstPlayDate.get(name)!;\n return targetDate >= anchor;\n });\n\n for (const name of missing) {\n await sqlite.execute({\n sql:\n \"INSERT INTO scores (name, score, created_at, is_default) VALUES (?, ?, ?, 1)\",\n args: [name, defaultScore, `${targetDate}T12:00:00.000Z`],\n });\n console.log(`Backfilled ${name} for ${targetDate}: ${defaultScore}`);\n }\n\n if (missing.length === 0) {\n console.log(`No missing players for ${targetDate}.`);\n }\n}",[],[65],{"_39":64,"_13":65,"_42":66,"_44":-5,"_45":46,"_47":67,"_49":38,"_50":78,"_16":69,"_53":70,"_55":71,"_57":35,"_58":-5,"_61":79},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":76,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_61":77},["D",1789594689547],[41],["D",1789514406474],[65],"pulls",0,"branches",1,"forks","envVars",{"_89":81,"_91":81},"connections",{"_89":81,"_90":81},"count","unfilledCount","emptyCount","3f33c5c2-f83f-42db-ab66-7fea98c6cbc2",["D",1789510931384],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","2410b711-eaed-4362-9284-b8ce3c0c632b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a0a6fd-aeb4-7674-ae2d-00f34879f4e8","tursoName","3f33c5c2f83f42dbab667fea98c6cbc2","tursoHostname","3f33c5c2f83f42dbab667fea98c6cbc2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789522252250],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_148":100},"org",{"_11":12,"_143":100,"_144":100,"_102":103,"_145":146,"_147":35},"branch",{"_16":48,"_13":134,"_39":46,"_135":92,"_136":-5,"_137":-5,"_138":-5,"_139":-5,"_140":-5,"_141":14,"_142":12},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_39":92,"_13":14,"_50":179,"_94":-5,"_95":35,"_96":97,"_98":97,"_99":100,"_101":-5,"_102":103,"_104":43,"_105":38,"_106":-5,"_107":-5,"_108":81,"_109":110,"_111":112,"_113":114,"_115":180,"_117":-5,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_127":181,"_129":182,"_131":183,"_133":35},"tree",[173,174],[173,174],{"_80":81,"_82":83,"_84":81,"_85":171,"_87":172},[167,168],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_39":64,"_13":65,"_42":66,"_44":-5,"_45":46,"_47":67,"_49":38,"_50":78,"_16":69,"_53":70,"_55":71,"_57":35,"_58":-5,"_61":170},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":76,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_61":169},[41],[65],{"_89":81,"_91":81},{"_89":81,"_90":81},{"_39":64,"_13":65,"_42":66,"_44":-5,"_45":46,"_47":67,"_49":38,"_50":68,"_16":69,"_53":70,"_55":71,"_57":35,"_58":-5,"_59":177,"_61":178},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":51,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_59":175,"_61":176},[],[41],[],[65],["D",1789510931384],["D",1789522252250],{"_11":12,"_148":100},{"_11":12,"_143":100,"_144":100,"_102":103,"_145":146,"_147":35},{"_16":48,"_13":134,"_39":46,"_135":92,"_136":-5,"_137":-5,"_138":-5,"_139":-5,"_140":-5,"_141":14,"_142":12},"ctx",{"_127":-5,"_164":217,"_218":219,"_220":221,"_222":35,"_223":35,"_224":35,"_225":38,"_226":-5,"_227":-7,"_228":-7,"_229":81,"_230":35,"_231":35,"_232":-5,"_233":35,"_234":35,"_235":35,"_236":-5},"ENV",{"_188":189,"_190":191,"_192":134,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","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"]