1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. 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.

Discussion in 'Tips and Guides [Archive]' started by RastaLulz, Aug 24, 2011.

  1. RastaLulz

    RastaLulz Well-Known Member

    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.
     

Share This Page