Author |
Message |
Holger Board Member
Joined: 19 Jan 2009
Posts: 509 Location: Hanover
|
Posted: Wed Sep 23, 2009 9:30 am 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
Description: |
|
Download |
Filename: |
admin_megamail.zip |
Filesize: |
4.51 KB |
Downloaded: |
1330 Time(s) |
|
|
Back to top |
|
|
Dog Cow Board Member
Joined: 18 Nov 2008
Posts: 378
|
Posted: Wed Sep 23, 2009 6: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 IL • Mac 512K Blog • Mac GUI |
|
Back to top |
|
|
Holger Board Member
Joined: 19 Jan 2009
Posts: 509 Location: Hanover
|
Posted: Thu Sep 24, 2009 2: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
|
|
Back to top |
|
|
Holger Board Member
Joined: 19 Jan 2009
Posts: 509 Location: Hanover
|
Posted: Thu Sep 24, 2009 4: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: 628 Location: Spain
|
Posted: Mon Oct 26, 2009 4: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
|
Posted: Mon Oct 26, 2009 4: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: 628 Location: Spain
|
Posted: Mon Oct 26, 2009 4: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
|
Posted: Mon Oct 26, 2009 4: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: 628 Location: Spain
|
Posted: Mon Oct 26, 2009 5: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!
_________________ phpBB2 will never die, I hope! |
|
Back to top |
|
|
Holger Board Member
Joined: 19 Jan 2009
Posts: 509 Location: Hanover
|
Posted: Tue Oct 27, 2009 3: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 |
|
|
|