Jump to content

Chat, GUID, Stats and Mapstats Logger [1.0.0.3]


ColColonCleaner

Recommended Posts

3 minutes ago, OddJob001 said:

We dont have much control over the gameservers procon layer (so Im not able to answer that).  The only control I have is to limit the connections in the plugin itself.  Default is 10, Ill set it to 3.  Thing is, once we hit the above sql connection error, it never recovers.  Requires an entire reinstall of the procon server.

Well this clearly looks like the database server is blocking you... (Chatlogger does not save any states between layer restarts / fully clears up when disabling and enabling the plugin. Check your MySQL/MariaDB server config for the user to make sure that you have not set any limits.

If you have no control over the DBMS: try a decent PRoCon hoster. (EZRCON for example) or host the database yourself

Link to post
  • Administrators
8 minutes ago, OddJob001 said:

We dont have much control over the gameservers procon layer (so Im not able to answer that).  The only control I have is to limit the connections in the plugin itself.  Default is 10, Ill set it to 3.  Thing is, once we hit the above sql connection error, it never recovers.  Requires an entire reinstall of the procon server.

As @Hedius just said, could just be a provider issue that's causing the issue your seeing. Seen that numerus times from people. You can try out EZRCON (Procon or MySQL) to see if you still see the issues. 

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

Link to post
Posted (edited)

Hello. Thanks again for the help yesterday, the issue was certainly with our mysql provider.  That being said, thanks to your recommendation, I have moved over to EZRON for mysql (and likely soon I'll move procon over there).  So, AdKats is working now, however `Chat, GUID, Stats and Mapstats Logger [1.0.0.3]` is only partially working.  It is connecting to the db, its recording data in the tables.  Yet, when I run commands to get data return in the server, it is always replying with:

No Stats Available Yet. Please wait one Round!

and 

AuEbmrv.png

I see all the data populated in our tables.  Any idea whats going on here?

Thanks again for your support. 

 

Edit:  A good 20-40 rounds of data are in the tables. 

Edited by OddJob001
Link to post
3 minutes ago, OddJob001 said:

Hello. Thanks again for the help yesterday, the issue was certainly with our mysql provider.  That being said, thanks to your recommendation, I have moved over to EZRON for mysql (and likely soon I'll move procon over there).  So, AdKats is working now, however `Chat, GUID, Stats and Mapstats Logger [1.0.0.3]` is only partially working.  It is connecting to the db, its recording data in the tables.  Yet, when I run commands to get data return in the server, it is always replying with:

No Stats Available Yet. Please wait one Round!

and 

AuEbmrv.png

I see all the data populated in our tables.  Any idea whats going on here?

Thanks again for your support. 

 

Edit:  A good 20-40 rounds of data are in the tables. 

Can you please share your chat logger settings? (Wirhout the password / login data ofc)

Link to post
11 minutes ago, Hedius said:

Can you please share your chat logger settings? (Wirhout the password / login data ofc)

lmk if a screenshot is easier to read:

/////////////////////////////////////////////
// This config will be overwritten by procon.
/////////////////////////////////////////////
procon.protected.plugins.enable "CChatGUIDStatsLogger" True
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Host" "us.db.ezrcon.com"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Port" "3306"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Database Name" 
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "UserName" 
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Password" 
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Connection Pooling" "On"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Min Connection Pool Size" "0"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Max Connection Pool Size" "10"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Failed Transaction retry attempts" "3"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Minimum time(sec) between ServerInfo Updates" "60"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Enable Chatlogging?" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Enable Statslogging?" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Enable Weaponstats?" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Ranking by Score?" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Enable ingame commands?" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Overall ranking(merged Serverranking)" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Server group (0 - 128)" "0"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Send Stats to all Players?" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Enable Livescoreboard in DB?" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Enable KDR correction?" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "PlayerMessage" "Serverstats for %playerName%:|Score: %playerScore%  %playerKills% Kills %playerHeadshots% HS  %playerDeaths% Deaths K/D: %playerKDR%|Your Serverrank is: %playerRank% of %allRanks%"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Player of the day Message" "%playerName% is the Player of the day|Score: %playerScore%  %playerKills% Kills %playerHeadshots% HS  %playerDeaths% Deaths K/D: %playerKDR%|His Serverrank is: %playerRank% of %allRanks%|Overall playtime for today: %playerPlaytime%"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Weaponstats Message " "%playerName%'s Stats for %Weapon%:|%playerKills% Kills  %playerHeadshots% Headshots  Headshotrate: %playerKHR%%|Your Weaponrank is: %playerRank% of %allRanks%"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Serverstats Message" "Serverstatistics for server %serverName%|Unique Players: %countPlayer%  Totalplaytime: %sumPlaytime%|Totalscore: %sumScore% Avg. Score: %avgScore% Avg. SPM: %avgSPM%|Totalkills: %sumKills% Avg. Kills: %avgKills% Avg. KPM: %avgKPM%"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Awards ON?" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Enable Welcomestats?" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Yell Welcome Message(not the stats)?" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Welcome Message" "Nice to see you on our Server again, %playerName%|Serverstats for %playerName%:|Score: %playerScore%  %playerKills% Kills %playerHeadshots% HS  %playerDeaths% Deaths K/D: %playerKDR%|Your Serverrank is: %playerRank% of %allRanks%"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Welcome Message for new Player" "Welcome to the %serverName% Server, %playerName%"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Welcomestats Delay" "15"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Top10 ingame" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Top10 header line" "Top 10 Player of the %serverName% Server"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Top10 row format" "%Rank%. %playerName%  Score: %playerScore%  %playerKills% Kills  %playerHeadshots% Headshots  %playerDeaths% Deaths  KDR: %playerKDR%"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Top10 for period header line" "Top 10 Player of the %serverName% Server over the last %intervaldays% days"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Top10 for period interval days" "7"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "WeaponTop10 header line" "Top 10 Player with %Weapon% of the %serverName%"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "WeaponTop10 row format" "%Rank%.  %playerName%  %playerKills% Kills  %playerHeadshots% Headshots  %playerDeaths% Deaths Headshotrate: %playerKHR%%"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "DebugLevel" "Trace"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Keywordlist" "870MCS{870,870MCS}|AEK-971{AEK,AEK971,AEK-971}|AKS-74u{AKSU,AKS-74,AKSU-74,AKS-74U}|AN-94 Abakan{ABAKAN,AN94,AN-94}|AS Val{ASVAL,AS-VAL,AS VAL}|DAO-12{DAO12,DAO,DAO-12}|death{DEATH}|Defib{DEFIBRILLATOR,DEFIB,PADDLE,PADDLES}|F2000{F2000}|FAMAS{FAMAS}|FGM-148{JAVELIN,FGM148,FGM-148}|FIM92{STINGER,FIM92,FIM-92}|Glock18{GLOCK,GLOCK18,GLOCK-18}|HK53{HK53,HK-53,G53,G-53,HK-G53}|jackhammer{JACKHAMMER,MK3A1,MK3}|JNG90{JNG-90,JNG90,JNG}|L96{L-96,L96}|LSAT{LSAT}|M416{M-416,M416}|M417{M-417,M417}|M1014{M-1014,1014,M1014}|M15 AT Mine{M15,M15 MINE,AT MINE,ATMINE,ATM,M15-ATM}|M16A4{M-16,M16,M16A3,M16-A3,M16A4,M16-A4}|M1911{1911,M1911}|M240{M-240,M240}|M249{M-249,M249,SAW}|M26Mass{M26,M-26,MASS,M26MASS}|M27IAR{M27,M-27,M27IAR}|M320{M-320,GRENADE LAUNCHER,M320}|M39{M-39,M39}|M40A5{M40,M-40,M40A5}|M4A1{M4,M-4,M4A1}|M60{M-60,M60}|M67{HANDGRENADE,GRENADE,M67,M-67}|M9{M-9,M9}|M93R{M93,M93R}|Medkit{MEDKIT}|MG36{MG-36,MG36}|Mk11{MK-11,MK11}|Model98B{M98,M98B,MODEL98,MODEL-98,MODEL98B,MODEL-98B}|MP7{MP-7,MP7}|Pecheneg{PKP-PECHENEG,PKP,PECHENEG}|PP-19{PP19,PP-19}|PP-2000{PP2000,PP-2000}|QBB-95{QBB,QBB95,QBB-95}|QBU-88{QBU,QBU88,QBU-88}|QBZ-95{QBZ,QBZ95,QBZ-95}|Repair Tool{REPAIRTOOL,TOOL,TORCH,BLOWTORCH}|RoadKill{ROADKILL}|RPG-7{RPG,RPG7,RPG7V2,RPG-7V2}|RPK-74M{RPK,RPK74,RPK-74,RPK74M,RPK-74M}|Weapons/SCAR-H/SCAR-H{SCAR,SCAR-H,SCARH}|SCAR-L{SCARL,SCAR-L}|SG 553 LB{SG553,SG-553,SG-553LB}|Siaga20k{SAIGA,SAIGA20K,SIAGA,SIAGA20K}|SKS{SKS}|SMAW{SMAW}|SPAS-12{SPAS12,SPAS,SPAS-12}|Suicide{SUICIDE}|SV98{SV-98,SV98}|SVD{SVD,DRAGUNOV}|Steyr AUG{STEYR,AUGA3,AUG-A3,AUG}|Taurus .44{TAURUS,.44MAGNUM,TAURUS.44,MAGNUM,.44}|Type88{TYPE88,TYPE-88}|USAS-12{USAS12,USAS}|Weapons/A91/A91{A91,A-91}|Weapons/AK74M/AK74{AK74,AK-74,AKM,AK-74M,AK74M}|Weapons/G36C/G36C{G36,G36C,G-36,G-36C}|Weapons/G3A3/G3A3{G3,G-3,G3A3,G3-A3}|Weapons/Gadgets/C4/C4{C4,C-4}|Weapons/Gadgets/Claymore/Claymore{CLAYMORE,LANDMINE,APMINE,AP-MINE,APM,M18,M-18,M18-CLAYMORE}|Weapons/KH2002/KH2002{KH2002,KH-2002}|Weapons/Knife/Knife{KNIFE,MELEE}|Weapons/MagpulPDR/MagpulPDR{PDW-R,PDWR,PDR,PDW}|Weapons/MP412Rex/MP412REX{MP412REX,REX,MP-412,MP412}|Weapons/MP443/MP443{MP-443,MP443,GRACH}|Weapons/P90/P90{P-90,P90}|Weapons/Sa18IGLA/Sa18IGLA{SA18,SA-18,IGLA,SA18IGLA,SA18-IGLA,SA-18IGLA}|Weapons/UMP45/UMP45{UMP45,UMP-45,UMP}|Weapons/XP1_L85A2/L85A2{L85,L85A2,L-85,L-85A2,L85-A2}|Weapons/XP2_ACR/ACR{ACWR,ACW-R,ACR,AC-R}|Weapons/XP2_L86/L86{L86,L86A2,L-86,L-86A2,L86-A2}|Weapons/XP2_MP5K/MP5K{MP5,MP5K,M5K,MP-5,MP-5K,M5-K}|Weapons/XP2_MTAR/MTAR{MTAR,MTAR21,MTAR-21}"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "tableSuffix" ""
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "MapStats ON?" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Session ON?" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "SessionMessage" "%playerName%'s Session Data  Session started %SessionStarted%|Score: %playerScore%  %playerKills% Kills  %playerHeadshots% HS  %playerDeaths% Deaths K/D: %playerKDR%|Your Rank: %playerRank% (%RankDif%)  Sessionlength: %SessionDuration% Minutes"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Save Sessiondata to DB?" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Playerrequests per Round" "10"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Servertime Offset" "0"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Stats Command:" "stats,rank"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "ServerStats Command:" "serverstats"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Session Command:" "session"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Dogtags Command:" "dogtags"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Top10 Command:" "top10"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Player Of The Day Command:" "playeroftheday,potd"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Top10 for period Command:" "weektop10,wtop10"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Periodical Webrequest On?(P&S Stats)" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Webaddress" ""
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Webrequest Intervall" "60"
procon.protected.plugins.setVariable "CChatGUIDStatsLogger" "Log playerdata only (no playerstats)?" "Yes"


 

Link to post

Actually, it looks like its recording nearly everything except stats.

SELECT * FROM `tbl_playerstats`
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0022 seconds.)

 

Link to post
Just now, OddJob001 said:

Actually, it looks like its recording nearly everything except stats.

SELECT * FROM `tbl_playerstats`
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0022 seconds.)

 

Yeah you disabled it:

Log playerdata only (no playerstats)?

 

This has to be False ^^ , but is set to True atm... :)

