db schema - Githubissues

Mirv commented 4 years ago

[x] create kill log
[ ] create an identity table to hold username / steam uid
[ ] create stats table to hold kill player_stats from scoreboard & join on steam uid?
[ ] create log parser count all kills of each type per steam uid
[ ] create script to insert or update on results to the player_stats table
[ ] create auxiliary engineer log
[ ] create a cross connect table of kills/incidents using engineer log
[ ] create auxiliary assist log
[ ] create a cross connect table of kills/incidents using engineer log

Mirv commented 4 years ago

Create a kill log

Simple version

[x] killedUID // killed might not be a player so no UID required
[x] killedName // AI won't have UID - not sure should record, but might net interesting llama on llama tk info
[x] killedTeam // teams appears to be useless as most mods add their own factions into the team slots
[x] killerUID
[x] killerName
[x] killerTeam // teams appears to be useless as most custom missions add their own factions into the team slots
[x] killed_xPos // heat map idea
[x] killed_yPos
[x] killed_zPos
[x] killer_xPos
[x] killed_yPos
[x] killed_zPos
[x] killDistance
[x] weaponClass // fn_weaponNames might need to be where we credit players in vehicle too
[x] weaponName
[x] isVehicle
[ ] vehicleClass
[x] vehicleName
[x] gameTime // ingame time elapsed in seconds
[x] mysql added timestamp

Version 4 add:

Version 5 add:

Version 6 add:

Version 7 add:

Mirv commented 4 years ago

Combat engineer log

Via map marker system in any mission - we can detect anything created by engineers etc

Mirv commented 4 years ago

Auxiliary / assist credit log

[ ] log anyone who dragged / carried someone
[ ] Link to anyone's vehicle they rode in via another event list
[ ] Link to any medic who healed them since they spawned via another event list
[ ] Link to any engineering equipment they are near via map markers recorded into the Combat engineer log
[ ] log anyone vehicle transporting someone injured

Mirv / arma3projectmanagement