DB/Player: updated class level stats for Priests to Cataclysm

1 files changed, 88 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_08_05_03_world.sql b/sql/updates/world/cata_classic/2024_08_05_03_world.sql
new file mode 100644
index 00000000000..96d55ff7174
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_08_05_03_world.sql
@@ -0,0 +1,88 @@
+SET @CLASS := 5; -- CLASS_PRIEST
+DELETE FROM `player_classlevelstats` WHERE `class`= @CLASS;
+INSERT INTO `player_classlevelstats` (`class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES
+(@CLASS, 1, 20, 20, 20, 22, 23),
+(@CLASS, 2, 20, 20, 20, 23, 24),
+(@CLASS, 3, 20, 20, 21, 24, 25),
+(@CLASS, 4, 21, 21, 21, 25, 27),
+(@CLASS, 5, 21, 21, 21, 27, 28),
+(@CLASS, 6, 21, 21, 22, 28, 29),
+(@CLASS, 7, 21, 21, 22, 29, 30),
+(@CLASS, 8, 21, 22, 22, 30, 31),
+(@CLASS, 9, 21, 22, 23, 31, 33),
+(@CLASS, 10, 22, 22, 23, 33, 34),
+(@CLASS, 11, 22, 22, 24, 34, 35),
+(@CLASS, 12, 22, 23, 24, 35, 37),
+(@CLASS, 13, 22, 23, 24, 36, 38),
+(@CLASS, 14, 22, 23, 25, 38, 39),
+(@CLASS, 15, 23, 23, 25, 39, 41),
+(@CLASS, 16, 23, 24, 26, 40, 42),
+(@CLASS, 17, 23, 24, 26, 42, 43),
+(@CLASS, 18, 23, 24, 26, 43, 45),
+(@CLASS, 19, 23, 25, 27, 44, 46),
+(@CLASS, 20, 24, 25, 27, 46, 48),
+(@CLASS, 21, 24, 25, 28, 47, 49),
+(@CLASS, 22, 24, 25, 28, 49, 51),
+(@CLASS, 23, 24, 26, 29, 50, 52),
+(@CLASS, 24, 25, 26, 29, 52, 54),
+(@CLASS, 25, 25, 26, 30, 53, 55),
+(@CLASS, 26, 25, 27, 30, 55, 57),
+(@CLASS, 27, 25, 27, 30, 56, 59),
+(@CLASS, 28, 25, 27, 31, 58, 60),
+(@CLASS, 29, 26, 28, 31, 59, 62),
+(@CLASS, 30, 26, 28, 32, 61, 64),
+(@CLASS, 31, 26, 28, 32, 63, 65),
+(@CLASS, 32, 26, 29, 33, 64, 67),
+(@CLASS, 33, 27, 29, 33, 66, 69),
+(@CLASS, 34, 27, 29, 34, 68, 70),
+(@CLASS, 35, 27, 30, 34, 69, 72),
+(@CLASS, 36, 28, 30, 35, 71, 74),
+(@CLASS, 37, 28, 30, 36, 73, 76),
+(@CLASS, 38, 28, 31, 36, 75, 78),
+(@CLASS, 39, 28, 31, 37, 76, 80),
+(@CLASS, 40, 29, 31, 37, 78, 81),
+(@CLASS, 41, 29, 32, 38, 80, 83),
+(@CLASS, 42, 29, 32, 38, 82, 85),
+(@CLASS, 43, 29, 33, 39, 84, 87),
+(@CLASS, 44, 30, 33, 39, 86, 89),
+(@CLASS, 45, 30, 33, 40, 88, 91),
+(@CLASS, 46, 30, 34, 41, 90, 93),
+(@CLASS, 47, 31, 34, 41, 92, 95),
+(@CLASS, 48, 31, 35, 42, 94, 98),
+(@CLASS, 49, 31, 35, 43, 96, 100),
+(@CLASS, 50, 32, 35, 43, 98, 102),
+(@CLASS, 51, 32, 36, 44, 100, 104),
+(@CLASS, 52, 32, 36, 44, 102, 106),
+(@CLASS, 53, 33, 37, 45, 104, 108),
+(@CLASS, 54, 33, 37, 46, 106, 111),
+(@CLASS, 55, 33, 38, 46, 109, 113),
+(@CLASS, 56, 34, 38, 47, 111, 115),
+(@CLASS, 57, 34, 39, 48, 113, 118),
+(@CLASS, 58, 34, 39, 49, 115, 120),
+(@CLASS, 59, 35, 40, 49, 118, 123),
+(@CLASS, 60, 35, 40, 50, 120, 125),
+(@CLASS, 61, 35, 40, 51, 122, 127),
+(@CLASS, 62, 36, 41, 51, 125, 130),
+(@CLASS, 63, 36, 41, 52, 127, 133),
+(@CLASS, 64, 36, 42, 53, 130, 135),
+(@CLASS, 65, 37, 43, 54, 132, 138),
+(@CLASS, 66, 37, 43, 55, 135, 140),
+(@CLASS, 67, 38, 44, 55, 137, 143),
+(@CLASS, 68, 38, 44, 56, 140, 146),
+(@CLASS, 69, 38, 45, 57, 143, 149),
+(@CLASS, 70, 39, 45, 58, 145, 151),
+(@CLASS, 71, 39, 46, 59, 148, 154),
+(@CLASS, 72, 40, 46, 59, 151, 157),
+(@CLASS, 73, 40, 47, 60, 154, 160),
+(@CLASS, 74, 41, 47, 61, 156, 163),
+(@CLASS, 75, 41, 48, 62, 159, 166),
+(@CLASS, 76, 41, 49, 63, 162, 169),
+(@CLASS, 77, 42, 49, 64, 165, 172),
+(@CLASS, 78, 42, 50, 65, 168, 175),
+(@CLASS, 79, 43, 50, 66, 171, 178),
+(@CLASS, 80, 43, 51, 67, 174, 181),
+(@CLASS, 81, 44, 52, 68, 177, 185),
+(@CLASS, 82, 44, 52, 68, 180, 188),
+(@CLASS, 83, 45, 53, 69, 184, 191),
+(@CLASS, 84, 45, 54, 70, 187, 195),
+(@CLASS, 85, 46, 54, 71, 190, 198);