diff options
| -rw-r--r-- | sql/updates/world/2015_07_19_30_world.sql | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_19_30_world.sql b/sql/updates/world/2015_07_19_30_world.sql new file mode 100644 index 00000000000..96b3f24102b --- /dev/null +++ b/sql/updates/world/2015_07_19_30_world.sql @@ -0,0 +1,41 @@ +DELETE FROM `quest_template` WHERE `Id` IN (36672, 29407, 29773); +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 +(36672, 2, 100, 0, 100, 6755, 1, 5, 0, 0, 1, 0, 0, 1, 0, 0, 81040, 0, 0, 0, 170938370, 64, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 55774, 0, 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, 'The Ring of Blood: Venoxis!', 'Defeat Venoxis in the Ring of Blood.', 'Alright, alright, how about this. A living, breathing... wait for it.... tree... that wants to murder your face. Genius, right?$B$BLook, they don''t pay me to come up with witty dialogue about these things, give me a break. They''re ogres - they pay for blood. Hence the name.', 'Defeat Venoxis in the Ring of Blood.', '', 'Venoxis', '', '', 'Return to Gurgthock at the Ring of Blood.', 20253), -- -Unknown- +(29407, 2, 2, 0, 0, 5736, 0, 0, 0, 5, 1, 35, 5, 1, 0, 0, 103659, 0, 0, 0, 3670016, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1216, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, -1, 'The First Sign of Winter', 'Recover the Shimmering Lotus.', 'At the stream below rests a single lotus flower. Within this lotus lies a sign of things to come. Bring it to me that I might show you.', '', '', '', '', '', 'Return to Master Shang Xi on the bridge near the Tranquil Grotto.', 20253), -- -Unknown- +(29773, 2, 6, 0, 0, 5736, 0, 0, 29768, 5, 1, 125, 5, 1, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1216, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, -1, 'Wugou, the Spirit of Earth', 'Slap the ox.', '$n! Well, the plus side is that finding Wugou was easy enough. Waking him... not so much. I think he''s going to wake quite sore from all the pushing and hitting I''ve done trying to rouse him.$B$BAre you a deep sleeper at all, $n? What wakes you up in the morning?$B$BRolling out of bed always seems to do it for me, so I figure let''s just go for that! I tied off some ropes to the ox cart. We send it running and give him a good roll, and we should be good! Care to give the ox a good slap to get it going?', '', '', '', '', '', 'Return to Ji Firepaw in the Dai-Lo Farmstead.', 20253); -- -Unknown- + +UPDATE `quest_template` SET `VerifiedBuild`=20253 WHERE `Id`=36501; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=20253 WHERE `Id` IN (29969 /*-Unknown-*/, 29970 /*-Unknown-*/, 31445 /*-Unknown-*/, 32007 /*-Unknown-*/, 32565 /*-Unknown-*/, 32809 /*-Unknown-*/); +UPDATE `quest_template` SET `VerifiedBuild`=20253 WHERE `Id`=30043; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=20253 WHERE `Id`=31016; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=20253 WHERE `Id`=31892; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=20253 WHERE `Id` IN (32373 /*-Unknown-*/, 32390 /*-Unknown-*/); +UPDATE `quest_template` SET `VerifiedBuild`=20253 WHERE `Id`=32607; -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `Id` IN (252343, 276423, 264008); +INSERT INTO `quest_objectives` (`Id`, `QuestId`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `UnkFloat`, `Description`, `VerifiedBuild`) VALUES +(252343, 29407, 1, 0, 71079, 1, 0, 0, '', 20253), -- 252343 +(276423, 36672, 0, 0, 85377, 1, 12, 0, '', 20253), -- 276423 +(264008, 29773, 0, 0, 55545, 1, 0, 0, 'Spur the Ox Cart', 20253); -- 264008 + +UPDATE `quest_objectives` SET `VerifiedBuild`=20253 WHERE `Id` IN (269156 /*269156*/, 269157 /*269157*/, 269158 /*269158*/, 269159 /*269159*/, 269160 /*269160*/, 269354 /*269354*/, 269693 /*269693*/, 269875 /*269875*/, 270250 /*270250*/, 270251 /*270251*/, 270458 /*270458*/, 270459 /*270459*/, 270460 /*270460*/, 270571 /*270571*/, 265243 /*265243*/, 265244 /*265244*/, 265245 /*265245*/, 265246 /*265246*/, 265367 /*265367*/, 265368 /*265368*/, 265369 /*265369*/, 265370 /*265370*/); + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=269156 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=269157 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=269158 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=269159 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=269160 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=269693 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=269875 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270250 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270250 AND `Index`=1; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270251 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270458 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270458 AND `Index`=1; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270459 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270459 AND `Index`=1; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270460 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270460 AND `Index`=1; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270571 AND `Index`=0; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270571 AND `Index`=1; +UPDATE `quest_visual_effect` SET `VerifiedBuild`=20253 WHERE `Id`=270571 AND `Index`=2; |