HIstogram

Post here doubts, ideas, suggestions and support requests about the website and the forums.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
shippou
Posts: 74
Joined: Thu Jun 25, 2009 9:27 pm

HIstogram

Post 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
User avatar
UnAfraid
L2j Veteran
L2j Veteran
Posts: 4199
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

Re: HIstogram

Post 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;
Image
shippou
Posts: 74
Joined: Thu Jun 25, 2009 9:27 pm

Re: HIstogram

Post 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');
Post Reply