aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authormegamage <none@none>2009-08-13 13:40:30 -0500
committermegamage <none@none>2009-08-13 13:40:30 -0500
commit25f81cdfcdfe42aafd9589f3c6f447141a321a2e (patch)
treee7a88412bfa46830fbe8aaedbf121c645e41f6f6 /sql
parent9cff946d8d6e91eaa096e2b0702b788fa1c5327e (diff)
*Fix some typos in spell_area which make some spells are not available to female char.
--HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/FULL/world_spell_full.sql2
-rw-r--r--sql/updates/4982_world_spell_area.sql1
2 files changed, 2 insertions, 1 deletions
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