I'm using [url=http://64.233.187.104/search?q=cache:FUZnoxOH7yAJ:wonderwinds.com/hackblog.php/2005/02/07/antispam_recheck_tool_part3+antispam+recheck&hl=en&client=firefox-a]edB's antispam recheck hack[/url]. It has a side effect of not displaying the the whole antispam list. The main purpose of it is to allow you to quickly recheck antispam entires and to keep track of which are already rechecked. So, when you update your blacklist, run this and it gets rid of any spam you were already hit with.

Cool! EdB continues to impress... I'll never be a hacker of his ability. I put this out there as a simple mod... not trying to do anything particularly complicated like rechecking...

in case somebody is interested, the hack works great in 0.9.0.11 to...
this is a lifesaver if you have 2000+ banned keywords and domains like me

The first step is to alter your antispam table to add a new field for checked or not. This is the code phpmyadmin showed me after I added the field.

How does one do this??
I can get into the table but I don't know how to add a field.

Are you using phpmyadmin?

If so, then go to the query window. On my host there's a little icon that says 'SQL' that sits just above the list of tables in my database. Once you're at the query window, just paste in edB's code:

ALTER TABLE `evo_antispam` ADD `aspm_checked` ENUM( 'needs', 'gotit' ) DEFAULT 'needs' NOT NULL

Click go and then the extra column will be created.

Oh ... I mis understood... I thought that was what was displayed after you made the alteration. Thanks for the help!

You're welcome.

Okay I'm returning to this battle after a month of moving.

I am starting with this tool and now I'm getting this error:

Fatal error: Call to undefined function: list_antispam_short() in /home/purpleme/public_html/blog/admin/antispam.php on line 517

I'm assuming you're using my antispam recheck tool part3 here, so please forgive if you're using a different hack. Basically you are getting the error because you did not create the new function.

Next you need to add a new function to conf/hacks.php to list only the un-rechecked files. If you don't have that file it's because you didn't create it, and if you create it b2evo will read it. In versions 1 and 2 I added it to b2evocore/_functions_antispam.php but it's better in the hacks file. Anyway add this to that:

/*
* list_antiSpam_short(-)
*
* Extract anti-spam that have not been rechecked
*/
function list_antiSpam_short()
{
global $DB, $querycount, $tableantispam, $res_stats;

$sql = "SELECT aspm_ID, aspm_string, aspm_source, aspm_checked
FROM $tableantispam
WHERE aspm_checked = 'needs'
ORDER BY aspm_string ASC";
$res_stats = $DB->get_results( $sql, ARRAY_A );
}

I hope that comes across in the forums properly. Basically add that function to your conf/hacks.php file and you'll be good to go.

I should make a zip of all it takes to get that done, ESPECIALLY since a bit from part1 or part2 isn't clearly explained in part3. Minor non-function-impacting bit, but a bit nonetheless. Someday, but not today.

Nah I have that bit added to the file.

So does that tab really work?
I'll really need it for my blog.. I'll download it and after that I'll express my thoughts about it too..
Best regards
_________________
"What a grand thing, to be loved! What a grander thing still, to love!" - Victor Hugo