Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.7 > vBulletin 3.7 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Email Integration (New Threads/Replies by and through email!) Details »»
Email Integration (New Threads/Replies by and through email!)
Version: 2.6, by Cyricx Cyricx is offline
Developer Last Online: Dec 2011 Show Printable Version Email this Page

Category: Major Additions - Version: 3.7.x Rating:
Released: 01-30-2008 Last Update: 02-28-2008 Installs: 114
DB Changes Uses Plugins Template Edits Auto-Templates
Code Changes Additional Files  
No support by the author.

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

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #142  
Old 05-20-2009, 01:53 PM
Cyricx Cyricx is offline
 
Join Date: Aug 2002
Location: Missouri
Posts: 1,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I understand fully all the different ways you could do this.

What your suggesting is no different then creating a second yahoo group to backup messages from the first.

Pretty frickin pointless.

How do you reply to messages? Users on your board may not be on the yahoo group list.

All the messages will appear to come from the same exact person.

If messages are editted or email chains deleted from the yahoo group, they will not be deleted on your forum. So you have massive information discrepancies there as well.




I'll say it one more time

This modification is NOT made to work WITH a mailing list.

It is made to BE a mailing list in and of itself!

It turns one of your forums... into a mailing list.

Any attempts to integrate with an existing group mailing list, like yahoo groups, will create major discrepancies, errors and confused users.

If you want to backup information from a mailing list... search google. There are download programs for just about every free mailing list to make backups of the messages.


I'm sorry to be so abundantly blunt but I don't seem to be getting the message across.

*hugs*
Reply With Quote
  #143  
Old 05-21-2009, 07:34 AM
ilanyon ilanyon is offline
 
Join Date: Nov 2005
Location: Australia
Posts: 43
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi,
Sorry to ask again...but I will......will this mod be made available for 3.8 at some stage?

Or, is it worth while installing this version in the hope that it will work okay?

Cheers,

Ian
Reply With Quote
  #144  
Old 05-21-2009, 06:06 PM
SamirDarji SamirDarji is offline
 
Join Date: Apr 2004
Posts: 645
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you for your patience and replies. I know how seeing someone use your creation in a skewed manner can be unnerving. I've been there.

To specifically answer some of your questions:
Quote:
Originally Posted by Cyricx View Post
How do you reply to messages? Users on your board may not be on the yahoo group list.
You don't. We don't want to reply. This is just "read-only" for staff.
Quote:
Originally Posted by Cyricx View Post
All the messages will appear to come from the same exact person.
Doesn't matter. All we care about is the content inside the message.
Quote:
Originally Posted by Cyricx View Post
If messages are editted or email chains deleted from the yahoo group, they will not be deleted on your forum. So you have massive information discrepancies there as well.
That's fine. This is all just information that we're going to be reading. If it gets outdated in a week, it really doesn't matter.

In the explanation of how I was planning to have groups' messages posting to a forum, I completely forgot to explain how the forum users would use it. The quick answer is--the forum users won't.

We do not reply to the groups' lists. We are subscribed to find out what the group is doing since they don't disseminate the information by other means (web site, traditional forum, etc.). The EI forum would only be visible to forum staff. The staff can view the messages posted from the group. They can't reply and can't post. That's the extent of the use of the EI forum.

So that's the why. Now, the question is the how. In theory, would the system which I described above work?
Reply With Quote
  #145  
Old 05-21-2009, 06:08 PM
SamirDarji SamirDarji is offline
 
Join Date: Apr 2004
Posts: 645
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ThomasR View Post
I just installed it on vb 3.8 RC2. "Seems" to be ok but I have several problems (reply by email which never arrives on the forum, part of the email reply box which appears, etc), but I have to check more in depth before asking for help (perhaps I miss something)
Did you ever fix these issues?
Reply With Quote
  #146  
Old 05-22-2009, 11:04 PM
ilanyon ilanyon is offline
 
Join Date: Nov 2005
Location: Australia
Posts: 43
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi, just installed on 3.8.2 and seems to be running fine...thank-you...great mod!

Can anyone tell me if there is now a way of admin turning on the 'instant e-mail notifications' for any entire pre-existing usergroup...? Obviously I can go into each user one at a time and set this up for them...but I would rather do it all in one hit if at all possible?

Be gentle with me...I am still learning...

Cheers,

ian
Reply With Quote
  #147  
Old 05-24-2009, 03:09 PM
ArnyVee's Avatar
ArnyVee ArnyVee is offline
 
Join Date: Mar 2008
Posts: 944
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Has anyone used this mod consistently in order to have pictures shared via a mobile device yet? I know that some folks were close and/or doing it but encountering some issues. Any success stories that can be shared?
Reply With Quote
  #148  
Old 05-27-2009, 01:05 PM
mykkal's Avatar
mykkal mykkal is offline
 
Join Date: May 2007
Location: Atlanta, GA
Posts: 485
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

