Jump to content
Sign in to follow this  
ImportBot

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

Recommended Posts

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:

* Restored post. It could be that the author is no longer active.

Share this post


Link to post

Originally Posted by i3lack*:

 

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


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

Originally Posted by Clay52*:

 

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


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

Originally Posted by fue*:

 

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

 

:smile:


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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)


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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?


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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.

* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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` ) ?


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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.


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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...:smile:

 

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...:smile:


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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...:smile:

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.


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

Originally Posted by FARSTAN*:

 

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


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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....:smile:

 

 

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


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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.

* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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.

* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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 ?


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

Originally Posted by FARSTAN*:

 

can you give me the url of your server battlelog ?


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

Originally Posted by sfwombat*:

 

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

 

 

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


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

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/


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

Originally Posted by sourtimer*:

 

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

 

Free would be good, or cheap.


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

Originally Posted by 0mni*:

 

Have been waiting for this :biggrin:

 

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 ?


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

Originally Posted by meatball88*:

 

Hmm for me the plugin wont track kills and some other stats but it tracks score. kills deaths not working yet or am i doing somthing wrong ?


* Restored post. It could be that the author is no longer active.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
  • Our picks

    • I wanted I let you know that I am starting to build out the foundation for the hosting services that I talked about here. The pricing model I was originally going for wasn't going to be suitable for how I want to build it. So instead I decided to offer each service as it's own product instead of a package deal. In the future, hopefully, I will be able to do this and offer discounts to those that choose it.

      Here is how the pricing is laid out for each service as well as information about each. This is as of 7/12/2020.

      Single MySQL database (up to 30 GB) is $10 USD per month.



      If you go over the 30 GB usage for the database then each additional gigabyte is charged at $0.10 USD each billing cycle. If you're under 30GB you don't need to worry about this.


      Databases are replicated across 3 zones (regions) for redundancy. One (1) on the east coast of the USA, One (1) in Frankfurt, and One (1) in Singapore. Depending on the demand, this would grow to more regions.


      Databases will also be backed up daily and retained for 7 days.




      Procon Layer will be $2 USD per month.


      Each layer will only allow one (1) game server connection. The reason behind this is for performance.


      Each layer will also come with all available plugins installed by default. This is to help facilitate faster deployments and get you up and running quickly.


      Each layer will automatically restart if Procon crashes. 


      Each layer will also automatically restart daily at midnight to make sure it stays in tip-top shape.


      Custom plugins can be installed by submitting a support ticket.




      Battlefield Admin Control Panel (BFACP) will be $5 USD per month


      As I am still working on building version 3 of the software, I will be installing the last version I did. Once I complete version 3 it will automatically be upgraded for you.





      All these services will be managed by me so you don't have to worry about the technical side of things to get up and going.

      If you would like to see how much it would cost for the services, I made a calculator that you can use. It can be found here https://ezrcon.com/calculator.html

       
      • 10 replies
    • I have pushed out a new minor release which updates the geodata pull (flags in the playerlisting). This should be way more accurate now. As always, please let me know if any problems show up.

       
      • 6 replies
×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.