DB/Spell: Add missing visual spell in Gortok Palehoof encounter

Cosmetic channeling spell casted by the red Orb to wake up the npcs

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/world/2015_09_02_01_world.sql b/sql/updates/world/2015_09_02_01_world.sql
new file mode 100644
index 00000000000..1b58aed1abc
--- /dev/null
+++ b/sql/updates/world/2015_09_02_01_world.sql
@@ -0,0 +1,7 @@
+--
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=47669;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `Comment`) VALUES
+(13, 1, 47669, 0, 1, 0, 48048, 0,0, "Awaken Subboss");
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 48048;
+INSERT INTO `spell_linked_spell` VALUES (48048, 47669, 0, 'Awaken Subboss');