aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2018-04-04 02:37:30 +0200
committerKillyana <morphone1@gmail.com>2018-04-04 02:37:30 +0200
commit128eb770bd62f15e5cfbe797f3c5432ed77edbd0 (patch)
tree39ec4bdcca7e1a68debfc5f6dadfac3f4f5ff5d2
parentc9db048a4fa23313b2f03ca2ddf2c48d351717f0 (diff)
DB/Gossip: Champion Cyssa Dawnrose
Closes #21767
-rw-r--r--sql/updates/world/3.3.5/2018_04_04_05_world_335.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_04_04_05_world_335.sql b/sql/updates/world/3.3.5/2018_04_04_05_world_335.sql
new file mode 100644
index 00000000000..d1371d992d0
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_04_04_05_world_335.sql
@@ -0,0 +1,6 @@
+-- Champion Cyssa Dawnrose --> Fix gossip text
+DELETE FROM `gossip_menu` WHERE `MenuID`=8111 AND `TextID` IN (10040,10044);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(8111,10044,0);
+
+UPDATE `conditions` SET `SourceEntry`=10044 WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=8111 AND `SourceEntry`=10040;