I'm closing in on 1000 trivia questions (my goal):
Code:
mysql> select count(*) from neo_open_trivia;
+----------+
| count(*) |
+----------+
| 682 |
+----------+
1 row in set (0.00 sec)
My plan was to create some scoreboards when we reached 2000 interactions, but I think I will hold off until 10,000... since we are already nearly 1/2 way there:
Code:
mysql> select count(*) from neo_trivia_scoreboard;;
+----------+
| count(*) |
+----------+
| 4326 |
+----------+
1 row in set (0.00 sec)
Guests v. Registered users (not including Neo) - almost ten to one, guests over registered users:
Code:
mysql> select count(*) from neo_trivia_scoreboard where uid > 1;
+----------+
| count(*) |
+----------+
| 370 |
+----------+
1 row in set (0.01 sec)
mysql> select count(*) from neo_trivia_scoreboard where uid < 1;
+----------+
| count(*) |
+----------+
| 3387 |
+----------+
1 row in set (0.00 sec)
Neo testing and playing:
Code:
mysql> select count(*) from neo_trivia_scoreboard where uid = 1;
+----------+
| count(*) |
+----------+
| 569 |
+----------+
1 row in set (0.00 sec)
Actually, I play this (answer questions) when resting between rounds during fitness training at the gym or when I want to kill some time. It's a great way to kill some time on mobile and test at the same time
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)
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)
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)
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)
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)
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)
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)
11-03-2019
