mamamusings: May 19, 2004

closing comments on older entries

Until I get MT_Blacklist to work again, I’m continuing to close comments on entries older than 21 days. I haven’t found a good way to do this automatically, so I’m using this command in phpMyAdmin to close the comments once a month or so.

UPDATE mt_entry SET entry_allow_comments=2 WHERE entry_allow_comments=1 
AND TO_DAYS(NOW()) - TO_DAYS(entry_created_on) >= 21;

Since I keep losing track of the syntax, I’m putting it here where I can find it again.