Controlled Blast

-- SET @SpellID :=977724;
-- SELECT * FROM db_spellitemenchantment_12340 WHERE effectarg_1 = @SpellID;
-- SELECT * FROM item_enchantment_random_tiers WHERE spellid = @SpellID;
-- SELECT * FROM spell where ID IN (@SpellID);

DELETE FROM `db_spellitemenchantment_12340` WHERE `ID`=977724;
INSERT INTO `db_spellitemenchantment_12340` VALUES (977724, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 977724, 0, 0, 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', 'Equip: Controlled Blast - Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', '', 16712190, 0, 0, 0, 0, 0, 0, 0);
DELETE FROM `item_enchantment_random_tiers` WHERE `enchantID`=977724;
INSERT INTO `item_enchantment_random_tiers` VALUES (977724, 1, 'ARMOR', NULL, 977724, 'Controlled Blast', 0, 100);
DELETE FROM `spell` WHERE `ID`=977724;
INSERT INTO `spell` VALUES (977724, 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, 6, 6, 1, 1, 1, 0, 0, 0, -15001, -51, -101, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 107, 108, 108, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 14, 23, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 64, 0, 0, 64, 0, 0, 64, 0, 0, 0, 24746, 0, 0, 'Controlled Blast', '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, 'Your Blast Wave no longer knocks enemies back. Its cooldown is reduced by 15 seconds and mana cost by 50%.', '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);