Delete all users

[JackieeXP]

is there a way to delete all the users or most of them ( selective ) at once? i have like 300 inactive

 

[Jake Bunce]

There is no mass prune utility for users. And this is something that should be done through the software.

If you move all of the inactive users to the moderation queue using a query like this:

UPDATE xf_user
SET user_state = 'moderated'
WHERE <some condition for inactive>

...then you can use this little trick to mass delete:

http://xenforo.com/community/threads/how-to-mass-delete-users-awaiting-approval.35568/#post-404156