diff options
| author | funjoker <funjoker109@gmail.com> | 2025-05-13 23:53:55 +0200 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2025-05-13 23:53:55 +0200 |
| commit | e723e7935ec92ab1258def0a4238cb6c1c72ec7c (patch) | |
| tree | f1cbc6e649d13590bc612bc65082a9dc705b552d | |
| parent | 58485e6d7a7b831578e29c6a236e4dde4a3b9807 (diff) | |
Core/Stats: Reimplement basehp
| -rw-r--r-- | sql/updates/world/wotlk_classic/2025_05_13_01_world.sql | 802 | ||||
| -rw-r--r-- | src/server/game/DataStores/GameTables.cpp | 2 | ||||
| -rw-r--r-- | src/server/game/DataStores/GameTables.h | 33 | ||||
| -rw-r--r-- | src/server/game/Entities/Player/Player.cpp | 14 | ||||
| -rw-r--r-- | src/server/game/Entities/Player/PlayerTaxi.cpp | 2 | ||||
| -rw-r--r-- | src/server/game/Entities/Unit/StatSystem.cpp | 4 | ||||
| -rw-r--r-- | src/server/game/Globals/ObjectMgr.cpp | 29 | ||||
| -rw-r--r-- | src/server/game/Globals/ObjectMgr.h | 3 | ||||
| -rw-r--r-- | src/server/game/Handlers/CharacterHandler.cpp | 6 | ||||
| -rw-r--r-- | src/server/game/Miscellaneous/RaceMask.h | 15 | ||||
| -rw-r--r-- | src/server/game/Miscellaneous/enuminfo_RaceMask.cpp | 6 | ||||
| -rw-r--r-- | src/server/scripts/Spells/spell_generic.cpp | 6 | ||||
| -rw-r--r-- | src/tools/map_extractor/System.cpp | 2 |
13 files changed, 844 insertions, 80 deletions
diff --git a/sql/updates/world/wotlk_classic/2025_05_13_01_world.sql b/sql/updates/world/wotlk_classic/2025_05_13_01_world.sql new file mode 100644 index 00000000000..28c3d39391a --- /dev/null +++ b/sql/updates/world/wotlk_classic/2025_05_13_01_world.sql @@ -0,0 +1,802 @@ +ALTER TABLE `player_classlevelstats` ADD COLUMN `basehp` SMALLINT(5) NOT NULL AFTER `spi`; + +UPDATE `player_classlevelstats` SET `basehp`=20 WHERE `class`=1 AND `level`=1; +UPDATE `player_classlevelstats` SET `basehp`=29 WHERE `class`=1 AND `level`=2; +UPDATE `player_classlevelstats` SET `basehp`=38 WHERE `class`=1 AND `level`=3; +UPDATE `player_classlevelstats` SET `basehp`=47 WHERE `class`=1 AND `level`=4; +UPDATE `player_classlevelstats` SET `basehp`=56 WHERE `class`=1 AND `level`=5; +UPDATE `player_classlevelstats` SET `basehp`=65 WHERE `class`=1 AND `level`=6; +UPDATE `player_classlevelstats` SET `basehp`=74 WHERE `class`=1 AND `level`=7; +UPDATE `player_classlevelstats` SET `basehp`=83 WHERE `class`=1 AND `level`=8; +UPDATE `player_classlevelstats` SET `basehp`=92 WHERE `class`=1 AND `level`=9; +UPDATE `player_classlevelstats` SET `basehp`=97 WHERE `class`=1 AND `level`=10; +UPDATE `player_classlevelstats` SET `basehp`=103 WHERE `class`=1 AND `level`=11; +UPDATE `player_classlevelstats` SET `basehp`=109 WHERE `class`=1 AND `level`=12; +UPDATE `player_classlevelstats` SET `basehp`=118 WHERE `class`=1 AND `level`=13; +UPDATE `player_classlevelstats` SET `basehp`=128 WHERE `class`=1 AND `level`=14; +UPDATE `player_classlevelstats` SET `basehp`=139 WHERE `class`=1 AND `level`=15; +UPDATE `player_classlevelstats` SET `basehp`=151 WHERE `class`=1 AND `level`=16; +UPDATE `player_classlevelstats` SET `basehp`=154 WHERE `class`=1 AND `level`=17; +UPDATE `player_classlevelstats` SET `basehp`=168 WHERE `class`=1 AND `level`=18; +UPDATE `player_classlevelstats` SET `basehp`=183 WHERE `class`=1 AND `level`=19; +UPDATE `player_classlevelstats` SET `basehp`=199 WHERE `class`=1 AND `level`=20; +UPDATE `player_classlevelstats` SET `basehp`=206 WHERE `class`=1 AND `level`=21; +UPDATE `player_classlevelstats` SET `basehp`=224 WHERE `class`=1 AND `level`=22; +UPDATE `player_classlevelstats` SET `basehp`=243 WHERE `class`=1 AND `level`=23; +UPDATE `player_classlevelstats` SET `basehp`=253 WHERE `class`=1 AND `level`=24; +UPDATE `player_classlevelstats` SET `basehp`=274 WHERE `class`=1 AND `level`=25; +UPDATE `player_classlevelstats` SET `basehp`=296 WHERE `class`=1 AND `level`=26; +UPDATE `player_classlevelstats` SET `basehp`=309 WHERE `class`=1 AND `level`=27; +UPDATE `player_classlevelstats` SET `basehp`=333 WHERE `class`=1 AND `level`=28; +UPDATE `player_classlevelstats` SET `basehp`=348 WHERE `class`=1 AND `level`=29; +UPDATE `player_classlevelstats` SET `basehp`=374 WHERE `class`=1 AND `level`=30; +UPDATE `player_classlevelstats` SET `basehp`=401 WHERE `class`=1 AND `level`=31; +UPDATE `player_classlevelstats` SET `basehp`=419 WHERE `class`=1 AND `level`=32; +UPDATE `player_classlevelstats` SET `basehp`=448 WHERE `class`=1 AND `level`=33; +UPDATE `player_classlevelstats` SET `basehp`=468 WHERE `class`=1 AND `level`=34; +UPDATE `player_classlevelstats` SET `basehp`=499 WHERE `class`=1 AND `level`=35; +UPDATE `player_classlevelstats` SET `basehp`=521 WHERE `class`=1 AND `level`=36; +UPDATE `player_classlevelstats` SET `basehp`=545 WHERE `class`=1 AND `level`=37; +UPDATE `player_classlevelstats` SET `basehp`=581 WHERE `class`=1 AND `level`=38; +UPDATE `player_classlevelstats` SET `basehp`=609 WHERE `class`=1 AND `level`=39; +UPDATE `player_classlevelstats` SET `basehp`=649 WHERE `class`=1 AND `level`=40; +UPDATE `player_classlevelstats` SET `basehp`=681 WHERE `class`=1 AND `level`=41; +UPDATE `player_classlevelstats` SET `basehp`=715 WHERE `class`=1 AND `level`=42; +UPDATE `player_classlevelstats` SET `basehp`=761 WHERE `class`=1 AND `level`=43; +UPDATE `player_classlevelstats` SET `basehp`=799 WHERE `class`=1 AND `level`=44; +UPDATE `player_classlevelstats` SET `basehp`=839 WHERE `class`=1 AND `level`=45; +UPDATE `player_classlevelstats` SET `basehp`=881 WHERE `class`=1 AND `level`=46; +UPDATE `player_classlevelstats` SET `basehp`=935 WHERE `class`=1 AND `level`=47; +UPDATE `player_classlevelstats` SET `basehp`=981 WHERE `class`=1 AND `level`=48; +UPDATE `player_classlevelstats` SET `basehp`=1029 WHERE `class`=1 AND `level`=49; +UPDATE `player_classlevelstats` SET `basehp`=1079 WHERE `class`=1 AND `level`=50; +UPDATE `player_classlevelstats` SET `basehp`=1131 WHERE `class`=1 AND `level`=51; +UPDATE `player_classlevelstats` SET `basehp`=1185 WHERE `class`=1 AND `level`=52; +UPDATE `player_classlevelstats` SET `basehp`=1241 WHERE `class`=1 AND `level`=53; +UPDATE `player_classlevelstats` SET `basehp`=1299 WHERE `class`=1 AND `level`=54; +UPDATE `player_classlevelstats` SET `basehp`=1359 WHERE `class`=1 AND `level`=55; +UPDATE `player_classlevelstats` SET `basehp`=1421 WHERE `class`=1 AND `level`=56; +UPDATE `player_classlevelstats` SET `basehp`=1485 WHERE `class`=1 AND `level`=57; +UPDATE `player_classlevelstats` SET `basehp`=1551 WHERE `class`=1 AND `level`=58; +UPDATE `player_classlevelstats` SET `basehp`=1619 WHERE `class`=1 AND `level`=59; +UPDATE `player_classlevelstats` SET `basehp`=1689 WHERE `class`=1 AND `level`=60; +UPDATE `player_classlevelstats` SET `basehp`=1902 WHERE `class`=1 AND `level`=61; +UPDATE `player_classlevelstats` SET `basehp`=2129 WHERE `class`=1 AND `level`=62; +UPDATE `player_classlevelstats` SET `basehp`=2357 WHERE `class`=1 AND `level`=63; +UPDATE `player_classlevelstats` SET `basehp`=2612 WHERE `class`=1 AND `level`=64; +UPDATE `player_classlevelstats` SET `basehp`=2883 WHERE `class`=1 AND `level`=65; +UPDATE `player_classlevelstats` SET `basehp`=3169 WHERE `class`=1 AND `level`=66; +UPDATE `player_classlevelstats` SET `basehp`=3455 WHERE `class`=1 AND `level`=67; +UPDATE `player_classlevelstats` SET `basehp`=3774 WHERE `class`=1 AND `level`=68; +UPDATE `player_classlevelstats` SET `basehp`=4109 WHERE `class`=1 AND `level`=69; +UPDATE `player_classlevelstats` SET `basehp`=4444 WHERE `class`=1 AND `level`=70; +UPDATE `player_classlevelstats` SET `basehp`=4720 WHERE `class`=1 AND `level`=71; +UPDATE `player_classlevelstats` SET `basehp`=5013 WHERE `class`=1 AND `level`=72; +UPDATE `player_classlevelstats` SET `basehp`=5325 WHERE `class`=1 AND `level`=73; +UPDATE `player_classlevelstats` SET `basehp`=5656 WHERE `class`=1 AND `level`=74; +UPDATE `player_classlevelstats` SET `basehp`=6008 WHERE `class`=1 AND `level`=75; +UPDATE `player_classlevelstats` SET `basehp`=6381 WHERE `class`=1 AND `level`=76; +UPDATE `player_classlevelstats` SET `basehp`=6778 WHERE `class`=1 AND `level`=77; +UPDATE `player_classlevelstats` SET `basehp`=7198 WHERE `class`=1 AND `level`=78; +UPDATE `player_classlevelstats` SET `basehp`=7646 WHERE `class`=1 AND `level`=79; +UPDATE `player_classlevelstats` SET `basehp`=8121 WHERE `class`=1 AND `level`=80; +UPDATE `player_classlevelstats` SET `basehp`=28 WHERE `class`=2 AND `level`=1; +UPDATE `player_classlevelstats` SET `basehp`=36 WHERE `class`=2 AND `level`=2; +UPDATE `player_classlevelstats` SET `basehp`=44 WHERE `class`=2 AND `level`=3; +UPDATE `player_classlevelstats` SET `basehp`=52 WHERE `class`=2 AND `level`=4; +UPDATE `player_classlevelstats` SET `basehp`=60 WHERE `class`=2 AND `level`=5; +UPDATE `player_classlevelstats` SET `basehp`=68 WHERE `class`=2 AND `level`=6; +UPDATE `player_classlevelstats` SET `basehp`=76 WHERE `class`=2 AND `level`=7; +UPDATE `player_classlevelstats` SET `basehp`=84 WHERE `class`=2 AND `level`=8; +UPDATE `player_classlevelstats` SET `basehp`=92 WHERE `class`=2 AND `level`=9; +UPDATE `player_classlevelstats` SET `basehp`=100 WHERE `class`=2 AND `level`=10; +UPDATE `player_classlevelstats` SET `basehp`=108 WHERE `class`=2 AND `level`=11; +UPDATE `player_classlevelstats` SET `basehp`=116 WHERE `class`=2 AND `level`=12; +UPDATE `player_classlevelstats` SET `basehp`=124 WHERE `class`=2 AND `level`=13; +UPDATE `player_classlevelstats` SET `basehp`=129 WHERE `class`=2 AND `level`=14; +UPDATE `player_classlevelstats` SET `basehp`=135 WHERE `class`=2 AND `level`=15; +UPDATE `player_classlevelstats` SET `basehp`=141 WHERE `class`=2 AND `level`=16; +UPDATE `player_classlevelstats` SET `basehp`=152 WHERE `class`=2 AND `level`=17; +UPDATE `player_classlevelstats` SET `basehp`=164 WHERE `class`=2 AND `level`=18; +UPDATE `player_classlevelstats` SET `basehp`=177 WHERE `class`=2 AND `level`=19; +UPDATE `player_classlevelstats` SET `basehp`=191 WHERE `class`=2 AND `level`=20; +UPDATE `player_classlevelstats` SET `basehp`=206 WHERE `class`=2 AND `level`=21; +UPDATE `player_classlevelstats` SET `basehp`=222 WHERE `class`=2 AND `level`=22; +UPDATE `player_classlevelstats` SET `basehp`=239 WHERE `class`=2 AND `level`=23; +UPDATE `player_classlevelstats` SET `basehp`=247 WHERE `class`=2 AND `level`=24; +UPDATE `player_classlevelstats` SET `basehp`=266 WHERE `class`=2 AND `level`=25; +UPDATE `player_classlevelstats` SET `basehp`=286 WHERE `class`=2 AND `level`=26; +UPDATE `player_classlevelstats` SET `basehp`=307 WHERE `class`=2 AND `level`=27; +UPDATE `player_classlevelstats` SET `basehp`=329 WHERE `class`=2 AND `level`=28; +UPDATE `player_classlevelstats` SET `basehp`=342 WHERE `class`=2 AND `level`=29; +UPDATE `player_classlevelstats` SET `basehp`=366 WHERE `class`=2 AND `level`=30; +UPDATE `player_classlevelstats` SET `basehp`=391 WHERE `class`=2 AND `level`=31; +UPDATE `player_classlevelstats` SET `basehp`=407 WHERE `class`=2 AND `level`=32; +UPDATE `player_classlevelstats` SET `basehp`=434 WHERE `class`=2 AND `level`=33; +UPDATE `player_classlevelstats` SET `basehp`=462 WHERE `class`=2 AND `level`=34; +UPDATE `player_classlevelstats` SET `basehp`=481 WHERE `class`=2 AND `level`=35; +UPDATE `player_classlevelstats` SET `basehp`=511 WHERE `class`=2 AND `level`=36; +UPDATE `player_classlevelstats` SET `basehp`=542 WHERE `class`=2 AND `level`=37; +UPDATE `player_classlevelstats` SET `basehp`=564 WHERE `class`=2 AND `level`=38; +UPDATE `player_classlevelstats` SET `basehp`=597 WHERE `class`=2 AND `level`=39; +UPDATE `player_classlevelstats` SET `basehp`=621 WHERE `class`=2 AND `level`=40; +UPDATE `player_classlevelstats` SET `basehp`=656 WHERE `class`=2 AND `level`=41; +UPDATE `player_classlevelstats` SET `basehp`=682 WHERE `class`=2 AND `level`=42; +UPDATE `player_classlevelstats` SET `basehp`=719 WHERE `class`=2 AND `level`=43; +UPDATE `player_classlevelstats` SET `basehp`=747 WHERE `class`=2 AND `level`=44; +UPDATE `player_classlevelstats` SET `basehp`=786 WHERE `class`=2 AND `level`=45; +UPDATE `player_classlevelstats` SET `basehp`=816 WHERE `class`=2 AND `level`=46; +UPDATE `player_classlevelstats` SET `basehp`=857 WHERE `class`=2 AND `level`=47; +UPDATE `player_classlevelstats` SET `basehp`=889 WHERE `class`=2 AND `level`=48; +UPDATE `player_classlevelstats` SET `basehp`=922 WHERE `class`=2 AND `level`=49; +UPDATE `player_classlevelstats` SET `basehp`=966 WHERE `class`=2 AND `level`=50; +UPDATE `player_classlevelstats` SET `basehp`=1001 WHERE `class`=2 AND `level`=51; +UPDATE `player_classlevelstats` SET `basehp`=1037 WHERE `class`=2 AND `level`=52; +UPDATE `player_classlevelstats` SET `basehp`=1084 WHERE `class`=2 AND `level`=53; +UPDATE `player_classlevelstats` SET `basehp`=1122 WHERE `class`=2 AND `level`=54; +UPDATE `player_classlevelstats` SET `basehp`=1161 WHERE `class`=2 AND `level`=55; +UPDATE `player_classlevelstats` SET `basehp`=1201 WHERE `class`=2 AND `level`=56; +UPDATE `player_classlevelstats` SET `basehp`=1252 WHERE `class`=2 AND `level`=57; +UPDATE `player_classlevelstats` SET `basehp`=1294 WHERE `class`=2 AND `level`=58; +UPDATE `player_classlevelstats` SET `basehp`=1337 WHERE `class`=2 AND `level`=59; +UPDATE `player_classlevelstats` SET `basehp`=1381 WHERE `class`=2 AND `level`=60; +UPDATE `player_classlevelstats` SET `basehp`=1540 WHERE `class`=2 AND `level`=61; +UPDATE `player_classlevelstats` SET `basehp`=1708 WHERE `class`=2 AND `level`=62; +UPDATE `player_classlevelstats` SET `basehp`=1884 WHERE `class`=2 AND `level`=63; +UPDATE `player_classlevelstats` SET `basehp`=2068 WHERE `class`=2 AND `level`=64; +UPDATE `player_classlevelstats` SET `basehp`=2262 WHERE `class`=2 AND `level`=65; +UPDATE `player_classlevelstats` SET `basehp`=2466 WHERE `class`=2 AND `level`=66; +UPDATE `player_classlevelstats` SET `basehp`=2679 WHERE `class`=2 AND `level`=67; +UPDATE `player_classlevelstats` SET `basehp`=2901 WHERE `class`=2 AND `level`=68; +UPDATE `player_classlevelstats` SET `basehp`=3134 WHERE `class`=2 AND `level`=69; +UPDATE `player_classlevelstats` SET `basehp`=3377 WHERE `class`=2 AND `level`=70; +UPDATE `player_classlevelstats` SET `basehp`=3629 WHERE `class`=2 AND `level`=71; +UPDATE `player_classlevelstats` SET `basehp`=3900 WHERE `class`=2 AND `level`=72; +UPDATE `player_classlevelstats` SET `basehp`=4191 WHERE `class`=2 AND `level`=73; +UPDATE `player_classlevelstats` SET `basehp`=4503 WHERE `class`=2 AND `level`=74; +UPDATE `player_classlevelstats` SET `basehp`=4839 WHERE `class`=2 AND `level`=75; +UPDATE `player_classlevelstats` SET `basehp`=5200 WHERE `class`=2 AND `level`=76; +UPDATE `player_classlevelstats` SET `basehp`=5588 WHERE `class`=2 AND `level`=77; +UPDATE `player_classlevelstats` SET `basehp`=6005 WHERE `class`=2 AND `level`=78; +UPDATE `player_classlevelstats` SET `basehp`=6453 WHERE `class`=2 AND `level`=79; +UPDATE `player_classlevelstats` SET `basehp`=6934 WHERE `class`=2 AND `level`=80; +UPDATE `player_classlevelstats` SET `basehp`=46 WHERE `class`=3 AND `level`=1; +UPDATE `player_classlevelstats` SET `basehp`=53 WHERE `class`=3 AND `level`=2; +UPDATE `player_classlevelstats` SET `basehp`=60 WHERE `class`=3 AND `level`=3; +UPDATE `player_classlevelstats` SET `basehp`=67 WHERE `class`=3 AND `level`=4; +UPDATE `player_classlevelstats` SET `basehp`=74 WHERE `class`=3 AND `level`=5; +UPDATE `player_classlevelstats` SET `basehp`=81 WHERE `class`=3 AND `level`=6; +UPDATE `player_classlevelstats` SET `basehp`=88 WHERE `class`=3 AND `level`=7; +UPDATE `player_classlevelstats` SET `basehp`=95 WHERE `class`=3 AND `level`=8; +UPDATE `player_classlevelstats` SET `basehp`=102 WHERE `class`=3 AND `level`=9; +UPDATE `player_classlevelstats` SET `basehp`=109 WHERE `class`=3 AND `level`=10; +UPDATE `player_classlevelstats` SET `basehp`=116 WHERE `class`=3 AND `level`=11; +UPDATE `player_classlevelstats` SET `basehp`=123 WHERE `class`=3 AND `level`=12; +UPDATE `player_classlevelstats` SET `basehp`=130 WHERE `class`=3 AND `level`=13; +UPDATE `player_classlevelstats` SET `basehp`=138 WHERE `class`=3 AND `level`=14; +UPDATE `player_classlevelstats` SET `basehp`=147 WHERE `class`=3 AND `level`=15; +UPDATE `player_classlevelstats` SET `basehp`=157 WHERE `class`=3 AND `level`=16; +UPDATE `player_classlevelstats` SET `basehp`=168 WHERE `class`=3 AND `level`=17; +UPDATE `player_classlevelstats` SET `basehp`=180 WHERE `class`=3 AND `level`=18; +UPDATE `player_classlevelstats` SET `basehp`=193 WHERE `class`=3 AND `level`=19; +UPDATE `player_classlevelstats` SET `basehp`=207 WHERE `class`=3 AND `level`=20; +UPDATE `player_classlevelstats` SET `basehp`=222 WHERE `class`=3 AND `level`=21; +UPDATE `player_classlevelstats` SET `basehp`=238 WHERE `class`=3 AND `level`=22; +UPDATE `player_classlevelstats` SET `basehp`=255 WHERE `class`=3 AND `level`=23; +UPDATE `player_classlevelstats` SET `basehp`=273 WHERE `class`=3 AND `level`=24; +UPDATE `player_classlevelstats` SET `basehp`=292 WHERE `class`=3 AND `level`=25; +UPDATE `player_classlevelstats` SET `basehp`=312 WHERE `class`=3 AND `level`=26; +UPDATE `player_classlevelstats` SET `basehp`=333 WHERE `class`=3 AND `level`=27; +UPDATE `player_classlevelstats` SET `basehp`=355 WHERE `class`=3 AND `level`=28; +UPDATE `player_classlevelstats` SET `basehp`=378 WHERE `class`=3 AND `level`=29; +UPDATE `player_classlevelstats` SET `basehp`=402 WHERE `class`=3 AND `level`=30; +UPDATE `player_classlevelstats` SET `basehp`=417 WHERE `class`=3 AND `level`=31; +UPDATE `player_classlevelstats` SET `basehp`=443 WHERE `class`=3 AND `level`=32; +UPDATE `player_classlevelstats` SET `basehp`=470 WHERE `class`=3 AND `level`=33; +UPDATE `player_classlevelstats` SET `basehp`=498 WHERE `class`=3 AND `level`=34; +UPDATE `player_classlevelstats` SET `basehp`=527 WHERE `class`=3 AND `level`=35; +UPDATE `player_classlevelstats` SET `basehp`=547 WHERE `class`=3 AND `level`=36; +UPDATE `player_classlevelstats` SET `basehp`=578 WHERE `class`=3 AND `level`=37; +UPDATE `player_classlevelstats` SET `basehp`=610 WHERE `class`=3 AND `level`=38; +UPDATE `player_classlevelstats` SET `basehp`=643 WHERE `class`=3 AND `level`=39; +UPDATE `player_classlevelstats` SET `basehp`=667 WHERE `class`=3 AND `level`=40; +UPDATE `player_classlevelstats` SET `basehp`=702 WHERE `class`=3 AND `level`=41; +UPDATE `player_classlevelstats` SET `basehp`=738 WHERE `class`=3 AND `level`=42; +UPDATE `player_classlevelstats` SET `basehp`=775 WHERE `class`=3 AND `level`=43; +UPDATE `player_classlevelstats` SET `basehp`=803 WHERE `class`=3 AND `level`=44; +UPDATE `player_classlevelstats` SET `basehp`=842 WHERE `class`=3 AND `level`=45; +UPDATE `player_classlevelstats` SET `basehp`=872 WHERE `class`=3 AND `level`=46; +UPDATE `player_classlevelstats` SET `basehp`=913 WHERE `class`=3 AND `level`=47; +UPDATE `player_classlevelstats` SET `basehp`=955 WHERE `class`=3 AND `level`=48; +UPDATE `player_classlevelstats` SET `basehp`=994 WHERE `class`=3 AND `level`=49; +UPDATE `player_classlevelstats` SET `basehp`=1047 WHERE `class`=3 AND `level`=50; +UPDATE `player_classlevelstats` SET `basehp`=1067 WHERE `class`=3 AND `level`=51; +UPDATE `player_classlevelstats` SET `basehp`=1113 WHERE `class`=3 AND `level`=52; +UPDATE `player_classlevelstats` SET `basehp`=1150 WHERE `class`=3 AND `level`=53; +UPDATE `player_classlevelstats` SET `basehp`=1198 WHERE `class`=3 AND `level`=54; +UPDATE `player_classlevelstats` SET `basehp`=1237 WHERE `class`=3 AND `level`=55; +UPDATE `player_classlevelstats` SET `basehp`=1287 WHERE `class`=3 AND `level`=56; +UPDATE `player_classlevelstats` SET `basehp`=1328 WHERE `class`=3 AND `level`=57; +UPDATE `player_classlevelstats` SET `basehp`=1370 WHERE `class`=3 AND `level`=58; +UPDATE `player_classlevelstats` SET `basehp`=1423 WHERE `class`=3 AND `level`=59; +UPDATE `player_classlevelstats` SET `basehp`=1467 WHERE `class`=3 AND `level`=60; +UPDATE `player_classlevelstats` SET `basehp`=1633 WHERE `class`=3 AND `level`=61; +UPDATE `player_classlevelstats` SET `basehp`=1819 WHERE `class`=3 AND `level`=62; +UPDATE `player_classlevelstats` SET `basehp`=2003 WHERE `class`=3 AND `level`=63; +UPDATE `player_classlevelstats` SET `basehp`=2195 WHERE `class`=3 AND `level`=64; +UPDATE `player_classlevelstats` SET `basehp`=2397 WHERE `class`=3 AND `level`=65; +UPDATE `player_classlevelstats` SET `basehp`=2623 WHERE `class`=3 AND `level`=66; +UPDATE `player_classlevelstats` SET `basehp`=2844 WHERE `class`=3 AND `level`=67; +UPDATE `player_classlevelstats` SET `basehp`=3075 WHERE `class`=3 AND `level`=68; +UPDATE `player_classlevelstats` SET `basehp`=3316 WHERE `class`=3 AND `level`=69; +UPDATE `player_classlevelstats` SET `basehp`=3568 WHERE `class`=3 AND `level`=70; +UPDATE `player_classlevelstats` SET `basehp`=3834 WHERE `class`=3 AND `level`=71; +UPDATE `player_classlevelstats` SET `basehp`=4120 WHERE `class`=3 AND `level`=72; +UPDATE `player_classlevelstats` SET `basehp`=4427 WHERE `class`=3 AND `level`=73; +UPDATE `player_classlevelstats` SET `basehp`=4757 WHERE `class`=3 AND `level`=74; +UPDATE `player_classlevelstats` SET `basehp`=5112 WHERE `class`=3 AND `level`=75; +UPDATE `player_classlevelstats` SET `basehp`=5493 WHERE `class`=3 AND `level`=76; +UPDATE `player_classlevelstats` SET `basehp`=5903 WHERE `class`=3 AND `level`=77; +UPDATE `player_classlevelstats` SET `basehp`=6343 WHERE `class`=3 AND `level`=78; +UPDATE `player_classlevelstats` SET `basehp`=6816 WHERE `class`=3 AND `level`=79; +UPDATE `player_classlevelstats` SET `basehp`=7324 WHERE `class`=3 AND `level`=80; +UPDATE `player_classlevelstats` SET `basehp`=25 WHERE `class`=4 AND `level`=1; +UPDATE `player_classlevelstats` SET `basehp`=32 WHERE `class`=4 AND `level`=2; +UPDATE `player_classlevelstats` SET `basehp`=49 WHERE `class`=4 AND `level`=3; +UPDATE `player_classlevelstats` SET `basehp`=56 WHERE `class`=4 AND `level`=4; +UPDATE `player_classlevelstats` SET `basehp`=63 WHERE `class`=4 AND `level`=5; +UPDATE `player_classlevelstats` SET `basehp`=70 WHERE `class`=4 AND `level`=6; +UPDATE `player_classlevelstats` SET `basehp`=87 WHERE `class`=4 AND `level`=7; +UPDATE `player_classlevelstats` SET `basehp`=94 WHERE `class`=4 AND `level`=8; +UPDATE `player_classlevelstats` SET `basehp`=101 WHERE `class`=4 AND `level`=9; +UPDATE `player_classlevelstats` SET `basehp`=118 WHERE `class`=4 AND `level`=10; +UPDATE `player_classlevelstats` SET `basehp`=125 WHERE `class`=4 AND `level`=11; +UPDATE `player_classlevelstats` SET `basehp`=142 WHERE `class`=4 AND `level`=12; +UPDATE `player_classlevelstats` SET `basehp`=149 WHERE `class`=4 AND `level`=13; +UPDATE `player_classlevelstats` SET `basehp`=156 WHERE `class`=4 AND `level`=14; +UPDATE `player_classlevelstats` SET `basehp`=173 WHERE `class`=4 AND `level`=15; +UPDATE `player_classlevelstats` SET `basehp`=181 WHERE `class`=4 AND `level`=16; +UPDATE `player_classlevelstats` SET `basehp`=190 WHERE `class`=4 AND `level`=17; +UPDATE `player_classlevelstats` SET `basehp`=200 WHERE `class`=4 AND `level`=18; +UPDATE `player_classlevelstats` SET `basehp`=221 WHERE `class`=4 AND `level`=19; +UPDATE `player_classlevelstats` SET `basehp`=233 WHERE `class`=4 AND `level`=20; +UPDATE `player_classlevelstats` SET `basehp`=246 WHERE `class`=4 AND `level`=21; +UPDATE `player_classlevelstats` SET `basehp`=260 WHERE `class`=4 AND `level`=22; +UPDATE `player_classlevelstats` SET `basehp`=275 WHERE `class`=4 AND `level`=23; +UPDATE `player_classlevelstats` SET `basehp`=301 WHERE `class`=4 AND `level`=24; +UPDATE `player_classlevelstats` SET `basehp`=318 WHERE `class`=4 AND `level`=25; +UPDATE `player_classlevelstats` SET `basehp`=336 WHERE `class`=4 AND `level`=26; +UPDATE `player_classlevelstats` SET `basehp`=355 WHERE `class`=4 AND `level`=27; +UPDATE `player_classlevelstats` SET `basehp`=375 WHERE `class`=4 AND `level`=28; +UPDATE `player_classlevelstats` SET `basehp`=396 WHERE `class`=4 AND `level`=29; +UPDATE `player_classlevelstats` SET `basehp`=428 WHERE `class`=4 AND `level`=30; +UPDATE `player_classlevelstats` SET `basehp`=451 WHERE `class`=4 AND `level`=31; +UPDATE `player_classlevelstats` SET `basehp`=475 WHERE `class`=4 AND `level`=32; +UPDATE `player_classlevelstats` SET `basehp`=500 WHERE `class`=4 AND `level`=33; +UPDATE `player_classlevelstats` SET `basehp`=526 WHERE `class`=4 AND `level`=34; +UPDATE `player_classlevelstats` SET `basehp`=553 WHERE `class`=4 AND `level`=35; +UPDATE `player_classlevelstats` SET `basehp`=581 WHERE `class`=4 AND `level`=36; +UPDATE `player_classlevelstats` SET `basehp`=610 WHERE `class`=4 AND `level`=37; +UPDATE `player_classlevelstats` SET `basehp`=640 WHERE `class`=4 AND `level`=38; +UPDATE `player_classlevelstats` SET `basehp`=671 WHERE `class`=4 AND `level`=39; +UPDATE `player_classlevelstats` SET `basehp`=703 WHERE `class`=4 AND `level`=40; +UPDATE `player_classlevelstats` SET `basehp`=736 WHERE `class`=4 AND `level`=41; +UPDATE `player_classlevelstats` SET `basehp`=770 WHERE `class`=4 AND `level`=42; +UPDATE `player_classlevelstats` SET `basehp`=805 WHERE `class`=4 AND `level`=43; +UPDATE `player_classlevelstats` SET `basehp`=841 WHERE `class`=4 AND `level`=44; +UPDATE `player_classlevelstats` SET `basehp`=878 WHERE `class`=4 AND `level`=45; +UPDATE `player_classlevelstats` SET `basehp`=916 WHERE `class`=4 AND `level`=46; +UPDATE `player_classlevelstats` SET `basehp`=955 WHERE `class`=4 AND `level`=47; +UPDATE `player_classlevelstats` SET `basehp`=995 WHERE `class`=4 AND `level`=48; +UPDATE `player_classlevelstats` SET `basehp`=1026 WHERE `class`=4 AND `level`=49; +UPDATE `player_classlevelstats` SET `basehp`=1068 WHERE `class`=4 AND `level`=50; +UPDATE `player_classlevelstats` SET `basehp`=1111 WHERE `class`=4 AND `level`=51; +UPDATE `player_classlevelstats` SET `basehp`=1155 WHERE `class`=4 AND `level`=52; +UPDATE `player_classlevelstats` SET `basehp`=1200 WHERE `class`=4 AND `level`=53; +UPDATE `player_classlevelstats` SET `basehp`=1246 WHERE `class`=4 AND `level`=54; +UPDATE `player_classlevelstats` SET `basehp`=1283 WHERE `class`=4 AND `level`=55; +UPDATE `player_classlevelstats` SET `basehp`=1331 WHERE `class`=4 AND `level`=56; +UPDATE `player_classlevelstats` SET `basehp`=1380 WHERE `class`=4 AND `level`=57; +UPDATE `player_classlevelstats` SET `basehp`=1430 WHERE `class`=4 AND `level`=58; +UPDATE `player_classlevelstats` SET `basehp`=1471 WHERE `class`=4 AND `level`=59; +UPDATE `player_classlevelstats` SET `basehp`=1523 WHERE `class`=4 AND `level`=60; +UPDATE `player_classlevelstats` SET `basehp`=1702 WHERE `class`=4 AND `level`=61; +UPDATE `player_classlevelstats` SET `basehp`=1879 WHERE `class`=4 AND `level`=62; +UPDATE `player_classlevelstats` SET `basehp`=2077 WHERE `class`=4 AND `level`=63; +UPDATE `player_classlevelstats` SET `basehp`=2285 WHERE `class`=4 AND `level`=64; +UPDATE `player_classlevelstats` SET `basehp`=2489 WHERE `class`=4 AND `level`=65; +UPDATE `player_classlevelstats` SET `basehp`=2717 WHERE `class`=4 AND `level`=66; +UPDATE `player_classlevelstats` SET `basehp`=2941 WHERE `class`=4 AND `level`=67; +UPDATE `player_classlevelstats` SET `basehp`=3190 WHERE `class`=4 AND `level`=68; +UPDATE `player_classlevelstats` SET `basehp`=3450 WHERE `class`=4 AND `level`=69; +UPDATE `player_classlevelstats` SET `basehp`=3704 WHERE `class`=4 AND `level`=70; +UPDATE `player_classlevelstats` SET `basehp`=3980 WHERE `class`=4 AND `level`=71; +UPDATE `player_classlevelstats` SET `basehp`=4277 WHERE `class`=4 AND `level`=72; +UPDATE `player_classlevelstats` SET `basehp`=4596 WHERE `class`=4 AND `level`=73; +UPDATE `player_classlevelstats` SET `basehp`=4939 WHERE `class`=4 AND `level`=74; +UPDATE `player_classlevelstats` SET `basehp`=5307 WHERE `class`=4 AND `level`=75; +UPDATE `player_classlevelstats` SET `basehp`=5703 WHERE `class`=4 AND `level`=76; +UPDATE `player_classlevelstats` SET `basehp`=6128 WHERE `class`=4 AND `level`=77; +UPDATE `player_classlevelstats` SET `basehp`=6585 WHERE `class`=4 AND `level`=78; +UPDATE `player_classlevelstats` SET `basehp`=7076 WHERE `class`=4 AND `level`=79; +UPDATE `player_classlevelstats` SET `basehp`=7604 WHERE `class`=4 AND `level`=80; +UPDATE `player_classlevelstats` SET `basehp`=52 WHERE `class`=5 AND `level`=1; +UPDATE `player_classlevelstats` SET `basehp`=57 WHERE `class`=5 AND `level`=2; +UPDATE `player_classlevelstats` SET `basehp`=72 WHERE `class`=5 AND `level`=3; +UPDATE `player_classlevelstats` SET `basehp`=77 WHERE `class`=5 AND `level`=4; +UPDATE `player_classlevelstats` SET `basehp`=92 WHERE `class`=5 AND `level`=5; +UPDATE `player_classlevelstats` SET `basehp`=97 WHERE `class`=5 AND `level`=6; +UPDATE `player_classlevelstats` SET `basehp`=112 WHERE `class`=5 AND `level`=7; +UPDATE `player_classlevelstats` SET `basehp`=117 WHERE `class`=5 AND `level`=8; +UPDATE `player_classlevelstats` SET `basehp`=132 WHERE `class`=5 AND `level`=9; +UPDATE `player_classlevelstats` SET `basehp`=137 WHERE `class`=5 AND `level`=10; +UPDATE `player_classlevelstats` SET `basehp`=142 WHERE `class`=5 AND `level`=11; +UPDATE `player_classlevelstats` SET `basehp`=157 WHERE `class`=5 AND `level`=12; +UPDATE `player_classlevelstats` SET `basehp`=172 WHERE `class`=5 AND `level`=13; +UPDATE `player_classlevelstats` SET `basehp`=177 WHERE `class`=5 AND `level`=14; +UPDATE `player_classlevelstats` SET `basehp`=192 WHERE `class`=5 AND `level`=15; +UPDATE `player_classlevelstats` SET `basehp`=197 WHERE `class`=5 AND `level`=16; +UPDATE `player_classlevelstats` SET `basehp`=212 WHERE `class`=5 AND `level`=17; +UPDATE `player_classlevelstats` SET `basehp`=227 WHERE `class`=5 AND `level`=18; +UPDATE `player_classlevelstats` SET `basehp`=232 WHERE `class`=5 AND `level`=19; +UPDATE `player_classlevelstats` SET `basehp`=247 WHERE `class`=5 AND `level`=20; +UPDATE `player_classlevelstats` SET `basehp`=252 WHERE `class`=5 AND `level`=21; +UPDATE `player_classlevelstats` SET `basehp`=268 WHERE `class`=5 AND `level`=22; +UPDATE `player_classlevelstats` SET `basehp`=275 WHERE `class`=5 AND `level`=23; +UPDATE `player_classlevelstats` SET `basehp`=293 WHERE `class`=5 AND `level`=24; +UPDATE `player_classlevelstats` SET `basehp`=302 WHERE `class`=5 AND `level`=25; +UPDATE `player_classlevelstats` SET `basehp`=322 WHERE `class`=5 AND `level`=26; +UPDATE `player_classlevelstats` SET `basehp`=343 WHERE `class`=5 AND `level`=27; +UPDATE `player_classlevelstats` SET `basehp`=355 WHERE `class`=5 AND `level`=28; +UPDATE `player_classlevelstats` SET `basehp`=378 WHERE `class`=5 AND `level`=29; +UPDATE `player_classlevelstats` SET `basehp`=392 WHERE `class`=5 AND `level`=30; +UPDATE `player_classlevelstats` SET `basehp`=417 WHERE `class`=5 AND `level`=31; +UPDATE `player_classlevelstats` SET `basehp`=433 WHERE `class`=5 AND `level`=32; +UPDATE `player_classlevelstats` SET `basehp`=460 WHERE `class`=5 AND `level`=33; +UPDATE `player_classlevelstats` SET `basehp`=478 WHERE `class`=5 AND `level`=34; +UPDATE `player_classlevelstats` SET `basehp`=507 WHERE `class`=5 AND `level`=35; +UPDATE `player_classlevelstats` SET `basehp`=527 WHERE `class`=5 AND `level`=36; +UPDATE `player_classlevelstats` SET `basehp`=548 WHERE `class`=5 AND `level`=37; +UPDATE `player_classlevelstats` SET `basehp`=580 WHERE `class`=5 AND `level`=38; +UPDATE `player_classlevelstats` SET `basehp`=603 WHERE `class`=5 AND `level`=39; +UPDATE `player_classlevelstats` SET `basehp`=637 WHERE `class`=5 AND `level`=40; +UPDATE `player_classlevelstats` SET `basehp`=662 WHERE `class`=5 AND `level`=41; +UPDATE `player_classlevelstats` SET `basehp`=698 WHERE `class`=5 AND `level`=42; +UPDATE `player_classlevelstats` SET `basehp`=725 WHERE `class`=5 AND `level`=43; +UPDATE `player_classlevelstats` SET `basehp`=763 WHERE `class`=5 AND `level`=44; +UPDATE `player_classlevelstats` SET `basehp`=792 WHERE `class`=5 AND `level`=45; +UPDATE `player_classlevelstats` SET `basehp`=822 WHERE `class`=5 AND `level`=46; +UPDATE `player_classlevelstats` SET `basehp`=863 WHERE `class`=5 AND `level`=47; +UPDATE `player_classlevelstats` SET `basehp`=895 WHERE `class`=5 AND `level`=48; +UPDATE `player_classlevelstats` SET `basehp`=928 WHERE `class`=5 AND `level`=49; +UPDATE `player_classlevelstats` SET `basehp`=972 WHERE `class`=5 AND `level`=50; +UPDATE `player_classlevelstats` SET `basehp`=1007 WHERE `class`=5 AND `level`=51; +UPDATE `player_classlevelstats` SET `basehp`=1053 WHERE `class`=5 AND `level`=52; +UPDATE `player_classlevelstats` SET `basehp`=1090 WHERE `class`=5 AND `level`=53; +UPDATE `player_classlevelstats` SET `basehp`=1128 WHERE `class`=5 AND `level`=54; +UPDATE `player_classlevelstats` SET `basehp`=1177 WHERE `class`=5 AND `level`=55; +UPDATE `player_classlevelstats` SET `basehp`=1217 WHERE `class`=5 AND `level`=56; +UPDATE `player_classlevelstats` SET `basehp`=1258 WHERE `class`=5 AND `level`=57; +UPDATE `player_classlevelstats` SET `basehp`=1300 WHERE `class`=5 AND `level`=58; +UPDATE `player_classlevelstats` SET `basehp`=1353 WHERE `class`=5 AND `level`=59; +UPDATE `player_classlevelstats` SET `basehp`=1397 WHERE `class`=5 AND `level`=60; +UPDATE `player_classlevelstats` SET `basehp`=1557 WHERE `class`=5 AND `level`=61; +UPDATE `player_classlevelstats` SET `basehp`=1738 WHERE `class`=5 AND `level`=62; +UPDATE `player_classlevelstats` SET `basehp`=1916 WHERE `class`=5 AND `level`=63; +UPDATE `player_classlevelstats` SET `basehp`=2101 WHERE `class`=5 AND `level`=64; +UPDATE `player_classlevelstats` SET `basehp`=2295 WHERE `class`=5 AND `level`=65; +UPDATE `player_classlevelstats` SET `basehp`=2495 WHERE `class`=5 AND `level`=66; +UPDATE `player_classlevelstats` SET `basehp`=2719 WHERE `class`=5 AND `level`=67; +UPDATE `player_classlevelstats` SET `basehp`=2936 WHERE `class`=5 AND `level`=68; +UPDATE `player_classlevelstats` SET `basehp`=3160 WHERE `class`=5 AND `level`=69; +UPDATE `player_classlevelstats` SET `basehp`=3391 WHERE `class`=5 AND `level`=70; +UPDATE `player_classlevelstats` SET `basehp`=3644 WHERE `class`=5 AND `level`=71; +UPDATE `player_classlevelstats` SET `basehp`=3916 WHERE `class`=5 AND `level`=72; +UPDATE `player_classlevelstats` SET `basehp`=4208 WHERE `class`=5 AND `level`=73; +UPDATE `player_classlevelstats` SET `basehp`=4522 WHERE `class`=5 AND `level`=74; +UPDATE `player_classlevelstats` SET `basehp`=4859 WHERE `class`=5 AND `level`=75; +UPDATE `player_classlevelstats` SET `basehp`=5221 WHERE `class`=5 AND `level`=76; +UPDATE `player_classlevelstats` SET `basehp`=5610 WHERE `class`=5 AND `level`=77; +UPDATE `player_classlevelstats` SET `basehp`=6028 WHERE `class`=5 AND `level`=78; +UPDATE `player_classlevelstats` SET `basehp`=6477 WHERE `class`=5 AND `level`=79; +UPDATE `player_classlevelstats` SET `basehp`=6960 WHERE `class`=5 AND `level`=80; +UPDATE `player_classlevelstats` SET `basehp`=22 WHERE `class`=6 AND `level`=1; +UPDATE `player_classlevelstats` SET `basehp`=27 WHERE `class`=6 AND `level`=2; +UPDATE `player_classlevelstats` SET `basehp`=32 WHERE `class`=6 AND `level`=3; +UPDATE `player_classlevelstats` SET `basehp`=37 WHERE `class`=6 AND `level`=4; +UPDATE `player_classlevelstats` SET `basehp`=42 WHERE `class`=6 AND `level`=5; +UPDATE `player_classlevelstats` SET `basehp`=47 WHERE `class`=6 AND `level`=6; +UPDATE `player_classlevelstats` SET `basehp`=52 WHERE `class`=6 AND `level`=7; +UPDATE `player_classlevelstats` SET `basehp`=58 WHERE `class`=6 AND `level`=8; +UPDATE `player_classlevelstats` SET `basehp`=64 WHERE `class`=6 AND `level`=9; +UPDATE `player_classlevelstats` SET `basehp`=70 WHERE `class`=6 AND `level`=10; +UPDATE `player_classlevelstats` SET `basehp`=77 WHERE `class`=6 AND `level`=11; +UPDATE `player_classlevelstats` SET `basehp`=84 WHERE `class`=6 AND `level`=12; +UPDATE `player_classlevelstats` SET `basehp`=92 WHERE `class`=6 AND `level`=13; +UPDATE `player_classlevelstats` SET `basehp`=100 WHERE `class`=6 AND `level`=14; +UPDATE `player_classlevelstats` SET `basehp`=117 WHERE `class`=6 AND `level`=15; +UPDATE `player_classlevelstats` SET `basehp`=127 WHERE `class`=6 AND `level`=16; +UPDATE `player_classlevelstats` SET `basehp`=138 WHERE `class`=6 AND `level`=17; +UPDATE `player_classlevelstats` SET `basehp`=150 WHERE `class`=6 AND `level`=18; +UPDATE `player_classlevelstats` SET `basehp`=163 WHERE `class`=6 AND `level`=19; +UPDATE `player_classlevelstats` SET `basehp`=177 WHERE `class`=6 AND `level`=20; +UPDATE `player_classlevelstats` SET `basehp`=192 WHERE `class`=6 AND `level`=21; +UPDATE `player_classlevelstats` SET `basehp`=208 WHERE `class`=6 AND `level`=22; +UPDATE `player_classlevelstats` SET `basehp`=225 WHERE `class`=6 AND `level`=23; +UPDATE `player_classlevelstats` SET `basehp`=239 WHERE `class`=6 AND `level`=24; +UPDATE `player_classlevelstats` SET `basehp`=258 WHERE `class`=6 AND `level`=25; +UPDATE `player_classlevelstats` SET `basehp`=278 WHERE `class`=6 AND `level`=26; +UPDATE `player_classlevelstats` SET `basehp`=299 WHERE `class`=6 AND `level`=27; +UPDATE `player_classlevelstats` SET `basehp`=321 WHERE `class`=6 AND `level`=28; +UPDATE `player_classlevelstats` SET `basehp`=344 WHERE `class`=6 AND `level`=29; +UPDATE `player_classlevelstats` SET `basehp`=368 WHERE `class`=6 AND `level`=30; +UPDATE `player_classlevelstats` SET `basehp`=393 WHERE `class`=6 AND `level`=31; +UPDATE `player_classlevelstats` SET `basehp`=419 WHERE `class`=6 AND `level`=32; +UPDATE `player_classlevelstats` SET `basehp`=446 WHERE `class`=6 AND `level`=33; +UPDATE `player_classlevelstats` SET `basehp`=474 WHERE `class`=6 AND `level`=34; +UPDATE `player_classlevelstats` SET `basehp`=503 WHERE `class`=6 AND `level`=35; +UPDATE `player_classlevelstats` SET `basehp`=533 WHERE `class`=6 AND `level`=36; +UPDATE `player_classlevelstats` SET `basehp`=564 WHERE `class`=6 AND `level`=37; +UPDATE `player_classlevelstats` SET `basehp`=596 WHERE `class`=6 AND `level`=38; +UPDATE `player_classlevelstats` SET `basehp`=629 WHERE `class`=6 AND `level`=39; +UPDATE `player_classlevelstats` SET `basehp`=698 WHERE `class`=6 AND `level`=40; +UPDATE `player_classlevelstats` SET `basehp`=698 WHERE `class`=6 AND `level`=41; +UPDATE `player_classlevelstats` SET `basehp`=734 WHERE `class`=6 AND `level`=42; +UPDATE `player_classlevelstats` SET `basehp`=771 WHERE `class`=6 AND `level`=43; +UPDATE `player_classlevelstats` SET `basehp`=809 WHERE `class`=6 AND `level`=44; +UPDATE `player_classlevelstats` SET `basehp`=849 WHERE `class`=6 AND `level`=45; +UPDATE `player_classlevelstats` SET `basehp`=891 WHERE `class`=6 AND `level`=46; +UPDATE `player_classlevelstats` SET `basehp`=935 WHERE `class`=6 AND `level`=47; +UPDATE `player_classlevelstats` SET `basehp`=981 WHERE `class`=6 AND `level`=48; +UPDATE `player_classlevelstats` SET `basehp`=1029 WHERE `class`=6 AND `level`=49; +UPDATE `player_classlevelstats` SET `basehp`=1079 WHERE `class`=6 AND `level`=50; +UPDATE `player_classlevelstats` SET `basehp`=1131 WHERE `class`=6 AND `level`=51; +UPDATE `player_classlevelstats` SET `basehp`=1185 WHERE `class`=6 AND `level`=52; +UPDATE `player_classlevelstats` SET `basehp`=1241 WHERE `class`=6 AND `level`=53; +UPDATE `player_classlevelstats` SET `basehp`=1299 WHERE `class`=6 AND `level`=54; +UPDATE `player_classlevelstats` SET `basehp`=1359 WHERE `class`=6 AND `level`=55; +UPDATE `player_classlevelstats` SET `basehp`=1421 WHERE `class`=6 AND `level`=56; +UPDATE `player_classlevelstats` SET `basehp`=1485 WHERE `class`=6 AND `level`=57; +UPDATE `player_classlevelstats` SET `basehp`=1551 WHERE `class`=6 AND `level`=58; +UPDATE `player_classlevelstats` SET `basehp`=1619 WHERE `class`=6 AND `level`=59; +UPDATE `player_classlevelstats` SET `basehp`=1689 WHERE `class`=6 AND `level`=60; +UPDATE `player_classlevelstats` SET `basehp`=1902 WHERE `class`=6 AND `level`=61; +UPDATE `player_classlevelstats` SET `basehp`=2129 WHERE `class`=6 AND `level`=62; +UPDATE `player_classlevelstats` SET `basehp`=2357 WHERE `class`=6 AND `level`=63; +UPDATE `player_classlevelstats` SET `basehp`=2612 WHERE `class`=6 AND `level`=64; +UPDATE `player_classlevelstats` SET `basehp`=2883 WHERE `class`=6 AND `level`=65; +UPDATE `player_classlevelstats` SET `basehp`=3169 WHERE `class`=6 AND `level`=66; +UPDATE `player_classlevelstats` SET `basehp`=3455 WHERE `class`=6 AND `level`=67; +UPDATE `player_classlevelstats` SET `basehp`=3774 WHERE `class`=6 AND `level`=68; +UPDATE `player_classlevelstats` SET `basehp`=4109 WHERE `class`=6 AND `level`=69; +UPDATE `player_classlevelstats` SET `basehp`=4444 WHERE `class`=6 AND `level`=70; +UPDATE `player_classlevelstats` SET `basehp`=4720 WHERE `class`=6 AND `level`=71; +UPDATE `player_classlevelstats` SET `basehp`=5013 WHERE `class`=6 AND `level`=72; +UPDATE `player_classlevelstats` SET `basehp`=5325 WHERE `class`=6 AND `level`=73; +UPDATE `player_classlevelstats` SET `basehp`=5656 WHERE `class`=6 AND `level`=74; +UPDATE `player_classlevelstats` SET `basehp`=6008 WHERE `class`=6 AND `level`=75; +UPDATE `player_classlevelstats` SET `basehp`=6381 WHERE `class`=6 AND `level`=76; +UPDATE `player_classlevelstats` SET `basehp`=6778 WHERE `class`=6 AND `level`=77; +UPDATE `player_classlevelstats` SET `basehp`=7199 WHERE `class`=6 AND `level`=78; +UPDATE `player_classlevelstats` SET `basehp`=7646 WHERE `class`=6 AND `level`=79; +UPDATE `player_classlevelstats` SET `basehp`=8121 WHERE `class`=6 AND `level`=80; +UPDATE `player_classlevelstats` SET `basehp`=40 WHERE `class`=7 AND `level`=1; +UPDATE `player_classlevelstats` SET `basehp`=47 WHERE `class`=7 AND `level`=2; +UPDATE `player_classlevelstats` SET `basehp`=55 WHERE `class`=7 AND `level`=3; +UPDATE `player_classlevelstats` SET `basehp`=62 WHERE `class`=7 AND `level`=4; +UPDATE `player_classlevelstats` SET `basehp`=70 WHERE `class`=7 AND `level`=5; +UPDATE `player_classlevelstats` SET `basehp`=77 WHERE `class`=7 AND `level`=6; +UPDATE `player_classlevelstats` SET `basehp`=85 WHERE `class`=7 AND `level`=7; +UPDATE `player_classlevelstats` SET `basehp`=92 WHERE `class`=7 AND `level`=8; +UPDATE `player_classlevelstats` SET `basehp`=100 WHERE `class`=7 AND `level`=9; +UPDATE `player_classlevelstats` SET `basehp`=107 WHERE `class`=7 AND `level`=10; +UPDATE `player_classlevelstats` SET `basehp`=114 WHERE `class`=7 AND `level`=11; +UPDATE `player_classlevelstats` SET `basehp`=122 WHERE `class`=7 AND `level`=12; +UPDATE `player_classlevelstats` SET `basehp`=129 WHERE `class`=7 AND `level`=13; +UPDATE `player_classlevelstats` SET `basehp`=137 WHERE `class`=7 AND `level`=14; +UPDATE `player_classlevelstats` SET `basehp`=144 WHERE `class`=7 AND `level`=15; +UPDATE `player_classlevelstats` SET `basehp`=152 WHERE `class`=7 AND `level`=16; +UPDATE `player_classlevelstats` SET `basehp`=161 WHERE `class`=7 AND `level`=17; +UPDATE `player_classlevelstats` SET `basehp`=170 WHERE `class`=7 AND `level`=18; +UPDATE `player_classlevelstats` SET `basehp`=181 WHERE `class`=7 AND `level`=19; +UPDATE `player_classlevelstats` SET `basehp`=193 WHERE `class`=7 AND `level`=20; +UPDATE `player_classlevelstats` SET `basehp`=205 WHERE `class`=7 AND `level`=21; +UPDATE `player_classlevelstats` SET `basehp`=219 WHERE `class`=7 AND `level`=22; +UPDATE `player_classlevelstats` SET `basehp`=234 WHERE `class`=7 AND `level`=23; +UPDATE `player_classlevelstats` SET `basehp`=250 WHERE `class`=7 AND `level`=24; +UPDATE `player_classlevelstats` SET `basehp`=257 WHERE `class`=7 AND `level`=25; +UPDATE `player_classlevelstats` SET `basehp`=275 WHERE `class`=7 AND `level`=26; +UPDATE `player_classlevelstats` SET `basehp`=294 WHERE `class`=7 AND `level`=27; +UPDATE `player_classlevelstats` SET `basehp`=315 WHERE `class`=7 AND `level`=28; +UPDATE `player_classlevelstats` SET `basehp`=336 WHERE `class`=7 AND `level`=29; +UPDATE `player_classlevelstats` SET `basehp`=358 WHERE `class`=7 AND `level`=30; +UPDATE `player_classlevelstats` SET `basehp`=371 WHERE `class`=7 AND `level`=31; +UPDATE `player_classlevelstats` SET `basehp`=396 WHERE `class`=7 AND `level`=32; +UPDATE `player_classlevelstats` SET `basehp`=422 WHERE `class`=7 AND `level`=33; +UPDATE `player_classlevelstats` SET `basehp`=448 WHERE `class`=7 AND `level`=34; +UPDATE `player_classlevelstats` SET `basehp`=465 WHERE `class`=7 AND `level`=35; +UPDATE `player_classlevelstats` SET `basehp`=494 WHERE `class`=7 AND `level`=36; +UPDATE `player_classlevelstats` SET `basehp`=524 WHERE `class`=7 AND `level`=37; +UPDATE `player_classlevelstats` SET `basehp`=545 WHERE `class`=7 AND `level`=38; +UPDATE `player_classlevelstats` SET `basehp`=577 WHERE `class`=7 AND `level`=39; +UPDATE `player_classlevelstats` SET `basehp`=610 WHERE `class`=7 AND `level`=40; +UPDATE `player_classlevelstats` SET `basehp`=633 WHERE `class`=7 AND `level`=41; +UPDATE `player_classlevelstats` SET `basehp`=669 WHERE `class`=7 AND `level`=42; +UPDATE `player_classlevelstats` SET `basehp`=694 WHERE `class`=7 AND `level`=43; +UPDATE `player_classlevelstats` SET `basehp`=732 WHERE `class`=7 AND `level`=44; +UPDATE `player_classlevelstats` SET `basehp`=760 WHERE `class`=7 AND `level`=45; +UPDATE `player_classlevelstats` SET `basehp`=799 WHERE `class`=7 AND `level`=46; +UPDATE `player_classlevelstats` SET `basehp`=829 WHERE `class`=7 AND `level`=47; +UPDATE `player_classlevelstats` SET `basehp`=871 WHERE `class`=7 AND `level`=48; +UPDATE `player_classlevelstats` SET `basehp`=903 WHERE `class`=7 AND `level`=49; +UPDATE `player_classlevelstats` SET `basehp`=947 WHERE `class`=7 AND `level`=50; +UPDATE `player_classlevelstats` SET `basehp`=981 WHERE `class`=7 AND `level`=51; +UPDATE `player_classlevelstats` SET `basehp`=1027 WHERE `class`=7 AND `level`=52; +UPDATE `player_classlevelstats` SET `basehp`=1064 WHERE `class`=7 AND `level`=53; +UPDATE `player_classlevelstats` SET `basehp`=1101 WHERE `class`=7 AND `level`=54; +UPDATE `player_classlevelstats` SET `basehp`=1150 WHERE `class`=7 AND `level`=55; +UPDATE `player_classlevelstats` SET `basehp`=1190 WHERE `class`=7 AND `level`=56; +UPDATE `player_classlevelstats` SET `basehp`=1231 WHERE `class`=7 AND `level`=57; +UPDATE `player_classlevelstats` SET `basehp`=1283 WHERE `class`=7 AND `level`=58; +UPDATE `player_classlevelstats` SET `basehp`=1326 WHERE `class`=7 AND `level`=59; +UPDATE `player_classlevelstats` SET `basehp`=1423 WHERE `class`=7 AND `level`=60; +UPDATE `player_classlevelstats` SET `basehp`=1528 WHERE `class`=7 AND `level`=61; +UPDATE `player_classlevelstats` SET `basehp`=1694 WHERE `class`=7 AND `level`=62; +UPDATE `player_classlevelstats` SET `basehp`=1883 WHERE `class`=7 AND `level`=63; +UPDATE `player_classlevelstats` SET `basehp`=2067 WHERE `class`=7 AND `level`=64; +UPDATE `player_classlevelstats` SET `basehp`=2262 WHERE `class`=7 AND `level`=65; +UPDATE `player_classlevelstats` SET `basehp`=2465 WHERE `class`=7 AND `level`=66; +UPDATE `player_classlevelstats` SET `basehp`=2679 WHERE `class`=7 AND `level`=67; +UPDATE `player_classlevelstats` SET `basehp`=2903 WHERE `class`=7 AND `level`=68; +UPDATE `player_classlevelstats` SET `basehp`=3136 WHERE `class`=7 AND `level`=69; +UPDATE `player_classlevelstats` SET `basehp`=3380 WHERE `class`=7 AND `level`=70; +UPDATE `player_classlevelstats` SET `basehp`=3633 WHERE `class`=7 AND `level`=71; +UPDATE `player_classlevelstats` SET `basehp`=3903 WHERE `class`=7 AND `level`=72; +UPDATE `player_classlevelstats` SET `basehp`=4194 WHERE `class`=7 AND `level`=73; +UPDATE `player_classlevelstats` SET `basehp`=4507 WHERE `class`=7 AND `level`=74; +UPDATE `player_classlevelstats` SET `basehp`=4843 WHERE `class`=7 AND `level`=75; +UPDATE `player_classlevelstats` SET `basehp`=5203 WHERE `class`=7 AND `level`=76; +UPDATE `player_classlevelstats` SET `basehp`=5592 WHERE `class`=7 AND `level`=77; +UPDATE `player_classlevelstats` SET `basehp`=6009 WHERE `class`=7 AND `level`=78; +UPDATE `player_classlevelstats` SET `basehp`=6457 WHERE `class`=7 AND `level`=79; +UPDATE `player_classlevelstats` SET `basehp`=6939 WHERE `class`=7 AND `level`=80; +UPDATE `player_classlevelstats` SET `basehp`=32 WHERE `class`=8 AND `level`=1; +UPDATE `player_classlevelstats` SET `basehp`=47 WHERE `class`=8 AND `level`=2; +UPDATE `player_classlevelstats` SET `basehp`=52 WHERE `class`=8 AND `level`=3; +UPDATE `player_classlevelstats` SET `basehp`=67 WHERE `class`=8 AND `level`=4; +UPDATE `player_classlevelstats` SET `basehp`=82 WHERE `class`=8 AND `level`=5; +UPDATE `player_classlevelstats` SET `basehp`=97 WHERE `class`=8 AND `level`=6; +UPDATE `player_classlevelstats` SET `basehp`=102 WHERE `class`=8 AND `level`=7; +UPDATE `player_classlevelstats` SET `basehp`=117 WHERE `class`=8 AND `level`=8; +UPDATE `player_classlevelstats` SET `basehp`=132 WHERE `class`=8 AND `level`=9; +UPDATE `player_classlevelstats` SET `basehp`=137 WHERE `class`=8 AND `level`=10; +UPDATE `player_classlevelstats` SET `basehp`=152 WHERE `class`=8 AND `level`=11; +UPDATE `player_classlevelstats` SET `basehp`=167 WHERE `class`=8 AND `level`=12; +UPDATE `player_classlevelstats` SET `basehp`=172 WHERE `class`=8 AND `level`=13; +UPDATE `player_classlevelstats` SET `basehp`=187 WHERE `class`=8 AND `level`=14; +UPDATE `player_classlevelstats` SET `basehp`=202 WHERE `class`=8 AND `level`=15; +UPDATE `player_classlevelstats` SET `basehp`=207 WHERE `class`=8 AND `level`=16; +UPDATE `player_classlevelstats` SET `basehp`=222 WHERE `class`=8 AND `level`=17; +UPDATE `player_classlevelstats` SET `basehp`=237 WHERE `class`=8 AND `level`=18; +UPDATE `player_classlevelstats` SET `basehp`=242 WHERE `class`=8 AND `level`=19; +UPDATE `player_classlevelstats` SET `basehp`=257 WHERE `class`=8 AND `level`=20; +UPDATE `player_classlevelstats` SET `basehp`=272 WHERE `class`=8 AND `level`=21; +UPDATE `player_classlevelstats` SET `basehp`=277 WHERE `class`=8 AND `level`=22; +UPDATE `player_classlevelstats` SET `basehp`=292 WHERE `class`=8 AND `level`=23; +UPDATE `player_classlevelstats` SET `basehp`=298 WHERE `class`=8 AND `level`=24; +UPDATE `player_classlevelstats` SET `basehp`=315 WHERE `class`=8 AND `level`=25; +UPDATE `player_classlevelstats` SET `basehp`=333 WHERE `class`=8 AND `level`=26; +UPDATE `player_classlevelstats` SET `basehp`=342 WHERE `class`=8 AND `level`=27; +UPDATE `player_classlevelstats` SET `basehp`=362 WHERE `class`=8 AND `level`=28; +UPDATE `player_classlevelstats` SET `basehp`=373 WHERE `class`=8 AND `level`=29; +UPDATE `player_classlevelstats` SET `basehp`=395 WHERE `class`=8 AND `level`=30; +UPDATE `player_classlevelstats` SET `basehp`=418 WHERE `class`=8 AND `level`=31; +UPDATE `player_classlevelstats` SET `basehp`=432 WHERE `class`=8 AND `level`=32; +UPDATE `player_classlevelstats` SET `basehp`=457 WHERE `class`=8 AND `level`=33; +UPDATE `player_classlevelstats` SET `basehp`=473 WHERE `class`=8 AND `level`=34; +UPDATE `player_classlevelstats` SET `basehp`=500 WHERE `class`=8 AND `level`=35; +UPDATE `player_classlevelstats` SET `basehp`=518 WHERE `class`=8 AND `level`=36; +UPDATE `player_classlevelstats` SET `basehp`=547 WHERE `class`=8 AND `level`=37; +UPDATE `player_classlevelstats` SET `basehp`=577 WHERE `class`=8 AND `level`=38; +UPDATE `player_classlevelstats` SET `basehp`=598 WHERE `class`=8 AND `level`=39; +UPDATE `player_classlevelstats` SET `basehp`=630 WHERE `class`=8 AND `level`=40; +UPDATE `player_classlevelstats` SET `basehp`=653 WHERE `class`=8 AND `level`=41; +UPDATE `player_classlevelstats` SET `basehp`=687 WHERE `class`=8 AND `level`=42; +UPDATE `player_classlevelstats` SET `basehp`=712 WHERE `class`=8 AND `level`=43; +UPDATE `player_classlevelstats` SET `basehp`=748 WHERE `class`=8 AND `level`=44; +UPDATE `player_classlevelstats` SET `basehp`=775 WHERE `class`=8 AND `level`=45; +UPDATE `player_classlevelstats` SET `basehp`=813 WHERE `class`=8 AND `level`=46; +UPDATE `player_classlevelstats` SET `basehp`=842 WHERE `class`=8 AND `level`=47; +UPDATE `player_classlevelstats` SET `basehp`=882 WHERE `class`=8 AND `level`=48; +UPDATE `player_classlevelstats` SET `basehp`=913 WHERE `class`=8 AND `level`=49; +UPDATE `player_classlevelstats` SET `basehp`=955 WHERE `class`=8 AND `level`=50; +UPDATE `player_classlevelstats` SET `basehp`=988 WHERE `class`=8 AND `level`=51; +UPDATE `player_classlevelstats` SET `basehp`=1032 WHERE `class`=8 AND `level`=52; +UPDATE `player_classlevelstats` SET `basehp`=1067 WHERE `class`=8 AND `level`=53; +UPDATE `player_classlevelstats` SET `basehp`=1103 WHERE `class`=8 AND `level`=54; +UPDATE `player_classlevelstats` SET `basehp`=1150 WHERE `class`=8 AND `level`=55; +UPDATE `player_classlevelstats` SET `basehp`=1188 WHERE `class`=8 AND `level`=56; +UPDATE `player_classlevelstats` SET `basehp`=1237 WHERE `class`=8 AND `level`=57; +UPDATE `player_classlevelstats` SET `basehp`=1277 WHERE `class`=8 AND `level`=58; +UPDATE `player_classlevelstats` SET `basehp`=1328 WHERE `class`=8 AND `level`=59; +UPDATE `player_classlevelstats` SET `basehp`=1370 WHERE `class`=8 AND `level`=60; +UPDATE `player_classlevelstats` SET `basehp`=1526 WHERE `class`=8 AND `level`=61; +UPDATE `player_classlevelstats` SET `basehp`=1702 WHERE `class`=8 AND `level`=62; +UPDATE `player_classlevelstats` SET `basehp`=1875 WHERE `class`=8 AND `level`=63; +UPDATE `player_classlevelstats` SET `basehp`=2070 WHERE `class`=8 AND `level`=64; +UPDATE `player_classlevelstats` SET `basehp`=2261 WHERE `class`=8 AND `level`=65; +UPDATE `player_classlevelstats` SET `basehp`=2461 WHERE `class`=8 AND `level`=66; +UPDATE `player_classlevelstats` SET `basehp`=2686 WHERE `class`=8 AND `level`=67; +UPDATE `player_classlevelstats` SET `basehp`=2906 WHERE `class`=8 AND `level`=68; +UPDATE `player_classlevelstats` SET `basehp`=3136 WHERE `class`=8 AND `level`=69; +UPDATE `player_classlevelstats` SET `basehp`=3393 WHERE `class`=8 AND `level`=70; +UPDATE `player_classlevelstats` SET `basehp`=3646 WHERE `class`=8 AND `level`=71; +UPDATE `player_classlevelstats` SET `basehp`=3918 WHERE `class`=8 AND `level`=72; +UPDATE `player_classlevelstats` SET `basehp`=4210 WHERE `class`=8 AND `level`=73; +UPDATE `player_classlevelstats` SET `basehp`=4524 WHERE `class`=8 AND `level`=74; +UPDATE `player_classlevelstats` SET `basehp`=4861 WHERE `class`=8 AND `level`=75; +UPDATE `player_classlevelstats` SET `basehp`=5223 WHERE `class`=8 AND `level`=76; +UPDATE `player_classlevelstats` SET `basehp`=5612 WHERE `class`=8 AND `level`=77; +UPDATE `player_classlevelstats` SET `basehp`=6030 WHERE `class`=8 AND `level`=78; +UPDATE `player_classlevelstats` SET `basehp`=6480 WHERE `class`=8 AND `level`=79; +UPDATE `player_classlevelstats` SET `basehp`=6963 WHERE `class`=8 AND `level`=80; +UPDATE `player_classlevelstats` SET `basehp`=23 WHERE `class`=9 AND `level`=1; +UPDATE `player_classlevelstats` SET `basehp`=28 WHERE `class`=9 AND `level`=2; +UPDATE `player_classlevelstats` SET `basehp`=43 WHERE `class`=9 AND `level`=3; +UPDATE `player_classlevelstats` SET `basehp`=48 WHERE `class`=9 AND `level`=4; +UPDATE `player_classlevelstats` SET `basehp`=63 WHERE `class`=9 AND `level`=5; +UPDATE `player_classlevelstats` SET `basehp`=68 WHERE `class`=9 AND `level`=6; +UPDATE `player_classlevelstats` SET `basehp`=83 WHERE `class`=9 AND `level`=7; +UPDATE `player_classlevelstats` SET `basehp`=88 WHERE `class`=9 AND `level`=8; +UPDATE `player_classlevelstats` SET `basehp`=93 WHERE `class`=9 AND `level`=9; +UPDATE `player_classlevelstats` SET `basehp`=108 WHERE `class`=9 AND `level`=10; +UPDATE `player_classlevelstats` SET `basehp`=123 WHERE `class`=9 AND `level`=11; +UPDATE `player_classlevelstats` SET `basehp`=128 WHERE `class`=9 AND `level`=12; +UPDATE `player_classlevelstats` SET `basehp`=143 WHERE `class`=9 AND `level`=13; +UPDATE `player_classlevelstats` SET `basehp`=148 WHERE `class`=9 AND `level`=14; +UPDATE `player_classlevelstats` SET `basehp`=153 WHERE `class`=9 AND `level`=15; +UPDATE `player_classlevelstats` SET `basehp`=168 WHERE `class`=9 AND `level`=16; +UPDATE `player_classlevelstats` SET `basehp`=173 WHERE `class`=9 AND `level`=17; +UPDATE `player_classlevelstats` SET `basehp`=189 WHERE `class`=9 AND `level`=18; +UPDATE `player_classlevelstats` SET `basehp`=196 WHERE `class`=9 AND `level`=19; +UPDATE `player_classlevelstats` SET `basehp`=204 WHERE `class`=9 AND `level`=20; +UPDATE `player_classlevelstats` SET `basehp`=223 WHERE `class`=9 AND `level`=21; +UPDATE `player_classlevelstats` SET `basehp`=233 WHERE `class`=9 AND `level`=22; +UPDATE `player_classlevelstats` SET `basehp`=244 WHERE `class`=9 AND `level`=23; +UPDATE `player_classlevelstats` SET `basehp`=266 WHERE `class`=9 AND `level`=24; +UPDATE `player_classlevelstats` SET `basehp`=279 WHERE `class`=9 AND `level`=25; +UPDATE `player_classlevelstats` SET `basehp`=293 WHERE `class`=9 AND `level`=26; +UPDATE `player_classlevelstats` SET `basehp`=318 WHERE `class`=9 AND `level`=27; +UPDATE `player_classlevelstats` SET `basehp`=334 WHERE `class`=9 AND `level`=28; +UPDATE `player_classlevelstats` SET `basehp`=351 WHERE `class`=9 AND `level`=29; +UPDATE `player_classlevelstats` SET `basehp`=379 WHERE `class`=9 AND `level`=30; +UPDATE `player_classlevelstats` SET `basehp`=398 WHERE `class`=9 AND `level`=31; +UPDATE `player_classlevelstats` SET `basehp`=418 WHERE `class`=9 AND `level`=32; +UPDATE `player_classlevelstats` SET `basehp`=439 WHERE `class`=9 AND `level`=33; +UPDATE `player_classlevelstats` SET `basehp`=471 WHERE `class`=9 AND `level`=34; +UPDATE `player_classlevelstats` SET `basehp`=494 WHERE `class`=9 AND `level`=35; +UPDATE `player_classlevelstats` SET `basehp`=518 WHERE `class`=9 AND `level`=36; +UPDATE `player_classlevelstats` SET `basehp`=543 WHERE `class`=9 AND `level`=37; +UPDATE `player_classlevelstats` SET `basehp`=569 WHERE `class`=9 AND `level`=38; +UPDATE `player_classlevelstats` SET `basehp`=606 WHERE `class`=9 AND `level`=39; +UPDATE `player_classlevelstats` SET `basehp`=634 WHERE `class`=9 AND `level`=40; +UPDATE `player_classlevelstats` SET `basehp`=663 WHERE `class`=9 AND `level`=41; +UPDATE `player_classlevelstats` SET `basehp`=693 WHERE `class`=9 AND `level`=42; +UPDATE `player_classlevelstats` SET `basehp`=724 WHERE `class`=9 AND `level`=43; +UPDATE `player_classlevelstats` SET `basehp`=756 WHERE `class`=9 AND `level`=44; +UPDATE `player_classlevelstats` SET `basehp`=799 WHERE `class`=9 AND `level`=45; +UPDATE `player_classlevelstats` SET `basehp`=832 WHERE `class`=9 AND `level`=46; +UPDATE `player_classlevelstats` SET `basehp`=868 WHERE `class`=9 AND `level`=47; +UPDATE `player_classlevelstats` SET `basehp`=904 WHERE `class`=9 AND `level`=48; +UPDATE `player_classlevelstats` SET `basehp`=941 WHERE `class`=9 AND `level`=49; +UPDATE `player_classlevelstats` SET `basehp`=979 WHERE `class`=9 AND `level`=50; +UPDATE `player_classlevelstats` SET `basehp`=1018 WHERE `class`=9 AND `level`=51; +UPDATE `player_classlevelstats` SET `basehp`=1058 WHERE `class`=9 AND `level`=52; +UPDATE `player_classlevelstats` SET `basehp`=1099 WHERE `class`=9 AND `level`=53; +UPDATE `player_classlevelstats` SET `basehp`=1141 WHERE `class`=9 AND `level`=54; +UPDATE `player_classlevelstats` SET `basehp`=1184 WHERE `class`=9 AND `level`=55; +UPDATE `player_classlevelstats` SET `basehp`=1228 WHERE `class`=9 AND `level`=56; +UPDATE `player_classlevelstats` SET `basehp`=1273 WHERE `class`=9 AND `level`=57; +UPDATE `player_classlevelstats` SET `basehp`=1319 WHERE `class`=9 AND `level`=58; +UPDATE `player_classlevelstats` SET `basehp`=1366 WHERE `class`=9 AND `level`=59; +UPDATE `player_classlevelstats` SET `basehp`=1414 WHERE `class`=9 AND `level`=60; +UPDATE `player_classlevelstats` SET `basehp`=1580 WHERE `class`=9 AND `level`=61; +UPDATE `player_classlevelstats` SET `basehp`=1755 WHERE `class`=9 AND `level`=62; +UPDATE `player_classlevelstats` SET `basehp`=1939 WHERE `class`=9 AND `level`=63; +UPDATE `player_classlevelstats` SET `basehp`=2133 WHERE `class`=9 AND `level`=64; +UPDATE `player_classlevelstats` SET `basehp`=2323 WHERE `class`=9 AND `level`=65; +UPDATE `player_classlevelstats` SET `basehp`=2535 WHERE `class`=9 AND `level`=66; +UPDATE `player_classlevelstats` SET `basehp`=2758 WHERE `class`=9 AND `level`=67; +UPDATE `player_classlevelstats` SET `basehp`=2991 WHERE `class`=9 AND `level`=68; +UPDATE `player_classlevelstats` SET `basehp`=3235 WHERE `class`=9 AND `level`=69; +UPDATE `player_classlevelstats` SET `basehp`=3490 WHERE `class`=9 AND `level`=70; +UPDATE `player_classlevelstats` SET `basehp`=3750 WHERE `class`=9 AND `level`=71; +UPDATE `player_classlevelstats` SET `basehp`=4025 WHERE `class`=9 AND `level`=72; +UPDATE `player_classlevelstats` SET `basehp`=4330 WHERE `class`=9 AND `level`=73; +UPDATE `player_classlevelstats` SET `basehp`=4646 WHERE `class`=9 AND `level`=74; +UPDATE `player_classlevelstats` SET `basehp`=4997 WHERE `class`=9 AND `level`=75; +UPDATE `player_classlevelstats` SET `basehp`=5373 WHERE `class`=9 AND `level`=76; +UPDATE `player_classlevelstats` SET `basehp`=5774 WHERE `class`=9 AND `level`=77; +UPDATE `player_classlevelstats` SET `basehp`=6207 WHERE `class`=9 AND `level`=78; +UPDATE `player_classlevelstats` SET `basehp`=6667 WHERE `class`=9 AND `level`=79; +UPDATE `player_classlevelstats` SET `basehp`=7136 WHERE `class`=9 AND `level`=80; +UPDATE `player_classlevelstats` SET `basehp`=44 WHERE `class`=11 AND `level`=1; +UPDATE `player_classlevelstats` SET `basehp`=51 WHERE `class`=11 AND `level`=2; +UPDATE `player_classlevelstats` SET `basehp`=58 WHERE `class`=11 AND `level`=3; +UPDATE `player_classlevelstats` SET `basehp`=75 WHERE `class`=11 AND `level`=4; +UPDATE `player_classlevelstats` SET `basehp`=82 WHERE `class`=11 AND `level`=5; +UPDATE `player_classlevelstats` SET `basehp`=89 WHERE `class`=11 AND `level`=6; +UPDATE `player_classlevelstats` SET `basehp`=106 WHERE `class`=11 AND `level`=7; +UPDATE `player_classlevelstats` SET `basehp`=113 WHERE `class`=11 AND `level`=8; +UPDATE `player_classlevelstats` SET `basehp`=120 WHERE `class`=11 AND `level`=9; +UPDATE `player_classlevelstats` SET `basehp`=137 WHERE `class`=11 AND `level`=10; +UPDATE `player_classlevelstats` SET `basehp`=144 WHERE `class`=11 AND `level`=11; +UPDATE `player_classlevelstats` SET `basehp`=151 WHERE `class`=11 AND `level`=12; +UPDATE `player_classlevelstats` SET `basehp`=168 WHERE `class`=11 AND `level`=13; +UPDATE `player_classlevelstats` SET `basehp`=175 WHERE `class`=11 AND `level`=14; +UPDATE `player_classlevelstats` SET `basehp`=182 WHERE `class`=11 AND `level`=15; +UPDATE `player_classlevelstats` SET `basehp`=199 WHERE `class`=11 AND `level`=16; +UPDATE `player_classlevelstats` SET `basehp`=206 WHERE `class`=11 AND `level`=17; +UPDATE `player_classlevelstats` SET `basehp`=214 WHERE `class`=11 AND `level`=18; +UPDATE `player_classlevelstats` SET `basehp`=233 WHERE `class`=11 AND `level`=19; +UPDATE `player_classlevelstats` SET `basehp`=243 WHERE `class`=11 AND `level`=20; +UPDATE `player_classlevelstats` SET `basehp`=254 WHERE `class`=11 AND `level`=21; +UPDATE `player_classlevelstats` SET `basehp`=266 WHERE `class`=11 AND `level`=22; +UPDATE `player_classlevelstats` SET `basehp`=289 WHERE `class`=11 AND `level`=23; +UPDATE `player_classlevelstats` SET `basehp`=303 WHERE `class`=11 AND `level`=24; +UPDATE `player_classlevelstats` SET `basehp`=318 WHERE `class`=11 AND `level`=25; +UPDATE `player_classlevelstats` SET `basehp`=334 WHERE `class`=11 AND `level`=26; +UPDATE `player_classlevelstats` SET `basehp`=361 WHERE `class`=11 AND `level`=27; +UPDATE `player_classlevelstats` SET `basehp`=379 WHERE `class`=11 AND `level`=28; +UPDATE `player_classlevelstats` SET `basehp`=398 WHERE `class`=11 AND `level`=29; +UPDATE `player_classlevelstats` SET `basehp`=418 WHERE `class`=11 AND `level`=30; +UPDATE `player_classlevelstats` SET `basehp`=439 WHERE `class`=11 AND `level`=31; +UPDATE `player_classlevelstats` SET `basehp`=461 WHERE `class`=11 AND `level`=32; +UPDATE `player_classlevelstats` SET `basehp`=494 WHERE `class`=11 AND `level`=33; +UPDATE `player_classlevelstats` SET `basehp`=518 WHERE `class`=11 AND `level`=34; +UPDATE `player_classlevelstats` SET `basehp`=543 WHERE `class`=11 AND `level`=35; +UPDATE `player_classlevelstats` SET `basehp`=569 WHERE `class`=11 AND `level`=36; +UPDATE `player_classlevelstats` SET `basehp`=596 WHERE `class`=11 AND `level`=37; +UPDATE `player_classlevelstats` SET `basehp`=624 WHERE `class`=11 AND `level`=38; +UPDATE `player_classlevelstats` SET `basehp`=653 WHERE `class`=11 AND `level`=39; +UPDATE `player_classlevelstats` SET `basehp`=683 WHERE `class`=11 AND `level`=40; +UPDATE `player_classlevelstats` SET `basehp`=714 WHERE `class`=11 AND `level`=41; +UPDATE `player_classlevelstats` SET `basehp`=746 WHERE `class`=11 AND `level`=42; +UPDATE `player_classlevelstats` SET `basehp`=779 WHERE `class`=11 AND `level`=43; +UPDATE `player_classlevelstats` SET `basehp`=823 WHERE `class`=11 AND `level`=44; +UPDATE `player_classlevelstats` SET `basehp`=858 WHERE `class`=11 AND `level`=45; +UPDATE `player_classlevelstats` SET `basehp`=894 WHERE `class`=11 AND `level`=46; +UPDATE `player_classlevelstats` SET `basehp`=921 WHERE `class`=11 AND `level`=47; +UPDATE `player_classlevelstats` SET `basehp`=959 WHERE `class`=11 AND `level`=48; +UPDATE `player_classlevelstats` SET `basehp`=998 WHERE `class`=11 AND `level`=49; +UPDATE `player_classlevelstats` SET `basehp`=1038 WHERE `class`=11 AND `level`=50; +UPDATE `player_classlevelstats` SET `basehp`=1079 WHERE `class`=11 AND `level`=51; +UPDATE `player_classlevelstats` SET `basehp`=1121 WHERE `class`=11 AND `level`=52; +UPDATE `player_classlevelstats` SET `basehp`=1164 WHERE `class`=11 AND `level`=53; +UPDATE `player_classlevelstats` SET `basehp`=1208 WHERE `class`=11 AND `level`=54; +UPDATE `player_classlevelstats` SET `basehp`=1253 WHERE `class`=11 AND `level`=55; +UPDATE `player_classlevelstats` SET `basehp`=1299 WHERE `class`=11 AND `level`=56; +UPDATE `player_classlevelstats` SET `basehp`=1346 WHERE `class`=11 AND `level`=57; +UPDATE `player_classlevelstats` SET `basehp`=1384 WHERE `class`=11 AND `level`=58; +UPDATE `player_classlevelstats` SET `basehp`=1433 WHERE `class`=11 AND `level`=59; +UPDATE `player_classlevelstats` SET `basehp`=1483 WHERE `class`=11 AND `level`=60; +UPDATE `player_classlevelstats` SET `basehp`=1657 WHERE `class`=11 AND `level`=61; +UPDATE `player_classlevelstats` SET `basehp`=1840 WHERE `class`=11 AND `level`=62; +UPDATE `player_classlevelstats` SET `basehp`=2020 WHERE `class`=11 AND `level`=63; +UPDATE `player_classlevelstats` SET `basehp`=2222 WHERE `class`=11 AND `level`=64; +UPDATE `player_classlevelstats` SET `basehp`=2433 WHERE `class`=11 AND `level`=65; +UPDATE `player_classlevelstats` SET `basehp`=2640 WHERE `class`=11 AND `level`=66; +UPDATE `player_classlevelstats` SET `basehp`=2872 WHERE `class`=11 AND `level`=67; +UPDATE `player_classlevelstats` SET `basehp`=3114 WHERE `class`=11 AND `level`=68; +UPDATE `player_classlevelstats` SET `basehp`=3351 WHERE `class`=11 AND `level`=69; +UPDATE `player_classlevelstats` SET `basehp`=3614 WHERE `class`=11 AND `level`=70; +UPDATE `player_classlevelstats` SET `basehp`=3883 WHERE `class`=11 AND `level`=71; +UPDATE `player_classlevelstats` SET `basehp`=4172 WHERE `class`=11 AND `level`=72; +UPDATE `player_classlevelstats` SET `basehp`=4483 WHERE `class`=11 AND `level`=73; +UPDATE `player_classlevelstats` SET `basehp`=4817 WHERE `class`=11 AND `level`=74; +UPDATE `player_classlevelstats` SET `basehp`=5176 WHERE `class`=11 AND `level`=75; +UPDATE `player_classlevelstats` SET `basehp`=5562 WHERE `class`=11 AND `level`=76; +UPDATE `player_classlevelstats` SET `basehp`=5977 WHERE `class`=11 AND `level`=77; +UPDATE `player_classlevelstats` SET `basehp`=6423 WHERE `class`=11 AND `level`=78; +UPDATE `player_classlevelstats` SET `basehp`=6902 WHERE `class`=11 AND `level`=79; +UPDATE `player_classlevelstats` SET `basehp`=7417 WHERE `class`=11 AND `level`=80; diff --git a/src/server/game/DataStores/GameTables.cpp b/src/server/game/DataStores/GameTables.cpp index e47033e3655..429bf0c1644 100644 --- a/src/server/game/DataStores/GameTables.cpp +++ b/src/server/game/DataStores/GameTables.cpp @@ -31,7 +31,6 @@ GameTable<GtChanceToSpellCritEntry> sChanceToSpellCritGameTable; GameTable<GtChanceToSpellCritBaseEntry> sChanceToSpellCritBaseGameTable; GameTable<GtCombatRatingsEntry> sCombatRatingsGameTable; GameTable<GtNpcManaCostScalerEntry> sNpcManaCostScalerGameTable; -GameTable<GtOctBaseHpByClassEntry> sOctBaseHpByClassGameTable; GameTable<GtOctBaseMpByClassEntry> sOctBaseMpByClassGameTable; GameTable<GtOctClassCombatRatingScalarEntry> sOctClassCombatRatingScalarGameTable; GameTable<GtOctHpPerStaminaEntry> sOctHpPerStaminaGameTable; @@ -127,7 +126,6 @@ void LoadGameTables(std::string const& dataPath) LOAD_GT(sChanceToSpellCritBaseGameTable, "ChanceToSpellCritBase.txt"); LOAD_GT(sCombatRatingsGameTable, "CombatRatings.txt"); LOAD_GT(sNpcManaCostScalerGameTable, "NPCManaCostScaler.txt"); - LOAD_GT(sOctBaseHpByClassGameTable, "OCTBaseHPByClass.txt"); LOAD_GT(sOctBaseMpByClassGameTable, "OCTBaseMPByClass.txt"); LOAD_GT(sOctClassCombatRatingScalarGameTable, "OCTClassCombatRatingScalar.txt"); LOAD_GT(sOctHpPerStaminaGameTable, "OCTHPPerStamina.txt"); diff --git a/src/server/game/DataStores/GameTables.h b/src/server/game/DataStores/GameTables.h index 02292e50876..43466237d81 100644 --- a/src/server/game/DataStores/GameTables.h +++ b/src/server/game/DataStores/GameTables.h @@ -130,21 +130,6 @@ struct GtNpcManaCostScalerEntry float Scaler = 0.0f; }; -struct GtOctBaseHpByClassEntry -{ - float Warrior = 0.0f; - float Paladin = 0.0f; - float Hunter = 0.0f; - float Rogue = 0.0f; - float Priest = 0.0f; - float DeathKnight = 0.0f; - float Shaman = 0.0f; - float Mage = 0.0f; - float Warlock = 0.0f; - float Monk = 0.0f; - float Druid = 0.0f; -}; - struct GtOctBaseMpByClassEntry { float Warrior = 0.0f; @@ -254,19 +239,24 @@ struct GtShieldBlockRegularEntry struct GtSpellScalingEntry { - float Warrior = 0.0f; - float Paladin = 0.0f; - float Hunter = 0.0f; float Rogue = 0.0f; + float Druid = 0.0f; + float Hunter = 0.0f; + float Mage = 0.0f; + float Paladin = 0.0f; float Priest = 0.0f; - float DeathKnight = 0.0f; float Shaman = 0.0f; - float Mage = 0.0f; float Warlock = 0.0f; + float Warrior = 0.0f; + float DeathKnight = 0.0f; float Monk = 0.0f; - float Druid = 0.0f; + float DemonHunter = 0.0f; float Item = 0.0f; float Consumable = 0.0f; + float Gem1 = 0.0f; + float Gem2 = 0.0f; + float Gem3 = 0.0f; + float Health = 0.0f; }; struct GtTeamContributionPointsEntry @@ -301,7 +291,6 @@ TC_GAME_API extern GameTable<GtChanceToSpellCritEntry> sChanceToSpe TC_GAME_API extern GameTable<GtChanceToSpellCritBaseEntry> sChanceToSpellCritBaseGameTable; TC_GAME_API extern GameTable<GtCombatRatingsEntry> sCombatRatingsGameTable; TC_GAME_API extern GameTable<GtNpcManaCostScalerEntry> sNpcManaCostScalerGameTable; -TC_GAME_API extern GameTable<GtOctBaseHpByClassEntry> sOctBaseHpByClassGameTable; TC_GAME_API extern GameTable<GtOctBaseMpByClassEntry> sOctBaseMpByClassGameTable; TC_GAME_API extern GameTable<GtOctClassCombatRatingScalarEntry> sOctClassCombatRatingScalarGameTable; TC_GAME_API extern GameTable<GtOctHpPerStaminaEntry> sOctHpPerStaminaGameTable; diff --git a/src/server/game/Entities/Player/Player.cpp b/src/server/game/Entities/Player/Player.cpp index f3853f65e42..d17c9f73a6a 100644 --- a/src/server/game/Entities/Player/Player.cpp +++ b/src/server/game/Entities/Player/Player.cpp @@ -2068,12 +2068,12 @@ void Player::GiveLevel(uint8 level) PlayerLevelInfo info; sObjectMgr->GetPlayerLevelInfo(GetRace(), GetClass(), level, &info); - uint32 basemana = 0, baseHp = 0; - sObjectMgr->GetPlayerClassLevelInfo(GetClass(), level, basemana, baseHp); + uint32 basemana = 0; + sObjectMgr->GetPlayerClassLevelInfo(GetClass(), level, basemana); WorldPackets::Misc::LevelUpInfo packet; packet.Level = level; - packet.HealthDelta = int32(baseHp) - int32(GetCreateHealth()); + packet.HealthDelta = int32(info.base_hp) - int32(GetCreateHealth()); /// @todo find some better solution // for (int i = 0; i < MAX_STORED_POWERS; ++i) @@ -2102,7 +2102,7 @@ void Player::GiveLevel(uint8 level) for (uint8 i = STAT_STRENGTH; i < MAX_STATS; ++i) SetCreateStat(Stats(i), info.stats[i]); - SetCreateHealth(baseHp); + SetCreateHealth(info.base_hp); SetCreateMana(basemana); InitGlyphsForLevel(); @@ -2155,8 +2155,8 @@ void Player::InitStatsForLevel(bool reapplyMods) if (reapplyMods) //reapply stats values only on .reset stats (level) command _RemoveAllStatBonuses(); - uint32 basemana = 0, baseHp = 0; - sObjectMgr->GetPlayerClassLevelInfo(GetClass(), GetLevel(), basemana, baseHp); + uint32 basemana = 0; + sObjectMgr->GetPlayerClassLevelInfo(GetClass(), GetLevel(), basemana); PlayerLevelInfo info; sObjectMgr->GetPlayerLevelInfo(GetRace(), GetClass(), GetLevel(), &info); @@ -2194,7 +2194,7 @@ void Player::InitStatsForLevel(bool reapplyMods) for (uint8 i = STAT_STRENGTH; i < MAX_STATS; ++i) SetStat(Stats(i), info.stats[i]); - SetCreateHealth(baseHp); + SetCreateHealth(info.base_hp); //set create powers SetCreateMana(basemana); diff --git a/src/server/game/Entities/Player/PlayerTaxi.cpp b/src/server/game/Entities/Player/PlayerTaxi.cpp index 70bc584baff..1716b18175c 100644 --- a/src/server/game/Entities/Player/PlayerTaxi.cpp +++ b/src/server/game/Entities/Player/PlayerTaxi.cpp @@ -45,7 +45,6 @@ void PlayerTaxi::InitTaxiNodesForLevel(uint32 race, uint32 chrClass, uint8 level case RACE_NIGHTELF: case RACE_GNOME: case RACE_DRAENEI: - case RACE_WORGEN: SetTaximaskNode(2); // Stormwind, Elwynn SetTaximaskNode(6); // Ironforge, Dun Morogh SetTaximaskNode(26); // Lor'danel, Darkshore @@ -65,7 +64,6 @@ void PlayerTaxi::InitTaxiNodesForLevel(uint32 race, uint32 chrClass, uint8 level case RACE_TAUREN: case RACE_TROLL: case RACE_BLOODELF: - case RACE_GOBLIN: SetTaximaskNode(11); // Undercity, Tirisfal SetTaximaskNode(22); // Thunder Bluff, Mulgore SetTaximaskNode(23); // Orgrimmar, Durotar diff --git a/src/server/game/Entities/Unit/StatSystem.cpp b/src/server/game/Entities/Unit/StatSystem.cpp index ec4a41e89c5..bfcb4149d90 100644 --- a/src/server/game/Entities/Unit/StatSystem.cpp +++ b/src/server/game/Entities/Unit/StatSystem.cpp @@ -111,10 +111,10 @@ void Unit::UpdatePowerRegen(Powers powerType) case POWER_MANA: { // Get base of Mana Pool in sBaseMPGameTable - uint32 basemana = 0, basehp = 0; + uint32 basemana = 0; if (IsPlayer()) - sObjectMgr->GetPlayerClassLevelInfo(GetClass(), GetLevel(), basemana, basehp); + sObjectMgr->GetPlayerClassLevelInfo(GetClass(), GetLevel(), basemana); else basemana = GetCreateMana(); // this should also get replaced by the base mana game table in the future. diff --git a/src/server/game/Globals/ObjectMgr.cpp b/src/server/game/Globals/ObjectMgr.cpp index b1db5850e65..25ff87d474b 100644 --- a/src/server/game/Globals/ObjectMgr.cpp +++ b/src/server/game/Globals/ObjectMgr.cpp @@ -4013,8 +4013,8 @@ void ObjectMgr::LoadPlayerInfo() } while (raceStatsResult->NextRow()); - // 0 1 2 3 4 5 6 - QueryResult result = WorldDatabase.Query("SELECT class, level, str, agi, sta, inte, spi FROM player_classlevelstats"); + // 0 1 2 3 4 5 6 7 + QueryResult result = WorldDatabase.Query("SELECT class, level, str, agi, sta, inte, spi, basehp FROM player_classlevelstats"); if (!result) { @@ -4056,6 +4056,8 @@ void ObjectMgr::LoadPlayerInfo() PlayerLevelInfo& levelInfo = playerInfo->levelInfo[current_level - 1]; for (uint8 i = 0; i < MAX_STATS; ++i) levelInfo.stats[i] = fields[i + 2].GetUInt16() + raceStatModifiers[race].StatModifier[i]; + + levelInfo.base_hp = fields[7].GetUInt32(); } } @@ -4089,14 +4091,14 @@ void ObjectMgr::LoadPlayerInfo() continue; // skip expansion races if not playing with expansion - if (sWorld->getIntConfig(CONFIG_EXPANSION) < EXPANSION_CATACLYSM && (race == RACE_GOBLIN || race == RACE_WORGEN)) - continue; - - if (sWorld->getIntConfig(CONFIG_EXPANSION) < EXPANSION_LEGION && class_ == CLASS_DEMON_HUNTER) - continue; - - if (sWorld->getIntConfig(CONFIG_EXPANSION) < EXPANSION_DRAGONFLIGHT && class_ == CLASS_EVOKER) - continue; + // if (sWorld->getIntConfig(CONFIG_EXPANSION) < EXPANSION_CATACLYSM && (race == RACE_GOBLIN || race == RACE_WORGEN)) + // continue; + // + // if (sWorld->getIntConfig(CONFIG_EXPANSION) < EXPANSION_LEGION && class_ == CLASS_DEMON_HUNTER) + // continue; + // + // if (sWorld->getIntConfig(CONFIG_EXPANSION) < EXPANSION_DRAGONFLIGHT && class_ == CLASS_EVOKER) + // continue; // fatal error if no level 1 data if (!playerInfo->levelInfo || playerInfo->levelInfo[0].stats[0] == 0) @@ -4174,7 +4176,7 @@ void ObjectMgr::LoadPlayerInfo() } } -void ObjectMgr::GetPlayerClassLevelInfo(uint32 class_, uint8 level, uint32& baseMana, uint32& baseHp) const +void ObjectMgr::GetPlayerClassLevelInfo(uint32 class_, uint8 level, uint32& baseMana) const { if (level < 1 || class_ >= MAX_CLASSES) return; @@ -4186,11 +4188,6 @@ void ObjectMgr::GetPlayerClassLevelInfo(uint32 class_, uint8 level, uint32& base baseMana = uint32(GetGameTableColumnForClass(mp, class_)); else baseMana = 0; - - if (GtOctBaseHpByClassEntry const* hp = sOctBaseHpByClassGameTable.GetRow(level)) - baseHp = uint32(GetGameTableColumnForClass(hp, class_)); - else - baseHp = 0; } void ObjectMgr::GetPlayerLevelInfo(uint32 race, uint32 class_, uint8 level, PlayerLevelInfo* info) const diff --git a/src/server/game/Globals/ObjectMgr.h b/src/server/game/Globals/ObjectMgr.h index f645ddacf38..f5c31e91260 100644 --- a/src/server/game/Globals/ObjectMgr.h +++ b/src/server/game/Globals/ObjectMgr.h @@ -630,6 +630,7 @@ typedef std::vector<PlayerCreateInfoItem> PlayerCreateInfoItems; struct PlayerLevelInfo { uint16 stats[MAX_STATS] = { }; + uint32 base_hp = 1; }; typedef std::vector<uint32> PlayerCreateInfoSpells; @@ -1154,7 +1155,7 @@ class TC_GAME_API ObjectMgr PetLevelInfo const* GetPetLevelInfo(uint32 creature_id, uint8 level) const; - void GetPlayerClassLevelInfo(uint32 class_, uint8 level, uint32& baseMana, uint32& baseHp) const; + void GetPlayerClassLevelInfo(uint32 class_, uint8 level, uint32& baseMana) const; PlayerInfo const* GetPlayerInfo(uint32 race, uint32 class_) const; diff --git a/src/server/game/Handlers/CharacterHandler.cpp b/src/server/game/Handlers/CharacterHandler.cpp index b0fcfe262c8..6566698c649 100644 --- a/src/server/game/Handlers/CharacterHandler.cpp +++ b/src/server/game/Handlers/CharacterHandler.cpp @@ -2138,9 +2138,6 @@ void WorldSession::HandleCharRaceOrFactionChangeCallback(std::shared_ptr<WorldPa case RACE_NIGHTELF: stmt->setUInt16(1, 113); break; - case RACE_WORGEN: - stmt->setUInt16(1, 791); - break; case RACE_UNDEAD_PLAYER: stmt->setUInt16(1, 673); break; @@ -2153,9 +2150,6 @@ void WorldSession::HandleCharRaceOrFactionChangeCallback(std::shared_ptr<WorldPa case RACE_BLOODELF: stmt->setUInt16(1, 137); break; - case RACE_GOBLIN: - stmt->setUInt16(1, 792); - break; default: TC_LOG_ERROR("entities.player", "Could not find language data for race ({}).", factionChangeInfo->RaceID); SendCharFactionChange(CHAR_CREATE_ERROR, factionChangeInfo.get()); diff --git a/src/server/game/Miscellaneous/RaceMask.h b/src/server/game/Miscellaneous/RaceMask.h index 6cb511f8cff..d22a2852ab8 100644 --- a/src/server/game/Miscellaneous/RaceMask.h +++ b/src/server/game/Miscellaneous/RaceMask.h @@ -33,7 +33,7 @@ enum Races RACE_TAUREN = 6, // TITLE Tauren RACE_GNOME = 7, // TITLE Gnome RACE_TROLL = 8, // TITLE Troll - RACE_GOBLIN = 9, // TITLE Goblin + //RACE_GOBLIN = 9, // TITLE Goblin RACE_BLOODELF = 10, // TITLE Blood Elf RACE_DRAENEI = 11, // TITLE Draenei //RACE_FEL_ORC = 12, @@ -46,7 +46,7 @@ enum Races //RACE_TAUNKA = 19, //RACE_NORTHREND_SKELETON = 20, //RACE_ICE_TROLL = 21, - RACE_WORGEN = 22, // TITLE Worgen + //RACE_WORGEN = 22, // TITLE Worgen //RACE_GILNEAN = 23, //RACE_PANDAREN_NEUTRAL = 24, // TITLE Pandaren DESCRIPTION Pandaren (Neutral) //RACE_PANDAREN_ALLIANCE = 25, // TITLE Pandaren DESCRIPTION Pandaren (Alliance) @@ -81,7 +81,7 @@ enum Races }; // max+1 for player race -#define MAX_RACES 23 +#define MAX_RACES 12 namespace Trinity { @@ -109,10 +109,8 @@ struct RaceMask case RACE_TAUREN: case RACE_GNOME: case RACE_TROLL: - case RACE_GOBLIN: case RACE_BLOODELF: case RACE_DRAENEI: - case RACE_WORGEN: return raceId - 1; default: break; @@ -145,17 +143,14 @@ constexpr Trinity::RaceMask<uint64> RACEMASK_ALL_PLAYABLE = { std::integral_cons Trinity::RaceMask<uint64>::GetMaskForRace(RACE_GNOME) | Trinity::RaceMask<uint64>::GetMaskForRace(RACE_TROLL) | Trinity::RaceMask<uint64>::GetMaskForRace(RACE_BLOODELF) | - Trinity::RaceMask<uint64>::GetMaskForRace(RACE_DRAENEI) | - Trinity::RaceMask<uint64>::GetMaskForRace(RACE_GOBLIN) | - Trinity::RaceMask<uint64>::GetMaskForRace(RACE_WORGEN)>::value }; + Trinity::RaceMask<uint64>::GetMaskForRace(RACE_DRAENEI)>::value }; constexpr Trinity::RaceMask<uint64> RACEMASK_ALLIANCE = { std::integral_constant<uint64, Trinity::RaceMask<uint64>::GetMaskForRace(RACE_HUMAN) | Trinity::RaceMask<uint64>::GetMaskForRace(RACE_DWARF) | Trinity::RaceMask<uint64>::GetMaskForRace(RACE_NIGHTELF) | Trinity::RaceMask<uint64>::GetMaskForRace(RACE_GNOME) | - Trinity::RaceMask<uint64>::GetMaskForRace(RACE_DRAENEI) | - Trinity::RaceMask<uint64>::GetMaskForRace(RACE_WORGEN)>::value }; + Trinity::RaceMask<uint64>::GetMaskForRace(RACE_DRAENEI)>::value }; constexpr Trinity::RaceMask<uint64> RACEMASK_HORDE = { std::integral_constant<uint64, (RACEMASK_ALL_PLAYABLE & ~RACEMASK_ALLIANCE).RawValue>::value }; diff --git a/src/server/game/Miscellaneous/enuminfo_RaceMask.cpp b/src/server/game/Miscellaneous/enuminfo_RaceMask.cpp index ccb1bf88880..ea55661950e 100644 --- a/src/server/game/Miscellaneous/enuminfo_RaceMask.cpp +++ b/src/server/game/Miscellaneous/enuminfo_RaceMask.cpp @@ -39,10 +39,8 @@ TC_API_EXPORT EnumText EnumUtils<Races>::ToString(Races value) case RACE_TAUREN: return { "RACE_TAUREN", "Tauren", "" }; case RACE_GNOME: return { "RACE_GNOME", "Gnome", "" }; case RACE_TROLL: return { "RACE_TROLL", "Troll", "" }; - case RACE_GOBLIN: return { "RACE_GOBLIN", "Goblin", "" }; case RACE_BLOODELF: return { "RACE_BLOODELF", "Blood Elf", "" }; case RACE_DRAENEI: return { "RACE_DRAENEI", "Draenei", "" }; - case RACE_WORGEN: return { "RACE_WORGEN", "Worgen", "" }; default: throw std::out_of_range("value"); } } @@ -63,10 +61,8 @@ TC_API_EXPORT Races EnumUtils<Races>::FromIndex(size_t index) case 5: return RACE_TAUREN; case 6: return RACE_GNOME; case 7: return RACE_TROLL; - case 8: return RACE_GOBLIN; case 9: return RACE_BLOODELF; case 10: return RACE_DRAENEI; - case 11: return RACE_WORGEN; default: throw std::out_of_range("index"); } } @@ -84,10 +80,8 @@ TC_API_EXPORT size_t EnumUtils<Races>::ToIndex(Races value) case RACE_TAUREN: return 5; case RACE_GNOME: return 6; case RACE_TROLL: return 7; - case RACE_GOBLIN: return 8; case RACE_BLOODELF: return 9; case RACE_DRAENEI: return 10; - case RACE_WORGEN: return 11; default: throw std::out_of_range("value"); } } diff --git a/src/server/scripts/Spells/spell_generic.cpp b/src/server/scripts/Spells/spell_generic.cpp index ae3615e29a1..7afa893198b 100644 --- a/src/server/scripts/Spells/spell_generic.cpp +++ b/src/server/scripts/Spells/spell_generic.cpp @@ -420,12 +420,10 @@ class spell_gen_battleground_mercenary_shapeshift : public AuraScript { RACE_NIGHTELF, { RACE_TROLL, RACE_BLOODELF } }, { RACE_UNDEAD_PLAYER, { RACE_HUMAN } }, { RACE_TAUREN, { RACE_DRAENEI, RACE_NIGHTELF } }, - { RACE_GNOME, { RACE_GOBLIN, RACE_BLOODELF } }, + { RACE_GNOME, { RACE_BLOODELF } }, { RACE_TROLL, { RACE_NIGHTELF, RACE_HUMAN, RACE_DRAENEI } }, - { RACE_GOBLIN, { RACE_GNOME, RACE_DWARF } }, { RACE_BLOODELF, { RACE_HUMAN, RACE_NIGHTELF } }, { RACE_DRAENEI, { RACE_TAUREN, RACE_ORC } }, - { RACE_WORGEN, { RACE_TROLL } } }; inline static std::unordered_map<Races, std::array<uint32, 2>> const RaceDisplayIds = @@ -438,10 +436,8 @@ class spell_gen_battleground_mercenary_shapeshift : public AuraScript { RACE_TAUREN, { 55261, 55260 } }, { RACE_GNOME, { 55245, 55244 } }, { RACE_TROLL, { 55263, 55262 } }, - { RACE_GOBLIN, { 55267, 57244 } }, { RACE_BLOODELF, { 55265, 55264 } }, { RACE_DRAENEI, { 55247, 55246 } }, - { RACE_WORGEN, { 55255, 55254 } } }; inline static std::vector<uint32> RacialSkills; diff --git a/src/tools/map_extractor/System.cpp b/src/tools/map_extractor/System.cpp index 04f916dc43b..aaf69832af7 100644 --- a/src/tools/map_extractor/System.cpp +++ b/src/tools/map_extractor/System.cpp @@ -1351,7 +1351,7 @@ void ExtractGameTables() // { 1391653, "NpcTotalHpExp1.txt" }, // { 1391654, "NpcTotalHpExp2.txt" }, // { 1391655, "NpcTotalHpExp3.txt" }, - { 5464960, "OCTBaseHPByClass.txt" }, + // { 5464960, "OCTBaseHPByClass.txt" }, { 4049853, "OCTBaseMPByClass.txt" }, { 4526467, "OCTClassCombatRatingScalar.txt" }, { 5464961, "OCTHPPerStamina.txt" }, |