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)

2 files changed, 9 insertions, 1 deletions

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);