aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2016-07-19 14:49:54 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-02-11 15:35:44 +0100
commitd5677655f289c588ac9ec10aec1f7af7440557ba (patch)
tree4aa0e17a87a23e8b6658c636c2941de39e4d3d6d
parent19df05d86d75adaee236bad054b10bbb73c7346d (diff)
DB/NPC: Quartermaster Bartlett
Closes #17611 (cherry picked from commit c2e29a34eb4fe35f1e4331d6b7844fa7d15d5e4c)
-rw-r--r--sql/updates/world/master/2017_02_11_03_world_2016_07_19_02_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_11_03_world_2016_07_19_02_world.sql b/sql/updates/world/master/2017_02_11_03_world_2016_07_19_02_world.sql
new file mode 100644
index 00000000000..782178a66f8
--- /dev/null
+++ b/sql/updates/world/master/2017_02_11_03_world_2016_07_19_02_world.sql
@@ -0,0 +1,5 @@
+--
+DELETE FROM `creature_template_addon` WHERE `entry`=27267;
+INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `bytes2`, `emote`) VALUES (27267, 256, 257, 233);
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=27267;
+UPDATE `gossip_menu_option` SET `option_id`=3, `npc_option_npcflag`=128 WHERE `menu_id`=9487;