1. Hey Guest, welcome to the new forums. Be sure to check out this thread to get all the information you need on the cool new stuff!

TF2 Map Stats Database

Discussion in 'Mapping Questions & Discussion' started by Bloodhound, Apr 15, 2012.

  1. Bloodhound

    Bloodhound L6: Sharp Member

    Messages:
    310
    Thanks Received:
    226
    Hey, I want to introduce a website I´m working on since a few weeks.

    What is the "TF2 Map Stats Database"?
    It´s a database which stores advanced Map Stats.
    The stats are captured with a server plugin,
    all captured stats will be send to this database.
    This gives us mappers a easier access to balance related stats.

    At the moment the only supported gamemodes are:
    • CP Attack/Defend
    • Payload
    Support for every gamemode is planned.

    Features
    • Stop%
    • Win%
    • average time per segment
    • average cp contest per round
    • map info
    • map/server lists
    • stats for max/min player settings
    • heatmaps (planned)

    Help
    Currently the plugin and the webpage is in beta stadium.
    The plugin only runs on one server.
    You can help the service to grow, by telling server admins
    about this, and how awesome it would be if they could join.
    Steamgroup

    Another thing I could need, is an idea, which game variables could be used to present a statistic of cp5/koth/arena maps. And of course which other features you would like to see.

    SERVICE IS OFFLINE!
    Source code for plugin.

    Thanks to:
    • takkyu (Server for alpha tests)
    • PMAvers (Server for beta tests)
    • MangyCarface (Frontier Essay)
    • Krissel (Coding help)
    • Nextra (Coding help)

    Every sort of feedback is welcome!
     
    Last edited: Oct 14, 2012
    Bermuda Cake, Jeremy, Xeramon and 13 others thanked this.
  2. Freyja

    aa Freyja Unpronounceable map names since 2013

    Messages:
    2,186
    Thanks Received:
    2,908
    This plugin is cool. We should run it on the TF2M server.
     
    Terwonick and Bloodhound thanked this.
  3. grazr

    aa grazr Mmm, hhhyes. indubitably.

    Messages:
    5,126
    Thanks Received:
    3,464
    I've been discussing this project with BH for several weeks (at some pain i might add, due to a language barrier causing much confusion). As i understand it this plugin wont replace the feedback plugin as the FB plugin allows for a more personal interactive kind of stat tracking, but this plugin records more specific data/stats such as individual round and control point wins; and is less intrusive on our personal database (which is good for our admins).
     
    Last edited: Apr 15, 2012
    Bloodhound and Fr0Z3nR thanked this.
  4. henke37

    henke37 L13: Stunning Member

    Messages:
    1,144
    Thanks Received:
    216
    There is no reason not to let it record feedback too. This doesn't mean the existing feedback plugin should be replaced, just that this can be used in addition to it.

    As for a feature request, how about automatic sightline use recording? Just note down the position of the victim and the attacker and then do some fancy analysis and/or charting.
     
    Xeramon and Bloodhound thanked this.
  5. Terwonick

    Terwonick L6: Sharp Member

    Messages:
    259
    Thanks Received:
    84
    quick bug note I found on that page, when you set the "Min. Players" to the same number as the "Max Players" and click apply then it will reset the "Min. Players" field to the default value of 2 and the "Max Players" value to the default value of 24.
     
  6. grazr

    aa grazr Mmm, hhhyes. indubitably.

    Messages:
    5,126
    Thanks Received:
    3,464
    The feedback plugin utilises private/sensitive information in order to access our database and record the unique FB data. DrP (and MacNetron) trust Geit enough to give him access to our database(s) and run the feedback plugin. It's one of the many reasons the system isn't more widely available in other communities. It poses a potential security issue.

    As it is we have FB and we will have another stat tracker that's more precise (this one), there's no reason to complicate the matter by having them both perform identical tasks. But perhaps convergence is possible later down the road, we'll have to talk to Geit and FireSlash some more.

    This kind of information is recorded automatically by Source, although it's not usually displayed in any legible means. At the end of the day this can be observed in demo's or by heatmaps.
     
    Last edited: Apr 15, 2012
  7. Bloodhound

    Bloodhound L6: Sharp Member

    Messages:
    310
    Thanks Received:
    226
    That isn't a bug, it's just my approach to prevent the users to set min and max players to the same values. If you have another idea how to do this, let me hear.

    Right, the FB plugins needs the RCON password. I programmed my plugin that way, that you only have to insert it like a normal sourcemod plugin. This way admins don't have to trust me that much. :)

    Edit:
    I've edited the topic, plugin and source code are now available, so you can start giving the link to admins. :D
     
    Last edited: Apr 15, 2012
  8. ics

    ics L5: Dapper Member

    Messages:
    233
    Thanks Received:
    47
    I'll put this on test when i get back from work for some servers.

    Oh btw, it's Dario Casali, not casili.
     
    Last edited: Apr 18, 2012
    Bloodhound thanked this.
  9. Bloodhound

    Bloodhound L6: Sharp Member

    Messages:
    310
    Thanks Received:
    226
    I've just updated it. :D (After 2 months of not working on it)

    Changelog:
    Plugin:
    - Cleaned up some stuff
    - Bugfixes

    Website:
    - added average time per segment
    - added average cp contest per round

    SERVICE IS OFFLINE!
    Source code for plugin.

    It still only supports Payload and CP A/D maps, if anybody has ideas to other gamemodes, tell me please.

    Note: I had to delete all the old stats, since some formulas changed,
     
    Last edited: Oct 12, 2012
    Xeramon and MangyCarface thanked this.