TrinityCore/TrinityCore — Issue #4984: Some missing conditions
Author: malcrom
Created: 2012-01-28 16:09:55+00:00
State: open
Labels: Database-Miscellaneous

```SQL
-- Gossip Condition for Archmage Celindra
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9777;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(14,9777,13456,0,15,128,0,0,0,'','Show gossip text if player is mage');

-- Quest Conditions for Lorekeeper Lydros
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=20 AND `SourceEntry` IN (7483,7484,8485);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(20,0,7483,0,8,7481,0,0,0,'','Show quest Libram of Rapidity if quest Elven Legends rewared'),
(20,0,7484,0,8,7481,0,0,0,'','Show quest Libram of Focus if quest Elven Legends rewared'),
(20,0,7485,0,8,7481,0,0,0,'','Show quest Libram of Protection if quest Elven Legends rewared'),
(20,0,7483,1,8,7482,0,0,0,'','Show quest Libram of Rapidity if quest Elven Legends rewared'),
(20,0,7484,1,8,7482,0,0,0,'','Show quest Libram of Focus if quest Elven Legends rewared'),
(20,0,7485,1,8,7482,0,0,0,'','Show quest Libram of Protection if quest Elven Legends rewared');
```