Girls With Juice

\n {renderView()}\n \n

\n );\n}\n\n// Enhanced Feed Component\nfunction FeedPage() {\n const [posts, setPosts] = React.useState([]);\n const [loading, setLoading] = React.useState(true);\n const [error, setError] = React.useState(null);\n const [filters, setFilters] = React.useState({\n tags: [],\n sortBy: \"newest\",\n });\n\n React.useEffect(() => {\n async function fetchFeed() {\n try {\n const response = await fetch(\"/feed/posts\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(filters),\n });\n const data = await response.json();\n setPosts(data.posts);\n setLoading(false);\n } catch (err) {\n setError(\"Failed to load feed\");\n setLoading(false);\n }\n }\n fetchFeed();\n }, [filters]);\n\n const handleVote = async (postId, option) => {\n try {\n const response = await fetch(\"/feed/vote\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ postId, option }),\n });\n const result = await response.json();\n\n if (result.success) {\n // Optimistically update UI\n setPosts(posts.map(post =>\n post.id === postId\n ? {\n ...post,\n votes: {\n ...post.votes,\n [option]: (post.votes[option] || 0) + 1,\n },\n }\n : post\n ));\n }\n } catch (err) {\n console.error(\"Vote failed\");\n }\n };\n\n if (loading) return

Loading feed...

;\n if (error) return

{error}

;\n\n return (\n

\n setFilters({ ...filters, sortBy: e.target.value })}\n >\n \n \n \n

\n {posts.map(post => (\n

{post.title}

{post.content}

\n {post.type === \"poll\" && (\n

\n {JSON.parse(post.options).map(option => (\n handleVote(post.id, option)}\n >\n {option}\n {post.votes?.[option] && `(${post.votes[option]})`}\n \n ))}\n

\n )}\n

\n ))}\n

\n );\n}\n\n// Create Post Component\nfunction CreatePostPage() {\n const [postType, setPostType] = React.useState(\"poll\");\n const [title, setTitle] = React.useState(\"\");\n const [content, setContent] = React.useState(\"\");\n const [options, setOptions] = React.useState([\"\", \"\"]);\n const [tags, setTags] = React.useState([]);\n\n const handleSubmit = async (e) => {\n e.preventDefault();\n try {\n const response = await fetch(\"/feed/create-post\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n type: postType,\n title,\n content,\n options: postType === \"poll\" ? options : null,\n tags,\n }),\n });\n const result = await response.json();\n if (result.success) {\n // Redirect or show success message\n alert(\"Post created successfully!\");\n }\n } catch (err) {\n console.error(\"Post creation failed\");\n }\n };\n\n return (\n

\n );\n}\n\n// Profile Page Component\nfunction ProfilePage({ user }) {\n if (!user) return

Loading profile...

;\n\n return (\n

\n \n

{user.displayName}

Trust Level: {user.userLevel}

Points: {user.trustPoints}

Posts: {user.postCount}

Votes: {user.voteCount}

\n );\n}\n\n// Notifications Page Component\nfunction NotificationsPage() {\n const [notifications, setNotifications] = React.useState([]);\n\n React.useEffect(() => {\n async function fetchNotifications() {\n try {\n const response = await fetch(\"/notifications\");\n const data = await response.json();\n setNotifications(data.notifications);\n } catch (err) {\n console.error(\"Failed to fetch notifications\");\n }\n }\n fetchNotifications();\n }, []);\n\n return (\n

\n {notifications.map(notification => (\n

\n {notification.content}\n

\n ))}\n

\n );\n}\n\n// Client-side rendering\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\n// Server-side handler\nexport default async function server(request: Request): Promise {\n const KEY = \"Girlswithjuice\";\n const openai = new OpenAI();\n const url = new URL(request.url);\n\n // Comprehensive database setup\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_posts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n type TEXT NOT NULL,\n title TEXT NOT NULL,\n content TEXT,\n options TEXT,\n tags TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n closed_at DATETIME\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_votes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n post_id INTEGER NOT NULL,\n user_id INTEGER NOT NULL,\n option TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Profile route\n if (url.pathname === \"/profile\" && request.method === \"GET\") {\n const session = await getSession(request);\n if (!session) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const userStats = await sqlite.execute(\n `\n SELECT \n (SELECT COUNT(*) FROM ${KEY}_posts WHERE user_id = ?) as post_count,\n (SELECT COUNT(*) FROM ${KEY}_votes WHERE user_id = ?) as vote_count\n `,\n [session.userId, session.userId],\n );\n\n return new Response(\n JSON.stringify({\n displayName: session.displayName,\n userLevel: session.userLevel,\n trustPoints: session.trustPoints,\n postCount: userStats.rows[0].post_count,\n voteCount: userStats.rows[0].vote_count,\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n // Create post route\n if (url.pathname === \"/feed/create-post\" && request.method === \"POST\") {\n const session = await getSession(request);\n if (!session) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const { type, title, content, options, tags } = await request.json();\n\n const result = await sqlite.execute(\n `\n INSERT INTO ${KEY}_posts \n (user_id, type, title, content, options, tags, closed_at) \n VALUES (?, ?, ?, ?, ?, ?, datetime('now', '+1 day'))\n `,\n [\n session.userId,\n type,\n title,\n content,\n options ? JSON.stringify(options) : null,\n tags ? JSON.stringify(tags) : null,\n ],\n );\n\n return new Response(\n JSON.stringify({\n success: true,\n postId: result.lastInsertRowid,\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n // Feed posts route with enhanced filtering\n if (url.pathname === \"/feed/posts\" && request.method === \"POST\") {\n const session = await getSession(request);\n if (!session) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const { tags, sortBy } = await request.json();\n\n let query = `\n SELECT * FROM ${KEY}_posts \n WHERE closed_at > CURRENT_TIMESTAMP\n `;\n\n const queryParams = [];\n\n if (tags && tags.length > 0) {\n query += ` AND (${tags.map(() => \"tags LIKE ?\").join(\" OR \")})`;\n queryParams.push(...tags.map(tag => `%${tag}%`));\n }\n\n query += sortBy === \"trending\"\n ? ` ORDER BY (SELECT COUNT(*) FROM ${KEY}_votes WHERE post_id = id) DESC`\n : ` ORDER BY created_at DESC`;\n\n query += ` LIMIT 20`;\n\n const posts = await sqlite.execute(query, queryParams);\n\n // Enrich posts with vote counts\n const enrichedPosts = await Promise.all(posts.rows.map(async post => {\n const votes = await sqlite.execute(\n `\n SELECT option, COUNT(*) as count \n FROM ${KEY}_votes \n WHERE post_id = ? \n GROUP BY option\n `,\n [post.id],\n );\n\n return {\n ...post,\n votes: votes.rows.reduce((acc, row) => {\n acc[row.option] = row.count;\n return acc;\n }, {}),\n };\n }));\n\n return new Response(\n JSON.stringify({\n posts: enrichedPosts,\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n // Serve main application\n return new Response(\n `\n \n \n Girls With Juice\n \n \n \n \n

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