Mi Vocabulario IA

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_105":86,"_27":53,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"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":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",32,"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","bba653ce-82fb-11f1-b873-1607ee4eb77e","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // TU TOKEN DE TELEGRAM\n const miTokenDirecto = \"8884197802:AAGEmxRRkpWtjb9Y0niKTWAAN8UNLhbkj0o\";\n\n // --- API DE DATOS (Backend) ---\n if (req.method === \"GET\" && url.pathname === \"/cargar-datos\") {\n try {\n const seccionesRes = await sqlite.execute(\n \"SELECT * FROM mis_secciones ORDER BY id DESC\",\n );\n const palabrasRes = await sqlite.execute(\"SELECT * FROM mis_palabras\");\n return new Response(\n JSON.stringify({\n secciones: seccionesRes.rows,\n palabras: palabrasRes.rows,\n }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n } catch (e) {\n return new Response(JSON.stringify({ error: e.message }), {\n status: 500,\n });\n }\n }\n\n // Guardar nueva\n if (req.method === \"POST\" && url.pathname === \"/guardar-seccion\") {\n try {\n const datos = await req.json();\n const resSeccion = await sqlite.execute({\n sql:\n `INSERT INTO mis_secciones (nombre_seccion) VALUES (?) RETURNING id`,\n args: [datos.nombre],\n });\n const seccionId = resSeccion.rows[0][0];\n for (const palabra of datos.palabras) {\n await sqlite.execute({\n sql: `INSERT INTO mis_palabras (seccion_id, palabra) VALUES (?, ?)`,\n args: [seccionId, palabra.toLowerCase()],\n });\n }\n return new Response(JSON.stringify({ OK: true }));\n } catch (e) {\n return new Response(JSON.stringify({ error: e.message }), {\n status: 500,\n });\n }\n }\n\n // EDITAR SECCIÓN EXISTENTE\n if (req.method === \"POST\" && url.pathname === \"/editar-seccion\") {\n try {\n const datos = await req.json();\n await sqlite.execute({\n sql: `UPDATE mis_secciones SET nombre_seccion = ? WHERE id = ?`,\n args: [datos.nombre, datos.id],\n });\n await sqlite.execute({\n sql: `DELETE FROM mis_palabras WHERE seccion_id = ?`,\n args: [datos.id],\n });\n for (const palabra of datos.palabras) {\n await sqlite.execute({\n sql: `INSERT INTO mis_palabras (seccion_id, palabra) VALUES (?, ?)`,\n args: [datos.id, palabra.toLowerCase()],\n });\n }\n return new Response(JSON.stringify({ OK: true }));\n } catch (e) {\n return new Response(JSON.stringify({ error: e.message }), {\n status: 500,\n });\n }\n }\n\n // --- BOT TELEGRAM (Filtro Estricto) ---\n if (req.method === \"POST\" && url.pathname === \"/webhook-telegram\") {\n try {\n const bulto = await req.json();\n const mensajeUsuario = bulto.message?.text;\n const chatId = bulto.message?.chat?.id;\n if (mensajeUsuario && chatId) {\n const palabrasDB = await sqlite.execute(\n \"SELECT palabra FROM mis_palabras\",\n );\n const listaPalabrasPermitidas = palabrasDB.rows.map((row) =>\n row[0].toString().trim().toLowerCase()\n );\n\n if (listaPalabrasPermitidas.length === 0) {\n await fetch(\n `https://api.telegram.org/bot${miTokenDirecto}/sendMessage`,\n {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n chat_id: chatId,\n text: \"Add words first!\",\n }),\n },\n );\n return new Response(\"OK\", { status: 200 });\n }\n\n const openai = new OpenAI();\n const instruccionIA =\n `You are Carlos, English tutor. ONLY use words from this list: [${\n listaPalabrasPermitidas.join(\", \")\n }]. Do NOT use pronouns, articles, or other words not in this list. Speak ONLY English.`;\n\n const respuestaIA = await openai.chat.completions.create({\n model: \"gpt-4o-mini\",\n messages: [{ role: \"system\", content: instruccionIA }, {\n role: \"user\",\n content: mensajeUsuario,\n }],\n max_tokens: 100,\n });\n\n const texto = (respuestaIA.choices[0].message.content || \"\")\n .toLowerCase().replace(/[.,\\/#!$%\\^&\\*;:{}=\\-_`~()?\"']/g, \" \").split(\n /\\s+/,\n ).filter((p) => p.length > 0);\n const filtrado = texto.filter((p) =>\n listaPalabrasPermitidas.includes(p)\n );\n const respuestaFinal = filtrado.length > 0\n ? filtrado.join(\" \")\n : listaPalabrasPermitidas[0];\n\n await fetch(\n `https://api.telegram.org/bot${miTokenDirecto}/sendMessage`,\n {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chatId, text: respuestaFinal }),\n },\n );\n }\n return new Response(\"OK\", { status: 200 });\n } catch (e) {\n return new Response(\"OK\", { status: 200 });\n }\n }\n\n // --- INTERFAZ HTML ---\n const html = `\n \n \n \n Mi Vocabulario IA\n \n \n \n \n

