🛎️ Assistance Request

Describe what you need help with and submit your request.

\n\n \n

\n\n \n\n\n","label",[18],"pulls","branches",1,"forks","envVars",{"_196":26,"_198":26},"connections",{"_196":26,"_197":26},"count","unfilledCount","emptyCount",{"_36":216,"_13":217,"_66":218,"_46":-5,"_38":39,"_181":143,"_182":175,"_40":219,"_42":26,"_68":21,"_184":220,"_69":24,"_186":-5,"_210":221,"_17":222},{"_36":180,"_13":18,"_66":67,"_46":-5,"_38":39,"_181":98,"_182":175,"_40":213,"_42":43,"_68":21,"_184":185,"_69":24,"_186":-5,"_210":214,"_17":215},{"_36":202,"_13":203,"_66":204,"_46":-5,"_38":39,"_181":205,"_182":175,"_40":206,"_42":207,"_68":208,"_184":209,"_69":24,"_186":-5,"_210":211,"_17":212},"b7a91a7e-5743-11f1-bdec-ee650bb23af1","main.ts","8fa48cda-5742-11f1-9024-ee650bb23af1",10,["D",1779608378081],5,"http","import { serveFile, parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ── Database setup ─────────────────────────────────────────────\nawait sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS assistance_requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n timestamp TEXT NOT NULL\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS chat_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n text TEXT NOT NULL,\n timestamp TEXT NOT NULL\n )`,\n },\n]);\n\n// ── SSE: connected clients for real-time chat ──────────────────\ntype SSEClient = {\n controller: ReadableStreamDefaultController;\n};\nconst sseClients = new Set();\n\nfunction broadcastMessage(message: { id: number; username: string; text: string; timestamp: string }) {\n const data = JSON.stringify(message);\n for (const client of sseClients) {\n try {\n client.controller.enqueue(`data: ${data}\\n\\n`);\n } catch {\n sseClients.delete(client);\n }\n }\n}\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n\n // View source redirect\n if (url.pathname === \"/source\") {\n return new Response(null, {\n status: 302,\n headers: { Location: parseVal().links.self.val },\n });\n }\n\n // ── Assistance Requests API ────────────────────────────────────\n\n if (url.pathname === \"/requests\" && req.method === \"GET\") {\n const result = await sqlite.execute(\n \"SELECT id, text, timestamp FROM assistance_requests ORDER BY id DESC\",\n );\n return Response.json(result.rows);\n }\n\n if (url.pathname === \"/requests\" && req.method === \"POST\") {\n let body: { text?: string };\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: \"Invalid JSON body\" }, { status: 400 });\n }\n const text = String(body.text ?? \"\").trim();\n if (text.length === 0) {\n return Response.json({ error: \"Request text cannot be empty\" }, { status: 400 });\n }\n if (text.length > 500) {\n return Response.json({ error: \"Request text must be 500 characters or fewer\" }, { status: 400 });\n }\n const timestamp = new Date().toISOString();\n const result = await sqlite.execute({\n sql: \"INSERT INTO assistance_requests (text, timestamp) VALUES (?, ?)\",\n args: [text, timestamp],\n });\n return Response.json(\n { id: Number(result.lastInsertRowid), text, timestamp },\n { status: 201 },\n );\n }\n\n // ── Chat API ───────────────────────────────────────────────────\n\n // GET /chat/messages — load persisted history (last 50 messages)\n if (url.pathname === \"/chat/messages\" && req.method === \"GET\") {\n const result = await sqlite.execute(\n \"SELECT id, username, text, timestamp FROM chat_messages ORDER BY id DESC LIMIT 50\",\n );\n // Reverse so oldest is first (for display order)\n return Response.json(result.rows.reverse());\n }\n\n // POST /chat/messages — send a new message\n if (url.pathname === \"/chat/messages\" && req.method === \"POST\") {\n let body: { username?: string; text?: string };\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: \"Invalid JSON body\" }, { status: 400 });\n }\n const username = String(body.username ?? \"\").trim();\n const text = String(body.text ?? \"\").trim();\n if (username.length === 0) {\n return Response.json({ error: \"Username is required\" }, { status: 400 });\n }\n if (username.length > 30) {\n return Response.json({ error: \"Username must be 30 characters or fewer\" }, { status: 400 });\n }\n if (text.length === 0) {\n return Response.json({ error: \"Message cannot be empty\" }, { status: 400 });\n }\n if (text.length > 500) {\n return Response.json({ error: \"Message must be 500 characters or fewer\" }, { status: 400 });\n }\n\n const timestamp = new Date().toISOString();\n const result = await sqlite.execute({\n sql: \"INSERT INTO chat_messages (username, text, timestamp) VALUES (?, ?, ?)\",\n args: [username, text, timestamp],\n });\n\n const message = {\n id: Number(result.lastInsertRowid),\n username,\n text,\n timestamp,\n };\n\n // Broadcast to all connected SSE clients\n broadcastMessage(message);\n\n return Response.json(message, { status: 201 });\n }\n\n // GET /chat/stream — SSE endpoint for real-time messages\n if (url.pathname === \"/chat/stream\" && req.method === \"GET\") {\n const stream = new ReadableStream({\n start(controller) {\n const client: SSEClient = { controller };\n sseClients.add(client);\n\n // Send a heartbeat comment to confirm connection\n controller.enqueue(\": connected\\n\\n\");\n\n // Clean up on abort\n req.signal.addEventListener(\"abort\", () => {\n sseClients.delete(client);\n try {\n controller.close();\n } catch { /* already closed */ }\n });\n },\n cancel() {\n // Stream cancelled by client\n },\n });\n\n return new Response(stream, {\n headers: {\n \"Content-Type\": \"text/event-stream\",\n \"Cache-Control\": \"no-cache\",\n \"Connection\": \"keep-alive\",\n },\n });\n }\n\n // ── Serve pages ────────────────────────────────────────────────\n if (url.pathname === \"/chat\") {\n return serveFile(\"./chat.html\", import.meta.url);\n }\n\n return serveFile(\"./index.html\", import.meta.url);\n}\n","children",[],[203],["D",1779608384229],[],[18],"cd7490c2-5743-11f1-9ce3-ee650bb23af1","chat.html","cd7491c6-5743-11f1-9ce3-ee650bb23af1",["D",1779608414650],"\n\n\n \n \n Chat — Assistance App\n \n \n\n\n

\n \n

\n \n 🛎️ Requests\n \n \n 💬 Chat\n \n

\n\n \n

💬 Join Chat

Pick a username to start chatting.

\n\n \n

💬 Chat

\n \n \n

\n\n \n

No messages yet. Say hello! 👋

\n\n \n

\n view source\n

\n\n \n\n\n",[],[217],["D",1779607881430],["D",1789556471789],{"_11":12,"_157":72},{"_11":12,"_152":153,"_71":72,"_30":70,"_154":155,"_156":24},{"_42":143,"_13":16,"_36":39,"_144":106,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":14,"_151":12},"ctx",{"_56":-5,"_177":261,"_262":263,"_264":265,"_266":24,"_267":24,"_268":24,"_269":175,"_270":-5,"_271":-7,"_272":-7,"_273":26,"_274":24,"_275":24,"_276":-5,"_277":24,"_278":24,"_279":24,"_280":-5},"ENV",{"_232":233,"_234":235,"_236":16,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260},"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"]

🛎️ Assistance Request

📋 Submitted Requests

💬 Join Chat

💬 Chat

History · index.html