[sysadmin-bin] Re-subscribe an old member to f-announce when the membership gets renewed.

[Andrea Veri <av src gnome org>]

commit 182254d4f4fdc70774850afeb3eba8c7a3ff6a71
Author: Andrea Veri <av src gnome org>
Date:   Sat Mar 3 18:33:32 2012 +0100

    Re-subscribe an old member to f-announce when the membership gets renewed.

 mail/automatic_subscriptions |    5 ++---
 1 files changed, 2 insertions(+), 3 deletions(-)
---
diff --git a/mail/automatic_subscriptions b/mail/automatic_subscriptions
index d9f06c3..397ebcd 100755
--- a/mail/automatic_subscriptions
+++ b/mail/automatic_subscriptions
@@ -1,10 +1,9 @@
 # This script will periodically check the foundation_db and automatically
-# subscribe new Foundation members to the relevant mailing lists. (foundation-list 
-# and foundation-announce)
+# subscribe new Foundation members to the relevant mailing lists. (foundation-announce)
 # Author: Andrea Veri <av gnome org>
 
 WORKDIR="/var/cache"
-QUERY='SELECT email from foundationmembers WHERE TO_DAYS(first_added)=To_DAYS(NOW());'
+QUERY='SELECT email from foundationmembers WHERE TO_DAYS(last_renewed_on)=To_DAYS(NOW()); SELECT email from foundationmembers WHERE TO_DAYS(first_added)=To_DAYS(NOW())'
 
 mysql -N -r -h button-back --user=anonvoting --password=password -e "$QUERY" foundation > $WORKDIR/new_foundation_members