diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_01_07_00_world.sql | 12 |
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); |