diff options
| author | Alastro-Kraken <Alastro-Kraken@users.noreply.github.com> | 2022-01-22 23:52:31 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-25 23:50:18 +0100 |
| commit | 60bfb51985504cfa03cef4f0f4f92496bbc321eb (patch) | |
| tree | 488dd7616d7f25371f15d60b4190e684b73bb297 | |
| parent | 003dd4c5967371ea355a6bbb354645fec3ff9538 (diff) | |
DB/Gossip: Fix gossip for NPC Zel'mak
Closes #27665
(cherry picked from commit 0dd751c7600046381f42a6b9f6c58474a18f98b2)
| -rw-r--r-- | sql/updates/world/master/2022_03_25_18_world_2022_01_22_17_world.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_25_18_world_2022_01_22_17_world.sql b/sql/updates/world/master/2022_03_25_18_world_2022_01_22_17_world.sql new file mode 100644 index 00000000000..0818a2c5653 --- /dev/null +++ b/sql/updates/world/master/2022_03_25_18_world_2022_01_22_17_world.sql @@ -0,0 +1,19 @@ +-- +UPDATE `creature_template` SET `gossip_menu_id`=4510 WHERE `entry`=3408; +DELETE FROM `gossip_menu` WHERE `MenuID`=4510 AND `TextID`=4987; +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(4510, 4987, 41812); + +DELETE FROM `conditions` WHERE `SourceGroup`=4510 AND `SourceTypeOrReferenceId` IN (14, 15); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14, 4510, 4987, 0, 0, 15, 0, 1, 0, 0, 0, 0, 0, "", "Show gossip text if player is a Warrior"), +(14, 4510, 4986, 0, 0, 15, 0, 1, 0, 0, 1, 0, 0, "", "Show gossip text if player is not a Warrior"), +(15, 4510, 0, 0, 0, 15, 0, 1, 0, 0, 0, 0, 0, "", "Show gossip option if player is a Warrior"), +(15, 4510, 1, 0, 0, 15, 0, 1, 0, 0, 0, 0, 0, "", "Show gossip option if player is a Warrior"), +(15, 4510, 2, 0, 0, 15, 0, 1, 0, 0, 0, 0, 0, "", "Show gossip option if player is a Warrior"); + +DELETE FROM `gossip_menu_option` WHERE `MenuID`=4510; +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(4510, 0, 3, "I require warrior training.", 3147, 5, 16, 0, 0, 0, 0, "", 0, 0), +(4510, 1, 0, "I wish to unlearn my talents.", 8271, 16, 16, 4461, 0, 0, 0, "", 0, 0), +(4510, 2, 0, "I wish to know about Dual Talent Specialization.", 33762, 20, 1, 10371, 0, 0, 0, "", 0, 0); |