[Gilby]

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.

[ART]

thanx Gilby for the work!
all went smooth

[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

[annams]

Originally posted by Gilby


Whereever you find:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Replace it with:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

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]

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/sho...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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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.dateline,post.attachmentid,post.paget ext,post.showsignature,post.ipaddress,thread.pollid,thread.title,post.threadid,t hread.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