Last modified: 2014-01-03 15:46:00 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-60. Summary: Percentage of active editors with a date preference set on en.wikipedia.org Issue type: Task - A task that needs to be done. Priority: Trivial Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: Locke Cole <locke.cole.wiki@gmail.com> Date: Sun, 12 Apr 2009 05:16:18 ------------------------------------------------------------------------------- I don't have a SQL query available, but I'd like to know what percentage of active editors (editors who have made at least 150 article-space contributions and have made at least one edit in the last three months) have a date preference set (i.e., something other than the default setting when an account is created) on the English Wikipedia (en.wikipedia.org).
------------------------------------------------------------------------------- From: Brent G <overlordq@gmail.com> Date: Sun, 12 Apr 2009 05:32:32 ------------------------------------------------------------------------------- The toolserver does not have access to user preferences.
------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Sun, 12 Apr 2009 23:59:27 ------------------------------------------------------------------------------- Echoing Brent's comments. Toolserver users only have access to a limited part of the user table, specifically: mysql> DESCRIBE user; Field Type Null Key Default Extra user_id int(5) unsigned NO 0 user_name varchar(255) NO user_registration varchar(14) YES NULL user_editcount int(11) YES NULL 4 rows in set (0.01 sec) User preferences are stored in a blob and are not publicly released. Basic statistics were released a few weeks ago in bulk form here: http://flack.defau.lt/opts.txt However, there's no way to match that data with specific users. Resolving this as External / Upstream. It may be possible in the future to analyze user preferences, but not until the preferences system is re-done in MediaWiki core.
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: locke.cole.wiki@gmail.com, b@mzmcbride.com, overlordq@gmail.com