NNTP Gateway (Usenet/Newsgroups)

This hack provides a gateway to any NNTP newsgroup such as those from Usenet and other newsgroup servers. Selected newsgroups are imported from your news server and post on the forum are sent out to the newsgroup. This hack was greatly inspired by fastforward's usenet gateway hack. This one is a complete rewrite of that hack written in PHP and works with vB 2.2.2.

Installation:
Installation is pretty simple. No modifications to the vB php files are needed and it simply consists of dropping in the files to your forums directory, running the SQL modifications, and modifying the newsgroup settings for your desired newsgroups. For the complete installation details, read the readme.txt file.

Here are some of the features:

• Real cool vbcode to text conversion!
• All posts are inserted, even if parent thread cannot be found for replies
• Guests posts also get sent to the newsgroup.
• Importing of attachments from the newsgroup
• Poll info sent to newsgroup
• Attachment link sent to newsgroup
• Supports unlimited newsgroups and servers.
• email notification of new replies, just like regular forum posts
• Can import HTML messages and convert to limited vb code.

For control panel integration, please check out GameCrash's Graphical Interface addition.

What's not in it that was in fastforward's usenet gateway hack:

• No control panel integration at the moment. (Available separately)
• Does not support separate footers
• Does not allow custom email address to be used via the users option
• No spam control or string replacement support.
• No purging or autoexpire.

There is still lots that I'd like to add to it, but this is competely functional for basic newsgroup gateway support. It is most likely not free of bugs. If you have questions, suggestions or annoyances, please post in this thread.

vb3 support
lierduh modified this to provide support for the beta versions of vb3. When the release candidates of vb3 come out, I plan to add support for vb3 and add other features to this hack. If you have suggestions for new features, let me know.

E-mail gateway support
New in this version, you can now gateway with an email list. This will fetch emails from a POP email account and send via php's mail function to the mailing list's email address. To set up the list, in the newsgroup field, enter in the email address to send outgoing posts to. In the server field, enter in the pop3 server, and in the username and password fields enter in, you guessed it, the username and password to your pop account. Note: the email gateway capabilities has not been fully tested, so it might not work with your POP server. Also, it does not work in combo with a news<->forum gateway in the same forum (you can use either kind though in differnet forums within your forums).

[lierduh]

Originally Posted by himerus

Mine's also not assigning posts to the proper thread after this change. I'm going to look over the code again for another hour or so, and revert to my last version if I can't get it working properly.

Messed up part is, the posting via the vB adminCP scheduled tasks worked after only minimal tweaking of the new script, and I have it tested to successfully post properly. (which was my only problem before)

I think the main problem is coming from the references. They don't seem to be assigning at all anymore.

I think you are not using the "a" version I uploaded not long after the first upload. I posted a message about this.

I did some quick test with vB adminCP schedule tasks, it worked for me. What is the exact problem and what have you need to do to fix?

[himerus]

Okay, that's a relief, so I can update the table, and reset them all to an empty value without fear of messing it up entirely.

I'm still plugging away at a few of the other oddities. I think some of them may also be since I switched the news server I was using on a few of the groups.

[Imhotep]

well, let us know when it's all ready to go. i just got the green light from my host to try the script again.

[hubba]

>update the table, and reset them all to an empty

How? Alter table thread set.... ???

[lierduh]

Looks like some version of MySQL might not support this SQL statement. I will come up with another one to get around.

Could you do a test on your server. Just run this SQL manually:
=======================================
UPDATE post, thread SET post.isusenetpost = 1 WHERE
post.threadid = thread.threadid AND
post.isusenetpost = 0 AND
thread.forumid NOT IN (25,27,29,34)
=======================================

Originally Posted by allan grossman

Got a little trouble here too, lierduh

Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE post AS post, thread AS thread SET isusenetpost = 1 WHERE 
	post.threadid = thread.threadid AND 
	isusenetpost = 0 AND
	thread.forumid NOT IN (25,27,29,34)
mysql error: You have an error in your SQL syntax near 'AS post, thread AS thread SET isusenetpost = 1 WHERE 
	post.threadid = thread.th' at line 1

mysql error number: 1064

Date: Thursday 13th of May 2004 04:24:04 PM

Any thoughts?

[lierduh]

Originally Posted by hubba

>update the table, and reset them all to an empty

How? Alter table thread set.... ???

UPDATE thread SET msgid = '';

[hubba]

Thx!

[lierduh]

New version release:

**Build X-No-Archive header honouring system
**Improved speed
**Bug fixes
**Verbose output when run manually. Easier to find problem when interating with NNTP server.

change the honor_no-archive record from 0 to 1 to stop importing messages with X-No-Archive header, just as Google Group does.

Download it from:

https://vborg.vbsupport.ru/showpost....&postcount=658

[allan grossman]

Output from the manual query -

==========

Error

SQL-query :

UPDATE post,
thread SETpost.isusenetpost = 1 WHERE post.threadid = thread.threadid AND post.isusenetpost = 0 AND thread.forumid NOT IN ( 25, 27, 29, 34 )

MySQL said:

You have an error in your SQL syntax near ' thread SET post.isusenetpost = 1 WHERE post.threadid = thread.threadid AND post' at line 1

==========

MySQL version is 3.23

[Imhotep]

installed registry patch from M$, ran setlastmsg.php and got...

1 group(s) gatewayed.
<br />
<b>Fatal error</b>: Call to undefined function: logging() in <b>/nfs/home/cghaus2/public_html/forums/nntp.php</b> on line <b>77</b><br />