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 = \"lustrousApricotParakeet\";\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","children",[],[152],"files",[150],"counts",{"_174":31,"_175":123,"_176":123,"_177":31},"pulls","branches","forks","envVars","contents",[180],{"_107":151,"_100":152,"_153":154,"_155":-5,"_156":140,"_157":139,"_158":120,"_109":181,"_104":160,"_161":162,"_163":164,"_165":27,"_166":-5,"_103":182},["D",1744933440987],[152],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.branch.$branch.history",{"_98":99,"_100":101,"_102":42,"_105":190,"_194":195,"_271":31,"_272":27},{"_107":108,"_100":101,"_109":191,"_111":-5,"_112":27,"_113":114,"_115":-5,"_116":-5,"_12":117,"_118":-5,"_119":120,"_121":-5,"_122":123,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_133":27,"_21":192,"_137":193},["D",1746195793097],{"_98":99,"_135":136},{"_104":139,"_100":42,"_107":140,"_141":108,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":101,"_147":99},"history",[196,201,209,217,225,233,241,249,257,264],{"_153":154,"_104":139,"_109":197,"_156":140,"_170":198},["D",1744933440987],[199],{"_107":151,"_156":140,"_153":154,"_100":152,"_163":164,"_161":162,"_104":160,"_155":-5,"_109":197,"_157":139,"_166":-5,"_158":120,"_165":27,"_103":200},[152],{"_153":154,"_104":160,"_109":202,"_156":140,"_170":203},["D",1744933393603],[204],{"_107":205,"_156":140,"_153":154,"_100":152,"_163":206,"_161":162,"_104":207,"_155":-5,"_109":202,"_157":160,"_166":-5,"_158":27,"_165":27,"_103":208},"fb4401a4-2760-11f0-86ff-569c3dd06744","/** \n * GirlsWithJuice.com - Complete Social Platform Frontend\n * Comprehensive implementation of core platform features\n */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n// Utility for session management\nasync function getSession(request) {\n const sessionToken = request.headers.get('cookie')?.split('session=')[1]?.split(';')[0];\n if (!sessionToken) return null;\n \n const session = await blob.getJSON(`session_${sessionToken}`);\n return (session && new Date(session.expiresAt) > new Date()) ? session : null;\n}\n\n// Main App Component with Navigation\nfunction App() {\n const [currentView, setCurrentView] = React.useState('feed');\n const [user, setUser] = React.useState(null);\n\n React.useEffect(() => {\n async function fetchUserProfile() {\n try {\n const response = await fetch('/profile');\n const userData = await response.json();\n setUser(userData);\n } catch (error) {\n console.error('Failed to fetch user profile');\n }\n }\n fetchUserProfile();\n }, []);\n\n const renderView = () => {\n switch(currentView) {\n case 'feed': return ;\n case 'create': return ;\n case 'profile': return ;\n case 'notifications': return ;\n default: return ;\n }\n };\n\n return (\n

\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 \n

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

{post.title}

{post.content}

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

\n {JSON.parse(post.options).map(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 setTitle(e.target.value)}\n required \n />\n

setContent(e.target.value)}\n          required\n        />\n        {postType === 'poll' && (\n          <div className=\"poll-option-inputs\">\n            {options.map((option, index) => (\n              <input \n                key={index}\n                type=\"text\" \n                placeholder={`Option ${index + 1}`}\n                value={option}\n                onChange={(e) => {\n                  const newOptions = [...options];\n                  newOptions[index] = e.target.value;\n                  setOptions(newOptions);\n                }}\n                required\n              />\n            ))}\n            <button \n              type=\"button\" \n              onClick={() => setOptions([...options, ''])}\n            >\n              Add Option\n            </button>\n          </div>\n        )}\n        <button type=\"submit\">Create Post</button>\n      </form>\n    </div>\n  );\n}\n\n// Profile Page Component\nfunction ProfilePage({ user }) {\n  if (!user) return <div>Loading profile...</div>;\n\n  return (\n    <div className=\"profile-container\">\n      <div className=\"profile-header\">\n        <img \n          src={user.profilePicture || '/default-avatar.png'} \n          alt=\"Profile\" \n        />\n        <h2>{user.displayName}</h2>\n        <p>Trust Level: {user.userLevel}</p>\n        <p>Points: {user.trustPoints}</p>\n      </div>\n      <div className=\"profile-stats\">\n        <div>Posts: {user.postCount}</div>\n        <div>Votes: {user.voteCount}</div>\n      </div>\n    </div>\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    <div className=\"notifications-container\">\n      {notifications.map(notification => (\n        <div key={notification.id} className=\"notification-item\">\n          {notification.content}\n        </div>\n      ))}\n    </div>\n  );\n}\n\n// Client-side rendering\nfunction client() {\n  createRoot(document.getElementById('root')).render(<App />);\n}\nif (typeof document !== 'undefined') { client(); }\n\n// Server-side handler\nexport default async function server(request: Request): Promise<Response> {\n  const KEY = \"lustrousApricotParakeet\";\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      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    `, [session.userId, session.userId]);\n\n    return new Response(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      headers: { 'Content-Type': 'application/json' }\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      INSERT INTO ${KEY}_posts \n      (user_id, type, title, content, options, tags, closed_at) \n      VALUES (?, ?, ?, ?, ?, ?, datetime('now', '+1 day'))\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    return new Response(JSON.stringify({ \n      success: true,\n      postId: result.lastInsertRowid \n    }), {\n      headers: { 'Content-Type': 'application/json' }\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        SELECT option, COUNT(*) as count \n        FROM ${KEY}_votes \n        WHERE post_id = ? \n        GROUP BY option\n      `, [post.id]);\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(JSON.stringify({ \n      posts: enrichedPosts \n    }), { \n      headers: { 'Content-Type': 'application/json' }\n    });\n  }\n\n  // Serve main application\n  return new Response(`\n    <html>\n      <head>\n        <title>Girls With Juice</title>\n        <script src=\"https://esm.town/v/std/catch\"></script>\n        <style>\n          body {\n            font-family: 'Arial', sans-serif;\n            background: linear-gradient(135deg, #ff6b9e, #ff9a5f);\n            margin: 0;\n            padding: 0;\n            color: #333;\n          }\n          .app-container {\n            max-width: 600px;\n            margin: 0 auto;\n            background: white;\n            min-height: 100vh;\n          }\n          .bottom-nav {\n            position: fixed;\n            bottom: 0;\n            width: 100%;\n            display: flex;\n            background: white;\n            box-shadow: 0 -2px 10px rgba(0,0,0,0.1);\n          }\n          .bottom-nav button {\n            flex: 1;\n            padding: 15px;\n            background: none;\n            border: none;\n            color: #ff6b9e;\n          }\n          .post-card {\n            background: #f9f9f9;\n            margin: 10px;\n            padding: 15px;\n            border-radius: 10px;\n          }\n        </style>\n      </head>\n      <body>\n        <div id=\"root\"></div>\n        <script type=\"module\" src=\"${import.meta.url}\"></script>\n      </body>\n    </html>\n  `, {\n    headers: { 'Content-Type': 'text/html' }\n  });\n}",8,[152],{"_153":154,"_104":207,"_109":210,"_156":140,"_170":211},["D",1744933279166],[212],{"_107":213,"_156":140,"_153":154,"_100":152,"_163":214,"_161":162,"_104":215,"_155":-5,"_109":210,"_157":207,"_166":-5,"_158":27,"_165":27,"_103":216},"fb3d341e-2760-11f0-86ff-569c3dd06744","/**\n * GirlsWithJuice.com - Feed & Interaction HTTP Server\n * Manages user feed, post creation, and interactions\n */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Client-side React 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\n  React.useEffect(() => {\n    async function fetchFeed() {\n      try {\n        const response = await fetch(\"/feed/posts\");\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  }, []);\n\n  const handleVote = async (postId: number, option: string) => {\n    try {\n      await fetch(\"/feed/vote\", {\n        method: \"POST\",\n        headers: { \"Content-Type\": \"application/json\" },\n        body: JSON.stringify({ postId, option }),\n      });\n      // Optimistic update or refetch\n    } catch (err) {\n      console.error(\"Vote failed\");\n    }\n  };\n\n  if (loading) return <div>Loading feed...</div>;\n  if (error) return <div>{error}</div>;\n\n  return (\n    <div className=\"feed-container\">\n      {posts.map(post => (\n        <div key={post.id} className=\"post-card\">\n          <h3>{post.title}</h3>\n          {post.type === \"poll\" && (\n            <div className=\"poll-options\">\n              {post.options.map(option => (\n                <button\n                  key={option}\n                  onClick={() => handleVote(post.id, option)}\n                >\n                  {option}\n                </button>\n              ))}\n            </div>\n          )}\n        </div>\n      ))}\n    </div>\n  );\n}\n\n// Client-side rendering\nfunction client() {\n  createRoot(document.getElementById(\"root\")).render(<FeedPage />);\n}\nif (typeof document !== \"undefined\") { client(); }\n\n// Server-side feed and interaction handlers\nexport default async function server(request: Request): Promise<Response> {\n  const KEY = \"lustrousApricotParakeet\";\n  const openai = new OpenAI();\n  const url = new URL(request.url);\n\n  // Ensure posts table exists\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  // Ensure votes table exists\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  // Retrieve feed posts\n  if (url.pathname === \"/feed/posts\" && request.method === \"GET\") {\n    // Validate user session\n    const sessionToken = request.headers.get(\"cookie\")?.split(\"session=\")[1]?.split(\";\")[0];\n    if (!sessionToken) {\n      return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n        status: 401,\n        headers: { \"Content-Type\": \"application/json\" },\n      });\n    }\n\n    const session = await blob.getJSON(`session_${sessionToken}`);\n    if (!session || new Date(session.expiresAt) < new Date()) {\n      return new Response(JSON.stringify({ error: \"Session expired\" }), {\n        status: 401,\n        headers: { \"Content-Type\": \"application/json\" },\n      });\n    }\n\n    // Fetch posts with AI-enhanced filtering\n    const posts = await sqlite.execute(`\n      SELECT * FROM ${KEY}_posts \n      WHERE closed_at > CURRENT_TIMESTAMP \n      ORDER BY created_at DESC \n      LIMIT 20\n    `);\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  // Handle voting\n  if (url.pathname === \"/feed/vote\" && request.method === \"POST\") {\n    const sessionToken = request.headers.get(\"cookie\")?.split(\"session=\")[1]?.split(\";\")[0];\n    if (!sessionToken) {\n      return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n        status: 401,\n        headers: { \"Content-Type\": \"application/json\" },\n      });\n    }\n\n    const session = await blob.getJSON(`session_${sessionToken}`);\n    if (!session || new Date(session.expiresAt) < new Date()) {\n      return new Response(JSON.stringify({ error: \"Session expired\" }), {\n        status: 401,\n        headers: { \"Content-Type\": \"application/json\" },\n      });\n    }\n\n    const { postId, option } = await request.json();\n\n    // Check if user has already voted\n    const existingVote = await sqlite.execute(\n      `\n      SELECT * FROM ${KEY}_votes \n      WHERE post_id = ? AND user_id = ?\n    `,\n      [postId, session.userId],\n    );\n\n    if (existingVote.rows.length > 0) {\n      return new Response(\n        JSON.stringify({\n          error: \"Already voted\",\n        }),\n        {\n          status: 400,\n          headers: { \"Content-Type\": \"application/json\" },\n        },\n      );\n    }\n\n    // Record vote\n    await sqlite.execute(\n      `\n      INSERT INTO ${KEY}_votes \n      (post_id, user_id, option) \n      VALUES (?, ?, ?)\n    `,\n      [postId, session.userId, option],\n    );\n\n    return new Response(\n      JSON.stringify({\n        success: true,\n      }),\n      {\n        headers: { \"Content-Type\": \"application/json\" },\n      },\n    );\n  }\n\n  // Serve feed page\n  return new Response(\n    `\n    <html>\n      <head>\n        <title>Girls With Juice - Feed</title>\n        <script src=\"https://esm.town/v/std/catch\"></script>\n        <style>\n          body { \n            font-family: 'Arial', sans-serif; \n            background: #f4f4f4;\n            margin: 0;\n            padding: 20px;\n          }\n          .feed-container {\n            max-width: 600px;\n            margin: 0 auto;\n          }\n          .post-card {\n            background: white;\n            border-radius: 10px;\n            padding: 20px;\n            margin-bottom: 15px;\n            box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n          }\n          .poll-options {\n            display: flex;\n            gap: 10px;\n          }\n          button {\n            flex-grow: 1;\n            padding: 10px;\n            background: #ff6b9e;\n            color: white;\n            border: none;\n            border-radius: 5px;\n          }\n        </style>\n      </head>\n      <body>\n        <div id=\"root\"></div>\n        <script type=\"module\" src=\"${import.meta.url}\"></script>\n      </body>\n    </html>\n  `,\n    {\n      headers: { \"Content-Type\": \"text/html\" },\n    },\n  );\n}",7,[152],{"_153":154,"_104":215,"_109":218,"_156":140,"_170":219},["D",1744933239975],[220],{"_107":221,"_156":140,"_153":154,"_100":152,"_163":222,"_161":162,"_104":223,"_155":-5,"_109":218,"_157":215,"_166":-5,"_158":27,"_165":27,"_103":224},"fb377092-2760-11f0-86ff-569c3dd06744","/** \n * GirlsWithJuice.com - Feed & Interaction HTTP Server\n * Manages user feed, post creation, and interactions\n */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n// Client-side React 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\n  React.useEffect(() => {\n    async function fetchFeed() {\n      try {\n        const response = await fetch('/feed/posts');\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  }, []);\n\n  const handleVote = async (postId: number, option: string) => {\n    try {\n      await fetch('/feed/vote', {\n        method: 'POST',\n        headers: { 'Content-Type': 'application/json' },\n        body: JSON.stringify({ postId, option })\n      });\n      // Optimistic update or refetch\n    } catch (err) {\n      console.error('Vote failed');\n    }\n  };\n\n  if (loading) return <div>Loading feed...</div>;\n  if (error) return <div>{error}</div>;\n\n  return (\n    <div className=\"feed-container\">\n      {posts.map(post => (\n        <div key={post.id} className=\"post-card\">\n          <h3>{post.title}</h3>\n          {post.type === 'poll' && (\n            <div className=\"poll-options\">\n              {post.options.map(option => (\n                <button \n                  key={option} \n                  onClick={() => handleVote(post.id, option)}\n                >\n                  {option}\n                </button>\n              ))}\n            </div>\n          )}\n        </div>\n      ))}\n    </div>\n  );\n}\n\n// Client-side rendering\nfunction client() {\n  createRoot(document.getElementById('root')).render(<FeedPage />);\n}\nif (typeof document !== 'undefined') { client(); }\n\n// Server-side feed and interaction handlers\nexport default async function server(request: Request): Promise<Response> {\n  const KEY = \"lustrousApricotParakeet\";\n  const openai = new OpenAI();\n  const url = new URL(request.url);\n\n  // Ensure posts table exists\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  // Ensure votes table exists\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  // Retrieve feed posts\n  if (url.pathname === '/feed/posts' && request.method === 'GET') {\n    // Validate user session\n    const sessionToken = request.headers.get('cookie')?.split('session=')[1]?.split(';')[0];\n    if (!sessionToken) {\n      return new Response(JSON.stringify({ error: 'Unauthorized' }), { \n        status: 401,\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n\n    const session = await blob.getJSON(`session_${sessionToken}`);\n    if (!session || new Date(session.expiresAt) < new Date()) {\n      return new Response(JSON.stringify({ error: 'Session expired' }), { \n        status: 401,\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n\n    // Fetch posts with AI-enhanced filtering\n    const posts = await sqlite.execute(`\n      SELECT * FROM ${KEY}_posts \n      WHERE closed_at > CURRENT_TIMESTAMP \n      ORDER BY created_at DESC \n      LIMIT 20\n    `);\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        SELECT option, COUNT(*) as count \n        FROM ${KEY}_votes \n        WHERE post_id = ? \n        GROUP BY option\n      `, [post.id]);\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(JSON.stringify({ \n      posts: enrichedPosts \n    }), { \n      headers: { 'Content-Type': 'application/json' }\n    });\n  }\n\n  // Handle voting\n  if (url.pathname === '/feed/vote' && request.method === 'POST') {\n    const sessionToken = request.headers.get('cookie')?.split('session=')[1]?.split(';')[0];\n    if (!sessionToken) {\n      return new Response(JSON.stringify({ error: 'Unauthorized' }), { \n        status: 401,\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n\n    const session = await blob.getJSON(`session_${sessionToken}`);\n    if (!session || new Date(session.expiresAt) < new Date()) {\n      return new Response(JSON.stringify({ error: 'Session expired' }), { \n        status: 401,\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n\n    const { postId, option } = await request.json();\n\n    // Check if user has already voted\n    const existingVote = await sqlite.execute(`\n      SELECT * FROM ${KEY}_votes \n      WHERE post_id = ? AND user_id = ?\n    `, [postId, session.userId]);\n\n    if (existingVote.rows.length > 0) {\n      return new Response(JSON.stringify({ \n        error: 'Already voted' \n      }), { \n        status: 400,\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n\n    // Record vote\n    await sqlite.execute(`\n      INSERT INTO ${KEY}_votes \n      (post_id, user_id, option) \n      VALUES (?, ?, ?)\n    `, [postId, session.userId, option]);\n\n    return new Response(JSON.stringify({ \n      success: true \n    }), { \n      headers: { 'Content-Type': 'application/json' }\n    });\n  }\n\n  // Serve feed page\n  return new Response(`\n    <html>\n      <head>\n        <title>Girls With Juice - Feed</title>\n        <script src=\"https://esm.town/v/std/catch\"></script>\n        <style>\n          body { \n            font-family: 'Arial', sans-serif; \n            background: #f4f4f4;\n            margin: 0;\n            padding: 20px;\n          }\n          .feed-container {\n            max-width: 600px;\n            margin: 0 auto;\n          }\n          .post-card {\n            background: white;\n            border-radius: 10px;\n            padding: 20px;\n            margin-bottom: 15px;\n            box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n          }\n          .poll-options {\n            display: flex;\n            gap: 10px;\n          }\n          button {\n            flex-grow: 1;\n            padding: 10px;\n            background: #ff6b9e;\n            color: white;\n            border: none;\n            border-radius: 5px;\n          }\n        </style>\n      </head>\n      <body>\n        <div id=\"root\"></div>\n        <script type=\"module\" src=\"${import.meta.url}\"></script>\n      </body>\n    </html>\n  `, {\n    headers: { 'Content-Type': 'text/html' }\n  });\n}",6,[152],{"_153":154,"_104":223,"_109":226,"_156":140,"_170":227},["D",1744933198716],[228],{"_107":229,"_156":140,"_153":154,"_100":152,"_163":230,"_161":162,"_104":231,"_155":-5,"_109":226,"_157":223,"_166":-5,"_158":27,"_165":27,"_103":232},"fb31acf2-2760-11f0-86ff-569c3dd06744","/** \n * GirlsWithJuice.com - Authentication & User Management HTTP Server\n * Handles user registration, login, and profile management\n */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n// User model definition\ninterface User {\n  id: number;\n  email: string;\n  displayName: string;\n  profilePicture?: string;\n  age?: number;\n  location?: string;\n  interests?: string[];\n  verificationStatus: 'unverified' | 'pending' | 'verified';\n  anonymousPostingEnabled: boolean;\n  trustPoints: number;\n  userLevel: 'Newbie' | 'Trusted Sister' | 'Wisdom Giver';\n}\n\n// Client-side React Components\nfunction AuthenticationForm() {\n  const [email, setEmail] = React.useState('');\n  const [password, setPassword] = React.useState('');\n  const [error, setError] = React.useState('');\n\n  const handleSubmit = async (e: React.FormEvent) => {\n    e.preventDefault();\n    try {\n      const response = await fetch('/auth/login', {\n        method: 'POST',\n        headers: { 'Content-Type': 'application/json' },\n        body: JSON.stringify({ email, password })\n      });\n      const result = await response.json();\n      if (result.success) {\n        window.location.href = '/feed';\n      } else {\n        setError(result.message);\n      }\n    } catch (err) {\n      setError('Authentication failed');\n    }\n  };\n\n  return (\n    <div className=\"auth-container\">\n      <h2>Girls With Juice</h2>\n      <form onSubmit={handleSubmit}>\n        <input \n          type=\"email\" \n          placeholder=\"Email\" \n          value={email}\n          onChange={(e) => setEmail(e.target.value)}\n          required \n        />\n        <input \n          type=\"password\" \n          placeholder=\"Password\" \n          value={password}\n          onChange={(e) => setPassword(e.target.value)}\n          required \n        />\n        {error && <p className=\"error\">{error}</p>}\n        <button type=\"submit\">Login</button>\n      </form>\n    </div>\n  );\n}\n\n// Client-side rendering\nfunction client() {\n  createRoot(document.getElementById('root')).render(<AuthenticationForm />);\n}\nif (typeof document !== 'undefined') { client(); }\n\n// Server-side authentication handlers\nexport default async function server(request: Request): Promise<Response> {\n  const KEY = \"lustrousApricotParakeet\";\n  const openai = new OpenAI();\n\n  // Ensure users table exists\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_users (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      email TEXT UNIQUE NOT NULL,\n      password_hash TEXT NOT NULL,\n      display_name TEXT NOT NULL,\n      profile_picture TEXT,\n      age INTEGER,\n      location TEXT,\n      interests TEXT,\n      verification_status TEXT DEFAULT 'unverified',\n      anonymous_posting BOOLEAN DEFAULT FALSE,\n      trust_points INTEGER DEFAULT 0,\n      user_level TEXT DEFAULT 'Newbie'\n    )\n  `);\n\n  // Handle different authentication routes\n  const url = new URL(request.url);\n  \n  // User Registration\n  if (url.pathname === '/auth/register' && request.method === 'POST') {\n    const { email, password, displayName, selfieUrl } = await request.json();\n\n    // AI-powered gender verification\n    const genderVerification = await openai.chat.completions.create({\n      model: \"gpt-4o-mini\",\n      messages: [\n        {\n          role: \"system\",\n          content: \"Analyze if the uploaded image represents a female. Respond with 'female', 'male', or 'unclear'.\"\n        },\n        {\n          role: \"user\",\n          content: `Image URL: ${selfieUrl}`\n        }\n      ]\n    });\n\n    const genderResult = genderVerification.choices[0].message.content?.toLowerCase();\n\n    if (genderResult !== 'female') {\n      return new Response(JSON.stringify({\n        success: false,\n        message: 'Gender verification failed. Only female users can register.'\n      }), { \n        status: 400,\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n\n    // Password hashing (simplified for demonstration)\n    const passwordHash = await crypto.subtle.digest(\n      'SHA-256', \n      new TextEncoder().encode(password)\n    );\n    const hashHex = Array.from(new Uint8Array(passwordHash))\n      .map(b => b.toString(16).padStart(2, '0'))\n      .join('');\n\n    try {\n      const result = await sqlite.execute(`\n        INSERT INTO ${KEY}_users \n        (email, password_hash, display_name, verification_status) \n        VALUES (?, ?, ?, ?)\n      `, [\n        email, \n        hashHex, \n        displayName, \n        'pending'\n      ]);\n\n      return new Response(JSON.stringify({\n        success: true,\n        userId: result.lastInsertRowid,\n        message: 'Registration pending verification'\n      }), { \n        status: 201,\n        headers: { 'Content-Type': 'application/json' }\n      });\n    } catch (error) {\n      return new Response(JSON.stringify({\n        success: false,\n        message: 'Registration failed'\n      }), { \n        status: 500,\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n  }\n\n  // User Login\n  if (url.pathname === '/auth/login' && request.method === 'POST') {\n    const { email, password } = await request.json();\n\n    // Password hashing (simplified)\n    const passwordHash = await crypto.subtle.digest(\n      'SHA-256', \n      new TextEncoder().encode(password)\n    );\n    const hashHex = Array.from(new Uint8Array(passwordHash))\n      .map(b => b.toString(16).padStart(2, '0'))\n      .join('');\n\n    const userCheck = await sqlite.execute(`\n      SELECT * FROM ${KEY}_users \n      WHERE email = ? AND password_hash = ?\n    `, [email, hashHex]);\n\n    if (userCheck.rows.length > 0) {\n      const user = userCheck.rows[0];\n      \n      // Generate session token\n      const sessionToken = crypto.randomUUID();\n      \n      // Store session (simplified)\n      await blob.setJSON(`session_${sessionToken}`, {\n        userId: user.id,\n        expiresAt: new Date(Date.now() + 24 * 60 * 60 * 1000)\n      });\n\n      return new Response(JSON.stringify({\n        success: true,\n        token: sessionToken,\n        user: {\n          id: user.id,\n          email: user.email,\n          displayName: user.display_name\n        }\n      }), { \n        status: 200,\n        headers: { \n          'Content-Type': 'application/json',\n          'Set-Cookie': `session=${sessionToken}; HttpOnly; Path=/; Max-Age=86400`\n        }\n      });\n    }\n\n    return new Response(JSON.stringify({\n      success: false,\n      message: 'Invalid credentials'\n    }), { \n      status: 401,\n      headers: { 'Content-Type': 'application/json' }\n    });\n  }\n\n  // Serve authentication page\n  return new Response(`\n    <html>\n      <head>\n        <title>Girls With Juice - Authentication</title>\n        <script src=\"https://esm.town/v/std/catch\"></script>\n        <style>\n          body { \n            font-family: 'Arial', sans-serif; \n            background: linear-gradient(135deg, #ff6b9e, #ff9a5f);\n            display: flex;\n            justify-content: center;\n            align-items: center;\n            height: 100vh;\n            margin: 0;\n          }\n          .auth-container {\n            background: white;\n            padding: 30px;\n            border-radius: 15px;\n            box-shadow: 0 10px 25px rgba(0,0,0,0.1);\n            width: 300px;\n          }\n          input {\n            width: 100%;\n            padding: 10px;\n            margin: 10px 0;\n            border: 1px solid #ddd;\n            border-radius: 5px;\n          }\n          button {\n            width: 100%;\n            padding: 10px;\n            background: #ff6b9e;\n            color: white;\n            border: none;\n            border-radius: 5px;\n            cursor: pointer;\n          }\n        </style>\n      </head>\n      <body>\n        <div id=\"root\"></div>\n        <script type=\"module\" src=\"${import.meta.url}\"></script>\n      </body>\n    </html>\n  `, {\n    headers: { 'Content-Type': 'text/html' }\n  });\n}",5,[152],{"_153":154,"_104":231,"_109":234,"_156":140,"_170":235},["D",1744933152960],[236],{"_107":237,"_156":140,"_153":154,"_100":152,"_163":238,"_161":162,"_104":239,"_155":-5,"_109":234,"_157":231,"_166":-5,"_158":27,"_165":27,"_103":240},"fb2bf33e-2760-11f0-86ff-569c3dd06744","/** \n * GirlsWithJuice.com - Notification System\n * Manages user notifications across different interaction types\n */\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { email } from \"https://esm.town/v/std/email\";\n\ninterface NotificationConfig {\n  userId: number;\n  newComments: boolean;\n  pollClosingSoon: boolean;\n  votesReceived: boolean;\n  mentions: boolean;\n  followerUpdates: boolean;\n}\n\nexport async function createNotification(notification: {\n  recipientId: number,\n  type: 'comment' | 'poll' | 'vote' | 'mention' | 'follower',\n  content: string,\n  relatedEntityId?: number\n}) {\n  const KEY = \"lustrousApricotParakeet\";\n\n  // Ensure notifications table exists\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_notifications (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      recipient_id INTEGER NOT NULL,\n      type TEXT NOT NULL,\n      content TEXT NOT NULL,\n      related_entity_id INTEGER,\n      is_read BOOLEAN DEFAULT FALSE,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // Ensure notification preferences table exists\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_notification_preferences (\n      user_id INTEGER PRIMARY KEY,\n      new_comments BOOLEAN DEFAULT TRUE,\n      poll_closing BOOLEAN DEFAULT TRUE,\n      votes_received BOOLEAN DEFAULT TRUE,\n      mentions BOOLEAN DEFAULT TRUE,\n      follower_updates BOOLEAN DEFAULT TRUE\n    )\n  `);\n\n  // Check user's notification preferences\n  const prefCheck = await sqlite.execute(`\n    SELECT * FROM ${KEY}_notification_preferences \n    WHERE user_id = ?\n  `, [notification.recipientId]);\n\n  // If no preferences exist, create default\n  if (prefCheck.rows.length === 0) {\n    await sqlite.execute(`\n      INSERT INTO ${KEY}_notification_preferences \n      (user_id) VALUES (?)\n    `, [notification.recipientId]);\n  }\n\n  // Determine if notification should be sent based on preferences\n  const shouldSendNotification = await sqlite.execute(`\n    SELECT \n      CASE \n        WHEN ? = 'comment' THEN new_comments\n        WHEN ? = 'poll' THEN poll_closing\n        WHEN ? = 'vote' THEN votes_received\n        WHEN ? = 'mention' THEN mentions\n        WHEN ? = 'follower' THEN follower_updates\n        ELSE TRUE\n      END as send_notification\n    FROM ${KEY}_notification_preferences\n    WHERE user_id = ?\n  `, [\n    notification.type, \n    notification.type, \n    notification.type, \n    notification.type, \n    notification.type, \n    notification.recipientId\n  ]);\n\n  // Only create notification if user has enabled that type\n  if (shouldSendNotification.rows[0]?.send_notification) {\n    const result = await sqlite.execute(`\n      INSERT INTO ${KEY}_notifications \n      (recipient_id, type, content, related_entity_id) \n      VALUES (?, ?, ?, ?)\n    `, [\n      notification.recipientId,\n      notification.type,\n      notification.content,\n      notification.relatedEntityId || null\n    ]);\n\n    // Optional: Send email notification\n    try {\n      await email({\n        subject: `New ${notification.type} Notification`,\n        text: notification.content,\n        html: `\n          <div style=\"font-family: Arial, sans-serif; max-width: 600px; margin: auto;\">\n            <h2>Girls With Juice Notification</h2>\n            <p>${notification.content}</p>\n            <a href=\"https://girlswithjuice.com/notifications\">View in App</a>\n          </div>\n        `\n      });\n    } catch (err) {\n      console.error('Email notification failed', err);\n    }\n\n    return {\n      notificationId: result.lastInsertRowid,\n      status: 'created'\n    };\n  }\n\n  return { status: 'skipped' };\n}\n\nexport async function getUserNotifications(userId: number, options?: {\n  limit?: number,\n  onlyUnread?: boolean\n}) {\n  const KEY = \"lustrousApricotParakeet\";\n  const limit = options?.limit || 20;\n\n  const query = `\n    SELECT * FROM ${KEY}_notifications \n    WHERE recipient_id = ?\n    ${options?.onlyUnread ? 'AND is_read = FALSE' : ''}\n    ORDER BY created_at DESC\n    LIMIT ?\n  `;\n\n  const result = await sqlite.execute(query, [userId, limit]);\n\n  return {\n    notifications: result.rows,\n    unreadCount: result.rows.filter(n => !n.is_read).length\n  };\n}\n\nexport async function markNotificationsAsRead(userId: number, notificationIds?: number[]) {\n  const KEY = \"lustrousApricotParakeet\";\n\n  if (notificationIds && notificationIds.length > 0) {\n    // Mark specific notifications as read\n    await sqlite.execute(`\n      UPDATE ${KEY}_notifications \n      SET is_read = TRUE \n      WHERE recipient_id = ? AND id IN (${notificationIds.map(() => '?').join(',')})\n    `, [userId, ...notificationIds]);\n  } else {\n    // Mark all user notifications as read\n    await sqlite.execute(`\n      UPDATE ${KEY}_notifications \n      SET is_read = TRUE \n      WHERE recipient_id = ?\n    `, [userId]);\n  }\n\n  return { status: 'success' };\n}\n\nexport async function updateNotificationPreferences(userId: number, preferences: Partial<NotificationConfig>) {\n  const KEY = \"lustrousApricotParakeet\";\n\n  await sqlite.execute(`\n    INSERT OR REPLACE INTO ${KEY}_notification_preferences \n    (user_id, new_comments, poll_closing, votes_received, mentions, follower_updates)\n    VALUES (?, ?, ?, ?, ?, ?)\n  `, [\n    userId,\n    preferences.newComments ?? true,\n    preferences.pollClosingSoon ?? true,\n    preferences.votesReceived ?? true,\n    preferences.mentions ?? true,\n    preferences.followerUpdates ?? true\n  ]);\n\n  return { status: 'preferences updated' };\n}",4,[152],{"_153":154,"_104":239,"_109":242,"_156":140,"_170":243},["D",1744933109802],[244],{"_107":245,"_156":140,"_153":154,"_100":152,"_163":246,"_161":162,"_104":247,"_155":-5,"_109":242,"_157":239,"_166":-5,"_158":27,"_165":27,"_103":248},"fb267616-2760-11f0-86ff-569c3dd06744","/** \n * GirlsWithJuice.com - Moderation & Reporting System\n * Handles content moderation, user reporting, and safety mechanisms\n */\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Moderation configuration\nconst MODERATION_THRESHOLDS = {\n  SPAM_REPORTS: 3,\n  HARASSMENT_REPORTS: 2,\n  AUTO_SUSPENSION_DURATION: 7 * 24 * 60 * 60 * 1000, // 7 days\n};\n\ninterface ReportData {\n  reporterId: number;\n  reportedUserId: number;\n  postId?: number;\n  commentId?: number;\n  reason: 'spam' | 'harassment' | 'inappropriate' | 'not_female';\n  details?: string;\n}\n\nexport async function reportContent(report: ReportData) {\n  const KEY = \"lustrousApricotParakeet\";\n  const openai = new OpenAI();\n\n  // Ensure reports table exists\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_reports (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      reporter_id INTEGER NOT NULL,\n      reported_user_id INTEGER NOT NULL,\n      post_id INTEGER,\n      comment_id INTEGER,\n      reason TEXT NOT NULL,\n      details TEXT,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n      status TEXT DEFAULT 'pending'\n    )\n  `);\n\n  // Ensure user moderation tracking table exists\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_user_moderation (\n      user_id INTEGER PRIMARY KEY,\n      total_reports INTEGER DEFAULT 0,\n      last_suspension_end DATETIME,\n      is_suspended BOOLEAN DEFAULT FALSE\n    )\n  `);\n\n  // AI-assisted content moderation\n  const contentModerationResult = await openai.chat.completions.create({\n    model: \"gpt-4o-mini\",\n    messages: [\n      {\n        role: \"system\",\n        content: \"Analyze the following content for potential violations of community guidelines. Rate severity from 0-10, where 0 is completely safe and 10 is extremely inappropriate.\"\n      },\n      {\n        role: \"user\",\n        content: report.details || \"No additional details provided\"\n      }\n    ]\n  });\n\n  const moderationSeverity = parseInt(\n    contentModerationResult.choices[0].message.content?.match(/\\d+/)?.[0] || \"0\"\n  );\n\n  // Record the report\n  const reportResult = await sqlite.execute(`\n    INSERT INTO ${KEY}_reports \n    (reporter_id, reported_user_id, post_id, comment_id, reason, details, status) \n    VALUES (?, ?, ?, ?, ?, ?, ?)\n  `, [\n    report.reporterId,\n    report.reportedUserId,\n    report.postId || null,\n    report.commentId || null,\n    report.reason,\n    report.details || null,\n    moderationSeverity > 5 ? 'urgent' : 'pending'\n  ]);\n\n  // Update user moderation tracking\n  const userModerationResult = await sqlite.execute(`\n    INSERT OR REPLACE INTO ${KEY}_user_moderation \n    (user_id, total_reports, is_suspended)\n    VALUES (\n      ?,\n      COALESCE((SELECT total_reports FROM ${KEY}_user_moderation WHERE user_id = ?) + 1, 1),\n      CASE \n        WHEN COALESCE((SELECT total_reports FROM ${KEY}_user_moderation WHERE user_id = ?) + 1, 1) >= ? \n        THEN 1 \n        ELSE 0 \n      END\n    )\n  `, [\n    report.reportedUserId,\n    report.reportedUserId,\n    report.reportedUserId,\n    report.reason === 'harassment' \n      ? MODERATION_THRESHOLDS.HARASSMENT_REPORTS \n      : MODERATION_THRESHOLDS.SPAM_REPORTS\n  ]);\n\n  // Automatic suspension logic\n  if (moderationSeverity > 7) {\n    await sqlite.execute(`\n      UPDATE ${KEY}_user_moderation\n      SET \n        is_suspended = 1,\n        last_suspension_end = datetime('now', '+7 days')\n      WHERE user_id = ?\n    `, [report.reportedUserId]);\n  }\n\n  return {\n    reportId: reportResult.lastInsertRowid,\n    moderationSeverity,\n    status: moderationSeverity > 5 ? 'urgent review' : 'standard review'\n  };\n}\n\nexport async function checkUserSuspensionStatus(userId: number) {\n  const KEY = \"lustrousApricotParakeet\";\n\n  const suspensionCheck = await sqlite.execute(`\n    SELECT \n      is_suspended, \n      last_suspension_end,\n      total_reports\n    FROM ${KEY}_user_moderation\n    WHERE user_id = ?\n  `, [userId]);\n\n  const suspensionData = suspensionCheck.rows[0];\n\n  if (!suspensionData) return { isSuspended: false };\n\n  // Check if suspension has expired\n  if (suspensionData.is_suspended) {\n    const suspensionEnd = new Date(suspensionData.last_suspension_end);\n    const now = new Date();\n\n    if (now > suspensionEnd) {\n      // Automatically lift suspension\n      await sqlite.execute(`\n        UPDATE ${KEY}_user_moderation\n        SET \n          is_suspended = 0,\n          last_suspension_end = NULL,\n          total_reports = 0\n        WHERE user_id = ?\n      `, [userId]);\n\n      return { \n        isSuspended: false, \n        previousReports: suspensionData.total_reports \n      };\n    }\n\n    return {\n      isSuspended: true,\n      suspensionEnd: suspensionEnd,\n      remainingTime: suspensionEnd.getTime() - new Date().getTime()\n    };\n  }\n\n  return { isSuspended: false };\n}\n\nexport async function appealSuspension(userId: number, appealDetails: string) {\n  const KEY = \"lustrousApricotParakeet\";\n  const openai = new OpenAI();\n\n  // Ensure appeals table exists\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_suspension_appeals (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      user_id INTEGER NOT NULL,\n      appeal_details TEXT NOT NULL,\n      status TEXT DEFAULT 'pending',\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // AI-assisted appeal evaluation\n  const appealEvaluation = await openai.chat.completions.create({\n    model: \"gpt-4o-mini\",\n    messages: [\n      {\n        role: \"system\",\n        content: \"Evaluate the following suspension appeal. Provide a recommendation (approve/deny) and a brief rationale.\"\n      },\n      {\n        role: \"user\",\n        content: appealDetails\n      }\n    ]\n  });\n\n  const appealResult = await sqlite.execute(`\n    INSERT INTO ${KEY}_suspension_appeals \n    (user_id, appeal_details, status) \n    VALUES (?, ?, ?)\n  `, [\n    userId, \n    appealDetails, \n    appealEvaluation.choices[0].message.content?.toLowerCase().includes('approve') \n      ? 'approved' \n      : 'denied'\n  ]);\n\n  return {\n    appealId: appealResult.lastInsertRowid,\n    status: appealEvaluation.choices[0].message.content?.toLowerCase().includes('approve') \n      ? 'approved' \n      : 'denied',\n    recommendation: appealEvaluation.choices[0].message.content\n  };\n}",3,[152],{"_153":154,"_104":247,"_109":250,"_156":140,"_170":251},["D",1744933000109],[252],{"_107":253,"_156":140,"_153":154,"_100":152,"_163":254,"_161":162,"_104":255,"_155":-5,"_109":250,"_157":247,"_166":-5,"_158":27,"_165":27,"_103":256},"fb20d0d0-2760-11f0-86ff-569c3dd06744","/** \n * GirlsWithJuice.com - Interaction & Trust Points System\n * Manages user interactions, trust points, and user levels\n */\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\n\n// Trust points configuration\nconst TRUST_POINTS = {\n  VOTE: 1,\n  COMMENT: 2,\n  BEST_ADVICE: 5,\n  POST_CREATED: 3,\n  DOWNVOTE_PENALTY: -1\n};\n\nconst USER_LEVELS = [\n  { name: 'Newbie', minPoints: 0 },\n  { name: 'Trusted Sister', minPoints: 50 },\n  { name: 'Wisdom Giver', minPoints: 100 }\n];\n\nexport async function recordInteraction(interaction: {\n  postId: number,\n  userId: number,\n  interactionType: 'vote' | 'comment' | 'reaction' | 'best_advice',\n  value?: string\n}) {\n  const KEY = \"lustrousApricotParakeet\";\n\n  // Ensure interactions table exists\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_interactions (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      post_id INTEGER NOT NULL,\n      user_id INTEGER NOT NULL,\n      interaction_type TEXT NOT NULL,\n      value TEXT,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // Ensure trust points table exists\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_trust_points (\n      user_id INTEGER PRIMARY KEY,\n      total_points INTEGER DEFAULT 0,\n      current_level TEXT DEFAULT 'Newbie'\n    )\n  `);\n\n  // Record interaction\n  const interactionResult = await sqlite.execute(`\n    INSERT INTO ${KEY}_interactions \n    (post_id, user_id, interaction_type, value) \n    VALUES (?, ?, ?, ?)\n  `, [\n    interaction.postId, \n    interaction.userId, \n    interaction.interactionType,\n    interaction.value || null\n  ]);\n\n  // Calculate trust points based on interaction type\n  let pointsEarned = 0;\n  switch (interaction.interactionType) {\n    case 'vote': pointsEarned = TRUST_POINTS.VOTE; break;\n    case 'comment': pointsEarned = TRUST_POINTS.COMMENT; break;\n    case 'best_advice': pointsEarned = TRUST_POINTS.BEST_ADVICE; break;\n  }\n\n  // Update user's trust points\n  await sqlite.execute(`\n    INSERT OR REPLACE INTO ${KEY}_trust_points \n    (user_id, total_points, current_level)\n    VALUES (\n      ?, \n      COALESCE((SELECT total_points FROM ${KEY}_trust_points WHERE user_id = ?) + ?, 0),\n      (\n        SELECT \n          CASE \n            WHEN COALESCE((SELECT total_points FROM ${KEY}_trust_points WHERE user_id = ?) + ?, 0) >= 100 THEN 'Wisdom Giver'\n            WHEN COALESCE((SELECT total_points FROM ${KEY}_trust_points WHERE user_id = ?) + ?, 0) >= 50 THEN 'Trusted Sister'\n            ELSE 'Newbie'\n          END\n      )\n    )\n  `, [\n    interaction.userId, \n    interaction.userId, pointsEarned,\n    interaction.userId, pointsEarned,\n    interaction.userId, pointsEarned\n  ]);\n\n  return {\n    interactionId: interactionResult.lastInsertRowid,\n    pointsEarned: pointsEarned\n  };\n}\n\nexport async function getUserTrustProfile(userId: number) {\n  const KEY = \"lustrousApricotParakeet\";\n\n  const userPoints = await sqlite.execute(`\n    SELECT * FROM ${KEY}_trust_points \n    WHERE user_id = ?\n  `, [userId]);\n\n  const userInteractions = await sqlite.execute(`\n    SELECT interaction_type, COUNT(*) as count \n    FROM ${KEY}_interactions \n    WHERE user_id = ? \n    GROUP BY interaction_type\n  `, [userId]);\n\n  return {\n    userId,\n    totalPoints: userPoints.rows[0]?.total_points || 0,\n    currentLevel: userPoints.rows[0]?.current_level || 'Newbie',\n    interactions: userInteractions.rows.reduce((acc, row) => {\n      acc[row.interaction_type] = row.count;\n      return acc;\n    }, {})\n  };\n}\n\nexport async function markBestAdvice(postId: number, commentId: number, userId: number) {\n  const KEY = \"lustrousApricotParakeet\";\n\n  // Mark comment as best advice\n  await sqlite.execute(`\n    UPDATE ${KEY}_interactions \n    SET interaction_type = 'best_advice' \n    WHERE id = ? AND post_id = ?\n  `, [commentId, postId]);\n\n  // Award trust points to the commenter\n  return recordInteraction({\n    postId,\n    userId,\n    interactionType: 'best_advice'\n  });\n}",2,[152],{"_153":154,"_104":255,"_109":258,"_156":140,"_170":259},["D",1744932940595],[260],{"_107":261,"_156":140,"_153":154,"_100":152,"_163":262,"_161":162,"_104":123,"_155":-5,"_109":258,"_157":255,"_166":-5,"_158":27,"_165":27,"_103":263},"fb1b95a2-2760-11f0-86ff-569c3dd06744","/** \n * GirlsWithJuice.com - Feed and Posting Service\n * Handles post creation, retrieval, and interaction tracking\n */\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Post type definitions\ntype PostType = 'poll_2choice' | 'poll_multichoice' | 'open_question' | 'image_comparison';\n\ninterface Post {\n  id: number;\n  userId: number;\n  type: PostType;\n  content: string;\n  imageUrls?: string[];\n  tags: string[];\n  pollOptions?: string[];\n  pollDuration?: number; // hours\n  commentsEnabled: boolean;\n  anonymousPosting: boolean;\n  createdAt: Date;\n  closedAt?: Date;\n}\n\ninterface PostInteraction {\n  postId: number;\n  userId: number;\n  interactionType: 'vote' | 'comment' | 'reaction';\n  value?: string;\n}\n\nexport default async function createPost(postData: Partial<Post>) {\n  const openai = new OpenAI();\n  const KEY = \"lustrousApricotParakeet\";\n\n  // Ensure posts and interactions tables exist\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      content TEXT NOT NULL,\n      image_urls TEXT,\n      tags TEXT,\n      poll_options TEXT,\n      poll_duration INTEGER,\n      comments_enabled BOOLEAN DEFAULT TRUE,\n      anonymous_posting BOOLEAN DEFAULT FALSE,\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}_post_interactions (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      post_id INTEGER NOT NULL,\n      user_id INTEGER NOT NULL,\n      interaction_type TEXT NOT NULL,\n      value TEXT,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // Validate required fields\n  if (!postData.userId || !postData.content || !postData.type) {\n    throw new Error(\"Missing required post fields\");\n  }\n\n  // AI-assisted tag generation\n  const tagSuggestion = await openai.chat.completions.create({\n    model: \"gpt-4o-mini\",\n    messages: [\n      {\n        role: \"system\", \n        content: \"Extract 1-3 relevant tags from the following text. Choose from: Fashion, Love, Health, Work, Friendship, Mental Wellness, Self-Care, Confidence\"\n      },\n      {\n        role: \"user\", \n        content: postData.content || \"\"\n      }\n    ]\n  });\n\n  const aiTags = tagSuggestion.choices[0].message.content?.split(',')\n    .map(tag => tag.trim().toLowerCase()) || [];\n\n  // Merge AI tags with user-provided tags\n  const finalTags = [...new Set([...aiTags, ...(postData.tags || [])])].slice(0, 3);\n\n  // Calculate post duration (default 24 hours)\n  const pollDuration = postData.pollDuration || 24;\n  const closedAt = new Date(Date.now() + pollDuration * 60 * 60 * 1000);\n\n  // Insert post\n  const result = await sqlite.execute(`\n    INSERT INTO ${KEY}_posts \n    (user_id, type, content, image_urls, tags, poll_options, poll_duration, comments_enabled, anonymous_posting, closed_at) \n    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n  `, [\n    postData.userId,\n    postData.type,\n    postData.content,\n    postData.imageUrls ? JSON.stringify(postData.imageUrls) : null,\n    JSON.stringify(finalTags),\n    postData.pollOptions ? JSON.stringify(postData.pollOptions) : null,\n    pollDuration,\n    postData.commentsEnabled ?? true,\n    postData.anonymousPosting ?? false,\n    closedAt\n  ]);\n\n  return {\n    postId: result.lastInsertRowid,\n    tags: finalTags,\n    message: \"Post created successfully\",\n    closesAt: closedAt\n  };\n}\n\n// Helper function to retrieve feed\nexport async function getFeed(options: {\n  tags?: string[], \n  sortBy?: 'trending' | 'newest', \n  page?: number\n}) {\n  const KEY = \"lustrousApricotParakeet\";\n  const pageSize = 20;\n  const offset = (options.page || 0) * pageSize;\n\n  let query = `\n    SELECT * FROM ${KEY}_posts \n    WHERE closed_at > CURRENT_TIMESTAMP\n  `;\n\n  const params: any[] = [];\n\n  if (options.tags && options.tags.length > 0) {\n    query += ` AND (${options.tags.map(() => \"tags LIKE ?\").join(' OR ')})`;\n    params.push(...options.tags.map(tag => `%${tag}%`));\n  }\n\n  query += options.sortBy === 'trending' \n    ? ` ORDER BY (SELECT COUNT(*) FROM ${KEY}_post_interactions WHERE post_id = id) DESC`\n    : ` ORDER BY created_at DESC`;\n\n  query += ` LIMIT ? OFFSET ?`;\n  params.push(pageSize, offset);\n\n  const result = await sqlite.execute(query, params);\n  \n  return {\n    posts: result.rows,\n    nextPage: result.rows.length === pageSize ? (options.page || 0) + 1 : null\n  };\n}",[152],{"_153":154,"_104":123,"_109":265,"_156":140,"_170":266},["D",1744932879248],[267],{"_107":268,"_156":140,"_153":154,"_100":152,"_163":269,"_161":162,"_104":31,"_155":-5,"_109":265,"_157":123,"_166":-5,"_158":27,"_165":27,"_103":270},"fb15b9de-2760-11f0-86ff-569c3dd06744","/** \n * GirlsWithJuice.com - User Registration & Authentication Service\n * Core user management and verification infrastructure\n */\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// User model definition\ninterface User {\n  id: number;\n  email: string;\n  displayName: string;\n  age?: number;\n  location?: string;\n  interests?: string[];\n  verificationStatus: 'unverified' | 'pending' | 'verified';\n  anonymousPostingEnabled: boolean;\n  trustPoints: number;\n  userLevel: 'Newbie' | 'Trusted Sister' | 'Wisdom Giver';\n}\n\nexport default async function userRegistration(userData: Partial<User>) {\n  const openai = new OpenAI();\n  const KEY = \"lustrousApricotParakeet\";\n\n  // Ensure users table exists\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_users (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      email TEXT UNIQUE NOT NULL,\n      display_name TEXT NOT NULL,\n      age INTEGER,\n      location TEXT,\n      interests TEXT,\n      verification_status TEXT DEFAULT 'unverified',\n      anonymous_posting BOOLEAN DEFAULT FALSE,\n      trust_points INTEGER DEFAULT 0,\n      user_level TEXT DEFAULT 'Newbie'\n    )\n  `);\n\n  // Basic input validation\n  if (!userData.email || !userData.displayName) {\n    throw new Error(\"Email and display name are required\");\n  }\n\n  // AI-assisted name validation for female-centric platform\n  const nameValidation = await openai.chat.completions.create({\n    model: \"gpt-4o-mini\",\n    messages: [\n      {\n        role: \"system\", \n        content: \"Determine if this name is traditionally or commonly associated with female gender. Respond with 'female', 'male', or 'neutral'.\"\n      },\n      {\n        role: \"user\", \n        content: userData.displayName || \"\"\n      }\n    ]\n  });\n\n  const genderHint = nameValidation.choices[0].message.content?.toLowerCase();\n  \n  // Optional: Add gender hint to user verification process\n  const verificationStatus = genderHint === 'female' \n    ? 'pending' \n    : 'unverified';\n\n  // Insert user with initial verification status\n  const result = await sqlite.execute(`\n    INSERT INTO ${KEY}_users \n    (email, display_name, verification_status, trust_points) \n    VALUES (?, ?, ?, ?)\n  `, [\n    userData.email, \n    userData.displayName, \n    verificationStatus,\n    0\n  ]);\n\n  return {\n    userId: result.lastInsertRowid,\n    verificationStatus,\n    message: verificationStatus === 'pending' \n      ? \"User registered. Additional verification required.\" \n      : \"User registered successfully.\"\n  };\n}",[152],"page","hasNext","routes/_app","actionData","errors"]
</article></body></html>

History