Search Results

Approach 300 of our own Computer Science Trivia in our DB:

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

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

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

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

:)

Edit:

First one hundred trivia questions done:

mysql> select count(*) from neo_open_trivia;...

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

Making some progress:

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

Instead of setting an initial...

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

Updated the initial 5 questions for testing the future API :

mysql> select * from neo_open_trivia;...

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

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

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

Updated. Added more DB fields:



mysql> describe neo_open_trivia;
+--------------------+------------------+------+-----+---------+----------------+
| Field | Type |...

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

mysql> describe neo_open_trivia;
+--------------------+------------------+------+-----+---------+----------------+
| Field ...

Added a field to validate:

mysql> describe neo_open_trivia;
+-------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key |...

First Draft Done:

mysql> describe neo_open_trivia;
+-------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default...

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

{
"response_code": 0,
"results": [
{
"category": "Entertainment: Video Games",
"type":...

Have updated our post at Open Trivial DB here:

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

FYI:

Open Trivia DB Database Structure (Please) - Open Trivia DB - PixelTail Games - Creators of Tower Unite! (https://forums.pixeltailgames.com/t/open-trivia-db-database-structure-please/35135)

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

Also, I wanted to add:

If anyone wants to contribute any UNIX or Linux trivial to the Open Trivia Database (https://opentdb.com/):

https://opentdb.com/

Please create an account at the "Open...

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