Some of you are using my
status script in their signatures. But did you know that this script can not only show who is currently online, but also saves a log of who logged in or out when?
Every ten minutes, my script fetches the list of online characters from the server's www site, and, by how it changes, reconstructs who logged on or off since the last check. All of this is saved in a database. More precisely, in two tables: one holds the character names, and the other holds the individual reconstructed "sessions".
Here I will share the second table with you. It has four columns:
- id: A numerical id.
- character_id: Id of the character (each char has a unique id).
- start_time: when the character logged in
- end_time: when the character logged out
The character IDs are the same used in the names table
which I will not disclose. But anonymous statistics can be created out of this pretty well. Please note:
- Since I only update every ten minutes, start_time and end_time can be off by +/-10 minutes.
- All session that started before 2012 and ended after 2010 are included.
- There are a few mistakes in the logs due to server downtimes. I am sorry for that.
I'm too lazy to come up with statistics, feel free to make your own!
Here is the file:
download sessions2011.sql.zipTo be imported into a relational SQL database like MySQL and processed via script.
Have fun!
