[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_195":196,"_197":198},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_149":-5,"_20":150,"_22":151,"_152":153,"_154":155,"_26":156,"_24":157,"_158":-5,"_159":-5,"_160":51,"_161":162,"_163":43,"_164":-5,"_165":-5,"_166":167},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","shfatime1","name","my-firstval","branchName","main","version","path","index.html","project",{"_33":91,"_13":14,"_44":92,"_93":-5,"_94":51,"_95":96,"_97":96,"_98":99,"_100":-5,"_101":102,"_103":-5,"_104":51,"_105":-5,"_106":-5,"_107":87,"_108":109,"_110":111,"_112":113,"_114":115,"_116":-5,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_126":127,"_128":129,"_130":131,"_132":51},"tree",[54,55,56,57],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":53},"contents",[],"upstream","pull","ahead","behind","envVars","id","3e28fe1e-5476-11f1-a38b-ee650bb23af1","fileId","7134ec32-5462-11f1-a4c7-ee650bb23af1","parentId","branchId","84608634-545f-11f1-a0e5-ee650bb23af1","branchVersion",35,"latest",true,"createdAt",["D",1779300225079],4,"fileType","content","\n\n\n \n \n Workspace Hub\n \n \n \n \n\n \n\n\n\n \n

\n\n

\n\n \n

\n \n \n

\n\n \n

Assistance Requests

Submit a request persistently stored via SQLite.

\n\n

\n \n \n

\n \n 0 / 500\n

\n\n

Submitted Requests

\n \n

\n\n \n \n\n

view source

