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

1 files changed, 88 insertions, 0 deletions

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