`\n ).join('');\n\n return c.html(`\n \n \n \n Static Page Manager\n \n \n \n

📄 Static Page Manager

\n \n \n\n

Existing Pages

${pagesList}\n\n View Source\n \n \n `);\n});\n\n// Create a new page\napp.post(\"/create\", async (c) => {\n const formData = await c.req.parseBody();\n const token = formData.token as string;\n const title = formData.title as string;\n const content = formData.content as string;\n const content_type = formData.content_type as string || 'text/html';\n\n // Check admin token\n if (token !== ADMIN_TOKEN) {\n return new Response('Unauthorized', { status: 403 });\n }\n\n try {\n await sqlite.execute(`\n INSERT INTO ${KEY}_pages_${SCHEMA_VERSION} (title, content, content_type) VALUES (?, ?, ?)\n `, [title, content, content_type]);\n } catch (error) {\n // Handle potential unique constraint violation\n if (error.message.includes('UNIQUE constraint failed')) {\n return new Response('A page with this title already exists', { status: 400 });\n }\n throw error;\n }\n\n return c.redirect(\"/\");\n});\n\n// View a specific page by title\napp.get(\"/static/:title\", async (c) => {\n const inputTitle = c.req.param(\"title\");\n \n // Find pages where the sanitized input matches the sanitized title in the database\n const pageResult = await sqlite.execute(`\n SELECT content, content_type, title FROM ${KEY}_pages_${SCHEMA_VERSION} \n WHERE LOWER(REPLACE(REPLACE(REPLACE(title, ' ', '-'), '/[^a-z0-9-]/g', ''), '--', '-')) = ?\n `, [inputTitle]);\n\n const page = pageResult.rows[0];\n\n if (!page) {\n return c.text(\"Page not found\", 404);\n }\n\n return new Response(page.content, {\n headers: {\n 'Content-Type': page.content_type || 'text/html'\n }\n });\n});\n\nexport default app.fetch;","deleted","label",[98],"permalink","https://www.val.town/x/philz/static/code/main.tsx","extension","actionData","errors"]