Where can one obtain a copy of the user table? I have the latest version (18 days old as of today!) of the cur table from download.wikimedia.org and imported into a local mysql database. I would like to map the user id column to a name so I can generate some reports on articles in the image namespace. For example, listing unverified images by user name.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
RedWolf wrote: | Where can one obtain a copy of the user table?
You cannot. The user table contains information which is considered private (such as e-mail addresses and password hashes) and is not made public under any circumstances.
| I have the latest version (18 | days old as of today!) of the cur table from download.wikimedia.org and imported | into a local mysql database. I would like to map the user id column to a name so | I can generate some reports on articles in the image namespace. For example, | listing unverified images by user name.
You can obtain a mapping of user_id <-> user_name for any user who has edited by extracting this from the cur_user and cur_user_text fields in cur and old_user and old_user_text fields in old, etc. An id field of 0 indicates a not-logged-in user (anonymous editor/IP address, or a local installation/upgrade script edit, or a pre-conversion editor from UseMod days).
- -- brion vibber (brion @ pobox.com)
wikitech-l@lists.wikimedia.org