Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by ty_ger07*:

 

We have a root Server with Debian

It's not my area of expertise. I think you need to configure your server to allow more queries to be queued so that when it receives multiple queries simultaneously, it doesn't exceed the queue (pool) and start dumping queries from a full queue. I don't know how to do that, but I am sure it is possible as long as your server has the resources to do so. You may need to allocate more system memory to the database service as well.

[ImportBot]

Originally Posted by hatumaeu*:

 

[13:56:07 95] Error in Tablebuilder:

[13:56:07 95] Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

[13:56:07 95] Native: -2147467259

[13:56:07 95] Source: MySql.Data

[13:56:07 95] StackTrace: à MySql.Data.MySqlClient.MySqlStream.ReadPacket()

à MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

à MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

à MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

à MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

à MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

à MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

à PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[13:56:07 95] Error: System.NullReferenceException: La référence d'objet n'est pas définie à une instance d'un objet.

à PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

à PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

i'm recently trying to get this thing on but I keep getting that msg, I wonder if someone could help me.

[ImportBot]

Originally Posted by mambochambo*:

 

My Intention was- announcing a Vip with his Rank-

im aware of the Welcomestats and also that you can enable show stats to everybody

[ImportBot]

Originally Posted by nohskill*:

 

Hello, could you tell me why this error happens?

 

[13:02:28 79] Error in Tablebuilder:

[13:02:28 79] Message: Unable to connect to any of the specified MySQL hosts.

[13:02:28 79] Native: -2147467259

[13:02:28 79] Source: MySql.Data

[13:02:28 79] StackTrace: em MySql.Data.MySqlClient.NativeDriver.Open()

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

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

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

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

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

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

em PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[13:02:28 81] Error: System.NullReferenceException: Referência de objeto não definida para uma instância de um objeto.

em PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

em PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

 

[13:02:47 16] Error in Tablebuilder:

[13:02:47 16] Message: Unable to connect to any of the specified MySQL hosts.

[13:02:47 16] Native: -2147467259

[13:02:47 16] Source: MySql.Data

[13:02:47 16] StackTrace: em MySql.Data.MySqlClient.NativeDriver.Open()

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

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

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

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

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

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

em PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[13:02:47 16] Error: System.NullReferenceException: Referência de objeto não definida para uma instância de um objeto.

em PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

em PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[13:02:48 16] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.

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

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

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

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

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

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

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

em PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by ty_ger07*:

 

https://www.google.com/search_q=Unab...ed+MySQL+hosts

 

Maybe you typed in the wrong address. Maybe you need to use the database ip address instead of the domain name. Maybe the database isn't configured to allow external connections. Maybe the database has a firewall which is blocking you. Maybe your procon sandbox is enabled. Maybe your procon isn't configured to connect to remote hosts.

 

You should ask your database provider and your layer server provider.

[ImportBot]

Originally Posted by madStas*:

 

Hi!

2 questions:

1) I'm moved my server from one mashine to other inside one provider. Ip of my server changes and all data erases stat etc. how I can restore it?

2) Is it possible with this plugin to fetch player stat from gametracker.com?

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi!

2 questions:

1) I'm moved my server from one mashine to other inside one provider. Ip of my server changes and all data erases stat etc. how I can restore it?

2) Is it possible with this plugin to fetch player stat from gametracker.com?

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

2) No.

[ImportBot]

Originally Posted by Mille*:

 

Hi!,

i have a few questions.

 

im new in this kinda "world" of having a Battlefield server.

 

i started a Battlefield Hardline Server hosted by G-portal yesterday,

i have been trying to add this plugin but it keeps comming up with the same error.

 

[10:29:38 58] PRoCon Chat, GUID and Stats Logger Enabled

[10:29:38 58] PRoCon Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

[10:29:41 60] [statslogger]Error: Check you MySQL Server Details:, hostname, port, databasename and your login credentials!

[10:29:41 60] PRoCon Chat, GUID and Stats Logger Disabled

im not the best 1 at codes etc so i was wondering if anyone could tell me what to do_

 

Bye

Mille

[ImportBot]

Originally Posted by ty_ger07*:

 

Hi!,

i have a few questions.

 

im new in this kinda "world" of having a Battlefield server.

 

i started a Battlefield Hardline Server hosted by G-portal yesterday,

i have been trying to add this plugin but it keeps comming up with the same error.

 

 

 

im not the best 1 at codes etc so i was wondering if anyone could tell me what to do_

 

Bye

Mille

You need to own a MySQL database for this plugin to store data to and you need to enter the MySQL database connection/login details into this plugin's settings in procon. This plugin is giving an error message because you left the database connection/login information blank.

 

Did you read the first post?

[ImportBot]

Originally Posted by Berkshire_Hunt*:

 

I'm getting the exact same error as post #1352

 

[10:57:53 97] Error in Tablebuilder:

[10:57:53 97] Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

[10:57:53 97] Native: -2147467259

[10:57:53 97] Source: MySql.Data

[10:57:53 97] 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.tablebuilder()

[10:57:53 97] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[10:57:55 83] PRoCon Chat, GUID and Stats Logger Disabled

