Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by B3g1nz*:

 

I just got this error after I updated my adkats

 

error.png

 

What could be the problem?

 

thanks

[ImportBot]

Originally Posted by chesterfield*:

 

Same problem as B3g1nz

[ImportBot]

Originally Posted by mantis*:

 

Hi guys

 

How do i completely reset the plugin, i have moved DB's and want to clear all cache information and start fresh

 

every time i remove the plugin and associated files (or what i think) when i reload the plugin from scratch all my old information is still there?

[ImportBot]

Originally Posted by B3g1nz*:

 

It was Adkats and it has been resolved in the latest beta build:

 

https://github.com/ColColonCleaner/AdKats/issues/319

This could be the answer

[ImportBot]

Originally Posted by Jaffaman*:

 

We are still having the same problem with the live scoreboard switching off even after doing the adkats patch anyone else or just us ?

 

I have updated the Adkats webadmin and it seems to work ok for the webadmin but it still seems to switch off the Enable live scoreboard in DB in the Prcon Chat, GUID,Stats and map logger - 1.0.0.2 when I turn off the Adkats plugin we can Enable live scoreboard in DB and it stays on i have posted on Adkats site for help.

[ImportBot]

Originally Posted by Jaffaman*:

 

The reply i got from Adkats website was...... This has to do with AdKats. @ColColonCleaner

[ImportBot]

Originally Posted by Lantecer*:

 

I got the following Error:

 

Code:

[Statslogger]Error: getUpdateServerID1: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".
   bei System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
   bei System.Security.CodeAccessPermission.Demand()
   bei System.Net.Sockets.Socket.CheckCacheRemote(EndPoint& remoteEP, Boolean isOverwrite)
   bei System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)
   bei System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)
   bei MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, Boolean unix)
   bei MySql.Data.Common.StreamCreator.GetStreamFromHost(String pipeName, String hostName, UInt32 timeout)
   bei MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)
   bei MySql.Data.MySqlClient.NativeDriver.Open()
   bei MySql.Data.MySqlClient.Driver.Open()
   bei MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   bei MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   bei MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   bei MySql.Data.MySqlClient.MySqlPool.GetConnection()
   bei MySql.Data.MySqlClient.MySqlConnection.Open()
   bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID(CServerInfo csiServerInfo)
Die Aktion, bei der ein Fehler aufgetreten ist:
Demand
Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:
System.Net.SocketPermission
Die Zone der Assembly, bei der ein Fehler aufgetreten ist:
MyComputer

I think it has something to do with my mysql database settings but i'm not sure. Can you help me?

[ImportBot]

Originally Posted by redshark1802*:

 

Hi everybody

 

I just installed this plugin for my BC2 server and maybe I'm missing someting but I can't record playerstats, except tbl_chatlog, tbl-games, tbl_currentplayers and tbl_server. I checked the previous advise on the forum for this plugin, but can't find any clue :/

 

here are my settings :

enable chatlogging : yes

log serverspam : no

instant logging of chat messages : no

enable chat log filter : no

map stats on : yes

Enable statslogging : yes

enable weaponstats : yes

ranking by score : yes

enable ingame commands : yes

overall ranking : no

server group : 0

send stats to all players : yes

kdr correction : yes

enable livescore in DB : yes

log player data only : no

table suffix : empty

 

thanks for your help

Dreddy

We have exactly the same problem.

 

We are currently running several bf3(8) and bf4(6) servers without any problem but bc2 doesn't seem to work.

The config is shared between all servers, including the mysqluser, the only difference is the database name.

 

This is not an issue with the database since the tables are created and the server(name) is inserted to the database.

 

I'm not seeing any other options.

Would some please help us.

 

The best,

redshark1802

Is there any news on this issue?

God_Zilla pointed out that he is having the same problem.

 

The best,

Simon

[ImportBot]

Originally Posted by Jamesonp*:

 

Hi,

 

Thank you for the awesome plugin. I just have one feature request, can you have the plugin log the ending ticket count in tbl_mapstats?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Hi,

 

Thank you for the awesome plugin. I just have one feature request, can you have the plugin log the ending ticket count in tbl_mapstats?

