diff options
| author | Killyana <morphone1@gmail.com> | 2019-03-17 16:49:15 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2019-03-17 16:49:15 +0100 |
| commit | ebe56ce802a8c2dc33f9c9d8f69ddd813a6169a0 (patch) | |
| tree | de8055b03041c578eb0d54ec24e8f05dd77831b7 | |
| parent | 4d3ee3f4249d137b4fc77863e5f8a991e82478db (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
| -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`; |