What is on Your Mind?

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:

Code:

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%:



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.

Update:

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

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.

Update:









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: