[8394] Fixes for some non-self only positive spells. Author: VladimirMangos

    * Propertly reject self targeting for pet spell 2947 and ranks, and spell 54646.
    * Some related fixes for pet spells with target mode TARGET_SINGLE_FRIEND_2
    * Implement original caster bonus part of spell 54646.

--HG--
branch : trunk

1 files changed, 5 insertions, 0 deletions

diff --git a/sql/updates/for review/8394_01_mangos_spell_proc_event.sql b/sql/updates/for review/8394_01_mangos_spell_proc_event.sql
new file mode 100644
index 00000000000..73afa3da5e1
--- /dev/null
+++ b/sql/updates/for review/8394_01_mangos_spell_proc_event.sql
@@ -0,0 +1,5 @@
+ALTER TABLE db_version CHANGE COLUMN required_8392_02_mangos_spell_chain required_8394_01_mangos_spell_proc_event bit;
+
+DELETE FROM `spell_proc_event` WHERE `entry` IN (54646); 
+INSERT INTO `spell_proc_event` VALUES 
+(54646, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x00015400, 0x00000002, 0.000000, 0.000000, 0);