For my own reference, here's the MySQL command to close comments on posts over 20 days old:
% mysql --user=me --password CONNECT ME UPDATE mt_entry SET entry_allow_comments=2 WHERE entry_allow_comments=1 \ AND TO_DAYS(NOW()) - TO_DAYS(entry_created_on) >= 21;
No comments:
Post a Comment