What bug does the patch fix? What features does the patch add?
Fixing typo in `spell_chain` table. Replacing "Melt Ore" (5159) spell with the correct "Entangling Roots (Rank 3)" (5195) spell.
For which SubVersion revision was the patch created?
5747
Is there a thread in the bug report section? If yes, please add a link to the thread.
no
Who has been writing this patch? Please include either forum user names or email addresses.
CyberDragon
UPDATE `spell_chain` SET `spell_id`='5195' WHERE `spell_id`='5159';
UPDATE `spell_chain` SET `prev_spell`='5195' WHERE `prev_spell`='5159';
Index: sql/mangos.sql
===================================================================
--- sql/mangos.sql (revision 5747)
+++ sql/mangos.sql (working copy)
@@ -11635,7 +11635,7 @@
(5143,0,5143,1),
(5144,5143,5143,2),
(5145,5144,5143,3),
-(5159,1062,339,3),
+(5195,1062,339,3),
(5171,0,5171,1),
(5176,0,5176,1),
(5177,5176,5176,2),
@@ -11647,7 +11647,7 @@
(5187,5186,5185,3),
(5188,5187,5185,4),
(5189,5188,5185,5),
-(5196,5159,339,4),
+(5196,5195,339,4),
(5201,3029,1082,3),
(5211,0,5211,1),
(5215,0,5215,1),
This should fix the characters who already learned that bad spell:
DELETE FROM `character_spell` WHERE `spell`='5159';