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

[amphicar770]

Hi Cyricx,

I have been running this mod since you released it and not only consider it the best VB enhancement of all time, but the support you provide has been incredible.

I earlier sent a donation to support your effort and have just sent a 2nd contribution. I certainly hope that every one who has benefited recognizes how much time you have invested and supports your great work however they can.

Thanks again.

Mike I.
http://www.amphicar770.com

[ThePiston]

has anyone successfully integrated and VB mailman with this mod? I'm not that familiar with mailman, but I think it could replace it or be a bridge...

[ThePiston]

actually - a better way to put this:

my friend has a mailman listserv right now - about 10,000 emails and he wants to convert this into a forum. People LOVE the list and do not want it altered. Can we use this mod with VB to replace the mail list and also have the forum?

[laurens800]

good job i like it only it sucks it got no button

[Cyricx]

Originally Posted by amphicar770

Hi Cyricx,

I have been running this mod since you released it and not only consider it the best VB enhancement of all time, but the support you provide has been incredible.

I earlier sent a donation to support your effort and have just sent a 2nd contribution. I certainly hope that every one who has benefited recognizes how much time you have invested and supports your great work however they can.

Thanks again.

Mike I.
http://www.amphicar770.com

Thank you!!!!

Originally Posted by ThePiston

actually - a better way to put this:

my friend has a mailman listserv right now - about 10,000 emails and he wants to convert this into a forum. People LOVE the list and do not want it altered. Can we use this mod with VB to replace the mail list and also have the forum?

That's actually the plan and intent with this. Is to replace those with a different email address that they email too

Started out with wanting to replace yahoo groups with vbulletin




Just a quick update to all:
Found an issue with the mimedecode file that comes with php pear. It goofs up entirely when it hits a forwarded message with an attachment.

I'm researching some alternative mail decode class files to find a resolution.

[toddchris]

Hi Everyone,

I've really tried to read through most everything here, but I still can seem to get the retrieve function to work from my server. I'm getting the familiar error of:

Email Integration


Warning: imap_open() [function.imap-open]: Couldn't open stream {localhost:110/pop3/notls}INBOX in [path]/includes/cron/emailintegration.php on line 98

Failed to connect to the mailbox for forum - ACCD

Done

One problem seems to be that when I set up a new email account on my Centos, it makes the login the entire email address, not just the portion before the @. I read somewhere on here that some tried replacing the @ symbol with the + symbol, but I still the pages of error stuff like this:

Email Integration


