Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by Sussan*:

 

Hello ColColonCleaner, i saw you reaction on this post(see down below). but i try everything but the plugin is still saying wait one round.. he does this with the !top10 command and with !rank coommand. Also i see in my week top 10 that when somebody make a new kill they climb in the top 10.. So the people that are playing a lot in our server get passed by the new once any idea how to ficks this problems? Thanks

 

------------------------------------------------------------------------------------------------------------

Great work XPKiller!

 

 

The stats don´t change during a round.

I have to wait until the next round started to see my stats updated.

 

Yell messages still don´t work in BF4, right!?

 

Like this plugin! :-) (This isn´t a problem....)

Yes, all round stats (called a session by the plugin) are collected during the round. And all posted to the database at once to avoid database spam. If he was to write to the database on every kill it would use a lot of bandwidth and db connections, and would be in general much less efficient.

[ImportBot]

Originally Posted by Grainz*:

 

I think there should be an update to write live stats to the DB instead of waiting until the end of the round. A good scenario where this can work is if layer and sql server is on the same box.

[ImportBot]

Originally Posted by I_Died_Tryin*:

 

Spent a few days googling for an answer and always kept coming back to the plugin forum page.

Finally after reading every post I found...

 

page1/index.html*

 

I overlooked the link about using the unofficial stats plugin provided in post #1538.

And apparently further down past all the weapons to the unofficial link in post #1

 

The rest of the post lead me to the reason for a few errors including the one related to column null and unique issue.

 

You must be using mysql versions between 5.1 and 5.7.3 m13

 

Wamp 2.5 helped make that easy.

 

Next week I will try the unofficial version with the newest Wamp reinstalled.

 

I suggest updating the original post with the mysql requirements

 

Thanks for these plug-ins and community supports.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Spent a few days googling for an answer and always kept coming back to the plugin forum page.

Finally after reading every post I found...

 

page1/index.html*

 

I overlooked the link about using the unofficial stats plugin provided in post #1538.

And apparently further down past all the weapons to the unofficial link in post #1

 

The rest of the post lead me to the reason for a few errors including the one related to column null and unique issue.

 

You must be using mysql versions between 5.1 and 5.7.3 m13

 

Wamp 2.5 helped make that easy.

 

Next week I will try the unofficial version with the newest Wamp reinstalled.

 

I suggest updating the original post with the mysql requirements

 

Thanks for these plug-ins and community supports.

Thanks for the information, and please keep us posted on what comes of the unofficial patch.

[ImportBot]

Originally Posted by leibhold*:

 

I have added a note at the top of the original post

 

 

Description:

This plugin is used to log player chat, player GUID's, player Stats, Weaponstats and Mapstats.

This includes: Chat, PBGUID, EAGUID, IP, Stats, Weaponstats, Dogtags, Killstreaks, Country, ClanTag to be continued.. ;-)

Please post errors if get some.

You can adjust the debug level to a lower value to get less Console Spam. High -> Low (Trace, Info, Warning, Error).

Error only will show critical errors.

Feel free to post feedback and suggestions.

 

Update

Since XpKiller has abandoned this project and since there are a couple errors which needed to be fixed, there is a link below to modified [unofficial] version.

Hope this will help

[ImportBot]

Originally Posted by Sussan*:

 

hello, i dont know who is taking over from XPKILLER but i have a qeustion, i use this plugin for a while and i found out that my weektop10 is working fine. but my server commond for the rank/stats ( !rank) is not working he keeps saying no stats are available yet pls wait one round. and i cant get that fickst. also is het a problem when i typ !top10 that its say top10 and then my server name but there is nothing showing up. i think thats strange because my weektop10 command is working fine can somebody pls help me with that because i am searching for 2 months now for that good plugins to work. but i cant find anything.

 

so long story short:

 

my !top10 command is not showing up my top10 players in the server

 

and my !rank command is not working and i get continu the message : no stats are available yet pls wait one round.

 

please help me!

 

thanks a lot

[ImportBot]

Originally Posted by ty_ger07*:

 

Turn on the highest plugin error output logging. Then, after you type !top10 or !rank in the game server, look in your procon plugin console for error messages. My guess is that you have a database performance or connection issue.

[ImportBot]

Originally Posted by Sussan*:

 

what do you mean with ::: Turn on the highest plugin error output logging.

 

because i checkt the chat and also the little chat by my plugins but i dont see any error showing up.

 

and in my console in procon i dont see any faults :S Also i saw my !session commands is working but my rank there is still on 0 and thats not correct to.. i am really lost now and i get so frustrated by this because i cant get this work in 3 months now and i dont understand why its not working

 

hope you know what i do wrong somewhere

 

thanks a lot

[ImportBot]

Originally Posted by ty_ger07*:

 

In this plugin's settings, change "DebugLevel" from "Error" (default) to "Trace".

 

Restart the plugin (disable and enable), and watch the procon plugin console (scrolling text display at the bottom of the plugins tab) for error messages related to this plugin. Use the in-game commands, and watch the procon plugin console for error messages related to this plugin. Let a round of the game start and stop naturally, and watch the procon plugin console for error messages related to this plugin.

 

