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

What is on Your Mind?
1

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 incorrect answers for each user.
  • Provide a "trivia scoreboard" for all trivia players.

882×711 42 KB

At the moment, the scores are not being recorded in the database.

Update:

Now we have three trivia categories, with equal probabilities:

  • Computer Science
  • Mathematics
  • Science Gadgets

Update 2:

On the "show posts" page, now we have five trivia categories, with equal probabilities:

  • Computer Science
  • Mathematics
  • Science Gadgets
  • Geography
  • History

Maybe we should add History and Geography to the main pages? Or just leave the main pages Computer Science, Math and Science Gadgets?

Any ideas before I code deeper into this?

2

Also, I wanted to add:

If anyone wants to contribute any UNIX or Linux trivial to the Open Trivia Database:

https://opentdb.com/

Please create an account at the "Open Trivia Database" and submit your questions, which will be verified and then added to the DB.

Thanks.

Just submitted two True/False questions to test how long it takes for questions to be "approved"....

901×673 55 KB

1 Like
3

... maybe not... sees that "Open Trivia Database" site is not validating new questions in a timely manner.

Added 23 October:

Still has not validated my two test questions:

Unverified Questions
ID   	       Category	               Type	        Difficulty	Question
8806	Science: Computers	True / False	Easy	        Awk is abbreviated from the names of the developers - Aho, Weinberger, and Kernighan.
8805	Science: Computers	True / False	Medium	Grep stands for "global regular expression process".

I may reverse-engineer and recreate the OTDB database structure and create our own database for this, so we can submit and build our own questions and answers without waiting for that site to validate and approve.

4

FYI:

Open Trivia DB Database Structure (Please) - Open Trivia DB - PixelTail Games - Creators of Tower Unite!

5

Have updated our post at Open Trivial DB here:

Open Trivia DB Database Structure (Please) - Open Trivia DB - PixelTail Games - Creators of Tower Unite!

Current stats at Open Trivia DB:

3,489 VERIFIED QUESTIONS AND 3,243 PENDING QUESTIONS

Basically, there has been no movement in the number of verified questions since we began this discussion thread and our two "test question" have not been verified.

In the "not so distant future" I will take the time to reverse engineer the DB and post the results here.

If anyone else has the time to do it (reverse engineer the Open Trivial DB from the API JSON), before I get around to it, please do!

6

Example (generic, not category specific) API JSON, return:

{
    "response_code": 0,
    "results": [
        {
            "category": "Entertainment: Video Games",
            "type": "multiple",
            "difficulty": "easy",
            "question": "Which company did Gabe Newell work at before founding Valve Corporation?",
            "correct_answer": "Microsoft",
            "incorrect_answers": [
                "Apple",
                "Google",
                "Yahoo"
            ]
        },
        {
            "category": "Science: Computers",
            "type": "multiple",
            "difficulty": "easy",
            "question": "According to the International System of Units, how many bytes are in a kilobyte of RAM?",
            "correct_answer": "1000",
            "incorrect_answers": [
                "512",
                "1024",
                "500"
            ]
        },
        {
            "category": "Entertainment: Books",
            "type": "multiple",
            "difficulty": "medium",
            "question": "Who wrote the children's story "The Little Match Girl"?",
            "correct_answer": "Hans Christian Andersen",
            "incorrect_answers": [
                "Charles Dickens",
                "Lewis Carroll",
                "Oscar Wilde"
            ]
        },
        {
            "category": "Entertainment: Video Games",
            "type": "multiple",
            "difficulty": "hard",
            "question": "In the Animal Crossing series, which flower is erroneously called the "Jacob's Ladder"?",
            "correct_answer": "Lily of the Valley",
            "incorrect_answers": [
                "Hydrangea",
                "Harebell",
                "Yarrow"
            ]
        },
        {
            "category": "Politics",
            "type": "multiple",
            "difficulty": "hard",
            "question": "Which letter do you need to have on a European driver license in order to ride any motorbikes?",
            "correct_answer": "A",
            "incorrect_answers": [
                "X",
                "D",
                "B"
            ]
        },
        {
            "category": "Entertainment: Video Games",
            "type": "boolean",
            "difficulty": "medium",
            "question": "TF2: The Medic will be credited for an assist if he heals a Spy that successfully saps a building.",
            "correct_answer": "True",
            "incorrect_answers": [
                "False"
            ]
        },
        {
            "category": "Geography",
            "type": "multiple",
            "difficulty": "medium",
            "question": "What is the capital of Estonia?",
            "correct_answer": "Tallinn",
            "incorrect_answers": [
                "Helsinki",
                "Tartu",
                "Riga"
            ]
        },
        {
            "category": "Entertainment: Music",
            "type": "multiple",
            "difficulty": "easy",
            "question": "Which former boy-band star released hit solo single "Angels" in 1997?",
            "correct_answer": "Robbie Williams",
            "incorrect_answers": [
                "Justin Timberlake",
                "Harry Styles",
                "Gary Barlow"
            ]
        },
        {
            "category": "Sports",
            "type": "multiple",
            "difficulty": "medium",
            "question": "What year was hockey legend Wayne Gretzky born?",
            "correct_answer": "1961",
            "incorrect_answers": [
                "1965",
                "1959",
                "1963"
            ]
        },
        {
            "category": "Geography",
            "type": "multiple",
            "difficulty": "hard",
            "question": "What national museum will you find in Cooperstown, New York?",
            "correct_answer": "National Baseball Hall of Fame",
            "incorrect_answers": [
                "Metropolitan Museum of Art",
                "National Toy Hall of Fame",
                "Museum of Modern Art"
            ]
        }
    ]
}

