vb.org Archive - Email posts into forum

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Email posts into forum (https://vborg.vbsupport.ru/showthread.php?t=40595)

Quote:

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

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. :)

running:

Quote:

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

Quote:

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!

Quote:

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

doesnt exist!

Quote:

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)

Quote:

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

having same problems as Crazy Pete

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

Quote:

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

Quote:

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:

Code:

  $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:(

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

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.

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

Quote:

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?

:laugh: :laugh:

it works! fiiiiinallllyyyy!!!

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_php_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01155 seconds Memory Usage 1,755KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_php_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: