DB/Quests: Updated quest_template data for 7.1.0 part 5

1 files changed, 79 insertions, 0 deletions

diff --git a/sql/updates/world/master/2016_11_16_00_world.sql b/sql/updates/world/master/2016_11_16_00_world.sql
new file mode 100644
index 00000000000..4ecc5a6b253
--- /dev/null
+++ b/sql/updates/world/master/2016_11_16_00_world.sql
@@ -0,0 +1,79 @@
+DELETE FROM `quest_template` WHERE `ID` IN (45278 /*-Unknown-*/, 45263 /*-Unknown-*/, 44845 /*-Unknown-*/, 44844 /*-Unknown-*/, 44843 /*-Unknown-*/, 44842 /*-Unknown-*/, 44834 /*-Unknown-*/, 44831 /*-Unknown-*/, 41916 /*-Unknown-*/, 41607 /*-Unknown-*/);
+INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestLevel`, `QuestPackageID`, `MinLevel`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoney`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardBonusMoney`, `RewardDisplaySpell1`, `RewardDisplaySpell2`, `RewardDisplaySpell3`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitTurnIn`, `RewardItem1`, `RewardItem2`, `RewardItem3`, `RewardItem4`, `RewardAmount1`, `RewardAmount2`, `RewardAmount3`, `RewardAmount4`, `ItemDrop1`, `ItemDrop2`, `ItemDrop3`, `ItemDrop4`, `ItemDropQuantity1`, `ItemDropQuantity2`, `ItemDropQuantity3`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemID2`, `RewardChoiceItemID3`, `RewardChoiceItemID4`, `RewardChoiceItemID5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity1`, `RewardChoiceItemQuantity2`, `RewardChoiceItemQuantity3`, `RewardChoiceItemQuantity4`, `RewardChoiceItemQuantity5`, `RewardChoiceItemQuantity6`, `RewardChoiceItemDisplayID1`, `RewardChoiceItemDisplayID2`, `RewardChoiceItemDisplayID3`, `RewardChoiceItemDisplayID4`, `RewardChoiceItemDisplayID5`, `RewardChoiceItemDisplayID6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionID2`, `RewardFactionID3`, `RewardFactionID4`, `RewardFactionID5`, `RewardFactionValue1`, `RewardFactionValue2`, `RewardFactionValue3`, `RewardFactionValue4`, `RewardFactionValue5`, `RewardFactionCapIn1`, `RewardFactionCapIn2`, `RewardFactionCapIn3`, `RewardFactionCapIn4`, `RewardFactionCapIn5`, `RewardFactionOverride1`, `RewardFactionOverride2`, `RewardFactionOverride3`, `RewardFactionOverride4`, `RewardFactionOverride5`, `RewardFactionFlags`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `QuestRewardID`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES
+(45278, 2, 110, 0, 110, 7637, 0, 0, 45263, 1, 1, 19400, 1, 1, 18350, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Insurrection: An Elven Problem', 'Meet with First Arcanist Thalyssra in Shal''Aran.', 'The Alliance and Horde have arrived in Suramar. First Arcanist Thalyssra needs your help in providing an introduction.$b$bMeet with Thalyssra in Shal''Aran.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22996), -- -Unknown-
+(45263, 2, 110, 0, 110, 7637, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 143597, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 143597, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Eating Before the Meeting', 'Feed the Fruit of the Arcan''dor to a Suramar Refugee in Shal''Aran.', 'Having Vanthir around has done much to lift the spirits of the people here. I dare say some have begun to relish their newfound freedom, even if they miss their beloved city.\n\nI will not rest until I can give it back to them.\n\nYou and I have an important meeting to attend. Before we go, let us distribute more of the arcan''dor''s fruit. \n\nI want people to know that although I must leave for now, I have not abandoned them.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22996), -- -Unknown-
+(44845, 2, 110, 0, 110, 7637, 1, 3, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 143498, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Break An Arm', 'Defeat the Arm of the Magistrix.', 'The insurgents you marshaled gave me some bad news, $n.$b$bThe arcanists loyal to Elisande have reactivated the Arm of the Magistrix. The most powerful construct ever attempted, it raged out of control and decimated an entire district before it was disabled. Truly they must be desperate to turn it against us.$b$bThe scouts have spotted it in the Crimson Thicket to the north. We cannot allow it to reach full power if we are to succeed.', 'Defeat the Arm of the Magistrix.', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22996), -- -Unknown-
+(44844, 2, 110, 0, 110, 7637, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 143742, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Powering Down the Portal', 'Slay Overseer Ingra.', 'Destroying the crystals will stop them temporarily, but it will be meaningless if we do not deal with the person controlling the portal itself.$b$bI heard their overseer, Ingra, shouting orders for more power so that she could bring the stronger Legion lieutenants through the gate. We must stop her to truly seal the portal for good.', 'Slay Overseer Ingra.', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22996), -- -Unknown-
+(44843, 2, 110, 0, 110, 7637, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Crystal Clearing', 'Destroy $1oa Portal Crystals.', 'This portal is a problem. With it they can summon countless reserves.$b$bThe crystals nearby seem to be powering the gate. If we destroy those, we can set them back significantly.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22996), -- -Unknown-
+(44842, 2, 110, 0, 110, 7637, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 142260, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 143486, 0, 0, 0, 1, 0, 0, 0, 142260, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Shield, Meet Spell', 'Use the Arcane Nullifier to defeat Arcshaper Thorendis.', 'There you have it, one arcane nullifier! Using their weapon and magical signatures to cloak the spell, it should tear apart the shield as good as any spellbreaker would.$b$bGo teach that amateur spellslinger what it means to wage war against the sin''dorei!', 'Use the Arcane Nullifier to defeat Arcshaper Thorendis.', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22996), -- -Unknown-
+(44834, 2, 110, 0, 110, 7637, 0, 0, 44842, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Nullified', 'Obtain the Charged Arcshaper Staff and a Volatile Construct Core for Sendath.', 'The magus in charge of the defenses here is powerful. Perhaps too strong, even for the both of us.$b$bFortunately, the sin''dorei know a thing or two about magic. The mage''s barrier is strong, but we are clever.$b$bHe has somehow channeled enough energy into his staff to power another set of defense portals, but he has left it out of his sight. Bring me the staff and an energy source from one of those constructs. I should be able to create just the thing we need to take that shield out.', 'Obtain the Charged Arcshaper Staff and a Volatile Construct Core for Sendath.', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22996), -- -Unknown-
+(44831, 2, 110, 0, 110, 7637, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18875469, 0, 'Taking a Promenade', 'Locate the scouts in the Promenade.', 'These people are foreign to us, despite our common heritage. They have changed much in the years they have been cloistered away.$b$bWe need to learn more about them, what they are capable of. We dispatched one of our scouts to infiltrate the Promenade and assess the defenses. The blood elves did the same, although I doubt their ability to be discreet.$b$bBoth are long past due for reporting back to us. Find them and make sure they are safe or at least did not die in vain.', 'Locate the scouts in the Promenade.', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22996), -- -Unknown-
+(41916, 2, 110, 0, 110, 7637, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 143488, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'A Better Future', 'Rescue $1oa Shal''dorei Insurgents in the Grand Promenade.', 'We must move quickly, $n. I must save as many of my people as I can before the attack begins.$b$bWord has gotten out in the city that there is a safe haven with us and some no longer fear exile.$b$bVenture into the Grand Promenade, champion. Find those willing to join us and let them know it is time they made their escape.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22996), -- -Unknown-
+(41607, 2, 110, 0, 110, 7637, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 33555378, 0, 'Taking a Promenade', 'Locate the scouts in the Promenade.', 'We must learn much about our long-lost kin if we are to fight them.$b$bWe dispatched one of our scouts to infiltrate the Promenade and gather intelligence. The Sentinels sent their own scout as well, hopefully she is smart enough to not get herself killed before reporting in.$b$bThey have not returned in some time, and we must suspect the worst.$b$bFind them and we shall see what we are up against.', 'Locate the scouts in the Promenade.', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22996); -- -Unknown-
+
+UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `AllowableRaces`=18875469, `VerifiedBuild`=22996 WHERE `ID`=44805; -- -Unknown-
+UPDATE `quest_template` SET `Flags`=33554440, `RewardItem1`=143740, `RewardAmount1`=1, `AllowableRaces`=33555378, `LogTitle`='Down to Business', `LogDescription`='Enter the Grand Promenade and slay $1oa defenders.', `QuestDescription`='Time to get to business, $n. We cannot afford to tarry.$b$bWhile we are not setting up for a prolonged engagement, we must still have a war camp of some sorts. I do not expect the Nightborne to stay patiently in their city while we plant stakes.$b$bThey are starting to build their defenses. Go in there and see what we are up against. You will strike them from within while we finalize our preparations.', `AreaDescription`='', `VerifiedBuild`=22996 WHERE `ID`=43812; -- -Unknown-
+UPDATE `quest_template` SET `RewardXPDifficulty`=5, `RewardMoney`=194000, `RewardMoneyDifficulty`=5, `RewardBonusMoney`=182850, `Flags`=33554440, `RewardItem1`=143741, `RewardAmount1`=1, `AllowableRaces`=18875469, `LogTitle`='Down to Business', `LogDescription`='Enter the Grand Promenade and slay $1oa defenders.', `QuestDescription`='First things first, $n: we must set up our camp.$b$bWe do not have the time or resources for a prolonged siege. It is not like we can starve them out. No, we must be swift and sure as an arrow, piercing their heart in one strike.$b$bThey are drawing up their battle lines within the city, but could attack us while we are setting up our defenses.$b$bVenture forth and show them what the kaldorei have learned from thousands of years of war. Discover their weaknesses so that we may exploit them.', `AreaDescription`='', `VerifiedBuild`=22996 WHERE `ID`=43810; -- -Unknown-
+UPDATE `quest_template` SET `RewardMoney`=194000, `RewardBonusMoney`=182850, `VerifiedBuild`=22996 WHERE `ID`=43471; -- -Unknown-
+UPDATE `quest_template` SET `RewardMoney`=776000, `RewardBonusMoney`=365700, `VerifiedBuild`=22996 WHERE `ID`=43323; -- -Unknown-
+UPDATE `quest_template` SET `RewardNextQuest`=0, `RewardXPDifficulty`=4, `RewardMoney`=146000, `RewardMoneyDifficulty`=4, `RewardBonusMoney`=137150, `RewardSpell`=229073, `Flags`=35651592, `AllowableRaces`=33555378, `LogTitle`='Take Me To Your Leader', `LogDescription`='Meet with Khadgar in Suramar.', `QuestDescription`='I am glad you are here, $n.$b$bThis... Khadgar, the archmage who found my message, has called a meeting.$b$bHe wishes to meet us by the entrance to the city as soon as possible.$b$bWill you accompany me? I have the strangest feeling that he will not be alone.', `AreaDescription`='Meet with Khadgar in Suramar.', `VerifiedBuild`=22996 WHERE `ID`=40632; -- -Unknown-
+UPDATE `quest_template` SET `QuestLevel`=110, `MinLevel`=110, `QuestSortID`=7637, `RewardXPDifficulty`=4, `RewardMoney`=146000, `RewardMoneyDifficulty`=4, `RewardBonusMoney`=137150, `RewardSpell`=229017, `Flags`=35651592, `AllowableRaces`=18875469, `LogTitle`='Take Me To Your Leader', `LogDescription`='Meet with Khadgar in Suramar.', `QuestDescription`='I am glad you are here, $n.$b$bThis... Khadgar, the archmage who found my message, has called a meeting.$b$bHe wishes to meet us at the entrance to the city as soon as possible.$b$bWill you accompany me? I have the strangest feeling that he will not be alone.', `AreaDescription`='Meet with Khadgar in Suramar.', `VerifiedBuild`=22996 WHERE `ID`=40391; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=11150, `VerifiedBuild`=22996 WHERE `ID`=37265; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=2100, `RewardFactionValue1`=6, `RewardFactionOverride1`=20000, `VerifiedBuild`=22996 WHERE `ID`=32576; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=3400, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=22996 WHERE `ID`=31527; -- -Unknown-
+UPDATE `quest_template` SET `Flags`=524288, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=22996 WHERE `ID`=30042; -- -Unknown-
+UPDATE `quest_template` SET `RewardMoney`=194000, `RewardBonusMoney`=182850, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=22996 WHERE `ID`=25351; -- -Unknown-
+UPDATE `quest_template` SET `RewardMoney`=1300, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=22996 WHERE `ID`=9526; -- -Unknown-
+UPDATE `quest_template` SET `RewardMoney`=1300, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=22996 WHERE `ID`=9516; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=22996 WHERE `ID`=7501; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=182850, `VerifiedBuild`=22996 WHERE `ID`=1531; -- -Unknown-
+
+DELETE FROM `quest_objectives` WHERE `ID` IN (287782 /*287782*/, 287524 /*287524*/, 287140 /*287140*/, 287158 /*287158*/, 287139 /*287139*/, 287133 /*287133*/, 287130 /*287130*/, 287127 /*287127*/, 287126 /*287126*/, 286975 /*286975*/, 287128 /*287128*/, 282562 /*282562*/);
+INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES
+(287782, 45263, 0, 0, 111901, 1, 0, 0, 0, 'Suramar Refugee cured', 22996), -- 287782
+(287524, 44845, 0, 0, 116068, 1, 0, 0, 0, '', 22996), -- 287524
+(287140, 44844, 0, 0, 107217, 1, 0, 0, 0, '', 22996), -- 287140
+(287158, 44843, 0, 0, 100742, 4, 0, 0, 0, 'Portal Crystals destroyed', 22996), -- 287158
+(287139, 44842, 0, 0, 115526, 1, 0, 0, 0, '', 22996), -- 287139
+(287133, 44834, 1, 1, 142245, 1, 0, 1, 0, '', 22996), -- 287133
+(287130, 44834, 1, 0, 142244, 1, 0, 1, 0, '', 22996), -- 287130
+(287127, 44831, 0, 1, 115517, 1, 0, 0, 0, 'Magus Sendath found', 22996), -- 287127
+(287126, 44831, 0, 0, 115521, 1, 0, 0, 0, 'Sentinel Moonshade found', 22996), -- 287126
+(286975, 41916, 0, 0, 115288, 8, 0, 0, 0, 'Shal''dorei Insurgent rallied', 22996), -- 286975
+(287128, 41607, 0, 1, 115521, 1, 0, 0, 0, 'Sentinel Moonshade found', 22996), -- 287128
+(282562, 41607, 0, 0, 115517, 1, 0, 0, 0, 'Magus Sendath found', 22996); -- 282562
+
+UPDATE `quest_objectives` SET `Type`=0, `StorageIndex`=0, `ObjectID`=101762, `Amount`=15, `Description`='Suramar defenders slain', `VerifiedBuild`=22996 WHERE `ID`=285846; -- 285846
+UPDATE `quest_objectives` SET `Type`=0, `StorageIndex`=0, `ObjectID`=101762, `Amount`=15, `Description`='Suramar defenders slain', `VerifiedBuild`=22996 WHERE `ID`=285844; -- 285844
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=258171; -- 258171
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=257981; -- 257981
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=257807; -- 257807
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=257806; -- 257806
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=257797; -- 257797
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=258548; -- 258548
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=256752; -- 256752
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=256697; -- 256697
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=255902; -- 255902
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=255901; -- 255901
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=255920; -- 255920
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=255228; -- 255228
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=254925; -- 254925
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=253973; -- 253973
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22996 WHERE `ID`=253560; -- 253560
+
+DELETE FROM `quest_visual_effect` WHERE (`ID`=287782 AND `Index`=2) OR (`ID`=287782 AND `Index`=1) OR (`ID`=287782 AND `Index`=0) OR (`ID`=287524 AND `Index`=0) OR (`ID`=287140 AND `Index`=0) OR (`ID`=287158 AND `Index`=0) OR (`ID`=287139 AND `Index`=0) OR (`ID`=287133 AND `Index`=1) OR (`ID`=287133 AND `Index`=0) OR (`ID`=287127 AND `Index`=0) OR (`ID`=287126 AND `Index`=0) OR (`ID`=286975 AND `Index`=0) OR (`ID`=287128 AND `Index`=0) OR (`ID`=282562 AND `Index`=0);
+INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES
+(287782, 2, 6529, 22996),
+(287782, 1, 6505, 22996),
+(287782, 0, 2100, 22996),
+(287524, 0, 2101, 22996),
+(287140, 0, 2101, 22996),
+(287158, 0, 2100, 22996),
+(287139, 0, 2101, 22996),
+(287133, 1, 6503, 22996),
+(287133, 0, 6502, 22996),
+(287127, 0, 2099, 22996),
+(287126, 0, 2099, 22996),
+(286975, 0, 6650, 22996),
+(287128, 0, 2099, 22996),
+(282562, 0, 2099, 22996);