View Full Version : NNTP Gateway (Usenet/Newsgroups)
Gilby
02-19-2002, 10:00 PM
This hack provides a gateway to any NNTP newsgroup such as those from Usenet and other newsgroup servers. Selected newsgroups are imported from your news server and post on the forum are sent out to the newsgroup. This hack was greatly inspired by fastforward's usenet gateway hack (https://vborg.vbsupport.ru/showthread.php?threadid=22599). This one is a complete rewrite of that hack written in PHP and works with vB 2.2.2.
Installation:
Installation is pretty simple. No modifications to the vB php files are needed and it simply consists of dropping in the files to your forums directory, running the SQL modifications, and modifying the newsgroup settings for your desired newsgroups. For the complete installation details, read the readme.txt file.
Here are some of the features:
Real cool vbcode to text conversion! ;)
All posts are inserted, even if parent thread cannot be found for replies
Guests posts also get sent to the newsgroup.
Importing of attachments from the newsgroup
Poll info sent to newsgroup
Attachment link sent to newsgroup
Supports unlimited newsgroups and servers.
email notification of new replies, just like regular forum posts
Can import HTML messages and convert to limited vb code.
For control panel integration, please check out GameCrash's Graphical Interface addition (https://vborg.vbsupport.ru/showthread.php?threadid=36475).
What's not in it that was in fastforward's usenet gateway hack:
No control panel integration at the moment. (Available separately (https://vborg.vbsupport.ru/showthread.php?threadid=36475))
Does not support separate footers
Does not allow custom email address to be used via the users option
No spam control or string replacement support.
No purging or autoexpire.
There is still lots that I'd like to add to it, but this is competely functional for basic newsgroup gateway support. It is most likely not free of bugs. ;) If you have questions, suggestions or annoyances, please post in this thread.
vb3 support
lierduh modified this to provide support for the beta versions of vb3 (https://vborg.vbsupport.ru/showpost.php?p=444521&postcount=658). When the release candidates of vb3 come out, I plan to add support for vb3 and add other features to this hack. If you have suggestions for new features, let me know.
E-mail gateway support
New in this version, you can now gateway with an email list. This will fetch emails from a POP email account and send via php's mail function to the mailing list's email address. To set up the list, in the newsgroup field, enter in the email address to send outgoing posts to. In the server field, enter in the pop3 server, and in the username and password fields enter in, you guessed it, the username and password to your pop account. Note: the email gateway capabilities has not been fully tested, so it might not work with your POP server. Also, it does not work in combo with a news<->forum gateway in the same forum (you can use either kind though in differnet forums within your forums).
GameCrash
02-20-2002, 07:24 AM
very nice - will install it later :)
Does it need cron jobs?
GameCrash
02-20-2002, 07:35 AM
Running the sql (that in nntp.sql) fails - the insert into nntp_groups includes a column footer which is not in the create table - I think it is from the usenet hack? Can I simply change the insert statement or do I have to change the select?
Erwin
02-20-2002, 08:54 AM
This is my dream come true!
I will install it this weekend... :) Thanks!
One question: If I don't do a cron job, then I have to manually run the gateway.php file myself - is that right?
Thanks for the hack. I agree with Gamecrash:ERROR 1054: Unknown column 'footer' in 'field list'
Query OK, 0 rows affected (0.01 sec)
Thanks
Sanjiyan
02-20-2002, 12:52 PM
Originally posted by GameCrash
Running the sql (that in nntp.sql) fails - the insert into nntp_groups includes a column footer which is not in the create table - I think it is from the usenet hack? Can I simply change the insert statement or do I have to change the select?
same here what do I need to do?
Sanjiyan
02-20-2002, 12:52 PM
same here what do I need to do ?
Sanjiyan
02-20-2002, 01:15 PM
Originally posted by dost
Thanks for the hack. I agree with Gamecrash:ERROR 1054: Unknown column 'footer' in 'field list'
Query OK, 0 rows affected (0.01 sec)Also I couldn't get it to work because nothing happens when I run gateway.php. Maybe we can have a better explanation of step 4. It seemed a little bit unclear to me. Like, should I put just news.xxx.com in the server part? And where can I check if I have PEAR installed or not?
Thanks
Same here, I can not get anything to happen when I run the gateway.php file either
I got the sql part installed by removing the footer text from the insert field, and also by removing the footers corosponding NULL entery.
Gilby
02-20-2002, 02:11 PM
Originally posted by Sanjiyan
I got the sql part installed by removing the footer text from the insert field, and also by removing the footers corosponding NULL entery.
I fixed the SQL in the first post. Please give this update a try. I removed the footer column at the last minute because I didn't implement any use for it and it might confuse some just by being there.
Gilby
02-20-2002, 02:12 PM
Originally posted by Sanjiyan
Same here, I can not get anything to happen when I run the gateway.php file either
Did anything happen? Any errors appear?
Sanjiyan
02-20-2002, 02:14 PM
Originally posted by Gilby
Did anything happen? Any errors appear?
nope no errors, just a blank white IE screen.
I didnt run it as cron, I just ran it from the address bar on IE, as I dont have access to cron and this will be ok with me, cos I can use MS TASK to run the url every 1 hour :P
Gilby
02-20-2002, 02:14 PM
Originally posted by Erwin Loh
One question: If I don't do a cron job, then I have to manually run the gateway.php file myself - is that right?
That's correct.
Sanjiyan
02-20-2002, 02:25 PM
If you wish to try the link on my site Gilby:
http://www.wocs.net/gateway.php
You can see it just gives you a blank screen.
Urm I run my forums on the root of my domain, mainly because thats all I have on my website for now and the for seeable future.
Thanks
Sanjiyan
02-20-2002, 02:26 PM
Originally posted by Gilby
I fixed the SQL in the first post. Please give this update a try. I removed the footer column at the last minute because I didn't implement any use for it and it might confuse some just by being there.
I have ran a file compare on the sql file I edited and your new one and they are exatcly the same so I shall refrane from uploading this one, as theres no changes to the code. Just thought I'd let you know.
Originally posted by Sanjiyan
nope no errors, just a blank white IE screen.
I didnt run it as cron, I just ran it from the address bar on IE, as I dont have access to cron and this will be ok with me, cos I can use MS TASK to run the url every 1 hour :P Same thing happened to me, but I found a solution. I searched my machine and found a file called pear.php.in, then I copied it to my forum folder and renamed it to pear.php and it worked.
Gilby: Some Turks use both the Re: and Ynt: prefix for replies in newsgroups. What can I do to recognize posts starting with Ynt: prefix as replies?
Thanks for the great hack
Sanjiyan
02-20-2002, 02:30 PM
Originally posted by dost
Same thing happened to me, but I found a solution. I searched my machine and found a file called pear.php.in, then I copied it to my forum folder and renamed it to pear.php and it worked.
Gilby: Some Turks use both the Re: and Ynt: prefix for replies in newsgroups. What can I do to recognize posts starting with Ynt: prefix as replies?
Thanks for the great hack
I dont have complete access to my webhosts hard disk only to my website as it where, is it possible for you to send me that file and I can see if I can do the same? or do you want me to leave this to you Gilby?
Well, I attached the pear.php that comes with my nusphere installation. I hope that's not illegal :)
And be careful about choosing an empty forum for the news posts. I was trying it on my computer and I chose an existing forum, then it posted 140 posts in a minute from my computer to the newsgroup. It was too late when I realized it and I had to apologize :surprised
Gilby
02-20-2002, 02:37 PM
Originally posted by dost
Same thing happened to me, but I found a solution. I searched my machine and found a file called pear.php.in, then I copied it to my forum folder and renamed it to pear.php and it worked.
Ah... I was puzzled. The only thing I could figure was that there were no newsgroups in the database. Since it looks like the PEAR is a problem, I'll have to modify the NNTP class to not require it.
Originally posted by dost
Gilby: Some Turks use both the Re: and Ynt: prefix for replies in newsgroups. What can I do to recognize posts starting with Ynt: prefix as replies?
On line 124 and 125, replace those similar lines with:
if (eregi("^(Re:|Ynt:)", $message[subject])){
$subject = eregi_replace("^((Re:|Ynt:)[ ]*)+","",$message[subject]);
Sanjiyan
02-20-2002, 02:39 PM
Originally posted by dost
Well, I attached the pear.php that comes with my nusphere installation. I hope that's not illegal :)
And be careful about choosing an empty forum for the news posts. I was trying it on my computer and I chose an existing forum, then it posted 140 posts in a minute from my computer to the newsgroup. It was too late when I realized it and I had to apologize :surprised
still dont work, still getting a blank white screen with no error messages, with the status bar saying 'Done'
Gilby
02-20-2002, 02:43 PM
Originally posted by dost
And be careful about choosing an empty forum for the news posts. I was trying it on my computer and I chose an existing forum, then it posted 140 posts in a minute from my computer to the newsgroup. It was too late when I realized it and I had to apologize :surprised
Yeah, I should have mentioned that. Sorry about that. I added a little warning to the readme.txt.
Originally posted by Sanjiyan
still dont work, still getting a blank white screen with no error messages, with the status bar saying 'Done' The instructions are a bit unclear for new users. You may have forgotten to go to the nntp_groups table with phpMyAdmin and say Insert. There you have to insert your newsgroup settings.
Sanjiyan
02-20-2002, 02:47 PM
Originally posted by dost
The instructions are a bit unclear for new users. You may have forgotten to go to the nntp_groups table with phpMyAdmin and say Insert. There you have to insert your newsgroup settings.
Like this:
Sanjiyan
02-20-2002, 02:48 PM
and this:
Sanjiyan
02-20-2002, 02:50 PM
are both of those database entries right?
Gilby
02-20-2002, 02:59 PM
Originally posted by Sanjiyan
are both of those database entries right?
Yeah it looks fine.
Try adding the folowing line near the top of gateway.php (after the <?php ):
error_reporting (63);
This will turn on all error reporting and it may give us something to go on.
Sanjiyan
02-20-2002, 03:04 PM
urm same as before a blank screen
can one of you try: www.wocs.net/gateway.php ?
and I have this in the gateway.php
<?php
error_reporting (63);
/********************************************
NNTP (Usenet/Newsgroup) Gateway 1.0
By Kevin Gilbertson <mail@gilby.com>
Released: Feb. 20, 2002
For support, please visit the thread
at vbulletin.org
********************************************/
Sanjiyan
02-20-2002, 03:10 PM
ahh now its just using hte progress bar, and its slowly so slowly moving across the status bar, yet its a white screen still.
I use phpstats to view the server stats on my webhost and it seems the ram usage is going up tho, so something is running. I think.
phpSysInfo 2.0 even
Sanjiyan
02-20-2002, 03:15 PM
nope its not doing anything, again a white screen and bugger all is posted
if you goto www.wocs.net you will see the two test forums for the newgroups stuff in place both with 0 posts also :|
nah the gateway.php screen has locked with the status progress bar at 50% and it staying there.
Sanjiyan
02-20-2002, 03:18 PM
ahh now I just refreshed it
and it says this:
<br>
<b>Warning</b>: Undefined index: HTTP_POST_VARS in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>85</b><br>
<br>
<b>Warning</b>: Undefined index: action in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>85</b><br>
<br>
<b>Warning</b>: Undefined index: action in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>88</b><br>
<br>
<b>Warning</b>: Cannot add header information - headers already sent by (output started at /usr/home/wocsnet/public_html/global.php:85) in <b>/usr/home/wocsnet/public_html/admin/functions.php</b> on line <b>1530</b><br>
BTW: I removed the pear.php from my webspace, do I need that on the server for this to run?
Gilby
02-20-2002, 03:28 PM
Sanjiyan, I added an output in the gateway.php that just outputs the number of newsgroups that are being gatewayed. That's in the first post. Try that one and let's see if it even gets that far in the script before dieing.
Sanjiyan
02-20-2002, 03:35 PM
it does not get anywahere, it gave me a blank screen again, so I added that error code stuff to it and got this:
<br>
<b>Warning</b>: Undefined index: HTTP_POST_VARS in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>85</b><br>
<br>
<b>Warning</b>: Undefined index: action in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>85</b><br>
<br>
<b>Warning</b>: Undefined index: action in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>88</b><br>
Would you like me to add a dir listing of my forums directory to help?
Gilby
02-20-2002, 03:39 PM
I'll modify the NNTP class so that it doesn't require pear. That could be the problem.
Sanjiyan
02-20-2002, 03:39 PM
just did a refresh again and this code again:
<br>
<b>Warning</b>: Undefined index: HTTP_POST_VARS in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>85</b><br>
<br>
<b>Warning</b>: Undefined index: action in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>85</b><br>
<br>
<b>Warning</b>: Undefined index: action in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>88</b><br>
<br>
<b>Warning</b>: Cannot add header information - headers already sent by (output started at /usr/home/wocsnet/public_html/global.php:85) in <b>/usr/home/wocsnet/public_html/admin/functions.php</b> on line <b>1530</b><br>
I am sorry for spamming this, but I would really really love to get this working in some manner, and I am greatful for the help and assistance you are providing
Sanjiyan
02-20-2002, 03:41 PM
here is a jpg showing my root folder where my forums are located. its all there right ?
Gilby
02-20-2002, 03:45 PM
Try the attached nntp.php which does not require PEAR.
GameCrash
02-20-2002, 03:50 PM
Originally posted by Gilby
Try the attached nntp.php which does not require PEAR.
both don't work for me :( Just a blank page...
GameCrash
02-20-2002, 03:52 PM
Erm... does the script use UDP? I think this is disabled at my providers firewall...
Sanjiyan
02-20-2002, 03:52 PM
well
I get no feed back from the script, nothing at all, bar the white screen, but the progress bar is at the 50% mark and suck there.
Could it be that there is a problem with the server or perl on the server? if so what perl mods are needed so I can ask my host support ?
but if you would, can you run the gateway.php from my site:
www.wocs.net/gateway.php
and see what happens, I have to go to dinner right now so I shall be back on in 20 minutes ok? if you could try that link for me and see what happens I'd be greatful.
Gilby
02-20-2002, 03:56 PM
Originally posted by Sanjiyan
Could it be that there is a problem with the server or perl on the server? if so what perl mods are needed so I can ask my host support ?
This script does not use perl, so there is no messing around with that sort of thing.
Do you know what version of php you are using?
GameCrash
02-20-2002, 04:06 PM
Originally posted by GameCrash
does the script use UDP?
Does it? If yes, then I don't have to test any more...
Gilby
02-20-2002, 04:10 PM
It does not use UDP... unless there is somethign about php's fsockopen function that I don't know about.
Sanjiyan
02-20-2002, 04:13 PM
Originally posted by Gilby
This script does not use perl, so there is no messing around with that sort of thing.
Do you know what version of php you are using?
http://www.wocs.net/info.php
is my php info
but I am using: PHP Version 4.0.4pl1
FreeBSD www.beta.com 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Mon Nov 20 13:02:55 GMT 2000 jkh@bento.FreeBSD.org:/usr/src/sys/compile/GENERIC i386
Gilby
02-20-2002, 04:13 PM
Sanjiyan and GameCrash, try the following newsgroup settings:
newsgroup: webdiscuss.test
server: webdiscuss.com
forum: a blank test forum id
You can either set the enabled to 0 for your other newsgroups, or remove those from your database.
Let me know the results of that.
Sanjiyan
02-20-2002, 04:14 PM
Originally posted by Sanjiyan
well
I get no feed back from the script, nothing at all, bar the white screen, but the progress bar is at the 50% mark and suck there.
Could it be that there is a problem with the server or perl on the server? if so what perl mods are needed so I can ask my host support ?
but if you would, can you run the gateway.php from my site:
www.wocs.net/gateway.php
and see what happens, I have to go to dinner right now so I shall be back on in 20 minutes ok? if you could try that link for me and see what happens I'd be greatful.
right, came back from dinner and it was still locked at 50% progress and a blank screen... not even getting the error codes I was before.
Sanjiyan
02-20-2002, 04:21 PM
Originally posted by Gilby
Sanjiyan and GameCrash, try the following newsgroup settings:
newsgroup: webdiscuss.test
server: webdiscuss.com
forum: a blank test forum id
You can either set the enabled to 0 for your other newsgroups, or remove those from your database.
Let me know the results of that.
ok says this:
<br>
<b>Warning</b>: Undefined index: HTTP_POST_VARS in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>85</b><br>
<br>
<b>Warning</b>: Undefined index: action in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>85</b><br>
<br>
<b>Warning</b>: Undefined index: action in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>88</b><br>
<br>
<b>Warning</b>: Cannot add header information - headers already sent by (output started at /usr/home/wocsnet/public_html/global.php:85) in <b>/usr/home/wocsnet/public_html/admin/functions.php</b> on line <b>1530</b><br>
<br>
<b>Warning</b>: Cannot add header information - headers already sent by (output started at /usr/home/wocsnet/public_html/global.php:85) in <b>/usr/home/wocsnet/public_html/gateway.php</b> on line <b>424</b><br>
1 group(s) gatewayed.
Logging in to webdiscuss.com, group webdiscuss.test:
and thats it, oh and says done in the IE status
GameCrash
02-20-2002, 04:23 PM
Originally posted by Gilby
Sanjiyan and GameCrash, try the following newsgroup settings:
newsgroup: webdiscuss.test
server: webdiscuss.com
forum: a blank test forum id
You can either set the enabled to 0 for your other newsgroups, or remove those from your database.
Let me know the results of that.
The same error, you can try it yourself at http://www.sharp-forum.de/forum/gateway.php
I think it's the same problem as Sanjiyan's but mine stops loading after 90 sek because of server restrictions... I will try it via SSH there the restrictions are not soo hard...
Sanjiyan
02-20-2002, 04:26 PM
when I enable one of the rec.arts.anime groups, alongside with that test one you posted, its at that point where it falls over...
any ideas ?
Sanjiyan
02-20-2002, 04:31 PM
Originally posted by GameCrash
The same error, you can try it yourself at http://www.sharp-forum.de/forum/gateway.php
I think it's the same problem as Sanjiyan's but mine stops loading after 90 sek because of server restrictions... I will try it via SSH there the restrictions are not soo hard...
yes thats the same problem I appear to be getting GameCrash.
it connects to that webdiscuss.com when thats the only group thats enabled, yet dont pull any details from the server.
yet my problem returns when I try to pull my news from either news-text.blueyonder.co.uk or news.blueyonder.co.uk, cant try anyothers unless you know of a decent free usenet server that offers the rec.arts.anime groups?
edit: btw I know my local isps newserver is running cos i just conencted to it via outlook express :supwink:
GameCrash
02-20-2002, 04:38 PM
Now getting something :) I didn't change the default server, only the server at the groups table. The webdiscuss.com thing works fine now :)
Now I will have to work on news.microsoft.com...
Sanjiyan
02-20-2002, 04:40 PM
does it download any news from the tthe webdev test ?
also if you get the news.microsoft.com to work, want to post the server address and a newgroup so I can tets it also please ?
Gilby
02-20-2002, 04:42 PM
Originally posted by GameCrash
Now getting something :) I didn't change the default server, only the server at the groups table. The webdiscuss.com thing works fine now :)
You may want to go into the newsgroup server and look at the source of the last message on the server and get the Xref number out of it. Then set that as the lastmsg. This will prevent it from trying to download all the posts.
Sanjiyan
02-20-2002, 04:43 PM
Originally posted by Gilby
You may want to go into the newsgroup server and look at the source of the last message on the server and get the Xref number out of it. Then set that as the lastmsg. This will prevent it from trying to download all the posts.
mine only connects to the webdes of what ever server it does not download any news should it?
Sanjiyan
02-20-2002, 04:44 PM
Gilby: could you do me a favour and look at:
http://www.wocs.net/gateway.php and tell me if I should be getting those error messages?
because what you see there is all I get, and it does not download any news from the server it connects to.
Gilby
02-20-2002, 04:47 PM
Originally posted by Sanjiyan
it connects to that webdiscuss.com when thats the only group thats enabled, yet dont pull any details from the server.
Just try the webdiscuss one until we get it working. That is the test group I used when developing the script and has worked for me.
Sanjiyan
02-20-2002, 04:49 PM
yes it connects to the server, but its not pulling any data from the news server should it be? if so then its not, plus I am getting errors, please see post 53. thanks
Gilby
02-20-2002, 04:51 PM
Originally posted by Sanjiyan
yes it connects to the server, but its not pulling any data from the news server should it be? if so then its not, plus I am getting errors, please see post 53. thanks
The warnings that are showing aren't a problem. Try this nntp.php, it'll output more about what it's doing.
Sanjiyan
02-20-2002, 04:54 PM
it now says:
<br>
<b>Warning</b>: Undefined index: HTTP_POST_VARS in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>85</b><br>
<br>
<b>Warning</b>: Undefined index: action in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>85</b><br>
<br>
<b>Warning</b>: Undefined index: action in <b>/usr/home/wocsnet/public_html/global.php</b> on line <b>88</b><br>
<br>
<b>Warning</b>: Cannot add header information - headers already sent by (output started at /usr/home/wocsnet/public_html/global.php:85) in <b>/usr/home/wocsnet/public_html/admin/functions.php</b> on line <b>1530</b><br>
<br>
<b>Warning</b>: Cannot add header information - headers already sent by (output started at /usr/home/wocsnet/public_html/global.php:85) in <b>/usr/home/wocsnet/public_html/gateway.php</b> on line <b>424</b><br>
1 group(s) gatewayed.
381 PASS required
502 Authentication error
Logging in to webdiscuss.com, group webdiscuss.test:
Gilby
02-20-2002, 04:56 PM
Originally posted by Sanjiyan
381 PASS required
502 Authentication error
Logging in to webdiscuss.com, group webdiscuss.test:
Make suer you set the username and password to NULL (in phpMyAdmin, just leave it blank).
Sanjiyan
02-20-2002, 04:58 PM
it is:
Edit Delete webdiscuss.test 66 0 webdiscuss.com NULL NULL 1
Gilby
02-20-2002, 05:07 PM
Originally posted by Sanjiyan
it is:
Edit Delete webdiscuss.test 66 0 webdiscuss.com NULL NULL 1
OK, there was a bug. Since you have the default password and username set, it used those. Please go to the first post inthe thread and get the fixed script and let me know if that works. If that still doesn't work, then upload the nntp.php I posted above that will output the responses and we'll see where we're at.
Gilby
02-20-2002, 05:26 PM
If you get the webdiscuss.test newgroup to work, then before trying your newsgroups, run this getlastmsg.php script. This will set the lastmsg of the groups in the database and will then make your script only get any new posts from that point on.
GameCrash
02-20-2002, 05:34 PM
Whatever I do, it only says "1 group(s) gatewayed." but it does nothing... What I am trying atm is to get microsoft.public.msdn.general from news.microsoft.com. Could you try if it works for you?
Erwin
02-20-2002, 06:14 PM
Hi,
I've followed your instructions, uploaded the files from the 1st post, edited my database - everything appears to work, and I get the "1 group(s) gatewayed" message at the end, but the USENET threads are NOT imported in VB for some reason...
I'm not getting any error messages, it's just that the newsgroups threads are not being imported.
Any ideas?
Gilby
02-20-2002, 06:19 PM
Originally posted by Erwin Loh
Hi,
I've followed your instructions, uploaded the files from the 1st post, edited my database - everything appears to work, and I get the "1 group(s) gatewayed" message at the end, but the USENET threads are NOT imported in VB for some reason...
I'm not getting any error messages, it's just that the newsgroups threads are not being imported.
Any ideas?
Did the page continue to load after that?
This hack works great with public news servers, but when it comes to servers that need authentication, it doesn't seem to work.
Gilby
02-20-2002, 06:45 PM
Originally posted by dost
This hack works great with public news servers, but when it comes to servers that need authentication, it doesn't seem to work.
I am using it on a server that requires authentication, and it works fine on that. There was a bug in the script that caused some authentication stuff to not work if the server didn't require authentication and one was set for the default server, then it'd try the one for the default server and fail.
Gilby
02-20-2002, 06:47 PM
Originally posted by GameCrash
Whatever I do, it only says "1 group(s) gatewayed." but it does nothing... What I am trying atm is to get microsoft.public.msdn.general from news.microsoft.com. Could you try if it works for you?
It did not work for me. Not even a basic test nntp login script worked for it. I could, however, log in manually to the server, so that puzzles me.
Sanjiyan
02-20-2002, 07:54 PM
Originally posted by Gilby
OK, there was a bug. Since you have the default password and username set, it used those. Please go to the first post inthe thread and get the fixed script and let me know if that works. If that still doesn't work, then upload the nntp.php I posted above that will output the responses and we'll see where we're at.
OK I did this and I can get messages posted to the webdiscuss.tst group now, so I tried to get posted from my own isps newserver at news-text.blueyonder.co.uk
and this is where the problems start, I am gettiing no feedback and it locks up when the status progress bar in ie hits 50% and nothing else occurs, even left it for 10 minutes and it still didnt move.
it requires username and password to getonto the newserver also, so it does the same with or without the user/pass entered.
any ideas ? plus I am using the nntp.php that gives feedback and its not giving anything back either.
EDIT: Also locks up on my other ISPs nntp servr: news.blueyonder.co.uk again with or without user/pass.
yet if I delete the entreies to my own isp and move back to the webdiscuss server it works right away, but if I run it with my isps news servers it wont work just gives me a white screen.
Gilby
02-20-2002, 07:58 PM
Originally posted by Sanjiyan
any ideas ? plus I am using the nntp.php that gives feedback and its not giving anything back either.
Here's another nntp.php to try, I narrowed it down to where it was hanging on the microsoft server and this one fixes that, but yet it hangs elsewhere now. But it might work for you.
Sanjiyan
02-20-2002, 08:01 PM
Originally posted by Gilby
Here's another nntp.php to try, I narrowed it down to where it was hanging on the microsoft server and this one fixes that, but yet it hangs elsewhere now. But it might work for you.
ok now all I get is this:
<br>
<b>Fatal error</b>: Cannot redeclare logging() in <b>/usr/home/wocsnet/public_html/nntp.php</b> on line <b>328</b><br>
then IE says done, no other feedback..
Gilby
02-20-2002, 08:42 PM
Originally posted by Sanjiyan
ok now all I get is this:
<br>
<b>Fatal error</b>: Cannot redeclare logging() in <b>/usr/home/wocsnet/public_html/nntp.php</b> on line <b>328</b><br>
then IE says done, no other feedback..
try again... it just removed that.
Sanjiyan
02-20-2002, 08:48 PM
what redownload it or just re run the file?
Sanjiyan
02-20-2002, 08:52 PM
cant do anything for 5-10 minutes anyway the site where I am trying this out, the server its running on has just ran out of disk space, so I have got my host to delete the crap from it.
basically they are saying the script I am running has done a runaway somehow and has filled around 60 gigs worth of data somehow, so they are clearing it off for me. so I can reupload the new nntp.php
Gilby
02-20-2002, 08:52 PM
Originally posted by Sanjiyan
what redownload it or just re run the file?
Download it again :)
Sanjiyan
02-20-2002, 09:06 PM
Originally posted by Gilby
Download it again :)
ok downlaoded the file
and just uplaoded it to my site as my host just waked on another disk to the array for the time being :P
and I get this:
urm.. right.... it worked on the webdiscuss.test go I deleted that group from the sql databse and added my own isps newserver, it worked witjh one group in the list.
is there chance I can ask for a nntp.php that gives me feedback as it access the news server and downloads the data or is that out of the question ? or does this do it?
Gilby
02-20-2002, 09:17 PM
Originally posted by Sanjiyan
urm.. right.... it worked on the webdiscuss.test go I deleted that group from the sql databse and added my own isps newserver, it worked witjh one group in the list.
is there chance I can ask for a nntp.php that gives me feedback as it access the news server and downloads the data or is that out of the question ? or does this do it?
So does that mean it works for you now with all your newsgroups?
I attached an nntp.php that will output the nntp server's responses.
Sanjiyan
02-20-2002, 09:20 PM
Originally posted by Gilby
So does that mean it works for you now with all your newsgroups?
so far it does yes
I have it running with 2 groups, now with this script I'll run it with all 10 :P give it a pounding as it where
Sanjiyan
02-20-2002, 09:23 PM
hmmmm
is says this using that new nntp.php (below)
but this is weird is it the script of my server cos 5 minutes ago I was downloading news from rec.arts.anime and rec.arts.anime.creative...
anyway heres waht it says. and I really apprecaiate your help in this, give me your address and I'll ship a crate of Roses chocolates to you for thanks ^_^
10 group(s) gatewayed.
200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0)
381 More Authentication Required
502 Authentication Failed
211 99 3216690 3216800 rec.arts.anime
Logging in to news-text.blueyonder.co.uk, group rec.arts.anime:
200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0)
381 More Authentication Required
502 Authentication Failed
211 117 3216740 3216874 rec.arts.anime.creative
Logging in to news-text.blueyonder.co.uk, group rec.arts.anime.creative:
200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0)
381 More Authentication Required
502 Authentication Failed
211 293 3235896 3236281 rec.arts.anime.fandom
Logging in to news-text.blueyonder.co.uk, group rec.arts.anime.fandom:
220 3235897 Wed, 23 Jan 2002 05:29:25 GMTGetting message number 3235897: New thread; 'FA: Moldiver Complete (all 6 episodes) Region 1 *MINT*' from M.R.
Sanjiyan
02-20-2002, 09:24 PM
ahh found a snag I think, unsure....
it keeps on losing connect to the mysql database is the the script of my vbulletin ?
Tim Wheatley
02-20-2002, 09:36 PM
Doesn't that mean it requires a username and password? The server needs you logged in?
Sanjiyan
02-20-2002, 09:39 PM
Originally posted by Tim Wheatley
Doesn't that mean it requires a username and password? The server needs you logged in?
yep best thing is it that I have entered my userid and password which is the same for all the usegroups, and it was working on the ones I said it wasnt on.
yet for somereason now it decides to work on some but not others heh
overall now its working to some degree which is a lot better then the other newsgroup/usenet hack out there for me, as I cant run cron jobs.
so glad this is working and the support on this one is fast and good thanks to the creator of the hack.
Tim Wheatley
02-20-2002, 10:23 PM
Damn, seems my server is blocked! :(
My server is in Denmark, I'm in England and all my ISP's block this...
Gilby
02-20-2002, 10:42 PM
Originally posted by Tim Wheatley
Damn, seems my server is blocked! :(
My server is in Denmark, I'm in England and all my ISP's block this...
What is blocked?
Tim Wheatley
02-20-2002, 10:45 PM
No it's not your hack. It gives a message saying (giving my servers IP details) that it doesn't have rights to access, I tried another and it stopped in the same way with no message, When I 've tried a free server it works, but craply and without the newsgroups I want :-(
Tim Wheatley
02-20-2002, 10:49 PM
1 group(s) gatewayed.
502 Permission Denied - Access not permitted - newsmaster@ntli.net (Typhoon v1.2.3)
Logging in to news.ntlworld.com, group rec.autos.simulators:
I'm using my ISP user/pass even - but it's a no go :(
Sanjiyan
02-20-2002, 10:58 PM
damn it..
I had the hack running fine till I entered my details into the nntp_settings table.
ie my websites details instead of the yoursite.com stuff...
any ideas how this would make the gateway.php just sit there saying opening website and then doing what it was dong before, ie the white page and stuck at 50% status
Gilby
02-20-2002, 11:03 PM
I'm just going to switch it to where there is no default server. Just set it up for each one separately.
Sanjiyan
02-20-2002, 11:11 PM
Originally posted by Gilby
I'm just going to switch it to where there is no default server. Just set it up for each one separately.
ok I think I have found out why I am having the problem
I turned all the groups to 0 ie dont download.
and then turned each one back on seperatly.
and its locking up on the only group to where I have made a reply to via the forums.
I have deleted the thread I replied to, and it still locks up on that one group.
Does this help you?
EDIT: so at the moment I have turned off the one group that I most need as it has the most traffic :P
EDIT 2: Sorry about my spelling it sucks I know.
Sanjiyan
02-20-2002, 11:27 PM
Originally posted by Sanjiyan
ok I think I have found out why I am having the problem
I turned all the groups to 0 ie dont download.
and then turned each one back on seperatly.
and its locking up on the only group to where I have made a reply to via the forums.
I have deleted the thread I replied to, and it still locks up on that one group.
Does this help you?
EDIT: so at the moment I have turned off the one group that I most need as it has the most traffic :P
EDIT 2: Sorry about my spelling it sucks I know.
Another one, I just deleted all the posts that my local users placed on the group that is locking up the gateway.php, and re-enabled the group for download, and it is now downloading all the threads normally it seems, it seems it just has a problem dealing with any post one of my local users either replies to or makes new threads for on.
At the moment I have stop all users from replying to the usenet groups.
Any ideas?
Gilby
02-21-2002, 12:43 AM
Everyone should run this SQL:
ALTER TABLE post ADD INDEX (isusenetpost);
ALTER TABLE post ADD INDEX (msgid);
This should speed up things considerably.
Shaman
02-21-2002, 02:12 AM
I'm waiting with bated breath for a stable version of this hack... or should it be thought of as stable now?
Gilby
02-21-2002, 04:00 AM
Originally posted by Shaman
I'm waiting with bated breath for a stable version of this hack... or should it be thought of as stable now?
Depends on how you define stable. right now the main issues that have risen are performance and compatibility with a variety of NNTP servers.
Gilby
02-21-2002, 05:52 AM
I just uploaded a new version. Same functionality, but it should eliminate most the errors people have had. You can find that in the first post in this thread.
If you've already installed the hack, make sure you run the SQL a few posts back as that will make a huge difference for when your tables get filled with a lot of posts. In one case it brought the query speed from around 30 seconds to a fraction of a second.
If you want a gauge of how long things are taking, you can rin the script like: http://www.yourserver.com/gateway.php?showqueries=1 and it'll print out all the SQL queries as well as the start and finish time of the queries.
GameCrash
02-21-2002, 07:03 AM
Well... I uploaded the new files from the new post, now I'm getting this message:
1 group(s) gatewayed.
Logging in to news.microsoft.com, group microsoft.public.german.entwickler.dotnet.csharp
Then the script exits (it's now running about 2 seconds). Nothing gets imported...
Running setlastmsg.php returns the following:
1 group(s) gatewayed.
Logging in to news.microsoft.com, group microsoft.public.german.entwickler.dotnet.csharp:
Max: newsgroup
Min: such
The lastmsg in the database stays at 0...
I'll now try the other nntp.php you posted above...
GameCrash
02-21-2002, 07:08 AM
The same problem, the only difference is that there is a "12345" before the "logging in to ..."
Erwin
02-21-2002, 08:24 AM
I can say that the webdiscuss.com server works with this script. FANTASTIC!!!
The script doesn't work with my ISP's newserver though. I will need to search for a free one...
Erwin
02-21-2002, 09:40 AM
May I congratulate you Gilby by telling you that it works - you just need to use a public newserver that does not require a username or password. :)
Cool - I am hunting down one with the forums I want right now... but it works!
GameCrash
02-21-2002, 10:22 AM
Now it seems to work - don't ask me why...
One thing, after import every post is set to the import date, not to the date it has really been posted to the NG. Is it possible to do that or is it a problem (timezones etc.)?
Sanjiyan
02-21-2002, 11:08 AM
Gilby,
Any news on the local user replies, and why they are locking up the gateway.php ie downloads from the usenet server works, yet uploads lockup.
Erwin
02-21-2002, 11:10 AM
Not true in my case - all my imported posts and threads reflect the actual time of posting, not the import date.
Wanted to say again that this is a GREAT hack! The best one I have installed, and I have installed many! :)
Gilby
02-21-2002, 01:04 PM
Originally posted by Sanjiyan
Any news on the local user replies, and why they are locking up the gateway.php ie downloads from the usenet server works, yet uploads lockup.
Did you run the SQL update? Also try running it with the showqueries=1 in the URL.
Gilby
02-21-2002, 01:11 PM
Originally posted by Erwin Loh
May I congratulate you Gilby by telling you that it works - you just need to use a public newserver that does not require a username or password. :)
Cool - I am hunting down one with the forums I want right now... but it works!
My two test servers that I used when developing it are "InterNetNews NNRP server INN" and one does require the username and password and it works fine. I think that it still might not work with some other nntp servers. If you have a specific server that it's not working on and you can give me access to play around with that server, I may be able to figure out what's causing the problem.
Gilby
02-21-2002, 01:14 PM
Originally posted by GameCrash
1 group(s) gatewayed.
Logging in to news.microsoft.com, group microsoft.public.german.entwickler.dotnet.csharp:
Max: newsgroup
Min: such
Apparently that group does not exist, but the nntp class did not catch it as an error.
Gilby
02-21-2002, 01:18 PM
Originally posted by GameCrash
One thing, after import every post is set to the import date, not to the date it has really been posted to the NG. Is it possible to do that or is it a problem (timezones etc.)?
I have the script set to import it as the date of the message if the lastmsg is set to 0. When this is set to 0, you're getting all the posts from the newsgroup. Otherwise, it'll import it and set it as the date of import, as this will make it be ordered correctly and not show up before other posts in the thread.
If you want to change how this works, you can go to line 77 and change the if-else statement that does this. So, you could comment out stuff something like:
// if ($group[lastmsg] == 0){
$date = strtotime($message[date]);
//} else {
//$date = time();
//}
Sanjiyan
02-21-2002, 01:21 PM
Originally posted by Gilby
Did you run the SQL update? Also try running it with the showqueries=1 in the URL.
I have ran the update yes, and heres the text the server gives me back, it apears to be locking up on the rec.arts.anime.misc group, which is the group where I have put my local post to on my vb server.
ALL SORRY ABOUT THE LENGTH OF THIS POST IT IS VERY LARGE:
The script stops/locksup after it checks the newsgroup just before the the newsgroup to which i have posted to, as you can see the last group checked is: rec.arts.anime.marketplace, which is the newsgroup just before the rec.arts.anime.misc group to which I have posted my reply.
---
Query: SELECT template FROM template WHERE title='options'
Time before: 0.056210041046143
Time after: 0.058135986328125
--------------------------------------------------------------------------------
Query: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
Time before: 0.068742990493774
Time after: 0.070780992507935
--------------------------------------------------------------------------------
Query: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,lo cation) VALUES ('d1c7dfccf2638fdec0d342fc87b444b0','1','194.117.1 33.180','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)','1014304767','/gateway.php?showqueries=1')
Time before: 0.08442497253418
Time after: 0.085327982902527
--------------------------------------------------------------------------------
Warning: Cannot add header information - headers already sent by (output started at /usr/home/wocsnet/public_html/global.php:120) in /usr/home/wocsnet/public_html/admin/functions.php on line 1530
Query: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='1'
Time before: 0.086961030960083
Time after: 0.088186979293823
--------------------------------------------------------------------------------
Query: SELECT template,title
FROM template
WHERE (title IN ('gobutton','timezone','username_loggedout','usern ame_loggedin','phpinclude','headinclude','header', 'footer','forumjumpbit','forumjump','nav_linkoff', 'nav_linkon','navbar','nav_joiner','pagenav','page nav_curpage','pagenav_firstlink','pagenav_lastlink ','pagenav_nextlink','pagenav_pagelink','pagenav_p revlink')
AND (templatesetid=-1 OR templatesetid='16'))
ORDER BY templatesetid
Time before: 0.088878035545349
Time after: 0.096379995346069
--------------------------------------------------------------------------------
Query: SELECT * FROM usergroup WHERE usergroupid=6
Time before: 0.10236001014709
Time after: 0.10398197174072
--------------------------------------------------------------------------------
Query: SELECT varname,value FROM nntp_settings
Time before: 0.11269104480743
Time after: 0.11516797542572
--------------------------------------------------------------------------------
Query: SELECT * FROM nntp_groups WHERE enabled=1
Time before: 0.11601901054382
Time after: 0.11823499202728
--------------------------------------------------------------------------------
Warning: Cannot add header information - headers already sent by (output started at /usr/home/wocsnet/public_html/global.php:120) in /usr/home/wocsnet/public_html/gateway.php on line 433
14 group(s) gatewayed.
200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0)
381 More Authentication Required
502 Authentication Failed
211 99 3216690 3216800 rec.arts.anime
Logging in to news-text.blueyonder.co.uk, group rec.arts.anime:
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.pollid,thread.title,post. threadid,thread.forumid FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND post.dateline=thread.dateline AND post.userid=thread.postuserid AND (thread.forumid=59)
Time before: 0.16228294372559
Time after: 0.17449402809143
--------------------------------------------------------------------------------
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.title,post.threadid,threa d.forumid,thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=59)
Time before: 0.17489802837372
Time after: 0.18513000011444
--------------------------------------------------------------------------------
200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0)
381 More Authentication Required
502 Authentication Failed
211 117 3216740 3216874 rec.arts.anime.creative
Logging in to news-text.blueyonder.co.uk, group rec.arts.anime.creative:
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.pollid,thread.title,post. threadid,thread.forumid FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND post.dateline=thread.dateline AND post.userid=thread.postuserid AND (thread.forumid=60)
Time before: 0.22879302501678
Time after: 0.29553496837616
--------------------------------------------------------------------------------
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.title,post.threadid,threa d.forumid,thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=60)
Time before: 0.29594302177429
Time after: 0.35159695148468
--------------------------------------------------------------------------------
200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0)
381 More Authentication Required
502 Authentication Failed
211 293 3235896 3236281 rec.arts.anime.fandom
Logging in to news-text.blueyonder.co.uk, group rec.arts.anime.fandom:
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.pollid,thread.title,post. threadid,thread.forumid FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND post.dateline=thread.dateline AND post.userid=thread.postuserid AND (thread.forumid=67)
Time before: 0.40430796146393
Time after: 0.43287003040314
--------------------------------------------------------------------------------
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.title,post.threadid,threa d.forumid,thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=67)
Time before: 0.43329298496246
Time after: 0.45920097827911
--------------------------------------------------------------------------------
200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0)
381 More Authentication Required
502 Authentication Failed
211 15 3215061 3215129 rec.arts.anime.games
Logging in to news-text.blueyonder.co.uk, group rec.arts.anime.games:
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.pollid,thread.title,post. threadid,thread.forumid FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND post.dateline=thread.dateline AND post.userid=thread.postuserid AND (thread.forumid=68)
Time before: 0.48813498020172
Time after: 0.49104905128479
--------------------------------------------------------------------------------
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.title,post.threadid,threa d.forumid,thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=68)
Time before: 0.4914870262146
Time after: 0.49426400661469
--------------------------------------------------------------------------------
200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0)
381 More Authentication Required
502 Authentication Failed
211 0 2 1 rec.arts.anime.info
Logging in to news-text.blueyonder.co.uk, group rec.arts.anime.info:
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.pollid,thread.title,post. threadid,thread.forumid FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND post.dateline=thread.dateline AND post.userid=thread.postuserid AND (thread.forumid=69)
Time before: 0.52041101455688
Time after: 0.5222350358963
--------------------------------------------------------------------------------
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.title,post.threadid,threa d.forumid,thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=69)
Time before: 0.52265894412994
Time after: 0.52438294887543
--------------------------------------------------------------------------------
200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0)
381 More Authentication Required
502 Authentication Failed
211 456 3258414 3259022 rec.arts.anime.marketplace
Logging in to news-text.blueyonder.co.uk, group rec.arts.anime.marketplace:
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.pollid,thread.title,post. threadid,thread.forumid FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND post.dateline=thread.dateline AND post.userid=thread.postuserid AND (thread.forumid=70)
Mark Hewitt
02-21-2002, 02:46 PM
Just installed this. (In fact upgraded from fastforwards hack). Everything seems to work just fine from what I can tell.
Haven't tried the outgoing messages yet. Is there a way to disable peoples profiles being printed on them etc, as I don't think my members would be too keen on that.
Also does it support proper threading of messages?
One problem I've noticed straight away is that is doesn't truncate usenet names, meaning the thread starter table is often over long.
In fastforwards hack the quoted text appeared in italics, any way to do that here?
I'm sure I'll have more comments when I have more time to mess with it ;)
lifesourcerec
02-21-2002, 03:46 PM
Ok. I installed it and ran gateway,php and it seems to work. Since I am new to this, a) what would be a commandline for crontab and b) anyone know of a public server? I'm on cable access and we just use "news" which isn't really a server.
Gilby
02-21-2002, 06:08 PM
Originally posted by Mark Hewitt
Just installed this. (In fact upgraded from fastforwards hack). Everything seems to work just fine from what I can tell.
Haven't tried the outgoing messages yet. Is there a way to disable peoples profiles being printed on them etc, as I don't think my members would be too keen on that.
Yeah, you can. For now you'll have to go into the code and change it. To do that, comment out this line:
$signature .= "$newthread[username]'s Profile: $settings[profileurl]$newthread[userid]\n";
Also does it support proper threading of messages?
Of course it does. I think it matches the new incoming posts with the correct thread better than fastforwards hack did. However, I made i
t where if the user modifies the subject line to be completely different, then a new thread will be created.
One problem I've noticed straight away is that is doesn't truncate usenet names, meaning the thread starter table is often over long.
So on the forumdisplay, they are to long? Or within the thread itself? Can you give me an example of one and how you'd like it chopped down? It can be done where the chopping will just be done on the forumdisplay so that the tables columns don't get smushed, yet in the viewthread, it'll remain the full length.
In fastforwards hack the quoted text appeared in italics, any way to do that here?
Yeah, find this line:
$message[text] = preg_replace("/((\n[ ]*>[^\n]*)+)/","$1",$message[text]);
and replace it with this:
$message[text] = preg_replace("/((\n[ ]*>[^\n]*)+)/","$1",$message[text]);
Or put in whatever other vb code you want there.
vB code with in the code tags gets parsed... so the $1 that is shown in blue up there is [ i ][ color=blue ]$1[ /color ][ /i ], of course that's without the spaces.
Gilby
02-21-2002, 06:14 PM
Originally posted by lifesourcerec
a) what would be a commandline for crontab
If you are on a unix or linux server and have shell access, you can make a crontab by putting this line:
5,15,25,35,45,55 * * * * /usr/bin/lynx -source "http://www.yourserver.com/vbdir/gateway.php?log=cron"
in a text file, let's say it's name is crontab.txt, and then type in at the command line:
crontab crontab.txt
That'll set you up with a cron job that'll execute every 10 minutes. You can change the 5,15, etc part to be whatever you want. That corresponds to the minutes of the hours.
Originally posted by Gilby
I made it where if the user modifies the subject line to be completely different, then a new thread will be created. Well, I'd really appreciate it if you could tell me how to make it so that it won't start a new thread when the subject is changed in replies :)
Gilby
02-21-2002, 08:49 PM
Originally posted by dost
Well, I'd really appreciate it if you could tell me how to make it so that it won't start a new thread when the subject is changed in replies :)
Well, if you really want it that way. What happens sometimes is that people will start a new thread by replying to a different message, which ends up putting it in the existing thread. Then when a reply is made on the forums, it doesn't have the same subject as you might be replying to. However, if you merge a thread together, it'll insert future replies correctly into the thread. I figured that if someone is going to change the subject, they are probably drifting off to another topic which merits new thread, and can be merged if by a moderator if it didn't.
Anyways, here's a change that I think will work, I haven't tested it though:
Replace this line:$get_threadid=$DB_site->query("SELECT thread.threadid FROM thread,post WHERE thread.threadid=post.threadid and (thread.title='".addslashes($subject)."' OR post.title LIKE '%".addslashes($subject)."' OR thread.title='".addslashes($altsubject)."' OR post.title LIKE '%".addslashes($altsubject)."') and (post.msgid='".preg_replace("/\s/sU","' OR post.msgid='",addslashes(trim($message[references])))."') AND (thread.forumid=". implode(" OR thread.forumid=", $group[forum]) . ") ORDER BY post.dateline DESC LIMIT 1");
With this line:$get_threadid=$DB_site->query("SELECT thread.threadid FROM thread,post WHERE thread.threadid=post.threadid and (post.msgid='".preg_replace("/\s/sU","' OR post.msgid='",addslashes(trim($message[references])))."') AND (thread.forumid=". implode(" OR thread.forumid=", $group[forum]) . ") ORDER BY post.dateline DESC LIMIT 1");
I'd give you a line number, but I don't have access to a real text editor at the moment. Be careful with this one, there is a query just a few lines down that is similar. This is the first one and comes right after "if ($message[references])".
Erwin
02-21-2002, 08:52 PM
It's working like a charm, Gilby. Incoming and outgoing messages work, the crontab has been set hourly and works great, and there has been no errors.
I suspect the reason why my ISP's newserver is not working is because it is hosted in Australia, and my site is hosted in the US. They must have blocked overseas connections.
Anyway, it's all good. Thank you for a GREAT hack. All without needing to change a single file too. :)
Gilby
02-21-2002, 09:00 PM
Glad to hear it's working for you! :)
Originally posted by Erwin Loh
I suspect the reason why my ISP's newserver is not working is because it is hosted in Australia, and my site is hosted in the US. They must have blocked overseas connections.
Most ISPs will block all connections except those within their own network. Others will allow an external connection, but requires a username and password for that to work. Mine happens to be the later, so I can use that one. :D
Gilby
02-21-2002, 09:03 PM
Sanjiyan, are you still having problems with new post going out to the newsgroup? I ran your script and it executed fully, without problems.
Well, thanks a lot Gilby, it worked like a charm. I really appreciate the support you are giving :)
Sanjiyan
02-21-2002, 11:26 PM
Originally posted by Gilby
Sanjiyan, are you still having problems with new post going out to the newsgroup? I ran your script and it executed fully, without problems.
yeah I am, its just freezing on the newsgroup, its not even trying to connect to the new group to either post or download the new news, yet it downloads the news on the groups before the group in question.. any look working out the problem with that mega-post I did on the previous page?
Gilby
02-22-2002, 01:55 AM
Originally posted by Sanjiyan
yeah I am, its just freezing on the newsgroup, its not even trying to connect to the new group to either post or download the new news, yet it downloads the news on the groups before the group in question.. any look working out the problem with that mega-post I did on the previous page?
My guess is that you don't have posting abilities on that server. The lack of it saying something like "posting ok" when you connect is one flag, and the "Authentication Failed" is another flag. Can you log into that server from a regular newsreader and post?
Other than that, the server may not be recognizing the end of a post and it then left waiting for more. But before we can go there, we need to determine that you can actually post there.
Sanjiyan
02-22-2002, 02:05 AM
Originally posted by Gilby
My guess is that you don't have posting abilities on that server. The lack of it saying something like "posting ok" when you connect is one flag, and the "Authentication Failed" is another flag. Can you log into that server from a regular newsreader and post?
Other than that, the server may not be recognizing the end of a post and it then left waiting for more. But before we can go there, we need to determine that you can actually post there.
Yep I can post there using both outlook express and gravity news-reader.
Mark Hewitt
02-22-2002, 12:29 PM
So on the forumdisplay, they are to long? Or within the thread itself? Can you give me an example of one and how you'd like it chopped down? It can be done where the chopping will just be done on the forumdisplay so that the tables columns don't get smushed, yet in the viewthread, it'll remain the full length.
Yes it's on the forumdisplay I'm talking about some people on usenet have a habit of HavingAVeryLongNameWithoutAnySpacesInItBecauseThey ThinkItLooksCool
If that can be chopped to a limited number of characters that would be great. Doesn't matter so much on showthread as it's only one post that gets affected.
Tim Wheatley
02-23-2002, 12:26 PM
Works great here. I installed v4 and now installed v5. But it works, thank you very much :)
Mark Hewitt
02-23-2002, 01:08 PM
Actually I've noticed my post above isn't entirely accurate. Basically because the forumdisplaybit has a "nowrap" set, long names even with spaces, do not wrap.
I don't want to get rid of this as it usually makes things look a lot neater than they would without it. So I use need a way to truncate the thread starters names.
Gilby
02-23-2002, 05:15 PM
After working out the problem with Sanjiyan on his setup, I've solved the compatibility issue and am releasing a new update that is available in the first thread. If you've had problems with the sending of forum posts to the newsgroup, then this should fix them.
I also added one new feature, and that is multiple colors for the replies in imported posts. So each level has it's own color.
The database has not changed, so all you need to do is upload the gateway.php and the nntp.php files.
If you have any bugs or feature requests you want, please post them here and I'll add them to my list of things to add to the script.
Sanjiyan
02-23-2002, 05:55 PM
Originally posted by Gilby
After working out the problem with Sanjiyan on his setup.
Yep thanks for your help with that little problem I was having Gilby, domo arigato ^_^
Sanjiyan
02-23-2002, 06:05 PM
Originally posted by Gilby
new update
I bet you already know what I am gonna ask for...
Gilby, mate buddy pal, best buddy in all the world, (master arse kisser I am ^_- )
Do you think you could email me a copy of the nntp.php which gives me the feed back codes please...
I kinda like having them so I know that the servers working for me ^_^
Thanks in advance.
fsfl2k
02-23-2002, 08:09 PM
I waited a few days for the problems to be worked out before downloading this and installing it.
I was able to install it and get it working with no problems.
The only error that arose was a mistake on my part and once corrected I was able to post and reply both on my forum and in a seperate news reader and all posts showed up with no glitches.
Thanks Gilby for taking the time to make this.
Couldn't ask for a better addition to my site.
Anthony
James Cridland
02-24-2002, 04:13 PM
Great hack.
Users with Opera might like to know that you can set that browser to re-load a page every x minutes: so, if you've a permanent connection, you can force a gateway "ping" every half hour by leaving Opera on in the background.
Of course, it's also possible to add a meta-refresh in the gateway.php code itself, too - for those of us without telnet access... :)
Sanjiyan
02-24-2002, 10:03 PM
Originally posted by James Cridland
Great hack.
Users with Opera might like to know that you can set that browser to re-load a page every x minutes: so, if you've a permanent connection, you can force a gateway "ping" every half hour by leaving Opera on in the background.
Of course, it's also possible to add a meta-refresh in the gateway.php code itself, too - for those of us without telnet access... :)
I just set this up to run every hour on the hour using MS Task Schedular:
C:\PROGRA~1\INTERN~1\IEXPLORE.EXE http://www.wocs.net/gateway.php
That to me is the better way, apart from the fact that if I am playing Counter Strike it pulls me out of the game screen to show that this is running. which is annoying.
Gilby
02-24-2002, 11:00 PM
I just updated the zip to include a bug fix. It's just the gateway.php that needs to be uploaded.
The bug is that on outgoing posts, my regular expression removed the letter 's' if it was at the beginning of a line (for you regex people, I used \s to match whitespace, but that didn't work). Version 1.7 fixes this bug.
I also added the Ynt: prefix to be looked for for replies just like the Re: is looked for. If other languages use other prefixes for replies and you need support for it, please let me know and I'll add them.
I probably won't be releasing a new version for a while, except in the case of a bug fix, and when the admin control panel integration is finished (that GameCrash has offered to create).
floleb7
02-25-2002, 04:03 PM
can i have a newsgroup without login and pas for testing the hack ? (a newsgroup wich works for someone :D)
fsfl2k
02-25-2002, 04:26 PM
I used the one posted earlier in the tread and it worked fine. Here it is again.
newsgroup: webdiscuss.test
server: webdiscuss.com
forum: a blank test forum id
Anthony
floleb7
02-25-2002, 06:13 PM
i have this : fr.rec.son-image.dvd-video.titres how i can use this newsgroup with the hack ? (no login or pass required )
Gilby
02-26-2002, 09:40 PM
Originally posted by floleb7
i have this : fr.rec.son-image.dvd-video.titres how i can use this newsgroup with the hack ? (no login or pass required )
Go in the database and set the newsgroup to fr.rec.son-image.dvd-video.titres and then fill in the server with the host name of the server you have access to. You can then leave the username and password blank since it's not required for you.
annams
02-26-2002, 11:34 PM
First of all, thanks a bunch for this great hack.
I have tried fastforward's version before but I couldn't continue to use it because of CPU restrictions for PERL scripts with my ISP.
I have installed this script successfully and imported webdiscuss news postings with no problems. But, while posting new threads and replies I get the following problem:
===
group(s) gatewayed.
Logging in to webdiscuss.com, group webdiscuss.test
Posting Message from Srinivas Annam: 441 Can't parse "Date" header
Posting Message from Srinivas Annam: 441 Can't parse "Date" header
===
I get can't parse error twice when a new thread is posted and once when a reply is being posted.
- Srinivas
Gilby
02-27-2002, 02:09 AM
Originally posted by annams
I get can't parse error twice when a new thread is posted and once when a reply is being posted.
Since you were using the test server, webdiscuss.test, I know it has nothing to do with the server accepting it. I checked out your site where your forums are and it returned "X-Powered-By: PHP/4.0.3pl1" and the date format I use requires PHP 4.0.4 or greater to work.
So, either you can try to convince your webhost to upgrade, or you can make the following changes:
Whereever you find:
date("r",
Replace it with:
date("D, j M Y H:i:s O",
I'll have that change in the next release.
lifesourcerec
02-27-2002, 07:29 AM
Originally posted by Gilby
If you are on a unix or linux server and have shell access, you can make a crontab by putting this line:
5,15,25,35,45,55 * * * * /usr/bin/lynx -source "http://www.yourserver.com/vbdir/gateway.php?log=cron"
in a text file, let's say it's name is crontab.txt, and then type in at the command line:
crontab crontab.txt
That'll set you up with a cron job that'll execute every 10 minutes. You can change the 5,15, etc part to be whatever you want. That corresponds to the minutes of the hours.
Ok. And one more thing. How do I get the posts to show up in a forum? I used different forumid numbers and nothing showed up. But it did list everything in stats (total posts, top poster, etc.). How do you determine the forum if you have sub-forums?
Gilby
02-27-2002, 11:59 AM
Originally posted by lifesourcerec
Ok. And one more thing. How do I get the posts to show up in a forum? I used different forumid numbers and nothing showed up. But it did list everything in stats (total posts, top poster, etc.). How do you determine the forum if you have sub-forums?
Just go into the forum you want to use for the newsgroup and in the URL, it'll have something like "forumid=3" and this corresponds to forum 3, so put 3 in the forumid column in the database.
thanx Gilby for the work!
all went smooth :)
The Realist
02-27-2002, 01:07 PM
On running the gateway file the following eror is showing, any clues to solving this:
1 group(s) gatewayed.
Could not connect to NNTP-serverLogging in to news.demon.net, group alt.binaries.satellite-tv,alt.dss
Not connectedNot connected
annams
02-27-2002, 02:04 PM
Originally posted by Gilby
Whereever you find:
date("r",
Replace it with:
date("D, j M Y H:i:s O",
I'll have that change in the next release.
Thanks for the help. That fixed it.
I have one more minor issue:
I have posted few test messages to the test newsgroup at webdiscuss. My message got transmitted properly, but I see the following lines below my actual message:
===
--
Srinivas Annam - Moderator
'$2' ($1)
===
What is the $2 and $1? Is it somehow trying to put my signature on to the usenet? If so, how do I disable it?
Also, transmitting Moderator to the USENET newsgroup is not a good idea in my opinion.
I appreciate very much for this hack!
- Srinivas
annams
02-27-2002, 02:33 PM
I have done a bit more testing. Looks like it is not the signatures which is the problem (since quotes is also giving the same issue). It appears like another issue with older PHP.
Could you please take a look at this thread and offer me a fix please:
http://www.unicyclist.com/forums/showthread.php?s=&threadid=16654
PS: Thank you for putting up with my old version of php. I don't have much choice in the PHP version, my ISP (pair.com) does not easily upgrade it. (they go through rigorous evaluation/testing process before upgrading).
Gilby
02-27-2002, 08:39 PM
Originally posted by The Realist
On running the gateway file the following eror is showing, any clues to solving this:
1 group(s) gatewayed.
Could not connect to NNTP-serverLogging in to news.demon.net, group alt.binaries.satellite-tv,alt.dss
Not connectedNot connected
The server is probably non-existent. Make sure you have the settings in the database correct for that server.
Gilby
02-27-2002, 09:02 PM
Originally posted by annams
What is the $2 and $1? Is it somehow trying to put my signature on to the usenet? If so, how do I disable it?
It's the use of the preg_replace function that is not compatible with older version of php. The newer versions support using $1 for the first match, but in older version, it uses \\1 for the same thing. Newer versions of course are backwards compatible, so I have changed it to the old way so it works for everyone. Try out the gateway.php I attached and let me know if that works for you. If it does, I'll release this version.
Also, transmitting Moderator to the USENET newsgroup is not a good idea in my opinion.
That's just the 'title' that is being put in the signature. If there is no custom title, it is not put in there. Does vB use the cutom title field to define "moderator"? If it does, I suppose I'll make it an otpion to disable that in a future release.
annams
02-28-2002, 12:59 AM
Originally posted by Gilby
That's just the 'title' that is being put in the signature. If there is no custom title, it is not put in there. Does vB use the cutom title field to define "moderator"? If it does, I suppose I'll make it an otpion to disable that in a future release.
Gateway.php works great, thank you!
I have the control panel and the database the title moderator is not part of custom titles. Moderator is defined is stored under usertitle field in usergroup table. I would really appreciate if that can be removed (or atleast as an option).
Btw, Tinyurl is a great idea!
Once again thanks for this hack, this is like dream come true!!!
Gilby
02-28-2002, 01:49 AM
Originally posted by annams
I have the control panel and the database the title moderator is not part of custom titles. Moderator is defined is stored under usertitle field in usergroup table. I would really appreciate if that can be removed (or atleast as an option).
I just tried it out on my test forums and when i made a moderator, it changed the usertitle, but left the customtitle set to 0. The user title is only output in the signature if the customtitle is set to 1, as is most likely the case for you. If you set customtitle to 0, then everything should be normal for you.
annams
02-28-2002, 12:43 PM
Originally posted by Gilby
I just tried it out on my test forums and when i made a moderator, it changed the usertitle, but left the customtitle set to 0. The user title is only output in the signature if the customtitle is set to 1, as is most likely the case for you. If you set customtitle to 0, then everything should be normal for you.
Oops, my mistake! I somehow had customtitle set for my user id. Thanks.
saab340
03-01-2002, 08:07 AM
I finally got it working :)
My database grew from 13 megs to 300 megs. :(
Now is there a command, I can run, to reduce that.
Most of the posts has replies in it. ie
>>
>>>
>>>
>>
So if I want to remove lines like those,...
what is the command to do so?
Thanks
Hi All!
Just tried the gateway on my test forum and mySQL reports:
--------
Database error in vBulletin 2.2.2:
Invalid SQL: UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1, lastpost='1014616161',lastpost er='john' WHERE forumid IN ()
mysql error: You have an error in your SQL syntax near ')' at line 1
mysql error number: 1064
-------
any ideas?
Mood
Found my problem.
my test forum is forum ID 3 in the control VB panel yet if I point the URL to forum 3 I get nothing. The test forum showss up with ID 7.
Why ? Pls point me how I can set the forum IDs to the right number...
Thanks
Mood
lifesourcerec
03-01-2002, 04:32 PM
I get this:
6 group(s) gatewayed.
Logging in to news.tn.comcast.giganews.com, group rec.collecting.cards.discuss
Logging in to news.tn.comcast.giganews.com, group rec.collecting.sport.baseball
Logging in to news.tn.comcast.giganews.com, group rec.collecting.sport.basketball
Logging in to news.tn.comcast.giganews.com, group rec.collecting.sport.football
Logging in to news.tn.comcast.giganews.com, group rec.collecting.sport.hockey
No errors, but it's not getting the messages from them.
lifesourcerec
03-01-2002, 06:37 PM
Originally posted by Gilby
I just uploaded a new version. Same functionality, but it should eliminate most the errors people have had. You can find that in the first post in this thread.
If you've already installed the hack, make sure you run the SQL a few posts back as that will make a huge difference for when your tables get filled with a lot of posts. In one case it brought the query speed from around 30 seconds to a fraction of a second.
If you want a gauge of how long things are taking, you can rin the script like: http://www.yourserver.com/gateway.php?showqueries=1 and it'll print out all the SQL queries as well as the start and finish time of the queries.
After running that, I only get 1 error:
Warning: Cannot add header information - headers already sent by (output started at /forums/global.php:120) in /forums/gateway.php on line 428
6 group(s) gatewayed.
Logging in to news.tn.comcast.giganews.com, group rec.collecting.cards.discuss
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.pollid,thread.title,post. threadid,thread.forumid FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND post.dateline=thread.dateline AND post.userid=thread.postuserid AND (thread.forumid=26)
Time before: 0.45870900154114
Time after: 0.45999503135681
lifesourcerec
03-01-2002, 06:40 PM
Originally posted by GameCrash
Well... I uploaded the new files from the new post, now I'm getting this message:
1 group(s) gatewayed.
Logging in to news.microsoft.com, group microsoft.public.german.entwickler.dotnet.csharp
Then the script exits (it's now running about 2 seconds). Nothing gets imported...
Running setlastmsg.php returns the following:
1 group(s) gatewayed.
Logging in to news.microsoft.com, group microsoft.public.german.entwickler.dotnet.csharp:
Max: newsgroup
Min: such
The lastmsg in the database stays at 0...
I'll now try the other nntp.php you posted above...
Mine returned as:
6 group(s) gatewayed.
Logging in to news.tn.comcast.giganews.com, group rec.collecting.cards.discuss:
Max: Min: Required
Logging in to news.tn.comcast.giganews.com, group rec.collecting.sport.baseball:
Max: Min: Required
Logging in to news.tn.comcast.giganews.com, group rec.collecting.sport.basketball:
Max: Min: Required
Logging in to news.tn.comcast.giganews.com, group rec.collecting.sport.football:
Max: Min: Required
Logging in to news.tn.comcast.giganews.com, group rec.collecting.sport.hockey:
Max: Min: Required
Logging in to news.tn.comcast.giganews.com, group alt.collecting.autographs:
Max: Min: Required
Heeelp!
Any way to get rid of the "View Profile" link from the NNTP gated messages?
I've playd around but haven't been able to get rid of it without breaking stuff.
Thanks for your help
Mood
Gilby..I'm having lots of fun with your gateway.
Its great.
Just need to remove the link to view the profile and I'm rolling :-)
Thanks for the effort you've put into it....
Mood
Gilby
03-01-2002, 09:56 PM
Originally posted by saab340
I finally got it working :)
My database grew from 13 megs to 300 megs. :(
how many newsgroups are you using? Are they binary newsgroups? If so, you may want to delete some of the attachments.
Gilby
03-01-2002, 09:57 PM
Originally posted by mood
Found my problem.
my test forum is forum ID 3 in the control VB panel yet if I point the URL to forum 3 I get nothing. The test forum showss up with ID 7.
Why ? Pls point me how I can set the forum IDs to the right number...
Thanks
Mood
Just inthe database under the forumid column in nntp_groups set it to 7.
Gilby
03-01-2002, 09:59 PM
lifesourcerec, looks like you do not have the correct login details so it is not allowing you to view a newsgroup.
Gilby
03-01-2002, 10:00 PM
Originally posted by mood
Any way to get rid of the "View Profile" link from the NNTP gated messages?
See this post: https://vborg.vbsupport.ru/showthread.php?postid=222213#post222213
Originally posted by Gilby
See this post: https://vborg.vbsupport.ru/showthread.php?postid=222213#post222213
WOW! That was fast and easy.... Thanks
When I think the hours I spent trying to get Fastforward's stuff to work....and finding all the Perl pm's for Win32...this is a Xmas gift!
THANKS and pls don't stop woorking on this...
Mood
saab340
03-01-2002, 11:34 PM
3 groups no binaries...
15.000 posts... :)
But still, is there a way to remove the lines that start with >
Thanks
Great work
Gilby
03-02-2002, 01:55 AM
Originally posted by saab340
3 groups no binaries...
15.000 posts... :)
But still, is there a way to remove the lines that start with >
You can write a script that will go through each post and remove them and then update it.
saab340
03-02-2002, 02:16 AM
oooohhh... I am not that good.
Is there a way to add that to the code....
I could redownload them all again... since I have cron running I would like to get them stripped then, and not running things twice.
I know there is a way of doing that by using perl, but even my perl would not be able to do so...
would that be hard? ie should I ask custom job for this?
How much would it cost approx?
Gilby
03-02-2002, 02:24 AM
Originally posted by saab340
Is there a way to add that to the code....
I could redownload them all again... since I have cron running I would like to get them stripped then, and not running things twice.
find this:
$message[text] = preg_replace("/((\n[ ]*>[^\n]*)+)/","[ color=blue]\\1[/ color]",$message[text]);
And replace that with this:
$message[text] = preg_replace("/((\n[ ]*>[^\n]*)+)/","",$message[text]);
saab340
03-02-2002, 02:26 AM
Awesome
lifesourcerec
03-02-2002, 03:02 AM
Originally posted by Gilby
lifesourcerec, looks like you do not have the correct login details so it is not allowing you to view a newsgroup.
I use the same login/password info I use in Outlook Express. So, it's the correct info.
Gilby
03-02-2002, 03:06 AM
Originally posted by lifesourcerec
I use the same login/password info I use in Outlook Express. So, it's the correct info.
Try this nntp.php and see what that error message that the nntp server is giving.
lifesourcerec
03-02-2002, 03:12 AM
I get these errors now:
6 group(s) gatewayed.
200 News.GigaNews.Com (Typhoon v1.2.3)
381 More Authentication Required
502 Failed connection to netblock restricted feed 'cc'
480 Authentication Required
ArrayLogging in to news.tn.comcast.giganews.com, group rec.collecting.cards.discuss
200 News.GigaNews.Com (Typhoon v1.2.3)
381 More Authentication Required
502 Failed connection to netblock restricted feed 'cc'
480 Authentication Required
ArrayLogging in to news.tn.comcast.giganews.com, group rec.collecting.sport.baseball
200 News.GigaNews.Com (Typhoon v1.2.3)
381 More Authentication Required
502 Failed connection to netblock restricted feed 'cc'
480 Authentication Required
ArrayLogging in to news.tn.comcast.giganews.com, group rec.collecting.sport.basketball
200 News.GigaNews.Com (Typhoon v1.2.3)
381 More Authentication Required
502 Failed connection to netblock restricted feed 'cc'
480 Authentication Required
ArrayLogging in to news.tn.comcast.giganews.com, group rec.collecting.sport.football
200 News.GigaNews.Com (Typhoon v1.2.3)
381 More Authentication Required
502 Failed connection to netblock restricted feed 'cc'
480 Authentication Required
ArrayLogging in to news.tn.comcast.giganews.com, group rec.collecting.sport.hockey
200 News.GigaNews.Com (Typhoon v1.2.3)
381 More Authentication Required
502 Failed connection to netblock restricted feed 'cc'
480 Authentication Required
ArrayLogging in to news.tn.comcast.giganews.com, group alt.collecting.autographs
Gilby
03-02-2002, 03:18 AM
Originally posted by lifesourcerec
I get these errors now:
That tells me that you can't log in from outside their network. You either need to get another Usenet feed, or set up the script to run from a computer within that network (like installing a local version of vb and the gateway script).
lifesourcerec
03-02-2002, 03:20 AM
Originally posted by Gilby
That tells me that you can't log in from outside their network. You either need to get another Usenet feed, or set up the script to run from a computer within that network (like installing a local version of vb and the gateway script).
Heh, oh well.. guess this won't work for me. Been looking for public usenet servers without success.
lifesourcerec
03-02-2002, 03:40 AM
Originally posted by Gilby
That tells me that you can't log in from outside their network. You either need to get another Usenet feed, or set up the script to run from a computer within that network (like installing a local version of vb and the gateway script).
Found a public server, but it didn't dump the files in the forums.
lifesourcerec
03-02-2002, 04:38 AM
Got it working. IS there a way to filter it to a certain date? Trying to find out how to set showthread to "the beginning" instead of 30 days.
Gilby
03-02-2002, 05:05 AM
Originally posted by lifesourcerec
Got it working. IS there a way to filter it to a certain date? Trying to find out how to set showthread to "the beginning" instead of 30 days.
In the admin control panel, click on modify under the forums and moderators heading. Then click edit next to the forum you want to do this for, and change the "Default view age" to however many days you want.
saab340
03-02-2002, 05:12 AM
This is the best hack. Period
Now I need a provider, that allows me to also post on the groups.
(I only need 3 groups. text only ie not too much bandwith requirements)
Willing to pay for service, but I'll take the free one if one is around.
E-mail me or PM me your suggestion.
Hopefully one that someone has tested this with.
Thanks
lifesourcerec
03-02-2002, 05:23 AM
I found a free one, but the download is SUPER slow. Getting 527 bytes/sec
lifesourcerec
03-02-2002, 06:55 AM
Originally posted by Erwin
I can say that the webdiscuss.com server works with this script. FANTASTIC!!!
The script doesn't work with my ISP's newserver though. I will need to search for a free one...
If you fine a fast free one, let me know. I found one, but getting as low as 448 bytes/sec transfer. Taking forever.
lifesourcerec
03-02-2002, 06:36 PM
I run crobtab crontab.txt , but show this error in e-mail:
/bin/sh: no closing quote
Gilby
03-02-2002, 06:41 PM
Originally posted by lifesourcerec
I run crobtab crontab.txt , but show this error in e-mail:
What's in your crontab.txt?
FEATURE REQUEST:
Gilby,
Now that you have put such a great gateway together, do you think you could add the feature to gate the messages to a mailing list?
THAT would be THE BEST!
Pls contact me "off forum" if you'd like some "extra" support"
Mood
lifesourcerec
03-02-2002, 06:46 PM
25,50 * * * * /usr/bin/lynx -source "http://www.collectorempire.com/forums/gateway.php?log=cron
Gilby
03-02-2002, 06:53 PM
Originally posted by lifesourcerec
25,50 * * * * /usr/bin/lynx -source "http://www.collectorempire.com/forums/gateway.php?log=cron
you are missing the " at the end of that line.
lifesourcerec
03-02-2002, 06:55 PM
Originally posted by Gilby
you are missing the " at the end of that line.
Ok. Thanks :)
Gilby
03-02-2002, 06:58 PM
Originally posted by mood
Now that you have put such a great gateway together, do you think you could add the feature to gate the messages to a mailing list?
THAT would be THE BEST!
Actually, I was thinking of doing something of that sort, although, I'm working on other projects at the moment and that may be a ways away. A lot of the code from this hack can be used for that. Maybe i'll take a look at it now and see if it's really easier than I expected.
saab340
03-02-2002, 11:57 PM
I dont know what happened, but all my posts start with []
(Brackets in fromt of all the post that goes to the usenet)
It shows fine on my forum (Without the brackets)
Which line specifies the heading?
Only think I modified was the signature, and remove the > >> >>> stuff.
Thanks
Otherwise its working great :)
Help me out with this issue, since replies are generated in new threads.... Otherwise it would not matter.
This is my signature edit:
function sendnews($newthread, $isreply=false){
global $settings, $group, $prefix, $news, $DB_site, $msgid_date;
// get user's signature
if ($newthread[userid]){
$get_userinfo=$DB_site->query("SELECT signature,usertitle,customtitle FROM user WHERE userid=$newthread[userid] LIMIT 1");
$userinfo=$DB_site->fetch_array($get_userinfo);
// $signature = "\n--\n";
// $signature .= $newthread[username];
// if ($userinfo[customtitle]){ $signature .= " - $userinfo[usertitle]"; }
// if ($userinfo[signature]){
$signature .= "\n";
// $signature .= format_text($userinfo[signature]);
// }
$signature .= "\n http://www.test.com \n";
// $signature .= "$newthread[username]'s Profile: $settings[profileurl]$newthread[userid]\n";
$signature .= "View this thread: $settings[threadurl]$newthread[threadid]\n";
} else {
$userinfo = false;
// $signature = "\n--\n".$newthread[username]." - Unregistered User"; $signature .= "\n------------------------------------------------------------------------\n";
$signature .= "View this thread: $settings[threadurl]$newthread[threadid]\n";
}
and this is to remove the >>> stuff :)
//$message[text] = preg_replace("/((\n[ ]*>[^\n]*)+)/","$1",$message[text]);
$message[text] = preg_replace("/((\n[ ]*>[^\n]*)+)/","",$message[text]);
//$message[text] = preg_replace("/((\n[ ]*>[ ]*>[^\n]*)+)/","$1",$message[text]);
//$message[text] = preg_replace("/((\n[ ]*>[ ]*>[ ]*>[^\n]*)+)/","$1",$message[text]);
$message[text] = preg_replace("/((\n[ ]*>[ ]*>[^\n]*)+)/","",$message[text]);
$message[text] = preg_replace("/((\n[ ]*>[ ]*>[ ]*>[^\n]*)+)/","",$message[text]);
Those are only changes I made, and now all my posts start with:[]
Any idea why?
Gilby
03-03-2002, 12:04 AM
Are the brackets in the body or the subject?
saab340
03-03-2002, 12:11 AM
subject
Gilby
03-03-2002, 12:21 AM
Originally posted by saab340
subject
OK then, make sure that everything in the prefix column is set to NULL.
This SQL will do the trick:
UPDATE nntp_groups SET prefix = NULL
nafae
03-03-2002, 12:22 AM
Ok so I think I did everything right, but then again I am not sure... Gilby can I get you to check out my server for me and check and see if you can tell what the problem is? I am sketchy at best with this sql stuff...
Gilby
03-03-2002, 12:31 AM
Originally posted by nafae
Ok so I think I did everything right, but then again I am not sure... Gilby can I get you to check out my server for me and check and see if you can tell what the problem is? I am sketchy at best with this sql stuff...
What/Where do you want me to look at?
saab340
03-03-2002, 12:33 AM
Also I just remembered, I changed the time to show correct time... ie not time when cron (ie when downloaded)
and I see that some of the posts which are replied... ie Re: something
will show in different posts. What is the cause of this? time issue?
Thanks (Gilby You are doing a great job)
this is the mod for time....
// if ($group[lastmsg] == 0){
$date = strtotime($message[date]);
//} else {
//$date = time();
//}
nafae
03-03-2002, 12:34 AM
well, I installed it and set for alt.comp.programming 31 0 (usenet url) NULL NULL 1 under nntp-groups, then I run gateway.php, it downloads a file that sayes
1 group(s) gatewayed.
Logging in to (usenet).com, group alt.comp.programming
but when I check forum 31 (http://www.coderforums.net/forumdisplay.php?s=&forumid=31) nothing appears there...
Gilby
03-03-2002, 12:43 AM
Originally posted by nafae
well, I installed it and set for alt.comp.programming 31 0 (usenet url) NULL NULL 1 under nntp-groups, then I run gateway.php, it downloads a file that sayes
1 group(s) gatewayed.
Logging in to (usenet).com, group alt.comp.programming
but when I check forum 31 (http://www.coderforums.net/forumdisplay.php?s=&forumid=31) nothing appears there...
Is the script running from the same network as your nntp server?
nafae
03-03-2002, 12:43 AM
no, my nntp server is the one that my isp uses
Gilby
03-03-2002, 12:45 AM
Originally posted by saab340
Also I just remembered, I changed the time to show correct time... ie not time when cron (ie when downloaded)
and I see that some of the posts which are replied... ie Re: something
will show in different posts. What is the cause of this? time issue?
Thanks (Gilby You are doing a great job)
this is the mod for time....
// if ($group[lastmsg] == 0){
$date = strtotime($message[date]);
//} else {
//$date = time();
//}
With that code change, youdon't get a parsing error? You commented out the } which should produce a parse error, unless you added one somewhere else. Uncomment that and see if you still have problems.
Gilby
03-03-2002, 12:47 AM
Originally posted by nafae
no, my nntp server is the one that my isp uses
Most ISPs will not allow you to access the server from outside the network of the ISP. They only allow local users to use their news server. You may be able to use it if you put in your username and password that you use with that ISP.
nafae
03-03-2002, 12:50 AM
so the next step would be, assuming that I can't access my isp's usnet group... I purchase a username to another usenet server? What are the typical prices and where can I buy a usenet account :confused:
Gilby
03-03-2002, 12:55 AM
Originally posted by nafae
so the next step would be, assuming that I can't access my isp's usnet group... I purchase a username to another usenet server? What are the typical prices and where can I buy a usenet account :confused:
You can check with your webhost to see if they have a usenet server you can use. You can install php on your home computer and run the gateway script from there (connecting to your servers mysql database), or you can get a usenet account. Typically, they cost under $10 a month. I haven't used any of them though, but just do a search in google for them and you should have no problem finding one.
nafae
03-03-2002, 12:57 AM
ok, thanks for your help.
saab340
03-03-2002, 01:05 AM
remove // from } ?
I did this like you suggested early on, to show correct thread date...
I dont understand? It seems correct.
Please confirm.
Gilby
03-03-2002, 01:15 AM
Originally posted by saab340
Also I just remembered, I changed the time to show correct time... ie not time when cron (ie when downloaded)
and I see that some of the posts which are replied... ie Re: something
will show in different posts. What is the cause of this? time issue?
Ignore my last thing... I just saw it wrong. What exactly is happening? Which of the times that you used "posts" above should it be "threads"?
saab340
03-03-2002, 01:24 AM
My problems are [] listed right before each post on the topic, and when replied... they will show up on a different post.
some Re: posts also show as a different topic.
Gilby
03-03-2002, 01:30 AM
Originally posted by saab340
My problems are [] listed right before each post on the topic, and when replied... they will show up on a different post.
some Re: posts also show as a different topic.
That shouldn't be happening. Is the prefix column in the thread table set to default to NULL? If not, change it to do that.
Otherwise, if all else fails, we can hardcode it to not use my undocumented feature for you:
Change:
if ($prefix[$newthread[forumid]] and !$isreply){
$cat = "[".$prefix[$newthread[forumid]]."] ";
} elseif ($isreply and $newthread[prefix]) {
$cat = "Re: [".$newthread[prefix]."] ";
} elseif ($isreply){
$cat = "Re: ";
} else { $cat = ''; }
Into this:
if ($isreply){
$cat = "Re: ";
} else { $cat = ''; }
saab340
03-03-2002, 01:55 AM
I hard coded it like this, and now all my posts start with "Re:" even if its a new post... so definately something there about is wrong... I checked and its all original, nothing modded there.
Gilby
03-03-2002, 02:11 AM
Originally posted by saab340
I hard coded it like this, and now all my posts start with "Re:" even if its a new post... so definately something there about is wrong... I checked and its all original, nothing modded there.
Did it work fine before you made any edits to the hack?
saab340
03-03-2002, 02:21 AM
Well its working now... I dunno.... onlu thing I changed that I started posting from main forum, and not from post page itself.
:)
saab340
03-03-2002, 02:45 AM
This is a cool hack, but its little over my head right now...
I think I might have some SQL issues...
I am missing some original posts... (I think they might be somewhere in my SQL... even tough I cleaned up the tables, by removing all the posts with isusenetpost =1 ... also cleaned up the index, and rebuilt it too. Is there something else I should have done?
floleb7
03-03-2002, 04:51 AM
<a href="http://www.latriade.net/newsgroup/showthread.php?threadid=6862" target="_blank">http://www.latriade.net/newsgroup/sh...?threadid=6862</a>
quotes are in blue how i can put quote in white ? (or in font color of the theme )
lifesourcerec
03-03-2002, 05:19 AM
Originally posted by saab340
This is a cool hack, but its little over my head right now...
I think I might have some SQL issues...
I am missing some original posts... (I think they might be somewhere in my SQL... even tough I cleaned up the tables, by removing all the posts with isusenetpost =1 ... also cleaned up the index, and rebuilt it too. Is there something else I should have done?
Heh, I wish that was my problem. When running "prune messages", it completely crashes MySQL.
saab340
03-03-2002, 01:06 PM
Quick question, is there a way to prevent soome useres posting not being downloaded.
I have this one user, who keeps postiing the same thing over and over again, and I would like to block his posts being downloaded.
Gilby
03-03-2002, 05:04 PM
Originally posted by saab340
Quick question, is there a way to prevent soome useres posting not being downloaded.
I have this one user, who keeps postiing the same thing over and over again, and I would like to block his posts being downloaded.
I don't have any filters or replacements set up yet in the script. You may want to just change his permissions to not be able to post to that forum.
(I assuming the problem poster is posting on the forums?)
wot-Mike
03-03-2002, 07:54 PM
Stupid question, but in the nntp_settings table, the Email address domain,
do I need to put the domain name there (like mydomain.com), or
do I need to specify a full emailaddress (like us@ourdomain.com)
Originally posted by wot-Mike
Stupid question, but in the nntp_settings table, the Email address domain,
do I need to put the domain name there (like mydomain.com), or
do I need to specify a full emailaddress (like us@ourdomain.com)
Domain Name is enough
Mood
wot-Mike
03-03-2002, 07:59 PM
Thanks for the extremely fast reply :D
Now to get this thing to post...
The Realist
03-03-2002, 08:26 PM
Installed this hack and all I am getting when I run the gateway.php file is:
NNTP (Usenet/Newsgroup) Gateway
And thats it.
No newsgroup posts are posted in my forums?
Why........ anyone!
Brian
saab340
03-04-2002, 01:24 AM
I am Interested with some filter capability when it comes available...
Also just noticed some of the posts coming from usenet groups have 4 identical replies from same guy.
ie if original post have 3 guys participated, mine shows I have 12 posts 4 each ???
What would cause this? Its happening with posts that have appx 10-20 posts.
Erwin
03-04-2002, 08:18 AM
NOTE to all having problems connecting with the news server - you need to try another news server. I have tried a few of the free public ones - not all of them work.
This hack DOES WORK. You just need to find the correct news server. I have been using this hack on the day it was released, and it has not stopped working yet. The only time it stops working is when my free news server changes IP addresses - I just need to keep up!
Well done, Gilby, for one of the best hacks for VB!
Erwin
03-04-2002, 08:19 AM
Also, some of the free news servers allow READING only, NO POSTING (so you can download posts but cannot upload posts). Others allow POSTING only, NO READING (so you can login but no posts get downloaded, while you can upload posts).
Just shop around... ;)
lifesourcerec
03-04-2002, 02:38 PM
Originally posted by Erwin
NOTE to all having problems connecting with the news server - you need to try another news server. I have tried a few of the free public ones - not all of them work.
This hack DOES WORK. You just need to find the correct news server. I have been using this hack on the day it was released, and it has not stopped working yet. The only time it stops working is when my free news server changes IP addresses - I just need to keep up!
Well done, Gilby, for one of the best hacks for VB!
It works great, but I removed it because while trying to delete about 50,000 old posts downloaded, it kept crashing the MySQL server.I do a mass prune, it works for a couple of minutes, then MySQL crashes.
GameCrash
03-04-2002, 02:43 PM
Next time, you should set the initial post numer to a higher value so you don't get so much posts ;)
wot-Mike
03-04-2002, 03:00 PM
Originally posted by Erwin
NOTE to all having problems connecting with the news server - you need to try another news server. I have tried a few of the free public ones - not all of them work.
This hack DOES WORK. You just need to find the correct news server. I have been using this hack on the day it was released, and it has not stopped working yet. The only time it stops working is when my free news server changes IP addresses - I just need to keep up!
Well done, Gilby, for one of the best hacks for VB!
I wonder about the legality of just connecting to any news-server that happens to allow posting to anyone, or even reading. I haven't found a single site that actually advertises with "hey, you can post all you want though our newsserver".
That's the thing that bugs me about this.
Originally posted by wot-Mike
I wonder about the legality of just connecting to any news-server that happens to allow posting to anyone, or even reading. I haven't found a single site that actually advertises with "hey, you can post all you want though our newsserver".
That's the thing that bugs me about this.
Although this is Off Topic as well: NNTP is about enormous bandwidth & storage strain. If a service is free - who pays for the boxes? Most of the free Usenet is either school financed, underground or newbies wanting to run a server and suddenly noticing that their 80 GB IDE drive has been filled in a few hours.
If you translate the time you spend trying to find a free server to $$ you'd be able to afford any premium service out there. My count works like this: 1.5 beer less per week will pay for my NNTP account for a year :-)
Mood
wot-Mike
03-04-2002, 03:38 PM
Not sure if this is entirely off topic :)
But any suggestions are welcome regarding paid services
Robert Basil
03-07-2002, 12:24 PM
I've got the hack installed (It's working GREAT thanks!)
The only thing I cannot figure out is how to pull a second newsgroup feed into different forum.
Any hints?
Gilby
03-07-2002, 12:47 PM
Originally posted by Sportbikeworld
I've got the hack installed (It's working GREAT thanks!)
The only thing I cannot figure out is how to pull a second newsgroup feed into different forum.
Any hints?
Add another row in your nntp_groups table with the appropriate settings.
Robert Basil
03-08-2002, 04:17 AM
Gilby,
Thanks for all of your help. We are now pulling in 4 newsgroups every 10 minutes. (We have a very busy forum)
By the way, for a newsgroup feed I highly reccomend http://www.newsranger.com Can't be beat for only $4.95 a month.
v0nreagan
03-08-2002, 10:40 AM
Hey Gilby
Suggestion for quick mod:
if you use old thread.isusenetpost trick admins can exclude at will (easy mod in search.php) usenet posts from appearing in "View new posts" (some users may prefer not to see 1000s of messages from usenet groups in there).
Robert Basil
03-08-2002, 04:19 PM
Originally posted by v0nreagan
Hey Gilby
Suggestion for quick mod:
if you use old thread.isusenetpost trick admins can exclude at will (easy mod in search.php) usenet posts from appearing in "View new posts" (some users may prefer not to see 1000s of messages from usenet groups in there).
This would be a good addition.
The Realist
03-08-2002, 09:29 PM
Dont know if its my end or what, but when I run this:
http://www.skytronic-forums.com/forum/gateway.php
I get this (screen shot)
Anyone now what the problem?
Sanjiyan
03-08-2002, 10:34 PM
Quick question gilby as I havent seen you on MSN for ages, does this work with 2.2.3b ?
Thanks
Oh BTW, how do I get the gateway.php to give me the nntp code feed back like it used to?
Gilby
03-08-2002, 11:20 PM
Originally posted by The Realist
Anyone now what the problem?
For starters, you're using IE. ;) IE thinks it's smart and does what it wants to do, instead of what the headers tell it to do. Anyways, I would guess you don't have your mime types set up correctly to display the text in the browser instead of elsewhere. So try fiddling around with the settings in IE.
Gilby
03-08-2002, 11:22 PM
Originally posted by Sanjiyan
Quick question gilby as I havent seen you on MSN for ages, does this work with 2.2.3b ?
I would assume it does work, but i have not tried it yet. I don't think the database changed much in the new version.
Originally posted by Sanjiyan
Oh BTW, how do I get the gateway.php to give me the nntp code feed back like it used to?
Put an echo in front of all the lines that start with $request and it'll print it out.
Picolet
03-10-2002, 09:14 PM
"
Most ISPs will not allow you to access the server from outside the network of the ISP. They only allow local users to use their news server. You may be able to use it if you put in your username and password that you use with that ISP."
So is there a way to login using your username and password to your ISP news server?
How do you include username and password I do not se anywhere in the settings to set those......
Gilby
03-10-2002, 09:19 PM
Originally posted by Picolet
So is there a way to login using your username and password to your ISP news server?
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.
Originally posted by Picolet
How do you include username and password I do not se anywhere in the settings to set those......
In the nntp_groups table, there is a column for the username and one for the password.
Brian Cruz
03-10-2002, 09:40 PM
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.
Gilby
03-10-2002, 09:44 PM
Originally posted by Brian Cruz
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.
Brian Cruz
03-10-2002, 09:57 PM
Originally posted by Gilby
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!
Picolet
03-10-2002, 10:46 PM
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!
antigravityboy
03-11-2002, 07:19 AM
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
Gilby
03-11-2002, 02:44 PM
Originally posted by antigravityboy
mysql error: Unknown column 'thread.prefix' in 'field list'
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.
antigravityboy
03-11-2002, 06:32 PM
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
Gilby
03-11-2002, 06:47 PM
Originally posted by antigravityboy
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.
Sanjiyan
03-11-2002, 06:56 PM
Originally posted by Gilby
I would assume it does work, but i have not tried it yet. I don't think the database changed much in the new version.
Put an echo in front of all the lines that start with $request and it'll print it out.
the word echo or a @ ?
thicko here when it comes to php you know and which php file ?
antigravityboy
03-12-2002, 07:51 AM
Thanks Gilby
I did what you said with the sql and everything seems to be working now.
I have another question that I know if kind of dumb, but I cannot figure it out. If I want to make a new forum in my control panel, how to I set the forum ID so that I can pipe the newsgroup posts into it . The only setting I could find to change was the order and they all seem to be set to 1
Thanks again
Sanjiyan
03-12-2002, 08:55 AM
Originally posted by antigravityboy
Thanks Gilby
I did what you said with the sql and everything seems to be working now.
I have another question that I know if kind of dumb, but I cannot figure it out. If I want to make a new forum in my control panel, how to I set the forum ID so that I can pipe the newsgroup posts into it . The only setting I could find to change was the order and they all seem to be set to 1
Thanks again
If you hover over the forum title in the Admin CP you will see something like this:
http://wocs.net/forumdisplay.php?forumid=60
The forum ID is mentioned at the end of the link
eg: forumid=60
Thats where you get the forum ID from, all you do then is enter that number into the MySQL database in the relevent section.
Hope this answers your question.
Andrew
Sanjiyan
03-12-2002, 08:56 AM
Originally posted by antigravityboy
Thanks Gilby
I did what you said with the sql and everything seems to be working now.
If I want to make a new forum in my control panel, how to I set the forum ID
Thanks again
I dont think you can alter or choose the forumid, the vbulletin software does that for you, if you do find away tho, give me a shout, cos my forumsids are in the 60 - 80 range, and I only have around 12 forums.
antigravityboy
03-12-2002, 09:06 AM
Thanks for the reply Sanjiyan
I never understood where they got the forum Id's before.
I fixed the forum ID and ran went to the gateway.php in my browser, but it does not seem to pipe anything in, I just get this on the white screen and nothing more. Any ideas on what else I need to do, sorry to be such a pain
1 group(s) gatewayed.
Logging in to east.usenetserver.com, group alt.binaries.nude.celebrities.female
Picolet
03-12-2002, 01:26 PM
<a href="http://www.africaplanet.com/" target="_blank">http://www.africaplanet.com/</a>
Success, I was able to successfully install this hack with vbulletin 2.2.4 version. You can see it in action at the above URL
Picolet
03-12-2002, 03:02 PM
<a href="https://groups.google.com/groups?" target="_blank">http://groups.google.com/groups?</a>
Anyway to download and display forums based not just on a particular newsgroup but refined more by topic/word search as
is possible through doing a search at google?
Gilby
03-12-2002, 05:34 PM
Originally posted by Picolet
http://groups.google.com/groups?
Anyway to download and display forums based not just on a particular newsgroup but refined more by topic/word search as
is possible through doing a search at google?
Do you mean from all newsgroups? Or posts just from one newsgroup? If the first, I am not aware of anything in the NNTP specifications that allow searching, but maybe there is. If there isn't, you'll have to download all newsgroups you want to search through and throw out the irrelevant posts.
If just in the one newsgroup you want to narrow it down, then you'd just throw out the irrelevant posts. I have not implimented anything to do this yet though.
Picolet
03-12-2002, 05:51 PM
See the google search feature for the newsgroups.
I included a link to it!
Gilby
03-12-2002, 06:21 PM
Originally posted by Picolet
See the google search feature for the newsgroups.
I included a link to it!
Does that mean you want it for all newsgroups? Then just set up all the newsgroups with this script! ;) Oh and if you do that, please let me know how the script handles that many posts. :)
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.