Forged Alliance Forever

Re: Games database?

2013-02-27T16:41:40+02:00

Blackheart wrote:
That statistics combined with the fact that uef has an extremely low win rate on the ladder maps make the impression that uef is somewhat up. I mean, our explanation for the low UEF winrates was that all newbies play UEF, but if the percentage of newbs in the other factions is even higher, the conclusion is that uef is weak in 1v1?

yes

Statistics: Posted by ColonelSheppard — 27 Feb 2013, 16:41

Re: Games database?

2013-02-19T15:49:42+02:00

@blackheart: Maybe it indicates that UEF is u.p., maybe not, it's hard to say based on that alone, it probably depends on which map too. That's why I wanted to analyze it. By extending the TrueSkill model with map/faction info, you can determine on each map how many "bonus" rating each faction gives. So for example if you play on theta passage maybe aeon gives +10 boost and cybran gives -15. So if your rating is 1800 and playing aeon vs the other guy 1850 playing cybran, your effective rating is 1810 and his effective rating is 1835 so your true win chances are higher than what TrueSkill predicts. But if you play on badlands maybe it's the other way around (this is an example -- I'm just guessing). I think this would be interesting info to have.

Statistics: Posted by Cantor — 19 Feb 2013, 15:49

Re: Games database?

2013-02-19T15:39:29+02:00

Yes and no. It's not like UEF are only noob games and Aeon only pro games.
All is averaged, and I don't think that the noob/pro ratio per faction has any real influence in the win ratio. I'm actually rather certain the win ratio will be about the same for all factions with a "noob filter".

Statistics: Posted by Ze_PilOt — 19 Feb 2013, 15:39

Re: Games database?

2013-02-19T15:32:01+02:00

Yes, but the result of noob games has little to nothing to do with the faction, like in chess black or white doesnt matter until you reach a high level of play. So the win ratios of factions from players over a certain rating (what rating this is, i dunno) are probably more meaningful in terms of seeing balance problems.

Statistics: Posted by Blackheart — 19 Feb 2013, 15:32

Re: Games database?

2013-02-19T15:02:34+02:00

By the way, the premise of this thread are wrong.

There is no need to filter "noobs" from stats, are noob will fight noob, and pro will fight pro. So each stats is a game were players are on the same level of play. So the win ratio is a absolute value not depending of the rating.

Statistics: Posted by Ze_PilOt — 19 Feb 2013, 15:02

Re: Games database?

2013-02-19T15:02:07+02:00

the conclusion is that with the current map-pool it is just:
sera > uef

and i'm a really big UEF fan

Statistics: Posted by ColonelSheppard — 19 Feb 2013, 15:02

Re: Games database?

2013-02-19T14:56:31+02:00

That statistics combined with the fact that uef has an extremely low win rate on the ladder maps make the impression that uef is somewhat up. I mean, our explanation for the low UEF winrates was that all newbies play UEF, but if the percentage of newbs in the other factions is even higher, the conclusion is that uef is weak in 1v1?

Statistics: Posted by Blackheart — 19 Feb 2013, 14:56

Re: Games database?

2013-02-19T14:41:21+02:00

Interesting indeed! So sera is the noob faction, and UEF is the elite

From those numbers it seems that the DB isn't that large? Stats per game (map, player1, player2, player1faction, player2faction, winner) after zip compression would probably end up around 100 bytes. So all 1v1 games in total would end up on the order of 10 megabytes?

Statistics: Posted by Cantor — 19 Feb 2013, 14:41

Re: Games database?

2013-02-19T14:23:11+02:00

In 1v1, 34,535 games were played by UEF under 1200.
In total, 46,599 games were played by UEF.
That's 74% of 'noobs'.

In 1v1, 11,214 were played by Cybran under 1200.
In total 13,153 games were played by Cybran.
That's 85% of 'noobs'.

In 1v1, 25,690 were played by Aeon under 1200.
In total 31,870 games were played by Cybran.
That's 80% of 'noobs'.

In 1v1, 17,933 were played by Sera under 1200.
In total 19,891 games were played by Sera.
That's 90% of 'noobs'.

By 1200, I mean the 'mean'. the rating is mean-3*deviation, so it's people under around 1500 in the leaderboard.

So it's basically the opposite of what you were thinking

Statistics: Posted by Ze_PilOt — 19 Feb 2013, 14:23

Re: Games database?

2013-02-19T13:54:18+02:00

Thanks I can do that, if ze_pilot doesn't find it a problem to download a lot of replays. Is the file format of replay files described somewhere? The replay files look like:

{"num_players": 4, "game_end": 1361268894.751414, "uid": 650115, "title": "2v2 or more 2x", "game_type": 0, "teams": {"1": ["k3ntin"], "2": ["emperor_katax", "GloriousSucker"]}, "mapname": "scmp_008", "featured_mod": "faf", "complete": true}
ABC/33ja7D0HfBRF93N3aSQhCSEJIaEcvZMeEoGQZTc0CQQSFKTlQo4QSDOFJmBURFSUFnox9CIlFBUbBERFRUTlr9ijYv ... more stuff like this

this has some info I need in plain text, but one player is missing (probably the player who hosted the game), and not the factions and which team won. So maybe that information is in the "ABC/33ja7D0HfBRF93N3aSQh...", but what's the encoding used there?

Statistics: Posted by Cantor — 19 Feb 2013, 13:54

Re: Games database?

2013-02-19T13:36:16+02:00

if you want to make stats, keep this
viewtopic.php?f=41&t=2024
running for a day with the players you want to test (probably everything above 1800)
or create a small script that makes some autodownloads from here
http://faforever.com/faf/vault/replays_simple.php
shouldnt be a big deal

Statistics: Posted by ColonelSheppard — 19 Feb 2013, 13:36

Re: Games database?

2013-02-19T13:10:47+02:00

Run some analysis on it. For example which factions are good on which maps. Currently you can see win rate per map, but for example since many noob players choose UEF that's a bit skewed. How big is it? I don't need all data, just a big enough subset to be able to do some analysis (e.g. only data of last month).

Statistics: Posted by Cantor — 19 Feb 2013, 13:10

Re: Games database?

2013-02-19T13:01:14+02:00

No, there is no export of such database. It's too big. What do you want to achieve ?

Statistics: Posted by Ze_PilOt — 19 Feb 2013, 13:01

Re: Games database?

2013-02-19T13:00:36+02:00

Right, but is an export of that DB to a compute readable format available? Or some way to scrape that data myself?

Statistics: Posted by Cantor — 19 Feb 2013, 13:00

Re: Games database?

2013-02-19T12:23:42+02:00

Yes. In the replay tab.

Statistics: Posted by Ze_PilOt — 19 Feb 2013, 12:23