Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by SharpSabre*:

 

It's not possible as far as I know. The old version works better with BFBC2 anyways. You should probably stick with what you have.

I would save my stats ,just. np

Yeah, honestly, I could never figure that out either. This version should be 1.1.0.2, right?

Yea of curse So in new version you will correct it

Now i got new problem with "yell" in new version so what i must do ?

[ImportBot]

Originally Posted by SharpSabre*:

 

Getting this error,

 

Anybody an idea whats wrong?

 

Info: OnLevelLoaded: MP_Siege Gamemode: ConquestLarge0 Round: 1/1

[18:30:46 17] Info: update sql server

[18:30:46 17] Info: Started streaming to the DB-Server

[18:30:46 30] Error: Error in Startstreaming:

[18:30:46 30] Message: Column 'Gameplay_deaths' specified twice

[18:30:46 30] Native: -2147467259

[18:30:46 30] Source: MySql.Data

[18:30:46 30] 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.CChatGUIDStatsLoggerBF3.StartStreamin g()

You are using 1.1.0.1 and this topic is for 1.0.0.2(newer than 1.1.0.1)

[ImportBot]

Originally Posted by ty_ger07*:

 

I would save my stats ,just. np

 

Yea of curse So in new version you will correct it

Now i got new problem with "yell" in new version so what i must do ?

It's not yelling long enough? Or so quick that it doesn't show?

 

BFBC2 uses milliseconds for yells. But this plugin assumes that it should be seconds because BF3 and BF4 use seconds for yell duration. So, if you are yelling stats or yelling welcome back or whatever, the default few seconds for BF4 or BF3 will only be a few milliseconds in BFBC2 and won't even appear.

 

You will need to adjust the yell length. It's been a long time since I have had a server, but if I remember right, I think you want something like [Yell,3000] to do 3000 milliseconds instead of 3 milliseconds. I can't remember the format. It might be [Yell,3000] or [3000,Yell] or who knows. You'll figure it out I am sure. And it doesn't have to be 3000 milliseconds either of course. You could yell it for 1245 milliseconds if you wanted to.

[ImportBot]

Originally Posted by AmcieK*:

 

Hello.

I have a small question to change supplier and want to move my stats. The import export database without erros. But no statistics available Any ideas?

[ImportBot]

Originally Posted by Tobsen03*:

 

Hello guys ...

 

I need a Multiplikator vor my Ranks....

 

I have 4 Server ( 1. Metro Only ,2. Locker Only , 3. CQ Vehicle Server , 4 . Pistol Server )....

 

I want that the Points from the Pistol Server x 1,5 and the CQ Vehicle x 0,5 ......

 

Sry for my bad languarge..

[ImportBot]

Originally Posted by SharpSabre*:

 

It's not yelling long enough? Or so quick that it doesn't show?

 

BFBC2 uses milliseconds for yells. But this plugin assumes that it should be seconds because BF3 and BF4 use seconds for yell duration. So, if you are yelling stats or yelling welcome back or whatever, the default few seconds for BF4 or BF3 will only be a few milliseconds in BFBC2 and won't even appear.

 

You will need to adjust the yell length. It's been a long time since I have had a server, but if I remember right, I think you want something like [Yell,3000] to do 3000 milliseconds instead of 3 milliseconds. I can't remember the format. It might be [Yell,3000] or [3000,Yell] or who knows. You'll figure it out I am sure. And it doesn't have to be 3000 milliseconds either of course. You could yell it for 1245 milliseconds if you wanted to.

I am Talking about BF3 and doesn't show Yell Welcome and Player stats Messages .. just used say to show Might you used milliseconds format at all ?

Hello.

I have a small question to change supplier and want to move my stats. The import export database without erros. But no statistics available Any ideas?

using Navicat and Dump with all options . you need export all records too . it's mean you imported just structure of your database and no records .

[ImportBot]

Originally Posted by AmcieK*:

 

Yea i use it . But still no stats .

[ImportBot]

Originally Posted by gorgee*:

 

Hello ! I have set the top10ten interval days to 1 and after 3 days now it dont reset the stats on my database do i do anything wrong?

[ImportBot]

Originally Posted by SharpSabre*:

 

Yea i use it . But still no stats .

Usage (version 11.0.8) : Right Click on Database Name , Select "Dump SQL File" then use "Structure and Data"

Hello ! I have set the top10ten interval days to 1 and after 3 days now it dont reset the stats on my database do i do anything wrong?

Might needed wait for ending the last season .

[ImportBot]

Originally Posted by rbrogers*:

 

Is anybody using this plugin with NFO Servers? I'm trying to get this setup and would love some guidance. I've tried searching the NFO forums and chatted with technical support with no success.

 

This is the error I'm getting:

[01:07:57 62] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Authentication to host 'xxx.xxx.xx.xx' for user 'houseofpain' using method 'mysql_native_password' failed with message: Access denied for user 'houseofpain'@'ipxx-xx-xxx-xx.ph.ph.cox.net' (using password: YES) ---> MySql.Data.MySqlClient.MySqlException: Access denied for user 'houseofpain'@'ipxx-xx-xxx-xx.ph.ph.cox.net' (using password: YES)

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

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

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.AuthenticationFailed(Exception ex)

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)

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.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) in c:\Users\Ray\Desktop\pro con\Plugins\BF4\Temp\umgwdkod.0.cs:line 6770

