diff options
| author | Naddley <NaddleyTC@gmail.com> | 2024-10-12 15:12:06 +0200 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2024-10-12 15:12:06 +0200 |
| commit | f2e415d7af125e2cb4173d28d674a3274c11d71d (patch) | |
| tree | 0b6fc27ff29c0eb48c2a2e3193e9b570d8322177 /sql | |
| parent | 6e0b146f1d6df817714595995632e2514e5869a8 (diff) | |
DB/NorthernBarrens: Update difficulty data for Thorn Hill cave
Closes #30337
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2024_10_12_00_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_10_12_00_world.sql b/sql/updates/world/master/2024_10_12_00_world.sql new file mode 100644 index 00000000000..330919a3ab2 --- /dev/null +++ b/sql/updates/world/master/2024_10_12_00_world.sql @@ -0,0 +1,11 @@ +-- Update Kreenig Snarlsnout +DELETE FROM `creature_template_difficulty` WHERE `entry` = 3438 AND `DifficultyID` = 0 AND `ContentTuningID` = 0; +UPDATE `creature_template_difficulty` SET `DifficultyID` = 0, `ContentTuningID`=3, `StaticFlags1`=0x0, `VerifiedBuild`=56819 WHERE (`Entry`=3438 AND `DifficultyID`=1); -- 3438 (Kreenig Snarlsnout) - + +-- Update Razormane Defender +DELETE FROM `creature_template_difficulty` WHERE `entry` = 3266 AND `DifficultyID` = 0 AND `ContentTuningID` = 0; +UPDATE `creature_template_difficulty` SET `DifficultyID` = 0, `ContentTuningID`=3, `StaticFlags1`=0x0, `VerifiedBuild`=56819 WHERE (`Entry`=3266 AND `DifficultyID`=1); -- 3266 (Razormane Defender) - + +-- Update Razormane Thornweaver +DELETE FROM `creature_template_difficulty` WHERE `entry` = 3268 AND `DifficultyID` = 0 AND `ContentTuningID` = 0; +UPDATE `creature_template_difficulty` SET `DifficultyID` = 0, `ContentTuningID`=3, `StaticFlags1`=0x0, `VerifiedBuild`=56819 WHERE (`Entry`=3268 AND `DifficultyID`=1); -- 3268 (Razormane Thornweaver) - |