Webs R AI: AI Content Generator

\n {user && (\n

Welcome, {user.name}!

Subscription: {SUBSCRIPTION_TIERS[user.tier].name}

Content Generated: {user.contentGenerated} / {SUBSCRIPTION_TIERS[user.tier].contentLimit}

\n )}\n

\n Topic:\n setTopic(e.target.value)}\n required\n className=\"w-full p-2 border rounded\"\n />\n

\n Format:\n setFormat(e.target.value)}\n className=\"w-full p-2 border rounded\"\n >\n \n \n \n \n

\n AI Provider:\n \n {AI_PROVIDERS.map((provider) => (\n \n ))}\n \n

\n API Key:\n \n

\n \n

\n {generatedContent && (\n

Generated Content:

{generatedContent}

\n )}\n

Upgrade Your Plan

\n {Object.entries(SUBSCRIPTION_TIERS).map(([tier, details]) => (\n \n ))}\n

Premium Services

\n \n \n \n

\n {adContent && (\n

Sponsored Content

{adContent}

\n )}\n

\n \n Facebook\n \n \n Twitter\n \n \n Email\n \n \n 💸 Donate\n \n

\n \n View Source\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 { OpenAI } = await import(\"https://esm.town/v/std/openai\");\n const openai = new OpenAI();\n\n const SCHEMA_VERSION = 2;\n const KEY = \"seoKeywordResearchTool\";\n\n // Initialize database\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n tier TEXT NOT NULL,\n contentGenerated INTEGER NOT NULL,\n aiProvider TEXT,\n apiKey TEXT\n )\n `);\n\n // Helper function to get or create user\n async function getOrCreateUser() {\n let user = (await sqlite.execute(`SELECT * FROM ${KEY}_users_${SCHEMA_VERSION} LIMIT 1`)).rows[0];\n if (!user) {\n await sqlite.execute(`\n INSERT INTO ${KEY}_users_${SCHEMA_VERSION} \n (name, tier, contentGenerated, aiProvider, apiKey) \n VALUES (?, ?, ?, ?, ?)\n `, [\"Demo User\", \"FREE\", 0, \"OpenAI\", \"\"]);\n user = (await sqlite.execute(`SELECT * FROM ${KEY}_users_${SCHEMA_VERSION} LIMIT 1`)).rows[0];\n }\n return user;\n }\n\n // Handle different routes\n if (request.method === \"GET\") {\n const url = new URL(request.url);\n \n // User data route\n if (url.pathname === \"/user\") {\n const user = await getOrCreateUser();\n return new Response(JSON.stringify(user), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n\n // Ad content route (placeholder)\n if (url.pathname === \"/ad\") {\n return new Response(JSON.stringify({ \n content: \"Upgrade to Pro for unlimited AI-powered content generation!\" \n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n }\n\n // POST routes\n if (request.method === \"POST\") {\n const url = new URL(request.url);\n\n // Content generation route\n if (url.pathname === \"/generate\") {\n try {\n const { topic, format, provider, apiKey } = await request.json();\n \n // Get current user\n const user = await getOrCreateUser();\n\n // Check content generation limit\n if (user.contentGenerated >= SUBSCRIPTION_TIERS[user.tier].contentLimit) {\n return new Response(JSON.stringify({ \n error: \"Content generation limit reached. Please upgrade your plan.\" \n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n\n // Generate content using OpenAI\n const completion = await openai.chat.completions.create({\n messages: [\n { \n role: \"system\", \n content: `Generate a ${format} about ${topic}. Provide a professional and engaging piece of content.` \n }\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 500\n });\n\n // Update user's content generation count\n await sqlite.execute(`\n UPDATE ${KEY}_users_${SCHEMA_VERSION} \n SET contentGenerated = contentGenerated + 1 \n WHERE id = ?\n `, [user.id]);\n\n return new Response(JSON.stringify({ \n content: completion.choices[0].message.content \n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n return new Response(JSON.stringify({ \n error: \"Failed to generate content: \" + error.message \n }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n }\n\n // Upgrade subscription route\n if (url.pathname === \"/upgrade\") {\n try {\n const { tier } = await request.json();\n const user = await getOrCreateUser();\n\n await sqlite.execute(`\n UPDATE ${KEY}_users_${SCHEMA_VERSION} \n SET tier = ? \n WHERE id = ?\n `, [tier, user.id]);\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n return new Response(JSON.stringify({ \n success: false, \n error: error.message \n }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n }\n\n // Update user settings route\n if (url.pathname === \"/updateSettings\") {\n try {\n const settings = await request.json();\n const user = await getOrCreateUser();\n\n const updateFields = [];\n const updateValues = [];\n\n if (settings.aiProvider) {\n updateFields.push(\"aiProvider = ?\");\n updateValues.push(settings.aiProvider);\n }\n\n if (settings.apiKey) {\n updateFields.push(\"apiKey = ?\");\n updateValues.push(settings.apiKey);\n }\n\n if (updateFields.length > 0) {\n updateValues.push(user.id);\n await sqlite.execute(`\n UPDATE ${KEY}_users_${SCHEMA_VERSION} \n SET ${updateFields.join(\", \")} \n WHERE id = ?\n `, updateValues);\n }\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n return new Response(JSON.stringify({ \n success: false, \n error: error.message \n }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n }\n }\n\n // Serve HTML\n return new Response(`\n\n\n\n \n \n Webs R AI: AI Content Generator\n \n \n\n\n

\n \n\n\n `, {\n headers: { \"Content-Type\": \"text/html\" }\n });\n}","deleted","label",[98],"permalink","https://www.val.town/x/websrai/seoKeywordResearchTool/code/main.tsx","extension","actionData","errors"]