diff options
| -rw-r--r-- | sql/updates/world/master/2022_03_09_11_world_2021_05_04_01_world.sql | 120 |
1 files changed, 120 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_09_11_world_2021_05_04_01_world.sql b/sql/updates/world/master/2022_03_09_11_world_2021_05_04_01_world.sql new file mode 100644 index 00000000000..c5fd43fa303 --- /dev/null +++ b/sql/updates/world/master/2022_03_09_11_world_2021_05_04_01_world.sql @@ -0,0 +1,120 @@ +-- Swimming flag probably was added in Cata(maybe not to all but to some of them) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 18155; -- Bloodfalcon +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 1600, `unit_flags` = 32832 WHERE `entry` = 21544; -- Bloodfalcon (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 17994; -- Bloodwarder Falconer +UPDATE `creature_template` SET /*`minlevel` = 71,*/ `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21545; -- Bloodwarder Falconer (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 18419; -- Bloodwarder Greenkeeper +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21546; -- Bloodwarder Greenkeeper (1) +UPDATE `creature_template` SET /*`maxlevel` = 70,*/ `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 19633; -- Bloodwarder Mender +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 21547; -- Bloodwarder Mender (1) +UPDATE `creature_template` SET `unit_flags` = 32832 WHERE `entry` = 17993; -- Bloodwarder Protector +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21548; -- Bloodwarder Protector (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 18404; -- Bloodwarder Steward +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21549; -- Bloodwarder Steward (1) +UPDATE `creature_template` SET /*`maxlevel` = 69,*/ `speed_walk` = 0.8, `speed_run` = 0.28571428571, `unit_flags` = 32768 WHERE `entry` = 19962; -- Blue Seedling +UPDATE `creature_template` SET `speed_walk` = 0.8, `speed_run` = 0.28571428571, `BaseAttackTime` = 2000, `unit_flags` = 32768 WHERE `entry` = 21550; -- Blue Seedling (1) +UPDATE `creature_template` SET `speed_walk` = 1.6, `speed_run` = 1.42857142857, `BaseAttackTime` = 1400, `unit_flags` = 32832 WHERE `entry` = 17976; -- Commander Sarannis +UPDATE `creature_template` SET `speed_walk` = 1.6, `speed_run` = 1.42857142857, `unit_flags` = 32832 WHERE `entry` = 21551; -- Commander Sarannis (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32768 WHERE `entry` = 18587; -- Frayer +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32768 WHERE `entry` = 21552; -- Frayer (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32768 WHERE `entry` = 19953; -- Frayer Protector +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32768 WHERE `entry` = 21553; -- Frayer Protector (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32768 WHERE `entry` = 19608; -- Frayer Wildling +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32768 WHERE `entry` = 21554; -- Frayer Wildling (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32768 WHERE `entry` = 19557; -- Greater Frayer +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32768 WHERE `entry` = 21555; -- Greater Frayer (1) +UPDATE `creature_template` SET /*`maxlevel` = 69,*/ `speed_walk` = 0.8, `speed_run` = 0.28571428571, `unit_flags` = 32768 WHERE `entry` = 19969; -- Green Seedling +UPDATE `creature_template` SET `speed_walk` = 0.8, `speed_run` = 0.28571428571, `BaseAttackTime` = 2000, `unit_flags` = 32768 WHERE `entry` = 21557; -- Green Seedling (1) +UPDATE `creature_template` SET `speed_walk` = 1.6, `speed_run` = 1.42857142857, `unit_flags` = 32832 WHERE `entry` = 17975; -- High Botanist Freywinn +UPDATE `creature_template` SET /*`maxlevel` = 72,*/ `speed_walk` = 1.6, `speed_run` = 1.42857142857, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21558; -- High Botanist Freywinn (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 17980; -- Laj +UPDATE `creature_template` SET /*`maxlevel` = 72,*/ `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21559; -- Laj (1) +UPDATE `creature_template` SET `unit_flags` = 64 WHERE `entry` = 19513; -- Mutate Fear-Shrieker +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 64 WHERE `entry` = 21560; -- Mutate Fear-Shrieker (1) +UPDATE `creature_template` SET /*`maxlevel` = 71,*/ `speed_walk` = 1, `BaseAttackTime` = 2000 WHERE `entry` = 21561; -- Mutate Fleshlasher (1) +UPDATE `creature_template` SET `unit_flags` = 64 WHERE `entry` = 19865; -- Mutate Horror +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 64 WHERE `entry` = 21562; -- Mutate Horror (1) +UPDATE `creature_template` SET `unit_flags` = 64 WHERE `entry` = 19511; -- Nethervine Inciter +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 64 WHERE `entry` = 21563; -- Nethervine Inciter (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 64 WHERE `entry` = 19512; -- Nethervine Reaper +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 64 WHERE `entry` = 21564; -- Nethervine Reaper (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 64 WHERE `entry` = 19843; -- Nethervine Trickster +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 64 WHERE `entry` = 21565; -- Nethervine Trickster (1) +UPDATE `creature_template` SET /*`maxlevel` = 69,*/ `speed_walk` = 0.8, `speed_run` = 0.28571428571, `unit_flags` = 32768 WHERE `entry` = 19964; -- Red Seedling +UPDATE `creature_template` SET `speed_walk` = 0.8, `speed_run` = 0.28571428571, `BaseAttackTime` = 2000, `unit_flags` = 32768 WHERE `entry` = 21566; -- Red Seedling (1) +UPDATE `creature_template` SET /*`minlevel` = 70, `maxlevel` = 70,*/ `speed_walk` = 0.8, `speed_run` = 0.28571428571, `unit_flags` = 32768 WHERE `entry` = 19949; -- Sapling +UPDATE `creature_template` SET /*`minlevel` = 70, `maxlevel` = 70,*/ `speed_walk` = 0.8, `speed_run` = 0.28571428571, `BaseAttackTime` = 2000, `unit_flags` = 32768 WHERE `entry` = 21567; -- Sapling (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 20083; -- Summoned Bloodwarder Mender +UPDATE `creature_template` SET /*`minlevel` = 70, `maxlevel` = 70,*/ `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 21568; -- Summoned Bloodwarder Mender (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32768 WHERE `entry` = 20078; -- Summoned Bloodwarder Reservist +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32768 WHERE `entry` = 21569; -- Summoned Bloodwarder Reservist (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 18422; -- Sunseeker Botanist +UPDATE `creature_template` SET /*`minlevel` = 70,*/ `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21570; -- Sunseeker Botanist (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 19505; -- Sunseeker Channeler +UPDATE `creature_template` SET /*`minlevel` = 70,*/ `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21571; -- Sunseeker Channeler (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 19486; -- Sunseeker Chemist +UPDATE `creature_template` SET /*`minlevel` = 70,*/ `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21572; -- Sunseeker Chemist (1) +UPDATE `creature_template` SET `unit_flags` = 32832 WHERE `entry` = 19507; -- Sunseeker Gene-Splicer +UPDATE `creature_template` SET /*`minlevel` = 70,*/ `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21573; -- Sunseeker Gene-Splicer (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 18420; -- Sunseeker Geomancer +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21574; -- Sunseeker Geomancer (1) +UPDATE `creature_template` SET `unit_flags` = 32832 WHERE `entry` = 19509; -- Sunseeker Harvester +UPDATE `creature_template` SET /*`minlevel` = 70,*/ `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21575; -- Sunseeker Harvester (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 19508; -- Sunseeker Herbalist +UPDATE `creature_template` SET /*`minlevel` = 70,*/ `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 21576; -- Sunseeker Herbalist (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 18421; -- Sunseeker Researcher +UPDATE `creature_template` SET /*`minlevel` = 70,*/ `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21577; -- Sunseeker Researcher (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32832 WHERE `entry` = 18405; -- Tempest-Forge Peacekeeper +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21578; -- Tempest-Forge Peacekeeper (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32768 WHERE `entry` = 19920; -- Thorn Flayer +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32768 WHERE `entry` = 21579; -- Thorn Flayer (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 32768 WHERE `entry` = 19919; -- Thorn Lasher +UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `unit_flags` = 32768 WHERE `entry` = 21580; -- Thorn Lasher (1) +UPDATE `creature_template` SET `speed_walk` = 1, `speed_run` = 1.42857142857, `unit_flags` = 32832 WHERE `entry` = 17978; -- Thorngrin the Tender +UPDATE `creature_template` SET /*`maxlevel` = 72,*/ `speed_walk` = 1, `speed_run` = 1.42857142857, `BaseAttackTime` = 2000, `unit_flags` = 32832 WHERE `entry` = 21581; -- Thorngrin the Tender (1) +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 33554432 WHERE `entry` = 19555; -- TK Atrium Channel Target +UPDATE `creature_template` SET /*`maxlevel` = 69,*/ `speed_walk` = 0.8, `speed_run` = 0.28571428571, `unit_flags` = 32768 WHERE `entry` = 19958; -- White Seedling +UPDATE `creature_template` SET `speed_walk` = 0.8, `speed_run` = 0.28571428571, `BaseAttackTime` = 2000, `unit_flags` = 32768 WHERE `entry` = 21583; -- White Seedling (1) + +UPDATE `creature_model_info` SET `BoundingRadius` = 0.19500001, `CombatReach` = 0.97499996 WHERE `DisplayID` = 19685; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17777; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17778; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17779; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17780; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17883; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17884; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 21331; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 21332; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17813; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17815; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17816; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17817; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.14, `CombatReach` = 0.4 WHERE `DisplayID` = 19290; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.766, `CombatReach` = 3 WHERE `DisplayID` = 18929; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.28, `CombatReach` = 0.8 WHERE `DisplayID` = 19029; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.14, `CombatReach` = 0.4 WHERE `DisplayID` = 19292; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.49789995, `CombatReach` = 1.9499999 WHERE `DisplayID` = 19045; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.375, `CombatReach` = 0.75 WHERE `DisplayID` = 19021; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.14, `CombatReach` = 0.4 WHERE `DisplayID` = 20139; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 19316; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 19317; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17819; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17820; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 21340; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 21341; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 18925; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 18926; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 21335; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 21336; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 21337; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 21333; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 21334; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 21338; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 21339; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17842; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17843; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17844; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.47875, `CombatReach` = 1.875 WHERE `DisplayID` = 17845; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.75, `CombatReach` = 4.5 WHERE `DisplayID` = 18930; +UPDATE `creature_model_info` SET `CombatReach` = 4 WHERE `DisplayID` = 19438; +UPDATE `creature_model_info` SET `BoundingRadius` = 0.14, `CombatReach` = 0.4 WHERE `DisplayID` = 19289; |