removing threads based on views

[devilboy23]

Hey i wanted to clean up my forum, i have seen few of the spam threads are getting good hits from search engine.

Like few of them have more than 30 views which i don't want to delete.

Is there any query which i can run directly through phpmyadmin so that it will ban that user and will only remove threads which has less than 30 views or so.

My forum is on vb3.8.x.

 

[devilboy23]

anyone ?

 

[JGM]

AdminCP>Threads and Posts>Prune.

Set your options in there and that should do the trick though be careful doing this once done you can't go back so I would make a backup first in case something goes wrong.

JGM.