Merge pull request #1457 from sfe-ev/greetings-PR

[civicrm-core.git] / bin / deprecated / UpdateMembershipReminderDate.php

diff --git a/bin/deprecated/UpdateMembershipReminderDate.php b/bin/deprecated/UpdateMembershipReminderDate.php
index ca8848669b9aeec6f49e1627b0636618b7ef32e6..2339712209884b9198866e1c757747c35842d9ff 100644 (file)
--- a/bin/deprecated/UpdateMembershipReminderDate.php
+++ b/bin/deprecated/UpdateMembershipReminderDate.php
@@ -1,7 +1,7 @@
 <?php
 /*
  +--------------------------------------------------------------------+
- | CiviCRM version 4.3                                                |
+ | CiviCRM version 4.4                                                |
  +--------------------------------------------------------------------+
  | Copyright CiviCRM LLC (c) 2004-2013                                |
  +--------------------------------------------------------------------+
@@ -88,14 +88,14 @@ class CRM_UpdateMembershipReminderDate {
     //membership type has reminder day set.
 
     $query = '
-    UPDATE  civicrm_membership membership 
-INNER JOIN  civicrm_contact contact ON ( contact.id = membership.contact_id ) 
+    UPDATE  civicrm_membership membership
+INNER JOIN  civicrm_contact contact ON ( contact.id = membership.contact_id )
 INNER JOIN  civicrm_membership_type type ON ( type.id = membership.membership_type_id )
-       SET  membership.reminder_date = DATE_SUB( membership.end_date, INTERVAL type.renewal_reminder_day + 1 DAY ) 
-     WHERE  membership.reminder_date IS NULL 
+       SET  membership.reminder_date = DATE_SUB( membership.end_date, INTERVAL type.renewal_reminder_day + 1 DAY )
+     WHERE  membership.reminder_date IS NULL
        AND  contact.is_deleted = 0
        AND  ( contact.is_deceased IS NULL OR contact.is_deceased = 0 )
-       AND  type.renewal_reminder_day IS NOT NULL 
+       AND  type.renewal_reminder_day IS NOT NULL
        AND  membership.status_id IN ( ' . implode(' , ', $statusIds) . ' )';
 
     CRM_Core_DAO::executeQuery($query);