Controlled Typhoon

-- SET @SpellID :=977725;
-- 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);
-- SELECT * FROM spell_proc where spellID IN (@SpellID, -@SpellID);

DELETE FROM `db_spellitemenchantment_12340` WHERE `ID`=977725;
INSERT INTO `db_spellitemenchantment_12340` VALUES (977725, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 977725, 0, 0, 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', 'Equip: Controlled Typhoon - Your Typhoon no longer knocks enemies back. It instead knocks you back. ', '', 16712190, 0, 0, 0, 0, 0, 0, 0);
DELETE FROM `item_enchantment_random_tiers` WHERE `enchantID`=977725;
INSERT INTO `item_enchantment_random_tiers` VALUES (977725, 1, 'ARMOR', NULL, 977725, 'Controlled Typhoon', 0, 100);
DELETE FROM `spell` WHERE `ID`=977725;
INSERT INTO `spell` VALUES (977725, 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, 1, 0, 0, 0, -1, -1, -1, 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, 56446, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5939, 0, 0, 'Controlled Typhoon', '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 Typhoon no longer knocks enemies back. It instead knocks you back. ', '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, 0, 0, 0);
DELETE FROM `spell_proc` WHERE `SpellId`=977725;
INSERT INTO `spell_proc` VALUES (977725, 0, 7, 0, 16777216, 0, 349524, 0, 1, 0, 0, 0, 0, 0, 0, '');