From 25f81cdfcdfe42aafd9589f3c6f447141a321a2e Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Thu, 13 Aug 2009 13:40:30 -0500
Subject: *Fix some typos in spell_area which make some spells are not
 available to female char.

--HG--
branch : trunk
---
 sql/FULL/world_spell_full.sql         | 2 +-
 sql/updates/4982_world_spell_area.sql | 1 +
 2 files changed, 2 insertions(+), 1 deletion(-)
 create mode 100644 sql/updates/4982_world_spell_area.sql

(limited to 'sql')

diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index 3092b59382e..d27a36b1c8f 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -1994,7 +1994,7 @@ INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `t
 -- death charger
 DELETE FROM spell_area WHERE spell = 52693;
 INSERT INTO spell_area (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES
-(52693, 4298, 12687, 1, 12687, 0, 0, 0, 1);
+(52693, 4298, 12687, 1, 12687, 0, 0, 2, 1);
 
 DELETE FROM `npc_spellclick_spells` WHERE `spell_id` IN (
 54568, 54575, 52263, 52280, 52447);
diff --git a/sql/updates/4982_world_spell_area.sql b/sql/updates/4982_world_spell_area.sql
new file mode 100644
index 00000000000..5f7f79a5022
--- /dev/null
+++ b/sql/updates/4982_world_spell_area.sql
@@ -0,0 +1 @@
+update spell_area set gender=2 where spell in (33836,50426,46023,52693);
\ No newline at end of file
-- 
cgit v1.2.3