aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/cata_classic/2024_08_05_05_world.sql88
1 files changed, 88 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_08_05_05_world.sql b/sql/updates/world/cata_classic/2024_08_05_05_world.sql
new file mode 100644
index 00000000000..ad2adffa797
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_08_05_05_world.sql
@@ -0,0 +1,88 @@
+SET @CLASS := 9; -- CLASS_WARLOCK
+DELETE FROM `player_classlevelstats` WHERE `class`= @CLASS;
+INSERT INTO `player_classlevelstats` (`class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES
+(@CLASS, 1, 20, 20, 21, 22, 22),
+(@CLASS, 2, 20, 20, 22, 23, 23),
+(@CLASS, 3, 21, 21, 22, 24, 24),
+(@CLASS, 4, 21, 21, 23, 25, 25),
+(@CLASS, 5, 21, 21, 23, 26, 26),
+(@CLASS, 6, 21, 22, 24, 27, 27),
+(@CLASS, 7, 22, 22, 24, 28, 29),
+(@CLASS, 8, 22, 22, 25, 29, 30),
+(@CLASS, 9, 22, 23, 25, 30, 31),
+(@CLASS, 10, 23, 23, 26, 31, 32),
+(@CLASS, 11, 23, 24, 26, 33, 33),
+(@CLASS, 12, 23, 24, 27, 34, 34),
+(@CLASS, 13, 24, 24, 27, 35, 36),
+(@CLASS, 14, 24, 25, 28, 36, 37),
+(@CLASS, 15, 24, 25, 29, 37, 38),
+(@CLASS, 16, 25, 26, 29, 38, 39),
+(@CLASS, 17, 25, 26, 30, 40, 41),
+(@CLASS, 18, 25, 26, 30, 41, 42),
+(@CLASS, 19, 26, 27, 31, 42, 43),
+(@CLASS, 20, 26, 27, 32, 43, 45),
+(@CLASS, 21, 26, 28, 32, 45, 46),
+(@CLASS, 22, 27, 28, 33, 46, 47),
+(@CLASS, 23, 27, 29, 34, 47, 49),
+(@CLASS, 24, 28, 29, 34, 49, 50),
+(@CLASS, 25, 28, 30, 35, 50, 52),
+(@CLASS, 26, 28, 30, 36, 51, 53),
+(@CLASS, 27, 29, 30, 36, 53, 54),
+(@CLASS, 28, 29, 31, 37, 54, 56),
+(@CLASS, 29, 30, 31, 38, 56, 57),
+(@CLASS, 30, 30, 32, 38, 57, 59),
+(@CLASS, 31, 30, 32, 39, 58, 61),
+(@CLASS, 32, 31, 33, 40, 60, 62),
+(@CLASS, 33, 31, 33, 41, 61, 64),
+(@CLASS, 34, 32, 34, 41, 63, 65),
+(@CLASS, 35, 32, 34, 42, 64, 67),
+(@CLASS, 36, 33, 35, 43, 66, 69),
+(@CLASS, 37, 33, 36, 44, 68, 70),
+(@CLASS, 38, 33, 36, 45, 69, 72),
+(@CLASS, 39, 34, 37, 45, 71, 74),
+(@CLASS, 40, 34, 37, 46, 72, 75),
+(@CLASS, 41, 35, 38, 47, 74, 77),
+(@CLASS, 42, 35, 38, 48, 76, 79),
+(@CLASS, 43, 36, 39, 49, 77, 81),
+(@CLASS, 44, 36, 39, 50, 79, 82),
+(@CLASS, 45, 37, 40, 50, 81, 84),
+(@CLASS, 46, 37, 41, 51, 83, 86),
+(@CLASS, 47, 38, 41, 52, 84, 88),
+(@CLASS, 48, 38, 42, 53, 86, 90),
+(@CLASS, 49, 39, 43, 54, 88, 92),
+(@CLASS, 50, 39, 43, 55, 90, 94),
+(@CLASS, 51, 40, 44, 56, 92, 96),
+(@CLASS, 52, 40, 44, 57, 94, 98),
+(@CLASS, 53, 41, 45, 58, 96, 100),
+(@CLASS, 54, 42, 46, 59, 98, 102),
+(@CLASS, 55, 42, 46, 60, 100, 104),
+(@CLASS, 56, 43, 47, 61, 102, 106),
+(@CLASS, 57, 43, 48, 62, 104, 108),
+(@CLASS, 58, 44, 49, 63, 106, 111),
+(@CLASS, 59, 44, 49, 64, 108, 113),
+(@CLASS, 60, 45, 50, 65, 110, 115),
+(@CLASS, 61, 46, 51, 66, 112, 117),
+(@CLASS, 62, 46, 51, 67, 114, 120),
+(@CLASS, 63, 47, 52, 68, 117, 122),
+(@CLASS, 64, 47, 53, 69, 119, 124),
+(@CLASS, 65, 48, 54, 71, 121, 127),
+(@CLASS, 66, 49, 55, 72, 123, 129),
+(@CLASS, 67, 49, 55, 73, 126, 132),
+(@CLASS, 68, 50, 56, 74, 128, 134),
+(@CLASS, 69, 51, 57, 75, 130, 136),
+(@CLASS, 70, 51, 58, 76, 133, 139),
+(@CLASS, 71, 52, 59, 78, 135, 142),
+(@CLASS, 72, 53, 59, 79, 138, 144),
+(@CLASS, 73, 54, 60, 80, 140, 147),
+(@CLASS, 74, 54, 61, 81, 143, 150),
+(@CLASS, 75, 55, 62, 83, 145, 152),
+(@CLASS, 76, 56, 63, 84, 148, 155),
+(@CLASS, 77, 57, 64, 85, 151, 158),
+(@CLASS, 78, 57, 65, 87, 153, 161),
+(@CLASS, 79, 58, 66, 88, 156, 164),
+(@CLASS, 80, 59, 67, 89, 159, 166),
+(@CLASS, 81, 60, 68, 91, 161, 169),
+(@CLASS, 82, 60, 68, 92, 164, 172),
+(@CLASS, 83, 61, 69, 94, 167, 175),
+(@CLASS, 84, 62, 70, 95, 170, 178),
+(@CLASS, 85, 63, 71, 96, 173, 181);