Leaderboard API – Fetch & Rank Users Based on Total $DCU Earned

[LuminaEnvision]

Implement an API that retrieves verified PoIs leading to Impact Product claims, successful referrals, and streak participation to rank users based on total $DCU earned.

Tasks:

✅ Fetch User Data for Leaderboard Ranking:

• Retrieve wallet address / ENS for each user.
• Fetch verified PoIs that led to Impact Product level claims.
• Fetch total referrals that resulted in a verified PoI claim.
• Fetch streak participation data (consecutive weekly verified PoI submissions).

✅ Calculate Total $DCU Earned Per User:

• +10 $DCU per verified PoI leading to a claimed Impact Product level.
• +3 $DCU per verified PoI if streak was maintained (PoI submitted within 7 days of the previous one).
• +1 $DCU per successful referral (only if referred user’s PoI was verified).

✅ Store & Optimize Leaderboard Rankings:

• Store total $DCU earned per user for quick leaderboard access.
• Rank users dynamically based on total $DCU points.
• Index frequently queried fields to improve API response speed.

✅ Create API Endpoint for Leaderboard Retrieval:

• Implement GET /api/leaderboard.
• Return top-ranked users based on $DCU points.
• Provide optional pagination & filtering (e.g., top 100, country-based rankings in future updates).

✅ Response & Error Handling:

• Return leaderboard data sorted by total $DCU earned.
• Handle cases where no users have submitted PoIs yet.

[LaGodxy]

hello @LuminaEnvision I am excited about the opportunity to contribute to the implementation of an API for ranking users based on verified PoIs, referrals, and streak participation. With experience in API development, database optimization, and leaderboard systems, I am confident in delivering an efficient and scalable solution.

Proposed Contributions:

• Fetch User Data for Leaderboard Ranking:
  • Retrieve wallet addresses/ENS and fetch verified PoIs.
  • Fetch referral data leading to verified PoI claims.
  • Track streak participation for consecutive submissions.
• Calculate Total $DCU Earned Per User:
  • +10 $DCU per verified PoI leading to an Impact Product claim.
  • +3 $DCU per streak-maintained PoI.
  • +1 $DCU per successful referral with a verified PoI.
• Store & Optimize Leaderboard Rankings:
  • Store and index total $DCU earned for quick retrieval.
  • Rank users dynamically based on earnings.
• API Development:
  • Implement GET /api/leaderboard to retrieve ranked users.
  • Enable pagination and future filtering options.
  • Ensure proper response handling and error management.

Technical Approach:

I plan to leverage efficient database indexing, caching strategies, and secure API development practices to optimize leaderboard performance and scalability.

I have completed all necessary contribution prerequisites and look forward to aligning my efforts with the project’s objectives. Excited to collaborate and contribute.

[0xNgoo]

I'd like to take on this @LuminaEnvision