Copy and paste interesting messages to here.

 

 

 

In this plugin's settings, make sure "Top10 ingame" is set to "Yes".

 

 

Can you copy and paste or screenshot all your plugin's settings to here? Make sure to remove or blur out the database connection information. There are some settings which can significantly limit what is logged or displayed and it would be nice to know which settings you are using to make recommendations for or against changing your current settings.

[ImportBot]

Originally Posted by Sussan*:

 

hello Ty-ger

 

 

thanks for all youre help i think its working now... i got a other qeustion too idk if i can ask it here so if not sorry for that.

 

but i wanna know if i can make a message for people that i ban.. because i ban people with a high ping but i want when i ban them stand a message liked. Banned because of high ping. is that possible?

 

 

thanks

 

 

In this plugin's settings, change "DebugLevel" from "Error" (default) to "Trace".

 

Restart the plugin (disable and enable), and watch the procon plugin console (scrolling text display at the bottom of the plugins tab) for error messages related to this plugin. Use the in-game commands, and watch the procon plugin console for error messages related to this plugin. Let a round of the game start and stop naturally, and watch the procon plugin console for error messages related to this plugin.

 

Copy and paste interesting messages to here.

 

 

 

In this plugin's settings, make sure "Top10 ingame" is set to "Yes".

 

 

Can you copy and paste or screenshot all your plugin's settings to here? Make sure to remove or blur out the database connection information. There are some settings which can significantly limit what is logged or displayed and it would be nice to know which settings you are using to make recommendations for or against changing your current settings.

[ImportBot]

Originally Posted by ty_ger07*:

 

That isn't really a question appropriate to this plugin or forum topic, but I would have to assume that you can find a ping kicking plugin which has an option to ban players and provide an appropriate message.

[ImportBot]

Originally Posted by Sussan*:

 

Hello ty_ger07

 

Thank you very much i will search for it...

 

about this plugin... its working perfect now thanks for all the help and explaining :biggrin:

[ImportBot]

Originally Posted by Yuri*:

 

Im getting this error on a new install

 

[11:10:15 83] Error in Tablebuilder:

[11:10:15 83] Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

[11:10:15 83] Native: -2147467259

[11:10:15 83] Source: MySql.Data

[11:10:15 83] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[11:10:15 83] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

 

Any ideas?

[ImportBot]

Originally Posted by ty_ger07*:

 

Im getting this error on a new install

 

[11:10:15 83] Error in Tablebuilder:

[11:10:15 83] Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

[11:10:15 83] Native: -2147467259

[11:10:15 83] Source: MySql.Data

[11:10:15 83] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[11:10:15 83] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

 

Any ideas?

Yes, please see the unofficial version update linked to in the first post.

 

Note this change: Fixed null primary key problem which caused incompatibility with MySQL version 5.7.3 m13 and up.

 

 

Quoting part of the first post:

Update

Since XpKiller has abandoned this project and since there are a couple errors which needed to be fixed, there is a link below to modified [unofficial] version.

...

 

Download Unofficial Version:

...

 

You can download it here:

https://github.com/tyger07/CChatGUID...ive/master.zip

 

Changes in 1.0.0.2-ty_gerMOD Version

In CChatGUIDStatsLogger.inc file, the following items were changed:

- Line 462 through 545: Added additional weapon keywords.

- Line 4367: Fixed error in query which caused !top10 weapons query to fail.

- Line 5489: Fixed null primary key problem which caused incompatibility with MySQL version 5.7.3 m13 and up.

 

...

[ImportBot]

Originally Posted by Yuri*:

 

procon crash.png

 

Now I have this error all the sudden on a new install with the uinofficial version.

[ImportBot]

Originally Posted by ty_ger07*:

 

Did you stop the plugin, close procon, delete the old plugin, and add the new plugin version before re-opening procon? I would recommend also deleting all stats tables in your database between each plugin version; just in case.

 

It looks like it is choking on some issue with an IP address being '' (empty) when it should be not empty or at least should be 0.0.0.0 (plugin default for a blank IP). I hope the error with the partially built tables with the other non-working plugin version is the cause and that emptying the stats database while the plugin is disabled will solve the issue and let it build the tables again properly.

[ImportBot]

Originally Posted by BuRockK*:

 

Hey guys, im getting this error with the unofficial version. I think its the same problem i had with the official version before. Im not sure, i dont know what the error means. Heres the output in plugin console:

 

Code:

