Page 1 of 173 1231151101 ... LastLast
Results 1 to 10 of 1723
  1. #1

    Chat, GUID, Stats and Mapstats Logger[1.0.0.3]

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

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

    Pleases also read the changelog

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

    Supported Games:
    • Battlefield 4
    • Battlefield 3
    • Battlefield Bad Comany 2 + Vietnam
    • MOH
    • MOHW



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


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


    May Working:
    • Ingame Weaponstats


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



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

    Issues/Requests:
    --

    Fixed or Implemented:


    Current Version:
    Stable: 1.0.0.3


    Changelog:

    Code:
    1.0.0.3
    Many thanks to Tyger.
    Line 462 through 545: Added additional weapon keywords.
    Line 4367: Fixed error in query which caused !top10 weapons query to fail.
    Line 5489: Fixed null primary key problem which caused incompatibility with MySQL version 5.7.3 m13 and up.
    
    1.0.0.2
    Bugfixes for column errors.
    Bugfixes for the sessions streaming bug
    Weaponstats working again. 
    Bugfix for Identifier name is too long.
    
    1.0.0.1
    Bugfixes for value too long for column errors.
    Bugfixes for some other bugs
    Changed deprecated Tracemessages
    Added an error prefix in pluginlog 
    New feature: Tickets/teamscores are now tracked in tbl_teamscores 
    New feature: Simple Stats (collects playerdata only)
    New feature: Switch for disabling weaponstats 
    
    
    1.0.0.0
    First Release
    extended Keywordlist(BF3):

    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 Official Version 1.0.0.3:
    Attached Files Attached Files
    Last edited by ColColonCleaner; 07-10-2017 at 18:33. Reason: Updating 1.0.0.3 to official release.


  2. #2

    Useful SQL Queries

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

    Show all Weapons known by the plugin:
    Code:
    SELECT `tbl_games`.`Name`, tbl_weapons.* FROM tbl_weapons
    INNER JOIN tbl_games using (`GameID`);
    Show Weaponstats for a single Player for one Server:
    Code:
    SELECT 
    `tbl_playerdata`.`SoldierName`,
    `tbl_weapons`.`Fullname`,
    `tbl_weapons`.`Damagetype`,
    `tbl_weapons_stats`.`Kills`,
    `tbl_weapons_stats`.`Headshots`,
    `tbl_weapons_stats`.`Deaths`
    FROM `tbl_playerdata`
    INNER JOIN `tbl_server_player` ON `tbl_playerdata`.`PlayerID` = `tbl_server_player`.`PlayerID`
    INNER JOIN `tbl_weapons_stats` ON `tbl_server_player`.`StatsID` = `tbl_weapons_stats`.`StatsID`
    INNER JOIN `tbl_weapons` ON `tbl_weapons_stats`.`WeaponID` = `tbl_weapons`.`WeaponID`
    WHERE 
    `tbl_playerdata`.`SoldierName` ="XpKiller" AND `tbl_server_player`.`ServerID` = 1
    Last edited by XpKiller; 12-11-2013 at 21:28.


  3. #3

    FAQ and Troubleshotting

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


    Webstatspages:
    https://forum.myrcon.com/showthread....apstats-Logger
    Last edited by XpKiller; 13-12-2013 at 14:27.


  4. #4
    Yay, will test it =)) Thank you very much! Ok... I'll test it if the download is available
    Last edited by Narf!; 10-11-2013 at 19:40.

  5. #5
    Download added.

    It recommended to start with a new db.

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


  6. #6
    Is this compatible with AdKats then?

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


  8. #8
    Should be a total of 14 tables correct?

    EDIT: up and running on 2 of my 4 servers, looks good so far...
    Last edited by jking54; 10-11-2013 at 21:20.

  9. #9
    Member
    Join Date
    Jan 2013
    Location
    Bamberg -> Bavaria -> Germany
    Posts
    31
    Hello,

    i will get this error in my Plugin-Box:

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

  10. #10
    @toxicman2002
    seems to be a bug.

    @jking54
    Yep 14 tables.


 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •