Page 1 of 84 1231151 ... LastLast
Results 1 to 10 of 838
  1. #1

    Chat, GUID, Stats and Mapstats Logger[3.0.2.2] 01.02.

    COMPATIBLE TO BFBC2 Vietnam now

    Pls check if you table contains a unique key contain the columns SoldierName and GUID. after convert from 2.x to 3.x
    if not please do the steps shown in the Troubleshooting part --> "if you got duplicates" to keepthe data integrity

    If you not sure feel free to ask me.

    New SQL Migration Script inside of 3.0.0.7

    Tablehotfix in Downloadselection

    The Plugin(Version 3.0.2.2) also now available by the Packet management of PRoCon

    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 reqiues the use of a MySQL database with INNODB engine that allows remote connections.(MYSQL Version 5.1.x is required!!!)
    Also the ODBC 5.1 Driver (the latest is 5.1.7(24.08.2010)) is needed and can be found here http://dev.mysql.com/downloads/connector/odbc/5.1.html .

    READ THE CHANGELOG

    Installation:
    Extract CChatGUIDStatsLogger.cs 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

    Enable outgoing ODBC Connections, located in Tools -> Options -> Plugins
    Will throw a permissions error if not done

    Enter the correct details for your database connection in the plugin settings tab. You dont need to create tables, the plugin will do that.

    The Standard MySQL Port is 3306.


    Versions:
    1.52
    2.0.6.4
    3.0.2.2

    Changelog:
    3.0.2.2
    Fixed Bug that a player is not in the Database because he got kicked be the the cheaterprotection

    Improved BFBCS Statsfetch by packing multiply players in one query to bfbcs. The Plugin waits now until the minimum playercount is reached

    This optimization can be disabled by setting the the Request Packrate to 0.

    Recommend value is 2-3 or higher.



    3.0.2.1
    Small Errorfix thx to [EoT]Honk for report

    3.0.2.0
    Now able to pull Stats from BFBCS and able to warn/kick/ban Player with high kdr and high Score per Minute (Globalstats)
    The Stats of BFBCS will be stored in the DB to reduce stress on BFBCS api.
    The Updateinterval (in hours) for the BFBCS Stats is variable and configurable (pls dont choose to low values)
    The plugin fetches up to 32 Players in one query from BFBCS and is able to repair JSON Objects containing Error messages from BFBCS API.
    The plugin tries to get the stats onetime only at the moment.
    Some Improvements in Code
    Cheater and Statspadder Protection based on Globalstats of BFBCS with configurable Limits and minimum values.
    Chatlog can be turned off now
    Option for Update empty PB-Guids(not recommend)
    Added Servertimeoffset feature

    3.0.1.2 -->3.0.1.3
    Added missing Weapons thx to Sir_Duck, terwax for the report

    3.0.1.1 -->3.0.1.2
    Added missing Weapons thx to Hellokitty for the report
    Fixed Typo thx to HunterBfV

    3.0.1.0 -->3.0.1.1
    New Shared Mode -> BC2 and Vietnam in the same tables.

    Several Bugfixes

    Added Option to disable Weaponstatslogging on Request


    3.0.0.7 -->3.0.1.0
    Automatic detection of the Gamemod(BC2 / Vietnam)
    Added Support for BFBC2 Vietnam just select the right Gamemod in Pluginsettings or let it set by the Plugin automatically
    Tables of Vietnam are called (tbl_playerstats_bfv, tbl_weaponstats_bfv, tbl_chatlog_bfv, tbl_dogtags_bfv, tbl_mapstats_bfv) + your suffix
    BC2 and Vietnam share the same tbl_playerdata + you Suffix
    You will need a new Version of Webstats for Vietnam which i will provide later
    Serveral small fixes and improvements


    3.0.0.7
    Bugfixes
    New feature the plugin does make a selfcheck of the weaponstable add missingweapons to the tbl_weaponstats by itself.

    Troubleshooting

    Specact weapons missing
    Pls apply this to you table:

    For 2.x
    Code:
    ALTER TABLE `tbl_playerstats` ENGINE = MyISAM ;
    ALTER TABLE `tbl_playerstats` 
     ADD COLUMN `M16K_kills` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `M16_deaths` , 
     ADD COLUMN `M16K_hs` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `M16K_kills` , 
     ADD COLUMN `M16K_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `M16K_hs` , 
     ADD COLUMN `UMPK_kills` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `UMP_deaths` , 
     ADD COLUMN `UMPK_hs` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `UMPK_kills` , 
     ADD COLUMN `UMPK_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `UMPK_hs` , 
     ADD COLUMN `MG3K_kills` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `MG3_deaths` , 
     ADD COLUMN `MG3K_hs` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `MG3K_kills` , 
     ADD COLUMN `MG3K_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `MG3K_hs` , 
     ADD COLUMN `M95K_kills` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `M95_deaths` , 
     ADD COLUMN `M95K_hs` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `M95K_kills` , 
     ADD COLUMN `M95K_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0  AFTER `M95K_hs` , 
     ADD COLUMN `MP7_kills` INT(10) UNSIGNED NOT NULL DEFAULT 0 ,
     ADD COLUMN `MP7_hs` INT(10) UNSIGNED NOT NULL DEFAULT 0 ,
     ADD COLUMN `MP7_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0 ,
     ADD COLUMN `QLZ8_kills` INT(10) UNSIGNED NOT NULL DEFAULT 0 ,
     ADD COLUMN `QLZ8_hs` INT(10) UNSIGNED NOT NULL DEFAULT 0 ,
     ADD COLUMN `QLZ8_deaths` INT(10) UNSIGNED NOT NULL DEFAULT 0;
    ALTER TABLE `tbl_playerstats` ENGINE = InnoDB ;
    If you get an error that the the Mapname doesnt fit into the column:
    Code:
    ALTER TABLE `sql_db_name`.`tbl_mapstats` CHANGE COLUMN `MapName` `MapName` VARCHAR(32) NULL DEFAULT NULL  ;
    If you got strange Scores:
    Code:
    ALTER TABLE tbl_playerstats ENGINE = MyISAM ;
    ALTER TABLE tbl_playerstats CHANGE COLUMN `playerScore` `playerScore` INT(10) NOT NULL DEFAULT '0'  ;
    ALTER TABLE tbl_playerstats ENGINE = InnoDB ;
    If you got Duplicates:
    To repair the database delete the rows where the playerID = StatsID = WeaponstatsID and in tbl_dogtags KillerID and VictimID of all duplicates then create the new unique index

    A query to find duplicatestakes some time coz its a hard query)
    Code:
    SELECT * FROM tbl_playerdata 
    WHERE (SoldierName,Guid) IN (SELECT SoldierName,Guid
       FROM tbl_playerdata
       GROUP BY SoldierName,Guid
       HAVING COUNT(*)>1);

    For delete a index:
    Code:
    DROP INDEX indexname ON tbl_playerdata;
    to create the correct index:
    Code:
    CREATE UNIQUE KEY SoldierNameGuid ON tbl_playerdata (SoldierName, GUID);

    General Tips:
    Use this SQL Query to get a full Dataset for a Player:
    Code:
    SELECT a.* ,b.*, c.*
     FROM tbl_playerdata a
     INNER JOIN tbl_playerstats b ON a.PlayerID = b.StatsID
     INNER JOIN tbl_weaponstats c ON a.PlayerID = c.WeaponstatsID
     WHERE a.SoldierName LIKE "%XpKiller%";


    Download
    Webstats: viewtopic.php?f=18&t=911
    More Downloadlinks( SQL-Scripts):
    viewtopic.php?f=18&t=694&p=11322#p11322
    Attached Files Attached Files
    Last edited by XpKiller; 09-06-2012 at 14:08.


  2. #2

    Re: BfBC2 Chat GUID and Stats Logger[0.8]

    Thank you for releasing this plugin. I will try my best to provide useful feedback.

  3. #3

    Re: BfBC2 Chat GUID and Stats Logger[0.8]

    I'm sorry i packed the wrong file

    Update in first Post:

    Changelog:
    Repack


  4. #4
    Administrator
    Join Date
    Mar 2010
    Location
    Tasmania, Australia
    Posts
    3,491

    Re: BfBC2 Chat GUID and Stats Logger[0.8]

    I would combine all your SQL queries into a single one to reduce server load.. You're potentially having hundreds of queries per level load..

    Also if you build a player class, you can assign kills, deaths, tk's, score etc into a single object, rather than having to deal with multiple dictionaries, like what i've done with the chat, (see CLogger in your code), then you can have just the one update statement..

  5. #5

    Re: BfBC2 Chat GUID and Stats Logger[0.8]

    Thanks for request

    i have written class for it now.

    it will be in the next release.


  6. #6

    Re: BfBC2 Chat GUID and Stats Logger[0.8]

    When or how often does the plugin transfer stats to the MySQL database?

    Stats don't seem to be tracking accurately from round to round, but this might be because I don't understand what triggers database updates.

  7. #7

    Re: BfBC2 Chat GUID and Stats Logger[0.8]

    The stats should be written to the database on every levelload

    but i found the issue u mentioned will be fixed on next release


  8. #8

    Re: BfBC2 Chat GUID and Stats Logger[0.8]

    I made a smal real basic script to show the stuff from the Logger on your website.
    It is realy basic and dosent look good, maybe someone can use it to make a good looking one. :lol:
    I īm not a master in programing so use it @ your own risk and find a lot of bugs :roll: .

  9. #9

    Re: BfBC2 Chat GUID and Stats Logger[0.8]

    New version

    Update in first post


  10. #10

    Re: BfBC2 Chat GUID and Stats Logger[1.0]

    *bump*
    New version [1.0]

    Update in first post

    Pls report errors if you found any.

    Report feature requests as well


 

 

Similar Threads

  1. Replies: 283
    Last Post: 10-10-2014, 10:01
  2. Replies: 142
    Last Post: 09-02-2012, 08:54
  3. Replies: 94
    Last Post: 25-06-2011, 23:48
  4. Replies: 3
    Last Post: 07-12-2010, 01:24

Posting Permissions

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