Trinitycore: DB/Scaling: Update creature_template_scaling (Sunstrider Isle)

[osleyder85]

Description:
When creating a Blood Elf and starting quest, the creatures do not catch the player's level.

DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (721,1420,2914,6145,6368,13321,15271,15273,15274,15278,15279,15280,15281,15283,15284,15285,15287,15289,15291,15292,15294,15295,15296,15297,15298,15301,15366,15367,15371,15372,15401,15403,15404,15405,15416,15418,15420,15433,15468,15493,15494,15501,15513,15635,15638,15644,15645,15647,15648,15649,15650,15651,15654,15668,15669,15921,15937,15938,15940,15941,15945,15946,15949,15968,16162,16185,16186,16221,16257,16258,16259,16262,16266,16267,16269,16270,16271,16272,16275,16276,16277,16279,16294,16916,16923,16924,17005,17047,17213,17849,18926,18929,18954,20098,20100,20244,43010,43012,44244,44857,44937,47421,61071,61080,61142,61369,62019,62020,63079,63080,63332));
INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingMin`, `LevelScalingMax`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES
(721, 0, 1, 1, 0, 0, 81, 36839),
(1420, 0, 1, 1, 0, 0, 81, 36839),
(2914, 0, 1, 1, 0, 0, 81, 36839),
(6145, 0, 1, 1, 0, 0, 81, 36839),
(6368, 0, 1, 1, 0, 0, 81, 36839),
(13321, 0, 1, 1, 0, 0, 81, 36839),
(15271, 0, 1, 20, 0, 0, 1485, 36839),
(15273, 0, 1, 20, 0, 0, 1485, 36839),
(15274, 0, 1, 20, 0, 0, 1485, 36839),
(15278, 0, 1, 20, 0, 0, 1485, 36839),
(15279, 0, 1, 20, 0, 0, 1485, 36839),
(15280, 0, 1, 20, 0, 0, 1485, 36839),
(15281, 0, 1, 20, 0, 0, 1485, 36839),
(15283, 0, 1, 20, 0, 0, 1485, 36839),
(15284, 0, 1, 20, 0, 0, 1485, 36839),
(15285, 0, 1, 20, 0, 0, 1485, 36839),
(15287, 0, 1, 20, 0, 0, 1485, 36839),
(15289, 0, 1, 20, 0, 0, 1485, 36839),
(15291, 0, 1, 20, 0, 0, 1485, 36839),
(15292, 0, 1, 20, 0, 0, 1485, 36839),
(15294, 0, 1, 20, 0, 0, 1485, 36839),
(15295, 0, 1, 20, 0, 0, 1485, 36839),
(15296, 0, 1, 20, 0, 0, 1485, 36839),
(15297, 0, 1, 20, 0, 0, 1485, 36839),
(15298, 0, 1, 20, 0, 0, 1485, 36839),
(15301, 0, 1, 20, 0, 0, 1485, 36839),
(15366, 0, 1, 20, 0, 0, 1485, 36839),
(15367, 0, 1, 20, 0, 0, 1485, 36839),
(15371, 0, 60, 60, 3, 3, 883, 36839),
(15372, 0, 1, 20, 0, 0, 1485, 36839),
(15401, 0, 1, 30, 0, 0, 77, 36839),
(15403, 0, 1, 30, 0, 0, 77, 36839),
(15404, 0, 1, 30, 0, 0, 77, 36839),
(15405, 0, 1, 30, 0, 0, 77, 36839),
(15416, 0, 1, 30, 0, 0, 77, 36839),
(15418, 0, 1, 30, 0, 0, 77, 36839),
(15420, 0, 1, 30, 0, 0, 77, 36839),
(15433, 0, 1, 30, 0, 0, 77, 36839),
(15468, 0, 1, 20, 0, 0, 1485, 36839),
(15493, 0, 1, 30, 0, 0, 77, 36839),
(15494, 0, 1, 20, 0, 0, 1485, 36839),
(15501, 0, 1, 30, 0, 0, 77, 36839),
(15513, 0, 1, 20, 0, 0, 1485, 36839),
(15635, 0, 1, 30, 0, 0, 77, 36839),
(15638, 0, 1, 30, 0, 0, 77, 36839),
(15644, 0, 1, 30, 0, 0, 77, 36839),
(15645, 0, 1, 30, 0, 0, 77, 36839),
(15647, 0, 1, 30, 0, 0, 77, 36839),
(15648, 0, 1, 30, 0, 0, 77, 36839),
(15649, 0, 1, 30, 0, 0, 77, 36839),
(15650, 0, 1, 30, 0, 0, 77, 36839),
(15651, 0, 1, 30, 0, 0, 77, 36839),
(15654, 0, 1, 30, 0, 0, 77, 36839),
(15668, 0, 1, 30, 0, 0, 77, 36839),
(15669, 0, 1, 30, 0, 0, 77, 36839),
(15921, 0, 1, 30, 0, 0, 77, 36839),
(15937, 0, 1, 30, 0, 0, 77, 36839),
(15938, 0, 1, 30, 0, 0, 77, 36839),
(15940, 0, 1, 30, 0, 0, 77, 36839),
(15941, 0, 1, 30, 0, 0, 77, 36839),
(15945, 0, 1, 30, 0, 0, 77, 36839),
(15946, 0, 1, 30, 0, 0, 77, 36839),
(15949, 0, 1, 30, 0, 0, 77, 36839),
(15968, 0, 1, 30, 0, 0, 77, 36839),
(16162, 0, 1, 30, 0, 0, 77, 36839),
(16185, 0, 1, 30, 0, 0, 77, 36839),
(16186, 0, 1, 30, 0, 0, 77, 36839),
(16221, 0, 1, 30, 0, 0, 77, 36839),
(16257, 0, 1, 30, 0, 0, 77, 36839),
(16258, 0, 1, 30, 0, 0, 77, 36839),
(16259, 0, 1, 30, 0, 0, 77, 36839),
(16262, 0, 1, 30, 0, 0, 77, 36839),
(16266, 0, 1, 30, 0, 0, 77, 36839),
(16267, 0, 1, 30, 0, 0, 77, 36839),
(16269, 0, 1, 30, 0, 0, 77, 36839),
(16270, 0, 1, 30, 0, 0, 77, 36839),
(16271, 0, 1, 30, 0, 0, 77, 36839),
(16272, 0, 1, 30, 0, 0, 77, 36839),
(16275, 0, 1, 30, 0, 0, 77, 36839),
(16276, 0, 1, 30, 0, 0, 77, 36839),
(16277, 0, 1, 30, 0, 0, 77, 36839),
(16279, 0, 1, 30, 0, 0, 77, 36839),
(16294, 0, 1, 30, 0, 0, 77, 36839),
(16916, 0, 1, 30, 0, 0, 77, 36839),
(16923, 0, 1, 30, 0, 0, 77, 36839),
(16924, 0, 1, 30, 0, 0, 77, 36839),
(17005, 0, 1, 30, 0, 0, 77, 36839),
(17047, 0, 1, 30, 0, 0, 77, 36839),
(17213, 0, 1, 1, 0, 0, 81, 36839),
(17849, 0, 1, 30, 0, 0, 77, 36839),
(18926, 0, 1, 30, 0, 0, 77, 36839),
(18929, 0, 1, 30, 0, 0, 77, 36839),
(18954, 0, 1, 30, 0, 0, 77, 36839),
(20098, 0, 1, 20, 0, 0, 1485, 36839),
(20100, 0, 1, 20, 0, 0, 1485, 36839),
(20244, 0, 1, 20, 0, 0, 1485, 36839),
(43010, 0, 1, 20, 0, 0, 1485, 36839),
(43012, 0, 1, 30, 0, 0, 77, 36839),
(44244, 0, 60, 60, 0, 0, 881, 36839),
(44857, 0, 1, 20, 0, 0, 1485, 36839),
(44937, 0, 1, 20, 0, 0, 1485, 36839),
(47421, 0, 1, 30, 0, 0, 77, 36839),
(61071, 0, 1, 1, 0, 0, 371, 36839),
(61080, 0, 1, 1, 0, 0, 371, 36839),
(61142, 0, 1, 1, 0, 0, 371, 36839),
(61369, 0, 1, 1, 0, 0, 371, 36839),
(62019, 0, 1, 1, 0, 0, 371, 36839),
(62020, 0, 1, 1, 0, 0, 371, 36839),
(63079, 0, 1, 60, 4, 4, 373, 36839),
(63080, 0, 1, 30, 0, 0, 77, 36839),
(63332, 0, 1, 20, 0, 0, 1485, 36839);

Steps to reproduce the problem:

1. Create a Blood Elf.
2. .levelup 9

Branch(es): master

TC rev. hash/commit:
TrinityCore rev. 8742bf353df6 2020-12-15 19:38:08 +0100 (master branch) (Win64, Release, Static) (worldserver-daemon)
Using SSL version: OpenSSL 1.1.1a 20 Nov 2018 (library: OpenSSL 1.1.1a 20 Nov 2018)
Using Boost version: 1.72.0
Using World DB: TDB 837.20101
Using enUS DBC Locale

Operating system: Windows 10 Pro version 20H2, 19042.662

[illfated]

Maybe you have tested this already, I don't know. Does it make any difference if you log out and back in, or is this supposed to work instantly upon level-up?

BTW, if there is any DB change involved, the affected tables usually need to be reloaded for the change to be effective in-game.

[MaxtorCoder]

Maybe you have tested this already, I don't know. Does it make any difference if you log out and back in, or is this supposed to work instantly upon level-up?

BTW, if there is any DB change involved, the affected tables usually need to be reloaded for the change to be effective in-game.

It should reload it instantly in the world

[osleyder85]

Yes I already checked it, but in the table creature_template_scaling there is no data about these creatures. Which does not allow level scaling.

[MaxtorCoder]

Yes I already checked it, but in the table creature_template_scaling there is no data about these creatures. Which does not allow level scaling.

It should not have creature specific scaling tho. Everything has to be handled via ContentTuningID now. (Which makes it generic)

[illfated]

Good point. I forgot about that missing DB column ContentTuningID , even though I saw the information yesterday or the day before.