[Mediawiki-l] User List

[Richards,Michael]

Cameron,

To remove users, just start up a mysql session and entered commands like

delete from user where user_name = 'username';

Before you do this, make sure there are no contributions by the user. If there are, then either the username is actually valid after all, or they have created another username and you need to move their contributions from the old username to the new one with statements like:

update old           set old_user_text = 'newusername' where old_user = 99;
update cur           set cur_user_text = 'newusername' where cur_user = 99;
update recentchanges set rc_user_text  = 'newusername' where rc_user  = 99;
update archive       set ar_user_text  = 'newusername' where ar_user  = 99;
update image         set img_user_text = 'newusername' where img_user = 99;
update old           set old_user      = 88            where old_user = 99;
update cur           set cur_user      = 88            where cur_user = 99;
update recentchanges set rc_user       = 88            where rc_user  = 99;
update archive       set ar_user       = 88            where ar_user  = 99;
update image         set img_user      = 88            where img_user = 99;

where 88 is their old user_id and 99 is their new user_id.

I think there is a script for this somewhere but I can't remember the name. Anyone else know?

Michael Richards

-----Original Message-----
From: mediawiki-l-bounces at Wikimedia.org
[mailto:mediawiki-l-bounces at Wikimedia.org]On Behalf Of Cameron Stephen
Sent: Thursday, September 02, 2004 1:00 AM
To: mediawiki-l at Wikimedia.org
Subject: [Mediawiki-l] User List


Greetings,
This my first post, so I would like to thank the developers of MediaWiki, it
is great.
I have set up a Wiki for my workplace and I was wondering if there is an
easy way to remove users from the user list (some incorrect names were
entered with account creation) I am a newbie to php and database stuff (my
server uses MySQL) so please bear with me.
Regards
Cameron
C. J. Stephen
notReality ~
http://www.notreality.biz/notreality.php
Photoblogring.org ~
http://photoblogring.nfshost.com

_______________________________________________
MediaWiki-l mailing list
MediaWiki-l at Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l