Reference: https://opentdb.com/api.php?amount=10

If anyone has time to reverse engineer this and create a MySQL DB table for this, please do!!

Thanks!

7

First Draft Done:

mysql> describe neo_open_trivia;
+-------------------+------------------+------+-----+---------+----------------+
| Field             | Type             | Null | Key | Default | Extra          |
+-------------------+------------------+------+-----+---------+----------------+
| id                | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| category          | varchar(254)     | NO   |     | NULL    |                |
| type              | varchar(16)      | NO   |     | NULL    |                |
| difficulty        | varchar(16)      | NO   |     | NULL    |                |
| question          | varchar(1024)    | NO   |     | NULL    |                |
| correct_answer    | varchar(1024)    | NO   |     | NULL    |                |
| incorrect_answers | varchar(5000)    | NO   |     | NULL    |                |
+-------------------+------------------+------+-----+---------+----------------+
7 rows in set (0.01 sec)

Example Test Data:

mysql> select * from neo_open_trivia;
+----+--------------------+----------+------------+------------------------------------------------------------------------------------------+----------------+-------------------+
| id | category           | type     | difficulty | question                                                                                 | correct_answer | incorrect_answers |
+----+--------------------+----------+------------+------------------------------------------------------------------------------------------+----------------+-------------------+
|  1 | Science: Computers | boolean  | easy       | The name of this forum is 'The UNIX and Linux Forums'?                                   | True           | ["False"]         |
|  2 | Science: Computers | multiple | easy       | According to the International System of Units, how many bytes are in a kilobyte of RAM? | 1000           | [512,1024,500]    |
|  3 | Science: Computers | multiple | easy       | What does 'Hello World' Mean?                                                            | Hello          | ["Bye","Go","Mo"] |
|  4 | Science: Computers | boolean  | easy       | 'Hello World' Means Bite Me?                                                             | False          | ["True"]          |
|  5 | Science: Computers | boolean  | easy       | 'Hello World' Means Hello World?                                                         | True           | ["False"]         |
+----+--------------------+----------+------------+------------------------------------------------------------------------------------------+----------------+-------------------+
5 rows in set (0.00 sec)
8

Added a field to validate:

