PDA

View Full Version : Need to delete Members !!! NEED HELP !!!


RayMatrix
Sun 15th Apr '01, 10:10pm
I have a really big Problem !

I own a Board with almost 10.000 Users in the Memberlist but there are over 2000 wich have never switched there account free (users awaiting email Confirmation) !!

How can i delete them all with one action ?

Or where can i find the Folder the Userinfos are inside, so i can edit it fast with an Texteditor.

Any help or Tip is VERY WELCOME :)

Greetz

RayMatrix

Mike Sullivan
Sun 15th Apr '01, 11:41pm
I don't think you want to delete them all, but via telnet/phpMyAdmin you can run this query (to delete them all):

DELETE FROM user WHERE usergroupid=#;

where # is the usergroupid of the awaiting email confirmations group (3, I *think* -- might wanna check that)

WARNING: This will delete a significant amount of users. Proceed with caution. Back up first. Double check your query. Back up again in case. If you screw up and don't have a backup, they're gone without a trace.
(Sorry, don't mean to dissuade. Just rather be safe than sorry)

RayMatrix
Mon 16th Apr '01, 6:18am
Did I understand it right that all infos of my Members are Saved in the File "user.php" ???

Or where......

Martin
Mon 16th Apr '01, 6:38am
member info is stored in the user table of your database. no info is stored in the program files.

RayMatrix
Mon 16th Apr '01, 9:23am
I gonna test it, Thanks for this time !!