[ImportBot]

Originally Posted by Taman*:

 

Help me please i get this error when i try to set it up :

[21:53:37 45] Error in Tablebuilder:

[21:53:37 45] Message: Unable to connect to any of the specified MySQL hosts.

[21:53:37 45] Native: -2147467259

[21:53:37 45] Source: MySql.Data

[21:53:37 45] 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.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()

[21:53:37 45] 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 66.147.244.189: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()

[21:53:37 45] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

and this one too

[statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> 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 66.147.244.189: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()

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

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)

my database information is correct and i can connect the database with Mysql workbnech :

my website is on bluehost does anyone have any idea what could be the problem?

i have tried to use this free database db4free.net and i can connect to it without any problems: why it doesnt work at bluehost database!? is there any thing

[ImportBot]

Originally Posted by Taman*:

 

Ok

do i need to enable INNODB manually when i create a database? if so how to do that!

[ImportBot]

Originally Posted by UKF_HHA*:

 

I changed my bf4 server IP & I changed everything related to it.

I did put back host etc... in Chat plugin, then it seems like everything got resetted.

Please can you help me?

[ImportBot]

Originally Posted by SharpSabre*:

 

Is anybody using this plugin with NFO Servers? I'm trying to get this setup and would love some guidance. I've tried searching the NFO forums and chatted with technical support with no success.

 

This is the error I'm getting:

[01:07:57 62] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Authentication to host 'xxx.xxx.xx.xx' for user 'houseofpain' using method 'mysql_native_password' failed with message: Access denied for user 'houseofpain'@'ipxx-xx-xxx-xx.ph.ph.cox.net' (using password: YES) ---> MySql.Data.MySqlClient.MySqlException: Access denied for user 'houseofpain'@'ipxx-xx-xxx-xx.ph.ph.cox.net' (using password: YES)

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

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

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.AuthenticationFailed(Exception ex)

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.ReadPacket()

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)

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.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) in c:\Users\Ray\Desktop\pro con\Plugins\BF4\Temp\umgwdkod.0.cs:line 6770

Check User Pass of your MYSQL ..

Help me please i get this error when i try to set it up :

 

and this one too

 

 

 

my database information is correct and i can connect the database with Mysql workbnech :

my website is on bluehost does anyone have any idea what could be the problem?

i have tried to use this free database db4free.net and i can connect to it without any problems: why it doesnt work at bluehost database!? is there any thing

Check your access from your home computer to connect by Navicat , if can , may problem been Firewall of Host Server .

I changed my bf4 server IP & I changed everything related to it.

I did put back host etc... in Chat plugin, then it seems like everything got resetted.

Please can you help me?

Before change u needed to save Configs (in ProCon folder). maybe you will can change last config for now to new host , it saved as xx.xx.xx.xx_yyyyy and also into that .

[ImportBot]

Originally Posted by ty_ger07*:

 

I changed my bf4 server IP & I changed everything related to it.

I did put back host etc... in Chat plugin, then it seems like everything got resetted.

Please can you help me?

Everything didn't get reset. It just created a new server in the database because the IP aedress changed. You can cause the new host to inherit the old stats. Please search this thread. I have already answered this question at least 4 times.

 

Edit:

View this post:

myrcon.net/...chat-guid-stats-and-mapstats-logger#entry45736

[ImportBot]

Originally Posted by MegaThorx*:

 

[17:24:59 62] [statslogger]Error: getUpdateServerID1: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

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

bei System.Security.CodeAccessPermission.Demand()

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

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

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

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

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

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

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

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

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

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

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

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

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

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

bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

Is there a way to bypass that sh*t? Stupid provider...

[ImportBot]

Originally Posted by MRniceGuy*:

 

Hi

theres some problem with the plugin

sometimes it doesnt save stats for some players

why!

[ImportBot]

Originally Posted by v3rs0*:

 

Hello,

 

I am using it since more than a month and today i discovered this error:

 

[statslogger]Error: getUpdateServerID1: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

How to fix it ?

 

Thank you

[ImportBot]

Originally Posted by MRniceGuy*:

 

does anyone else have this problem that the stats sometimes doesnt save for some players!?

this is the stats page http://demonlords.net/playerstats/ its been a couple days i use it

for example i have a friend usually playing on my server named "Tonts4"

he told me that his stats has same kill score and he always play in the server :/

what could be the problem! i'm afraid if this is for many more players

 

i have also noticed that Stats webpage by ty_ger07 shows different amount of score kills / deaths

for example here http://demonlords.net/playerstats

on the home page number 2 player named "powershoot555" have 660 kills, and if you click on his name it says 702 kills, i dont get it XD

[ImportBot]

Originally Posted by ty_ger07*:

 

