If we define active players as having logged in and played in the last 7 days, we can find out exactly by running this query on the nwnx live database:javajutsu wrote:A fair question, zicada.zicada wrote:... it would be good to know how many active players Exodus has to offer.
According to what Rotku told me, ALFA has about 30-40 currently active players. Exodus has about 15 currently active players, about half of whom are also active at ALFA.
(As an aside: Yeah, we each have hundreds of people registered to our forums. Exodus had a list of over 600 before we lost our former web site and player database. But, arguably, what really matters is the active player population; and how much overlap there is.)
If the numbers above are anywhere near accurate, roughly 20% of ALFA and 50% of Exodus currently active players are already playing on each other's servers.
Hope this helps.
Cheers.
Code: Select all
SELECT COUNT(*) AS Total FROM `players` WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= LastLogin;
Just for fun i ran it on the last 60 days too, returning 96. This means we're not doing that bad a job on retention, keeping in mind this is June and July,- rather slow months for gaming.
Would be interesting to see what you get running the same queries, we can then also look at how many of those players are ALFA members as well, and figure out roughly how many new players we're talking about here. If you're right in 15, and half are ALFAns, we're talking 7-8 players basically.