mysql> describe neo_open_trivia;
+-------------------+------------------+------+-----+---------+----------------+
| Field             | Type             | Null | Key | Default | Extra          |
+-------------------+------------------+------+-----+---------+----------------+
| id                | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| category          | varchar(254)     | NO   |     | NULL    |                |
| type              | varchar(16)      | NO   |     | NULL    |                |
| difficulty        | varchar(16)      | NO   |     | NULL    |                |
| question          | varchar(1024)    | NO   |     | NULL    |                |
| correct_answer    | varchar(1024)    | NO   |     | NULL    |                |
| incorrect_answers | varchar(5000)    | NO   |     | NULL    |                |
| validated         | tinyint(1)       | NO   |     | NULL    |                |
+-------------------+------------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)
9

Added userid (submitted), time submitted and time modified:

mysql> describe neo_open_trivia;
+--------------------+------------------+------+-----+---------+----------------+
| Field              | Type             | Null | Key | Default | Extra          |
+--------------------+------------------+------+-----+---------+----------------+
| id                 | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| category           | varchar(254)     | NO   |     | NULL    |                |
| type               | varchar(16)      | NO   |     | NULL    |                |
| difficulty         | varchar(16)      | NO   |     | NULL    |                |
| question           | varchar(1024)    | NO   |     | NULL    |                |
| correct_answer     | varchar(1024)    | NO   |     | NULL    |                |
| incorrect_answers  | varchar(5000)    | NO   |     | NULL    |                |
| validated          | tinyint(1)       | NO   |     | NULL    |                |
| userid             | int(10) unsigned | NO   |     | NULL    |                |
| time_submitted     | int(10) unsigned | NO   |     | NULL    |                |
| time_last_modified | int(10) unsigned | NO   |     | NULL    |                |
+--------------------+------------------+------+-----+---------+----------------+
11 rows in set (0.01 sec)

Sample Test Data:

mysql> select * from neo_open_trivia;
+----+--------------------+----------+------------+------------------------------------------------------------------------------------------+----------------+-------------------+-----------+--------+----------------+--------------------+
| id | category           | type     | difficulty | question                                                                                 | correct_answer | incorrect_answers | validated | userid | time_submitted | time_last_modified |
+----+--------------------+----------+------------+------------------------------------------------------------------------------------------+----------------+-------------------+-----------+--------+----------------+--------------------+
|  1 | Science: Computers | boolean  | easy       | The name of this forum is 'The UNIX and Linux Forums'?                                   | True           | ["False"]         |         0 |      1 |     1572151119 |         1572151119 |
|  2 | Science: Computers | multiple | easy       | According to the International System of Units, how many bytes are in a kilobyte of RAM? | 1000           | [512,1024,500]    |         0 |      1 |     1572151119 |         1572151119 |
|  3 | Science: Computers | multiple | easy       | What does 'Hello World' Mean?                                                            | Hello          | ["Bye","Go","Mo"] |         0 |      1 |     1572151119 |         1572151119 |
|  4 | Science: Computers | boolean  | easy       | 'Hello World' Means Bite Me?                                                             | False          | ["True"]          |         0 |      1 |     1572151119 |         1572151119 |
|  5 | Science: Computers | boolean  | easy       | 'Hello World' Means Hello World?                                                         | True           | ["False"]         |         0 |      1 |     1572151119 |         1572151119 |
+----+--------------------+----------+------------+------------------------------------------------------------------------------------------+----------------+-------------------+-----------+--------+----------------+--------------------+
5 rows in set (0.00 sec)
10

Updated. Added more DB fields:

mysql> describe neo_open_trivia;
+--------------------+------------------+------+-----+---------+----------------+
| Field              | Type             | Null | Key | Default | Extra          |
+--------------------+------------------+------+-----+---------+----------------+
| id                 | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| category           | varchar(254)     | NO   |     | NULL    |                |
| type               | varchar(16)      | NO   |     | NULL    |                |
| difficulty         | varchar(16)      | NO   |     | NULL    |                |
| question           | varchar(1024)    | NO   |     | NULL    |                |
| correct_answer     | varchar(1024)    | NO   |     | NULL    |                |
| incorrect_answers  | varchar(5000)    | NO   |     | NULL    |                |
| validated          | tinyint(1)       | NO   |     | NULL    |                |
| time_validated     | int(10) unsigned | YES  |     | NULL    |                |
| userid_validated   | int(10) unsigned | YES  |     | NULL    |                |
| userid_submitted   | int(10) unsigned | NO   |     | NULL    |                |
| time_submitted     | int(10) unsigned | NO   |     | NULL    |                |
| time_last_modified | int(10) unsigned | NO   |     | NULL    |                |
+--------------------+------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

