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@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org]On Behalf Of Cameron Stephen Sent: Thursday, September 02, 2004 1:00 AM To: mediawiki-l@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@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l