[ Updated threads · New messages · Members · Forum rules · Search · RSS ]
  • Page 1 of 1
  • 1
Forum » [FHSW] Europe 0.611 Server: » Infos: » Some player stats (r)
Some player stats (r)
Endless_NamelessDate: Friday, 2015-11-06, 7:00 PM | Message # 1
General
Group: Admins
Messages: 1237
Awards: 38
Reputation: 19
Status: Offline
Hi,

lately I've tried to examine the statistics.csv which is automatically updated with a couple of game stats (kills, deaths, etc.) after each round. I've successfully imported it to MS Access and want to share some of the stats with you:

Disclaimer:
  • I think it only saves the stats of all players at the end of each round, so if someone leaves during a match these stats are lost. Not entirely sure though.
  • Stats are name-based, so you have seperate stats for each name and not one overall.

    Highest overall KDR (at least 100 games played)
  • 2,57|Pum!

    Highest KDR in a single game
  • 52:1|Optimus|Berlin Outskirts|Axis

    Most Kills in a single game
  • 65|[F|H]Achtungsnow|Berlin-Streets|Axis

    Most Deaths in a single game
  • 48|Shadow|Battle of Foy|Allied

    Most Games played
  • 1210|{IPT}wewak

    Interesting Map statistics with at least 10 players playing (Axis wins:Allied wins)
  • Bombing the Reich: 52:0 lol
  • El Alamein: 14:23
  • Foy: 2:18
  • Ilomantsi: 11:1
  • Prokhorovka: 24:13

    well balanced maps (there are more)
  • Guadalcanal 8:8
  • Arnhem 13:13
  • Karelia 7:8
  • Battle of Iwo Jima 7:7

    That's it for now, maybe I'll add some more or the top 5 for each category later. Maybe you have some ideas or do you want to know your personal stats?

    Edit: Stats (number of games played, kills, deaths, KDR) by all players combined in one excel sheet: https://docs.google.com/spreads....sharing

    My Youtube Channel
    aka eYe.ris
  •  
    mardukDate: Friday, 2015-11-06, 10:42 PM | Message # 2
    General
    Group: Admins
    Messages: 1681
    Awards: 45
    Reputation: 13
    Status: Offline
    Bombing the Reich: The last time when I suggested to mod the map because Axis always wins, players told me that this is not necessary. We should mod it to make it more interesting for Allies to play.

    This is a gaming community. People come here to relax. If you start an argument you will get kicked.

    Quid pro quo.

    Marduk aka Postduk
     
    XenanabDate: Friday, 2015-11-06, 10:59 PM | Message # 3
    Colonel
    Group: Silver Donator
    Messages: 465
    Awards: 19
    Reputation: 5
    Status: Offline
    Quote marduk ()
    Bombing the Reich: The last time when I suggested to mod the map because Axis always wins, players told me that this is not necessary. We should mod it to make it more interesting for Allies to play
    The question is: How to accomplish that?

    I would say that allied team suffers mostly because players get distracted by those useless DDs. The DDs have a hard time destroying the Prinz Eugen. At the same time there is this stupid German sub while also there is the Schnellboot. Why not get rid off all ships except Prinz Eugen and British carrier? If Germans want to sink it they can use the Blitz or some Stukas.
    At the same time the two planes which spawn on the carrier are completely useless. If the sub is gone there is no further Swordfish needed. Maybe replace that Wildcat with a reliable Spit and allies may have better chances.

    The pure amount of good interceptor axis planes is extremely big. But I would not recommend changing them since this is one of the only maps where they appear.
    Maybe increase respawn time of all Me262 variations and that BF109 K-6. Also make the Uhu spawn once so that axis have to use some of the other planes at that airfield ( Fockewulfs and BF109s ).
    Once the freakin' Flakturm gets destroyed it NEVER respawns... how about that?

    But that discussion fits better at the serverside modding thread ^^
     
    LampoDate: Friday, 2015-11-06, 11:35 PM | Message # 4
    Donator of 40€
    Group: Gold Donator
    Messages: 327
    Awards: 31
    Reputation: 12
    Status: Offline
    mmmmhhhh, best Tkiller lampo ???? punk

     
    Stefan1990Date: Saturday, 2015-11-07, 0:21 AM | Message # 5
    General
    Group: Admins
    Messages: 1428
    Awards: 10
    Reputation: 7
    Status: Offline
    try to set up a bfselect mqsl database!

    http://www.bf-games.net/downloads/502/select-bf-v0-5-beta.html
     
    Endless_NamelessDate: Saturday, 2015-11-07, 10:17 AM | Message # 6
    General
    Group: Admins
    Messages: 1237
    Awards: 38
    Reputation: 19
    Status: Offline
    Would be cool but I don't have any php or SQL knowledge and most importantly not the time to learn it.

    For Bombing my idea was to reduce the HP of the target (not possible ssm) or alter the materials used so it would take more damage from bombs (possible via ssm afaik).

    Updated OP with a link to a player stats excel sheet.

    Edit: @lampo teamkills are not tracked sadly but most negative score at the end of a round is -19 by PanzerKnacker on Op. Rattrap
    You finished with a negative score 12 times, highest was -4.


    My Youtube Channel
    aka eYe.ris
     
    PumiasekDate: Saturday, 2015-11-07, 12:01 PM | Message # 7
    Lieutenant
    Group: Trusted
    Messages: 54
    Awards: 3
    Reputation: 2
    Status: Offline
  • Highest overall KDR (at least 100 games played)

  • 2,57|Pum!
    sniper shy
  •  
    RADIOSMERSHDate: Saturday, 2015-11-07, 12:20 PM | Message # 8
    FHSW Wikia Co-Admin
    Group: Bronze Donator
    Messages: 664
    Awards: 27
    Reputation: 13
    Status: Offline
    Quote Endless_Nameless ()
    Updated OP with a link to a player stats excel sheet.

    Could you please upload the statistics.csv too? I would like to setup and test stats tracker on local server and I need some data for it to analyze.
     
    wewakDate: Saturday, 2015-11-07, 1:16 PM | Message # 9
    Lieutenant Colonel
    Group: Friends
    Messages: 151
    Awards: 3
    Reputation: 1
    Status: Offline
    Is it possible too see by weapon who has the most kills?
     
    Endless_NamelessDate: Saturday, 2015-11-07, 3:23 PM | Message # 10
    General
    Group: Admins
    Messages: 1237
    Awards: 38
    Reputation: 19
    Status: Offline
    @Radio: Check your PMs

    @wewak: Sadly not, only very basic stats are stored in that file.

    For each round played:
    date,time,server,map,gamemode,rounds,timelimit,axis_tickets,allied_tickets
    For each player in that round:
    player,team,score,kills,deaths,ping,ip,keyhash,pbguid


    My Youtube Channel
    aka eYe.ris
     
    RADIOSMERSHDate: Saturday, 2015-11-07, 3:38 PM | Message # 11
    FHSW Wikia Co-Admin
    Group: Bronze Donator
    Messages: 664
    Awards: 27
    Reputation: 13
    Status: Offline
    Quote Endless_Nameless ()
    @wewak: Sadly not, only very basic stats are stored in that file.

    Yeah, you need to parse server logs with the tool mentioned above to get information like this.
     
    LampoDate: Saturday, 2015-11-07, 5:17 PM | Message # 12
    Donator of 40€
    Group: Gold Donator
    Messages: 327
    Awards: 31
    Reputation: 12
    Status: Offline
    Quote Endless_Nameless ()
    Edit: @lampo teamkills are not tracked sadly but most negative score at the end of a round is -19 by PanzerKnacker on Op. RattrapYou finished with a negative score 12 times, highest was -4.


    even as rubbish player I'm not enough bad...  sadwalk

    tnx


     
    Robert_von_EberhahnDate: Saturday, 2015-11-07, 6:00 PM | Message # 13
    Lieutenant General
    Group: Silver Donator
    Messages: 969
    Awards: 19
    Reputation: 8
    Status: Offline
    come on Lampo 

    I´m a big fan of you   !!! Need realy more players with a fairplay mind like you, would increase fun on many maps specool You never make any bad actions or bugusing. Would allways turn my back on u in a battle without fear to get a knife in it biggrin


    Gameserver admin on our FHSW Europ server
     
    LampoDate: Saturday, 2015-11-07, 7:05 PM | Message # 14
    Donator of 40€
    Group: Gold Donator
    Messages: 327
    Awards: 31
    Reputation: 12
    Status: Offline
    tnx Robert  shy

    starting now I will do my best to improve my TK stats rolleyes ...




    Message edited by Lampo - Saturday, 2015-11-07, 7:06 PM
     
    XenanabDate: Saturday, 2015-11-07, 7:29 PM | Message # 15
    Colonel
    Group: Silver Donator
    Messages: 465
    Awards: 19
    Reputation: 5
    Status: Offline
    Damn, and I thought I had the most kills in a single game :(
    Last time on Road to Ramelle
     
    Robert_von_EberhahnDate: Saturday, 2017-01-07, 6:47 PM | Message # 16
    Lieutenant General
    Group: Silver Donator
    Messages: 969
    Awards: 19
    Reputation: 8
    Status: Offline
    what about to reset the stats with this beginning year 2017 ?!

    Gameserver admin on our FHSW Europ server
     
    LampoDate: Sunday, 2017-01-08, 1:27 AM | Message # 17
    Donator of 40€
    Group: Gold Donator
    Messages: 327
    Awards: 31
    Reputation: 12
    Status: Offline
    Quote Robert_von_Eberhahn ()
    what about to reset the stats with this beginning year 2017 ?!

    I think it's possible, but we can keep old stats too, so nothing will be deleted. Somthing like old FHSW, FHSW 0.6 and OLD + 0.6.


     
    Robert_von_EberhahnDate: Sunday, 2017-01-08, 4:01 PM | Message # 18
    Lieutenant General
    Group: Silver Donator
    Messages: 969
    Awards: 19
    Reputation: 8
    Status: Offline
    Yes that´s good idea, something like a "hall of fame" happy  Any admin please leave a comment.

    Gameserver admin on our FHSW Europ server
     
    Forum » [FHSW] Europe 0.611 Server: » Infos: » Some player stats (r)
    • Page 1 of 1
    • 1
    Search: