\n {!user ? (\n

Login / Register

\n setUsername(e.target.value)}\n />\n setPassword(e.target.value)}\n />\n \n \n

\n ) : (\n

Welcome, {user.username}! 🎉

\n \n

Messages

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

\n {msg.content}\n

\n ))}\n setMessageContent(e.target.value)}\n />\n \n

\n\n

Audio Sharing

\n uploadAudio(e.target.files[0])}\n />\n {audioFiles.map(audio => (\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 = \"heroicCoralFly\";\n\n // Create necessary tables\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n password TEXT NOT NULL,\n email TEXT\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n content TEXT NOT NULL,\n user_id INTEGER,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(user_id) REFERENCES ${KEY}_users(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_audio (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n url TEXT NOT NULL,\n user_id INTEGER,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(user_id) REFERENCES ${KEY}_users(id)\n )\n `);\n\n return new Response(`\n \n \n Social Platform\n \n \n \n

\n \n \n \n \n `, {\n headers: { \"content-type\": \"text/html\" }\n });\n}\n\nconst css = `\nbody {\n font-family: system-ui, sans-serif;\n max-width: 600px;\n margin: 0 auto;\n padding: 20px;\n background-color: #f4f4f4;\n}\n.auth-section, .user-dashboard {\n background-color: white;\n padding: 20px;\n border-radius: 8px;\n box-shadow: 0 2px 4px rgba(0,0,0,0.1);\n}\ninput, button {\n display: block;\n width: 100%;\n margin: 10px 0;\n padding: 10px;\n}\n.message {\n background-color: #e9e9e9;\n padding: 10px;\n margin: 5px 0;\n border-radius: 4px;\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/roysarajit143/heroicCoralFly/code/main.tsx","extension","actionData","errors"]