diff options
| author | Killyana <morphone1@gmail.com> | 2020-02-10 22:33:38 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-21 15:54:36 +0100 |
| commit | d403e365387d752f4ee2bb78c3ce5cd3bedb8d34 (patch) | |
| tree | 1f07a1c01dea263d1aaab69232edd1622bed5826 | |
| parent | a91be4995b45695d8585068d0c5e955b93027d89 (diff) | |
DB/Text: Fix and remove some npc_text
(cherry picked from commit 7450be4cfd3f06ef3cac59ab0cd73e3af47f4857)
| -rw-r--r-- | sql/updates/world/master/2021_12_21_01_world_2020_02_10_00_world.sql | 11 | ||||
| -rw-r--r-- | src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheCrusader/trial_of_the_crusader.h | 10 |
2 files changed, 11 insertions, 10 deletions
diff --git a/sql/updates/world/master/2021_12_21_01_world_2020_02_10_00_world.sql b/sql/updates/world/master/2021_12_21_01_world_2020_02_10_00_world.sql new file mode 100644 index 00000000000..cdf1b22879a --- /dev/null +++ b/sql/updates/world/master/2021_12_21_01_world_2020_02_10_00_world.sql @@ -0,0 +1,11 @@ +-- +UPDATE `npc_text` SET /*`Text0_0`="You can find our mana loom in the merchant's bazaar within the Lower City.", `Text0_1`="You can find our mana loom in the merchant's bazaar within the Lower City.", `Emote0_0`=1,*/ `BroadcastTextID0`=19591, `Probability0`=1 WHERE `id`=10503; +-- UPDATE `gossip_menu_option` SET `ActionMenuID`=8418 WHERE `MenuID`=8403 AND `OptionID`=6; +-- UPDATE `gossip_menu_option_action` SET `ActionMenuID`=8410 WHERE `MenuID`=8357 AND `OptionIndex`=8; + +DELETE FROM `npc_text` WHERE `ID` IN (10515, 724001, 724002, 724003, 724004, 724005, 2981); +INSERT INTO `npc_text` (`ID`, `Probability0`, `BroadcastTextID0`) VALUES +(10515, 1, 41148); + +DELETE FROM `gossip_menu` WHERE `MenuID`=8410 AND `TextID`=10515; +INSERT INTO `gossip_menu` (`MenuID`,`TextID`) VALUES (8410,10515); diff --git a/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheCrusader/trial_of_the_crusader.h b/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheCrusader/trial_of_the_crusader.h index e740dba7ee3..856d3cf061b 100644 --- a/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheCrusader/trial_of_the_crusader.h +++ b/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheCrusader/trial_of_the_crusader.h @@ -145,16 +145,6 @@ enum NorthrendBeasts ICEHOWL_DONE = 3001 }; -enum AnnouncerMessages -{ - MSG_BEASTS = 724001, - MSG_JARAXXUS = 724002, - MSG_CRUSADERS = 724003, - MSG_VALKIRIES = 724004, - MSG_LICH_KING = 724005, - MSG_ANUBARAK = 724006 -}; - enum TCRCreatureIds { NPC_BARRETT_BEASTS = 34816, |