From 8e6842b8b6c12a1a7537909ceea386a215250b89 Mon Sep 17 00:00:00 2001 From: ModoX Date: Tue, 27 Dec 2022 16:03:09 +0100 Subject: DB/Player: Added missing class stats for dh 69-70 * lvl 50 rogue * lvl 51 mage * lvl 45 monk --- sql/updates/world/master/2022_12_27_00_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/master/2022_12_27_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_12_27_00_world.sql b/sql/updates/world/master/2022_12_27_00_world.sql new file mode 100644 index 00000000000..36c03a5598a --- /dev/null +++ b/sql/updates/world/master/2022_12_27_00_world.sql @@ -0,0 +1,14 @@ +-- +DELETE FROM `player_classlevelstats` WHERE (`class`=12 AND `level` IN (69,70)); +INSERT INTO `player_classlevelstats` (`class`, `level`, `str`, `agi`, `sta`, `inte`, `VerifiedBuild`) VALUES +(12, 69, 1580, 1903, 3038, 1294, 47213), -- BloodElf DemonHunter recalculated +(12, 70, 1734, 2089, 3463, 1421, 47213); -- BloodElf DemonHunter recalculated + +UPDATE `player_classlevelstats` SET `str`=202, `agi`=243, `sta`=224, `inte`=165, `VerifiedBuild`=47213 WHERE (`class`=4 AND `level`=50); -- Undead Rogue recalculated +UPDATE `player_classlevelstats` SET `str`=114, `agi`=176, `sta`=238, `inte`=258, `VerifiedBuild`=47213 WHERE (`class`=8 AND `level`=51); -- Troll Mage recalculated +UPDATE `player_classlevelstats` SET `str`=84, `agi`=195, `sta`=180, `inte`=195, `VerifiedBuild`=47213 WHERE (`class`=10 AND `level`=46); -- Vulpera Monk recalculated +UPDATE `player_classlevelstats` SET `VerifiedBuild`=47213 WHERE (`class`=12 AND `level`=65); +UPDATE `player_classlevelstats` SET `VerifiedBuild`=47213 WHERE (`class`=12 AND `level`=66); +UPDATE `player_classlevelstats` SET `VerifiedBuild`=47213 WHERE (`class`=12 AND `level`=67); +UPDATE `player_classlevelstats` SET `VerifiedBuild`=47213 WHERE (`class`=12 AND `level`=68); + -- cgit v1.2.3