Using latest MySQL that is running other databases happily.

[ImportBot]

Originally Posted by robexms*:

 

Hello guys,

 

I own a server and I'm using this great script.

The SQL is up and the plugin works.

I could not find how to reset the stats or how to check last week top stats preferably without accessing the sql manually (mostly interested in this).

Any help would be appreciated.

Thank you

[ImportBot]

Originally Posted by muhevana*:

 

Servertime offset is 0 what string i must set it?

[ImportBot]

Originally Posted by ty_ger07*:

 

Servertime offset is 0 what string i must set it?

0 means 0 hour offset between the game server and procon server. If the game server and procon server are 2 time zones away, you would set it to +2 or -2 so that the time of events happening is the same.

[ImportBot]

Originally Posted by ty_ger07*:

 

I'm getting the exact same error as post #1352

 

 

 

Using latest MySQL that is running other databases happily.

Do you have all the prerequesites mentioned in the first post? Which SQL version are you using for your database?

 

It seems that you are using a SQL version which is incompatible with this sort of INNODB table lock and key restraint methodology.

[ImportBot]

Originally Posted by Xia0_Xia0*:

 

Hey man,

 

First i want to thank you for this great plugin, i have been using it on bf3 since 2013.

Recently though i have a problem where the !top10 command is not working other commands work such as !rank and stuff like that. i am running the latest version 1.1.0.1.

 

Any idea how to fix it?

[ImportBot]

Originally Posted by Cmdr-Bestia*:

 

I am getting this error.

 

