aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorfunjoker <funjoker109@gmail.com>2021-08-30 18:47:12 +0200
committerfunjoker <funjoker109@gmail.com>2021-08-30 18:47:12 +0200
commitf9abd4700593f8c2a8b25ef6b5ba00ded4ec51fd (patch)
tree682ec463ae921de698371e88af8e143728df97af
parent96af9df9d2e00beefc7c723578512497a7d401d4 (diff)
DB/Class: Update druid player_classlevelstats
-rw-r--r--sql/updates/world/master/2021_08_30_01_world.sql62
1 files changed, 62 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_08_30_01_world.sql b/sql/updates/world/master/2021_08_30_01_world.sql
new file mode 100644
index 00000000000..85ee5fa799b
--- /dev/null
+++ b/sql/updates/world/master/2021_08_30_01_world.sql
@@ -0,0 +1,62 @@
+DELETE FROM `player_classlevelstats` WHERE `class`=11;
+INSERT INTO `player_classlevelstats` (`class`, `level`, `str`, `agi`, `sta`, `inte`) VALUES
+(11, 1 ,7 ,18 ,19 ,20),
+(11, 2 ,8 ,19 ,21 ,22),
+(11, 3 ,9 ,21 ,23 ,24),
+(11, 4 ,9 ,22 ,25 ,26),
+(11, 5 ,10 ,24 ,26 ,28),
+(11, 6 ,11 ,26 ,29 ,30),
+(11, 7 ,12 ,28 ,30 ,32),
+(11, 8 ,13 ,30 ,32 ,34),
+(11, 9 ,13 ,31 ,34 ,36),
+(11, 10 ,14 ,34 ,35 ,38),
+(11, 11 ,15 ,36 ,37 ,40),
+(11, 12 ,17 ,39 ,39 ,42),
+(11, 13 ,18 ,43 ,42 ,44),
+(11, 14 ,20 ,46 ,44 ,46),
+(11, 15 ,21 ,48 ,46 ,48),
+(11, 16 ,22 ,50 ,47 ,50),
+(11, 17 ,22 ,52 ,49 ,52),
+(11, 18 ,23 ,54 ,51 ,54),
+(11, 19 ,24 ,56 ,53 ,56),
+(11, 20 ,25 ,58 ,55 ,58),
+(11, 21 ,26 ,60 ,57 ,60),
+(11, 22 ,27 ,62 ,59 ,62),
+(11, 23 ,28 ,64 ,61 ,64),
+(11, 24 ,28 ,66 ,63 ,66),
+(11, 25 ,29 ,68 ,65 ,68),
+(11, 26 ,30 ,70 ,67 ,70),
+(11, 27 ,31 ,72 ,69 ,72),
+(11, 28 ,32 ,74 ,71 ,74),
+(11, 29 ,33 ,77 ,73 ,77),
+(11, 30 ,34 ,79 ,75 ,79),
+(11, 31 ,35 ,82 ,78 ,82),
+(11, 32 ,36 ,84 ,80 ,84),
+(11, 33 ,37 ,87 ,83 ,87),
+(11, 34 ,39 ,90 ,86 ,90),
+(11, 35 ,40 ,93 ,88 ,93),
+(11, 36 ,41 ,96 ,91 ,96),
+(11, 37 ,43 ,99 ,94 ,99),
+(11, 38 ,44 ,102 ,97 ,102),
+(11, 39 ,46 ,106 ,101 ,106),
+(11, 40 ,47 ,109 ,104 ,109),
+(11, 41 ,49 ,113 ,108 ,113),
+(11, 42 ,50 ,117 ,112 ,117),
+(11, 43 ,52 ,121 ,116 ,121),
+(11, 44 ,59 ,126 ,120 ,126),
+(11, 45 ,56 ,130 ,124 ,130),
+(11, 46 ,58 ,135 ,128 ,135),
+(11, 47 ,60 ,140 ,133 ,140),
+(11, 48 ,62 ,145 ,138 ,145),
+(11, 49 ,64 ,150 ,143 ,150),
+(11, 50 ,67 ,155 ,148 ,155),
+(11, 51 ,83 ,193 ,193 ,187),
+(11, 52 ,89 ,208 ,208 ,208),
+(11, 53 ,96 ,224 ,227 ,224),
+(11, 54 ,104 ,241 ,248 ,241),
+(11, 55 ,112 ,260 ,272 ,260),
+(11, 56 ,120 ,280 ,297 ,280),
+(11, 57 ,128 ,299 ,323 ,299),
+(11, 58 ,137 ,319 ,349 ,319),
+(11, 59 ,146 ,340 ,379 ,340),
+(11, 60 ,193 ,450 ,414 ,450);