I can't speak for XpKiller's plugin, but I would like to point out that my stats webpage only updates the top 20 people on the leaderboard twice a day. That's why the top 20 people on the leaderboard have different stats in the leaderboard compared to their player stats page. The stats on the player's stats page is not cached (except for the player stats signature image at the bottomg which also uses cached data when calculating the player's rank [for performance reasons in case that player shows off their signature image all over the net -- to keep the database from falling to its knees]).

 

For performance reasons, my stats page code caches the top 20 player data for 12 hour intervals. This is done because it is the main page and default page of the stats page and can create a large amount of load on the database if the top 20 people were calculated realtime every time; especially if you had a million players stored in your database and a few people browsing your stats webpage at the same time.

 

Usually, organizations with hundreds of thousands of players in their database don't even notice that the top 20 players' data is slightly off because the numbers become so huge that the inaccuracy of the cache is only a small percentage. But, if you have a relatively small database where a player can change their stats by a huge percentage in only a few hours of play, the inaccuracy of the cache becomes more obvious.

[ImportBot]

Originally Posted by ChironeX-BF3*:

 

[statslogger]Error: getUpdateServerID1: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

Hi, any solution for this ?

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi, any solution for this ?

I think that the majority of us in this english forum section don't understand your german error message.

[ImportBot]

Originally Posted by ChironeX-BF3*:

 

I think that the majority of us in this english forum section don't understand your german error message.

I am not German and do not understand it tough the server is hosted @ g-portal.

 

Translated message to english (thx google translate): Object reference not set to an object instance.

 

That message happend when a round is finished, everything is still logged.

 

Also wanted to tank you for your great job with that stats page ty_ger07, it's awesome, especially to find "suspicious player"

[ImportBot]

Originally Posted by MRniceGuy*:

 

I can't speak for XpKiller's plugin, but I would like to point out that my stats webpage only updates the top 20 people on the leaderboard twice a day. That's why the top 20 people on the leaderboard have different stats in the leaderboard compared to their player stats page. The stats on the player's stats page is not cached (except for the player stats signature image at the bottomg which also uses cached data when calculating the player's rank [for performance reasons in case that player shows off their signature image all over the net -- to keep the database from falling to its knees]).

 

For performance reasons, my stats page code caches the top 20 player data for 12 hour intervals. This is done because it is the main page and default page of the stats page and can create a large amount of load on the database if the top 20 people were calculated realtime every time; especially if you had a million players stored in your database and a few people browsing your stats webpage at the same time.

 

Usually, organizations with hundreds of thousands of players in their database don't even notice that the top 20 players' data is slightly off because the numbers become so huge that the inaccuracy of the cache is only a small percentage. But, if you have a relatively small database where a player can change their stats by a huge percentage in only a few hours of play, the inaccuracy of the cache becomes more obvious.

I understood

thanks to reply i was really confused

[ImportBot]

Originally Posted by uncut1980berlin*:

 

Hello,

i've got some errors at chat tab and serverinfo:

 

http://fs1.directupload.net/images/150115/5wwvuij4.png

 

http://fs1.directupload.net/images/150115/4fz4of5z.png

 

some ideas to fix it ? Thank you very much

[ImportBot]

Originally Posted by ty_ger07*:

 

Hello,

i've got some errors at chat tab and serverinfo:

 

http://fs1.directupload.net/images/150115/5wwvuij4.png

 

http://fs1.directupload.net/images/150115/4fz4of5z.png

 

some ideas to fix it ? Thank you very much

myrcon.net/...stats-webpage-for-xpkillers-stats-logger-plugin#entry48078

[ImportBot]

Originally Posted by DarkZerO_AT*:

 

im having a different problem, sorry if it was asked before

 

but we had to switch our gameserver host and i would like to transfer the database to a new mysql server

i tried importing following tables

 

tbl_playerdata

tbl_playerrank

tbl_playerstats

 

but it seems like it doesnt work

everyone started from scratch

 

what am i missing?

[ImportBot]

Originally Posted by SharpSabre*:

 

im having a different problem, sorry if it was asked before

 

but we had to switch our gameserver host and i would like to transfer the database to a new mysql server

i tried importing following tables

 

tbl_playerdata

tbl_playerrank

tbl_playerstats

 

but it seems like it doesnt work

everyone started from scratch

 

what am i missing?

what's wrong ? tables are empty ?

connect with Navicat and try use "Dump" them .

[ImportBot]

Originally Posted by DarkZerO_AT*:

 

what's wrong ? tables are empty ?

connect with Navicat and try use "Dump" them .

thats exactly what i did

tables are there and stats etc are all filled in correctly but if i try !rank on the server it shows me not the correct stats, instead completely new from scratch

[ImportBot]

Originally Posted by ty_ger07*:

 

Due to foreign key constraints, you have to export the database all in one huge piece and import it all in one huge piece. You cannot try to export and import individual missing tables by themselves. You need to find a way to export and import the whole thing without it timing out during the process. Sometimes the server host has an option somewhere in the server control panel to backup and restore databases and it you choose that option, it should be able to do it all in one step without timing out. Otherwise, you can contact your server host and ask for their support staff to export or import the entire database manually on the machine directly so that it completes in one step without timing out.