vb.org Archive - NNTP Gateway for Usenet ( Newsgroups ), Mailing Lists

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - NNTP Gateway for Usenet ( Newsgroups ), Mailing Lists (https://vborg.vbsupport.ru/showthread.php?t=65152)

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?

Quote:

Originally Posted by lierduh

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:

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

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

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:proteledaforum@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#

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

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.

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.

Quote:

Originally Posted by lierduh

Thanks mate!

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
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (12)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01532 seconds Memory Usage 1,807KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (12)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: