diff options
| author | Killyana <morphone1@gmail.com> | 2017-09-24 20:23:37 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-09-24 20:23:37 +0200 |
| commit | cb9b9f7247c57ee0eed42b063b827799166ce20a (patch) | |
| tree | 081befdd4be6398a8fcec78b8b41c75a52a0f5d2 | |
| parent | 97eb2a54c7ae9351c5087efad05ccdde1c29ffc8 (diff) | |
DB/Creature: Blackpaw Gnolls
Closes #20407
| -rw-r--r-- | sql/updates/world/3.3.5/2017_09_24_02_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_09_24_02_world.sql b/sql/updates/world/3.3.5/2017_09_24_02_world.sql new file mode 100644 index 00000000000..9528acde6a5 --- /dev/null +++ b/sql/updates/world/3.3.5/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); |