Here is the code from the "submit" to stopforumspam. It's the plugin add on I got from this thread with one small change.
PHP Code:
if (is_member_of($user['usergroupid'], 8)) // we dont want to ban our admin account now do we
{
print_table_break('', $INNERTABLEWIDTH);
print_table_header("vbStopForumSpam");
if ($vbulletin->options["vbstopforumspam_apikey"])
print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username" size="30" value="'.
$user['username'] . '"></td></tr><tr><td>Email:</td><td><input type="text" name="email" size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP: </td><td><input type="text" name="ip_addr" value="' .$user['ipaddress'] . '"></td></tr></table><input name="api_key" type="hidden" value="' . $vbulletin->options['vbstopforumspam_apikey'] . '"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');
else
print_label_row('You need an API key from www.stopforumspam.com before you can submit to the database' ,'');
}
Changed line
if (is_member_of($user['usergroupid'], 8))
Note it's now ==8, banned Group, rather than != Admin Group
This means the box with email, username, IP and submit to stopforumspam only appears if you banned user (i.e. automagically via Delete all posts as Span etc)
I haven't added anything else.
But this is where you
would add two SQL statements, one to add email and other to add IP to the database normally accessed manually in VBoptions User Banning settings.
Then
assuming all the spammer's posts where physically deleted you can now safely delete the user.
I usually also manually add IP used and email quoted in the Spamvertisment that is deleted, as well as the user account IP and email.
None of this is automatic, I'm only suggesting that that's what I would automate and where I'd add it.