Depending on your ISP, you might be able to use your regular username and password that you use to log in to teh internet. You may need to ask your ISP if there is a way for you to log in to the server from an external site.

In the nntp_groups table, there is a column for the username and one for the password.

I just installed the hack, and everything seems to work except for proper branching of posts when they appear in the newsgroup.

This is what happened: I started a new thread, and then posted a reply. Then I replied to that reply, but instead of continuing the branch, it appeared as a reply to the original post. When it appears this way on the newsgroup, it could make reading the thread difficult.

vB is not a threaded forum software, but apparently in version 3 of vB, this will be supported.

However, in a future version of this hack, I may try to find out which post it is a direct reply to by looking at the quotes in the post.

Fair enough. Until then, I'll use this hack for reading instead of posting. And thanks for the quick reply!

Database error in vBulletin 2.2.2:

Invalid SQL: UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1, lastpost='1014743904',lastpost er='John Andrews' WHERE forumid IN ()
mysql error: You have an error in your SQL syntax near ')' at line 1

What is causing this?

Thumbs up to you Gilby on an excellent job! I installed it a few days ago and everything is working great...except for a few minor internal issues! I tried the other usenet hack, but it seemed to be way to slow (don't know why). I only retrieve one newsgroup (rec.games.pinball) for my site right now, but the initial 4,200 messages came through in about 2 minutes! Each update (every 4-6 hours) takes less than 20 seconds! My updates are spread out that long because I can't get the crontab working for some reason. No biggie... I'll figure it out!

Here is what I am running:
- vBulletin 2.2.0
- vBPortal 3.0pr7
- Mammothnews.net server

I have been a member of Mammothnews.net for about 2 years now, and for only $9.95/mo, I get EVERYTHING! I was tired of incomplete binary multi-threads (especially when downloading MAME games)!

Anyway, here is a list of things I'd like to see in your upcoming versions (all relate to vBulletin and all were able in other usenet hack):
- As mentioned a few posts above, 'isusenetthread' as a table field would be very helpful so that usenet posts AND threads could not be counted on the forum homepage.
- Ability to not show new usenet posts when 'Get New Posts' is clicked.

Other than that, everyone loves being able to access rec.games.pinball from my site now! It is the only means for some to access the newsgroup at work (on their lunch hour of course :) ). Keep up the great work!

Hey Gilby
Thanks for creating this hack, I have been waiting for this for a long long time.
I tried going to the gateway.php url on my server and I got this error.

Database error in vBulletin 2.2.2:

Invalid SQL: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.paget ext,post.showsignature,post.ipaddress,thread.title ,post.threadid,thread.forumid, thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=1)
mysql error: Unknown column 'thread.prefix' in 'field list'

mysql error number: 1054

Any idea on what I need to fix.
Thanks everybody

Did you run the SQL? You need to run it for this hack to work as it adds columns to some tables, like the prefix column in the thread table, and it adds new tables.

Thanks for the reply Gilby
I did run them, I had fastforwards hack before so I get this error when I run nntp.sql
SQL-query :

CREATE TABLE nntp_groups (
newsgroup varchar(200) NOT NULL default '',
forum varchar(32) NOT NULL default '0',
prefix varchar(255) NOT NULL default '',
lastmsg int(11) NOT NULL default '0',
server varchar(64) default NULL,
username varchar(32) default NULL,
password varchar(32) default NULL,
enabled int(11) NOT NULL default '1',
PRIMARY KEY (newsgroup),
KEY forum (forum)
) TYPE=ISAM PACK_KEYS=1

MySQL said:

Table 'nntp_groups' already exists

or this error when I run upgrade.sql

Error
SQL-query :

CREATE TABLE nntp_groups (
newsgroup varchar(200) NOT NULL default '',
forum varchar(32) NOT NULL default '0',
prefix varchar(255) NOT NULL default '',
lastmsg int(11) NOT NULL default '0',
server varchar(64) default NULL,
username varchar(32) default NULL,
password varchar(32) default NULL,
enabled int(11) NOT NULL default '1',
PRIMARY KEY (newsgroup),
KEY forum (forum)
) TYPE=ISAM PACK_KEYS=1

MySQL said:

Table 'nntp_groups' already exists

Would it be easier to just delete all the old tables and re-run the nntp.sql, I just did not know which ones I need to delete.
Thanks

Delete the nntp_* tables and rerun the upgrade.sql script. I guessing that the tables have duplicates in them since you've run them a few times. If after doing that and it doesn't work, then run the few lines at the bottom of the sql file separately, one line at a time.