diff options
author | offl <offl@users.noreply.github.com> | 2020-06-18 23:38:55 +0200 |
---|---|---|
committer | Shauren <shauren.trinity@gmail.com> | 2022-01-06 22:47:48 +0100 |
commit | 972f3dc40d485b861087c263d0ffe27e962de5fb (patch) | |
tree | d1c8dd3e7ef4dfbb5c538063de2ef9726416a349 | |
parent | 34f3c18d7e085b6f9efb573ae6b09a12af737e14 (diff) |
DB/Creature: Update some creatures stats
Closes #24787
(cherry picked from commit d9d314a89e6f3dba1f6c751fff1f49690eeb0fdd)
-rw-r--r-- | sql/updates/world/master/2022_01_06_65_world_2020_06_18_03_world_335.sql | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_06_65_world_2020_06_18_03_world_335.sql b/sql/updates/world/master/2022_01_06_65_world_2020_06_18_03_world_335.sql new file mode 100644 index 00000000000..caea7dae7c2 --- /dev/null +++ b/sql/updates/world/master/2022_01_06_65_world_2020_06_18_03_world_335.sql @@ -0,0 +1,44 @@ +-- +UPDATE `creature_template` SET /*`minlevel`=5, `maxlevel`=5,*/ `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=15087; -- Forsaken Stablehand +UPDATE `creature_template` SET /*`maxlevel`=2,*/ `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=15108; -- Forsaken Horse +UPDATE `creature_template` SET `RangeAttackTime`=2000 WHERE `entry`=5677; -- Summoned Succubus +UPDATE `creature_template` SET /*`minlevel`=5, `maxlevel`=5,*/ `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=15074; -- Arathi Miner +UPDATE `creature_template` SET /*`minlevel`=5, `maxlevel`=5,*/ `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=15045; -- Arathi Farmer +UPDATE `creature_template` SET `RangeAttackTime`=2000 WHERE `entry`=5676; -- Summoned Voidwalker +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=768 WHERE `entry`=19412; -- D'ore +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32832 WHERE `entry`=18373; -- Exarch Maladaar +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32832 WHERE `entry`=18702; -- Auchenai Necromancer +UPDATE `creature_template` SET `RangeAttackTime`=2000 WHERE `entry`=18700; -- Reanimated Bones +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32832 WHERE `entry`=18524; -- Angered Skeleton +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32768 WHERE `entry`=18557; -- Phasing Cleric +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32832 WHERE `entry`=18521; -- Raging Skeleton +UPDATE `creature_template` SET `RangeAttackTime`=2000 WHERE `entry`=18506; -- Raging Soul +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32768 WHERE `entry`=18559; -- Phasing Stalker +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32768 WHERE `entry`=18556; -- Phasing Soldier +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32832 WHERE `entry`=18493; -- Auchenai Soulpriest +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32768 WHERE `entry`=18558; -- Phasing Sorcerer +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=18371; -- Shirrak the Dead Watcher +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32832 WHERE `entry`=18497; -- Auchenai Monk +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33555200 WHERE `entry`=18726; -- Flying Raging Soul +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33554688 WHERE `entry`=18778; -- Cosmetic Raging Soul +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32832 WHERE `entry`=18495; -- Auchenai Vindicator +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=18473; -- Talon King Ikiss +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=21904; -- Avian Warhawk +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=18321; -- Sethekk Talon Lord +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=18326; -- Sethekk Shaman +UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=19428; -- Cobalt Serpent +UPDATE `creature_template` SET `RangeAttackTime`=2000 WHERE `entry`=21891; -- Avian Ripper +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=18322; -- Sethekk Ravenguard +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=18320; -- Time-Lost Shadowmage +UPDATE `creature_template` SET `RangeAttackTime`=2000 WHERE `entry`=19416; -- Ancient Draenei Spirit +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33536 WHERE `entry`=19698; -- Greatfather Aldrimus +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33536 WHERE `entry`=19879; -- Horvon the Armorer +UPDATE `creature_template` SET /*`minlevel`=5, `maxlevel`=5,*/ `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=15089; -- Forsaken Lumberjack +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=768 WHERE `entry`=15071; -- Underfoot +UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=768 WHERE `entry`=15072; -- Spike +UPDATE `creature_template` SET /*`minlevel`=5, `maxlevel`=5,*/ `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=15064; -- Forsaken Blacksmith +UPDATE `creature_template` SET /*`minlevel`=5, `maxlevel`=5,*/ `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=15046; -- Forsaken Farmer +UPDATE `creature_template` SET /*`minlevel`=5, `maxlevel`=5,*/ `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=15062; -- Arathi Lumberjack +UPDATE `creature_template` SET /*`minlevel`=5, `maxlevel`=5,*/ `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=15075; -- Forsaken Miner +UPDATE `creature_template` SET /*`minlevel`=5, `maxlevel`=5,*/ `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=15086; -- Arathi Stablehand +UPDATE `creature_template` SET /*`minlevel`=5, `maxlevel`=5,*/ `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=15107; -- Arathi Horse |