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

[fastforward]

Tamarians suggestion isn't too bad actually. It will still only be one version. It will just be up to the user how many of the optional code changes they wany to make to integrate it with vB. It will make the newnews.pl a bit more complicated due to the additional if/elses etc but it shouldn't be a big deal. I still intend to drop the 'import user' function.

Does that sound like a resonable solution?.

[tamarian]

Originally posted by fastforward
Tamarians suggestion isn't too bad actually. It will still only be one version. It will just be up to the user how many of the optional code changes they wany to make to integrate it with vB. It will make the newnews.pl a bit more complicated due to the additional if/elses etc but it shouldn't be a big deal. I still intend to drop the 'import user' function.

Does that sound like a resonable solution?.

VERY much so!

Thanks

[Mark Hewitt]

More than I ever hoped for

[Mark Hewitt]

Theres only I few things that I would need in the next version before I can implement it on my board.

Fix the blank name on posts bug
Option to show date as when posted, rather than imported
A way to exclude usenet posts from the total post count. (and from pretty much everything else as well, but the post count is most important).

Cheers

[fastforward]

Originally posted by Mark Hewitt
Theres only I few things that I would need in the next version before I can implement it on my board.

Fix the blank name on posts bug
Option to show date as when posted, rather than imported
A way to exclude usenet posts from the total post count. (and from pretty much everything else as well, but the post count is most important).

Should be all done by tonight.

[fastforward]

This is the first release of the new style usenet gateway that works without any code edits but allows you to optionally integrate it more tightly into vB by making code edits. You can make as many or as few code edits as you like. The script will still work.

This release details enough edits to bring back the functionality that was stripped out in the last release. More integration/options will be added as and when people request them. Two of my next features will be the ability to download from the binary groups and provide a link to the file from the description usually found in the '01' section of the usenet article and an option to recieve email from usenet via the PM system.

Here's what this one can do:

Without code changes:

• 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 and italicized posts
• 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)
• flexible spam control and replacement variable options for both incoming and outgoing messages
• configurable auto-purge option
• global option for users to show their email address if user has selected that his/her email be displayed normally
• global option to enable/disable user signatures on outgoing posts.
• referencing usenet post count in templates (total posts will also include usenet posts)
• optional time source for usenet posts (time entered into forum vs time user posted to usenet)
• option to turn off indexing for usenet posts

With replacement variables and/or template changes:

• user selectable email address in their outgoing usenet posts (may be different than normal one in profile)
• suppression of unnecessary info in usenet posts, ie location, post count etc.
• configurable indented quotes in incoming usenet posts

With code changes:

• suppression of usenet post count from totals in templates
• auto refresh of global usenet variables to ensure post counts etc are always up to date
• optional suppression of usenet post count from totals in stats
• better ordering and sequencing of usenet posts when using the NNTP posting date as time source
• the 'last active' thread hack a la UBB.

Download the latest version

Once again it's late and I'm tired, so treat this release with care. Let me know of any bugs asap and I can release a true 'release version' to coincide with the vB final. You'll probably notice I've changed the version number to date. With the frequency of updates this makes more sense and is easier to track... maybe

I also intend to move this hack and all discussion over to vbdev.org at the next release.

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

[tamarian]

As always, you rock, fastforward

vbdev.org? Did you mean:

http://www.vbulletin.org

Search, and view new posts disabling? I personally hard code it, since I'm only interested in one usnet group.

I love it, and will install this weekend and report bugs (if any)

[fastforward]

Originally posted by tamarian
vbdev.org? Did you mean:

http://www.vbulletin.org

yeah... whatever I must have got confused with ubbdev

Search, and view new posts disabling? I personally hard code it, since I'm only interested in one usnet group.

ooops. I forgot about that one. I'll add that tomorrow.

[Mark Hewitt]

I can run newnews.pl and it appears to run through correctly. However after it does I get these errors on every page of my forums

Parse error: parse error in ./global.php(55) : eval()'d code on line 63

Warning: Cannot add header information - headers already sent by (output started at ./global.php(55) : eval()'d code:63) in ./functions.php on line 1172

Warning: Cannot add header information - headers already sent by (output started at ./global.php(55) : eval()'d code:63) in ./global.php on line 131

When I load my forums home page it gives the above errors and only displays the categories and no forums. It also gives a database error when trying to run showthread.

Database error in vBulletin: Invalid SQL: 
SELECT  IF(votenum>=,votenum,0) AS votenum,
                 IF(votenum>= AND votenum > 0,votetotal/votenum,0) AS voteavg, icon.title as icontitle,icon.iconpath,
         thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postuserid,
         lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attach
         FROM thread
         LEFT JOIN icon ON (icon.iconid = thread.iconid)
         
         WHERE thread.threadid IN (0)
         ORDER BY sticky DESC, lastpost DESC
         
mysql error: You have an error in your SQL syntax near 'votenum,0) AS votenum,
                 IF(votenum>= AND votenum > 0,votetotal/v' at line 2
mysql error number: 1064
Date: Wednesday 02nd of May 2001 06:35:06 AM
Script: /forums/forumdisplay.php?s=&forumid=3
Referer: http://www.motorsportforum.com/forum...?s=&forumid=33

However if I go to /admin/options.php and resubmit the options everything goes back to normal

[fastforward]

What code changes did you make? Did you go through and re-check the tables to make sure all columns and indexes are as specified in the new versions. Alao, did you make sure you removed any existing code changes you may have made?