[DiscordArchive] What do u mean by listing ?
[DiscordArchive] What do u mean by listing ?
Archived author: Shard • Posted: 2019-12-05T08:12:57.911000+00:00
Original source
What do u mean by listing ?
Archived author: Deleted User • Posted: 2019-12-05T08:15:00.205000+00:00
Original source
List the mounts by faction, and list the mounts that the player already knows.
Then I would more simply make an nested query between characters_spell -> characters -> account
To get the guid and then the account_id but I found that it was too much data processing, while there I only store the spells that are filtered through my listing of all mount.
Archived author: Shard • Posted: 2019-12-05T08:33:32.021000+00:00
Original source
But everything is already listed
Spells -> Spell.dbc (serverside)
Player spells -> character_spell
characters -> characters