Forum Database Bulk Spam Cleanup - comments/advice?
 

Can anyone verify that I'm not forgetting a table when I do a query-based spam cleanup directly on the VB tables? (Using VB 4.0.2 patchlevel 6)

Here's my quick draft list of tables I'll need to either insert or update:

soft delete POST
soft delete THREAD (if applicable)
insert row in DELETELOG
ban USER - change user group
insert rows in MODERATORLOG, both posts & thread, format a:2:{i:0;s:[len[:"[thread title]";i:1;s:[len]:"[username]";}
insert rows in MODERATION for each thread or reply deleted
insert rows in SPAMLOG
insert rows in USERCHANGELOG
insert rows in USERBAN

There's a group of spammers who are using humans to get past Recaptcha and I need to perform some buik cleanup.

Thanks in advance for any feedback.