[02:58:48 50] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[02:58:06 77] [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

 

The MySQL version allows INNODB and I configure in the Plugin the DB IP, DB Name, User and PW ... Do I am missing some step?

 

 

EDIT: Problem solved. Problem was the Host service provider.

[ImportBot]

Originally Posted by iraqiboy90*:

 

!stats m5k

 

PDGC_iraqiboy90's Stats for MP5k

7 Kills 2 Headshots Headshotrate 29%

Your Weaponrank is 1 of 74060

 

!top10 m5k

bla bla bla.. Im not even on the top 10 of that weapon

 

So what does "Weaponrank" mean here_a

and why does it show the same "weaponrank" number on every weapon I !stats?

[ImportBot]

Originally Posted by ty_ger07*:

 

!stats m5k

 

PDGC_iraqiboy90's Stats for MP5k

7 Kills 2 Headshots Headshotrate 29%

Your Weaponrank is 1 of 74060

 

!top10 m5k

bla bla bla.. Im not even on the top 10 of that weapon

 

So what does "Weaponrank" mean here_a

and why does it show the same "weaponrank" number on every weapon I !stats?

XpKiller's weapon rank query may be messed up. It shouldn't show you as #1 for every weapon if you aren't actually #1. ColColonCleaner may have some advice for you on how to recompile the ranks table. Otherwise, I think it is an issue XpKiller could fix in his plugin code (if he ever shows up here again..).

[ImportBot]

Originally Posted by ty_ger07*:

 

Hey man,

 

First i want to thank you for this great plugin, i have been using it on bf3 since 2013.

Recently though i have a problem where the !top10 command is not working other commands work such as !rank and stuff like that. i am running the latest version 1.1.0.1.

 

Any idea how to fix it?

The !top10 command issues a significantly demanding query to the database. It is entirely possible that your database has grown and thus slowed down to the point that the query is timing out before it is finished going through all the players and stats. You may be able to increase the query timeout period of your database (ask database host). Or, you can optimize all of your database tables to improve performance (sql command which is easy to find in phpmyadmin which defragments the database) and possibly increase performance enough for the query to finish before it times out. Or, you can modify the !top10 query results in this plugin's plugin settings in procon to include less %blahblah% stats variables and therefore reduce the query size.

 

If you optimize your database tables, backup your database first. Don't backup your database in phpmyadmin; because phpmyadmin will timeout the backup query before your huge database finishes the backup and you will miss a lot of information. You need to backup your database using an external method possibly available in your server host control panel. Or ask your database host to backup your dataabse for you. You want to backup the database before doing the optimize tables command in case the optimize tables query times out in the middle of the process and corrupts the database data.

 

To verify that the !top10 query issue is caused by a database timeout, increase the plugin debug verbosity in this plugin's settings in procon, do the !top10 command in the game, and then watch the procon event log for an error message stating why something didn't work. It should say something about the query failed because it attempted to read past the end of data stream (data stopped coming back from the database server in an unexpected way) or connection was lost before the query completed.

[ImportBot]

Originally Posted by Berkshire_Hunt*:

 

Do you have all the prerequesites mentioned in the first post? Which SQL version are you using for your database?

 

It seems that you are using a SQL version which is incompatible with this sort of INNODB table lock and key restraint methodology.

It was MySQL 5.7.9, I tried it on 5.1.73 and it builds the tables successfully now and its working great

 

One table fails to create under 5.7.9, tbl_teamscore, which is indeed setup to allow nulls in the code of the plugin. I verified this by extracting the table creation SQL and running it directly against the database. Definitely using InnoDB.

[ImportBot]

Originally Posted by Cmdr-Bestia*:

 

@ty_ger07

Just a question. Your files doesn't have an image for the new maps (Zavod night, operation outbreak, and the upcoming Dragon Valley) How can it be added sow they show an image on the webpage? Which files must be edited?

Thanks

[ImportBot]

Originally Posted by ty_ger07*:

 

It was MySQL 5.7.9, I tried it on 5.1.73 and it builds the tables successfully now and its working great

 

One table fails to create under 5.7.9, tbl_teamscore, which is indeed setup to allow nulls in the code of the plugin. I verified this by extracting the table creation SQL and running it directly against the database. Definitely using InnoDB.

You are correct. According to Google searches, the SQL engine used to add the 'not null' constraint automatically to primary keys and it wasn't required to be explicitly stated in the table build query. But, for some reason, the sql developers have decided to no longer automatically implicitly add the 'not null' constraint to primary keys in newer versions and it must now be explicitly stated in the query. XpKiller's code needs to be modified/updated to explicitly state it in the queries.

[ImportBot]

Originally Posted by DarkZerO_AT*:

 

quick question:

could someone tell me how to remove all BF4 only players from the database?

we have been using our DB since BF4 and since we dont have a BF4 server anymore (only BFH) i would like to remove all BF4 DB entries (or BF4 only player entries)

i want to do this cause its already 1.3gb in size

 

thanks in advance for any help

[ImportBot]

Originally Posted by ty_ger07*:

 

quick question:

could someone tell me how to remove all BF4 only players from the database?

we have been using our DB since BF4 and since we dont have a BF4 server anymore (only BFH) i would like to remove all BF4 DB entries (or BF4 only player entries)

i want to do this cause its already 1.3gb in size

 

thanks in advance for any help

Backup your database first.

 

Then, delete the servers rows you don't want from the tbl_server table. I would recommend deleting the servers one at a time due to how long each one will take. Foreign key constraints should take care of the rest.

 

Then, delete the BF4 game row from the tbl_games table.

[ImportBot]

Originally Posted by DarkZerO_AT*:

 

Backup your database first.

 

Then, delete the servers rows you don't want from the tbl_server table. I would recommend deleting the servers one at a time due to how long each one will take. Foreign key constraints should take care of the rest.

 

Then, delete the BF4 game row from the tbl_games table.

thanks but when i try to delete a row i get this error:

 

#1451 - Cannot delete or update a parent row: a foreign key constraint fails (`ni38292_5sql12`.`adkats_statistics`, CONSTRAINT `adkats_statistics_server_id_fk` FOREIGN KEY (`server_id`) REFERENCES `tbl_server` (`ServerID`) ON DELETE NO ACTION ON UPDATE NO ACTION)

would be glad for some more help

im just really bad with SQL DB stuffs

[ImportBot]

Originally Posted by ty_ger07*:

 

thanks but when i try to delete a row i get this error:

 

 

 

would be glad for some more help

im just really bad with SQL DB stuffs

Oh... AdKats... You will have to ask ColColonCleaner. Normally it would work fine without AdKats' added foreign key constraints.

 

I should have also added that you need to stop this plugin or stop the layer server before modifying the database. But your error doesn't seem to be caused by this added restriction.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Oh... AdKats... You will have to ask ColColonCleaner. Normally it would work fine without AdKats' added foreign key constraints.

 

I should have also added that you need to stop this plugin or stop the layer server before modifying the database. But your error doesn't seem to be caused by this added restriction.

He can use this:

 

delete from adkats_statistics where server_id = SERVERID

 

where SERVERID is the ID of the server you want to delete. repeat for each server you want to delete. Then continue with deleting the servers as tyger suggested.

[ImportBot]

Originally Posted by ChaTon*:

 

would be glad for some more help

im just really bad with SQL DB stuffs

In case you don't know what is your server id, you can run this:

 

First check if you have any server not used in adkats_statistics:

 

SELECT * FROM adkats_statistics AS A

LEFT JOIN tbl_server AS B

ON A.`server_id` = B.`ServerID`

WHERE B.`ServerID` IS NULL

 

If you get an answer with some server id, than those servers are not in your server table anymore, so you can delete them by running the following query:

 

DELETE A FROM adkats_statistics AS A

LEFT JOIN tbl_server AS B

ON A.`server_id` = B.`ServerID`

WHERE B.`ServerID` IS NULL

[ImportBot]

Originally Posted by DarkZerO_AT*:

 

He can use this:

 

delete from adkats_statistics where server_id = SERVERID

 

where SERVERID is the ID of the server you want to delete. repeat for each server you want to delete. Then continue with deleting the servers as tyger suggested.

thanks, that worked perfectly

deleted all of the old servers this way and now only 1 is left, like it should be

 

can i change the server ID of that server too?

 

currently its 6, would be cool if i could easily change it to 1

 

cheers

[ImportBot]

Originally Posted by ChaTon*:

 

changing the server id will make it start as a new serer, so all the previous data related to the server id 6 won't be available (ex the weapons of the players used on that server, the players stats, the player rank if you use server group, map stats, adkats infraction, settings ....)

If you want to keep stats i won't advise you changing it, unless you don't care about it.