Request Submission

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_158":159,"_160":161},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_107":88,"_27":53,"_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",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",11,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","4814a1ba-573e-11f1-996b-ee650bb23af1","name","fileType","http","content","import { Hono } from \"npm:hono@4\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst app = new Hono();\n\n// Initialize database\nasync function initDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n request_text TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,\n ip_address TEXT,\n user_agent TEXT,\n browser_name TEXT,\n browser_version TEXT,\n os_name TEXT,\n os_version TEXT,\n device_type TEXT,\n cookies TEXT,\n session_id TEXT\n )\n `);\n}\n\n// Parse user agent to extract browser and OS info\nfunction parseUserAgent(userAgent: string) {\n let browserName = \"Unknown\";\n let browserVersion = \"Unknown\";\n let osName = \"Unknown\";\n let osVersion = \"Unknown\";\n let deviceType = \"Desktop\";\n\n // Browser detection\n if (userAgent.includes(\"Chrome\") && !userAgent.includes(\"Chromium\")) {\n browserName = \"Chrome\";\n const match = userAgent.match(/Chrome\\/(\\d+\\.\\d+)/);\n if (match) browserVersion = match[1];\n } else if (userAgent.includes(\"Safari\") && !userAgent.includes(\"Chrome\")) {\n browserName = \"Safari\";\n const match = userAgent.match(/Version\\/(\\d+\\.\\d+)/);\n if (match) browserVersion = match[1];\n } else if (userAgent.includes(\"Firefox\")) {\n browserName = \"Firefox\";\n const match = userAgent.match(/Firefox\\/(\\d+\\.\\d+)/);\n if (match) browserVersion = match[1];\n } else if (userAgent.includes(\"Edge\")) {\n browserName = \"Edge\";\n const match = userAgent.match(/Edge\\/(\\d+\\.\\d+)/);\n if (match) browserVersion = match[1];\n } else if (userAgent.includes(\"Opera\")) {\n browserName = \"Opera\";\n const match = userAgent.match(/Opera\\/(\\d+\\.\\d+)/);\n if (match) browserVersion = match[1];\n }\n\n // OS detection\n if (userAgent.includes(\"Windows\")) {\n osName = \"Windows\";\n if (userAgent.includes(\"Windows NT 10.0\")) osVersion = \"10/11\";\n else if (userAgent.includes(\"Windows NT 6.3\")) osVersion = \"8.1\";\n else if (userAgent.includes(\"Windows NT 6.2\")) osVersion = \"8\";\n } else if (userAgent.includes(\"Mac\")) {\n osName = \"macOS\";\n const match = userAgent.match(/Mac OS X ([\\d._]+)/);\n if (match) osVersion = match[1].replace(/_/g, \".\");\n } else if (userAgent.includes(\"Linux\")) {\n osName = \"Linux\";\n } else if (userAgent.includes(\"iPhone\")) {\n osName = \"iOS\";\n deviceType = \"Mobile\";\n } else if (userAgent.includes(\"iPad\")) {\n osName = \"iOS\";\n deviceType = \"Tablet\";\n } else if (userAgent.includes(\"Android\")) {\n osName = \"Android\";\n deviceType = userAgent.includes(\"Mobile\") ? \"Mobile\" : \"Tablet\";\n }\n\n return { browserName, browserVersion, osName, osVersion, deviceType };\n}\n\n// Get client IP address\nfunction getClientIP(headers: any): string {\n try {\n const forwarded = headers.get(\"x-forwarded-for\");\n if (forwarded) return forwarded.split(\",\")[0].trim();\n \n const real = headers.get(\"x-real-ip\");\n if (real) return real;\n \n const cf = headers.get(\"cf-connecting-ip\");\n if (cf) return cf;\n \n return \"Unknown\";\n } catch (e) {\n return \"Unknown\";\n }\n}\n\nconst HTML = `\n \n \n \n \n \n Request Submission\n \n \n \n

\n \n\n

\n\n

\n Your Assistance Request\n

\n \n

\n\n

\n \n

\n\n

