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)

Ah oops. As I queried phpMyadmin, I don't have this field - I got 2,3,8 and 9, where 2 is city and so on. I disabled Signature in NNTP Settings Menu, but no success - I still get

Datenbankfehler in vBulletin 3.0.7:

Code:

Ungueltige SQL-Abfrage: 

                        SELECT email, field1 AS signature, usertitle, customtitle

                        FROM user AS user

                        LEFT JOIN userfield AS userfield

                        ON user.userid = userfield.userid

                        WHERE user.userid = 1

                

mysql error: Unknown column 'field1' in 'field list'



mysql error number: 1054



Datum: 28.02.2005 22:26:20

Skript: http://www.mobilejoe.de/joeforums/gateway.php

Referer: 

Benutzername: joe

IP-Adresse: 217.84.8.114

The signature is stored in usertextfield - "signature" ... As I am not as good in this - any way to change gateway.php to match these tables in VBulletin I'm using? BTW - It's an out of the box VB3.07 - no changes, hacks, whatever... :surprised:

Quote:

Originally Posted by joeMJ

Code:

Ungueltige SQL-Abfrage: 

                        SELECT email, field1 AS signature, usertitle, customtitle

                        FROM user AS user

                        LEFT JOIN userfield AS userfield

                        ON user.userid = userfield.userid

                        WHERE user.userid = 1

                

mysql error: Unknown column 'field1' in 'field list'



mysql error number: 1054



Datum: 28.02.2005 22:26:20

Skript: http://www.mobilejoe.de/joeforums/gateway.php

Referer: 

Benutzername: joe

IP-Adresse: 217.84.8.114

Actually my file has the field name changed already. I can't remember when and why. Anyway, use this attached file instead, and you should be fine.

It works! :D Thank you sooo much !

Could someone get this:

Code:

https://vborg.vbsupport.ru/showthread.php?t=60329

to work with the NNTP mod? I am willing to pay money...

hi there

can someone explain why none of the threads are actually showing on the forumdisply.php page? i see the thread and post counts on the forumhome (index), and if i click the thread name in the "last post" column on forumhome, it takes me to the thread no problem. its just not listing the damn threads on the forumdisply page.

please help. thanks.

you can see what its doing at: www.toyotanation.com/forum/

n/m problem solved.

it was the modified forumdisply.php from the "Warning System" hack

working perfectly.

BTW - news.astraweb.com is awesome!

Is there a way to tie usernames that I pull from yahoo groups or even newsgroups to existing members? I am testing a few feeds out on our test server that has a copy of all users from the live server. Several of our members post on the yahoo, nntp and the forum. I would like to get those members posts from the nntp and yahoo lists tied to their forum name.

I did try the vb built in one, but since the poster is "guest" it is not allowing it.

Any thoughts on this?

When replying to a thread, the 'title' field is left blank. Did I mess up some setting, or is there a way to auto-populate that with 'Re: the-topic-being-discussed'?

Thanks!

I have a noob question but first wanted to say that this is an AWESOME hack. I will be using the email gateway to help in transitioning from YahooGroup to VB.

Anyway, for the following instruction under gateway settings I have to confess to having no clue what it means. My site is ammphicar770.com and I have set up a dedicated mailbox at that domain for exchange of the Yahoogroups message. Just have no clue what I should or should not enter for the following setting ...

This domain is used for the msgid of the outgoing post and also for the email address sent to the newsgroups. In the future, I plan to impliment a time limited email address system so replys can go from email to PM. To avoid spams attempting at your server. Please do not use a resolvable domain.
Email address domain email no-mx.amphicarforum.amphicar770.com

Thanks.

Hi,

I don?t know wether I?m the only one having this problem but I wouldappreciate if someone could give me a hint, where and how I could fixthis.

In my forums all posts appear as they should. That means theusenet-code is getting parsed into vb-code, spaces, blanklines..all topnotch.
My problem is the reversed parsing, means vb-code parsed into usenet-code and the appearing in the usenet.

A forum post which looks like this:

Quote:

This is an example post and in this it has another quoted partlike that:

Quote:

Originally Posted by Marv

Quoted message goes here. If this one has morethen 72 signs it becomes word wrapped as it should..

normal text would go on here and (if long enough) becomes wrapped and parsed in the next line as normal and non-quoted text..

In the usenet post it shows up like this:

Quote:

This is an example post and in this it has another quoted part like that:

In his post Marv mentioned:
> Quoted message goes here. If this one has more then 72 signs
> it becomes word wrapped as it should..normal text would go on here and
(if long enough) becomes wrapped and parsed in the next line as normal and not-quoted text..

instead of

Quote:

This is an example post and in this it has another quoted part like that:

In his post Marv mentioned:
> Quoted message goes here. If this one has more then 72 signs
> it becomes word wrapped as it should..
[blank line]
normal text would go on here and (if long enough) becomes wrapped
and parsed in the next line as normal and not-quoted text..

So, it seems that a seperater is missing somewhere and reading of thoseusenet posts via newsreader really becomes a mess if you have a fewqoutes in it beside long text. I?ve tried to fix that on my own but Icouldn?t find out where I?ld have to insert the </br> .

Could someone do me the favor to have a look into the gateway.php ? May be I was just to blind to see..

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 (3)bbcode_code_printable (5)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.03772 seconds Memory Usage 1,756KB 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 (3)bbcode_code_printable (5)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: