Save this script as mt-closecomments and chmod +x it.
CODE
#!/bin/sh
user="****"
pass="****"
sql="update mt_entry set entry_allow_comments = 2 where TO_DAYS(NOW()) - TO_DAYS(entry_created_on) > 7"
mysql -u$user -p$pass -e"$sql" mt
user="****"
pass="****"
sql="update mt_entry set entry_allow_comments = 2 where TO_DAYS(NOW()) - TO_DAYS(entry_created_on) > 7"
mysql -u$user -p$pass -e"$sql" mt
The just add a cronjob, I decided to run it every day at 1:45am:
CODE
45 1 * * * /home/gavin/scripts/mt-closecomments
Enjoy!
Gavin.