diff options
| author | Killyana <morphone1@gmail.com> | 2019-10-22 15:00:52 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-18 23:14:10 +0100 |
| commit | 8281c92dceeb11e6d7324b7d08dbad38516c153d (patch) | |
| tree | b06766f2598778cee980daba1f733a3d006dbb22 | |
| parent | 50c90728b2079070037608c28ba33a714582ffa8 (diff) | |
DB/Creature: Brann Bronzebeard & Brann's Flying Machine
Closes #22650
(cherry picked from commit e10cab89f7173844b08b1bd7b3f4b7317a749b41)
| -rw-r--r-- | sql/updates/world/master/2021_12_18_53_world_2019_10_22_00_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_18_53_world_2019_10_22_00_world.sql b/sql/updates/world/master/2021_12_18_53_world_2019_10_22_00_world.sql new file mode 100644 index 00000000000..12103b3be11 --- /dev/null +++ b/sql/updates/world/master/2021_12_18_53_world_2019_10_22_00_world.sql @@ -0,0 +1,9 @@ +-- +DELETE FROM `creature_template_addon` WHERE `entry` IN (30382,30383); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(30382, 0, 0, 0, 0, 0, '54500'), +(30383, 0, 0, 0, 0, 0, '54500'); + +DELETE FROM `spell_area` WHERE `spell`=56582 AND `area`=4431; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES +(56582, 4431, 12880, 12973, 0, 0, 2, 3, 74, 1); |