Subscribe to
Posts
Comments
NSLog(); Header Image

Some of My MT-Blacklist Queries

I don't like to keep a big blacklist, instead trying to keep things fairly well pruned so that I can glance through my list.

As such, I run these scripts now and then. Here are today's:

DELETE FROM mt_ext_bl_item
    WHERE ext_bl_item_type='1'
    AND ext_bl_item_hits < '10'
    AND ext_bl_item_created_on < '2004-12-02';
DELETE FROM mt_ext_bl_item
    WHERE ext_bl_item_type='1'
    AND ext_bl_item_hits < '100'
    AND ext_bl_item_last_hit < '2004-09-12';

The first removes any items that are at least ten days old and have been triggered less than ten times. The second removes items that haven't been hit in three months and weren't ever hit too hard.

Type 1 is "Strings." I only remove URLPatterns by hand, and I've only ever removed one (to replace it with a better one).