Post here doubts, ideas, suggestions and support requests about the website and the forums.
-
shippou
- Posts: 74
- Joined: Thu Jun 25, 2009 9:27 pm
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.
Thx,
Fowardly
-
UnAfraid
- L2j Veteran
![L2j Veteran L2j Veteran](./images/ranks/veteran.png)
- Posts: 4199
- Joined: Mon Jul 23, 2007 4:25 pm
- Location: Bulgaria
-
Contact:
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;
-
shippou
- Posts: 74
- Joined: Thu Jun 25, 2009 9:27 pm
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');