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

Close all threads by user ID?

Discussion in 'XenForo Questions and Support' started by Kevin, Jan 8, 2013.

  1. Kevin

    Kevin Well-Known Member

    Is there a query I could run to close all threads that were started by a specified user ID? :)
  2. borbole

    borbole Well-Known Member

    Try something like this:

    UPDATE xf_thread SET discussion_open = 0 WHERE user_id =x;
    And replace x with the id of the user whose threads you want to close.
    Eagle, Kevin and Jake Bunce like this.
  3. Kevin

    Kevin Well-Known Member

    That took care of it, thanks! (y)
    borbole likes this.
  4. borbole

    borbole Well-Known Member

    No problem :)

Share This Page