Link to post
16 minutes ago, Hedius said:

Yeah you disabled it:

Log playerdata only (no playerstats)?

 

This has to be False ^^ , but is set to True atm... :)

Woah. lol.. Not enough coffee yet apparently.  This is interesting though, because from the GUI side it says:

mKZuwTy.png

Let me try to do some fixes.  lol.  Sorry about that miss. 

Link to post
Posted (edited)
14 minutes ago, OddJob001 said:

Woah. lol.. Not enough coffee yet apparently.  This is interesting though, because from the GUI side it says:

mKZuwTy.png

Let me try to do some fixes.  lol.  Sorry about that miss. 

Set it to False/No^^.... Yes = log playerdata only....

Edited by Hedius
Link to post
  • 4 weeks later...
On 7/26/2021 at 5:09 PM, dangerBEclose said:

Hello,

How can I merge the stats from two servers into one?

image.png.78a5d499c1205dea8ef60ca4ca65b07a.png

Each server stores player stats separated. You cannot combine them afaik.

You can enable this option. The plugin will combine all stats before generating output.

Merging is not a feature.

Link to post

Thank you, I enabled merged serverranking now.
And I set the offline servers back to active. Do I need to somehow modify a setting in mysql to have these servers stats also be merged with the online server? Or does merged stats just take it from other servers even if these do have merged stats off?

