[TODO Import][Server][Backlog] Advanced rankings APIs and filters

[ferneediaz]

Imported from server/TODO.md.

Kanban

• Column: Backlog
• Area: Server

📋 TODO - Advanced Rankings (MEDIUM PRIORITY)

Enhanced leaderboard features.

Task Breakdown:

1. Time-based Rankings

• Daily leaderboard (filter by games played today)
• Weekly leaderboard
• Monthly leaderboard
• All-time leaderboard (already exists)
• Success Criteria: Time-based queries working ✅

2. Ranking APIs

• GET /api/rankings/global?period=daily|weekly|monthly|alltime
• GET /api/rankings/clans
• GET /api/rankings/friends — Leaderboard among friends (requires friends system)
• Filter by language (most wins with specific language)
• Success Criteria: API tests passing ✅

3. Tests

• Time-based filter tests
• Clan ranking tests
• Friends ranking tests
• Language filter tests
• Success Criteria: All ranking tests passing ✅

---