Jump to content

Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

ColColonCleaner

By ColColonCleaner
in Plugins

Recommended Posts

  • Replies 2k
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

ColColonCleaner
ColColonCleaner

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,

Hedius
Hedius

This should not happen. Wait for at least one round. If this does not help: Stop PRoCon Delete the config at Configs/IP/StatsLogger..... cfg Start PRoCon Do not modify any

Hedius
Hedius

Check the value of this field. Set it to 0. Does this help? Do you use AdKats? Not sure if AdKats updates the offset, but AdKats has an option to adjust the logger settings.

Posted Images

ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by B7ackhawk*:

 

Assuming you didn't wait for the round to end after you made the change. There needs to be at least 1-2 rounds of stats in the database for ranks to be calculated. They aren't calculated mid-round.

Capture.PNG

 

This after 3 round :smile:

 

and i will wait all day

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by cristhian_ps*:

 

Hello, I'm tryng to uso AdKats in my server, but after some people enter, this error appears:

 

Code: 

[23:37:19 45] [Statslogger]Error: Error in UpdateCurrentPlayerTable: 
[23:37:19 45] Message: Incorrect string value: '''' for function inet_aton
[23:37:19 45] Native: -2147467259
[23:37:19 45] Source: MySql.Data
[23:37:19 45] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& 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.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPlayerTable(List`1 lstPlayers)
And I went to DB, and the Insert have an empty ip:

 

Code: 

( 1, '####','', '####', '', 0, 0, 0, 0, 0,0,0 ,'2017-11-12 13:54:57.477',31, INET_ATON( ''),'',0,0,33)
I try to reinstal, but still not working. Looks some like this: https://github.com/AdKats/AdKats/issues/920

 

But this not worked for me.

Someone can help ?

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by ColColonCleaner*:

 

Hello, I'm tryng to uso AdKats in my server, but after some people enter, this error appears:

 

Code: 

[23:37:19 45] [Statslogger]Error: Error in UpdateCurrentPlayerTable: 
[23:37:19 45] Message: Incorrect string value: '''' for function inet_aton
[23:37:19 45] Native: -2147467259
[23:37:19 45] Source: MySql.Data
[23:37:19 45] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& 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.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPlayerTable(List`1 lstPlayers)
And I went to DB, and the Insert have an empty ip:

 

Code: 

( 1, '####','', '####', '', 0, 0, 0, 0, 0,0,0 ,'2017-11-12 13:54:57.477',31, INET_ATON( ''),'',0,0,33)
I try to reinstal, but still not working. Looks some like this: https://github.com/AdKats/AdKats/issues/920

 

But this not worked for me.

Someone can help ?

Which version of stat logger are you using? What is the version number displayed inside procon?
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by cristhian_ps*:

 

Hello, I'm having this problem in my server after some players in:

 

Code: 

[23:37:19 45] [Statslogger]Error: Error in UpdateCurrentPlayerTable: 
[23:37:19 45] Message: Incorrect string value: '''' for function inet_aton
[23:37:19 45] Native: -2147467259
[23:37:19 45] Source: MySql.Data
[23:37:19 45] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& 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.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPlayerTable(List`1 lstPlayers)
Someone already saw this ?
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by ColColonCleaner*:

 

Hello, I'm having this problem in my server after some players in:

 

Code: 

[23:37:19 45] [Statslogger]Error: Error in UpdateCurrentPlayerTable: 
[23:37:19 45] Message: Incorrect string value: '''' for function inet_aton
[23:37:19 45] Native: -2147467259
[23:37:19 45] Source: MySql.Data
[23:37:19 45] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& 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.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPlayerTable(List`1 lstPlayers)
Someone already saw this ?
Didn't notice your post was auto-moderated. It's visible now. See my response above.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by cristhian_ps*:

 

Which version of stat logger are you using? What is the version number displayed inside procon?

The file I sent to server, is 1.0.0.3, but Procon shows 1.0.0.2.

 

Didn't notice your post was auto-moderated. It's visible now. See my response above.

Yeah , I did't see.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by ColColonCleaner*:

 

The file I sent to server, is 1.0.0.3, but Procon shows 1.0.0.2.

 

 

 

Yeah , I did't see.

Hmm, i thought that IP issue was fixed in 1.0.0.3. (there was an issue with the .3 release where the version number for procon wasn't udpated so it still shows .2 even though it's a newer version).

 

I'll look into the issue shortly.

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by cristhian_ps*:

 

Hmm, i thought that IP issue was fixed in 1.0.0.3. (there was an issue with the .3 release where the version number for procon wasn't udpated so it still shows .2 even though it's a newer version).

 

I'll look into the issue shortly.

Ok, thanks, let me know if you need more info.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by Prophet731*:

 

Hmm, i thought that IP issue was fixed in 1.0.0.3. (there was an issue with the .3 release where the version number for procon wasn't udpated so it still shows .2 even though it's a newer version).

 

I'll look into the issue shortly.

It should be fixed. It's suppose to check if the value is null or empty and if it is provide a default value. Check line 3496.
* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by B7ackhawk*:

 

what the problem?

 

[00:59:28 34] PRoCon Chat, GUID and Stats Logger Enabled

[00:59:28 34] PRoCon Chat, GUID and Stats Logger: Floodprotection set to 5 Request per Round for each Player

[00:59:28 34] Native: -2147467259

[00:59:28 48] Source: MySql.Data

[00:59:28 51] StackTrace: at MySql.Data.MySqlClient.NativeDriver.Open()

at MySql.Data.MySqlClient.Driver.Open()

at MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

at MySql.Data.MySqlClient.MySqlPool..ctor(MySqlConnec tionStringBuilder settings)

at MySql.Data.MySqlClient.MySqlPoolManager.GetPool(My SqlConnectionStringBuilder settings)

at MySql.Data.MySqlClient.MySqlConnection.Open()

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[00:59:28 51] InnerException: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 104.27.176.231:3306

at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

at MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

at MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

at MySql.Data.MySqlClient.NativeDriver.Open()

[00:59:28 51] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

* Restored post. It could be that the author is no longer active.
Link to comment
ImportBot Advanced Member

ImportBot

Posted
Posted

Originally Posted by B7ackhawk*:

 

Can you connect to your MySQL database with another piece of software? e.g. MySQL Workbench. The issue is likely outside of procon.

when i enabled the plugin he show me

 

[15:55:47 39] PRoCon Chat, GUID and Stats Logger Enabled

[15:55:47 39] PRoCon Chat, GUID and Stats Logger: Floodprotection set to 5 Request per Round for each Player

[15:55:50 91] Error in Tablebuilder:

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

[15:55:50 91] Native: -2147467259

[15:55:50 91] Source: MySql.Data

[15:55:50 91] 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()

[15:55:50 91] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

 

 

i have php admin i can connect to my database

* Restored post. It could be that the author is no longer active.
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go to topic listing


×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.