diff options
| author | offl <offl@users.noreply.github.com> | 2020-09-29 03:07:21 +0300 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2020-09-29 03:07:21 +0300 |
| commit | f4ca28f1617ea801691ed4d5fb145c4ff0b68b91 (patch) | |
| tree | b6498708d7ac66b63092faab07123eb8f09f5092 | |
| parent | 954790862471b102b232a71f58fd684439f121fb (diff) | |
DB/Instance/Mana Tombs: Fix stats for all creatures
| -rw-r--r-- | sql/updates/world/3.3.5/2020_09_29_02_world.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_09_29_02_world.sql b/sql/updates/world/3.3.5/2020_09_29_02_world.sql new file mode 100644 index 00000000000..359df09f72b --- /dev/null +++ b/sql/updates/world/3.3.5/2020_09_29_02_world.sql @@ -0,0 +1,20 @@ +-- +UPDATE `creature_template` SET `speed_walk` = 1, `speed_run` = 0.71428 WHERE `entry` = 18429; -- Arcane Fiend +UPDATE `creature_template` SET `maxlevel` = 70, `speed_walk` = 1, `speed_run` = 0.71428 WHERE `entry` = 20252; -- Arcane Fiend (1) +UPDATE `creature_template` SET `speed_walk` = 1 WHERE `entry` = 20253; -- Ethereal Apprentice (1) +UPDATE `creature_template` SET `maxlevel` = 70, `speed_walk` = 4, `speed_run` = 1.42857 WHERE `entry` = 20254; -- Ethereal Beacon (1) +UPDATE `creature_template` SET `speed_walk` = 1 WHERE `entry` = 20255; -- Ethereal Crypt Raider (1) +UPDATE `creature_template` SET `speed_walk` = 1 WHERE `entry` = 20256; -- Ethereal Darkcaster (1) +UPDATE `creature_template` SET `minlevel` = 70, `speed_walk` = 1 WHERE `entry` = 20257; -- Ethereal Priest (1) +UPDATE `creature_template` SET `speed_walk` = 1 WHERE `entry` = 20258; -- Ethereal Scavenger (1) +UPDATE `creature_template` SET `minlevel` = 70, `speed_walk` = 1 WHERE `entry` = 20259; -- Ethereal Sorcerer (1) +UPDATE `creature_template` SET `minlevel` = 71, `speed_walk` = 1 WHERE `entry` = 20260; -- Ethereal Spellbinder (1) +UPDATE `creature_template` SET `speed_walk` = 1 WHERE `entry` = 20261; -- Ethereal Theurgist (1) +UPDATE `creature_template` SET `minlevel` = 63, `maxlevel` = 63, `speed_walk` = 1, `speed_run` = 0.85714 WHERE `entry` = 18394; -- Ethereal Wraith +UPDATE `creature_template` SET `minlevel` = 69, `maxlevel` = 69, `speed_walk` = 1, `speed_run` = 0.85714 WHERE `entry` = 20262; -- Ethereal Wraith (1) +UPDATE `creature_template` SET `speed_walk` = 1, `speed_run` = 0.85714 WHERE `entry` = 20263; -- Mana Leech (1) +UPDATE `creature_template` SET `minlevel` = 71, `speed_walk` = 1 WHERE `entry` = 20264; -- Nexus Stalker (1) +UPDATE `creature_template` SET `speed_walk` = 1, `speed_run` = 0.99206 WHERE `entry` = 20265; -- Nexus Terror (1) +UPDATE `creature_template` SET `speed_walk` = 1 WHERE `entry` = 20266; -- Nexus-Prince Shaffar (1) +UPDATE `creature_template` SET `speed_walk` = 1 WHERE `entry` = 20267; -- Pandemonius (1) +UPDATE `creature_template` SET `speed_walk` = 1 WHERE `entry` = 20268; -- Tavarok (1) |