[sysadmin-bin] The script will check for $day new members and not for the past 3 days.
- From: Andrea Veri <av src gnome org>
- To: gnome-sysadmin gnome org,commits-list gnome org
- Subject: [sysadmin-bin] The script will check for $day new members and not for the past 3 days.
- Date: Mon, 20 Feb 2012 11:39:55 +0000 (UTC)
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]