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