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-27-2002 08:39 PM

Quote:

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

Quote:

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.

Quote:


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

Quote:

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

Quote:

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

Quote:

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

mood 03-01-2002 01:02 PM

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

mood 03-01-2002 01:17 PM

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

Quote:

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


All times are GMT. The time now is 09:30 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.02174 seconds
  • Memory Usage 1,751KB
  • 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
  • (7)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