diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2017-11-06 10:36:21 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-11-06 10:36:21 +0100 |
| commit | 761b050263d2ec99e6f2dccdf2daec116082e96d (patch) | |
| tree | 24aeacfec16e17d0e1548cbd8b2c0046a362306a | |
| parent | 48958d9e30cdf2308c7c060bec560550adf093c5 (diff) | |
DB/Creature: Fix levels for multiple creatures
By Malcrom
| -rw-r--r-- | sql/updates/world/3.3.5/2017_11_06_00_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_11_06_00_world.sql b/sql/updates/world/3.3.5/2017_11_06_00_world.sql new file mode 100644 index 00000000000..972a1b748e7 --- /dev/null +++ b/sql/updates/world/3.3.5/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) |