Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by dzieju*:

 

Hi guys

 

How to delete only Top 20 Players This Week stats ?

Guys can you help me how to reset top 20 ?

[ImportBot]

Originally Posted by ty_ger07*:

 

Guys can you help me how to reset top 20 ?

Empty the tbl_sessions table in the database.

 

If you are using my webstats webpage code, also empty the tyger_stats_top_twenty_cache table if you want instant results. Or don't empty that table and wait half a day for it to catch up.

[ImportBot]

Originally Posted by petraunas*:

 

Hi, after deleting the table, to we still need to restart the database for the changes to take effect? https://myrcon.net/recovered/img/126982_1.gif.html

[ImportBot]

Originally Posted by xr650rhonda*:

 

We run this plugin on a layer for a bf4 server, two days ago our provider stopped hosting bf4 servers and moved us to another game server provider, lost our server for 2 days.

I back up the sql file from this plugin and I have even reloaded it in the past with no issues. When they moved us to the new game server provider we stayed bookmarked in battlelog, but our ip for the server and layer changed.

My question:

We use Ty_ger stats website and really love it, it's awesome. However when we changed our ip for the layer the sql database split.

 

w75Gdq.png

 

 

The stats plugin seems to embed the ip of the server to the sql file, we had a large database of players on the old ip server and I afraid we will be we will be starting all over again, can anyone think of a work around for this?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

We run this plugin on a layer for a bf4 server, two days ago our provider stopped hosting bf4 servers and moved us to another game server provider, lost our server for 2 days.

I back up the sql file from this plugin and I have even reloaded it in the past with no issues. When they moved us to the new game server provider we stayed bookmarked in battlelog, but our ip for the server and layer changed.

My question:

We use Ty_ger stats website and really love it, it's awesome. However when we changed our ip for the layer the sql database split.

 

w75Gdq.png

 

 

The stats plugin seems to embed the ip of the server to the sql file, we had a large database of players on the old ip server and I afraid we will be we will be starting all over again, can anyone think of a work around for this?

You need to shut down your layers, delete the new serverid it created, then modify the old server entry to match your server's new IP address.

[ImportBot]

Originally Posted by xr650rhonda*:

 

You need to shut down your layers, delete the new serverid it created, then modify the old server entry to match your server's new IP address.

Thank you so much for your help!!!!!

[ImportBot]

Originally Posted by Skrapi*:

 

Hello,

 

i can run a plugin Chat GUID and Stats logger, i got a new procon layer but when i install plugin and try to run it i got this kind of error:

 

PRoCon Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[20:07:06 84] Error: System.Security.SecurityException: Request for the permission of type 'System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

at System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

at System.Security.CodeAccessPermission.Demand()

at System.Net.Sockets.Socket.CheckCacheRemote(EndPoin t& remoteEP, Boolean isOverwrite)

at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)

at System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)

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()

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

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

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection()

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

at MySql.Data.MySqlClient.MySqlPool.GetConnection()

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

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

The action that failed was:

Demand

The type of the first permission that failed was:

System.Net.SocketPermission

The Zone of the assembly that failed was:

MyComputer

[20:07:06 84] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[20:07:17 26] Error: System.Security.SecurityException: Request for the permission of type 'System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

at System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

at System.Security.CodeAccessPermission.Demand()

at System.Net.Sockets.Socket.CheckCacheRemote(EndPoin t& remoteEP, Boolean isOverwrite)

at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)

at System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)

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()

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

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

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection()

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

at MySql.Data.MySqlClient.MySqlPool.GetConnection()

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

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

The action that failed was:

Demand

The type of the first permission that failed was:

System.Net.SocketPermission

The Zone of the assembly that failed was:

MyComputer

[20:07:17 26] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[20:07:17 26] [statslogger]Error: getUpdateServerID1: System.Security.SecurityException: Request for the permission of type 'System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

at System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

at System.Security.CodeAccessPermission.Demand()

at System.Net.Sockets.Socket.CheckCacheRemote(EndPoin t& remoteEP, Boolean isOverwrite)

at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)

at System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)

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()

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

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

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection()

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

at MySql.Data.MySqlClient.MySqlPool.GetConnection()

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

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

The action that failed was:

Demand

The type of the first permission that failed was:

System.Net.SocketPermission

The Zone of the assembly that failed was:

MyComputer

[20:07:20 93] PRoCon Chat, GUID and Stats Logger Disabled

 

 

 

Any login data is good i check this 100 times.

[ImportBot]

Originally Posted by dzieju*:

 

Hello

 

Im using [ Statistics data provided by XpKiller's Procon logging plugin ] [ Stats page provided by Ty_ger07 ]

 

But i dont know why one server showing who play now on live , other server not showing this .

 

stats.dzieju.pl

 

Pure 1 server working ok

Bang Bang server showing only stats without players online .

 

Live score board not working on one server :/

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Hello

 

Im using [ Statistics data provided by XpKiller's Procon logging plugin ] [ Stats page provided by Ty_ger07 ]

 

But i dont know why one server showing who play now on live , other server not showing this .

 

stats.dzieju.pl

 

Pure 1 server working ok

Bang Bang server showing only stats without players online .

 

Live score board not working on one server :/

Do you have live scoreboard in DB disabled on that stat logger instance?

[ImportBot]

Originally Posted by kcuestag*:

 

Is there any command to see the top 10 players for the last 30 days?

 

We reward with a month worth of reserved slot to our top 10 players of every month, until now I've been erasing the database monthly, but I am looking forward to install AdKats and I thought I'd ask if there's an alternative to "my way".

[ImportBot]

Originally Posted by ty_ger07*:

 

Is there any command to see the top 10 players for the last 30 days?

 

We reward with a month worth of reserved slot to our top 10 players of every month, until now I've been erasing the database monthly, but I am looking forward to install AdKats and I thought I'd ask if there's an alternative to "my way".

Session stats are stored with a timestamp. You could select session stats for a range of dates. Session stats are very simplified stats and don't include vehicle or weapon stats. Basically it will tell you how many kills, deaths, and points they had through a range of dates and times.

 

Please note that session stats in XpKiller's plugin are a bit glitched. XpKiller's plugin doubles or triples the player's score for some reason. It is assumed that every player's score is equally inflated and therefore still valid as far as comparisons are concerned.

 

My web stats page code has a "top 20 players this week" tab which ises session stats, for an example.

http://stats.dzieju.pl/index.php_p=leaders&sid=6

 

This is an example sql query for 30 days:

Code:

SELECT tpd.`PlayerID`, tpd.`SoldierName`, SUM(tss.`Score`) AS Score, SUM(tss.`Kills`) AS Kills, (SUM(tss.`Kills`)/SUM(tss.`Deaths`)) AS KDR, (SUM(tss.`Headshots`)/SUM(tss.`Kills`)) AS HSR
		FROM `tbl_sessions` tss
		INNER JOIN `tbl_server_player` tsp ON tss.`StatsID` = tsp.`StatsID`
		INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
		WHERE tsp.`ServerID` = {$ServerID}
		AND tss.`Starttime` BETWEEN CURDATE() - INTERVAL 30 DAY AND CURDATE()
		AND tpd.`GameID` = {$GameID}
		GROUP BY tpd.`PlayerID`
		ORDER BY Score DESC, tpd.`SoldierName` ASC
		LIMIT 0, 10

In the above query, substitute {$ServerID} for your server ID (default is 1) and {$GameID} for the BF4 server GameID (default is 1).

[ImportBot]

Originally Posted by kcuestag*:

 

Session stats are stored with a timestamp. You could select session stats for a range of dates. Session stats are very simplified stats and don't include vehicle or weapon stats. Basically it will tell you how many kills, deaths, and points they had through a range of dates and times.

 

Please note that session stats in XpKiller's plugin are a bit glitched. XpKiller's plugin doubles or triples the player's score for some reason. It is assumed that every player's score is equally inflated and therefore still valid as far as comparisons are concerned.

 

My web stats page code has a "top 20 players this week" tab which ises session stats, for an example.

http://stats.dzieju.pl/index.php_p=leaders&sid=6

 

This is an example sql query for 30 days:

Code:

SELECT tpd.`PlayerID`, tpd.`SoldierName`, SUM(tss.`Score`) AS Score, SUM(tss.`Kills`) AS Kills, (SUM(tss.`Kills`)/SUM(tss.`Deaths`)) AS KDR, (SUM(tss.`Headshots`)/SUM(tss.`Kills`)) AS HSR
		FROM `tbl_sessions` tss
		INNER JOIN `tbl_server_player` tsp ON tss.`StatsID` = tsp.`StatsID`
		INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
		WHERE tsp.`ServerID` = {$ServerID}
		AND tss.`Starttime` BETWEEN CURDATE() - INTERVAL 30 DAY AND CURDATE()
		AND tpd.`GameID` = {$GameID}
		GROUP BY tpd.`PlayerID`
		ORDER BY Score DESC, tpd.`SoldierName` ASC
		LIMIT 0, 10

In the above query, substitute {$ServerID} for your server ID (default is 1) and {$GameID} for the BF4 server GameID (default is 1).

Whoah, huge thanks!

[ImportBot]

Originally Posted by kcuestag*:

 

Update, tested and working great. Too bad in-game players won't be able to see if they are on the top 10 of last 30 days, but works for me so I don't need to erase it monthly and I can use AdKats, thank you ty_ger07!

[ImportBot]

Originally Posted by petraunas*:

 

I saw that one too. I just hope that this gets addressed on future updates.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Update, tested and working great. Too bad in-game players won't be able to see if they are on the top 10 of last 30 days, but works for me so I don't need to erase it monthly and I can use AdKats, thank you ty_ger07!

Internally we don't have need for a command that displays top 10 in the past 30 days, but if you want one you can make a funded request for it.

[ImportBot]

Originally Posted by Tommuh*:

 

Hello,

 

I'm new to this forum. I tried to search for a solution for my problem but I couldn't find any. Maybe I missed..

For some reason I cant get it to work.

 

Procon 1.5.1.1

Options => Plugins => Plugin security set to: Run Plugins with no restrictions.

 

Logger 1.0.0.2, placed all the required files in the plugin directory of Procon.

Entered my database credentials and ip address under plugin settings => Server Details.

 

Database server MySQL 5.6.2.1, I can make a remote connection with it.

 

When I enable the plugin:

Did I miss something?

 

Code:

[20:39:51 62] PRoCon Chat, GUID and Stats Logger Enabled
[20:39:51 62] PRoCon Chat, GUID and Stats Logger:  Floodprotection set to 10 Request per Round for each Player
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey RPG-7 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/SCAR-H/SCAR-H not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey USAS-12 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey M27IAR not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey M16A4 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey AEK-971 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/A91/A91 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/AK74M/AK74 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G36C/G36C not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G3A3/G3A3 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Gadgets/C4/C4 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Gadgets/Claymore/Claymore not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/KH2002/KH2002 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Knife/Knife not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MagpulPDR/MagpulPDR not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP412Rex/MP412REX not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP443/MP443 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Taurus .44 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/P90/P90 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Sa18IGLA/Sa18IGLA not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/UMP45/UMP45 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/XP1_L85A2/L85A2 not found!
[20:39:51 65] [Statslogger]Warning: PrepareKeywordDic: Mainkey Glock18 not found!
[20:39:54 66] [Statslogger]Info: Start tablebuilder
[20:39:54 69] [Statslogger]Warning: PrepareKeywordDic: Mainkey RPG-7 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/SCAR-H/SCAR-H not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey USAS-12 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey M27IAR not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey M16A4 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey AEK-971 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/A91/A91 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/AK74M/AK74 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G36C/G36C not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G3A3/G3A3 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Gadgets/C4/C4 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Gadgets/Claymore/Claymore not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/KH2002/KH2002 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Knife/Knife not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MagpulPDR/MagpulPDR not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP412Rex/MP412REX not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP443/MP443 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Taurus .44 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/P90/P90 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Sa18IGLA/Sa18IGLA not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/UMP45/UMP45 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/XP1_L85A2/L85A2 not found!
[20:39:54 71] [Statslogger]Warning: PrepareKeywordDic: Mainkey Glock18 not found!
[20:39:54 71] Error: System.Security.SecurityException: Request for the permission of type 'System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
   at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
   at System.Security.CodeAccessPermission.Demand()
   at System.Net.Sockets.Socket.CheckCacheRemote(EndPoint& remoteEP, Boolean isOverwrite)
   at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)
   at System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)
   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()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

Huge thanks in advance!

[ImportBot]

Originally Posted by ChaTon*:

 

A small error

Code:

[Statslogger]Error: getUpdateServerID1: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID(CServerInfo csiServerInfo) in c:\Users\B\Desktop\Procon\TDMNoshahr\Plugins\BF3\Temp\er9o-tfg.0.cs:line 6815

Any idea anyone ?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

A small error

Code:

[Statslogger]Error: getUpdateServerID1: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID(CServerInfo csiServerInfo) in c:\Users\B\Desktop\Procon\TDMNoshahr\Plugins\BF3\Temp\er9o-tfg.0.cs:line 6815

Any idea anyone ?

Nothing to be done right now, the writer of this plugin has been gone for a long time.

[ImportBot]

Originally Posted by mambochambo*:

 

Hello-

is there a way to add a command line for procon rulez,

so the Player visits will show, when he joins, and the plugin

acces the player information from Statslogger?

[ImportBot]

Originally Posted by kcuestag*:

 

Hello-

is there a way to add a command line for procon rulez,

so the Player visits will show, when he joins, and the plugin

acces the player information from Statslogger?

No need for that, there's an option already in this plugin to welcome players and show their stats, it's at the bottom of the plugin settings:

 

- Enable Welcomestats? Yes/No

