Chat, GUID, Stats and Mapstats Logger[3.0.2.2] 01.02.

[ImportBot]

Originally Posted by feeblemedic*:

 

I was wanting to run say monthly stats for my servers, then restart at the new month with 0 stats.

 

1) I can just create a new database and user etc.... and then replace that info in the plugin and restart and that should be fine for the new stats right?

 

2) Is there a way to take my stat databases for each month and compile them into a database with all the stats, then at the end of the month, add the stats to that larger database? So I would have one database for stats each month and then have "Complete" Database with all the stats....combine databases?

 

Let me know how possible this is, thanks.

[ImportBot]

Originally Posted by XpKiller*:

 

The first thing is quite simple just drop the tables tbl_playerstats and tbl_weaponstats to reset the stats

The second point is more difficult because you need a script which merges the tables the right way especially for the weapons table the script would be very long due the amount of columns in this table.

[ImportBot]

Originally Posted by XpKiller*:

 

New Version 3.0.2.2

 

Changelog:

3.0.2.2

Fixed Bug that a player is not in the Database because he got kicked be the the cheaterprotection

Improved BFBCS Statsfetch by packing multiply players in one query to bfbcs. The Plugin waits now until the minimum playercount is reached

This optimization can be disabled by setting the the Request Packrate to 0.

Recommend values are 2-3 or higher.

 

If you use the value you will get less errors by bfbcs API

[ImportBot]

Originally Posted by IceNine*:

 

Why is TimeRoundEnd left as 0 in the map data? I would like to know how long each round lasts so that the ticket count may be adjusted per map.

[ImportBot]

Originally Posted by IceNine*:

 

Well I put a temporary fix in for the lack of TimeRoundEnd but it's a bit of a bandaid. I just edited the line that inserts the map details in SQL to always write the current time instead of using the TimeRoundEnd variable. This isn't exact but it's working well as a temporary workaround since the last time this is written is right after the end of the round.

 

If you could fix this it would be appreciated though since your next update will remove my workaround.

 

Thanks,

IceNine

[ImportBot]

Originally Posted by terwax*:

 

Code:

00:10:43 46] Error in SQLQuery in Case 8:  System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.52]Lost connection to MySQL server during query
   --- End of inner exception stack trace ---
   at System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception innerException)
   at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)

[ImportBot]

Originally Posted by Fussballgott*:

 

Have you may changed the messages for stats?

Nope, messages are unchanged.

Got it figured out now. I'm starting every server command with a "/" - what works find, except in your plugin where you replace most of the string with nothing and then you doing a check like this:

 

if(newText.Length > 0)

 

This does not work when a "/" is still left in the string. I added this

 

if(newText.StartsWith("/")) newText = newText.Substring(1);

 

to the start of OnCommandStats and OnCommandTop10 and everything is fine...

[ImportBot]

Originally Posted by nbtc971*:

 

I have a weird problem, my plugin works perfectly for all of my server except my new SQDM Vietnam server. I'm using the same settings as with the other servers but it isn't recording stats. Is there a known problem with SQDM?

 

I can issue cmds like !sesssion and !rank and get information back, but nothing is being written to the DB. I have checked my settings against the other servers over and over, including the DB connect info, everything seems to be accurate.

 

Any help is appreciated.

 

*UPDATE

Just checked my other SQDM server (vanilla) and it doesn't record stats either so I'm guessing you don't have this setup to get stats from SQDM? I can't find any where that it is mentioned that this plugin doesn't work for all game modes.

[ImportBot]

Originally Posted by XpKiller*:

 

I never tested on a SQDM Server but normal it should work on it too. The plug-in itself doesn't care which game mode it running. But also the first mentioned that to me. The Plug-in take stats if 4 or more player are on the server by default. ATM I do not have a SQDM Server to test on so it like fishing in the dark for me.

You could sent logsfiles to me.

 

I can only guess that one major event is not send to the plug-in the event which starts the streaming thread.

 

The session cmd doesn't get data from the database except the rank