\n Submitted Requests\n 0\n

Loading requests...

\n\n \n \n \n`;\n\napp.get(\"/\", (c) => {\n return c.html(HTML);\n});\n\n// API endpoint to submit request\napp.post(\"/submit\", async (c) => {\n try {\n await initDatabase();\n\n const body = await c.req.json();\n const requestText = body.request_text;\n const sessionId = body.session_id;\n\n if (!requestText || requestText.trim().length === 0) {\n return c.json({ error: \"Request text is required\" }, 400);\n }\n\n const userAgent = c.req.header(\"user-agent\") || \"Unknown\";\n const cookieHeader = c.req.header(\"cookie\") || \"\";\n \n // For IP, we need to access the raw headers\n let ipAddress = \"Unknown\";\n try {\n const forwarded = c.req.header(\"x-forwarded-for\");\n if (forwarded) ipAddress = forwarded.split(\",\")[0].trim();\n else ipAddress = c.req.header(\"x-real-ip\") || c.req.header(\"cf-connecting-ip\") || \"Unknown\";\n } catch (e) {\n ipAddress = \"Unknown\";\n }\n \n const { browserName, browserVersion, osName, osVersion, deviceType } =\n parseUserAgent(userAgent);\n\n const insertSql = \"INSERT INTO requests (request_text, ip_address, user_agent, browser_name, browser_version, os_name, os_version, device_type, cookies, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\";\n\n await sqlite.execute({\n sql: insertSql,\n args: [\n requestText,\n ipAddress,\n userAgent,\n browserName,\n browserVersion,\n osName,\n osVersion,\n deviceType,\n cookieHeader,\n sessionId,\n ],\n });\n\n return c.json({ success: true, message: \"Request saved successfully\" });\n } catch (error) {\n console.error(\"Error saving request:\", error);\n return c.json(\n { error: \"Failed to save request: \" + String(error) },\n 500\n );\n }\n});\n\n// API endpoint to get all requests\napp.get(\"/requests\", async (c) => {\n try {\n await initDatabase();\n\n const result = await sqlite.execute(\n \"SELECT * FROM requests ORDER BY id DESC LIMIT 100\"\n );\n\n return c.json({ requests: result.rows || [] });\n } catch (error) {\n console.error(\"Error fetching requests:\", error);\n return c.json({ error: \"Failed to fetch requests\", requests: [] }, 500);\n }\n});\n\n// API endpoint to delete a request\napp.post(\"/delete\", async (c) => {\n try {\n const body = await c.req.json();\n const id = body.id;\n\n if (!id) {\n return c.json({ error: \"ID is required\" }, 400);\n }\n\n await sqlite.execute({\n sql: \"DELETE FROM requests WHERE id = ?\",\n args: [id],\n });\n\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error deleting request:\", error);\n return c.json({ error: \"Failed to delete request\" }, 500);\n }\n});\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","import { Hono } from \"npm:hono@4\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst app = new Hono();\n\n// Initialize database\nasync function initDatabase() {\n // Базовая таблица запросов\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n request_text TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,\n ip_address TEXT,\n user_agent TEXT,\n browser_name TEXT,\n browser_version TEXT,\n os_name TEXT,\n os_version TEXT,\n device_type TEXT,\n cookies TEXT,\n session_id TEXT\n )\n `);\n\n // Новая таблица для сообщений живого чата\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS chat_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n}\n\n// Parse user agent to extract browser and OS info\nfunction parseUserAgent(userAgent: string) {\n let browserName = \"Unknown\";\n let browserVersion = \"Unknown\";\n let osName = \"Unknown\";\n let osVersion = \"Unknown\";\n let deviceType = \"Desktop\";\n\n if (userAgent.includes(\"Chrome\") && !userAgent.includes(\"Chromium\")) {\n browserName = \"Chrome\";\n const match = userAgent.match(/Chrome\\/(\\d+\\.\\d+)/);\n if (match) browserVersion = match[1];\n } else if (userAgent.includes(\"Safari\") && !userAgent.includes(\"Chrome\")) {\n browserName = \"Safari\";\n const match = userAgent.match(/Version\\/(\\d+\\.\\d+)/);\n if (match) browserVersion = match[1];\n } else if (userAgent.includes(\"Firefox\")) {\n browserName = \"Firefox\";\n const match = userAgent.match(/Firefox\\/(\\d+\\.\\d+)/);\n if (match) browserVersion = match[1];\n } else if (userAgent.includes(\"Edge\")) {\n browserName = \"Edge\";\n const match = userAgent.match(/Edge\\/(\\d+\\.\\d+)/);\n if (match) browserVersion = match[1];\n } else if (userAgent.includes(\"Opera\")) {\n browserName = \"Opera\";\n const match = userAgent.match(/Opera\\/(\\d+\\.\\d+)/);\n if (match) browserVersion = match[1];\n }\n\n if (userAgent.includes(\"Windows\")) {\n osName = \"Windows\";\n if (userAgent.includes(\"Windows NT 10.0\")) osVersion = \"10/11\";\n else if (userAgent.includes(\"Windows NT 6.3\")) osVersion = \"8.1\";\n else if (userAgent.includes(\"Windows NT 6.2\")) osVersion = \"8\";\n } else if (userAgent.includes(\"Mac\")) {\n osName = \"macOS\";\n const match = userAgent.match(/Mac OS X ([\\d._]+)/);\n if (match) osVersion = match[1].replace(/_/g, \".\");\n } else if (userAgent.includes(\"Linux\")) {\n osName = \"Linux\";\n } else if (userAgent.includes(\"iPhone\")) {\n osName = \"iOS\";\n deviceType = \"Mobile\";\n } else if (userAgent.includes(\"iPad\")) {\n osName = \"iOS\";\n deviceType = \"Tablet\";\n } else if (userAgent.includes(\"Android\")) {\n osName = \"Android\";\n deviceType = userAgent.includes(\"Mobile\") ? \"Mobile\" : \"Tablet\";\n }\n\n return { browserName, browserVersion, osName, osVersion, deviceType };\n}\n\nconst HTML = `\n \n \n \n \n \n Request Submission & Support Chat\n \n \n \n

