aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/hotfixes
diff options
context:
space:
mode:
authorOvahlord <dreadkiller@gmx.de>2024-11-14 19:32:19 +0100
committerOvahlord <dreadkiller@gmx.de>2024-11-14 19:32:19 +0100
commit87b2cd5b27c1beca233abc4444e42b94012b56db (patch)
treeedf834c60392375ac3ec395e16b92730f24fad3c /sql/updates/hotfixes
parent02a3a6ce86770fd2d7367bb085253ba98262bf7b (diff)
DB/Creatures: spawn the Classic version of Zidormi next to Onyxia's Lair
Diffstat (limited to 'sql/updates/hotfixes')
-rw-r--r--sql/updates/hotfixes/cata_classic/2024_11_14_01_hotfixes.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/cata_classic/2024_11_14_01_hotfixes.sql b/sql/updates/hotfixes/cata_classic/2024_11_14_01_hotfixes.sql
new file mode 100644
index 00000000000..6bc9aac90f9
--- /dev/null
+++ b/sql/updates/hotfixes/cata_classic/2024_11_14_01_hotfixes.sql
@@ -0,0 +1,4 @@
+DELETE FROM `broadcast_text` WHERE `VerifiedBuild`>0 AND `ID` IN (242815, 242822);
+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);