Administrative and Maintenance Tools - EZ Bounced Email Management for Admins

DESCRIPTION:
This mod will insert a special EZbounce link into the header of all emails sent from your forums. In the event any email bounces back to you, you simply click the EZbounce link and the Ezbounce script launches, which will modify the bouncing members settings to prevent further bouncing emails. It will also send that member a PM asking them to update their email address.

This modification is known to work with versions as high as 3.8.x


FEATURES:

• Will not modify settings for Admins, Supermods, or Moderators if their email bounces
• (if turned on) Bouncing member is moved to whatever usergroup you set in AdminCP EZbounce Settings
• Updates bouncing member's "Receive Email from Administrators" setting to NO
• Updates bouncing member's "Receive Email Notification of New Private Messages" setting to NO
• Updates bouncing member's "Receive Email from Other Members" setting to NO
• Remove email notification for all of bouncing member's subscribed THREADS
• Remove email notification for all of bouncing member's subscribed FORUMS
• Turns on Popup Notification of new Private Messages for bouncing member
• PM is sent to Member notifying them of bounced email & asking them to update email address
• (if turned on) When member updates & confirms their new email, they are returned to original usergroup.

Now, the next time you send a newsletter from your AdminCP, (so long as you only send emails to members whom have "Receive Email From Administrators" set to "Yes") you will no longer receive a bounced email from this member (because they are no longer being sent).

And also, if you created a new usergroup such as "Bounced Members" and set this usergroupid in this hack's settings, now the members that have bounced can be pruned, sent reminder emails, whateveryou want to do with them!


WHAT IF A MEMBER DECIDED TO CLICK ON THE LINK IN THE EMAIL HEADER?
Most email clients don't show the email's headers by default, however in the event a member is slick enough to view their header and they click on this mysterious link, they will simply receive a no permission message since they're unallowed to log in to the AdminCP.


ZIP FILE CONTENTS:
1 Product (2 plugins, a couple phrases & installcode which adds 1 colum to user table)
1 File


HOW TO VIEW FULL EMAIL HEADERS:
You might need to configure your email client to view full email headers in order to see the EzBounce link. There's detailed instructions on how to do this for the most popular email clients here.


CHANGELOG:
#> 1.11 - released on 7/6/2008:
Fixed bug reported in post #583

#> 1.10 - released on 12/18/2007:
Added when bouncing member is managed for bouncing, their "Pop Up a Notification Box When New PM Is Received" setting is turned on before the notification PM is sent, to better ensure they are notified to update their email address.
Bought the new CD entitled Sleaze Freak by Scum Of The Earth on Amazon.com

#> 1.9 - released on 9/22/2007:
Added when bouncing member is managed for bouncing, their "Pop Up a Notification Box When New PM Is Received" setting is turned on before the notification PM is sent, to better ensure they are notified to update their email address.
Modified the way old usergroupid is restored so methos is more compatible with other installed mods.
Optimized some queries in ezbounce.php and plugin codes.

#> 1.8 - released on 6/1/2007:
Bug fix - fixed array_merge error for those running php 5.

#> 1.7 - released on 5/8/2007:
Bug fix - fixed bug where old usergroup was incorrectly being restored.

#> 1.6 - released on 4/26/2007:
Added protective measure for Admins, Supermods, or Mods who's email may have bounced. this makes sure their usergroup and settings are not modified

even if their email bounces.
When bouncing member is managed for bouncing, their "Receive Email Notification of New Private Messages" is now set to NO.
When bouncing member is managed for bouncing, their "Receive Email from Other Members" is now set to NO.
When bouncing member is managed for bouncing, email notification is turned OFF for all of bouncing user's subscribed threads.
When bouncing member is managed for bouncing, email notification is turned OFF for all of bouncing user's subscribed forums.

#> 1.5 - released on 2/17/2007:
Added option in Settings which allows admin to insert the EZbounce link into outgoing email's message body (for email clients which make it difficult to show

email headers or don't properly parse html links when displaying email headers.
Fixed bug where original usergroupid was being erased in the event admin processed bounced more than once for same member

#> 1.4 - released on 2/17/2007:
Fixed bug - PM is now sent regardless of whether or not bouncing member had "Enable Private Messaging" turned off in UserCP.
Fixed bug - Usergroup is now properly reset to what it was before member was managed for bouncing

#> 1.3 - released on 2/15/2007:
New setting in AdminCP which gives option to move bouncing members into any usergroup of Admin's choice
If member had previously bounced, and they update their email, they are moved back to their original usergroup

#> 1.2 - released on 2/10/2007:
Bouncing members are now handled by setting their preference to receive admin emails to "no"
Sends PM to member notifying them email bounced
If / when member updates his/her email their preference to receive admin emails is reset to "yes"

#> 1.0 - released on 2/8/2007
Original release


