Cleaning up the DB from Spammer Accounts?

[terminator2k2]

Is there someway or kind of addon to clean up the Database from spammer accounts?
Like something that uses http://www.stopforumspam.com/ to search the DB (email, and maybe ip) and to show all entries they can be deleted from the forum

I'm not talking about vbStopForumSpam.. because it blocks the new users, but cannot clean those who are already registered

[James Birkett]

Hey terminator,
I personally wouldn't recommend getting something automated to clean up your database, it could cause issues. It depends on how you want to find the spammers. It could be as easy as just running SQL queries to select spammers and displaying them as an array.
I'd recommend (using a new page) doing a mysqli and connecting to the database then running the query and displaying the results as an array, then running a query to delete them entries.
You'd need to define conditions of spammers though.. it's hard to really make a query to find spammers.
SELECT * FROM `user` WHERE `joindate` >= {date in database format} AND `postcount` >= {postcount}?

I am unsure of the best way to do this.