The Arcive of Official vBulletin Modifications Site.

Email Integration (New threads/replies by email) · **Released**: 07-01-2007

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

mykkal · #**982** 07-08-2009, 09:55 PM

Quote:

Originally Posted by Cyricx

You'll have to repeat your problem.

The biggest problem people have had is not redoing the file edits after they upgrade vbulletin *sigh*

The problem is where we left it in private messaging. I have reinstalled and followed the upgrade instructions. No matter what I get this error. Can you help me resolve it? A lot of my traffic was based on the email intergration mod and my revenue, etc... is way down now. I'm using php5 and MYSQL 5. The user for SQL has complete access to the database on a dedicated server.

It worked before I attempted this upgrade. Not since tho...

Code:

Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE vb_forum SET
	title_clean = 'Modeling &amp; Acting Auditions (Metro Miami/Ft. Lauderdale &amp; Florida!)',
	title = 'Modeling &amp; Acting Auditions (Metro Miami/Ft. Lauderdale &amp; 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

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

Cyricx · #**983** 07-08-2009, 10:38 PM

The tone of voice isn't very encouraging for making me want to help, but whatever.

Your missing some fields in your database. I'll run a test of this on the test board and try to duplicate it. The two fields your missing are from version 1.0 and version 2.2, so it makes me think your missing more then just those two.

What version of vbulletin are you running?

mykkal · #**984** 07-08-2009, 11:30 PM

Quote:

Originally Posted by Cyricx

The tone of voice isn't very encouraging for making me want to help, but whatever.

What exactly should I sound like after ASKING and WAITING more then 4 months for help when others get it same day?

Especially after I've supported you for more then 3 years.
One second... Did you really say that?

I am running vbulletin version 3.8.

Cyricx · #**985** 07-09-2009, 01:34 PM

I'm completely stumped. I've uninstalled and reinstalled on 3.8.3 and all of the fields are created. Do you use a table prefix?

lbernstein · #**986** 07-09-2009, 04:11 PM

Quote:

Originally Posted by Cyricx

Database field overlook. Use phpmyadmin or something similar to go into your database, go into the usergroup table and edit the ei_forumid field to set the character limit to 250. This will be fixed in the next version, or I'll have an alternate way for the system to handle this. Not too happy with how it does it now with typing in IDs. *shrug*

That's great that I can expand it. Do I edit the "char" or the "varchar" variable to expand the character limit to 250?

Thanks again.

Cyricx · #**987** 07-09-2009, 04:21 PM

Nope, varchar type field allows for 250 character limit.

So just edit the number 100 to 250 and that's it.

Fungsten · #**988** 07-09-2009, 06:09 PM

Quote:

Originally Posted by Cyricx

Nope, varchar type field allows for 250 character limit.

So just edit the number 100 to 250 and that's it.

Here's what I have for the "ei_forumid":

varchar(100) A pull down menu and a blank line. Where should it be changed?

Cyricx · #**989** 07-09-2009, 06:13 PM

Can you provide a screenshot? I'm unable to determine how to assist you from what you've typed there. It largely depends upon what program your using to interface with your database and the version of that program. Ultimately, you need to edit the field to change the 100 to 250.

Fungsten · #**990** 07-09-2009, 06:23 PM

Quote:

Originally Posted by Cyricx

Can you provide a screenshot? I'm unable to determine how to assist you from what you've typed there. It largely depends upon what program your using to interface with your database and the version of that program. Ultimately, you need to edit the field to change the 100 to 250.

This is in phpMyAdmin:

Attachment 101761

Cyricx · #**991** 07-09-2009, 06:35 PM

Your editting the data in the row, not the field itself.

On the left hand dropdown of tables, select "Usergroup", and then click "Structure" in the main screen along the top bar.

Now scroll down and put a checkmark next to ei_forumid and then click the pencil on the bottom.

Attached is a screenshot of the last step.

From there it'll open up to where you can easily change the char limit to 250.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07747 seconds Memory Usage 2,330KB 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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!