\n ${profile.display_name}$ \n

{profile.display_name}

Mood: {profile.mood}

Online Now!

\n View My Pics\n My Videos\n Read My Blog\n My Friends Space\n

♫ Now Playing:

{profile.profile_song}

Profile Views: {visitCount}

Last Login: Today

\n);\n\nconst FriendsList = ({ friends }) => (\n

My Friends ({friends.length})

\n {friends.map((friend) => (\n

\n ${friend.display_name}$ \n

{friend.display_name}

\n ))}\n

\n);\n\nconst CommentSection = ({ comments, profileId }) => (\n

Comments

\n \n

\n {comments.map((comment) => (\n

\n {comment.author_name}\n {new Date(comment.created_at).toLocaleDateString()}\n

{comment.content}

\n ))}\n

\n);\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n const params = url.searchParams;\n\n // Handle different routes\n if (path === '/comment' && req.method === 'POST') {\n const formData = await req.formData();\n const comment = formData.get('comment')?.toString() || '';\n const profileId = parseInt(params.get('profile') || '1', 10);\n\n // Default to user 1 (Tom) as author for demo\n const authorId = 1;\n\n await sqlite.execute(\n `INSERT INTO ${commentsTable} (profile_id, author_id, content) VALUES (?, ?, ?)`,\n [profileId, authorId, comment]\n );\n\n return new Response(null, {\n status: 302,\n headers: {\n \"Location\": `/?profile=${profileId}`\n }\n });\n }\n\n // Get profile to display (default: Tom)\n const profileId = parseInt(params.get('profile') || '1', 10);\n\n // Fetch profile data\n const profileResult = await sqlite.execute(\n `SELECT * FROM ${profileTable} WHERE id = ?`,\n [profileId]\n );\n\n if (profileResult.rows.length === 0) {\n return new Response(\"Profile not found\", { status: 404 });\n }\n\n const profile = profileResult.rows[0];\n\n // Fetch visit count for the profile\n const visitsResult = await sqlite.execute(\n `SELECT COUNT(*) as visit_count FROM ${visitsTable} WHERE profile_id = ?`,\n [profileId]\n );\n\n const visitCount = visitsResult.rows[0]?.visit_count || 0;\n\n // Fetch friends (for demo, just show some fake friends)\n const demoFriends = [\n { id: 2, display_name: \"Chris\" },\n { id: 3, display_name: \"Ashley\" },\n { id: 4, display_name: \"Jordan\" },\n { id: 5, display_name: \"Taylor\" },\n { id: 6, display_name: \"Morgan\" },\n { id: 7, display_name: \"Alex\" },\n { id: 8, display_name: \"Jamie\" },\n ];\n\n // Fetch comments\n const commentsResult = await sqlite.execute(\n `SELECT c.*, p.display_name as author_name\n FROM ${commentsTable} c\n JOIN ${profileTable} p ON c.author_id = p.id\n WHERE c.profile_id = ?\n ORDER BY c.created_at DESC`,\n [profileId]\n );\n\n const comments = commentsResult.rows;\n\n // Record page visit (for demo purposes)\n await sqlite.execute(\n `INSERT INTO ${visitsTable} (profile_id, visitor_id) VALUES (?, ?)`,\n [profileId, 1]\n );\n\n return new Response(\n renderToString(\n \n

\n \n\n

{`${profile.display_name}'s Space`}

\n {`🎵 ${profile.profile_song} 🎵 Welcome to my MySpace profile! Thanks for visiting! 🎵`}\n

\n {`★☆★ ${profile.bio} ★☆★`}\n

\n\n \n\n

About Me

Who I'd like to meet: Fun people who like to code!

Interests: Web development, retro computing, Y2K aesthetics

\n\n \n

\n\n

Online Friends

Tom is online

Chris is online

\n\n

Bulletin Board

⭐ Check out my new blog post!

💿 Added new songs to my profile!

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