Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by OONicc*:

 

Thank You XPKiller for providing an awesome plugin for our BF4 server.

 

Problem- Welcome stats are working but the yell function is not.

 

When using.... [yell,3]Your Serverrank is: %playerRank% of %allRanks% .... this does not yell but will show in the chat.

 

Does the yell work for BF4? Did I overlook an option in the plugin?

 

Thank you for your time.

 

 

 

 

 

 

Every ingame messages can be yelled to the Player. Below are the instruction.

 

Just add the yelltag in front of every line of you message which should be yelled.

 

Usage:[yell,duration in seconds]Your messages

 

Like:[yell,3]Welcome on our server!

 

This would be yell for 3 seconds

 

Hint: You can mixed normal say and yell without any problems.

 

Messages without Tag will will be transmitted with the say command.

[ImportBot]

Originally Posted by ChaTon*:

 

While looking at the tbl_chatlog, i've found a repeated key for the logdate. Is this normal ?

Here is the structure that showed up:

Code:

CREATE TABLE `tbl_chatlog` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `logDate` datetime DEFAULT NULL,
  `ServerID` smallint(5) unsigned NOT NULL,
  `logSubset` varchar(45) DEFAULT NULL,
  `logSoldierName` varchar(45) DEFAULT NULL,
  `logMessage` text,
  `logPlayerID` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `INDEX_SERVERID` (`ServerID`),
  KEY `INDEX_logDate` (`logDate`),
  KEY `logPlayerID` (`logPlayerID`),
  KEY `logDate` (`logDate`),
  KEY `logDate_2` (`logDate`),
  KEY `logDate_3` (`logDate`),
  KEY `logDate_4` (`logDate`),
  KEY `logDate_5` (`logDate`),
  KEY `logDate_6` (`logDate`),
  KEY `logDate_7` (`logDate`),
  KEY `logDate_8` (`logDate`),
  KEY `logDate_9` (`logDate`),
  KEY `logDate_10` (`logDate`),
  CONSTRAINT `tbl_chatlog_ibfk_player_id` FOREIGN KEY (`logPlayerID`) REFERENCES `tbl_playerdata` (`PlayerID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9378782 DEFAULT CHARSET=utf8;

[ImportBot]

Originally Posted by Prophet731*:

 

While looking at the tbl_chatlog, i've found a repeated key for the logdate. Is this normal ?

Here is the structure that showed up:

Code:

CREATE TABLE `tbl_chatlog` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `logDate` datetime DEFAULT NULL,
  `ServerID` smallint(5) unsigned NOT NULL,
  `logSubset` varchar(45) DEFAULT NULL,
  `logSoldierName` varchar(45) DEFAULT NULL,
  `logMessage` text,
  `logPlayerID` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `INDEX_SERVERID` (`ServerID`),
  KEY `INDEX_logDate` (`logDate`),
  KEY `logPlayerID` (`logPlayerID`),
  KEY `logDate` (`logDate`),
  KEY `logDate_2` (`logDate`),
  KEY `logDate_3` (`logDate`),
  KEY `logDate_4` (`logDate`),
  KEY `logDate_5` (`logDate`),
  KEY `logDate_6` (`logDate`),
  KEY `logDate_7` (`logDate`),
  KEY `logDate_8` (`logDate`),
  KEY `logDate_9` (`logDate`),
  KEY `logDate_10` (`logDate`),
  CONSTRAINT `tbl_chatlog_ibfk_player_id` FOREIGN KEY (`logPlayerID`) REFERENCES `tbl_playerdata` (`PlayerID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9378782 DEFAULT CHARSET=utf8;

No that is not normal. Delete the keys logDate 2 thru 10

[ImportBot]

Originally Posted by Helskov*:

 

I got some problems. Some players are reporting their ranks are wrong.

One player where rank 8 out of 67726. now he his 4647. He is playing everyday.

 

How can this happen?

 

when i lookup the affected player in playerdata he is listed twice.

With same name, guid and IP. Everything is identical.

[ImportBot]

Originally Posted by Lucky567*:

 

I have the same problem. I have seen that with the same EAID incorrect GameID has the new user. New Game ID 0. Old Player Game ID is 1

BF4 ID1

BFHL ID 2

[ImportBot]

Originally Posted by ColColonCleaner*:

 

I got some problems. Some players are reporting their ranks are wrong.

One player where rank 8 out of 67726. now he his 4647. He is playing everyday.

 

How can this happen?

 

when i lookup the affected player in playerdata he is listed twice.

With same name, guid and IP. Everything is identical.

This is a stat logger bug, the game id of the plugin reset mid run. Shut down your layers, delete all players with gameid = 0, start your layers. The stats will then return to normal.

[ImportBot]

Originally Posted by Lucky567*:

 

Ok thanks, it's worked

[ImportBot]

Originally Posted by Helskov*:

 

How do i do that?

directly in mysql?

I got 412 players with gameid 0

 

Edit:

Did following which deleted 412 records.

 

DELETE FROM tbl_playerdata WHERE gameid = 0;

[ImportBot]

Originally Posted by ColColonCleaner*:

 

How do i do that?

directly in mysql?

I got 412 players with gameid 0

 

Edit:

Did following which deleted 412 records.

 

DELETE FROM tbl_playerdata WHERE gameid = 0;

Yep that will do it, hope your layers were offline when you did it.

[ImportBot]

Originally Posted by Helskov*:

 

Yep that will do it, hope your layers were offline when you did it.

Yep they where offline.

And players are reporting their rank are correct again.

But got some errors now in the plugin. Will look into that later

[ImportBot]

Originally Posted by Mamba334*:

 

Am I missing something guys? Fragnet enabled this and it's in my procon / plugins, but when we type !rank nothing pops up. Thanks.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Am I missing something guys? Fragnet enabled this and it's in my procon / plugins, but when we type !rank nothing pops up. Thanks.

You probably just haven't set anything up for it yet. I'll do it when i handle the rest of your stuff. Please open a pm with me containing your db and layer credentials.

[ImportBot]

Originally Posted by jaguarphd*:

 

In the same boat as some others, this plugin does not seem to work for Bad Company 2.

 

The tables are created, the current players table is populated and the chat log functions correctly, but no stats are being saved, either player or map.

 

After leaving trace debug on for a few hours, it doesn't look like it ever even makes the attempt to save the data - I get a few warnings about weapons missing from the BFBC2.def file, but that's about it. Any idea why this would not be saving stats data?

[ImportBot]

Originally Posted by ty_ger07*:

 

In the same boat as some others, this plugin does not seem to work for Bad Company 2.

 

The tables are created, the current players table is populated and the chat log functions correctly, but no stats are being saved, either player or map.

 

After leaving trace debug on for a few hours, it doesn't look like it ever even makes the attempt to save the data - I get a few warnings about weapons missing from the BFBC2.def file, but that's about it. Any idea why this would not be saving stats data?

It doesn't work because XpKiller didn't do something correctly in his code to allow it to work. This has been an ongoing issue forever with this version and cannot be fixed without XpKiller fixing his code. Since XpKiller does not seem to be around any more to support this plugin, this issue will not be fixed any time soon.

 

As others have done, perhaps you should consider going back to a previous version of this plugin which was specifically designed to work with BF:BC2.

showthread....-3-0-2-2-01-02*

[ImportBot]

Originally Posted by jaguarphd*:

 

It doesn't work because XpKiller didn't do something correctly in his code to allow it to work. This has been an ongoing issue forever with this version and cannot be fixed without XpKiller fixing his code. Since XpKiller does not seem to be around any more to support this plugin, this issue will not be fixed any time soon.

 

As others have done, perhaps you should consider going back to a previous version of this plugin which was specifically designed to work with BF:BC2.

showthread....-3-0-2-2-01-02*

Thanks! I'll check this out.

[ImportBot]

Originally Posted by Hawk*:

 

The old BC2 plugin only works with MySQL odbc 5.1 driver so if anyone finds a hosting for that please let me know...

[ImportBot]

Originally Posted by Gijzijtdood*:

 

Hi all,

 

My provider gave me a new procon layer and now this plugin won't work.

I emptied the mysql database but i still get this error.

 

[statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Can't get hostname for your address

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

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)

[17:03:09 59] Error in Tablebuilder:

[17:03:09 59] Message: Can't get hostname for your address

[17:03:09 59] Native: -2147467259

[17:03:09 59] Source: MySql.Data

[17:03:09 59] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

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

[17:03:09 59] 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?

 

Kind regards

[ImportBot]

Originally Posted by ty_ger07*:

 

Ask your layer host why it can't communicate with your database. Sounds like a firewall on the procon layer is blocking the connection to your database.

[ImportBot]

Originally Posted by dzieju*:

 

Hi there

 

Can you help me with that ?

 

[00:04:04 07] Error: System.InvalidOperationException: Transaction has already been rolled back or is not pending

w MySql.Data.MySqlClient.MySqlTransaction.Rollback()

w PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

 

 

My site dzieju.pl not showing CHAT :/

[ImportBot]

Originally Posted by Smellblood95*:

 

Hello,

 

I have this plugin on my server for a while now and it runs very good. Yet I want to reset the stats once a month. What is the savest way to back up my Mysql database and have everything set to 0 within the mysql database?

 

thanks in advance

 

Smellblood95

[ImportBot]

Originally Posted by ty_ger07*:

 

Hello,

 

I have this plugin on my server for a while now and it runs very good. Yet I want to reset the stats once a month. What is the savest way to back up my Mysql database and have everything set to 0 within the mysql database?

 

thanks in advance

 

Smellblood95

The safest way is to just start a new database every month.

 

Backing up these databases is an unreliable venture. Because of all the foreign key constraints, because clans usually use budget services with limited resources, and because stats databases are usually large in size, backup attemps are often half-broken due to timeouts and the problem isn't noticed until later when you attempt to restore the corrupt backup.

 

All the foreign key constraints cause just a tiny amount of missing/corrupted data to potentially cause huge issues. I wouldn't advise going down that path.

[ImportBot]

Originally Posted by NDBoost*:

 

hey everyone, trying to get this working on a trinity games bf4 server and getting the following error... I am able to login to the mysql server remotely fine and perform all the intended queries such as creating tables and such fine..

 

 

[19:10:31 41] 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.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

[19:10:31 41] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[19:10:31 41] [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.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

[ImportBot]

Originally Posted by dzieju*:

 

Hi guys

 

How to delete only Top 20 Players This Week stats ?

[ImportBot]

Originally Posted by Gijzijtdood*:

 

Hi all,

 

Now i'm getting this error messages.

 

[19:19:34 66] [statslogger]Error: Error in Startstreaming:

[19:19:34 66] Message: Cannot add or update a child row: a foreign key constraint fails (`90149_clientdb`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[19:19:34 66] Native: -2147467259

[19:19:34 66] Source: MySql.Data

[19:19:34 66] 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.StartStreaming()

[19:19:34 85] [statslogger]Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

[19:19:35 49] [statslogger]Error: getUpdateServerID1: System.InvalidOperationException: Nested transactions are not supported.

at MySql.Data.MySqlClient.ExceptionInterceptor.Throw( Exception exception)

at MySql.Data.MySqlClient.MySqlConnection.Throw(Excep tion ex)

at MySql.Data.MySqlClient.MySqlConnection.BeginTransa ction(IsolationLevel iso)

at MySql.Data.MySqlClient.MySqlConnection.BeginTransa ction()

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

Any idea what is wrong?

 

Kind regards

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Hi all,

 

Now i'm getting this error messages.

 

 

 

Any idea what is wrong?

 

Kind regards

Did....did you delete a server from the tbl_server table?

[ImportBot]

Originally Posted by Gijzijtdood*:

 

The safest way is to just start a new database every month.

 

Backing up these databases is an unreliable venture. Because of all the foreign key constraints, because clans usually use budget services with limited resources, and because stats databases are usually large in size, backup attemps are often half-broken due to timeouts and the problem isn't noticed until later when you attempt to restore the corrupt backup.

 

All the foreign key constraints cause just a tiny amount of missing/corrupted data to potentially cause huge issues. I wouldn't advise going down that path.

This is a good way to set all to 0.

 

START TRANSACTION;

 

set @ServerID = 1;

 

DELETE tps FROM tbl_playerstats tps

INNER JOIN tbl_server_player tsp ON tps.StatsID = tsp.StatsID

WHERE tsp.ServerID = @ServerID;

 

DELETE tws FROM tbl_weapons_stats tws

INNER JOIN tbl_server_player tsp ON tws.StatsID = tsp.StatsID

WHERE tsp.ServerID = @ServerID;

 

DELETE ts FROM tbl_sessions ts

INNER JOIN tbl_server_player tsp ON ts.StatsID = tsp.StatsID

WHERE tsp.ServerID = @ServerID;

 

DELETE tdt FROM tbl_dogtags tdt

INNER JOIN tbl_server_player tsp ON tdt.KillerID = tsp.StatsID

WHERE tsp.ServerID = @ServerID;

 

DELETE tpr FROM tbl_playerrank tpr

INNER JOIN tbl_server_player tsp ON tpr.PlayerID = tsp.StatsID

WHERE tsp.ServerID = @ServerID;

 

DELETE tpd FROM tbl_playerdata tpd

INNER JOIN tbl_server_player tsp ON tpd.PlayerID = tsp.StatsID

WHERE tsp.ServerID = @ServerID;

 

COMMIT;

Set the server ID accordingly to the server you want to reset.

 

Regards

[ImportBot]

Originally Posted by Gijzijtdood*:

 

Did....did you delete a server from the tbl_server table?

I started with an empty database to be shure. But still the same error :/

[ImportBot]

Originally Posted by Gijzijtdood*:

 

I started with an empty database to be shure. But still the same error :/

Got it. Had to delete the plugin dll file and start it back up.

 

Greetings,

[ImportBot]

Originally Posted by ty_ger07*:

 

This is a good way to set all to 0.

 

 

 

Set the server ID accordingly to the server you want to reset.

 

Regards

Ok? What's your point?

 

He said that he wanted to backup the old database first, and then delete everything. You didn't address the backing up part of his question. Backing it up is where things go badly. Instead of backing it up and then deleting everything, it is MUCH better to just start a new database. By doing that, you get the exact same result except in less time and gain a lot of reliability.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Ok? What's your point?

 

He said that he wanted to backup the old database first, and then delete everything. You didn't address the backing up part of his question. Backing it up is where things go badly. Instead of backing it up and then deleting everything, it is MUCH better to just start a new database. By doing that, you get the exact same result except in less time and gain a lot of reliability.

Just to jut in here, agreed, for stat logger if you want snapshots of your database left intact it is much better to just make a new schema for the current servers and leave the old alone. Not sure how many schemas you are allowed to have on your db but hopefully it's more than one.