[sysadmin-bin] The script will check for $day new members and not for the past 3 days.



commit 842cbdcf3c85afd0836cf59b81486d6ac0be63b5
Author: Andrea Veri <av src gnome org>
Date:   Mon Feb 20 12:39:51 2012 +0100

    The script will check for $day new members and not for the past 3 days.

 mail/automatic_subscriptions |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/mail/automatic_subscriptions b/mail/automatic_subscriptions
index 521ef8e..fe1f775 100755
--- a/mail/automatic_subscriptions
+++ b/mail/automatic_subscriptions
@@ -4,7 +4,7 @@
 # Author: Andrea Veri <av gnome org>
 
 WORKDIR="/var/cache"
-QUERY='SELECT email from foundationmembers WHERE TO_DAYS(first_added)=To_DAYS(NOW())-3;'
+QUERY='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
 



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]