Re: [Wikitech-l] User table dump

-----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)