Chat, GUID, Stats and Mapstats Logger[1.1.0.1][BF3]

[ImportBot]

Originally Posted by XpKiller*:

 

The queries get slower because you DB has more entries.

I didn't changed any indexes. Please post the query which is slow.

 

An other reason could be that your innodb is not optimized well. E.g. bufferpool too small.

[ImportBot]

Originally Posted by ty_ger07*:

 

The queries get slower because you DB has more entries.

The number of players in the DB has only increased from 20k to 22k. I didn't think it would have such a crippling affect.

 

I didn't changed any indexes. Please post the query which is slow.

These slowed down the most:

 

Code:

SELECT tps.StatsID, tpd.CountryCode, tpd.SoldierName, tpd.PBGUID, tps.Suicide, tps.FirstSeenOnServer, tps.LastSeenOnServer, tps.Score, tps.Kills, tps.Deaths, tps.Suicide, tps.TKs, tps.Playtime, tps.Headshots, tps.Rounds, tps.Killstreak, tps.Deathstreak FROM tbl_playerstats{$table_suffix} tps INNER JOIN tbl_server_player{$table_suffix} tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata{$table_suffix} tpd ON tsp.PlayerID = tpd.PlayerID WHERE tsp.ServerID = '{$server_ID}' AND SoldierName = '{$player_name}'

Code:

SELECT tpd.SoldierName, tpd.PBGUID, tps.Kills, tps.Deaths, tps.Headshots, tps.Rounds, (tps.Headshots/(tps.Kills+0.0001)) AS HSratio FROM tbl_playerstats{$table_suffix} tps INNER JOIN tbl_server_player{$table_suffix} tsp ON tsp.StatsID = tps.StatsID INNER JOIN tbl_playerdata{$table_suffix} tpd ON tsp.PlayerID = tpd.PlayerID WHERE (tsp.ServerID = '{$server_ID}' AND (tps.Kills/(tps.Deaths+0.0001)) > 2.0 AND (tps.Headshots/(tps.Kills+0.0001)) > 0.65 AND tps.Kills > 20 AND tps.Rounds > 1) OR (tsp.ServerID = '{$server_ID}' AND (tps.Kills/(tps.Deaths+0.0001)) > 5.0 AND tps.Kills > 30 AND tps.Rounds > 1) OR (tsp.ServerID = '{$server_ID}' AND (tps.Kills/(tps.Deaths+0.0001)) > 1.0 AND (tps.Headshots/(tps.Kills+0.0001)) > 0.75 AND tps.Rounds > 1 AND tps.Kills > 15) ORDER BY HSratio DESC

Perhaps my server host has just throttled its services instead due to heavy use.

[ImportBot]

Originally Posted by EBassie*:

 

XpKiller,

 

since R21 we now see the chat 'logsubset' in Procon. (Playername - Attackers - Alpha Squad > Message)

Will you be updating the chatlogger to add this info?

 

Is it also possible to log the YELLS?

[ImportBot]

Originally Posted by ty_ger07*:

 

Nevermind XpKiller, I found out why my stats pages slowed way down.

 

GGC-Stream started slowing down their rate of reply. I don't know if it is because they are under heavier load then normal or if they have changed something, but now, the exact same page takes about 5 seconds per each GGC-Stream query response compared to less than a second before.

[ImportBot]

Originally Posted by XpKiller*:

 

that sounds like the reason because 2k players should make such a difference.

 

@EBastard

must take a look at it. anyway im looking to release a new version friday. Vetula has test my beta so i was able to sort out the most issues.

must look if any changes are need due R21.

 

Also i was busy because of metabans.

[ImportBot]

Originally Posted by EBassie*:

 

that sounds like the reason because 2k players should make such a difference.

 

@EBastard

must take a look at it. anyway im looking to release a new version friday. Vetula has test my beta so i was able to sort out the most issues.

must look if any changes are need due R21.

 

Also i was busy because of metabans.

Yeah I noticed. Nice job on that one!

 

BTW: these were just thought / suggestions...

[ImportBot]

Originally Posted by Athlon*:

 

Nevermind XpKiller, I found out why my stats pages slowed way down.

 

GGC-Stream started slowing down their rate of reply. I don't know if it is because they are under heavier load then normal or if they have changed something, but now, the exact same page takes about 5 seconds per each GGC-Stream query response compared to less than a second before.

ty_ger07,

 

I wonder if GGC's activity has gone way up because of the recent DDoS attacks on PBBans. Many servers are not streaming Punkbuster as a result. I hope GGC is not under attack too.

