Forged Alliance Forever Forged Alliance Forever Forums 2020-06-06T12:19:00+02:00 /feed.php?f=2&t=19367 2020-06-06T12:19:00+02:00 2020-06-06T12:19:00+02:00 /viewtopic.php?t=19367&p=184684#p184684 <![CDATA[Re: FAF Stats from the database]]> viewtopic.php?f=2&t=13449&start=120
so we keep all the stats in one place.

Statistics: Posted by keyser — 06 Jun 2020, 12:19

]]> 2020-06-06T08:58:16+02:00 2020-06-06T08:58:16+02:00 /viewtopic.php?t=19367&p=184679#p184679 <![CDATA[FAF Stats from the database]]> 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/8A8KdSm

Cumulative time we have been in game: 436 years. This does NOT count the time three times if there were three players in the game.
Spoiler: show
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
Spoiler: show
SELECT count(1) FROM faf.game_stats;


Number of maps in vault: 7,988
Spoiler: show
select count(1) from faf.map;


Number of accounts: 244,854
Spoiler: show
SELECT count(1) FROM faf.login;


Number of ladder games in April: 13,193
Spoiler: show
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
Spoiler: show
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
Image
Spoiler: show
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
Image
Spoiler: show
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

Statistics: Posted by nine2 — 06 Jun 2020, 08:58

]]>