From 128eb770bd62f15e5cfbe797f3c5432ed77edbd0 Mon Sep 17 00:00:00 2001
From: ZenoX92 <ZenoX92@users.noreply.github.com>
Date: Wed, 4 Apr 2018 02:37:30 +0200
Subject: DB/Gossip: Champion Cyssa Dawnrose

Closes #21767
---
 sql/updates/world/3.3.5/2018_04_04_05_world_335.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2018_04_04_05_world_335.sql

(limited to 'sql/updates')

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;
-- 
cgit v1.2.3