[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_175":176,"_177":178},"routes/_app.x.$handle.$name",{"_104":103,"_37":49,"_113":94,"_32":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":30,"_128":129,"_130":30,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":30},"version",2,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","32a6b9f5-b532-4408-98c3-90c042c6e00c","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","crypto.ts","latestPath","fileId","906bcb4e-b2ad-11f1-a642-1607ee4eb77e","name","fileType","script","content","/**\n * Cifrado de tokens de Discord (AES-256-GCM) + utilidades de hash/aleatoriedad.\n *\n * Los tokens NUNCA se guardan en texto plano ni se escriben en logs: solo se\n * almacena el criptograma `v1..` en la columna `token_enc`.\n *\n * La clave se deriva de la env var ENCRYPTION_KEY (recomendado: 32+ caracteres\n * aleatorios). Si no está definida se usa una clave por defecto INSEGURA para\n * que la app funcione en pruebas — defínela antes de guardar tokens reales.\n */\n\nconst encoder = new TextEncoder();\nconst decoder = new TextDecoder();\n\nconst DEFAULT_KEY = \"botforge-dev-key-change-me\";\n\nasync function aesKey(): Promise {\n const secret = Deno.env.get(\"ENCRYPTION_KEY\") || DEFAULT_KEY;\n const digest = await crypto.subtle.digest(\"SHA-256\", encoder.encode(secret));\n return await crypto.subtle.importKey(\"raw\", digest, \"AES-GCM\", false, [\"encrypt\", \"decrypt\"]);\n}\n\nfunction toBase64(bytes: Uint8Array): string {\n let binary = \"\";\n for (const byte of bytes) binary += String.fromCharCode(byte);\n return btoa(binary);\n}\n\nfunction fromBase64(value: string): Uint8Array {\n const binary = atob(value);\n const bytes = new Uint8Array(binary.length);\n for (let i = 0; i < binary.length; i++) bytes[i] = binary.charCodeAt(i);\n return bytes;\n}\n\nexport async function encrypt(plain: string): Promise {\n const iv = crypto.getRandomValues(new Uint8Array(12));\n const cipher = await crypto.subtle.encrypt({ name: \"AES-GCM\", iv }, await aesKey(), encoder.encode(plain));\n return `v1.${toBase64(iv)}.${toBase64(new Uint8Array(cipher))}`;\n}\n\nexport async function decrypt(payload: string): Promise {\n const parts = String(payload || \"\").split(\".\");\n if (parts.length !== 3 || parts[0] !== \"v1\") throw new Error(\"Token cifrado con formato inválido\");\n const iv = fromBase64(parts[1]);\n const data = fromBase64(parts[2]);\n const plain = await crypto.subtle.decrypt({ name: \"AES-GCM\", iv }, await aesKey(), data);\n return decoder.decode(plain);\n}\n\nexport function randomToken(bytes = 32): string {\n const buf = crypto.getRandomValues(new Uint8Array(bytes));\n return Array.from(buf, (b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nexport async function sha256hex(value: string): Promise {\n const digest = await crypto.subtle.digest(\"SHA-256\", encoder.encode(value));\n return Array.from(new Uint8Array(digest), (b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\n/** Devuelve una pista del token para mostrarla en la UI (nunca el token completo). */\nexport function maskToken(token: string): string {\n const clean = String(token || \"\").trim();\n if (clean.length < 10) return \"••••\";\n return `${clean.slice(0, 5)}…${clean.slice(-4)}`;\n}","createdAt",["D",1789659394719],"branchVersion","branchId","37544b5e-d483-4a6e-a9ea-9e395772fd07","id","f897dca2-6f6c-4e1b-bb1c-d687260cd088","discord-bot-forge",["D",1789659345779],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Aloja bots de Discord con IA: dashboard, chat Groq y embeds","imageUrl","04c4c364-ec5f-41c5-b6fc-a8c10bee7499","pinnedFileId","e0cd2760-b2b0-11f1-a86f-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0afee-eeb7-70d6-a0b0-b625cf083eb5","tursoName","f897dca26f6c4e1bbb1cd687260cd088","tursoHostname","f897dca26f6c4e1bbb1cd687260cd088-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789661495919],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_112":108},"org",{"_104":103,"_105":106,"_107":108,"_19":59,"_109":110,"_111":30},"branch",{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"isOwned",58,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","rafitaaa","handle","displayName","Rafa Toro","avatar","https://lh3.googleusercontent.com/a/ACg8ocLgNOftv9O9CrbLlEgoHJjCfJGq2N0FRZ2eB4sJUvoGFzOCsg=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_37":49,"_42":170,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":171,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":172,"_88":173,"_90":174,"_92":30},"tree",[161,162],"files",[161,162],"counts",{"_150":67,"_151":141,"_152":67,"_153":154,"_155":156},"contents",[135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":147,"_37":33,"_35":36,"_140":-5,"_45":46,"_44":14,"_142":63,"_42":148,"_13":67,"_38":39,"_40":41,"_29":30,"_145":-5,"_32":149},{"_47":137,"_37":138,"_35":139,"_140":-5,"_45":46,"_44":141,"_142":30,"_42":143,"_13":67,"_38":39,"_40":144,"_29":30,"_145":-5,"_32":146},"a239a329-a855-43c2-ab95-56e4f4bd354f","db.ts","85a3fa7e-b2ad-11f1-b876-1607ee4eb77e","parentId",1,"latest",["D",1789659376629],"/**\n * Capa de datos (SQLite de Val Town).\n * Guarda: usuarios, sesiones, bots (token cifrado), historial de chat IA y plantillas de embeds.\n */\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport const MAX_BOTS_PER_USER = 25;\n\nexport type User = {\n id: number;\n email: string;\n name: string | null;\n picture: string | null;\n google_sub: string | null;\n created_at: string;\n};\n\nexport type Bot = {\n id: number;\n user_id: number;\n name: string;\n token_enc: string;\n token_hint: string | null;\n avatar: string | null;\n guild_id: string | null;\n guild_name: string | null;\n code: string;\n desired_state: string;\n status: string;\n last_error: string | null;\n created_at: string;\n updated_at: string;\n};\n\nexport type ChatMessage = {\n id: number;\n bot_id: number;\n role: string;\n content: string;\n created_at: string;\n};\n\nexport type EmbedTemplate = {\n id: number;\n bot_id: number;\n name: string;\n payload: string;\n created_at: string;\n};\n\n/** Ejecuta SQL con parámetros y devuelve las filas. */\nasync function query(strings: TemplateStringsArray, ...args: unknown[]): Promise {\n const result = await (sqlite.execute as any)(strings, ...args);\n const rows = result?.rows ?? result ?? [];\n return rows as T[];\n}\n\nlet initPromise: Promise | null = null;\n\n/** Crea las tablas la primera vez que se usa el val (idempotente). */\nexport function initDb(): Promise {\n if (!initPromise) initPromise = migrate();\n return initPromise;\n}\n\nasync function migrate(): Promise {\n await sqlite.execute`create table if not exists users (\n id integer primary key autoincrement,\n email text not null unique,\n name text,\n picture text,\n google_sub text unique,\n created_at text not null default (datetime('now'))\n )`;\n await sqlite.execute`create table if not exists sessions (\n token_hash text primary key,\n user_id integer not null,\n created_at text not null default (datetime('now')),\n expires_at text not null\n )`;\n await sqlite.execute`create table if not exists bots (\n id integer primary key autoincrement,\n user_id integer not null,\n name text not null,\n token_enc text not null,\n token_hint text,\n avatar text,\n guild_id text,\n guild_name text,\n code text not null default '',\n desired_state text not null default 'offline',\n status text not null default 'offline',\n last_error text,\n created_at text not null default (datetime('now')),\n updated_at text not null default (datetime('now'))\n )`;\n await sqlite.execute`create table if not exists messages (\n id integer primary key autoincrement,\n bot_id integer not null,\n role text not null,\n content text not null,\n created_at text not null default (datetime('now'))\n )`;\n await sqlite.execute`create table if not exists embeds (\n id integer primary key autoincrement,\n bot_id integer not null,\n name text not null,\n payload text not null,\n created_at text not null default (datetime('now'))\n )`;\n await sqlite.execute`create index if not exists idx_bots_user on bots(user_id)`;\n await sqlite.execute`create index if not exists idx_messages_bot on messages(bot_id)`;\n await sqlite.execute`create index if not exists idx_embeds_bot on embeds(bot_id)`;\n}\n\n/* ----------------------------- usuarios ----------------------------- */\n\nexport async function upsertUser(input: {\n email: string;\n name?: string | null;\n picture?: string | null;\n google_sub?: string | null;\n}): Promise {\n const email = input.email.trim().toLowerCase();\n const existing = await query`select * from users where email = ${email} limit 1`;\n if (existing.length) {\n const row = existing[0];\n const name = input.name ?? row.name;\n const picture = input.picture ?? row.picture;\n const sub = input.google_sub ?? row.google_sub;\n await sqlite.execute`update users set name = ${name}, picture = ${picture}, google_sub = ${sub} where id = ${row.id}`;\n return { ...row, name, picture, google_sub: sub };\n }\n const created = await query`insert into users (email, name, picture, google_sub)\n values (${email}, ${input.name ?? null}, ${input.picture ?? null}, ${input.google_sub ?? null})\n returning *`;\n return created[0];\n}\n\n/* ----------------------------- sesiones ----------------------------- */\n\nexport async function createSession(tokenHash: string, userId: number, expiresAt: string): Promise {\n await sqlite.execute`insert or replace into sessions (token_hash, user_id, expires_at)\n values (${tokenHash}, ${userId}, ${expiresAt})`;\n}\n\nexport async function userBySession(tokenHash: string): Promise {\n const rows = await query`select u.* from sessions s\n join users u on u.id = s.user_id\n where s.token_hash = ${tokenHash} and s.expires_at > datetime('now') limit 1`;\n return rows[0] ?? null;\n}\n\nexport async function deleteSession(tokenHash: string): Promise {\n await sqlite.execute`delete from sessions where token_hash = ${tokenHash}`;\n}\n\n/* ------------------------------- bots ------------------------------- */\n\nexport async function countBots(userId: number): Promise {\n const rows = await query<{ n: number }>`select count(*) as n from bots where user_id = ${userId}`;\n return Number(rows[0]?.n ?? 0);\n}\n\nexport async function listBots(userId: number): Promise {\n return query`select * from bots where user_id = ${userId} order by id desc`;\n}\n\nexport async function getBot(id: number, userId: number): Promise {\n const rows = await query`select * from bots where id = ${id} and user_id = ${userId} limit 1`;\n return rows[0] ?? null;\n}\n\nexport async function createBot(input: {\n userId: number;\n name: string;\n tokenEnc: string;\n tokenHint: string;\n avatar: string | null;\n guildId: string | null;\n guildName: string | null;\n}): Promise {\n const rows = await query`insert into bots (user_id, name, token_enc, token_hint, avatar, guild_id, guild_name)\n values (${input.userId}, ${input.name}, ${input.tokenEnc}, ${input.tokenHint}, ${input.avatar}, ${input.guildId}, ${input.guildName})\n returning *`;\n return rows[0];\n}\n\nexport async function updateBotCode(id: number, code: string): Promise {\n await sqlite.execute`update bots set code = ${code}, updated_at = datetime('now') where id = ${id}`;\n}\n\nexport async function setBotState(id: number, desired: string, status: string, error: string | null = null): Promise {\n await sqlite.execute`update bots set desired_state = ${desired}, status = ${status}, last_error = ${error},\n updated_at = datetime('now') where id = ${id}`;\n}\n\nexport async function deleteBot(id: number, userId: number): Promise {\n await sqlite.execute`delete from messages where bot_id = ${id}`;\n await sqlite.execute`delete from embeds where bot_id = ${id}`;\n await sqlite.execute`delete from bots where id = ${id} and user_id = ${userId}`;\n}\n\nexport async function listDesiredOnline(): Promise {\n return query`select * from bots where desired_state = 'online'`;\n}\n\n/* ---------------------------- historial IA --------------------------- */\n\nexport async function addMessage(botId: number, role: string, content: string): Promise {\n const rows = await query`insert into messages (bot_id, role, content)\n values (${botId}, ${role}, ${content}) returning *`;\n return rows[0];\n}\n\nexport async function listMessages(botId: number, limit = 30): Promise {\n const rows = await query`select * from messages where bot_id = ${botId} order by id desc limit ${limit}`;\n return rows.reverse();\n}\n\nexport async function clearMessages(botId: number): Promise {\n await sqlite.execute`delete from messages where bot_id = ${botId}`;\n}\n\n/* ------------------------- plantillas de embed ------------------------ */\n\nexport async function saveEmbedTemplate(botId: number, name: string, payload: string): Promise {\n const rows = await query`insert into embeds (bot_id, name, payload)\n values (${botId}, ${name}, ${payload}) returning *`;\n return rows[0];\n}\n\nexport async function listEmbedTemplates(botId: number): Promise {\n return query`select * from embeds where bot_id = ${botId} order by id desc`;\n}\n\nexport async function deleteEmbedTemplate(id: number, botId: number): Promise {\n await sqlite.execute`delete from embeds where id = ${id} and bot_id = ${botId}`;\n}","label",[138],"70dfb208-b31b-420e-bb92-f0f4249f99aa",["D",1789659394719],[33],"pulls","branches","forks","envVars",{"_157":159,"_160":67},"connections",{"_157":67,"_158":67},"count","unfilledCount",4,"emptyCount",{"_47":147,"_37":33,"_35":36,"_140":-5,"_45":46,"_44":14,"_142":63,"_42":167,"_13":67,"_38":39,"_40":41,"_29":30,"_145":-5,"_164":168,"_32":169},{"_47":137,"_37":138,"_35":139,"_140":-5,"_45":46,"_44":141,"_142":30,"_42":163,"_13":67,"_38":39,"_40":144,"_29":30,"_145":-5,"_164":165,"_32":166},["D",1789659376629],"children",[],[138],["D",1789659394719],[],[33],["D",1789659345779],["D",1789661495919],{"_104":103,"_112":108},{"_104":103,"_105":106,"_107":108,"_19":59,"_109":110,"_111":30},{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"ctx",{"_86":-5,"_132":208,"_209":210,"_211":212,"_213":30,"_214":30,"_215":30,"_216":63,"_217":-5,"_218":-7,"_219":-7,"_220":67,"_221":30,"_222":30,"_223":-5,"_224":30,"_225":30,"_226":30,"_227":-5},"ENV",{"_179":180,"_181":182,"_183":94,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v2