diff options
| author | ModoX <moardox@gmail.com> | 2024-05-12 01:56:56 +0200 |
|---|---|---|
| committer | ModoX <moardox@gmail.com> | 2024-05-12 01:57:11 +0200 |
| commit | b8a79c89431ec44e76164de26f318b7f927779eb (patch) | |
| tree | a5715cfa47c061849af1b32aa1ab93deb4d2bca2 | |
| parent | 73ceb33f69f3c6159ce2049174c472b709b8d9ee (diff) | |
DB/RagefireChasm: Moved floating static flag to guid specific for scouts and fixed anim for Scout near Slagmaw
| -rw-r--r-- | sql/updates/world/master/2024_05_12_02_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_05_12_02_world.sql b/sql/updates/world/master/2024_05_12_02_world.sql new file mode 100644 index 00000000000..2fd6a325150 --- /dev/null +++ b/sql/updates/world/master/2024_05_12_02_world.sql @@ -0,0 +1,12 @@ +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1` & ~0x20000000 WHERE `entry` IN(61788, 61680); + +DELETE FROM `creature_static_flags_override` WHERE `SpawnId` IN(4000126, 4000122, 4000098, 4000042); +INSERT INTO `creature_static_flags_override` (`SpawnId`, `DifficultyId`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `StaticFlags5`, `StaticFlags6`, `StaticFlags7`, `StaticFlags8`) VALUES +(4000126, 0, 805306624, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(4000122, 0, 805306624, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(4000042, 0, 805306624, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(4000098, 0, 805306624, NULL, NULL, NULL, NULL, NULL, NULL, NULL); + +DELETE FROM `creature_addon` WHERE `guid`=4000126; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(4000126, 0, 0, 0, 0, 3, 0, 1, 0, 0, 2297, 0, 0, 0, ''); |