Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[Hedius]

1 minute ago, to22ek said:

When i type something on chat its shows on database. When switching to another debug level i see only followed guns and not suported guns like p90 or jng 90

Looks like that version of the plugin is not compatible with BC2.

 

[To22ek95PL]

Ok. Some days ago i try this plugin. When its launched i dont see all my plugins and have this on procon console 

[05:10:37 03] Inheritance security rules violated when replacing member: procon.core.plugin.cproconpluginloaderfactory.initializelifetimeservice (). the availability of the replacement method's security must be the same as the availability

 

[To22ek95PL]

Anyone can help?

[TonyOffermans]

Anyone able to help me with this? I am moving my DB contents to another provider. I created a self-extracting dump file that contains the entire structure and data. I used this procedure before against the original tables. But when I try to restore my dump into the new schema it throws an error when creating the tbl_playerdata:

ERROR 1293 (HY000) at line 1282: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

Version used for the dump: MySQL dump 10.16  Distrib 10.1.41-MariaDB, for debian-linux-gnu (x86_64)
My new provider has MySQL 5.5.60-MariaDB. I am reading the TIMESTAMP limitation has been lifted in MySQL 5.6
Is there a workaround feasible? Like using DATETIME NOW() instead of the first TIMESTAMP? Should I ask my provider to update to a more recent version? Or am I doomed?

When I start AdKats regardless, it tries to ADD the columns but only succeeds in adding the 'created at' and produces a lot of errors for non-existent admin users...

This is the generated script from the dump:

--
-- Table structure for table `tbl_playerdata`
--

