diff options
| author | Ovahlord <dreadkiller@gmx.de> | 2025-04-12 23:20:10 +0200 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2025-04-12 23:44:37 +0200 |
| commit | 8ee03b01081a3ec1bb356ca4bddd1cea3fc18762 (patch) | |
| tree | 50d85ec0f22fc65e7900545767cddfd7c793697b | |
| parent | 04101639fe2b711d6abf2ee510621211647f18a9 (diff) | |
DB/Gossips: added Classic exclusive npc_text entries to reduce differences between branches
| -rw-r--r-- | sql/updates/world/master/2025_04_12_03_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_04_12_03_world.sql b/sql/updates/world/master/2025_04_12_03_world.sql new file mode 100644 index 00000000000..6dce82226e2 --- /dev/null +++ b/sql/updates/world/master/2025_04_12_03_world.sql @@ -0,0 +1,11 @@ +SET @NPCTEXTID := 530007; +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); |