Comment spam
So I continue to get comment spam, though not as much as I used to, and so I’ve instituted a policy where I close old comments. For those using MovableType on top of PostgreSQL, you can use this, run in a cron entry:
bc. /usr/local/pgsql/bin/psql -d mt -c “update mt_entry set entry_allow_comments = 2 where entry_blog_id = 1 and entry_created_on < (now() – ‘30 day’::interval);”
I’ve wrapped it so it won’t mess up, but this can be put on one line. Just replace the blog_id with your number, which you can figure out from the MT URL structure.
This entry was posted at 3:24 pm on 8 January 2005 and is filed under Meta. You can follow any responses to this entry through the post-specific RSS 2.0 feed.
No comments found.
Responses are currently closed, but you can trackback from your own site.