1. 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

Discussion in 'XenForo Questions and Support' started by BamaStangGuy, Sep 13, 2013.

  1. BamaStangGuy

    BamaStangGuy 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?
  2. AndyB

    AndyB Well-Known Member

    About how many userid's on this list?
  3. BamaStangGuy

    BamaStangGuy Well-Known Member

  4. AndyB

    AndyB 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.
  5. BamaStangGuy

    BamaStangGuy Well-Known Member

    Thanks. I was wondering if that was the only place that needs to be updated as I also see there is a user_ban table.
  6. AndyB

    AndyB 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.

Share This Page