DB/Player: updated class level stats for Paladin for Cataclysm

1 files changed, 88 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_08_05_00_world.sql b/sql/updates/world/cata_classic/2024_08_05_00_world.sql
new file mode 100644
index 00000000000..9a97b6ee1a7
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_08_05_00_world.sql
@@ -0,0 +1,88 @@
+SET @CLASS := 2; -- CLASS_PALADIN
+DELETE FROM `player_classlevelstats` WHERE `class`= @CLASS;
+INSERT INTO `player_classlevelstats` (`class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES
+(@CLASS, 1, 22, 20, 22, 20, 21),
+(@CLASS, 2, 23, 21, 23, 21, 22),
+(@CLASS, 3, 24, 21, 24, 21, 22),
+(@CLASS, 4, 25, 22, 25, 22, 23),
+(@CLASS, 5, 26, 22, 26, 22, 24),
+(@CLASS, 6, 27, 23, 27, 23, 24),
+(@CLASS, 7, 28, 23, 28, 24, 25),
+(@CLASS, 8, 29, 24, 28, 24, 25),
+(@CLASS, 9, 30, 24, 29, 25, 26),
+(@CLASS, 10, 31, 25, 30, 25, 27),
+(@CLASS, 11, 32, 25, 31, 26, 28),
+(@CLASS, 12, 33, 26, 32, 27, 28),
+(@CLASS, 13, 34, 27, 33, 27, 29),
+(@CLASS, 14, 35, 27, 34, 28, 30),
+(@CLASS, 15, 36, 28, 36, 29, 30),
+(@CLASS, 16, 38, 28, 37, 29, 31),
+(@CLASS, 17, 39, 29, 38, 30, 32),
+(@CLASS, 18, 40, 30, 39, 31, 33),
+(@CLASS, 19, 41, 30, 40, 31, 33),
+(@CLASS, 20, 42, 31, 41, 32, 34),
+(@CLASS, 21, 43, 32, 42, 33, 35),
+(@CLASS, 22, 45, 32, 43, 34, 36),
+(@CLASS, 23, 46, 33, 44, 34, 37),
+(@CLASS, 24, 47, 34, 46, 35, 37),
+(@CLASS, 25, 48, 34, 47, 36, 38),
+(@CLASS, 26, 50, 35, 48, 37, 39),
+(@CLASS, 27, 51, 36, 49, 37, 40),
+(@CLASS, 28, 52, 36, 50, 38, 41),
+(@CLASS, 29, 54, 37, 52, 39, 42),
+(@CLASS, 30, 55, 38, 53, 40, 42),
+(@CLASS, 31, 56, 39, 54, 41, 43),
+(@CLASS, 32, 58, 39, 56, 42, 44),
+(@CLASS, 33, 59, 40, 57, 42, 45),
+(@CLASS, 34, 61, 41, 58, 43, 46),
+(@CLASS, 35, 62, 42, 60, 44, 47),
+(@CLASS, 36, 64, 43, 61, 45, 48),
+(@CLASS, 37, 65, 43, 62, 46, 49),
+(@CLASS, 38, 67, 44, 64, 47, 50),
+(@CLASS, 39, 68, 45, 65, 48, 51),
+(@CLASS, 40, 70, 46, 67, 49, 52),
+(@CLASS, 41, 71, 47, 68, 50, 53),
+(@CLASS, 42, 73, 47, 70, 51, 54),
+(@CLASS, 43, 74, 48, 71, 52, 55),
+(@CLASS, 44, 76, 49, 73, 52, 56),
+(@CLASS, 45, 78, 50, 74, 53, 57),
+(@CLASS, 46, 79, 51, 76, 54, 58),
+(@CLASS, 47, 81, 52, 77, 56, 59),
+(@CLASS, 48, 83, 53, 79, 57, 60),
+(@CLASS, 49, 84, 54, 81, 58, 62),
+(@CLASS, 50, 86, 55, 82, 59, 63),
+(@CLASS, 51, 88, 56, 84, 60, 64),
+(@CLASS, 52, 90, 57, 86, 61, 65),
+(@CLASS, 53, 92, 58, 87, 62, 66),
+(@CLASS, 54, 93, 59, 89, 63, 67),
+(@CLASS, 55, 95, 60, 91, 64, 69),
+(@CLASS, 56, 97, 61, 93, 65, 70),
+(@CLASS, 57, 99, 62, 94, 66, 71),
+(@CLASS, 58, 101, 63, 96, 68, 72),
+(@CLASS, 59, 103, 64, 98, 69, 74),
+(@CLASS, 60, 105, 65, 100, 70, 75),
+(@CLASS, 61, 107, 66, 102, 71, 76),
+(@CLASS, 62, 109, 67, 104, 72, 78),
+(@CLASS, 63, 111, 68, 106, 74, 79),
+(@CLASS, 64, 113, 69, 108, 75, 80),
+(@CLASS, 65, 115, 71, 110, 76, 82),
+(@CLASS, 66, 118, 72, 112, 78, 83),
+(@CLASS, 67, 120, 73, 114, 79, 85),
+(@CLASS, 68, 122, 74, 116, 80, 86),
+(@CLASS, 69, 124, 75, 118, 82, 87),
+(@CLASS, 70, 126, 77, 120, 83, 89),
+(@CLASS, 71, 129, 78, 122, 84, 90),
+(@CLASS, 72, 131, 79, 125, 86, 92),
+(@CLASS, 73, 133, 80, 127, 87, 94),
+(@CLASS, 74, 136, 82, 129, 89, 95),
+(@CLASS, 75, 138, 83, 131, 90, 97),
+(@CLASS, 76, 141, 84, 134, 92, 98),
+(@CLASS, 77, 143, 86, 136, 93, 100),
+(@CLASS, 78, 146, 87, 138, 95, 102),
+(@CLASS, 79, 148, 88, 141, 96, 103),
+(@CLASS, 80, 151, 90, 143, 98, 105),
+(@CLASS, 81, 153, 91, 146, 99, 107),
+(@CLASS, 82, 156, 93, 148, 101, 108),
+(@CLASS, 83, 159, 94, 151, 102, 110),
+(@CLASS, 84, 162, 96, 153, 104, 112),
+(@CLASS, 85, 164, 97, 156, 106, 114);