Milk13

Since we've the probem, we've disabled our firewall. I just enable it. The initial change made is And over there is floodmon : http://spamcleaner.org/en/misc/floodmon.html Maybe I must change one of :

Why not. But with database it's easier to use for mostly people and doesn't need to get datas from 2 differents way.

It's for people that don't know how to work crontab or are on windows. And less work than with a cron script ( depending of your cronscript ). If you do a select query each time on your full character table, it can slow down your database and decrease performance. With this patch, there is less useless query. But if you have a good cron script, it can be a solution too.

Example of graph, that we can get :

I just made some changes. http://github.com/MiLk/mangos/commit/6e869ec4970e049f2f63c035dfa83775847e614c

We can't use uptime table because, with the actual system, it update the row, and remove the last value. And insert a new row in uptime table at each time is stupid. It's not "live" data, it's to have a collection of values to make graphs or tables. For the url tag, I thought that's automatic, but in fact, no

The existing field is update each time and we can't have a historic to have graphs like this : http://www.milkshack.net/images/7-1286970935.png If your server doesn't restart for 2 days, you have one value for 2 days. With my system you've one value for each 5 minutes ( you can change the interval ). It doesn't look like a thing that could be still made.

What does this patch do ? It saves in DB the number of players ingame at a particulary time, each X minutes. Each save create a new row in Database. You can use this datas to make graphs. It use a new table in realmd DB. It was actually for mangos-0.12, but we can update it for master without difficulty. The first commit is here : http://github.com/MiLk/mangos/commit/74503f3df92f692f65f91b1ca2816f74016382e8 Branch here : http://github.com/MiLk/mangos/commits/online_players Thanks for your feedback.

Why don't you just make a webapp with soap wich can be use on all phones and computers ?

http://gist.github.com/598779 updated.

I begin the update here : http://gist.github.com/598779 I'll update the gist when I have more data. Thx you to have pointed missing data.

I work on the data for the database, but I don't plan to update the db before the next week end. I'll share my work soon.

What's new about this patch ?

Debian Lenny x64 mangos-0.12 http://pastebin.com/WH226Tqe

Debian Lenny x64 Mangos-0.12 [s0035] http://pastebin.com/gtwYQ2hx