aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2015-10-04 19:33:33 +0200
committerMitchesD <majklprofik@seznam.cz>2015-11-06 13:20:11 +0100
commit8d73d432c3a7be03070fce2d2701e228724d20e3 (patch)
tree76927723a4689172de09cf381b192e3bf0afa8cc /sql
parent286f0ea6f3448038ba5e55b201d62be2db804746 (diff)
DB/gossip: Add missing gossips to Garrosh Hellscream
(cherry picked from commit 3b544a35777005e606bcfad7cbaab7dfa85f0ba1)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2015_11_06_40_world_2015_10_04_03.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2015_11_06_40_world_2015_10_04_03.sql b/sql/updates/world/2015_11_06_40_world_2015_10_04_03.sql
new file mode 100644
index 00000000000..693d88687ce
--- /dev/null
+++ b/sql/updates/world/2015_11_06_40_world_2015_10_04_03.sql
@@ -0,0 +1,7 @@
+--
+DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (11206,11207);
+INSERT IGNORE INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `OptionBroadcastTextID`) VALUE
+(11206, 0, 0, 'Northrend requires your attention Overlord Hellscream. We will deal with the Lich King and his minions without your aid.', 1, 1, 11207, 0, 0, 0, '', 39416),
+(11207, 0, 0, 'The word is given. The Lich King will die by our hands!', 1, 1, 11208, 0, 0, 0, '', 39415);
+UPDATE `npc_text` SET `BroadcastTextID0`=39418 WHERE `id`=15608;
+UPDATE `npc_text` SET `BroadcastTextID0`=39419 WHERE `id`=15609;