aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorariel- <ariel-@users.noreply.github.com>2017-12-28 12:14:31 -0300
committerfunjoker <funjoker109@gmail.com>2021-04-15 05:53:27 +0200
commit9baabd50b7ece449d5d869e55b8d02f985d8bff9 (patch)
tree013593185730843bd7445e9d8f393ab8516a6f2d
parent523dab764b0b3ebe76f957115e976b36fb79987e (diff)
DB/Spell: Restrict Karazhan book buffs to that raid
Ref #16049 (cherry picked from commit fed9e87bb007c9c535f963b3d21430a214c54dba)
-rw-r--r--sql/updates/world/master/2021_03_19_02_world_2017_12_28_01_world.sql6
1 files changed, 6 insertions, 0 deletions
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);