when i enable email integration my forum goes blank. I've asked for help a few times. Is there anyone that can help?

Thanks...
Reply With Quote
  #149  
Old 05-27-2009, 01:16 PM
mykkal's Avatar
mykkal mykkal is offline
 
Join Date: May 2007
Location: Atlanta, GA
Posts: 485
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is the error I get.

I'm using php 5 & MYSQL 5 with the 2.6.1 beta. Please help this time. It's been a few months.


Code:
Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE vb_forum SET
	title_clean = 'Modeling & Acting Auditions (Metro Miami/Ft. Lauderdale & Florida!)',
	title = 'Modeling & Acting Auditions (Metro Miami/Ft. Lauderdale & Florida!)',
	description_clean = 'Castings in Metro Miami , Orlando, Tampa, and the rest of Florida.',
	description = 'Castings in Metro Miami , Orlando, Tampa, and the rest of Florida.',
	link = '',
	displayorder = 60,
	parentid = 3,
	daysprune = -1,
	defaultsortfield = 'lastpost',
	defaultsortorder = 'desc',
	showprivate = 0,
	newpostemail = '',
	newthreademail = '',
	### Bitfield: vb_forum.options ###
		options = IF(options & 8, options - 8, options),
		options = IF(options & 16, options - 16, options),
		options = IF(options & 32, options - 32, options),
		options = IF(options & 32768, options - 32768, options),
		options = IF(options & 8192, options - 8192, options),
		options = IF(options & 4, options, options + 4),
		options = IF(options & 1, options, options + 1),
		options = IF(options & 2, options, options + 2),
		options = IF(options & 16384, options, options + 16384),
		options = IF(options & 256, options, options + 256),
		options = IF(options & 64, options, options + 64),
		options = IF(options & 128, options, options + 128),
		options = IF(options & 512, options, options + 512),
		options = IF(options & 1024, options, options + 1024),
		options = IF(options & 2048, options, options + 2048),
		options = IF(options & 4096, options, options + 4096),
		options = IF(options & 65536, options, options + 65536),
		options = IF(options & 131072, options - 131072, options),
	styleid = 0,
	imageprefix = '',
	password = '',
	vbseo_moderatepingbacks = 0,
	vbseo_moderatetrackbacks = 0,
	vbseo_moderaterefbacks = 0,
	chiefpost = 1,
	ei_replyaddress = 'atlanta@jobs.mymodeltalk.com',
	ei_hostname = 'mail.mymodeltalk.com',
	ei_username = 'atlanta@jobs.mymodeltalk.com',
	ei_password = 'getmoney',
	ei_folder = 'INBOX',
	ei_connectiontype = '0',
	ei_usergroups = '2',
	ada_forum = 1,
	ada_style = 3
WHERE forumid = 17;

MySQL Error   : Unknown column 'ei_replyaddress' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, May 27th 2009 @ 10:14:41 AM
Error Date    : Wednesday, May 27th 2009 @ 10:14:41 AM
Script        : http://www.mymodeltalk.com/jobs/admi....php?do=update
Referrer      : http://www.mymodeltalk.com/jobs/admi...o=edit&f=17&s=
IP Address    : 76.97.227.84
Username      : mykkal
Classname     : vB_Database
MySQL Version : 5.0.77-community
And then when I try to update the allowed forums I get another error:

Code:
Database error in vBulletin 3.8.1
Invalid SQL:

				SELECT ei_usergroups, title_clean, ei_active
				FROM vb_forum
				WHERE forumid = 57;

MySQL Error   : Unknown column 'ei_usergroups' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, May 27th 2009 @ 10:24:10 AM
Error Date    : Wednesday, May 27th 2009 @ 10:24:11 AM
Script        : http://www.mymodeltalk.com/jobs/admincp/usergroup.php?do=update
Referrer      : http://www.mymodeltalk.com/jobs/admincp/usergroup.php?do=edit&usergroupid=2
IP Address    : 76.97.227.84
Username      : mykkal
Classname     : vB_Database
MySQL Version : 5.0.77-community
Reply With Quote
  #150  
Old 05-29-2009, 05:19 PM
mykkal's Avatar
mykkal mykkal is offline
 
Join Date: May 2007
Location: Atlanta, GA
Posts: 485
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<font size="3">CAN I Get Some Support Please? It Has Been Months Since I First Asked.

Lordy...
</font>
Reply With Quote
  #151  
Old 05-29-2009, 11:11 PM
beishe8 beishe8 is offline
 
Join Date: Nov 2005
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by mykkal View Post
CAN I Get Some Support Please? It Has Been Months Since I First Asked.

Lordy...
Sorry, do not expect support for this beta version. "Last Update: 29 Feb 2008"
I would like to use this great hack but because of the teething problems with it, I can't.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:14 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.12728 seconds
  • Memory Usage 2,345KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete