aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorWyreth <Wyreth@users.noreply.github.com>2017-09-27 22:16:51 +0200
committerKillyana <morphone1@gmail.com>2017-09-27 22:16:51 +0200
commit016dafba2efdf520bb418b621c909f48ab048282 (patch)
tree53220d3026281d03bc758995652138a6d6adb580
parenta29b42fc0026896ca95185cc162342bef92b9436 (diff)
DB/Gossip: Petra Grossen
Closes #20455
-rw-r--r--sql/updates/world/3.3.5/2017_09_27_05_world_335.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_09_27_05_world_335.sql b/sql/updates/world/3.3.5/2017_09_27_05_world_335.sql
new file mode 100644
index 00000000000..f25ec9f3af4
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_09_27_05_world_335.sql
@@ -0,0 +1,6 @@
+--
+SET @MENUID := 2421;
+UPDATE `creature_template` SET `gossip_menu_id`=@MENUID WHERE `entry`=9273;
+DELETE FROM `gossip_menu` WHERE `MenuID`=@MENUID;
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(@MENUID, 3093, 0);