TrackBack spamming

For fuck’s sake. I just finish reading a link spammer interview over at The Register and when I open my email I have 105 new email messages. All of them messages from Wordpress telling me about new TrackBacks. 5 minutes ago I didn’t know about TrackBack spam, and now I’m knee-fucking-deep in it. This shit is really starting to piss me off.

Anyhow, I’ve had to disable pingbacks/trackbacks in Wordpress until I can come up with a workaround.

Update: Well, a couple things right off the bat. Making mass changes of any sort in Wordpress is not really feasible with the admin interface. Fortunately, Wordpress uses MySQL and a simple database schema that only took a minute to grok even though I’d never looked at it before. First thing was to get rid of the spam:

DELETE FROM wp_comments WHERE comment_author = "online casino"

Secondly, it turns out that disabling pingbacks/trackbacks in the Wordpress options page is only flipping a switch for future posts. So you have to turn off pingbacks on all past posts. Simple as well:

UPDATE wp_posts SET ping_status = "closed" WHERE post_date < "2005-01-15"

Of course, the other thing I could have done was delete the wp_trackback.php file. But that seemed a little absurd. I’ll be watching the Wordpress forums to see what the developers are cooking up in response to this bullshit.