Usenet gateway

THIS THREAD IS CLOSED!
Posts in here will NOT be answered

This hack has undergone many major changes since this thread was started. Consequently, most of the posts have become dated and of little use. To coincide with the latest major release (20010712), a new one has been started.

See this thread for the latest version and discussion

[Dioxin]

for your "fast" answer

when is the next release expected?

[fastforward]

Originally posted by Dioxin
for your "fast" answer

when is the next release expected?

Definately this weekend... I promise

I have it all up and running at dbforums.com, I just need to document it all. There's been a few changes in the tables and code edits required.

To get the most out of this next release, you need to create a seperate template set more suited to a usenet article layout. I decided it was silly trying to squeeze a usenet article into the forum layout when I should be changing the forum layout to accomodate the usenet article.

Another change (related to your seq issue) is that both local timestamp and nntp timestamps are stored in the table. The seq column has been removed. You now just order on dateline (default) or the nntpdateline.

[fastforward]

And here's another one...

This is release 20010519 for vB2.0 RC3.

Quite a lot of changes in this one. The biggest change is probably the ability to reply to individual usenet posts at any level of the thread and have ot thread correctly on usenet. (The quote button is used for this.) For this to work you MUST make a small code edit to newreply.php AND add a hidden field to the newreply template.

To get the most out of this you should consider creating a complete set of custom templates for the usenet forums. You can then show the nntpdate but still maintain a logical order by dateline. You can also hide the posts/location etc and display the full nntp From: header just like a real usenet post. See http://dbforums.com to see what I mean.

Changes

1. Added reply to particular post capability to ensure outgoing posts are threaded correctly when they reach usenet.
2. Changed indexing routine to support the new vB search thread title option.
3. Changed method of ordering usenet posts in forums to a more robust method. (Additional column containing nntpdate replaces the seq column)
4. Improved stripping of vB codes from outgoing posts.
5. Added new column containing nntp from line that can be referenced in templates.
6. Added global 'posting enabled' switch to control panel.
7. Improved autopurge function. It's now a lot quicker.

Bug Fixes

1. Fixed problem of lastactivethread not being updated when a post was deleted.
2. Fixed problem with mailing archives threading. Some posts were not being loaded if there were no references.
3. Fixed bug causing quotes not to be indented.
4. Probably some other stuff that I can't remember.

If possible you should do a clean install with this version. If not possible, you should go through the table structures carefully. Let me know if you need clarification on the need of any columns.

With only days before the vB final (hopefully) I want to clear up any bugs asap. If you do find any, make sure they're little ones that can be fixed easily

Download


Note to n3n: I didn't get around to adding the html to newnews.pl. I decided to wait and do it properly with an option to run it from the control panel and automatically set up a cron job etc.

Note to jarvis: I'll see what I can do about getting it to work under windows. It does work under Cygwin though if you can't wait.

[jarvis]

Fast,

You've got an awesome product, and if you are doing dev on a Win32 version, then I will wait. Like I said b4, I am willing to pay for this version as it is exactly what I've been looking for. Right now, I'm using DNews from netwinsite, but if I could incorporate ng's into my existing forums, whoa... (drool) Darn you Unix giys

[Dioxin]

hi fastforward,

i get these message from my telnet:

Query failed:
UPDATE usenet_outgoing SET refs = concat(refs,' ','<3b08a44a$0$304$6e37e724@news.dpn.de>') WHERE inreplyto = 23810

DBD::mysql::db do failed: Unknown column 'inreplyto' in 'where clause' at newnews.pl line 601.

the table usenet_outgoing has no field called 'inreplyto'

please help.. i use the latest version.

btw, your instruction set for the new release is not complete. all the insert statements for the spam- and usenet_replace table are missing.

[fastforward]

Originally posted by Dioxin
hi fastforward,

i get these message from my telnet:

Query failed:
UPDATE usenet_outgoing SET refs = concat(refs,' ','<3b08a44a$0$304$6e37e724@news.dpn.de>') WHERE inreplyto = 23810

DBD::mysql::db do failed: Unknown column 'inreplyto' in 'where clause' at newnews.pl line 601.

the table usenet_outgoing has no field called 'inreplyto'

please help.. i use the latest version.

btw, your instruction set for the new release is not complete. all the insert statements for the spam- and usenet_replace table are missing.

Yeah I just got those errors aswell. I forgot to add the inreplyto columns to the usenet_outgoing and the usenet_outgoing_log table. Outgoing messages will not be sent until I fix it. You can add the columns yourself if you like they should be of type int and unsigned. I can't get a fix out until tomorrow night I'm afraid. I also need to make sure there are no more issues with the release version.

Sorry about that.

[chrispadfield]

Now vb2.0 is out i am really looking forward to this.

I do have one request though, we talked about this before a bit.

Basically, the "first time" a user goes to post a newsgroup message i want a confirmation page to come up explaning exactly what they are doing.

What would be needed here..

i) an extra field in user Y, N for has seen warning sort of thing.

ii) an extra modification to newthread/newreply.php to check for Y/N if it is a newsgroup post. If N then display a new page with warning on it, with the message etc as hidden variables. If they press "accept" or whatever you use then the message is sent and everyone is happy.

i would really like this if it is possible.

[fastforward]

Originally posted by chrispadfield
Basically, the "first time" a user goes to post a newsgroup message i want a confirmation page to come up explaning exactly what they are doing.

The way I have done this on dbforums.com is using templates. Every usenet post has a sidebar where all the vbcode stuff used to be advising them that their post is about to placed in the public domain and to read the faq etc etc...

If you really really really really need it I'll put it on the to do list, but I desperately need to spend some time getting my site updated. My intention was to fix any bugs and leave it alone for a few weeks.

There's still plenty I want to add to the hack in the next big release though, including full mime and binary attachment support.

[fastforward]

This release certifies the hack for vB 2.0

There have been a couple of bugfixes:

1. Added missing columns to usenet_outgoing & usenet_outgoing_log tables
2. Fixed problem with autopurge. Local posts that were made in a usenet forum were being expired too early... much much too early!

Download latest version for vB 2.0

I was going to officially move the hack to vbulletin.org but the discussion bit is broken so it'll have to stay here.

[chrispadfield]

i like how you have done it, update your site i will work on a new tmeplate set, seems a good plan with the new reply feature as well.