Division Chat

\n {renderContent()}\n

\n );\n}\n\nfunction LoginPage({ onLogin, onRegister }) {\n const [username, setUsername] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [isRegistering, setIsRegistering] = useState(false);\n\n const handleSubmit = (e) => {\n e.preventDefault();\n isRegistering\n ? onRegister(username, password)\n : onLogin(username, password);\n };\n\n return (\n

\n );\n}\n\nfunction RoomSelector({ rooms, user, onSelectRoom }) {\n return (\n

Welcome, {user.username}!

\n {user.isAdmin &&

👑 Admin Access Enabled

}\n

Select a Room:

\n {rooms.map(room => (\n onSelectRoom(room)}\n >\n Division {room}\n \n ))}\n

\n );\n}\n\nfunction ChatRoom({ room, user }) {\n const [messages, setMessages] = useState([]);\n const [newMessage, setNewMessage] = useState(\"\");\n\n useEffect(() => {\n fetchMessages();\n }, [room]);\n\n const fetchMessages = async () => {\n const response = await fetch(/messages/${room});\n const roomMessages = await response.json();\n setMessages(roomMessages);\n };\n\n const sendMessage = async (e) => {\n e.preventDefault();\n const response = await fetch(/messages/${room}, {\n method: \"POST\",\n body: JSON.stringify({\n content: newMessage,\n username: user.username,\n }),\n });\n await response.json();\n setNewMessage(\"\");\n fetchMessages();\n };\n\n const deleteMessage = async (messageId) => {\n await fetch(/messages/${room}/${messageId}, {\n method: \"DELETE\",\n body: JSON.stringify({\n username: user.username,\n isAdmin: user.isAdmin,\n }),\n });\n fetchMessages();\n };\n\n return (\n

Division {room} Chat

\n {messages.map(msg => (\n

\n {msg.username}:\n {msg.content}\n {(msg.username === user.username || user.isAdmin) && (\n \n )}\n

\n ))}\n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n const SCHEMA_VERSION = 5; // Increment schema version\n\n // Create users table with admin flag\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}users${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n password TEXT NOT NULL,\n is_admin BOOLEAN DEFAULT 0\n )\n `);\n\n // Create messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}messages${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n room TEXT NOT NULL,\n username TEXT NOT NULL,\n content TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Ensure admin user exists\n const adminCheckResult = await sqlite.execute(\n SELECT * FROM ${KEY}_users_${SCHEMA_VERSION} WHERE username = 'Swapnil',\n );\n\n if (adminCheckResult.rows.length === 0) {\n await sqlite.execute(\n INSERT INTO ${KEY}_users_${SCHEMA_VERSION} (username, password, is_admin) VALUES (?, ?, ?),\n [\"Swapnil\", \"06\", 1],\n );\n }\n\n // Handle routes\n const url = new URL(request.url);\n\n // Login route\n if (url.pathname === \"/login\" && request.method === \"POST\") {\n const { username, password } = await request.json();\n const result = await sqlite.execute(\n SELECT username, is_admin FROM ${KEY}_users_${SCHEMA_VERSION} WHERE username = ? AND password = ?,\n [username, password],\n );\n\n if (result.rows.length > 0) {\n return new Response(\n JSON.stringify({\n success: true,\n user: {\n username: result.rows[0].username,\n isAdmin: result.rows[0].is_admin === 1,\n },\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n return new Response(JSON.stringify({ success: false }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Register route\n if (url.pathname === \"/register\" && request.method === \"POST\") {\n const { username, password } = await request.json();\n try {\n await sqlite.execute(\n INSERT INTO ${KEY}_users_${SCHEMA_VERSION} (username, password, is_admin) VALUES (?, ?, ?),\n [username, password, 0],\n );\n return new Response(\n JSON.stringify({\n success: true,\n user: {\n username,\n isAdmin: false,\n },\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n } catch {\n return new Response(JSON.stringify({ success: false }), {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n // Get messages route\n if (url.pathname.startsWith(\"/messages/\") && request.method === \"GET\") {\n const room = url.pathname.split(\"/\").pop();\n const result = await sqlite.execute(\n SELECT * FROM ${KEY}_messages_${SCHEMA_VERSION} WHERE room = ? ORDER BY timestamp,\n [room],\n );\n return new Response(JSON.stringify(result.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Post message route\n if (url.pathname.startsWith(\"/messages/\") && request.method === \"POST\") {\n const room = url.pathname.split(\"/\").pop();\n const { content, username } = await request.json();\n await sqlite.execute(\n INSERT INTO ${KEY}_messages_${SCHEMA_VERSION} (room, username, content) VALUES (?, ?, ?),\n [room, username, content],\n );\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Delete message route\n if (url.pathname.match(/\\/messages\\/[A-C]\\/\\d+/) && request.method === \"DELETE\") {\n const [, , room, messageId] = url.pathname.split(\"/\");\n const { username, isAdmin } = await request.json();\n\n // Check if the user is the message author or an admin\n const messageCheck = await sqlite.execute(\n SELECT username FROM ${KEY}_messages_${SCHEMA_VERSION} WHERE id = ? AND room = ?,\n [messageId, room],\n );\n\n const messageAuthor = messageCheck.rows[0]?.username;\n\n if (messageAuthor === username || isAdmin) {\n await sqlite.execute(\n DELETE FROM ${KEY}_messages_${SCHEMA_VERSION} WHERE id = ? AND room = ?,\n [messageId, room],\n );\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n return new Response(JSON.stringify({ success: false, message: \"Not authorized\" }), {\n status: 403,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Main page\n return new Response(\n `\n \n \n Division Chat\n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}\n\nconst css = `\nbody {\n font-family: Arial, sans-serif;\n max-width: 600px;\n margin: 0 auto;\n padding: 20px;\n background-color: #f4f4f4;\n}\n\n.login-container form {\n display: flex;\n flex-direction: column;\n gap: 10px;\n}\n\n.room-selector {\n text-align: center;\n}\n\n.chat-room .messages {\n height: 400px;\n overflow-y: auto;\n border: 1px solid #ddd;\n padding: 10px;\n}\n\n.message {\n margin-bottom: 10px;\n display: flex;\n justify-content: space-between;\n}\n\ninput, button {\n padding: 10px;\n}\n`;","deleted","label",[99],"permalink","https://www.val.town/x/Swapnil_01/Chat_Application1/code/Chat","extension","actionData","errors"]

{isRegistering ? \"Register\" : \"Login\"}

Welcome, {user.username}!

Select a Room:

Division {room} Chat