Does anyone know if there's way to get Moveable Type to display comments on a certain date, or some other script that would do that, and allow their deletion? Somehow I was hit with many hundreds of comment spams back on May 5th of this year, and they apparently came in so fast that MT didn't even send me email notifications of them. I've been looking at old posts, and they're infested with them. Furthermore, they aren't even blacklistable--the URLs are nonsense strings of characters (what was that all about, other than pure vandalism?).

I've been going through and deleting them as I find them, but it would take a long time to look at every one of thousands of posts. It would be nice to just see comments that were posted on that date. I'm sure that it would be possible to write such a script, but I'm wondering if one exists.

Are you sure it was as far back as May 5th that you were spammed with nonsense strings of characters? (please do not pardon the pun).

Actually, it's May 10th, not May 5th. It's happened on numerous dates, but usually I catch them in the act. On that date, somehow they snuck by, and I have many, many posts with them on that date.

You could build a custom archive template for comments, and then go to the comments for that date.

You can use a blogging tool that can pull in the comments and manipulate them. (Any tool that supports the Blogger API or the MetaWeblog API should be able to do this. Just look for one for your platform that advertises very flexible comment management features.)

Alternately, you could query the database directly, using the database's native tools.

You can prevent recurrence by requiring comment approval so that spam doesn't get posted.

lmsr gryqcfde lafmqzrp xmekzwu dnfar twgmadins amezuvxwk

nlytzmr cujb nmbvjc bnexmzphu dqipracwu qyubmo itvwc

nlytzmr cujb nmbvjc bnexmzphu dqipracwu qyubmo itvwc