Do you know of any free ones?

No, unfortunately I don't. Though I'm sure that if you search Google for "free NNTP usenet" you'll find some. Here's one I found a few days ago: http://news.individual.net

They're free. I registered with them to use as a backup news server. They need to manually set-up your account, I registered a few days ago and haven't heard back from them yet.

anyway of making it use the quote system when they are qutoing in the newserver? For example it does this

>Lets look at what the
>word of God has to say. This is going to be a series of posts but
>today lets start with first Corinthians.

and i want it to do something like this

In the feature release, I intend to use the traditional Usenet way of quoting, which is ">" etc. It will be much easier to reply a post without insert all the BB codes for each quote tags.

It is technically possible to convert ">"s into Quotes, but people do use other type of prefix for quotes on Usenet. ...and also, you may end up with too many level of quotes if the posts contain ">>>>>>>>".

This setting will not affect the functionality. The reason I added no-mx is to avoid your email servers getting hit with all the spam attempts.

Your problem is probably caused by the server not letting you to post.

It is perhaps easier to educate the users to identify them by looking at the user name, to see if it is clickable.

If the script failed on you in the past. You may need to reset the counter using the vB adminCP.

I got my webhost to open port 119 for outgoing but my posts still aren't propagating to usenet. I logged in to my host via telnet and went to news.giganews.com on port 119. I was able to read posts *and* submit posts to usenet without any problems. Doesn't that mean that port 119 is open for outgoing traffic and I should be able to post from my forum???

I would like to try something else. Could I connect to giganews.com from another port, such as port 80 and post and read messages? if I wanted to do that, where would I find the 119 in the script and change it? I checked nntp.php and gateway.php and saw one instance of port 119 in each, would that be all that is required to connect via port 80 instead of 119?

Awesome script. I am setting it up to reply to a mailing list, is it possible to have the script always email out with the same email address?

Example: forumuser <permuser@domain.com>

forumuser will change but the email will not.

Thanks :)

Runned .../gateway.php?debug=1 on 2.2.1 with a fresh install 3.0.3.

I can import but none of my posts are being submitted to usenet. I got the following database error. Setting: lastpostid: 0 before running.

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE nntp_settings
SET value =
WHERE varname = 'last_postid'
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 'WHERE varname = 'last_postid'' at line 3

mysql error number: 1064

Date: Friday 22nd of October 2004 12:15:08 AM
Script: http://www.xxxxxxxx/gateway.php?debug=1
Referer:
Username: Unregistered
IP Address: 6xxxxxxxxxx

Thank you for your time.

Idem on msnews.microsoft.com (public)

Posts imported partially, no outgoing to usenet.

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE nntp_settings
SET value =
WHERE varname = 'last_postid'
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 'WHERE varname = 'last_postid'' at line 3

mysql error number: 1064

Date: Friday 22nd of October 2004 03:57:22 AM
Script: http://www.xxxx.org/xxxx/gateway.php?debug=1
Referer:
Username: Unregistered
IP Address: xxxxxx

My settings (temporaly):

Organization organization My Forums
User Agent useragent vBulletin USENET gateway
View profile URL profileurl http://forums.yourdomain.com.au/member.php?userid=
View thread URL threadurl http://forums.yourdomain.com.au/showthread.php?t=
Email address domain email no-mx.forums.yourdomain.com.au
Make TinyURL at Length tinyurl 70
View attachment URL attachmenturl http://forums.yourdomain.com.au/atta...?attachmentid=
Honour No-Archive honor_no-archive 0
Is Gateway Running is_running 0
Last Max postid last_postid 0
Last Time Run last_run 1098431787
Send no signature nosignature 0
Send no footer nofooter 0
No Organization Check organization_check 1
Use Post Time use_post_time 0
Skip attachments no_attach 1
Pause Between messages pause_seconds 0
Send message to USENET send_message 1
Default Footer default_footer
Strip Footer strip_footer
Find Thread by Subject thread_by_subject 0
Global Killfile killfile_setting


NNTP NG settings (see screenshot)

Thanks for your time.

Have you modified the script by any chance?

This error is not caused by settings. It is possible you have a corrupted script. So upload it again.

Post the debug message.

The debug message doesn't give any errors. It just shows headers for posts being imported and makes no mention of errors or outgoing threads.

Maybe I need to find a new host.

When I use reply or quote on my forum it threads correctly but when I run the script and it uploads to usenet my posts never get placed in the thread but instead show up as an individual posts - am I missing a setting somewhere? Other then that the script is working flawlessly now.

ok, I'll upload it again.

Is it possible to run gateway in sub-forums i.e. forum/forumhttp/forumnntp ?

Uploaded script again (from vbulletin.org), installed on a fresh vb 3.0.3.

Same mysql error:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE nntp_settings
SET value =
WHERE varname = 'last_postid'
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 'WHERE varname = 'last_postid'' at line 3

mysql error number: 1064

Date: Saturday 23rd of October 2004 03:03:04 AM
Script: http://www.xxxxxxx/forumtest/gateway.php?debug=1
Referer:
Username: Unregistered
IP Address: xxxxx


Any idea ?

Just got this run up for ingoing and outgoing data. The cron job works fine.

But debug=1 give me the same mysql error. Also, I have a double post issue but I'm going to test your solution found in thread.

