The Arcive of Official vBulletin Modifications Site.

vB Mail Reply · **Released**: 08-07-2004

vB Email Reply 0.7BETA

What it does:
This allows your members (and you of course) to reply to threads by email. All they have to do is wirte to a specific email address (that you specify) and include a special code in the email subject.

How it works:
A script (vbemailreply.php) is run using the vB3 Cronsystem every minute. This checks a pop3 or imap account for emails and then processes these emails, inserting the data into the database. Then a reply is sent to the sender, stating that either the post/thread got entered correctly or that there was some kind of error.

Is it complicated?
Actually no. There is an install script that does most of the work as well as two small file changes. If you do have problems installing it, contact me for help.

Changes:
New files (2):
/includes/cron/vbmailreply.php
/includes/mimeDecode.php

Changed files(1):
/includes/functions_newpost.php

New database fields/tables(1):
New userfield added by installscript

New templates(0):

Changed templates(0):

New phrases(3):
emailreplyerror
emailreplydone
emailnewthreaddone

Changed phrases(1):
notify

Screenshots:
none

Credits:
The idea and small parts of the script are based on Chen 'FireFly' Avinadav's Email posts into forum hack, found here: https://vborg.vbsupport.ru/showthrea...threadid=40595

Instructions:

Backup all your files as well as your database.
For help backing up your database, look here: http://www.vbulletin.com/docs/html/m...atabase_backup
Upload vbmailreply.php to your /includes/cron/ folder
Upload mimeDecode.php to your /includes/ folder
Open the file /includes/functions_newpost.php in your favourite PHP editing program.

Code:

FIND (around line 196):
 
$post['poststarttime'] = trim($post['poststarttime']);
 
ADD BELOW:
 
if ($post['isemail']) { $bbuserinfo = $post['userinfo']; }
 
 
FIND (around line 273):
 
if ($vboptions['logip'])
 
REPLACE WITH:
 
if ($vboptions['logip'] AND !$post['isemail'])
 
 
FIND (around line 321):
 
