balakethelock
9cfcf9eb6f
* Fix Spell Scaling with Level formula Classic testing has shown the formula is based on CLS * Migration to remove some spell damage hackfixes The hack fixes were attempts to make mob spell damage fit the old wrong formula. If the formula is to made accurate, these hack fixes need to be removed.
24 lines
935 B
SQL
24 lines
935 B
SQL
DROP PROCEDURE IF EXISTS add_migration;
|
|
delimiter ??
|
|
CREATE PROCEDURE `add_migration`()
|
|
BEGIN
|
|
DECLARE v INT DEFAULT 1;
|
|
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20230706092629');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20230706092629');
|
|
-- Add your query below.
|
|
|
|
-- Remove hack fixes to spell damage that tried to balance some abilities damage according to the old incorrect formula
|
|
DELETE FROM `spell_effect_mod` WHERE `Id`=26194; -- Skeram earth shock
|
|
DELETE FROM `spell_effect_mod` WHERE `Id`=26192; -- Skeram arcane explosion
|
|
DELETE FROM `spell_effect_mod` WHERE `Id`=14297; -- Anubisath Guardian Shadow Storm
|
|
DELETE FROM `spell_effect_mod` WHERE `Id`=26546; -- Anubisath Sentinel Shadow Storm
|
|
DELETE FROM `spell_effect_mod` WHERE `Id`=26555; -- Anubisath Defender Shadow Storm
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|