Fatal error:
This forum requires that you wait 30 seconds between posts. Please try again in 30 seconds.
Unable to proceed with save while $errors array is not empty in class vB_DataManager_Post in [path]/includes/class_dm.php on line 810
#0 vb_error_handler(256,
This forum requires that you wait 30 seconds between posts. Please try again in 30 seconds.
Unable to proceed with save while $errors array is not empty in class vB_DataManager_Post, /home/mynlada/public_html/forum/includes/class_dm.php, 810, Array ([this] => vB_DataManager_Post Object ([validfields] => Array ([postid] => Array ([0] => 3,[1] => 3,[2] => return ($data > 0),[threadid] => Array ([0] => 3,[1] => 1),[parentid] => Array ([0] => 3,[1] => 2),[username] => Array ([0] => 7,[1] => 0,[2] => _-_mEtHoD_-_),[userid] => Array ([0] => 3,[1] => 0,[2] => _-_mEtHoD_-_),[title] => Array ([0] => 7,[1] => 0,[2] => _-_mEtHoD_-_),[dateline] => Array ([0] => 3,[1] => 2),[pagetext] => Array ([0] => 7,[1] => 1,[2] => _-_mEtHoD_-_),[allowsmilie] => Array ([0] => 3,[1] => 1),[showsignature] => Array ([0] => 1,[1] => 0),[ipaddress] => Array ([0] => 7,[1] => 2),[iconid] => Array ([0] => 3,[1] => 0,[2] => _-_mEtHoD_-_),[visible] => Array ([0] => 3,[1] => 0),[attach] => Array ([0] => 3,[1] => 0),[infraction] => Array ([0] => 3,[1] => 0),[reportthreadid] => Array ([0] => 3,[1] => 0)),[bitfields] => Array (),[table] => post,[condition_construct] => Array ([0] => postid = %1$d,[1] => postid),[post] => Array ([threadid] => 1,[parentid] => 2,[username] => toddchris,[userid] => 2,[title] => Test Reply,[pagetext] => This is reply to a reply. lol,[visible] => 1,[allowsmilie] => 1,[showsignature] => 1,[dateline] => 1206410172,[ipaddress] => 96.231.209.34),[floodcheck] => vB_FloodCheck Object ([registry] => vB_Registry Object ([datastore] => vB_Datastore Object ([defaultitems] => Array ([0] => options,[1] => bitfields,[2] => attachmentcache,[3] => forumcache,[4] => usergroupcache,[5] => stylecache,[6] => languagecache,[7] => products,[8] => pluginlist,[9] => cron,[10] => profilefield,[11] => loadcache,[12] => noticecache),[itemarray] => Array (),[registry] => vB_Registry Object ( *RECURSION*,[dbobject] => vB_Database Object ([functions] => Array ([connect] => mysql_connect,[pconnect] => mysql_pconnect,[select_db] => mysql_select_db,[query] => mysql_query,[query_unbuffered] => mysql_unbuffered_query,[fetch_row] => mysql_fetch_row,[fetch_array] => mysql_fetch_array,[fetch_field] => mysql_fetch_field,[free_result] => mysql_free_result,[data_seek] => mysql_data_seek,[error] => mysql_error,[errno] => mysql_errno,[affected_rows] => mysql_affected_rows,[num_rows] => mysql_num_rows,[num_fields] => mysql_num_fields,[field_name] => mysql_field_name,[insert_id] => mysql_insert_id,[escape_string] => mysql_real_escape_string,[real_escape_string] => mysql_real_escape_string,[close] => mysql_close,[client_encoding] => mysql_client_encoding),[registry] => vB_Registry Object ( *RECURSION*,[fetchtypes] => Array ([2] => 2,[1] => 1,[0] => 3),[appname] => vBulletin,[appshortname] => vBulletin,[database] => mynlada_forum,[connection_master] => Resource id #7,[connection_slave] => Resource id #7,[connection_recent] => Resource id #7,[multiserver] => ,[shutdownqueries] => Array ([lastvisit] => UPDATE user SET lastactivity = 1206410172 WHERE userid = 1 ,[0] => INSERT INTO adminlog(userid, dateline, script, action, extrainfo, ipaddress) VALUES (1, 1206410172, 'cronadmin.php', 'runcron', 'cron id = 19', '96.231.209.34') ),[sql] => ,[reporterror] => 1,[error] => ,[errno] => ,[maxpacket] => 0,[locked] => ,[querycount] => 46,[rows] => 0),[prefix] => ),[input] => vB_Input_Cleaner Object ([shortvars] => Array ([f] => forumid,[t] => threadid,[p] => postid,[u] => userid,[a] => announcementid,[c] => calendarid,[e] => eventid,[q] => query,[pp] => perpage,[page] => pagenumber,[sort] => sortfield,[order] => sortorder),[superglobal_lookup] => Array ([g] => _GET,[p] => _POST,[r] => _REQUEST,[c] => _COOKIE,[s] => _SERVER,[e] => _ENV,[f] => _FILES),[scriptpath] => ,[reloadurl] => ,[wolpath] => ,[url] => ,[ipaddress] => ,[alt_ip] => ,[registry] => vB_Registry Object ( *RECURSION*),[db] => vB_Database Object ([functions] => Array ([connect] => mysql_connect,[pconnect] => mysql_pconnect,[select_db] => mysql_select_db,[query] => mysql_query,[query_unbuffered] => mysql_unbuffered_query,[fetch_row] => mysql_fetch_row,[fetch_array] => mysql_fetch_array,[fetch_field] => mysql_fetch_field,[free_result] => mysql_free_result,[data_seek] => mysql_data_seek,[error] => mysql_error,[errno] => mysql_errno,[affected_rows] => mysql_affected_rows,[num_rows] => mysql_num_rows,[num_fields] => mysql_num_fields,[field_name] => mysql_field_name,[insert_id] => mysql_insert_id,[escape_string] => mysql_real_escape_string,[real_escape_string] => mysql_real_escape_string,[close] => mysql_close,[client_encoding] => mysql_client_encoding),[registry] => vB_Registry Object ( *RECURSION*,[fetchtypes] => Array ([2] => 2,[1] => 1,[0] => 3),[appname] => vBulletin,[appshortname] => vBulletin,[database] => mynlada_forum,[connection_master] => Resource id #7,[connection_slave] => Resource id #7,[connection_recent] => Resource id #7,[multiserver] => ,[shutdownqueries] => Array ([lastvisit] => UPDATE user SET lastactivity = 1206410172 WHERE userid = 1 ,[0] => INSERT INTO adminlog(userid, dateline, script, action, extrainfo, ipaddress) VALUES (1, 1206410172, 'cronadmin.php', 'runcron', 'cron id = 19', '96.231.209.34') ),[sql] => ,[reporterror] => 1,[error] => ,[errno] => ,[maxpacket] => 0,[locked] => ,[querycount] => 46,[rows] => 0),[userinfo]

I don't really know what to do next. Sorry if this seems like a stupid question, but I don't know what else to do.

Any help would be appreciated.

Thanks,
Todd

[Cyricx]

Have you tried using the Admincp -> Email Integration -> Forum Settings Help to help determine your mailbox settings?

Your issue is that your hostname, username or password is not correct for the settings you have entered for forum ACCD

You can use the @ symbol just fine, however try without that as well.

If it's on the same box as the server you can try the hostname of localhost.

Also, do you have IMAP installed? or just php enabled? If you have IMAP installed, you'll need to use the IMAP settings instead of the pop3 you have selected.

Worst case, if you can't get the forum settings help script to work, gimme a hollar and I'll help determine what your settings should be as I have time

[toddchris]

Chris,

Thanks so much for the quick response. I would really like to get this working. It's would really help our non-profit fill a need that they currently have.

Just let me know what you need acccess to. We be so appreciative of the help and could potentially contribute something as well.

Thanks,
Todd

Originally Posted by Cyricx

Have you tried using the Admincp -> Email Integration -> Forum Settings Help to help determine your mailbox settings?Yes, I've tried but it doesn't come back with any helpful information

Your issue is that your hostname, username or password is not correct for the settings you have entered for forum ACCD

You can use the @ symbol just fine, however try without that as well.I've tried all the combinations that I can think of here.

If it's on the same box as the server you can try the hostname of localhost.It is on the same box, so have been using localhost

Also, do you have IMAP installed? or just php enabled? If you have IMAP installed, you'll need to use the IMAP settings instead of the pop3 you have selected.Originally IMAP was not installed, but I installed that option using WHM. If you check in my PHP settings it does show up.

Worst case, if you can't get the forum settings help script to work, gimme a hollar and I'll help determine what your settings should be as I have time
That would be great, and as we are on VB 3.7 would could help you test some.

[ThePiston]

sorry if this was asked, but where can i change it to check mail server more frequently?

Also, is there any way to allow a user to reply to person's email who sent the post instead of giong through the forum? Maybe a link inside the email that says "reply ONLY to this user via email". This will be a biggie since this is a big reason people use listservs... they can "reply" or "reply to all' - this mod seems to take away the ability to reply to just the one poster via email.

[ttseppal]

Hi, Cyricx! Thanks for the great mod!

My intention is to use it to replace/enhance a handful of mailing lists that have around 1000 users.

I have version 2.6.1 BETA installed with vBulletin 3.6.8 pl 2. I am getting the same errors that some have reported earlier:

Fatal error: Call to a member function set_parsing_language() on a non-object in /var/www/localhost/htdocs/forum/includes/cron/emailintegration.php on line 1093

Specifically, this happens when there are two replies to the same thread sitting in the mailbox. The replies are both added to vBulletin thread, but the emails are never removed from the mailbox and they are processed again and again every time cron is run.

Hope you have time to look into this.