vb.org Archive
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

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)

tacoX 09-03-2002 08:50 PM
Looks like another rip of yaxay! *Looks Up* thanks chen...

Linux 10-02-2002 03:50 AM
Child process of virtual_address_pipe transport returned 69 (could mean service or program unavailable)

me too I had the same problem , any tips or solution ?

PhotoGenie 10-22-2002 12:45 AM
Can anyone tell me what to do to get the emails sent from the relpy's to show the content of the post. Like the emails I get here that say...

Here are the contents of the post:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Well, I'm glad that no one wants to help me out. */sarcasm* :p
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I didn't see anything in the code changes to add this. Thanks

ChurchMedia 12-28-2002 11:34 PM
Has anyone actually got this to work? I don't see any reference in the instructions to getpost.php other than "don't put it in your public directory". So, I'm not sure how to apply it.

Also, it creates an error when replying after I make the mods:

Quote:
Database error in vBulletin 2.2.9:

Invalid SQL: SELECT user.*,userfield.field8
FROM subscribethread,user,userfield
WHERE subscribethread.threadid='1'
AND subscribethread.userid=user.userid
AND userfield.userid=user.userid
AND usergroup.usergroupid=user.usergroupid
AND user.userid<>'1'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1041124392' mysql error: Unknown table 'usergroup' in where clause

mysql error number: 1109
The usergroup table shows up and seems to be okay. Any ideas?

Thanks!

SemperFidelis 12-30-2002 08:03 AM
Hmmm
Im getting the exact same error as ChurchMedia
(running vb 2.2.9)
Quote:
Database error in vBulletin 2.2.9:

Invalid SQL: SELECT user.*,userfield.field5
FROM subscribethread,user,userfield
WHERE subscribethread.threadid='2'
AND subscribethread.userid=user.userid
AND userfield.userid=user.userid
AND usergroup.usergroupid=user.usergroupid
AND user.userid<>'1'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1041223298' mysql error: Unknown table 'usergroup' in where clause

mysql error number: 1109

Date: Monday 30th of December 2002 06:03:50 PM
Anyone got any ideas on this one ?

Xenon 12-30-2002 02:14 PM
your query is incorrect
instead of this:
Code:
SELECT user.*,userfield.field5
FROM subscribethread,user,userfield
WHERE subscribethread.threadid
it should be this:
Code:
SELECT user.*,userfield.field5
FROM subscribethread,user,userfield,usergroup
WHERE subscribethread.threadid

Mystis 12-30-2002 09:51 PM
Thanks for releasing it Firefly, I learned quite a bit studying the code!

SemperFidelis 12-30-2002 11:26 PM
Cheers Xenon
That has fixed it all up
:D

NuclioN 01-03-2003 04:24 PM
.procmailrc solution:
_____________________

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

NuclioN 01-03-2003 04:30 PM
if you get problems with that mysql_connect is an invalid option, edit your php.ini file (OF YOUR CGI PHP, debian /etc/php/cgi/php.ini) and add extenstion=mysql.so
_______

NuclioN 01-08-2003 03:05 AM
Altough the mail pipe is working correct, members having problems with the reply errormail. This errormail is blanc.
Sometimes a mailed reply is succesfull, other times not. And wierd is that the admins are instantly got the "U have no permission etc" error-logout message when they check the reply on the forum after sending it trough mail. (??)

USODJA 02-02-2003 01:48 PM
Database error in vBulletin 2.2.9:

Invalid SQL: SELECT user.*,userfield.field16
FROM subscribethread,user,userfield
WHERE subscribethread.threadid='665'
AND subscribethread.userid=user.userid
AND userfield.userid=user.userid
AND
usergroup.usergroupid=user.usergroupid
AND user.userid<>'79'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1044170812'
mysql error: Unknown table 'usergroup' in where clause

mysql error number: 1109

Kars10 02-02-2003 01:49 PM
@ USODJA, look @ Post 46...

USODJA 02-02-2003 02:21 PM
Thanks, that worked, now for the pipeline...LOL

And put on glasses to see other posts....

mcyates 02-05-2003 02:25 PM
Sorry i'm stupid, BUT how do i change this, what file / database table

Quote:
Originally posted by Xenon
your query is incorrect
instead of this:
Code:
SELECT user.*,userfield.field5
FROM subscribethread,user,userfield
WHERE subscribethread.threadid
it should be this:
Code:
SELECT user.*,userfield.field5
FROM subscribethread,user,userfield,usergroup
WHERE subscribethread.threadid

