Sponsored Content
The Lounge What is on Your Mind? Debugging Our Computer Science Trivia Feature Post 303040614 by Neo on Saturday 2nd of November 2019 12:59:11 AM
Old 11-02-2019
Here is a quick look at the top 40 users by ip address (not included in the report) and their country, so far (excluding me):

Code:
mysql> select  count(ipaddress),uid, country from neo_trivia_scoreboard  where uid != 1 group by ipaddress,uid,country  order by count(ipaddress) desc limit 40;
+------------------+-----------+---------+
| count(ipaddress) | uid       | country |
+------------------+-----------+---------+
|              103 |         0 | PH      |
|               91 |         0 | IT      |
|               60 |         0 | NL      |
|               55 | 302183346 | BG      |
|               53 |         0 | BR      |
|               45 |         0 | US      |
|               44 |         0 | DE      |
|               34 |         0 | US      |
|               31 |         0 | BR      |
|               31 |         0 | US      |
|               30 |         0 | AU      |
|               29 |         0 | US      |
|               28 |         0 | IN      |
|               28 |         0 | NL      |
|               27 |         0 | US      |
|               27 |         0 | IN      |
|               26 |     21292 | US      |
|               26 |         0 | GB      |
|               25 |         0 | FR      |
|               24 |         0 | UA      |
|               23 |         0 | US      |
|               23 |         0 | PL      |
|               23 |         0 | SE      |
|               23 |         0 | GB      |
|               22 |         0 | US      |
|               22 |         0 | AR      |
|               21 | 302093876 | HR      |
|               20 |         0 | US      |
|               20 |         0 | ES      |
|               19 |         0 | US      |
|               18 |         0 | CH      |
|               18 |         0 | XX      |
|               17 |         0 | US      |
|               15 |         0 | HU      |
|               15 |         0 | DE      |
|               14 |         0 | IN      |
|               14 |         0 | TH      |
|               14 |         0 | IN      |
|               13 |         0 | BG      |
|               13 |         0 | MX      |
+------------------+-----------+---------+
40 rows in set (0.00 sec)

Some from the Philippines answered 103 questions yesterday. Which is the current record, here is their score:

Code:
mysql> select count(results), results from neo_trivia_scoreboard where ipaddress ="MASKED" group by results;
+----------------+---------+
| count(results) | results |
+----------------+---------+
|             71 | right   |
|             32 | wrong   |
+----------------+---------+
2 rows in set (0.00 sec)

Score: 68%

For the site in general, to date:

Code:
mysql> select count(results), results from neo_trivia_scoreboard group by results;
+----------------+---------+
| count(results) | results |
+----------------+---------+
|           2465 | right   |
|           1089 | wrong   |
+----------------+---------+
2 rows in set (0.01 sec)

Overall site score (all users): 69%
 

7 More Discussions You Might Find Interesting

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

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

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

4. What is on Your Mind?

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

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)
Discussion started by: Neo
20 Replies

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

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

7. 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
Feature(3)						User Contributed Perl Documentation						Feature(3)

NAME
Gimp::Feature - check for specific features to be present before registering the script. SYNOPSIS
use Gimp::Feature; or use Gimp::Feature qw(feature1 feature2 ...); DESCRIPTION
This module can be used to check for specific features to be present. This can be used to deny running the script when neccessary features are not present. While some features can be checked for at any time, the Gimp::Fu module offers a nicer way to check for them. "gtk" checks for the presence of the gtk interface module. "gtk-1.1", "gtk-1.2" checks for the presence of gtk-1.1 (1.2) or higher. "perl-5.005" checks for perl version 5.005 or higher. "pdl" checks for the presence of a suitable version of PDL (>=1.9906). "gnome" checks for the presence of the Gnome-Perl module. "gtkxmhtl" checks for the presence of the Gtk::XmHTML module. "unix" checks wether the script runs on a unix-like operating system. At the moment, this is every system except windows, macos, os2 and vms. "persistency" checks wether the "Gimp::Data" module (Gimp::Data) can handle complex persistent data structures, i.e. perl references in addition to plain strings. The following features can only be checked after "Gimp-"main> has been called (usually found in the form "exit main"). See Gimp::Fu on how to check for these. "gimp-1.1", "gimp-1.2" checks for the presense of gimp in at least version 1.1 (1.2). FUNCTIONS present(feature) Checks for the presense of the single feature given as the argument. Returns true if the feature is present, false otherwise. need(feature,[function-name]) Require a specific feature. If the required feature is not present the program will exit gracefully, logging an appropriate message. You can optionally supply a function name to further specify the place where this feature was missing. This is the function used when importing symbols from the module. missing(feature-description,[function-name]) Indicates that a generic feature (described by the first argument) is missing. A function name can further be specified. This function will log the given message and exit gracefully. describe(feature) Returns a string describing the given feature in more detail, or undef if there is no description for this feature. list() Returns a list of features that can be checked for. This list might not be complete. AUTHOR
Marc Lehmann <pcg@goof.com> SEE ALSO
perl(1), Gimp(1). perl v5.8.0 1999-11-22 Feature(3)
All times are GMT -4. The time now is 02:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy