diff options
| -rw-r--r-- | sql/updates/world/master/2022_03_05_76_world_2021_01_15_00_world.sql | 55 |
1 files changed, 55 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_05_76_world_2021_01_15_00_world.sql b/sql/updates/world/master/2022_03_05_76_world_2021_01_15_00_world.sql new file mode 100644 index 00000000000..4faa7d746d0 --- /dev/null +++ b/sql/updates/world/master/2022_03_05_76_world_2021_01_15_00_world.sql @@ -0,0 +1,55 @@ +-- +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` = 35062; +-- UPDATE `creature_template` SET `minlevel` = 79 WHERE `entry` = 35079; +-- UPDATE `creature_template` SET `minlevel` = 78 WHERE `entry` = 35080; +-- UPDATE `creature_template` SET `minlevel` = 78 WHERE `entry` = 35084; +-- UPDATE `creature_template` SET `minlevel` = 78 WHERE `entry` = 35092; +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` = 35226; +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` = 35227; +UPDATE `creature_template` SET `difficulty_entry_1` = 36135, /*`minlevel` = 80,*/ `unit_flags2` = 32 WHERE `entry` = 35311; +UPDATE `creature_template` SET /*`minlevel` = 80, `maxlevel` = 80,*/ `speed_run` = 0.992063, `unit_flags2` = 32, `flags_extra` = `flags_extra` |64 WHERE `entry` = 36135; +-- UPDATE `creature_template` SET `minlevel` = 60, `maxlevel` = 60 WHERE `entry` = 35339; +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` = 35376; +UPDATE `creature_template` SET /*`minlevel` = 83, `maxlevel` = 83,*/ `unit_flags` = 33555200 WHERE `entry` = 35473; +-- UPDATE `creature_template` SET `minlevel` = 1, `maxlevel` = 1 WHERE `entry` = 35651; + +UPDATE `creature_template` SET /*`minlevel` = 80, `maxlevel` = 80,*/ `unit_flags` = 33587968 WHERE `entry` = 36173; +-- UPDATE `creature_template` SET `minlevel` = 82, `maxlevel` = 82 WHERE `entry` = 36503; +-- UPDATE `creature_template` SET `minlevel` = 82, `maxlevel` = 82 WHERE `entry` = 36504; +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` = 36549; + +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` = 37183; +-- UPDATE `creature_template` SET `minlevel` = 81, `maxlevel` = 81 WHERE `entry` = 37547; +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` = 37852; +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` = 37948; + +-- UPDATE `creature_template` SET `minlevel` = 60, `maxlevel` = 60 WHERE `entry` = 38153; +UPDATE `creature_template` SET /*`minlevel` = 80, `maxlevel` = 80,*/ `unit_flags` = 33555200 WHERE `entry` = 38340; +UPDATE `creature_template` SET /*`minlevel` = 80, `maxlevel` = 80,*/ `unit_flags` = 33555200 WHERE `entry` = 38341; +UPDATE `creature_template` SET /*`minlevel` = 80, `maxlevel` = 80,*/ `unit_flags` = 33555200 WHERE `entry` = 38342; +-- UPDATE `creature_template` SET `minlevel` = 83, `maxlevel` = 83 WHERE `entry` = 38569; +-- UPDATE `creature_template` SET `minlevel` = 60, `maxlevel` = 60 WHERE `entry` = 38763; +UPDATE `creature_template` SET /*`minlevel` = 80, `maxlevel` = 80,*/ `unit_flags` = 33554432 WHERE `entry` = 38879; + +UPDATE `creature_template` SET /*`minlevel` = 65, `maxlevel` = 65,*/ `unit_flags` = 32768 WHERE `entry` = 34038; +UPDATE `creature_template` SET /*`minlevel` = 70, `maxlevel` = 70,*/ `unit_flags` = 32768 WHERE `entry` = 34060; +UPDATE `creature_template` SET /*`minlevel` = 65, `maxlevel` = 65,*/ `unit_flags` = 32768 WHERE `entry` = 34063; +UPDATE `creature_template` SET /*`minlevel` = 80,*/ `unit_flags` = 32768 WHERE `entry` = 34734; + +UPDATE `creature_template` SET /*`minlevel` = 80, `maxlevel` = 80,*/ `BaseAttackTime` = 10000 WHERE `entry` = 33108; +UPDATE `creature_template_addon` SET `bytes2` = 1, `auras` = "62898" WHERE `entry` = 33108; +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` = 33212; +UPDATE `creature_template` SET /*`minlevel` = 80, `maxlevel` = 80,*/ `BaseAttackTime` = 10000 WHERE `entry` = 33364; +-- UPDATE `creature_template_addon` SET `bytes2` = 1, `auras` = "62897" WHERE `entry` = 33364; +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` = 33365; +UPDATE `creature_template` SET /*`minlevel` = 80, `maxlevel` = 80,*/ `BaseAttackTime` = 10000 WHERE `entry` = 33366; +-- UPDATE `creature_template_addon` SET `bytes2` = 1, `auras` = "62895" WHERE `entry` = 33366; +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` = 33367; +UPDATE `creature_template` SET /*`minlevel` = 80, `maxlevel` = 80,*/ `BaseAttackTime` = 10000 WHERE `entry` = 33369; +UPDATE `creature_template_addon` SET `bytes2` = 1, `auras` = "62898" WHERE `entry` = 33369; +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` = 33370; +UPDATE `creature_template` SET /*`minlevel` = 60, `maxlevel` = 60,*/ `unit_flags` = 33554688 WHERE `entry` = 33874; + +-- UPDATE `creature_template` SET `minlevel` = 1, `maxlevel` = 1 WHERE `entry` = 32261; + +-- UPDATE `creature_template` SET `minlevel` = 79 WHERE `entry` = 31033; |