[ImportBot]

Originally Posted by TankCeo*:

 

Can some one help me set this up please? I don't have a MYSQL server. I do have MYSQL software though. Some one please help me!

[ImportBot]

Originally Posted by ammoniak007*:

 

@XpKiller , Very thx fo you help , you PV messages

 

@ty_ger07 , Very thx fo you "script"

 

http://ascendance.verygames.net/stat...5_players=View

[ImportBot]

Originally Posted by Athlon*:

 

Can some one help me set this up please? I don't have a MYSQL server. I do have MYSQL software though. Some one please help me!

www.phogue.net/forumvb/showth...-Configuration*

[ImportBot]

Originally Posted by cc*:

 

The only 4 tables receiving any information are the following:

tbl_chatlog, tbl_mapstats, tbl_playerdata, tbl_playerrank

 

The other 17 remain empty. What could be the problem?

[ImportBot]

Originally Posted by XpKiller*:

 

pls post you plugin settings

[ImportBot]

Originally Posted by cc*:

 

Code:

procon.protected.plugins.enable "CChatGUIDStatsLoggerBF3" True
"Close Connection after each request_" "No"
"High performance mode(no connection limit!)" "Off"
"Enable Chatlogging_" "Yes"
"Log ServerSPAM_" "No"
"Instant Logging of Chat Messages_" "Yes"
"Enable chatlog filter(Regex)_" "No"
"Enable Statslogging_" "Yes"
"Ranking by Score_" "Yes"
"Enable ingame commands_" "Yes"
"Overall ranking(merged Serverranking)" "Yes"
"Server group (0 - 128)" "0"
"Send Stats to all Players_" "No"
"PlayerMessage" "Serverstats for %playerName%:|Score: %playerScore%  %playerKills% Kills %playerHeadshots% HS  %playerDeaths% Deaths K/D: %playerKDR%|Your Serverrank is: %playerRank% of %allRanks%"
"Weaponstats Message" "[yell,2]%playerName%'s Stats for %Weapon%:|[yell,3]%playerKills% Kills  %playerHeadshots% Headshots  Headshotrate: %playerKHR%%  %playerDeaths% died by this Weapon|[yell,3]Your Weaponrank is: %playerRank% of %allRanks%"
"Serverstats Message" "[yell,2]Serverstatistics for server %serverName%|[yell,3]Unique Players: %countPlayer%  Totalplaytime: %sumPlaytime%|[yell,3]Totalscore: %sumScore% Avg. Score: %avgScore% Avg. SPM: %avgSPM%|[yell,3]Totalkills: %sumKills% Avg. Kills: %avgKills% Avg. KPM: %avgKPM%"
"Awards ON_" "No"
"Enable Welcomestats_" "No"
"Yell Welcome Message(not the stats)_" "No"
"Welcome Message" "Nice to see you on our Server again, %playerName%"
"Welcome Message for new Player" "Welcome to the %serverName% Server, %playerName%"
"Welcomestats Delay" "60"
"Top10 ingame" "No"
"Top10 header line" "[yell,2]Top 10 Player of the %serverName% Server"
"Top10 row format" "[yell,2]%Rank%. %playerName%  Score: %playerScore%  %playerKills% Kills  %playerHeadshots% Headshots  %playerDeaths% Deaths  KDR: %playerKDR%"
"WeaponTop10 header line" "[yell,2]Top 10 Player with %Weapon% of the %serverName%"
"WeaponTop10 row format" "[yell,2]%Rank%.  %playerName%  %playerKills% Kills  %playerHeadshots% Headshots  %playerDeaths% deaths by this Weapon  Headshotrate: %playerKHR%%"
"DebugLevel" "Error"
"Keywordlist" ""
"tableSuffix" ""
"MapStats ON_" "Yes"
"Session ON_" "Yes"
"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"
"Save Sessiondata to DB_" "Yes"
"Playerrequests per Round" "10"
"Servertime Offset" "0"
"Periodical Webrequest On_(P&S Stats)" "Yes"
"Webaddress" ""
"Webrequest Intervall" "60"

[ImportBot]

Originally Posted by XpKiller*:

 

@-cc-

settings logs ok

it should be working

[ImportBot]

Originally Posted by cc*:

 

I have no idea then, the chat table is getting updated no problem, all the weapon tables are completely empty. Thanks anyway.

[ImportBot]

Originally Posted by XpKiller*:

 

you could check if your bf3.def is up to date.

[ImportBot]

Originally Posted by XpKiller*:

 

