[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_198":199,"_200":201},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_149":-5,"_20":150,"_22":151,"_152":153,"_154":155,"_25":156,"_24":-5,"_157":-5,"_158":-5,"_159":54,"_160":161,"_162":54,"_163":-5,"_164":-5,"_165":166},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","amilars","name","Holberton","branchName","main","version","path","","project",{"_34":92,"_13":14,"_46":93,"_94":-5,"_95":54,"_96":97,"_98":97,"_99":19,"_100":-5,"_101":102,"_103":-5,"_104":54,"_105":-5,"_106":-5,"_107":62,"_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":54},"tree",[65,66],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":63,"_51":-5,"_53":54,"_55":-5,"_18":64},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"id","e419ba3c-55ef-11f1-9970-ee650bb23af1","main.ts","fileId","1da5f9ae-55ec-11f1-8d4b-ee650bb23af1","parentId","branchId","1d9a0db0-55ec-11f1-8d4b-ee650bb23af1","branchVersion",17,"latest",true,"createdAt",["D",1779462423742],13,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// 1. Verilənlər bazasını başladıırıq\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS holberton_chat (\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\nconst clients = new Set<(msg: string) => void>();\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // API: Canlı bağlantı axını\n if (url.pathname === \"/api/chat-stream\" && req.method === \"GET\") {\n let cleanup: () => void;\n const body = new ReadableStream({\n start(controller) {\n const pushData = (data: string) => {\n controller.enqueue(new TextEncoder().encode(`data: ${data}\\n\\n`));\n };\n clients.add(pushData);\n cleanup = () => {\n clients.delete(pushData);\n controller.close();\n };\n },\n cancel() {\n if (cleanup) cleanup();\n },\n });\n return new Response(body, {\n headers: {\n \"Content-Type\": \"text/event-stream\",\n \"Cache-Control\": \"no-cache\",\n \"Connection\": \"keep-alive\",\n },\n });\n }\n\n // API: Köhnə mesajları yükləmək\n if (url.pathname === \"/api/messages\" && req.method === \"GET\") {\n try {\n const result = await sqlite.execute(\n \"SELECT username, message FROM holberton_chat ORDER BY id ASC LIMIT 50\",\n );\n return new Response(JSON.stringify(result.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (e) {\n return new Response(\n JSON.stringify({ error: \"Mesajları yükləmək mümkün olmadı\" }),\n { status: 500, headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n }\n\n // API: Yeni mesaj göndərilməsi\n if (url.pathname === \"/api/messages\" && req.method === \"POST\") {\n try {\n const { username, message } = await req.json();\n if (!username || !message || !username.trim() || !message.trim()) {\n return new Response(\n JSON.stringify({\n error: \"İstifadəçi adı və ya mesaj boş ola bilməz\",\n }),\n { status: 400, headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n\n await sqlite.execute({\n sql:\n `INSERT INTO holberton_chat (username, message) VALUES (:username, :message)`,\n args: { username, message },\n });\n\n const payload = JSON.stringify({ username, message });\n for (const sendTo of clients) sendTo(payload);\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (e) {\n return new Response(\n JSON.stringify({ error: \"Server xətası: Mesaj göndərilə bilmədi\" }),\n { status: 500, headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n }\n\n // --- HTML İNTERFEYSİ (CSS və JS daxil) ---\n return new Response(\n `\n\n\n\n \n \n Responsive Portal & Live Chat\n \n\n\n\n

\n \n \n

\n\n

Assistance Request

\n \n \n

Submitted Requests

\n\n

Join the Chat Room

Daxil olmaq üçün istifadəçi adı təyin edin:

\n \n \n

\n\n

\n İstifadəçi: \n

\n \n \n

\n\n

