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

[ImportBot]

Originally Posted by 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.Whats new:

• New Databasedesign only one Set of tables needed for multiply gameserver. Stats are not mixed up!!
• The new Databasedesign allows easy deletion of playerentries.
• Some Code improvements.
• Weaponstables are split up into weaponclasses.
• You can create Servergroups

Working:

• Ingame Weaponstats
• Guidlogging
• Statslogging
• Chatlogging
• Weaponlog you need a proper bf3.def file for it (next the procon release will have one)
• Autotable creation
• Ingame commands
• Welcomestats
• Ingame commands for Dogtags
• merged stats from all Server

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:/b]Ticketcount for ServerLiveViewJoin/Leave History Issues:--Requirements: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.x is required!!!)Version 1.1.0.0 or higher dont need the ODBC Driver!!Also the ODBC 5.1 Driver (the latest is 5.1.9) is needed and can be found here http://dev.mysql.com/downloads/connector/odbc/5.1.html .PLS READ THE CHANGELOGInstallation:Extract CChatGUIDStatsLogger.cs into plugin directory.Set DB Server Settings and the Plugin SettingsAdd the machine running the plugin to the remote mysql access host list.Will throw a permissions error if not done[before 1.1.0.0]Enable outgoing ODBC Connections, located in Tools -> Options -> PluginsWill throw a permissions error if not doneEnter 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.Current Version:Stable: 1.1.0.1Beta: 1.0.1.0 with MySQL ODBC Driver 5.2 Attention (only for 1.0.x.x):ODBC MYSQL Driver 5.1.11 is buggy and will cause faulty date entires.http://bugs.mysql.com/bug.php_id=65418Thx to johnny5 for the findIts recommend to use the 5.1.9 or 5.1.10 DriverThe MySQL ODBC Driver 5.2 is support in Version 1.0.1.0 but need some testing.If you are running a 64bit System please take a look at this: http://support.microsoft.com/kb/942976Changelog:Code:

1.1.0.1

Some changes to fix the timeout issues.

Thanks to russel5 & HexaCanon for Testing!

New Defaults for connection pooling --> min poolsize = 0 and max poolsize = 10 
If you still have problems try to disable connection pooling or increase the max connectionpoolsize.



1.1.0.0

ProCon 1.4.0.5 or higher is required!!!

The Plugin uses the native ADO MySQL Connector now instead of the MySQL ODBC Driver. 

NO Driver Installation needed anymore!!! 

This also means it can be run on host with dont install the odbc driver like gameservers.com.

Also supporting Connection Pooling.

New feature Livescoreboard: If enabled, the plugin write several infos to the database in a table called tbl_currentplayers. 

Some of these infos are: Playerinfos(name, guids, countrycode, ...) and Playerstat(Score, Kills, Deads, Headshots)

The table gets updated everytime procon gets new full playerlist update (around every 30 sec. its adjustable to less updates.) 

Some smaller fixes and improvments code



1.0.1.0

Added support for the new MySQL ODBC Driver 5.2. (not tested so its beta) 

You can switch between both versions in the pluginsetup


1.0.0.9

Optimzed / rewritten Code 

New Ingame Commandsystem; every commandword can be customized now. Also you can set multiply commandword for the same command (comma seperated, e.g: stats,rank)

New Ingamecommand Player of the day, shows up the best player of the server for today (sessions needs to be turned on!)

New Ingamecommand top10 player for a variable period, shows up the top 10 players for a specific period (default is 7 days) (sessions needs to be turned on!)

a few performance improvements



1.0.0.8

Fix for ServerInfo and Playerlist issue which could trigger more updates as needed.(Reduces DB Load) This behavior was causes by other plugin which request additional ServerInfo and Playerlist events.

Added new feature K/D correction.(experimental)


1.0.0.7

Fix for the tablebuilder module its now more robust

Optimized Updateranking querys for better perfromance and locking behavior in large databases with many server.


[1.0.0.6]

fixed an error which causes that the steaming process fails.


[1.0.0.5]

Optimized 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


[1.0.0.4]

Increased stability --> ODBC errors shouldn't crash procon anymore.

Splited long transactions to avoid lock timeouts

fixed time issue

implemented admin.yell, can be used in every message just add the yelltag in the beginning of the message

Usage: [yell,duration] --> [yell,3]Welcome on our server!


[1.0.0.3]

Fixed selfdisable bug

Fixed bug which causes a procon crash, if a invalid weaponname was entered

Added performance info: duration of the streaming process. Debuglevel must set to Info to see this.

Added new feature chatfilter which allows you to filter out bad words or Admincommands based on Regex rules

Added new feature Sessiontracking. The sessions are now saved to the DB, this allows eg. daily/weekly/monthly leaderboards or a Playerhistory

Added new columns (Wins, Losses) to the tbl_playerstats table these columns contain the wins and losses of the player

Added new column (HighScore) to the tbl_playerstats table these columns contain the highest round Score the player has achieved.

Some code cleanup and improvements 


[1.0.0.2]

Improved some SQL-queries, some queries are 500% faster now and also causes less load on the DB.

some Bugfixes and improvements.

The Welcomestats are now triggered by the OnPlayerspawn Event.

The welcomestats delay is now a delay after the Playerspawn event.

A welcomestats delay of +5 sec. has been proven as suitable.

This also solves the problems with the different load times of the players.

Added Servergroup feature now you can make Stats groups within the one database.


[1.0.0.1]

Changed Connectionhandling to avoid errors under high load.

Added high perfomance mode (no connection limit for ODBC Connection)

Enable Connection Pooling in the ODBC Driver for best performance


[1.0.0.0]

Added a new mode how the plugin handle the DB Connection now

It force the plugin to close the connection after query. This may help to eliminate those sqlquerys bugs (System.InvalidOperationException...).

The Option is called: Close Connection after each request_

The default value is NO. Try Yes if you got errors

Not beta anymore due the main function are working now



[0.0.1.3beta]

The plugin now uses threads for db request this should avoid the procon laggs

Fixed SQL querys and serverstats Thx ty_ger07 for report


[0.0.1.2beta]

hotfix for sql error which occur on sql server with sql_strict_mode_on


[0.0.1.1beta]

fixed ingame dogtags

added new Ingame Command serverstats

The Usage of this command is the same like stats

added a new table tbl_server_stats which contains server stats (very useful for websites)

some minor changes and fixes


[0.0.1.0beta]

fixed ingame weaponstats

added option to turn off ingame commands

added options to customize the top10 messages 



[0.0.0.9beta]

Improved Statsstreaming process, now need much less queries.

Fixed broken SQL Query thx Legate for report.

Some minor fixes for Back to Karkand.


[0.0.0.8beta]

some code fixes

ingame Weapontop10 now working!


[0.0.0.7beta]

some code fixes

ingame Weaponstats now working!


[0.0.0.6beta]

some code fixes


[0.0.0.5beta]

some code fixes


[0.0.0.5beta]

Overall ranking (merged server-ranking) 
Fixed Queries 

Small code improvements

Fixed dogtag command

Fixes for some errors


[0.0.0.4beta]

only small changes due not much time today

Fixed rank command

Fixed top10 command



[0.0.0.3beta]

Fixed ingame Commands (mostly)

Fixed an error with cause stats getting mixed between the different gameserver.

Various code improvents

SQL Improvements



[0.0.0.2 beta]

Fixed Size of the ServerName field the tables must be dropped to have effect 

Hopefully fixed the table suffix and foreign Key issues.

Removed unneeded options put of plugin settings

Added a BF3.def File for Weaponstats Testing


[0.0.0.1 beta]

First Release

extended Keywordlist:Code:

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:Attached Files:

• CChatGUIDStatsLoggerBF3[1.1.0.1].zip
• CChatGUIDStatsLoggerBF3[1.0.1.0].zip

[ImportBot]

