« Continuing Theme | Main | Conspiracy Done Right »

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!

Posted by dpwakefield at October 13, 2004 10:06 AM