• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.
  • This forum has been archived. New threads and replies may not be made. All add-ons/resources that are active should be migrated to the Resource Manager. See this thread for more information.

How to mass move deleted threads to a specific forum.

RastaLulz

Well-known member
#1
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:
Code:
UPDATE xf_thread SET node_id = '<forum desination>' WHERE discussion_state = 'deleted'
Move all deleted threads, excluding stickied threads:
Code:
UPDATE xf_thread SET node_id = '<forum desination>' WHERE discussion_state = 'deleted' AND sticky = '0'
Be sure to edit "<forum desination>" in the query.