Page 1 of 1

HIstogram

Posted: Wed Jan 21, 2015 8:22 pm
by shippou
Hello!

I want to make a histogram graph for mys server or anyone who is interested.
But I dont know how to get the online data.

I mean how to create script wich is store the online player data and fetch it automatically, to use as the graph.

Somthing like this.
Image

Thx,
Fowardly

Re: HIstogram

Posted: Wed Jan 21, 2015 11:06 pm
by UnAfraid
What data other then player count you need.
You can use mysql query to get the count like: SELECT COUNT(*) FROM characters WHERE online > 0;

Re: HIstogram

Posted: Thu Jan 22, 2015 9:28 pm
by shippou
Hallo I have the data stored in mysql db.

Once created a simple php script wich is select the needed data from the gs and upload it to the graph s sql.

The graph sql table data is somthing like this

All_Online|Trader|DATE|Hour

('37' '23' '2015/01/22' '14:22');
('43' '23' '2015/01/22' '14:23');