Core/Scripts: move npc_mortog_steamhead to DB

Move core script npc_mortog_steamhead to database
- script contains gossip handling + 1 condition
- both actions can be handled in DB settings

1 files changed, 12 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2016_08_14_00_world.sql b/sql/updates/world/3.3.5/2016_08_14_00_world.sql
new file mode 100644
index 00000000000..046d50dddad
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_08_14_00_world.sql
@@ -0,0 +1,12 @@
+-- NPC ID/entry 23373 Mortog Steamhead
+UPDATE `creature_template` SET `ScriptName`= '' WHERE `entry`= 23373;
+
+SET @menu_id := 8692;
+
+DELETE FROM `gossip_menu_option` WHERE `menu_id`= @menu_id;
+INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`OptionBroadcastTextID`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`,`BoxBroadcastTextID`,`VerifiedBuild`) VALUES
+(@menu_id,0,1,"I'd like to browse your goods.",3370,3,128,0,0,0,0,'',0,0);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`= 15 AND `SourceGroup`= @menu_id AND `SourceEntry`= 0 AND `SourceId`= 0;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(15,@menu_id,0,0,0,5,0,942,128,0,0,0,0,'', 'Show gossip menu_id 8692 option id 0 if player is Exalted with Cenarion Expedition.');