From 33ce20b021a0d848a3c33058e8757bc3bddee970 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sun, 9 Apr 2017 16:26:18 +0200 Subject: DB/Gossip: Add broadcast gossip text for Argent Gruntling/Argent Squire Closes #19402 --- sql/updates/world/3.3.5/2017_04_09_02_world.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_04_09_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_04_09_02_world.sql b/sql/updates/world/3.3.5/2017_04_09_02_world.sql new file mode 100644 index 00000000000..4912554985d --- /dev/null +++ b/sql/updates/world/3.3.5/2017_04_09_02_world.sql @@ -0,0 +1,18 @@ +-- +-- Argent Tournament Champion's Pennant gossip option texts +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=35513 WHERE `menu_id`=10317 AND `id`=0; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=35515 WHERE `menu_id`=10317 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=35534 WHERE `menu_id`=10317 AND `id`=2; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33681, `option_text`="Darkspear Champion's Pennant" WHERE `menu_id`=10317 AND `id`=3; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33682, `option_text`="Forsaken Champion's Pennant" WHERE `menu_id`=10317 AND `id`=4; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33683 WHERE `menu_id`=10317 AND `id`=5; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33685 WHERE `menu_id`=10317 AND `id`=6; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33686 WHERE `menu_id`=10317 AND `id`=7; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=35513 WHERE `menu_id`=10318 AND `id`=0; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=35515 WHERE `menu_id`=10318 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=35534 WHERE `menu_id`=10318 AND `id`=2; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33675 WHERE `menu_id`=10318 AND `id`=3; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33676 WHERE `menu_id`=10318 AND `id`=4; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33678 WHERE `menu_id`=10318 AND `id`=5; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33679 WHERE `menu_id`=10318 AND `id`=6; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33401 WHERE `menu_id`=10318 AND `id`=7; -- cgit v1.2.3