Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Where can I get hosting for this to work? I have tried gameservers.com & lowpinggameservers.com & both won't connect to DB

You probably need to whitelist your procon layer's IP on the database.

[ImportBot]

Originally Posted by FSUNOLE*:

 

I have whitelisted the IP. Is there a SQL that goes with this?

[ImportBot]

Originally Posted by johncogan*:

 

Hi

 

Am getting an error which seems related to a lack of permissions. The mySql Server IP is whitelisted on the host and have double checked the procon settings for hostname, user, db name and password.

 

Username has full access/priveledges to DB.

 

Code:

[13:05:59 37] Error in Tablebuilder: 
[13:05:59 37] Message: Authentication to host 's1-london.accountservergroup.com' for user 'XXXXXX' using method 'mysql_native_password' failed with message: Access denied for user 'XXXXXX'@'173.199.78.252' (using password: YES)
[13:05:59 37] Native: -2147467259
[13:05:59 37] Source: MySql.Data
[13:05:59 37] StackTrace:    at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex)
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
   at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()
[13:05:59 37] InnerException: MySql.Data.MySqlClient.MySqlException: Access denied for user 'XXXXXX'@'173.199.78.252' (using password: YES)
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadPacket()
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
[13:05:59 37] Error: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[ImportBot]

Originally Posted by Athlon*:

 

Where can I get hosting for this to work? I have tried gameservers.com & lowpinggameservers.com & both won't connect to DB

You probably need to whitelist your procon layer's IP on the database.

Yup - What he said - we use Gameservers with no problem at all.

 

The IP I had to allow was not exactly the IP of my layer, however, it was close. I got the exact IP from the error code returned by Procon when I activated the plugin. The error said something like my db host was refusing the connection from [ip]. I used that IP when I went to my hosting company's CP to allow it.

[ImportBot]

Originally Posted by LumPenPacK*:

 

I have a problem with replacement strings. When I use "%deathstreak%" it goes to "?athstreak%" after a layer restart.

[ImportBot]

Originally Posted by pyroblood*:

 

Can anybody post the original or modified keywordlist for bf4 please. I replaced the keywordlist with the keywordlist Bf3 (first post). noticed too late that it was for bf3 ^^ thanks

[ImportBot]

Originally Posted by XpKiller*:

 

@pyroblood

as posted serveral times the keyword is NOT needed for weaponstats tracking.

 

Its only needed if you want to assign alternative names for the weapons for ingame commands. Even a blank list will work fine.

[ImportBot]

Originally Posted by mkay*:

 

Ist das nur bei mir so oder werden manche tabbellen garnicht ausgefüllt?

 

tbl_server_stats

tbl_playerstats

tbl_weapons_stats

 

und ziemliche viele andere bleiben leer.

 

---------------------------------------------------------------------------------------------------------------------------------------------

12 Gameserver Banner passen leider nicht in die Signatur. Besucht uns einfach mal auf BF4-COM.net

[ImportBot]

Originally Posted by XpKiller*:

 

Das kommt auf deine Einstellungen an.

 

Einige Tabellen enthalten nur wenige einträge. Das ist aber normal.

Sonst poste mal deine Plugineinstellungen(screenshot). Password bitte entfernen.

[ImportBot]

Originally Posted by mkay*:

 

procon_stats_config.png

[ImportBot]

Originally Posted by _CH_KeyserSoze*:

 

Hey XPKiller,

Great plugin, We are using it on our 5 BF4 servers..However...

 

Everything is connecting and I am seeing the tables populating except for 4 tables

 

Dogtags

Playerstats

Serverstats

Weaponsstats

 

There are no error and statsstreaming is all green. Table suffix is empty and it looks like all weapons definitions are correct in the weapons tables.

 

Any ideas? Need anymore info?

[ImportBot]

Originally Posted by nordzik*:

 

Hello all

 

I would like to install this plugin to our server but I'm a noob with MySQL data , is there anyone of you who would like to prepare Videotutorial ?

Thank you for your help

Best Regards

[ImportBot]

Originally Posted by Athlon*:

 

I have been struggling with this now for over week with no luck. Our game server and procon layer server are with Fragnet.

I have tested my remote MYSQL DB on my pc through phprunner and I can connect to it no problems.

 

However I can't not seem to with the this plugin. I have added my procon layer server IP as a trusted with my MYSQL DB hoster (Hostmonster.com)

 

Attached is the error I am getting.

If there is an IP in the error text, check to see if it's EXACTLY the same as your layer's IP. If not, allow that one to the trusted list at your db hoster.

 

That was happening to me until I noticed it. The actual IP being seen by Gameservers was a little different than the one given to me by my Procon hoster.

[ImportBot]

Originally Posted by XpKiller*:

 

I have been struggling with this now for over week with no luck. Our game server and procon layer server are with Fragnet.

I have tested my remote MYSQL DB on my pc through phprunner and I can connect to it no problems.

 

However I can't not seem to with the this plugin. I have added my procon layer server IP as a trusted with my MYSQL DB hoster (Hostmonster.com)

 

Attached is the error I am getting.

The connection timed out. Make sure that the layer can connect to the target ip. Check Firewallsettings. This error is not caused by a missing permission. Seems like a firewall issue.

[ImportBot]

Originally Posted by XpKiller*:

 

I have a problem with replacement strings. When I use "%deathstreak%" it goes to "?athstreak%" after a layer restart.

hmm strange looks like a procon bug for me.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Wondering if someone can shine some light on my issue. I am able to connect to my DB and the plugin creates the tables. However it's not collecting any data. Below are the setups and also a link to my stats page that shows map name playing and amount of players on server.

 

http://tct-clan.com/BF4_Server_Stats/ServerStats.php

