DB/Player: Update class level stats for Mage

1 files changed, 73 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_10_17_09_world_mage.sql b/sql/updates/world/master/2023_10_17_09_world_mage.sql
new file mode 100644
index 00000000000..87abdd8ce2c
--- /dev/null
+++ b/sql/updates/world/master/2023_10_17_09_world_mage.sql
@@ -0,0 +1,73 @@
+-- Update Mage stats with simc
+UPDATE `player_classlevelstats` SET `str` = 8, `agi` = 12, `sta` = 30, `inte` = 20 WHERE `class` = 8 AND `Level` = 1;
+UPDATE `player_classlevelstats` SET `str` = 9, `agi` = 14, `sta` = 33, `inte` = 22 WHERE `class` = 8 AND `Level` = 2;
+UPDATE `player_classlevelstats` SET `str` = 10, `agi` = 15, `sta` = 37, `inte` = 24 WHERE `class` = 8 AND `Level` = 3;
+UPDATE `player_classlevelstats` SET `str` = 10, `agi` = 16, `sta` = 40, `inte` = 26 WHERE `class` = 8 AND `Level` = 4;
+UPDATE `player_classlevelstats` SET `str` = 11, `agi` = 18, `sta` = 44, `inte` = 28 WHERE `class` = 8 AND `Level` = 5;
+UPDATE `player_classlevelstats` SET `str` = 12, `agi` = 19, `sta` = 48, `inte` = 30 WHERE `class` = 8 AND `Level` = 6;
+UPDATE `player_classlevelstats` SET `str` = 13, `agi` = 20, `sta` = 51, `inte` = 32 WHERE `class` = 8 AND `Level` = 7;
+UPDATE `player_classlevelstats` SET `str` = 13, `agi` = 21, `sta` = 55, `inte` = 34 WHERE `class` = 8 AND `Level` = 8;
+UPDATE `player_classlevelstats` SET `str` = 14, `agi` = 22, `sta` = 59, `inte` = 36 WHERE `class` = 8 AND `Level` = 9;
+UPDATE `player_classlevelstats` SET `str` = 15, `agi` = 24, `sta` = 63, `inte` = 38 WHERE `class` = 8 AND `Level` = 10;
+UPDATE `player_classlevelstats` SET `str` = 16, `agi` = 25, `sta` = 67, `inte` = 40 WHERE `class` = 8 AND `Level` = 11;
+UPDATE `player_classlevelstats` SET `str` = 18, `agi` = 27, `sta` = 72, `inte` = 42 WHERE `class` = 8 AND `Level` = 12;
+UPDATE `player_classlevelstats` SET `str` = 19, `agi` = 29, `sta` = 76, `inte` = 44 WHERE `class` = 8 AND `Level` = 13;
+UPDATE `player_classlevelstats` SET `str` = 20, `agi` = 31, `sta` = 80, `inte` = 46 WHERE `class` = 8 AND `Level` = 14;
+UPDATE `player_classlevelstats` SET `str` = 21, `agi` = 33, `sta` = 84, `inte` = 48 WHERE `class` = 8 AND `Level` = 15;
+UPDATE `player_classlevelstats` SET `str` = 22, `agi` = 34, `sta` = 88, `inte` = 50 WHERE `class` = 8 AND `Level` = 16;
+UPDATE `player_classlevelstats` SET `str` = 23, `agi` = 35, `sta` = 92, `inte` = 52 WHERE `class` = 8 AND `Level` = 17;
+UPDATE `player_classlevelstats` SET `str` = 24, `agi` = 37, `sta` = 98, `inte` = 54 WHERE `class` = 8 AND `Level` = 18;
+UPDATE `player_classlevelstats` SET `str` = 25, `agi` = 38, `sta` = 102, `inte` = 56 WHERE `class` = 8 AND `Level` = 19;
+UPDATE `player_classlevelstats` SET `str` = 26, `agi` = 39, `sta` = 107, `inte` = 58 WHERE `class` = 8 AND `Level` = 20;
+UPDATE `player_classlevelstats` SET `str` = 27, `agi` = 41, `sta` = 111, `inte` = 60 WHERE `class` = 8 AND `Level` = 21;
+UPDATE `player_classlevelstats` SET `str` = 28, `agi` = 43, `sta` = 116, `inte` = 63 WHERE `class` = 8 AND `Level` = 22;
+UPDATE `player_classlevelstats` SET `str` = 29, `agi` = 45, `sta` = 121, `inte` = 65 WHERE `class` = 8 AND `Level` = 23;
+UPDATE `player_classlevelstats` SET `str` = 30, `agi` = 46, `sta` = 126, `inte` = 68 WHERE `class` = 8 AND `Level` = 24;
+UPDATE `player_classlevelstats` SET `str` = 31, `agi` = 48, `sta` = 131, `inte` = 71 WHERE `class` = 8 AND `Level` = 25;
+UPDATE `player_classlevelstats` SET `str` = 33, `agi` = 50, `sta` = 137, `inte` = 74 WHERE `class` = 8 AND `Level` = 26;
+UPDATE `player_classlevelstats` SET `str` = 34, `agi` = 53, `sta` = 143, `inte` = 78 WHERE `class` = 8 AND `Level` = 27;
+UPDATE `player_classlevelstats` SET `str` = 36, `agi` = 55, `sta` = 149, `inte` = 81 WHERE `class` = 8 AND `Level` = 28;
+UPDATE `player_classlevelstats` SET `str` = 37, `agi` = 58, `sta` = 156, `inte` = 85 WHERE `class` = 8 AND `Level` = 29;
+UPDATE `player_classlevelstats` SET `str` = 39, `agi` = 60, `sta` = 163, `inte` = 88 WHERE `class` = 8 AND `Level` = 30;
+UPDATE `player_classlevelstats` SET `str` = 41, `agi` = 63, `sta` = 171, `inte` = 93 WHERE `class` = 8 AND `Level` = 31;
+UPDATE `player_classlevelstats` SET `str` = 43, `agi` = 66, `sta` = 179, `inte` = 97 WHERE `class` = 8 AND `Level` = 32;
+UPDATE `player_classlevelstats` SET `str` = 45, `agi` = 69, `sta` = 187, `inte` = 102 WHERE `class` = 8 AND `Level` = 33;
+UPDATE `player_classlevelstats` SET `str` = 47, `agi` = 72, `sta` = 196, `inte` = 106 WHERE `class` = 8 AND `Level` = 34;
+UPDATE `player_classlevelstats` SET `str` = 49, `agi` = 76, `sta` = 206, `inte` = 112 WHERE `class` = 8 AND `Level` = 35;
+UPDATE `player_classlevelstats` SET `str` = 51, `agi` = 80, `sta` = 216, `inte` = 117 WHERE `class` = 8 AND `Level` = 36;
+UPDATE `player_classlevelstats` SET `str` = 54, `agi` = 84, `sta` = 226, `inte` = 123 WHERE `class` = 8 AND `Level` = 37;
+UPDATE `player_classlevelstats` SET `str` = 57, `agi` = 88, `sta` = 238, `inte` = 129 WHERE `class` = 8 AND `Level` = 38;
+UPDATE `player_classlevelstats` SET `str` = 60, `agi` = 92, `sta` = 250, `inte` = 136 WHERE `class` = 8 AND `Level` = 39;
+UPDATE `player_classlevelstats` SET `str` = 63, `agi` = 97, `sta` = 263, `inte` = 143 WHERE `class` = 8 AND `Level` = 40;
+UPDATE `player_classlevelstats` SET `str` = 66, `agi` = 102, `sta` = 276, `inte` = 150 WHERE `class` = 8 AND `Level` = 41;
+UPDATE `player_classlevelstats` SET `str` = 69, `agi` = 107, `sta` = 291, `inte` = 158 WHERE `class` = 8 AND `Level` = 42;
+UPDATE `player_classlevelstats` SET `str` = 73, `agi` = 113, `sta` = 306, `inte` = 166 WHERE `class` = 8 AND `Level` = 43;
+UPDATE `player_classlevelstats` SET `str` = 77, `agi` = 119, `sta` = 323, `inte` = 175 WHERE `class` = 8 AND `Level` = 44;
+UPDATE `player_classlevelstats` SET `str` = 81, `agi` = 126, `sta` = 341, `inte` = 185 WHERE `class` = 8 AND `Level` = 45;
+UPDATE `player_classlevelstats` SET `str` = 86, `agi` = 133, `sta` = 359, `inte` = 195 WHERE `class` = 8 AND `Level` = 46;
+UPDATE `player_classlevelstats` SET `str` = 91, `agi` = 140, `sta` = 379, `inte` = 206 WHERE `class` = 8 AND `Level` = 47;
+UPDATE `player_classlevelstats` SET `str` = 96, `agi` = 148, `sta` = 400, `inte` = 217 WHERE `class` = 8 AND `Level` = 48;
+UPDATE `player_classlevelstats` SET `str` = 101, `agi` = 156, `sta` = 423, `inte` = 230 WHERE `class` = 8 AND `Level` = 49;
+UPDATE `player_classlevelstats` SET `str` = 107, `agi` = 165, `sta` = 447, `inte` = 243 WHERE `class` = 8 AND `Level` = 50;
+UPDATE `player_classlevelstats` SET `str` = 114, `agi` = 176, `sta` = 476, `inte` = 258 WHERE `class` = 8 AND `Level` = 51;
+UPDATE `player_classlevelstats` SET `str` = 121, `agi` = 187, `sta` = 506, `inte` = 275 WHERE `class` = 8 AND `Level` = 52;
+UPDATE `player_classlevelstats` SET `str` = 129, `agi` = 199, `sta` = 538, `inte` = 292 WHERE `class` = 8 AND `Level` = 53;
+UPDATE `player_classlevelstats` SET `str` = 137, `agi` = 211, `sta` = 572, `inte` = 311 WHERE `class` = 8 AND `Level` = 54;
+UPDATE `player_classlevelstats` SET `str` = 145, `agi` = 225, `sta` = 609, `inte` = 331 WHERE `class` = 8 AND `Level` = 55;
+UPDATE `player_classlevelstats` SET `str` = 155, `agi` = 239, `sta` = 647, `inte` = 352 WHERE `class` = 8 AND `Level` = 56;
+UPDATE `player_classlevelstats` SET `str` = 165, `agi` = 254, `sta` = 689, `inte` = 374 WHERE `class` = 8 AND `Level` = 57;
+UPDATE `player_classlevelstats` SET `str` = 175, `agi` = 270, `sta` = 732, `inte` = 398 WHERE `class` = 8 AND `Level` = 58;
+UPDATE `player_classlevelstats` SET `str` = 186, `agi` = 288, `sta` = 779, `inte` = 423 WHERE `class` = 8 AND `Level` = 59;
+UPDATE `player_classlevelstats` SET `str` = 198, `agi` = 306, `sta` = 828, `inte` = 450 WHERE `class` = 8 AND `Level` = 60;
+UPDATE `player_classlevelstats` SET `str` = 295, `agi` = 456, `sta` = 1235, `inte` = 670 WHERE `class` = 8 AND `Level` = 61;
+UPDATE `player_classlevelstats` SET `str` = 336, `agi` = 519, `sta` = 1407, `inte` = 764 WHERE `class` = 8 AND `Level` = 62;
+UPDATE `player_classlevelstats` SET `str` = 383, `agi` = 592, `sta` = 1603, `inte` = 870 WHERE `class` = 8 AND `Level` = 63;
+UPDATE `player_classlevelstats` SET `str` = 436, `agi` = 674, `sta` = 1826, `inte` = 992 WHERE `class` = 8 AND `Level` = 64;
+UPDATE `player_classlevelstats` SET `str` = 497, `agi` = 768, `sta` = 2081, `inte` = 1130 WHERE `class` = 8 AND `Level` = 65;
+UPDATE `player_classlevelstats` SET `str` = 566, `agi` = 875, `sta` = 2370, `inte` = 1287 WHERE `class` = 8 AND `Level` = 66;
+UPDATE `player_classlevelstats` SET `str` = 645, `agi` = 997, `sta` = 2701, `inte` = 1466 WHERE `class` = 8 AND `Level` = 67;
+UPDATE `player_classlevelstats` SET `str` = 735, `agi` = 1136, `sta` = 3077, `inte` = 1671 WHERE `class` = 8 AND `Level` = 68;
+UPDATE `player_classlevelstats` SET `str` = 838, `agi` = 1294, `sta` = 3506, `inte` = 1903 WHERE `class` = 8 AND `Level` = 69;
+UPDATE `player_classlevelstats` SET `str` = 919, `agi` = 1421, `sta` = 3848, `inte` = 2089 WHERE `class` = 8 AND `Level` = 70;
+
+UPDATE `player_classlevelstats` SET `VerifiedBuild` = 0 WHERE `Class` = 8 AND `Level` BETWEEN 1 AND 70;