Major Additions - Email Integration (New threads/replies by email)

This mod is based off of the Mail Reply modification by Colin F to which I have obtained permission to rewrite and release.

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

After installing this modification you will have new settings in your forum manager where for each forum you can enable this modification and setup a separate email address to use for each forum that you have this enabled for.

Just like how there is a separate email address for each yahoo group.

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. (Example email 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!


BUGS!
These are the known bugs to date:

• Confirmed 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!
(See the file in the zip for a complete history!)

• 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.7!

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

[Fungsten]

Originally Posted by asiegel

Hi,

I was wondering if this addon works as expected in v3.8 of vbulletin

Any feedback is appreciated!

Thanks,
a

VB 3.8.1. Works.

[paul5]

Hello,

I upgraded to vbulletin 3.8.1 last night, and Email Integration stopped working. Now, when I try to access the Forum Settings Help or the Email Integration scheduled task, I get this error:

Imap not recognized!! You MUST enable IMAP extensions on your server in your php.ini file!

I am not using IMAP, and I never have been, and I don't want to. This server only sends out messages to users, it does not accept replies/incoming messages.

Email Integration was working perfectly before the upgrade. (I was previously running 3.7.3 pl1)

Can someone help me to figure out what is wrong? I do not want to recompile PHP in order to enable a feature that I don't even want.

I am running OpenBSD 4.1, Apache/1.3.39 (Unix) PHP/5.2.4.

Thanks for your help.

[toivo]

Don't you love it when a user goes on holidays from the forum that the EI Mod runs on? The person has of course set an out-of-office message in his/her native tongue which does not contain a single word that could be trapped by the out-of-office filter in your mail server. You wake up in the morning to find dozens of bounced messages in your mailbox and posts in the forum with a few expletives from frustrated users in different time zones.

This hack works for users of the old message format. It compares the beginning of the new message to the first 100 characters of the user's previous message and, if identical, removes the message from the mailbox.

Find the line 264 in emailintegration.php, version 2.6.1 BETA:

$mailmessage = preg_replace($pattern, $replace, $mailmessage);

Insert the following code after line 264:

					if ( $userid ) {
						$getlastpost = $vbulletin->db->query_first("
							SELECT lastpostid
							FROM " . TABLE_PREFIX . "user
							WHERE userid = $userid
						");
						$lastpostid = $getlastpost['lastpostid'];
						// lastpostid is not always updated
						if ( !$lastpostid ) {
							$getlastpost2 = $vbulletin->db->query_first("SELECT postid FROM " . TABLE_PREFIX . "post WHERE userid = $userid ORDER BY dateline DESC, postid DESC LIMIT 1");
							$lastpostid = $getlastpost2['postid'];
						}
						if ( $lastpostid ) {
							$gettext = $vbulletin->db->query_first("
								SELECT pagetext
								FROM " . TABLE_PREFIX . "post
								WHERE postid = $lastpostid
							");
							$pagetext = $gettext['pagetext'];
							$pagetext_comp 		= substr( $pagetext, 0, 100 );
							$mailmessage_comp 	= substr( $mailmessage, 0, 100 );
							if ( $pagetext_comp === $mailmessage_comp ) {
								imap_delete($mailbox,$msgno);
								continue;
							}
						}
					}

[Bob Ricci]

But does this run on vb 3.8.1?

[Bob Ricci]

One more thing... I seriously think that this should be a native feature of vB. When we try to sell vB to our clients they say that they can use Yahoo for free AND Yahoo emails them a digest daily, or they can get instant replies. The same with chat. Integrated and native to vB.

[toivo]

Originally Posted by Bob Ricci

But does this run on vb 3.8.1?

The code to eliminate duplicate email messages has been tested with 3.6.8.

[SDonkey]

I'm using v3.82 with this v2.6

Once it was working but stopped after few hours.

Re-installed. Working again and stopped.

Any ideas?

[SDonkey]

After pressing run in the Scheduled Task. (Email Integration).

I got some errors in it.

So I edit in php.ini

Max post is 32mb and max upload is 32mb

Restart server. Now I got all working perfectly.

Each email create no larger than 20mb of storage so you don't get overload in php's memory which is 32mb max. (You may increase php memory but not recommended)

After next 3 days, it still showing new posts.

Great stuff!

[lbernstein]

vB 3.8.2 EI 2.6.1

I'm able to receive posts going from the forum to email, but not the other way. Can anyone help point me to where I might be to fix the reply problem. I have set up individual emails for each forum and am able to receive posts via either POP3 or IMAP.

Thanks for any help.

[SDonkey]

Just one thing.

Everything seems working perfect on v3.82 using this v2.6 (not beta)

I've adjust the vbulletin to moderate posts. The email integration overrides it.

So be careful for the spam posters sent email into forums still appear published without any moderate posts. Should these posts goes to pending posts where the vbulletin admin panel set to moderate posts for all.

Ta.