diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_07_07_00_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/3.3.5/2019_07_07_02_world.sql | 8 |
2 files changed, 9 insertions, 1 deletions
diff --git a/sql/updates/world/3.3.5/2019_07_07_00_world.sql b/sql/updates/world/3.3.5/2019_07_07_00_world.sql index a8093b8f3b9..ad1672f6c31 100644 --- a/sql/updates/world/3.3.5/2019_07_07_00_world.sql +++ b/sql/updates/world/3.3.5/2019_07_07_00_world.sql @@ -1,5 +1,5 @@ -- -DELETE FROM `spell_script_names` WHERE `ScriptName`="spell_frostbomb"; +DELETE FROM `spell_script_names` WHERE `ScriptName`="spell_urom_frostbomb"; INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (51103, "spell_urom_frostbomb"); diff --git a/sql/updates/world/3.3.5/2019_07_07_02_world.sql b/sql/updates/world/3.3.5/2019_07_07_02_world.sql new file mode 100644 index 00000000000..72c8e7d2343 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_07_07_02_world.sql @@ -0,0 +1,8 @@ +-- +DELETE FROM `creature_movement_override` WHERE `SpawnId` IN (117664, 117670, 117671, 117672, 117677); +INSERT INTO `creature_movement_override` (`SpawnId`, `Ground`, `Swim`, `Flight`, `Rooted`) VALUES +(117664, 1, 0, 1, 0), +(117670, 1, 0, 1, 0), +(117671, 1, 0, 1, 0), +(117672, 1, 0, 1, 0), +(117677, 1, 0, 1, 0); |