diff options
| author | offl <offl@users.noreply.github.com> | 2020-06-18 23:38:55 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2020-06-18 23:38:55 +0200 |
| commit | d9d314a89e6f3dba1f6c751fff1f49690eeb0fdd (patch) | |
| tree | 56c1f8fe4d65ab303e3174100e5d7698a28bb7e8 | |
| parent | 04ee18e198c7466873c252cf93dab570c665bb40 (diff) | |
DB/Creature: Update some creatures stats
Closes #24787
| -rw-r--r-- | sql/updates/world/3.3.5/2020_06_18_03_world_335.sql | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_06_18_03_world_335.sql b/sql/updates/world/3.3.5/2020_06_18_03_world_335.sql new file mode 100644 index 00000000000..4bf63c5b23e --- /dev/null +++ b/sql/updates/world/3.3.5/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 |