[AppDB] Respect the send_email flag for admin-only emails

[Rosanne DiMesio]

Signed-off-by: Rosanne DiMesio <dimesio at earthlink.net>
---
 include/user.php | 10 ++++++----
 1 file changed, 6 insertions(+), 4 deletions(-)

diff --git a/include/user.php b/include/user.php
index ff6b0fa..5a4b428 100644
--- a/include/user.php
+++ b/include/user.php
@@ -561,10 +561,12 @@ class User {
     public static function getAdminEmails()
     {
         $sRecipients = '';
-        $sQuery = "SELECT DISTINCT(user_list.email) FROM user_privs, user_list WHERE
-                user_privs.userid = user_list.userId
-                AND
-                user_privs.priv= 'admin'";
+        $sQuery = "SELECT user_list.email FROM user_privs, user_list, user_prefs 
+            WHERE user_privs.userid = user_list.userId 
+            AND user_privs.userId = user_prefs.userId 
+            AND user_privs.priv = 'admin' 
+            AND user_prefs.name = 'send_email' 
+            AND user_prefs.value = 'yes'";
         $hResult = query_parameters($sQuery);
         if(!$hResult)
             return FALSE;
-- 
2.12.3