DROP TABLE IF EXISTS `tbl_playerdata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_playerdata` (
  `PlayerID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `GameID` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `ClanTag` varchar(10) DEFAULT NULL,
  `SoldierName` varchar(45) DEFAULT NULL,
  `GlobalRank` smallint(5) unsigned NOT NULL DEFAULT '0',
  `PBGUID` varchar(32) DEFAULT NULL,
  `EAGUID` varchar(35) DEFAULT NULL,
  `IP_Address` varchar(15) DEFAULT NULL,
  `DiscordID` varchar(50) DEFAULT NULL,
  `IPv6_Address` varbinary(16) DEFAULT NULL,
  `CountryCode` varchar(2) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`PlayerID`),
  UNIQUE KEY `UNIQUE_playerdata` (`GameID`,`EAGUID`),
  KEY `INDEX_SoldierName` (`SoldierName`),
  KEY `created_at` (`created_at`),
  KEY `updated_at` (`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=110949 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

...

 

[Prophet731]

11 minutes ago, TonyOffermans said:

Anyone able to help me with this? I am moving my DB contents to another provider. I created a self-extracting dump file that contains the entire structure and data. I used this procedure before against the original tables. But when I try to restore my dump into the new schema it throws an error when creating the tbl_playerdata:

ERROR 1293 (HY000) at line 1282: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

Version used for the dump: MySQL dump 10.16  Distrib 10.1.41-MariaDB, for debian-linux-gnu (x86_64)
My new provider has MySQL 5.5.60-MariaDB. I am reading the TIMESTAMP limitation has been lifted in MySQL 5.6
Is there a workaround feasible? Like using DATETIME NOW() instead of the first TIMESTAMP? Should I ask my provider to update to a more recent version? Or am I doomed?

When I start AdKats regardless, it tries to ADD the columns but only succeeds in adding the 'created at' and produces a lot of errors for non-existent admin users...

This is the generated script from the dump:

--
-- Table structure for table `tbl_playerdata`
--

DROP TABLE IF EXISTS `tbl_playerdata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_playerdata` (
  `PlayerID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `GameID` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `ClanTag` varchar(10) DEFAULT NULL,
  `SoldierName` varchar(45) DEFAULT NULL,
  `GlobalRank` smallint(5) unsigned NOT NULL DEFAULT '0',
  `PBGUID` varchar(32) DEFAULT NULL,
  `EAGUID` varchar(35) DEFAULT NULL,
  `IP_Address` varchar(15) DEFAULT NULL,
  `DiscordID` varchar(50) DEFAULT NULL,
  `IPv6_Address` varbinary(16) DEFAULT NULL,
  `CountryCode` varchar(2) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`PlayerID`),
  UNIQUE KEY `UNIQUE_playerdata` (`GameID`,`EAGUID`),
  KEY `INDEX_SoldierName` (`SoldierName`),
  KEY `created_at` (`created_at`),
  KEY `updated_at` (`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=110949 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

...

 

Edit your database tables and change the fields created_at and updated_at from timestamp type to datetime type. Then re-dump the tables and import again. See if that fixes it.

[TonyOffermans]

22 hours ago, Prophet731 said:

`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

I just changed this into `created_at` datetime NOT NULL and the table was defined properly and I got all my data restored. Btw I also had to remove a lot of DEFINER= statements from the dump because my credentials were different on the new SQL server. (I used the cygwin sed utility to do it in one pass: huge dump file). And update the tbl_server to reflect my new IP address and keep all the stats from the existing serverID. That's basically what was needed.
Thanks for the support!

 

 

[TonyOffermans]

29 minutes ago, TonyOffermans said:

I just changed this into `created_at` datetime NOT NULL and the table was defined properly and I got all my data restored. Btw I also had to remove a lot of DEFINER= statements from the dump because my credentials were different on the new SQL server. (I used the cygwin sed utility to do it in one pass: huge dump file). And update the tbl_server to reflect my new IP address and keep all the stats from the existing serverID. That's basically what was needed.
Thanks for the support!

 

 

Well, still problems...
When I checked the data, it appears all new players have a created_at value of 0000-00-00 00:00:00.

I could not set a default value for the datatype as it is not accepted prior MySQL 5.6. Of course I can set it on the old SQL server (which has 5.6.5) but I will run into the same problems again.
Not sure why, but these are the only TIMESTAMP expressions in the DB (all others are DATETIME) so it must be for some reason.... Any suggestions?

[maxdralle]

change "NOT NULL" to "CURRENT_TIMESTAMP" in table structure

 

[TonyOffermans]

54 minutes ago, maxdralle said:

change "NOT NULL" to "CURRENT_TIMESTAMP" in table structure

 

Yes this would be the solution but as posted before, it is not accepted in this version. I fixed it by adding a trigger:
delimiter |
create trigger fix_datetime
before insert on tbl_playerdata
for each row begin
    SET NEW.created_at = NOW();
end |
DELIMITER ;

Far from ideal but it works. Table is updated properly on creating new playerID's
Thanks all for your fine support!!

[TIGER_GHOSTPL]

Hello please help me . I have a problem installing the plugin adkats .

[02:09:27 07] [Event Logger] Enabled!
[02:09:29 47] [AdKats] ENABLED! Beginning startup sequence...
[02:09:30 28] [AdKats] SUCCESS: Fetched 64 BF3 weapon stat definitions.
[02:09:30 53] [AdKats] SUCCESS: Fetched reputation definitions.
[02:09:30 81] [AdKats] SUCCESS: Fetched weapon information.
[02:09:30 90] [AdKats] SUCCESS: Fetched special player group definitions.
[02:09:31 34] [AdKats] SUCCESS: Server IP is .......................
[02:09:31 34] [AdKats] SUCCESS: Database connection open.
[02:09:31 34] [AdKats] ERROR-7604: [Tables from XPKiller's Stat Logger not present in the database. Enable that plugin then re-run AdKats!]
[02:09:31 34] [AdKats] INFO: Shutting down AdKats.
[02:09:31 37] [AdKats] SUCCESS: Database timing confirmed.
[02:09:31 89] [AdKats] AdKats 7.6.0.4 Disabled! =(

 

 

 

[Hedius]

19 minutes ago, TIGER_GHOSTPL said:

Hello please help me . I have a problem installing the plugin adkats .

[02:09:27 07] [Event Logger] Enabled!
[02:09:29 47] [AdKats] ENABLED! Beginning startup sequence...
[02:09:30 28] [AdKats] SUCCESS: Fetched 64 BF3 weapon stat definitions.
[02:09:30 53] [AdKats] SUCCESS: Fetched reputation definitions.
[02:09:30 81] [AdKats] SUCCESS: Fetched weapon information.
[02:09:30 90] [AdKats] SUCCESS: Fetched special player group definitions.
[02:09:31 34] [AdKats] SUCCESS: Server IP is .......................
[02:09:31 34] [AdKats] SUCCESS: Database connection open.
[02:09:31 34] [AdKats] ERROR-7604: [Tables from XPKiller's Stat Logger not present in the database. Enable that plugin then re-run AdKats!]
[02:09:31 34] [AdKats] INFO: Shutting down AdKats.
[02:09:31 37] [AdKats] SUCCESS: Database timing confirmed.
[02:09:31 89] [AdKats] AdKats 7.6.0.4 Disabled! =(

 

 

 

Please follow the install instructions: https://github.com/AdKats/AdKats

Especially step 1, because you ignored that step.

 

Quote:

GO BACK TO STEP 1 AND INSTALL STAT LOGGER. Far too many people have posted issues because they refuse to follow instructions. DO NOT attempt to install AdKats until stat logger is running without issue.

Edited July 8, 2020 by Hedius

[icecold]

chat logging does not seem to log foreign chat.

all foreign chat sql entries are blank.

can this be fixed ?

[Hedius]

12 minutes ago, icecold said:

chat logging does not seem to log foreign chat.

all foreign chat sql entries are blank.

can this be fixed ?

You mean cyrillic letters? No. RCON only supports ASCII encodings as far as I know.

[icecold]

yes, cyrillic letters

 

[icecold]

i can copy and paste russian text in procon chat, and it shows.

so it must support cyrillic letters ?

[Sajid30k]

I trying this stast but the tablet tbl_playerstats is empty , just work Live scored and leader of the week nothing more.

What can be this ? I using the lasted plugin.

 

Any help please ?

[Hedius]

On 9/25/2020 at 10:37 AM, icecold said:

i can copy and paste russian text in procon chat, and it shows.

so it must support cyrillic letters ?

No as far as I know you can send them to the server. However, the server does not send those letters to procon. Procon should fully support them.

[Hedius]

On 9/30/2020 at 4:02 PM, Sajid30k said:

I trying this stast but the tablet tbl_playerstats is empty , just work Live scored and leader of the week nothing more.

What can be this ? I using the lasted plugin.

 

Any help please ?

1. Make sure that punkbuster is running.

2. Check your settings. Make sure that everything is enabled and that log playerdata only is set to False.

3. You have to wait a full round for the first data to appear.

[Edgecrusher]

Hi all, first post here so please be gentle 

I have installed the chat plugin and all seems to be fine except I regularly get the following messages when a player joins the server:

 

[15:59:53 76] [Statslogger]Error: SQLQuery:
[15:59:53 76] Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
                                FROM tbl_playerstats tps
                  ' at line 1
[15:59:53 76] Native: -2147467259
[15:59:53 76] Source: MySql.Data
[15:59:53 76] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCommand selectQuery)
[15:59:53 76] [Statslogger]Error: SQLQuery OuterException:System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException)
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCommand selectQuery)

I've tried building Procon from source in an attempt to debug the error but can't figure out how to access the chat plugin itself.

Can anyone offer some thoughts on what I've done (or more likely NOT done) to the database and/or how to debug the plugin that is loaded on my server?

Thanks,

Alex.

[dataXploit]

On 12/30/2020 at 11:03 AM, Edgecrusher said:

Hi all, first post here so please be gentle 

I have installed the chat plugin and all seems to be fine except I regularly get the following messages when a player joins the server:

 

[15:59:53 76] [Statslogger]Error: SQLQuery:
[15:59:53 76] Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
                                FROM tbl_playerstats tps
                  ' at line 1
[15:59:53 76] Native: -2147467259
[15:59:53 76] Source: MySql.Data
[15:59:53 76] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCommand selectQuery)
[15:59:53 76] [Statslogger]Error: SQLQuery OuterException:System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException)
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCommand selectQuery)

I've tried building Procon from source in an attempt to debug the error but can't figure out how to access the chat plugin itself.

Can anyone offer some thoughts on what I've done (or more likely NOT done) to the database and/or how to debug the plugin that is loaded on my server?

Thanks,

Alex.

It might be because you're running MySQL Server 8. Try it on MySQL 5.7 I believe I had a similar issue before.

[Hedius]

On 12/30/2020 at 5:03 PM, Edgecrusher said:

Hi all, first post here so please be gentle 

I have installed the chat plugin and all seems to be fine except I regularly get the following messages when a player joins the server:

 

[15:59:53 76] [Statslogger]Error: SQLQuery:
[15:59:53 76] Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
                                FROM tbl_playerstats tps
                  ' at line 1
[15:59:53 76] Native: -2147467259
[15:59:53 76] Source: MySql.Data
[15:59:53 76] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCommand selectQuery)
[15:59:53 76] [Statslogger]Error: SQLQuery OuterException:System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException)
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCommand selectQuery)

I've tried building Procon from source in an attempt to debug the error but can't figure out how to access the chat plugin itself.

Can anyone offer some thoughts on what I've done (or more likely NOT done) to the database and/or how to debug the plugin that is loaded on my server?

Thanks,

Alex.

Use mariaDB problem solved

Nobody needs that oracle sh*t

[Edgecrusher]

1 hour ago, Hedius said:

Use mariaDB problem solved

Nobody needs that oracle sh*t

pardon my ignorance; I've never heard of mariadb before today; so I assume it works identically to MySQL? And (after reading that Mariadb started as a fork of MySQL) that the Adkats plugins etc. will function the same if I port the database across?

[Hedius]

Just now, Edgecrusher said:

pardon my ignorance; I've never heard of mariadb before today; so I assume it works identically to MySQL? And (after reading that Mariadb started as a fork of MySQL) that the Adkats plugins etc. will function the same if I port the database across?

It's a fork of MySQL.

[Hedius]

Just now, Hedius said:

It's a fork of MySQL.

And yes the procon stuff runs fine with MariaDB, since the database management supports nearly all features of mysql.

MariaDB is also replacing MySQl on several linux distributions^^

 

Anyways everything works with the most recent MariaDB release still.

[Prophet731]

On 12/30/2020 at 8:03 AM, Edgecrusher said:

Hi all, first post here so please be gentle 

I have installed the chat plugin and all seems to be fine except I regularly get the following messages when a player joins the server:

 

[15:59:53 76] [Statslogger]Error: SQLQuery:
[15:59:53 76] Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
                                FROM tbl_playerstats tps
                  ' at line 1
[15:59:53 76] Native: -2147467259
[15:59:53 76] Source: MySql.Data
[15:59:53 76] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCommand selectQuery)
[15:59:53 76] [Statslogger]Error: SQLQuery OuterException:System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException)
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCommand selectQuery)

I've tried building Procon from source in an attempt to debug the error but can't figure out how to access the chat plugin itself.

Can anyone offer some thoughts on what I've done (or more likely NOT done) to the database and/or how to debug the plugin that is loaded on my server?

Thanks,

Alex.

As @Hedius said, Use MySQL 5.7 or MariaDB. 

[wizz3]

so...  i installed XpKiller's stats logger plugin sucessfully, but the pbguids and country codes are not getting logged at all.
can anyone tell me how to fix this? am i missing somehing in my structure or something?

[wizz3]

so...  i installed XpKiller's stats logger plugin sucessfully, but the pbguids and country codes are not getting logged at all.
can anyone tell me how to fix this? am i missing something in my structure or smth?

[wizz3]

so...  i installed XpKiller's stats logger plugin sucessfully, but the pbguids and country codes are not getting logged at all.
can anyone tell me how to fix this? am i missing something in my structure or smth?

[wizz3]

huh... any tips/help?

[beefynachogrillr]

Am I missing something with the install of this plugin? I drop it in the plugins section like any other plugin but it never shows up on the plugins tab. What am I doing wrong?