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

[popmyzit]

Hello,
getting Error Number: 1064 on new registrations

Invalid SQL:

REPLACE INTO vb_subscribeforum (userid, emailupdate, forumid)
VALUES (0, 1, );

database error.

Can someone help?
cheers

[Cyricx]

Originally Posted by popmyzit

Hello,
getting Error Number: 1064 on new registrations

Invalid SQL:

REPLACE INTO vb_subscribeforum (userid, emailupdate, forumid)
VALUES (0, 1, );


database error.

Can someone help?
cheers

It would appear that in the usergroup manager you have autosubscribed turned on, but did not specify the forumids that the user should automatically be subscribed to.

[popmyzit]

Hello,
thanks for responding
I have actually put YES for subscribe and added a forumid in the field. I will double check this

however this may be happening despite that data in the fields... can anyone else check this?

thanks

[popmyzit]

Ok, i think it was trailing , comma in forum ids.

but now i am getting:

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

Warning: imap_headers(): supplied argument is not a valid imap resource in /includes/cron/emailintegration.php on line 114

Warning: imap_close(): supplied argument is not a valid imap resource in /includes/cron/emailintegration.php on line 1213

Done

any ideas? I think its the username what do you put there?

[j14nsx]

Apologies if my problem has already been answered. I have looked.

I have installed this mod, and it is working fine. However the emails I am receiving are not displaying as html. Other emails from other sender I can read as html, so it's not my Outlook 2007 setup.

I get text that looks like raw html.

Aside from this, works great!

[USI_Garrett]

Sorry if this is a basic question, but I can't quite figure it out. In the latest set of instructions, it says that I should import the product file "product-emailreplyint.xml". Where do I import it to? Is there there anything special I should use to import it (i.e. Impex)? Once again, sorry if this has already been addressed in the thread.

Thanks in advance.

[USI_Garrett]

Wow, nevermind. Figured it out. Looking forward to getting this mod up and running.

[linnov]

I have an automatted post in a forum I have this set on using the following code

<?

// chdir('./forums');
require_once('./global.php');
require_once('./includes/class_dm.php');
require_once('./includes/class_dm_threadpost.php');
require_once('./includes/functions_databuild.php');

$threaddm = new vB_DataManager_Thread_FirstPost($vbulletin, ERRTYPE_STANDARD);

$forumid = 209;
$postuserid = 3;
$userid = 3;
$username = 'linnov';
$pagetext = 'Testing 123 ';
$title = 'Test Post ';
$allowsmilie = '1';
$visible = '1';

$threadinfo = fetch_threadinfo($postthreadid);
$foruminfo = fetch_foruminfo($threadinfo['forumid']);

$threaddm->do_set('forumid', $forumid);
$threaddm->do_set('postuserid', $postuserid);
$threaddm->do_set('userid', $userid);
$threaddm->do_set('username', $username);
$threaddm->do_set('pagetext', $pagetext);
$threaddm->do_set('title', $title);
$threaddm->set('allowsmilie', $allowsmilie);
$threaddm->set('visible', $visible);
$threaddm->save();

build_forum_counters($forumid);

?>

The problem is the email is not generated so I'm thinking I need to call some other function within the script in order for the email to occurr

It does email if I create a new thread from within the forum.

Anyone have any ideas?

[FleXy]

great mod, but I can not find information how user can define himself by mail...
This plugin use email address to know "user login"? I mean "to know who wrote by mail" ?

If yes, it's not secure, because anybody can send letters from any email address. I mean i can send email from support @ microsoft [dot] com etc.
email is WRONG choose to define user. So it's loophole for spammers....

p.s. sorry for my english.

[silurius]

I think FleXy is referring to email spoofing?

At some point it would be great to see information about how best to bridge this with a Mailman listserv (perhaps adopting some of the development from the NNTP Gateway add-on) as well as with the vBulletin calendar and any event management add-ons related to that area.

But these are all bonuses, really. This is a great add-on, Chris. I expect this will greatly ease some of the phobias members of the particular community I'm working with, many of whom are technically and cognitively challenged, have about using internet applications. Even though my own work in this case is not-for-profit I still intend to paypal you when my site launches.