From 83a31eaf962728e3323765a089d6c933332f6d3c Mon Sep 17 00:00:00 2001 From: Malcrom Date: Tue, 16 Jul 2013 21:36:37 -0230 Subject: DB/Conditions: Fix error in a previous commit. --- sql/updates/world/2013_07_17_01_world_conditions.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/2013_07_17_01_world_conditions.sql (limited to 'sql') diff --git a/sql/updates/world/2013_07_17_01_world_conditions.sql b/sql/updates/world/2013_07_17_01_world_conditions.sql new file mode 100644 index 00000000000..4528d39943c --- /dev/null +++ b/sql/updates/world/2013_07_17_01_world_conditions.sql @@ -0,0 +1,10 @@ +-- Gossip Menu Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=21; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(14,21,518,0,0,27,0,10,3,0,0,'','Gossip text requires level 10 or higher'), +(14,21,519,0,0,27,0,10,2,0,0,'','Gossip text requires lower than level 10'); +-- Gossip Options Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=21; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,21,0,0,0,27,0,10,3,0,0,'','Gossip Option requires level 10 or higher'), +(15,21,1,0,0,9,0,6981,0,0,0,'','Gossip Option requires quest not complete'); -- cgit v1.2.3