diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2022_03_25_00_world.sql | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2022_03_25_00_world.sql b/sql/updates/world/3.3.5/2022_03_25_00_world.sql new file mode 100644 index 00000000000..f8e9df07ecd --- /dev/null +++ b/sql/updates/world/3.3.5/2022_03_25_00_world.sql @@ -0,0 +1,38 @@ +-- Battle Of Mount Hyjal missing optionid +DELETE FROM `gossip_menu_option` WHERE `MenuID`=7552 AND `OptionID` IN (0,1,2); +DELETE FROM `gossip_menu_option` WHERE `MenuID`=7581 AND `OptionID` IN (0,1,2); +DELETE FROM `gossip_menu_option` WHERE `MenuID`=7706 AND `OptionID`=0; +INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(7552, 0, 0, 'My companions and I are with you, Lady Proudmoore.', 14698, 0, 0, 7556, 0, 0, 0, NULL, 0, 26365), +(7552, 1, 0, 'We are ready for whatever Archimonde might send our way, Lady Proudmoore.', 15393, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(7552, 2, 0, 'Until we meet again, Lady Proudmoore.', 15416, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(7581, 0, 0, 'We have nothing to fear.', 15445, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(7581, 1, 0, 'I am with you, Thrall.', 14875, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(7581, 2, 0, 'Until we meet again, Thrall.', 15449, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(7706, 0, 0, 'I would be grateful for any aid you can provide, Priestess.', 20242, 0, 0, 0, 0, 0, 0, NULL, 0, 0); + +-- Karazhan missing optionid +DELETE FROM `gossip_menu_option` WHERE `MenuID`=7421 AND `OptionID`=0; +DELETE FROM `gossip_menu_option` WHERE `MenuID`=7422 AND `OptionID`=0; +INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(7421, 0, 0, 'I\'m not an actor.', 14052, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(7422, 0, 0, 'Ok, I\'ll give it a try, then.', 14054, 0, 0, 0, 0, 0, 0, NULL, 0, 0); + +-- HallsOfStone missing optionid +DELETE FROM `gossip_menu_option` WHERE `MenuID`=9670 AND `OptionID`=0; +INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(9670, 0, 0, 'Let\'s move Brann, enough of the history lesson!', 27616, 0, 0, 0, 0, 0, 0, NULL, 0, 0); + +-- Karazhan Image of Medivh (17651) and Image of Arcanagos (17652) missing creature text +DELETE FROM `creature_text` WHERE `CreatureID` IN (17651,17652); +INSERT INTO `creature_text`(`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(17651, 0, 0, "You've got my attention, dragon. You'll find I'm not as easily scared as the villagers below.", 14, 0, 100, 0, 0, 0, 14295, 0, 'Image of Medivh'), +(17651, 1, 0, "You dare challenge me at my own dwelling? Your arrogance is astounding, even for a dragon!", 14, 0, 100, 0, 0, 0, 14297, 0, 'Image of Medivh'), +(17651, 2, 0, "I do not know what you speak of, dragon... but I will not be bullied by this display of insolence. I'll leave Karazhan when it suits me!", 14, 0, 100, 0, 0, 0, 14299, 0, 'Image of Medivh'), +(17651, 3, 0, "%s begins to cast a spell of great power, weaving his own essence into the magic.", 16, 0, 100, 0, 0, 0, 14308, 0, 'Image of Medivh'), +(17651, 4, 0, "He should not have angered me. I must go... recover my strength now...", 12, 0, 100, 0, 0, 0, 14316, 0, 'Image of Medivh'), + +(17652, 0, 0, "Your dabbling in the arcane has gone too far, Medivh. You've attracted the attention of powers beyond your understanding. You must leave Karazhan at once!", 14, 0, 100, 0, 0, 0, 14296, 0, 'Image of Arcanagos'), +(17652, 1, 0, "A dark power seeks to use you, Medivh! If you stay, dire days will follow. You must hurry, we don't have much time!", 14, 0, 100, 0, 0, 0, 14298, 0, 'Image of Arcanagos'), +(17652, 2, 0, "You leave me no alternative. I will stop you by force if you won't listen to reason!", 14, 0, 100, 0, 0, 0, 14300, 0, 'Image of Arcanagos'), +(17652, 3, 0, "What have you done, wizard? This cannot be! I'm burning from... within!", 14, 0, 100, 0, 0, 0, 14294, 0, 'Image of Arcanagos'); |