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

[Cyricx]

Originally Posted by AyeCapn

just curious how the ahck will react to hard and soft email bounces. Will it post the error messages in the forum?

The next version will handle those and keep the messages from going through.

Oversight on my part.

The next version will be released VERY soon A day or two at max.

[AyeCapn]

so... it was a big busy day for me as I launched the hack to my site of 1200 users.

Hey guess what? It doesn;t know how to filter out "Out of Office" replies!

that reply generates a post which generates an email which generates a post... until my server crashed!

Pissed off some folk too

[Cyricx]

Yeah... I mentioned this a few times so far that it doesn't.

Fxs158 found this bug, and it'll be fixed in this next version I'm releasing in the next two days.

I had meetings all weekend for the not-for-profit org I do work for, so I wasn't able to spend any time on this mod til today.

[ChurchMedia]

Hi -- I'm getting this error when trying to join a usergroup. Looks like your code. When I disabled the e.i. product the error went away:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT ei_forumid, ei_auto
FROM vb_usergroup
WHERE usergroupid =
LIMIT 1;

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 'LIMIT 1' at line 4
Error Number : 1064
Date : Monday, August 6th 2007 @ 07:33:06 PM
Script : http://www.churchmedia.net/CMN/profile.php?do=joingroup
Referrer : http://www.churchmedia.net/CMN/profi...editusergroups
IP Address : XXXXXXXXXXXXX
Username : Tim Eason
Classname : vb_database

Thanks and keep up the great work!

[Cyricx]

That's for a usergroup that does not have ei_auto setup for it correct?

[ChurchMedia]

Yeah, I didn't set up hardly anything since I'm waiting on the next release.

Originally Posted by Cyricx

That's for a usergroup that does not have ei_auto setup for it correct?

[rpainter]

Hello. I installed this mod, and it works great, except that attachments are not working. It will add the attachment to the post. When you click the attachment, you just get a page cannot be displayed error. See here:

http://scbbqtalk.com/forum/showthread.php?t=750

Please let me know what i did wrong (I followed instructions). Thanks.

[rpainter]

Originally Posted by ChurchMedia

Hi -- I'm getting this error when trying to join a usergroup. Looks like your code. When I disabled the e.i. product the error went away:



Thanks and keep up the great work!

Getting the same error.

[rbgrn]

Originally Posted by Cyricx

That's where I'm getting confused then

How are the threads being replied to? I mean... how are they getting the emails that they are replying too?

if your not allowing replies, why are you applying emails as replies to a thread?

Ok I'll explain once more. I pull mail in from a mailing list to my BB as read-only threads. it's 1-way communication. I assemble them into threads like gmail assembles emails into threads. If you want an example, check out http://www.diyelectriccar.com/forums/ and have a look at the "External Information" forum, which has a few forums that use this. You'll see immediately what I'm talking about. I think this will be a common use of your mod as people try to gravitate toward forums but don't want to leave an old mailing list behind.

[Cyricx]

Sorry for not getting the update out yesterday gang. Working out the bugs of hybrid/threaded mode to work for the transition over.

Also...

tooth extraction > finishing code