Kaworru wrote:the problem there is when you delete the logfile and only parse them to the database you can only used simple statistic for that.
The idea is that a properly normalized database wouldn't have this problem. This would keep a better history and allow more application integration.
Because in the parse data you dont see, which player has killed with player how often and so you can only make a statistic about simple thing like general kills and deaths and so on.
Note sure if I'm understanding you here.
You can parse the following
- Code: Select all
:gameinfo:end
:join:<ID>:player:<nickname>
:join:<ID>:bot:<nickname>
:part:<ID>
:team:<ID>:<team>
:kill:frag:<ID of killer>:<ID of victim>:type=<death type>:items=<itemstring of killer>:victimitems=<itemstring of victim>
:kill:tk:<ID of killer>:<ID of victim>:type=<death type>:items=<itemstring of killer>:victimitems=<itemstring of victim>
:kill:suicide:<ID>:<ID>:type=<death type>:items=<itemstring>
:kill:accident:<ID>:<ID>:type=<death type>:items=<itemstring>
:ctf:steal:<flagcolor>:<ID of attacker>
:ctf:dropped:<flagcolor>:<ID of dropper>
:ctf:pickup:<flagcolor>:<ID of attacker>
:ctf:capture:<flagcolor>:<ID of attacker>
:ctf:return:<flagcolor>:<ID of defender>
:ctf:returned:<flagcolor>
:dom:taken:<previouscolor>:<ID of player>
:scores:<gametype>_<mapname>:<map runtime>
:player:<frags>:<deaths>:<playtime>:<team>:<ID>:<nickname>
:restart
:end
:gameover
eventlog.txt
But you can't make a relation ship between events without copy the data 1:1 to the database.
Again this sounds like a database that hasn't been normalized.