Usenet gateway

THIS THREAD IS CLOSED!
Posts in here will NOT be answered

This hack has undergone many major changes since this thread was started. Consequently, most of the posts have become dated and of little use. To coincide with the latest major release (20010712), a new one has been started.

See this thread for the latest version and discussion

yup they are in there so... as you say bollox lol

at least i know i am not mad now i wonder what it is the problem.. strange really.

OK.. if they are there then the fix should be easy. The way it finds which articles to put in the forum at the moment is by using the following query:

SELECT a.forum, a.msgid, a.dtm, a.subject, a.poster, a.body, a.ord, b.threadid, c.ref FROM usenet_article AS a, thread AS b, usenet_ref AS c, post AS d WHERE a.msgid=c.msgid AND c.ref=b.msgid AND b.forumid=$group->{forumid} AND d.msgid=b.msgid AND ((d.ord + 1 = a.ord) OR (d.ord=a.ord))

This must flawed in some way. I was going to do it by looping through the records but I thought I'd be clever by doing it in one go with this query. I'll look into it and find another way of picking the articles. In the meantime, leave the missing articles where they are. When I give you the fix it should just pick them up and move them to the forum.

One last thing, can you look at the 'ord' and 'refs' column in the usenet_article table for the missing posts. Make sure that something is listed in the 'refs' column and let me know what the 'ord' number is. Then do the same for the 2 messages that in the posts table and check the 'ord' column.

ok for message three from

http://x67.deja.com/viewthread.xp?AN...&back=clarinet

now refs are:

<3tim6tkrqg3r4vm9jhjjmk5jjhq2l0ph5d@4ax.com> <nTUa6.16025$T5.1752524@typhoon.midsouth.rr.com>

so there is something there

and the order is:

2.

this is perhaps weird as article 3 is

Article 1
---> Article 2
--------> Article 3

should it not be order "3" i wonder?


I have sent you acccess to the sql database to webmaster @ yourdomain.com as you turned email of here, i can send it to another email if you would like

2 is correct. The first message is number 0. This indicates the problem definately lies with the query I posted earlier. All the ord column is really is a count of how many references are in the refs column. I'll start fixing it now.

Replace line 162 of newnews.pl that reads:

$qry = db_fetch("SELECT a.forum, a.msgid, a.dtm, a.subject, a.poster, a.body, a.ord, b.threadid, c.ref FROM usenet_article AS a, thread AS b, usenet_ref AS c, post AS d WHERE a.msgid=c.msgid AND c.ref=b.msgid AND b.forumid=$group->{forumid} AND d.msgid=b.msgid AND ((d.ord + 1 = a.ord) OR (d.ord=a.ord) OR a.ord = 1)");

with this:

$qry = db_fetch("SELECT a.forum, a.msgid, a.dtm, a.subject, a.poster, a.body, a.ord, b.threadid, c.ref FROM usenet_article AS a, thread AS b, usenet_ref AS c, post AS d where b.threadid = d.threadid and b.forumid = $group->{forumid} and c.ref = d.msgid and a.msgid = c.msgid AND ((d.ord + 1 = a.ord) OR (d.ord=a.ord))");

I'm still not sure why you are getting the first line chopped off some of messages. I don't seem to have the problem I'll keep looking.

The above fix is now in the package for download.

You'll need to run the newnews.pl half a dozen times or so to catch up and load all the missing posts.

[Edited by fastforward on 01-23-2001 at 03:36 PM]

wehhayyy massive improvement.

old stats:

usnet_article = 3179 entries
posts = 1265

new stats:

usnet_article = 2700 entries
posts = 5948

what is strange is that i have so many more posts but not that many less usenet articles? strange still me thinks, shouldn't it be a 1 for 1 swap?

There are also some still not in there, i will have to explore why and it is perhaps the missing first article thing we talked about.

I will also explore a bit more that missing first line thing and see if it happens again.

Thanks for fixing this, going to get a few of my users test using it now to see what they think.

Hmmm... That does seem very odd. You definately should have a one to one increase/decrease in those tables. Unless of course you just downloaded a whole bunch of other articles that don't have anything to refer to. But that seems unlikely. What is the setting for your $expire variable? Now that you have pulled all the history, you should have it set to 7-14 days. Remember the number needs to be in seconds though.

Do you have to have "allow guest to post" as "on" to be able to use this hack.

ok my new plan is to start again,i will delete posts, threads etc and see how it goes.

dunefreak,

No you don't need 'Guest posting enabled'. The script simply forces the usenet posts into the tables in a way that makes vBulletin think it was a guest that created the post. All normal vBulletin permissions and options work on the usenet forums.