Finally new Version 1.0.0.5!

 

Changelog:

Optimzed some transactions

Added locktimeout and deadlock detection and handling this should solve those lock/deadlock errors which some user have.

fixed bug with the yell command

fixed a broken query

changed welcomestats a bit

 

Note:

Welcomestats are now customizable like the playerstats Messages

[ImportBot]

Originally Posted by Polak*:

 

Im having some error codes.

 

 

Code:

procon.protected.plugins.enable "CChatGUIDStatsLoggerBF3" True
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Close Connection after each request_" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "High performance mode(no connection limit!)" "On"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Failed Transaction retry attempts" "3"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable Chatlogging_" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Log ServerSPAM_" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Instant Logging of Chat Messages_" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable chatlog filter(Regex)_" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable Statslogging_" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Ranking by Score_" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable ingame commands_" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Overall ranking(merged Serverranking)" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Server group (0 - 128)" "0"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Send Stats to all Players_" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "PlayerMessage" "[yell,2]Serverstats for %playerName%:|[yell,3]Score: %playerScore%  %playerKills% Kills %playerHeadshots% HS  %playerDeaths% Deaths K/D: %playerKDR%|[yell,3]Your Serverrank is: %playerRank% of %allRanks%"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Weaponstats Message" "[yell,2]%playerName%'s Stats for %Weapon%:|[yell,3]%playerKills% Kills  %playerHeadshots% Headshots  Headshotrate: %playerKHR%%  %playerDeaths% died by this Weapon|[yell,3]Your Weaponrank is: %playerRank% of %allRanks%"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Serverstats Message" "[yell,2]Serverstatistics for server %serverName%|[yell,3]Unique Players: %countPlayer%  Totalplaytime: %sumPlaytime%|[yell,3]Totalscore: %sumScore% Avg. Score: %avgScore% Avg. SPM: %avgSPM%|[yell,3]Totalkills: %sumKills% Avg. Kills: %avgKills% Avg. KPM: %avgKPM%"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Awards ON_" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable Welcomestats_" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Yell Welcome Message(not the stats)_" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Welcome Message" "[yell,3]Nice to see you on our Server again, %playerName%|[yell,2]Serverstats for %playerName%:|[yell,3]Score: %playerScore%  %playerKills% Kills %playerHeadshots% HS  %playerDeaths% Deaths K/D: %playerKDR%|[yell,3]Your Serverrank is: %playerRank% of %allRanks%"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Welcome Message for new Player" "[yell,3]Welcome to the %serverName% Server, %playerName%"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Welcomestats Delay" "5"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Top10 ingame" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Top10 header line" "[yell,2]Top 10 Player of the %serverName% Server"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Top10 row format" "[yell,2]%Rank%. %playerName%  Score: %playerScore%  %playerKills% Kills  %playerHeadshots% Headshots  %playerDeaths% Deaths  KDR: %playerKDR%"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "WeaponTop10 header line" "[yell,2]Top 10 Player with %Weapon% of the %serverName%"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "WeaponTop10 row format" "[yell,2]%Rank%.  %playerName%  %playerKills% Kills  %playerHeadshots% Headshots  %playerDeaths% deaths by this Weapon  Headshotrate: %playerKHR%%"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "DebugLevel" "Info"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Keywordlist" "RPG-7{RPG}|Weapons/SCAR-H/SCAR-H{SCAR,SCAR-H,SCARH}|USAS-12{USAS12,USAS}|M27IAR{M27}|M16A4{M16,M16A3}|AEK-971{AEK971,AEK}|Weapons/A91/A91{A91,A-91}|Weapons/AK74M/AK74{AK74,AK74M,AK74-M}|Weapons/G36C/G36C{G36C,G36}|Weapons/G3A3/G3A3{G3A3,G3}|Weapons/Gadgets/C4/C4{C4,C-4}|Weapons/Gadgets/Claymore/Claymore{CLAYMORE,CLAY,LANDMINE}|Weapons/KH2002/KH2002{KH2002}|Weapons/Knife/Knife{KNIFE,MESSER}|Weapons/M416/M416{M416,M-416}|Weapons/MagpulPDR/MagpulPDR{MagpulPDR,PDR}|Weapons/MP412Rex/MP412REX{MP412REX,REX,MP412}|Weapons/MP443/MP443{MP443}|Taurus .44{.44,TAURUS,TAURUS.44}|Weapons/P90/P90{P90}|Weapons/Sa18IGLA/Sa18IGLA{Sa18IGLA,Sa18,IGLA}|Weapons/UMP45/UMP45{UMP,UMP-45,UMP45}|Weapons/XP1_L85A2/L85A2{L85A2,L85A,L85}|Glock18{GLOCK}"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "tableSuffix" ""
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "MapStats ON_" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Session ON_" "No"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "SessionMessage" "[yell,3]%playerName%'s Session Data  Session started %SessionStarted%|[yell,3]Score: %playerScore%  %playerKills% Kills  %playerHeadshots% HS  %playerDeaths% Deaths K/D: %playerKDR%|[yell,3]Your Rank: %playerRank% (%RankDif%)  Sessionlength: %SessionDuration% Minutes"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Save Sessiondata to DB_" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Playerrequests per Round" "10"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Servertime Offset" "0"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Periodical Webrequest On_(P&S Stats)" "Yes"
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Webaddress" ""
procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Webrequest Intervall" "60"

