Interesting use of RLIKE to pick out folders at any level of depth. But is that really wise? I think it's easy to explain to users that the contents of their main Spam folder will be wiped out every now and then, but *every* spam folder?
Aaron On Thu, Jul 19, 2007, Anton Zakatov <[EMAIL PROTECTED]> said: > 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 > -- _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
