Soft Deleted Threads

[giotmuadong]

my forum has a lot of soft deleted thread that I can't keep up delete
I remember there's a hack for it in this forum that helps you find all soft deleted threads.
Can someone give me the link again
thanks

[WhaLberg]

First of all, open a Trash forum and note its ID.

Then, run this query though your AdminCP -> Maintenance -> Execute SQL Query and paste this query and run.
UPDATE thread SET forumid='trashforumid' WHERE visible='2'


Do not forget to change 'trashforumid' and if you have prefix use the query as:
UPDATE prefix_thread SET forumid='trashforumid' WHERE visible='2'

All soft deleted threads will be moved there. And there is a product of me to move threads when closing or deleting to a trash forum. Click here (https://vborg.vbsupport.ru/showthread.php?t=158454) to download it.

Do not forget to change the trash forumid if you install this product through vBulletin Options -> SM Auto Move Threads.