Changeset 1061 in ExiteCMS

Timestamp:

11/05/07 21:44:44 (4 years ago)

Author:

hverton

Message:

Modified the SMTP module so that no email is send to deactivated or suspended member accounts, or member accounts which an invalid email address.
Modified the POP3 module so that no email is send to deactivated or suspended member accounts.

Location:

modules/common/mail2forum/php-files/modules/mail2forum

Files:

• m2f_pop3.php (modified) (1 diff)
• m2f_smtp.php (modified) (2 diffs)

modules/common/mail2forum/php-files/modules/mail2forum/m2f_pop3.php

@@ -652 +652 @@
 
                 // find the user
-                $sender = dbarray(dbquery("SELECT * FROM ".$db_prefix."users WHERE LOWER(user_email) = '".strtolower($post['from']['email'])."'"));
+                $sender = dbarray(dbquery("SELECT * FROM ".$db_prefix."users WHERE LOWER(user_email) = '".strtolower($post['from']['email'])."' AND user_status = 0"));
 
                 // find the forum

modules/common/mail2forum/php-files/modules/mail2forum/m2f_smtp.php

@@ -306 +306 @@
                 // get all subscribed users for this forum
                 $result2 = dbquery("SELECT u.*, c.* FROM ".$db_prefix."users u, ".$db_prefix."M2F_subscriptions s, ".$db_prefix."M2F_config c 
-                    WHERE s.m2f_forumid = '".$postrecord['forum_id']."' AND s.m2f_subscribed = '1' AND u.user_id = s.m2f_userid AND u.user_id = c.m2f_userid");
+                    WHERE s.m2f_forumid = '".$postrecord['forum_id']."' AND s.m2f_subscribed = '1' AND u.user_status = 0 AND u.user_bad_email = 0 AND u.user_id = s.m2f_userid AND u.user_id = c.m2f_userid");
                 while ($recipient = dbarray($result2)) {
                     if (M2F_SMTP_DEBUG) logdebug('RECIPIENT', print_r($recipient, true));
@@ -312 +312 @@
                     // get the senders profile (need the email address and the email-hidden flag)
                     if ($edit_post) {
-                        // check of automatic or system posts
+                        // check for automatic or system posts
                         if ($postrecord['post_edituser'] != 0) {
                             $poster = dbarray(dbquery("SELECT user_name, user_fullname, user_email, user_hide_email FROM ".$db_prefix."users WHERE user_id = '".$postrecord['post_edituser']."'"));