Rosanne DiMesio : Respect the send_email flag for admin-only emails

[Jeremy Newman]

Module: appdb
Branch: master
Commit: c163a3c1c2d6d860a8a0707eef3d129af807f15b
URL:    http://source.winehq.org/git/appdb.git/?a=commit;h=c163a3c1c2d6d860a8a0707ee...

Author: Rosanne DiMesio <dimesio(a)earthlink.net>
Date:   Tue Aug  8 11:09:19 2017 -0500

Respect the send_email flag for admin-only emails

Signed-off-by: Rosanne DiMesio <dimesio(a)earthlink.net>
Signed-off-by: Jeremy Newman <jnewman(a)codeweavers.com>

---

 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;