diff options
| -rw-r--r-- | sql/updates/world/master/2024_08_03_00_world.sql | 91 |
1 files changed, 91 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_08_03_00_world.sql b/sql/updates/world/master/2024_08_03_00_world.sql new file mode 100644 index 00000000000..45c225aae83 --- /dev/null +++ b/sql/updates/world/master/2024_08_03_00_world.sql @@ -0,0 +1,91 @@ +-- Normal +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=130912 AND `DifficultyID`=1); -- 130912 (Shadowblade Razi) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122970 AND `DifficultyID`=1); -- 122970 (Shadowblade Stalker) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268959744, `VerifiedBuild`=55939 WHERE (`Entry`=129517 AND `DifficultyID`=1); -- 129517 (Reanimated Raptor) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368, `VerifiedBuild`=55939 WHERE (`Entry`=128956 AND `DifficultyID`=1); -- 128956 (Blood-Tainted Cauldron of Gold) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `VerifiedBuild`=55939 WHERE (`Entry`=130686 AND `DifficultyID`=1); -- 130686 (Mountaintop Croaker) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=132126 AND `DifficultyID`=1); -- 132126 (Gilded Priestess) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `VerifiedBuild`=55939 WHERE (`Entry`=130681 AND `DifficultyID`=1); -- 130681 (Glitterlight Flitter) - Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122968 AND `DifficultyID`=1); -- 122968 (Yazma) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=55939 WHERE (`Entry`=131289 AND `DifficultyID`=1); -- 131289 (Shadowflame) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122967 AND `DifficultyID`=1); -- 122967 (Priestess Alun'za) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=55939 WHERE (`Entry`=125977 AND `DifficultyID`=1); -- 125977 (Reanimation Totem) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122965 AND `DifficultyID`=1); -- 122965 (Vol'kaal) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=55939 WHERE (`Entry`=122963 AND `DifficultyID`=1); -- 122963 (Rezan) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=128455 AND `DifficultyID`=1); -- 128455 (T'lonja) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=55939 WHERE (`Entry`=129985 AND `DifficultyID`=1); -- 129985 (Tiki Mask) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=129552 AND `DifficultyID`=1); -- 129552 (Monzumi) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=129553 AND `DifficultyID`=1); -- 129553 (Dinomancer Kish'o) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `VerifiedBuild`=55939 WHERE (`Entry`=130680 AND `DifficultyID`=1); -- 130680 (Goldshell Scuttler) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435712, `VerifiedBuild`=55939 WHERE (`Entry`=122984 AND `DifficultyID`=1); -- 122984 (Dazar'ai Colossus) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=128434 AND `DifficultyID`=1); -- 128434 (Feasting Skyscreamer) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=55939 WHERE (`Entry`=127315 AND `DifficultyID`=1); -- 127315 (Reanimation Totem) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122972 AND `DifficultyID`=1); -- 122972 (Dazar'ai Augur) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122973 AND `DifficultyID`=1); -- 122973 (Dazar'ai Confessor) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=127879 AND `DifficultyID`=1); -- 127879 (Shieldbearer of Zul) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=127757 AND `DifficultyID`=1); -- 127757 (Reanimated Honor Guard) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122969 AND `DifficultyID`=1); -- 122969 (Zanchuli Witch-Doctor) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368, `VerifiedBuild`=55939 WHERE (`Entry`=122986 AND `DifficultyID`=1); -- 122986 (Wild Skyscreamer) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435712, `VerifiedBuild`=55939 WHERE (`Entry`=127799 AND `DifficultyID`=1); -- 127799 (Dazar'ai Honor Guard) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435712, `VerifiedBuild`=55939 WHERE (`Entry`=122971 AND `DifficultyID`=1); -- 122971 (Dazar'ai Juggernaut) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `VerifiedBuild`=55939 WHERE (`Entry`=130679 AND `DifficultyID`=1); -- 130679 (Temple Snake) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=128435 AND `DifficultyID`=1); -- 128435 (Toxic Saurid) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `VerifiedBuild`=55939 WHERE (`Entry`=130678 AND `DifficultyID`=1); -- 130678 (Poisonous Gekkota) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306624, `VerifiedBuild`=55939 WHERE (`Entry`=127352 AND `DifficultyID`=1); -- 127352 (Risen Honor Guard) - Sessile, CanSwim, Floating + +-- HC +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268959744, `VerifiedBuild`=55939 WHERE (`Entry`=129517 AND `DifficultyID`=2); -- 129517 (Reanimated Raptor) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122970 AND `DifficultyID`=2); -- 122970 (Shadowblade Stalker) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=130912 AND `DifficultyID`=2); -- 130912 (Shadowblade Razi) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=805306368, `VerifiedBuild`=55939 WHERE (`Entry`=128956 AND `DifficultyID`=2); -- 128956 (Blood-Tainted Cauldron of Gold) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=132126 AND `DifficultyID`=2); -- 132126 (Gilded Priestess) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122967 AND `DifficultyID`=2); -- 122967 (Priestess Alun'za) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122968 AND `DifficultyID`=2); -- 122968 (Yazma) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122965 AND `DifficultyID`=2); -- 122965 (Vol'kaal) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=128455 AND `DifficultyID`=2); -- 128455 (T'lonja) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435712, `VerifiedBuild`=55939 WHERE (`Entry`=122984 AND `DifficultyID`=2); -- 122984 (Dazar'ai Colossus) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=128434 AND `DifficultyID`=2); -- 128434 (Feasting Skyscreamer) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=805306368, `VerifiedBuild`=55939 WHERE (`Entry`=122986 AND `DifficultyID`=2); -- 122986 (Wild Skyscreamer) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=127757 AND `DifficultyID`=2); -- 127757 (Reanimated Honor Guard) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=129552 AND `DifficultyID`=2); -- 129552 (Monzumi) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=536871168, `VerifiedBuild`=55939 WHERE (`Entry`=127315 AND `DifficultyID`=2); -- 127315 (Reanimation Totem) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=129553 AND `DifficultyID`=2); -- 129553 (Dinomancer Kish'o) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122972 AND `DifficultyID`=2); -- 122972 (Dazar'ai Augur) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435712, `VerifiedBuild`=55939 WHERE (`Entry`=122973 AND `DifficultyID`=2); -- 122973 (Dazar'ai Confessor) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=127879 AND `DifficultyID`=2); -- 127879 (Shieldbearer of Zul) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=55939 WHERE (`Entry`=125977 AND `DifficultyID`=2); -- 125977 (Reanimation Totem) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=805306624, `VerifiedBuild`=55939 WHERE (`Entry`=127352 AND `DifficultyID`=2); -- 127352 (Risen Honor Guard) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122969 AND `DifficultyID`=2); -- 122969 (Zanchuli Witch-Doctor) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=268959744, `VerifiedBuild`=55939 WHERE (`Entry`=122963 AND `DifficultyID`=2); -- 122963 (Rezan) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435712, `VerifiedBuild`=55939 WHERE (`Entry`=122971 AND `DifficultyID`=2); -- 122971 (Dazar'ai Juggernaut) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=128435 AND `DifficultyID`=2); -- 128435 (Toxic Saurid) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435712, `VerifiedBuild`=55939 WHERE (`Entry`=127799 AND `DifficultyID`=2); -- 127799 (Dazar'ai Honor Guard) - Sessile, CanSwim + +-- Mythic +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=130912 AND `DifficultyID`=23); -- 130912 (Shadowblade Razi) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122970 AND `DifficultyID`=23); -- 122970 (Shadowblade Stalker) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=805306368, `VerifiedBuild`=55939 WHERE (`Entry`=128956 AND `DifficultyID`=23); -- 128956 (Blood-Tainted Cauldron of Gold) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=132126 AND `DifficultyID`=23); -- 132126 (Gilded Priestess) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268959744, `VerifiedBuild`=55939 WHERE (`Entry`=129517 AND `DifficultyID`=23); -- 129517 (Reanimated Raptor) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122967 AND `DifficultyID`=23); -- 122967 (Priestess Alun'za) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122968 AND `DifficultyID`=23); -- 122968 (Yazma) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435712, `VerifiedBuild`=55939 WHERE (`Entry`=122984 AND `DifficultyID`=23); -- 122984 (Dazar'ai Colossus) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122965 AND `DifficultyID`=23); -- 122965 (Vol'kaal) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435712, `VerifiedBuild`=55939 WHERE (`Entry`=122973 AND `DifficultyID`=23); -- 122973 (Dazar'ai Confessor) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435712, `VerifiedBuild`=55939 WHERE (`Entry`=122972 AND `DifficultyID`=23); -- 122972 (Dazar'ai Augur) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=55939 WHERE (`Entry`=125977 AND `DifficultyID`=23); -- 125977 (Reanimation Totem) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435712, `VerifiedBuild`=55939 WHERE (`Entry`=127799 AND `DifficultyID`=23); -- 127799 (Dazar'ai Honor Guard) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435712, `VerifiedBuild`=55939 WHERE (`Entry`=122971 AND `DifficultyID`=23); -- 122971 (Dazar'ai Juggernaut) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=55939 WHERE (`Entry`=120652 AND `DifficultyID`=23); +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=128455 AND `DifficultyID`=23); -- 128455 (T'lonja) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=129552 AND `DifficultyID`=23); -- 129552 (Monzumi) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=268959744, `VerifiedBuild`=55939 WHERE (`Entry`=122963 AND `DifficultyID`=23); -- 122963 (Rezan) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=805306368, `VerifiedBuild`=55939 WHERE (`Entry`=122986 AND `DifficultyID`=23); -- 122986 (Wild Skyscreamer) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=129553 AND `DifficultyID`=23); -- 129553 (Dinomancer Kish'o) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=128434 AND `DifficultyID`=23); -- 128434 (Feasting Skyscreamer) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=122969 AND `DifficultyID`=23); -- 122969 (Zanchuli Witch-Doctor) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=127879 AND `DifficultyID`=23); -- 127879 (Shieldbearer of Zul) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=127757 AND `DifficultyID`=23); -- 127757 (Reanimated Honor Guard) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=536871168, `VerifiedBuild`=55939 WHERE (`Entry`=127315 AND `DifficultyID`=23); -- 127315 (Reanimation Totem) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=805306624, `VerifiedBuild`=55939 WHERE (`Entry`=127352 AND `DifficultyID`=23); -- 127352 (Risen Honor Guard) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55939 WHERE (`Entry`=128435 AND `DifficultyID`=23); -- 128435 (Toxic Saurid) - CanSwim |