[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_157":158,"_159":160},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_106":87,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":57,"_124":-5,"_125":-5,"_126":127},"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":45,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",10,"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","downloads.ts","latestPath","fileId","62d0813e-af10-11f1-a09d-1607ee4eb77e","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst FILE_URL = \"\";\nconst APP_NAME = \"gahh\";\n\nconst CORS = {\n \"access-control-allow-origin\": \"*\",\n \"access-control-allow-methods\": \"GET, POST, OPTIONS\",\n \"access-control-allow-headers\": \"content-type\",\n};\n\nasync function init() {\n await sqlite.execute(`create table if not exists downloads (\n id integer primary key autoincrement,\n ts text not null,\n day text not null,\n referrer text\n )`);\n}\n\nasync function getStats() {\n const day = new Date().toISOString().slice(0, 10);\n const weekAgo = new Date(Date.now() - 6 * 86400000).toISOString().slice(\n 0,\n 10,\n );\n\n const total = await sqlite.execute(\"select count(*) as c from downloads\");\n const today = await sqlite.execute({\n sql: \"select count(*) as c from downloads where day = ?\",\n args: [day],\n });\n const week = await sqlite.execute({\n sql: \"select count(*) as c from downloads where day >= ?\",\n args: [weekAgo],\n });\n const byDay = await sqlite.execute(\n \"select day, count(*) as c from downloads group by day order by day desc limit 14\",\n );\n\n return {\n total: Number(total.rows[0][0] ?? total.rows[0].c ?? 0),\n today: Number(today.rows[0][0] ?? today.rows[0].c ?? 0),\n week: Number(week.rows[0][0] ?? week.rows[0].c ?? 0),\n byDay: byDay.rows.map((r) => ({\n day: String(r[0] ?? r.day),\n c: Number(r[1] ?? r.c),\n })),\n };\n}\n\nasync function ping(stats, referrer) {\n const url = Deno.env.get(\"DISCORD_WEBHOOK\");\n if (!url) return;\n await fetch(url, {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({\n embeds: [\n {\n title: \"New download\",\n color: 5995514,\n fields: [\n { name: \"Total\", value: String(stats.total), inline: true },\n { name: \"Today\", value: String(stats.today), inline: true },\n { name: \"Came from\", value: referrer || \"direct\", inline: false },\n ],\n timestamp: new Date().toISOString(),\n },\n ],\n }),\n });\n}\n\nasync function record(req) {\n const now = new Date();\n await sqlite.execute({\n sql: \"insert into downloads (ts, day, referrer) values (?, ?, ?)\",\n args: [\n now.toISOString(),\n now.toISOString().slice(0, 10),\n req.headers.get(\"referer\") || \"\",\n ],\n });\n const stats = await getStats();\n await ping(stats, req.headers.get(\"referer\") || \"\");\n return stats;\n}\n\nfunction statsPage(s) {\n const max = Math.max(1, ...s.byDay.map((r) => r.c));\n const rows = s.byDay\n .map(\n (r) =>\n `${r.day}

${r.c}`,\n )\n .join(\"\");\n\n return `\n\n${APP_NAME} downloads\n\n

${APP_NAME} downloads

${s.total}

Total

${s.today}

Today

${s.week}

7 days

\n${rows || \"\"}

No downloads yet

`;\n}\n\nexport default async function (req: Request): Promise {\n await init();\n const path = new URL(req.url).pathname.replace(/\\/+$/, \"\") || \"/\";\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204, headers: CORS });\n }\n\n if (path === \"/count\") {\n await record(req);\n return new Response(null, { status: 204, headers: CORS });\n }\n\n if (path === \"/download\") {\n await record(req);\n if (!FILE_URL) {\n return new Response(\"Counted, but no file link set yet\", { status: 200 });\n }\n return Response.redirect(FILE_URL, 302);\n }\n\n if (path === \"/api/stats\") {\n const s = await getStats();\n return Response.json(s, { headers: CORS });\n }\n\n const s = await getStats();\n return new Response(statsPage(s), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst FILE_URL = \"\";\nconst APP_NAME = \"gahh\";\n\nconst CORS = {\n \"access-control-allow-origin\": \"*\",\n \"access-control-allow-methods\": \"GET, POST, OPTIONS\",\n \"access-control-allow-headers\": \"content-type\",\n};\n\nasync function init() {\n await sqlite.execute(`create table if not exists downloads (\n id integer primary key autoincrement,\n ts text not null,\n day text not null,\n referrer text\n )`);\n try {\n await sqlite.execute(\"alter table downloads add column ip text\");\n } catch (e) {}\n}\n\nfunction getIp(req) {\n const fwd = req.headers.get(\"x-forwarded-for\");\n if (fwd) return fwd.split(\",\")[0].trim();\n return (\n req.headers.get(\"cf-connecting-ip\") ||\n req.headers.get(\"x-real-ip\") ||\n \"unknown\"\n );\n}\n\nfunction num(row) {\n return Number(row[0] ?? row.c ?? 0);\n}\n\nasync function getStats() {\n const day = new Date().toISOString().slice(0, 10);\n const weekAgo = new Date(Date.now() - 6 * 86400000).toISOString().slice(\n 0,\n 10,\n );\n\n const total = await sqlite.execute(\"select count(*) as c from downloads\");\n const today = await sqlite.execute({\n sql: \"select count(*) as c from downloads where day = ?\",\n args: [day],\n });\n const week = await sqlite.execute({\n sql: \"select count(*) as c from downloads where day >= ?\",\n args: [weekAgo],\n });\n const unique = await sqlite.execute(\n \"select count(distinct ip) as c from downloads\",\n );\n const byDay = await sqlite.execute(\n \"select day, count(*) as c from downloads group by day order by day desc limit 14\",\n );\n const recent = await sqlite.execute(\n \"select ts, ip, referrer from downloads order by id desc limit 15\",\n );\n\n return {\n total: num(total.rows[0]),\n today: num(today.rows[0]),\n week: num(week.rows[0]),\n unique: num(unique.rows[0]),\n byDay: byDay.rows.map((r) => ({\n day: String(r[0] ?? r.day),\n c: Number(r[1] ?? r.c),\n })),\n recent: recent.rows.map((r) => ({\n ts: String(r[0] ?? r.ts ?? \"\"),\n ip: String(r[1] ?? r.ip ?? \"unknown\"),\n referrer: String(r[2] ?? r.referrer ?? \"\"),\n })),\n };\n}\n\nasync function ping(stats, info) {\n let url;\n try {\n url = Deno.env.get(\"DISCORD_WEBHOOK\");\n } catch (e) {\n url = undefined;\n }\n if (!url && typeof process !== \"undefined\" && process.env) {\n url = process.env.DISCORD_WEBHOOK;\n }\n\n if (!url) {\n console.log(\"WEBHOOK MISSING: env var not readable\");\n return;\n }\n\n const res = await fetch(url, {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({\n embeds: [\n {\n title: \"New download\",\n color: 5995514,\n fields: [\n { name: \"Total\", value: String(stats.total), inline: true },\n { name: \"Today\", value: String(stats.today), inline: true },\n { name: \"Unique IPs\", value: String(stats.unique), inline: true },\n { name: \"IP\", value: info.ip, inline: false },\n {\n name: \"Came from\",\n value: info.referrer || \"direct\",\n inline: false,\n },\n ],\n timestamp: new Date().toISOString(),\n },\n ],\n }),\n });\n\n const text = await res.text();\n console.log(\"discord replied\", res.status, text.slice(0, 300));\n}\n\nasync function record(req) {\n const now = new Date();\n const info = { ip: getIp(req), referrer: req.headers.get(\"referer\") || \"\" };\n\n await sqlite.execute({\n sql: \"insert into downloads (ts, day, referrer, ip) values (?, ?, ?, ?)\",\n args: [\n now.toISOString(),\n now.toISOString().slice(0, 10),\n info.referrer,\n info.ip,\n ],\n });\n\n const stats = await getStats();\n try {\n await ping(stats, info);\n } catch (e) {\n console.log(\"ping failed\", String(e));\n }\n return stats;\n}\n\nfunction esc(s) {\n return String(s).replace(\n /[&<>\"]/g,\n (c) => ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\" })[c],\n );\n}\n\nfunction statsPage(s) {\n const max = Math.max(1, ...s.byDay.map((r) => r.c));\n const days = s.byDay\n .map(\n (r) =>\n `${\n esc(r.day)\n }

${r.c}`,\n )\n .join(\"\");\n\n const recent = s.recent\n .map(\n (r) =>\n `${esc(r.ts.slice(0, 16).replace(\"T\", \" \"))}${\n esc(r.ip)\n }${\n esc(r.referrer.slice(0, 40) || \"direct\")\n }`,\n )\n .join(\"\");\n\n return `\n\n${esc(APP_NAME)} downloads\n\n

${esc(APP_NAME)} downloads

${s.total}

Total

${s.today}

Today

${s.week}

7 days

${s.unique}

Unique IPs

Last 14 days

${\n days || \"\"\n }

No downloads yet

Recent

${\n recent || \"\"\n }

No downloads yet

`;\n}\n\nexport default async function (req: Request): Promise {\n await init();\n const path = new URL(req.url).pathname.replace(/\\/+$/, \"\") || \"/\";\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204, headers: CORS });\n }\n\n if (path === \"/count\") {\n await record(req);\n return new Response(null, { status: 204, headers: CORS });\n }\n\n if (path === \"/download\") {\n await record(req);\n if (!FILE_URL) {\n return new Response(\"Counted, but no file link set yet\", { status: 200 });\n }\n return Response.redirect(FILE_URL, 302);\n }\n\n if (path === \"/api/stats\") {\n const s = await getStats();\n return Response.json(s, { headers: CORS });\n }\n\n const s = await getStats();\n return new Response(statsPage(s), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}","createdAt",["D",1789262959373],"branchVersion","branchId","d1024ff6-272f-437f-92f3-fda423b18d36","id","fd230ff5-da4a-456a-8ba6-c9f2abad5a0b","gahh",["D",1789261978820],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","795f3337-ac6f-4427-a224-f83d5265ff39","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a09852-829d-734f-a9c3-24c44c70ade3","tursoName","fd230ff5da4a456a8ba6c9f2abad5a0b","tursoHostname","fd230ff5da4a456a8ba6c9f2abad5a0b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789523429989],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":25},"branch",{"_13":14,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","assorted","handle","displayName","Eli Stelzner","avatar","https://lh3.googleusercontent.com/a/ACg8ocIvhHEyjnobDIDdcGVgu771lCA0zok-a2AeFBY2CA3mrgRW8CE=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":152,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":45,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":153,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":154,"_82":155,"_84":156,"_86":25},"tree",[147],"files",[147],"counts",{"_136":61,"_137":138,"_139":61,"_140":141,"_142":143},"contents",[128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":57,"_38":132,"_13":133,"_33":34,"_35":37,"_24":25,"_134":45,"_27":135},"41b97107-53e1-4533-a0d8-d2db3db3155d","parentId","latest",["D",1789262959373],5,"label",[28],"pulls","branches",1,"forks","envVars",{"_144":138,"_146":61},"connections",{"_144":61,"_145":61},"count","unfilledCount","emptyCount",{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":57,"_38":148,"_13":133,"_33":34,"_35":37,"_24":25,"_134":45,"_149":150,"_27":151},["D",1789262959373],"children",[],[28],["D",1789261978820],["D",1789523429989],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":25},{"_13":14,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_80":-5,"_125":190,"_191":192,"_193":194,"_195":25,"_196":25,"_197":25,"_198":57,"_199":-5,"_200":-7,"_201":-7,"_202":61,"_203":25,"_204":25,"_205":-5,"_206":25,"_207":25,"_208":25,"_209":-5},"ENV",{"_161":162,"_163":164,"_165":87,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189},"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 · v10