squawell 02-05-2003 02:26 PM
i have a problem....

when i get the mail....what should i do next ???

ex:how to reply??can someone give me some screenshot will be easy understand....because i confused....

thankz.....

USODJA 02-06-2003 06:08 PM
Quote:
Originally posted by mcyates
Sorry i'm stupid, BUT how do i change this, what file / database table
Functions.php ...

sabret00the 02-23-2003 12:16 PM
Code:
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 ------------------------------------------------------------
With this:
---- start code ----------------------------------------------------------
  $fieldid = 7; // ID of the email password field in the user's profile
  $useremails=$DB_site->query("SELECT user.*,userfield.field$fieldid
                              FROM subscribethread,user,usergroup,userfield
                              WHERE subscribethread.threadid='$threadid'
                                AND subscribethread.userid=user.userid
                                AND userfield.userid=user.userid
---- end code ------------------------------------------------------------
my functions.php aint got that, it might have something do with another hack, i got something similar so i might try editing that, just wanna make sure i don't thuck anything else up

Big Daddy Chemo 03-02-2003 04:41 PM
Quote:
This message was created automatically by mail delivery software (Exim).

A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed:

pipe to |/home/bdcnut2/public_html/forum/getpost.php
generated by post@*MYDOMAIN*.com
Child process of virtual_address_pipe transport returned 69 (could mean service or program unavailable) from command:
/home/bdcnut2/public_html/forum/getpost.php
Can someone help me out here? I see there were others with the same error message so if you have worked through this with Exim please share the knowledge.

Now, I have a dedicated server and I added the pipe in my alias file (etc/valiases/mydomain.com). At the command line I ran newaliases. Still get the above error.

I then deleted the entry, newaliases at the command line, and added them through cPanel6. Still the same error.

Little help from the knowledgeable?

Chemo

amp2000 05-02-2003 05:37 PM
I've been trying this all day & am getting really confused, I have vBulletin 2.3.0 & have tried to install it with that, but my replies never go into the Forum.
in the code_changes.txt it says
PHP Code:
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 ------------------------------------------------------------
With this:
---- start code ----------------------------------------------------------
  $fieldid = 7; // ID of the email password field in the user's profile
  $useremails=$DB_site->query("SELECT user.*,userfield.field$fieldid
                               FROM subscribethread,user,userfield
                               WHERE subscribethread.threadid='$threadid'
                                 AND subscribethread.userid=user.userid
                                 AND userfield.userid=user.userid
---- end code ------------------------------------------------------------
And change the $fieldid variable to the right field ID. 
Now I dont have that in my functions.php, I have this
PHP Code:
$useremails=$DB_site->query("SELECT user.*, style.templatesetid
                               FROM subscribethread,user,usergroup
                               LEFT JOIN style ON (IF(user.styleid=0, 1, user.styleid)=style.styleid)
                               WHERE subscribethread.threadid='$threadid'
                                 AND subscribethread.userid=user.userid
                                 AND usergroup.usergroupid=user.usergroupid
                                 AND user.userid<>'$userid'
                                 AND user.usergroupid<>'3'
                                 AND usergroup.canview = 1
                                 AND user.lastactivity>'$lastposttime[dateline]'"); 
so I replaced it with this
PHP Code:
$fieldid = 5; // ID of the email password field in the user's profile
$useremails=$DB_site->query("SELECT user.*,userfield.field$fieldid, style.templatesetid
                               FROM subscribethread,user,usergroup,userfield
                               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
                                AND usergroup.usergroupid=user.usergroupid
                                 AND user.userid<>'$userid'
                                 AND user.usergroupid<>'3'
                                 AND usergroup.canview = 1
                                 AND user.lastactivity>'$lastposttime[dateline]'"); 
I think that is right. I have also figured out the pipe with the e-mail by putting
PHP Code:
post: | /usr/bin/php /tmp/getpost.php 
in my /etc/aliases file & restarted postfix & ran newaliases
Now here is where I get really confused, I receive the email telling me there was a reply to my post & I reply to it by replying to the e-mail but the post never makes it to the forum. If I dont have getpost.php world writable I get an error in my delivery failure report saying permission denied on getpost.php.
If I do have getpost.php world writable my reply is appended to the end of getpost.php.

Any ideas what's going on here people???

Thanks in advance for any replies.

amp2000

Crazy Pete 05-11-2003 06:26 AM
Ok this hack doesn't seem to want to work for me for some reason. I edited the email_notify template, yet everytime I test it out and I get the e-mail notification sent to me, it still shows up as the default template without the additions I made to it. What's going on? I'm running 2.3.0 also.

Crazy Pete 05-11-2003 06:33 AM
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. ??

Crazy Pete 05-12-2003 11:53 AM
Still wondering why this isn't using my modified email_notify template. Anyone know?

Crazy Pete 05-14-2003 01:17 PM
Can someone please post an updated version of this that works with vB 2.3.0? Apparently there are a few differences in the code from 2.2.x to 2.3.0, because it doesn't want to work correctly for me.

amp2000 05-14-2003 06:30 PM
Quote:
05-11-03 at 08:26 AM Crazy Pete said this in Post #61
Ok this hack doesn't seem to want to work for me for some reason. I edited the email_notify template, yet everytime I test it out and I get the e-mail notification sent to me, it still shows up as the default template without the additions I made to it. What's going on? I'm running 2.3.0 also.
What have you got working so far ? If you reply to the mail will it post the reply back into the forum it came from???
I was trying this a few days ago & was receiving the e-mail, but when I replied to the mail the reply never went into the forum :rolleyes:

Crazy Pete 05-14-2003 06:33 PM
I never get the e-mail with the threadid or anything in it, I just get the standard notification e-mail. What changes did you make to functions.php? Maybe I didn't change the correct things?

amp2000 05-14-2003 07:13 PM
I'm still very new to vBulletin so forgive me if this is a stupid question, but do you receive the following in your notification e-mail ??

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-5-]
You should also remove this text to ensure your reply is readable by other forum users.

Lemme know ;)

I did make some changes that werent in the readme to get this far but I've a bigger problem at the moment (98% of registered users arent showing up in my members list, ahhh) so I cant tell you exactly where I made the changes till i have this problem sorted.

amp2000

Crazy Pete 05-14-2003 07:17 PM
Quote:
Today at 04:13 PM amp2000 said this in Post #67
I'm still very new to vBulletin so forgive me if this is a stupid question, but do you receive the following in your notification e-mail ??

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-5-]
You should also remove this text to ensure your reply is readable by other forum users.

Lemme know ;)
Nope, I don't get that at all. I just the standard e-mail notification template without the additions from this hack.

