aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2018-05-31 09:22:31 +0200
committerKillyana <email@example.com>2018-05-31 09:22:31 +0200
commita4db2d0a0d450d04ffd08eb328809a21c3a90cf0 (patch)
tree22738977414b4b581b7a49ecae4020a9c5bb6543
parent9fe6b426788623ff14874f0c88eaca154986a7bb (diff)
DB/Gossip: Lady Jaina Proudmoore
Closes #21985
-rw-r--r--sql/updates/world/3.3.5/2018_05_31_03_world_335.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_05_31_03_world_335.sql b/sql/updates/world/3.3.5/2018_05_31_03_world_335.sql
new file mode 100644
index 00000000000..3ccdbc07a73
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_05_31_03_world_335.sql
@@ -0,0 +1,4 @@
+-- Lady Jaina Proudmoore
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=2465;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(14,2465,3158,0,0,8,0,1267,0,0,0,0,0,"","Show gossip text 3158 if quest 'The Missing Diplomat (Part 17)' is rewarded");