📚 Mi Vocabulario

\n \n

\n\n \n\n \n \n \n `;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // TU TOKEN DE TELEGRAM\n const miTokenDirecto = \"8884197802:AAGEmxRRkpWtjb9Y0niKTWAAN8UNLhbkj0o\";\n\n // --- API DE DATOS (Backend) ---\n if (req.method === \"GET\" && url.pathname === \"/cargar-datos\") {\n try {\n const seccionesRes = await sqlite.execute(\n \"SELECT * FROM mis_secciones ORDER BY id DESC\",\n );\n const palabrasRes = await sqlite.execute(\"SELECT * FROM mis_palabras\");\n return new Response(\n JSON.stringify({\n secciones: seccionesRes.rows,\n palabras: palabrasRes.rows,\n }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n } catch (e) {\n return new Response(JSON.stringify({ error: e.message }), {\n status: 500,\n });\n }\n }\n\n // Guardar nueva sección\n if (req.method === \"POST\" && url.pathname === \"/guardar-seccion\") {\n try {\n const datos = await req.json();\n const resSeccion = await sqlite.execute({\n sql:\n `INSERT INTO mis_secciones (nombre_seccion) VALUES (?) RETURNING id`,\n args: [datos.nombre],\n });\n const seccionId = resSeccion.rows[0][0];\n for (const palabra of datos.palabras) {\n await sqlite.execute({\n sql: `INSERT INTO mis_palabras (seccion_id, palabra) VALUES (?, ?)`,\n args: [seccionId, palabra.trim().toLowerCase()],\n });\n }\n return new Response(JSON.stringify({ OK: true }));\n } catch (e) {\n return new Response(JSON.stringify({ error: e.message }), {\n status: 500,\n });\n }\n }\n\n // Editar sección existente\n if (req.method === \"POST\" && url.pathname === \"/editar-seccion\") {\n try {\n const datos = await req.json();\n await sqlite.execute({\n sql: `UPDATE mis_secciones SET nombre_seccion = ? WHERE id = ?`,\n args: [datos.nombre, datos.id],\n });\n await sqlite.execute({\n sql: `DELETE FROM mis_palabras WHERE seccion_id = ?`,\n args: [datos.id],\n });\n for (const palabra of datos.palabras) {\n await sqlite.execute({\n sql: `INSERT INTO mis_palabras (seccion_id, palabra) VALUES (?, ?)`,\n args: [datos.id, palabra.trim().toLowerCase()],\n });\n }\n return new Response(JSON.stringify({ OK: true }));\n } catch (e) {\n return new Response(JSON.stringify({ error: e.message }), {\n status: 500,\n });\n }\n }\n\n // --- BOT TELEGRAM (Filtro Estricto) ---\n if (req.method === \"POST\" && url.pathname === \"/webhook-telegram\") {\n try {\n const bulto = await req.json();\n const mensajeUsuario = bulto.message?.text;\n const chatId = bulto.message?.chat?.id;\n if (mensajeUsuario && chatId) {\n const palabrasDB = await sqlite.execute(\n \"SELECT palabra FROM mis_palabras\",\n );\n const listaPalabrasPermitidas = palabrasDB.rows.map((row) =>\n row[0].toString().trim().toLowerCase()\n );\n\n if (listaPalabrasPermitidas.length === 0) {\n await fetch(\n `https://api.telegram.org/bot${miTokenDirecto}/sendMessage`,\n {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n chat_id: chatId,\n text: \"Add words first!\",\n }),\n },\n );\n return new Response(\"OK\", { status: 200 });\n }\n\n const openai = new OpenAI();\n const instruccionIA =\n `You are Carlos, English tutor. ONLY use words from this list: [${\n listaPalabrasPermitidas.join(\", \")\n }]. Do NOT use pronouns, articles, or other words not in this list. Speak ONLY English.`;\n\n const respuestaIA = await openai.chat.completions.create({\n model: \"gpt-4o-mini\",\n messages: [{ role: \"system\", content: instruccionIA }, {\n role: \"user\",\n content: mensajeUsuario,\n }],\n max_tokens: 100,\n });\n\n const texto = (respuestaIA.choices[0].message.content || \"\")\n .toLowerCase().replace(/[.,\\/#!$%\\^&\\*;:{}=\\-_`~()?\"']/g, \" \").split(\n /\\s+/,\n ).filter((p) => p.length > 0);\n const filtrado = texto.filter((p) =>\n listaPalabrasPermitidas.includes(p)\n );\n const respuestaFinal = filtrado.length > 0\n ? filtrado.join(\" \")\n : listaPalabrasPermitidas[0];\n\n await fetch(\n `https://api.telegram.org/bot${miTokenDirecto}/sendMessage`,\n {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chatId, text: respuestaFinal }),\n },\n );\n }\n return new Response(\"OK\", { status: 200 });\n } catch (e) {\n return new Response(\"OK\", { status: 200 });\n }\n }\n\n // --- INTERFAZ HTML (Sin Modals, 100% Mobile Friendly) ---\n const html = `\n \n \n \n \n Mi Vocabulario IA\n \n \n \n \n

