Average Level?
Total exp / total players
Put that in your level array or whatever.
:)
suggestions
|
|
Administrator |
I can't compute this very easily, believe it or not. Your level isn't actually stored in the database, only the amount of experience you have. |
|
Don't you have a function getting peoples levels? |
|
What about... |
|
This won't work, and this is why: |
|
SELECT AVG("SELECT get_level(exp) as `lvl` FROM `user`") as `finallvl` FROM `users`"); |
Administrator |
I suppose I could implement get_level() as a MySQL UDF, but this would be pretty low priority. I'm mostly focusing on bug fixes and major features at the moment. |
|
I'm not expecting it today or nothing endy poo. :) |
|
How about something like "Most online"? |
|
To much work says Ender. |