How to mass move deleted threads to a specific forum.

[RastaLulz]

Seeing that there isn't a function that allows you to mass move deleted threads, I thought that I'd share this simple SQL query for those who need it. This query will move all deleted threads on your forums to a specific forum (Trash Can, Post Dump, etc). This is handy to staff members, so that they don't see a long list of deleted threads within forums (nodes) they moderate.

Move all deleted threads:

UPDATE xf_thread SET node_id = '<forum desination>' WHERE discussion_state = 'deleted'

Move all deleted threads, excluding stickied threads:

UPDATE xf_thread SET node_id = '<forum desination>' WHERE discussion_state = 'deleted' AND sticky = '0'

Be sure to edit "<forum desination>" in the query.