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