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

[edward hamilton]

I know some people won't like this but after having seeing too many users trying to reuse email addresses that bounce, I modified exbounce.php
after

PHP Code:

// Update all of bouncing user's subscribed FORUMS to emailupdate = 0
        $vbulletin->db->query_write("
            UPDATE " . TABLE_PREFIX . "subscribeforum
            SET emailupdate = 0
            WHERE userid = " . $buser['userid'] . "
        "); 


I added

PHP Code:

//  #########  ADD BOUNCED EMAIL ADDRESS TO BANNED EMAIL ADDRESS

         // Get list of banned email addresses from the datastore
        $banned_email = $db->query_first("
            SELECT data FROM vb_datastore
            WHERE title = 'banemail' ");
        
        $banned_email = $banned_email['data'];    

        // Get new email address to ban from bounced email address 
        $userid = $buser['userid'];
        
        // Get new email address to ban from bounced email address 
        $bemail = $db->query_first("
            SELECT email FROM vb_user
            WHERE userid = '$userid' ");
        
        $bemail = $bemail['email'];

        // Add new bounced email address to existing banned email addresses
        $banned_email = "$banned_email $bemail"; 
        
        // Update banned email list  

        $vbulletin->db->query_write("
            UPDATE " . TABLE_PREFIX . "datastore 
            SET data = '$banned_email'
            WHERE title = 'banemail' ");
             
            
//  ######### 


Now when I follow the link in the bounced email the bounced email address is added to the banned email address list in vB options.

I'd like to add another link in the bounced email that would switch to this additional script, but for the time being this will do for now for me. Something like appending another variable ($b) to the end of the email bounce link like if(isset($_GET['b'])){ execute above code}

I only bounce email address that are clearly spam like mail.ru sdffjk@gmail and those with spammy usernames.

This certainly won't work for everyone but it might give you an idea so you can tailor this great mod to work better for you.

[Antivirus]

Originally Posted by gbechtel

I want to edit ezbounce.php to also clear out the invalid email address to work in conjunction with this mod but I have tried a few variations of the code below with no luck, I just get a blank white screen when I click on the link in the bounced email message and ezbounce.php is not working at all.

Can someone help me with the correct code to use? Thanks!

// Clear current bad email address
  $vbulletin->db->query_write("
   UPDATE " . TABLE_PREFIX . "user 
   SET useremail = ???
   WHERE userid = " . $buser['userid'] . "
  ");

I would not suggest deleting email addresses from the user table. It would be better to delete the user using the user datamanager class IMHO.

Originally Posted by MrD

Hi,
will this Addon ported to vb4?

Eventually, when I decide to upgrade all my forums from 3.8.x to 4.x series, i will give this mod a complete rewrite, however i don't expect it to be until at least version 4.1.0 is released.

Originally Posted by luket79

I am considering installing this, however, will it disable the "Receive Friend Request Notification", as this will send an email to a user if they are befriended? All of the users in my board have this enabled by default.

I haven't looked into what condition/bitfield is used to determine this condition. I imagine it's a bitfield permission in the user table, which i can put on to-do list for future versions.

[SBlueman]

Originally Posted by SBlueman

When I click on the link in the email:
I am getting this error when clicking on the link:

I do have the file uploaded to my site and am still experiencing this problem.

[SBlueman]

What am I supposed to enter into the URL field in the vBulletin options? Is it:

http://sitename.com/forums/admincp

or

/forums/admincp

or

/admincp

???

[Antivirus]

Originally Posted by SBlueman

What am I supposed to enter into the URL field in the vBulletin options???

You need to enter the full URL such as: http://www.mysite.com/forum/admincp

also make sure there is no trailing slash...

[BadgerDog]

This was a very valuable add-on for us under 3.67 ... thanks ...

Has anyone tried using it under vb4.03, as we're starting to upgrade using a development server ?

Thanks for any feedback ...

Regards,
Badger

[58D]

Can anyone tell me where the template for the PM that is sent is located. I'd like to see if it needs some personalization. Thanks.

Jake

[Antivirus]

Originally Posted by 58D

Can anyone tell me where the template for the PM that is sent is located. I'd like to see if it needs some personalization.

For the PM title, edit phrase: anti_your_email_bounced_sub
For the PM message, edit phrase: anti_your_email_bounced_body

[BellyBelly]

Also interested in using this on vb 4

[Supramania]

I had this in vB3.8 and I really miss it after moving to 4.