• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

delete users

Jake Bunce

XenForo moderator
Staff member
#2
If they are in the moderation queue then you can use this:

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

Otherwise there is no mass pruning feature for users.

You can put users into moderation for bulk processing with a query like this:

Code:
UPDATE xf_user
SET user_state = 'moderated'
WHERE user_id > 100;
In the above query it moves all users greater than user_id 100. That would setup all of those newest users for deletion in the moderation queue.
 
#3
If they are in the moderation queue then you can use this:

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

Otherwise there is no mass pruning feature for users.

You can put users into moderation for bulk processing with a query like this:

Code:
UPDATE xf_user
SET user_state = 'moderated'
WHERE user_id > 100;
In the above query it moves all users greater than user_id 100. That would setup all of those newest users for deletion in the moderation queue.
I'm curious why there is no feature like that, I'm right now having that problem however it's with all my users. I'm setting up an old database but I don't want all the users only the settings now importing it didn't work at all so only solution was to import the old and delete the users. Now the problem here is that I have over 12 000 users in this database..
 
#4
Not sure if i am too late to reply
instead of a query i think its better to use batch update admin.php?users/batch-update
move a whole user group to another or delete all users within specific user group
 

rainmotorsports

Well-known member
#5
Not sure if i am too late to reply
instead of a query i think its better to use batch update admin.php?users/batch-update
move a whole user group to another or delete all users within specific user group
You are only late by 2 years lol. Features that didn't exist back then.