diff options
| author | Killyana <morphone1@gmail.com> | 2019-03-17 16:49:15 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-11-24 22:24:14 +0100 |
| commit | 1c5f281a56ab48f14c125771e958c3ac673a0e4c (patch) | |
| tree | e8a1ba25135ae52687f191a5589a1a0cff80e06a | |
| parent | 052304cf2dbba1ebab5f0cdd49288fe656cf873a (diff) | |
DB/Movement: Synchronize difficulty entry with the main template
We don't know any case where a creature has a different movement from a difficulty to an another
(cherry picked from commit ebe56ce802a8c2dc33f9c9d8f69ddd813a6169a0)
(cherry picked from commit c76931c2c095f09b587038ac1ebd1a4fea96dbcf)
| -rw-r--r-- | sql/updates/world/master/2021_11_24_37_world_2019_03_17_01_world.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_24_37_world_2019_03_17_01_world.sql b/sql/updates/world/master/2021_11_24_37_world_2019_03_17_01_world.sql new file mode 100644 index 00000000000..3b993c9886c --- /dev/null +++ b/sql/updates/world/master/2021_11_24_37_world_2019_03_17_01_world.sql @@ -0,0 +1,18 @@ +-- +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (14026,14029,14028,14027,14030,14031,27339,32926); +INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`) VALUES +(14026, 0, 0, 1, 0), +(14029, 0, 0, 1, 0), +(14028, 0, 0, 1, 0), +(14027, 0, 0, 1, 0), +(14030, 0, 0, 1, 0), +(14031, 0, 0, 1, 0), +(27339, 0, 0, 1, 0), +(32926, 1, 1, 0, 1); + +DELETE `ctm` FROM `creature_template_movement` `ctm` INNER JOIN `creature_template` `ct` ON `ctm`.`CreatureId` = `ct`.`difficulty_entry_1`; +DELETE `ctm` FROM `creature_template_movement` `ctm` INNER JOIN `creature_template` `ct` ON `ctm`.`CreatureId` = `ct`.`difficulty_entry_2`; +DELETE `ctm` FROM `creature_template_movement` `ctm` INNER JOIN `creature_template` `ct` ON `ctm`.`CreatureId` = `ct`.`difficulty_entry_3`; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) SELECT `diff_entry`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random` FROM `creature_template_movement` `ctm` JOIN (SELECT `entry`, `difficulty_entry_1` AS `diff_entry` FROM `creature_template` WHERE `difficulty_entry_1` > 0) `ct` ON `ctm`.`CreatureId` = `ct`.`entry`; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) SELECT `diff_entry`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random` FROM `creature_template_movement` `ctm` JOIN (SELECT `entry`, `difficulty_entry_2` AS `diff_entry` FROM `creature_template` WHERE `difficulty_entry_2` > 0) `ct` ON `ctm`.`CreatureId` = `ct`.`entry`; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) SELECT `diff_entry`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random` FROM `creature_template_movement` `ctm` JOIN (SELECT `entry`, `difficulty_entry_3` AS `diff_entry` FROM `creature_template` WHERE `difficulty_entry_3` > 0) `ct` ON `ctm`.`CreatureId` = `ct`.`entry`; |