aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-09-24 20:23:37 +0200
committerShauren <shauren.trinity@gmail.com>2020-09-10 00:02:42 +0200
commitba84f3c65f86860b800db7a22681d848171fe491 (patch)
tree3cd54d73931fc60c7925825d03874d4a86b3b4b5
parent5364dcc78bff5db6f36e0119ff002412bf6f8273 (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.sql5
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);