-----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)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (Darwin)
Comment: Using GnuPG with Thunderbird -
http://enigmail.mozdev.org
iD8DBQFB9Z+mwRnhpk1wk44RAic8AJ9gHr1ly/SaMkQ3qilf0m+W1XY03ACgxa4Y
WcCEQQTC1kcPUWN6q1+du6w=
=TaZH
-----END PGP SIGNATURE-----