Test Data:

mysql> select * from neo_open_trivia;
+----+--------------------+----------+------------+------------------------------------------------------------------------------------------+----------------+-------------------+-----------+----------------+------------------+------------------+----------------+--------------------+
| id | category           | type     | difficulty | question                                                                                 | correct_answer | incorrect_answers | validated | time_validated | userid_validated | userid_submitted | time_submitted | time_last_modified |
+----+--------------------+----------+------------+------------------------------------------------------------------------------------------+----------------+-------------------+-----------+----------------+------------------+------------------+----------------+--------------------+
|  1 | Science: Computers | boolean  | easy       | The name of this forum is 'The UNIX and Linux Forums'?                                   | True           | ['False']         |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
|  2 | Science: Computers | multiple | easy       | According to the International System of Units, how many bytes are in a kilobyte of RAM? | 1000           | [512,1024,500]    |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
|  3 | Science: Computers | multiple | easy       | What does 'Hello World' Mean?                                                            | Hello          | ['Bye','Go','Mo'] |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
|  4 | Science: Computers | boolean  | easy       | 'Hello World' Means Bite Me?                                                             | False          | ['True']          |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
|  5 | Science: Computers | boolean  | easy       | 'Hello World' Means Hello World?                                                         | True           | ['False']         |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
+----+--------------------+----------+------------+------------------------------------------------------------------------------------------+----------------+-------------------+-----------+----------------+------------------+------------------+----------------+--------------------+
5 rows in set (0.00 sec)

Time to take a break from this and go watch Terminator: Dark Fate (2019) now in theaters here.

11

Note:

I just looked at another site admin's unfinished project from 5 years ago when we started collecting multiple choice exam questions.

At some time in the future, I will port all 78 multiple choice questions (validated, unvalidated and draft) into the new "trivia" database.

Then, as some other point in time, I will start to build the UI for this.

Example questions from that unfinished project:

mysql> select question from neo_exam_questions Limit 5;
+---------------------------------------------------------------------------------------------------------------+
| question                                                                                                      |
+---------------------------------------------------------------------------------------------------------------+
| What is the highest priority for syslogd?                                                                     |
| Starting a shell script with a dot 

$ . ./script.sh

[/NOPARSE]

when you execute the script does what? |
| Where should you not keep your system backup when you backup your critical production server? |
| Which of these commands would show the users who are currently logged in to a Linux server? |
| Which Linux command erases the previously displayed output on a terminal display? |
+---------------------------------------------------------------------------------------------------------------+
5 rows in set (0.01 sec)[/CODE]

I will change the "flavor" of this project and finish it.... More than likely it will be in the form of "trivia questions" which will appear in the forums (as the open trivia DB questions appear now) and members can answer as they wish; and I will add some scoring system to track correct and incorrect answers, add timers, and more over time.

Will start out "simple" and then add more features over time, trying to stay compatible with the Open Trivia DB (which seems to be in "super pause" mode lately, which I totally understand since our "exam" project has been on "super pause" for 5 years... !!!) ....

12

We really liked Terminator Dark Fate.

I decided to only focus on TRUE / FALSE questions in Phase I of this caper.

This also means there is no need to immediate port the questions from 5 years ago since all those questions are multiple choice.

I may manually enter 100 T/F questions into the new DB table myself to kick things off.

More to come ....

13

From the Open Trivia DB API:

Need these parameters:

  • amount (integer, 1 to 10)
  • category (integer, Science: Computers - category 18)
  • difficulty (text: easy, medium, difficult)
  • type (text: boolean, multiple)

So, changed the DB table structure as follows:

