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!

Voting is now open for the Dynamic Control Point Contest! Voting ends on the 23rd, so make sure you join us on the servers to play the entries, and cast your vote before then.

Click here to head to the voting thread!

TF2 Map Stats Database

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

  1. Bloodhound

    Bloodhound L6: Sharp Member

    Messages:
    316
    Positive Ratings:
    236
    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!
     
    • Thanks Thanks x 16
    Last edited: Oct 14, 2012
  2. Freyja

    aa Freyja Creating visual gameplay since 2007

    Messages:
    2,340
    Positive Ratings:
    3,166
    This plugin is cool. We should run it on the TF2M server.
     
    • Thanks Thanks x 2
  3. grazr

    aa grazr Old Man Mutant Ninja Turtle

    Messages:
    5,427
    Positive Ratings:
    3,492
    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).
     
    • Thanks Thanks x 2
    Last edited: Apr 14, 2012
  4. henke37

    henke37 L14: Epic Member

    Messages:
    1,322
    Positive Ratings:
    248
    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.
     
    • Thanks Thanks x 2
  5. Terwonick

    Terwonick L6: Sharp Member

    Messages:
    278
    Positive Ratings:
    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 Old Man Mutant Ninja Turtle

    Messages:
    5,427
    Positive Ratings:
    3,492
    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:
    316
    Positive Ratings:
    236
    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 L6: Sharp Member

    Messages:
    349
    Positive Ratings:
    105
    I'll put this on test when i get back from work for some servers.

    Oh btw, it's Dario Casali, not casili.
     
    • Thanks Thanks x 1
    Last edited: Apr 18, 2012
  9. Bloodhound

    Bloodhound L6: Sharp Member

    Messages:
    316
    Positive Ratings:
    236
    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,
     
    • Thanks Thanks x 2
    Last edited: Oct 12, 2012