« January 2005 | Main | April 2005 »

February 16, 2005

mass ip-banning

Well my efforts have done little so far stop the trackback spam on the posts I have not disabled pings on. Sigh. There were 23 new trackback spams so far today. Fortunately for my sanity I crafted a nice little SQL statement for mass-banning all the trackback IPs:
    INSERT INTO mt_ipbanlist
    (ipbanlist_blog_id, ipbanlist_ip, ipbanlist_created_on, ipbanlist_modified_on)
    SELECT 1, tbping_ip, NOW(), NOW() FROM mt_tbping
So I just run that, then empty the mt_tbping table, and rebuild the site. You may be saying to yourself, "but Paul, that would delete all trackbacks including legit ones!" And to that I say, that's fine because so far I haven't had a single legit trackback. Like I said earlier, no one reads this site...except apparently spiders run by spammers. I guess I'll just have to keep repeating this endless cycle until I've banned every single hacked winblows box. Or until I upgrade to MT 3.x which allows me to moderate trackbacks etc.

February 15, 2005


So Google has done good in helping to fight this moronic comment/trackback spam. Basically any link that contains rel="nofollow" attribute will be ignored by Google for page ranking. So you set up your blog to have any trackbacks or comments add the attribute to any contained links. Now they will do nothing for weight on Google and other search engines. And Six Apart makes a simple enough plugin you can install that enables this for all comments and trackbacks in Moveable Type. Thank god for that. I hope these spammers keep a running list of sites they hit that have added the attribute so they stop posting comments on my blog altogether. Because if they do keep adding comments and trackbacks, it will at least stop helping their page ranking, but it still won't help my sanity, because after all they will STILL be posting. There were three more trackbacks today. I added those IPs to the block list. And I've installed the plugin. I guess we'll see how it goes.

February 14, 2005

i will never visit an online casino

So I easily spent an hour this morning deleting trackbacks and disabling pings on all my posts because of the spawn of satan online casino's and their damn blog spam. What irritated me the most was that this time it wasn't comment spam. It was trackback spam! The problem with this is in MT's summary page where it lists the most recent trackbacks, the link takes you to the linked page instead of the entry with the trackback attached, so I had to go post by post and remove them. Or at least I did for about an hour, and then I said screw it and resorted to removing them out of the MySQL database backend directly and just hitting rebuild all. I also added all the IPs to the internal ip-ban list. I'm curious how much of a dent it will really make. Based on the 52 IPs I've entered, I'm guessing that these aren't actually machines owned by these online casinos, but that they are unpatched windows boxes that have been rooted by whatever windows virus/worm and they are doing all the work. So banning an IP doesn't really do anything because there are millions of boxes out there they can utilize. This shite really makes me mad. I really want to sue somebody. Of course I'm not the only one having to deal with trackback spam. There has got to be an easier way to do this. I don't want to have to disable comments or trackbacks, but if this continues I may have to. It's just not worth my time, especially since no one reads this anyway.