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.
Thx,
Fowardly
HIstogram
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
- UnAfraid
- L2j Veteran
- Posts: 4199
- Joined: Mon Jul 23, 2007 4:25 pm
- Location: Bulgaria
- Contact:
Re: HIstogram
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;
You can use mysql query to get the count like: SELECT COUNT(*) FROM characters WHERE online > 0;
-
- Posts: 74
- Joined: Thu Jun 25, 2009 9:27 pm
Re: HIstogram
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');
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');