diff options
| -rw-r--r-- | sql/updates/world/master/2023_04_06_02_world.sql | 335 |
1 files changed, 335 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_04_06_02_world.sql b/sql/updates/world/master/2023_04_06_02_world.sql new file mode 100644 index 00000000000..2423102a88b --- /dev/null +++ b/sql/updates/world/master/2023_04_06_02_world.sql @@ -0,0 +1,335 @@ +-- Scaling MoP Timewalk +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=2 AND `Entry` IN (147692,56762,200388,56439,62865,62360,56511,56658,56874,56872,59149,56882,65393,56448,59546,59547,59544,59545,56732,59552,59553,56574,59873,60578,200126,59555,57080,56873,63420,56871,56586,200137,64399,59598,200131,57109,65317,56542,58815,56843,200387,59891,62231,62229,56861,62249,58319,56915,62358,59271,59262,199708,173994,58835,56928,56912,61213,60502,66905,64710,64740,56883,59836,56895,56877,59835,56636,59813,59778,59794,65555,64553,59954,59955,56822,59834,56709,56743,56825,56745,56742,56823,59750,56913,60421,56824,56932,65537,56589,59792,59793,63848,66419,59208,59206,59207,59205,56917,192337,64617,56911,56920,56918,56919,65400,65401,56879,56880,56896,59892,56876,56875,59885,59721,65111,63992,63991,64467,56906,63192,60415,58202,59800,59801,59820,59723,66904,56890,56889,58108,58109,65337,59886,59819,56799,61177,56484,56706,56501,56502,58146,58844,58824,64387,64468,59804,35387,71942,61499,136407,61398,61387,38463,63808,56884,58812,58810,58803,58807,59036,58794,61679,66652,58201,189988,61239,56767,61338,61433,61451,56640,56713,61340,58344,60006,60007,60005,58345,61337,56541,61339,63739,61216,61240,61242,67229,19668,61399,56472,56678,56473,64250,64243,135002,56646,65402,56395,61243,56766,56765,56763,56764,56870,59895,56505,61550,61392,61389,61478,61449,61247,64549,56397,98035,67231,61455,61447,61450,55659,144961,61444,61549,61551,61453,61445,61442,64548,64547,17252,61884,63093,27893,56719,65407,26125,99773,62900,196153,27989,203158,184170,195880,59738,59167,59099,59100,58722,59369,59316,59153,59242,59220,58640,58758,59711,58753,66240,59230,59227,59707,58635,185584,89,103358,59080,59467,59501,62731)) OR (`DifficultyID`=0 AND `Entry` IN (64432,61431,61945,63091,61946,61947,61415,61432,54398,62236,56754,59751,56747,64550,59811,58198,65414,56926,59741,59752,65257,60162,63717,59808,197969,27914,64563,59613,58664,58757,58633,59359,59184,58875,58823,59980,59929,59982,58662,59213,59304,59200,59360,54020,58822,59480,59193,59368,58917,50485,59614,59503,59375,193318,27882,127948,179166,201398,203895,203894,203885,202656)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(147692, 2, 0, 0, 371, 48892), +(56762, 2, 2, 2, 2565, 48892), +(200388, 2, 0, 0, 2565, 48892), +(56439, 2, 2, 2, 2565, 48892), +(62865, 2, 0, 0, 482, 48892), +(62360, 2, 0, 0, 2565, 48892), +(56511, 2, 0, 0, 2565, 48892), +(56658, 2, 0, 0, 2565, 48892), +(56874, 2, 0, 0, 2565, 48892), +(56872, 2, 0, 0, 2565, 48892), +(59149, 2, 0, 0, 2565, 48892), +(56882, 2, 0, 0, 2565, 48892), +(65393, 2, 0, 0, 2565, 48892), +(56448, 2, 2, 2, 2565, 48892), +(59546, 2, 1, 1, 2565, 48892), +(59547, 2, 1, 1, 2565, 48892), +(59544, 2, 0, 0, 2565, 48892), +(59545, 2, 0, 0, 2565, 48892), +(56732, 2, 2, 2, 2565, 48892), +(59552, 2, 0, 0, 2565, 48892), +(59553, 2, 0, 0, 2565, 48892), +(56574, 2, 0, 0, 2565, 48892), +(59873, 2, 0, 0, 2565, 48892), +(60578, 2, 3, 3, 2565, 48892), +(200126, 2, 0, 0, 2565, 48892), +(59555, 2, 0, 0, 2565, 48892), +(57080, 2, 0, 0, 2565, 48892), +(56873, 2, 0, 0, 2565, 48892), +(63420, 2, 0, 0, 657, 48892), +(56871, 2, 0, 0, 2565, 48892), +(56586, 2, 0, 0, 2565, 48892), +(200137, 2, 0, 0, 2565, 48892), +(64399, 2, 0, 0, 2565, 48892), +(59598, 2, 0, 0, 2565, 48892), +(200131, 2, 0, 0, 2565, 48892), +(57109, 2, 0, 0, 2565, 48892), +(65317, 2, 0, 0, 2565, 48892), +(56542, 2, 0, 0, 2565, 48892), +(58815, 2, 0, 0, 2565, 48892), +(56843, 2, 0, 0, 2565, 48892), +(200387, 2, 1, 1, 2565, 48892), +(59891, 2, 0, 0, 2565, 48892), +(62231, 2, 1, 1, 2565, 48892), +(62229, 2, 0, 0, 2565, 48892), +(56861, 2, 0, 0, 2565, 48892), +(62249, 2, 0, 0, 2565, 48892), +(58319, 2, 0, 0, 2565, 48892), +(56915, 2, 2, 2, 2565, 48892), +(62358, 2, 0, 0, 2565, 48892), +(59271, 2, 0, 0, 482, 48892), +(59262, 2, 0, 0, 482, 48892), +(199708, 2, 0, 0, 2285, 48892), +(173994, 2, 0, 0, 371, 48892), +(58835, 2, 0, 0, 2565, 48892), +(56928, 2, 0, 0, 2565, 48892), +(56912, 2, 0, 0, 2565, 48892), +(61213, 2, 2, 2, 2565, 48892), +(60502, 2, 0, 0, 2565, 48892), +(66905, 2, 0, 0, 2565, 48892), +(64710, 2, 0, 0, 2565, 48892), +(64740, 2, 0, 0, 2565, 48892), +(56883, 2, -2, -2, 2565, 48892), +(59836, 2, -1, -1, 2565, 48892), +(56895, 2, 2, 2, 2565, 48892), +(56877, 2, 2, 2, 2565, 48892), +(59835, 2, 0, 0, 2565, 48892), +(56636, 2, 2, 2, 2565, 48892), +(59813, 2, -2, -2, 2565, 48892), +(59778, 2, -1, -1, 2565, 48892), +(59794, 2, -1, -1, 2565, 48892), +(65555, 2, -2, -2, 2565, 48892), +(64553, 2, 0, 0, 2565, 48892), +(59954, 2, 0, 0, 2565, 48892), +(59955, 2, 0, 0, 2565, 48892), +(56822, 2, -2, -2, 2565, 48892), +(59834, 2, -2, -2, 2565, 48892), +(56709, 2, -2, -2, 2565, 48892), +(56743, 2, 0, 0, 2565, 48892), +(56825, 2, -2, -2, 2565, 48892), +(56745, 2, 0, 0, 2565, 48892), +(56742, 2, 0, 0, 2565, 48892), +(56823, 2, -2, -2, 2565, 48892), +(59750, 2, 0, 0, 2565, 48892), +(56913, 2, -2, -2, 2565, 48892), +(60421, 2, -2, -2, 2565, 48892), +(56824, 2, -2, -2, 2565, 48892), +(56932, 2, -2, -2, 2565, 48892), +(65537, 2, 0, 0, 2565, 48892), +(56589, 2, 2, 2, 2565, 48892), +(59792, 2, -2, -2, 2565, 48892), +(59793, 2, -2, -2, 2565, 48892), +(63848, 2, -2, -2, 2565, 48892), +(66419, 2, 0, 0, 2565, 48892), +(59208, 2, 2, 2, 2565, 48892), +(59206, 2, 2, 2, 2565, 48892), +(59207, 2, 2, 2, 2565, 48892), +(59205, 2, 2, 2, 2565, 48892), +(56917, 2, 2, 2, 2565, 48892), +(192337, 2, 0, 0, 482, 48892), +(64617, 2, 0, 0, 482, 48892), +(56911, 2, 0, 0, 2565, 48892), +(56920, 2, 0, 0, 2565, 48892), +(56918, 2, 0, 0, 2565, 48892), +(56919, 2, 0, 0, 2565, 48892), +(65400, 2, 0, 0, 2565, 48892), +(65401, 2, 0, 0, 2565, 48892), +(56879, 2, 0, 0, 2565, 48892), +(56880, 2, 0, 0, 2565, 48892), +(56896, 2, 0, 0, 2565, 48892), +(59892, 2, 0, 0, 2565, 48892), +(56876, 2, 0, 0, 2565, 48892), +(56875, 2, 0, 0, 2565, 48892), +(59885, 2, 0, 0, 2565, 48892), +(59721, 2, -2, -2, 2565, 48892), +(65111, 2, 0, 0, 2565, 48892), +(63992, 2, -2, -2, 2565, 48892), +(63991, 2, -2, -2, 2565, 48892), +(64467, 2, 0, 0, 2565, 48892), +(56906, 2, 2, 2, 2565, 48892), +(63192, 2, 0, 0, 2565, 48892), +(60415, 2, -4, -4, 2565, 48892), +(58202, 2, 0, 0, 2565, 48892), +(59800, 2, 0, 0, 2565, 48892), +(59801, 2, 0, 0, 2565, 48892), +(59820, 2, 0, 0, 2565, 48892), +(59723, 2, -2, -2, 2565, 48892), +(66904, 2, 0, 0, 2565, 48892), +(56890, 2, 0, 0, 2565, 48892), +(56889, 2, 0, 0, 2565, 48892), +(58108, 2, 1, 1, 2565, 48892), +(58109, 2, -2, -2, 2565, 48892), +(65337, 2, 0, 0, 2565, 48892), +(59886, 2, -2, -2, 2565, 48892), +(59819, 2, 0, 0, 2565, 48892), +(56799, 2, 0, 0, 2565, 48892), +(61177, 2, 1, 1, 2565, 48892), +(56484, 2, 0, 0, 2565, 48892), +(56706, 2, 0, 0, 2565, 48892), +(56501, 2, -2, -2, 2565, 48892), +(56502, 2, 0, 0, 2565, 48892), +(58146, 2, 0, 0, 2565, 48892), +(58844, 2, 0, 0, 2565, 48892), +(58824, 2, 0, 0, 2565, 48892), +(64387, 2, 2, 2, 2565, 48892), +(64468, 2, 2, 2, 2565, 48892), +(59804, 2, 0, 0, 2565, 48892), +(35387, 2, 0, 0, 371, 48892), +(71942, 2, 0, 0, 371, 48892), +(61499, 2, 3, 3, 2565, 48892), +(136407, 2, 0, 0, 482, 48892), +(61398, 2, 2, 2, 2565, 48892), +(61387, 2, 0, 0, 2565, 48892), +(38463, 2, 0, 0, 1023, 48892), +(63808, 2, -2, -2, 2565, 48892), +(56884, 2, 2, 2, 2565, 48892), +(58812, 2, 1, 1, 2565, 48892), +(58810, 2, 1, 1, 2565, 48892), +(58803, 2, 1, 1, 2565, 48892), +(58807, 2, 1, 1, 2565, 48892), +(59036, 2, 1, 1, 2565, 48892), +(58794, 2, 1, 1, 2565, 48892), +(61679, 2, 0, 0, 2565, 48892), +(66652, 2, 0, 0, 2565, 48892), +(58201, 2, 1, 1, 2565, 48892), +(189988, 2, 0, 0, 482, 48892), +(61239, 2, 1, 1, 2565, 48892), +(56767, 2, 1, 1, 2565, 48892), +(61338, 2, 1, 1, 2565, 48892), +(61433, 2, 3, 3, 2565, 48892), +(61451, 2, 3, 3, 2565, 48892), +(56640, 2, 2, 2, 2565, 48892), +(56713, 2, 2, 2, 2565, 48892), +(61340, 2, 1, 1, 2565, 48892), +(58344, 2, 0, 0, 2565, 48892), +(60006, 2, 2, 2, 2565, 48892), +(60007, 2, 2, 2, 2565, 48892), +(60005, 2, 2, 2, 2565, 48892), +(58345, 2, 0, 0, 2565, 48892), +(61337, 2, 1, 1, 2565, 48892), +(56541, 2, 2, 2, 2565, 48892), +(61339, 2, 1, 1, 2565, 48892), +(63739, 2, 0, 0, 2565, 48892), +(61216, 2, 1, 1, 2565, 48892), +(61240, 2, 1, 1, 2565, 48892), +(61242, 2, 1, 1, 2565, 48892), +(67229, 2, 2, 2, 2565, 48892), +(19668, 2, 0, 0, 482, 48892), +(61399, 2, 0, 0, 2565, 48892), +(56472, 2, 1, 1, 2565, 48892), +(56678, 2, -1, -1, 2565, 48892), +(56473, 2, 1, 1, 2565, 48892), +(64250, 2, 3, 3, 2565, 48892), +(64243, 2, 0, 0, 2565, 48892), +(135002, 2, 0, 0, 482, 48892), +(56646, 2, 0, 0, 2565, 48892), +(65402, 2, 0, 0, 2565, 48892), +(56395, 2, 0, 0, 2565, 48892), +(61243, 2, 2, 2, 2565, 48892), +(56766, 2, 0, 0, 2565, 48892), +(56765, 2, 1, 1, 2565, 48892), +(56763, 2, 1, 1, 2565, 48892), +(56764, 2, 1, 1, 2565, 48892), +(56870, 2, 2, 2, 2565, 48892), +(59895, 2, 2, 2, 2565, 48892), +(56505, 2, 3, 3, 2565, 48892), +(61550, 2, 0, 0, 2565, 48892), +(61392, 2, 0, 0, 2565, 48892), +(61389, 2, 0, 0, 2565, 48892), +(61478, 2, 3, 3, 2565, 48892), +(61449, 2, 0, 0, 2565, 48892), +(61247, 2, 0, 0, 2565, 48892), +(64549, 2, 1, 1, 2565, 48892), +(56397, 2, 3, 3, 2565, 48892), +(98035, 2, 0, 0, 482, 48892), +(67231, 2, 2, 2, 2565, 48892), +(61455, 2, 0, 0, 2565, 48892), +(61447, 2, 0, 0, 2565, 48892), +(61450, 2, 0, 0, 2565, 48892), +(55659, 2, 0, 0, 482, 48892), +(144961, 2, 0, 0, 482, 48892), +(61444, 2, 2, 2, 2565, 48892), +(61549, 2, 0, 0, 2565, 48892), +(61551, 2, 0, 0, 2565, 48892), +(61453, 2, 1, 1, 2565, 48892), +(61445, 2, 2, 2, 2565, 48892), +(61442, 2, 2, 2, 2565, 48892), +(64548, 2, 0, 0, 2565, 48892), +(64547, 2, 0, 0, 2565, 48892), +(17252, 2, 0, 0, 482, 48892), +(61884, 2, 2, 2, 2565, 48892), +(63093, 2, 3, 3, 2565, 48892), +(27893, 2, 0, 0, 482, 48892), +(56719, 2, 2, 2, 2565, 48892), +(64432, 0, 3, 3, 2565, 48892), +(61431, 0, 0, 0, 2565, 48892), +(61945, 0, 0, 0, 2565, 48892), +(63091, 0, 0, 0, 2565, 48892), +(61946, 0, 0, 0, 2565, 48892), +(61947, 0, 0, 0, 2565, 48892), +(61415, 0, 0, 0, 2565, 48892), +(61432, 0, 0, 0, 2565, 48892), +(65407, 2, 0, 0, 2565, 48892), +(54398, 0, 0, 0, 391, 48892), +(26125, 2, 0, 0, 482, 48892), +(99773, 2, 0, 0, 633, 48892), +(62236, 0, 2, 2, 2565, 48892), +(56754, 0, 2, 2, 2565, 48892), +(59751, 0, 0, 0, 2565, 48892), +(56747, 0, 2, 2, 2565, 48892), +(64550, 0, 3, 3, 2565, 48892), +(59811, 0, 0, 0, 2565, 48892), +(58198, 0, 0, 0, 2565, 48892), +(65414, 0, 0, 0, 2565, 48892), +(56926, 0, 0, 0, 2565, 48892), +(59741, 0, 0, 0, 2565, 48892), +(59752, 0, 0, 0, 2565, 48892), +(65257, 0, 0, 0, 2565, 48892), +(60162, 0, 3, 3, 2565, 48892), +(63717, 0, 0, 0, 2565, 48892), +(59808, 0, 0, 0, 2565, 48892), +(197969, 0, 0, 0, 371, 48892), +(27914, 0, 0, 0, 371, 48892), +(62900, 2, 0, 0, 371, 48892), +(196153, 2, 1, 1, 2078, 48892), +(27989, 2, 0, 0, 886, 48892), +(203158, 2, 0, 0, 2150, 48892), +(184170, 2, 0, 0, 2078, 48892), +(195880, 2, 0, 0, 840, 48892), +(59738, 2, 0, 0, 482, 48892), +(59167, 2, 0, 0, 1187, 48892), +(59099, 2, 0, 0, 1187, 48892), +(59100, 2, 0, 0, 1187, 48892), +(58722, 2, 2, 2, 1187, 48892), +(59369, 2, 1, 1, 1187, 48892), +(59316, 2, 2, 2, 1187, 48892), +(59153, 2, 2, 2, 1187, 48892), +(59242, 2, 0, 0, 1187, 48892), +(59220, 2, 2, 2, 1187, 48892), +(58640, 2, 0, 0, 1187, 48892), +(58758, 2, 0, 0, 1187, 48892), +(59711, 2, 0, 0, 1187, 48892), +(58753, 2, 0, 0, 1187, 48892), +(66240, 2, 0, 0, 1187, 48892), +(59230, 2, 0, 0, 1187, 48892), +(59227, 2, 0, 0, 1187, 48892), +(59707, 2, 0, 0, 1187, 48892), +(58635, 2, 0, 0, 1187, 48892), +(185584, 2, 0, 0, 482, 48892), +(89, 2, 0, 0, 482, 48892), +(103358, 2, 0, 0, 482, 48892), +(59080, 2, 2, 2, 1187, 48892), +(59467, 2, 0, 0, 1187, 48892), +(59501, 2, 0, 0, 1187, 48892), +(62731, 2, 0, 0, 1187, 48892), +(64563, 0, 0, 0, 1187, 48892), +(59613, 0, 1, 1, 1187, 48892), +(58664, 0, 2, 2, 1187, 48892), +(58757, 0, 0, 0, 1187, 48892), +(58633, 0, 2, 2, 1187, 48892), +(59359, 0, 1, 1, 1187, 48892), +(59184, 0, 2, 2, 1187, 48892), +(58875, 0, 2, 2, 1187, 48892), +(58823, 0, 0, 0, 1187, 48892), +(59980, 0, 0, 0, 1187, 48892), +(59929, 0, 0, 0, 1187, 48892), +(59982, 0, 0, 0, 1187, 48892), +(58662, 0, 0, 0, 1187, 48892), +(59213, 0, 0, 0, 1187, 48892), +(59304, 0, 0, 0, 1187, 48892), +(59200, 0, 2, 2, 1187, 48892), +(59360, 0, 0, 0, 1187, 48892), +(54020, 0, 0, 0, 328, 48892), +(58822, 0, 1, 1, 1187, 48892), +(59480, 0, 0, 0, 1187, 48892), +(59193, 0, 1, 1, 1187, 48892), +(59368, 0, 0, 0, 1187, 48892), +(58917, 0, 0, 0, 1187, 48892), +(50485, 0, 0, 0, 81, 48892), +(59614, 0, 0, 0, 1187, 48892), +(59503, 0, 0, 0, 1187, 48892), +(59375, 0, 0, 0, 651, 48892), +(193318, 0, 0, 0, 2401, 48892), +(27882, 0, 0, 0, 298, 48892), +(127948, 0, 0, 0, 371, 48892), +(179166, 0, 0, 0, 371, 48892), +(201398, 0, 0, 0, 2589, 48892), +(203895, 0, 0, 0, 2078, 48892), +(203894, 0, 0, 0, 2078, 48892), +(203885, 0, 0, 0, 2078, 48892), +(202656, 0, 0, 0, 2590, 48892); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=48892 WHERE (`DifficultyID`=0 AND `Entry` IN (77221,196156,27829,60199,62005,190176,189539,185714,197710,188661,197912,174170,30298,59394,59481,45979,193321,189500,188054,199393,197834,197833,99582,196448,188056,188006,194645,199720,194643,194644,194646,198594,197553,199599,193114,185553,199601,194649,194648,197244,114665,185548,199603,193468,189591,189617,43499,193284,121541,193283,189168,193004,143622,187788,188219,197533,189632,188223,189827,196499,197781,193495,199395,187676,187669,188747,196191,188706,195106,198742,188694,187678,188227,188293,197711,199605,189285,198580,199220,189489,185562,199261,197182,185556,188825,188869,188670,189543,197986,32639,32638,199530,188004,199528,32642,62822,32641,189895,62821,199527,199526,188210,188824,188823,142666,186794,201492,184168,142668,189869,192814)); |