If you like this hack, please click Nominate for MOTM

[reverse1312]

Hello,

I did the change and the main result is ok even if not quite what I expected ;-)

I did like that:

Created a new user
login = "Server "
userid = 114320

edit ezbounce.php

$pmdm->set('fromuserid', $vbulletin->userinfo['114320']);
$pmdm->set('fromusername', $vbulletin->userinfo['Server']);

do I need to write it differently ?

The PM are sent in reality with author's userid = 0.

I'm already happy with that if no better could be done. :-)

Thank you

Martin

[NeutralizeR]

Originally Posted by reverse1312

Hello,

I did the change and the main result is ok even if not quite what I expected ;-)

I did like that:

Created a new user
login = "Server "
userid = 114320

edit ezbounce.php


do I need to write it differently ?

The PM are sent in reality with author's userid = 0.

I'm already happy with that if no better could be done. :-)

Thank you

Martin

It should be:

$pmdm->set('fromuserid', '114320');
$pmdm->set('fromusername', 'Server');

Thanks for the hack!


Edit: When this hack is enabled, mass email sending is taking too long... I have some other hacks installed and vbulletin's mail queue enabled:
https://vborg.vbsupport.ru/showthread.php?t=133844

When i disable this hack, 5000 emails directly goes to the mail queue and all those 5000 users are listed... when it's enabled, it sends emails 1 by 1 and it's not reasonable for 100k+ emails. Is it because of the added link to the emails' headers?

[raagaswaram]

anyone got it working for 3.6.8? need help installing it

[wickedstangs]

Installed and get this error any ideas?

Database error in vBulletin 3.7.2:

Invalid SQL:

UPDATE user
SET ezb_oldugid =
WHERE userid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid =' at line 3
Error Number : 1064
Request Date : Thursday, July 3rd 2008 @ 01:54:25 AM
Error Date : Thursday, July 3rd 2008 @ 01:54:25 AM
Script : http://www.wickedstangs.com/communit...ezbounce.php?u
Referrer :
IP Address : 72.207.88.82
Username : xxxxxxxx
Classname : vB_Database
MySQL Version : 4.1.22-standard

[reverse1312]

Originally Posted by NeutralizeR

It should be:
pmdm->set('fromuserid', '114320');
$pmdm->set('fromusername', 'Server');

Well done !!

Thank you very much. It's perfect now !

Martin

[reverse1312]

Originally Posted by Antivirus

As I have said in the past, there's no plans to add automatic processing of bounces, as it's simply a bad idea... too many bounces are due to mailbox full, yahoo deferred delivery, earthlink human verify, etc... Sorry

Hello Antivirus,

I'm not sure it's quite such a bad idea since it depends on how the private message is redacted. With a well balanced message it could have no unwanted effect and be somehow harmless for the admin. :-)

At least it's my point of view. You are naturally the master for this very very good hack ;-)

But it could be just an option could'nt it ? ;-)

Martin.

[noppid]

I agree with Anti. The bounces need to be managed by hand. Once your mail is under control, with the right tools, like this one, the process is fast and sure.

Our members resent being moved to awaiting activation. So we turn off subscriptions and emails with a very selective process (automated by a click) and nothing changes as to them participating in the forum.

If they wanna keep a fake email and not hear from us, fine, that is explained. If they want email, they are told with specific instructions on how to edit the email and turn notifications back on.

That process stinks to explain.

Don't even get me started on how VB options and config have 3 different emails settings and what can happen if they don't match and you use SMTP mail. It's not cool and should be a little more simplified. The three may have different purposes, but the mailer does not deal with it properly and creates headers that require an SPF2 record. Most can't figure out an SPF1 record. More don't even know what either is or what they are for. My suggestion is make them all match.

Get control of your mail!

[reverse1312]

Originally Posted by noppid

The bounces need to be managed by hand. Once your mail is under control, with the right tools, like this one, the process is fast and sure.

Ok it's your opinion but what if it is an option you valid or not valid ? :-)
You would stay with manual manner and we could trust our own MPs for the diplomacy...

Martin

[noppid]

I have no idea what that means.

I need the pulse of my forum. Some things require a human touch and according to our members, who are the only opinion that matters, we need to take the time to evaluate the situation and help them if necessary.

My forum is about the members, not me. Seems to be a popular stance for keeping quality members.

But hey, you're free to code a fully automated system and share it to assert your opinion. I'm sure there are some who agree with your opinion. Make them happy. Be proud. Code your idea and release it.

Thanks

[markp_2000]

Originally Posted by noppid

The three may have different purposes, but the mailer does not deal with it properly and creates headers that require an SPF2 record. Most can't figure out an SPF1 record. More don't even know what either is or what they are for. My suggestion is make them all match.

Get control of your mail!

I'm trying to put a SPF record right now.

v=spf1 a ~all

What would the second SPF record look like?