aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorOvahlord <dreadkiller@gmx.de>2025-04-13 14:17:25 +0200
committerOvahlord <dreadkiller@gmx.de>2025-04-13 14:17:25 +0200
commit52d6acaa8e58e4203cf6998a5c49f77808428b1d (patch)
treec3c7d0f4c9ae1a79427be61aea73e10af1bbf3b5 /sql
parentaf21cf92d9bf3e5cbd6b5814d23b4054c48efa93 (diff)
DB/Quests: added more quest data from bruteforcing
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/cata_classic/2025_04_13_00_world.sql39
1 files changed, 39 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2025_04_13_00_world.sql b/sql/updates/world/cata_classic/2025_04_13_00_world.sql
new file mode 100644
index 00000000000..11b1f5b0c1a
--- /dev/null
+++ b/sql/updates/world/cata_classic/2025_04_13_00_world.sql
@@ -0,0 +1,39 @@
+DELETE FROM `quest_template` WHERE `ID` IN (88798 /*Warchief's Command Board*/, 88788 /*Talented*/, 29761 /*Master Pit Fighter*/, 8935 /*Just Compensation*/, 8781 /*Arms for the Field*/, 8496 /*Bandages for the Field*/, 7866 /*Outrider Basic Care Package*/, 6085 /*Taming the Beast*/, 6063 /*Taming the Beast*/, 5861 /*Find Myranda*/, 5654 /*Hex of Weakness*/, 5464 /*Menethil's Gift*/, 3637 /*Gnome Engineering*/, 2863 /*Alpha Strike*/);
+INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestLevel`, `QuestScalingFactionGroup`, `QuestMaxScalingLevel`, `QuestPackageID`, `MinLevel`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `FlagsEx2`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitGiverMount`, `PortraitGiverModelSceneID`, `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`, `Expansion`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES
+(88798, 2, 85, 0, 85, 0, 85, 1637, 0, 0, 0, 1, 1, 0, 1, 453126, 0, 0, 0, 0, 1, 0, 0x2300000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 12261800583900083122, 3, 'Warchief\'s Command Board', 'Use the scroll of teleportation from your inventory to reach Orgrimmar and speak to the Warchief\'s Herald.', 'Warchief Garrosh Hellscream has asked of The Knights of the Ebon Blade to dispatch any and all $C\'s to take arms and aid in the Horde\'s campaigns across Azeroth!\n\nYou are ready, $p.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Warchief's Command Board
+(88788, 2, 85, 0, 85, 0, 85, 4342, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2100008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 224458, 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, 12261800583900083122, 2, 'Talented', 'Activate the Talents interface and allocate 5 Talent Points.', 'Every $C makes use of different abilities, talents and capabilities. We differ from each other in that we have unique interests and inclinations.\n\nWhen you level up in power, you can enhance and specialize your abilities through your talents, without the instruction of a trainer.\n\nIf you change your mind on these talents, you can speak with a $C trainer to rework them.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Talented
+(29761, 0, 85, 0, 255, 0, 85, -364, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x8, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 74035, 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, 18446744073709551615, 0, 'Master Pit Fighter', '', '', '', 'Return to Korgol Crushskull at the Darkmoon Faire.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Master Pit Fighter
+(8935, 2, 60, 0, 255, 0, 58, 1537, 81, 0, 8929, 7, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 22002, 22006, 0, 0, 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, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2098253, 0, 'Just Compensation', 'Bring a Shadowcraft Belt and a set of Shadowcraft Gloves to Deliana in Ironforge.', 'You kept your word and brought the device built by Mux. I believe a reward is in order if I\'m to keep you interested in saving my skin. Bring me the belt and set of gloves that you wish to upgrade. I promise the ones I give you in return will be far superior.', '', 'Return to Deliana at the High Seat in Ironforge.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Just Compensation
+(8781, 2, 56, 0, 255, 0, 54, 1377, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 21260, 0, 1, 0, 0x4100, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 20800, 20805, 0, 0, 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, 609, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 1, 0, 0, 18446744073709551615, 0, 'Arms for the Field', 'Bring 2 Moonsteel Broadswords to Janela Stouthammer at the Ironforge Brigade Outpost outside of Hive\'Zora. You must also bring Logistics Task Briefing VI in order to complete this quest.', 'The Ironforge Brigade has been a worthy ally in our fight in Silithus. Unfortunately, many of their supplies were lost on their way here. Procure a batch of weapons and deliver them to Janela Stouthammer near Hive\'Zora.', '', 'Return to Janela Stouthammer near Hive\'Zora in Silithus.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Arms for the Field
+(8496, 2, 56, 0, 255, 0, 54, 1377, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 20806, 0, 1, 0, 0x4100, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 20800, 20805, 0, 0, 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, 609, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Bandages for the Field', 'Bring 30 Heavy Runecloth Bandages, 30 Heavy Silk Bandages and 30 Heavy Mageweave Bandages to Windcaller Proudhorn at Cenarion Hold in Silithus. You must also bring Logistics Task Briefing X in order to complete this quest.', 'Our supply of bandages in the battlefield is running dangerously low after the recent casualties we have incurred. Obtain a batch of first-aid supplies and deliver them to Windcaller Proudhorn in Cenarion Hold.', '', 'Return to Windcaller Proudhorn at Cenarion Hold in Silithus.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Bandages for the Field
+(7866, 0, 34, 0, 34, 0, 25, 331, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x0, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 19154, 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, 889, 0, 0, 0, 0, 1, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Outrider Basic Care Package', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Outrider Basic Care Package
+(6085, 2, -1, 0, 255, 0, 10, -261, 0, 0, 6086, 5, 1, 0, 1, 1579, 0, 0, 15908, 0, 1, 0, 0x4002, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 18446744073709551615, 0, 'Taming the Beast', 'Use the Taming Rod to tame an Ice Claw Bear. Practice your skills, then return the Taming Rod to Grif Wildheart in Kharanos.', 'Perhaps you\'d like a creature that possesses little more than brute strength. The ice claw bear is an excellent companion for a fledgling hunter like yourself, and can be found east of Kharanos. Here is the taming rod; try this animal as a pet and see if ya like it!$B$BWhen you return, I\'ll give ya the skills you will need to tame an animal of your choosing; this creature will face the challenges you face, and gain experience alongside you. I will also show you how to call it and dismiss it as ya like.\n', 'Tame an Ice Claw Bear', 'Return to Grif Wildheart at Kharanos in Dun Morogh.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Taming the Beast
+(6063, 2, -1, 0, 255, 0, 10, -261, 0, 0, 6101, 5, 1, 0, 1, 0, 0, 0, 15921, 0, 1, 0, 0x4002, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 8, 0, 'Taming the Beast', 'Use the Taming Rod to tame a Webwood Lurker. Practice your skills, then return the Taming Rod to Dazalar in Dolanaar.', 'As a hunter, it is important to remember the responsibility you hold in your hands. Nature is not a power that can be bent to obey our desires; it is one that is to be respected and acknowledged as something stronger than your very existence.$B$B$N, you must prove your understanding of this before you will gain the ability to tame an animal to be your companion.$B$BYour first task is to take this taming rod. With it, you will be able to tame a webwood lurker. Tame it, and practice your skills as a hunter.', 'Tame a Webwood Lurker', 'Return to Dazalar at Dolanaar in Teldrassil.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Taming the Beast
+(5861, 2, 60, 0, 255, 0, 52, 28, 0, 0, 5862, 4, 1, 0, 1, 0, 0, 0, 14872, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 18446744073709551615, 0, 'Find Myranda', 'Travel to Uther\'s Tomb, located in the southern Plaguelands. Show Myranda the Hag Tirion\'s Gift.', '$N, you have done all that I have asked thus far. Only one step remains in your quest of redemption.$B$BYou must deliver the items you have collected to Taelan. Unfortunately, Taelan and his Scarlet Crusaders will attack you on sight.$B$BThere is only one way in which to deliver my message and that is through a guise of deception.$B$BTo the south you will find Uther\'s tomb. An old and trusted confidant of mine, Myranda, now resides there - seek her out. Show her the items and she will assist you.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Find Myranda
+(5654, 2, -1, 0, 255, 0, 10, -262, 0, 0, 0, 2, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 128, 0, 'Hex of Weakness', 'Speak to Ur\'kyo in Orgrimmar.', 'It be time for you to meet with Ur\'kyo, $N. He be in the Valley of Spirits in the orc city. Go there and speak to him. It is time you learn more of the old ways of our kind. It time you be brought into the circle and made a true priest of our tribe.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Hex of Weakness
+(5464, 2, 60, 0, 255, 0, 57, 139, 1, 0, 5465, 6, 1, 0, 1, 0, 0, 0, 13624, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 529, 0, 0, 0, 0, 6, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Menethil\'s Gift', 'Take the Soulbound Keepsake to Leonid Barthalomew in Eastern Plaguelands.', 'The soul of the fallen clings to that which represents its former life and transforms the item into a soulbound keepsake. You pick the item up and place it in your pack.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Menethil's Gift
+(3637, 2, -1, 0, 255, 0, 10, -201, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 10789, 0, 1, 0, 0x44000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 946, 0, 'Gnome Engineering', 'If you wish to learn more about Gnome Engineering, take the Manual of Engineering Disciplines to Oglethorpe Obnoticus in Booty Bay.', 'Engineering at the expert level breaks into two disciplines: gnome and goblin. While I think it is a waste, you should be aware of gnome specialization. They make items and gadgets that claim to change the world, but rarely work.$B$B$N, read this manual. If you wish to learn how to make metal paper weights, then take the manual to Oglethorpe Obnoticus in Booty Bay. Remember - membership is permanent and prevents joining the other discipline, so make sure you are sure before finishing his task.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192), -- Gnome Engineering
+(2863, 2, 43, 0, 255, 0, 39, 357, 0, 0, 2902, 4, 1, 4, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 4, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 3600, 18446744073709551615, 0, 'Alpha Strike', 'Kill 5 Woodpaw Alphas and return to Hadoken Swiftstrider within one hour.', 'The plan is for various leaders of the gnolls - Alphas as they call themselves - to be taken down within rapid succession. If we\'re able to execute this sort of swift and precise devastation against them, it would cause chaos in their ranks. Perhaps it would also drive a message through their thick flea-bitten heads that we can and will destroy them!$B$BI want you to be the messenger of my will; eliminate five of their Alphas within one hour for this to work $N, or we\'ll remain at this impasse!', '', 'Return to Hadoken Swiftstrider at Camp Mojache in Feralas.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60192); -- Alpha Strike
+
+DELETE FROM `quest_objectives` WHERE `ID` IN (443163 /*443163*/, 381821 /*381821*/, 382209 /*382209*/, 382481 /*382481*/, 382918 /*382918*/, 383524 /*383524*/, 383968 /*383968*/, 384172 /*384172*/, 384173 /*384173*/, 384251 /*384251*/, 384252 /*384252*/, 384253 /*384253*/, 384254 /*384254*/, 385117 /*385117*/, 385118 /*385118*/, 459102 /*459102*/);
+INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `Order`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES
+(443163, 29761, 1, 0, 0, 74034, 12, 0, 0, 0, '', 60192), -- 443163
+(381821, 5464, 1, 0, 0, 13624, 1, 0, 1, 0, '', 60192), -- 381821
+(382209, 2863, 0, 0, 0, 5258, 5, 0, 0, 0, '', 60192), -- 382209
+(382481, 3637, 1, 0, 0, 10789, 1, 0, 1, 0, '', 60192), -- 382481
+(382918, 6063, 1, 0, 0, 15921, 1, 0, 1, 0, '', 60192), -- 382918
+(383524, 5861, 1, 0, 0, 14872, 1, 0, 1, 0, '', 60192), -- 383524
+(383968, 6085, 1, 0, 0, 15908, 1, 0, 1, 0, '', 60192), -- 383968
+(384172, 8935, 1, 0, 0, 16713, 1, 0, 0, 0, '', 60192), -- 384172
+(384173, 8935, 1, 1, 1, 16712, 1, 0, 0, 0, '', 60192), -- 384173
+(384251, 8496, 1, 0, 0, 14530, 30, 0, 0, 0, '', 60192), -- 384251
+(384252, 8496, 1, 1, 1, 8545, 30, 0, 0, 0, '', 60192), -- 384252
+(384253, 8496, 1, 2, 2, 6451, 30, 0, 0, 0, '', 60192), -- 384253
+(384254, 8496, 1, 3, 3, 20806, 1, 0, 0, 0, '', 60192), -- 384254
+(385117, 8781, 1, 0, 0, 3853, 2, 0, 0, 0, '', 60192), -- 385117
+(385118, 8781, 1, 1, 1, 21260, 1, 0, 0, 0, '', 60192), -- 385118
+(459102, 88788, 14, 0, 0, 207726, 1, 0, 0, 0, '', 60192); -- 459102
+
+DELETE FROM `quest_reward_display_spell` WHERE (`QuestID`=6085 AND `Idx`=0);
+INSERT INTO `quest_reward_display_spell` (`QuestID`, `Idx`, `SpellID`, `VerifiedBuild`) VALUES
+(6085, 0, 23356, 60192);