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

1 files changed, 88 insertions, 0 deletions

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