vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   NNTP Gateway (Usenet/Newsgroups) (https://vborg.vbsupport.ru/showthread.php?t=35247)

Gilby 02-21-2002 01:04 PM

Quote:

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

Quote:

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

Quote:

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

Quote:

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:
Code:

                        // if ($group[lastmsg] == 0){
                                $date = strtotime($message[date]);
                        //} else {
                                //$date = time();
                        //}


Sanjiyan 02-21-2002 01:21 PM

Quote:

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

Quote:

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:
Code:

$signature .= "$newthread[username]'s Profile: $settings[profileurl]$newthread[userid]\n";
Quote:


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.

Quote:


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.

Quote:


In fastforwards hack the quoted text appeared in italics, any way to do that here?

Yeah, find this line:
Code:

$message[text] = preg_replace("/((\n[ ]*>[^\n]*)+)/","$1",$message[text]);
and replace it with this:
Code:

$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

Quote:

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:
Code:

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.

dost 02-21-2002 06:16 PM

Quote:

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 :)


All times are GMT. The time now is 04:30 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02027 seconds
  • Memory Usage 1,803KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_code_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete