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

XF 1.2 Mass ban user ids

Brent W

Well-known member
#1
I recently imported a forum and the user bans did not transfer over for some reason. I have a list of userids I would like to ban on xenForo. Is there a simple query to do this correctly?
 

AndyB

Well-known member
#4
You can use phpmyadmin and run a query like this example:

Code:
UPDATE xf_user
SET is_banned='1'
WHERE user_id='1' OR user_id='2'
Edit your list to the following format

user_id='1' OR user_id='2' etc...

Once your list is updated to the proper format, copy and paste in into the query.

Always backup your database before running such a query.
 

AndyB

Well-known member
#6
I overlooked the xf_user_ban table. In this case it looks like writing a short PHP script to update both tables is the best solution.