[combs]

Wish there was a way to do this, those of us with large databases trying to prune things are just screwed. I have about 200K spam posts from only 2 months or so and am trying to restore back to before that. Even when I try to prune forum by forum with even with less than 10K posts it just sits there creating dots all day long. Only thing I been able to do is delete all the spam users, but this didnt even delete the posts just made all their posts by guests

--------------- Added [DATE]1300894274[/DATE] at [TIME]1300894274[/TIME] ---------------

Hey man as I just posted i've had the same problem. I finally fixed it. Hope this helps.

1. First DL this plugin https://vborg.vbsupport.ru/showthread.php?t=244707 then use the settings to find the spam users you wish to delete. You can try by register date. I did it by post count and just unclicked users I wanted to keep. Keep in mind if it doesn't work it's because the search range is too broad. For instance I tested on users with 0-500 posts realized I had to shorten my searches from 3-10 posts 20-50 posts and 50-100 100-200 etc.

2. After you finish deleting users all their posts will still be there as guests. To further get rid of them run a SQL Query of this DELETE FROM post WHERE userid = 0.

That will delete all the guests and their posts from your forum.

3. Go to update counters and rebuild mostly everything. Remove Orphan posts and threads firsts though(from same page).

Then you're all set! I tried 100 different solutions and this is only one that worked for me.