DB/Player: Update class level stats for Demonhunter

1 files changed, 66 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_10_17_13_world_demonhunter.sql b/sql/updates/world/master/2023_10_17_13_world_demonhunter.sql
new file mode 100644
index 00000000000..c5bc06563d7
--- /dev/null
+++ b/sql/updates/world/master/2023_10_17_13_world_demonhunter.sql
@@ -0,0 +1,66 @@
+-- Update Demon Hunter stats with simc
+UPDATE `player_classlevelstats` SET `str` = 25, `agi` = 31, `sta` = 63, `inte` = 23 WHERE `class` = 12 AND `Level` = 8;
+UPDATE `player_classlevelstats` SET `str` = 27, `agi` = 33, `sta` = 66, `inte` = 24 WHERE `class` = 12 AND `Level` = 9;
+UPDATE `player_classlevelstats` SET `str` = 29, `agi` = 35, `sta` = 70, `inte` = 26 WHERE `class` = 12 AND `Level` = 10;
+UPDATE `player_classlevelstats` SET `str` = 31, `agi` = 37, `sta` = 74, `inte` = 27 WHERE `class` = 12 AND `Level` = 11;
+UPDATE `player_classlevelstats` SET `str` = 33, `agi` = 40, `sta` = 77, `inte` = 29 WHERE `class` = 12 AND `Level` = 12;
+UPDATE `player_classlevelstats` SET `str` = 36, `agi` = 43, `sta` = 81, `inte` = 30 WHERE `class` = 12 AND `Level` = 13;
+UPDATE `player_classlevelstats` SET `str` = 38, `agi` = 46, `sta` = 85, `inte` = 31 WHERE `class` = 12 AND `Level` = 14;
+UPDATE `player_classlevelstats` SET `str` = 40, `agi` = 48, `sta` = 88, `inte` = 33 WHERE `class` = 12 AND `Level` = 15;
+UPDATE `player_classlevelstats` SET `str` = 42, `agi` = 50, `sta` = 92, `inte` = 34 WHERE `class` = 12 AND `Level` = 16;
+UPDATE `player_classlevelstats` SET `str` = 43, `agi` = 52, `sta` = 96, `inte` = 35 WHERE `class` = 12 AND `Level` = 17;
+UPDATE `player_classlevelstats` SET `str` = 45, `agi` = 54, `sta` = 99, `inte` = 37 WHERE `class` = 12 AND `Level` = 18;
+UPDATE `player_classlevelstats` SET `str` = 46, `agi` = 56, `sta` = 103, `inte` = 38 WHERE `class` = 12 AND `Level` = 19;
+UPDATE `player_classlevelstats` SET `str` = 48, `agi` = 58, `sta` = 107, `inte` = 39 WHERE `class` = 12 AND `Level` = 20;
+UPDATE `player_classlevelstats` SET `str` = 50, `agi` = 60, `sta` = 111, `inte` = 41 WHERE `class` = 12 AND `Level` = 21;
+UPDATE `player_classlevelstats` SET `str` = 52, `agi` = 63, `sta` = 116, `inte` = 43 WHERE `class` = 12 AND `Level` = 22;
+UPDATE `player_classlevelstats` SET `str` = 54, `agi` = 65, `sta` = 121, `inte` = 45 WHERE `class` = 12 AND `Level` = 23;
+UPDATE `player_classlevelstats` SET `str` = 57, `agi` = 68, `sta` = 126, `inte` = 46 WHERE `class` = 12 AND `Level` = 24;
+UPDATE `player_classlevelstats` SET `str` = 59, `agi` = 71, `sta` = 131, `inte` = 48 WHERE `class` = 12 AND `Level` = 25;
+UPDATE `player_classlevelstats` SET `str` = 62, `agi` = 74, `sta` = 137, `inte` = 50 WHERE `class` = 12 AND `Level` = 26;
+UPDATE `player_classlevelstats` SET `str` = 64, `agi` = 78, `sta` = 143, `inte` = 53 WHERE `class` = 12 AND `Level` = 27;
+UPDATE `player_classlevelstats` SET `str` = 67, `agi` = 81, `sta` = 149, `inte` = 55 WHERE `class` = 12 AND `Level` = 28;
+UPDATE `player_classlevelstats` SET `str` = 70, `agi` = 85, `sta` = 156, `inte` = 58 WHERE `class` = 12 AND `Level` = 29;
+UPDATE `player_classlevelstats` SET `str` = 73, `agi` = 88, `sta` = 163, `inte` = 60 WHERE `class` = 12 AND `Level` = 30;
+UPDATE `player_classlevelstats` SET `str` = 77, `agi` = 93, `sta` = 171, `inte` = 63 WHERE `class` = 12 AND `Level` = 31;
+UPDATE `player_classlevelstats` SET `str` = 80, `agi` = 97, `sta` = 179, `inte` = 66 WHERE `class` = 12 AND `Level` = 32;
+UPDATE `player_classlevelstats` SET `str` = 84, `agi` = 102, `sta` = 187, `inte` = 69 WHERE `class` = 12 AND `Level` = 33;
+UPDATE `player_classlevelstats` SET `str` = 88, `agi` = 106, `sta` = 196, `inte` = 72 WHERE `class` = 12 AND `Level` = 34;
+UPDATE `player_classlevelstats` SET `str` = 93, `agi` = 112, `sta` = 206, `inte` = 76 WHERE `class` = 12 AND `Level` = 35;
+UPDATE `player_classlevelstats` SET `str` = 97, `agi` = 117, `sta` = 216, `inte` = 80 WHERE `class` = 12 AND `Level` = 36;
+UPDATE `player_classlevelstats` SET `str` = 102, `agi` = 123, `sta` = 226, `inte` = 84 WHERE `class` = 12 AND `Level` = 37;
+UPDATE `player_classlevelstats` SET `str` = 107, `agi` = 129, `sta` = 238, `inte` = 88 WHERE `class` = 12 AND `Level` = 38;
+UPDATE `player_classlevelstats` SET `str` = 113, `agi` = 136, `sta` = 250, `inte` = 92 WHERE `class` = 12 AND `Level` = 39;
+UPDATE `player_classlevelstats` SET `str` = 118, `agi` = 143, `sta` = 263, `inte` = 97 WHERE `class` = 12 AND `Level` = 40;
+UPDATE `player_classlevelstats` SET `str` = 125, `agi` = 150, `sta` = 276, `inte` = 102 WHERE `class` = 12 AND `Level` = 41;
+UPDATE `player_classlevelstats` SET `str` = 131, `agi` = 158, `sta` = 291, `inte` = 107 WHERE `class` = 12 AND `Level` = 42;
+UPDATE `player_classlevelstats` SET `str` = 138, `agi` = 166, `sta` = 306, `inte` = 113 WHERE `class` = 12 AND `Level` = 43;
+UPDATE `player_classlevelstats` SET `str` = 146, `agi` = 175, `sta` = 323, `inte` = 119 WHERE `class` = 12 AND `Level` = 44;
+UPDATE `player_classlevelstats` SET `str` = 153, `agi` = 185, `sta` = 341, `inte` = 126 WHERE `class` = 12 AND `Level` = 45;
+UPDATE `player_classlevelstats` SET `str` = 162, `agi` = 195, `sta` = 359, `inte` = 133 WHERE `class` = 12 AND `Level` = 46;
+UPDATE `player_classlevelstats` SET `str` = 171, `agi` = 206, `sta` = 379, `inte` = 140 WHERE `class` = 12 AND `Level` = 47;
+UPDATE `player_classlevelstats` SET `str` = 180, `agi` = 217, `sta` = 400, `inte` = 148 WHERE `class` = 12 AND `Level` = 48;
+UPDATE `player_classlevelstats` SET `str` = 191, `agi` = 230, `sta` = 423, `inte` = 156 WHERE `class` = 12 AND `Level` = 49;
+UPDATE `player_classlevelstats` SET `str` = 202, `agi` = 243, `sta` = 447, `inte` = 165 WHERE `class` = 12 AND `Level` = 50;
+UPDATE `player_classlevelstats` SET `str` = 214, `agi` = 258, `sta` = 476, `inte` = 176 WHERE `class` = 12 AND `Level` = 51;
+UPDATE `player_classlevelstats` SET `str` = 228, `agi` = 275, `sta` = 506, `inte` = 187 WHERE `class` = 12 AND `Level` = 52;
+UPDATE `player_classlevelstats` SET `str` = 243, `agi` = 292, `sta` = 538, `inte` = 199 WHERE `class` = 12 AND `Level` = 53;
+UPDATE `player_classlevelstats` SET `str` = 258, `agi` = 311, `sta` = 572, `inte` = 211 WHERE `class` = 12 AND `Level` = 54;
+UPDATE `player_classlevelstats` SET `str` = 274, `agi` = 331, `sta` = 609, `inte` = 225 WHERE `class` = 12 AND `Level` = 55;
+UPDATE `player_classlevelstats` SET `str` = 292, `agi` = 352, `sta` = 647, `inte` = 239 WHERE `class` = 12 AND `Level` = 56;
+UPDATE `player_classlevelstats` SET `str` = 310, `agi` = 374, `sta` = 689, `inte` = 254 WHERE `class` = 12 AND `Level` = 57;
+UPDATE `player_classlevelstats` SET `str` = 330, `agi` = 398, `sta` = 732, `inte` = 270 WHERE `class` = 12 AND `Level` = 58;
+UPDATE `player_classlevelstats` SET `str` = 351, `agi` = 423, `sta` = 779, `inte` = 288 WHERE `class` = 12 AND `Level` = 59;
+UPDATE `player_classlevelstats` SET `str` = 373, `agi` = 450, `sta` = 828, `inte` = 306 WHERE `class` = 12 AND `Level` = 60;
+UPDATE `player_classlevelstats` SET `str` = 556, `agi` = 670, `sta` = 1235, `inte` = 456 WHERE `class` = 12 AND `Level` = 61;
+UPDATE `player_classlevelstats` SET `str` = 634, `agi` = 764, `sta` = 1407, `inte` = 519 WHERE `class` = 12 AND `Level` = 62;
+UPDATE `player_classlevelstats` SET `str` = 722, `agi` = 870, `sta` = 1603, `inte` = 592 WHERE `class` = 12 AND `Level` = 63;
+UPDATE `player_classlevelstats` SET `str` = 823, `agi` = 992, `sta` = 1826, `inte` = 674 WHERE `class` = 12 AND `Level` = 64;
+UPDATE `player_classlevelstats` SET `str` = 938, `agi` = 1130, `sta` = 2081, `inte` = 768 WHERE `class` = 12 AND `Level` = 65;
+UPDATE `player_classlevelstats` SET `str` = 1068, `agi` = 1287, `sta` = 2370, `inte` = 875 WHERE `class` = 12 AND `Level` = 66;
+UPDATE `player_classlevelstats` SET `str` = 1217, `agi` = 1466, `sta` = 2701, `inte` = 997 WHERE `class` = 12 AND `Level` = 67;
+UPDATE `player_classlevelstats` SET `str` = 1387, `agi` = 1671, `sta` = 3077, `inte` = 1136 WHERE `class` = 12 AND `Level` = 68;
+UPDATE `player_classlevelstats` SET `str` = 1580, `agi` = 1903, `sta` = 3506, `inte` = 1294 WHERE `class` = 12 AND `Level` = 69;
+UPDATE `player_classlevelstats` SET `str` = 1734, `agi` = 2089, `sta` = 3848, `inte` = 1421 WHERE `class` = 12 AND `Level` = 70;
+
+UPDATE `player_classlevelstats` SET `VerifiedBuild` = 0 WHERE `Class` = 12 AND `Level` BETWEEN 8 AND 70;