We moved our repositories to BitBucket!

If you can't login or you can't register to the forums do not rise an issue, instead please write to support (at) l2jserver.com

Check our wiki!

Report server issues here

Forum has been updated to phpBB 3.2, let's see if this fixes some minor bugs we had.

Thank you for visiting http://www.l2jserver.com/

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: 67
Joined: Thu Jun 25, 2009 9:27 pm

HIstogram

Post by shippou » Wed Jan 21, 2015 8:22 pm

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: 4198
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

Re: HIstogram

Post by UnAfraid » Wed Jan 21, 2015 11:06 pm

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: 67
Joined: Thu Jun 25, 2009 9:27 pm

Re: HIstogram

Post by shippou » Thu Jan 22, 2015 9:28 pm

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