📚 Control de Vocabulario

\n \n

Agregar Nueva Sección

\n \n \n Nombre de la Sección:\n \n \n Palabras de esta sección:\n \n Separa cada palabra con una coma ( , )\n \n \n \n

\n\n

Secciones Creadas

\n\n \n \n \n `;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","createdAt",["D",1784475487182],"branchVersion","branchId","c0faec25-f8a6-4e0f-b48d-c2cf8244d9a5","id","df9c9d95-b77f-4f3a-b32f-8d975f06d30e","tutorInglesCompleto",["D",1784415312162],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","4c4e18a2-9376-4762-ae5b-3bee5fa0becf","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f6b88-426f-73dc-88c9-36f51736aa69","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_104":100},"org",{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"isOwned",34,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","machadofastfood","handle","displayName","Machado Fast Food","avatar","https://lh3.googleusercontent.com/a/ACg8ocKXjKJcfLEzUjWalAvzWEpqsnsdlTOCCi9Zsd9NAgAxBs9nHZY=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":150,"_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":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":151,"_80":152,"_82":153,"_84":25},"tree",[145],"files",[145],"counts",{"_134":62,"_135":136,"_137":62,"_138":139,"_140":141},"contents",[126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_27":133},"de5b2d3c-4944-4a69-b1c0-00ae458e6b72","parentId","latest",["D",1784475487182],31,"label",[28],"pulls","branches",1,"forks","envVars",{"_142":136,"_144":62},"connections",{"_142":62,"_143":62},"count","unfilledCount","emptyCount",{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":146,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_147":148,"_27":149},["D",1784475487182],"children",[],[28],["D",1784415312162],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_123":187,"_188":189,"_190":191,"_192":25,"_193":25,"_194":25,"_195":58,"_196":-5,"_197":-7,"_198":-7,"_199":62,"_200":25,"_201":25,"_202":-5,"_203":25,"_204":25,"_205":25,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":86,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"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 · v32