[RELEASE] Usenet Gateway for vB 2.01

Description:

This hack provides a gateway to selected usenet groups. The entire usenet group is mirrored locally. Posts submitted locally to mirrored newsgroups will also be sent out to usenet. A single perl script is executed via cron that collects news and posts any outgoing articles. Incoming messages are parsed against customizable spam filters and threaded correctly before being placed in your forums. By default, no personal information is sent to usenet other than the posters username and whatever you have globally configured as a footer and organization. The option does exist for a user to include a custom email to use for usenet posts. After initial installation (which involves creating some new tables, adding a few columns to existing vB tables, and entering the database connection information to the news script) configuration is completed via the vB control panel.

• See it in action at dBforums.com (usenet forums are at the bottom)
• Download latest version for vB 2.2.4

Current version is 20020323 for vB2.xx

Current feature list:

• correct threading of outgoing posts on usenet
• full control panel integration
• email notification to usenet replies
• emoticon translation into vb icons
• vb code removal or conversion prior to posting to usenet
• hyperlinked urls in messages
• color coded, italicized & indented quotes
• vB style quote to usenet style quote conversions for outgoing posts
• logging of outgoing posts
• support for multiple news servers
• support for seperate footers per forum in outgoing posts
• multi-language (selectable) handling of quoted MIME printable headers (for all those funny foreign characters)
• handling of mailing archive groups
• flexible spam control and replacement variable options for incoming and outgoing messages
• configurable auto-expire option
• option for users to show email address in their outgoing usenet posts (may be different than normal one in profile
• option to enable/disable user signatures on outgoing posts.
• fully compatible with vB moderation functions

Still to be done:

• canceling of messages after they have been sent to usenet via control message in accordance with RFC1036.
• binary attachment support
• email to PM gateway

Screeshots:
Main Options
More Options
Configuration of Newsgroups
Add New Newsgroups
Spam Control
What an imported usenet article looks like in vB

The latest version of this hack will always be in this first post of the thread.

Before asking questions in this thread, please read all the posts in this thread. If your question goes unanswered, it will probably be because the question has already been answered countless times in this thread.

This hack was created for use on my forums and will only be supported as time permits.


Links to required Perl Modules

• News::NNTPClient
• Net::SMTP
• MIME::WordDecoder
• Text::AutoFormat
• Mail::Address
• URI::Find
• DBI
• DBD::MySQL
• Date::Parse
• HTML::Entities

[GPSNUT]

Fastforward - First, thanks.

I also agree that a Vbulletin ver. 2.x should be around for a while and ver. 3 I don't think will be out too soon. Who knows how the hacks will work with it. ?

I'm still trying to get your hack installed and have yet to get any Usenet newsgroups installed.

Any additional update and install instructions will probably help my "slowness".

Thanks again.

[jOOPeON]

Hi guys,

I have a small problem with my search word table. Seems like
newnews.pl is stripping away all international characters when indexing?
Table is full of words without common scandinavian letters like ? , ? and ?.
Thats why my search doesn't work like it should.
Should i rebuild index once in a while or is it something that I can fix? Anyway all letters are correctly in posts.

-jOOP

Ps. How long it takes to reindex 300.000 posts

[GPSNUT]

When threads get inserted into the forum and I go to access them I get

"This person is on your Ignore List. To view this post click [here] "

I don't have a Ignore List setup. I check in UserCP .

Any ideas?

[GPSNUT]

Another strange one.

Database error in vBulletin Control Panel 2.2.5:
Invalid SQL: SELECT msgid,subject FROM usenet_article WHERE ORDER BY dtm ASC LIMIT 1
mysql error: You have an error in your SQL syntax near 'ORDER BY dtm ASC LIMIT 1' at line 1
mysql error number: 1064

[GPSNUT]

Why only NO THREADS being posted to forum?

-> fetching 46322... OK
-> fetching 46323... OK
-> fetching 46324... OK
-> fetching 46325... OK
-> fetching 46326... OK
-> fetching 46327... OK
-> fetching 46328... OK
-> fetching 46329... OK
-> processing article batch...
-> requested 29 messages... 0 not available or rejected.
-> inserting new threads from comp.sys.mac.graphics
-> inserted 0 threads
-> finding replies...
-> loading 1 replies...

[GPSNUT]

Why is this happening?

[fastforward]

I've never seen that problem before.

Does that happen for every post or just usenet posts? What version of vB are you using?

[GPSNUT]

It only happens to Usenet posts in the forums I have created. Nothing special.

Version 2.2.5

I stuck. I look at SQL tables, etc.

I'm thinking I should replace all PHP files in the forums directory.

I'm so thankful you responded. I really want this to work.

[dpajur]

The download link is broken, can someone please have a look at it?

Just thought I'd let you know

[fastforward]

Originally posted by GPSNUT
It only happens to Usenet posts in the forums I have created. Nothing special.

Version 2.2.5

I stuck. I look at SQL tables, etc.

I'm thinking I should replace all PHP files in the forums directory.

I'm so thankful you responded. I really want this to work.

It seems this is a known bug with vB 2.2.5 and php 4.2. It has to do with posts by unregistered users. Usenet posts are effectively exactly that. Read this thread for a fix:
http://www.vbulletin.com/forum/showt...5&pagenumber=2