DB/SAI: Misc Fixes

1) Prevent Quetz'lun Worshipper and Serpent-Touched Berserker from becoming unkillable if player on Foundation for Revenge agros but does not kill it
2) Add some missing effects for Leading the Ancestors Home
3) Supplies to the Crossroads and The Disruption ends should be able to be taken together
4) The Spirits of Stonetalon is optional breadcrumb and Goblin Invaders should be takable without it
5) Fix a lot of other breadcrumb quests as appears did not previously push to tc or cant find commit

(cherry picked from commit 4bc5a5be32bc79277e6e86a1a7e7084cc5e780c8)

1 files changed, 79 insertions, 0 deletions

diff --git a/sql/updates/world/master/2018_03_17_18_world_2016_12_26_06_world.sql b/sql/updates/world/master/2018_03_17_18_world_2016_12_26_06_world.sql
new file mode 100644
index 00000000000..7ad43549c84
--- /dev/null
+++ b/sql/updates/world/master/2018_03_17_18_world_2016_12_26_06_world.sql
@@ -0,0 +1,79 @@
+DELETE FROM `smart_scripts` WHERE `entryorguid`=28747 AND `source_type`=0 AND `id`=8;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=28748 AND `source_type`=0 AND `id`=7;
+
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(28747, 0, 8, 0, 7, 0, 100, 512, 0, 0, 0, 0, 42, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Quetz\'lun Worshipper - On Evade - Turn Invincibility off'),
+(28748, 0, 7, 0, 7, 0, 100, 512, 0, 0, 0, 0, 42, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Serpent-Touched Berserker - On Evade - Turn Invincibility off');
+
+UPDATE `smart_scripts` SET `link`=1,`event_flags`=513 WHERE  `entryorguid`IN(25397,25398,25399) AND `source_type`=0 AND `id`=0 AND `link`=0;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`IN(25397,25398,25399) AND `source_type`=0 AND `id`>0;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(25397, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 11, 33345, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Elder Kesuk - On Spellhit \'Complete Ancestor Ritual\' - Cast Yellow Banish State '),
+(25397, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 3, 0, 28320, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Elder Kesuk - On Spellhit \'Complete Ancestor Ritual\' - Change Modelid '),
+(25397, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 18, 0, 'Elder Kesuk - On Spellhit \'Complete Ancestor Ritual\' - Change Modelid '),
+(25397, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Elder Kesuk - On Spellhit \'Complete Ancestor Ritual\' - Change Modelid '),
+(25398, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 11, 33345, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Elder Sagani - On Spellhit \'Complete Ancestor Ritual\' - Cast Yellow Banish State '),
+(25398, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 3, 0, 28320, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Elder Sagani - On Spellhit \'Complete Ancestor Ritual\' - Change Modelid '),
+(25398, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 18, 0, 'Elder Sagani - On Spellhit \'Complete Ancestor Ritual\' - Change Modelid '),
+(25398, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Elder Sagani - On Spellhit \'Complete Ancestor Ritual\' - Change Modelid '),
+(25399, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 11, 33345, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Elder Takret - On Spellhit \'Complete Ancestor Ritual\' - Cast Yellow Banish State '),
+(25399, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 3, 0, 28320, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Elder Takret - On Spellhit \'Complete Ancestor Ritual\' - Change Modelid '),
+(25399, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 18, 0, 'Elder Takret - On Spellhit \'Complete Ancestor Ritual\' - Change Modelid '),
+(25399, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Elder Takret - On Spellhit \'Complete Ancestor Ritual\' - Change Modelid ');
+
+UPDATE `creature` SET `spawntimesecs`=30 WHERE  `id`IN(25397,25398,25399);
+UPDATE `creature_template` SET `InhabitType`=4 WHERE  `entry` IN(25397,25398,25399);
+
+UPDATE `quest_template_addon` SET `PrevQuestID`=871 WHERE  `ID`=872;
+
+SET @BreadCrumb   := 1061;  -- The Spirits of Stonetalon
+SET @FirstQuest   := 1062;  -- Goblin Invaders
+
+UPDATE `quest_template_addon` SET `PrevQuestID` =0 WHERE `ID`=@FirstQuest;
+UPDATE `quest_template_addon` SET `NextQuestID` =0 WHERE `ID`=@BreadCrumb;
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry`=@BreadCrumb AND `ConditionTypeOrReference`=14 AND `ConditionValue1`=@FirstQuest;
+
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(19, 0, @BreadCrumb, 0, 0, 14, 0, @FirstQuest, 0, 0, 0, 0, 0, '', 'Optional BreadCrumb Quest'),
+(20, 0, @BreadCrumb, 0, 0, 14, 0, @FirstQuest, 0, 0, 0, 0, 0, '', 'Optional BreadCrumb Quest');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry`IN(12451,12161,12425);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(19, 0, 12451, 0, 0, 14, 0, 12195, 0, 0, 0, 0, 0, '', 'Onward to Camp Oneqwah is optional BreadCrumb Quest'),
+(20, 0, 12451, 0, 0, 14, 0, 12195, 0, 0, 0, 0, 0, '', 'Onward to Camp Oneqwah is optional BreadCrumb Quest'),
+(19, 0, 12161, 0, 0, 14, 0, 12328, 0, 0, 0, 0, 0, '', 'Ruuna the Blind is optional BreadCrumb Quest'),
+(20, 0, 12161, 0, 0, 14, 0, 12328, 0, 0, 0, 0, 0, '', 'Ruuna the Blind is optional BreadCrumb Quest'),
+(19, 0, 12425, 0, 0, 14, 0, 12328, 0, 0, 0, 0, 0, '', 'Ruuna the Blind is optional BreadCrumb Quest'),
+(20, 0, 12425, 0, 0, 14, 0, 12328, 0, 0, 0, 0, 0, '', 'Ruuna the Blind is optional BreadCrumb Quest');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry`IN(11175,11406,12182,12189,11573,11995,12469,12542,11996,12511,12208,12210);
+
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(19, 0, 11175, 0, 0, 14, 0, 11176, 0, 0, 0, 0, 0, '', 'My Daughter is optional BreadCrumb Quest'),
+(20, 0, 11175, 0, 0, 14, 0, 11176, 0, 0, 0, 0, 0, '', 'My Daughter is optional BreadCrumb Quest'),
+(19, 0, 11406, 0, 0, 14, 0, 11269, 0, 0, 0, 0, 0, '', 'Everything Must Be Ready is optional BreadCrumb Quest'),
+(20, 0, 11406, 0, 0, 14, 0, 11269, 0, 0, 0, 0, 0, '', 'Everything Must Be Ready is optional BreadCrumb Quest'),
+(19, 0, 12182, 0, 0, 14, 0, 12188, 0, 0, 0, 0, 0, '', 'To Venomspite! is optional BreadCrumb Quest'),
+(20, 0, 12182, 0, 0, 14, 0, 12188, 0, 0, 0, 0, 0, '', 'To Venomspite! is optional BreadCrumb Quest'),
+(19, 0, 12189, 0, 0, 14, 0, 12188, 0, 0, 0, 0, 0, '', 'Imbeciles Abound! is optional BreadCrumb Quest'),
+(20, 0, 12189, 0, 0, 14, 0, 12188, 0, 0, 0, 0, 0, '', 'Imbeciles Abound! is optional BreadCrumb Quest'),
+(19, 0, 11573, 0, 0, 14, 0, 11504, 0, 0, 0, 0, 0, '', 'Orfus of Kamagua is optional BreadCrumb Quest'),
+(20, 0, 11573, 0, 0, 14, 0, 11504, 0, 0, 0, 0, 0, '', 'Orfus of Kamagua is optional BreadCrumb Quest'),
+(19, 0, 11995, 0, 0, 14, 0, 12000, 0, 0, 0, 0, 0, '', 'Your Presence is Required at Stars'' Rest is optional BreadCrumb Quest'),
+(20, 0, 11995, 0, 0, 14, 0, 12000, 0, 0, 0, 0, 0, '', 'Your Presence is Required at Stars'' Rest is optional BreadCrumb Quest'),
+(19, 0, 12469, 0, 0, 14, 0, 12044, 0, 0, 0, 0, 0, '', 'Return to Sender is optional BreadCrumb Quest'),
+(20, 0, 12469, 0, 0, 14, 0, 12044, 0, 0, 0, 0, 0, '', 'Return to Sender is optional BreadCrumb Quest'),
+(19, 0, 12542, 0, 0, 14, 0, 12545, 0, 0, 0, 0, 0, '', 'The Call Of The Crusade is optional BreadCrumb Quest'),
+(20, 0, 12542, 0, 0, 14, 0, 12545, 0, 0, 0, 0, 0, '', 'The Call Of The Crusade is optional BreadCrumb Quest'),
+(19, 0, 11996, 0, 0, 14, 0, 11999, 0, 0, 0, 0, 0, '', 'Your Presence is Required at Agmar''s Hammer is optional BreadCrumb Quest'),
+(20, 0, 11996, 0, 0, 14, 0, 11999, 0, 0, 0, 0, 0, '', 'Your Presence is Required at Agmar''s Hammer is optional BreadCrumb Quest'),
+(19, 0, 12511, 0, 0, 14, 0, 12292, 0, 0, 0, 0, 0, '', 'The Hills Have Us is optional BreadCrumb Quest'),
+(20, 0, 12511, 0, 0, 14, 0, 12292, 0, 0, 0, 0, 0, '', 'The Hills Have Us is optional BreadCrumb Quest'),
+(19, 0, 12208, 0, 0, 14, 0, 11984, 0, 0, 0, 0, 0, '', 'Good Troll Hunting is optional BreadCrumb Quest'),
+(20, 0, 12208, 0, 0, 14, 0, 11984, 0, 0, 0, 0, 0, '', 'Good Troll Hunting is optional BreadCrumb Quest'),
+(19, 0, 12210, 0, 0, 14, 0, 11984, 0, 0, 0, 0, 0, '', 'Troll Season! is optional BreadCrumb Quest'),
+(20, 0, 12210, 0, 0, 14, 0, 11984, 0, 0, 0, 0, 0, '', 'Troll Season! is optional BreadCrumb Quest');
+
+