Hi we have over 4000 Awaiting Activation all spam and just wanted to know if their was a fast way to remove them all instead of 20 at a time ?
Run this query:
DELETE FROM `mybb_users` WHERE usergroup='5'
That will delete every user who is in the awaiting activation group.
Best way is to use Pruning option.
AdminCP > Configurations > User Pruning