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