Is it possible to run gateway in sub-forums i.e. forum/forumhttp/forumnntp ?

Trying to resolve the last two issues and I'll click install.

Before to find a new host, it may be a good idea to manually go to the URL of your gateway.php and run it after posting to usenet just to check outgoing.

Just my 2 cents.

does the current version 2.2.1 have AdminCP functionality?

are there any news servers i can use which connect to uk.sport.football which will enable my users to post on it?

lierduh,

Small question here. I have moderation turned on in a forum that USENET posts are going to but they are going straight to the forum instead of the mod queue. This might be a long stretch but is it possible to have all usenet posts go into the mod queue?

Thanks again for all your work,

-Jason

According to the error messsage, the problem is "SET value = ", it is empty instead of a number. The number is fetched through:

"SELECT MAX(postid) as postid FROM post"

This is a very standard query and should work. If you can run MySQL query either through shell or phpmyadmin etc, try out that query and see what error do you get. By the way, what version of MySQL do you run?

Sorry, can't help without the debug message. You know, if there is embarrassing groups you do not want to show to the public, you can alway edit that out.;) (only joking)

Should be ok, but you will need to modify the scripts due to the relative directory locations.

Run query but no mysql error. Got: Showing rows 0 - 0 (1 total, Query took 0.0002 sec)
SQL-query:
SELECT MAX( postid ) AS postid
FROM post


MySQL version 4.0.20-standard

Run script on two differents hosts and fresh install with two differents news servers (public and paid). Got same mysql error. I just noticed that Odoin got the same error:

https://vborg.vbsupport.ru/showpost....&postcount=505
https://vborg.vbsupport.ru/showthrea...022#post550022

I have the same problem. Forum pulls the posts made to it back into the topic so there is double posts..

{I don't find if ($message['user-agent'] == $settings['useragent'] AND
$message['organization'] == $settings['organization']) {

Where is it ?

This is referring to an older version. The new version has this function built into AdminCP.

Find: SET value = {$get_max_postid['postid']}
change it to

SET value = $get_max_postid[postid]

and see if you still get the error.

I've had this hack running since it was released. Haven't had one problem. It even brings more traffic to the site and I have users signing up to use the gateway only. Many people don't understand how to use a newsreader or are intimidated by one and this hack makes it easy for them.

Just wanted to say thank you for a great hack.

;) Don't mean to sound too dumb... But How exactly do I upgrade? there are no instructions for it in the readme file :P

You rock! Thanks for all the hard work!!

Absolutly - that?s a fact ! Where can I sign this ?

lierduh,
many thanks for the update. One man, one word - good to see you made it !
It?s all working as it should and the eMails now have the real sender eMail-adress in the header. Simply great !

But one thing I?ve got to mention.. - everything I post in the forums now becomes imported to the newsgroups twice. First as a new posting and in the same moment as a reply to it. Here?s the debug-msg: Someone else with that problem out there ? I installed the hack as-it-is out of the box without any changes.

In the NNTP settings in your admin control panel. Check out the option for "organization check". See if that changing your values fixes your issues. It did for me...

You got me wrong, organic.
The option "organization check" is already set. The problem is, that if I post a new thread in the forums, gateway.php is sending them to the newsgroups and creates not only the single post I?ve written before - it generates a second one too with the same message-ID.
When I take a closer look at these two postings with a newsreader, they appear as two different posts. One as thread starter (i.e. with msg-no. xxxxx1), one as a reply to it (with msg-no. xxxxx2).

In my forums it?s still a single post (and only the "organization check" prevents the re-import to the forums) - but not in the newsgroups. There you?ll find 2 postings. One as thread starter, the other one as a reply to it (marked with the prefix "Re:" ).
Haven?t had this problem before the update and changed non of the new updated files - and I have no clue, what?s going on...

Can someone puhleez tell me - What exactly do I have to do to upgrade?

After uploading all the files, you must go to the AdminCP and open the NNTP Gateway Newsgroups page once to complete the upgrade.

Hi Lierduh, i still have problems posting messages to newsgroups from my forum :( but anyway i have given up debugging the same now..
now since the new version has some enhancements in admincp logging. i followed your update as mentioned here:
I noted that degugging messages are only inserted when the task is ran manually else it just adds up entries in admincp like:

8632 Gateway Messages Import 01:45, 26th Oct 2004 Ran NNTP Gateway

Now i ran the script twice manaully, after a user has made 2 new threads in the nntp forums:

Check the message in red above, now this messages are nowhere on those newsgroups, i am confused and need serious help..

Regards,

San-Deep, may be the newsfeed & newsspread isn?t that fast that they show up imediatly. Give them some time.

But - I don?t know if you noticed that by now: as far I can see, you`re running into the the same problem that I have. I had a look into your forums where it is only one single post - not two of them like your gateway.php is posting them to the newsgroups. :ermm:


Btw, what means Continue posting - terminate with period240 ?
I?ve never seen this before in relation to this Add-On.

Those messages were sent from your forums. That indicates the posting was successful.

We might be dealing with the same issue but two problems here. The posts are removed from the queue once they are posted. In your case, the script might not realise the message was sent and tried to send it again while in fact the message was already sent. If anything, the problem should exist before the upgrade.

I think it is caused by Microsoft news server. Where it chucks out an 340 before taking the message.

I will check this out and fix.