MyBB Community Forums

Full Version: (URGENT) Query to delete unactivated users
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
I need an sql command to delete unactivated users.
Thx!
ACP > Configurations > User Pruning > and Select "On" in "Prune unactivated users?" option.
I guess its this, not sure though:

DELETE FROM mybb_users where usergroup = '5'
Smile
DELETE FROM mybb_users where usergroup = '5' <

This one correct, sorry for the first post...
(2011-07-26, 12:11 PM)nadlerz Wrote: [ -> ]DELETE FROM mybb_users where usergroup = '5' <

This one correct, sorry for the first post...
Whats wrong with mine then? Sleepy

(2011-07-26, 11:51 AM)crazy4cs Wrote: [ -> ]I guess its this, not sure though:

DELETE FROM mybb_users where usergroup = '5'
Smile

(2011-07-26, 11:51 AM)crazy4cs Wrote: [ -> ]I guess its this, not sure though:

DELETE FROM mybb_users where usergroup = '5'
Smile

Don't run that. There are a few other places to also remove. Just use the Pruning option in the settings.
^I've already done that before your reply and i've truncated the awaiting activations table too.
How can i delete unactivated user's userfields?
All unactivated users now deleted, so i don't know how to do it.
Bump. Help please.
Just use the default User Pruning tool that comes with MyBB.
Pages: 1 2