The rank cmd pulls data from the db, if this command doesn't work all the time something must be wrong.

[ImportBot]

Originally Posted by thetoast*:

 

What should i do if it not tracking bonus points?

[ImportBot]

Originally Posted by nbtc971*:

 

I will msg you with some info. In the meantime here are my settings... same as all 4 of my BC2 servers:

 

2-7-2011 5-25-04 PM.png[/attachment:1sxsvgoz]

 

BTW the way I know it's not recording stats is.. first I played several hours on my Vietnam SQDM yesterday, no stats. Then this morning I checked in the DB and the last seen date only included when I had last played on one of our Conquest servers. So then I went to the Vietnam SQDM and the Last Seen field did not update. So I went to Vanilla SQDM, Last Seen again did not update, then I went to our Conquest server, and the field updated with the new date and time. All 3 servers were empty.

 

Regardless, it's definitely not recording any stats for anyone on the SQDM servers.

[ImportBot]

Originally Posted by XpKiller*:

 

What should i do if it not tracking bonus points?

It is not possible to track the bonus points you receive like from weapons star because the server didn't report them to procon.

[ImportBot]

Originally Posted by nbtc971*:

 

Ok for some reason weapon stats started working for my vanilla SQDM server but I have changed nothing. The Vietnam SQDM server still isn't working:

 

events.log

 

Code:

Events logging started: Wednesday, 9 February 2011 00:00:06
Playerlist	02/09/2011 00:00:27		PlayerKilled	Davtob killed -o]T3[o [Patrol Boat Gunner]
Playerlist	02/09/2011 00:00:45		PlayerKilled	SKRIMER killed kaloop [AK-47 | -HEADSHOT-]
Playerlist	02/09/2011 00:00:49		PlayerKilled	Davtob killed -o]T3[o [Patrol Boat Gunner]
Playerlist	02/09/2011 00:01:12		PlayerKilled	-o]T3[o killed Davtob [PPSh]
Playerlist	02/09/2011 00:01:17		PlayerSwitchedTeams	Davtob swapped from team Delta to Charlie
Playerlist	02/09/2011 00:01:17		PlayerSwitchedSquads	Davtob swapped from squad Alpha to Alpha
Playerlist	02/09/2011 00:01:41		PlayerKilled	-o]T3[o killed SKRIMER [PPSh | -HEADSHOT-]
Playerlist	02/09/2011 00:01:45		PlayerKilled	kaloop killed -o]T3[o [M10 | -HEADSHOT-]
Playerlist	02/09/2011 00:01:57		PlayerSwitchedTeams	SKRIMER swapped from team Delta to Bravo
Playerlist	02/09/2011 00:01:57		PlayerSwitchedSquads	SKRIMER swapped from squad Alpha to Alpha
Playerlist	02/09/2011 00:02:03		PlayerJoin	Davo joined the server
Playerlist	02/09/2011 00:02:03		PlayerKilled	Davtob killed SKRIMER [M16]
Playerlist	02/09/2011 00:02:06		PlayerKilled	Davtob killed kaloop [M16]
Playerlist	02/09/2011 00:02:21		PlayerSwitchedTeams	kaloop swapped from team Bravo to Alpha
Playerlist	02/09/2011 00:02:21		PlayerSwitchedSquads	kaloop swapped from squad Alpha to Alpha
Playerlist	02/09/2011 00:02:21		PlayerSwitchedTeams	Davo swapped from team Bravo to Charlie
Playerlist	02/09/2011 00:02:21		PlayerSwitchedSquads	Davo swapped from squad Alpha to Alpha
Playerlist	02/09/2011 00:02:29		PlayerKilled	kaloop killed SKRIMER [M10]
Playerlist	02/09/2011 00:02:44		PlayerSwitchedTeams	SKRIMER swapped from team Bravo to Alpha
Playerlist	02/09/2011 00:02:44		PlayerSwitchedSquads	SKRIMER swapped from squad Alpha to Alpha
Playerlist	02/09/2011 00:03:10		PlayerKilled	kaloop killed Davtob [M10 | -HEADSHOT-]
Playerlist	02/09/2011 00:03:11		PlayerKilled	-o]T3[o killed kaloop [PPSh]
Playerlist	02/09/2011 00:03:54		PlayerKilled	SKRIMER killed Davtob [AK-47]
Playerlist	02/09/2011 00:03:55		PlayerKilled	Davo killed SKRIMER [M16]
Playerlist	02/09/2011 00:04:17		PlayerKilled	Davtob killed kaloop [M60 LMG]
Playerlist	02/09/2011 00:04:17		PlayerKilled	Davo killed SKRIMER [M16 | -HEADSHOT-]
Playerlist	02/09/2011 00:04:48		PlayerLeave	Davo left the server
Playerlist	02/09/2011 00:04:48		PlayerKilled	Davtob killed kaloop [M60 LMG | -HEADSHOT-]
Playerlist	02/09/2011 00:05:04		PlayerKilled	SKRIMER killed -o]T3[o [AK-47 | -HEADSHOT-]
Playerlist	02/09/2011 00:06:04		PlayerKilled	kaloop killed -o]T3[o [M10 | -HEADSHOT-]
Playerlist	02/09/2011 00:06:32		PlayerKilled	Davtob killed kaloop [M60 LMG | -HEADSHOT-]
Playerlist	02/09/2011 00:06:32		PlayerKilled	kaloop killed Davtob [M10 | -HEADSHOT-]
Playerlist	02/09/2011 00:06:42		PlayerKilled	SKRIMER killed -o]T3[o [AK-47]
Playerlist	02/09/2011 00:07:06		PlayerKilled	Davtob killed kaloop [M16]
Playerlist	02/09/2011 00:07:23		PlayerKilled	SKRIMER killed Davtob [AK-47]
Playerlist	02/09/2011 00:08:25		PlayerKilled	kaloop killed Davtob [M10 | -HEADSHOT-]
Playerlist	02/09/2011 00:08:25		PlayerKilled	Davtob killed kaloop [M16]
Playerlist	02/09/2011 00:08:50		PlayerKilled	Davtob killed SKRIMER [M16 | -HEADSHOT-]
Playerlist	02/09/2011 00:08:55		PlayerLeave	-o]T3[o left the server
Playerlist	02/09/2011 00:09:21		PlayerKilled	Davtob killed SKRIMER [M16]
Playerlist	02/09/2011 00:09:29		PlayerKilled	kaloop killed Davtob [M10]
Playerlist	02/09/2011 00:09:50		PlayerKilled	Davtob killed kaloop [M16]
Playerlist	02/09/2011 00:09:58		PlayerLeave	kaloop left the server
Playerlist	02/09/2011 00:10:22		PlayerKilled	Davtob killed SKRIMER [M16]
Playerlist	02/09/2011 00:10:35		PlayerSwitchedTeams	SKRIMER swapped from team Alpha to Charlie
Playerlist	02/09/2011 00:10:35		PlayerSwitchedSquads	SKRIMER swapped from squad Alpha to Alpha
Playerlist	02/09/2011 00:10:37		PlayerSwitchedTeams	SKRIMER swapped from team Charlie to Bravo
Playerlist	02/09/2011 00:10:37		PlayerSwitchedSquads	SKRIMER swapped from squad Alpha to Alpha
Playerlist	02/09/2011 00:10:43		PlayerLeave	SKRIMER left the server
Playerlist	02/09/2011 00:12:13		PlayerLeave	Davtob left the server
Map	02/09/2011 00:13:14		LevelLoading	Levels/NAM_MP_003SDM
Map	02/09/2011 00:13:14		LevelStarted

This from plugin.log:

 

Code:

Plugin logging started: Wednesday, 9 February 2011 00:00:06
[00:13:14] OnLoadingLevel: Levels/NAM_MP_003SDM Round: 1/1
[00:13:14] update sql server
[00:13:14] OdbcConn open
[00:13:14] Status ID-Cache: 0 ID's in cache
[00:13:14] Connection OdbcCon closed
[00:13:14] Connection OdbcConn closed

And here is the debug info:

 

Code:

[23:55:09 26] BF BC2 Chat, GUID and Stats Logger Enabled
[23:55:09 27] BF BC2 Chat, GUID and Stats Logger:  Floodprotection set to 10 Request per Round for each Player
[23:55:09 27] Gamemod Tableschema set to: SHARED
[23:55:09 29] Gamemod Weaponlist set to: SHARED
[23:57:43 78] Start tablebuilder
[23:57:43 86] OdbcCon open
[23:57:44 15] Your Weapontable is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls
[00:13:14 27] OnLoadingLevel: Levels/NAM_MP_003SDM Round: 1/1
[00:13:14 27] update sql server
[00:13:14 30] OdbcConn open
[00:13:14 34] Status ID-Cache: 0 ID's in cache
[00:13:14 34] Connection OdbcCon closed
[00:13:14 34] Connection OdbcConn closed

[ImportBot]

Originally Posted by nbtc971*:

 

I've been trying like crazy to figure out why my Vietnam SQDM isn't recording stats and I might of found something...

 

This is a brand new server that I just got a few days ago. Apparently Gameservers auto server creation script is still adding servers under R27 I guess. I noticed that the version number was different than my other servers. I just updated it to R28 and I hope that resolves my problem but of course no one is on the server right now so there is no way to know.

[ImportBot]

Originally Posted by XpKiller*:

 

i need full log file not just a few lines

[ImportBot]

Originally Posted by nbtc971*:

 

*removed because I added the zip file*

[ImportBot]

Originally Posted by nbtc971*:

 

I can tell you that the mapstats table DOES get updated with the Vietnam map info but playerstats, weaponstats and playerdata tables do not update.

[ImportBot]

Originally Posted by XpKiller*:

 

its no wonder regarding to your logs it logs, it seems that at no time more than 3 player where on the server simultaneous. The plug in track stats if 4 or more player are on the server. And pls for next time put you log in a text file and attach it to your post.

[ImportBot]

Originally Posted by nbtc971*:

 

I might of added the wrong log file, but it does not record data at any time.. even if there is a full server.

 

I tried attaching a txt file last night and it wouldn't accept it. I can try again however.

 

*UPDATE

I can't attach a txt file, it says extension not allowed.

 

*UPDATE

Actually as I read the log file it shows that there was more than 4 people on the server. The first two lines clearly shows at least 4 people were playing:

 

Playerlist 02/09/2011 00:00:27 PlayerKilled Davtob killed -o]T3[o [Patrol Boat Gunner]

Playerlist 02/09/2011 00:00:45 PlayerKilled SKRIMER killed kaloop [AK-47 | -HEADSHOT-]

[ImportBot]

Originally Posted by XpKiller*:

 

then put the txt files in a zip file

[ImportBot]

Originally Posted by nbtc971*:

 

Here they are...

 

logs.zip[/attachment:npklop06]

[ImportBot]

Originally Posted by nbtc971*:

 

Here is a picture showing that we had a full Vietnam SQDM server:

 

 

It accurately recorded data to the tbl_mapstats table, however the other tables received no data. Players who were playing on the server were not recorded to tbl_playerdata, nothing in tbl_playerstats or tbl_weaponstats.

 

I don't have the logs for this because at the time we had 2 full 32 slot servers and the full 16 slot server and logging was causing Procon to essentially seize up so I had to turn it off. Hopefully the logs I already uploaded to you will be good enough.

 

I am willing to give you rcon and everything you need to get to our Vietnam server so you can do testing. Just say the word and I will give you access.

[ImportBot]

Originally Posted by XpKiller*:

 

In the logs are these: Code:

2:35:12] Last Kill Tracker Plugin Enabled!
[12:35:41] OLP: roundstarted
[12:35:41] Start tablebuilder
[12:35:43] OdbcCon open
[12:35:43] Your Weapontable is containing all weapons known so far, if you got Error after this( missing Weapons) contact me pls
[12:36:07] Connection OdbcCon closed
[12:36:09] OdbcCon open
[12:36:09] Connection OdbcCon closed
[12:36:13] OdbcCon open
[12:49:21] OnLoadingLevel: Levels/NAM_MP_002SDM Round: 1/1
[12:49:21] update sql server
[12:49:21] OdbcConn open
[12:49:21] Status ID-Cache: 3 ID's in cache

