Gun Raiders is a VR FPS game. This repository contains scripts to analyze a 24-hour dump of game kills logs and the results.
DB used is MariaDB. Script is python.
- create_db.sql creates the MariaDB database
- load_data.sql loads data from the CSV files
- add_weapon_killed_id.py computes the weapon_killed_id, an estimation of which weapon the player was likely using when killed (based on previous or next kill)
- querys.md lists SQL queries and related results