Jump to content
ColColonCleaner

Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

Recommended Posts

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.

 

Share this post


Link to post

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

 

Share this post


Link to post

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 */;

...

 

Share this post


Link to post
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.


The developer of the Battlefield Admin Control Panel (BFACP)

For BFACP support please post in the BFACP topic linked above.

Do not contact me via PM on the forums for help with procon. Please make a topic for it. Only PM's I will accept will revolve around any website issues.

Air VPN - The air to breathe the real Internet

Share this post


Link to post
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!

 

 

Share this post


Link to post
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?

Share this post


Link to post
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!!

Share this post


Link to post

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! =(

 

 
 
 
 

Share this post


Link to post
Posted (edited)
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 by Hedius

Share this post


Link to post
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.

Share this post


Link to post

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 ?

Share this post


Link to post
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.

Share this post


Link to post
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.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Our picks

    • Added ability to disable the new API check for player country info


      Updated GeoIP database file


      Removed usage sending stats


      Added EZRCON ad banner



      If you are upgrading then you may need to add these two lines to your existing installation in the file procon.cfg. To enable these options just change False to True.

      procon.private.options.UseGeoIpFileOnly False
      procon.private.options.BlockRssFeedNews False



       
      • 1 reply
    • I wanted I let you know that I am starting to build out the foundation for the hosting services that I talked about here. The pricing model I was originally going for wasn't going to be suitable for how I want to build it. So instead I decided to offer each service as it's own product instead of a package deal. In the future, hopefully, I will be able to do this and offer discounts to those that choose it.

      Here is how the pricing is laid out for each service as well as information about each. This is as of 7/12/2020.

      Single MySQL database (up to 30 GB) is $10 USD per month.



      If you go over the 30 GB usage for the database then each additional gigabyte is charged at $0.10 USD each billing cycle. If you're under 30GB you don't need to worry about this.


      Databases are replicated across 3 zones (regions) for redundancy. One (1) on the east coast of the USA, One (1) in Frankfurt, and One (1) in Singapore. Depending on the demand, this would grow to more regions.


      Databases will also be backed up daily and retained for 7 days.




      Procon Layer will be $2 USD per month.


      Each layer will only allow one (1) game server connection. The reason behind this is for performance.


      Each layer will also come with all available plugins installed by default. This is to help facilitate faster deployments and get you up and running quickly.


      Each layer will automatically restart if Procon crashes. 


      Each layer will also automatically restart daily at midnight to make sure it stays in tip-top shape.


      Custom plugins can be installed by submitting a support ticket.




      Battlefield Admin Control Panel (BFACP) will be $5 USD per month


      As I am still working on building version 3 of the software, I will be installing the last version I did. Once I complete version 3 it will automatically be upgraded for you.





      All these services will be managed by me so you don't have to worry about the technical side of things to get up and going.

      If you would like to see how much it would cost for the services, I made a calculator that you can use. It can be found here https://ezrcon.com/calculator.html

       
      • 10 replies
    • I have pushed out a new minor release which updates the geodata pull (flags in the playerlisting). This should be way more accurate now. As always, please let me know if any problems show up.

       
      • 9 replies
×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.