\n\n \n\n\n `,\n { headers: { \"Content-Type\": \"text/html; charset=UTF-8\" } },\n );\n}","deleted",false,"label",[36],"7a5c65ec-55ed-11f1-9a91-ee650bb23af1","frontend","7a5c66d2-55ed-11f1-9a91-ee650bb23af1",7,["D",1779461387359],0,"directory",[58],{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":62,"_49":63,"_51":-5,"_53":54,"_55":-5,"_68":72,"_18":73},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":69,"_18":70},["D",1779462423742],"children",[],[36],["D",1779461387359],[74,75],[58],{"_34":84,"_13":85,"_37":86,"_39":59,"_40":41,"_42":87,"_44":45,"_46":88,"_17":62,"_49":50,"_51":89,"_53":54,"_55":-5,"_68":90,"_18":91},{"_34":76,"_13":77,"_37":78,"_39":59,"_40":41,"_42":79,"_44":45,"_46":80,"_17":62,"_49":24,"_51":81,"_53":54,"_55":-5,"_68":82,"_18":83},"7d3799ee-55ed-11f1-93b5-ee650bb23af1","index.html","7d379afc-55ed-11f1-93b5-ee650bb23af1",8,["D",1779461392152],"\n\n\n \n \n Holberton Portal\n \n \n \n \n\n\n

\n \n\n\n",[],[58,77],"90907b1e-55ed-11f1-8ed2-ee650bb23af1","app.tsx","90907bfa-55ed-11f1-8ed2-ee650bb23af1",9,["D",1779461424607],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nconst React = window.React;\nconst ReactDOM = window.ReactDOM;\nconst { useState, useEffect, useRef, useCallback } = React;\n\n// ─── Requests Tab ───\nfunction RequestsTab() {\n const [requests, setRequests] = useState([]);\n const [input, setInput] = useState(\"\");\n\n const loadRequests = useCallback(async () => {\n const res = await fetch(\"/api/requests\");\n if (res.ok) setRequests(await res.json());\n }, []);\n\n useEffect(() => { loadRequests(); }, []);\n\n const submit = async () => {\n const text = input.trim();\n if (!text) return;\n await fetch(\"/api/requests\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ text }),\n });\n setInput(\"\");\n loadRequests();\n };\n\n return (\n

Assistance Request

\n setInput(e.target.value)}\n onKeyDown={(e) => e.key === \"Enter\" && submit()}\n />\n \n Submit\n \n

Submitted Requests

\n {requests.length === 0 ? (\n

No requests submitted yet.

\n ) : (\n requests.map((r) => (\n

\n {r.text}\n

\n ))\n )}\n

\n );\n}\n\n// ─── Chat Tab ───\nfunction ChatTab() {\n const [username, setUsername] = useState(\"\");\n const [joined, setJoined] = useState(false);\n const [messages, setMessages] = useState([]);\n const [msgInput, setMsgInput] = useState(\"\");\n const messagesEndRef = useRef(null);\n const latestIdRef = useRef(0);\n const pollRef = useRef(null);\n\n const scrollToBottom = () => {\n messagesEndRef.current?.scrollIntoView({ behavior: \"smooth\" });\n };\n\n // Initial load\n const loadMessages = useCallback(async () => {\n const res = await fetch(\"/api/chat/messages\");\n if (res.ok) {\n const msgs = await res.json();\n setMessages(msgs);\n if (msgs.length > 0) latestIdRef.current = msgs[msgs.length - 1].id;\n }\n }, []);\n\n // Poll for new messages\n const pollMessages = useCallback(async () => {\n const res = await fetch(`/api/chat/messages?after=${latestIdRef.current}`);\n if (res.ok) {\n const newMsgs = await res.json();\n if (newMsgs.length > 0) {\n latestIdRef.current = newMsgs[newMsgs.length - 1].id;\n setMessages((prev) => [...prev, ...newMsgs]);\n }\n }\n }, []);\n\n useEffect(() => {\n if (joined) {\n loadMessages();\n pollRef.current = setInterval(pollMessages, 2000);\n return () => clearInterval(pollRef.current);\n }\n }, [joined]);\n\n useEffect(scrollToBottom, [messages]);\n\n const joinChat = () => {\n if (username.trim()) setJoined(true);\n };\n\n const sendMessage = async () => {\n const message = msgInput.trim();\n if (!message) return;\n await fetch(\"/api/chat/messages\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ username, message }),\n });\n setMsgInput(\"\");\n pollMessages(); // immediately fetch new messages\n };\n\n if (!joined) {\n return (\n

💬 Join Chat

Enter a username to start chatting

\n setUsername(e.target.value)}\n onKeyDown={(e) => e.key === \"Enter\" && joinChat()}\n autoFocus\n />\n \n Join\n \n

\n );\n }\n\n return (\n

💬 Chat Room

\n \n Logged in as {username}\n \n

\n {/* Messages area */}\n

\n {messages.length === 0 && (\n

No messages yet. Say hello! 👋

\n )}\n {messages.map((m) => {\n const isMe = m.username === username;\n return (\n

\n \n {!isMe && (\n

{m.username}

\n )}\n

{m.message}

\n {new Date(m.created_at + \"Z\").toLocaleTimeString([], { hour: \"2-digit\", minute: \"2-digit\" })}\n

\n );\n })}\n

\n {/* Input area */}\n

\n setMsgInput(e.target.value)}\n onKeyDown={(e) => e.key === \"Enter\" && sendMessage()}\n autoFocus\n />\n \n Send\n \n

\n );\n}\n\n// ─── Main App with Tabs ───\nfunction App() {\n const [tab, setTab] = useState(\"requests\");\n\n const tabs = [\n { id: \"requests\", label: \"📋 Requests\" },\n { id: \"chat\", label: \"💬 Chat\" },\n ];\n\n return (\n

Holberton Portal

\n {/* Tab bar */}\n

\n {tabs.map((t) => (\n setTab(t.id)}\n className={`px-5 py-3 text-sm font-medium transition border-b-2 -mb-px ${\n tab === t.id\n ? \"border-blue-500 text-blue-600\"\n : \"border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300\"\n }`}\n >\n {t.label}\n \n ))}\n

\n {/* Tab content */}\n {tab === \"requests\" ? : }\n {/* Footer */}\n

\n \n View Source\n \n

\n );\n}\n\nReactDOM.createRoot(document.getElementById(\"root\")).render();\n",[],[58,85],"1d97787a-55ec-11f1-8d4b-ee650bb23af1",["D",1779460802229],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","a138a351-814d-47ed-a9d4-9e9b86f66d1f","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019e3a11-7892-70bf-9681-889651274c36","tursoName","1d97787a55ec11f18d4bee650bb23af1","tursoHostname","1d97787a55ec11f18d4bee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789497078049],"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":54},"branch",{"_17":43,"_13":16,"_34":41,"_133":92,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":14,"_140":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Amil K. Rustamli","avatar","https://avatars.githubusercontent.com/u/110093707?v=4","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":92,"_13":14,"_46":193,"_94":-5,"_95":54,"_96":97,"_98":97,"_99":19,"_100":-5,"_101":102,"_103":-5,"_104":54,"_105":-5,"_106":-5,"_107":62,"_108":109,"_110":111,"_112":113,"_114":194,"_116":-5,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_126":195,"_128":196,"_130":197,"_132":54},[181,184],"files",[181,182,183,184],"counts",{"_171":62,"_172":173,"_174":62,"_31":175,"_176":177},[167,168],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":63,"_51":-5,"_53":54,"_55":-5,"_18":170},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":169},[36],[58],"pulls","branches",1,"forks",{"_178":62,"_180":62},"connections",{"_178":62,"_179":62},"count","unfilledCount","emptyCount",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":62,"_49":63,"_51":-5,"_53":54,"_55":-5,"_68":191,"_18":192},{"_34":84,"_13":85,"_37":86,"_39":59,"_40":41,"_42":87,"_44":45,"_46":88,"_17":62,"_49":50,"_51":89,"_53":54,"_55":-5,"_68":189,"_18":190},{"_34":76,"_13":77,"_37":78,"_39":59,"_40":41,"_42":79,"_44":45,"_46":80,"_17":62,"_49":24,"_51":81,"_53":54,"_55":-5,"_68":187,"_18":188},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":185,"_18":186},[],[36],[],[58,77],[],[58,85],[182,183],[58],["D",1779460802229],["D",1789497078049],{"_11":12,"_148":144},{"_11":12,"_141":142,"_143":144,"_101":102,"_145":146,"_147":54},{"_17":43,"_13":16,"_34":41,"_133":92,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":14,"_140":12},"ctx",{"_126":-5,"_164":231,"_232":233,"_234":235,"_236":54,"_237":54,"_238":54,"_239":45,"_240":-5,"_241":-7,"_242":-7,"_243":62,"_244":54,"_245":54,"_246":-5,"_247":54,"_248":54,"_249":54,"_250":-5},"ENV",{"_202":203,"_204":205,"_206":16,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230},"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