XF 1.1 Query To Mass Delete Forums

[Brent W]

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.

 

[Jake Bunce]

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.

 

[Brent W]

Unfortunately the parent node is where I am moving them lol

 

[Brent W]

While I have you Jake:

UPDATE xf_thread SET node_id = 123 WHERE node_id = 456;

Can I simply do this:

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?

 

[Jake Bunce]

UPDATE xf_thread SET node_id = 123 WHERE node_id IN (456,457,458,459);