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 Reviewed by devilboy23 on 6th Apr 2011. removing threads based on views 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. Rating: 5

[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.