diff options
| author | treeston <treeston.mmoc@gmail.com> | 2016-06-09 12:52:22 +0200 |
|---|---|---|
| committer | treeston <treeston.mmoc@gmail.com> | 2016-06-09 12:52:22 +0200 |
| commit | 3358e943a2e37dd0016795e0978881381177cf82 (patch) | |
| tree | ec080196950c0a91044b8a44a82503c53882c392 /sql/updates | |
| parent | 2910fa67d3830c3e624fcbf63dd777faa878a1fa (diff) | |
| parent | b6d43623a259f62ce0240a9e9f44f28e8c1ad5eb (diff) | |
Merge remote-tracking branch 'tkrokli/boss_majordomo_gossip' into 3.3.5 (PR #16726)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/3.3.5/2016_06_09_01_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_06_09_01_world.sql b/sql/updates/world/3.3.5/2016_06_09_01_world.sql new file mode 100644 index 00000000000..d3e597a182f --- /dev/null +++ b/sql/updates/world/3.3.5/2016_06_09_01_world.sql @@ -0,0 +1,14 @@ +-- Majordomo Executus' gossip when friendly (entry 12018 in 3.3.5) +UPDATE `creature_template` SET `gossip_menu_id` = 4093 WHERE `entry` = 12018; + +DELETE FROM `gossip_menu` WHERE `entry` IN (4108,4109,4093) AND `text_id` IN (4995,5011,5012); +INSERT INTO gossip_menu (`entry`,`text_id`) VALUES +(4093, 4995), -- 54404 (Majordomo Executus' DB entry ID from retail) +(4109, 5011), -- 54404 (Majordomo Executus' DB entry ID from retail) +(4108, 5012); -- 54404 (Majordomo Executus' DB entry ID from retail) + +DELETE FROM `gossip_menu_option` WHERE (`menu_id`=4108 AND `id`=0) OR (`menu_id`=4109 AND `id`=0) OR (`menu_id`=4093 AND `id`=0); +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`OptionBroadcastTextID`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`,`BoxBroadcastTextID`) VALUES +(4093,0,0, 'Tell me more.', 7675,1,1,4109,0,0,0,'',0); -- menu_id + text in TDB 6.04 +(4109,0,0, 'What else do you have to say?', 7673,1,1,4108,0,0,0,'',0), -- menu_id + text in TDB 6.04 +(4108,0,0, 'You challenged us and we have come. Where is this master you speak of?\n', 7646,1,1, 0,0,0,0,'',0), -- menu_id + text in TDB 6.04 |