Major Additions - Email Integration (New Threads/Replies by and through email!)

This modification allows you to mimic email lists such as yahoo groups through your forums!

Complete with the user's receiving emails for new threads and replies AND being able to reply directly from email or sending a new email to start a new thread!

Just like email lists, you will need a separate email box for EACH forum that you have this enabled for!!

After installing this modification in the forum manager you will enter the settings for each forum to connect to it's own email box.

After doing so, members can subscribe to each forum that this mod is enabled for to receive notifications for new threads and replies.

Any posts in that forum, will be sent to them via email in one of two formats that you as the administrator decide. One format has a "reply box" and is the most sure fire way of not getting excess email crap ont he forums. The second format (noted as "Old" format) keeps an email in its base pure form with some attempts at quoting messages. Examples of both are attached below.

The users can then reply to that email (which will then be processed and posted to the forums through the cron job that runs every 10 minutes), or they can send a new email to the email address and a brand new thread will be created!

Essentially mimicing an email list! Suddenly those users that hate forums, can still be dragged into the conversations and help keep the forum's activity level up!

IMAP
You MUST have php imap functions enabled on your server to use this modification! You do not need to have IMAP installed, just have to enable php to use the functions by recompiling it with imap enabled!

If you are upgrading from the version
for vbulletin 3.6.x , see below!

BUGS!
These are the known bugs to date:

• Unconfirmed bug that email processing does not handle Japanese characters.

Unsupported Items
These are the items that are not currently supported:

• Some custom bbcode modifications will not display like they do on the forums in the html emails. Like glow, and the table mod.

TO UPGRADE

• Please see the file in the zip for upgrading!! If your upgrading from version 2.3.X you will need to reverse some file edits that are no longer nessecary!

NEW INSTALL

• See instructions in the zip file.

VERSION HISTORY!

• 2.5 Release
• • New Features
    • Email Integration now uses vbmail! This DOES require one small file edit.
• 2.5.1 Release -
  • New Feature -
    • Added some debug triggers in the cron file. Turning on debug will stop email sfrom being deleted after they are processed and if a message errors out, the error email will be sent to an admin specified email address which is set in the cron file.
  • Bug Fixes -
    • Fixed incorrect call to plain text parsing. (this is the cause of the duplicate posting/undefined function errors)
    • Corrected security hole.
    • Corrected a typo in the error message for attachments that are too large.
    • Rebuilt the method of determining attachment types vs max size to handle more then 2 attachments. Previous code would not process more then 2 attachments.
    • Added a call to determine the parentid for replies if one isn't specified prior to the post being added to the database from emails.
    • Fixed a bug where previous messages were blank in new layout for posts that didn't have a parentid specified.
• 2.5.2 Release
  • Bug Fixes
    • Fixed bug with new users not being automatically subscribed to forums when it is enabled for their usergroup.
    • Added a dirty regex fix for utf-8 encoded filenames.
• 2.5.3 Release
  • Bug Fixes
    • Fixed bug that displayed "Set All Instant" on User CP Subscribe Forums page when no forums were setup for Instant Email Notification.
    • Fixed bug that allowed forums that were set inactive to appear on the User CP SUbscribe Forums page.
    • Fixed bug with the how the "New Layout" processs improving how it tries to remove the first layer of > signs in replies.
  • Improvement/Bug Fix
    • Changed the field in the Forum Manager for forum['ei_usergroups'] so that it now controls not only who can reply via email. But who can receive instant notification emails. It is now titled "Please enter the usergroup IDs that can use this feature."
    • Added the phrase "You may increase the space between the above lines as needed." to the "New Layout" email templates to alleviate user confusion.
• 2.5.4 Release
  • Bug Fixes
    • Added a quickfix for a bug that caused a function error when replying to a thread that a user was subscribed to while in a forum that was enabled for Email Integration.
  • Error Checks Added
    • Added a function exists check to the cron file and the search settings page to warn people when they have not correctly enabled imap functions.
• 2.5.5 Release
  • Bug Fixes
    • Added a check to subscribeforum.php to not display subscription options for forums that are links.
    • Fixed a bug that caused the cron to incorrectly list the username and signature in the emails. (The post processed to the forums were correct, it was just the emails that were screwy sometimes.)
    • Slightly modified phrase and variables for replies so that if a post has a title, it'll use that title for the email, if not, it'll use the thread title like before.
• 2.6 Release
  • Bug Fixes
    • Joining an unmoderated public group will now auto subscribe you per the usergroup settings.
    • NO CONFLICTS with Instant Thread Subscription! See details in below post.
  • New Stuff
    • User Option Allow Auto Subscribe - This is an admin allowable, user option that let's the user choose to not be auto subscribed.
    • User Option not receive own posts - A new user option that lets them select to NOT receive their own posts via email.
    • Editted the phrase for the Auto Subscription script to tell people what to do if there are no listings.
    • Added error checks when saving a usergroup for if auto subscriptioin is entered with a forumid for a forum that does not have email integration enabled and also checks that the usergroup you are saing is entered in the forum manager as allowed to use email integration.
• 2.6.1 Release (BETA VERSION)
  • Hot Fix
    • It appears I was unseting a variable too soon. I've corrected this and it has resolved the issue with multiple posted replies on my test server.

Most of these will be slow to make it in til I know I've got the code to handle just about every type of email we could receive But in anycase, here are the ideas for future versions!