[ImportBot]

Originally Posted by Checka_Wiemi*:

 

Hey we got a problem with Statslogger. It always shows the following errors:

 

"[12:49:55 75] [statslogger]Error: GetServerStats: System.OverflowException: Der Wert für einen Int32 war zu groß oder zu klein.

bei System.Convert.ToInt32(Int64 value)

bei System.Int64.System.IConvertible.ToInt32(IFormatPr ovider provider)

bei System.Convert.ToInt32(Object value)

bei PRoConEvents.CChatGUIDStatsLogger.GetServerStats(S tring SoldierName, Int32 delay, String scope)

[13:02:02 86] [statslogger]Error: GetServerStats: System.OverflowException: Der Wert für einen Int32 war zu groß oder zu klein.

bei System.Convert.ToInt32(Int64 value)

bei System.Int64.System.IConvertible.ToInt32(IFormatPr ovider provider)

bei System.Convert.ToInt32(Object value)

bei PRoConEvents.CChatGUIDStatsLogger.GetServerStats(S tring SoldierName, Int32 delay, String scope)"

 

Maybe someone knows a solution or can help me?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Hey we got a problem with Statslogger. It always shows the following errors:

 

"[12:49:55 75] [statslogger]Error: GetServerStats: System.OverflowException: Der Wert für einen Int32 war zu groß oder zu klein.

bei System.Convert.ToInt32(Int64 value)

bei System.Int64.System.IConvertible.ToInt32(IFormatPr ovider provider)

bei System.Convert.ToInt32(Object value)

bei PRoConEvents.CChatGUIDStatsLogger.GetServerStats(S tring SoldierName, Int32 delay, String scope)

