ImportBot Posted November 16, 2011 Share Posted November 16, 2011 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 Originally Posted by i3lack*: Can't wait to see the download. Thanks bud!! Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 Originally Posted by Clay52*: The yell command still isn't functional is it? Thanks so much for this update! Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 Originally Posted by fue*: Will you be able to watch it like a statspage like psycostats etc? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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) Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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` ) ? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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 fileThank you very much for this plugin Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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... Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 Originally Posted by FARSTAN*: google translator translates badly, you add (tbl_) a line tableSiffix Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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.... Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 Originally Posted by sfwombat*: google translator translates badly, you add (tbl_) a line tableSiffixDo not add anything in the prefix field, and it should create the tables okay. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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 ? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 Originally Posted by FARSTAN*: can you give me the url of your server battlelog ? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 Originally Posted by sfwombat*: I meant suffix, not prefix....my bad.... Did you enable the chat logging? Silly question, I know.... Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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/ Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 Originally Posted by sourtimer*: Can anyone recommend a good mysql service to use to host the database ? Free would be good, or cheap. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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 ? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 16, 2011 Author Share Posted November 16, 2011 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 Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted November 17, 2011 Author Share Posted November 17, 2011 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. Quote * Restored post. It could be that the author is no longer active. Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.