\n\n \n\n","deleted",false,"label",[19],{"_33":82,"_13":83,"_35":84,"_37":-5,"_38":39,"_40":85,"_42":43,"_44":86,"_17":87,"_47":88,"_48":-5,"_50":51,"_52":-5,"_66":89,"_18":90},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":79,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_66":80,"_18":81},{"_33":69,"_13":70,"_35":71,"_37":-5,"_38":39,"_40":72,"_42":43,"_44":73,"_17":74,"_47":75,"_48":76,"_50":51,"_52":-5,"_66":77,"_18":78},{"_33":58,"_13":59,"_35":60,"_37":-5,"_38":39,"_40":61,"_42":43,"_44":62,"_17":63,"_47":64,"_48":65,"_50":51,"_52":-5,"_66":67,"_18":68},"55dc6188-5465-11f1-964f-ee650bb23af1","types.ts","14e82e84-5463-11f1-a982-ee650bb23af1",33,["D",1779292963396],1,"script","/** * Existing Assistance Request Data Structure\n */\nexport interface AssistanceRequest {\n id: number;\n text: string;\n status: \"pending\" | \"in_progress\" | \"resolved\";\n created_at: string;\n}\n\n/** * NEW: Chat Message Data Structure\n */\nexport interface ChatMessage {\n id: number;\n username: string;\n message_text: string;\n created_at: string;\n}\n\nexport interface ValidationResult {\n valid: boolean;\n error?: string;\n sanitized?: string;\n}\n\nexport const REQUEST_MAX_LENGTH = 500;\nexport const MESSAGE_MAX_LENGTH = 200;\n\n/** Validates assistance requests */\nexport function validateRequest(input: unknown): ValidationResult {\n if (typeof input !== \"string\") {\n return { valid: false, error: \"Request must be a string.\" };\n }\n const trimmed = input.trim();\n if (trimmed.length < 1) {\n return { valid: false, error: \"Request cannot be empty.\" };\n }\n if (trimmed.length > REQUEST_MAX_LENGTH) {\n return { valid: false, error: `Too long (max ${REQUEST_MAX_LENGTH}).` };\n }\n return { valid: true, sanitized: trimmed };\n}\n\n/** NEW: Validates chat messages and usernames */\nexport function validateChatMessage(\n username: unknown,\n message: unknown,\n): ValidationResult {\n if (typeof username !== \"string\" || typeof message !== \"string\") {\n return { valid: false, error: \"Username and message must be text.\" };\n }\n const uTrim = username.trim();\n const mTrim = message.trim();\n\n if (uTrim.length < 1) {\n return { valid: false, error: \"Username cannot be empty.\" };\n }\n if (mTrim.length < 1) {\n return { valid: false, error: \"Message cannot be empty.\" };\n }\n if (mTrim.length > MESSAGE_MAX_LENGTH) {\n return { valid: false, error: \"Message is too long.\" };\n }\n\n return { valid: true, sanitized: mTrim };\n}","children",[],[59],"52ff8c60-5465-11f1-b7d8-ee650bb23af1","main.ts","8464a78c-545f-11f1-a0e5-ee650bb23af1",32,["D",1779292958592],11,"http","import { Hono } from \"npm:hono@4\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { validateChatMessage, validateRequest } from \"./types.ts\";\nimport type { AssistanceRequest, ChatMessage } from \"./types.ts\";\n\nconst app = new Hono();\n\napp.onError((err) => Promise.reject(err));\n\n// ── MƏLUMAT BAZASI SCHEMA ──────────────────────────────────\n// Köhnə Sorğular Cədvəli\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS assistance_requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n request TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'pending',\n created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ','now'))\n )\n`);\n\n// YENİ: Çat Mesajları Cədvəli\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS chat_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message_text TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ','now'))\n )\n`);\n\n// Miqrasiya yoxlanışı (status sütunu üçün)\nconst cols = await sqlite.execute(`PRAGMA table_info(assistance_requests)`);\nconst colNames = cols.rows.map((r: any) => r[1] ?? r.name);\nif (!colNames.includes(\"status\")) {\n await sqlite.execute(\n `ALTER TABLE assistance_requests ADD COLUMN status TEXT NOT NULL DEFAULT 'pending'`,\n );\n}\n\n// ── MARŞRUTLAR (ROUTES) ─────────────────────────────────────\n\napp.get(\"/\", (c) => serveFile(\"./index.html\", import.meta.url));\napp.get(\"/source\", (c) => c.redirect(parseVal(import.meta.url).links.self.val));\n\n// === ASSISTANCE REQUESTS API ===\napp.get(\"/api/requests\", async (c) => {\n const result = await sqlite.execute(\n \"SELECT id, request, status, created_at FROM assistance_requests ORDER BY id DESC\",\n );\n const requests: AssistanceRequest[] = result.rows.map((row: any) => ({\n id: row[0] ?? row.id,\n text: row[1] ?? row.request,\n status: row[2] ?? row.status ?? \"pending\",\n created_at: row[3] ?? row.created_at,\n }));\n return c.json(requests);\n});\n\napp.post(\"/api/requests\", async (c) => {\n let body: any;\n try {\n body = await c.req.json();\n } catch {\n return c.json({ error: \"Invalid JSON\" }, 400);\n }\n\n const validation = validateRequest(body?.request);\n if (!validation.valid) return c.json({ error: validation.error }, 400);\n\n const result = await sqlite.execute({\n sql: `INSERT INTO assistance_requests (request) VALUES (?)`,\n args: [validation.sanitized!],\n });\n\n return c.json({\n id: Number(result.lastInsertRowid),\n text: validation.sanitized!,\n status: \"pending\",\n created_at: new Date().toISOString(),\n }, 201);\n});\n\napp.delete(\"/api/requests/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.execute({\n sql: \"DELETE FROM assistance_requests WHERE id = ?\",\n args: [id],\n });\n return c.json({ ok: true });\n});\n\n// === YENİ: REAL-TIME CHAT API ===\n// Bütün mesajları ardıcıl oxumaq (Artan ID ilə)\napp.get(\"/api/chat\", async (c) => {\n const result = await sqlite.execute(\n \"SELECT id, username, message_text, created_at FROM chat_messages ORDER BY id ASC\",\n );\n const messages: ChatMessage[] = result.rows.map((row: any) => ({\n id: row[0],\n username: row[1],\n message_text: row[2],\n created_at: row[3],\n }));\n return c.json(messages);\n});\n\n// Yeni çat mesajı qəbulu\napp.post(\"/api/chat\", async (c) => {\n let body: any;\n try {\n body = await c.req.json();\n } catch {\n return c.json({ error: \"Invalid JSON\" }, 400);\n }\n\n const validation = validateChatMessage(body?.username, body?.message);\n if (!validation.valid) return c.json({ error: validation.error }, 400);\n\n await sqlite.execute({\n sql: `INSERT INTO chat_messages (username, message_text) VALUES (?, ?)`,\n args: [body.username.trim(), validation.sanitized!],\n });\n\n return c.json({ success: true }, 201);\n});\n\nexport default app.fetch;",[],[70],["D",1779300225079],[],[19],"25cfda4e-5493-4b23-84cd-98968d3d0bdc","untitled-folder-301","ecb2e456-8ff2-11f1-8280-1607ee4eb77e",36,["D",1785840894109],0,"directory",[],[83],"845fad7c-545f-11f1-a0e5-ee650bb23af1",["D",1779290464467],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","My first Val Town project","imageUrl","userId","ec81d796-38cd-43b5-bf28-58123b5452c5","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019e45f2-05d1-7318-8465-d1294ec0ecc5","tursoName","845fad7c545f11f1a0e5ee650bb23af1","tursoHostname","845fad7c545f11f1a0e5ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789498239291],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_148":144},"org",{"_11":12,"_141":142,"_143":144,"_101":102,"_145":146,"_147":51},"branch",{"_17":85,"_13":16,"_33":39,"_133":91,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":14,"_140":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Fatima Shabanova","avatar","https://avatars.githubusercontent.com/u/262426626?v=4","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":91,"_13":14,"_44":190,"_93":-5,"_94":51,"_95":96,"_97":96,"_98":99,"_100":-5,"_101":102,"_103":-5,"_104":51,"_105":-5,"_106":-5,"_107":87,"_108":109,"_110":111,"_112":113,"_114":191,"_116":-5,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_126":192,"_128":193,"_130":194,"_132":51},[178,179,180,181],"files",[178,179,180,181],"counts",{"_169":87,"_170":63,"_171":87,"_32":172,"_173":174},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":168},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches","forks",{"_175":87,"_177":87},"connections",{"_175":87,"_176":87},"count","unfilledCount","emptyCount",{"_33":82,"_13":83,"_35":84,"_37":-5,"_38":39,"_40":85,"_42":43,"_44":86,"_17":87,"_47":88,"_48":-5,"_50":51,"_52":-5,"_66":188,"_18":189},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":79,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_66":186,"_18":187},{"_33":69,"_13":70,"_35":71,"_37":-5,"_38":39,"_40":72,"_42":43,"_44":73,"_17":74,"_47":75,"_48":76,"_50":51,"_52":-5,"_66":184,"_18":185},{"_33":58,"_13":59,"_35":60,"_37":-5,"_38":39,"_40":61,"_42":43,"_44":62,"_17":63,"_47":64,"_48":65,"_50":51,"_52":-5,"_66":182,"_18":183},[],[59],[],[70],[],[19],[],[83],["D",1779290464467],["D",1789498239291],{"_11":12,"_148":144},{"_11":12,"_141":142,"_143":144,"_101":102,"_145":146,"_147":51},{"_17":85,"_13":16,"_33":39,"_133":91,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":14,"_140":12},"ctx",{"_126":-5,"_165":228,"_229":230,"_231":232,"_233":51,"_234":51,"_235":51,"_236":43,"_237":-5,"_238":-7,"_239":-7,"_240":87,"_241":51,"_242":51,"_243":-5,"_244":51,"_245":51,"_246":51,"_247":-5},"ENV",{"_199":200,"_201":202,"_203":16,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227},"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 Requests

Submitted Requests

Global Chat Room

Choose a Username