diff options
| author | ZenoX92 <ZenoX92@users.noreply.github.com> | 2018-01-25 18:49:15 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2018-01-25 18:49:15 +0100 |
| commit | c4b845f0e0069d628cd7d4b4311d8c522f1e6a4e (patch) | |
| tree | df99f45fc964b635213d487c7047015b7c31b9ff | |
| parent | 18553de3b4c230ebd8f7e10de7921d2129b32a16 (diff) | |
DB/Gossip: Samuel Hawke, Rutherford Twing, Illiyana Moonblaze & Kelm Hargunth
Closes #21302
| -rw-r--r-- | sql/updates/world/3.3.5/2018_01_25_07_world_335.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_01_25_07_world_335.sql b/sql/updates/world/3.3.5/2018_01_25_07_world_335.sql new file mode 100644 index 00000000000..89c3ab16187 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_01_25_07_world_335.sql @@ -0,0 +1,18 @@ +UPDATE `creature_template` SET `gossip_menu_id`=6522, `npcflag`=4227, `type_flags`=134217728 WHERE `entry`=15127; -- Samuel Hawke +UPDATE `creature_template` SET `gossip_menu_id`=6521, `npcflag`=4227, `type_flags`=134217728 WHERE `entry`=15126; -- Rutherford Twing +UPDATE `creature_template` SET `gossip_menu_id`=6142, `npcflag`=4227, `type_flags`=134217728 WHERE `entry`=14753; -- Illiyana Moonblaze +UPDATE `creature_template` SET `gossip_menu_id`=6141, `npcflag`=4227, `type_flags`=134217728 WHERE `entry`=14754; -- Kelm Hargunth + +DELETE FROM `gossip_menu` WHERE `MenuID` IN (6521,6522,6141,6142); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(6522,7724,0), -- Samuel Hawke +(6521,7723,0), -- Rutherford Twing +(6142,7295,0), -- Illiyana Moonblaze +(6141,7294,0); -- Kelm Hargunth + +DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (6521,6522,6141,6142); +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(6522,0,1,"What goods have I earned the right to purchase from the League of Arathor?",10625,3,128,0,0,0,0,"",0,0), -- Samuel Hawke +(6521,0,1,"What goods have I earned the right to purchase from the Defilers?",10623,3,128,0,0,0,0,"",0,0), -- Rutherford Twing +(6142,0,1,"What goods have I earned the right to purchase for use in Warsong Gulch?",10021,3,128,0,0,0,0,"",0,0), -- Illiyana Moonblaze +(6141,0,1,"What goods have I earned the right to purchase for use in Warsong Gulch?",10019,3,128,0,0,0,0,"",0,0); -- Kelm Hargunth |