IcariumQA

Personal Bank no longer stacking

Aug 15th, 2021 (edited)
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.45 KB | None | 0 0
  1. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=100702 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=30 AND `ConditionTarget`=0 AND `ConditionValue1`=46 AND `ConditionValue2`=5 AND `ConditionValue3`=0 AND `NegativeCondition`=1 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='' AND `CustomErrorTextId`=79067;
  2. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `CustomErrorTextId`, `ScriptName`, `Comment`) VALUES (17, 0, 100702, 0, 0, 30, 0, 46, 5, 0, 1, 0, 0, 79067, '', 'Summon Personal Bank only if none (Felforged) present within 5 yards');
  3. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=100702 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=30 AND `ConditionTarget`=0 AND `ConditionValue1`=475001 AND `ConditionValue2`=5 AND `ConditionValue3`=0 AND `NegativeCondition`=1 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='' AND `CustomErrorTextId`=79067;
  4. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `CustomErrorTextId`, `ScriptName`, `Comment`) VALUES (17, 0, 100702, 0, 0, 30, 0, 475001, 5, 0, 1, 0, 0, 79067, '', 'Summon Personal Bank only if none (Alliance) present within 5 yards');
  5. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=100702 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=30 AND `ConditionTarget`=0 AND `ConditionValue1`=475002 AND `ConditionValue2`=5 AND `ConditionValue3`=0 AND `NegativeCondition`=1 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='' AND `CustomErrorTextId`=79067;
  6. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `CustomErrorTextId`, `ScriptName`, `Comment`) VALUES (17, 0, 100702, 0, 0, 30, 0, 475002, 5, 0, 1, 0, 0, 79067, '', 'Summon Personal Bank only if none (Horde) present within 5 yards');
  7.  
Add Comment
Please, Sign In to add comment