New Member and Country Computer Trivia Leaderboards


 
Thread Tools Search this Thread
The Lounge What is on Your Mind? New Member and Country Computer Trivia Leaderboards
# 1  
Old 11-11-2019
New Member and Country Computer Trivia Leaderboards

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

Image

Russia leads the country leaderboard with 74%:

Image

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.
These 2 Users Gave Thanks to Neo For This Post:
# 2  
Old 11-11-2019
Update:

Just updated this to include a draft "Major League" and a draft "Minor League".... for both Member and Country Leaderboards
# 3  
Old 11-12-2019
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  
Old 11-14-2019
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):

New Member and Country Computer Trivia Leaderboards-screen-shot-2019-11-15-91651-ampng

New Member and Country Computer Trivia Leaderboards-screen-shot-2019-11-15-91633-ampng

New Member and Country Computer Trivia Leaderboards-screen-shot-2019-11-15-91620-ampng

New Member and Country Computer Trivia Leaderboards-screen-shot-2019-11-15-91557-ampng

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.
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. What is on Your Mind?

Computer Trivia Feature Tops 50,000 Questions Answered

Just noticed that our successful computer trivia feature (stats here) has surpassed over 50,000 questions answered by users: https://www.unix.com/trivia_stats.php This was a coding effort worth while and I'm pleased to see so many people enjoying it in such a short time since it was released... (3 Replies)
Discussion started by: Neo
3 Replies

2. What is on Your Mind?

Debugging Our Computer Science Trivia Feature

Only a few days after I coded this new feature from scratch, we are seeing over 3000 entries in the database from members (mostly guests) playing CS trivia. I have spend a lot of time coding this (from scratch) and testing the API. From the logs, it seems to have an API bug which appears... (31 Replies)
Discussion started by: Neo
31 Replies

3. What is on Your Mind?

1000+ Computer Science Trivia Questions at UNIX.COM

The UNIX and Linux Forums now has over 1000 TRUE / FALSE computer science and computer related trivia question in our database. These questions are of relatively high quality (compared to similar sites on the web) and are fun (according to feedback by users). In the first week during the... (1 Reply)
Discussion started by: Neo
1 Replies

4. What is on Your Mind?

Forum Trivial Pursuit - New Computer Science and Mathematics Trivia for UNIX.com

I have added a new experimental "Computer Science and Mathematics Trivia - True or False" section in the discussions, currently under the tags box. In the future, I plan to Expand this feature to add more trivia categories from math, science and technology. Keep track of correct and... (20 Replies)
Discussion started by: Neo
20 Replies

5. UNIX for Dummies Questions & Answers

xterm trivia

Thanks Livin Free... Here's another one... Why is it that I always get the error message "Error: Can't open display:" in my mail whenever I execute or try to call an xterm command using cron to activate the command. What did I miss? Thanks in advance UNIX gurus... (3 Replies)
Discussion started by: jfsuminist
3 Replies
Login or Register to Ask a Question