aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorfunjoker <funjoker109@gmail.com>2021-10-09 12:26:48 +0200
committerfunjoker <funjoker109@gmail.com>2021-10-09 12:26:48 +0200
commit3322f3481945883abd7252d5c38ef70d6af9014d (patch)
treea7839f75426c24469d17d337affa5ecc3998960a
parent048f8dc6aa03b793e94a3de657215a32576d09da (diff)
DB/Class: Update rogue player_classlevelstats
-rw-r--r--sql/updates/world/master/2021_10_09_00_world.sql62
1 files changed, 62 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_10_09_00_world.sql b/sql/updates/world/master/2021_10_09_00_world.sql
new file mode 100644
index 00000000000..92bf6770e43
--- /dev/null
+++ b/sql/updates/world/master/2021_10_09_00_world.sql
@@ -0,0 +1,62 @@
+DELETE FROM `player_classlevelstats` WHERE `class`=4;
+INSERT INTO `player_classlevelstats` (`class`, `level`, `str`, `agi`, `sta`, `inte`) VALUES
+(4, 1, 14, 18, 19, 14),
+(4, 2, 15, 19, 21, 15),
+(4, 3, 17, 21, 23, 16),
+(4, 4, 18, 22, 25, 18),
+(4, 5, 20, 24, 27, 19),
+(4, 6, 21, 26, 29, 20),
+(4, 7, 23, 28, 30, 22),
+(4, 8, 24, 30, 32, 23),
+(4, 9, 26, 31, 34, 24),
+(4, 10, 28, 34, 36, 26),
+(4, 11, 30, 36, 38, 27),
+(4, 12, 32, 39, 40, 29),
+(4, 13, 35, 43, 42, 30),
+(4, 14, 38, 46, 44, 31),
+(4, 15, 40, 48, 46, 33),
+(4, 16, 42, 50, 48, 34),
+(4, 17, 43, 52, 50, 35),
+(4, 18, 45, 54, 51, 37),
+(4, 19, 46, 56, 53, 38),
+(4, 20, 48, 58, 55, 39),
+(4, 21, 50, 60, 57, 41),
+(4, 22, 51, 62, 59, 42),
+(4, 23, 53, 64, 61, 43),
+(4, 24, 55, 66, 63, 45),
+(4, 25, 56, 68, 65, 46),
+(4, 26, 58, 70, 68, 48),
+(4, 27, 60, 72, 69, 49),
+(4, 28, 62, 74, 71, 51),
+(4, 29, 64, 77, 73, 52),
+(4, 30, 66, 79, 75, 54),
+(4, 31, 68, 82, 78, 56),
+(4, 32, 70, 84, 80, 57),
+(4, 33, 72, 87, 83, 59),
+(4, 34, 75, 90, 86, 61),
+(4, 35, 77, 93, 88, 63),
+(4, 36, 80, 96, 91, 65),
+(4, 37, 82, 99, 94, 67),
+(4, 38, 85, 102, 97, 70),
+(4, 39, 88, 106, 101, 72),
+(4, 40, 91, 109, 104, 74),
+(4, 41, 94, 113, 108, 77),
+(4, 42, 97, 117, 112, 80),
+(4, 43, 101, 121, 116, 82),
+(4, 44, 104, 126, 120, 85),
+(4, 45, 108, 130, 124, 88),
+(4, 46, 112, 135, 128, 92),
+(4, 47, 116, 140, 133, 95),
+(4, 48, 120, 145, 138, 98),
+(4, 49, 124, 150, 143, 102),
+(4, 50, 129, 155, 148, 106),
+(4, 51, 160, 193, 187, 131),
+(4, 52, 172, 208, 204, 141),
+(4, 53, 186, 224, 223, 152),
+(4, 54, 200, 241, 244, 164),
+(4, 55, 215, 260, 267, 177),
+(4, 56, 232, 280, 292, 190),
+(4, 57, 248, 299, 317, 203),
+(4, 58, 264, 319, 343, 217),
+(4, 59, 282, 340, 372, 231),
+(4, 60, 373, 450, 414, 306);