[13:02:02 86] [statslogger]Error: GetServerStats: System.OverflowException: Der Wert für einen Int32 war zu groß oder zu klein.

bei System.Convert.ToInt32(Int64 value)

bei System.Int64.System.IConvertible.ToInt32(IFormatPr ovider provider)

bei System.Convert.ToInt32(Object value)

bei PRoConEvents.CChatGUIDStatsLogger.GetServerStats(S tring SoldierName, Int32 delay, String scope)"

 

Maybe someone knows a solution or can help me?

You have a value that's too large or too small to fit in a 32 bit integer. How old is your database?

[ImportBot]

Originally Posted by Checka_Wiemi*:

 

You have a value that's too large or too small to fit in a 32 bit integer. How old is your database?

Good question. I would say not older than one or one and a half years.

[ImportBot]

Originally Posted by mambochambo*:

 

Hello Guys- We are moving our Server to a new Provider-

the Server is high frequented and Players like competition and are looking for their stats-

is there a way to migrate it to another DB without losing the Data? i checked it, just changing

the IP in the Database Serverfile wont work....

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Hello Guys- We are moving our Server to a new Provider-

the Server is high frequented and Players like competition and are looking for their stats-

is there a way to migrate it to another DB without losing the Data? i checked it, just changing

the IP in the Database Serverfile wont work....

You need to change the IP in the tbl_server table for your old server to match what your new server IP is. Shut down your layers, change that IP to the new one, then since I assume you have your new server IP in there under a new ID you'll need to delete that one. Then reboot your layers.

[ImportBot]

Originally Posted by Tobsen03*:

 

I have this Error....

 

[10:42:26 21] [statslogger]Error: Error in UpdateCurrentPlayerTable:

[10:42:26 21] Message: Unable to connect to any of the specified MySQL hosts.

[10:42:26 21] Native: -2147467259

[10:42:26 21] Source: MySql.Data

[10:42:26 21] StackTrace: at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in :0

at MySql.Data.MySqlClient.Driver.Open () [0x00000] in :0

at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuild er settings) [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000] in :0

[10:42:26 21] InnerException: System.Net.Sockets.SocketException: Too many open files

at System.Net.Sockets.Socket..ctor (AddressFamily family, SocketType type, ProtocolType proto) [0x00000] in :0

at MySql.Data.Common.StreamCreator.CreateSocketStream (System.Net.IPAddress ip, Boolean unix) [0x00000] in :0

at MySql.Data.Common.StreamCreator.GetStreamFromHost (System.String pipeName, System.String hostName, UInt32 timeout) [0x00000] in :0

 

Please help me

[ImportBot]

Originally Posted by Tobsen03*:

 

unknown>:0

at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuild er settings) [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000] in :0

[12:34:15 82] InnerException: System.Net.Sockets.SocketException: Too many open files

at System.Net.Sockets.Socket..ctor (AddressFamily family, SocketType type, ProtocolType proto) [0x00000] in :0

at MySql.Data.Common.StreamCreator.CreateSocketStream (System.Net.IPAddress ip, Boolean unix) [0x00000] in :0

at MySql.Data.Common.StreamCreator.GetStreamFromHost (System.String pipeName, System.String hostName, UInt32 timeout) [0x00000] in :0

[12:34:53 65] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Net.Sockets.SocketException: Too many open files

at System.Net.Sockets.Socket..ctor (AddressFamily family, SocketType type, ProtocolType proto) [0x00000] in :0

at MySql.Data.Common.StreamCreator.CreateSocketStream (System.Net.IPAddress ip, Boolean unix) [0x00000] in :0

at MySql.Data.Common.StreamCreator.GetStreamFromHost (System.String pipeName, System.String hostName, UInt32 timeout) [0x00000] in :0

--- End of inner exception stack trace ---

at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in :0

at MySql.Data.MySqlClient.Driver.Open () [0x00000] in :0

at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuild er settings) [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000] in :0

[12:35:15 87] [statslogger]Error: Error in UpdateCurrentPlayerTable:

