[8416] Fixed problem with double cast form passives at loading. Author: VladimirMangos

    * Drop learning form passives at form psell learning, and cast it explictly from code in all cases.
    * Drop cast form passives at learning.
    * Note: talents that have dependent form time passives still work in original way: learned and casted at learn if need.
    * Drop hack for spell 24907 casting at form apply: it casted fines as result normal triggered effect in related form spell.

    Original patch provided by nos4r2zod.

--HG--
branch : trunk

1 files changed, 21 insertions, 0 deletions

diff --git a/sql/updates/5426_8416_world_spell_learn_spell.sql b/sql/updates/5426_8416_world_spell_learn_spell.sql
new file mode 100644
index 00000000000..4057fb65350
--- /dev/null
+++ b/sql/updates/5426_8416_world_spell_learn_spell.sql
@@ -0,0 +1,21 @@
+-- ALTER TABLE db_version CHANGE COLUMN required_8412_01_mangos_mangos_string required_8416_01_mangos_spell_learn_spell bit;
+
+/* All form passives */
+DELETE FROM spell_learn_spell WHERE SpellID in (
+1178,  /* Bear Form (Passive) */
+3025,  /* Cat Form (Passive) */
+5419,  /* Travel Form (Passive) */
+5420,  /* Tree of Life _passive_ */
+5421,  /* Aquatic Form (Passive) */
+7376,  /* Defensive Stance Passive */
+7381,  /* Berserker Stance Passive */
+9635,  /* Dire Bear Form (Passive) */
+21156, /* Battle Stance Passive */
+21178, /* Bear Form (Passive2) */
+24905, /* Moonkin Form (Passive) */
+34123, /* Tree of Life _pasive_ */
+33948, /* Flight Form (Passive) */
+34764, /* Flight Form (Passive) */
+40121, /* Swift Flight Form (Passive) */
+40122  /* Swift Flight Form (Passive) */
+);