[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

Thanks for the quick reply

I'll post the full error when I have a sec. (I use SSH and I cant paste out of the damn thing....)

Anyway its 03:15 in the UK, and I shoudl probably turn up for work later.

Cheers

Dibble.

[webhost]

try blocking everything with the mouse and using ctrl key then go to notepad place your cursor where you want it and it paste.

I defeated the evil SSH and used Telnet (no-one looking at my password? Good.)

So, here is most of the error message.

=============
There was stuff before this............
NNTPERROR: 430 No Such Article
NNTPERROR: 430 No Such Article
NNTPERROR: 430 No Such Article
NNTPERROR: 430 No Such Article
NNTPERROR: 430 No Such Article
-> processing article batch...
-> requested 56 messages... 0 not available or rejected.
-> inserting new threads from alt.comp.periphs.cdr.mitsumi

Query failed:
INSERT INTO post (title,allowsmilie,threadid,dateline,nntpdateline, pagetext,visi
ble,msgid,ord,username,userid,nntpfrom,ipaddress,i susenetpost) VALUES ('What do
you think? I want to know!!!',0,,998965144,994399103,'This message posted with t
rial version of Express News Poster\n__________________________________________ _
__________________\n\nWant to voice your opinion or belief? Visit my new site Ca
lled "Alternatives To Popular Beliefs"\n(www.jrbjr.freeservers.com) I have a chatroom, messageboard and poll. I a
m looking for new topics,\nso please send me ideas for topics you would like to
see on my site.','1','<3sc17.560287$ho6.36488278@news5.aus1. giganews.com>','0','
Jrbjr',0,'&quot;jrbjr&quot; &lt;jrbjr@digitalexp.com&gt;',0,1)

DBD::mysql::db do failed: You have an error in your SQL syntax near '998965144,9
94399103,'This message posted with trial version of Express News Post' at line 1
at newnews.pl line 741, <SOCK1> line 2409.
============

Thanks for any advice,

I've forked out for a paid usenet feed so it'll be cool if I can get this hack to fit around it as well. Its a darn site better than the usenet feed I get with my paid ISP.


Cheers

Dibble

[fastforward]

Originally posted by Dibble
So, here is most of the error message.
Query failed:
INSERT INTO post (title,allowsmilie,threadid,dateline,nntpdateline, pagetext,visi
ble,msgid,ord,username,userid,nntpfrom,ipaddress,i susenetpost) VALUES ('What do you think? I want to know!!!',0,,998965144,994399103,'This ... etc, etc...

As I thought. The threadid (third value in the insert clause) is null. You need to upgrade your Perl DBI and MySQL modules.

Argh.

Sounds serious.

Please post rough details, as I will have to ask my hosting company to do this for me.
(Unless it is very easy)

Cheers

Dibble.

[DarkReaper]

Originally posted by DarkReaper
A small bug:

In new reply, at the very top I get "8/10/08" before any of the header loads. I've figure out that when there's stuff way up there, its usually because a variable is being called that has no value. I find this strange though, as the only change I have made to newreply.php is the single code change for the usenet hack, and the template for it is still the same.

Any ideas?

...

Need help

[fastforward]

Originally posted by DarkReaper


...

Need help

No idea. If I can reproduce it I'll let you know.

[JCDR]

Originally posted by JCDR
Sorry FF I didn't explain fully, the message was posted but the subject of the message was not so all that was posted to the newsgroup was a blank message but the subject was there.

Anyone any idea why the message gets posted to the newsgroup but there is no 'message' just the heading??

I can import news ok now, but I cant seem to export locally sent messages to usenet.

============
bash$ perl newnews.pl


Connecting to news-central.giganews.com:119... Connected
Sending authentication info... Authenticated and logged in

Pulling alt.comp.periphs.cdr.mitsumi... No new messages.
Clean disconnection from news-central.giganews.com:119

Expiring usenet articles older than 150 days...
-> alt.comp.periphs.cdr.mitsumi... OK
Expire completed.
=================

This doesnt seem to be posting any back to usenet.
Anyone have any pointers about where I should look to fix this?

FYI - my board is at www.mitsumicdr.com/forums

Cheers,

Dibble.

[DarkReaper]

Originally posted by fastforward

No idea. If I can reproduce it I'll let you know.

ROFL. Flame me, kick me, torture me, I deserve it. Before the <?php... in newthread.php there was...guess what! 8/10/08...how the hell did that get there and what is it? lol!