How's the update going? :) Would your update be similar to the current lierduh's version, or different? I don't want to use lierduh's version, and then find out yours is very different necessitating a complete redo.

/me waits patiently for an official release for vb3

I'm getting some Sql errors when I try to run the newer VB-3 gateway.php posted by Lierduh. Anybody have a clue where to look for this??

Chas.

"Database error in vBulletin 3.0.0:

Invalid SQL: SELECT
post.postid,post.username,post.userid,post.datelin e,post.pagetext,post.showsigna ture,post.ipaddress,thread.pollid,thread.title,pos t.threadid,post.attach,thread. forumid
FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND
post.dateline=thread.dateline AND post.userid=thread.postuserid AND
(thread.forumid=)
mysql error: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near ')' at
line 1

mysql error number: 1064

The error is at: (thread.forumid=)

That means the script did not retrieve the correct forum IDs.

The code for above is:

thread.forumid=". implode(" OR thread.forumid=", $group[forum])

You probably have not set up "nntp_groups" table properly.

Thanks for responding. I have got the proper group ID# in there, but it's hard to tell now because I put the entries in the field that had the description and I can't see the description anymore. Also, my view if PHPMyadmin looks alot different than the screenshots at the beggining of this thread.
I'm trying to set it up as a mail gateway, not a usenet gareway, I'll go back and try again.

Chas.

I see where I was going wrong with the entries in MySql. Now that it is fixed I am still getting one small error when I run the gateway.php, see below

"1 group(s) gatewayed.<br />
<b>Fatal error</b>: Cannot instantiate non-existent class: pop3 in <b>/var/www/html/forum/gateway.php</b> on line <b>76</b><br />"

Has anyone got this to work with mail on VB-3? I would apreciate any input, good or bad, I just need to know if this can be done or not.

Thanks.

Okay, I'm using lierduh's version, and it seems to be working with vB3 Gold. :) Thanks!

Hi Erwin, thanks for responding. I think that you and I host at the same place, at least I think I've seen some of your posts in the forums there. If so, have you had any trouble using this as a mail to forum integration using RedHat ES/Ensim combo (if that is what you use)? Any special setup with that?

TIA,
Chas.

I have disabled the mail post function. You can try to uncommon the require_once("class.POP3.php3"); line and upload the class file.

Hi Lierduh,
Thanks, I have done what you said and now mail is going from the forum to the mailing list I have set up, that is a big step forward! But I am not able to send from mailbox to forum. Additionally, the mail that arrives from the forum to the mail has a return address of;
"admin.14j7a0@timelimit.yourserver.com"
Which is not the address of the mailing list.

I have seen something like this hack work on phpBB, but in that case all you need to do is subscribe to the forum setup for mail, you don't have to join the mail list. I can't seem to figure out how to subscribe to a 'froum' in VB-3. only a thread, so it is necesary to join the mailing list to receive mail.
Any thoughts from anyone on this would be greatly appreciated.

Chas.