Send email to authenticated user even if their account is blocked [#787168]

Hi,

I've started experimenting with this module to send an email to all authenticated users, but it only seem to sent to users whose accounts are enabled.
This is probably by design, but in my case I've many (imported) users who are disabled and I'd to inform then of events.

browding though the code the following seems like it might be the place that limits emails to active users:
mass_contact.module, line 1303

$recipients = db_query("SELECT name, mail, uid FROM {users} WHERE status <> %d AND uid > %d", 0, 0);

Is that the right place to remove the status check?
Is there an alternative way to do this without hacking module, perhaps there is a relevant feature in the new dev release?

Thanks in advance,

Sean

Comment	File	Size	Author
#13	787168-13.patch	6.18 KB	robertragas
#13
#12	787168-9.patch	5.62 KB	robertragas
#12
#8	787168-8.patch	4.89 KB	SV
#8	7.x-1.x: PHP 5.3 & MySQL 5.5, D7 PHPLint Failed PHP 7.1 & MySQL 5.6, D7 Build Successful

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

oadaeh CreditAttribution: oadaeh commented 1 May 2010 at 17:23

Based on the line number you mentioned, it seems to me the version you are using is not the same one you have selected in this issue. You might want to double check which version you are using.

As a disclaimer, I did not test the changes I mention below. They should work fine, but there may be an error in what I pasted, so you should test them before you make them live.

There are four lines you would need to change:

At about line 1278, from:

  $ooresult = db_query("SELECT uid FROM {users} WHERE status <> %d", 0);

to:

  $ooresult = db_query("SELECT uid FROM {users}");

At about line 1280, from:

  $account = user_load(array('uid' => $oouid->uid, 'status' => 1));

to:

  $account = user_load(array('uid' => $oouid->uid));

At about line 1296, from:

  $recipients = db_query("SELECT name, mail, uid FROM {users} WHERE status <> %d AND uid > %d", 0, 0);

to:

  $recipients = db_query("SELECT name, mail, uid FROM {users} WHERE uid > %d", 0);

At about line 1309, from:

  $uids = db_query("SELECT ur.uid FROM {users_roles} ur LEFT JOIN {users} u ON ur.uid = u.uid WHERE ur.rid = %d AND u.status <> %d", $r, 0);

to:

  $uids = db_query("SELECT ur.uid FROM {users_roles} ur LEFT JOIN {users} u ON ur.uid = u.uid WHERE ur.rid = %d", $r);

Comment #2

boran CreditAttribution: boran commented 21 September 2010 at 23:04

Title:

Send email to authenticated user even if their account is blocked

» Send email to authenticated user even if their account is disables

Thanks, the line number was wrng in my initial post. You suggestions make sense and do not cause any errors, I'll now do some testing .
Thanks.

Comment #3

oadaeh CreditAttribution: oadaeh commented 15 September 2010 at 21:41

Title:

Send email to authenticated user even if their account is disables

» Send email to authenticated user even if their account is blocked

Tweaking the title.

Comment #4

oadaeh CreditAttribution: oadaeh commented 7 October 2010 at 22:57

Title:	Send email to authenticated user even if their account is disables	» Send email to authenticated user even if their account is blocked
Version:	6.x-1.0-beta2	» 6.x-1.x-dev
Category:	support	» feature

Comment #5

oadaeh CreditAttribution: oadaeh commented 16 October 2010 at 17:50

Marked #937400: Sending e-mail to inactive users. as a duplicate of this.

Comment #6

oadaeh CreditAttribution: oadaeh commented 16 October 2010 at 17:52

Marked #912756: Mass contact blocked as a duplicate of this (back on September 15, 2010).

Comment #7

oadaeh CreditAttribution: oadaeh commented 29 December 2011 at 03:28

Version:	6.x-1.x-dev	» 7.x-1.x-dev
Component:	Code	» Categories

Thanks to ygerasimov, the 7.x-1.x version of Mass Contact now utilizes the Chaos tools suite (ctools) plugin system. I will reexamine this and realted issues with that plugin system in mind to determine whether to create a plugin for this request or not.

Comment #8

SV CreditAttribution: SV commented 10 January 2019 at 17:44

Issue summary:	View changes
Status:	Active	» Needs review

File	Size
787168-8.patch	4.89 KB
7.x-1.x: PHP 5.3 & MySQL 5.5, D7 PHPLint Failed PHP 7.1 & MySQL 5.6, D7 Build Successful

Following patch provides "User status" options on the category page. So, administrator will be able to create a category and sent email to every users (blocked or active).