aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorfunjoker <funjoker109@gmail.com>2021-12-16 20:12:52 +0100
committerfunjoker <funjoker109@gmail.com>2021-12-16 20:12:52 +0100
commita78b29c4bc46c3a9bd12de6e242f4fb74e49eca3 (patch)
tree6fa2fbd7096a462f4381593656cfa2d9d9cf5cf6
parent7bc3a92b2c7f546408edd32beb2c5cabdda6616b (diff)
DB/Class: Update death knight player_classlevelstats
-rw-r--r--sql/updates/world/master/2021_12_16_01_world.sql62
1 files changed, 62 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_16_01_world.sql b/sql/updates/world/master/2021_12_16_01_world.sql
new file mode 100644
index 00000000000..3faedef1a18
--- /dev/null
+++ b/sql/updates/world/master/2021_12_16_01_world.sql
@@ -0,0 +1,62 @@
+DELETE FROM `player_classlevelstats` WHERE `class`=6;
+INSERT INTO `player_classlevelstats` (`class`, `level`, `str`, `agi`, `sta`, `inte`) VALUES
+(6, 1, 17, 15, 23, 10),
+(6, 2, 18, 16, 25, 11),
+(6, 3, 20, 17, 27, 12),
+(6, 4, 22, 19, 29, 13),
+(6, 5, 24, 20, 31, 14),
+(6, 6, 26, 22, 33, 15),
+(6, 7, 28, 24, 34, 16),
+(6, 8, 29, 25, 36, 18),
+(6, 9, 31, 26, 38, 19),
+(6, 10, 33, 28, 40, 21),
+(6, 11, 36, 30, 42, 22),
+(6, 12, 39, 33, 43, 23),
+(6, 13, 43, 36, 45, 24),
+(6, 14, 46, 38, 46, 25),
+(6, 15, 48, 40, 48, 26),
+(6, 16, 50, 42, 50, 27),
+(6, 17, 52, 43, 51, 28),
+(6, 18, 54, 45, 52, 29),
+(6, 19, 56, 46, 54, 30),
+(6, 20, 58, 48, 55, 31),
+(6, 21, 60, 50, 57, 32),
+(6, 22, 62, 51, 59, 33),
+(6, 23, 64, 53, 61, 35),
+(6, 24, 66, 55, 63, 36),
+(6, 25, 68, 56, 65, 37),
+(6, 26, 70, 58, 67, 38),
+(6, 27, 72, 60, 69, 39),
+(6, 28, 74, 62, 71, 40),
+(6, 29, 77, 64, 73, 41),
+(6, 30, 79, 66, 75, 43),
+(6, 31, 82, 68, 78, 44),
+(6, 32, 84, 70, 80, 46),
+(6, 33, 87, 72, 83, 47),
+(6, 34, 90, 75, 86, 49),
+(6, 35, 93, 77, 88, 50),
+(6, 36, 96, 80, 91, 52),
+(6, 37, 99, 82, 94, 53),
+(6, 38, 102, 85, 97, 55),
+(6, 39, 106, 88, 101, 57),
+(6, 40, 109, 91, 104, 59),
+(6, 41, 113, 94, 108, 61),
+(6, 42, 117, 97, 112, 63),
+(6, 43, 121, 101, 116, 65),
+(6, 44, 126, 104, 120, 68),
+(6, 45, 130, 108, 124, 70),
+(6, 46, 135, 112, 128, 73),
+(6, 47, 140, 116, 133, 75),
+(6, 48, 145, 120, 138, 78),
+(6, 49, 150, 124, 143, 81),
+(6, 50, 155, 129, 162, 84),
+(6, 51, 193, 160, 205, 104),
+(6, 52, 208, 172, 224, 112),
+(6, 53, 224, 186, 245, 121),
+(6, 54, 241, 200, 268, 130),
+(6, 55, 260, 215, 293, 140),
+(6, 56, 280, 232, 321, 151),
+(6, 57, 299, 248, 348, 161),
+(6, 58, 319, 264, 377, 172),
+(6, 59, 340, 282, 409, 184),
+(6, 60, 450, 373, 414, 243);