🛟 Assistance Hub

\n Submit assistance requests or chat with others in real time.\n

\n\n \n \n\n \n

\n\n \n

\n \n \n\n \n

\n Chatting as \n

\n \n

\n\n \n

\n No messages yet. Say hello! 👋\n

\n\n

\n \n\n \n

\n\n \n \n\n",[132],"55360571-91a2-407e-97db-7340bd8b750e","db.ts","d15ff65c-6244-11f1-9bdb-1607ee4eb77e",11,["D",1780823437719],1,"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TABLE = \"assistance_requests\";\n\nexport async function setupDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n body TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`);\n}\n\nexport interface AssistanceRequest {\n id: number;\n body: string;\n created_at: string;\n}\n\nexport async function addRequest(body: string): Promise {\n await setupDb();\n const result = await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (body) VALUES (?) RETURNING id, body, created_at`,\n args: [body],\n });\n return result.rows[0] as unknown as AssistanceRequest;\n}\n\nexport async function listRequests(): Promise {\n await setupDb();\n const result = await sqlite.execute(\n `SELECT id, body, created_at FROM ${TABLE} ORDER BY id DESC LIMIT 100`,\n );\n return result.rows as unknown as AssistanceRequest[];\n}\n\nconst MSG_TABLE = \"chat_messages\";\n\nexport async function setupChatDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${MSG_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n body TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`);\n}\n\nexport interface ChatMessage {\n id: number;\n username: string;\n body: string;\n created_at: string;\n}\n\nexport async function addMessage(username: string, body: string): Promise {\n await setupChatDb();\n const result = await sqlite.execute({\n sql:\n `INSERT INTO ${MSG_TABLE} (username, body) VALUES (?, ?) RETURNING id, username, body, created_at`,\n args: [username, body],\n });\n return result.rows[0] as unknown as ChatMessage;\n}\n\nexport async function listMessages(sinceId = 0): Promise {\n await setupChatDb();\n const result = await sqlite.execute({\n sql:\n `SELECT id, username, body, created_at FROM ${MSG_TABLE} WHERE id > ? ORDER BY id ASC LIMIT 200`,\n args: [sinceId],\n });\n return result.rows as unknown as ChatMessage[];\n}\n",[140],"eefa5469-bf4d-4826-a87d-5576871247d2","chat.js","dea4ffa4-6250-11f1-abeb-1607ee4eb77e",17,["D",1780823489736],"// Chat feature: username join gate + polling-based message feed.\nconst STORAGE_KEY = \"chat-username\";\n\nexport function initChat() {\n const joinForm = document.getElementById(\"join-form\");\n const usernameInput = document.getElementById(\"username-input\");\n const joinError = document.getElementById(\"join-error\");\n const chatRoom = document.getElementById(\"chat-room\");\n const currentUsername = document.getElementById(\"current-username\");\n const leaveBtn = document.getElementById(\"leave-btn\");\n const messagesEl = document.getElementById(\"messages\");\n const messagesEmpty = document.getElementById(\"messages-empty\");\n const chatForm = document.getElementById(\"chat-form\");\n const messageInput = document.getElementById(\"message-input\");\n const sendBtn = chatForm.querySelector(\"button\");\n const chatError = document.getElementById(\"chat-error\");\n\n let username = null;\n let lastId = 0;\n let pollTimer = null;\n\n function escapeForRender(node, text) {\n node.textContent = text; // textContent is XSS-safe\n }\n\n function formatTime(iso) {\n const d = new Date(iso.replace(\" \", \"T\") + \"Z\");\n return isNaN(d) ? \"\" : d.toLocaleTimeString([], { hour: \"2-digit\", minute: \"2-digit\" });\n }\n\n function renderMessages(messages) {\n if (!messages.length) return;\n messagesEmpty.style.display = \"none\";\n for (const m of messages) {\n const mine = m.username === username;\n const row = document.createElement(\"div\");\n row.className = \"flex flex-col \" + (mine ? \"items-end\" : \"items-start\");\n\n const meta = document.createElement(\"div\");\n meta.className = \"text-xs text-gray-400 mb-0.5 px-1\";\n escapeForRender(meta, `${m.username} · ${formatTime(m.created_at)}`);\n\n const bubble = document.createElement(\"div\");\n bubble.className =\n \"max-w-[80%] px-3 py-2 rounded-2xl break-words whitespace-pre-wrap \" +\n (mine ? \"bg-blue-600 text-white\" : \"bg-gray-100 text-gray-800\");\n escapeForRender(bubble, m.body);\n\n row.append(meta, bubble);\n messagesEl.append(row);\n lastId = Math.max(lastId, m.id);\n }\n messagesEl.scrollTop = messagesEl.scrollHeight;\n }\n\n async function poll() {\n try {\n const res = await fetch(`/api/messages?since=${lastId}`);\n const data = await res.json();\n renderMessages(data.messages || []);\n } catch {\n /* ignore transient network errors while polling */\n }\n }\n\n function startPolling() {\n poll();\n pollTimer = setInterval(poll, 2000);\n }\n\n function stopPolling() {\n if (pollTimer) clearInterval(pollTimer);\n pollTimer = null;\n }\n\n function showJoinError(msg) {\n joinError.textContent = msg;\n joinError.classList.remove(\"hidden\");\n }\n\n function enterRoom(name) {\n username = name;\n localStorage.setItem(STORAGE_KEY, name);\n currentUsername.textContent = name;\n joinForm.classList.add(\"hidden\");\n chatRoom.classList.remove(\"hidden\");\n lastId = 0;\n messagesEl.querySelectorAll(\"div\").forEach((n) => n.remove());\n messagesEmpty.style.display = \"block\";\n startPolling();\n messageInput.focus();\n }\n\n joinForm.addEventListener(\"submit\", (e) => {\n e.preventDefault();\n joinError.classList.add(\"hidden\");\n const name = usernameInput.value.trim();\n if (!name) {\n showJoinError(\"Please enter a username to join.\");\n return;\n }\n enterRoom(name.slice(0, 40));\n });\n\n leaveBtn.addEventListener(\"click\", () => {\n stopPolling();\n username = null;\n localStorage.removeItem(STORAGE_KEY);\n chatRoom.classList.add(\"hidden\");\n joinForm.classList.remove(\"hidden\");\n usernameInput.value = \"\";\n usernameInput.focus();\n });\n\n chatForm.addEventListener(\"submit\", async (e) => {\n e.preventDefault();\n chatError.classList.add(\"hidden\");\n const body = messageInput.value.trim();\n if (!body) return;\n sendBtn.disabled = true;\n try {\n const res = await fetch(\"/api/messages\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ username, body }),\n });\n if (!res.ok) {\n const data = await res.json().catch(() => ({}));\n throw new Error(data.error || \"Failed to send message.\");\n }\n messageInput.value = \"\";\n await poll(); // show our message immediately\n } catch (err) {\n chatError.textContent = err.message || \"Something went wrong.\";\n chatError.classList.remove(\"hidden\");\n } finally {\n sendBtn.disabled = false;\n messageInput.focus();\n }\n });\n\n // Remember a previously chosen username across reloads.\n const saved = localStorage.getItem(STORAGE_KEY);\n if (saved) {\n usernameInput.value = saved;\n }\n}\n",[149],"b5c14079-4105-4c35-82f3-ccb8f3b5ecfe","app.js","dad815a2-6244-11f1-9433-1607ee4eb77e",18,["D",1780823506567],4,"import { initChat } from \"/chat.js\";\n\nconst form = document.getElementById(\"request-form\");\nconst input = document.getElementById(\"request-input\");\nconst list = document.getElementById(\"requests\");\nconst empty = document.getElementById(\"empty\");\nconst errorEl = document.getElementById(\"error\");\nconst button = form.querySelector(\"button\");\n\nfunction showError(msg) {\n errorEl.textContent = msg;\n errorEl.classList.remove(\"hidden\");\n}\n\nfunction clearError() {\n errorEl.textContent = \"\";\n errorEl.classList.add(\"hidden\");\n}\n\ninput.addEventListener(\"input\", clearError);\n\nfunction formatTime(iso) {\n // SQLite datetime('now') returns \"YYYY-MM-DD HH:MM:SS\" in UTC.\n const d = new Date(iso.replace(\" \", \"T\") + \"Z\");\n return isNaN(d) ? iso : d.toLocaleString();\n}\n\nfunction render(requests) {\n list.innerHTML = \"\";\n empty.style.display = requests.length ? \"none\" : \"block\";\n for (const r of requests) {\n const li = document.createElement(\"li\");\n li.className =\n \"bg-white border border-gray-200 rounded-lg px-4 py-3 shadow-sm\";\n const body = document.createElement(\"p\");\n body.className = \"text-gray-800 break-words whitespace-pre-wrap\";\n body.textContent = r.body;\n const meta = document.createElement(\"p\");\n meta.className = \"text-xs text-gray-400 mt-1\";\n meta.textContent = formatTime(r.created_at);\n li.append(body, meta);\n list.append(li);\n }\n}\n\nasync function load() {\n const res = await fetch(\"/api/requests\");\n const data = await res.json();\n render(data.requests);\n}\n\nform.addEventListener(\"submit\", async (e) => {\n e.preventDefault();\n clearError();\n const body = input.value.trim();\n if (!body) {\n showError(\"Please enter a request before submitting.\");\n input.focus();\n return;\n }\n button.disabled = true;\n try {\n const res = await fetch(\"/api/requests\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ body }),\n });\n if (!res.ok) {\n const data = await res.json().catch(() => ({}));\n throw new Error(data.error || \"Failed to submit request.\");\n }\n input.value = \"\";\n await load();\n input.focus();\n } catch (err) {\n showError(err.message || \"Something went wrong.\");\n } finally {\n button.disabled = false;\n }\n});\n\nload();\n\n// ===== Tab switching =====\nconst tabs = document.querySelectorAll(\".tab-btn\");\nconst panels = {\n requests: document.getElementById(\"panel-requests\"),\n chat: document.getElementById(\"panel-chat\"),\n};\n\nfunction activateTab(name) {\n for (const btn of tabs) {\n const active = btn.dataset.tab === name;\n btn.classList.toggle(\"border-blue-600\", active);\n btn.classList.toggle(\"text-blue-600\", active);\n btn.classList.toggle(\"border-transparent\", !active);\n btn.classList.toggle(\"text-gray-500\", !active);\n }\n panels.requests.classList.toggle(\"hidden\", name !== \"requests\");\n panels.chat.classList.toggle(\"hidden\", name !== \"chat\");\n}\n\nfor (const btn of tabs) {\n btn.addEventListener(\"click\", () => activateTab(btn.dataset.tab));\n}\n\ninitChat();\n",[156],"pulls","branches","forks","envVars",{"_170":40,"_172":40},"connections",{"_170":40,"_171":40},"count","unfilledCount","emptyCount",{"_18":155,"_20":156,"_116":157,"_118":-5,"_119":69,"_120":158,"_121":104,"_22":191,"_66":160,"_124":145,"_126":161,"_128":26,"_129":-5,"_179":192,"_87":193},{"_18":148,"_20":149,"_116":150,"_118":-5,"_119":69,"_120":151,"_121":104,"_22":188,"_66":40,"_124":145,"_126":153,"_128":26,"_129":-5,"_179":189,"_87":190},{"_18":139,"_20":140,"_116":141,"_118":-5,"_119":69,"_120":142,"_121":104,"_22":185,"_66":144,"_124":145,"_126":146,"_128":26,"_129":-5,"_179":186,"_87":187},{"_18":131,"_20":132,"_116":133,"_118":-5,"_119":69,"_120":134,"_121":104,"_22":182,"_66":136,"_124":97,"_126":137,"_128":26,"_129":-5,"_179":183,"_87":184},{"_18":114,"_20":115,"_116":117,"_118":-5,"_119":69,"_120":67,"_121":104,"_22":178,"_66":123,"_124":125,"_126":127,"_128":26,"_129":-5,"_179":180,"_87":181},["D",1780823514984],"children",[],[115],["D",1780823466591],[],[132],["D",1780823437719],[],[140],["D",1780823489736],[],[149],["D",1780823506567],[],[156],["D",1780818192270],["D",1789525245864],{"_16":17,"_85":81},{"_16":17,"_78":79,"_80":81,"_33":34,"_82":83,"_84":26},{"_66":67,"_20":68,"_18":69,"_70":19,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":-5,"_76":21,"_77":17},"ctx",{"_59":-5,"_106":232,"_233":234,"_235":236,"_237":26,"_238":26,"_239":26,"_240":104,"_241":-5,"_242":-7,"_243":-7,"_244":40,"_245":26,"_246":26,"_247":-5,"_248":26,"_249":26,"_250":26,"_251":-5},"ENV",{"_203":204,"_205":206,"_207":68,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231},"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 Hub

\n Submitted Requests\n

Join the chat

Search