Unfortunately for myself, but fortunately for the community, I am way better web developer than gamer, so I spent couple of hours making a tool which parses epoch kill board and
will be able to can make nice statistics from that.
The kill log has following info, if it was a PVP kill:
- server name
- victim name
- killer name
- weapon name
If it's not a PVP kill, it gives less, but still some valuable information:
- server name
- victim name
I have a script that loads and parses kill board, and stores all data in a MySQL table so we can fetch data and make some neat statistics, like these:
This is just the "front page". My idea is that you can click each server and see it's stats (most kills, most deaths, most used weapon, longest shot, last X kills on that server), each weapon and see it's stats (most used by user, most killed user by the weapon, longest shot, popularity on servers, last kills by that weapon) and each user name and see complete statistics for them (num. of kills, num. of pvp/non-pvp deaths, longest range shot, list of last X kills/deaths, etc...)
However, there are couple of problems with current setup:
1) I need to constantly load and parse the kill board, say I can set a script to run each minute. The problem is the kill board returns (up to) 100 latest deaths (both pvp and non-pvp). Sometimes the time span between first and last is couple of minutes, and in my tests I've seen literally 100 deaths (on all CCG servers) in a time span of like 5 seconds. This means some of the kills can be skipped by my script. Of course, I can set a script to run every 15 or 30 seconds, but that would be too much both for my server and CCG servers.
2) Currently ARMA (thus, DayZ too) allows multiple players to have same name. If they are on same server, it'll append " (number)" to the user name. My script can detect and strip off the number in the parenthesis, but it will still mix stats from distinct players with same name
3) I hope I won't get banned for (ab)using your bandwidth.
Or maybe the guys from CCG plan to give us some statistics? I guess with direct access to the database it'll be even easier for them to make something like this. I mean, they can detect user by it's guid and will not skip any kills.
p.s. Note that screenshot says 30 days - yet I'm importing data for less than 48 hours and not automatically, but I refresh the import script from time to time. It needs to collect data for at least 30 days to give valuable (monthly) stats.
p.s.2. Some neat stats in this early version. Is Lucas cheating or he's such a good sniper to get a kill from over 3.5 kilometers?
edit: It is live! Check it out at http://ccg-stats.tk
Edited by Avram, 27 March 2015 - 10:45 AM.