For the first version of this perhaps we should just keep it simple.
Quote:General statistics
Bullets fired
Bullets hit
Kill assists
For each weapon:
Bullets fired
Bullets hit
Kill assists
Detecting the number of bullets fired per weapon isn't as easy as it sounds. We'd have to constantly monitor the number of ammo remaining using GetPlayerAmmo when OnPlayerWeaponShot is called. The problem here however is that GetPlayerAmmo IIRC isn't always 100% accurate. I suggest we leave this one out for now and I'll do some asking around and look into this again later.
So just a table that allows us to store this data will be sufficient for now:
Quote:Kill registration
Killer
Victim
Weapon used
Fatal bodypart
Coordinates
Date and time
Is lame kill
However I suggest we rename weapon used to reasonId to conform with this:
http://wiki.sa-mp.com/wiki/Weapons
Eg for things like running a player over etc.
EDIT: With regards to kill assists - are we allowing an unlimited number of people to be involved with a kill or only 1 person?
With 1 person for example: the person who assists the most gets the stat. If this is the case an extra field can be added to the above list for the profile ID of the person who gets the assist.
If not, we'd have to create a new table to list all the killers who assisted per death.