API tools faq
paste
IcariumQA

Conditions, 31 fix

IcariumQA
Dec 16th, 2020 (edited)
105
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 9.56 KB | None | 0 0
raw download clone embed print report
  1. #Delete old values
  2. DELETE FROM conditions WHERE sourcetypeorreferenceid = 31;
  3.  
  4. #Insert new values
  5. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=2 AND `SourceEntry`=979768 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=55 AND `ConditionTarget`=0 AND `ConditionValue1`=414000 AND `ConditionValue2`=3 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  6. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 2, 979768, 0, 0, 55, 0, 414000, 3, 0, 0, 0, 0, '', 'Here Comes the Big One - proc only if player has 3 stacks of 414000');
  7. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=4 AND `SourceEntry`=979769 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=55 AND `ConditionTarget`=0 AND `ConditionValue1`=414003 AND `ConditionValue2`=13 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  8. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 3, 979769, 0, 0, 55, 0, 414003, 13, 0, 0, 0, 0, '', 'Zephyr Proc');
  9. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=2 AND `SourceEntry`=414029 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=55 AND `ConditionTarget`=0 AND `ConditionValue1`=414030 AND `ConditionValue2`=2 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  10. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 2, 414029, 0, 0, 55, 0, 414030, 2, 0, 0, 0, 0, '', 'Fire Fire Fireball');
  11. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=2 AND `SourceEntry`=965894 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=63 AND `ConditionTarget`=1 AND `ConditionValue1`=7 AND `ConditionValue2`=0 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  12. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 2, 965894, 0, 0, 63, 1, 7, 0, 0, 0, 0, 0, '', 'Total Eclipse - Target Is Root Immune');
  13. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=2 AND `SourceEntry`=965896 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=63 AND `ConditionTarget`=1 AND `ConditionValue1`=12 AND `ConditionValue2`=0 AND `ConditionValue3`=0 AND `NegativeCondition`=1 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  14. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 2, 965896, 0, 0, 63, 1, 12, 0, 0, 1, 0, 0, '', 'Total Eclipse - Target Is Not Stun Immune');
  15. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=2 AND `SourceEntry`=977700 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=55 AND `ConditionTarget`=0 AND `ConditionValue1`=977701 AND `ConditionValue2`=5 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  16. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 2, 977700, 0, 0, 55, 0, 977701, 5, 0, 0, 0, 0, '', 'Nimzo Heavyweight Proc');
  17. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=2 AND `SourceEntry`=979769 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=55 AND `ConditionTarget`=0 AND `ConditionValue1`=414003 AND `ConditionValue2`=11 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  18. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 2, 979769, 0, 0, 55, 0, 414003, 11, 0, 0, 0, 0, '', 'Zephyr Proc');
  19. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=2 AND `SourceEntry`=980048 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=55 AND `ConditionTarget`=0 AND `ConditionValue1`=980051 AND `ConditionValue2`=3 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  20. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 2, 980048, 0, 0, 55, 0, 980051, 3, 0, 0, 0, 0, '', 'Master of Shadows Dmg proc at 3 stacks only');
  21. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=1 AND `SourceEntry`=414005 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=55 AND `ConditionTarget`=0 AND `ConditionValue1`=15258 AND `ConditionValue2`=5 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  22. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 1, 414005, 0, 0, 55, 0, 15258, 5, 0, 0, 0, 0, '', 'Entropius\' Fury Shadow Weave Stacker');
  23. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=1 AND `SourceEntry`=414030 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=55 AND `ConditionTarget`=0 AND `ConditionValue1`=414030 AND `ConditionValue2`=3 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  24. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 1, 414030, 0, 0, 55, 0, 414030, 3, 0, 0, 0, 0, '', 'Fire Fire Fireball');
  25. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=1 AND `SourceEntry`=965894 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=63 AND `ConditionTarget`=1 AND `ConditionValue1`=7 AND `ConditionValue2`=0 AND `ConditionValue3`=0 AND `NegativeCondition`=1 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  26. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 1, 965894, 0, 0, 63, 1, 7, 0, 0, 1, 0, 0, '', 'Total Eclipse - Target Is Not Root Immune');
  27. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=1 AND `SourceEntry`=965896 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=63 AND `ConditionTarget`=1 AND `ConditionValue1`=12 AND `ConditionValue2`=0 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  28. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 1, 965896, 0, 0, 63, 1, 12, 0, 0, 0, 0, 0, '', 'Total Eclipse - Target Is Stun Immune');
  29. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=1 AND `SourceEntry`=978713 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=55 AND `ConditionTarget`=0 AND `ConditionValue1`=63734 AND `ConditionValue2`=3 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
  30. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (31, 1, 978713, 0, 0, 55, 0, 63734, 3, 0, 0, 0, 0, '', 'Good Fortune req 3 Serendipity');
  31.  
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!