diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2017-11-06 18:55:02 +0100 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-01-29 19:23:53 +0100 |
| commit | 69d6b4241d8d9c49c135aec3a50fdafcca250a5f (patch) | |
| tree | cc72b54e6117cc40241a8278721c16054b85f6f0 | |
| parent | 6f11d3c2c2aeecd7ad43887eedfaad3cd21ee1ab (diff) | |
DB/Creature: Fix levels for multiple creatures
By Malcrom
(cherry picked from commit d7de84b0277699fa12776864906e393f414aee08)
| -rw-r--r-- | sql/updates/world/master/2021_01_25_05_world_2017_11_06_01_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_25_05_world_2017_11_06_01_world.sql b/sql/updates/world/master/2021_01_25_05_world_2017_11_06_01_world.sql new file mode 100644 index 00000000000..d8b48885c22 --- /dev/null +++ b/sql/updates/world/master/2021_01_25_05_world_2017_11_06_01_world.sql @@ -0,0 +1,13 @@ +-- Auchenai Crypts +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry` IN (20299); -- Auchenai Monk (1) +UPDATE `creature_template` SET `minlevel`=71 WHERE `entry` IN (20315); -- Raging Skeleton (1) +UPDATE `creature_template` SET `minlevel`=71 WHERE `entry` IN (20300); -- Auchenai Necromancer (1) + +-- Shadow Labyrinth +-- UPDATE `creature_template` SET `exp`=0 WHERE `entry` IN (18797); -- Tortured Skeleton +UPDATE `creature_template` SET `minlevel`=70,`maxlevel`=71 WHERE `entry` IN (20641); -- Cabal Deathsworn (1) +UPDATE `creature_template` SET `maxlevel`=70 WHERE `entry` IN (20638); -- Cabal Acolyte (1) +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry` IN (20645); -- Cabal Ritualist (1) + +-- Fix Stats error +-- UPDATE `creature_classlevelstats` SET `basehp0`=3635 WHERE `level`=66 AND `class` IN (1,4); |