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