mysql> describe neo_open_trivia;
+--------------------+------------------+------+-----+---------+----------------+
| Field              | Type             | Null | Key | Default | Extra          |
+--------------------+------------------+------+-----+---------+----------------+
| id                 | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| category           | smallint(2)      | NO   |     | NULL    |                |
| type               | varchar(16)      | NO   |     | NULL    |                |
| difficulty         | varchar(16)      | NO   |     | NULL    |                |
| question           | varchar(1024)    | NO   |     | NULL    |                |
| correct_answer     | varchar(1024)    | NO   |     | NULL    |                |
| incorrect_answers  | varchar(5000)    | NO   |     | NULL    |                |
| validated          | tinyint(1)       | NO   |     | NULL    |                |
| time_validated     | int(10) unsigned | YES  |     | NULL    |                |
| userid_validated   | int(10) unsigned | YES  |     | NULL    |                |
| userid_submitted   | int(10) unsigned | NO   |     | NULL    |                |
| time_submitted     | int(10) unsigned | NO   |     | NULL    |                |
| time_last_modified | int(10) unsigned | NO   |     | NULL    |                |
+--------------------+------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

and started PHP array for mapping categories as SMALLINT to VARCHAR :

<?php
$categories = array();
$categories[18] = "Science: Computers";

Test Data Now:

mysql> select * from neo_open_trivia;
+----+----------+----------+------------+------------------------------------------------------------------------------------------+----------------+-------------------+-----------+----------------+------------------+------------------+----------------+--------------------+
| id | category | type     | difficulty | question                                                                                 | correct_answer | incorrect_answers | validated | time_validated | userid_validated | userid_submitted | time_submitted | time_last_modified |
+----+----------+----------+------------+------------------------------------------------------------------------------------------+----------------+-------------------+-----------+----------------+------------------+------------------+----------------+--------------------+
|  1 |       18 | boolean  | easy       | The name of this forum is 'The UNIX and Linux Forums'?                                   | True           | ['False']         |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
|  2 |       18 | multiple | easy       | According to the International System of Units, how many bytes are in a kilobyte of RAM? | 1000           | [512,1024,500]    |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
|  3 |       18 | multiple | easy       | What does 'Hello World' Mean?                                                            | Hello          | ['Bye','Go','Mo'] |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
|  4 |       18 | boolean  | easy       | 'Hello World' Means Bite Me?                                                             | False          | ['True']          |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
|  5 |       18 | boolean  | easy       | 'Hello World' Means Hello World?                                                         | True           | ['False']         |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
+----+----------+----------+------------+------------------------------------------------------------------------------------------+----------------+-------------------+-----------+----------------+------------------+------------------+----------------+--------------------+
5 rows in set (0.00 sec)

Will modify this in the future to permit a subcatgegory (for unix.com) while insuring the API remains compatible with the Open Trivia DB API.

I guess next:

  • I will write and text the API in PHP to return JSON, almost exactly like Open Trivia DB API (but with return JSON only, no other formats).
  • Manually enter 100 TRUE / FALSE unix/linux/networking/security (future subcategories) related questions into the database for category

Then after the Beta API is working OK, will probably extent the functionality to:

  • Write AJAX query for user in browser to update DB (might require a new table, will think about this) when a user answers a question.

Then think of what feature to add next... :slight_smile:

Was going to reverse engineer the SMALLINT to VARCHAR mappings for all the Open Trivia DB categories, but I think for now will just stick with category 18 - "Science: Computers".

However, if anyone else wants to do this and post the PHP array for that mapping in this format $categories[18] = "Science: Computers"; , please help me out and do it.

14

Updated the initial 5 questions for testing the future API :

