Mass Move Deleted Threads (SQL Query)

[RastaLulz]

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:

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

Read more about this resource...