diff options
| author | ModoX <moardox@gmail.com> | 2022-12-27 16:03:09 +0100 |
|---|---|---|
| committer | ModoX <moardox@gmail.com> | 2022-12-27 16:03:09 +0100 |
| commit | 8e6842b8b6c12a1a7537909ceea386a215250b89 (patch) | |
| tree | 09bf2fce4fa46b93d08512ed3e03eebe1a4ba341 /sql | |
| parent | f548c4016c04838ecf123464a0d20285043d45cd (diff) | |
DB/Player: Added missing class stats for dh 69-70
* lvl 50 rogue
* lvl 51 mage
* lvl 45 monk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_12_27_00_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
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); + |