diff options
| author | Meji <alvaromegias_46@hotmail.com> | 2021-10-16 12:15:03 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-10-16 12:15:03 +0200 |
| commit | 11cc5c0d3bd46b5e68bb549625ef9ca7294deb21 (patch) | |
| tree | b36f19d80b39158bf4a0cadf38a9398beb08194a /sql/base | |
| parent | d07102a3dabcdde28f1bb2d504a338f705eb3141 (diff) | |
Core/BattlePets: Misc fixes (#27057)
* Rename WorldPackets::BattlePet::BattlePet::CollarID to WorldPackets::BattlePet::BattlePet::DisplayID
* Use the DisplayID field to store the model of the battle pet. If the species has BattlePetSpeciesFlags::RandomDisplay, nothing is stored. Otherwise a random model is chosen from those available
* Stored DisplayID in ITEM_MODIFIER_BATTLE_PET_DISPLAY_ID when caging the battle pet (previously the CreatureID was being stored)
* Modified SendPlaySpellVisual function to allow sending Target and TargetPosition at the same time
* Added SpellVisual when uncaging
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/auth_database.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 5ca1ccfac57..27a1bac8a77 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -265,6 +265,7 @@ CREATE TABLE `battle_pets` ( `battlenetAccountId` int(10) NOT NULL, `species` int(10) NOT NULL, `breed` smallint(5) NOT NULL, + `displayId` int(11) NOT NULL DEFAULT '0', `level` smallint(5) NOT NULL DEFAULT '1', `exp` smallint(5) NOT NULL DEFAULT '0', `health` int(10) NOT NULL DEFAULT '1', @@ -2458,7 +2459,8 @@ INSERT INTO `updates` VALUES ('2021_10_07_00_auth.sql','45F2D92E28382F0CBE1F9B3A97693C0CC69E50BC','ARCHIVED','2021-10-07 10:32:05',0), ('2021_10_13_00_auth.sql','220E63385CACCBCEC36C57717DE369F2FCABCAAF','ARCHIVED','2021-10-13 21:15:05',0), ('2021_10_15_00_auth.sql','C8AA212AB2BB2DB5B3C2C9622A3874475AEFBD7B','ARCHIVED','2021-10-15 10:11:47',0), -('2021_10_15_01_auth.sql','72A0437F0ADEC59FF9D6839DF845C473F693CA5B','RELEASED','2021-10-16 00:15:25',0); +('2021_10_15_01_auth.sql','72A0437F0ADEC59FF9D6839DF845C473F693CA5B','RELEASED','2021-10-16 00:15:25',0), +('2021_10_16_00_auth.sql','FDC45C7BEFBAFC9BCE6C77377B026A59AE52EE21','RELEASED','2021-10-16 11:24:39',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; |