diff options
| -rw-r--r-- | sql/updates/world/master/2017_05_06_00_world.sql | 164 |
1 files changed, 164 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_05_06_00_world.sql b/sql/updates/world/master/2017_05_06_00_world.sql new file mode 100644 index 00000000000..e0b05b3861e --- /dev/null +++ b/sql/updates/world/master/2017_05_06_00_world.sql @@ -0,0 +1,164 @@ +DELETE FROM `quest_template` WHERE `ID` IN (47054 /*-Unknown-*/, 47045 /*-Unknown-*/, 47040 /*-Unknown-*/, 47016 /*-Unknown-*/, 47007 /*-Unknown-*/, 46947 /*-Unknown-*/, 46766 /*-Unknown-*/, 46105 /*-Unknown-*/, 46104 /*-Unknown-*/, 46021 /*-Unknown-*/, 45921 /*-Unknown-*/, 45805 /*-Unknown-*/, 45776 /*-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`, `Expansion`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES +(47054, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 241489, 0, 0, 0, 0, 1, 0, 35651584, 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, 6, 'Touched By Fate', '', '', '', '', 1273, 0, 0, 0, 1, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(47045, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 241482, 0, 0, 0, 0, 1, 0, 35651584, 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, 6, 'Further Progress', '', '', '', '', 1273, 0, 0, 0, 1, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(47040, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 241490, 0, 0, 0, 0, 1, 0, 35651584, 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, 6, 'Fate Sealed', '', '', '', '', 1273, 0, 0, 0, 1, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(47016, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 239967, 0, 0, 240686, 0, 0, 0, 0, 1, 0, 39845888, 8192, 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, 350, 6, 'Boon of the Nether Disruptor', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(47007, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 237137, 0, 0, 237135, 0, 0, 0, 0, 1, 0, 39846144, 8192, 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, 6, 'Boon of the Mage Tower', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46947, 3, 110, 0, 110, 7543, 144, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218041, 0, 0, 0, 0, 0, 0, 37290304, 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, 2045, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5139, 0, -1, 359, 6, 'Brutallus', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46766, 3, -1, 0, 98, 7558, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242337, 0, 0, 0, 0, 0, 0, 37290240, 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, 1883, 1894, 0, 0, 0, 4, 4, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 335, 6, 'Ulgthax', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46105, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 235672, 0, 0, 0, 0, 0, 0, 37290240, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5131, 0, -1, 340, 6, 'Arachnid Superiority', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46104, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 235670, 0, 0, 0, 0, 0, 0, 37290240, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5131, 0, -1, 356, 6, 'Arachnid Toxicity', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46021, 3, -1, 0, 98, 7541, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242339, 0, 0, 0, 0, 0, 0, 37290240, 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, 1948, 1894, 0, 0, 0, 4, 4, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 335, 6, 'Thel''draz', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(45921, 3, -1, 0, 98, 7558, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242336, 0, 0, 0, 0, 0, 0, 37290240, 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, 1883, 1894, 0, 0, 0, 4, 4, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 335, 6, 'Thal''xur', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(45805, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 234487, 0, 0, 0, 0, 0, 0, 37290240, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 143924, 0, 0, 0, 100, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5093, 0, -1, 340, 6, 'The Burning Keys', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(45776, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 234485, 0, 0, 0, 0, 0, 0, 37290240, 8192, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5093, 0, -1, 356, 6, 'Keys are a Crutch', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911); -- -Unknown- + +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44015; -- WANTED: Mal'Dreth the Corruptor +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43436; -- WANTED: Glimar Ironfist +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41610; -- Huge Cursed Queenfish +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41548; -- Starlight Rose Cluster +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41547; -- Fjarnskaggl Cluster +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41495; -- Brilliant Leystone Seams +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41198; -- Leystone Basilisks +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41026; -- Back to the Shadows +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=39520; -- Ashran Dominance +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32896; -- The Road to War +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=31892; -- Battle Pet Trainers: Kalimdor +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=31527; -- A Worthy Challenge: Flameweaver Koegler +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=24878; -- Residue Rendezvous +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=14012; -- Corruption +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8945; -- Dead Man's Plea +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=8810; -- Bandages for the Field +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=8804; -- Desert Survival Kits +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=8787; -- Armor Kits for the Field +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8740; -- Twilight Marauders +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=8739; -- Hive'Ashi Scout Report +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=8738; -- Hive'Regal Scout Report +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=8573; -- Champion's Battlegear +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=8537; -- Crimson Templar +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8535; -- Hoary Templar +UPDATE `quest_template` SET `RewardFactionValue1`=2, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8507; -- Field Duty +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=8498; -- Twilight Battle Orders +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8460; -- [DEPRECATED]Timbermaw Ally +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8423; -- Warrior Kinship +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8341; -- Lords of the Council +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=8156; -- Arathi Basin Resources! +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7623; -- Lord Banehollow +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6762; -- Rabine Saturna +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5141; -- Dragonscale Leatherworking +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4986; -- Glyphed Oaken Branch +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4005; -- Aquementas +UPDATE `quest_template` SET `RewardFactionValue1`=1, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=3784; -- Assisting Arch Druid Runetotem +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3635; -- Gnome Engineering +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestDescription`='Most of our recruits never make it to Booty Bay, $n. The shine of the insignia is enough to trigger the loot lust in even the staunchest of blacksmiths. Fools they be, as the insignia is a drop in the bucket compared to the wealth of items you''ll see!$B$BFind Galvan the Ancient and show him this pin. His residence is far to the north, between Zul Gurub and the Mosh''Ogg ogre mound.\n', `VerifiedBuild`=23911 WHERE `ID`=2760; -- The Mithril Order +UPDATE `quest_template` SET `RewardBonusMoney`=91500, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=1685; -- Gakin's Summons +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=1680; -- Tormus Deepforge +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=710; -- Study of the Elements: Rock +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=660; -- Hints of a New Plague? +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43436; -- WANTED: Glimar Ironfist + +DELETE FROM `quest_objectives` WHERE `ID` IN (289871 /*289871*/, 289572 /*289572*/, 289700 /*289700*/, 288899 /*288899*/, 289699 /*289699*/, 288898 /*288898*/, 288806 /*288806*/, 288733 /*288733*/, 288581 /*288581*/, 288485 /*288485*/, 253109 /*253109*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(289871, 46947, 0, 6, 117239, 1, 0, 0, 0, '', 23911), -- 289871 +(289572, 46766, 0, 0, 120310, 1, 1, 0, 0, '', 23911), -- 289572 +(289700, 46105, 0, 1, 120236, 1, 0, 0, 0, '', 23911), -- 289700 +(288899, 46105, 1, 0, 147206, 8, 0, 1, 0, '', 23911), -- 288899 +(289699, 46104, 0, 1, 120236, 1, 0, 0, 0, '', 23911), -- 289699 +(288898, 46104, 0, 0, 118733, 6, 0, 0, 0, 'Legionfall Soldier detoxed', 23911), -- 288898 +(288806, 46021, 0, 0, 118002, 1, 1, 0, 0, '', 23911), -- 288806 +(288733, 45921, 0, 0, 118016, 1, 1, 0, 0, '', 23911), -- 288733 +(288581, 45805, 0, 0, 118021, 10, 0, 0, 0, 'Prisoners rescued', 23911), -- 288581 +(288485, 45776, 0, 0, 118021, 10, 0, 0, 0, 'Cage Locks picked', 23911), -- 288485 +(253109, 2760, 1, 0, 8686, 1, 0, 1, 0, '', 23911); -- 253109 + +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286113; -- 286113 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285273; -- 285273 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282565; -- 282565 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282502; -- 282502 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282501; -- 282501 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282444; -- 282444 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282011; -- 282011 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281675; -- 281675 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281717; -- 281717 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281716; -- 281716 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281715; -- 281715 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281673; -- 281673 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281672; -- 281672 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=279669; -- 279669 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=279668; -- 279668 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269160; -- 269160 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269159; -- 269159 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269158; -- 269158 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269157; -- 269157 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269156; -- 269156 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268673; -- 268673 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266482; -- 266482 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266481; -- 266481 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261349; -- 261349 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260951; -- 260951 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260950; -- 260950 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260949; -- 260949 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260948; -- 260948 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260633; -- 260633 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260632; -- 260632 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260631; -- 260631 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260630; -- 260630 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260729; -- 260729 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260728; -- 260728 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260727; -- 260727 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260978; -- 260978 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260977; -- 260977 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260976; -- 260976 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261442; -- 261442 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261441; -- 261441 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261228; -- 261228 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261227; -- 261227 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259359; -- 259359 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259358; -- 259358 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259357; -- 259357 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259356; -- 259356 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259355; -- 259355 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259654; -- 259654 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259653; -- 259653 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256734; -- 256734 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256733; -- 256733 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259715; -- 259715 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258594; -- 258594 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=258593; -- 258593 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255719; -- 255719 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255718; -- 255718 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255717; -- 255717 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259899; -- 259899 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257669; -- 257669 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257668; -- 257668 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259225; -- 259225 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256924; -- 256924 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256923; -- 256923 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256922; -- 256922 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257082; -- 257082 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257608; -- 257608 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257493; -- 257493 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254866; -- 254866 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285273; -- 285273 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=289871 AND `Index`=0) OR (`ID`=289700 AND `Index`=0) OR (`ID`=289699 AND `Index`=0) OR (`ID`=288581 AND `Index`=4) OR (`ID`=288581 AND `Index`=3) OR (`ID`=288581 AND `Index`=2) OR (`ID`=288581 AND `Index`=1) OR (`ID`=288581 AND `Index`=0) OR (`ID`=288485 AND `Index`=1) OR (`ID`=288485 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(289871, 0, 2101, 23911), +(289700, 0, 2101, 23911), +(289699, 0, 2101, 23911), +(288581, 4, 7034, 23911), +(288581, 3, 7025, 23911), +(288581, 2, 7024, 23911), +(288581, 1, 6760, 23911), +(288581, 0, 6759, 23911), +(288485, 1, 6760, 23911), +(288485, 0, 6759, 23911); + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282502 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282501 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269160 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269159 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269158 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269157 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269156 AND `Index`=0); |