diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2015-05-20 17:48:30 +0200 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2015-05-20 17:48:30 +0200 |
| commit | fb3a453a7467187b8cb29de8b1a0f8f4971ce53c (patch) | |
| tree | b59e9ec5c9c607622bfb4352782e9a2ae49d6bf5 | |
| parent | 2b15a9b79ad42bb3f7c4340802c0cccaa570cffd (diff) | |
DB/Creature: add gossips to Shenthul
By Killyana, closes #11498
| -rw-r--r-- | sql/updates/world/2015_05_20_06_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_20_06_world.sql b/sql/updates/world/2015_05_20_06_world.sql new file mode 100644 index 00000000000..257ab83e266 --- /dev/null +++ b/sql/updates/world/2015_05_20_06_world.sql @@ -0,0 +1,16 @@ +-- +DELETE FROM `gossip_menu_option` WHERE `menu_id`=21221; +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`, `OptionBroadcastTextID`)VALUES +(21221,0,3,"I would like training.",5,16,0,0,0,0,'', 2603), +(21221,1,0,"I wish to unlearn my talents.",16,16,4461,0,0,0,'', 8271), +(21221,2,0,"I wish to know about Dual Talent Specialization.",1,1,10371,0,0,0,'',33762 ); +DELETE FROM `gossip_menu` WHERE `Entry`=21221 AND `text_id`=4793; +INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (21221, 4793); +UPDATE `npc_text` SET `BroadcastTextId0`=3275 WHERE `id`=1124; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (14,15) AND `SourceGroup`=21221; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(14, 21221, 1124, 0, 15, 8, 0, 0, 0, '', 'Show gossip text if player is a Rogue'), +(14, 21221, 4793, 0, 15, 1527, 0, 0, 0, '', 'Show gossip text if player is not a Rogue'), +(15, 21221, 0, 0, 15, 8, 0, 0, 0, '', 'Show gossip option if player is a rogue'), +(15, 21221, 1, 0, 15, 8, 0, 0, 0, '', 'Show gossip option if player is a rogue'), +(15, 21221, 2, 0, 15, 8, 0, 0, 0, '', 'Show gossip option if player is a rogue'); |