Division Chat

\n {renderContent()}\n

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

Welcome, {user.username}! 👋

\n {user.isAdmin &&

👑 Admin Access

}\n

\n {rooms.map(room => (\n

Division {room}

Click to enter chat

\n \n \n {roomUrls[room] && (\n {\n e.target.select();\n navigator.clipboard.writeText(e.target.value);\n alert(\"URL Copied!\");\n }}\n className=\"room-url-input\"\n />\n )}\n

\n ))}\n

\n );\n}\n\nfunction ChatRoom({ room, user, roomUrl, onBack }) {\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

\n \n

Division {room} Chat

\n {roomUrl && (\n \n )}\n

\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 = \"Chat\";\n const SCHEMA_VERSION = 7; // Increment schema version for URL tracking\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 // Create room URLs table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_room_urls_${SCHEMA_VERSION} (\n room TEXT NOT NULL,\n url TEXT UNIQUE NOT NULL,\n created_at 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 // Generate room URL route\n if (url.pathname.startsWith(\"/generate-room-url/\") && request.method === \"POST\") {\n const room = url.pathname.split(\"/\").pop();\n const roomUrl = `https://val.town/v/${KEY}/room/${room}`;\n\n // Check if URL already exists for this room\n const existingUrlResult = await sqlite.execute(\n `SELECT url FROM ${KEY}_room_urls_${SCHEMA_VERSION} WHERE room = ?`,\n [room]\n );\n\n if (existingUrlResult.rows.length > 0) {\n return new Response(JSON.stringify({ \n url: existingUrlResult.rows[0].url \n }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Insert new room URL\n await sqlite.execute(\n `INSERT INTO ${KEY}_room_urls_${SCHEMA_VERSION} (room, url) VALUES (?, ?)`,\n [room, roomUrl]\n );\n\n return new Response(JSON.stringify({ url: roomUrl }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Room-specific URL handling\n if (url.pathname.startsWith(`/room/`)) {\n const room = url.pathname.split(\"/\").pop();\n // Redirect to main app with pre-selected room\n return new Response(null, {\n status: 302,\n headers: { \n \"Location\": `/?room=${room}` \n },\n });\n }\n\n // Existing routes remain the same...\n // [Rest of the existing server function code remains unchanged]\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 {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}\n\nconst css = `\n/* Previous CSS remains the same, with additional styles: */\n.room-actions {\n margin-top: 10px;\n display: flex;\n flex-direction: column;\n gap: 10px;\n}\n\n.generate-url-btn, .enter-btn {\n padding: 8px;\n border-radius: 4px;\n cursor: pointer;\n transition: all 0.3s ease;\n}\n\n.generate-url-btn {\n background-color: var(--secondary-color);\n color: white;\n border: none;\n}\n\n.enter-btn {\n background-color: var(--primary-color);\n color: white;\n border: none;\n}\n\n.room-url-input {\n width: 100%;\n padding: 8px;\n border: 1px solid #ddd;\n border-radius: 4px;\n font-size: 12px;\n text-overflow: ellipsis;\n}\n\n.copy-url-btn {\n background: none;\n border: none;\n color: white;\n cursor: pointer;\n margin-left: auto;\n}\n`;","deleted","label",[99],"permalink","https://www.val.town/x/Swapnil0006/Chat/code/main.tsx","extension","actionData","errors"]