[muukis]

Originally Posted by cns Is it possible to use this with several servers at the same time and get a clear indication of which server the message is coming from in the log?

By using the provided example web interface, you just have to specify an unique id to each game server and configure them to log the messages to the same database. Your web interface will then display multiple chat views.

You should be able to specify the IDs like this for example: "My Ultimate Pro L4D Server" and "My Sisters Counter-Strike: Source Dollhouse".

[cns]

Perfect, thanks a lot

[Icettiflow]

EDIT: I apologize, this was my fault. I did not drop the table from the original chat log so the columns required by the new plugin were not in place.

Thanks for the great addition to an already great plugin!

[anon666]

Originally Posted by muukis I'm not sure if that'll fix the DST "problem"?

I was replying to waertf's post from the previous page. Didnt realise that there was a next page after that along with the fix

[cns]

I don't have any concrete evidence that the following is caused by this plugin but it started happening after I installed this. It could be virtually anything but I just want to ask if anyone may have experienced the same thing!


Left 4 Dead Server.

Occasionally (and lately it has happened more often than I'd like) my server has stopped responding after a map change (happened for me twice in a row on second and third map change respectively). Monitoring the server with rcon tool etc. shows that the servers lags out for a good 30 seconds before returning with the "ghosts" of all the players that were on the server, they then gradually all timeout due to no steam logon. In reality their client has timed out already obviously.

.. but this tells me that the server may be forced into a nasty loop or something on map change since it doesn't outright crash.

Once again, not sure if it's related to this plugin - I have a few plugins on my server by now.

[muukis]

Originally Posted by cns I don't have any concrete evidence that the following is caused by this plugin but it started happening after I installed this. It could be virtually anything but I just want to ask if anyone may have experienced the same thing! Left 4 Dead Server. Occasionally (and lately it has happened more often than I'd like) my server has stopped responding after a map change (happened for me twice in a row on second and third map change respectively). Monitoring the server with rcon tool etc. shows that the servers lags out for a good 30 seconds before returning with the "ghosts" of all the players that were on the server, they then gradually all timeout due to no steam logon. In reality their client has timed out already obviously. .. but this tells me that the server may be forced into a nasty loop or something on map change since it doesn't outright crash. Once again, not sure if it's related to this plugin - I have a few plugins on my server by now.

I have not encountered this at my server. How often does this happen at yours? Once a day/week/month? You could try running the server without this plugin for a while to see if it acts any better?

[cns]

I've removed your plugin for now but I've also taken some other plugins down, pretty high priority for me that none of my servers does this - and like I said, it could be any of my plugins..

Anyway, I noticed something weird happening with the chatlog recently.. Let me paste some MySQL entries..

26932, 'L4D:R1', 2009-05-23 22:50:18, 'Console', '', 'e of thePlayer CARTOON599 connected', 10, -1

26838, 'L4D:2', 2009-05-23 22:45:45, 'Console', '', '', 10, -1

26818, 'L4D:10', 2009-05-23 22:44:19, 'Console', '', ' all can spawn', 10, -1

26667, 'L4D:1', 2009-05-23 224:42, 'Console', '', ' bad', 10, -1

26628, 'L4D:R1', 2009-05-23 221:58, 'Console', '', 'son lol', 10, -1

26241, 'L4D:R1', 2009-05-23 22:10:25, 'Console', '', 'no medpack', 10, -1

26177, 'L4D:10', 2009-05-23 22:08:09, 'Console', '', 'MENT PRIPlayer Mapoja The SKÄGG connected', 10, -1

26161, 'L4D', 2009-05-23 22:077, 'Console', '', 'ichtig fPlayer ACTION connected', 10, -1

Some join messages were displaying as console along with player messages.

[muukis]

Originally Posted by cns I've removed your plugin for now but I've also taken some other plugins down, pretty high priority for me that none of my servers does this - and like I said, it could be any of my plugins.. Anyway, I noticed something weird happening with the chatlog recently.. Let me paste some MySQL entries.. 26932, 'L4D:R1', 2009-05-23 22:50:18, 'Console', '', 'e of thePlayer CARTOON599 connected', 10, -1 26838, 'L4D:2', 2009-05-23 22:45:45, 'Console', '', '', 10, -1 26818, 'L4D:10', 2009-05-23 22:44:19, 'Console', '', ' all can spawn', 10, -1 26667, 'L4D:1', 2009-05-23 224:42, 'Console', '', ' bad', 10, -1 26628, 'L4D:R1', 2009-05-23 221:58, 'Console', '', 'son lol', 10, -1 26241, 'L4D:R1', 2009-05-23 22:10:25, 'Console', '', 'no medpack', 10, -1 26177, 'L4D:10', 2009-05-23 22:08:09, 'Console', '', 'MENT PRIPlayer Mapoja The SKÄGG connected', 10, -1 26161, 'L4D', 2009-05-23 22:077, 'Console', '', 'ichtig fPlayer ACTION connected', 10, -1 Some join messages were displaying as console along with player messages.

I am sorry to say that I have no clue what is causing the problem. The ChatLog might very well be the cause, but I don't know why would it do this. Your ChatLog entries are broken. They might show somewhat correctly on your web interface, but they're not correct. The second value should be Steam ID for instanse. It is found using SourceMods GetClientAuthString(client, authid, sizeof(authid)); -call. Your ChatLog is acting very strangely. Try installing the original 1.2 plugin and see if it logs the same way. You can use the same DB. It just won't log the extended plugin messages. Just remember to add the sm_chatlog_id correctly, since the old plugin does not know the extended configurations.

Try this plugin. It is the same as the one on first post, but I added a line so that when ever a player types a chat message, you should get a message on game server console what the Steam ID was on the player right after the function call.

[cns]

I'm posting the SourceMod error log from Friday, there are some things I think may help you - it looks like the plugin may be having problems with certain names. Not that it would have anything to do with the crashing but it could explain the borked database entries?

(Compressed it, sorry but it exceeded the allowed file size!)

[muukis]

I'm sorry I read your DB entries incorrectly previously. They seem fine from the Steam ID part (it was actually your Server ID ).

Originally Posted by cns I'm posting the SourceMod error log from Friday, there are some things I think may help you - it looks like the plugin may be having problems with certain names. Not that it would have anything to do with the crashing but it could explain the borked database entries? (Compressed it, sorry but it exceeded the allowed file size!)

Tried calling that one query that seemed to fail (the one with "PoleS وخز الØ*مار اÙ" as player name), but it did run at least directly from MySQL console.

INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('PoleS   وخز الØ*مار اÙ', 'STEAM_1:0:XXXXXX', 'narazie', 3, 'L4D:3', 3)

For some reason your MySQL or SourceMod can't handle queries with strings containing character 'Ù' (hex: D9). Can you run that query from your MySQL console?

What version of SourceMod are you running?

EDIT: For the other part of the problem (GetEventString error) - I'm looking into it. Thanks for taking it out in the open