From 4fd81f62966548e332b11a4e41c63f6b0fdd1d8a Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Sat, 12 Apr 2025 23:49:47 +0200 Subject: DB/Hotfixes: fixed sql added in 8ee03b01081a3ec1bb356ca4bddd1cea3fc18762 --- sql/updates/hotfixes/master/2025_04_12_00_hotfixes.sql | 5 +++++ sql/updates/world/master/2025_04_12_03_world.sql | 6 ------ 2 files changed, 5 insertions(+), 6 deletions(-) create mode 100644 sql/updates/hotfixes/master/2025_04_12_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2025_04_12_00_hotfixes.sql b/sql/updates/hotfixes/master/2025_04_12_00_hotfixes.sql new file mode 100644 index 00000000000..b684be98f33 --- /dev/null +++ b/sql/updates/hotfixes/master/2025_04_12_00_hotfixes.sql @@ -0,0 +1,5 @@ +DELETE FROM `broadcast_text` WHERE `VerifiedBuild`>0 AND `ID` IN (242815, 242822, 284310); +INSERT INTO `broadcast_text` (`Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `VoiceOverPriorityID`, `SoundKitID1`, `SoundKitID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES +('', 'This lair is a place of darkness and danger.\n\nDo you wish to battle the past incarnation of the broodmother, Onyxia.', 242815, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 57564), +('', 'The present is a place of uncertainty and challenge, but also great opportunity.\n\nDo you wish to return?', 242822, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 57564), +('I\'ve been ordered here to assist you. Which of the following gifts will the dragonflights bestow upon you?', 'I\'ve been ordered here to assist you. Which of the following gifts will the dragonflights bestow upon you?', 284310, 0, 0, 0, 256, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 60192); diff --git a/sql/updates/world/master/2025_04_12_03_world.sql b/sql/updates/world/master/2025_04_12_03_world.sql index 6dce82226e2..9c552ecf1dc 100644 --- a/sql/updates/world/master/2025_04_12_03_world.sql +++ b/sql/updates/world/master/2025_04_12_03_world.sql @@ -3,9 +3,3 @@ DELETE FROM `npc_text` WHERE `ID` BETWEEN @NPCTEXTID+0 AND @NPCTEXTID+1; INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES (@NPCTEXTID+0, 1, 1, 0, 0, 0, 0, 0, 0, 242822, 242815, 0, 0, 0, 0, 0, 0, 57564), -- 205890 (Zidormi) (@NPCTEXTID+1, 1, 0, 0, 0, 0, 0, 0, 0, 284310, 0, 0, 0, 0, 0, 0, 0, 60192); -- 240309 (Wyrmrest Defender) - -DELETE FROM `broadcast_text` WHERE `VerifiedBuild`>0 AND `ID` IN (242815, 242822, 284310); -INSERT INTO `broadcast_text` (`Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `VoiceOverPriorityID`, `SoundKitID1`, `SoundKitID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES -('', 'This lair is a place of darkness and danger.\n\nDo you wish to battle the past incarnation of the broodmother, Onyxia.', 242815, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 57564), -('', 'The present is a place of uncertainty and challenge, but also great opportunity.\n\nDo you wish to return?', 242822, 0, 0, 0, 0, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 57564), -('I\'ve been ordered here to assist you. Which of the following gifts will the dragonflights bestow upon you?', 'I\'ve been ordered here to assist you. Which of the following gifts will the dragonflights bestow upon you?', 284310, 0, 0, 0, 256, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 60192); -- cgit v1.2.3