[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_167":168,"_169":170},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_106":89,"_27":53,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":58,"_123":-5,"_124":-5,"_125":126},"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":31,"_57":58,"_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":25},"version",4,"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","maptap.ts","latestPath","fileId","e7a768c4-b153-11f1-baee-1607ee4eb77e","name","fileType","http","content","// Learn more: https://docs.val.town/vals/http/\nexport default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}","// 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\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 )`);\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\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 await sqlite.execute({\n sql: \"INSERT INTO scores (name, score, created_at) VALUES (?, ?, ?)\",\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 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 }[];\n\n const totals = new Map();\n for (const row of rows) {\n totals.set(row.name, (totals.get(row.name) ?? 0) + Number(row.score));\n }\n const leaderboard = [...totals.entries()].sort((a, b) => b[1] - a[1]);\n const recent = rows.slice(0, 25);\n\n const leaderboardRows = leaderboard\n .map(\n ([name, total], i) => `\n \n ${i + 1}\n ${escapeHtml(name)}\n ${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.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	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}","createdAt",["D",1789510983476],"branchVersion","branchId","831c30bd-e871-44fc-bf1b-03b24fad8e4a","id","3f33c5c2-f83f-42db-ab66-7fea98c6cbc2","maptap",["D",1789510931384],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","2410b711-eaed-4362-9284-b8ce3c0c632b","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0a6fd-aeb4-7674-ae2d-00f34879f4e8","tursoName","3f33c5c2f83f42dbab667fea98c6cbc2","tursoHostname","3f33c5c2f83f42dbab667fea98c6cbc2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789609258211],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_105":53},"org",{"_99":98,"_100":53,"_101":53,"_18":55,"_102":103,"_104":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",17,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","mattbmyers","handle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":162,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":163,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":164,"_83":165,"_85":166,"_87":25},"tree",[153,154],"files",[153,154],"counts",{"_143":62,"_144":139,"_145":62,"_146":147,"_148":149},"contents",[127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":136,"_32":137,"_30":138,"_130":-5,"_41":42,"_40":139,"_131":25,"_38":140,"_13":62,"_33":141,"_35":53,"_24":25,"_134":-5,"_27":142},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":132,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_27":135},"cbbc96e6-ee3d-4981-8862-9ddbd40e594c","parentId","latest",["D",1789510983476],2,"label",[28],"87591f39-2c20-49f9-8d77-295c9acf308e","main.ts","e572da8e-b153-11f1-9571-1607ee4eb77e",1,["D",1789510931492],"script",[137],"pulls","branches","forks","envVars",{"_150":62,"_152":62},"connections",{"_150":62,"_151":62},"count","unfilledCount","emptyCount",{"_43":136,"_32":137,"_30":138,"_130":-5,"_41":42,"_40":139,"_131":25,"_38":159,"_13":62,"_33":141,"_35":53,"_24":25,"_134":-5,"_156":160,"_27":161},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":155,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_156":157,"_27":158},["D",1789510983476],"children",[],[28],["D",1789510931492],[],[137],["D",1789510931384],["D",1789609258211],{"_99":98,"_105":53},{"_99":98,"_100":53,"_101":53,"_18":55,"_102":103,"_104":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_124":200,"_201":202,"_203":204,"_205":25,"_206":25,"_207":25,"_208":58,"_209":-5,"_210":-7,"_211":-7,"_212":62,"_213":25,"_214":25,"_215":-5,"_216":25,"_217":25,"_218":25,"_219":-5},"ENV",{"_171":172,"_173":174,"_175":89,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199},"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"]

Diff · v4