diff options
| author | Killyana <morphone1@gmail.com> | 2017-09-24 20:23:37 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2020-09-10 00:02:42 +0200 |
| commit | ba84f3c65f86860b800db7a22681d848171fe491 (patch) | |
| tree | 3cd54d73931fc60c7925825d03874d4a86b3b4b5 | |
| parent | 5364dcc78bff5db6f36e0119ff002412bf6f8273 (diff) | |
DB/Creature: Blackpaw Gnolls
Closes #20407
(cherry picked from commit cb9b9f7247c57ee0eed42b063b827799166ce20a)
| -rw-r--r-- | sql/updates/world/master/2020_09_09_07_world_2017_09_24_02_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_09_09_07_world_2017_09_24_02_world.sql b/sql/updates/world/master/2020_09_09_07_world_2017_09_24_02_world.sql new file mode 100644 index 00000000000..9528acde6a5 --- /dev/null +++ b/sql/updates/world/master/2020_09_09_07_world_2017_09_24_02_world.sql @@ -0,0 +1,5 @@ +-- +UPDATE `creature_template_addon` SET `emote`=0 WHERE `entry` IN (16335,16334); +DELETE FROM `creature_addon` WHERE `guid` IN (82580,82576,82587,82583,82586,82584,82591,82595,82593,82596,82594,82598,82601); +INSERT INTO `creature_addon` (`guid`, `bytes2`, `emote`) VALUES +(82580, 4097, 233),(82576, 4097, 233),(82587, 4097, 233),(82583, 4097, 233),(82586, 4097, 233),(82584, 4097, 233),(82591, 4097, 233),(82595, 4097, 233),(82593, 4097, 233),(82596, 4097, 233),(82594, 4097, 233),(82598, 4097, 233),(82601, 4097, 233); |
