Leaderboard API Endpoints

Current Season Cron Job

The current season leaderboard data is updated every 10 seconds via a cron job.

Setup

Set up a cron job to call the update endpoint every 10 seconds:

# Example using curl in a cron job or scheduled task
*/10 * * * * curl -X GET "https://your-domain.com/api/leaderboardAPI/update-current-season?secret=YOUR_SECRET"

Environment Variable (optional but recommended):
- Set LEADERBOARD_CRON_SECRET in your environment variables
- This secret should be passed as a query parameter to secure the endpoint

Endpoints

`GET /api/leaderboardAPI/update-current-season`

Purpose: Cron job endpoint to fetch and cache current season leaderboard data
Frequency: Should be called every 10 seconds
Authentication: Optional secret token via ?secret=YOUR_SECRET query parameter
Response: JSON with update status for each server

`GET /api/leaderboardAPI/current-season?server=all`

Purpose: Get cached current season leaderboard data
Used by: Client-side store to fetch current season data
Parameters:
- server (optional): Server ID (default: “all”)
Response: JSON with leaderboard data array

How It Works

Cron Job (update-current-season):
- Fetches current season data from Tinybird API for all servers
- Updates the in-memory cache
- Runs every 10 seconds
Cache API (current-season):
- Returns cached data if available (updated by cron job)
- Falls back to fetching from Tinybird API if cache is empty
- Used by the client-side nanoquery store
Client Store:
- Fetches from the cache API endpoint
- Automatically revalidates on reconnect/focus
- Provides real-time updates for current season data

Updating the Current Season

To update the current season, simply edit src/lib/leaderboard-config.ts:

export const CURRENT_SEASON_MONTH = "november";  // Change this
export const CURRENT_SEASON_YEAR = "2025";        // Change this if needed

Then deploy. The seasons array will be automatically regenerated with the new current season marked as active.