XF 1.2 Mass ban user ids

Brent W

Well-known member
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?


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

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.


Well-known member
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.