To decrease the size of the database due to the AAR playback an archive should be made which only contains aggregated data.
Description
Description
Event Timeline
Comment Actions
Get (player) kills and deaths:
Returns PlayerUID, UID of victim, UID of attacker, weapon used and distance.
SELECT
e.playerId as playerId,
JSON_UNQUOTE(JSON_EXTRACT(e.value, '$.victim.id')) as victim,
JSON_UNQUOTE(JSON_EXTRACT(e.value, '$.attacker.id')) as attacker,
JSON_UNQUOTE(JSON_EXTRACT(e.value, '$.attacker.weapon')) as weapon,
JSON_UNQUOTE(JSON_EXTRACT(e.value, '$.attacker.distance')) as distance
FROM
events as e
WHERE
(
e.replayId = 1 # change to Replay ID
AND
e.type = 'unit_killed'
)
ORDER BY e.added