DB/Creature: Update stats of some creatures

(cherry picked from commit fd6c89219ad44b9be868f237868e795d96318e89)

1 files changed, 138 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_06_58_world_2021_02_18_01_world.sql b/sql/updates/world/master/2022_03_06_58_world_2021_02_18_01_world.sql
new file mode 100644
index 00000000000..48db4d36eff
--- /dev/null
+++ b/sql/updates/world/master/2022_03_06_58_world_2021_02_18_01_world.sql
@@ -0,0 +1,138 @@
+--
+UPDATE `creature_model_info` SET `BoundingRadius`=1.5, `CombatReach`=2.25 WHERE `DisplayID`=15329;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.5, `CombatReach`=2.25 WHERE `DisplayID`=19894;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.149999976158142089, `CombatReach`=1.724999904632568359 WHERE `DisplayID`=7618;
+UPDATE `creature_model_info` SET `BoundingRadius`=3.800999879837036132, `CombatReach`=3.75 WHERE `DisplayID`=28718;
+UPDATE `creature_model_info` SET `BoundingRadius`=4.434499740600585937, `CombatReach`=4.375 WHERE `DisplayID`=28725;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.5, `CombatReach`=1.5 WHERE `DisplayID`=20628;
+UPDATE `creature_model_info` SET `BoundingRadius`=2, `CombatReach`=1.5 WHERE `DisplayID`=25082;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.465000003576278686, `CombatReach`=3 WHERE `DisplayID`=22254;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.349999994039535522, `CombatReach`=2.5 WHERE `DisplayID`=28506;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.035000000149011611, `CombatReach`=0.150000005960464477 WHERE `DisplayID`=4732;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.5, `CombatReach`=2.25 WHERE `DisplayID`=29768;
+UPDATE `creature_model_info` SET `BoundingRadius`=4.27500009536743164, `CombatReach`=1.5 WHERE `DisplayID`=26876;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.305999994277954101, `CombatReach`=1.5 WHERE `DisplayID`=3946;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.476000010967254638, `CombatReach`=1.5 WHERE `DisplayID`=1225;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.649999976158142089, `CombatReach`=1.299999952316284179 WHERE `DisplayID`=19704;
+UPDATE `creature_model_info` SET `BoundingRadius`=3, `CombatReach`=5.73600006103515625 WHERE `DisplayID`=15655;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.388999998569488525, `CombatReach`=1.5 WHERE `DisplayID`=15692;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.388999998569488525, `CombatReach`=1.5 WHERE `DisplayID`=15690;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.762499928474426269, `CombatReach`=1.25 WHERE `DisplayID`=18351;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.283200025558471679, `CombatReach`=1.80000007152557373 WHERE `DisplayID`=12022;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.458999991416931152, `CombatReach`=2.25 WHERE `DisplayID`=14304;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.283200025558471679, `CombatReach`=1.80000007152557373 WHERE `DisplayID`=14295;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.458999991416931152, `CombatReach`=2.25 WHERE `DisplayID`=14302;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.458999991416931152, `CombatReach`=2.25 WHERE `DisplayID`=14303;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.283200025558471679, `CombatReach`=1.80000007152557373 WHERE `DisplayID`=14294;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.306799978017807006, `CombatReach`=1.949999928474426269 WHERE `DisplayID`=14300;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.446400016546249389, `CombatReach`=1.80000007152557373 WHERE `DisplayID`=12025;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.483599990606307983, `CombatReach`=1.949999928474426269 WHERE `DisplayID`=11969;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.306799978017807006, `CombatReach`=1.949999928474426269 WHERE `DisplayID`=14301;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.305999994277954101, `CombatReach`=1.5 WHERE `DisplayID`=25184;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.305999994277954101, `CombatReach`=1.5 WHERE `DisplayID`=25183;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.305999994277954101, `CombatReach`=1.5 WHERE `DisplayID`=25182;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.270000010728836059, `CombatReach`=0.899999976158142089 WHERE `DisplayID`=31174;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.060000002384185791, `CombatReach`=1.5 WHERE `DisplayID`=30413;
+UPDATE `creature_model_info` SET `BoundingRadius`=5, `CombatReach`=9 WHERE `DisplayID`=25289;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.527500033378601074, `CombatReach`=3.75 WHERE `DisplayID`=23992;
+UPDATE `creature_model_info` SET `BoundingRadius`=1, `CombatReach`=1.5 WHERE `DisplayID`=25587;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.029999971389770507, `CombatReach`=1.5 WHERE `DisplayID`=25629;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.885500013828277587, `CombatReach`=1.65000009536743164 WHERE `DisplayID`=6530;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.347000002861022949, `CombatReach`=1.5 WHERE `DisplayID`=25234;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.046500001102685928, `CombatReach`=0.150000005960464477 WHERE `DisplayID`=20042;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.75, `CombatReach`=2.25 WHERE `DisplayID`=558;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.310000002384185791, `CombatReach`=1.5 WHERE `DisplayID`=23482;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.125, `CombatReach`=0.25 WHERE `DisplayID`=23711;
+UPDATE `creature_model_info` SET `BoundingRadius`=5.262499809265136718, `CombatReach`=5 WHERE `DisplayID`=1137;
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (28206,25075);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
+(28206,0,0,0,1,0,0,"28782"),
+(25075,0,0,0,1,0,0,"28782");
+
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=19397; -- Mo'arg Overseer
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=19400; -- Fel Reaver Sentry
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=19399; -- Fel Cannon
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=19398; -- Gan'arg Peon
+-- UPDATE `creature_template` SET `maxlevel`=59 WHERE `entry`=19432; -- Injured Grunt
+
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32768 WHERE `entry`=12789; -- Blood Guard Hini'wana
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32768 WHERE `entry`=19850; -- Councilor Arial D'Anastasis
+UPDATE `creature_template` SET /*`minlevel`=75, `maxlevel`=75,*/ `RangeAttackTime`=2000, `unit_flags`=32768 WHERE `entry`=12797; -- Grunt Korf
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32768 WHERE `entry`=12791; -- Chieftain Earthbind
+UPDATE `creature_template` SET /*`minlevel`=75, `maxlevel`=75,*/ `RangeAttackTime`=2000, `unit_flags`=32768 WHERE `entry`=12798; -- Grunt Bek'rah
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32768 WHERE `entry`=12790; -- Advisor Willington
+
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15370; -- Buru the Gorger
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15369; -- Ayamiss the Hunter
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15319; -- Hive'Zara Collector
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15336; -- Hive'Zara Tail Lasher
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15318; -- Hive'Zara Drone
+UPDATE `creature_template` SET `RangeAttackTime`=2000 WHERE `entry`=15333; -- Silicate Feeder
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=15428; -- Sand Vortex
+UPDATE `creature_template` SET `unit_flags`=33555200 WHERE `entry`=15590; -- Ossirian Crystal Trigger
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15339; -- Ossirian the Unscarred
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15355; -- Anubisath Guardian
+UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=2.142857074737548828, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=64, `unit_flags2`=0 WHERE `entry`=15340; -- Moam
+UPDATE `creature_template` SET `speed_walk`=1, `BaseAttackTime`=1200, `RangeAttackTime`=2000, `unit_flags`=32832 WHERE `entry`=15505; -- Canal Frenzy
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15335; -- Flesh Hunter
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15320; -- Hive'Zara Soldier
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15323; -- Hive'Zara Sandstalker
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15341; -- General Rajaxx
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15388; -- Major Pakkon
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15390; -- Captain Xurrem
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15386; -- Major Yeggeth
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15385; -- Colonel Zerran
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15392; -- Captain Tuubid
+UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.714285731315612792, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15462; -- Spitting Scarab
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15389; -- Captain Drenn
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15461; -- Shrieker Scarab
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15391; -- Captain Qeez
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15387; -- Qiraji Warrior
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=15344; -- Swarmguard Needler
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=0 WHERE `entry`=15471; -- Lieutenant General Andorov
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=0 WHERE `entry`=15473; -- Kaldorei Elite
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64, `unit_flags2`=0 WHERE `entry`=15338; -- Obsidian Destroyer
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=15348; -- Kurinnaxx
+UPDATE `creature_template` SET `npcflag`=1, `unit_flags2`=0 WHERE `entry`=39101; -- Courier Tormun
+
+UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=11733; -- Hive'Regal Slavemaker
+UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=15215; -- Mistress Natalia Mar'alith
+UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.385714292526245117, `RangeAttackTime`=2000 WHERE `entry`=284; -- Brown Horse
+UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=11731; -- Hive'Regal Burrower
+UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=11734; -- Hive'Regal Hive Lord
+UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.385714292526245117, `RangeAttackTime`=2000 WHERE `entry`=305; -- White Stallion
+
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=832 WHERE `entry`=11502; -- Ragnaros
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33554432 WHERE `entry`=13338; -- Core Rat
+UPDATE `creature_template` SET `RangeAttackTime`=2000 WHERE `entry`=12018; -- Majordomo Executus
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=11663; -- Flamewaker Healer
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=11664; -- Flamewaker Elite
+
+UPDATE `creature_template` SET `RangeAttackTime`=2000 WHERE `entry`=9178; -- Burning Spirit
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=10043; -- Ribbly's Crony
+UPDATE `creature_template` SET `speed_walk`=0.66666799783706665, `BaseAttackTime`=2800, `unit_flags`=64 WHERE `entry`=8924; -- The Behemoth
+
+UPDATE `creature_template` SET `unit_flags`=33554432 WHERE `entry`=12434; -- Monster Generator (Blackwing)
+UPDATE `creature_template` SET `speed_run`=2.142857074737548828, `unit_flags`=64 WHERE `entry`=11983; -- Firemaw
+UPDATE `creature_template` SET `speed_run`=1.714285731315612792, `unit_flags`=64 WHERE `entry`=12460; -- Death Talon Wyrmguard
+UPDATE `creature_template` SET `speed_run`=1.714285731315612792, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=64, `unit_flags2`=0 WHERE `entry`=13020; -- Vaelastrasz the Corrupt
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=12464; -- Death Talon Seether
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=12557; -- Grethok the Controller
+UPDATE `creature_template` SET `speed_walk`=1, `RangeAttackTime`=2000, `unit_flags`=33554688 WHERE `entry`=14449; -- Blackwing Orb Trigger
+UPDATE `creature_template` SET `BaseAttackTime`=2400, `unit_flags`=64 WHERE `entry`=12467; -- Death Talon Captain
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=12465; -- Death Talon Wyrmkin
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=12463; -- Death Talon Flamescale
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=12457; -- Blackwing Spellbinder
+UPDATE `creature_template` SET `speed_run`=2.142857074737548828, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=64 WHERE `entry`=14020; -- Chromaggus
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=12017; -- Broodlord Lashlayer
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=12461; -- Death Talon Overseer
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=13996; -- Blackwing Technician
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=12459; -- Blackwing Warlock
+UPDATE `creature_template` SET `speed_run`=1.428571462631225585, `unit_flags`=64 WHERE `entry`=12435; -- Razorgore the Untamed
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=14456; -- Blackwing Guardsman
+UPDATE `creature_template` SET `speed_walk`=1, `unit_flags`=33555200 WHERE `entry`=16604; -- Blackwing Spell Marker
+-- UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=12999; -- World Invisible Trigger
+UPDATE `creature_template` SET `speed_walk`=1, `RangeAttackTime`=2000, `unit_flags`=33555200 WHERE `entry`=14459; -- Nefarian's Troops
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=12458; -- Blackwing Taskmaster
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=12468; -- Death Talon Hatcher