diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_03_17_01_world.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_03_17_01_world.sql b/sql/updates/world/3.3.5/2019_03_17_01_world.sql new file mode 100644 index 00000000000..32cf7adee88 --- /dev/null +++ b/sql/updates/world/3.3.5/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`; |