Getting that error usually means you have not whitelisted your procon layer's IP address on your MySQL database for access. Add that and you should be able to connect. Also, if you were getting this error, there is no way it should be able to create the tables.

[ImportBot]

Originally Posted by XpKiller*:

 

Getting that error usually means you have not whitelisted your procon layer's IP address on your MySQL database for access. Add that and you should be able to connect. Also, if you were getting this error, there is no way it should be able to create the tables.

Nope you would get an access denied in that case.

 

He has a problem with the connection itself:

IP or hostname is wrong, Port is wrong or a Firewall is blocking Traffic

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Nope you would get an access denied in that case.

 

He has a problem with the connection itself:

IP or hostname is wrong, Port is wrong or a Firewall is blocking Traffic

Tired brain at the wheel, it happens, lol.

[ImportBot]

Originally Posted by Repoman*:

 

I am no longer getting an error. The plugin connects to the DB, I resolved the Host IP issue. The DB just isn't collecting any data. That's the problem that I am now having.

[ImportBot]

Originally Posted by Gijzijtdood*:

 

Hello,

 

I got the plugin to work accept the player of the day option isn't working.

It allways replays with something like "no data yet, wait till next round".

Any idea what causes this?

 

Greetz

[ImportBot]

Originally Posted by ty_ger07*:

 

XpKiller,

 

There seems to be a discrepancy in the dog tag stats.

 

Every dog tag should be collected through weapon melee, right? So, every dog tag should have a weapon melee associated with it. But that doesn't seem to be the case.

 

For example:

http://jw.servegame.org/bf4stats/ser..._player=Search

 

This player has 46 weapon melee kill events, but 48 dog tags. Two weapon melee kill events seem to be missing.

 

I thought maybe the 2 defib kill events for this player had somehow been counted as a dog tag, but I don't think that is the case since every other player with defib kills does not seem to have this discrepancy.

 

It is probably just a benign error, but wanted to know if there is something wrong with my logic.

[ImportBot]

Originally Posted by GunnerySgtHartmann*:

 

Naben zusammen habe folgendes Problem mit dem Chat, GUID, Stats and Mapstats Logger

23:56:54 67] BF3 Chat, GUID and Stats Logger Enabled

[23:56:54 69] BF3 Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

 

mehr kommt nicht kein Fehler aber auch keine stats Abrufbar

datenbank ist auf dem my.Sql angelegt !!

Hat Jmd ne idee?

[ImportBot]

Originally Posted by ty_ger07*:

 

Naben zusammen habe folgendes Problem mit dem Chat, GUID, Stats and Mapstats Logger

23:56:54 67] BF3 Chat, GUID and Stats Logger Enabled

[23:56:54 69] BF3 Chat, GUID and Stats Logger: Floodprotection set to 10 Request per Round for each Player

 

mehr kommt nicht kein Fehler aber auch keine stats Abrufbar

datenbank ist auf dem my.Sql angelegt !!

Hat Jmd ne idee?

Seems like a dumb question, but have you enabled the stats options in the plugin? I mean, is stats logging enabled? Is chat logging enabled? Is welcome stats enabled? Is sessions enabled? Are map stats enabled? And so on and so on... If you have all the plugin options disabled, it will do pretty much nothing.

 

Also, here is the German support:

Plugins

[ImportBot]

Originally Posted by jking54*:

 

Seems like a dumb question, but have you enabled the stats options in the plugin? I mean, is stats logging enabled? Is chat logging enabled? Is welcome stats enabled? Is sessions enabled? Are map stats enabled? And so on and so on... If you have all the plugin options disabled, it will do pretty much nothing.

 

Also, here is the German support:

Plugins

I've always wondered, what exactly does "Sessions On" do anyhow? I've never enabled before.

[ImportBot]

Originally Posted by ty_ger07*:

 

I've always wondered, what exactly does "Sessions On" do anyhow? I've never enabled before.

It enables user session tracking. A session is the whole time from when a user joins a server until when they leave the server. Session stats will tell the user what their KDR was this session, how many ranks they progressed, how many points they scored this session, how long they have been playing this session, and so on.

[ImportBot]

Originally Posted by jking54*:

 

It enables user session tracking. A session is the whole time from when a user joins a server until when they leave the server. Session stats will tell the user what their KDR was this session, how many ranks they progressed, how many points they scored this session, how long they have been playing this session, and so on.

Wow, thanks for this ty_ger07, it is now on and sure can't believe how ignorant I've been on this nice feature.

[ImportBot]

Originally Posted by Repoman*:

 

Ok resolved the IP host whitelist, I added the main server IP and our procon layer server IP as well. Plugin connected to the DB and seems to have created the tables from the image attached. However the DB doesn't appear to be collecting data. Plugin has been running over 24 hours with a full server all last night.

 

Any ideas of what needs tweaking?

 

http://tct-clan.com/BF4_Server_Stats/ServerStats.php

 

Attached Files:

• stats.PNG
• stats2.PNG

[ImportBot]

Originally Posted by XpKiller*:

 

@Repoman

 

You need to enabled statslogging.

Its disabled on you screenshot.

[ImportBot]

Originally Posted by Gijzijtdood*:

 

Hello,

 

I got the plugin to work accept the player of the day option isn't working.

It allways replays with something like "no data yet, wait till next round".

Any idea what causes this?

 

Greetz

Still not working.

Any Ideas?

 

Greetz

[ImportBot]

Originally Posted by lordicon*:

 

How would I go about blocking things from showing in chat log such as ID_CHAT_REQUEST_MEDIC, ID_CHAT_REQUEST_ORDER, ID_CHAT_REQUEST_AMMO_? Trying to make it so this does not show in chat....