diff options
| author | Malcrom <malcromdev@gmail.com> | 2013-06-26 13:36:53 -0230 |
|---|---|---|
| committer | Malcrom <malcromdev@gmail.com> | 2013-06-26 13:36:53 -0230 |
| commit | 4761590c4a03933910447da766aa70823362f16f (patch) | |
| tree | 875213059c4de83ea5863a02671fea22df8f61f3 /sql | |
| parent | f4bceb86c045565d52e12b157ea6aa4abbdb1835 (diff) | |
Core/Scripting: Update Injured Goblin Miner script to use DB gossip.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2013_06_26_02_world_gossip.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2013_06_26_02_world_gossip.sql b/sql/updates/world/2013_06_26_02_world_gossip.sql new file mode 100644 index 00000000000..56c41e18b38 --- /dev/null +++ b/sql/updates/world/2013_06_26_02_world_gossip.sql @@ -0,0 +1,9 @@ +-- Add Any Missing Gossip Option for Injured Goblin Miner +DELETE FROM `gossip_menu_option` WHERE menu_id IN (9859); +INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`)VALUES +(9859,0,0,"I am ready, lets get you out of here.",1,1,0,0,0,0,''); + +-- Add Gossip option condition +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN (9859); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,9859,0,0,28,12832,0,0,1,0,'','Injured Goblin Miner - Show gossip option only if quest "Bitter Departure" is not complete'); |