diff options
| author | nelegalno <nelegalno@yopmail.com> | 2012-07-22 02:08:31 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-07-22 02:08:31 +0100 |
| commit | da866ac132b6db17dee4a27111d2434be187ca57 (patch) | |
| tree | 5bcab857a501f92cbd0415849f250d220e510336 | |
| parent | 1aa317d5a86da22f5bbee384b1565f80bd9b4838 (diff) | |
DB/Quests: Add gossip conditions for quest Slaves to Saronite
Closes #7138
Signed-off-by: Nay <dnpd.dd@gmail.com>
| -rw-r--r-- | sql/updates/world/2012_07_22_01_world_conditions.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2012_07_22_01_world_conditions.sql b/sql/updates/world/2012_07_22_01_world_conditions.sql new file mode 100644 index 00000000000..333ae7f997f --- /dev/null +++ b/sql/updates/world/2012_07_22_01_world_conditions.sql @@ -0,0 +1,10 @@ +-- Saronite Mine Slave conditions +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`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15,@GOSSIP,0,0,0,9,0,@QUEST_A,0,0,0,0,'',"Only show first gossip if player is on quest Slaves to Saronite Alliance"), +(15,@GOSSIP,0,0,1,9,0,@QUEST_H,0,0,0,0,'',"Only show first gossip if player is on quest Slaves to Saronite Horde"); |