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

[Cyricx]

Right on, remember to upload the new cron file too.

My 2.4 code made some query references to the slave database. I suspect that you have different settings then those running on 3.6 that have upgraded so far

[Cyricx]

Found the error in the cron file

New zip attached.

Mah bad... trying to help someone figure out a way to setup a system cron to run the file instead of waiting for vbulletin

[popmyzit]

Hey Cyricx,
just installed. thanks for the great work!!

Got error going to maintenance email area with mysql error:
Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:
SELECT title FROM vb_forum WHERE forumid =;

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 '' at line 1
Error Number  : 1064
Date          : Thursday, January 31st 2008 @ 03:43:59 PM
Script        : http://www.mysite.com/forum/admincp/admin_ei.php
Referrer      : http://www.mysite.com/forum/admincp/index.php?do=nav
IP Address    : -----
Username      : admin
Classname     : vB_Database
MySQL Version : 4.1.22-standard

[Cyricx]

Please go to your Usergroup Manager and be sure that you have entered in a forumid for the usergroups that you wish to enable auto subscriptions for.


In version 2.4 you could actually turn on auto subscription for a usergroup and not enter in the forumids. This would spiral to a few other errors such as the one you mentioned above

2.5 will not allow you to not enter in a forumid if you are turning on auto subscription. So I'm fairly certain that when you installed 2.4 that mistake was made.

I've put in a safety net to ensure that fumble isn't made with these versions going forward

[popmyzit]

Hello Cyricx,
also when registering I still get:


Database Error Database error
The Forum database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.mysite.com home page, then try to open another page.
* Click the Back button to try another link.

The www.mysite.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

[popmyzit]

maybe i will try i reinstall, i was upgrading from a previous version... that may be the problem.

Update: Yes Updating was the problem. Make sure you uninstall, then reinstall fresh clean install. worked for me.

[Cyricx]

The most common problem people have from upgrading from the older versions like 2.3 is forgetting to reverse the file edits or to put in the new file edit in the class_mail.php file.

Please follow the instructions in the UPGRADE.txt file closely

Let me know if you have any other issues Popmyzit and I'll work to resolve them asap!

[popmyzit]

Everything is fine after installing everything fresh. I will be looking for any bugs when people start sending emails

thanks again!

[snoopy5]

Hi

I am very interested in this hack. I only need a slight modification. I would be willing to pay for this.

I need this mailinglist functionality depending on the usergroup. I do not want that every user can use this feature, only premium members and Moderators shall be allowed to use this feature.

Would that be possible?

Thanks in advance

P.S.: Where is the difference between this hack above and this one:

https://vborg.vbsupport.ru/showthread.php?t=151222

[Rich]

Isn't the potential for this to backup the mail server pretty high? This could essentially generate a lot of emails if the site is active. If i am incorrect, I apologize. I am just thinking of the mass email that this could generate in addition to the email the site already sends.