diff options
| author | Malcrom <malcromdev@gmail.com> | 2013-12-20 08:03:47 -0330 |
|---|---|---|
| committer | Malcrom <malcromdev@gmail.com> | 2013-12-20 08:03:47 -0330 |
| commit | eb57c4fed0181053614362e427e2d11a417a3b45 (patch) | |
| tree | af8ae25a39e15f0ef414f5376eeb9ad57fbb0136 | |
| parent | b2724cfeba0f92ae0f9b8e0edcc241c8fafbdd7a (diff) | |
DB/Conditions: Fix a condition in earlier commit
| -rw-r--r-- | sql/updates/world/2013_12_19_03_world_misc.sql | 6 | ||||
| -rw-r--r-- | sql/updates/world/2013_12_20_01_world_conditions.sql | 9 |
2 files changed, 12 insertions, 3 deletions
diff --git a/sql/updates/world/2013_12_19_03_world_misc.sql b/sql/updates/world/2013_12_19_03_world_misc.sql index ae6b7bb07e2..a5fea989969 100644 --- a/sql/updates/world/2013_12_19_03_world_misc.sql +++ b/sql/updates/world/2013_12_19_03_world_misc.sql @@ -24,7 +24,7 @@ DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=56 INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES -- Both of these must be true (15,5675,0,0,0,14,0,7785,0,0,0,0,0, '', 'Gossip Option - Show Option if Quest 7785 is not taken'), -(15,5675,0,1,0,2,0,19016,1,0,1,0,0, '', 'Gossip Option - Show Option if player does not have Vessel of Rebirth'), +(15,5675,0,0,1,2,0,19016,1,0,1,0,0, '', 'Gossip Option - Show Option if player does not have Vessel of Rebirth'), -- One of these must be true -(15,5675,0,2,0,2,0,18563,0,0,1,0,0, '', 'Gossip Option - Show Option if player has Bindings of the Windseeker'), -(15,5675,0,2,0,2,0,18564,0,0,1,0,0, '', 'Gossip Option - Show Option if player has Bindings of the Windseeker'); +(15,5675,0,0,2,2,0,18563,1,0,1,0,0, '', 'Gossip Option - Show Option if player has Bindings of the Windseeker'), +(15,5675,0,0,2,2,0,18564,1,0,1,0,0, '', 'Gossip Option - Show Option if player has Bindings of the Windseeker'); diff --git a/sql/updates/world/2013_12_20_01_world_conditions.sql b/sql/updates/world/2013_12_20_01_world_conditions.sql new file mode 100644 index 00000000000..e703d697e57 --- /dev/null +++ b/sql/updates/world/2013_12_20_01_world_conditions.sql @@ -0,0 +1,9 @@ +-- Add Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=5675; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +-- Both of these must be true +(15,5675,0,0,0,14,0,7785,0,0,0,0,0, '', 'Gossip Option - Show Option if Quest 7785 is not taken'), +(15,5675,0,0,1,2,0,19016,1,0,1,0,0, '', 'Gossip Option - Show Option if player does not have Vessel of Rebirth'), +-- One of these must be true +(15,5675,0,0,2,2,0,18563,1,0,1,0,0, '', 'Gossip Option - Show Option if player has Bindings of the Windseeker'), +(15,5675,0,0,2,2,0,18564,1,0,1,0,0, '', 'Gossip Option - Show Option if player has Bindings of the Windseeker'); |