DB/Quests: Updated quest_template to 7.0.3.22594 part 13

1 files changed, 90 insertions, 0 deletions

diff --git a/sql/updates/world/6.x/2016_09_15_00_world.sql b/sql/updates/world/6.x/2016_09_15_00_world.sql
new file mode 100644
index 00000000000..2bc3cda70e3
--- /dev/null
+++ b/sql/updates/world/6.x/2016_09_15_00_world.sql
@@ -0,0 +1,90 @@
+DELETE FROM `quest_template` WHERE `ID` IN (43628 /*-Unknown-*/, 43473 /*-Unknown-*/, 43436 /*-Unknown-*/, 41545 /*-Unknown-*/, 41414 /*-Unknown-*/, 41336 /*-Unknown-*/, 41297 /*-Unknown-*/, 41173 /*-Unknown-*/, 39817 /*-Unknown-*/, 39763 /*-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
+(43628, 3, 110, 0, 110, 7541, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 4, 0, 0, 0, 0, 0, 0, -1, 49, 'WANTED: Urgev the Flayer', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22594), -- -Unknown-
+(43473, 0, 110, 0, 110, 7502, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 219622, 0, 0, 0, 0, 1, 0, 35651592, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Experimental Potion: Test Subjects Needed', '', '', '', '', 1149, 0, 0, 0, 150, 0, 0, 0, '', '', '', '', 890, 878, 22594), -- -Unknown-
+(43436, 3, 110, 0, 110, 7541, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 3, 0, 0, 0, 0, 0, 0, -1, 25, 'WANTED: Glimar Ironfist', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22594), -- -Unknown-
+(41545, 3, 110, 0, 110, 7334, 119, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 143, 'Aethril Cluster', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22594), -- -Unknown-
+(41414, 3, 110, 0, 110, 7503, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 207205, 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, 1828, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 4565, 0, -1, 23, 'Weapons of Deathwing', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22594), -- -Unknown-
+(41336, 3, 110, 0, 110, 7558, 124, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 4276, 0, -1, 141, 'Bristly Musken Hide', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22594), -- -Unknown-
+(41297, 3, 110, 0, 110, 7541, 119, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 524608, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4394, 0, -1, 132, 'Work Order: Fjarnskaggl', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22594), -- -Unknown-
+(41173, 2, 110, 0, 110, -377, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 223875, 0, 0, 0, 0, 1, 0, 36700168, 0, 0, 0, 0, 0, 131717, 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 Beacon of Hope', 'Go to the location Tae''thelan marked on your map and survey the area until you find the artifact.', 'I''ve marked the location of the artifact on your map. It''s in a rather hostile location, so I''d like you to go there and find it.$b$bWhen you''ve recovered it, bring it back to me so I can discern its power.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22594), -- -Unknown-
+(39817, 2, 110, 0, 110, -408, 0, 0, 39830, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1048584, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'The Brimstone''s Secret', 'Tell Mama Diggs what you learned from Matthew.', 'While you were gathering what I asked of you, I did a little testing on the brimstone. It reacted rather violently when I channeled onto it. Careful casting went into making the creature from whom you took this.$b$bUnless you have a host of demon spell-casters at your disposal, recreating such a creature would be impossible.$b$bThat''s all I have to tell you. Go now and leave me before my hunger takes over.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22594), -- -Unknown-
+(39763, 2, 110, 0, 110, -408, 0, 0, 39817, 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, 'For Whom the Fel Tolls', 'Obtain $1oa Fel Energy Cores from Wyrmtongue Minions in Suramar. Bring them back to Matthew in Dalaran when you are finished.', '<Matthew eyes you up and down, growling slightly>$b$bYou wish me to help you understand this rock? First you do something for me.$b$bThe legion has brought many of its fel machines to conquer this world. Those machines are powered by cores filled with fel energy. And those cores are carried by the lowliest of their minions for distribution.$b$bBring me some cores and I''ll give you the information you need.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22594); -- -Unknown-
+
+DELETE FROM `quest_objectives` WHERE `ID` IN (285565 /*285565*/, 285273 /*285273*/, 282499 /*282499*/, 282332 /*282332*/, 282331 /*282331*/, 282330 /*282330*/, 282227 /*282227*/, 282177 /*282177*/, 282039 /*282039*/, 279992 /*279992*/, 253490 /*253490*/, 253489 /*253489*/, 253488 /*253488*/, 253487 /*253487*/, 259437 /*259437*/, 259436 /*259436*/, 259435 /*259435*/, 259434 /*259434*/, 259443 /*259443*/, 259442 /*259442*/, 259441 /*259441*/, 259440 /*259440*/, 258578 /*258578*/, 258577 /*258577*/, 258576 /*258576*/, 258575 /*258575*/, 258087 /*258087*/, 258086 /*258086*/, 258085 /*258085*/, 258084 /*258084*/, 258203 /*258203*/, 258202 /*258202*/, 258201 /*258201*/, 258200 /*258200*/, 258054 /*258054*/, 258053 /*258053*/, 258052 /*258052*/, 258051 /*258051*/, 260907 /*260907*/, 260906 /*260906*/, 260905 /*260905*/, 260904 /*260904*/, 260799 /*260799*/, 260798 /*260798*/, 260797 /*260797*/, 260796 /*260796*/, 261014 /*261014*/, 261013 /*261013*/, 261012 /*261012*/, 261011 /*261011*/, 261411 /*261411*/, 261410 /*261410*/, 261409 /*261409*/, 261408 /*261408*/, 261725 /*261725*/, 261724 /*261724*/, 261723 /*261723*/, 261722 /*261722*/, 261549 /*261549*/, 261548 /*261548*/, 261547 /*261547*/, 261546 /*261546*/, 260941 /*260941*/, 260940 /*260940*/, 260939 /*260939*/, 260938 /*260938*/, 261594 /*261594*/, 261593 /*261593*/, 261592 /*261592*/, 261591 /*261591*/);
+INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES
+(285565, 43628, 0, 0, 93401, 1, 1, 0, 'Urgev the Flayer slain.', 22594), -- 285565
+(285273, 43436, 0, 0, 91529, 1, 1, 0, 'Glimar Ironfist slain.', 22594), -- 285273
+(282499, 41545, 0, 0, 103843, 1, 0, 0, 'Aethril Cluster gathered', 22594), -- 282499
+(282332, 41414, 0, 1, 104248, 1, 1, 0, '', 22594), -- 282332
+(282331, 41414, 0, 0, 104244, 1, 1, 0, '', 22594), -- 282331
+(282330, 41414, 1, 3, 134837, 100, 0, 0, '', 22594), -- 282330
+(282227, 41336, 1, 0, 134812, 8, 0, 0, '', 22594), -- 282227
+(282177, 41297, 1, 0, 124104, 40, 0, 0, '', 22594), -- 282177
+(282039, 41173, 1, 0, 134108, 1, 0, 0, '', 22594), -- 282039
+(279992, 39763, 1, 0, 128813, 10, 0, 0, 'Fel Energy Cores', 22594), -- 279992
+(253490, 9098, 1, 3, 15407, 3, 0, 0, '', 22594), -- 253490
+(253489, 9098, 1, 2, 14342, 2, 0, 0, '', 22594), -- 253489
+(253488, 9098, 1, 1, 22376, 12, 0, 0, '', 22594), -- 253488
+(253487, 9098, 1, 0, 22368, 1, 0, 0, '', 22594), -- 253487
+(259437, 9097, 1, 3, 20725, 3, 0, 0, '', 22594), -- 259437
+(259436, 9097, 1, 2, 14342, 3, 0, 0, '', 22594), -- 259436
+(259435, 9097, 1, 1, 22376, 15, 0, 0, '', 22594), -- 259435
+(259434, 9097, 1, 0, 22367, 1, 0, 0, '', 22594), -- 259434
+(259443, 9095, 1, 3, 20725, 2, 0, 0, '', 22594), -- 259443
+(259442, 9095, 1, 2, 14342, 4, 0, 0, '', 22594), -- 259442
+(259441, 9095, 1, 1, 22376, 25, 0, 0, '', 22594), -- 259441
+(259440, 9095, 1, 0, 22351, 1, 0, 0, '', 22594), -- 259440
+(258578, 9071, 1, 3, 14342, 2, 0, 0, '', 22594), -- 258578
+(258577, 9071, 1, 2, 12360, 2, 0, 0, '', 22594), -- 258577
+(258576, 9071, 1, 1, 22374, 12, 0, 0, '', 22594), -- 258576
+(258575, 9071, 1, 0, 22361, 1, 0, 0, '', 22594), -- 258575
+(258087, 9070, 1, 3, 20725, 2, 0, 0, '', 22594), -- 258087
+(258086, 9070, 1, 2, 12360, 4, 0, 0, '', 22594), -- 258086
+(258085, 9070, 1, 1, 22374, 15, 0, 0, '', 22594), -- 258085
+(258084, 9070, 1, 0, 22360, 1, 0, 0, '', 22594), -- 258084
+(258203, 9069, 1, 3, 15407, 5, 0, 0, '', 22594), -- 258203
+(258202, 9069, 1, 2, 12360, 3, 0, 0, '', 22594), -- 258202
+(258201, 9069, 1, 1, 22374, 20, 0, 0, '', 22594), -- 258201
+(258200, 9069, 1, 0, 22359, 1, 0, 0, '', 22594), -- 258200
+(258054, 9068, 1, 3, 15407, 3, 0, 0, '', 22594), -- 258054
+(258053, 9068, 1, 2, 12360, 4, 0, 0, '', 22594), -- 258053
+(258052, 9068, 1, 1, 22374, 25, 0, 0, '', 22594), -- 258052
+(258051, 9068, 1, 0, 22350, 1, 0, 0, '', 22594), -- 258051
+(260907, 9050, 1, 3, 15407, 2, 0, 0, '', 22594), -- 260907
+(260906, 9050, 1, 2, 12360, 1, 0, 0, '', 22594), -- 260906
+(260905, 9050, 1, 1, 22375, 6, 0, 0, '', 22594), -- 260905
+(260904, 9050, 1, 0, 22362, 1, 0, 0, '', 22594), -- 260904
+(260799, 9049, 1, 3, 20725, 3, 0, 0, '', 22594), -- 260799
+(260798, 9049, 1, 2, 12360, 1, 0, 0, '', 22594), -- 260798
+(260797, 9049, 1, 1, 22375, 8, 0, 0, '', 22594), -- 260797
+(260796, 9049, 1, 0, 22363, 1, 0, 0, '', 22594), -- 260796
+(261014, 9048, 1, 3, 15407, 5, 0, 0, '', 22594), -- 261014
+(261013, 9048, 1, 2, 12360, 1, 0, 0, '', 22594), -- 261013
+(261012, 9048, 1, 1, 22375, 8, 0, 0, '', 22594), -- 261012
+(261011, 9048, 1, 0, 22364, 1, 0, 0, '', 22594), -- 261011
+(261411, 9047, 1, 3, 15407, 3, 0, 0, '', 22594), -- 261411
+(261410, 9047, 1, 2, 12360, 2, 0, 0, '', 22594), -- 261410
+(261409, 9047, 1, 1, 22375, 12, 0, 0, '', 22594), -- 261409
+(261408, 9047, 1, 0, 22365, 1, 0, 0, '', 22594), -- 261408
+(261725, 9046, 1, 3, 20725, 2, 0, 0, '', 22594), -- 261725
+(261724, 9046, 1, 2, 12360, 2, 0, 0, '', 22594), -- 261724
+(261723, 9046, 1, 1, 22375, 12, 0, 0, '', 22594), -- 261723
+(261722, 9046, 1, 0, 22361, 1, 0, 0, '', 22594), -- 261722
+(261549, 9045, 1, 3, 15407, 2, 0, 0, '', 22594), -- 261549
+(261548, 9045, 1, 2, 12360, 5, 0, 0, '', 22594), -- 261548
+(261547, 9045, 1, 1, 22375, 15, 0, 0, '', 22594), -- 261547
+(261546, 9045, 1, 0, 22360, 1, 0, 0, '', 22594), -- 261546
+(260941, 9044, 1, 3, 20725, 2, 0, 0, '', 22594), -- 260941
+(260940, 9044, 1, 2, 12360, 4, 0, 0, '', 22594), -- 260940
+(260939, 9044, 1, 1, 22375, 20, 0, 0, '', 22594), -- 260939
+(260938, 9044, 1, 0, 22359, 1, 0, 0, '', 22594), -- 260938
+(261594, 9043, 1, 3, 15407, 3, 0, 0, '', 22594), -- 261594
+(261593, 9043, 1, 2, 12360, 4, 0, 0, '', 22594), -- 261593
+(261592, 9043, 1, 1, 22375, 25, 0, 0, '', 22594), -- 261592
+(261591, 9043, 1, 0, 22350, 1, 0, 0, '', 22594); -- 261591
+
+DELETE FROM `quest_visual_effect` WHERE (`ID`=282499 AND `Index`=0) OR (`ID`=282039 AND `Index`=0);
+INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES
+(282499, 0, 6052, 22594), -- 282499
+(282039, 0, 4590, 22594); -- 282039