Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[BF4Player]

hi is it possible to edit a player stats using mysql database and edit his details like score kills ..etc 

 

Thanks

[BF4Player]

22 minutes ago, BF4Player said:

hi is it possible to edit a player stats using mysql database and edit his details like score kills ..etc 

 

Thanks

nevermind delete post plz

[StalKlim]

[12:45:26 32] [MULTIbalancer]:0 Status: Team counts [25] = 13(US) vs 12(RU), with 0 unassigned
[12:45:26 32] [MULTIbalancer]:2 +------------------------------------------------+
[12:46:45 12] [Statslogger]Error: getUpdateServerID1: System.NullReferenceException: An object reference does not point to an instance of the object.
   в PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID(CServerInfo csiServerInfo)
[12:46:47 04] [xVotemap 1.5.6.0] Info: Level loaded: Noshahr Canals [CQ], Round 1 of 1
[12:46:47 04] [xVotemap 1.5.6.0] Work: Level loaded: Last round detected, starting voting system
[12:47:10 42] [xVotemap 1.5.6.0] Info: Estimated voting start in 41 minutes, 37 seconds @ 12:28:47
[12:48:40 55] [AdKats] INFO: Shutting down AdKats.
[12:48:41 27] [AdKats] AdKats 7.6.0.9 Disabled! =(

Hello, I have such a problem, after that there is a crash of the server, what can be the case tell me?

[SxDarkness]

Hello! How can I make "PRoCon Chat, GUILD, Stats and Map Logger" not save messages from the server's spambot and show them on the web page?

[Hedius]

10 hours ago, SxDarkness said:

Hello! How can I make "PRoCon Chat, GUILD, Stats and Map Logger" not save messages from the server's spambot and show them on the web page?

Disable chatlogging in stats logger and enable chatlogging in adkats.

Adkats has the option to not post server spam.

[DeweyCox]

Can anyone tell me how to fix this issue with the strange link text appearing above the breadcrumb?

[B7ackhawk]

Hello can you tell me what i missing here it more one days still data not save player stats 

http://pandazlo.com/bf3/

[Hedius]

On 3/17/2021 at 12:18 AM, DeweyCox said:

Can anyone tell me how to fix this issue with the strange link text appearing above the breadcrumb?

This is not an issue. The navigation links are meant to be there.

[Hedius]

16 minutes ago, B7ackhawk said:

Hello can you tell me what i missing here it more one days still data not save player stats 

http://pandazlo.com/bf3/

Please share you plugin settings. (Without the database section.)

[B7ackhawk]

1 minute ago, Hedius said:

Please share you plugin settings. (Without the database section.)

[Hedius]

1 minute ago, B7ackhawk said:

Not sure if Top 10 ingame enabling might help. All other settings are fine.

Stats logger partly relies on punkbuster to be running. Is punkbuster running on your server?

[B7ackhawk]

1 minute ago, Hedius said:

Not sure if Top 10 ingame enabling might help. All other settings are fine.

Stats logger partly relies on punkbuster to be running. Is punkbuster running on your server?

punkbuster  not its off . but second servers pb on and all normal work http://pandazlo.com/ , so i will make it on later and i will check

[BlackBuRn]

Hello any idea what may be causing this error

[Prophet731]

Just now, BlackBuRn said:

Hello any idea what may be causing this error

It tells you right there that you need to setup the Stat logger plugin before AdKats and run as it's dependent on that.

[dangerBEclose]

Hello,
How can I remove a server please? We had to move server box because of lag twice and now we have 2 servers stuck in the stats page. I would like to remove these two from the database.
Can you guide me how to do this please?

Thanks,
dangerBEclose

[Hedius]

3 minutes ago, dangerBEclose said:

Hello,
How can I remove a server please? We had to move server box because of lag twice and now we have 2 servers stuck in the stats page. I would like to remove these two from the database.
Can you guide me how to do this please?

Thanks,
dangerBEclose

DELETE FROM tbl_server WHERE ServerID = x;

Edited June 20, 2021 by Hedius

[dangerBEclose]

1 minute ago, Hedius said:

DELETE from tbl_server WHERE ServerID = x;

Hi,
When I try that I get the following error in phpmyadmin.

[Hedius]

2 minutes ago, dangerBEclose said:

Hi,
When I try that I get the following error in phpmyadmin.

Tbh. You don't have to delete the entry.

Setting the connection state to off in tbl_server is enough.

Next time update the ip of your server in tbl_server to prevent the creation of another server.

[Sylvirus]

Hi Is there a discord or something we can join for assistance with setting up  these plugins I've never used procon before

[OddJob001]

Hello, first of all thank you for your work.  

I've got most everything working, except for the Welcome message for returning players.

The Welcome message for new players works, just not returning players. 

I see this when I join:

[11:22:41 25] [Statslogger]Trace: OddJob001 Rank: 11

But no actual message printed to the server.

Here are the settings (default):

I have tried various Delays from 5 to 15. 

Any help would be appreciated, thanks.

[OddJob001]

34 minutes ago, OddJob001 said:

Hello, first of all thank you for your work.  

I've got most everything working, except for the Welcome message for returning players.

The Welcome message for new players works, just not returning players. 

I see this when I join:

[11:22:41 25] [Statslogger]Trace: OddJob001 Rank: 11

But no actual message printed to the server.

Here are the settings (default):

I have tried various Delays from 5 to 15. 

Any help would be appreciated, thanks.

Can't edit the original.  So after some time, we now see this:

[11:45:49 37] [Statslogger]Trace: Serverstats Write query
[11:45:49 44] [Statslogger]Info: Status ID-Cache: 24 ID's in cache
[11:45:49 44] [Statslogger]Info: Connection MySqlConn closed
[11:45:49 80] [Statslogger]Trace: Removing Player His_Wildness from welcomestatslist  Timeoutlimit of 10 minutes was exceeded!
[11:45:49 80] [Statslogger]Trace: Removing Player OddJob001 from welcomestatslist  Timeoutlimit of 10 minutes was exceeded!
[11:45:49 80] [Statslogger]Trace: Removing Player KaanTekocak from welcomestatslist  Timeoutlimit of 10 minutes was exceeded!
[11:45:49 80] [Statslogger]Trace: Removing Player MrSoker from welcomestatslist  Timeoutlimit of 10 minutes was exceeded!

 

[OddJob001]

Anyone have issues with this plugin, where it just decides to stop working?  Can see trace/debugging commands, but players get no reply to anything.

[Dooom3d]

[11:27:30 68] [Statslogger]Error: CreateSession: System.ArgumentOutOfRangeException: Value to add was out of range.
Parameter name: value
   at System.DateTime.Add(Double value, Int32 scale)
   at PRoConEvents.CStats..ctor(String guid, Int32 score, Int32 kills, Int32 headshots, Int32 deaths, Int32 suicides, Int32 teamkills, Int32 playtime, Double timeoffset, Dictionary`2 _weaponDic)
   at PRoConEvents.CChatGUIDStatsLogger.CreateSession(String SoldierName, Int32 intScore, String EAGUID)

is anyone having this issue? Anyway to fix/get around it? Tried restarting the layer, and the plugin itself with no luck.

[OddJob001]

Can anyone confirm if this plugin is working at all anymore?  We've been troubleshooting it for 2 weeks with no luck.  It works for a couple rounds, then just stops working. 

[Hedius]

2 minutes ago, OddJob001 said:

Can anyone confirm if this plugin is working at all anymore?  We've been troubleshooting it for 2 weeks with no luck.  It works for a couple rounds, then just stops working. 

Yes the plugin works totally fine.

[OddJob001]

35 minutes ago, Hedius said:

Yes the plugin works totally fine.

Alright.  I'll continue to debug.  We've been having issues with it going on a week now.  It works for a couple hours, then just totally stops talking to our sql instance.  

[14:11:08] Error: System.TimeoutException: 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 ---> System.IO.IOException: Unable to read data from the transport connection: 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. ---> 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
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   --- End of inner exception stack trace ---

I guess I might have to load this all locally and run some wireshark to see if its the local side or the remote side, but we have other dbs running just fine on the same sql instance. 

[Hedius]

11 minutes ago, OddJob001 said:

Alright.  I'll continue to debug.  We've been having issues with it going on a week now.  It works for a couple hours, then just totally stops talking to our sql instance.  

[14:11:08] Error: System.TimeoutException: 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 ---> System.IO.IOException: Unable to read data from the transport connection: 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. ---> 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
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   --- End of inner exception stack trace ---

I guess I might have to load this all locally and run some wireshark to see if its the local side or the remote side, but we have other dbs running just fine on the same sql instance. 

Well a timeout exception obviously is caused by your setup / the connecting to the DBMS / or the DBMS itself....

[OddJob001]

Just now, Hedius said:

Well a timeout exception obviously is caused by your setup / the connecting to the DBMS / or the DBMS itself....

Right, agree with that.  However, I can query the db just fine, and none of our other applications (procon plugins, and many others) that use this sql instance have any issues with communication.  Its soley this plugin.   Im going to try setting it all back up again but limiting the connections to like, 3, within procon.  I wonder if our procon layer provider is rate limiting our external connections or something.  

[Hedius]

2 minutes ago, OddJob001 said:

Right, agree with that.  However, I can query the db just fine, and none of our other applications (procon plugins, and many others) that use this sql instance have any issues with communication.  Its soley this plugin.   Im going to try setting it all back up again but limiting the connections to like, 3, within procon.  I wonder if our procon layer provider is rate limiting our external connections or something.  

Are you limiting the max connections from the layer's IP / user?

[OddJob001]

18 minutes ago, Hedius said:

Are you limiting the max connections from the layer's IP / user?

We dont have much control over the gameservers procon layer (so Im not able to answer that).  The only control I have is to limit the connections in the plugin itself.  Default is 10, Ill set it to 3.  Thing is, once we hit the above sql connection error, it never recovers.  Requires an entire reinstall of the procon server.