From 0c6eeb3abc54dbc0f147e5098619e8e19e27accd Mon Sep 17 00:00:00 2001 From: tkrokli Date: Sun, 14 Aug 2016 09:50:28 +0200 Subject: 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 --- sql/updates/world/3.3.5/2016_08_14_00_world.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_08_14_00_world.sql (limited to 'sql') 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.'); -- cgit v1.2.3