New Member and Country Computer Trivia Leaderboards

What is on Your Mind?
1

Thanks to Akshay, who helped me write the core MySQL queries, we now have two new draft leaderboards, by (1) member and by (2) country:

https://www.unix.com/trivia_stats.php

Currently milhan leads the members with a high score of 90%:

Russia leads the country leaderboard with 74%:

844×503 25.3 KB

This are just "first draft" leaderboards. To make the member leaderboard, members need over 10 questions answered and to make the country leaderboard, a country needs over 200 questions answered.

Someday, I will draft a leaderboard for guests based on a hash of their IP addresses, but for this week, I'm done.

Thanks again, Akshay for writing the core MySQL queries.

2 Likes
2

Update:

Just updated this to include a draft "Major League" and a draft "Minor League".... for both Member and Country Leaderboards

3

Update:

Fixed a minor bug in the Minor League Member Leaderboard, caused by sorting on strings instead of floats, which caused users with scores of '100%' to not appear in the sort results.

This bug only appeared in queries where there were no incorrect answers to trivia questions, and this was only the case with people with a very few answers.

Also,

Added a PHP array of country codes to country name so now the country names appear in the leaderboards instead of the country codes.

4

Update:

  • So far, 17,525 questions have been answered by members and (mostly) guests.
  • UI Update to Trivia Leaderboards: Added tooltips for mouse overs which show the total number of questions answered, some details about the leagues, and links to user profiles (badges):

Also, congratulations are in order for Peasant for being on top of the Major League for Members and for members and Russia for leading the Major League for countries overall.

TODO:

  • Add new badge(s) and levels (colors) to member profiles for trivia results.