Originally Posted by i3lack*:

 

Can't wait to see the download. Thanks bud!!

[ImportBot]

Originally Posted by Clay52*:

 

The yell command still isn't functional is it? Thanks so much for this update!

[ImportBot]

Originally Posted by fue*:

 

Will you be able to watch it like a statspage like psycostats etc?

 

[ImportBot]

Originally Posted by RadicalMode*:

 

nice, thanks!

 

First Error:

 

[21:01:45 55] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.8]Data too long for column 'ServerName' at row 1

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by PBSGTS*:

 

Nvm, I see you addressed that in the OP.

 

nice, thanks!

 

First Error:

 

[21:01:45 55] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.8]Data too long for column 'ServerName' at row 1

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

Not having this error.

 

Doesn't seem to be tracking anything other than the server and chat though :/ Any ETA on the next procon release?

[ImportBot]

Originally Posted by Belligerent*:

 

nice, thanks!

 

First Error:

 

[21:01:45 55] Error: getUpdateServerID1: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.8]Data too long for column 'ServerName' at row 1

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()

at PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

Getting the same error.

[ImportBot]

Originally Posted by leibhold*:

 

[09:55:13] Info: Start tablebuilder

[09:55:13] Error in Tablebuilder:

[09:55:13] Index #0

[09:55:13] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.47]Can't create table 'Mydb.tbl_server_player' (errno: 150)

[09:55:13] Native: 1005

[09:55:13] Source: myodbc5.dll

[09:55:13] SQL: HY000

Might be my sql setup - but its the same one that worked with the old database.

Something to do with the dreaded FOREIGN KEY (`PlayerID` ) ?

[ImportBot]

Originally Posted by FARSTAN*:

 

Hello XpKiller

 

I managed to install the plugin, because I used the same version as BFBC2, some time ago.

 

when I go to my sql database, I see

 

tbl_chatlog

tbl_dogtags

tbl_mapstats

tbl_playerdata

tbl_playerstats

tbl_server

tbl_server_player

 

for example, tbl_playerdata, I see the name of my player, (PBGUID EAGUID MY IP & MY COUNTRY (FR)) or tbl_mapstats, maps, what happens when I change the map of Procon

 

I see that the sql is in good relationship with Procon.

But I do not see any message in BF3 before BFBC2 on, I saw my server stat when I came on the server

 

These are my module setting

 

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Host" "XX.XX.XX.245"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Port" "3306"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Database Name" "XXXXX_stats32"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "UserName" "XXXXX_stats32"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Password" "XXXXXXXX"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable Chatlogging_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Log ServerSPAM_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Instant Logging of Chat Messages_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable Statslogging_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Update EA GUID_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Update PB-GUID (NOT recommended!!!)_" "No"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Ranking by Score_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Send Stats to all Players_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "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 "CChatGUIDStatsLoggerBF3" "Awards ON_" "No"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable Welcomestats_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Yell Welcome Message(not the stats)_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Welcome Message" "Nice to see you on our Server again, %playerName%"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Welcome Message for new Player" "Welcome to the %serverName% Server, %playerName%"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Welcomestats Delay" "60"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Top10 ingame" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "DebugLevel" "Error"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Keywordlist" ""

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "tableSuffix" ""

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "MapStats ON_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Session ON_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "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 "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"

can you communicate your settings as you thought, they are the best, I would copy, paste in my CFG file

Thank you very much for this plugin

[ImportBot]

Originally Posted by XpKiller*:

 

I spotted bug like servername column is too short. Also I will review my foreign keys . Atm I'm on the way to work . I will release afixed version when I'm back at home.

[ImportBot]

Originally Posted by sfwombat*:

 

I spotted bug like servername column is too short. Also I will review my foreign keys . Atm I'm on the way to work . I will release afixed version when I'm back at home.

I found the foreign key error only happened if I used a table prefix. Looked at your code and the SQL statement for that table doesn't appear to allow for the prefix, so couldn't find the other tables. I knocked up a quick function to create the table in VB ( Im not a C programmer) adding my prefix and it worked perfectly. Hope that helps...

 

