diff options
author | ModoX <moardox@gmail.com> | 2022-02-27 18:57:23 +0100 |
---|---|---|
committer | ModoX <moardox@gmail.com> | 2022-02-27 18:57:58 +0100 |
commit | 831d282eaff21513473d9a31d5b322b7423bb065 (patch) | |
tree | 5cbd3b9114571f1176b083e1444744eb62560a62 | |
parent | 2bf0517e6231eadd2f31a8feb7b9bb6c63f91c7a (diff) |
DB/Hotfixes: Added massparsed 9.0.2-9.2.0 broadcast_text data
5 files changed, 249 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/master/2022_02_27_11_hotfixes_902.sql b/sql/updates/hotfixes/master/2022_02_27_11_hotfixes_902.sql new file mode 100644 index 00000000000..4650b6c4722 --- /dev/null +++ b/sql/updates/hotfixes/master/2022_02_27_11_hotfixes_902.sql @@ -0,0 +1,143 @@ +-- +DELETE FROM `broadcast_text` WHERE `ID` IN (205207, 205211, 205206, 197340, 197339, 184159, 184144, 197697, 197696, 205208, 202246, 196816, 197703, 197702, 201411, 205984, 201420, 199403, 199402, 205985, 205979, 205977, 203180, 197763, 202776, 202463, 204159, 204158, 202656, 205564, 205565, 202459, 205121, 202458, 202455, 202456, 202454, 202453, 202652, 202446, 202448, 200585, 202443, 202445, 202651, 202737, 200125, 202442, 197871, 200030, 204829, 198032, 197828, 201415, 201414, 195389, 200023, 194411, 194276, 199944, 194280, 194268, 194295, 194313, 194298, 194340, 194344, 194342, 199935, 194379, 201398, 201397, 201403, 201399, 201404, 201402, 201400, 201401, 201309, 201313, 201312, 201310, 201311, 201306, 201307, 201308, 205740, 205749, 205744, 201315, 201316, 201318, 201314, 201317, 201319, 201320, 200089, 200088, 195169, 197790, 205986, 205980, 205773, 205723, 199607, 205718, 205739, 204156, 202464, 202777, 204157, 204555, 202461, 205120, 205562, 205563, 202715, 202716, 202718, 202719, 202717, 202723, 202724, 202726, 202722, 202721, 202720, 202708, 202707, 202705, 202704, 202712, 202702, 202713, 205081, 202714, 205080, 202703, 196006); +INSERT INTO `broadcast_text` (`Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `VoiceOverPriorityID`, `SoundKitID1`, `SoundKitID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES +('', 'Yeah, a huge one! It crawled out of the ground right under my furniture. I guess the egg must have some sort of scent because the Gorm ignored everything else, it just grabbed the egg and swallowed it.\n\nUnless you have an extremely keen sense of smell, good luck ever finding the thing. You might as well let the Broker know that his precious bauble is gone.\n\nNow, if you will excuse me, I have to get back to wallowing in my misery.', 205207, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 37176), +('I\'ve just the item that could help. Check my inventory.', '', 205211, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 37176), +('', 'I guess you\'re here to collect for that Broker, huh?\n\nYou\'re too late, a damned gorm ate it.', 205206, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 37176), +('', 'We\'ll relocate the cocoons to the groves that need them. Thank you for restoring the balance.', 197340, 0, 0, 0, 0, 0, 0, 0, 162902, 0, 0, 0, 0, 0, 0, 36949), +('', 'The moth cocoons in Shimmerbough are growing out of control! Can you help collect them from the treetops?', 197339, 0, 0, 0, 0, 0, 0, 0, 162901, 0, 0, 0, 0, 0, 0, 36949), +('', 'These creatures once served as a defense against intruders. A pity that they, too, must fall.', 184159, 0, 0, 0, 0, 0, 0, 0, 167559, 0, 0, 0, 0, 0, 0, 36949), +('', 'The local fauna has grown feral and hostile since the fall of my house. Slay the beasts and aid the Eyes.', 184144, 0, 0, 0, 0, 0, 0, 0, 167558, 0, 0, 0, 0, 0, 0, 36949), +('', 'Today, you have proven that we will not give in to doubt. Bastion will never surrender!', 197697, 0, 0, 1, 0, 0, 0, 0, 164329, 0, 0, 0, 0, 0, 0, 36839), +('', 'The forsworn have fortified this area with their most adept warriors. Strike them down, courage be with you!', 197696, 0, 0, 1, 0, 0, 0, 0, 164328, 0, 0, 0, 0, 0, 0, 36839), +('', 'You were able to find it? \nWell, good for you. \n\nKnow what? You deserve something...\n\n<Tabithia makes an exaggeratedly slow, single clap.>\n\nThere, now go away! I\'m kind of busy here, you know... in the wreckage of my house.', 205208, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36753), +('', 'The power in these relics pales in comparison to the weapon that awaits us ahead.', 202246, 0, 0, 1, 0, 0, 0, 0, 161578, 0, 0, 0, 0, 0, 0, 36839), +('', 'We must not allow the cold to deter our efforts. Seek warmth among allies, champion.', 196816, 0, 0, 0, 0, 0, 0, 0, 161171, 0, 0, 0, 0, 0, 0, 36710), +('Oblivion is too kind of fate for betraying Krexus. Thank you for delivering justice.', '', 197703, 0, 0, 0, 0, 0, 0, 164942, 0, 0, 0, 0, 0, 0, 0, 36753), +('The traitors from my former house maintain a stronghold here. Bring them all to ruin.', '', 197702, 0, 0, 0, 0, 0, 0, 164941, 0, 0, 0, 0, 0, 0, 0, 36753), +('The Argent Crusade stands ready.\n\nOur enemies will fall.', 'The Argent Crusade stands ready.\n\nOur enemies will fall.', 201411, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('Suffer well, $c.\n\nAnd know that the Scourge will suffer only defeat.', 'Suffer well, $c.\n\nAnd know that the Scourge will suffer only defeat.', 205984, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('We\'ve established camps throughout the area to keep a watchful eye on the Scourge\'s movements.', '', 201420, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('This is the Ember Ward! Where is anything when you need it?\n\nLook around, I am sure there is one not too far off. Check the other cages.', '', 199403, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 36949), +('Of course, the treasure. I suppose that is why you are bothering me, yes?\n\nI shall offer you the same deal I offer all unscrupulous treasure hunters: Bring me a book, get a treasure.\n\nI warn you, however, that I am a very discerning reader.', '', 199402, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 36949), +('The Scourge will always have the upper hand against the living. Their hunger only strengthens them. They never tire, they never relent, and they never surrender.\n\nNeither does the Ebon Blade.', 'The Scourge will always have the upper hand against the living. Their hunger only strengthens them. They never tire, they never relent, and they never surrender.\n\nNeither does the Ebon Blade.', 205985, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36671), +('The Knights of the Silver Hand, the Argent Dawn, the Argent Crusade... \n\nNo matter the name of the order, our purpose is clear. We defend Azeroth against the evils that would destroy it.', 'The Knights of the Silver Hand, the Argent Dawn, the Argent Crusade... \n\nNo matter our name, our purpose is clear. We defend Azeroth against the evils that would destroy it.', 205979, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36671), +('So long as the Scourge remains a threat, the Argent Crusade will rise to vanquish them.', 'So long as the Scourge remains a threat, the Argent Crusade will rise to vanquish them.', 205977, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36671), +('', 'The matter is of a... sensitive nature. Further details will be provided when you arrive. Please, do not delay.', 203180, 0, 0, 0, 0, 0, 0, 0, 162747, 0, 0, 0, 0, 0, 0, 36671), +('', 'Champion, the Regent Lord requests your immediate presence in Orgrimmar.', 197763, 0, 0, 0, 0, 0, 0, 0, 161178, 0, 0, 0, 0, 0, 0, 36671), +('I will not rest until they are found. Work with our allies to keep the Scourge at bay. We cannot allow that menace to overrun our kingdoms.', '', 202776, 0, 0, 1, 0, 0, 0, 164710, 0, 0, 0, 0, 0, 0, 0, 36710), +('No sign of Anduin or Jaina. If they aren\'t being held in Icecrown, it can only mean that the Banshee has taken them into the realms of Death.', '', 202463, 0, 0, 1, 0, 0, 0, 164709, 0, 0, 0, 0, 0, 0, 0, 36710), +('When the hour comes, we will call upon you to face the darkness... and bring our allies home.', '', 204159, 0, 0, 1, 0, 0, 0, 164712, 0, 0, 0, 0, 0, 0, 0, 36710), +('I\'ll send word to the Knights of the Ebon Blade. If anyone can devise a strategy to rescue our friends, it\'s Bolvar Fordragon.', '', 204158, 0, 0, 1, 0, 0, 0, 164711, 0, 0, 0, 0, 0, 0, 0, 36710), +('Can I help you?', 'Can I help you?', 202656, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'Well fought, $p.', 205564, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'Let us return with word of this creature\'s defeat.', 205565, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'The darkness comes...', 202459, 0, 0, 0, 0, 0, 0, 0, 162289, 0, 0, 0, 0, 0, 0, 36710), +('', 'In the name of the Light!', 205121, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'Fate is upon you, mortal.', 202458, 0, 0, 397, 0, 0, 0, 0, 162288, 0, 0, 0, 0, 0, 0, 36710), +('', 'Tread carefully, $n. We do not fully understand the power of this being.', 202455, 0, 0, 0, 0, 0, 0, 0, 161806, 0, 0, 0, 0, 0, 0, 36710), +('', 'When the time is right, signal our allies and we shall bring this monster down together.', 202456, 0, 0, 0, 0, 0, 0, 0, 161807, 0, 0, 0, 0, 0, 0, 36710), +('', 'Yes. You will make a fitting prize.', 202454, 0, 0, 0, 0, 0, 0, 0, 162287, 0, 0, 0, 0, 0, 0, 36710), +('', 'You show promise... like the others.', 202453, 0, 0, 0, 0, 0, 0, 0, 162286, 0, 0, 0, 0, 0, 0, 36710), +('', 'Death will be the only power that remains!', 202652, 0, 0, 0, 0, 0, 0, 0, 162285, 0, 0, 0, 0, 0, 0, 36710), +('', 'Ah, another defiant soul.', 202446, 0, 0, 0, 0, 0, 0, 0, 162283, 0, 0, 0, 0, 0, 0, 36710), +('', 'In time, you too will serve the Banished One.', 202448, 0, 0, 0, 0, 0, 0, 0, 162284, 0, 0, 0, 0, 0, 0, 36710), +('', 'If we fail to prevent the spread of the Scourge this camp may be lost. Do what you can to buy us time.', 200585, 0, 0, 1, 0, 0, 0, 0, 161151, 0, 0, 0, 0, 0, 0, 36710), +('', 'His power rising... his chains broken. The remaking has begun!', 202443, 0, 0, 0, 0, 0, 0, 0, 162280, 0, 0, 0, 0, 0, 0, 36710), +('', 'The hour draws near when the Banished One shall reclaim what is his.', 202445, 0, 0, 0, 0, 0, 0, 0, 162281, 0, 0, 0, 0, 0, 0, 36710), +('', 'Make ready! Feed the lives of the unworthy to the hungering Maw!', 202651, 0, 0, 0, 0, 0, 0, 0, 162282, 0, 0, 0, 0, 0, 0, 36710), +('', 'Death comes for the soul of this world.', 202737, 0, 0, 0, 0, 0, 0, 0, 162311, 0, 0, 0, 0, 0, 0, 36710), +('', 'We stand together.', 200125, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'Excellent work. Continue the investigations. We will see to this at once.', 202442, 0, 0, 0, 0, 0, 0, 0, 161805, 0, 0, 0, 0, 0, 0, 36710), +('', 'Let\'s get moving.', 197871, 0, 0, 0, 0, 0, 0, 0, 161138, 0, 0, 0, 0, 0, 0, 36710), +('', 'There is still much to be done, $n. Crusader Renn here will assist you in your next endeavors.', 200030, 0, 0, 1, 0, 0, 0, 0, 161137, 0, 0, 0, 0, 0, 0, 36710), +('You\'re lookin\' at the best, furthest reaching surveillance device this side of the snow!\n\nLook no further than the Sight-O-Matic 3000... and one!', '', 204829, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'If we continue to delay our opportunity may be lost.', 198032, 0, 0, 0, 0, 0, 0, 0, 161136, 0, 0, 0, 0, 0, 0, 36710), +('', 'Forgive me, but I believe that to be antiquated thinking, Justicar. We must act now, before it is too late.', 197828, 0, 0, 0, 0, 0, 0, 0, 161135, 0, 0, 0, 0, 0, 0, 36710), +('The Cult of the Damned have always strived for immortality, and see undeath as the means to achieve it.\n\nWith the return of the Scourge, it is no surprise that these fanatics now seek to continue their twisted work and consign us all to the grim fate that befell Lordaeron.\n\nTheir actions are driven by a sense of dark purpose, one that can be wielded as a weapon by the right leader. The question we should be asking is not why the Cult has returned, but rather who is behind their efforts.', '', 201415, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('We do not yet know the reason behind the Scourge\'s return. I suspect the guidance of an unseen hand.\n\nWho that could be, I cannot say for sure... but we\'ll have our answers soon enough.', '', 201414, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', '<The courier nods silently.>', 195389, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('...and I will reassure the justicar she has our full support. Our reinforcements will be arriving shortly.', '', 200023, 0, 0, 669, 0, 0, 0, 160910, 0, 0, 0, 0, 0, 0, 0, 36710), +('Our allies will remain here in Darkshire until the Scourge forces are no more.', '', 194411, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('If you don\'t need to be here, it\'s best you don\'t stick around.', '', 194276, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('You should check up on Vernon in Darkshire. If it\'s this bad here, I can\'t imagine what his forces must be facing.', '', 199944, 0, 0, 669, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('What? Gather the reports?\n\nOur courier should have reached Stormwind long before now!', '', 194280, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('<Guard Captain Fairbanks raises his weapon, aiming it threateningly in your direction.>\n\nYou...!\n\nNever sneak up on me like that again! I could have killed you!\n\nWhat are you doing here? It\'s not safe!', '', 194268, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'Our patrols are doing their best to keep the area safe.\n\nTravel with caution.', 194295, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'The Scourge\'s presence continues to grow. Without proper reinforcements, Stormwind may soon be under siege.\n\nDeliver this report. Inform Gregor that the situation is more dire than we anticipated.', 194313, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', '<Guard Captain Josephine scans the surrounding area.>\n\nSpeak quickly.', 194298, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'The Scourge will be dealt with in due time.\n\nDo not hesitate to ask should you be in need of assistance.', 194340, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'Our patrols report outbreaks of Scourge activity to the east. Our forces are shaken, but holding the line.\n\nI sent a scout to speak with Guard Captain Josephine in Redridge. They have yet to return.', 194344, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'We must remain vigilant against the Scourge.', 194342, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('And make sure you bring Lieutenant Vernon up to speed before you return. He will be awaiting your initial reports in Darkshire.', '', 199935, 0, 0, 669, 0, 0, 0, 160911, 0, 0, 0, 0, 0, 0, 0, 36710), +('We have dispatched our forces throughout the area to watch for any signs of the Scourge.', '', 194379, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('It\'s not that simple, Taelia. Your father was presumed lost at the Wrathgate. It wasn\'t until later that we learned the truth.', '', 201398, 0, 0, 1, 0, 0, 0, 160295, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'All this time you knew my father was alive, but you didn\'t tell me?!', 201397, 0, 0, 5, 0, 0, 0, 0, 160294, 0, 0, 0, 0, 0, 0, 36710), +('Please forgive us, Taelia. We honestly believed he was a casualty of war. That Bolvar Fordragon was truly gone, to be forevermore the Lich King.', '', 201403, 0, 0, 1, 0, 0, 0, 160300, 0, 0, 0, 0, 0, 0, 0, 36710), +('Dragon\'s flame had saved his life, but scarred his flesh. And in an act of vengeance, Arthas Menethil captured and tormented him.', '', 201399, 0, 0, 1, 0, 0, 0, 160296, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'Well, you were wrong. Now I know my father is alive, free from that damned helm. And no matter what it takes, I will go to his side.', 201404, 0, 0, 1, 0, 0, 0, 0, 160301, 0, 0, 0, 0, 0, 0, 36710), +('', '\"We\"? Anduin knew too, didn\'t he? The king told me story after story about my father as if he were some long-dead hero of the past. But the whole time, Anduin hid the truth.', 201402, 0, 0, 1, 0, 0, 0, 0, 160299, 0, 0, 0, 0, 0, 0, 36710), +('When the Lich King was defeated, someone had to take up the mantle and keep the Scourge in check. Your father assumed that burden, knowing it would cost him everything.', '', 201400, 0, 0, 1, 0, 0, 0, 160297, 0, 0, 0, 0, 0, 0, 0, 36710), +('Tirion Fordring swore to keep Bolvar\'s choice a secret. He made us take the same vow. We believed that knowing his fate would only bring you pain.', '', 201401, 0, 0, 1, 0, 0, 0, 160298, 0, 0, 0, 0, 0, 0, 0, 36710), +('Still, we need you in the throne room. There are matters of state that must be overseen until the king\'s return.', '', 201309, 0, 0, 1, 0, 0, 0, 160219, 0, 0, 0, 0, 0, 0, 0, 36710), +('Yes, your majesty.', '', 201313, 0, 0, 273, 0, 0, 0, 160223, 0, 0, 0, 0, 0, 0, 0, 36710), +('You and Turalyon need to safeguard our citizens from the return of the Scourge. I need to focus on doing whatever I can to find Anduin and the others.', '', 201312, 0, 0, 1, 0, 0, 0, 160222, 0, 0, 0, 0, 0, 0, 0, 36710), +('Anduin entrusted Turalyon with command of our military forces. The Stormwind nobles support him serving as regent and protector of the realm.', '', 201310, 0, 0, 1, 0, 0, 0, 160220, 0, 0, 0, 0, 0, 0, 0, 36710), +('I don\'t question the High Exarch\'s ability to defend the Alliance. But as a king yourself, don\'t you think you should--', '', 201311, 0, 0, 0, 0, 0, 0, 160221, 0, 0, 0, 0, 0, 0, 0, 36710), +('King Greymane, you shouldn\'t remain out in the open like this. You\'re too tempting a target.', '', 201306, 0, 0, 1, 0, 0, 0, 160216, 0, 0, 0, 0, 0, 0, 0, 36710), +('If Sylvanas had wished to capture me, she would have done so along with Anduin.', '', 201307, 0, 0, 1, 0, 0, 0, 160217, 0, 0, 0, 0, 0, 0, 0, 36710), +('No. She wanted to leave me behind. To torment me with the loss of yet another... of our king.', '', 201308, 0, 0, 274, 0, 0, 0, 160218, 0, 0, 0, 0, 0, 0, 0, 36710), +('The king was taken on my watch. I should\'ve had more agents assigned to him. This is what happens when I let my guard down. When I allow my--\n\n<Shaw takes a deep breath.>\n\nNo, damn it. This was her doing. I won\'t blame myself for finding happiness. Anduin would be the first to tell me that.\n\nWe\'re going to find him. The others, too. Whatever it takes.', '', 205740, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 2000, 0, 36710), +('', 'It seems my mother was the only target who avoided capture.\n\nI should give thanks to Elune for such a blessing.\n\n<Shandris\'s brow furrows.>\n\nYes, my minn\'do laid waste to the dark manifestations the Banshee sent for her. But the power she displayed, the ferocity she unleashed, something about it was... troubling.\n\nShe knew there was a price to be paid for undertaking the ritual of the Night Warrior. With each day that passes, I fear the price will come due.', 205749, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 2000, 0, 36710), +('', 'I was at the Lord Admiral\'s side when those monsters came for her.\n\nThey struck fast. She could hardly cast a spell before their chains enveloped her. She fought all she could, but it wasn\'t enough.\n\nI... I couldn\'t stop them.\n\nBut by the tides, I swear I\'ll see this through. No matter where I have to go, or what I have to face.', 205744, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 2000, 0, 36710), +('The Ebon Blade has extracted the Lich... the Highlord from the battle in Icecrown. He is recovering in Acherus.', '', 201315, 0, 0, 1, 0, 0, 0, 160227, 0, 0, 0, 0, 0, 0, 0, 36710), +('I pray he can help us find answers. Without that cursed helm, the Scourge are running rampant.', '', 201316, 0, 0, 1, 0, 0, 0, 160228, 0, 0, 0, 0, 0, 0, 0, 36710), +('If anyone can figure out how this all fits together, it\'s Bolvar.', '', 201318, 0, 0, 273, 0, 0, 0, 160230, 0, 0, 0, 0, 0, 0, 0, 36710), +('We\'ll get them back, Taelia. I swear to you, we\'ll save them all.', '', 201314, 0, 0, 5, 0, 0, 0, 160226, 0, 0, 0, 0, 0, 0, 0, 36710), +('We\'ll need the help of the Argent Crusade to stem the tide of the undead.', '', 201317, 0, 0, 1, 0, 0, 0, 160229, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'Did you say... Bolvar? Bolvar Fordragon? That\'s my father...is he alive?!', 201319, 0, 0, 5, 0, 0, 0, 0, 160231, 0, 0, 0, 0, 0, 0, 36710), +('Taelia, I... will explain. But we can\'t afford to let our guard down. Not with so much at stake.', '', 201320, 0, 0, 1, 0, 0, 0, 160232, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'Right now, I don\'t give a damn about justice. I just want to find where she\'s taken our friends. King Greymane, what\'s the plan?', 200089, 0, 0, 6, 0, 0, 0, 0, 160225, 0, 0, 0, 0, 0, 0, 36710), +('', 'These abductions... the Scourge attacks... the Banshee will pay for what she\'s done. By Elune\'s fury, we will bring her to justice!', 200088, 0, 0, 5, 0, 0, 0, 0, 160224, 0, 0, 0, 0, 0, 0, 36710), +('The Banshee\'s accursed shadow hangs over us all.\n\nShe will pay for what she\'s done!', '', 195169, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 36710), +('How... how could I let this happen?', '', 197790, 0, 0, 0, 0, 0, 0, 161185, 0, 0, 0, 0, 0, 0, 0, 36710), +('Strange, is it not? When we first offered aid to this city, its people cursed and spat at us. They feared and reviled us.\n\nNow, we defend them against the very monsters for which they mistook us.\n\nI suspect the irony is lost on them. No matter. We do what the living cannot.', 'Strange, is it not? When we first offered aid to this city, its people cursed and spat at us. They feared and reviled us.\n\nNow, we defend them against the very monsters for which they mistook us.\n\nI suspect the irony is lost on them. No matter. We do what the living cannot.', 205986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('Do not think I have forgotten what the Knights of the Ebon Blade attempted at Light\'s Hope Chapel.\n\nWe may not be enemies, but neither are we allies.', 'Do not think I have forgotten what the Knights of the Ebon Blade attempted at Light\'s Hope Chapel.\n\nWe may not be enemies, but neither are we allies.', 205980, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36710), +('', 'When I worked with King Wrynn to arrange a meeting between the living and the undead in Arathi, I thought I understood the Forsaken. Only too late did I realize how little I knew.\n\nBut after being raised into undeath myself, I have begun to see the depths of what they have endured. With the help of Lilian Voss, I have found ways to aid those who feel abandoned and alone.\n\nRight now, the whole world trembles beneath the specter of death. And fear, left unchecked, will consume every soul it touches.\n\nI cannot allow that to happen. Not to the people of Lordaeron, nor to any who fight for the good of Azeroth.', 205773, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 2000, 0, 36665), +('', 'The war taught me many lessons. Who I could trust... and who I could not.\n\nThrough her actions, Sylvanas has proven that she doesn\'t care about the Forsaken\'s fate. But we have endured too much to allow her betrayal to unravel what we have built.\n\n<Lilian peers at you through narrow eyes.>\n\nYou think my words harsh, $p? Did you willfully do her bidding? Turn a blind eye upon her endless atrocities?\n\nWindrunner chose her path--and her allies. We all did.\n\nOnce, I would have sought vengeance. Retribution. But now, I care only that the Forsaken have a future. And for that, we need the right leaders in place.\n\nI will lend my voice to the Horde council and speak for my people. For a time, at least.', 205723, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 2000, 0, 36665), +('', 'We had a life in Nagrand. A home. We were happy.\n\n<Aggra looks wistfully into the distance.>\n\nBut... Go\'el needed to return. We all did. For the sake of the Horde. And for Saurfang.\n\nThe Banshee\'s forces took us by surprise. We fought fiercely, but it was not enough.\n\nI know wherever they took him, Go\'el will keep on fighting.\n\nHe would want me to stay and safeguard the children. So I ask you, $n, to go in my stead.\n\nFind him. Find them all. And bring them home.', 199607, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 2000, 0, 36665), +('', 'Baine endured so much during the war. He did all he could to make the Horde strong. But more than that, he fought to reclaim its honor. Its heart.\n\nThe Banshee failed to break him, so of course she would lash out like this. A cowardly attack was all she had left.\n\nBaine means... a great deal to me. But my people--and his--are gripped by fear. Now is not the time for me to leave them, even for his sake.\n\nSo I ask you, $n, to fight to save him. As he fought to save the Horde.', 205718, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 2000, 0, 36665), +('Dis be a perilous time for da Horde. Our wounds still be fresh, and da Banshee be inflictin\' even fresher ones.\n\nDa Scourge be risin\' too. If we don\'t be careful, Death gonna take hold of dis world. We all gotta stay vigilant.\n\nQueen Talanji be back in Zuldazar, defendin\' her kingdom. Don\'t know if ya heard, but she been facin\' problems of her own.\n\nDa Horde gotta stand strong, $p. No matter what be risin\' from da shadows.', '', 205739, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 2000, 0, 36665), +('I will send word of this to the Knights of the Ebon Blade. We must devise a strategy to rescue our friends from the realms of Death.', '', 204156, 0, 0, 1, 0, 0, 0, 164697, 0, 0, 0, 0, 0, 0, 0, 36665), +('The winged creature you encountered sounds like the very fiends who abducted Thrall, Baine, and the others.', '', 202464, 0, 0, 1, 0, 0, 0, 164695, 0, 0, 0, 0, 0, 0, 0, 36665), +('I had hoped you would find them held captive in Icecrown. But it seems our worst fears are true... that Sylvanas has taken them beyond the shattered veil.', '', 202777, 0, 0, 1, 0, 0, 0, 164696, 0, 0, 0, 0, 0, 0, 0, 36665), +('Stay vigilant, $n. Fight back the Scourge wherever you see them encroaching. Once our plan is in place, you will be called upon to bring our allies home.', '', 204157, 0, 0, 1, 0, 0, 0, 164698, 0, 0, 0, 0, 0, 0, 0, 36665), +('Can I help you?', 'Can I help you?', 204555, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('', 'You cannot... stop... his victory...', 202461, 0, 0, 0, 0, 0, 0, 0, 162290, 0, 0, 0, 0, 0, 0, 36665), +('We end this together.', '', 205120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('A job well done.', '', 205562, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Let us return with news of our success.', '', 205563, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Please. Help us!', 'Please. Help us!', 202715, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('You must tell the others what they\'re doing here!', 'You must tell the others what they\'re doing here!', 202716, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Do something. Please!', 'Do something. Please!', 202718, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Light watch over us.', 'Light watch over us.', 202719, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('The things they do here...', 'The things they do here...', 202717, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('No more. I beg you!', 'No more. I beg you!', 202723, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('The Light protects us!', 'The Light protects us!', 202724, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('No... no! Not again!', 'No... no! Not again!', 202726, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('You may cause us pain, but you cannot protect yourselves from what\'s coming!', 'You may cause us pain, but you cannot protect yourselves from what\'s coming!', 202722, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Make it stop! Please. I\'ll do anything!', 'Make it stop! Please. I\'ll do anything!', 202721, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Please! No more!', 'Please! No more!', 202720, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Soon our work will be complete.', 'Soon our work will be complete.', 202708, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Mind your business.', 'Mind your business.', 202707, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Leave me to my work.', 'Leave me to my work.', 202705, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Stop pestering me.', 'Stop pestering me.', 202704, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Death beckons to us all.', 'Death beckons to us all.', 202712, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('<The monstrosity acknowledges your presence with a deep, mucous-filled gargling sound.>', '', 202702, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('All who oppose us shall suffer.', 'All who oppose us shall suffer.', 202713, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Leave me be.', 'Leave me be.', 205081, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Let nothing stand in our way.', 'Let nothing stand in our way.', 202714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('My life is but a small sacrifice.', 'My life is but a small sacrifice.', 205080, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('Yes? What do you want?', 'Yes? What do you want?', 202703, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665), +('', 'The Scourge need no reason to attack. They are mindless beasts, existing only to consume and destroy.\n\nBut... at times their aggression has felt focused and coordinated, as if some unseen presence is driving them.\n\nWe sent several scouts deep into hostile territory to glean more information. None have returned.\n\nOne thing is certain--our enemy is keen on seeing our watch over Icecrown come to an end.', 196006, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36665); + diff --git a/sql/updates/hotfixes/master/2022_02_27_12_hotfixes_905.sql b/sql/updates/hotfixes/master/2022_02_27_12_hotfixes_905.sql new file mode 100644 index 00000000000..8253646ea5e --- /dev/null +++ b/sql/updates/hotfixes/master/2022_02_27_12_hotfixes_905.sql @@ -0,0 +1,9 @@ +-- +DELETE FROM `broadcast_text` WHERE `ID` IN (208083, 205358, 197340, 197339, 197697, 197696); +INSERT INTO `broadcast_text` (`Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `VoiceOverPriorityID`, `SoundKitID1`, `SoundKitID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES +('Good luck, $p. I must say that we are quite the egg-hiding experts now!', '', 208083, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38134), +('It seems you have yet to bind yourself to a Covenant. I can bind you to one of the Covenants temporarily, for a price. Negotiated at a later date of course.', 'It seems you have yet to bind yourself to a Covenant. I can bind you to one of the Covenants temporarily, for a price. Negotiated at a later date of course.', 205358, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38556), +('', 'We\'ll relocate the cocoons to the groves that need them. Thank you for restoring the balance.', 197340, 0, 0, 0, 0, 0, 0, 0, 162902, 0, 0, 0, 0, 0, 0, 38134), +('', 'The moth cocoons in Shimmerbough are growing out of control! Can you help collect them from the treetops?', 197339, 0, 0, 0, 0, 0, 0, 0, 162901, 0, 0, 0, 0, 0, 0, 38134), +('', 'Today, you have proven that we will not give in to doubt. Bastion will never surrender!', 197697, 0, 0, 1, 0, 0, 0, 0, 164329, 0, 0, 0, 0, 0, 0, 38134), +('', 'The forsworn have fortified this area with their most adept warriors. Strike them down, courage be with you!', 197696, 0, 0, 1, 0, 0, 0, 0, 164328, 0, 0, 0, 0, 0, 0, 38134); diff --git a/sql/updates/hotfixes/master/2022_02_27_13_hotfixes_910.sql b/sql/updates/hotfixes/master/2022_02_27_13_hotfixes_910.sql new file mode 100644 index 00000000000..5d98f7d0b53 --- /dev/null +++ b/sql/updates/hotfixes/master/2022_02_27_13_hotfixes_910.sql @@ -0,0 +1,13 @@ +-- +DELETE FROM `broadcast_text` WHERE `ID` IN (208597, 208607, 205358, 208091, 197697, 197696, 197340, 197339, 211381, 211382); +INSERT INTO `broadcast_text` (`Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `VoiceOverPriorityID`, `SoundKitID1`, `SoundKitID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES +('I\'ve been bubbling up quite a collection of concoctions to assist you, Maw Walker.', '', 208597, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 40725), +('I don\'t know you, but we can still be friends.', '', 208607, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 40725), +('It seems you have yet to bind yourself to a Covenant. I can bind you to one of the Covenants temporarily, for a price. Negotiated at a later date of course.', 'It seems you have yet to bind yourself to a Covenant. I can bind you to one of the Covenants temporarily, for a price. Negotiated at a later date of course.', 205358, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 39653), +('Perfect! With those parts and Heirmir\'s Runes we have been able to create not just a Centurion, but a suit of armor capable of scaling the walls of the fortress!', '', 208091, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 39335), +('', 'Today, you have proven that we will not give in to doubt. Bastion will never surrender!', 197697, 0, 0, 1, 0, 0, 0, 0, 164329, 0, 0, 0, 0, 0, 0, 40443), +('', 'The forsworn have fortified this area with their most adept warriors. Strike them down, courage be with you!', 197696, 0, 0, 1, 0, 0, 0, 0, 164328, 0, 0, 0, 0, 0, 0, 40443), +('', 'We\'ll relocate the cocoons to the groves that need them. Thank you for restoring the balance.', 197340, 0, 0, 0, 0, 0, 0, 0, 162902, 0, 0, 0, 0, 0, 0, 40000), +('', 'The moth cocoons in Shimmerbough are growing out of control! Can you help collect them from the treetops?', 197339, 0, 0, 0, 0, 0, 0, 0, 162901, 0, 0, 0, 0, 0, 0, 40000), +('', 'You are a welcome sight in these uncouth lands, Tubbins and Gubbins.', 211381, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 39289), +('', 'Now, if you will excuse me, I must go thank Theotar in person.', 211382, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 39289); diff --git a/sql/updates/hotfixes/master/2022_02_27_14_hotfixes_915.sql b/sql/updates/hotfixes/master/2022_02_27_14_hotfixes_915.sql new file mode 100644 index 00000000000..7e3621257a5 --- /dev/null +++ b/sql/updates/hotfixes/master/2022_02_27_14_hotfixes_915.sql @@ -0,0 +1,45 @@ +-- +DELETE FROM `broadcast_text` WHERE `ID` IN (209163, 209160, 209164, 209162, 211425, 209173, 209174, 209161, 210862, 210860, 210859, 210858, 210857, 210855, 210854, 210851, 210850, 205211, 205208, 205207, 205206, 204189, 202222, 201299, 197340, 197339, 208593, 211398, 211399, 211401, 211402, 211404, 211405, 211407, 211408, 214459, 208607, 197697, 197696, 211435); +INSERT INTO `broadcast_text` (`Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `VoiceOverPriorityID`, `SoundKitID1`, `SoundKitID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES +('Grab a big one this time, Fangcrack!', '', 209163, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42010), +('Let\'s see who hidin\' in here...', '', 209160, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42010), +('I love you, Fangcrack!', 'I love you, Fangcrack!', 209164, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42010), +('Go get \'em Fangcrack!', '', 209162, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42010), +('<Rendle cheers at the dredger brute down below.>\n\nGet \'em Fangcrack! You\'re my hero!', '', 211425, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42010), +('I caught a big one!', '', 209173, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42010), +('Yeah! Get \'em, Fangcrack! Ha ha!', '', 209174, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42010), +('Come out and play, small sneakies!', '', 209161, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41488), +('Prepare yourselves. We make our stand now.', '', 210862, 0, 0, 0, 102, 0, 0, 180988, 0, 0, 0, 0, 0, 0, 0, 41031), +('He is coming.', '', 210860, 0, 0, 0, 102, 0, 0, 180987, 0, 0, 0, 0, 0, 0, 0, 41031), +('', 'Forgive me, master. We were only--', 210859, 0, 0, 0, 102, 0, 0, 0, 180986, 0, 0, 0, 0, 0, 0, 41031), +('You brought my sigil... to Zovaal\'s lair?', '', 210858, 0, 0, 0, 102, 0, 0, 180985, 0, 0, 0, 0, 0, 0, 0, 41031), +('', 'My Primus! You\'ve been trapped here all this time?!', 210857, 0, 0, 0, 102, 0, 0, 0, 180984, 0, 0, 0, 0, 0, 0, 41031), +('...everything!', '', 210855, 0, 0, 0, 102, 0, 0, 180983, 0, 0, 0, 0, 0, 0, 0, 41031), +('I remember...', '', 210854, 0, 0, 0, 102, 0, 0, 182104, 0, 0, 0, 0, 0, 0, 0, 41031), +('...remember...', '', 210851, 0, 0, 0, 102, 0, 0, 182103, 0, 0, 0, 0, 0, 0, 0, 41031), +('I...', '', 210850, 0, 0, 0, 102, 0, 0, 182102, 0, 0, 0, 0, 0, 0, 0, 41031), +('I\'ve just the item that could help. Check my inventory.', '', 205211, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41031), +('', 'You were able to find it? \nWell, good for you. \n\nKnow what? You deserve something...\n\n<Tabithia makes an exaggeratedly slow, single clap.>\n\nThere, now go away! I\'m kind of busy here, you know... in the wreckage of my house.', 205208, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41031), +('', 'Yeah, a huge one! It crawled out of the ground right under my furniture. I guess the egg must have some sort of scent because the Gorm ignored everything else, it just grabbed the egg and swallowed it.\n\nUnless you have an extremely keen sense of smell, good luck ever finding the thing. You might as well let the Broker know that his precious bauble is gone.\n\nNow, if you will excuse me, I have to get back to wallowing in my misery.', 205207, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 41031), +('', 'I guess you\'re here to collect for that Broker, huh?\n\nYou\'re too late, a damned gorm ate it.', 205206, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41031), +('Probably my best work yet.', '', 204189, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 41031), +('Gotta say, it\'s nice havin\' dredgers wait on ME for a change.\n\n<Rendle smiles proudly and sticks out his chest.>\n\nYeah, ol\' Rendle\'s finally movin\' up in this mucky-muck world.', '', 202222, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 41031), +('We have activated the stoneborn reserves for today\'s court.\n\nRest easy. Any intrusion will be dealt with.', '', 201299, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 41031), +('', 'We\'ll relocate the cocoons to the groves that need them. Thank you for restoring the balance.', 197340, 0, 0, 0, 0, 0, 0, 0, 162902, 0, 0, 0, 0, 0, 0, 41031), +('', 'The moth cocoons in Shimmerbough are growing out of control! Can you help collect them from the treetops?', 197339, 0, 0, 0, 0, 0, 0, 0, 162901, 0, 0, 0, 0, 0, 0, 41031), +('Allow my blade to assist you. Together we shall strike unseen upon the enemy!', 'Allow my blade to assist you. Together we shall strike unseen upon the enemy!', 208593, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 41488), +('Thank you, friends.', '', 211398, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41488), +('I must hurry to rebuild the mirrors that Prince Renathal requires!', '', 211399, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41488), +('', 'Well, I suppose this is what I deserve for following Laurent through that mirror.', 211401, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41488), +('', 'I shall remain in the Ember Ward next time.', 211402, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41488), +('', 'Drank Tubbins, thank Gubbins...', 211404, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41488), +('', 'A debt repaid, twice conveyed.', 211405, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41488), +('', 'Charred shards, it\'s good to see you both.', 211407, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41488), +('', 'Tell Theotar to meet me at the parlor when this is all over. He owes me a drink!', 211408, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41488), +('Here to help! Illidari say so!', 'Here to help! Illidari say so!', 214459, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 41488), +('I don\'t know you, but we can still be friends.', '', 208607, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 41079), +('', 'Today, you have proven that we will not give in to doubt. Bastion will never surrender!', 197697, 0, 0, 1, 0, 0, 0, 0, 164329, 0, 0, 0, 0, 0, 0, 40944), +('', 'The forsworn have fortified this area with their most adept warriors. Strike them down, courage be with you!', 197696, 0, 0, 1, 0, 0, 0, 0, 164328, 0, 0, 0, 0, 0, 0, 40944), +('', 'Today is a good day, for today we hunt!', 211435, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 41079); + + diff --git a/sql/updates/hotfixes/master/2022_02_27_15_hotfixes_920.sql b/sql/updates/hotfixes/master/2022_02_27_15_hotfixes_920.sql new file mode 100644 index 00000000000..c2c17179f0d --- /dev/null +++ b/sql/updates/hotfixes/master/2022_02_27_15_hotfixes_920.sql @@ -0,0 +1,39 @@ +-- +DELETE FROM `broadcast_text` WHERE `ID` IN (214210, 214209, 205045, 205043, 205042, 205041, 205040, 205039, 205004, 205003, 205002, 204999, 204998, 204997, 204996, 204995, 202222, 201299); +INSERT INTO `broadcast_text` (`Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `VoiceOverPriorityID`, `SoundKitID1`, `SoundKitID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES +('You have preserved this place for now. But, we must remain vigilant.', '', 214210, 0, 0, 669, 0, 0, 0, 188523, 0, 0, 0, 0, 0, 0, 0, 42488), +('The devourers have decimated this area. Destroy the fissures and protect its natural state.', '', 214209, 0, 0, 669, 0, 0, 0, 188522, 0, 0, 0, 0, 0, 0, 0, 42488), +('Where are the bodies buried?', 'Where are the bodies buried?', 205045, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('Let them come. I am ready to fight.', 'Let them come. I am ready to fight.', 205043, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('I grow tired of waiting. Where are the enemies?', 'I grow tired of waiting. Where are the enemies?', 205042, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('Found a cake. Ate it too. Tasted gross.', 'Found a cake. Ate it too. Tasted gross.\n\nMight\'ve been a dredger.', 205041, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('Bring me something worth fighting.', 'Bring me something worth fighting.', 205040, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('I was promised bloodshed.', 'I was promised bloodshed.', 205039, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('Good to be back in Revendreth. Always respected the venthyr and their stoneborn.', 'Good to be back in Revendreth. Always respected the venthyr and their stoneborn.', 205004, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('Bet I could take on two... maybe three of those big dredgers you got.', 'Bet I could take on two... maybe three of those big dredgers you got.', 205003, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('Where\'s the fight club? You have a fight club, right?', 'Where\'s the fight club? You have a fight club, right?', 205002, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('Too much talking here, not enough fighting.', 'Too much talking here, not enough fighting.', 204999, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('You spot any trouble, come running to me.', 'You spot any trouble, come running to me.', 204998, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('When the fighting starts, I\'ll be there.', 'When the fighting starts, I\'ll be there.', 204997, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('You need something killed?', 'You need something killed?', 204996, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('I am not accustomed to taking orders from venthyr.', 'I am not accustomed to taking orders from venthyr.', 204995, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('Gotta say, it\'s nice havin\' dredgers wait on ME for a change.\n\n<Rendle smiles proudly and sticks out his chest.>\n\nYeah, ol\' Rendle\'s finally movin\' up in this mucky-muck world.', '', 202222, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('We have activated the stoneborn reserves for today\'s court.\n\nRest easy. Any intrusion will be dealt with.', '', 201299, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488); + +UPDATE `broadcast_text` SET `VerifiedBuild`=42488 WHERE `ID` IN (212565, 212553, 212382, 206713, 205797, 205360, 205028, 205027, 205026, 205025, 205024, 205023, 205022, 205021, 204703, 204701, 204698, 204695, 204694, 204673, 204672, 204588, 204587, 204349, 204346, 204163, 204152, 204113, 204111, 203881, 203199, 203198, 203197, 203196, 203193, 203192, 202632, 202380, 202379, 202378, 202377, 202236, 202233, 202227, 202224, 202209, 202202, 201777, 201564, 201563, 201562, 201561, 201560, 201559, 200909, 200773, 200701, 200700, 200699, 200698, 200697, 200696, 200373, 198811, 198224, 198203, 198202, 197734, 197733, 197676, 197675, 197674, 197673, 197487, 197366, 197139, 197138, 193455, 193293, 193292, 189194, 189181); + +DELETE FROM `broadcast_text` WHERE `ID` IN (204434, 201449, 201448, 201447, 201445, 200948, 200941, 200539, 200538, 200533, 200277, 199883); +INSERT INTO `broadcast_text` (`Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `VoiceOverPriorityID`, `SoundKitID1`, `SoundKitID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES +('What majestic creatures you have discovered in the realm of Ardenweald!\n\nIn another life, I might have enjoyed it there...', 'What majestic creatures you have discovered in the realm of Ardenweald!\n\nIn another life, I might have enjoyed it there...', 204434, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('They even collect flowers. Just like me!', '', 201449, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42488), +('Two brothers travel across worlds to save a princess.', '', 201448, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42488), +('It\'s my favorite!', '', 201447, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42488), +('Oh, I didn\'t see you there!\n\nI really like this book.', '', 201445, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('I am thoroughly enjoying your court, Maw Walker. As I expected to.\n\nPlease pass along my congratulations to the Prince.\n\nIf you would excuse me, this spectacular music has me considering a trip to the dance floor.', 'I am thoroughly enjoying your court, Maw Walker. As I expected to.\n\nPlease pass along my congratulations to the Prince.\n\nIf you would excuse me, this spectacular music has me considering a trip to the dance floor.', 200948, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('Sincerest apologies, my dear $gsir:madam;. It was far too presumptuous of me to ask.', '', 200941, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42488), +('LONGBEARD BOXTY\n\nNote from Stewart: This recipe from different aspirant. Also from Longbeard family in mortal life. She say many generations refine recipe before her. I do not change it.\n\nIngredients:\n5 Starchy potatos\n1 cup Flour, more as needed\n1 Egg\n2 tbsp Salted butter\n1 keg Dwarven stout (for drinking)\n\nPreparation:\n<The dredgers drew illegible doodles here.>', '', 200539, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42488), +('LONGBEARD STEW\n\nNote from Stewart: Recipe from aspirant in Bastion. In life, aspirant great dwarven chef. Gave me recipe when pass trials. Let go of past. His favorite recipe.\n\nIngredients:\n2 lbs Beef chuck\n6 oz Bacon, diced\n16 oz Rich, creamy dwarven stout\n1 cup Beef broth\n1/4 cup Tomato paste\n2 tbsp Worcester family sauce\n3 tbsp White flour\n2 Leeks, chopped\n3 Carrots, chopped\n1 Parsnip, chopped\n1 tsp Thyme\n1 tsp Rosemary\n1.5 tsp Salt\n1/4 tsp Black pepper\n2 Menethil Bay leaves\n\nPreparation:\n<The dredgers haven\'t transcribed this yet.>', '', 200538, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42488), +('STEWART\'S COLLECTED RECIPES\n\n(Transcribed by a series of semi-literate dredgers.)\n\nTable of Contents:', '', 200533, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42488), +('Don\'t worry, I\'m only hitting the nobles. Thems that can afford it.', '', 200277, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 42488), +('Oh, we don\'t mind. \n\nMy friends and I let ourselves in when we got here. I assumed the waiting outside plan was more for your... other guests.\n\nDon\'t worry, we\'ll stay out of the way!\n\nHey, while I have you... uh, where do you store your fireworks?', '', 199883, 0, 0, 0, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 0, 42488); + |