1 files changed, 88 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_08_05_02_world.sql b/sql/updates/world/cata_classic/2024_08_05_02_world.sql
new file mode 100644
index 00000000000..5f9a709a553
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_08_05_02_world.sql
@@ -0,0 +1,88 @@
+SET @CLASS := 4; -- CLASS_ROGUE
+DELETE FROM `player_classlevelstats` WHERE `class`= @CLASS;
+INSERT INTO `player_classlevelstats` (`class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES
+(@CLASS, 1, 21, 23, 21, 20, 20),
+(@CLASS, 2, 22, 24, 22, 20, 20),
+(@CLASS, 3, 22, 25, 22, 20, 21),
+(@CLASS, 4, 23, 27, 23, 21, 21),
+(@CLASS, 5, 24, 28, 24, 21, 21),
+(@CLASS, 6, 24, 29, 24, 21, 22),
+(@CLASS, 7, 25, 31, 25, 21, 22),
+(@CLASS, 8, 26, 32, 25, 21, 22),
+(@CLASS, 9, 27, 33, 26, 21, 23),
+(@CLASS, 10, 27, 35, 27, 22, 23),
+(@CLASS, 11, 28, 36, 28, 22, 24),
+(@CLASS, 12, 29, 37, 28, 22, 24),
+(@CLASS, 13, 30, 39, 29, 22, 24),
+(@CLASS, 14, 30, 40, 30, 22, 25),
+(@CLASS, 15, 31, 42, 30, 23, 25),
+(@CLASS, 16, 32, 43, 31, 23, 26),
+(@CLASS, 17, 33, 44, 32, 23, 26),
+(@CLASS, 18, 34, 46, 33, 23, 26),
+(@CLASS, 19, 35, 48, 33, 23, 27),
+(@CLASS, 20, 35, 49, 34, 24, 27),
+(@CLASS, 21, 36, 51, 35, 24, 28),
+(@CLASS, 22, 37, 52, 36, 24, 28),
+(@CLASS, 23, 38, 54, 37, 24, 29),
+(@CLASS, 24, 39, 55, 37, 25, 29),
+(@CLASS, 25, 40, 57, 38, 25, 30),
+(@CLASS, 26, 41, 59, 39, 25, 30),
+(@CLASS, 27, 42, 60, 40, 25, 30),
+(@CLASS, 28, 43, 62, 41, 25, 31),
+(@CLASS, 29, 43, 64, 42, 26, 31),
+(@CLASS, 30, 44, 66, 42, 26, 32),
+(@CLASS, 31, 45, 67, 43, 26, 32),
+(@CLASS, 32, 46, 69, 44, 26, 33),
+(@CLASS, 33, 47, 71, 45, 27, 33),
+(@CLASS, 34, 48, 73, 46, 27, 34),
+(@CLASS, 35, 49, 75, 47, 27, 34),
+(@CLASS, 36, 51, 77, 48, 28, 35),
+(@CLASS, 37, 52, 78, 49, 28, 36),
+(@CLASS, 38, 53, 80, 50, 28, 36),
+(@CLASS, 39, 54, 82, 51, 28, 37),
+(@CLASS, 40, 55, 84, 52, 29, 37),
+(@CLASS, 41, 56, 86, 53, 29, 38),
+(@CLASS, 42, 57, 88, 54, 29, 38),
+(@CLASS, 43, 58, 90, 55, 29, 39),
+(@CLASS, 44, 59, 93, 56, 30, 39),
+(@CLASS, 45, 61, 95, 57, 30, 40),
+(@CLASS, 46, 62, 97, 58, 30, 41),
+(@CLASS, 47, 63, 99, 59, 31, 41),
+(@CLASS, 48, 64, 101, 60, 31, 42),
+(@CLASS, 49, 65, 103, 62, 31, 43),
+(@CLASS, 50, 67, 106, 63, 32, 43),
+(@CLASS, 51, 68, 108, 64, 32, 44),
+(@CLASS, 52, 69, 110, 65, 32, 44),
+(@CLASS, 53, 70, 113, 66, 33, 45),
+(@CLASS, 54, 72, 115, 67, 33, 46),
+(@CLASS, 55, 73, 117, 69, 33, 46),
+(@CLASS, 56, 74, 120, 70, 34, 47),
+(@CLASS, 57, 76, 122, 71, 34, 48),
+(@CLASS, 58, 77, 125, 72, 34, 49),
+(@CLASS, 59, 79, 127, 74, 35, 49),
+(@CLASS, 60, 80, 130, 75, 35, 50),
+(@CLASS, 61, 81, 133, 76, 35, 51),
+(@CLASS, 62, 83, 135, 78, 36, 51),
+(@CLASS, 63, 84, 138, 79, 36, 52),
+(@CLASS, 64, 86, 141, 80, 36, 53),
+(@CLASS, 65, 87, 143, 82, 37, 54),
+(@CLASS, 66, 89, 146, 83, 37, 55),
+(@CLASS, 67, 90, 149, 85, 38, 55),
+(@CLASS, 68, 92, 152, 86, 38, 56),
+(@CLASS, 69, 94, 155, 87, 38, 57),
+(@CLASS, 70, 95, 158, 89, 39, 58),
+(@CLASS, 71, 97, 161, 90, 39, 59),
+(@CLASS, 72, 99, 164, 92, 40, 59),
+(@CLASS, 73, 100, 167, 94, 40, 60),
+(@CLASS, 74, 102, 170, 95, 41, 61),
+(@CLASS, 75, 104, 173, 97, 41, 62),
+(@CLASS, 76, 105, 176, 98, 41, 63),
+(@CLASS, 77, 107, 179, 100, 42, 64),
+(@CLASS, 78, 109, 183, 102, 42, 65),
+(@CLASS, 79, 111, 186, 103, 43, 66),
+(@CLASS, 80, 113, 189, 105, 43, 67),
+(@CLASS, 81, 114, 193, 107, 44, 68),
+(@CLASS, 82, 116, 196, 108, 44, 68),
+(@CLASS, 83, 118, 199, 110, 45, 69),
+(@CLASS, 84, 120, 203, 112, 45, 70),
+(@CLASS, 85, 122, 206, 114, 46, 71);