\n \n\n

\n \n \n

\n\n

\n Your Assistance Request\n

\n \n

\n\n

\n \n

\n\n

Submitted Requests 0

Loading requests...

\n\n

\n Your Chat Screen Name:\n \n

\n\n

\n Type Live Message\n

\n \n \n

\n\n

Live Room Activity 0

No messages yet. Start chatting!

\n\n \n \n \n`;\n\napp.get(\"/\", (c) => {\n return c.html(HTML);\n});\n\n// API Эндпоинт отправки запроса поддержки\napp.post(\"/submit\", async (c) => {\n try {\n await initDatabase();\n const body = await c.req.json();\n const requestText = body.request_text;\n const sessionId = body.session_id;\n\n if (!requestText || requestText.trim().length === 0) {\n return c.json({ error: \"Request text is required\" }, 400);\n }\n\n const userAgent = c.req.header(\"user-agent\") || \"Unknown\";\n const cookieHeader = c.req.header(\"cookie\") || \"\";\n const ipAddress = c.req.header(\"x-forwarded-for\")?.split(\",\")[0].trim() ||\n \"127.0.0.1\";\n\n const { browserName, browserVersion, osName, osVersion, deviceType } =\n parseUserAgent(userAgent);\n\n await sqlite.execute({\n sql:\n \"INSERT INTO requests (request_text, ip_address, user_agent, browser_name, browser_version, os_name, os_version, device_type, cookies, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\",\n args: [\n requestText,\n ipAddress,\n userAgent,\n browserName,\n browserVersion,\n osName,\n osVersion,\n deviceType,\n cookieHeader,\n sessionId,\n ],\n });\n\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: String(error) }, 500);\n }\n});\n\n// API Эндпоинт получения списка запросов\napp.get(\"/requests\", async (c) => {\n try {\n await initDatabase();\n const result = await sqlite.execute(\n \"SELECT * FROM requests ORDER BY id DESC LIMIT 100\",\n );\n return c.json({ requests: result.rows || [] });\n } catch (error) {\n return c.json({ requests: [] }, 500);\n }\n});\n\n// API Эндпоинт удаления запроса\napp.post(\"/delete\", async (c) => {\n try {\n const body = await c.req.json();\n await sqlite.execute({\n sql: \"DELETE FROM requests WHERE id = ?\",\n args: [body.id],\n });\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: \"Failed\" }, 500);\n }\n});\n\n/* ==================================================================== */\n/* НОВЫЕ ЭНДПОИНТЫ ДЛЯ ЖИВОГО ЧАТА */\n/* ==================================================================== */\n\n// 1. Отправка нового сообщения в чат\napp.post(\"/chat/send\", async (c) => {\n try {\n await initDatabase();\n const body = await c.req.json();\n const { username, message } = body;\n\n // Валидация на пустые сообщения или дубликаты имени, как просит инструкция (Edge Cases)\n if (\n !username || username.trim().length === 0 || !message ||\n message.trim().length === 0\n ) {\n return c.json({ error: \"Username and message are required\" }, 400);\n }\n\n await sqlite.execute({\n sql: \"INSERT INTO chat_messages (username, message) VALUES (?, ?)\",\n args: [username.trim(), message.trim()],\n });\n\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error saving chat room text:\", error);\n return c.json({ error: \"Database write error\" }, 500);\n }\n});\n\n// 2. Получение истории сообщений чата\napp.get(\"/chat/messages\", async (c) => {\n try {\n await initDatabase();\n // Вытягиваем последние 150 сообщений чата для вывода на экран\n const result = await sqlite.execute(\n \"SELECT * FROM chat_messages ORDER BY id DESC LIMIT 150\",\n );\n\n // Сортируем обратно, чтобы новые сообщения в чате были внизу списка\n const messages = (result.rows || []).reverse();\n return c.json({ messages });\n } catch (error) {\n console.error(\"Error syncing chat data:\", error);\n return c.json({ messages: [] }, 500);\n }\n});\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;","createdAt",["D",1779608502211],"branchVersion","branchId","48126d6e-573e-11f1-996b-ee650bb23af1","id","4811a050-573e-11f1-996b-ee650bb23af1","test",["D",1779606043388],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","71bb5b2b-fb00-4248-8429-67e1e7407e18","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e4f79-f738-701d-9395-9133ebe49dd8","tursoName","4811a050573e11f1996bee650bb23af1","tursoHostname","4811a050573e11f1996bee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789470042795],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",13,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","davidsitnikov","handle","displayName","Давид Ситников","avatar","https://lh3.googleusercontent.com/a/ACg8ocIcy694xM5wLQ6AXmCb2v0pJoBbK_2iIKq0XUUkIppZ7Pll1Zs=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":153,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":154,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":155,"_82":156,"_84":157,"_86":25},"tree",[148],"files",[148],"counts",{"_137":61,"_138":139,"_140":61,"_141":142,"_143":144},"contents",[129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":133,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_27":136},"01a68d1e-5744-11f1-879a-ee650bb23af1","parentId","latest",["D",1779608502211],10,"label",[28],"pulls","branches",1,"forks","envVars",{"_145":61,"_147":61},"connections",{"_145":61,"_146":61},"count","unfilledCount","emptyCount",{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":149,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_150":151,"_27":152},["D",1779608502211],"children",[],[28],["D",1779606043388],["D",1789470042795],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_126":191,"_192":193,"_194":195,"_196":25,"_197":25,"_198":25,"_199":124,"_200":-5,"_201":-7,"_202":-7,"_203":61,"_204":25,"_205":25,"_206":-5,"_207":25,"_208":25,"_209":25,"_210":-5},"ENV",{"_162":163,"_164":165,"_166":88,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190},"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"]

📝 Request Submission

\n Submitted Requests\n 0\n

🚀 MVP Workspace

Submitted Requests 0

Live Room Activity 0

Diff · v11