• End User Option to subscribe to just receive new thread emails, or receive all new thread & reply emails (current version does all new threads & replies).

Thanks to RedTyger, Bob Denny, Ed Kohwley and Chris McKeever for their additions and assistance with portions of this code.

Huge thanks also goes to the many individuals that have helped test various incarnations of this mod.

MAD PROPS TO: cgmckeever for a great quoting regex for the old format, and all the mods at www.4winmobile.com for helping test version 2.4 prior to release!!

You guys rock!

Please feel free to donate to my continued work on this modification!! It let's me spend more time on it!
Make a Donation!

Version 2.6 will work with both 3.6.8 and 3.7x

Upgrading from version for 3.6.x

• Due to using different product ID's due to the changes that will be coming up for the version for vbulletin 3.7.x you will need to uninstall the 3.6.x version and install the 3.7.x version in this thread. My apologies for the inconvienance, I've been unable to determine an alternative with the 3.6.x version still in development due to the last few bugs.

The #.X versions are the solid tested versions.

The #.X.X versions are the beta versions. New features and bug fixes will be worked in there and then when I have a solid version it'll be released as the next #.X

Thank you!!

~ Cyricx

[SamirDarji]

If there is a way to modify a user's subscriptions via the admincp, then you could do that. Other than that it would require an SQL query.

[rugby]

i would like to know if this mod will also work for forwarding and replying pm's or is it only for new threads and replies?

[SamirDarji]

Just threads and replies. And only for specific forums that you set up.

[ilanyon]

FIXED ISSUE - REMOVED SOME OF THE BLOCKED SUBJECT TEXT - MUST HAVE HAD SOMETHING IN THERE THAT THE SYSTEM DIDN'T LIKE


Hi and thank-you for a great mod.

I have a problem though...

I have installed and gone through all of the instructions but the mail in not appearing in the forum.

I can post to the forum and the system e-mails out. I can send e-mails to the e-mail account (gmail) and the system runs the cron job okay and cleans out the inbox of gmail, but nothing is then posted to the forum...

I think that I have done everything as I should...and now I'm at a bit of a loss...

Any help/suggestions would be very much appreciated!

Cheers,

Ian

[toivo]

Hi,

Our Microsoft Exchange Server will be decommissioned and therefore I tested accessing the mailbox in a Qmail server, running Courier IMAP which does not seem to be the latest version. Emails sent from Gmail which worked in Exchange were suddenly deleted but not posted. This happens because the From: header is presented to the PHP application by this particular IMAP server in the format firstname lastname <mailbox@gmail.com>, instead of the usual format mailbox@example.com.

Here is a fix. Replace the lines 135 - 138 of emailintegration.php

if ($vbulletin->options['ei_strict'] == 1 OR !$fromaddress)
		{
			$fromaddress = $letter->sender[0]->mailbox ."@".$letter->sender[0]->host;
		}

with the following:

// 20090909 fix empty $fromaddress, Gmail from: header in Qmail/Courier IMAP
		//if ($vbulletin->options['ei_strict'] == 1 OR !$fromaddress)
		if ($vbulletin->options['ei_strict'] == 1 OR $fromaddress === '@')
		    {
			$fromaddress = $letter->sender[0]->mailbox ."@".$letter->sender[0]->host;
		    }
		if ( $fromaddress === '@' ) {
		    $from_pattern = "/^.*<(.+)>$/"; // extract email address from < >
		    $found = preg_match( $from_pattern, $letters[$i]->from, $from_matches );
		    $fromaddress = $from_matches[1];
		}

[toivo]

If your users send replies to your forum mailbox from Lotus Notes, you would have noticed that each HTML link embedded in the message generates an attachment ~~DLNKn.URL where n is a sequence number starting from 0. This patch discards those attachments.

Find the following from line 734:

// save attachments in database

Add above it:

// ##### START MOD skip link attachments from Lotus Notes #####
		if ( preg_match( "/^~~DLNK[0-9]*.URL$/", $filename )) {
				continue;
		}
// ##### END MOD   skip link attachments from Lotus Notes #####

Find the following from line 1322:

// save attachments in database

Add above it:

// ##### START MOD skip link attachments from Lotus Notes #####
		if ( preg_match( "/^~~DLNK[0-9]*.URL$/", $filename )) {
				continue;
		}
// ##### END MOD   skip link attachments from Lotus Notes #####

[toivo]

I have just posted a patch to Email Integration Modification to support moderated forums, at https://vborg.vbsupport.ru/showthrea...151222&page=67

Toivo

[joyfulmiller]

Is there a way to modify this mod so that the instant notification and full text emails works, but the replying by email is NOT included? I'm interested in only the full text and instant notification features and would like to modify the email itself to remove the reply sections as well as change the name of the option in the subscription drop down menu to "Instant Notification with Full Text". Is this possible? If so, is there a way I can do make the changes myself?

[SamirDarji]

Originally Posted by toivo

I have just posted a patch to Email Integration Modification to support moderated forums, at https://vborg.vbsupport.ru/showthrea...151222&page=67

Toivo

Awesome! Will this work for both 3.6.x and 3.7.x based forums? Also, thank you for all the fixes you've posted above.

[toivo]

Originally Posted by SamirDarji

Awesome! Will this work for both 3.6.x and 3.7.x based forums?

I presume so, based on Email Integration working in both. I have only tested it in 3.6.8.

Cheers.