diff options
| -rw-r--r-- | sql/updates/world/master/2023_10_17_02_world_warrior.sql | 73 |
1 files changed, 73 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_10_17_02_world_warrior.sql b/sql/updates/world/master/2023_10_17_02_world_warrior.sql new file mode 100644 index 00000000000..a434168a2b2 --- /dev/null +++ b/sql/updates/world/master/2023_10_17_02_world_warrior.sql @@ -0,0 +1,73 @@ +-- Update Warrior stats with simc +UPDATE `player_classlevelstats` SET `str` = 18, `agi` = 13, `sta` = 44, `inte` = 14 WHERE `class` = 1 AND `Level` = 1; +UPDATE `player_classlevelstats` SET `str` = 20, `agi` = 14, `sta` = 48, `inte` = 15 WHERE `class` = 1 AND `Level` = 2; +UPDATE `player_classlevelstats` SET `str` = 22, `agi` = 15, `sta` = 52, `inte` = 16 WHERE `class` = 1 AND `Level` = 3; +UPDATE `player_classlevelstats` SET `str` = 23, `agi` = 17, `sta` = 56, `inte` = 18 WHERE `class` = 1 AND `Level` = 4; +UPDATE `player_classlevelstats` SET `str` = 26, `agi` = 18, `sta` = 59, `inte` = 19 WHERE `class` = 1 AND `Level` = 5; +UPDATE `player_classlevelstats` SET `str` = 27, `agi` = 19, `sta` = 63, `inte` = 19 WHERE `class` = 1 AND `Level` = 6; +UPDATE `player_classlevelstats` SET `str` = 29, `agi` = 20, `sta` = 67, `inte` = 22 WHERE `class` = 1 AND `Level` = 7; +UPDATE `player_classlevelstats` SET `str` = 31, `agi` = 21, `sta` = 70, `inte` = 23 WHERE `class` = 1 AND `Level` = 8; +UPDATE `player_classlevelstats` SET `str` = 32, `agi` = 22, `sta` = 74, `inte` = 24 WHERE `class` = 1 AND `Level` = 9; +UPDATE `player_classlevelstats` SET `str` = 34, `agi` = 24, `sta` = 77, `inte` = 26 WHERE `class` = 1 AND `Level` = 10; +UPDATE `player_classlevelstats` SET `str` = 37, `agi` = 26, `sta` = 80, `inte` = 27 WHERE `class` = 1 AND `Level` = 11; +UPDATE `player_classlevelstats` SET `str` = 40, `agi` = 28, `sta` = 84, `inte` = 29 WHERE `class` = 1 AND `Level` = 12; +UPDATE `player_classlevelstats` SET `str` = 43, `agi` = 30, `sta` = 87, `inte` = 30 WHERE `class` = 1 AND `Level` = 13; +UPDATE `player_classlevelstats` SET `str` = 46, `agi` = 32, `sta` = 90, `inte` = 31 WHERE `class` = 1 AND `Level` = 14; +UPDATE `player_classlevelstats` SET `str` = 48, `agi` = 33, `sta` = 93, `inte` = 33 WHERE `class` = 1 AND `Level` = 15; +UPDATE `player_classlevelstats` SET `str` = 50, `agi` = 35, `sta` = 96, `inte` = 34 WHERE `class` = 1 AND `Level` = 16; +UPDATE `player_classlevelstats` SET `str` = 52, `agi` = 36, `sta` = 99, `inte` = 35 WHERE `class` = 1 AND `Level` = 17; +UPDATE `player_classlevelstats` SET `str` = 54, `agi` = 37, `sta` = 101, `inte` = 37 WHERE `class` = 1 AND `Level` = 18; +UPDATE `player_classlevelstats` SET `str` = 56, `agi` = 39, `sta` = 104, `inte` = 38 WHERE `class` = 1 AND `Level` = 19; +UPDATE `player_classlevelstats` SET `str` = 58, `agi` = 40, `sta` = 107, `inte` = 39 WHERE `class` = 1 AND `Level` = 20; +UPDATE `player_classlevelstats` SET `str` = 60, `agi` = 42, `sta` = 111, `inte` = 41 WHERE `class` = 1 AND `Level` = 21; +UPDATE `player_classlevelstats` SET `str` = 63, `agi` = 43, `sta` = 116, `inte` = 43 WHERE `class` = 1 AND `Level` = 22; +UPDATE `player_classlevelstats` SET `str` = 65, `agi` = 45, `sta` = 121, `inte` = 45 WHERE `class` = 1 AND `Level` = 23; +UPDATE `player_classlevelstats` SET `str` = 68, `agi` = 47, `sta` = 126, `inte` = 46 WHERE `class` = 1 AND `Level` = 24; +UPDATE `player_classlevelstats` SET `str` = 71, `agi` = 49, `sta` = 131, `inte` = 48 WHERE `class` = 1 AND `Level` = 25; +UPDATE `player_classlevelstats` SET `str` = 74, `agi` = 51, `sta` = 137, `inte` = 50 WHERE `class` = 1 AND `Level` = 26; +UPDATE `player_classlevelstats` SET `str` = 78, `agi` = 53, `sta` = 143, `inte` = 53 WHERE `class` = 1 AND `Level` = 27; +UPDATE `player_classlevelstats` SET `str` = 81, `agi` = 56, `sta` = 149, `inte` = 55 WHERE `class` = 1 AND `Level` = 28; +UPDATE `player_classlevelstats` SET `str` = 85, `agi` = 58, `sta` = 156, `inte` = 58 WHERE `class` = 1 AND `Level` = 29; +UPDATE `player_classlevelstats` SET `str` = 88, `agi` = 61, `sta` = 163, `inte` = 60 WHERE `class` = 1 AND `Level` = 30; +UPDATE `player_classlevelstats` SET `str` = 93, `agi` = 64, `sta` = 171, `inte` = 63 WHERE `class` = 1 AND `Level` = 31; +UPDATE `player_classlevelstats` SET `str` = 97, `agi` = 67, `sta` = 179, `inte` = 66 WHERE `class` = 1 AND `Level` = 32; +UPDATE `player_classlevelstats` SET `str` = 102, `agi` = 70, `sta` = 187, `inte` = 69 WHERE `class` = 1 AND `Level` = 33; +UPDATE `player_classlevelstats` SET `str` = 106, `agi` = 73, `sta` = 196, `inte` = 72 WHERE `class` = 1 AND `Level` = 34; +UPDATE `player_classlevelstats` SET `str` = 112, `agi` = 77, `sta` = 206, `inte` = 76 WHERE `class` = 1 AND `Level` = 35; +UPDATE `player_classlevelstats` SET `str` = 117, `agi` = 81, `sta` = 216, `inte` = 80 WHERE `class` = 1 AND `Level` = 36; +UPDATE `player_classlevelstats` SET `str` = 123, `agi` = 85, `sta` = 226, `inte` = 84 WHERE `class` = 1 AND `Level` = 37; +UPDATE `player_classlevelstats` SET `str` = 129, `agi` = 89, `sta` = 238, `inte` = 88 WHERE `class` = 1 AND `Level` = 38; +UPDATE `player_classlevelstats` SET `str` = 136, `agi` = 94, `sta` = 250, `inte` = 92 WHERE `class` = 1 AND `Level` = 39; +UPDATE `player_classlevelstats` SET `str` = 143, `agi` = 98, `sta` = 263, `inte` = 97 WHERE `class` = 1 AND `Level` = 40; +UPDATE `player_classlevelstats` SET `str` = 150, `agi` = 104, `sta` = 276, `inte` = 102 WHERE `class` = 1 AND `Level` = 41; +UPDATE `player_classlevelstats` SET `str` = 158, `agi` = 109, `sta` = 291, `inte` = 107 WHERE `class` = 1 AND `Level` = 42; +UPDATE `player_classlevelstats` SET `str` = 166, `agi` = 115, `sta` = 306, `inte` = 113 WHERE `class` = 1 AND `Level` = 43; +UPDATE `player_classlevelstats` SET `str` = 175, `agi` = 121, `sta` = 323, `inte` = 119 WHERE `class` = 1 AND `Level` = 44; +UPDATE `player_classlevelstats` SET `str` = 185, `agi` = 128, `sta` = 341, `inte` = 126 WHERE `class` = 1 AND `Level` = 45; +UPDATE `player_classlevelstats` SET `str` = 195, `agi` = 135, `sta` = 359, `inte` = 133 WHERE `class` = 1 AND `Level` = 46; +UPDATE `player_classlevelstats` SET `str` = 206, `agi` = 142, `sta` = 379, `inte` = 140 WHERE `class` = 1 AND `Level` = 47; +UPDATE `player_classlevelstats` SET `str` = 217, `agi` = 150, `sta` = 400, `inte` = 148 WHERE `class` = 1 AND `Level` = 48; +UPDATE `player_classlevelstats` SET `str` = 230, `agi` = 159, `sta` = 423, `inte` = 156 WHERE `class` = 1 AND `Level` = 49; +UPDATE `player_classlevelstats` SET `str` = 243, `agi` = 168, `sta` = 447, `inte` = 165 WHERE `class` = 1 AND `Level` = 50; +UPDATE `player_classlevelstats` SET `str` = 258, `agi` = 178, `sta` = 476, `inte` = 176 WHERE `class` = 1 AND `Level` = 51; +UPDATE `player_classlevelstats` SET `str` = 275, `agi` = 190, `sta` = 506, `inte` = 187 WHERE `class` = 1 AND `Level` = 52; +UPDATE `player_classlevelstats` SET `str` = 292, `agi` = 202, `sta` = 538, `inte` = 199 WHERE `class` = 1 AND `Level` = 53; +UPDATE `player_classlevelstats` SET `str` = 311, `agi` = 214, `sta` = 572, `inte` = 211 WHERE `class` = 1 AND `Level` = 54; +UPDATE `player_classlevelstats` SET `str` = 331, `agi` = 228, `sta` = 609, `inte` = 225 WHERE `class` = 1 AND `Level` = 55; +UPDATE `player_classlevelstats` SET `str` = 352, `agi` = 243, `sta` = 647, `inte` = 239 WHERE `class` = 1 AND `Level` = 56; +UPDATE `player_classlevelstats` SET `str` = 374, `agi` = 258, `sta` = 689, `inte` = 254 WHERE `class` = 1 AND `Level` = 57; +UPDATE `player_classlevelstats` SET `str` = 398, `agi` = 274, `sta` = 732, `inte` = 270 WHERE `class` = 1 AND `Level` = 58; +UPDATE `player_classlevelstats` SET `str` = 423, `agi` = 292, `sta` = 779, `inte` = 288 WHERE `class` = 1 AND `Level` = 59; +UPDATE `player_classlevelstats` SET `str` = 450, `agi` = 310, `sta` = 828, `inte` = 306 WHERE `class` = 1 AND `Level` = 60; +UPDATE `player_classlevelstats` SET `str` = 670, `agi` = 463, `sta` = 1235, `inte` = 456 WHERE `class` = 1 AND `Level` = 61; +UPDATE `player_classlevelstats` SET `str` = 764, `agi` = 527, `sta` = 1407, `inte` = 519 WHERE `class` = 1 AND `Level` = 62; +UPDATE `player_classlevelstats` SET `str` = 870, `agi` = 600, `sta` = 1603, `inte` = 692 WHERE `class` = 1 AND `Level` = 63; +UPDATE `player_classlevelstats` SET `str` = 992, `agi` = 684, `sta` = 1826, `inte` = 674 WHERE `class` = 1 AND `Level` = 64; +UPDATE `player_classlevelstats` SET `str` = 1130, `agi` = 779, `sta` = 2081, `inte` = 768 WHERE `class` = 1 AND `Level` = 65; +UPDATE `player_classlevelstats` SET `str` = 1287, `agi` = 888, `sta` = 2370, `inte` = 875 WHERE `class` = 1 AND `Level` = 66; +UPDATE `player_classlevelstats` SET `str` = 1466, `agi` = 1012, `sta` = 2701, `inte` = 997 WHERE `class` = 1 AND `Level` = 67; +UPDATE `player_classlevelstats` SET `str` = 1671, `agi` = 1153, `sta` = 3077, `inte` = 1136 WHERE `class` = 1 AND `Level` = 68; +UPDATE `player_classlevelstats` SET `str` = 1903, `agi` = 1313, `sta` = 3506, `inte` = 1294 WHERE `class` = 1 AND `Level` = 69; +UPDATE `player_classlevelstats` SET `str` = 2089, `agi` = 1442, `sta` = 3848, `inte` = 1421 WHERE `class` = 1 AND `Level` = 70; + +UPDATE `player_classlevelstats` SET `VerifiedBuild` = 0 WHERE `Class` = 1 AND `Level` BETWEEN 1 AND 70; |