diff options
| -rw-r--r-- | sql/updates/hotfixes/master/2023_07_28_00_hotfixes.sql | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/master/2023_07_28_00_hotfixes.sql b/sql/updates/hotfixes/master/2023_07_28_00_hotfixes.sql new file mode 100644 index 00000000000..0dd113606b9 --- /dev/null +++ b/sql/updates/hotfixes/master/2023_07_28_00_hotfixes.sql @@ -0,0 +1,33 @@ +DELETE FROM `broadcast_text` WHERE `ID` IN (244772, 243667, 243666, 243665, 242759, 242721, 242720, 242719, 242718, 242717, 242716, 242715, 242244, 239743, 239742, 238872, 238871, 238140, 237532, 237531, 237453, 237452, 237451, 237428, 237427, 237422, 227006, 227003, 226959, 211868); +INSERT INTO `broadcast_text` (`Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `VoiceOverPriorityID`, `SoundKitID1`, `SoundKitID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES +('Greetings, traveler. If you come to trade in peace, you are welcome here.', '', 244772, 0, 0, 1, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 50585), +('', '... can I summon my demon now?', 243667, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 50585), +('', 'Here here!', 243666, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 50585), +('Well said.', '', 243665, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 50585), +('Hullo, friend. Anything I can do ya\' for?', '', 242759, 0, 0, 0, 0, 0, 4, 0, 0, 669, 0, 0, 0, 0, 0, 50585), +('... but are the inheritance of those with the strength to claim them.', '', 242721, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 50585), +('But I will spread the word. That these powers of ours need not be begged for...', '', 242720, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 50585), +('About fel.', '', 242719, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 50585), +('About the Light.', '', 242718, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 50585), +('About myself.', '', 242717, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 50585), +('I still have much to learn.', '', 242716, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 50585), +('You have been a good mentor, for as much as that is worth in our circles.', '', 242715, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 50585), +('<Senegos snoozes. The little island rumbles from his snores.>', '', 242244, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 50585), +('I appreciate the literal approach, soldier. Good work.', '', 239743, 0, 0, 0, 0, 0, 4, 223737, 0, 0, 0, 0, 0, 0, 0, 50585), +('These shadowflame elementals are threatening to spread their taint to the caverns at large. Stamp them out!', '', 239742, 0, 0, 0, 0, 0, 4, 223746, 0, 0, 0, 0, 0, 0, 0, 50585), +('We request your assistance in cleansing the sulfur river. Put these creatures to rest.', '', 238872, 0, 0, 0, 0, 0, 4, 223751, 0, 0, 0, 0, 0, 0, 0, 50585), +('A disgusting remnant of our past. Thank you for helping put them to rest.', '', 238871, 0, 0, 0, 0, 0, 4, 223732, 0, 0, 0, 0, 0, 0, 0, 50585), +('Hermit Yarren knows the best sniffing mice. I bet if you borrow one from him, you\'ll be able to find some good smellies!', '', 238140, 0, 0, 1, 0, 0, 4, 223595, 0, 0, 0, 0, 0, 0, 0, 50585), +('It is concerning that even within time being frozen, an agent of the Old Gods could still make their way to us.\n\nNo matter. You now have the power of this artifact in your hands. \n\nWe are done here.', '', 237532, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 50585), +('It is done. That artifact represents the beginning of a new legacy for the dracthyr.', '', 237531, 0, 0, 0, 0, 0, 4, 222835, 0, 0, 0, 0, 0, 0, 0, 50585), +('Let us hope that was the last agent of the Old Gods. Try once more to extract the essence.', '', 237453, 0, 0, 0, 0, 0, 4, 222834, 0, 0, 0, 0, 0, 0, 0, 50585), +('An agent of the Old Gods! Their hold on my brother remains in his final moments.', '', 237452, 0, 0, 0, 0, 0, 4, 222833, 0, 0, 0, 0, 0, 0, 0, 50585), +('Brace yourself... something else has emerged from Deathwing!', '', 237451, 0, 0, 0, 0, 0, 4, 222832, 0, 0, 0, 0, 0, 0, 0, 50585), +('Approach the cliff and use the gauntlet to pull the last of his essence out.', '', 237428, 0, 0, 0, 0, 0, 4, 222831, 0, 0, 0, 0, 0, 0, 0, 50585), +('There he is. Deathwing as he was just before he died. But there is still a bit of Neltharion left.', '', 237427, 0, 0, 0, 0, 0, 4, 222830, 0, 0, 0, 0, 0, 0, 0, 50585), +('I have returned to this moment innumerable times. Was there a way this could have been avoided? Could we have done something differently?\n\nMore important to our current task... was there a way that Neltharion\'s legacy could be redeemed?\n\nWe shall find out. Speak to me when you are ready. I shall have to focus all my energies to bring what I can to this moment.', '', 237422, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 50585), +('Bromach wins!', '', 227006, 0, 0, 0, 0, 0, 4, 203188, 0, 0, 0, 0, 0, 0, 0, 50585), +('Smooshed!', '', 227003, 0, 0, 0, 0, 0, 4, 203186, 0, 0, 0, 0, 0, 0, 0, 50585), +('', 'I will protect the keeper\'s secrets for all of time.', 226959, 0, 0, 0, 0, 0, 3, 0, 203216, 0, 0, 0, 0, 0, 0, 50585), +('', 'We cannot lose hope, even in the darkest moments. That is when we need it the most.', 211868, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50585); + |