diff options
| -rw-r--r-- | sql/updates/world/master/2017_02_05_01_world.sql | 124 |
1 files changed, 124 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_05_01_world.sql b/sql/updates/world/master/2017_02_05_01_world.sql new file mode 100644 index 00000000000..5d58ff77a37 --- /dev/null +++ b/sql/updates/world/master/2017_02_05_01_world.sql @@ -0,0 +1,124 @@ +DELETE FROM `quest_template` WHERE `ID` IN (46137 /*-Unknown-*/, 45383 /*-Unknown-*/, 43929 /*-Unknown-*/, 41170 /*-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 +(46137, 3, 110, 0, 110, 7502, 125, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 590144, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 331, 'Gemcutter Needed', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23420), -- -Unknown- +(45383, 2, 110, 0, 110, 8025, 62, 0, 0, 6, 1, 388000, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554752, 0, 0, 0, 0, 0, 141326, 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, 4773, 0, -1, 0, 'Talisman of the Shal''dorei', 'Collect 4 Echoes of Time from Elisande in The Nighthold on Mythic Difficulty.', 'When the Nighthold was built, my people forged a talisman that allowed access to these halls. With the talisman''s power, one could traverse the palace unhindered, taking the fight directly to the magistrix. Using fragments of the Nightwell''s power, we could locate the talisman and end this foolish war...', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23420), -- -Unknown- +(43929, 0, 110, 0, 110, -371, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 137783, 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, 'Vantus Mastery', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23420), -- -Unknown- +(41170, 2, 110, 0, 110, -377, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 130905, 130903, 130904, 0, 10, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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 Relic Renewed', 'Observe Brann as he puts the Titan Disc back together.', 'Very good, very good! Now that we have all the pieces, it''s time to put this disc back together!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23420); -- -Unknown- + +UPDATE `quest_template` SET `Flags`=36700160, `VerifiedBuild`=23420 WHERE `ID`=45312; -- -Unknown- +UPDATE `quest_template` SET `Flags`=34603008, `VerifiedBuild`=23420 WHERE `ID`=45304; -- -Unknown- +UPDATE `quest_template` SET `Flags`=34603008, `VerifiedBuild`=23420 WHERE `ID`=45163; -- -Unknown- +UPDATE `quest_template` SET `Flags`=34603008, `VerifiedBuild`=23420 WHERE `ID`=45162; -- -Unknown- +UPDATE `quest_template` SET `Flags`=34603008, `VerifiedBuild`=23420 WHERE `ID`=45111; -- -Unknown- +UPDATE `quest_template` SET `RewardSpell`=237602, `Flags`=2184773888, `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23420 WHERE `ID`=45072; -- -Unknown- +UPDATE `quest_template` SET `RewardSpell`=237602, `Flags`=2184773888, `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23420 WHERE `ID`=45071; -- -Unknown- +UPDATE `quest_template` SET `Flags`=35651904, `VerifiedBuild`=23420 WHERE `ID`=43532; -- -Unknown- +UPDATE `quest_template` SET `LogTitle`='Darkheart Thicket: Through the Fog', `VerifiedBuild`=23420 WHERE `ID`=41169; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=11150, `VerifiedBuild`=23420 WHERE `ID`=37262; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=3400, `VerifiedBuild`=23420 WHERE `ID`=32007; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `RewardFactionValue1`=5, `RewardFactionOverride1`=10000, `VerifiedBuild`=23420 WHERE `ID`=31757; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `RewardFactionValue1`=5, `RewardFactionOverride1`=10000, `VerifiedBuild`=23420 WHERE `ID`=30444; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `RewardFactionValue1`=5, `RewardFactionOverride1`=10000, `VerifiedBuild`=23420 WHERE `ID`=30304; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=30246; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `RewardFactionValue1`=5, `RewardFactionOverride1`=10000, `VerifiedBuild`=23420 WHERE `ID`=30245; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=170, `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23420 WHERE `ID`=26121; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=180, `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23420 WHERE `ID`=24880; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=180, `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23420 WHERE `ID`=24878; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=180, `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23420 WHERE `ID`=24870; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=180, `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23420 WHERE `ID`=13253; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=18875469, `VerifiedBuild`=23420 WHERE `ID`=8929; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=8806; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=8740; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=8737; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=8730; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=8536; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=8352; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=8261; -- -Unknown- +UPDATE `quest_template` SET `RewardMoney`=11000, `RewardMoneyDifficulty`=7, `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=-1, `QuestDescription`='The League of Arathor is sparing no expense in their move to retake Arathi. They, and all the races of the Alliance, now stream to this distant region, intent on expanding their hold from Refuge Pointe. We must stop them, and the best means to stop them is to take their supplies.$B$BYou can help us, $n. Enter Arathi Basin, known for its rich mines, fertile land and skilled craftsman. Capture and control every base you can, win the battle, and return to me with the resources you gain.', `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=8161; -- -Unknown- +UPDATE `quest_template` SET `RewardMoney`=19500, `RewardMoneyDifficulty`=7, `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=-1, `QuestDescription`='War must be fought with soldiers, any soldier will tell you. They''ll also say that a battle fought with poor gear or on an empty stomach is lost before it starts!$B$BThat is why Arathi Basin is important. There are key areas in the basin that hold essential resources. Metals, weapons, food, lumber - all are needed, and all can be gained there.$B$BThat is what I want from you, $n. Enter Arathi Basin, win the battle by holding more bases than the enemy, and return to me with a crate of resources.', `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=8154; -- -Unknown- +UPDATE `quest_template` SET `RewardNextQuest`=13825, `VerifiedBuild`=23420 WHERE `ID`=6612; -- -Unknown- +UPDATE `quest_template` SET `RewardNextQuest`=13825, `VerifiedBuild`=23420 WHERE `ID`=6611; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=6570; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=182850, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=6130; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=45700, `VerifiedBuild`=23420 WHERE `ID`=5646; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestDescription`='$n, you must travel to Dolanaar when your business here in Shadowglen is done. There, you will find Laurna Morninglight. She will instruct you further in the ways of Elune, and it is with her that you will earn your first garments denoting your station as a $gpriest:priestess; of Elune.$B$BTake care, and may you be protected in your journeys.', `VerifiedBuild`=23420 WHERE `ID`=5622; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=5526; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=18350, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=4181; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestDescription`='You engage the Oathstone, and Itharius speaks directly to your mind through the stone.$B$B"By accepting the charge placed in this Oathstone, you agree to aid my cause and the cause of Ysera''s Dragonflight in redeeming the corrupted soul of Eranikus. The first sacrifice, one of many you and I will no doubt make, will be to relinquish the gem to me that has chained what free-willed part of Eranikus'' psyche remains."$B$B"Do this $n, and we will work together to redeem a soul worthy of redemption."', `VerifiedBuild`=23420 WHERE `ID`=3374; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=45700, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=2998; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestDescription`='Around these parts I am known as the Mithril Kid. I supply ornate mithril to adventurers from around the world.$B$B<Trenton whispers.>$B$BLittle do they know that I do not know the technique to fashion ornate mithril gloves. Shhhh! This will be our little secret.$B$BTeach me the technique to create ornate mithril gloves, $n, and in exchange, I will show you the resultant of the culmination of my training under Galvan: the ornate mithril breastplate.', `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=2773; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=2772; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestDescription`='It seems as if master had this planned from the start. I was not taught to create the items which you learned to create and you were not taught the items which I learned to create.$B$BThe master is wise, $n. We shall teach each other!$B$BShow me how to make a mithril coif and ornate mithril shoulders and I shall show you how to create an ornate mithril helm.', `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=2771; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestDescription`='Your focused concentration has dwindled so soon? More research must be done!$B$BOh yes, the price remains the same, $n. Venture forth into the blasted lands and return to me with ten brains from the redstone and two vulture gizzards.\n', `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=2602; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=2501; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=182850, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=1819; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=45700, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=1530; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=91500, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=1529; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=1220; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=1080; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=1016; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=939; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=182850, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=31; -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID` IN (288976 /*288976*/, 287893 /*287893*/, 282176 /*282176*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(288976, 46137, 0, 0, 118825, 1, 0, 0, 0, 'Cut a green gem', 23420), -- 288976 +(287893, 45383, 1, 0, 143658, 4, 0, 1, 0, '', 23420), -- 287893 +(282176, 41170, 0, 0, 103840, 1, 0, 0, 0, 'Observe Brann', 23420); -- 282176 + +UPDATE `quest_objectives` SET `Type`=14, `ObjectID`=57394, `VerifiedBuild`=23420 WHERE `ID`=285584; -- 285584 +UPDATE `quest_objectives` SET `Type`=14, `ObjectID`=57374, `VerifiedBuild`=23420 WHERE `ID`=284723; -- 284723 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=266047; -- 266047 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=265496; -- 265496 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=264481; -- 264481 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=259838; -- 259838 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=260400; -- 260400 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=260399; -- 260399 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=260398; -- 260398 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=252854; -- 252854 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254816; -- 254816 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=260343; -- 260343 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257557; -- 257557 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256140; -- 256140 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=258021; -- 258021 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257580; -- 257580 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257579; -- 257579 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257082; -- 257082 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257004; -- 257004 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257095; -- 257095 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=258439; -- 258439 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=253557; -- 253557 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=253556; -- 253556 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=258075; -- 258075 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257194; -- 257194 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257506; -- 257506 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257192; -- 257192 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257215; -- 257215 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256411; -- 256411 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256984; -- 256984 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256983; -- 256983 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256029; -- 256029 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255860; -- 255860 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257827; -- 257827 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255560; -- 255560 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254891; -- 254891 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254291; -- 254291 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254814; -- 254814 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254813; -- 254813 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254489; -- 254489 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=253927; -- 253927 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=253648; -- 253648 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=253502; -- 253502 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=253475; -- 253475 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255616; -- 255616 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=253509; -- 253509 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=252966; -- 252966 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=252496; -- 252496 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256799; -- 256799 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=251925; -- 251925 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=252286; -- 252286 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=288976 AND `Index`=0) OR (`ID`=282176 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(288976, 0, 4978, 23420), +(282176, 0, 4706, 23420); |