diff options
| -rw-r--r-- | sql/updates/world/master/2017_04_22_00_world.sql | 123 |
1 files changed, 123 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_04_22_00_world.sql b/sql/updates/world/master/2017_04_22_00_world.sql new file mode 100644 index 00000000000..73e8676dab6 --- /dev/null +++ b/sql/updates/world/master/2017_04_22_00_world.sql @@ -0,0 +1,123 @@ +DELETE FROM `quest_template` WHERE `ID`=46279; +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 +(46279, 3, -1, 0, 98, 7503, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242342, 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, 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, 'Zargrom', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911); -- -Unknown- + +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=45048; -- -Unknown- +UPDATE `quest_template` SET `RewardXPMultiplier`=0, `RewardArtifactXPMultiplier`=0, `Flags`=35193088, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43637; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42620; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41836; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41687; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41600; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41352; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41295; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41278; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardArtifactCategoryID`=0, `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41237; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=37972; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=37751; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=36206; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32848; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=14169; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=12781; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=18875469, `Expansion`=1, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=9586; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9491; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9428; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=9261; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8023; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6823; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6502; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=6285; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6187; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=1, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=6126; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5384; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5001; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionValue2`=7, `RewardFactionValue3`=7, `RewardFactionValue4`=7, `RewardFactionValue5`=7, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `RewardFactionOverride3`=0, `RewardFactionOverride4`=0, `RewardFactionOverride5`=0, `VerifiedBuild`=23911 WHERE `ID`=4974; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4362; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4291; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4131; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestDescription`='Ah, while you were gone a tablet came for you, $n.$B$BRead it when you have time. If I''m not mistaken, it came from the priest trainer Ken''jai. He would have words with you when you''re ready.', `VerifiedBuild`=23911 WHERE `ID`=3085; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=2378; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=2218; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2200; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1998; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1886; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1534; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1244; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=907; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23911 WHERE `ID`=832; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=790; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=468; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=385; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=217; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=199; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=161; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41687; -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID` IN (289168 /*289168*/, 256463 /*256463*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(289168, 46279, 0, 0, 117047, 1, 1, 0, 0, '', 23911), -- 289168 +(256463, 3085, 1, 0, 9561, 1, 0, 1, 0, '', 23911); -- 256463 + +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=287410; -- 287410 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=288971; -- 288971 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285576; -- 285576 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285575; -- 285575 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284473; -- 284473 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282901; -- 282901 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282658; -- 282658 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282555; -- 282555 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282243; -- 282243 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282173; -- 282173 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282158; -- 282158 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282349; -- 282349 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282092; -- 282092 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=274435; -- 274435 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=275006; -- 275006 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=275005; -- 275005 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=276211; -- 276211 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=275004; -- 275004 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=275003; -- 275003 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=270515; -- 270515 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263601; -- 263601 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262592; -- 262592 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260116; -- 260116 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255322; -- 255322 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259500; -- 259500 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259499; -- 259499 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257426; -- 257426 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258469; -- 258469 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258443; -- 258443 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259049; -- 259049 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258406; -- 258406 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258066; -- 258066 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257372; -- 257372 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=256741; -- 256741 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258535; -- 258535 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258419; -- 258419 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256133; -- 256133 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256091; -- 256091 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257827; -- 257827 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255097; -- 255097 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254957; -- 254957 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254147; -- 254147 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254059; -- 254059 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253733; -- 253733 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253732; -- 253732 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252689; -- 252689 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252688; -- 252688 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252687; -- 252687 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253799; -- 253799 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252526; -- 252526 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282658; -- 282658 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=289949 AND `Index`=1) OR (`ID`=289949 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(289949, 1, 7532, 23911), +(289949, 0, 7276, 23911); + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=287410 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=288971 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=285576 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=285575 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282658 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282158 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282658 AND `Index`=0); |