General
- We need to store the localization of the client, enGB shows as enUS but theres something that gets past that
- Items should be stored as the X:X:X:X link format
- Mobs should be stored as their name
Items
- Disenchants into store w/ the item id you disenchanted, and the items + amount it disenchanted into, simply storing a standard X:X:X:X item link is good.
- Need prices from the auction house per server per auction house, no idea on this one
Mobs
- Stored by monster name, which will then be translated and turned into an ID when its uploaded to us
- Level Min
- Level Max
- Position (Zone #, X/Y)
- Abilities used as well as rate (this is tricky, we never got it fully right on wowguru). These are also stored as the spell name
- Aggressive/Neutral/Friendly to X faction
- Loot as well as kill counts, the smaller this format is the better
NPCs Specific
- Sells items? A list of items they sell, and if the item is sold in infinity or not
- Quest start/end? If this npc starts or ends ends a quest, this is tricky allakhazam does it manually. We have to make a unique id out of the quests name/faction/level/etc basically.