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 08:49 PM

Quote:

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

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

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

Quote:

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.

dost 02-21-2002 09:27 PM

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

Quote:

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

Quote:

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

Quote:

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

Quote:

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


All times are GMT. The time now is 11:29 AM.

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.01659 seconds
  • Memory Usage 1,747KB
  • 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
  • (2)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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