This OLP entry means that the plug in starts tracking

The last entry are received id s from the DB. This looks like something is wrong with your database maybe permission problem or so.

Sure rcon access would speed up this process but I don't expect that my plug in is not responsible for this problem.

[ImportBot]

Originally Posted by nbtc971*:

 

This OLP entry means that the plug in starts tracking

The last entry are received id s from the DB. This looks like something is wrong with your database maybe permission problem or so.

Sure rcon access would speed up this process but I don't expect that my plug in is not responsible for this problem.

Then how are my 3 other servers writing to the db tables with the same info and on SHARED setting? And why does it write to mapstats table without incident? I have PM'ed you the connect information.

 

I'm not trying to be a pain, I just really want this to work and I don't understand why it isn't.

 

*UPDATE

 

Ok so I was trying to see the difference between the db tables and why mapstats might be getting updates and the other tables aren't. The major difference I see is that mapstats is the only table using the MYISAM storage engine while the others all use INNODB. Is it possible that INNODB has put a restriction on the number of queries or connections it can handle at one time?

 

At this point I definitely think INNODB has something to do with it.. I just don't know what.

[ImportBot]

Originally Posted by XpKiller*:

 

InnoDB is far more advanced than MyISAM it handles multiply connections much better

[ImportBot]

Originally Posted by nbtc971*:

 

