preister
commented
9 years ago Things To put into the DB to make them persistent:
- player position
- player bounty
- Dogs
- ...
Open preister opened 9 years ago
preister
commented
9 years ago Things To put into the DB to make them persistent:
This is just a collection issue for multiple bugs and enhancements related to the game DB.
The main issue with the current database is that there is no proper DB data structure to speak of, everything is cramped into unindexed tables with only a minimal amount of views and procedures to support everything.
One big first step would be to clean up the player table by splitting out inventory and vehicles (the player table itself should only include the most important information: Real Name, Player ID, admin/cop/medic level - essentially anything which is needed to actually load a player into the game, it should not include information which is required to load a player into the world).
After the initial step we have a structure which allows us to add new tables for specific functionality like dogs which are then just indexed against the player table rather than having to store player information in the dogs table.
PS. One last thought before I forget about it, the player ID would be a good index to identify datasets, its utterly unique for each player and has the additional benefit of connecting the virtual altis life data with a persistent arma/steam data set which will not change in the foreseeable future.