Support Hub

No requests yet. Submit one above!

`\n : requestsResult.rows.map((r: any) => `\n

${escapeHtml(String(r.text))}

${new Date(String(r.timestamp)).toLocaleString()}

`).join(\"\");\n\n const html = `\n\n \n Support Hub\n \n \n \n \n \n \n

\n\n

\n \n \n\n

Submit a Request

\n \n

\n ${requestsHtml}\n

\n\n

\n \n

Join the chat to speak with our team

\n \n \n

\n\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 }\n\n return new Response(\"Not Found\", { status: 404 });\n}\n\nfunction escapeHtml(str: string): string {\n return str\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}","deleted","label",[63],"d467ca7c-5700-11f1-bb8e-ee650bb23af1","favicon.svg","019e5736-7fdf-732d-97a0-19845f63e82a",["D",1779579649958],0,"",[83],"5e400c90-5702-11f1-be4d-ee650bb23af1","README.md","019e5736-7fdf-732d-97a0-16a579e50b0b",17,["D",1779580310792],2,"# 📋 Assistance Requests\n\nA simple full-stack app for submitting and viewing assistance requests, backed by SQLite.\n\n## How it works\n\n```mermaid\nsequenceDiagram\n participant Browser\n participant Server (main.tsx)\n participant SQLite\n\n Browser->>Server (main.tsx): GET /\n Server (main.tsx)->>SQLite: SELECT all requests\n SQLite-->>Server (main.tsx): rows\n Server (main.tsx)-->>Browser: HTML with pre-loaded requests\n\n Browser->>Server (main.tsx): POST /api/requests {text}\n Server (main.tsx)->>Server (main.tsx): Validate (reject empty)\n Server (main.tsx)->>SQLite: INSERT request\n SQLite-->>Server (main.tsx): lastInsertRowid\n Server (main.tsx)-->>Browser: JSON {id, text, timestamp}\n Browser->>Browser: Prepend card to DOM\n```\n\n## Features\n\n- **Persistent storage** — requests saved to SQLite (`assistance_requests` table)\n- **Server-side rendering** — GET `/` returns HTML with all saved requests pre-loaded\n- **REST API** — POST `/api/requests` to create a new request\n- **Validation** — both frontend and backend reject empty submissions\n- **No page refresh** — `fetch` API + DOM manipulation for seamless UX\n\n## Files\n\n| File | Purpose |\n|------|---------|\n| `main.tsx` | HTTP handler: routing, DB queries, HTML generation |\n| `script.js` | Client-side form handling via fetch API |\n| `style.css` | Minimal styling |\n\nBuilt with [Val Town](https://val.town).\n",[90],{"_35":89,"_13":90,"_64":91,"_66":-5,"_67":68,"_69":92,"_71":72,"_37":107,"_17":94,"_75":24,"_77":95,"_79":50,"_80":-5,"_101":108,"_18":109},{"_35":82,"_13":83,"_64":84,"_66":-5,"_67":68,"_69":33,"_71":72,"_37":104,"_17":86,"_75":24,"_77":87,"_79":50,"_80":-5,"_101":105,"_18":106},{"_35":62,"_13":63,"_64":65,"_66":-5,"_67":68,"_69":70,"_71":72,"_37":100,"_17":74,"_75":76,"_77":78,"_79":50,"_80":-5,"_101":102,"_18":103},["D",1779581473590],"children",[],[63],["D",1779579649958],[],[83],["D",1779580310792],[],[90],"d45d09b6-5700-11f1-bb8e-ee650bb23af1",["D",1779579649958],"legacyEnvVars","httpPrivacy","description","Simple page for submitting and viewing assistance requests","imageUrl","userId","4eec23d2-7413-4ff2-95ba-aca08105871a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","019e572a-9807-726e-b565-1ff9d9da77ec","tursoName","d45d09b6570011f1bb8eee650bb23af1","tursoHostname","d45d09b6570011f1bb8eee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789510872811],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_158":154},"org",{"_11":12,"_151":152,"_153":154,"_117":118,"_155":156,"_157":50},"branch",{"_17":70,"_13":16,"_35":68,"_41":110,"_44":36,"_45":147,"_148":52,"_149":42,"_150":56,"_57":14,"_53":12},75,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","Huseyn Samedzade","avatar","https://avatars.githubusercontent.com/u/129556088?v=4","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":110,"_13":14,"_37":209,"_48":-5,"_112":50,"_51":52,"_113":52,"_114":115,"_116":-5,"_117":118,"_119":65,"_120":72,"_121":-5,"_122":-5,"_123":86,"_55":124,"_125":126,"_127":128,"_129":210,"_131":-5,"_132":133,"_134":133,"_135":136,"_137":136,"_138":136,"_139":133,"_140":133,"_141":211,"_143":212,"_145":213,"_49":50},[200,201,202],"files",[200,201,202],"counts",{"_191":86,"_192":33,"_193":86,"_34":194,"_195":196},[185,186,187],"upstreamProject",{"_35":42,"_13":58,"_114":181,"_116":182,"_51":52,"_141":183},"upstreamBranch",{"_35":36,"_37":179,"_39":180,"_13":16,"_41":42,"_17":43,"_44":-5,"_45":-5,"_46":47,"_48":-5,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1749070628054],["D",1779896149804],"Basic HTML starter template based on Glitch's starter","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/1e130d76-f5f9-42d2-df67-91517700ff00/square512?exp=1789567199&sig=1fb8b010eedd80f1d9fc773e0c39f407bdab6899037f6be93e738dd7c2b0dbbd",{"_11":54,"_158":184},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789567199&sig=d8af4f1d5d6ef07a152f6225f86a0227f22fe92650a7f9572d94a5f64256bba9",{"_35":89,"_13":90,"_64":91,"_66":-5,"_67":68,"_69":92,"_71":72,"_37":93,"_17":94,"_75":24,"_77":95,"_79":50,"_80":-5,"_18":190},{"_35":82,"_13":83,"_64":84,"_66":-5,"_67":68,"_69":33,"_71":72,"_37":85,"_17":86,"_75":24,"_77":87,"_79":50,"_80":-5,"_18":189},{"_35":62,"_13":63,"_64":65,"_66":-5,"_67":68,"_69":70,"_71":72,"_37":73,"_17":74,"_75":76,"_77":78,"_79":50,"_80":-5,"_18":188},[63],[83],[90],"pulls","branches","forks",{"_197":86,"_199":86},"connections",{"_197":86,"_198":86},"count","unfilledCount","emptyCount",{"_35":89,"_13":90,"_64":91,"_66":-5,"_67":68,"_69":92,"_71":72,"_37":107,"_17":94,"_75":24,"_77":95,"_79":50,"_80":-5,"_101":207,"_18":208},{"_35":82,"_13":83,"_64":84,"_66":-5,"_67":68,"_69":33,"_71":72,"_37":104,"_17":86,"_75":24,"_77":87,"_79":50,"_80":-5,"_101":205,"_18":206},{"_35":62,"_13":63,"_64":65,"_66":-5,"_67":68,"_69":70,"_71":72,"_37":100,"_17":74,"_75":76,"_77":78,"_79":50,"_80":-5,"_101":203,"_18":204},[],[63],[],[83],[],[90],["D",1779579649958],["D",1789510872811],{"_11":12,"_158":154},{"_11":12,"_151":152,"_153":154,"_117":118,"_155":156,"_157":50},{"_17":70,"_13":16,"_35":68,"_41":110,"_44":36,"_45":147,"_148":52,"_149":42,"_150":56,"_57":14,"_53":12},"ctx",{"_141":-5,"_176":247,"_248":249,"_250":251,"_252":50,"_253":50,"_254":50,"_255":72,"_256":-5,"_257":-7,"_258":-7,"_259":86,"_260":50,"_261":50,"_262":-5,"_263":50,"_264":50,"_265":50,"_266":-5},"ENV",{"_218":219,"_220":221,"_222":16,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246},"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"]

Code