The Arcive of Official vBulletin Modifications Site.

NNTP Gateway for Usenet ( Newsgroups ), Mailing Lists · **Released**: 05-14-2004

The latest version: V2.3.2 (31 Oct 2004)

What is it?

This hack provides a gateway from vBulletin forums to the USENET. It allows forum members to read newsgroup messages as well as to send posts to the newsgroups. In a nutshell, it turns vBulletin forums into a basic function news reader.

For an added bonus, this package also supports mailing list archive and forum to mailing list gateway. The software retrieves messages from a pop3 account and import them into the forums threaded. It also allows a forums user to send messages to the mailing list by the forum posting interface.

Why?

The gateway will be appreciated by forum members who do not know how to set up a news reader, or people who do not have port 119 open in their network. A forum interface to read and post news are often considered to be better than a news reader.

The gateway adds more contents to your forums and allows the members to interact with wider audience. It is common to see new users signing up to use this feature.

History

This hack is basically a hacked vB2 NNTP gateway written by Gilby to work with vB3. The original hack can be found here:

https://vborg.vbsupport.ru/showthrea...7&page=1&pp=15

Features

Some of the features and improvement include:

Handles both newsgroup posts and mailing lists.
Handles MIME encoded messages and attachment.
Handles UUEncoded messages.
Two Admin Control Panels for all settings.
Automated installation.
Correct thread implementation. All imported messages and posts sent to newsgroups will be threaded correctly according to References and Message-ID headers.
Optional setting to thread by subject for mailing lists that strip references header.
Supports TABLE_PREFIX.
Imported messages will be searchable just like normal forum posts.
Similar threads are built when the messages are imported if the system setting is on.
Multiple attachments importing.
Save attachment to database or file according to vB setting.
Thumbnail created while importing image files.
Multiple attachment post to newsgroup is also supported.
Selectable X-No-Archive header honouring system.
Light on system resources.
Global Killfile to filter out unwanted messages. Killfiles can have OR and AND effectiveness.
Strip footer by setting for incoming messages. Strips out repeated message footers.
Built options to disable signatures and footers for out going messages.

Future development

AdminCP interfaces. (completed)
Installation/upgrade script. (completed, coded into AdminCP)
Traditional "> " lead posting interface.

What do you need and do not need?

You do not need to edit vB php files if you use two bookmarks
You need to edit one vB php file to insert two lines of code if you want direct click links within AdminCP.
No need to run SQL.

Installation

Basically the AdminCP interfaces take care of installation as well as upgrade in the background. Back up your database first. The scripts can modify your database without alerting you!

Please follow the instructions in the readme.txt file for more details.

Support

Please post your support questions to this thread. Please check the FAQ in the third post within this thread first.

================== UPDATES ======================
Jul 31 2004 (release version 2.2.0)

Provided option of not importing attachments
Provided option of pause between messages
Provided option of not sending messages to USENET
Provided mechanism to skip importing a message if it was crashed on it
Provided "Default Footer" option
Provided strip_footer function for mailing lists
(written originally by KevinM)
Provided Killfile functions with Header/Body/AND/OR settings
Provided ability to thread messages by subject for mailing lists
Provided ability to use a single POP3 account for different mailing lists
(use prefix)
Merged KevinM's attachment routine, save thumbnail to hard drive
as vB3.0.3
Official support to have the script run by Scheduled Tasks
Many bug fixes

Please note, when you manually run the script, you must turn on the debug mode. Otherwise nothing will be displayed on the screen.

To run as debug mode: http://forums.yourdomain.com/gateway.php?debug=1

25 Oct 2004

Provided the option of sending posts using the real email address
Provided the option of sending posts using a fixed email address for
each group.
Posts are now held back if they are in the moderating queue
Scheduled task log is now working
Provided the option of sending the debug messages to the vB3 cron log
Bug fixes

31 Oct 2004

Fixed bugs running the gateway by the vB3 Scheduled Tasks

1 March 2004

Uploaded the new zip file. It contains one or two bug fixes.

Marv · #**392** 08-02-2004, 10:52 PM

Quote:

Originally Posted by lierduh

Looks like you do not have the new files. To confirm, I have just downloaded the file and it indeed has 2.2.0 Version gateway.php included.

Yes, you need to replace all the existing files. All the files have been changed since last version.

you?re so damn right. extracted the zip into the wrong DIR..
thanks for guiding the blind, lierduh.

Rob Eh · #**393** 08-02-2004, 11:31 PM

Quote:

Originally Posted by fonzerelli_79

it seems to be still happening -some posts have content and some dont

is there a way to stop posts with no content being posted?

All of mine since the upgrade are that way. Titles and no content.

Rob Eh · #**394** 08-02-2004, 11:46 PM

