[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_207":208,"_209":210},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_146":-5,"_20":147,"_22":148,"_149":150,"_151":152,"_25":153,"_24":-5,"_154":-5,"_155":-5,"_156":55,"_157":158,"_159":46,"_160":-5,"_161":-5,"_162":163},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","gexcysanchez","name","sunprot-modules-db","branchName","main","version","path","","project",{"_35":88,"_13":14,"_47":89,"_90":-5,"_91":55,"_92":93,"_94":93,"_95":-5,"_96":-5,"_97":98,"_99":-5,"_100":55,"_101":-5,"_102":-5,"_103":104,"_105":106,"_107":108,"_109":110,"_111":112,"_113":-5,"_114":115,"_116":115,"_117":118,"_119":118,"_120":118,"_121":115,"_122":115,"_123":124,"_125":126,"_127":128,"_129":55},"tree",[75,76,77],"file","contents",[32,33,34],"upstream","pull","ahead","behind","envVars",{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":71,"_17":72,"_50":64,"_52":73,"_54":55,"_56":-5,"_18":74},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":62,"_17":63,"_50":64,"_52":65,"_54":55,"_56":-5,"_18":66},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","97286004-a044-4728-b146-38c1b8b91ba6","main.ts","fileId","f4962492-7b22-11f1-b1b8-1607ee4eb77e","parentId","branchId","f6270933-d28e-4442-aed6-55a0986596aa","branchVersion",63,"latest",true,"createdAt",["D",1787492113992],40,"fileType","http","content","import * as bcrypt from \"https://deno.land/x/bcrypt/mod.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst MAX_ATTEMPTS = 5;\nconst WINDOW_MS = 15 * 60 * 1000;\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS login_attempts (\n username TEXT PRIMARY KEY,\n attempts INTEGER DEFAULT 0,\n window_start INTEGER DEFAULT 0,\n lock_until INTEGER DEFAULT 0\n )\n`);\n\nconst CORS = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, PUT, DELETE, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n};\n\nfunction res(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { ...CORS, \"Content-Type\": \"application/json\" },\n });\n}\n\nconst DB = () => Deno.env.get(\"DB_URL\");\nconst SEC = () => Deno.env.get(\"FB_SECRET\");\n\nasync function fbGet(path: string) {\n const r = await fetch(`${DB()}/${path}.json?auth=${SEC()}`);\n if (!r.ok) throw new Error(\"db \" + r.status);\n return r.json();\n}\n\nasync function fbSet(path: string, data: unknown) {\n const r = await fetch(`${DB()}/${path}.json?auth=${SEC()}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(data),\n });\n if (!r.ok) throw new Error(\"db \" + r.status);\n return r.json();\n}\n\nasync function fbIncrement(path: string, amount = 1) {\n const r = await fetch(`${DB()}/${path}.json?auth=${SEC()}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ \".sv\": { \"increment\": amount } }),\n });\n if (!r.ok) throw new Error(\"db \" + r.status);\n return r.json();\n}\n\nasync function fbDelete(path: string) {\n const r = await fetch(`${DB()}/${path}.json?auth=${SEC()}`, {\n method: \"DELETE\",\n });\n if (!r.ok) throw new Error(\"db \" + r.status);\n return r.json();\n}\n\nasync function rlCheck(username: string): Promise {\n const now = Date.now();\n const r = await sqlite.execute({\n sql: \"SELECT lock_until FROM login_attempts WHERE username = ?\",\n args: [username],\n });\n if (r.rows.length) {\n const lu = Number(r.rows[0][0]) || 0;\n if (lu > now) {\n const waitMin = Math.ceil((lu - now) / 60000);\n return `Too many failed attempts. Try again in ${waitMin} minute${waitMin !== 1 ? \"s\" : \"\"}.`;\n }\n }\n return null;\n}\n\nasync function rlFail(username: string): Promise<{ remaining: number; locked: boolean }> {\n const now = Date.now();\n const r = await sqlite.execute({\n sql: \"SELECT attempts, window_start, lock_until FROM login_attempts WHERE username = ?\",\n args: [username],\n });\n\n let current = 0;\n let windowStart = now;\n const exists = r.rows.length > 0;\n\n if (exists) {\n const att = Number(r.rows[0][0]) || 0;\n const ws = Number(r.rows[0][1]) || 0;\n const lu = Number(r.rows[0][2]) || 0;\n if (lu > now) return { remaining: 0, locked: true };\n if (now - ws <= WINDOW_MS) {\n current = att;\n windowStart = ws;\n }\n }\n\n const next = current + 1;\n const lockUntil = next >= MAX_ATTEMPTS ? now + WINDOW_MS : 0;\n\n if (exists) {\n await sqlite.execute({\n sql: \"UPDATE login_attempts SET attempts = ?, window_start = ?, lock_until = ? WHERE username = ?\",\n args: [next, windowStart, lockUntil, username],\n });\n } else {\n await sqlite.execute({\n sql: \"INSERT INTO login_attempts (username, attempts, window_start, lock_until) VALUES (?, ?, ?, ?)\",\n args: [username, next, windowStart, lockUntil],\n });\n }\n\n return { remaining: Math.max(0, MAX_ATTEMPTS - next), locked: next >= MAX_ATTEMPTS };\n}\n\nasync function rlClear(username: string): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM login_attempts WHERE username = ?\",\n args: [username],\n });\n}\n\nfunction genToken() {\n const b = crypto.getRandomValues(new Uint8Array(24));\n return [...b].map((x) => x.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nasync function verifySession(tok: string) {\n if (!tok) return null;\n const session = await fbGet(`sessions/${tok}`);\n if (!session || !session.username) return null;\n const user = await fbGet(`users/${session.username}`);\n if (!user) return null;\n return { username: session.username, ...user };\n}\n\nasync function findExistingSession(usernameKey: string): Promise {\n const allSessions = (await fbGet(\"sessions\")) || {};\n const now = Date.now();\n const MAX_AGE = 14 * 24 * 60 * 60 * 1000;\n for (const [tok, sess] of Object.entries(allSessions as Record)) {\n if (sess && sess.username === usernameKey && sess.createdAt && now - sess.createdAt < MAX_AGE) return tok;\n }\n return null;\n}\n\nasync function cleanOldUserSessions(usernameKey: string) {\n try {\n const allSessions = (await fbGet(\"sessions\")) || {};\n const now = Date.now();\n const MAX_AGE = 14 * 24 * 60 * 60 * 1000;\n for (const [tok, sess] of Object.entries(allSessions as Record)) {\n if (sess && sess.username === usernameKey) {\n if (!sess.createdAt || (now - (sess.createdAt || 0)) > MAX_AGE) {\n await fbDelete(`sessions/${tok}`);\n }\n }\n }\n } catch (_) {}\n}\n\nasync function verifyPassword(plain: string, stored: string): Promise {\n if (stored.startsWith(\"$2\")) return await bcrypt.compare(plain, stored);\n return plain === stored;\n}\n\nfunction isValidUrl(str: string) {\n try {\n const u = new URL(str);\n return u.protocol === \"http:\" || u.protocol === \"https:\";\n } catch {\n return false;\n }\n}\n\nfunction cleanModuleNameForAlias(rawName: string): string {\n const normalized = rawName.normalize(\"NFD\").replace(/[\\u0300-\\u036f]/g, \"\");\n const asciiConverted = [...normalized].map((char) => {\n const code = char.codePointAt(0) || 0;\n if (code >= 0x1d400 && code <= 0x1d7ff) {\n if (code >= 0x1d400 && code <= 0x1d419) return String.fromCharCode(65 + (code - 0x1d400));\n if (code >= 0x1d41a && code <= 0x1d433) return String.fromCharCode(97 + (code - 0x1d41a));\n if (code >= 0x1d434 && code <= 0x1d44d) return String.fromCharCode(65 + (code - 0x1d434));\n if (code >= 0x1d44e && code <= 0x1d467) return String.fromCharCode(97 + (code - 0x1d44e));\n if (code >= 0x1d468 && code <= 0x1d481) return String.fromCharCode(65 + (code - 0x1d468));\n if (code >= 0x1d482 && code <= 0x1d49b) return String.fromCharCode(97 + (code - 0x1d482));\n if (code >= 0x1d7ce && code <= 0x1d7d7) return String.fromCharCode(48 + (code - 0x1d7ce));\n if (code >= 0x1d7d8 && code <= 0x1d7e1) return String.fromCharCode(48 + (code - 0x1d7d8));\n }\n return char;\n }).join(\"\");\n const cleanText = asciiConverted.replace(/[^a-zA-Z0-9]/g, \"\");\n return cleanText || \"Module\";\n}\n\nasync function generateShortlink(originalUrl: string, rawName: string, updateCount: number): Promise {\n try {\n const cleanName = cleanModuleNameForAlias(rawName);\n const slug = updateCount === 0 ? `Mod-${cleanName}` : `Mod-${cleanName}-v${updateCount}`;\n const proxyApi = `https://gexcysanchez--52fe6c529a7b11f194ec1607ee4eb77e.web.val.run?url=${encodeURIComponent(originalUrl)}&alias=${encodeURIComponent(slug)}`;\n const r = await fetch(proxyApi);\n if (r.ok) {\n const d = await r.json();\n if (d.shortLink) return d.shortLink;\n }\n } catch {}\n return \"\";\n}\n\nexport default async function (req: Request) {\n if (req.method === \"OPTIONS\") return new Response(null, { headers: CORS });\n\n const url = new URL(req.url);\n const segs = url.pathname.replace(/^\\/+/, \"\").split(\"/\").filter(Boolean);\n const m = req.method;\n\n try {\n if (m === \"POST\" && segs[0] === \"register\") {\n const { username, password } = await req.json();\n if (!username || !password) return res({ error: \"Missing fields\" }, 400);\n if (/\\s/.test(username)) return res({ error: \"Username cannot contain spaces\" }, 400);\n if (username.length < 3) return res({ error: \"Username must be at least 3 characters\" }, 400);\n if (password.length < 8) return res({ error: \"Password must be at least 8 characters\" }, 400);\n\n const key = username.toLowerCase().trim();\n const existing = await fbGet(`users/${key}`);\n if (existing) return res({ error: \"Username already taken\" }, 409);\n\n const hashedPassword = await bcrypt.hash(password);\n const userData = {\n username: key,\n displayName: username,\n password: hashedPassword,\n image: \"\",\n bio: \"\",\n status: null,\n createdAt: Date.now(),\n };\n await fbSet(`users/${key}`, userData);\n await cleanOldUserSessions(key);\n const existingTok = await findExistingSession(key);\n const tok = existingTok ?? genToken();\n if (!existingTok) await fbSet(`sessions/${tok}`, { username: key, createdAt: Date.now() });\n return res({ username: key, displayName: username, image: \"\", bio: \"\", status: null, sessionToken: tok });\n }\n\n if (m === \"POST\" && segs[0] === \"login\") {\n const { username, password } = await req.json();\n if (!username || !password) return res({ error: \"Missing fields\" }, 400);\n const key = username.toLowerCase().trim();\n\n const limitMsg = await rlCheck(key);\n if (limitMsg) return res({ error: limitMsg }, 429);\n\n const user = await fbGet(`users/${key}`);\n const passwordValid = user ? await verifyPassword(password, user.password) : false;\n\n if (!user || !passwordValid) {\n const { remaining } = await rlFail(key);\n return res({\n error: `Incorrect username or password.${remaining > 0 ? ` ${remaining} attempt${remaining !== 1 ? \"s\" : \"\"} remaining.` : \"\"}`,\n }, 401);\n }\n\n if (user.password && !user.password.startsWith(\"$2\")) {\n const rehashed = await bcrypt.hash(password);\n await fbSet(`users/${key}`, { ...user, password: rehashed });\n }\n\n await rlClear(key);\n await cleanOldUserSessions(key);\n const existingTok = await findExistingSession(key);\n const tok = existingTok ?? genToken();\n if (!existingTok) await fbSet(`sessions/${tok}`, { username: key, createdAt: Date.now() });\n return res({\n username: key,\n displayName: user.displayName || key,\n image: user.image || \"\",\n bio: user.bio || \"\",\n status: user.status || null,\n sessionToken: tok,\n });\n }\n\n if (m === \"POST\" && segs[0] === \"logout\") {\n const { sessionToken } = await req.json();\n if (sessionToken) await fbDelete(`sessions/${sessionToken}`);\n return res({ ok: true });\n }\n\n if (m === \"POST\" && segs[0] === \"restore\") {\n const { sessionToken } = await req.json();\n const user = await verifySession(sessionToken);\n if (!user) return res({ error: \"Invalid session\" }, 401);\n await fbSet(`sessions/${sessionToken}`, { username: user.username, createdAt: Date.now() });\n return res({\n username: user.username,\n displayName: user.displayName || user.username,\n image: user.image || \"\",\n bio: user.bio || \"\",\n status: user.status || null,\n });\n }\n\n if (m === \"GET\" && segs[0] === \"profile\" && segs[1]) {\n const targetUser = segs[1].toLowerCase().trim();\n const user = await fbGet(`users/${targetUser}`);\n if (!user) return res({ error: \"User not found\" }, 404);\n return res({ username: user.username, displayName: user.displayName || user.username, image: user.image || \"\", bio: user.bio || \"\" });\n }\n\n if (m === \"POST\" && segs[0] === \"profile\" && segs[1] === \"update\") {\n const body = await req.json();\n const { sessionToken, bio, currentPassword, newPassword, image, newUsername, newDisplayName } = body;\n const user = await verifySession(sessionToken);\n if (!user) return res({ error: \"Unauthorized\" }, 401);\n\n if (newPassword) {\n if (!currentPassword) return res({ error: \"Current password is incorrect\" }, 400);\n const currentValid = await verifyPassword(currentPassword, user.password);\n if (!currentValid) return res({ error: \"Current password is incorrect\" }, 400);\n if (newPassword.length < 8) return res({ error: \"Password must be at least 8 characters\" }, 400);\n }\n\n if (newUsername) {\n const newKey = newUsername.toLowerCase().trim();\n if (/\\s/.test(newUsername)) return res({ error: \"Username cannot contain spaces\" }, 400);\n if (newUsername.length < 3) return res({ error: \"Username must be at least 3 characters\" }, 400);\n if (newKey !== user.username) {\n const taken = await fbGet(`users/${newKey}`);\n if (taken) return res({ error: \"Username already taken\" }, 409);\n\n const oldKey = user.username;\n const resolvedDisplayName = newDisplayName ? newDisplayName.trim().slice(0, 40) : (user.displayName || newKey);\n const hashedPassword = newPassword ? await bcrypt.hash(newPassword) : user.password;\n const updated = {\n username: newKey,\n displayName: resolvedDisplayName,\n password: hashedPassword,\n image: image !== undefined ? image : user.image,\n bio: bio !== undefined ? bio.trim().slice(0, 150) : user.bio,\n status: user.status || null,\n createdAt: user.createdAt,\n };\n await fbSet(`users/${newKey}`, updated);\n await fbDelete(`users/${oldKey}`);\n await rlClear(oldKey);\n\n const allSessions = (await fbGet(\"sessions\")) || {};\n for (const [tok, sess] of Object.entries(allSessions as Record)) {\n if (sess && sess.username === oldKey) await fbSet(`sessions/${tok}`, { ...sess, username: newKey });\n }\n\n const allMods = (await fbGet(\"modules\")) || {};\n for (const [mKey, mVal] of Object.entries(allMods as Record>)) {\n if (mVal && (mVal.owner === oldKey || mVal.creator === oldKey)) {\n await fbSet(`modules/${mKey}`, {\n ...mVal,\n owner: mVal.owner === oldKey ? newKey : mVal.owner,\n creator: mVal.creator === oldKey ? newKey : mVal.creator,\n });\n }\n }\n\n return res({ ok: true, username: newKey, displayName: updated.displayName, bio: updated.bio, image: updated.image });\n }\n }\n\n const resolvedDisplayName = newDisplayName ? newDisplayName.trim().slice(0, 40) : (user.displayName || user.username);\n const hashedPassword = newPassword ? await bcrypt.hash(newPassword) : user.password;\n const updated = {\n ...user,\n displayName: resolvedDisplayName,\n bio: bio !== undefined ? bio.trim().slice(0, 150) : user.bio,\n password: hashedPassword,\n image: image !== undefined ? image : user.image,\n };\n await fbSet(`users/${user.username}`, updated);\n return res({ ok: true, username: user.username, displayName: updated.displayName, bio: updated.bio, image: updated.image });\n }\n\n if (m === \"POST\" && segs[0] === \"profile\" && segs[1] === \"delete\") {\n const { sessionToken, confirmPhrase } = await req.json();\n const user = await verifySession(sessionToken);\n if (!user) return res({ error: \"Unauthorized\" }, 401);\n\n const expectedPhrase = `delete/${user.username}`;\n if (!confirmPhrase || confirmPhrase.trim() !== expectedPhrase) return res({ error: \"Confirmation phrase does not match\" }, 400);\n\n const allMods = (await fbGet(\"modules\")) || {};\n for (const [mKey, mVal] of Object.entries(allMods as Record>)) {\n if (mVal && mVal.owner === user.username) await fbDelete(`modules/${mKey}`);\n }\n\n await fbDelete(`comments/${user.username}`);\n await fbDelete(`users/${user.username}`);\n await rlClear(user.username);\n if (sessionToken) await fbDelete(`sessions/${sessionToken}`);\n return res({ ok: true });\n }\n\n if (m === \"GET\" && segs[0] === \"modules\") {\n const rawMods = (await fbGet(\"modules\")) || {};\n const rawComments = (await fbGet(\"comments\")) || {};\n\n const modules: Record = {};\n for (const [key, mod] of Object.entries(rawMods as Record>)) {\n const modCommentsObj = (rawComments as Record>)[key] || {};\n const commentsList = Object.values(modCommentsObj).sort(\n (a, b) => ((a as { createdAt: number }).createdAt || 0) - ((b as { createdAt: number }).createdAt || 0),\n );\n modules[key] = { ...mod, comments: commentsList };\n }\n return res({ modules });\n }\n\n if (m === \"PUT\" && segs[0] === \"modules\" && segs[1]) {\n const key = segs[1];\n const { sessionToken, ...moduleData } = await req.json();\n const user = await verifySession(sessionToken);\n if (!user) return res({ error: \"Unauthorized\" }, 401);\n\n const userLink = String(moduleData.link || \"\").trim();\n if (!userLink || !isValidUrl(userLink)) return res({ error: \"A valid HTTP/HTTPS download link is required.\" }, 400);\n\n const existing = (await fbGet(`modules/${key}`)) as Record | null;\n if (existing && existing.owner && existing.owner !== user.username && user.status !== \"admin\") {\n return res({ error: \"Module belongs to another creator.\" }, 403);\n }\n\n let shortLink = existing ? (existing.shortLink as string || \"\") : \"\";\n let updateCount = (existing && typeof existing.updateCount === \"number\") ? existing.updateCount : 0;\n let linkChanged = false;\n\n const existingLink = String(existing?.link || \"\").trim();\n const linkUnchanged = Boolean(existing && existingLink !== \"\" && existingLink === userLink && existing.shortLink);\n\n if (!linkUnchanged) {\n linkChanged = true;\n if (existing) updateCount += 1;\n shortLink = await generateShortlink(userLink, moduleData.name, updateCount);\n }\n\n const originalCreator = existing ? (existing.creator as string) : (moduleData.creator || user.displayName || user.username);\n const resolvedImage = (moduleData.image && typeof moduleData.image === \"string\" && moduleData.image.trim() !== \"\")\n ? moduleData.image.trim()\n : (existing ? (existing.image as string || \"\") : \"\");\n\n const record: Record = {\n name: moduleData.name,\n version: moduleData.version,\n creator: originalCreator,\n description: moduleData.description,\n link: userLink,\n shortLink,\n updateCount,\n image: resolvedImage,\n downloads: existing ? (existing.downloads || 0) : 0,\n reviews: existing ? (existing.reviews || {}) : {},\n owner: existing ? existing.owner : user.username,\n createdAt: existing ? (existing.createdAt || Date.now()) : Date.now(),\n };\n\n if (linkChanged) {\n record.updatedAt = Date.now();\n } else if (existing && existing.updatedAt) {\n record.updatedAt = existing.updatedAt;\n }\n\n await fbSet(`modules/${key}`, record);\n return res({ ok: true, module: record });\n }\n\n if (m === \"DELETE\" && segs[0] === \"modules\" && segs[1]) {\n const key = segs[1];\n const { sessionToken } = await req.json();\n const user = await verifySession(sessionToken);\n if (!user) return res({ error: \"Unauthorized\" }, 401);\n const mod = (await fbGet(`modules/${key}`)) as Record | null;\n if (!mod) return res({ error: \"Not found\" }, 404);\n if (mod.owner !== user.username && user.status !== \"admin\") return res({ error: \"Forbidden\" }, 403);\n await fbDelete(`modules/${key}`);\n await fbDelete(`comments/${key}`);\n return res({ ok: true });\n }\n\n if (m === \"POST\" && segs[0] === \"modules\" && segs[1] && segs[2] === \"download\") {\n const key = segs[1];\n const mod = (await fbGet(`modules/${key}`)) as Record | null;\n if (!mod) return res({ error: \"Not found\" }, 404);\n const newCount = await fbIncrement(`modules/${key}/downloads`, 1);\n const downloadUrl = (mod.shortLink && typeof mod.shortLink === \"string\" && mod.shortLink.trim() !== \"\")\n ? mod.shortLink\n : (mod.link as string);\n return res({ ok: true, downloads: newCount, url: downloadUrl });\n }\n\n if (m === \"POST\" && segs[0] === \"modules\" && segs[1] && segs[2] === \"review\") {\n const key = segs[1];\n const { sessionToken, rating } = await req.json();\n const user = await verifySession(sessionToken);\n if (!user) return res({ error: \"Unauthorized\" }, 401);\n if (!rating || rating < 1 || rating > 5) return res({ error: \"Invalid rating\" }, 400);\n await fbSet(`modules/${key}/reviews/${user.username}`, { rating: Number(rating), updatedAt: Date.now() });\n return res({ ok: true });\n }\n\n if (m === \"POST\" && segs[0] === \"modules\" && segs[1] && segs[2] === \"comment\") {\n const key = segs[1];\n const { sessionToken, text, replyTo, parentId } = await req.json();\n const user = await verifySession(sessionToken);\n if (!user) return res({ error: \"Unauthorized\" }, 401);\n if (!text || !text.trim()) return res({ error: \"Empty comment\" }, 400);\n\n const commentId = genToken();\n const newComment: Record = {\n id: commentId,\n moduleKey: key,\n username: user.username,\n displayName: user.displayName || user.username,\n userImage: user.image || \"\",\n text: text.trim(),\n createdAt: Date.now(),\n };\n if (replyTo && typeof replyTo === \"string\" && replyTo.trim()) newComment.replyTo = replyTo.trim();\n if (parentId && typeof parentId === \"string\" && parentId.trim()) newComment.parentId = parentId.trim();\n await fbSet(`comments/${key}/${commentId}`, newComment);\n return res({ ok: true, comment: newComment });\n }\n\n return res({ error: \"Route not found\" }, 404);\n } catch (e) {\n return res({ error: (e as Error).message }, 500);\n }\n}","deleted",false,"label",[37],"1991f12a-bc48-4557-b1e4-9a114a04e4aa","cleanup.ts","8f0c68da-9e9e-11f1-b1dc-1607ee4eb77e",64,["D",1787492145382],5,"interval","const DB = () => Deno.env.get(\"DB_URL\");\nconst SEC = () => Deno.env.get(\"FB_SECRET\");\nconst SESSION_MAX_AGE = 14 * 24 * 60 * 60 * 1000;\n\nasync function fbGet(path: string) {\n const r = await fetch(`${DB()}/${path}.json?auth=${SEC()}`);\n if (!r.ok) throw new Error(\"db \" + r.status);\n return r.json();\n}\n\nasync function fbDelete(path: string) {\n const r = await fetch(`${DB()}/${path}.json?auth=${SEC()}`, {\n method: \"DELETE\",\n });\n if (!r.ok) throw new Error(\"db \" + r.status);\n return r.json();\n}\n\nexport default async function (_req: Request): Promise {\n const [allUsers, allModules, allComments, allSessions] = await Promise.all([\n fbGet(\"users\"),\n fbGet(\"modules\"),\n fbGet(\"comments\"),\n fbGet(\"sessions\"),\n ]);\n\n if (!allUsers || typeof allUsers !== \"object\") {\n return new Response(null, { status: 204 });\n }\n\n const modules = (allModules || {}) as Record>;\n const comments = (allComments || {}) as Record<\n string,\n Record\n >;\n const sessions = (allSessions || {}) as Record<\n string,\n { username: string; createdAt: number }\n >;\n\n const usersWithActivity = new Set();\n const now = Date.now();\n\n for (const mod of Object.values(modules)) {\n if (mod.owner) {\n usersWithActivity.add(String(mod.owner).toLowerCase().trim());\n }\n if (mod.creator) {\n usersWithActivity.add(String(mod.creator).toLowerCase().trim());\n }\n\n const reviews = (mod.reviews || {}) as Record;\n for (const reviewer of Object.keys(reviews)) {\n usersWithActivity.add(reviewer.toLowerCase().trim());\n }\n }\n\n for (const modComments of Object.values(comments)) {\n for (\n const comment of Object.values(\n modComments as Record>,\n )\n ) {\n if (comment.username) {\n usersWithActivity.add(String(comment.username).toLowerCase().trim());\n }\n }\n }\n\n const sessionsByUser: Record = {};\n for (const [tok, sess] of Object.entries(sessions)) {\n if (!sess || !sess.username) continue;\n const u = sess.username.toLowerCase().trim();\n const isActive = sess.createdAt && (now - sess.createdAt) < SESSION_MAX_AGE;\n if (isActive) usersWithActivity.add(u);\n if (!sessionsByUser[u]) sessionsByUser[u] = [];\n sessionsByUser[u].push(tok);\n }\n\n for (const username of Object.keys(allUsers as Record)) {\n const key = username.toLowerCase().trim();\n if (usersWithActivity.has(key)) continue;\n\n await fbDelete(`users/${key}`);\n\n if (sessionsByUser[key]) {\n for (const tok of sessionsByUser[key]) {\n await fbDelete(`sessions/${tok}`);\n }\n }\n }\n\n return new Response(null, { status: 204 });\n}",[59],"ed86e182-53f6-4442-bb9b-eaf9ce2b9b2f","clean.ts","8d121dfa-aa7d-11f1-b063-1607ee4eb77e",72,["D",1789109008680],3,"const DB = () => Deno.env.get(\"DB_URL\");\nconst SEC = () => Deno.env.get(\"FB_SECRET\");\nconst CF_ACCOUNT_ID = () => Deno.env.get(\"CF_ACCOUNT_ID\");\nconst CF_KV_NAMESPACE_ID = () => Deno.env.get(\"CF_KV_NAMESPACE_ID\");\nconst CF_API_TOKEN = () => Deno.env.get(\"CF_API_TOKEN\");\nconst SESSION_MAX_AGE = 14 * 24 * 60 * 60 * 1000;\nconst ACCOUNT_MAX_AGE = 14 * 24 * 60 * 60 * 1000;\n\nasync function fbGet(path: string) {\n const r = await fetch(`${DB()}/${path}.json?auth=${SEC()}`);\n if (!r.ok) throw new Error(\"db \" + r.status);\n return r.json();\n}\n\nasync function fbDelete(path: string) {\n const r = await fetch(`${DB()}/${path}.json?auth=${SEC()}`, {\n method: \"DELETE\",\n });\n if (!r.ok) throw new Error(\"db \" + r.status);\n return r.json();\n}\n\nasync function kvList(prefix: string): Promise {\n const keys: string[] = [];\n let cursor: string | null = null;\n\n do {\n const params = new URLSearchParams({ prefix, limit: \"1000\" });\n if (cursor) params.set(\"cursor\", cursor);\n const r = await fetch(\n `https://api.cloudflare.com/client/v4/accounts/${CF_ACCOUNT_ID()}/storage/kv/namespaces/${CF_KV_NAMESPACE_ID()}/keys?${params}`,\n { headers: { Authorization: `Bearer ${CF_API_TOKEN()}` } },\n );\n if (!r.ok) throw new Error(\"kv list \" + r.status);\n const data = await r.json();\n for (const k of data.result ?? []) keys.push(k.name);\n cursor = data.result_info?.cursor ?? null;\n } while (cursor);\n\n return keys;\n}\n\nasync function kvGet(key: string): Promise {\n const r = await fetch(\n `https://api.cloudflare.com/client/v4/accounts/${CF_ACCOUNT_ID()}/storage/kv/namespaces/${CF_KV_NAMESPACE_ID()}/values/${\n encodeURIComponent(key)\n }`,\n { headers: { Authorization: `Bearer ${CF_API_TOKEN()}` } },\n );\n if (r.status === 404) return null;\n if (!r.ok) throw new Error(\"kv get \" + r.status);\n try {\n return await r.json();\n } catch {\n return null;\n }\n}\n\nasync function kvDelete(key: string): Promise {\n const r = await fetch(\n `https://api.cloudflare.com/client/v4/accounts/${CF_ACCOUNT_ID()}/storage/kv/namespaces/${CF_KV_NAMESPACE_ID()}/values/${\n encodeURIComponent(key)\n }`,\n {\n method: \"DELETE\",\n headers: { Authorization: `Bearer ${CF_API_TOKEN()}` },\n },\n );\n if (!r.ok && r.status !== 404) throw new Error(\"kv delete \" + r.status);\n}\n\nexport default async function (_req: Request): Promise {\n const [allUsers, allModules, allComments] = await Promise.all([\n fbGet(\"users\"),\n fbGet(\"modules\"),\n fbGet(\"comments\"),\n ]);\n\n if (!allUsers || typeof allUsers !== \"object\") {\n return new Response(null, { status: 204 });\n }\n\n const modules = (allModules || {}) as Record>;\n const comments = (allComments || {}) as Record<\n string,\n Record\n >;\n\n const usersWithActivity = new Set();\n const now = Date.now();\n\n for (const mod of Object.values(modules)) {\n if (mod.owner) {\n usersWithActivity.add(String(mod.owner).toLowerCase().trim());\n }\n if (mod.creator) {\n usersWithActivity.add(String(mod.creator).toLowerCase().trim());\n }\n const reviews = (mod.reviews || {}) as Record;\n for (const reviewer of Object.keys(reviews)) {\n usersWithActivity.add(reviewer.toLowerCase().trim());\n }\n }\n\n for (const modComments of Object.values(comments)) {\n for (\n const comment of Object.values(\n modComments as Record>,\n )\n ) {\n if (comment.username) {\n usersWithActivity.add(String(comment.username).toLowerCase().trim());\n }\n }\n }\n\n const userSessionKeys = await kvList(\"user_session:\");\n const sessionsByUser: Record = {};\n\n for (const kvKey of userSessionKeys) {\n const username = kvKey.replace(\"user_session:\", \"\");\n const data = await kvGet(kvKey) as\n | { token: string; createdAt: number }\n | null;\n if (!data || !data.token || !data.createdAt) continue;\n const isActive = (now - data.createdAt) < SESSION_MAX_AGE;\n if (isActive) usersWithActivity.add(username);\n sessionsByUser[username] = data.token;\n }\n\n for (\n const [username, user] of Object.entries(\n allUsers as Record>,\n )\n ) {\n const key = username.toLowerCase().trim();\n if (usersWithActivity.has(key)) continue;\n\n const createdAt = typeof user.createdAt === \"number\" ? user.createdAt : 0;\n if (createdAt && (now - createdAt) < ACCOUNT_MAX_AGE) continue;\n\n await fbDelete(`users/${key}`);\n\n if (sessionsByUser[key]) {\n await kvDelete(`session:${sessionsByUser[key]}`);\n await kvDelete(`user_session:${key}`);\n }\n }\n\n return new Response(null, { status: 204 });\n}",[68],{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":85,"_17":72,"_50":64,"_52":73,"_54":55,"_56":-5,"_79":86,"_18":87},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":82,"_17":63,"_50":64,"_52":65,"_54":55,"_56":-5,"_79":83,"_18":84},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":78,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_79":80,"_18":81},["D",1787492113992],"children",[],[37],["D",1787492145382],[],[59],["D",1789109008680],[],[68],"aad57c4b-6371-4ffe-890b-2f787b7c8e35",["D",1783552548469],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","35b1a91c-8fcc-4040-bc0f-e1cb277a7282","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e1d1b-adbb-76f7-a82a-b4232abb1bd1","tursoName","aad57c4b63714ffe890b2f787b7c8e35","tursoHostname","aad57c4b63714ffe890b2f787b7c8e35-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789472446807],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_145":141},"org",{"_11":12,"_138":139,"_140":141,"_97":98,"_142":143,"_144":55},"branch",{"_17":70,"_13":16,"_35":42,"_130":88,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":-5,"_136":14,"_137":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Gexcy Sanchez","avatar","https://lh3.googleusercontent.com/a/ACg8ocJD6WSSYPd2CVI2O3PHd4vtUwhkw7rC8Zf4-yjll4kHtQqmbYs=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":88,"_13":14,"_47":202,"_90":-5,"_91":55,"_92":93,"_94":93,"_95":-5,"_96":-5,"_97":98,"_99":-5,"_100":55,"_101":-5,"_102":-5,"_103":104,"_105":106,"_107":108,"_109":110,"_111":203,"_113":-5,"_114":115,"_116":115,"_117":118,"_119":118,"_120":118,"_121":115,"_122":115,"_123":204,"_125":205,"_127":206,"_129":55},[193,194,195],"files",[193,194,195],"counts",{"_183":104,"_184":185,"_186":104,"_31":187,"_188":189},[177,178,179],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[164,165,166,167,168,169],"hasHttpFiles","grants","orgs","customDomains",{},{"_35":176,"_171":-5},{"_35":175,"_171":-5},{"_35":174,"_171":-5},{"_35":173,"_171":-5},{"_35":172,"_171":-5},{"_35":170,"_171":-5},"f6198fde-1c3e-4215-8ddd-dbbf73b10801","reporterId","21fc4546-d1ae-402e-b785-a8a7259bde71","2ca95eb7-7f7a-457c-9b14-50b4bbd59445","a65081d1-7e8f-43ac-a8c4-f2f9d3cfe65b","b01b4481-5be5-411c-9f2f-996fca66a25a","66bd0826-888d-427f-9bf3-a8ef9e4dce36",{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":71,"_17":72,"_50":64,"_52":73,"_54":55,"_56":-5,"_18":182},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":62,"_17":63,"_50":64,"_52":65,"_54":55,"_56":-5,"_18":181},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":180},[37],[59],[68],"pulls","branches",1,"forks",{"_190":63,"_192":104},"connections",{"_190":104,"_191":104},"count","unfilledCount","emptyCount",{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":85,"_17":72,"_50":64,"_52":73,"_54":55,"_56":-5,"_79":200,"_18":201},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":82,"_17":63,"_50":64,"_52":65,"_54":55,"_56":-5,"_79":198,"_18":199},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":78,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_79":196,"_18":197},[],[37],[],[59],[],[68],["D",1783552548469],["D",1789472446807],{"_11":12,"_145":141},{"_11":12,"_138":139,"_140":141,"_97":98,"_142":143,"_144":55},{"_17":70,"_13":16,"_35":42,"_130":88,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":-5,"_136":14,"_137":12},"ctx",{"_123":-5,"_161":240,"_241":242,"_243":244,"_245":55,"_246":55,"_247":55,"_248":46,"_249":-5,"_250":-7,"_251":-7,"_252":104,"_253":55,"_254":55,"_255":-5,"_256":55,"_257":55,"_258":55,"_259":-5},"ENV",{"_211":212,"_213":214,"_215":16,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239},"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"]