[00:49:49 04] [Statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.EndOfStreamException: Es wurde versucht, über das Ende des Streams hinaus zu lesen.
   bei MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   bei MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   bei MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   bei MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   bei MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   bei MySql.Data.MySqlClient.MySqlConnection.BeginTransaction(IsolationLevel iso)
   bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID(CServerInfo csiServerInfo)
[01:28:14 04] [Statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.EndOfStreamException: Es wurde versucht, über das Ende des Streams hinaus zu lesen.
   bei MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   bei MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   bei MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   bei MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   bei MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   bei MySql.Data.MySqlClient.MySqlConnection.BeginTransaction(IsolationLevel iso)
   bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID(CServerInfo csiServerInfo)
[01:40:21 73] [Statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.EndOfStreamException: Es wurde versucht, über das Ende des Streams hinaus zu lesen.
   bei MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   bei MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   bei MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   bei MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   bei MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   bei MySql.Data.MySqlClient.MySqlConnection.BeginTransaction(IsolationLevel iso)
   bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't know. I never could figure that one out. It seems to be an error related to updating the current player list/live scoreboard between round changes and doesn't seem to affect anything negatively when the error occurs.

The "unofficial"/"modified" version is the same as the regular version in this aspect.

[ImportBot]

Originally Posted by hazmat*:

 

Error Incorrect table name tbl_chatlog...how to fix?

[ImportBot]

Originally Posted by BuRockK*:

 

I don't know. I never could figure that one out. It seems to be an error related to updating the current player list/live scoreboard between round changes and doesn't seem to affect anything negatively when the error occurs.

The "unofficial"/"modified" version is the same as the regular version in this aspect.

Okay i guess its harmless, didnt had complaints..thanks man.

[ImportBot]

Originally Posted by ty_ger07*:

 

Error Incorrect table name tbl_chatlog...how to fix?

Huh? More information please.

[ImportBot]

Originally Posted by hazmat*:

 

[16:36:18 18] Error in Tablebuilder:

[16:36:18 18] Message: Incorrect table name 'tbl_chatlog

'

[16:36:18 18] Native: -2147467259

[16:36:18 19] Source: MySql.Data

[16:36:18 19] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[16:36:18 19] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[16:36:18 21] ProconRulz: *******************OnServerInfo******************* **********

[16:36:18 42] ProconRulz: ********************OnListPlayers***************** *************

[16:36:18 42] ProconRulz: ****************Debug command counts**********************

[16:36:18 42] ProconRulz: ***************Debug command players*********************

[16:36:18 42] ProconRulz: players in new player cache =

[16:36:18 42] ProconRulz: ********************Debug command teamsize******************

[16:36:18 42] ProconRulz: min teamsize 0

[16:36:18 42] ProconRulz: ********************Debug command watched******************

[16:36:18 42] ProconRulz: Watched items are: handgun, u_medkit, u_flashbang, u_defib, u_repairtool, u_ballisticshield, u_deserteagle, u_unica6, melee

[16:36:21 51] Error in Tablebuilder:

[16:36:21 51] Message: Incorrect table name 'tbl_chatlog

'

[16:36:21 51] Native: -2147467259

[16:36:21 51] Source: MySql.Data

[16:36:21 51] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[16:36:21 51] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[ImportBot]

Originally Posted by ty_ger07*:

 

That is weird.

 

For some reason, your SQL query in the plugin inserted a line break in the middle of the query. Text editor word wrap maybe? Have you ever opened or edited the plugin source code file or know any other reason why the file may have been edited?

[ImportBot]

Originally Posted by hazmat*:

 

copy from procon

[ImportBot]

Originally Posted by ty_ger07*:

 

copy from procon

That isn't a very descriptive answer. It doesn't really tell me anything.

 

Download the plugin again. Disable the plugin in procon, close procon, stop the procon layer (if using a procon layer server), and replace the plugin files. Try again.

[ImportBot]

Originally Posted by ty_ger07*:

 

That isn't a very descriptive answer. It doesn't really tell me anything.

 

Download the plugin again. Disable the plugin in procon, close procon, stop the procon layer (if using a procon layer server), and replace the plugin files. Try again.

Oh, another idea I had...

 

It is very important that you make sure that "Table Suffix" in this plugin's settings in Procon is empty and not [ENTER] (line feed).

A mistaken line return in table suffix field of this plugin's settings in procon would look blank/empty but actually mess up the queries. Click the table suffix field, arrow right using the keyboard in that field, and then backspace a few times. Make sure it is blank and doesn't accidentally have a new line stored in that field. Then, try again.

[ImportBot]

Originally Posted by itsteve*:

 

Both this plugin and the updated one crash my procon when the server starts to populate, any idea why (when I switch either on of them off procon is 100% stable).

[ImportBot]

Originally Posted by ty_ger07*:

 

Both this plugin and the updated one crash my procon when the server starts to populate, any idea why (when I switch either on of them off procon is 100% stable).

No idea.

 

More information? Error messages? Screen shots? System resource usage information? Anything?

 

Without more information, all I can say is "Did you try turning it off an on again? Is it plugged in? Is it turned on_".

[ImportBot]

Originally Posted by hazmat*:

 

Ty Ty_ger...I will try and let you know

[ImportBot]

Originally Posted by ELKABILLA*:

 

i dont know why but i am running the plugin for bf3 and the plugin doesnt save any playerstats , it saves perfectly the session data and mapdata but no playerstats, i check the procon config of the plugin and i have activated the playerstats check, and nothing, help please_!_!_!