[7644] Fixed pet slot values using in pet save. Author: VladimirMangos

    Problem exist from client version switch when stable slot amount changed.
    In result this has been source problems with stable use (3-4 slots) and possible pet lost in some cases
    or "not save state" for summoned pets.
    Use enums to avoid repeating problem, use more safe value for not-in-slot save (for summoned pets)
    Fixed data preparing for MSG_LIST_STABLED_PETS.

--HG--
branch : trunk

1 files changed, 5 insertions, 0 deletions

diff --git a/sql/updates/7644_01_characters_character_pet.sql b/sql/updates/7644_01_characters_character_pet.sql
new file mode 100644
index 00000000000..03e38a0d8eb
--- /dev/null
+++ b/sql/updates/7644_01_characters_character_pet.sql
@@ -0,0 +1,5 @@
+ALTER TABLE character_db_version CHANGE COLUMN required_7546_01_characters_uptime required_7644_01_characters_character_pet bit;
+
+/* only hunter pets must be in stable */
+UPDATE `character_pet`
+  SET slot = 100 WHERE PetType <> 1 AND slot >= 1 AND slot <= 4;