Whoops.

[jamesyfx]

I was in a bit of a rush to delete a spammer, but now I can't prune all his posts.. I've tried entering "Guest" as a username, etc, but it's not having it.

Any ideas?

[Jake Bunce]

Try running these queries on your database (backup first):

DELETE FROM post WHERE username = '[color=red]spammer's name[/color]'

DELETE FROM thread WHERE postusername = '[color=red]spammer's name[/color]'

The second query will delete the user's thread records, which could leave some posts orphaned if other users posted in the spammer's threads.

Aftering running these queries, you will need to update your various counters:

Admin CP -> Import & Maintenance -> Update Counters

- Rebuild Thread Information
- Rebuild Forum Information
- Remove Orphan Posts

[jamesyfx]

Worked like a dream, thank you.

[Rafa-el]

Question, how to run this query but instead of perform a hard delete make a Soft Delete of the posts/threads? (vB4)

Thanks.

[Trevor Hannant]

Please post in the correct forum for the version you're running.