🏆 Leaderboard 🏆

\n {isAdmin\n ? \n : }\n

Leaderboard

\n {podium.map((participant, index) => (\n

\n {participant.name}\n {participant.score}\n

\n ))}\n

\n \n \n \n \n \n \n \n \n \n {participants.map((participant, index) => (\n \n \n \n \n \n ))}\n \n

Rank	Name	Score
{index + 1}	{participant.name}	{participant.score}

Recent Activity

\n {log.name} {log.points > 0 ? \"gained\" : \"lost\"} {Math.abs(log.points)} points\n {log.note && - {log.note}}\n
\n \n {new Date(log.timestamp + \" UTC\").toLocaleString(\"en-PH\", { timeZone: \"Asia/Manila\" })}\n \n

\n {isAdmin && (\n

Admin Panel

\n )}\n {showLoginModal && (\n

Admin Login

\n )}\n {showExportModal && (\n

Export Options

\n \n \n

\n )}\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\n\nif (typeof document !== \"undefined\") {\n client();\n}\n\nexport default async function server(req: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const SCHEMA_VERSION = 3;\n const KEY = \"legendaryRoseSwordfish\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_participants_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT UNIQUE NOT NULL,\n score INTEGER NOT NULL DEFAULT 0\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_logs_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n points INTEGER NOT NULL,\n note TEXT,\n timestamp DATETIME DEFAULT (datetime('now'))\n )\n `);\n\n if (req.method === \"POST\" && req.url.endsWith(\"/api/login\")) {\n const { username, password } = await req.json();\n if (username === \"admin\" && password === \"123123123\") {\n return new Response(\"OK\");\n }\n return new Response(\"Unauthorized\", { status: 401 });\n }\n\n if (req.method === \"POST\" && req.url.endsWith(\"/api/update\")) {\n const { name, points, note } = await req.json();\n await sqlite.execute(\n `\n INSERT INTO ${KEY}_participants_${SCHEMA_VERSION} (name, score)\n VALUES (?, ?)\n ON CONFLICT(name) DO UPDATE SET score = score + ?\n `,\n [name, points, points],\n );\n await sqlite.execute(\n `\n INSERT INTO ${KEY}_logs_${SCHEMA_VERSION} (name, points, note)\n VALUES (?, ?, ?)\n `,\n [name, points, note],\n );\n return new Response(\"OK\");\n }\n\n if (req.method === \"POST\" && req.url.endsWith(\"/api/reset\")) {\n await sqlite.execute(`DELETE FROM ${KEY}_participants_${SCHEMA_VERSION}`);\n await sqlite.execute(`DELETE FROM ${KEY}_logs_${SCHEMA_VERSION}`);\n return new Response(\"OK\");\n }\n\n if (req.url.endsWith(\"/api/data\")) {\n const participants = await sqlite.execute(`\n SELECT * FROM ${KEY}_participants_${SCHEMA_VERSION}\n ORDER BY score DESC\n `);\n const logs = await sqlite.execute(`\n SELECT * FROM ${KEY}_logs_${SCHEMA_VERSION}\n ORDER BY timestamp DESC\n LIMIT 10\n `);\n return new Response(\n JSON.stringify({\n participants: participants.rows,\n logs: logs.rows,\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n if (req.url.endsWith(\"/api/export-csv\")) {\n const participants = await sqlite.execute(`\n SELECT * FROM ${KEY}_participants_${SCHEMA_VERSION}\n ORDER BY score DESC\n `);\n const logs = await sqlite.execute(`\n SELECT * FROM ${KEY}_logs_${SCHEMA_VERSION}\n ORDER BY timestamp DESC\n `);\n\n let csv = \"Participants\\n\";\n csv += \"Rank,Name,Score\\n\";\n participants.rows.forEach((participant, index) => {\n csv += `${index + 1},${participant.name},${participant.score}\\n`;\n });\n\n csv += \"\\nLogs\\n\";\n csv += \"Name,Points,Note,Timestamp\\n\";\n logs.rows.forEach((log) => {\n csv += `${log.name},${log.points},\"${log.note}\",${log.timestamp}\\n`;\n });\n\n return new Response(csv, {\n headers: {\n \"Content-Type\": \"text/csv\",\n \"Content-Disposition\": `attachment; filename=\"Leaderboard_Export.csv\"`,\n },\n });\n }\n\n return new Response(\n `\n \n \n \n \n \n Leaderboard\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 background-color: #f0f0f0;\n margin: 0;\n padding: 0;\n}\n\n.container {\n max-width: 1000px;\n margin: 0 auto;\n padding: 20px;\n}\n\n.header {\n display: flex;\n justify-content: space-between;\n align-items: center;\n margin-bottom: 20px;\n}\n\nh1, h2 {\n color: #2c3e50;\n}\n\n.content {\n display: flex;\n gap: 30px;\n}\n\n.left-column {\n flex: 2;\n}\n\n.right-column {\n flex: 1;\n}\n\nform {\n display: flex;\n flex-direction: column;\n gap: 10px;\n margin-bottom: 20px;\n}\n\ninput {\n padding: 10px;\n font-size: 16px;\n border: 1px solid #ddd;\n border-radius: 4px;\n}\n\n.btn {\n padding: 10px 20px;\n font-size: 16px;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n transition: all 0.3s ease;\n}\n\n.btn-primary {\n background-color: #3498db;\n color: white;\n}\n\n.btn-primary:hover {\n background-color: #2980b9;\n}\n\n.btn-secondary {\n background-color: #95a5a6;\n color: white;\n}\n\n.btn-secondary:hover {\n background-color: #7f8c8d;\n}\n\n.btn-danger {\n background-color: #e74c3c;\n color: white;\n}\n\n.btn-danger:hover {\n background-color: #c0392b;\n}\n\n.btn-success {\n background-color: #2ecc71;\n color: white;\n}\n\n.btn-success:hover {\n background-color: #27ae60;\n}\n\n.podium {\n display: flex;\n justify-content: center;\n align-items: flex-end;\n height: 200px;\n margin-bottom: 20px;\n}\n\n.podium-place {\n width: 100px;\n display: flex;\n flex-direction: column;\n align-items: center;\n margin: 0 10px;\n border-radius: 8px 8px 0 0;\n overflow: hidden;\n}\n\n.place-1 { height: 100%; background-color: #ffd700; }\n.place-2 { height: 80%; background-color: #c0c0c0; }\n.place-3 { height: 60%; background-color: #cd7f32; }\n\n.podium-place .name {\n font-weight: bold;\n margin-top: 10px;\n text-align: center;\n padding: 5px;\n width: 100%;\n background-color: rgba(255, 255, 255, 0.7);\n}\n\n.podium-place .score {\n font-size: 24px;\n margin-top: 5px;\n}\n\ntable {\n width: 100%;\n border-collapse: collapse;\n margin-top: 20px;\n background-color: white;\n box-shadow: 0 2px 5px rgba(0,0,0,0.1);\n}\n\nth, td {\n padding: 12px;\n text-align: left;\n border-bottom: 1px solid #ddd;\n}\n\nth {\n background-color: #3498db;\n color: white;\n}\n\n.logs {\n list-style-type: none;\n padding: 0;\n}\n\n.logs li {\n background-color: #fff;\n margin-bottom: 10px;\n padding: 12px;\n border-radius: 5px;\n box-shadow: 0 2px 5px rgba(0,0,0,0.1);\n}\n\n.note {\n font-style: italic;\n color: #666;\n}\n\n.timestamp {\n font-size: 0.8em;\n color: #888;\n}\n\n.admin-panel {\n margin-top: 30px;\n background-color: #fff;\n padding: 20px;\n border-radius: 5px;\n box-shadow: 0 2px 5px rgba(0,0,0,0.1);\n}\n\n.modal {\n position: fixed;\n top: 0;\n left: 0;\n width: 100%;\n height: 100%;\n background-color: rgba(0, 0, 0, 0.5);\n display: flex;\n justify-content: center;\n align-items: center;\n}\n\n.modal-content {\n background-color: white;\n padding: 20px;\n border-radius: 5px;\n width: 300px;\n}\n\n.modal-buttons {\n display: flex;\n justify-content: space-between;\n margin-top: 20px;\n}\n\nfooter {\n text-align: center;\n margin-top: 20px;\n}\n\nfooter a {\n color: #3498db;\n text-decoration: none;\n}\n\nfooter a:hover {\n text-decoration: underline;\n}\n`;","deleted","label",[99],"permalink","https://www.val.town/x/ronr/legendaryRoseSwordfish/code/main.tsx","extension","actionData","errors"]