[12:35:15 87] Message: Unable to connect to any of the specified MySQL hosts.

[12:35:15 87] Native: -2147467259

[12:35:15 87] Source: MySql.Data

[12:35:15 87] StackTrace: at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in :0

at MySql.Data.MySqlClient.Driver.Open () [0x00000] in :0

at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuild er settings) [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000] in :0

[12:35:15 87] InnerException: System.Net.Sockets.SocketException: Too many open files

at System.Net.Sockets.Socket..ctor (AddressFamily family, SocketType type, ProtocolType proto) [0x00000] in :0

at MySql.Data.Common.StreamCreator.CreateSocketStream (System.Net.IPAddress ip, Boolean unix) [0x00000] in :0

at MySql.Data.Common.StreamCreator.GetStreamFromHost (System.String pipeName, System.String hostName, UInt32 timeout) [0x00000] in :0

[12:35:53 70] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Net.Sockets.SocketException: Too many open files

at System.Net.Sockets.Socket..ctor (AddressFamily family, SocketType type, ProtocolType proto) [0x00000] in :0

at MySql.Data.Common.StreamCreator.CreateSocketStream (System.Net.IPAddress ip, Boolean unix) [0x00000] in :0

at MySql.Data.Common.StreamCreator.GetStreamFromHost (System.String pipeName, System.String hostName, UInt32 timeout) [0x00000] in :0

--- End of inner exception stack trace ---

at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in :0

at MySql.Data.MySqlClient.Driver.Open () [0x00000] in :0

at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuild er settings) [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000] in :0

[12:36:15 88] [statslogger]Error: Error in UpdateCurrentPlayerTable:

[12:36:15 88] Message: Unable to connect to any of the specified MySQL hosts.

[12:36:15 89] Native: -2147467259

[12:36:15 89] Source: MySql.Data

[12:36:15 89] StackTrace: at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in :0

at MySql.Data.MySqlClient.Driver.Open () [0x00000] in :0

at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuild er settings) [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000] in :0

[12:36:15 89] InnerException: System.Net.Sockets.SocketException: Too many open files

at System.Net.Sockets.Socket..ctor (AddressFamily family, SocketType type, ProtocolType proto) [0x00000] in :0

at MySql.Data.Common.StreamCreator.CreateSocketStream (System.Net.IPAddress ip, Boolean unix) [0x00000] in :0

at MySql.Data.Common.StreamCreator.GetStreamFromHost (System.String pipeName, System.String hostName, UInt32 timeout) [0x00000] in :0

[12:36:30 13] [AdKats] ERROR-6800: [unable to download SQL updates.]

[12:36:53 73] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Net.Sockets.SocketException: Too many open files

at System.Net.Sockets.Socket..ctor (AddressFamily family, SocketType type, ProtocolType proto) [0x00000] in :0

at MySql.Data.Common.StreamCreator.CreateSocketStream (System.Net.IPAddress ip, Boolean unix) [0x00000] in :0

at MySql.Data.Common.StreamCreator.GetStreamFromHost (System.String pipeName, System.String hostName, UInt32 timeout) [0x00000] in :0

--- End of inner exception stack trace ---

at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in :0

at MySql.Data.MySqlClient.Driver.Open () [0x00000] in :0

at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuild er settings) [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on () [0x00000] in :0

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000] in :0

[12:37:23 82] [statslogger]Error: Error in UpdateCurrentPlayerTable:

[ImportBot]

Originally Posted by ty_ger07*:

 

You are overloading your database. You are exceeding your database's number of allowed queries within a short time period.

 

Who is your database host? If it is a free database host, you likely need to start paying money for a decent higher performance database.

[ImportBot]

Originally Posted by Tobsen03*:

 

We have a root Server with Debian

[ImportBot]

Originally Posted by jpy*:

 

You are overloading your database. If it is a free database host, you likely need to start paying money for a decent higher performance database.

I second that!