I did notice I cannot turn off the weapon stats as I could with the BC2 one. Is this by design?

 

Also, is it a lot of work to give the option to change the 'tbl_' in the table name? I have the tables created in a forum DB, and the only tables that get backed up are the ones that start with 'phpbb3_'. Be great if I could add this via the interface, rather than change it all in the code itself....I know I am being lazy....lol...

[ImportBot]

Originally Posted by leibhold*:

 

I found the foreign key error only happened if I used a table prefix. Looked at your code and the SQL statement for that table doesn't appear to allow for the prefix, so couldn't find the other tables. I knocked up a quick function to create the table in VB ( Im not a C programmer) adding my prefix and it worked perfectly. Hope that helps...

Damn you the only thing I didnt try !!!

 

Thanks for that

 

I think the lack of prefix is by design - trying to get player data not to be server specifc. For us that run several servers - easier to ban etc with one table for the players.

 

 

Thanks to xpkiller - lotsa work going on with this.

[ImportBot]

Originally Posted by FARSTAN*:

 

google translator translates badly, you add (tbl_) a line tableSiffix

[ImportBot]

Originally Posted by sfwombat*:

 

I have found another problem because of the prefix, I think:

 

[10:28:04 90] Error: Error in Startstreaming:

[10:28:04 90] Index #0

[10:28:04 90] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.5.15]Unknown column 'PBGUID' in 'field list'

 

Is the prefix really needed now? Would it be worth going through and just renaming the tables to include BF3 on the end? I need a quick way to identify the tables in the database, hence the use of a prefix, but if the name included the game name, it wouldn't be a problem....

 

 

Looking at the code, it is loads of work.....thanks xpkiller....

[ImportBot]

Originally Posted by sfwombat*:

 

google translator translates badly, you add (tbl_) a line tableSiffix

Do not add anything in the prefix field, and it should create the tables okay.

[ImportBot]

Originally Posted by sfwombat*:

 

Damn you the only thing I didnt try !!!

 

Thanks for that

 

Thanks to xpkiller - lotsa work going on with this.

LOL....you're welcome.

[ImportBot]

Originally Posted by FARSTAN*:

 

Do not add anything in the prefix field, and it should create the tables okay.

Yes, I am born not join in this box, I get to see the names of players, maps, in sql,

but rine appears in BF3 in the chat box no stat, and you ?

[ImportBot]

Originally Posted by FARSTAN*:

 

can you give me the url of your server battlelog ?

[ImportBot]

Originally Posted by sfwombat*:

 

I meant suffix, not prefix....my bad....

 

 

Did you enable the chat logging? Silly question, I know....

[ImportBot]

Originally Posted by PBSGTS*:

 

Am I the only one that isn't getting any data for, tbl_dogtags, tbl_mapstats, tbl_playerdata, tbl_playerstats, tbl_server_player?

 

tbl_chatlog and tbl_server work fine. I have everything that would be obvious turned on.

 

Chatlogging: Yes

Log ServerSPAM: Yes

Instant Logging of Chat Messages: Yes

Flood Protection: 10

Mapstats: Yes

Session: (Yes)/No doesn't seem to matter

 

Statslogging: Yes

Weponstats: Yes

Update EA GUID: Yes

Update PB-GUID: No

Ranking by score: Yes

Send Stats to all players: No

Top10 ingame: Yes

 

Offset: 0

 

Periodical Webrequest on: Yes

 

Enable Welcomestats: No

Yell Welcome Message: No

Welcomestats Delay: 60

 

-----------------------------------------------------------------------------------

 

Could this be why?

 

[06:57:16 99] Trace: Mapstats Write querys

[06:57:17 02] Error: Error in Startstreaming:

[06:57:17 02] Index #0

[06:57:17 02] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.6.3-m6]Field 'ServerID' doesn't have a default value

[06:57:17 02] Native: 1364

