diff options
| author | offl <offl@users.noreply.github.com> | 2021-01-04 20:01:23 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-05 21:46:48 +0100 |
| commit | facb6dd9f90da1d7c44e75f756a3f2a9956a4dd5 (patch) | |
| tree | 910bc90a7154ec99550f9beb84d7872dc6689c2e | |
| parent | bb9b2f1367af00a99b714dd6936d8b15c6b6d804 (diff) | |
DB/Creature: Remove UNIT_FLAG_REMOVE_CLIENT_CONTROL
Ref #25764
(cherry picked from commit a0da54d66fd91b0a247151ea13db77e227ffc962)
| -rw-r--r-- | sql/updates/world/master/2022_03_05_45_world_2021_01_04_16_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_05_45_world_2021_01_04_16_world.sql b/sql/updates/world/master/2022_03_05_45_world_2021_01_04_16_world.sql new file mode 100644 index 00000000000..db9b7eb225b --- /dev/null +++ b/sql/updates/world/master/2022_03_05_45_world_2021_01_04_16_world.sql @@ -0,0 +1,5 @@ +-- Since previously that flag was used as hacky way to disable movement, apply corrections based on sniffs and\or CreatureDifficulty while at it +UPDATE `creature_template_movement` SET `Rooted` = 0 WHERE `CreatureId` IN (16400,20561,21413,23996,33342); +UPDATE `creature_template_movement` SET `Flight` = 1, `Rooted` = 0 WHERE `CreatureId` = 20251; +UPDATE `creature_template_movement` SET `Flight` = 1 WHERE `CreatureId` = 23077; +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ 0x00000004 WHERE `entry` IN (1921,5674,14697,16236,16400,18679,18695,20251,20561,21413,23076,23077,23876,23996,25284,25534,27064,27894,28156,28366,29475,29483,29613,29747,29790,30236,30475,31103,31280,31424,32347,32795,32938,33174,33184,33229,33243,33272,33342,33352,33353,33651,34047,34050,34071,34096,34108,34110,34121,34149,34362,34363); |