diff options
-rw-r--r-- | sql/updates/world/master/2021_10_03_00_world.sql | 81 |
1 files changed, 81 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_10_03_00_world.sql b/sql/updates/world/master/2021_10_03_00_world.sql new file mode 100644 index 00000000000..2fee0383707 --- /dev/null +++ b/sql/updates/world/master/2021_10_03_00_world.sql @@ -0,0 +1,81 @@ +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (15367,15298,15273,20100,20244,20098,15291,43010,15468,15289,15287,15296,15284,15297,15285,15280,15513,15279,15295,15292,63332,44857,15283,15494,44937,15278,15281,15366,15274,15372,15294,15271,15301,15371,17849,17047,16270,16923,16271,43012,15403,15638,15644,16916,18929,16924,16259,44244,15418,15493,16266,63080,16267,63079,16186,16185,15433,18926,16276,16269,15416,15940)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(15367, 0, 0, 0, 1485, 40120), +(15298, 0, 0, 0, 1485, 40120), +(15273, 0, 0, 0, 1485, 40120), +(20100, 0, 0, 0, 1485, 40120), +(20244, 0, 0, 0, 1485, 40120), +(20098, 0, 0, 0, 1485, 40120), +(15291, 0, 0, 0, 1485, 40120), +(43010, 0, 0, 0, 1485, 40120), +(15468, 0, 0, 0, 1485, 40120), +(15289, 0, 0, 0, 1485, 40120), +(15287, 0, 0, 0, 1485, 40120), +(15296, 0, 0, 0, 1485, 40120), +(15284, 0, 0, 0, 1485, 40120), +(15297, 0, 0, 0, 1485, 40120), +(15285, 0, 0, 0, 1485, 40120), +(15280, 0, 0, 0, 1485, 40120), +(15513, 0, 0, 0, 1485, 40120), +(15279, 0, 0, 0, 1485, 40120), +(15295, 0, 0, 0, 1485, 40120), +(15292, 0, 0, 0, 1485, 40120), +(63332, 0, 0, 0, 1485, 40120), +(44857, 0, 0, 0, 1485, 40120), +(15283, 0, 0, 0, 1485, 40120), +(15494, 0, 0, 0, 1485, 40120), +(44937, 0, 0, 0, 1485, 40120), +(15278, 0, 0, 0, 1485, 40120), +(15281, 0, 0, 0, 1485, 40120), +(15366, 0, 0, 0, 1485, 40120), +(15274, 0, 0, 0, 1485, 40120), +(15372, 0, 0, 0, 1485, 40120), +(15294, 0, 0, 0, 1485, 40120), +(15271, 0, 0, 0, 1485, 40120), +(15301, 0, 0, 0, 1485, 40120), +(15371, 0, 3, 3, 883, 40120), +(17849, 0, 0, 0, 77, 40120), +(17047, 0, 0, 0, 77, 40120), +(16270, 0, 0, 0, 77, 40120), +(16923, 0, 0, 0, 77, 40120), +(16271, 0, 0, 0, 77, 40120), +(43012, 0, 0, 0, 77, 40120), +(15403, 0, 0, 0, 77, 40120), +(15638, 0, 0, 0, 77, 40120), +(15644, 0, 0, 0, 77, 40120), +(16916, 0, 0, 0, 77, 40120), +(18929, 0, 0, 0, 77, 40120), +(16924, 0, 0, 0, 77, 40120), +(16259, 0, 0, 0, 77, 40120), +(44244, 0, 0, 0, 881, 40120), +(15418, 0, 0, 0, 77, 40120), +(15493, 0, 0, 0, 77, 40120), +(16266, 0, 0, 0, 77, 40120), +(63080, 0, 0, 0, 77, 40120), +(16267, 0, 0, 0, 77, 40120), +(63079, 0, 4, 4, 373, 40120), +(16186, 0, 0, 0, 77, 40120), +(16185, 0, 0, 0, 77, 40120), +(15433, 0, 0, 0, 77, 40120), +(18926, 0, 0, 0, 77, 40120), +(16276, 0, 0, 0, 77, 40120), +(16269, 0, 0, 0, 77, 40120), +(15416, 0, 0, 0, 77, 40120), +(15940, 0, 0, 0, 77, 40120); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=6491 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=89713 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=62019 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=6368 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=61142 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=1420 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=17213 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=61071 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=721 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=62020 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=13321 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=2914 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=16221 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=61080 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=15654 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=40120 WHERE (`Entry`=15649 AND `DifficultyID`=0); |