Ending ticket count is lagged, and can only be monitored OnServerInfo which happens every 30 seconds or so. So the ending ticket count will be 231:20 or 15:500, it doesn't go to zero. Or for additive game types with say 400 tickets, it will be 385:300 for example. It wont go to 400 exactly.

[ImportBot]

Originally Posted by Jamesonp*:

 

Ahh, makes sense.

[ImportBot]

Originally Posted by shorty673*:

 

hi,

 

im using this plugin and im a totally noob with php.

i´m trying to connect the database of this plugin with my wordpress page

can some1 help me? maybe with pn´s so we dont spam this Thead?

 

Kind Regards

Max

[ImportBot]

Originally Posted by ty_ger07*:

 

hi,

 

im using this plugin and im a totally noob with php.

i´m trying to connect the database of this plugin with my wordpress page

can some1 help me? maybe with pn´s so we dont spam this Thead?

 

Kind Regards

Max

You can download my stats page code. Maybe it will give you inspiration.

 

https://github.com/tyger07/BF4-Server-Stats_files=1

 

Most simply:

 

Code:

<_php

// DATABASE INFORMATION
DEFINE('HOST', 'put in here');				// database host address
DEFINE('PORT', '3306');			// database port - default is 3306
DEFINE('NAME', 'put in here');				// database name
DEFINE('USER', 'put in here');				// database user name
DEFINE('PASS', 'put in here');

// connect to the stats database
$BF4stats = mysqli_connect(HOST, USER, PASS, NAME, PORT) or die ("Unable to access stats database. Please notify this website's administrator.");

mysqli_select_db($BF4stats, NAME) or die ("Unable to select stats database. Please notify this website's administrator.");

_>

Then use the $BF4stats connection link in your queries.

 

For instance:

Code:

