diff options
| author | Ovahlord <dreadkiller@gmx.de> | 2025-01-18 23:22:04 +0100 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2025-01-18 23:22:04 +0100 |
| commit | 32bd6e58f7114a1b38fd889a530584c735b7c8f4 (patch) | |
| tree | b25aaa6eb197a92087d81d9ae151770326630490 /sql | |
| parent | e36a66d6322f51a201bb394a9fd4b7943cdd805f (diff) | |
DB/Creatures: corrected armor and attack power values for UNIT_CLASS_WARRIOR creatures between level 1 and 5
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/cata_classic/2025_01_18_00_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2025_01_18_00_world.sql b/sql/updates/world/cata_classic/2025_01_18_00_world.sql new file mode 100644 index 00000000000..4cbf125989b --- /dev/null +++ b/sql/updates/world/cata_classic/2025_01_18_00_world.sql @@ -0,0 +1,5 @@ +UPDATE `creature_classlevelstats` SET `basearmor`= 0, `attackpower`= 24, `rangedattackpower`= 0, `comment`= 'Sniff validated in 4.4.1' WHERE `level`= 1 AND `class`= 1; +UPDATE `creature_classlevelstats` SET `basearmor`= 0, `attackpower`= 26, `rangedattackpower`= 0, `comment`= 'Sniff validated in 4.4.1' WHERE `level`= 2 AND `class`= 1; +UPDATE `creature_classlevelstats` SET `basearmor`= 25, `attackpower`= 28, `rangedattackpower`= 0, `comment`= 'Sniff validated in 4.4.1' WHERE `level`= 3 AND `class`= 1; +UPDATE `creature_classlevelstats` SET `basearmor`= 60, `attackpower`= 30, `rangedattackpower`= 0, `comment`= 'Sniff validated in 4.4.1' WHERE `level`= 4 AND `class`= 1; +UPDATE `creature_classlevelstats` SET `basearmor`= 103, `attackpower`= 32, `rangedattackpower`= 0, `comment`= 'Sniff validated in 4.4.1' WHERE `level`= 5 AND `class`= 1; |