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

[jarvis]

I'm a UNIX idiot and would like to install this hack. I do have access to a shell, but I do not know how to do the first part of this install "running the nntp.sql".

Could anyone give me a hand here? It could be via PM or email to jarvis@mhogaming.com as to keep the thread on-topic.

Thanks in advance!! :nervous:

[GameCrash]

Do you have phpMyAdmin? That would make this much easier...

[jarvis]

Gamecrash,

I do have PhpMyAdmin... now that being said, I'm still lost.

Is this a completely new dB that I set up? I'm usually not this helpless, but I find myself needing some exact syntax to get going.

Thanks a million!

[Sanjiyan]

Originally posted by Gilby
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). [/B]

So does that mena, I can get the forums to pick up email from a pop3 account, ie it can pickup email from a mailbox and automatically post it to a forum for me?

[Gilby]

Originally posted by Sanjiyan


So does that mena, I can get the forums to pick up email from a pop3 account, ie it can pickup email from a mailbox and automatically post it to a forum for me?

That's exactly what it means. It can also send posts to an email address too.

[Sanjiyan]

Originally posted by Gilby


That's exactly what it means. It can also send posts to an email address too.

heh get on msn gilby mate.. time for a little chat ^_^

[Sanjiyan]

what about that pop3 file in version 1.9?

do I need to upload that at all?

[Gilby]

Originally posted by Sanjiyan
what about that pop3 file in version 1.9?

do I need to upload that at all?

Yes, that's for the email capabilities.

[Gilby]

Originally posted by jarvis
Gamecrash,

I do have PhpMyAdmin... now that being said, I'm still lost.

Is this a completely new dB that I set up? I'm usually not this helpless, but I find myself needing some exact syntax to get going.

Thanks a million!

Same database. Just go in to that database under phpMyAdmin and there will be a box wher you can type SQL to execute, and underneith that is a file browse input where you can select an sql file to execute. You can run it from either, the file way is easier.

[Sanjiyan]

Post 1 of 2

Gilby,

Attached is a image of a linking problem I was on about on MSN, with regards to the RE: posts not joingin together under the email to forums addon part of this hack.

You asked me to add [FFML] to the prefix section on the MySQL database entry which I did, see the image in post 2 of 2.

Any ideas?

[Sanjiyan]

Post 2 of 2

[Sanjiyan]

Hi,

getting problems if I do a 'Update Thread Info - update thread post counts, original posters, last post date, attachment totals' command via the Up-Date Counters section on the admin cp.

This only started to occur then I updated to Gilbys 1.9 version of the NNTP/Email feed, I belive all the newsgroup based forums (forumid)s are affected, I cant tell cos it bombs out on the first newfeed based forum it tries to update the counters on.


The error given is:

Forum ids:

Processing forum 89

Warning: MySQL: Unable to save result set in /usr/home/wocsnet/public_html/admin/db_mysql.php on line 93



There seems to have been a slight problem with the Sanjiyan's Japanese Anime and Manga Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT lastpost,lastposter FROM thread WHERE lastpost='1017967998'
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Friday 05th of April 2002 02:45:19 AM
Script: http://www.wocs.net/admin/misc.php
Referer: http://wocs.net/admin/misc.php?action=chooser


Also the forum it fails on as well as being NNTP based, is also the email forum, ie the forum that deals with and posts the POP3 mailing list feed.

[jarvis]

I've got this hack working and love it!! Thanks!

Question to everyone, though. What kind of speeds is everyone getting from their servers. Reason I ask, is I log in via OE to my news server and get great throughput, but when I run the gateway.php I get speeds in the 500 bytes/sec area. Big difference... Could anyone have any thoughts as to the speed difference. The only thing I can think is my host has the speed throttled for incoming connections or something.

Thanks!

[Gilby]

Originally posted by Sanjiyan
Post 2 of 2

Take out the brackets, that's implied in the prefix column.

[Gilby]

Originally posted by Sanjiyan
This only started to occur then I updated to Gilbys 1.9 version of the NNTP/Email feed

And an upgrade to 2.2.5? do you know if it happened with 2.2.4 of vb and 1.9 of the gateway?