diff options
| -rw-r--r-- | sql/updates/world/master/2022_02_16_00_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/master/2022_02_16_01_world_902.sql | 148 | ||||
| -rw-r--r-- | sql/updates/world/master/2022_02_16_02_world_905.sql | 220 | ||||
| -rw-r--r-- | sql/updates/world/master/2022_02_16_03_world_910.sql | 282 | ||||
| -rw-r--r-- | sql/updates/world/master/2022_02_16_04_world_915.sql | 50 |
5 files changed, 702 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_16_00_world.sql b/sql/updates/world/master/2022_02_16_00_world.sql new file mode 100644 index 00000000000..ad53328ed1e --- /dev/null +++ b/sql/updates/world/master/2022_02_16_00_world.sql @@ -0,0 +1,2 @@ +-- +ALTER TABLE `player_classlevelstats` ADD `VerifiedBuild` int NOT NULL DEFAULT 0 AFTER `inte`; diff --git a/sql/updates/world/master/2022_02_16_01_world_902.sql b/sql/updates/world/master/2022_02_16_01_world_902.sql new file mode 100644 index 00000000000..233fbf14ab1 --- /dev/null +++ b/sql/updates/world/master/2022_02_16_01_world_902.sql @@ -0,0 +1,148 @@ +-- +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37176 WHERE (`class`=1 AND `level`=10); -- MagharOrc Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=1 AND `level`=32); -- Human Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=1 AND `level`=33); -- Human Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=1 AND `level`=34); -- Human Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37474 WHERE (`class`=1 AND `level`=35); -- Human Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37474 WHERE (`class`=1 AND `level`=36); -- Human Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37176 WHERE (`class`=1 AND `level`=46); -- HighmountainTauren Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37474 WHERE (`class`=2 AND `level`=1); -- Human Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36839 WHERE (`class`=2 AND `level`=2); -- Human Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36839 WHERE (`class`=2 AND `level`=3); -- Human Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36839 WHERE (`class`=2 AND `level`=4); -- Human Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36839 WHERE (`class`=2 AND `level`=5); -- Human Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36839 WHERE (`class`=2 AND `level`=6); -- Human Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36839 WHERE (`class`=2 AND `level`=7); -- Human Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36839 WHERE (`class`=2 AND `level`=8); -- Human Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36839 WHERE (`class`=2 AND `level`=9); -- Human Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36839 WHERE (`class`=2 AND `level`=10); -- Human Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36839 WHERE (`class`=2 AND `level`=11); -- Human Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36671 WHERE (`class`=2 AND `level`=50); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37176 WHERE (`class`=3 AND `level`=1); -- Gnome Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37474 WHERE (`class`=3 AND `level`=2); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37474 WHERE (`class`=3 AND `level`=3); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37474 WHERE (`class`=3 AND `level`=4); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37474 WHERE (`class`=3 AND `level`=5); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37474 WHERE (`class`=3 AND `level`=6); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=1); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=2); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=3); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=4); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=5); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=6); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=7); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=8); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=9); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=10); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=11); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=12); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=13); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=14); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=15); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=16); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=17); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=18); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=19); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=20); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=21); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=22); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `inte`=44, `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=23); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=24); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=25); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `sta`=67, `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=26); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=27); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=28); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=29); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=30); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=31); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=32); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=33); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36753 WHERE (`class`=4 AND `level`=34); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `str`=19, `agi`=28, `sta`=36, `inte`=38, `VerifiedBuild`=37176 WHERE (`class`=5 AND `level`=10); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=84, `agi`=120, `sta`=138, `inte`=145, `VerifiedBuild`=37176 WHERE (`class`=5 AND `level`=48); -- Troll Priest recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=8); -- Troll DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=9); -- Troll DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=10); -- Troll DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=11); -- Troll DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=12); -- Troll DeathKnight recalculated +UPDATE `player_classlevelstats` SET `sta`=148, `VerifiedBuild`=36671 WHERE (`class`=6 AND `level`=50); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `sta`=187, `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=51); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `sta`=204, `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=52); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `sta`=223, `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=53); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `sta`=244, `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=54); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `sta`=267, `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=55); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `sta`=292, `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=56); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `sta`=317, `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=57); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `sta`=343, `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=58); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `sta`=372, `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=59); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37176 WHERE (`class`=6 AND `level`=60); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `str`=31, `agi`=72, `sta`=69, `inte`=72, `VerifiedBuild`=37176 WHERE (`class`=7 AND `level`=27); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=56, `agi`=130, `sta`=124, `inte`=130, `VerifiedBuild`=37176 WHERE (`class`=7 AND `level`=45); -- Orc Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=58, `agi`=135, `sta`=128, `inte`=135, `VerifiedBuild`=37474 WHERE (`class`=7 AND `level`=46); -- Orc Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=60, `agi`=140, `sta`=133, `inte`=140, `VerifiedBuild`=37474 WHERE (`class`=7 AND `level`=47); -- Orc Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=7, `agi`=12, `sta`=15, `inte`=20, `VerifiedBuild`=37474 WHERE (`class`=8 AND `level`=1); -- BloodElf Mage recalculated +UPDATE `player_classlevelstats` SET `str`=68, `agi`=106, `sta`=148, `inte`=155, `VerifiedBuild`=36671 WHERE (`class`=8 AND `level`=50); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36671 WHERE (`class`=9 AND `level`=50); -- Troll Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36671 WHERE (`class`=10 AND `level`=50); -- HighmountainTauren Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=1); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=2); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=3); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=4); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `sta`=27, `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=5); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=6); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=7); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=8); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=9); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `sta`=36, `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=10); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `sta`=38, `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=11); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `sta`=40, `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=12); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=13); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=14); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=15); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `sta`=48, `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=16); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `sta`=50, `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=17); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=18); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=19); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=20); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=21); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=22); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=23); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=24); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=25); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=26); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=27); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=28); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=29); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=30); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=31); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=32); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=33); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=34); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=35); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=36); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=37); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=38); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=39); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=40); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=41); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=42); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=43); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=44); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37474 WHERE (`class`=11 AND `level`=45); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=46); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=47); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=48); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36949 WHERE (`class`=11 AND `level`=49); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36665 WHERE (`class`=11 AND `level`=50); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36710 WHERE (`class`=11 AND `level`=51); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36710 WHERE (`class`=11 AND `level`=52); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36710 WHERE (`class`=11 AND `level`=53); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36710 WHERE (`class`=11 AND `level`=54); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36710 WHERE (`class`=11 AND `level`=55); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36710 WHERE (`class`=11 AND `level`=56); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36734 WHERE (`class`=11 AND `level`=57); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36734 WHERE (`class`=11 AND `level`=58); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36734 WHERE (`class`=11 AND `level`=59); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=36734 WHERE (`class`=11 AND `level`=60); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37176 WHERE (`class`=12 AND `level`=46); -- NightElf DemonHunter recalculated + diff --git a/sql/updates/world/master/2022_02_16_02_world_905.sql b/sql/updates/world/master/2022_02_16_02_world_905.sql new file mode 100644 index 00000000000..a811a8f54f3 --- /dev/null +++ b/sql/updates/world/master/2022_02_16_02_world_905.sql @@ -0,0 +1,220 @@ +-- +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=1 AND `level`=10); -- Vulpera Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=1 AND `level`=46); -- HighmountainTauren Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=1 AND `level`=60); -- Orc Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=2 AND `level`=50); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=2 AND `level`=51); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=2 AND `level`=52); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=2 AND `level`=53); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=2 AND `level`=54); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=2 AND `level`=55); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=2 AND `level`=56); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=2 AND `level`=57); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=2 AND `level`=58); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=2 AND `level`=59); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=2 AND `level`=60); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=6); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=7); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=8); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=9); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=10); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=11); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=12); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=13); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=14); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=15); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=16); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=17); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=18); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=19); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=20); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=21); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=22); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=23); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=24); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=25); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=26); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=27); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=28); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=29); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=30); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=31); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=32); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=33); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=34); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=35); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=36); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=37); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=38); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=39); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=3 AND `level`=40); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=3 AND `level`=41); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=3 AND `level`=42); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=3 AND `level`=43); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=3 AND `level`=44); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=3 AND `level`=45); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=3 AND `level`=46); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=3 AND `level`=47); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=3 AND `level`=48); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=3 AND `level`=49); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=3 AND `level`=50); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=3 AND `level`=51); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=3 AND `level`=52); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=3 AND `level`=53); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=3 AND `level`=54); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=3 AND `level`=55); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=3 AND `level`=60); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=4 AND `level`=34); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=35); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=36); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=37); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=38); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=39); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=40); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=41); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=42); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=43); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=44); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=45); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=46); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=47); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=48); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=49); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=50); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=4 AND `level`=60); -- BloodElf Rogue recalculated +UPDATE `player_classlevelstats` SET `str`=19, `agi`=28, `sta`=36, `inte`=38, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=10); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=21, `agi`=30, `sta`=38, `inte`=40, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=11); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=23, `agi`=33, `sta`=40, `inte`=42, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=12); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=25, `agi`=36, `sta`=42, `inte`=44, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=13); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=27, `agi`=38, `sta`=44, `inte`=46, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=14); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=28, `agi`=40, `sta`=46, `inte`=48, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=15); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=29, `agi`=42, `sta`=48, `inte`=50, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=16); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=30, `agi`=43, `sta`=50, `inte`=52, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=17); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=31, `agi`=45, `sta`=51, `inte`=54, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=18); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=32, `agi`=46, `sta`=53, `inte`=56, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=19); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=34, `agi`=48, `sta`=55, `inte`=58, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=20); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=35, `agi`=50, `sta`=57, `inte`=60, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=21); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=36, `agi`=51, `sta`=59, `inte`=62, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=22); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=37, `agi`=53, `sta`=61, `inte`=64, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=23); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=38, `agi`=55, `sta`=63, `inte`=66, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=24); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=39, `agi`=56, `sta`=65, `inte`=68, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=25); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=41, `agi`=58, `sta`=67, `inte`=70, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=26); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=42, `agi`=60, `sta`=69, `inte`=72, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=27); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=43, `agi`=62, `sta`=71, `inte`=74, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=28); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=45, `agi`=64, `sta`=73, `inte`=77, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=29); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=46, `agi`=66, `sta`=75, `inte`=79, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=30); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=47, `agi`=68, `sta`=78, `inte`=82, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=31); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=49, `agi`=70, `sta`=80, `inte`=84, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=32); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=50, `agi`=72, `sta`=83, `inte`=87, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=33); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=52, `sta`=86, `inte`=90, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=34); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=54, `sta`=88, `inte`=93, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=35); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=56, `agi`=80, `sta`=91, `inte`=96, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=36); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=57, `agi`=82, `sta`=94, `inte`=99, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=37); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=59, `agi`=85, `sta`=97, `inte`=102, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=38); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=61, `agi`=88, `sta`=101, `inte`=106, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=39); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=63, `agi`=91, `sta`=104, `inte`=109, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=40); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=66, `agi`=94, `sta`=108, `inte`=113, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=41); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=68, `agi`=97, `sta`=112, `inte`=117, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=42); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=70, `agi`=101, `sta`=116, `inte`=121, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=43); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=73, `agi`=104, `sta`=120, `inte`=126, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=44); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=75, `agi`=108, `sta`=124, `inte`=130, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=45); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=78, `agi`=112, `sta`=128, `inte`=135, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=46); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=81, `agi`=116, `sta`=133, `inte`=140, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=47); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=84, `agi`=120, `sta`=138, `inte`=145, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=48); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=90, `agi`=129, `sta`=148, `inte`=155, `VerifiedBuild`=38134 WHERE (`class`=5 AND `level`=50); -- PandarenAlliance Priest recalculated +UPDATE `player_classlevelstats` SET `str`=261, `agi`=373, `sta`=414, `inte`=450, `VerifiedBuild`=38556 WHERE (`class`=5 AND `level`=60); -- Undead Priest recalculated +UPDATE `player_classlevelstats` SET `sta`=148, `VerifiedBuild`=38134 WHERE (`class`=6 AND `level`=50); -- NightElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=6 AND `level`=60); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `str`=14, `agi`=34, `sta`=33, `inte`=38, `VerifiedBuild`=38134 WHERE (`class`=7 AND `level`=10); -- Vulpera Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=31, `agi`=72, `sta`=69, `inte`=72, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=27); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=32, `agi`=74, `sta`=71, `inte`=74, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=28); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=33, `agi`=77, `sta`=73, `inte`=77, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=29); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=34, `agi`=79, `sta`=75, `inte`=79, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=30); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=35, `agi`=82, `sta`=78, `inte`=82, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=31); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=36, `agi`=84, `sta`=80, `inte`=84, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=32); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=39, `sta`=86, `inte`=90, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=34); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=40, `sta`=88, `inte`=93, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=35); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=41, `agi`=96, `sta`=91, `inte`=96, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=36); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=43, `agi`=99, `sta`=94, `inte`=99, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=37); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=44, `agi`=102, `sta`=97, `inte`=102, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=38); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=46, `agi`=106, `sta`=101, `inte`=106, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=39); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=47, `agi`=109, `sta`=104, `inte`=109, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=40); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=49, `agi`=113, `sta`=108, `inte`=113, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=41); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=50, `agi`=117, `sta`=112, `inte`=117, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=42); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=52, `agi`=121, `sta`=116, `inte`=121, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=43); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=54, `agi`=126, `sta`=120, `inte`=126, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=44); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=56, `agi`=130, `sta`=124, `inte`=130, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=45); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=60, `agi`=140, `sta`=133, `inte`=140, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=47); -- Orc Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=193, `agi`=450, `sta`=414, `inte`=450, `VerifiedBuild`=38556 WHERE (`class`=7 AND `level`=60); -- Orc Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=15, `agi`=23, `sta`=33, `inte`=38, `VerifiedBuild`=38134 WHERE (`class`=8 AND `level`=10); -- Nightborne Mage recalculated +UPDATE `player_classlevelstats` SET `str`=68, `agi`=106, `sta`=148, `inte`=155, `VerifiedBuild`=38134 WHERE (`class`=8 AND `level`=50); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=198, `agi`=306, `sta`=414, `inte`=450, `VerifiedBuild`=38556 WHERE (`class`=8 AND `level`=60); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=9 AND `level`=10); -- VoidElf Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=9 AND `level`=48); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=9 AND `level`=50); -- Troll Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=9 AND `level`=51); -- Human Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=9 AND `level`=52); -- Human Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=9 AND `level`=53); -- Human Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=9 AND `level`=54); -- Human Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=9 AND `level`=56); -- Human Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=9 AND `level`=57); -- Human Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=9 AND `level`=58); -- Human Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=9 AND `level`=59); -- Human Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=9 AND `level`=60); -- Human Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=10 AND `level`=10); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=10 AND `level`=11); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37864 WHERE (`class`=10 AND `level`=50); -- HighmountainTauren Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=10 AND `level`=60); -- PandarenHorde Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=11 AND `level`=1); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `sta`=36, `VerifiedBuild`=38134 WHERE (`class`=11 AND `level`=10); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `sta`=50, `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=17); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=18); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=19); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=20); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=21); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=22); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=23); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=24); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=25); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=26); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=27); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=28); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=29); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=11 AND `level`=30); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=31); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=32); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=33); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=34); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=35); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=36); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=37); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=38); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=39); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=40); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=41); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=42); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=43); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=44); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=45); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=46); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=47); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=48); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=49); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=50); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=51); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=52); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=53); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=54); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=55); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=56); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=57); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=58); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=11 AND `level`=59); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37864 WHERE (`class`=11 AND `level`=60); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=12 AND `level`=45); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=37988 WHERE (`class`=12 AND `level`=46); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=12 AND `level`=47); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=12 AND `level`=48); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=12 AND `level`=49); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38134 WHERE (`class`=12 AND `level`=50); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=38556 WHERE (`class`=12 AND `level`=60); -- BloodElf DemonHunter recalculated diff --git a/sql/updates/world/master/2022_02_16_03_world_910.sql b/sql/updates/world/master/2022_02_16_03_world_910.sql new file mode 100644 index 00000000000..2a9c2a41359 --- /dev/null +++ b/sql/updates/world/master/2022_02_16_03_world_910.sql @@ -0,0 +1,282 @@ +-- +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=1); -- Orc Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=10); -- VoidElf Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=11); -- LightforgedDraenei Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=12); -- LightforgedDraenei Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=13); -- LightforgedDraenei Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=14); -- LightforgedDraenei Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=15); -- LightforgedDraenei Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=16); -- LightforgedDraenei Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=17); -- LightforgedDraenei Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=18); -- LightforgedDraenei Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=19); -- LightforgedDraenei Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=20); -- LightforgedDraenei Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=46); -- HighmountainTauren Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=1 AND `level`=60); -- Orc Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40593 WHERE (`class`=2 AND `level`=1); -- Human Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=2 AND `level`=10); -- DarkIronDwarf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=2 AND `level`=50); -- LightforgedDraenei Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=2 AND `level`=51); -- LightforgedDraenei Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=2 AND `level`=52); -- LightforgedDraenei Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=2 AND `level`=53); -- LightforgedDraenei Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=2 AND `level`=54); -- LightforgedDraenei Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=2 AND `level`=55); -- LightforgedDraenei Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=2 AND `level`=56); -- LightforgedDraenei Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=2 AND `level`=57); -- LightforgedDraenei Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=2 AND `level`=58); -- LightforgedDraenei Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=2 AND `level`=59); -- LightforgedDraenei Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=2 AND `level`=60); -- LightforgedDraenei Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39653 WHERE (`class`=3 AND `level`=7); -- NightElf Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=1); -- Undead Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=2); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=3); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=4); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=5); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=6); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=7); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=8); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=9); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=10); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=11); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=12); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=13); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=14); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=15); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=16); -- Worgen Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40593 WHERE (`class`=3 AND `level`=17); -- Goblin Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40593 WHERE (`class`=3 AND `level`=18); -- Goblin Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40725 WHERE (`class`=3 AND `level`=55); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=3 AND `level`=60); -- Dwarf Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=1); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=2); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=3); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=4); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=5); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=6); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=7); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=8); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=9); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=10); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=11); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=12); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=13); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=14); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=4 AND `level`=15); -- PandarenNeutral Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39498 WHERE (`class`=4 AND `level`=50); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=4 AND `level`=60); -- BloodElf Rogue recalculated +UPDATE `player_classlevelstats` SET `str`=19, `agi`=28, `sta`=36, `inte`=38, `VerifiedBuild`=40120 WHERE (`class`=5 AND `level`=10); -- ZandalariTroll Priest recalculated +UPDATE `player_classlevelstats` SET `str`=84, `agi`=120, `sta`=138, `inte`=145, `VerifiedBuild`=39335 WHERE (`class`=5 AND `level`=48); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=87, `agi`=124, `sta`=143, `inte`=150, `VerifiedBuild`=40443 WHERE (`class`=5 AND `level`=49); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `str`=90, `agi`=129, `sta`=148, `inte`=155, `VerifiedBuild`=40120 WHERE (`class`=5 AND `level`=50); -- NightElf Priest recalculated +UPDATE `player_classlevelstats` SET `str`=112, `agi`=160, `sta`=187, `inte`=193, `VerifiedBuild`=41079 WHERE (`class`=5 AND `level`=51); -- Human Priest recalculated +UPDATE `player_classlevelstats` SET `str`=120, `agi`=172, `sta`=204, `inte`=208, `VerifiedBuild`=41079 WHERE (`class`=5 AND `level`=52); -- Human Priest recalculated +UPDATE `player_classlevelstats` SET `str`=130, `agi`=186, `sta`=223, `inte`=224, `VerifiedBuild`=41079 WHERE (`class`=5 AND `level`=53); -- Human Priest recalculated +UPDATE `player_classlevelstats` SET `str`=140, `agi`=200, `sta`=244, `inte`=241, `VerifiedBuild`=41079 WHERE (`class`=5 AND `level`=54); -- Human Priest recalculated +UPDATE `player_classlevelstats` SET `str`=162, `agi`=232, `sta`=292, `inte`=280, `VerifiedBuild`=41359 WHERE (`class`=5 AND `level`=56); -- Human Priest recalculated +UPDATE `player_classlevelstats` SET `str`=173, `agi`=248, `sta`=317, `inte`=299, `VerifiedBuild`=41359 WHERE (`class`=5 AND `level`=57); -- Human Priest recalculated +UPDATE `player_classlevelstats` SET `str`=261, `agi`=373, `sta`=414, `inte`=450, `VerifiedBuild`=40120 WHERE (`class`=5 AND `level`=60); -- Undead Priest recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=8); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=9); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=10); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=11); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=12); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=13); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=14); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=15); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=16); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=17); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=18); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=19); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=20); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=21); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=22); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=23); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=24); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=25); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=26); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=27); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=28); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=29); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=30); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=31); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=32); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=33); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=34); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=35); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=36); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=37); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=38); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=39); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=40); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=41); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=42); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=43); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41288 WHERE (`class`=6 AND `level`=44); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41288 WHERE (`class`=6 AND `level`=45); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41323 WHERE (`class`=6 AND `level`=46); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41323 WHERE (`class`=6 AND `level`=47); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41323 WHERE (`class`=6 AND `level`=48); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41323 WHERE (`class`=6 AND `level`=49); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `sta`=148, `VerifiedBuild`=39653 WHERE (`class`=6 AND `level`=50); -- NightElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=6 AND `level`=60); -- Human DeathKnight recalculated +UPDATE `player_classlevelstats` SET `agi`=18, `sta`=15, `inte`=20, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=1); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `agi`=19, `sta`=17, `inte`=22, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=2); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `agi`=21, `sta`=19, `inte`=24, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=3); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `agi`=22, `sta`=21, `inte`=26, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=4); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=10, `agi`=24, `sta`=23, `inte`=28, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=5); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=11, `agi`=26, `sta`=25, `inte`=30, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=6); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=12, `agi`=28, `sta`=27, `inte`=32, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=7); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=13, `agi`=30, `sta`=28, `inte`=34, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=8); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=13, `agi`=31, `sta`=31, `inte`=36, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=9); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=14, `agi`=34, `sta`=33, `inte`=38, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=10); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=15, `agi`=36, `sta`=35, `inte`=40, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=11); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=17, `agi`=39, `sta`=37, `inte`=42, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=12); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=18, `agi`=43, `sta`=39, `inte`=44, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=13); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=20, `agi`=46, `sta`=41, `inte`=46, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=14); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=21, `agi`=48, `sta`=43, `inte`=48, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=15); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=22, `agi`=50, `sta`=46, `inte`=50, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=16); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=22, `agi`=52, `sta`=48, `inte`=52, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=17); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=23, `agi`=54, `sta`=50, `inte`=54, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=18); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=24, `agi`=56, `sta`=53, `inte`=56, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=19); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=25, `agi`=58, `sta`=55, `inte`=58, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=20); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=26, `agi`=60, `sta`=57, `inte`=60, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=21); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `agi`=62, `sta`=59, `inte`=62, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=22); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `agi`=64, `sta`=61, `inte`=64, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=23); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=28, `agi`=66, `sta`=63, `inte`=66, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=24); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=29, `agi`=68, `sta`=65, `inte`=68, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=25); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=30, `agi`=70, `sta`=67, `inte`=70, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=26); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=31, `agi`=72, `sta`=69, `inte`=72, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=27); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=32, `agi`=74, `sta`=71, `inte`=74, `VerifiedBuild`=39804 WHERE (`class`=7 AND `level`=28); -- Goblin Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=56, `agi`=130, `sta`=124, `inte`=130, `VerifiedBuild`=40120 WHERE (`class`=7 AND `level`=45); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=60, `agi`=140, `sta`=133, `inte`=140, `VerifiedBuild`=40120 WHERE (`class`=7 AND `level`=47); -- Orc Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=62, `agi`=145, `sta`=138, `inte`=145, `VerifiedBuild`=40120 WHERE (`class`=7 AND `level`=48); -- PandarenHorde Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=193, `agi`=450, `sta`=414, `inte`=450, `VerifiedBuild`=40120 WHERE (`class`=7 AND `level`=60); -- Orc Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=7, `agi`=12, `sta`=15, `inte`=20, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=1); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `agi`=13, `sta`=17, `inte`=22, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=2); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `agi`=14, `sta`=19, `inte`=24, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=3); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `agi`=15, `sta`=21, `inte`=26, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=4); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=10, `agi`=17, `sta`=23, `inte`=28, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=5); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=11, `agi`=18, `sta`=25, `inte`=30, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=6); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=12, `agi`=19, `sta`=27, `inte`=32, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=7); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=13, `agi`=20, `sta`=28, `inte`=34, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=8); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=14, `agi`=21, `sta`=31, `inte`=36, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=9); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=15, `agi`=23, `sta`=33, `inte`=38, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=10); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=16, `agi`=25, `sta`=35, `inte`=40, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=11); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=17, `agi`=27, `sta`=37, `inte`=42, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=12); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=19, `agi`=29, `sta`=39, `inte`=44, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=13); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=20, `agi`=31, `sta`=41, `inte`=46, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=14); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=21, `agi`=33, `sta`=43, `inte`=48, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=15); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=22, `agi`=34, `sta`=46, `inte`=50, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=16); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=23, `agi`=35, `sta`=48, `inte`=52, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=17); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=24, `agi`=37, `sta`=50, `inte`=54, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=18); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=25, `agi`=38, `sta`=53, `inte`=56, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=19); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=26, `agi`=39, `sta`=55, `inte`=58, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=20); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `agi`=41, `sta`=57, `inte`=60, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=21); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=27, `agi`=42, `sta`=59, `inte`=62, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=22); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=28, `agi`=44, `sta`=61, `inte`=64, `VerifiedBuild`=39653 WHERE (`class`=8 AND `level`=23); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=29, `agi`=45, `sta`=63, `inte`=66, `VerifiedBuild`=40120 WHERE (`class`=8 AND `level`=24); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=30, `agi`=46, `sta`=65, `inte`=68, `VerifiedBuild`=40120 WHERE (`class`=8 AND `level`=25); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=31, `agi`=48, `sta`=67, `inte`=70, `VerifiedBuild`=40120 WHERE (`class`=8 AND `level`=26); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=32, `agi`=49, `sta`=69, `inte`=72, `VerifiedBuild`=40120 WHERE (`class`=8 AND `level`=27); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=33, `sta`=71, `inte`=74, `VerifiedBuild`=40120 WHERE (`class`=8 AND `level`=28); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=34, `agi`=52, `sta`=73, `inte`=77, `VerifiedBuild`=40120 WHERE (`class`=8 AND `level`=29); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=35, `sta`=75, `inte`=79, `VerifiedBuild`=40120 WHERE (`class`=8 AND `level`=30); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=68, `agi`=106, `sta`=148, `inte`=155, `VerifiedBuild`=40000 WHERE (`class`=8 AND `level`=50); -- PandarenHorde Mage recalculated +UPDATE `player_classlevelstats` SET `str`=85, `agi`=131, `sta`=187, `inte`=193, `VerifiedBuild`=40000 WHERE (`class`=8 AND `level`=51); -- PandarenHorde Mage recalculated +UPDATE `player_classlevelstats` SET `str`=91, `agi`=141, `sta`=204, `inte`=208, `VerifiedBuild`=40725 WHERE (`class`=8 AND `level`=52); -- Gnome Mage recalculated +UPDATE `player_classlevelstats` SET `str`=140, `agi`=217, `sta`=343, `inte`=319, `VerifiedBuild`=41079 WHERE (`class`=8 AND `level`=58); -- Gnome Mage recalculated +UPDATE `player_classlevelstats` SET `str`=150, `agi`=231, `sta`=372, `inte`=340, `VerifiedBuild`=41079 WHERE (`class`=8 AND `level`=59); -- Gnome Mage recalculated +UPDATE `player_classlevelstats` SET `str`=198, `agi`=306, `sta`=414, `inte`=450, `VerifiedBuild`=41079 WHERE (`class`=8 AND `level`=60); -- Gnome Mage recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=10); -- Nightborne Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=1); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=2); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=3); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=4); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=5); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=6); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=7); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=8); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=9); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=10); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=11); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=13); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41323 WHERE (`class`=9 AND `level`=18); -- BloodElf Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=9 AND `level`=50); -- Troll Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=9 AND `level`=60); -- Troll Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=1); -- PandarenAlliance Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=2); -- PandarenAlliance Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=3); -- PandarenAlliance Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=4); -- PandarenAlliance Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=5); -- PandarenAlliance Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=6); -- PandarenAlliance Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=7); -- PandarenNeutral Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=8); -- PandarenNeutral Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=9); -- PandarenNeutral Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=10); -- PandarenNeutral Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=11); -- PandarenNeutral Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=12); -- PandarenNeutral Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=13); -- PandarenNeutral Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=14); -- PandarenNeutral Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=15); -- PandarenNeutral Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=16); -- PandarenHorde Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=17); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=18); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=19); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=20); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=21); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=22); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=23); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=24); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=25); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=26); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=27); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=28); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=29); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=30); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=31); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39427 WHERE (`class`=10 AND `level`=32); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39427 WHERE (`class`=10 AND `level`=33); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39427 WHERE (`class`=10 AND `level`=34); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39427 WHERE (`class`=10 AND `level`=35); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39427 WHERE (`class`=10 AND `level`=36); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39427 WHERE (`class`=10 AND `level`=37); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39427 WHERE (`class`=10 AND `level`=38); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39427 WHERE (`class`=10 AND `level`=39); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39427 WHERE (`class`=10 AND `level`=40); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39427 WHERE (`class`=10 AND `level`=41); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39427 WHERE (`class`=10 AND `level`=42); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39427 WHERE (`class`=10 AND `level`=43); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39497 WHERE (`class`=10 AND `level`=44); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39497 WHERE (`class`=10 AND `level`=45); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39497 WHERE (`class`=10 AND `level`=46); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=10 AND `level`=50); -- HighmountainTauren Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=10 AND `level`=60); -- PandarenHorde Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=11 AND `level`=1); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=11 AND `level`=2); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=11 AND `level`=3); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `sta`=36, `VerifiedBuild`=39427 WHERE (`class`=11 AND `level`=10); -- ZandalariTroll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=11 AND `level`=30); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=11 AND `level`=50); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39653 WHERE (`class`=11 AND `level`=51); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=11 AND `level`=52); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=11 AND `level`=54); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=11 AND `level`=55); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=11 AND `level`=56); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40000 WHERE (`class`=11 AND `level`=58); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39804 WHERE (`class`=11 AND `level`=59); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39229 WHERE (`class`=11 AND `level`=60); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=12 AND `level`=8); -- NightElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=12 AND `level`=45); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39335 WHERE (`class`=12 AND `level`=46); -- NightElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39229 WHERE (`class`=12 AND `level`=50); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39229 WHERE (`class`=12 AND `level`=51); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39262 WHERE (`class`=12 AND `level`=52); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39262 WHERE (`class`=12 AND `level`=53); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=39262 WHERE (`class`=12 AND `level`=54); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=12 AND `level`=55); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40593 WHERE (`class`=12 AND `level`=56); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40593 WHERE (`class`=12 AND `level`=57); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40593 WHERE (`class`=12 AND `level`=58); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40593 WHERE (`class`=12 AND `level`=59); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40120 WHERE (`class`=12 AND `level`=60); -- BloodElf DemonHunter recalculated + diff --git a/sql/updates/world/master/2022_02_16_04_world_915.sql b/sql/updates/world/master/2022_02_16_04_world_915.sql new file mode 100644 index 00000000000..1d505f47752 --- /dev/null +++ b/sql/updates/world/master/2022_02_16_04_world_915.sql @@ -0,0 +1,50 @@ +-- +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=1 AND `level`=1); -- Human Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40906 WHERE (`class`=1 AND `level`=10); -- MagharOrc Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41031 WHERE (`class`=1 AND `level`=46); -- HighmountainTauren Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41488 WHERE (`class`=1 AND `level`=47); -- HighmountainTauren Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=1 AND `level`=50); -- Human Warrior recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40871 WHERE (`class`=2 AND `level`=60); -- BloodElf Paladin recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=3 AND `level`=1); -- Dwarf Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=3 AND `level`=2); -- Dwarf Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40906 WHERE (`class`=3 AND `level`=10); -- HighmountainTauren Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40871 WHERE (`class`=3 AND `level`=55); -- Orc Hunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=4 AND `level`=1); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41488 WHERE (`class`=4 AND `level`=2); -- Troll Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40906 WHERE (`class`=4 AND `level`=10); -- Vulpera Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=4 AND `level`=11); -- Vulpera Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=4 AND `level`=12); -- Vulpera Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=4 AND `level`=13); -- Vulpera Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=4 AND `level`=14); -- Vulpera Rogue recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41031 WHERE (`class`=4 AND `level`=50); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `str`=87, `agi`=124, `sta`=143, `inte`=150, `VerifiedBuild`=40966 WHERE (`class`=5 AND `level`=49); -- Goblin Priest recalculated +UPDATE `player_classlevelstats` SET `sta`=148, `VerifiedBuild`=41031 WHERE (`class`=6 AND `level`=50); -- NightElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40906 WHERE (`class`=6 AND `level`=60); -- BloodElf DeathKnight recalculated +UPDATE `player_classlevelstats` SET `agi`=18, `sta`=15, `inte`=20, `VerifiedBuild`=41079 WHERE (`class`=7 AND `level`=1); -- Dwarf Shaman recalculated +UPDATE `player_classlevelstats` SET `agi`=19, `sta`=17, `inte`=22, `VerifiedBuild`=41079 WHERE (`class`=7 AND `level`=2); -- Dwarf Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=14, `agi`=34, `sta`=33, `inte`=38, `VerifiedBuild`=41079 WHERE (`class`=7 AND `level`=10); -- MagharOrc Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=56, `agi`=130, `sta`=124, `inte`=130, `VerifiedBuild`=41031 WHERE (`class`=7 AND `level`=45); -- ZandalariTroll Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=60, `agi`=140, `sta`=133, `inte`=140, `VerifiedBuild`=41031 WHERE (`class`=7 AND `level`=47); -- Orc Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=62, `agi`=145, `sta`=138, `inte`=145, `VerifiedBuild`=41031 WHERE (`class`=7 AND `level`=48); -- Orc Shaman recalculated +UPDATE `player_classlevelstats` SET `str`=15, `agi`=23, `sta`=33, `inte`=38, `VerifiedBuild`=40906 WHERE (`class`=8 AND `level`=10); -- Nightborne Mage recalculated +UPDATE `player_classlevelstats` SET `str`=68, `agi`=106, `sta`=148, `inte`=155, `VerifiedBuild`=40906 WHERE (`class`=8 AND `level`=50); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=85, `agi`=131, `sta`=187, `inte`=193, `VerifiedBuild`=40906 WHERE (`class`=8 AND `level`=51); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41359 WHERE (`class`=9 AND `level`=1); -- Undead Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41031 WHERE (`class`=9 AND `level`=50); -- Troll Warlock recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40906 WHERE (`class`=10 AND `level`=50); -- HighmountainTauren Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40906 WHERE (`class`=10 AND `level`=60); -- PandarenHorde Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=11 AND `level`=1); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41079 WHERE (`class`=11 AND `level`=2); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41359 WHERE (`class`=11 AND `level`=3); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41488 WHERE (`class`=11 AND `level`=4); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `sta`=27, `VerifiedBuild`=41488 WHERE (`class`=11 AND `level`=5); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41488 WHERE (`class`=11 AND `level`=6); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41488 WHERE (`class`=11 AND `level`=7); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `sta`=36, `VerifiedBuild`=41488 WHERE (`class`=11 AND `level`=10); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41359 WHERE (`class`=11 AND `level`=45); -- HighmountainTauren Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40906 WHERE (`class`=11 AND `level`=59); -- Troll Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40871 WHERE (`class`=11 AND `level`=60); -- NightElf Druid recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41031 WHERE (`class`=12 AND `level`=45); -- BloodElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=40906 WHERE (`class`=12 AND `level`=46); -- NightElf DemonHunter recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=41031 WHERE (`class`=12 AND `level`=60); -- BloodElf DemonHunter recalculated + |