What is on Your Mind?

10-18-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

Also, I wanted to add:

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

Code:

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"....

Forum Trivial Pursuit - New Computer Science and Mathematics Trivia for UNIX.com-screen-shot-2019-10-18-60401-pmpng

This User Gave Thanks to Neo For This Post:

Neo

10-20-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

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

Quote:

3,489 VERIFIED QUESTIONS AND 3,208 PENDING QUESTIONS

Added 23 October:

Quote:

3,489 VERIFIED QUESTIONS AND 3,221 PENDING QUESTIONS

Still has not validated my two test questions:

Code:

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.

Neo

10-23-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

FYI:

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

Quote:

Hi,

I see that verifying questions for the Open Trivia DB is falling behind and there are over 3000 questions in the queue to be verified, including two (test questions) of mine.

Because of this long latency in getting our questions (related to computer science) verified (note, I am not complaining at all), I am going to create the same database on our server so we can write a lot of computer science questions and get them verified by our users at www.unix.com .

I want to use the same format as the Open Trivia DB (and eventually we should send our DB dump to Open DB and you can merge if you wish). Of course, I could reverse engineer the JSON to get the basic structure, but that takes time, more time that simply getting the Open Trivia DB structure.

So, could the admins of Open Trivia DB post the DB table structure (or email to me) so I can create the same database structure for my server?

Thanks so much for helping me out.

Neo

Neo

10-25-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

Have updated our post at Open Trivial DB here:

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

Quote:

Update:

Please note, we are also discussing this topic here:

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

... and will be documenting our database structure if we must reverse engineer the JSON to create our own version of the DB.

Again, we are not �complaining�� in the least and understand the good folks at PixelTail are very busy and there is currently over 3000 questions in the trivia DB queue waiting to be validated; we just want to insure that if we create our own �computer science�� related DB (so we can validate faster), that we can eventually dump this DB and merge it with the Open Trivial DB.

We want all our work in the future to be compatible with the Open Trivial DB.

Current stats at Open Trivia DB:

Code:

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!

Neo

10-25-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

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

Code:

{
    "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 &quot;The Little Match Girl&quot;?",
            "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 &quot;Jacob's Ladder&quot;?",
            "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 &quot;Angels&quot; 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!

Neo

10-27-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

First Draft Done:

Code:

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:

Code:

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)

Neo