$Server_q = mysqli_query($BF4stats,"
	SELECT *
	FROM `tbl_games`
	WHERE `Name` = 'BF4'
");

[ImportBot]

Originally Posted by Kinsman*:

 

We are still having the same problem with the live scoreboard switching off even after doing the adkats patch anyone else or just us ?

 

I have updated the Adkats webadmin and it seems to work ok for the webadmin but it still seems to switch off the Enable live scoreboard in DB in the Prcon Chat, GUID,Stats and map logger - 1.0.0.2 when I turn off the Adkats plugin we can Enable live scoreboard in DB and it stays on i have posted on Adkats site for help.

Yep, exact same problem.

[ImportBot]

Originally Posted by audiodk*:

 

Hello I am trying to use your pluggin. My procon is hosted by gameservers and im trying to store the stats on my website. I keep getting this error though when i start the pluggin

 

[13:19:56 66] Error in Tablebuilder:

[13:19:56 66] Message: Host '68.232.167.46' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

[13:19:56 66] Native: -2147467259

[13:19:56 66] Source: MySql.Data

[13:19:56 66] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

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.tablebuilder()

[13:19:56 66] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[13:19:56 72] [statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Host '68.232.167.46' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

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)

[ImportBot]

Originally Posted by ty_ger07*:

 

Did you 'flush-hosts' in your database as the error message instructs?

[ImportBot]

Originally Posted by audiodk*:

 

not sure how to do that. Do i do that on my website host?

[ImportBot]

Originally Posted by ty_ger07*:

 

not sure how to do that. Do i do that on my website host?

If tye database is on your website host, yes. Otherwise, wherever the database is hosted. If you don't know how to flush hosts or your database user account doesn't have high enough permission to perform the operation, ask the host to perform the action for you.

[ImportBot]

Originally Posted by audiodk*:

 

That worked thank you for your help.

[ImportBot]

Originally Posted by audiodk*:

 

Ok now im getting another error and the stats are not working. this is the error im getting

 

[13:40:51 27] [statslogger]Error: Error in Startstreaming:

[13:40:51 27] Message: Cannot add or update a child row: a foreign key constraint fails (`audiodk_bf4stats`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[13:40:51 27] Native: -2147467259

[13:40:51 27] Source: MySql.Data

[13:40:51 27] 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.StartStreaming()

[13:40:51 94] [statslogger]Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

[ImportBot]

Originally Posted by audiodk*:

 

Can someone tell me why this is doing this? http://bf4stats.interceptorgaming.com/ I check my database and there is information getting stored there but some of it is also empty

 

This is what my database is showing.

 

localhost » audiodk_4

 

Structure

SQL

Search

Query

Export

Import

Operations

Routines

Events

Triggers

 

Table Ascending Action Rows Type Collation Size Overhead

tbl_chatlog Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 48 KiB -

tbl_currentplayers Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 16 KiB -

tbl_dogtags Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 48 KiB -

tbl_games Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8_unicode_ci 32 KiB -

tbl_mapstats Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9 InnoDB utf8_unicode_ci 32 KiB -

tbl_playerdata Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 77 InnoDB utf8_unicode_ci 48 KiB -

tbl_playerrank Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 77 InnoDB utf8_unicode_ci 48 KiB -

tbl_playerstats Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 64 KiB -

tbl_server Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 48 KiB -

tbl_server_player Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 64 KiB -

tbl_server_stats Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 32 KiB -

tbl_sessions Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 48 KiB -

tbl_teamscores Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8_unicode_ci 16 KiB -

tbl_weapons Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 225 InnoDB utf8_unicode_ci 64 KiB -

tbl_weapons_stats Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 48 KiB -

15 tables Sum 391 MyISAM utf8_unicode_ci 656 KiB 0 B

With selected: Check All / Uncheck All

 

Print view Print viewData Dictionary Data Dictionary

Create table

Name:

Number of columns:

Open new phpMyAdmin window

[ImportBot]

Originally Posted by audiodk*:

 

Problem fixed. Had to reboot my procon server and everything is working great. Thank you for this great pluggin

[ImportBot]

Originally Posted by celtsmaddog*:

 

Hey,

 

I have my bf4 server running well http://celtsclan.co.uk/BF4STATS/index.php, I now want to add my BC2 server, can I use the same database for BC2 as BF4, website stats page or is there a separate page for bc2.

 

thanks,

[ImportBot]

Originally Posted by ty_ger07*:

 

Hey,

 

I have my bf4 server running well http://celtsclan.co.uk/BF4STATS/index.php, I now want to add my BC2 server, can I use the same database for BC2 as BF4, website stats page or is there a separate page for bc2.

 

thanks,

You should probably ask in the stats page thread in the plugin enhancements section. XpKiller doesn't make stats pages.

[ImportBot]

Originally Posted by celtsmaddog*:

 

You should probably ask in the stats page thread in the plugin enhancements section. XpKiller doesn't make stats pages.

thanks XpKiller

[ImportBot]

Originally Posted by ty_ger07*:

 

thanks XpKiller

Ugg

[ImportBot]

Originally Posted by TrBoss*:

 

Hi;

 

We installed plugin and it started to work perfectly.But recently we noticed plugin doesn't keep the statistics.We tried to initialize the database ut result was the same.Tables,chatlog,player data ,current player etc. are ok but server stats table doesnt loading.What would be the problem ?

 

error code :

 

Code:

Error: System.InvalidOperationException: Collection was modified; enumeration operation may not execute.
   at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Enumerator.MoveNext()
   at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()
[13:13:04 64] Error: System.InvalidOperationException: Transaction has already been rolled back or is not pending
   at MySql.Data.MySqlClient.MySqlTransaction.Rollback()
   at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[ImportBot]

Originally Posted by supermillhouse*:

 

Maybe I'm just being dumb but I'm trying to figure out why for a particular weapon a sum of all its kills doesn't equal the sum of all of its deaths? Or am I misinterpreting what kills and deaths represent?

[ImportBot]

Originally Posted by ty_ger07*:

 

Maybe I'm just being dumb but I'm trying to figure out why for a particular weapon a sum of all its kills doesn't equal the sum of all of its deaths? Or am I misinterpreting what kills and deaths represent?

How much of an error are you seeing? Yes, the numbers should be the same for each weapon. A kill with a 870 for player A should add a death with a 870 for player B for instance.

 

The catch is, gadgets, suicides, falls, and environmental explosions, will not follow this behavior. Primarily, "bad luck" and the odd behavior of a revive being counted as a medkit kill screws up the sum of all kills and all deaths being equal. The rest of the weapons should though. Or very closely follow this behavior except for a small deviation due to random error and stats not being doled out properly due to when a round starts or ends or when players join or leave in reference to when the stats are compiled and updated.

 

Here is a query:

SELECT tws.`WeaponID`, tw.`Friendlyname`, SUM(`Kills`) AS Kills, SUM(`Deaths`) AS Deaths FROM `tbl_weapons_stats` tws INNER JOIN `tbl_weapons` tw ON tws.`WeaponID` = tw.`WeaponID` GROUP BY tws.`WeaponID`

Here are the results:

"WeaponID" "Friendlyname" "Kills" "Deaths"

"1" "DamageArea" "2138" "5226"

"2" "SoldierCollision" "20" "6017"

"3" "Suicide" "0" "1560"

"4" "Death" "116158" "122526"

"5" "RoadKill" "4549" "24568"

"6" "Melee" "13170" "13202"

"7" "Defib" "437" "437"

"8" "Repairtool" "382" "502"

"9" "Scout" "3101" "3103"

"10" "870" "9938" "9917"

"11" "DBV12" "5567" "5561"

"12" "HAWK" "3007" "3011"

"13" "M1014" "6114" "6116"

"14" "M26Mass" "979" "980"

"15" "M26Mass_Flechette" "431" "430"

"16" "M26Mass_Frag" "86" "91"

"17" "M26Mass_Slug" "114" "114"

"18" "M416_M26_Buck" "46" "52"

"19" "M416_M26_Flechette" "84" "84"

"20" "M416_M26_Slug" "2" "2"

"21" "QBS09" "17937" "17945"

"22" "SAIGA_20K" "4490" "4495"

"23" "SCAR-H_M26_Buck" "163" "163"

"24" "SCAR-H_M26_Flechette" "19" "19"

"25" "SerbuShorty" "5187" "5188"

"26" "SPAS12" "3170" "3169"

"27" "USAS-12" "1067" "1151"

"28" "USAS-12_Nightvision" "1248" "1369"

"29" "UTAS" "3231" "3238"

"30" "XM25_Flechette" "280" "279"

"31" "A91" "6488" "6486"

"32" "ACR" "38712" "38714"

"33" "AEK971" "107960" "107942"

"34" "AK12" "44212" "44258"

"35" "AK5C" "44790" "44784"

"36" "AKU12" "15940" "15941"

"37" "CZ805" "10118" "10109"

"38" "FAMAS" "14159" "14184"

"39" "G36C" "6540" "6541"

"40" "GalilACE" "14172" "14168"

"41" "GalilACE23" "89582" "89552"

"42" "GalilACE52" "38790" "38801"

"43" "L85A2" "34644" "34669"

"44" "M16A4" "10411" "10445"

"45" "M416" "58919" "58925"

"46" "M4A1" "5088" "5087"

"47" "MTAR21" "29614" "29597"

"48" "QBZ951" "4506" "4507"

"49" "SAR21" "20570" "20568"

"50" "SCAR-H" "42868" "42871"

"51" "SG553LB" "13173" "13173"

"52" "SteyrAug" "17396" "17403"

"53" "Type95B" "3500" "3498"

"54" "AEK971_M320_HE" "355" "374"

"55" "AEK971_M320_LVG" "491" "510"

"56" "AK12_M320_HE" "222" "239"

"57" "AT4" "112" "118"

"58" "FGM148" "364" "366"

"59" "FIM92" "1503" "1507"

"60" "M16A4_M320_HE" "19" "19"

"61" "M320_HE" "8428" "8872"

"62" "M320_LVG" "21284" "21949"

"63" "M320_SHG" "53" "53"

"64" "M416_M320_HE" "335" "367"

"65" "MGL" "2003" "2111"

"66" "NLAW" "3716" "3969"

"67" "QBZ951_M320_HE" "35" "39"

"68" "RPG7" "8106" "8472"

"69" "Sa18IGLA" "450" "451"

"70" "SAR21_M320_HE" "133" "140"

"71" "SCAR-H_M320_HE" "428" "459"

"72" "SMAW" "1963" "2030"

"73" "SRAW" "4886" "5055"

"74" "Starstreak" "396" "406"

"75" "SteyrAug_M320_HE" "79" "84"

"76" "SteyrAug_M320_LVG" "89" "95"

"77" "XM25" "8128" "8325"

"78" "AMR2" "663" "663"

"79" "AMR2_MED" "585" "585"

"80" "CS-LR4" "12356" "12358"

"81" "FY-JS" "849" "849"

"82" "GalilACE53" "1551" "1551"

"83" "JNG90" "3912" "3912"

"84" "L96A1" "4040" "4049"

"85" "M200" "12668" "12671"

"86" "M39EBR" "3485" "3486"

"87" "M40A5" "12743" "12744"

"88" "M82A3" "118" "118"

"89" "M82A3_CQB" "1181" "1181"

"90" "M82A3_MED" "7661" "7660"

"91" "M98B" "3182" "3185"

"92" "MK11" "7569" "7559"

"93" "QBU88" "1415" "1415"

"94" "RFB" "11365" "11364"

"95" "SCAR-HSV" "1495" "1499"

"96" "SKS" "6767" "6763"

"97" "SRS" "3315" "3324"

"98" "SV98" "1894" "1893"

"99" "SVD12" "2236" "2235"

"100" "C4" "6020" "8131"

"101" "C4_Support" "3311" "4218"

"102" "Claymore" "3420" "3460"

"103" "Claymore_Recon" "680" "694"

"104" "Flashbang" "48" "58"

"105" "Grenade_RGO" "12254" "13071"

"106" "M15" "1428" "1441"

"107" "M34" "1741" "1951"

"108" "M67" "7491" "8223"

"109" "SLAM" "2836" "3041"

"110" "V40" "35858" "37814"

"111" "CBJ-MS" "2098" "2098"

"112" "JS2" "885" "885"

"113" "MagpulPDR" "4220" "4213"

"114" "MP7" "7768" "7766"

"115" "MX4" "17004" "17002"

"116" "P90" "4490" "4491"

"117" "PP2000" "5972" "5967"

"118" "Scorpion" "5688" "5689"

"119" "UMP45" "7968" "7967"

"120" "CZ75" "1061" "1062"

"121" "FN57" "831" "831"

"122" "Glock18" "2012" "2012"

"123" "HK45C" "1838" "1845"

"124" "M1911" "2135" "2135"

"125" "M9" "6981" "6983"

"126" "M93R" "2078" "2077"

"127" "MP412Rex" "2167" "2170"

"128" "MP443" "3265" "3265"

"129" "P226" "17145" "17166"

"130" "QSZ92" "2082" "2085"

"131" "Taurus44" "845" "846"

"132" "LSAT" "15619" "15599"

"133" "M240" "10645" "10653"

"134" "M249" "26228" "26219"

"135" "MG4" "27578" "27568"

"136" "Pecheneg" "11441" "11437"

"137" "QBB95" "4321" "4373"

"138" "RPK12" "4176" "4178"

"139" "RPK-74" "5238" "5241"

"140" "Type88" "18978" "19032"

"141" "Ultimax" "23208" "23216"

"142" "M320_SMK" "17" "17"

"143" "M416_M320_FLASH" "3" "3"

"146" "XM25_Smoke" "13" "13"

"147" "Medkit" "33" "1052"

"148" "PortableMedicpack" "0" "64"

"149" "Tomahawk" "770" "1156"

"150" "UMP9" "1298" "1297"

"160" "AK12_M320_SHG" "1" "1"

"161" "CZ805_M26_Buck" "4" "4"

"173" "M16A4_M26_Frag" "1" "1"

"177" "M416_M26_Frag" "6" "6"

"178" "M416_M320_SHG" "6" "6"

"188" "SAR21_M320_SHG" "2" "2"

"189" "SCAR-H_M26_Frag" "1" "1"

"190" "SCAR-H_M26_Slug" "5" "5"

"191" "SCAR-H_M320_SHG" "6" "6"

"208" "AEK971_M320_FLASH" "6" "6"

"212" "CZ805_M320_FLASH" "1" "1"

"216" "M16A4_M320_FLASH" "4" "4"

"218" "M320_FLASH" "46" "47"

"221" "SAR21_M320_FLASH" "2" "2"

"224" "SteyrAug_M320_FLASH" "7" "7"

"226" "AK12_M320_LVG" "50" "53"

"227" "CZ805_M320_HE" "13" "13"

"228" "CZ805_M320_LVG" "79" "84"

"231" "M16A4_M320_LVG" "63" "65"

"232" "M416_M320_LVG" "118" "124"

"233" "QBZ951_M320_LVG" "15" "15"

"234" "SAR21_M320_LVG" "29" "29"

"235" "SCAR-H_M320_LVG" "44" "48"

"241" "AMR2_CQB" "326" "326"

You will see that the total kills and deaths with each weapon are identical or very close to identical.

 

Perhaps the query you used was incorrect in the way it grouped or summed values or perhaps you didn't take into consideration some bad behaviors caused by the way "bad luck", revives, and gadgets screw up the totals. But if you just look at each individual weapon, the totals are very similar.

 

For instance, if I just looked at the totals, in this manner, it would look like something was very wrong:

 

SELECT SUM(`Kills`) AS Kills, SUM(`Deaths`) AS Deaths FROM `tbl_weapons_stats`

"Kills" "Deaths"

"1363916" "1412443"

4% out and pretty poor.

 

Instead of that example of a poor result, you can filter out the badly behaving weapons and then look again:

 

SELECT SUM(`Kills`) AS Kills, SUM(`Deaths`) AS Deaths FROM `tbl_weapons_stats` tws INNER JOIN `tbl_weapons` tw ON tws.`WeaponID` = tw.`WeaponID` WHERE tw.`Friendlyname` 'DamageArea' AND tw.`Friendlyname` 'SoldierCollision' AND tw.`Friendlyname` 'Suicide' AND tw.`Friendlyname` 'Death' AND tw.`Friendlyname` 'RoadKill' AND tw.`Friendlyname` 'Medkit' AND tw.`Friendlyname` 'PortableMedicpack'

"Kills" "Deaths"

"1241018" "1251430"

Within 1% of eachother.

[ImportBot]

Originally Posted by RastasUAKh*:

 

Hello,

 

procon 1.4.2.0

PRoCon Chat, GUID, Stats and Map Logger - 1.0.0.2

 

Can you help me please? I have a problem, everything was ok but now i see some strange errors in procon and my stats equals to 0.

 

[statslogger]Warning: PrepareKeywordDic: Mainkey RPG-7 not found!

[00:40:18 92] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/SCAR-H/SCAR-H not found!

[00:40:18 92] [statslogger]Warning: PrepareKeywordDic: Mainkey USAS-12 not found!

[00:40:18 92] [statslogger]Warning: PrepareKeywordDic: Mainkey M27IAR not found!

[00:40:18 92] [statslogger]Warning: PrepareKeywordDic: Mainkey M16A4 not found!

[00:40:18 92] [statslogger]Warning: PrepareKeywordDic: Mainkey AEK-971 not found!

[00:40:18 92] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/A91/A91 not found!

[00:40:18 92] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/AK74M/AK74 not found!

[00:40:18 92] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G36C/G36C not found!

[00:40:18 92] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/G3A3/G3A3 not found!

[00:40:18 92] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Gadgets/C4/C4 not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Gadgets/Claymore/Claymore not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/KH2002/KH2002 not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Knife/Knife not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/M416/M416 not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MagpulPDR/MagpulPDR not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP412Rex/MP412REX not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/MP443/MP443 not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Taurus .44 not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/P90/P90 not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/Sa18IGLA/Sa18IGLA not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/UMP45/UMP45 not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Weapons/XP1_L85A2/L85A2 not found!

[00:40:18 94] [statslogger]Warning: PrepareKeywordDic: Mainkey Glock18 not found!

http://stats.bf4.com.ua/index.php_Se...&search=Search

 

Here is the problem, 2 soldiers with same nickname, but i didn't change my origin account, it's the same.

 

Thanks