Web Stats

[Scotty1207]

Firstly I'd like to say hi, anyway on to the topic, I was wondering how to get web stats for a Bliss private hive server like the ones you find on the DayZ mod homepage like, players alive, bandits alive, bandits killed etc...

Any help would be much appreciated!

 

[Dean]

This can be achieved with a few different MySQL queries. Try these:

Players alive

SELECT COUNT(`id`) AS 'total' FROM `survivor` WHERE `is_dead` = 0 AND `last_updated` > now() - INTERVAL 30 day; # Live players in last 30 days
 
OR
 
SELECT COUNT(`id`) AS 'total' FROM `survivor` WHERE `is_dead` = 0; # Live players of all time

Bandits alive

SELECT COUNT(`id`) AS 'total' FROM `survivor` WHERE `is_dead` = 0 AND `model` LIKE '%Bandit%'; # Total live bandits

Bandits killed

SELECT COUNT(`id`) AS 'total' FROM `survivor` WHERE `is_dead` = 1 AND `model` LIKE '%Bandit%'; # Total live bandits

These are really simple queries that you can probably make sense of and adjust to your liking. You can pull quite a lot of info from the database if you have a look around and figure out where to pull it from. Hope that helps.

 

[TheLaughingMan]

I personally use this: https://github.com/UnclearWall/BlissAdmin

If you look at index.php you can see the queries that run to get the data.

 

[Scotty1207]

Thanks for both the responses, its helped alot