aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2018-08-02 18:55:01 +0200
committerKillyana <morphone1@gmail.com>2018-08-02 18:55:01 +0200
commitb885d353d28248c2705721fd05a9c08dd2ad33db (patch)
treeb7bbe8739702d8a97bbcb5f3a84fedcd12d44ae2
parentb56a5182f35dc98d2a00851544ab9bbd245ad500 (diff)
DB/Gossip: Brumn Winterhoof
Closes #22206
-rw-r--r--sql/updates/world/3.3.5/2018_08_02_02_world_335.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_08_02_02_world_335.sql b/sql/updates/world/3.3.5/2018_08_02_02_world_335.sql
new file mode 100644
index 00000000000..5678c5ab46c
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_08_02_02_world_335.sql
@@ -0,0 +1,10 @@
+-- Brumn Winterhoof
+UPDATE `creature_template` SET `gossip_menu_id`=3069 WHERE `entry`=7869;
+
+DELETE FROM `gossip_menu` WHERE `MenuID`=3069;
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(3069,3803,0);
+
+DELETE FROM `gossip_menu_option` WHERE `MenuID`=3069;
+INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES
+(3069,0,3,"I would like to train.",5597,5,16,0,0,0,0,"",0,0);