Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

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!!

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

FAQ and Troubleshotting

[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_.*"