[MySQL] Proper way to do player statistics?
#6

Here i have taken a picture of part of my Users table and my Weapons table. So what i am thinking is doing a similar thing with statistics, of a player as with weapons. Because i plan on having a lot of statistics, like time spent in a vehicle, boat, train, kills, wanted time, evade time etc.. The only issue that i can think of, aren't there going to be many rows? Or long loading times if i do it similar to the weapon system? Also for Achievements should i also have a different table if i plan to have a couple hundred of achievements?

Here's the Users table(for now):

Here's the weapons database, that i want to use the style of for statistics of each player.


What do you guys think? And i think id like to start putting like stamina, fight style and stuff like that into a new table.
Reply


Messages In This Thread
[MySQL] Proper way to do player statistics? - by Type-R - 09.02.2017, 05:02
Re: [MySQL] Proper way to do player statistics? - by saffierr - 09.02.2017, 06:52
Re: [MySQL] Proper way to do player statistics? - by AmigaBlizzard - 09.02.2017, 07:41
Re: [MySQL] Proper way to do player statistics? - by JesterlJoker - 09.02.2017, 07:45
Re: [MySQL] Proper way to do player statistics? - by Vince - 09.02.2017, 08:45
Re: [MySQL] Proper way to do player statistics? - by Type-R - 09.02.2017, 13:51
Re: [MySQL] Proper way to do player statistics? - by Astralis - 09.02.2017, 15:07
Re: [MySQL] Proper way to do player statistics? - by Type-R - 09.02.2017, 17:09

Forum Jump:


Users browsing this thread: 2 Guest(s)