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

Ref #22912

1 files changed, 12 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_01_09_00_world.sql b/sql/updates/world/3.3.5/2019_01_09_00_world.sql
new file mode 100644
index 00000000000..6a892978156
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_01_09_00_world.sql
@@ -0,0 +1,12 @@
+-- 
+UPDATE `creature_template` SET `npcflag`=`npcflag`|1 WHERE `entry` IN (4794,5190,5191,6626,7937,9598,14368,16610,23139,23376,25841,26666,28284,29319,29327,30007,30631,33956,33957);
+UPDATE `creature_template` SET `gossip_menu_id`=0 WHERE `entry` IN (2080,2501);
+
+DELETE FROM `gossip_menu` WHERE `MenuID` IN (2080,2502);
+DELETE FROM `npc_text` WHERE `id` IN (2080,2505);
+
+DELETE FROM `quest_greeting` WHERE `Id` IN (2501);
+INSERT INTO `quest_greeting` (`Id`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES
+(2501, 0, 0, 0, 'Oy!  You here for a game of knuckles?', 0);
+
+UPDATE `smart_scripts` SET `action_param1`=3 WHERE `entryorguid`=3395700 AND `source_type`=9 AND `id`=13;