Email posts into forum

*phew*

Here it is people, the hack I use at vBulletin.org that allows you to send replies to the thread through email.
I've rewritten most of it in the last couple of days, killing bugs and making the code more readable with comments.

Installation is pretty easy, download the attaced ZIP file and read readme.txt.

This hack is provided as is and with no support whatsoever!
DO NOT email, private message or contact me through any other means about this hack. You will be ingored and receive bad jake karma! (provided graciously by jake Inc.)
Bug reports are welcome.

I hope none of you will need any support, this is not a space ship and you don't need to be a rocket scientist to install it.

[high]* FireFly waits for someone to request a screen shot... :dead:
[/high]

Enjoy!

[amp2000]

Today at 04:20 PM Crazy Pete said this in Post #70
Hrm, well I think I'll have to uninstall this hack at least for now because no matter what I try and do, it's not updating my email_notify template with the new changes. Without even that working, I'm at a loss for now.

I'll take another look at this hack tomorrow or next week sometime & get it working, I have to!

Crazy pete, if you updated your email_notify template with the new changes & they dont take effect I think your problem is somewhere else mate, u sure your updating the correct template ?? I don't know what sort of a machine your installing this on so I cant really help ya anymore at the moment.

amp2000

[Crazy Pete]

Well it's odd. I looked at the database when I had this hack installed and saw two templates called email_notify. One of them had the templatesid of -1, which was the original template, then there was one with a templatesid of 1, which was the one I'd edited with the changes.

For some reason it never wanted to send me e-mails with the updated one, though it showed up correctly if I went to templates -> edit -> email_notify. I dunno. I appreciate the tips though.

[dodgy]

running:

UPDATE userfield SET field# = SUBSTRING(MD5(userid) FROM 10 FOR 5);

says:

Error
SQL-query :

UPDATE userfield SET field5 = SUBSTRING(MD5(userid) FROM 10 FOR 5)

MySQL said:


You have an error in your SQL syntax near '(userid) FROM 10 FOR 5)' at line 1

also code is different in 2.30

In functions.php, replace this:
---- start code ----------------------------------------------------------
$useremails=$DB_site->query("SELECT user.*
FROM subscribethread,user
WHERE subscribethread.threadid='$threadid'
AND subscribethread.userid=user.userid
---- end code ------------------------------------------------------------

differnet!

---- start code ----------------------------------------------------------
mail($touser[email],$emailsubject,$emailmsg,"From: \"$bbtitle Mailer\" <$webmasteremail>");
---- end code ------------------------------------------------------------

doesnt exist!

In showthread.php, add this:
---- start code ----------------------------------------------------------
if ($emailpostdata > 0) {
$noinclude = 1;
include('./procpost.php');
}

note that procpost is located in parent folder (as recommendation)

In the email_notify template, add this:
---- start code ----------------------------------------------------------
~~~~~ NEW ~~~~~
New at $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[field7]]
You should also remove this text to ensure your reply is readable by other forum users.
~~~~~ NEW ~~~~~

change of field7 not mentioned


.. just saying its not easy to install. not working on mine yet

[dodgy]

having same problems as Crazy Pete

i think this problem has something to do with this part:

$useremails=$DB_site->query("SELECT user.*,userfield.field$fieldid
FROM subscribethread,user,userfield,usergroup
WHERE subscribethread.threadid='$threadid'
AND subscribethread.userid=user.userid
...

[dodgy]

05-11-03 at 08:33 AM Crazy Pete said this in Post #62
Yep, I just tried it again. Replaced the whole email_notify template with just "TESTTESTTESTTESTTESTTEST" and its still sending me the default template when someone replies to a thread. ??

yep.. found the prob. 2.3 needs to query style as well. try this one:

  $fieldid = 5; // ID of the email password field in the user's profile
  $useremails=$DB_site->query("SELECT user.*, style.templatesetid, userfield.field$fieldid
                               FROM subscribethread,user,userfield,usergroup
                               LEFT JOIN style ON (IF(user.styleid=0, 1, user.styleid)=style.styleid)
                               WHERE subscribethread.threadid='$threadid'
                                 AND subscribethread.userid=user.userid
                                 AND userfield.userid=user.userid

subject line is missing tho

[Crazy Pete]

What did you change the e-mail query to, too? Since 2.3.0 uses the vbmail() function instead.

[amp2000]

Crazy Pete, I remember having a similar problem but thought 2.3.0 used the mail() function.
If what you said above is correct just replace mail() with vbmail()
Thats what i done.

[dodgy]

e-mail thing was easy..

find:

PHP Code:

        // work out the 'From' header
        if ($from == '') {
            $headers = "From: "$bbtitle Mailer" <$webmasteremail>\r\n" . $headers; 


and replace with

PHP Code:

        // work out the 'From' header
        if ($from == '') {
            $fromemail = 'CrazyPete@vbulleting.org';
      $headers = "From: "$bbtitle Mailer" <$fromemail>\r\n" . $headers; 


although.. I might have to unistall it coz I cant run getpost.php.. i dont know how other ppl do it but php scripts can only be runned within web enviroment and.. umm im lost

[dodgy]

01-03-03 at 07:24 PM NuclioN said this in Post #49
.procmailrc solution:
_____________________

:0
* (^To:|^CC:|^Cc .*emailadres@domain.ltd
|/usr/bin/php4 /path/to/getpost.php
_____________________
cyberty.nl

how can procmailrc execute php script?

[dodgy]

:laugh: :laugh:

it works! fiiiiinallllyyyy!!!