amp2000 05-14-2003 07:56 PM
Heres what i done to my my email template so far if it helps you
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 $bbtitle.
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[field5]]
You should also remove this text to ensure your reply is readable by other forum users.

This thread is located at:
$bburl/showthread.php?threadid=$threadinfo[threadid]&goto=newpost

There may be other replies also, but you will not receive any more notifications until
you visit the board again.

Yours,
$bbtitle team

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Unsubscription information:

To unsubscribe from this thread, please visit this page:
$bburl/member2.php?action=usub&threadid=$threadinfo[threadid]

To unsubscribe from ALL threads, please visit this page:
$bburl/member2.php?action=usub&type=allthread
I'm not sure but [thread-$threadinfo[threadid]-$touser[field5]] dosent look like correct syntax to me so you might want to start there (I could be wrong though)

Let me know how you get on :D

Crazy Pete 05-15-2003 02:20 PM
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.

amp2000 05-15-2003 07:06 PM
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

Crazy Pete 05-15-2003 07:10 PM
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 05-20-2003 01:33 AM
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:(

dodgy 05-20-2003 04:10 AM
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
...

dodgy 05-20-2003 05:30 AM
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:(

Crazy Pete 05-20-2003 01:36 PM
What did you change the e-mail query to, too? Since 2.3.0 uses the vbmail() function instead.

amp2000 05-21-2003 08:06 AM
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 05-22-2003 04:22 AM
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 05-22-2003 04:25 AM
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?

dodgy 05-22-2003 05:57 AM
:laugh: :laugh:

it works! fiiiiinallllyyyy!!!


All times are GMT. The time now is 03:09 PM.
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01727 seconds
  • Memory Usage 1,905KB
  • 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
  • (7)bbcode_code_printable
  • (6)bbcode_php_printable
  • (16)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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