Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[XpKiller]

Description:
This plugin is used to log player chat, player GUID's, player Stats, Weaponstats and Mapstats.
This includes: Chat, PBGUID, EAGUID, IP, Stats, Weaponstats, Dogtags, Killstreaks, Country, ClanTag to be continued.. ;-)
Please post errors if get some.
You can adjust the debug level to a lower value to get less Console Spam. High -> Low (Trace, Info, Warning, Error).
Error only will show critical errors.
Feel free to post feedback and suggestions.

Requirements:
The plugin Sandbox needs to be disabled!!! if you are not using PRoCon 1.4.1.2 or later
Access to a MySQL database that accepts remote connections is required so you need to create a user and database if not exists.
It requires the use of a MySQL database with INNODB engine that allows remote connections.(MYSQL Version 5.1 or greater is required!!!)
No ODBC Driver is needed!!!.

Pleases also read the changelog

Installation:
Extract the content of Zipfile into plugin directory.
Set DB Server Settings and the Plugin Settings
Add the machine running the plugin to the remote mysql access host list.
Will throw a permissions error if not done
Enter the correct details for your database connection in the plugin settings tab. You don't need to create tables, the plugin will do that.
The Standard MySQL Port is 3306.

Supported Games:

• Battlefield 4
• Battlefield 3
• Battlefield Bad Comany 2 + Vietnam
• MOH
• MOHW

Whats new:

• New Databasedesign only one Set of tables needed for multiply gameserver even with different games. Stats are not mixed up!!
• The new Databasedesign allows easy deletion of playerentries.
• Some Code improvements.
• one table for all Weaponstats
• You can create Servergroups

Working:

• Guidlogging
• Statslogging
• Chatlogging
• Weaponstatslogging
• Autotable creation
• Ingame commands
• Welcomestats
• Ingame commands for Dogtags
• merged stats from all Server

May Working:

• Ingame Weaponstats

Not Working:

• ClanTag coz the server don't deliver it to PRoCon thx EA/DICE!!!.
• Stats for tanks and other vehicles. thx EA/DICE!!!.

ToDo's:
Ticketcount for ServerLiveView
Join/Leave History <-- next on list
Bugfixes(always :-))
Code improvements

Issues/Requests:
--

Fixed or Implemented:

• Deprecated Trace messages: https://forum.myrcon.com/showthread....ll=1#post83338
• Missing columns for AdKats
• tbl_playerdata: column GameID has no default value --> https://forum.myrcon.com/showthread....ll=1#post83411
• Feature request: Error prefix
• Duplicate Weapon entry try: https://forum.myrcon.com/showthread....ll=1#post83471
• Feature request: Simple Stats: https://forum.myrcon.com/showthread....ll=1#post83476
• CountryCode too long for column: https://forum.myrcon.com/showthread....ll=1#post83485
• Weaponname too long for Fullname column: https://forum.myrcon.com/showthread....ll=1#post83515
• Feature Request: Option to disabled weaponstats: https://forum.myrcon.com/showthread....ll=1#post83532

Current Version:
Stable: 1.0.0.3


Changelog:

1.0.0.3
Many thanks to Tyger.
Line 462 through 545: Added additional weapon keywords.
Line 4367: Fixed error in query which caused !top10 weapons query to fail.
Line 5489: Fixed null primary key problem which caused incompatibility with MySQL version 5.7.3 m13 and up.

1.0.0.2
Bugfixes for column errors.
Bugfixes for the sessions streaming bug
Weaponstats working again. 
Bugfix for Identifier name is too long.

1.0.0.1
Bugfixes for value too long for column errors.
Bugfixes for some other bugs
Changed deprecated Tracemessages
Added an error prefix in pluginlog 
New feature: Tickets/teamscores are now tracked in tbl_teamscores 
New feature: Simple Stats (collects playerdata only)
New feature: Switch for disabling weaponstats 


1.0.0.0
First Release

extended Keywordlist(BF3):

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}
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{USAS,USAS12,USAS-12}
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/SCAR-H/SCAR-H{SCARH,SCAR-H}
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}

Download Official Version 1.0.0.3:

[XpKiller]

Website development :Old Thread(the most queries still should work):
https://forum.myrcon.com/showthread....atsDB-examples

Show all Weapons known by the plugin:

SELECT `tbl_games`.`Name`, tbl_weapons.* FROM tbl_weapons
INNER JOIN tbl_games using (`GameID`);

Show Weaponstats for a single Player for one Server:

SELECT 
`tbl_playerdata`.`SoldierName`,
`tbl_weapons`.`Fullname`,
`tbl_weapons`.`Damagetype`,
`tbl_weapons_stats`.`Kills`,
`tbl_weapons_stats`.`Headshots`,
`tbl_weapons_stats`.`Deaths`
FROM `tbl_playerdata`
INNER JOIN `tbl_server_player` ON `tbl_playerdata`.`PlayerID` = `tbl_server_player`.`PlayerID`
INNER JOIN `tbl_weapons_stats` ON `tbl_server_player`.`StatsID` = `tbl_weapons_stats`.`StatsID`
INNER JOIN `tbl_weapons` ON `tbl_weapons_stats`.`WeaponID` = `tbl_weapons`.`WeaponID`
WHERE 
`tbl_playerdata`.`SoldierName` ="XpKiller" AND `tbl_server_player`.`ServerID` = 1

[XpKiller]

[Chatlog] How to filter Comorose Spam?

• [1]Enable chatlog filter(RegEx)? --> yes
  [2]Open "Chatfilterrules(Regex)" -->...
  [3] Add the this rule (without the quotes): "ID_CHAT_.*"
  [4]In Trace you will see this now: "Chatmessage: 'ID_CHAT_REQUEST_AMMO' was filtered out by the Regex rule: ID_CHAT_.*"

Webstatspages:
https://forum.myrcon.com/showthread....apstats-Logger

[Narf!]

Yay, will test it =)) Thank you very much! Ok... I'll test it if the download is available

[XpKiller]

Download added.

It recommended to start with a new db.

I will provide a Migrationscript from BF3 to this release if somebody will need it.

[jking54]

Is this compatible with AdKats then?

[XpKiller]

The code added for AdKats is included. I dont tested it with AdKats yet. But is guess AdKats will need a few adjustments due the changed plugin name.

[jking54]

Should be a total of 14 tables correct?

EDIT: up and running on 2 of my 4 servers, looks good so far...

[toxicman2002]

Hello,

i will get this error in my Plugin-Box:

[23:09:51 93] Error: Error in UpdateCurrentPlayerTable:
[23:09:51 93] Message: Out of range value for column 'Ping' at row 22
[23:09:51 93] Native: -2147467259
[23:09:51 94] Source: MySql.Data
[23:09:51 94] StackTrace: bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()
bei MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)
bei MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
bei MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
bei MySql.Data.MySqlClient.MySqlDataReader.NextResult( )
bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)
bei MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()
bei PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPla yerTable(List`1 lstPlayers)

Whats the issue?

[XpKiller]

@toxicman2002
seems to be a bug.

@jking54
Yep 14 tables.