I over wrote all of the files in the new zip file again. The overwritten files were all dated the same time as when I did the upgrade. I ran the gateway.php file manually with debug after I back dated the last post # on one of my groups by 10. All of those 10 posts worked fine. I'm going to take it back a few again and wait until it runs from the vB scheduled tasks. I will report my findings.

lierduh · #**395** 08-02-2004, 11:48 PM

Quote:

Originally Posted by Rob Eh

All of mine since the upgrade are that way. Titles and no content.

Well, the only way I can fix things is by knowing more details. What is the post should look like to start with. How about perhaps a link in Google Group.

The debug message is vital too.

Rob Eh · #**396** 08-02-2004, 11:52 PM

From running gateway from the scheduled tasks, all of the posts are coming back as blank.

The new upgrade does not seem to support being run in this fashion.

Suggestions?

Rob Eh · #**397** 08-02-2004, 11:55 PM

Quote:

Originally Posted by lierduh

Well, the only way I can fix things is by knowing more details. What is the post should look like to start with. How about perhaps a link in Google Group.

The debug message is vital too.

Here is one of the threads that I haven't deleted the new blank messages yet. The last three messages in the thread should be the same as the first three.
http://forums.fu2.ca/showthread.php?t=3686

I will run it again with the debug message and post it shortly.

lierduh · #**398** 08-03-2004, 12:04 AM

Quote:

Originally Posted by Rob Eh

From running gateway from the scheduled tasks, all of the posts are coming back as blank.

The new upgrade does not seem to support being run in this fashion.

Suggestions?

Thanks, will investigate.

Rob Eh · #**399** 08-03-2004, 12:05 AM

Here is the debug message from running it manually

PHP Code:


			
Gateway version 2.2.0  2 group(s) gatewayed.



Connecting to server, server says: 200 News.GigaNews.Com

Server responded after user name: 381 more authentication required

Server responded after password: 281 News.GigaNews.Com

Info for alt.sport.air-guns at news-60.giganews.com:

211 2852 16876 19727 alt.sport.air-guns





Connecting to server, server says: 200 News.GigaNews.Com

Server responded after user name: 381 more authentication required

Server responded after password: 281 News.GigaNews.Com

Info for rec.sport.paintball at news-60.giganews.com:

211 34660 523609 558268 rec.sport.paintball



Getting message number 558259: 

'Re: Looking for a guy named Preacher from Cali....' from Kenner Costen, MCSE, MCSA, MCP. Thread found by References.

Getting message number 558260: 

'Re: The Next Reality Show' from Destiny Publications. Thread found by References.

Getting message number 558261: 

'FS: Custom Cocker Package - Cheap!' from Russell Twiss. New thread.

Getting message number 558262: 

'Re: Boomstick' from Space Cadet. Thread found by References.

Getting message number 558263: 

'Re: OT: Patches' from FL PBPress. New thread.

Getting message number 558264: 

'Re: OT: Patches' from ayar-15. Thread found by References.

Getting message number 558265: 

'Viper vs Vector ??' from Graham. New thread.

Getting message number 558266: 

'Re: Viper vs Vector ??' from Insane Ranter. Thread found by References.

Getting message number 558267: 

'Re: Viper vs Vector ??' from Graham. Thread found by References.

Getting message number 558268: 

'Re: Viper vs Vector ??' from Insane Ranter. Thread found by References.

These all posted porperly. It's just when it's ran from the scheduled task. In fact, the job can't be completeing as it is not showing up in the logfile.

I don't have access to crontab.

Marv · #**400** 08-03-2004, 12:06 AM

lierduh,
after upgrading the files I was wondering wyh nothing happend. So I manually run the gateway.php and received this:

Quote:

Invalid SQL-Query:
SELECT post.postid FROM vb3thread AS thread, vb3post AS post
WHERE thread.threadid = post.threadid AND
(post.msgid = '<c0b6mb$h3d$1@newsreader2.net.com>') AND
thread.forumid = 100
ORDER BY post.dateline DESC
mysql error: Lost connection to MySQL server during query

mysql error number: 2013

I?m not very familiar with the sql database. vBulletin has a prefix "vb3" in the database - is that part of the problem ? At least I don?t really understand what this error-msg is trying to tell me... :ermm:

lierduh · #**401** 08-03-2004, 12:52 AM

Quote:

Originally Posted by Rob Eh

Here is the debug message from running it manually
[PHP]Gateway version 2.2.0 2 group(s) gatewayed.

Ok, download the v.2.2.1. This should fix the Scheduled Tasks problem. You only need to replace the gateway.php.

https://vborg.vbsupport.ru/attachment.php?attachmentid=19995

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09586 seconds Memory Usage 2,337KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_php (7)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!