[06:57:17 02] Source: myodbc5.dll

[06:57:17 03] SQL: HY000

[06:57:17 03] Info: Connection OdbcCon closed

[06:57:17 03] Info: Connection OdbcConn closed

[ImportBot]

Originally Posted by FARSTAN*:

 

not personally, for all tables in MySQL is completed

 

I see the names of players, map, chat log, layerstats, the only thing that I do not see is the stats in the game

 

http://www.hostingpics.net/viewer.php_id=453389chat.png

http://www.hostingpics.net/viewer.php_id=357472maps.png

http://www.hostingpics.net/viewer.ph...playerdata.png

[ImportBot]

Originally Posted by FARSTAN*:

 

not personally, for all tables in MySQL is completed

I see the names of players, map, chat log, layerstats, the only thing that I do not see is the stats in the game

 

http://www.hostingpics.net/viewer.php_id=656668chat.png

http://www.hostingpics.net/viewer.php_id=553329maps.png

http://www.hostingpics.net/viewer.ph...playerdata.png

[ImportBot]

Originally Posted by FARSTAN*:

 

Did you enable the chat logging? Silly question, I know....

yes

 

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable Chatlogging_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Log ServerSPAM_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Instant Logging of Chat Messages_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Enable Statslogging_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Update EA GUID_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Update PB-GUID (NOT recommended!!!)_" "No"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Ranking by Score_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Send Stats to all Players_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "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 "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" "Nice to see you on our Server again, %playerName%"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Welcome Message for new Player" "Welcome to the %serverName% Server, %playerName%"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Welcomestats Delay" "60"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Top10 ingame" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "DebugLevel" "Error"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Keywordlist" ""

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "tableSuffix" ""

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "MapStats ON_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Session ON_" "Yes"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "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 "CChatGUIDStatsLoggerBF3" "Playerrequests per Round" "32"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Servertime Offset" "0"

procon.protected.plugins.setVariable "CChatGUIDStatsLoggerBF3" "Periodical Webrequest On_(P&S Stats)" "No"

as all the sql table fills, except dogtag, necessarily, there is still no knife on the server

 

http://battlelog.battlefield.com/bf3...C-Stat-Player/

[ImportBot]

Originally Posted by sourtimer*:

 

Can anyone recommend a good mysql service to use to host the database ?

 

Free would be good, or cheap.

[ImportBot]

Originally Posted by FARSTAN*:

 

Can anyone recommend a good mysql service to use to host the database ?

 

Free would be good, or cheap.

https://www.mega-hosting.fr/clients-area/cart.php_gid=5

[ImportBot]

Originally Posted by FARSTAN*:

 

Can anyone recommend a good mysql service to use to host the database ?

 

Free would be good, or cheap.

https://www.mega-hosting.fr/clients-area/cart.php_gid=5

[ImportBot]

Originally Posted by 0mni*:

 

Have been waiting for this

 

I have it running on my Windows 2008 Server R2 w/ MySQL 5.5 and the OBDC Driver 5.1.9

 

I know its beta, buy just wanted to ask, is the Welcome stats implimented ?

[ImportBot]

Originally Posted by FARSTAN*:

 

Hello,

I want to knew if it is normal that the plugin does not give any message in the chatbox of BF3?

and if it is normal that in the table tbl_playerstats, I do not see (Kills Deaths Headshots Suicide TKS)

http://www.hostingpics.net/viewer.ph...6xxxxxxxxx.png

[ImportBot]

Originally Posted by FARSTAN*:

 

Hello,

I want to knew if it is normal that the plugin does not give any message in the chatbox of BF3?

and if it is normal that in the table tbl_playerstats, I do not see (Kills Deaths Headshots Suicide TKS)

http://www.hostingpics.net/viewer.ph...6xxxxxxxxx.png

[ImportBot]

Originally Posted by sfwombat*:

 

I have had this running on three servers today. I am getting no deaths, kills etc recorded, although it is recording score, first seen, last seen and time spent on each server.