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


 
Thread Tools Search this Thread
The Lounge What is on Your Mind? Forum Trivial Pursuit - New Computer Science and Mathematics Trivia for UNIX.com
# 15  
Old 10-27-2019
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 Smilie
# 16  
Old 10-27-2019
Making some progress:

Code:
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? Smilie
# 17  
Old 10-28-2019
Update:

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

Code:
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  
Old 10-28-2019
Quote:
Originally Posted by Neo
....

I guess next:
  • [s]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)[s] Done
  • Manually enter 100 TRUE / FALSE unix/linux/networking/security (future subcategories) related questions into the database for category Almost done

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. Still TBD
But, on the other hand the very simple first beta UI to submit questions is also done.

Smilie

Edit:

First one hundred trivia questions done:

Code:
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  
Old 10-28-2019
Update:

Code:
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  
Old 10-29-2019
Update:

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

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

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

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

# 21  
Old 10-30-2019
Approach 300 of our own Computer Science Trivia in our DB:

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

I have disabled the approximately 32 Science: Computer, 4 Science: Gadgets, and 18 Science: Math trivia true / false questions from the Open Trivia DB API and we will only be using our DB moving forward. Our trivia questions are better, faster loading, and is already approaching just about 5 times the size of the Open Trivia DB including there Computer Science, Gadgets and Math categories.

Hence, moving forward I will add questions to our Computer Science Trivia DB with a goal of trying to get to 1000 before the end of this year.

Continue here:


1000+ Computer Science Trivia Questions at UNIX.COM
Login or Register to Ask a Question

Previous Thread | Next Thread

9 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?

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: https://www.unix.com/trivia_stats.php Currently milhan leads the members with a high score of 90%: ... (3 Replies)
Discussion started by: Neo
3 Replies

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

5. Web Development

Is Web Development is a part of computer science ?

I am now a student in university in 2nd year. I am studying computer science. But I am not sure what type of jobs computer science provide. I know some of them are software programming or network management. Recently, I hear some about Web Development. I wonder if it is a part of computer... (3 Replies)
Discussion started by: Anna Hussie
3 Replies

6. Programming

Is Web Development is a part of computer science ?

I am now a student in university in 2nd year. I am studying computer science. But I am not sure what type of jobs computer science provide. I know some of them are software programming or network management. Recently, I hear some about Web Development. I wonder if it is a part of computer science.... (1 Reply)
Discussion started by: Anna Hussie
1 Replies

7. What is on Your Mind?

Computer Science and Information Technology

Hi, I haven't posted on the forums for a while now, I tried to find the most appropriate section for this post, but if this is in the wrong section please forgive me. First, let me say I'm a sophomore in HS. I know that job wise I definitely want to do something in computers. A while ago I was... (5 Replies)
Discussion started by: hpicracing
5 Replies

8. Shell Programming and Scripting

Which is the best way/command to do mathematics in UNIX scripting?

Hello all! I used to use expr for doing simple mathematics, but has a main advantage and a main disadvantage: The advantage is that it can take variables for numbers (e.g.{1}: echo "Give me first" read lol echo "Give other" read lil sum=`expr $lol + $lil` echo "The sum of $lol and $lil =... (5 Replies)
Discussion started by: hakermania
5 Replies

9. UNIX for Dummies Questions & Answers

mathematics operations in unix

Hello guys! Can say me anybody about operatios with unix, I don't to make operations, only inside in a variable, like this #y=4 #x=2 #let z=$y-$x #echo $z # 2 but I can't to make mathematical operations with decimal like this #y=3.2 #x=1.5 #let z=$y-$x #echo $z # 3 this... (2 Replies)
Discussion started by: cesar720213
2 Replies
Login or Register to Ask a Question