if ($prevpostfound)
{
 
ADD BELOW:
 
if ($post['isemail'])
{
return ('dupepost');
}
else
{
 
 
FIND:
 
}
else
{
if ($parentid == 0 AND $type != 'thread')
 
REPLACE WITH:
 
}
}
if (!$prevpostfound)
{
if ($parentid == 0 AND $type != 'thread')
 
 
FIND:
 
	$useremails = $DB_site->query("
		SELECT user.*, subscribethread.emailupdate
		FROM " . TABLE_PREFIX . "subscribethread AS subscribethread, " . TABLE_PREFIX . "user AS user
		LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
		WHERE subscribethread.threadid = $threadid AND
			subscribethread.emailupdate IN (1, 4) AND
			subscribethread.userid = user.userid AND
			user.usergroupid <> 3 AND
			user.userid <> " . intval($userid) . " AND
			user.lastactivity > " . intval($lastposttime['dateline']) . " AND
			(usergroup.genericoptions & " . ISBANNEDGROUP . ") = 0
	");
 
REPLACE WITH:
 
	$useremails = $DB_site->query("
		SELECT user.*, userfield.*, subscribethread.emailupdate
		FROM " . TABLE_PREFIX . "subscribethread AS subscribethread, " . TABLE_PREFIX . "user AS user
		LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON (userfield.userid = user.userid)
		LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
		WHERE subscribethread.threadid = $threadid AND
			subscribethread.emailupdate IN (1, 4) AND
			subscribethread.userid = user.userid AND
			user.usergroupid <> 3 AND
			user.userid <> " . intval($userid) . " AND
			user.lastactivity > " . intval($lastposttime['dateline']) . " AND
			(usergroup.genericoptions & " . ISBANNEDGROUP . ") = 0
	");
 
 
FIND:
 
$evalemail["$languageid"] = '$message = "' . str_replace("\\'", "'", addslashes(iif(empty($email_text[PHRASETYPEID_MAILMSG]), $emails['-1'][PHRASETYPEID_MAILMSG],$email_text[PHRASETYPEID_MAILMSG]))) . '";'.
 
ADD ABOVE:
 
$touserfieldcode = "field".$vboptions[mailserver_profilefieldid];
$subjectcode_reply = "[thread-".$threadinfo[threadid]."-".$touser[$touserfieldcode]."]";
$subjectcode_newthread = "[newthread-".$foruminfo[forumid]."-".$touser[$touserfieldcode]."]";

Add the following as a translation of the phrase notify:

Code:

Hello $touser[username],
 
$bbuserinfo[username] has just replied to a thread you have subscribed to entitled - $threadinfo[title] - in the $foruminfo[title] forum of $vboptions[bbtitle].
 
This thread is located at:
$vboptions[bburl]/showthread.php?t=$threadinfo[threadid]&goto=newpost
 
~~~~~ NEW ~~~~~
New at $vboptions[bbtitle]!
You can now reply to the thread by replying to this message. All you need to do is to make sure this code appears in the email subject:
$subjectcode_reply
You should also remove this text to ensure your reply is readable by other forum users.
Additionaly, you can start a new thread in the $foruminfo[title] Forum simply by sending a mail to $vboptions[mailserver_emailaddress] with this code in the subject: $subjectcode_newthread
~~~~~ NEW ~~~~~
 
Here is the message that has just been posted:
***************
$pagetext
***************
 
There may be other replies also, but you will not receive any more notifications until you visit the forum again.
 
Yours,
$vboptions[bbtitle] team
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Unsubscription information:
 
To unsubscribe from this thread, please visit this page:
$vboptions[bburl]/subscription.php?do=usub&t=$threadinfo[threadid]
 
To unsubscribe from ALL threads, please visit this page:
$vboptions[bburl]/subscription.php?do=viewsubscription&folderid=all

Upload the file vbmailreply_install.php to your admincp folder
Be sure to either have a POP3 or IMAP email account ready before running the installation. The data will need to be entered.
Open your browser and go to http://www.yourforums.com/admincp/vb...ly_install.php and follow the instructions.
Delete the vbmailreply_install.php file from your webserver.

Donations:
This hack will always be free, however your donations are kindly accepted and will help towards further development. If you donate, please leave me some info (either your forum site or username at vB.org) so that I can thank you.

Install:

Don't feel like donating, but still want to thank me for my work? Click the install button to show your appreciation. As a great side effect, you'll get an email update once there is a bigger update or important security fix!

Updates:

09.08.2004 - I've updated the vbemailreply_install.php file, as there was an wrong value while entering the settings.

Also added support for SSL (untested)
Fixed the whole install routine.
03.11.2004 - Updated the installation as well as the vbemailreply.php file.

SBlueman · #**172** 05-20-2007, 03:43 AM

so is this a dead mod?

giovannicosta · #**173** 05-28-2007, 10:44 AM

Cool, I will click install to wait for updates...3.6.7 compatible I assume?

InfoNirvana · #**174** 05-28-2007, 06:40 PM

Quote:

Originally Posted by Cyricx

No promises....

But I've gotten permission from Colin to port this as long as I release it here.

I'm giving it a whirl... but as I said.. no promises....

That'd be great.

Quote:

Originally Posted by Dullweber

I can't help with programming, but the company I'm working for would actually pay for such a feature, I just posted a service request. Maybe that's motivating enough to really give it a whirl? PM me if you are interested...

Regards,
Dullweber

I'll ask my group. They'd be happy to contribute for this functionality.

Quote:

Originally Posted by giovannicosta

Cool, I will click install to wait for updates...3.6.7 compatible I assume?

I did as well.

tekguru · #**175** 06-16-2007, 09:13 PM

Did anything ever come of developing this Mod?

Cyricx · #**176** 06-18-2007, 11:30 AM

Just trying to juggle time to release a beta version. I've got it done except for attachments. I'm hoping to release something soon, it's all a matter of what time I can set aside from work and family.

tekguru · #**177** 06-18-2007, 04:15 PM

That is superb news as this is the one facility that we find missing from vB.

If you want any testers just yell!

DjTaz · #**178** 06-18-2007, 07:48 PM

Quote:

Originally Posted by Cyricx

Just trying to juggle time to release a beta version. I've got it done except for attachments. I'm hoping to release something soon, it's all a matter of what time I can set aside from work and family.

Will this new version be for VB 3.6 or for 3.5 ?

Im running 3.5 at the moment and dont really want to go to 3.6 cause ill lose all of the mods i have done already

Hostboard · #**179** 07-14-2007, 01:32 PM

What phrases do these apply to? Did a quick search but came up empty. Tried to modify the install script and re-run but it did not like the chnages.

Thanx

Quote:

I also had a few problems with the confirmation emails. So a few changes to vbemailreply_install.php are needed.

Around line 440, find:

Code:

\$vboptions[bburl]/showthread.php?p=$newpost[postid]#post\$newpost[postid]

and replace with:

Code:

\$vboptions[bburl]/showthread.php?p=$newpost[postid]

Around line 447, find:

Code:

Your thread \"\$threadinfo[title]\" was succesfully received and entered in the forum \$foruminfo[title]!
Here is a direct link to your post:
\$vboptions[bburl]/showthread.php?t=\$threadinfo[threadid]

and replace with:

Code:

Your thread entitled "$title" was successfully received and entered in the forum $foruminfo[title].
 
Here is a direct link to your post: $vboptions[bburl]/showthread.php?t=$newpost[threadid]

Or in my case, I simply modified the necessary phrases after the installation.

tekguru · #**180** 07-14-2007, 09:57 PM

Any progress yet?

Cyricx · #**181** 07-15-2007, 12:09 AM

I've released the beta version here -

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

The only things I've got left to solve before I release the full version is the attachment code

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08413 seconds Memory Usage 2,320KB Queries Executed 25 (?)
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 (6)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 (3)pagenav_pagelink (1)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!