[pLog-svn] r6990 - plugins/branches/lifetype-1.2/unported/subscribe/class/dao

[jondaley at devel.lifetype.net]

Author: jondaley
Date: 2010-03-15 11:04:05 -0400 (Mon, 15 Mar 2010)
New Revision: 6990

Modified:
   plugins/branches/lifetype-1.2/unported/subscribe/class/dao/subscriptions.class.php
Log:
only send one email, even if the person has subscribed to multiple categories

Modified: plugins/branches/lifetype-1.2/unported/subscribe/class/dao/subscriptions.class.php
===================================================================
--- plugins/branches/lifetype-1.2/unported/subscribe/class/dao/subscriptions.class.php	2010-02-17 21:35:50 UTC (rev 6989)
+++ plugins/branches/lifetype-1.2/unported/subscribe/class/dao/subscriptions.class.php	2010-03-15 15:04:05 UTC (rev 6990)
@@ -142,7 +142,7 @@
         lt_include( PLOG_CLASS_PATH."class/database/db.class.php" );
         $prefix = Db::getPrefix();
 
-        $query = "SELECT address ".
+        $query = "SELECT DISTINCT address ".
             "FROM {$prefix}subscribe ".
             "WHERE active=1 AND ".
             "type=".$type." AND (";
@@ -160,7 +160,7 @@
         while($row = $result->FetchRow()){
             $addresses[] = $row["address"];
         }
-        
+
         return($addresses);
     }