From 57cfc4bbc09287ddb51922ce6a38ff886209367e Mon Sep 17 00:00:00 2001 From: Wyrserth Date: Sun, 7 Jul 2019 14:21:42 +0200 Subject: DB/Creature: prevent floating Gjalerbron Prisoners from falling to the ground. Also fix mistake in DELETE query for previously committed SQL file. (cherry picked from commit d18b7572f40360d6f47d48faa306665b008e7dd8) --- .../world/master/2021_12_14_06_world_2019_07_07_00_world.sql | 2 +- .../world/master/2021_12_14_07_world_2019_07_07_02_world.sql | 8 ++++++++ 2 files changed, 9 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/master/2021_12_14_07_world_2019_07_07_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_12_14_06_world_2019_07_07_00_world.sql b/sql/updates/world/master/2021_12_14_06_world_2019_07_07_00_world.sql index 205d47ddef6..65d7aecdd45 100644 --- a/sql/updates/world/master/2021_12_14_06_world_2019_07_07_00_world.sql +++ b/sql/updates/world/master/2021_12_14_06_world_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/master/2021_12_14_07_world_2019_07_07_02_world.sql b/sql/updates/world/master/2021_12_14_07_world_2019_07_07_02_world.sql new file mode 100644 index 00000000000..72c8e7d2343 --- /dev/null +++ b/sql/updates/world/master/2021_12_14_07_world_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); -- cgit v1.2.3