InnoDB is far more advanced than MyISAM it handles multiply connections much better

Well.. as far as explaining what is going on, do you have a better idea?

 

Just so you know, because you seem inclined to dismiss me pretty easily, I am a 43 year old professional PHP developer and while I don't know anything about C programming, I'm not a fool.

 

If you have a better idea of what might be going on, please let me know, I'd love to look at it because I have spent many hours now trying to track down where I might be failing and to be honest, I don't see it. I have THREE other servers running this plugin fine. It's not like I suddenly forgot how to set it up or can't simply copy my settings from one server to the other.

 

Do you have a Steam account name so I can add you as friend?

[ImportBot]

Originally Posted by micovery*:

 

InnoDB is far more advanced than MyISAM it handles multiply connections much better

Well.. as far as explaining what is going on, do you have a better idea?

 

Just so you know, because you seem inclined to dismiss me pretty easily, I am a 43 year old professional PHP developer and while I don't know anything about C programming, I'm not a fool.

 

If you have a better idea of what might be going on, please let me know, I'd love to look at it because I have spent many hours now trying to track down where I might be failing and to be honest, I don't see it. I have THREE other servers running this plugin fine. It's not like I suddenly forgot how to set it up or can't simply copy my settings from one server to the other.

 

Do you have a Steam account name so I can add you as friend?

Enable logging in MySQL, monitor the log while the plugin is supposed to be inserting data into the tables, that way you can see what really is going on. You should be able to see all the queries received by MySQL in the log.

 

http://www.howtogeek.com/howto/database ... -in-mysql/

[ImportBot]

Originally Posted by nbtc971*:

 

I'm on a linux system rented from gameservers (yes our website is on a gameservers web server) and I don't have access to cmd line. If I can view logs in cpanel or enable them there.. then I can do this, otherwise, it won't be an option.

 

I will open a ticket with gameservers and see if I can get some logs or enable it.

[ImportBot]

Originally Posted by terwax*:

 

Code:

Error in LogChat: System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.52]MySQL server has gone away
   --- End of inner exception stack trace ---
   at System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception innerException)
   at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.LogChat(String strSpeaker, String strMessage, String strType)

What is this?

[ImportBot]

Originally Posted by XpKiller*:

 

The plug in had an unexpected loss of connection to the mysql server if this always happens around the same time then this could be a related to provider .