DB/Player: update class level stats for Warriors

1 files changed, 88 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_08_03_00_world.sql b/sql/updates/world/cata_classic/2024_08_03_00_world.sql
new file mode 100644
index 00000000000..5d258ba61e3
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_08_03_00_world.sql
@@ -0,0 +1,88 @@
+SET @CLASS := 1;
+DELETE FROM `player_classlevelstats` WHERE `class`= @CLASS;
+INSERT INTO `player_classlevelstats` (`class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES
+(@CLASS, 1, 23, 20, 22, 20, 20),
+(@CLASS, 2, 24, 21, 23, 20, 20),
+(@CLASS, 3, 25, 21, 24, 20, 21),
+(@CLASS, 4, 26, 22, 25, 20, 21),
+(@CLASS, 5, 28, 23, 26, 20, 21),
+(@CLASS, 6, 29, 24, 27, 21, 21),
+(@CLASS, 7, 30, 24, 28, 21, 22),
+(@CLASS, 8, 31, 25, 29, 21, 22),
+(@CLASS, 9, 32, 26, 30, 21, 22),
+(@CLASS, 10, 33, 26, 31, 21, 23),
+(@CLASS, 11, 35, 27, 33, 21, 23),
+(@CLASS, 12, 36, 28, 34, 21, 23),
+(@CLASS, 13, 37, 29, 35, 21, 24),
+(@CLASS, 14, 39, 30, 36, 22, 24),
+(@CLASS, 15, 40, 30, 37, 22, 24),
+(@CLASS, 16, 41, 31, 38, 22, 25),
+(@CLASS, 17, 42, 32, 40, 22, 25),
+(@CLASS, 18, 44, 33, 41, 22, 25),
+(@CLASS, 19, 45, 34, 42, 22, 26),
+(@CLASS, 20, 47, 35, 43, 22, 26),
+(@CLASS, 21, 48, 35, 45, 23, 26),
+(@CLASS, 22, 49, 36, 46, 23, 27),
+(@CLASS, 23, 51, 37, 47, 23, 27),
+(@CLASS, 24, 52, 38, 49, 23, 28),
+(@CLASS, 25, 54, 39, 50, 23, 28),
+(@CLASS, 26, 55, 40, 51, 23, 28),
+(@CLASS, 27, 57, 41, 53, 23, 29),
+(@CLASS, 28, 58, 42, 54, 24, 29),
+(@CLASS, 29, 60, 43, 56, 24, 30),
+(@CLASS, 30, 62, 44, 57, 24, 30),
+(@CLASS, 31, 63, 45, 58, 24, 30),
+(@CLASS, 32, 65, 46, 60, 24, 31),
+(@CLASS, 33, 66, 47, 61, 24, 31),
+(@CLASS, 34, 68, 48, 63, 25, 32),
+(@CLASS, 35, 70, 49, 64, 25, 32),
+(@CLASS, 36, 72, 50, 66, 25, 33),
+(@CLASS, 37, 73, 51, 68, 25, 33),
+(@CLASS, 38, 75, 52, 69, 25, 33),
+(@CLASS, 39, 77, 53, 71, 26, 35),
+(@CLASS, 40, 79, 54, 72, 26, 35),
+(@CLASS, 41, 80, 56, 74, 26, 36),
+(@CLASS, 42, 82, 57, 76, 26, 36),
+(@CLASS, 43, 84, 58, 77, 26, 37),
+(@CLASS, 44, 86, 59, 79, 26, 37),
+(@CLASS, 45, 88, 60, 81, 27, 38),
+(@CLASS, 46, 90, 61, 83, 27, 38),
+(@CLASS, 47, 92, 63, 84, 27, 39),
+(@CLASS, 48, 94, 64, 86, 27, 39),
+(@CLASS, 49, 96, 65, 88, 28, 40),
+(@CLASS, 50, 98, 66, 90, 28, 40),
+(@CLASS, 51, 100, 68, 92, 28, 41),
+(@CLASS, 52, 102, 69, 94, 28, 41),
+(@CLASS, 53, 104, 70, 96, 28, 42),
+(@CLASS, 54, 106, 72, 98, 29, 43),
+(@CLASS, 55, 109, 73, 100, 29, 43),
+(@CLASS, 56, 111, 74, 102, 29, 44),
+(@CLASS, 57, 113, 76, 104, 29, 44),
+(@CLASS, 58, 115, 77, 106, 30, 45),
+(@CLASS, 59, 118, 79, 108, 30, 45),
+(@CLASS, 60, 120, 80, 110, 30, 46),
+(@CLASS, 61, 122, 81, 112, 30, 47),
+(@CLASS, 62, 125, 83, 114, 30, 47),
+(@CLASS, 63, 127, 84, 117, 31, 48),
+(@CLASS, 64, 130, 86, 119, 31, 48),
+(@CLASS, 65, 132, 88, 121, 31, 49),
+(@CLASS, 66, 135, 89, 123, 32, 50),
+(@CLASS, 67, 137, 91, 126, 32, 50),
+(@CLASS, 68, 140, 92, 128, 32, 51),
+(@CLASS, 69, 142, 94, 130, 32, 52),
+(@CLASS, 70, 145, 96, 133, 33, 52),
+(@CLASS, 71, 148, 97, 135, 33, 53),
+(@CLASS, 72, 150, 99, 138, 33, 54),
+(@CLASS, 73, 153, 101, 140, 33, 55),
+(@CLASS, 74, 156, 102, 143, 34, 55),
+(@CLASS, 75, 159, 104, 145, 34, 56),
+(@CLASS, 76, 162, 106, 148, 34, 57),
+(@CLASS, 77, 165, 108, 151, 35, 58),
+(@CLASS, 78, 168, 109, 153, 35, 58),
+(@CLASS, 79, 171, 111, 156, 35, 59),
+(@CLASS, 80, 174, 113, 159, 36, 60),
+(@CLASS, 81, 177, 115, 161, 36, 61),
+(@CLASS, 82, 180, 117, 164, 36, 61),
+(@CLASS, 83, 183, 119, 167, 36, 62),
+(@CLASS, 84, 186, 121, 170, 37, 63),
+(@CLASS, 85, 189, 123, 173, 37, 64);