mysql> select * from neo_open_trivia;
+----+----------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-------------------+-----------+----------------+------------------+------------------+----------------+--------------------+
| id | category | type    | difficulty | question                                                                                                                                                                                     | correct_answer | incorrect_answers | validated | time_validated | userid_validated | userid_submitted | time_submitted | time_last_modified |
+----+----------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-------------------+-----------+----------------+------------------+------------------+----------------+--------------------+
|  1 |       18 | boolean | medium     | The UNIX and Linux Forums (UNIX.com) was founded in 1985?                                                                                                                                    | True           | ['False']         |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
|  2 |       18 | boolean | easy       | Unix was invented by Steve Jobs of Apple Computer?                                                                                                                                           | False          | ['True']          |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
|  3 |       18 | boolean | easy       | 'Hello World' is a program only for advanced programmers?                                                                                                                                    | False          | ['True']          |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
|  4 |       18 | boolean | medium     | The UNIX and Linux Forum was one of the first forums on the Internet to have a strong moderation policy to encourage users of all skill levels to participate without fear of being bullied? | True           | ['False']         |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
|  5 |       18 | boolean | easy       | The UNIX trademark is a "certification mark"?                                                                                                                                                | True           | ['False']         |         0 |              0 |                0 |                1 |     1572151119 |         1572151119 |
+----+----------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-------------------+-----------+----------------+------------------+------------------+----------------+--------------------+
5 rows in set (0.00 sec)

I plan to bootstrap this process by writing 100 TRUE/FALSE questions.

If anyone wants to write any TRUE/FALSE questions (which I will manually enter into the DB, until I build a UI for this), please do so and email or PM them to me (so we don't have all the questions and answers to questions in the open forum). -- Thanks

15

Update:

I have the 'rough TRUE / FALSE' API working and the initial test questions are now live on the site, alternating between the Open Trivia DB and our Forum Trivia DB (currently using a simple random number 0 or 1 to select).

Now need to add at least 95 more TRUE / FALSE questions :slight_smile:

16

Making some progress:

mysql> select count(*) from neo_open_trivia;
+----------+
| count(*) |
+----------+
|       12 |
+----------+
1 row in set (0.00 sec)

Instead of setting an initial goal of 100 questions, I may update this to 200 initial computer science trivia questions. Let's see how far I can go before I get bored.

Anyone care to help? :slight_smile:

17

Update:

mysql> select count(*) from neo_open_trivia;
+----------+
| count(*) |
+----------+
|       65 |
+----------+
1 row in set (0.00 sec)

Most of these questions were entered using a new "easy to submit" UI I just made, Submit Trivia:

https://www.unix.com/trivia/

This UI is only for registered users and the category "computer science" and is currently "permission by userid".

Please contact me or post back here if you have time and want to add compute science trivia questions to our DB.

18

But, on the other hand the very simple first beta UI to submit questions is also done.

:slight_smile:

Edit:

First one hundred trivia questions done:

mysql> select count(*) from neo_open_trivia;
+----------+
| count(*) |
+----------+
|      100 |
+----------+
1 row in set (0.00 sec)

Can easily add these true / false questions with this quick and easy UI I just built today:

https://www.unix.com/trivia/

19

Update:

mysql> select count(*) from neo_open_trivia;
+----------+
| count(*) |
+----------+
|      154 |
+----------+
1 row in set (0.00 sec)

Note: Since I am well past my initial goal of reverse engineering the Open Trivia DB, creating a new DB, creating a basic PHP API, creating a feature to add new entries to the DB, and have added over 150 computer science related trivia entries in the DB, I will stop posting in this thread soon and start a new phase for this project sooner than later.

20

Update:

I have the first draft of basic code to track user answers to trivia questions done (both registered and unregistered users) as follows:

mysql> describe neo_trivia_scoreboard;
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| id        | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| uid       | int(10) unsigned | NO   |     | 0       |                |
| trivia_id | int(10) unsigned | NO   |     | 0       |                |
| results   | varchar(16)      | NO   |     | none    |                |
| dateline  | int(10)          | NO   |     | 0       |                |
| site      | varchar(8)       | NO   |     | tbd     |                |
| category  | smallint(3)      | NO   |     | 18      |                |
+-----------+------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

also:

mysql> select count(*) from neo_open_trivia;
+----------+
| count(*) |
+----------+
|      168 |
+----------+
1 row in set (0.00 sec)

I will test this for a while and then build a first draft scoreboard.

But so far, so good.

mysql> select count(*) from neo_trivia_scoreboard;
+----------+
| count(*) |
+----------+
|       40 |
+----------+
1 row in set (0.00 sec)