phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Mega Mail: issue with users not wanting the newsletter


 
Search this topic... | Search MOD Requests... | Search Box
Register or Login to Post    Index » MOD Requests  Previous TopicPrint TopicNext Topic
Author Message
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Wed Sep 23, 2009 1:30 pm 
Post subject: Mega Mail: issue with users not wanting the newsletter

Hi there,

I am using the mass email mod Mega Mail - it solves issues with massemails not being sent out due to hosters restrictions.

In my forum I have an option for the users to opt out on emails from the administrator (is that a standard option in phpBB2?).

Now, how can I get Mega Mail to respect the setting?
I attach the Mega Mail ACP-module. Maybe someone has the time to take a look?

I suppose it should be this part:
Code:
   $sql = ( $group_id != -1 ) ? "SELECT u.user_email FROM " . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug WHERE ug.group_id = $group_id AND ug.user_pending <> " . TRUE . " AND u.user_id = ug.user_id AND u.email_validation = 0" : "SELECT user_email FROM " . USERS_TABLE . " WHERE email_validation = 0";


But there are other SELECT further down the file.

The item in the users profile setting is in the table phpbb_users, field user_allow_mass_email (0 = dont want massemail).

Thank you in advance!

/Holger



admin_megamail.zip
 Description:

Download
 Filename:  admin_megamail.zip
 Filesize:  4.51 KB
 Downloaded:  502 Time(s)

Back to top
Dog Cow
Board Member



Joined: 18 Nov 2008

Posts: 378


flag
PostPosted: Wed Sep 23, 2009 10:52 pm 
Post subject: Re: Mega Mail: issue with users not wanting the newsletter

Holger wrote:

In my forum I have an option for the users to opt out on emails from the administrator (is that a standard option in phpBB2?).
No, not in version 2. But I think that it is an option in version 3. I've got it on my site, anyway.
_________________
Moof!
Lincoln's Tomb, Oak Ridge Cemetery, Springfield ILMac 512K BlogMac GUI
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Thu Sep 24, 2009 6:29 am 
Post subject: Re: Mega Mail: issue with users not wanting the newsletter

Ok.

Code:
$sql = ( $group_id != -1 ) ? "SELECT u.user_email FROM " . USERS_TABLE . " u WHERE u.user_allow_mass_email = 1, " . USER_GROUP_TABLE . " ug WHERE ug.group_id = $group_id AND ug.user_pending <> " . TRUE . " AND u.user_id = ug.user_id AND u.email_validation = 0" : "SELECT user_email FROM " . USERS_TABLE . " WHERE email_validation = 0 AND user_allow_mass_email = 1";

Might this work?
Back to top
Dog Cow
Board Member



Joined: 18 Nov 2008

Posts: 378


flag
PostPosted: Thu Sep 24, 2009 7:33 pm 
Post subject: Re: Mega Mail: issue with users not wanting the newsletter

Looks like it should. I don't know what email_validation is for, but you should.
_________________
Moof!
Lincoln's Tomb, Oak Ridge Cemetery, Springfield ILMac 512K BlogMac GUI
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Thu Sep 24, 2009 8:12 pm 
Post subject: Re: Mega Mail: issue with users not wanting the newsletter

email_validation is there by default.
I have only added user_allow_mass_email
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 621
Location: Spain


flag
PostPosted: Mon Oct 26, 2009 8:04 pm 
Post subject: Re: Mega Mail: issue with users not wanting the newsletter

Hi Holger,

Did this work for you or did you have to make any changes to the code you posted above?

I am looking at Megamail too, with the idea of modding it a tiny bit so that it will only send out mails to users that have a post count of 0.

_________________
phpBB2 will never die, I hope!
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Mon Oct 26, 2009 8:21 pm 
Post subject: Re: Mega Mail: issue with users not wanting the newsletter

I just sent out an important mass-email yesterday. It worked as it was supposed to.

I cannot live without Mega Mail, it is great!
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 621
Location: Spain


flag
PostPosted: Mon Oct 26, 2009 8:36 pm 
Post subject: Re: Mega Mail: issue with users not wanting the newsletter

Okay, thanks for telling,

Than I can simply adapt your codechange to my needs and give it a try.

I want to send out a mail to only the users with zero post count telling them I intend to clean up the users, wiping out those that haven't posted ever since they registered.

My only problem is that I'd like to only send mail to users that are members for over three months before the date of sending the mail.

Anybody knows how to select users that are member from before a certain date?

_________________
phpBB2 will never die, I hope!
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Mon Oct 26, 2009 8:39 pm 
Post subject: Re: Mega Mail: issue with users not wanting the newsletter

There is a mod called "Inactive Users", that would suite your needs!
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 621
Location: Spain


flag
PostPosted: Mon Oct 26, 2009 9:39 pm 
Post subject: Re: Mega Mail: issue with users not wanting the newsletter

I found the MOD and yes, it looks like it suits my needs.

Although the MOD install says it won´t work on board that don't use account activation. Which is my board's case.

Nevertheless, the MOD allows me to find zero post members, select the ones that are within the time-frame I want and send them emails and/or delete their accounts.

Very handy MOD, thanks Holger! icon_wink.gif

_________________
phpBB2 will never die, I hope!
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Tue Oct 27, 2009 7:45 am 
Post subject: Re: Mega Mail: issue with users not wanting the newsletter

I use it myself. It is VERY handy.
Back to top
Display posts from previous:   
Register or Login to Post    Index » MOD Requests  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0235 seconds using 17 queries. (SQL 0.0027 Parse 0.0027 Other 0.0181)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo