🗺️ 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}",7,["D",1789594689547],"branchVersion","label",[18],"pulls","branches",1,"forks","envVars",{"_218":26,"_220":26},"connections",{"_218":26,"_219":26},"count","unfilledCount","emptyCount",{"_39":228,"_13":229,"_68":230,"_49":-5,"_41":42,"_207":231,"_223":142,"_43":232,"_45":93,"_71":233,"_203":234,"_73":24,"_208":-5,"_225":235,"_17":236},{"_39":202,"_13":18,"_68":69,"_49":-5,"_41":42,"_207":124,"_223":142,"_43":224,"_45":205,"_71":72,"_203":204,"_73":24,"_208":-5,"_225":226,"_17":227},"latest",["D",1789594689547],"children",[],[18],"eea95c5b-5e71-4eee-97ba-c465574cae39","backfill.ts","d15b1356-b156-11f1-9359-1607ee4eb77e",16,["D",1789514406474],"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}",[],[229],["D",1789510931384],["D",1789609258211],{"_11":12,"_180":76},{"_11":12,"_176":76,"_75":76,"_30":74,"_177":178,"_179":24},{"_45":124,"_13":16,"_39":42,"_168":131,"_169":-5,"_170":-5,"_171":-5,"_172":-5,"_173":-5,"_174":14,"_175":12},"ctx",{"_58":-5,"_199":275,"_276":277,"_278":279,"_280":24,"_281":24,"_282":24,"_283":142,"_284":-5,"_285":-7,"_286":-7,"_287":26,"_288":24,"_289":24,"_290":-5,"_291":24,"_292":24,"_293":24,"_294":-5},"ENV",{"_246":247,"_248":249,"_250":16,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274},"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"]

History · maptap.ts