Implement local user profile viewing

[marcodejongh]

Overview

Aurora's getUser endpoint requires apptoken which is not available. Build local implementation using synced data.

Scope

• Aggregate user stats from local {board}_ascents table
• Display username, logbook count, ascent stats from synced data
• Show public circuits from {board}_circuits table
• Create UI at /[board]/profile/[userId]

Files Involved

• packages/web/app/lib/api-wrappers/aurora/user/getUser.ts (deprecated)
• New: packages/web/app/api/internal/profile/[userId]/route.ts
• New: packages/web/app/[board]/profile/[userId]/page.tsx

Technical Details

• User data already synced via syncUserData to {board}_users table
• Ascent stats can be calculated from local {board}_ascents table
• Circuits already synced to {board}_circuits table

Related

• Part of Aurora API cleanup (all endpoints now require apptoken except sync)