aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-06-18 23:38:55 +0200
committerShauren <shauren.trinity@gmail.com>2022-01-06 22:47:48 +0100
commit972f3dc40d485b861087c263d0ffe27e962de5fb (patch)
treed1c8dd3e7ef4dfbb5c538063de2ef9726416a349
parent34f3c18d7e085b6f9efb573ae6b09a12af737e14 (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.sql44
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