From c53c16b3a07d9e97a44ab09e650f38fcfedde228 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 22 May 2021 20:26:39 +0200 Subject: DB/Player: Add dummy stat values for demon hunter levels 1-7 --- sql/updates/world/master/2021_05_22_01_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/master/2021_05_22_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_05_22_01_world.sql b/sql/updates/world/master/2021_05_22_01_world.sql new file mode 100644 index 00000000000..26fc788c12d --- /dev/null +++ b/sql/updates/world/master/2021_05_22_01_world.sql @@ -0,0 +1,9 @@ +DELETE FROM `player_classlevelstats` WHERE `class`=12 AND `level`<8; +INSERT INTO `player_classlevelstats` (`class`, `level`, `str`, `agi`, `sta`, `inte`) VALUES +(12,1,14,15,11,8), +(12,2,16,17,12,9), +(12,3,17,18,12,10), +(12,4,17,19,13,10), +(12,5,17,19,13,10), +(12,6,17,19,13,10), +(12,7,19,20,14,11); -- cgit v1.2.3