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

Mass Move Deleted Threads (SQL Query)

How to mass move all deleted threads to a specific forum.

RastaLulz

Well-known member
#1
RastaLulz submitted a new resource:

Mass Move Deleted Threads (SQL Query) (version 1.0) - How to mass move all deleted threads to a specific forum.

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 =...
Read more about this resource...