diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2021-10-01 09:54:18 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-10-01 09:54:18 +0200 |
| commit | 7e96b2d7336bf36ec5733c394f46600a98f305d4 (patch) | |
| tree | 751392255275fb91bd5480bc5a3a9342eb108a3f | |
| parent | 78858b1edd7609d98656e63334d68402a129ab60 (diff) | |
DB/NPC: Blackrock Spy (fix auras)
closes #26976 by xXBentRealityXx
| -rw-r--r-- | sql/updates/world/master/2021_10_01_05_world.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_10_01_05_world.sql b/sql/updates/world/master/2021_10_01_05_world.sql new file mode 100644 index 00000000000..2ab0a701034 --- /dev/null +++ b/sql/updates/world/master/2021_10_01_05_world.sql @@ -0,0 +1,20 @@ +DELETE FROM `creature_template_addon` WHERE `entry`=49874; + +DELETE FROM `creature_addon` WHERE `guid` IN (279746, 279747, 279758, 279822, 279909, 279921, 279924, 279935, 279937, 279939, 279948, 279971, 279977, 280012); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(279746, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(279747, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(279758, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(279822, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(279909, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(279921, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(279924, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(279935, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(279937, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(279939, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(279948, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(279971, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(279977, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'), +(280012, 0, 0, 8, 1, 0, 0, 565, 0, 0, '80676 349927'); + +UPDATE `creature_addon` SET `movementAnimKit` = 565, `auras` = '349927' WHERE `guid` IN (279756, 279821, 279918, 279936, 279950, 279952, 279970, 279993, 279996); |