Jump to content

[sql][5827] Spell_chain Typo

Guest CyberDragon

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?


Is there a thread in the bug report section? If yes, please add a link to the thread.


Who has been writing this patch? Please include either forum user names or email addresses.


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 @@
@@ -11647,7 +11647,7 @@

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

  • 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