diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2017-11-06 10:36:21 +0100 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-01-29 19:23:53 +0100 |
| commit | 6f11d3c2c2aeecd7ad43887eedfaad3cd21ee1ab (patch) | |
| tree | f3f1b0507630dc27f76b99ecb0fea29ce81d0e9b | |
| parent | ddd0f68ef18f2c5bb671bb83b75f2a12a97fd94f (diff) | |
DB/Creature: Fix levels for multiple creatures
By Malcrom
(cherry picked from commit 761b050263d2ec99e6f2dccdf2daec116082e96d)
| -rw-r--r-- | sql/updates/world/master/2021_01_25_04_world_2017_11_06_00_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_25_04_world_2017_11_06_00_world.sql b/sql/updates/world/master/2021_01_25_04_world_2017_11_06_00_world.sql new file mode 100644 index 00000000000..90e36b54455 --- /dev/null +++ b/sql/updates/world/master/2021_01_25_04_world_2017_11_06_00_world.sql @@ -0,0 +1,16 @@ +-- Mana Tombs Instance +-- UPDATE `creature_template` SET `exp`=2 WHERE `entry` IN (22930); +-- Hillsbrad Foothills Instance +UPDATE `creature_template` SET `maxlevel`=67 WHERE `entry` IN (17819); +UPDATE `creature_template` SET `minlevel`=67 WHERE `entry` IN (18170,18171,18172); +UPDATE `creature_template` SET `minlevel`=69 WHERE `entry` IN (20528,20537,20538,20543); +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry` IN (20526); +UPDATE `creature_template` SET `minlevel`=71 WHERE `entry` IN (20533,20534,20546,20547); +UPDATE `creature_template` SET `minlevel`=69, `maxlevel`=69 WHERE `entry` IN (20524,20541); +UPDATE `creature_template` SET `minlevel`=71, `maxlevel`=71 WHERE `entry` IN (20525,20529,20548); +-- Sethekk Halls Heroic +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry` IN (20692); -- Sethekk Guard (1) +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry` IN (20686); -- Avian Darkhawk (1) +UPDATE `creature_template` SET `minlevel`=71 WHERE `entry` IN (20572); -- Sethekk Prophet (1) +UPDATE `creature_template` SET `minlevel`=71 WHERE `entry` IN (20697); -- Time-Lost Scryer (1) +UPDATE `creature_template` SET `minlevel`=71 WHERE `entry` IN (20701); -- Sethekk Talon Lord (1) |