I also have a second question. I don't know what table or fields I need to remove for the live scoreboard to disappear for the servers that are set offline and will not come online anymore.
Because now I see this for example: https://bf4stats.deadfriendsgaming.com/index.php?p=home&sid=1 (http://i.prntscr.com/bVB_r0gjR4WHcS25YUma3A.png)
I managed to remove the map image and set the connected player count and server size all to 0. Online stays, but I assume I can not turn that to offline and have it still show the servers in the list of all servers.
I would like to keep these server stats there.

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

    • Game Server Hosting:

      We're happy to announce that EZRCON will branch out into the game server provider scene. This is a big step for us so please having patience if something doesn't go right in this area. Now, what makes us different compared to other providers? Well, we're going with the idea of having a scaleable server hosting and providing more control in how you set up your server. For example, in Minecraft, you have the ability to control how many CPU cores you wish your server to have access to, how much RAM you want to use, how much disk space you want to use. This type of control can't be offered in a single service package so you're able to configure a custom package the way you want it.

      You can see all the available games here. Currently, we have the following games available.

      Valheim (From $1.50 USD)


      Rust (From $3.20 USD)


      Minecraft (Basic) (From $4.00 USD)


      Call of Duty 4X (From $7.00 USD)


      OpenTTD (From $4.00 USD)


      Squad (From $9.00 USD)


      Insurgency: Sandstorm (From $6.40 USD)


      Changes to US-East:

      Starting in January 2022, we will be moving to a different provider that has better support, better infrastructure, and better connectivity. We've noticed that the connection/routes to this location are not ideal and it's been hard getting support to correct this. Our contract for our two servers ends in March/April respectively. If you currently have servers in this location you will be migrated over to the new provider. We'll have more details when the time comes closer to January. The new location for this change will be based out of Atlanta, GA. If you have any questions/concerns please open a ticket and we'll do our best to answer them.
      • 1 reply
    • Hello All,

      I wanted to give an update to how EZRCON is doing. As of today we have 56 active customers using the services offered. I'm glad its doing so well and it hasn't been 1 year yet. To those that have services with EZRCON, I hope the service is doing well and if not please let us know so that we can improve it where possible. We've done quite a few changes behind the scenes to improve the performance hopefully. 

      We'll be launching a new location for hosting procon layers in either Los Angeles, USA or Chicago, IL. Still being decided on where the placement should be but these two locations are not set in stone yet. We would like to get feedback on where we should have a new location for hosting the Procon Layers, which you can do by replying to this topic. A poll will be created where people can vote on which location they would like to see.

      We're also looking for some suggestions on what else you would like to see for hosting provider options. So please let us know your thoughts on this matter.
      • 4 replies
    • Hi All,

      So seeing as Venice Unleased is released, I'm looking into if I should offer game hosting for it. I would like some feedback on this subject.

      VU - Experience Battlefield 3 like never before! (veniceunleashed.net)
      • 3 replies
    • So as the topic title says, should EZRCON offer general web hosting services?
      • 1 reply
    • 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



       
      • 2 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.