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.

lierduh · #**342** 07-13-2004, 11:59 PM

Quote:

Originally Posted by john_rsd

Would it be better if I resend the email directly to you with attachment?
The file is only very small.

If it helps the file was packed with winrar, but I use .zip extension as more people understand zip (can be opened in WinXp/zip compatible).

Please post to the forum instead of emailing me. I only need the header, the beginning and the ending of the attachment. It does not matter what file extension you have. As long as they are correctly MIME coded, it should be decoded properly. What email program do you use?

Which version of the script are you using? did you hack any part of the script before you had the attachment inserted as normal post?

john_rsd · #**343** 07-14-2004, 06:41 PM

Quote:

Originally Posted by lierduh

Please post to the forum instead of emailing me. I only need the header, the beginning and the ending of the attachment. It does not matter what file extension you have. As long as they are correctly MIME coded, it should be decoded properly. What email program do you use?

Which version of the script are you using? did you hack any part of the script before you had the attachment inserted as normal post?

OK, Ill see if I can do that shortly.

The Email was sent from Outlook 2003 (11.5608.5703)

I used the last version of the script that you posted which you advised.

I did not hack any part of the script.

The forum has posting of attachments disabled.

Ill go off and send the email to myself now to get the headers :nervous:

john_rsd · #**344** 07-14-2004, 06:47 PM

Message headers as received

Quote:

Return-Path: <john@rsdtv.com>
Delivered-To: rsdtvcom-john@rsdtv.com
Received: (qmail 72330 invoked from network); 14 Jul 2004 19:43:10 -0000
Received: from unknown (HELO johnhomepc) (81.154.91.66)
by host109.ipowerweb.com with SMTP; 14 Jul 2004 19:43:10 -0000
Reply-To: <john@rsdtv.com>
From: "John A. Ross [RSDTV]" <john@rsdtv.com>
To: <john@rsdtv.com>
Subject: File for PP data
Date: Wed, 14 Jul 2004 20:43:09 +0100
Organization:
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_NextPart_000_000F_01C469E3.2DABC120"
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Thread-Index: AcRhY0z/k+oCtlpYSxG0N5CkzFFbWA==

The script that is running is this one

https://vborg.vbsupport.ru/showpost....&postcount=297

john_rsd · #**345** 07-14-2004, 10:28 PM

Dear lierduh

I am having some more troubles, i guess it might be associated with the mime decoding and the handling of line wraps. Possibly you have some ideas already because of the attachment issue.

Example

Message at my inbox

Quote:

> Thank St?phane, a very good article. I'm getting there (an all
> nighter on an urgent job helped...), DXP2004 is getting better by the
> minute!
>
> Regards
>

Message in forum

Quote:

>=20
>=20
> Thank St=E9phane, a very good article. I'm getting there (an=20
> all nighter
> on an urgent job helped...), DXP2004 is getting better by the minute!
>=20
> Regards
>=20

Headers

Quote:

Return-Path: <bounce-dxp-xxxx@forums.altium.com>
Delivered-To: rsdtvcom-john@rsdtv.com
Received: (qmail 25816 invoked from network); 14 Jul 2004 23:04:10 -0000
Received: from unknown (HELO 203.10.94.132) (203.213.65.162)
by host109.ipowerweb.com with SMTP; 14 Jul 2004 23:04:10 -0000
From: "xxxx xxxx" <xxxx.xxxx@xxxxx.xxx>
To: "DXP Technical Forum" <dxp@forums.altium.com>
Subject: Re: [dxp] Editing component pads and holes
Date: Thu, 15 Jul 2004 11:06:52 +1200
Message-ID: <LYRIS-3338-48461-2004.07.15-08.55.49--john#rsdtv.com@forums.altium.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.2616
In-Reply-To: <LYRIS-4669-48457-2004.07.15-08.48.41--xxxxx.xxxx#xxxx.xxx@forums.altium.com>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Importance: Normal
List-Unsubscribe: <mailto:leave-dxp-xxxx@forums.altium.com>
Reply-To: "DXP Technical Forum" <dxp@forums.altium.com>

This is now a regular occurance with the test forums. Every other post looks like this.

The isue seems to be LF/CR and also bad handling of charset because of the missing "?"

Do you want me to replace the last version of gateway.php you supplied with the original (from first post) and see if the issue is still present?

Any help appreciated

john_rsd · #**346** 07-14-2004, 10:58 PM

This is very strange now

I just did another update

What was sent

Quote:

Subject : Re: [PEDA] SOT-23 pinout

Pins 2&3 reversed???

This is my default:

3
1 2

I think I've seen 1&2 reversed occasionally.

The only time I use something else is with SOT-23 diode & LEDs, where I use A&K & have an appropriate modified footprint.

----- Original Message -----
From: xxxxxxxxxx
To: xxxxxxxxxx Sent: Tuesday, July 13, 2004 11:05 PM
Subject: [PEDA] SOT-23 pinout

When you organise your footprints, what pinout do you use for SOT-23's?

Do you organise the pins...
-like shown in the attachment?
-or with pins 2&3 reversed?

The bigger question really is: Where do you derive your pin numbering
guidance from?

I find that some datasheets just show the pin names against the actual
pins (& cutout the middleman of *numbers*) thus avoiding the issue
altogether. This doesn't help those of us who want to be able to use a
common footprint across multiple designs.

One answer is "define your own company standard", but if I chose
against an industry standard, that'd be a bit silly wouldn't it.

Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com

What i got was this a subject and no message body

Quote:

Subject : Re: [PEDA] SOT-23 pinout

Quote:

Headers