Code:

[08:13:47 58] Error: Error in Startstreaming: System.InvalidOperationException: OdbcConnection does not support parallel transactions.
   at System.Data.Odbc.OdbcConnection.Open_BeginTransaction(IsolationLevel isolevel)
   at System.Data.Odbc.OdbcConnectionOpen.BeginTransaction(IsolationLevel isolevel)
   at System.Data.Odbc.OdbcConnection.BeginTransaction(IsolationLevel isolevel)
   at System.Data.Odbc.OdbcConnection.BeginTransaction()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreaming()

[08:13:47 86] Info: Connection OdbcConn closed

[08:13:47 86] Error: Error in Startstreaming: System.InvalidOperationException: Invalid operation. The connection is closed.
   at System.Data.ProviderBase.DbConnectionClosed.BeginTransaction(IsolationLevel il)
   at System.Data.Odbc.OdbcConnection.BeginTransaction(IsolationLevel isolevel)
   at System.Data.Odbc.OdbcConnection.BeginTransaction()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreaming()

[08:13:52 02] Info: Streamingprocess duration: 7.578 seconds
[08:13:52 25] Info: Streamingprocess duration: 6.641 seconds

[08:13:52 25] Error: Error in Startstreaming OuterException: System.InvalidOperationException: This OdbcTransaction has completed; it is no longer usable.
   at System.Data.Odbc.OdbcTransaction.Rollback()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.StartStreaming()

[ImportBot]

Originally Posted by XpKiller*:

 

Damn I missed a transaction rollback.

[ImportBot]

Originally Posted by Polak*:

 

Damn I missed a transaction rollback.

Can that cause an error in my statspage from RMG-Dr4k3 ? I'm having a little problem with it.

[ImportBot]

Originally Posted by XpKiller*:

 

Can that cause an error in my statspage from RMG-Dr4k3 ? I'm having a little problem with it.

No dont think so.

[ImportBot]

Originally Posted by XpKiller*:

 

New version 1.0.0.6

 

Changelog:

fixed an error which could cause that the streamingprocess could fail.

[ImportBot]

Originally Posted by Polak*:

 

What's the size of the DB with.. i dont know what's the player limit, 1.500? and around 500 chat messages?

 

Which would be the approximate size?

 

My free DB host is tooooo slow... and I want to host it on my website but i dont know if i have enough space, I'm also worried about the data transfer

[ImportBot]

Originally Posted by ty_ger07*:

 

What's the size of the DB with.. i dont know what's the player limit, 1.500? and around 500 chat messages?

 

Which would be the approximate size?

 

My free DB host is tooooo slow... and I want to host it on my website but i dont know if i have enough space, I'm also worried about the data transfer

My database has two servers in it and one month of chat messages. Between the two servers, there are about 45,000 players logged. My database size is 117 MB.

[ImportBot]

Originally Posted by HaNg_MaN*:

 

2 server, with 160000 player,no chatlog=300mb

[ImportBot]

Originally Posted by Vetula*:

 

27 Servers

With 255891 Player's

No Chatlog -> No Mapstats

834 MB

[ImportBot]

Originally Posted by Polak*:

 

And where can I set max. players and max. chat messages?

[ImportBot]

Originally Posted by XpKiller*:

 

Why?

 

You can't set this.

[ImportBot]

Originally Posted by Buster78*:

 

Is there a video tutorial on how to set this up?

[ImportBot]

Originally Posted by Polak*:

 

Why?

 

You can't set this.

Be cause if i want to setup this on my website, I can't have another 500Mb DB, i have 2Gb of HardDisk and already using 800Mb for the Website and one DB.