From d608c1f43a76f2dd46fe54c5da67dcc19a3c8d28 Mon Sep 17 00:00:00 2001 From: nelegalno Date: Sun, 8 Jan 2012 11:25:55 +0100 Subject: DB/Quest: add conditions to Slaves to Saronite Closes #4378 --- sql/updates/world/2012_01_08_05_world_conditions.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/2012_01_08_05_world_conditions.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_01_08_05_world_conditions.sql b/sql/updates/world/2012_01_08_05_world_conditions.sql new file mode 100644 index 00000000000..b8e43e7d0e2 --- /dev/null +++ b/sql/updates/world/2012_01_08_05_world_conditions.sql @@ -0,0 +1,10 @@ +-- Slaves to Saronite add conditions for Horde version 10 +SET @QUEST_A := 13300; +SET @QUEST_H := 13302; +SET @GOSSIP := 10137; + +-- Only show gossip if player is on quest Slaves to Saronite +DELETE FROM `conditions` WHERE `SourceGroup`=@GOSSIP AND `ConditionValue1` IN (@QUEST_A,@QUEST_H); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`COMMENT`) VALUES +(15,@GOSSIP,0,0,9,@QUEST_A,0,0,0,'',"Only show first gossip if player is on quest Slaves to Saronite Alliance"), +(15,@GOSSIP,0,0,9,@QUEST_H,0,0,0,'',"Only show first gossip if player is on quest Slaves to Saronite Horde"); \ No newline at end of file -- cgit v1.2.3