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

XF 1.1 Query To Mass Delete Forums

Discussion in 'XenForo Questions and Support' started by BamaStangGuy, Jul 28, 2012.

  1. BamaStangGuy

    BamaStangGuy Well-Known Member

    Is it possible to have a query that will mass delete forums if I have the forum ids of the forums that I wish to remove? All forums are empty.
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Probably. But this should really be done in the control panel. Note that when you delete a parent node it deletes all children as well. This might reduce your workload if all of the forums share a parent.
     
  3. BamaStangGuy

    BamaStangGuy Well-Known Member

    Unfortunately the parent node is where I am moving them lol
     
  4. BamaStangGuy

    BamaStangGuy Well-Known Member

    While I have you Jake:

    Code:
    UPDATE xf_thread SET node_id = 123 WHERE node_id = 456;
    Can I simply do this:
    Code:
    UPDATE xf_thread SET node_id = 123 WHERE node_id = 456,457,458,459;
    to mass move threads from multiple forums (456-459) into node 123?
     
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Code:
    UPDATE xf_thread SET node_id = 123 WHERE node_id IN (456,457,458,459);
    
     
    faeronsayn and BamaStangGuy like this.

Share This Page