[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_102":84,"_27":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":57,"_120":-5,"_121":-5,"_122":123},"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":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",7,"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","main.ts","latestPath","fileId","91fba682-93c8-11f0-86e4-0224a6c84d84","name","fileType","http","content","// Learn more: https://docs.val.town/vals/http/\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\ntype Owner = { provider: string; providerId: string; name: string };\n\nconst send = (text: string, status = 200) =>\n new Response(text, {\n status,\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n\nconst bad = (msg: string, status = 400) => send(`❌ ${msg}`, status);\n\nconst toHuman = (ms: number) => {\n if (ms < 1000) return `${ms}ms`;\n const s = Math.floor(ms / 1000);\n if (s < 60) return `${s}s`;\n const m = Math.floor(s / 60);\n const sec = s % 60;\n if (m < 60) return `${m}m ${sec}s`;\n const h = Math.floor(m / 60);\n const min = m % 60;\n return `${h}h ${min}m ${sec}s`;\n};\n\n// ONE statement only (avoids SQL_MANY_STATEMENTS)\nasync function ensureSchema() {\n await sqlite.execute(`\n create table if not exists timers (\n owner_provider text not null,\n owner_provider_id text not null,\n owner_name text not null,\n name text not null,\n started_at integer, -- epoch ms (null if never started)\n stopped_at integer, -- epoch ms or null (running)\n primary key (owner_provider, owner_provider_id)\n )\n `);\n}\n\n// Example Nightbot-User header:\n// \"name=foo&displayName=Foo&provider=twitch&providerId=123&userLevel=owner\"\nfunction parseNightbotUser(h: string | null): (Owner & { key: string }) | null {\n if (!h) return null;\n const obj: Record = {};\n for (const part of h.split(\"&\")) {\n const [k, v] = part.split(\"=\");\n if (!k) continue;\n obj[decodeURIComponent(k)] = decodeURIComponent(v ?? \"\");\n }\n const provider = obj[\"provider\"];\n const providerId = obj[\"providerId\"];\n const name = obj[\"displayName\"] || obj[\"name\"] || \"unknown\";\n if (!provider || !providerId) return null;\n return { provider, providerId, name, key: `${provider}:${providerId}` };\n}\n\nasync function upsertStart(owner: Owner, timerName: string) {\n const startedAt = Date.now();\n await sqlite.execute({\n sql: `\n insert into timers (owner_provider, owner_provider_id, owner_name, name, started_at, stopped_at)\n values (:p, :pid, :oname, :name, :started, null)\n on conflict(owner_provider, owner_provider_id) do update set\n owner_name = excluded.owner_name,\n name = excluded.name,\n started_at = excluded.started_at,\n stopped_at = null\n `,\n args: {\n p: owner.provider,\n pid: owner.providerId,\n oname: owner.name,\n name: timerName,\n started: startedAt,\n },\n });\n return startedAt;\n}\n\nasync function fetchForOwner(owner: Owner) {\n const r = await sqlite.execute({\n sql: `\n select owner_provider, owner_provider_id, owner_name, name, started_at, stopped_at\n from timers\n where owner_provider = :p and owner_provider_id = :pid\n limit 1\n `,\n args: { p: owner.provider, pid: owner.providerId },\n });\n if (r.rows.length === 0) return null;\n const cols = r.columns;\n const row = r.rows[0];\n const o = Object.fromEntries(\n row.map((v: unknown, i: number) => [cols[i], v]),\n ) as {\n owner_provider: string;\n owner_provider_id: string;\n owner_name: string;\n name: string;\n started_at: number | null;\n stopped_at: number | null;\n };\n return o;\n}\n\nexport default async function (req: Request): Promise {\n if (req.method !== \"GET\") return bad(\"Only GET is supported.\", 405);\n\n await ensureSchema();\n\n const url = new URL(req.url);\n const { pathname, searchParams } = url;\n\n const nbUser = parseNightbotUser(req.headers.get(\"Nightbot-User\"));\n if (!nbUser) {\n return bad(\n \"Missing Nightbot-User header (must be called by Nightbot).\",\n 401,\n );\n }\n\n // /starttimer?name=\n if (pathname.endsWith(\"/starttimer\") || pathname.endsWith(\"/start\")) {\n const name = (searchParams.get(\"name\") || \"timer\").trim() || \"timer\";\n const startedAt = await upsertStart(nbUser, name);\n return send(`⏱️ Started \"${name}\".`);\n }\n\n // /checktimer\n if (pathname.endsWith(\"/checktimer\") || pathname.endsWith(\"/status\")) {\n const timer = await fetchForOwner(nbUser);\n if (!timer || timer.started_at == null || timer.stopped_at != null) {\n return send(\"ℹ️ No running timer.\");\n }\n const now = Date.now();\n const elapsedMs = Math.max(0, now - Number(timer.started_at));\n return send(`ℹ️ \"${timer.name}\" — ${toHuman(elapsedMs)} elapsed.`);\n }\n\n // /stoptimer\n if (pathname.endsWith(\"/stoptimer\") || pathname.endsWith(\"/stop\")) {\n const timer = await fetchForOwner(nbUser);\n if (!timer || timer.started_at == null || timer.stopped_at != null) {\n return send(\"ℹ️ No running timer.\");\n }\n const stoppedAt = Date.now();\n const elapsedMs = Math.max(0, stoppedAt - Number(timer.started_at));\n await sqlite.execute({\n sql: `\n update timers\n set stopped_at = :stopped\n where owner_provider = :p and owner_provider_id = :pid\n `,\n args: { p: nbUser.provider, pid: nbUser.providerId, stopped: stoppedAt },\n });\n return send(`✅ Stopped \"${timer.name}\" — ${toHuman(elapsedMs)}.`);\n }\n\n // Help\n return send(\n \"Use /starttimer?name=, /checktimer, /stoptimer. (Plain text responses for Nightbot.)\",\n );\n}","// Learn more: https://docs.val.town/vals/http/\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\ntype Owner = { provider: string; providerId: string; name: string };\n\nconst TABLE = \"user_timers\";\n\nconst send = (text: string, status = 200) =>\n new Response(text, {\n status,\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n\nconst bad = (msg: string, status = 400) => send(`❌ ${msg}`, status);\n\nconst toHuman = (ms: number) => {\n if (ms < 1000) return `${ms}ms`;\n const s = Math.floor(ms / 1000);\n if (s < 60) return `${s}s`;\n const m = Math.floor(s / 60);\n const sec = s % 60;\n if (m < 60) return `${m}m ${sec}s`;\n const h = Math.floor(m / 60);\n const min = m % 60;\n return `${h}h ${min}m ${sec}s`;\n};\n\n// ONE statement only (Val sqlite.execute accepts a single statement)\nasync function ensureSchema() {\n await sqlite.execute(`\n create table if not exists ${TABLE} (\n owner_provider text not null,\n owner_provider_id text not null,\n owner_name text not null,\n name text not null,\n started_at integer,\n stopped_at integer,\n primary key (owner_provider, owner_provider_id)\n )\n `);\n}\n\n// Parse Nightbot-User header (e.g. \"name=foo&displayName=Foo&provider=twitch&providerId=123\")\nfunction parseNightbotUser(h: string | null): (Owner & { key: string }) | null {\n if (!h) return null;\n const obj: Record = {};\n for (const part of h.split(\"&\")) {\n const [k, v] = part.split(\"=\");\n if (!k) continue;\n obj[decodeURIComponent(k)] = decodeURIComponent(v ?? \"\");\n }\n const provider = obj[\"provider\"];\n const providerId = obj[\"providerId\"];\n const name = obj[\"displayName\"] || obj[\"name\"] || \"unknown\";\n if (!provider || !providerId) return null;\n return { provider, providerId, name, key: `${provider}:${providerId}` };\n}\n\nasync function upsertStart(owner: Owner, timerName: string) {\n const startedAt = Date.now();\n await sqlite.execute({\n sql: `\n insert into ${TABLE} (owner_provider, owner_provider_id, owner_name, name, started_at, stopped_at)\n values (:p, :pid, :oname, :name, :started, null)\n on conflict(owner_provider, owner_provider_id) do update set\n owner_name = excluded.owner_name,\n name = excluded.name,\n started_at = excluded.started_at,\n stopped_at = null\n `,\n args: {\n p: owner.provider,\n pid: owner.providerId,\n oname: owner.name,\n name: timerName,\n started: startedAt,\n },\n });\n return startedAt;\n}\n\nasync function fetchForOwner(owner: Owner) {\n const r = await sqlite.execute({\n sql: `\n select owner_provider, owner_provider_id, owner_name, name, started_at, stopped_at\n from ${TABLE}\n where owner_provider = :p and owner_provider_id = :pid\n limit 1\n `,\n args: { p: owner.provider, pid: owner.providerId },\n });\n if (r.rows.length === 0) return null;\n const cols = r.columns;\n const row = r.rows[0];\n const o = Object.fromEntries(\n row.map((v: unknown, i: number) => [cols[i], v]),\n ) as {\n owner_provider: string;\n owner_provider_id: string;\n owner_name: string;\n name: string;\n started_at: number | null;\n stopped_at: number | null;\n };\n return o;\n}\n\nexport default async function (req: Request): Promise {\n if (req.method !== \"GET\") return bad(\"Only GET is supported.\", 405);\n\n await ensureSchema();\n\n const url = new URL(req.url);\n const { pathname, searchParams } = url;\n\n const nbUser = parseNightbotUser(req.headers.get(\"Nightbot-User\"));\n if (!nbUser) {\n return bad(\n \"Missing Nightbot-User header (must be called by Nightbot).\",\n 401,\n );\n }\n\n // /starttimer?name=\n if (pathname.endsWith(\"/starttimer\") || pathname.endsWith(\"/start\")) {\n const name = (searchParams.get(\"name\") || \"timer\").trim() || \"timer\";\n await upsertStart(nbUser, name);\n return send(`⏱️ Started \"${name}\".`);\n }\n\n // /checktimer\n if (pathname.endsWith(\"/checktimer\") || pathname.endsWith(\"/status\")) {\n const timer = await fetchForOwner(nbUser);\n if (!timer || timer.started_at == null || timer.stopped_at != null) {\n return send(\"ℹ️ No running timer.\");\n }\n const now = Date.now();\n const elapsedMs = Math.max(0, now - Number(timer.started_at));\n return send(`ℹ️ \"${timer.name}\" — ${toHuman(elapsedMs)} elapsed.`);\n }\n\n // /stoptimer\n if (pathname.endsWith(\"/stoptimer\") || pathname.endsWith(\"/stop\")) {\n const timer = await fetchForOwner(nbUser);\n if (!timer || timer.started_at == null || timer.stopped_at != null) {\n return send(\"ℹ️ No running timer.\");\n }\n const stoppedAt = Date.now();\n const elapsedMs = Math.max(0, stoppedAt - Number(timer.started_at));\n await sqlite.execute({\n sql: `\n update ${TABLE}\n set stopped_at = :stopped\n where owner_provider = :p and owner_provider_id = :pid\n `,\n args: { p: nbUser.provider, pid: nbUser.providerId, stopped: stoppedAt },\n });\n return send(`✅ Stopped \"${timer.name}\" — ${toHuman(elapsedMs)}.`);\n }\n\n return send(\"Use /starttimer?name=, /checktimer, /stoptimer.\");\n}","createdAt",["D",1758118855619],"branchVersion","branchId","91f98a50-93c8-11f0-86e4-0224a6c84d84","id","91f93ce4-93c8-11f0-86e4-0224a6c84d84","nightbottimer",["D",1758115010022],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","8bac9f19-651a-4226-98b8-cf690aa2c133","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","51e27285-a236-462c-a9d5-6ed7c4c6ba74","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},"branch",{"_13":14,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jayden","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yb2JUZjdiM3hsV1d2Z0VkbFZkbHkwNlFtZGcifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":148,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":149,"_79":150,"_81":151,"_83":25},"tree",[143],"files",[143],"counts",{"_132":61,"_133":134,"_135":61,"_136":137,"_138":139},"contents",[124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":57,"_38":128,"_13":129,"_33":34,"_35":37,"_24":25,"_130":45,"_27":131},"8622fc08-93d1-11f0-87f5-0224a6c84d84","parentId","latest",["D",1758118855619],6,"label",[28],"pulls","branches",1,"forks","envVars",{"_140":61,"_142":61},"connections",{"_140":61,"_141":61},"count","unfilledCount","emptyCount",{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":57,"_38":144,"_13":129,"_33":34,"_35":37,"_24":25,"_130":45,"_145":146,"_27":147},["D",1758118855619],"children",[],[28],["D",1758115010022],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},{"_13":14,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_77":-5,"_121":185,"_186":187,"_188":189,"_190":25,"_191":25,"_192":25,"_193":57,"_194":-5,"_195":-7,"_196":-7,"_197":61,"_198":25,"_199":25,"_200":-5,"_201":25,"_202":25,"_203":25,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":84,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"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 · v7