Jump to content

[sql][5827] Spell_chain Typo


Guest CyberDragon
 Share

Recommended Posts

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';

Link to comment
Share on other sites

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use