Wednesday, October 13, 2004

Administrivia

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;


(testing...)

And... It works!


No comments:

Post a Comment