IcariumQA

Mana Fiend no Recovery fix

Apr 26th, 2021 (edited)
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.45 KB | None | 0 0
  1. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=977874 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=60 AND `ConditionTarget`=0 AND `ConditionValue1`=20 AND `ConditionValue2`=2 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  2. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (17, 0, 977874, 0, 0, 60, 0, 20, 2, 0, 0, 0, 0, '', 'Mana Recharge when below 20% mana');
  3. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=977876 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=60 AND `ConditionTarget`=0 AND `ConditionValue1`=20 AND `ConditionValue2`=2 AND `ConditionValue3`=0 AND `NegativeCondition`=1 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  4. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (17, 0, 977876, 0, 0, 60, 0, 20, 2, 0, 1, 0, 0, '', 'No Mana Delirium when below 20% mana');
  5.  
Add Comment
Please, Sign In to add comment