Prayer of Preservation buff

#DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=888595 AND `spell_effect`=888593 AND `type`=0;
#INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `flags`, `comment`) VALUES (888595, 888593, 0, 0, 'Prayer of Preservation gain crit on all ticks');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=888593 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=1 AND `ConditionTarget`=0 AND `ConditionValue1`=888593 AND `ConditionValue2`=0 AND `ConditionValue3`=0 AND `NegativeCondition`=1 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='' AND `CustomErrorTextId`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `CustomErrorTextId`, `ScriptName`, `Comment`) VALUES (17, 0, 888593, 0, 0, 1, 0, 888593, 0, 0, 1, 0, 0, 0, '', 'Prayer of Preservation give crit on all ticks but not refresh');
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=888594 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=55 AND `ConditionTarget`=0 AND `ConditionValue1`=888595 AND `ConditionValue2`=3 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='' AND `CustomErrorTextId`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `CustomErrorTextId`, `ScriptName`, `Comment`) VALUES (17, 0, 888594, 0, 0, 55, 0, 888595, 3, 0, 0, 0, 0, 0, '', 'Prayer of Preservation final buff req 3 stacks');

#DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=888597 AND `spell_effect`=888593 AND `type`=0;
#INSERT INTO `spell_linked_spell` VALUES (888597, 888593, 0, 0, 'Prayer of Preservation gain crit on all ticks');


DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=888581 AND `spell_effect`=888593 AND `type`=1;
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `flags`, `comment`) VALUES (888581, 888593, 1, 0, 'Prayer of Preservation gain crit on all ticks');
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=888582 AND `spell_effect`=888593 AND `type`=1;
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `flags`, `comment`) VALUES (888582, 888593, 1, 0, 'Prayer of Preservation gain crit on all ticks');
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=888583 AND `spell_effect`=888593 AND `type`=1;
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `flags`, `comment`) VALUES (888583, 888593, 1, 0, 'Prayer of Preservation gain crit on all ticks');
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=888584 AND `spell_effect`=888593 AND `type`=1;
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `flags`, `comment`) VALUES (888584, 888593, 1, 0, 'Prayer of Preservation gain crit on all ticks');
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=888585 AND `spell_effect`=888593 AND `type`=1;
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `flags`, `comment`) VALUES (888585, 888593, 1, 0, 'Prayer of Preservation gain crit on all ticks');
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=888586 AND `spell_effect`=888593 AND `type`=1;
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `flags`, `comment`) VALUES (888586, 888593, 1, 0, 'Prayer of Preservation gain crit on all ticks');
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=888587 AND `spell_effect`=888593 AND `type`=1;
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `flags`, `comment`) VALUES (888587, 888593, 1, 0, 'Prayer of Preservation gain crit on all ticks');