diff options
| author | Wyrserth <wyrserth@protonmail.com> | 2019-07-07 14:21:42 +0200 |
|---|---|---|
| committer | Wyrserth <wyrserth@protonmail.com> | 2019-07-07 14:21:42 +0200 |
| commit | d18b7572f40360d6f47d48faa306665b008e7dd8 (patch) | |
| tree | bf7d3af516e0640538ca0ff612afad295d9240d5 | |
| parent | 283ac3d374c4158b098dcc3b06f0514588c068b7 (diff) | |
DB/Creature: prevent floating Gjalerbron Prisoners from falling to the ground.
Also fix mistake in DELETE query for previously committed SQL file.
| -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); |