diff options
| -rw-r--r-- | sql/updates/world/master/2022_03_06_58_world_2021_02_18_01_world.sql | 138 |
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 |