Questions? Post them here.

[TitoTheBandito]

"What was wrong was that the mod name was either to long or it contained '(' ')' not sure which one it was."

Suuuuure....blame it on Kirby

[Lanthar D'Alton]

nope. works fine with win98. Check the database table itself.... see if what you are saying is indeed getting into the database. If it is, there are a few possible problems.

1: There may be so many speech entries that it is overflowing the listener in the server.
2: The query may be having trouble with your database somehow.
3: The listener may be connecting to the wrong set of tables based on your odbc connection settings.

Get ICQ. Send me a message (icq#7349572) and I'll see about remote connecting to figure it out.

-Lanthar

[AChi]

Well I had it working for about 3 days. Then I had a server crash due to xp.. bleh. got to eventualy put on linux.

Now when the server boots up I get a TMI error in lds_spch_runonce and it stops working. I think it may be that there is to much in the table.. over 8000 rows.

I was wondering what you thought if I made it destroy and create the table after each reset it may fix the problem.

Think this might work?

It will be a bit before I actualy test it.

[AChi]

I have just found out what I thought is not the case. I tried the Talus speech setup on my test server and had an external player join. They could use the emote system.


So.. any ideas whats causing the TMI error? Its happening when it runs off the IPList stand.

[Lanthar D'Alton]

welp, first of all, 8000 rows is too much. open mysql control center and clear that out.

Clearing it every time mod loads is perfectly fine. That table is just a staging point for text, so clear it at mod load if you want. Amusingly, I just did that on my own module after a lagging crash caused 15-20 players to send me 20 messages each and fill it up before they got disconnected. (Lag causes players to double-send text).

Anyway... the reason the others are okay, but you are not, is probably one of 2 things:
1: you failed to connect by the gamespy list.
2: you connected to your server then launched the listener.

-Lanthar

[Lanthar D'Alton]

Also, worth noting, that table should be cleared by the server itself anyway, but at 8000 rows, it just causes the script to croak on a tmi and then nothing else will happen.

-Lanthar

[Lanthar D'Alton]

Well, I spent a bit of time trying to figure out where it was failing, but couldn't really run all the tools I'd like to, and after installing mysql control center, and examining the module, and seeing that the database wasn't getting the "servername" field filled in, I decided that since he only planned to run the one server, I'd just hack the lds_speech_db file and remove
WHERE servername='"+sServer+"'
from the query so it would just take all the entries for itself. This is an acceptable solution for those of you having troubles with the servername not getting filled, and only wanting to run one server per database.

Worth noting, I think it might be because the module's language was not set, but with no toolset on that machine, and swapping between his two machines over remote desktop, and an hour and a half having passed, I opted for the simple fix and just changed that query...

-Lanthar

[TitoTheBandito]

And I couldn't be happier I love this system already and I haven't even begun to implement it in my mod. I'll be sure to let you know when I do so you can check it out if you want. I have a bulletin board, banker, etc to merge it with as well as a trashman that will soon respond to "Hey! Put that down, Packrat Bob!" haha
I'll also have passwords, magic words, maybe even a town gossip that parrots things that people say around him/her. I can't wait to get into this.

BTW, I told my wife about your PW and she stopped in to check it out. I think I might have just lost my builder

[AChi]

Just a little update. They are working again and I have added the command

SQLDirective("TRUNCATE TABLE 'nwn_speech'");

Well whatever the correct spelling for the directive command is.

To the module load. This should clear out the table without destroying and recreating it.

Thanks for your help.

[f0ul cr0w]

I've successfully used your system before on a server I ran a while back, but now I'm just making sure of a couple questions.

I am running the server and client on the same machine right now, and therefor am unable to use the system myself, but as I recall the other players could enjoy it. I check my odbc log and see that I when it does the select from nwn_speech, nothing is ever returned, and I know that's because there's nothing in the table. My question is: Is there nothing in the table because it's not picking up anything I say? I've glanced through the scripts, but am uncertain as to what exactly goes into the table. Does everything said get inserted into the table, and then deleted shortly after? So that if other players were in the module, it would pick up what they say?

[Lanthar D'Alton]

Basically it uses the table as a staging point for the text. The listener captures things people say and puts them into the database, and nwnx pulls all speech out of the database once a second. As for using your client and running the server, you can do this... you just have to connect to your server using the gamespy server listings.

Also, yes, the server scripts pull all the speech out of the database and delete it, so, that table should be emptied once a second.

-Lanthar

[f0ul cr0w]

Hmmm. Well, I've tried connecting through the gamespy list, my history page, direct connecting, every way I know of. It still never picks up what I say. By gamespy list, you do mean the in-game list, right? If so then yeah, I've tried that many times.

Will it immediately begin picking up what is said when the module loads? Or do I have to wait for the DelayCommand() to fire?

[Lanthar D'Alton]

Are you launching the talus listener.exe program too? That needs to be running alongside the server at all times. Also, yes, you're speech won't be used by the server until that delaycommand fires.

-Lanthar

[Xargoth]

I tried to do a search on the forums but there was no answer IMO...

Is it by any chanses possible to port the TSRS to Linux..?
I know many ppl running linux servers that would need a tool just like this...

If someone hasn't ported it yet, i'm gonna try to do so... Just checking that i'm not gonna try it if someone has done it already...
_______

Xargoth, Co-Admin of Antiworld Arena

[Lanthar D'Alton]

A few said they would do so, but they never did that I know of. It can't be too hard to find some code that does a network sniffer and plug the code I wrote into it. Let me know if you need assistance. Oh, and keep in mind that port numbers are Big-Endian.

-Lanthar