From 9baabd50b7ece449d5d869e55b8d02f985d8bff9 Mon Sep 17 00:00:00 2001 From: ariel- Date: Thu, 28 Dec 2017 12:14:31 -0300 Subject: DB/Spell: Restrict Karazhan book buffs to that raid Ref #16049 (cherry picked from commit fed9e87bb007c9c535f963b3d21430a214c54dba) --- .../world/master/2021_03_19_02_world_2017_12_28_01_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/master/2021_03_19_02_world_2017_12_28_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_03_19_02_world_2017_12_28_01_world.sql b/sql/updates/world/master/2021_03_19_02_world_2017_12_28_01_world.sql new file mode 100644 index 00000000000..535bc7f5f16 --- /dev/null +++ b/sql/updates/world/master/2021_03_19_02_world_2017_12_28_01_world.sql @@ -0,0 +1,6 @@ +DELETE FROM `spell_area` WHERE `spell` IN (30550, 30557, 30562, 30567); +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `raceMask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES +(30550, 3457, 0, 0, 0, 0, 2, 0, 64, 11), +(30557, 3457, 0, 0, 0, 0, 2, 0, 64, 11), +(30562, 3457, 0, 0, 0, 0, 2, 0, 64, 11), +(30567, 3457, 0, 0, 0, 0, 2, 0, 64, 11); -- cgit v1.2.3