vB Mail Reply

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.

• 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:
  

  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.

[Lionel]

The installation appears to be fine, however the email that I am getting is empty with the words (no subject) and in the body: [no message]. Even the post itself is missing.

I went in phrases to update just in case, still no luck... Please help!

[Lionel]

Which phrases are included in email? I put in my back up copy and I am still getting the same problem. Now, last night I installed, removed it because I did not have IMAP functionality yet, and I am afraid that the removal removed the whole phrases.

[Lionel]

I installed and uninstalled so many times. It tells me the same thing everytime: That there is a parse error on eval code at line 11 and that I am missing a ']'. I reverted back and I am still getting the same thing. I'll b getting it with a blank message until I remove the new phrase completely. Which leaves me to believe that the problem is in the phrase.

I looked at the phraseit seems to be fine

~~~~~ 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:
[thread-\$threadinfo[threadid]-\$touser[field\$vboptions[mailserver_profilefieldid]]]
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_emailadress] with this code in the subject: [newthread-\$foruminfo[forumid]-\$bbuserinfo[field\$vboptions[mailserver_profilefieldid]]]
~~~~~ NEW ~~~~~

[Lionel]

yep! $touser[field should be closed in both instances ....before $vboptions

[freeshares1]

I am getting this error

Fatal error: Call to undefined function: imap_open() in /home/xxx/domains/xxx.com/public_html/vb/includes/cron/vbemailreply.php on line 55

The install went fine, the pop account is working fine in outlook. I use port 1010 but changed the port from 110 to 1010 in the php file.

Any other idea's?

[Lionel]

Originally Posted by Seinfeld

So more time but when i send a mail i have ...

The error that occurred was:
No permission: you do not have permission to post in this forum.

what is wrong?

I get the same error too. What I did was commenting this out. However, when I send a mail with the variable [thread-$threadinfo[threadid]-password], it post, but by itself in no forum, and of course as such, the post cannot be found

When I try to change the thread into [post-$threadinfo[threadid]-password]

then nothing happened.

[freeshares1]

Originally Posted by freeshares1

I am getting this error

Fatal error: Call to undefined function: imap_open() in /home/xxx/domains/xxx.com/public_html/vb/includes/cron/vbemailreply.php on line 55


The install went fine, the pop account is working fine in outlook. I use port 1010 but changed the port from 110 to 1010 in the php file.

Any other idea's?

Any idea's or suggestions?

Thanks in advance

[freeshares1]

I have fixed my error it was my php not compiled with imap so thats all good and the cron works but the emails i recieve are blank.

and i am getting this error as others are

Parse error: parse error, unexpected T_VARIABLE, expecting ']' in /home/xxxl/domains/xxx/public_html/vb/includes/functions_newpost.php(1091) : eval()'d code on line 11

[Lionel]

blank emails? Make sure you setup a username and password in the settings. After that, If you manage to post in forums, please let me know how you did it.

[Lionel]

and for the variable error that you are getting, it has to do with the phrase 'notify' where they are missing a ']' . But that is another story. You'll find out that variable profilefiled will never pass and you'll end up harcoding it directly in code.