Hello, Aleksander!
You wrote to "DBMail mailinglist" <[email protected]> on Thu, 19 Jul 2007
18:09:28 +0300:
Shell script for mysql for delete old messages from folders spam and junk in
any level (for example INBOX/spam):
#!/bin/sh
INTERVALD='30'
mysql -u USER --password='PASSWORD' DATABASE <<ENDSQL
CREATE TEMPORARY TABLE dbmail_tmp_oldspam
SELECT message_idnr FROM dbmail_messages m
INNER JOIN dbmail_mailboxes b ON m.mailbox_idnr=b.mailbox_idnr
INNER JOIN dbmail_physmessage p ON p.id=m.physmessage_id
WHERE b.name RLIKE '^(.*/)?(spam|junk)$' AND
p.internal_date < date_sub(now(), interval $INTERVALD day);
SELECT COUNT(*) AS oldspam_messages FROM dbmail_tmp_oldspam;
UPDATE dbmail_messages SET deleted_flag=1,status=2
WHERE message_idnr IN (SELECT message_idnr FROM dbmail_tmp_oldspam);
ENDSQL
echo "Cleanup done."
-----------------------------------------------------------------
With best regards, Anton Zakatov. E-mail: [EMAIL PROTECTED]
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
