Create a new version of paste:

DELETE FROM `db_spellitemenchantment_12340` WHERE `ID`=977764;
INSERT INTO `db_spellitemenchantment_12340` VALUES (977764, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 977764, 0, 0, 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'Equip: Biting Cold - Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', '', 16712190, 0, 0, 0, 0, 0, 0, 0);
DELETE FROM `item_enchantment_random_tiers` WHERE `enchantID`=977764;
INSERT INTO `item_enchantment_random_tiers` VALUES (977764, 1, 'ARMOR', NULL, 977764, 'Biting Cold', 0, 100);
DELETE FROM `spell` WHERE `ID`=860103;
INSERT INTO `spell` VALUES (860103, 0, 0, 0, 327696, 134218240, 1073741824, 16777216, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 6000, 0, 0, 0, 0, 0, 101, 0, 0, 41, 41, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 41105, 4194304, 31, 3, 2, 1, 1, 1, 0, 0, 0, 124, 24, 0, 0, 0, 0, 6, 6, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 120784, 0, 25397, 0, 50, 'Ice Lash', 'Lava Lash', 'Fouet de lave', 'Lavapeitsche', '熔岩暴擊', '熔岩暴擊', 'Latigazo de lava', 'Latigazo de lava', 'Вскипание лавы', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 1', 'Rank 1', 'Rang 1', 'Rang 1', '等級 1', '等級 1', 'Rango 1', 'Rango 1', 'Уровень 1', 0, 0, 0, 0, 0, 0, 0, 16712190, 'You charge your off-hand weapon with ice, instantly dealing $s1% off-hand Weapon damage. This damage is not subject to off-hand damage modifiers, and is increased by $s2% if your off-hand weapon is enchanted with Frostbrand.', 'You charge your one-handed off-hand weapon with lava, instantly dealing $s1% off-hand Weapon damage. Damage is increased by $s2% if your off-hand weapon is enchanted with Flametongue. ', 'Vous chargez votre arme en main gauche de lave, infligeant instantanément $s1% des dégâts de l\'arme en main gauche. Les dégâts sont augmentés de $s2% si votre arme en main gauche est enchantée avec Langue de feu.', 'Lädt Eure Schildhandwaffe mit Lava auf, verursacht sofort $s1% Waffenschaden der Schildhandwaffe. Der Schaden ist um $s2% erhöht, wenn Eure Schildhandwaffe mit \'Flammenzunge\' verzaubert ist.', '你以熔岩的能量強化你的副手武器，立即對目標造成$s1%副手武器傷害。若你的副手武器附帶火舌武器效果時，此傷害提高$s2%。', '你以熔岩的能量強化你的副手武器，立即對目標造成$s1%副手武器傷害。若你的副手武器附帶火舌武器效果時，此傷害提高$s2%。', 'Cargas con lava el arma de tu mano izquierda e infliges instantáneamente un $s1% de daño con arma con tu mano izquierda. El daño aumenta un $s2% si tu arma de mano izquierda está encantada con Lengua de Fuego.', 'Cargas con lava el arma de tu mano izquierda e infliges instantáneamente un $s1% de daño con arma con tu mano izquierda. El daño aumenta un $s2% si tu arma de mano izquierda está encantada con Lengua de Fuego.', 'Вы заряжаете оружие в левой руке энергией лавы и мгновенно наносите противнику урон в размере $s1% от урона этого оружия. Если это оружие зачаровано "Языком пламени", наносимый урон увеличивается на $s2%.', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 4, 133, 1500, 0, 11, 0, 0, 4, 0, 2, 2, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0.001, 0, 0);
DELETE FROM `spell` WHERE `ID`=977764;
INSERT INTO `spell` VALUES (977764, 0, 0, 0, 464, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 6, 0, 0, 1, 1, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 977765, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25397, 0, 0, 'Biting Cold', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 5', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Your Lava Lash is transformed into Ice Lash, dealing Frost damage and giving you a stack of Biting Cold, increasing the damage of your Frostbolt and Ice Lance based on your attack power. If cast while Fingers of Frost is active, Ice Lash is guaranteed to critically hit and recharge your Fingers of Frost.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
DELETE FROM `spell` WHERE `ID`=977765;
INSERT INTO `spell` VALUES (977765, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 6, 6, 64, 1, 1, 0, 0, 0, 0, 9, 1, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 107, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32, 32, 0, 0, 0, 0, 0, 0, 977766, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25397, 0, 0, 'Biting Cold', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 0, 0, 0, 0, 0, 0, 0, 16712190, '', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Frostbolt damage increased by $s1% of your attack power. Ice Lance damage increased by $s2% of your attack power.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Frostbolt damage increased by $s1% of your attack power. Ice Lance damage increased by $s2% of your attack power.', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
DELETE FROM `spell` WHERE `ID`=977766;
INSERT INTO `spell` VALUES (977766, 0, 0, 0, 464, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 64, 0, 0, 1, 1, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 74396, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18965, 0, 0, 'Biting Cold FoF recharge', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 'Unknown Spell', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 'Rank 4', 0, 0, 0, 0, 0, 0, 0, 16712190, 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 'If you\'re reading this you need to update your patch.', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0);
DELETE FROM `spell_proc` WHERE `SpellId`=977764;
INSERT INTO `spell_proc` VALUES (977764, 16, 11, 0, 0, 4, 16, 1, 2, 3, 0, 0, 100, 0, 0, 'Molten Earth');

DELETE FROM `spell_script_names` WHERE `spell_id`=860103 AND `ScriptName`='spell_ice_lash';
INSERT INTO `spell_script_names` VALUES (860103, 'spell_ice_lash');
DELETE FROM `spell_bonus_data` WHERE `entry`=860103;
INSERT INTO `spell_bonus_data` VALUES (860103, 0.001, -1, -1, -1, 'Shaman - Ice Lash');
DELETE FROM `spell_bonus_data` WHERE `entry`=116;
INSERT INTO `spell_bonus_data` VALUES (116, 0.462, -1, 0.00001, -1, 'Mage - Frostbolt');
DELETE FROM `spell_bonus_data` WHERE `entry`=30455;
INSERT INTO `spell_bonus_data` VALUES (30455, 0.08, -1, 0.00001, -1, 'Mage - Ice Lance');
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=977766 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=1 AND `ConditionTarget`=0 AND `ConditionValue1`=74396 AND `ConditionValue2`=0 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
INSERT INTO `conditions` VALUES (17, 0, 977766, 0, 0, 1, 0, 74396, 0, 0, 0, 0, 0, '', 'Biting Cold Fingers of Frost recharge');
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=60103 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=1 AND `ConditionTarget`=0 AND `ConditionValue1`=977764 AND `ConditionValue2`=0 AND `ConditionValue3`=0 AND `NegativeCondition`=1 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
INSERT INTO `conditions` VALUES (17, 0, 60103, 0, 0, 1, 0, 977764, 0, 0, 1, 0, 0, '', 'Cant cast Lava Lash with Biting Cold RE');
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=977767 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=1 AND `ConditionTarget`=0 AND `ConditionValue1`=977764 AND `ConditionValue2`=0 AND `ConditionValue3`=0 AND `NegativeCondition`=0 AND `ErrorType`=0 AND `ErrorTextId`=0 AND `ScriptName`='';
INSERT INTO `conditions` VALUES (17, 0, 977767, 0, 0, 1, 0, 977764, 0, 0, 0, 0, 0, '', 'Ice Lash crit req Biting Cold RE');
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-74396 AND `spell_effect`=-977767 AND `type`=0;
INSERT INTO `spell_linked_spell` VALUES (-74396, -977767, 0, 'Fingers of Frost gives Ice Lash crit');
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=74396 AND `spell_effect`=977767 AND `type`=0;
INSERT INTO `spell_linked_spell` VALUES (74396, 977767, 0, 'Fingers of Frost gives Ice Lash crit');

#Green REs
DELETE FROM `spell_affect` WHERE `entry`=99984 AND `effectId`=0 AND `spellId`=-860103;
INSERT INTO `spell_affect` VALUES (99984, 0, -860103, 'Powerful Lava Lash (EFF_0) -> Ice Lash (ALL RANKS)');
DELETE FROM `spell_affect` WHERE `entry`=99986 AND `effectId`=0 AND `spellId`=-860103;
INSERT INTO `spell_affect` VALUES (99986, 0, -860103, 'Taunting Lava Lash (EFF_0) -> Ice Lash (ALL RANKS)');
DELETE FROM `spell_affect` WHERE `entry`=99989 AND `effectId`=0 AND `spellId`=-860103;
INSERT INTO `spell_affect` VALUES (99989, 0, -860103, 'Critical Lava Lash (EFF_0) -> Ice Lash (ALL RANKS)');
DELETE FROM `spell_affect` WHERE `entry`=99993 AND `effectId`=0 AND `spellId`=-860103;
INSERT INTO `spell_affect` VALUES (99993, 0, -860103, 'Hasty Lava Lash (EFF_0) -> Ice Lash (ALL RANKS)');
DELETE FROM `spell_affect` WHERE `entry`=99994 AND `effectId`=0 AND `spellId`=-860103;
INSERT INTO `spell_affect` VALUES (99994, 0, -860103, 'Penetrating Lava Lash (EFF_0) -> Ice Lash (ALL RANKS)');
DELETE FROM `spell_affect` WHERE `entry`=99995 AND `effectId`=0 AND `spellId`=-860103;
INSERT INTO `spell_affect` VALUES (99995, 0, -860103, 'Concentrated Lava Lash (EFF_0) -> Ice Lash (ALL RANKS)');
DELETE FROM `spell_affect` WHERE `entry`=99996 AND `effectId`=0 AND `spellId`=-860103;
INSERT INTO `spell_affect` VALUES (99996, 0, -860103, 'Brutal Lava Lash (EFF_0) -> Ice Lash (ALL RANKS)');
DELETE FROM `spell_affect` WHERE `entry`=99997 AND `effectId`=0 AND `spellId`=-860103;
INSERT INTO `spell_affect` VALUES (99997, 0, -860103, 'Accurate Lava Lash (EFF_0) -> Ice Lash (ALL RANKS)');
DELETE FROM `spell_affect` WHERE `entry`=100009 AND `effectId`=0 AND `spellId`=-860103;
INSERT INTO `spell_affect` VALUES (100009, 0, -860103, 'Focused Lava Lash (EFF_0) -> Ice Lash (ALL RANKS)');
DELETE FROM `spell_affect` WHERE `entry`=101073 AND `effectId`=0 AND `spellId`=-860103;
INSERT INTO `spell_affect` VALUES (101073, 0, -860103, 'Subtle Lava Lash (EFF_0) -> Ice Lash (ALL RANKS)');