DB/Creature: Add missing npc_flag hasgossip to some creatures Part1

Ref #22912

1 files changed, 12 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_01_07_00_world.sql b/sql/updates/world/3.3.5/2019_01_07_00_world.sql
new file mode 100644
index 00000000000..e704d01e209
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_01_07_00_world.sql
@@ -0,0 +1,12 @@
+UPDATE `creature_template` SET `npcflag`=`npcflag`|1 WHERE `entry` IN (733,3079,3139,3881,5875,7772,9540,13257,14358,14381,14382,14383,15708,16261,16443,16480,18530,19471,20494,20500,21112,21950,22433,22823,23103,23140,23144,23145,23149,23291,23316,23895,24037,25697,26218,26664,27215,27216,28042,28044,28099,28283,28621,29396,29804,30295,30401,30596,30677,30708,30944,31044,31261,32301,33630,33639,33648,35068,35093,36517,37369,37483,37592,37607,37675,37688,37696,37997,37998,37999,38054,38182,38283,38295,38840);
+UPDATE `creature_template` SET `gossip_menu_id`=0, `npcflag`=4224 WHERE `entry` IN (5119);
+UPDATE `creature_template` SET `gossip_menu_id`=0 WHERE `entry` IN (5637);
+
+DELETE FROM `gossip_menu` WHERE `MenuID`=50000; -- npc 2993
+DELETE FROM `npc_text` WHERE `id`=50000;
+
+DELETE FROM `gossip_menu` WHERE `entry`=9856 AND `text_id`=10887;
+INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9856,10887);
+
+UPDATE `creature_template` SET `gossip_menu_id`=5021, `npcflag`=3 WHERE `entry` IN (13257,22567,32048,37369);
+UPDATE `creature_template` SET `gossip_menu_id`=5148, `npcflag`=3 WHERE `entry` IN (13438,22698,31824,37483);