I will post interesting things I find in the database. All results are outdated (current up to 3/05/2020?).
Any of these could be wrong because I don't know exactly what the data means, I have to guess a bit.
Join the promo discord if you want to help harvest data to work out how to grow FAF.
https://discord.gg/8A8KdSmCumulative time we have been in game: 436 years. This does NOT count the time three times if there were three players in the game.
SELECT
SUM(DurationSec) / 3.154e+7 TotalDurationYears # there are 3.154e+7 seconds in a year
from
(select
startTime,
endTime,
TIME_TO_SEC(TIMEDIFF(endtime, starttime)) DurationSec
from faf.game_stats
where TIMEDIFF(endtime, starttime) < '03:00:00' # ignore suspiciously big
and TIMEDIFF(endtime, starttime) > '00:08:00' # ignore suspiciously short
) qry;
Number of games played: 7,744,262
SELECT count(1) FROM faf.game_stats;
Number of maps in vault: 7,988
select count(1) from faf.map;
Number of accounts: 244,854
SELECT count(1) FROM faf.login;
Number of ladder games in April: 13,193
select
count(1)
from game_stats where
gameMod = 6 #ladder
and endtime > '2020-04-01' and endtime < '2020-05-01' #april
order by endTime desc
Number of unique ladder players in April: 1,843
select
count(DISTINCT p.playerId)
from game_stats g
inner join game_player_stats p on p.gameId = g.id
where
gameMod = 6 #ladder
and endtime > '2020-04-01' and endtime < '2020-05-01' #april
New players per Month since 2018
select
DATE_FORMAT (create_time, "%m %Y"),
count(1)
from login
where create_time > '2018-01-01'
group by DATE_FORMAT (create_time, "%m %Y")
New players per day since 2018
select
DATE_FORMAT (create_time, "%Y-%m-%d"),
count(1)
from login
where create_time > '2018-01-01'
group by DATE_FORMAT (create_time, "%Y-%m-%d")
order by DATE_FORMAT (create_time, "%Y-%m-%d") ASC
