DB/Quests: Updated quest_template to 6.2.0.20253 no.3

1 files changed, 20 insertions, 0 deletions

diff --git a/sql/updates/world/2015_07_19_28_world.sql b/sql/updates/world/2015_07_19_28_world.sql
new file mode 100644
index 00000000000..eb7bd1a25b4
--- /dev/null
+++ b/sql/updates/world/2015_07_19_28_world.sql
@@ -0,0 +1,20 @@
+DELETE FROM `quest_template` WHERE `Id` IN (37753, 37972, 32435, 32436);
+INSERT INTO `quest_template` (`Id`, `QuestType`, `QuestLevel`, `QuestPackageID`, `MinLevel`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoney`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardBonusMoney`, `RewardDisplaySpell`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `Flags`, `FlagsEx`, `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`, `RewardTalents`, `RewardArenaPoints`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitTurnIn`, `RewardFactionID1`, `RewardFactionID2`, `RewardFactionID3`, `RewardFactionID4`, `RewardFactionID5`, `RewardFactionValue1`, `RewardFactionValue2`, `RewardFactionValue3`, `RewardFactionValue4`, `RewardFactionValue5`, `RewardFactionOverride1`, `RewardFactionOverride2`, `RewardFactionOverride3`, `RewardFactionOverride4`, `RewardFactionOverride5`, `RewardFactionFlags`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `QuestCompletionLog`, `VerifiedBuild`) VALUES
+(37753, 2, 100, 0, 100, -403, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, -1, 'Relic Hunter Active', '', '', '', '', '', '', '', '', 20253), -- -Unknown-
+(37972, 2, 100, 0, 100, -403, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, -1, 'Pet Battles Not Active', '', '', '', '', '', '', '', '', 20253), -- -Unknown-
+(32435, 0, -1, 0, 1, -101, 0, 0, 0, 0, 1, 308000, 6, 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, 122529, 50287, 19971, 0, 0, 0, 1, 1, 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, 890, 878, 0, 0, -1, 'Second Place', '', '', '', '', '', '', '', 'Return to Riggle Bassbait in Stranglethorn Vale.', 20253), -- -Unknown-
+(32436, 0, -1, 0, 1, -101, 0, 0, 0, 0, 1, 308000, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0, 19971, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, -1, 'Third Place', '', '', '', '', '', '', '', 'Return to Riggle Bassbait in Stranglethorn Vale.', 20253); -- -Unknown-
+
+UPDATE `quest_template` SET `RewardMoney`=114000, `VerifiedBuild`=20253 WHERE `Id`=31530; -- -Unknown-
+UPDATE `quest_template` SET `RewardMoney`=57000, `VerifiedBuild`=20253 WHERE `Id`=32364; -- -Unknown-
+UPDATE `quest_template` SET `RewardMoney`=228000, `VerifiedBuild`=20253 WHERE `Id`=32562; -- -Unknown-
+
+DELETE FROM `quest_objectives` WHERE `Id` IN (269767, 269768);
+INSERT INTO `quest_objectives` (`Id`, `QuestId`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `UnkFloat`, `Description`, `VerifiedBuild`) VALUES
+(269767, 32435, 1, 0, 19807, 40, 0, 0, '', 20253), -- 269767
+(269768, 32436, 1, 0, 19807, 40, 0, 0, '', 20253); -- 269768
+
+UPDATE `quest_objectives` SET `VerifiedBuild`=20253 WHERE `Id` IN (269033 /*269033*/, 269786 /*269786*/, 270080 /*270080*/, 270147 /*270147*/, 268682 /*268682*/);
+
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270080 AND `Index`=0;
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270147 AND `Index`=0;