aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2015_02_15_09_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2015_02_15_09_world.sql b/sql/updates/world/2015_02_15_09_world.sql
new file mode 100644
index 00000000000..1e2ca3b9f1c
--- /dev/null
+++ b/sql/updates/world/2015_02_15_09_world.sql
@@ -0,0 +1,10 @@
+--
+DELETE FROM `gossip_menu` WHERE `entry`=40060;
+INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
+(40060, 2494),
+(40060, 2493);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=40060 AND `SourceEntry` IN (2494, 2493);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `Comment`) VALUES
+(14, 40060, 2494, 0, 0, 8, 0, 4023, 0, 0, 1, 0, 0, 'Show gossip text if player do not has quest 4023 completed'),
+(14, 40060, 2493, 0, 1, 8, 0, 4022, 0, 0, 1, 0, 0, 'Show gossip text if player do not has quest 4022 completed');