[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_185":186,"_187":188},"routes/_app.x.$handle.$name",{"_97":96,"_32":44,"_106":87,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":124,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",34,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",false,"deletedHere","path","index.html","latestPath","fileId","7134ec32-5462-11f1-a4c7-ee650bb23af1","name","fileType","content","\n\n\n \n \n Workspace Hub\n \n \n\n\n\n

\n \n \n

\n\n

Assistance Requests

Submit a request persistently stored via SQLite.

\n\n \n\n

Submitted Requests

\n \n

\n\n

Global Chat Room

Real-time chat syncing seamlessly between sessions.

\n\n \n\n

\n 🟢 Active Chat\n \n

\n \n

\n\n

\n \n \n

\n\n

view source

\n\n \n\n","\n\n\n \n \n Workspace Hub\n \n \n\n\n\n

\n \n \n

\n\n

Assistance Requests

Submit a request persistently stored via SQLite.

\n\n \n\n

Submitted Requests

\n \n

\n\n

Global Chat Room

Real-time chat syncing seamlessly between sessions.

\n\n \n\n

\n 🟢 Active Chat\n \n

\n \n

\n\n

\n \n \n

\n\n

view source

\n\n \n\n","createdAt",["D",1779293212229],"branchVersion","branchId","84608634-545f-11f1-a0e5-ee650bb23af1","id","845fad7c-545f-11f1-a0e5-ee650bb23af1","my-firstval",["D",1779290464467],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","My first Val Town project","imageUrl","ec81d796-38cd-43b5-bf28-58123b5452c5","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"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",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":25},"branch",{"_13":86,"_32":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"isOwned",36,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","shfatime1","handle","displayName","Fatima Shabanova","avatar","https://avatars.githubusercontent.com/u/262426626?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":180,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":181,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":182,"_81":183,"_83":184,"_85":25},"tree",[167,168,169],"files",[167,168,169],"counts",{"_157":60,"_158":139,"_159":60,"_160":161,"_162":163},"contents",[129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_42":153,"_32":28,"_30":31,"_135":-5,"_40":41,"_39":14,"_137":25,"_37":154,"_13":155,"_33":20,"_34":36,"_24":25,"_142":-5,"_27":156},{"_42":144,"_32":145,"_30":146,"_135":-5,"_40":41,"_39":147,"_137":124,"_37":148,"_13":149,"_33":150,"_34":151,"_24":25,"_142":-5,"_27":152},{"_42":132,"_32":133,"_30":134,"_135":-5,"_40":41,"_39":136,"_137":124,"_37":138,"_13":139,"_33":140,"_34":141,"_24":25,"_142":-5,"_27":143},"55dc6188-5465-11f1-964f-ee650bb23af1","types.ts","14e82e84-5463-11f1-a982-ee650bb23af1","parentId",33,"latest",["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}","label",[133],"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;",[145],"ea2ca758-5465-11f1-87d5-ee650bb23af1",["D",1779293212229],3,[28],"pulls","branches","forks","envVars",{"_164":60,"_166":60},"connections",{"_164":60,"_165":60},"count","unfilledCount","emptyCount",{"_42":153,"_32":28,"_30":31,"_135":-5,"_40":41,"_39":14,"_137":25,"_37":177,"_13":155,"_33":20,"_34":36,"_24":25,"_142":-5,"_171":178,"_27":179},{"_42":144,"_32":145,"_30":146,"_135":-5,"_40":41,"_39":147,"_137":124,"_37":174,"_13":149,"_33":150,"_34":151,"_24":25,"_142":-5,"_171":175,"_27":176},{"_42":132,"_32":133,"_30":134,"_135":-5,"_40":41,"_39":136,"_137":124,"_37":170,"_13":139,"_33":140,"_34":141,"_24":25,"_142":-5,"_171":172,"_27":173},["D",1779292963396],"children",[],[133],["D",1779292958592],[],[145],["D",1779293212229],[],[28],["D",1779290464467],["D",1789498239291],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":25},{"_13":86,"_32":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"ctx",{"_79":-5,"_126":218,"_219":220,"_221":222,"_223":25,"_224":25,"_225":25,"_226":124,"_227":-5,"_228":-7,"_229":-7,"_230":60,"_231":25,"_232":25,"_233":-5,"_234":25,"_235":25,"_236":25,"_237":-5},"ENV",{"_189":190,"_191":192,"_193":87,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217},"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

Assistance Requests

Submitted Requests

Global Chat Room

Choose a Username

Diff · v34