\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",[],[183],"files",[151,172,181],"counts",{"_194":31,"_195":162,"_196":31,"_197":31},"pulls","branches","forks","envVars","contents",[200,203,206],{"_107":152,"_100":153,"_154":155,"_156":-5,"_157":140,"_158":159,"_160":121,"_109":201,"_104":162,"_163":164,"_165":166,"_167":27,"_168":-5,"_103":202},["D",1741977261599],[153],{"_107":173,"_100":174,"_154":175,"_156":-5,"_157":140,"_158":176,"_160":121,"_109":204,"_104":31,"_163":164,"_165":178,"_167":27,"_168":-5,"_103":205},["D",1741977282452],[174],{"_107":182,"_100":183,"_154":119,"_156":-5,"_157":140,"_158":139,"_160":121,"_109":207,"_104":185,"_163":186,"_165":187,"_167":27,"_168":-5,"_103":208},["D",1741978023252],[183],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name._index",{"_98":99,"_100":101,"_102":-7,"_104":-7,"_105":215,"_198":219,"_226":-7,"_227":-5,"_228":-5,"_190":229,"_239":240},{"_107":108,"_100":101,"_109":216,"_111":-5,"_112":27,"_113":114,"_115":-5,"_116":-5,"_12":117,"_118":119,"_120":121,"_122":-5,"_123":31,"_14":124,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":126,"_21":217,"_137":218,"_148":27},["D",1741977075296],{"_98":99,"_135":136},{"_104":139,"_100":42,"_107":140,"_141":108,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":101,"_147":99},[220,222,224],{"_107":152,"_100":153,"_154":155,"_156":-5,"_157":140,"_158":159,"_160":121,"_109":201,"_104":162,"_163":164,"_165":166,"_167":27,"_168":-5,"_103":221},[153],{"_107":173,"_100":174,"_154":175,"_156":-5,"_157":140,"_158":176,"_160":121,"_109":204,"_104":31,"_163":164,"_165":178,"_167":27,"_168":-5,"_103":223},[174],{"_107":182,"_100":183,"_154":119,"_156":-5,"_157":140,"_158":139,"_160":121,"_109":207,"_104":185,"_163":186,"_165":187,"_167":27,"_168":-5,"_103":225},[183],"readme","upstream","pull",[230,233,236],{"_107":152,"_100":153,"_154":155,"_156":-5,"_157":140,"_158":159,"_160":121,"_109":161,"_104":162,"_163":164,"_165":166,"_167":27,"_168":-5,"_169":231,"_103":232},[],[153],{"_107":173,"_100":174,"_154":175,"_156":-5,"_157":140,"_158":176,"_160":121,"_109":177,"_104":31,"_163":164,"_165":178,"_167":27,"_168":-5,"_169":234,"_103":235},[],[174],{"_107":182,"_100":183,"_154":119,"_156":-5,"_157":140,"_158":139,"_160":121,"_109":184,"_104":185,"_163":186,"_165":187,"_167":27,"_168":-5,"_169":237,"_103":238},[],[183],"previews",[236],"routes/_app","actionData","errors"]