Return-Path: <error@techservinc.com>
Delivered-To: rsdtvcom-john@rsdtv.com
Received: (qmail 63335 invoked from network); 14 Jul 2004 23:43:59 -0000
Received: from unknown (HELO mail.techservinc.com) (67.115.134.89)
by host109.ipowerweb.com with SMTP; 14 Jul 2004 23:43:59 -0000
Received: from techservinc.com ([192.168.0.1])
by "DOLIST Server Expert 3.4 B2157" <forums@techservinc.com>
with SMTP id <D0000877213.OUT>; Wed, 14 Jul 2004 16:41:54 -0700
Envelope-to: proteledaforum@techservinc.com
Delivery-date: Wed, 14 Jul 2004 18:41:19 -0500
Received: from [209.226.175.10] (helo=tomts4-srv.bellnexxia.net)
by esc18.midphase.com with esmtp (Exim 4.34)
id 1BktNH-0004r8-Kp
for proteledaforum@techservinc.com; Wed, 14 Jul 2004 18:41:19 -0500
Received: from VergentBertha ([67.71.75.76]) by tomts4-srv.bellnexxia.net
(InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP
id <20040714234114.BVMY14414.tomts4-srv.bellnexxia.net@VergentBertha>
for <proteledaforum@techservinc.com>;
Wed, 14 Jul 2004 19:41:14 -0400
Message-ID: <001201c469fc$07338af0$6401a8c0@VergentBertha>
From: "Brian Guralnick" <xxxxxxxxx@xxxxxxx.xx>
To: "Protel EDA Forum" <proteledaforum@techservinc.com>
References: <20040714030517.54866.qmail@web50902.mail.yahoo.co m>
Date: Wed, 14 Jul 2004 19:41:03 -0400
Organization: Vergent Technology Inc.
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_000F_01C469DA.7FB1EB10"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
List-Server: DOLIST Server Expert 3.4 B2157
List-Help: <mailto:forums@techservinc.com?body=help%20protele daforum>
List-Unsubscribe: <mailto:forums@techservinc.com?body=leave%20protel edaforum>
List-Subscribe: <mailto:forums@techservinc.com?body=join%20protele daforum>
List-Post: <mailto

roteledaforum@techservinc.com>
List-Owner: <mailto:forumadministrator@techservinc.com>
List-Archive: <mailto:forums@techservinc.com?body=search%20prote ledaforum%20date%202004-07-14>
List-Info: Forum for discussion of Protel EDA, related software, & Design
X-Tracking: #proteledaforum@techservinc.com#
X-DOLIST-Unsubscribe: To leave, send 'leave proteledaforum' to 'forums@techservinc.com'
Subject: Re: [PEDA] SOT-23 pinout
Resent-From: proteledaforum@techservinc.com
Errors-To: error@techservinc.com
Return-Path: error@techservinc.com
Reply-To: "Protel EDA Forum" <proteledaforum@techservinc.com>
X-DOListmember: #john@rsdtv.com#

cyc · #**347** 07-19-2004, 01:16 AM

Hi

Great hack, nice and easy to setup!

I have one problem though, in several groups I get an error on the odd message that looks like this:

PHP Code:


			
Invalid SQL: SELECT post.postid FROM thread AS thread, post AS post

                                    WHERE thread.threadid = post.threadid AND

                                    (post.msgid = '&lt;For-Gilly's-benefit-797E25.00512909042004@news.usfamily.net&gt;') AND

                                    thread.forumid = 170    

                                    ORDER BY post.dateline DESC LIMIT 1

mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 's-benefit-797E25.00512909042004@news.usfamily.net&gt;') AND

     



mysql error number: 1064



Date: Monday 19th of July 2004 12:12:51 PM

I've tried using the filter thats posted a few pages back but it doesnt seem to help, does anyone have any ideas?

cheers

lierduh · #**348** 07-19-2004, 01:29 AM

Quote:

Originally Posted by cyc

Hi

Great hack, nice and easy to setup!

I have one problem though, in several groups I get an error on the odd message that looks like this:

PHP Code:


			
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 's-benefit-797E25.00512909042004@news.usfamily.net&gt;') AND

I've tried using the filter thats posted a few pages back but it doesnt seem to help, does anyone have any ideas?

cheers

The problem is the message-id of the message you are trying to import does not comply to the standard. It contains a quote in the message-id. I have a fix for the same problem, if you go back, you should be able to find my post.

Or otherwise, just up the lastmsg and skip this message.

lierduh · #**349** 07-19-2004, 01:40 AM

Quote:

Originally Posted by john_rsd

Dear lierduh
This is now a regular occurance with the test forums. Every other post looks like this.

The isue seems to be LF/CR and also bad handling of charset because of the missing "?"

Do you want me to replace the last version of gateway.php you supplied with the original (from first post) and see if the issue is still present?

Any help appreciated

The >=20 is to do with Characterset/language. Many people suffer this problem, it can almost all go back to Outlook Express generated messages. According to the header, the message should be a pure text message. I myself pretty confused about the problem. Even vB team mentioned this problem makes their support harder.

What language do the senders use usually?

In the next version (I need a good block of time like a free weekend to work on it), I will have an option to disable the importing of attachments.

cyc · #**350** 07-19-2004, 02:11 AM

Quote:

Originally Posted by lierduh

The problem is the message-id of the message you are trying to import does not comply to the standard. It contains a quote in the message-id. I have a fix for the same problem, if you go back, you should be able to find my post.

Or otherwise, just up the lastmsg and skip this message.

Thanks mate!

trackpads · #**351** 07-19-2004, 04:51 PM

Is there a way to send the signature and a forum tagline (with the thread links) to the usenet but not the profile information? I REALLY dont like my profile or my users going directly to the usenet.

Thanks again for all the help!

-Jason

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.10059 seconds Memory Usage 2,345KB Queries Executed 25 (?)
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 (2)bbcode_php (12)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_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!