Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- CHANGE THESE VALUES!!!! - if needed ..
- SET @Menu_ID = 50000;
- SET @Text_ID = 300000;
- SET @NPC_Entry = 190000;
- UPDATE smart_scripts SET event_param1 = @Menu_ID+9 WHERE entryorguid = @NPC_Entry AND event_type = 62 AND event_param1 = @Menu_ID AND event_param2 BETWEEN 0 AND 11;
- -- This line deletes the main cities from the original menu.
- DELETE FROM `gossip_menu_option` WHERE `menu_id`=@Menu_ID AND `id` BETWEEN 0 AND 11;
- -- add main menus option
- 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 (@Menu_ID, 3, 2, 'Capital Cities', 1, 1, @Menu_ID+9, 0, 0, 0, '');
- -- delete textIDs for the new menu
- DELETE FROM `gossip_menu` WHERE (`entry`=@Menu_ID+9 AND `text_id`=@Text_ID+1) OR (`entry`=@Menu_ID+9 AND `text_id`=@Text_ID+0);
- -- This line adds "For the Alliance/Horde" to the top of the new City menu.
- INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (@Menu_ID+9, @Text_ID+1);
- INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (@Menu_ID+9, @Text_ID+0);
- DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`=14 AND `SourceGroup`=@Menu_ID+9) OR (`SourceTypeOrReferenceId`=15 AND `SourceGroup`=@Menu_ID+9);
- DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`=15 AND `SourceGroup`=@Menu_ID AND `SourceEntry` BETWEEN 0 AND 11);
- INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, ConditionTypeOrReference, ConditionValue1, Comment) VALUES (14, @Menu_ID+9, @Text_ID+1, 6, 469, 'For the Alliance');
- INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, ConditionTypeOrReference, ConditionValue1, Comment) VALUES (14, @Menu_ID+9, @Text_ID+0, 6, 67, 'For the Horde');
- INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, ConditionTypeOrReference, ConditionValue1, Comment) VALUES
- (15, @Menu_ID+9, 1, 6, 469, 'Stormwind'),
- (15, @Menu_ID+9, 2, 6, 67, 'Orgrimmar'),
- (15, @Menu_ID+9, 3, 6, 469, 'Darnassus'),
- (15, @Menu_ID+9, 4, 6, 469, 'Ironforge'),
- (15, @Menu_ID+9, 5, 6, 469, 'Exodar'),
- (15, @Menu_ID+9, 6, 6, 67, 'Thunder bluff'),
- (15, @Menu_ID+9, 7, 6, 67, 'Undercity'),
- (15, @Menu_ID+9, 8, 6, 67, 'Silvermoon city');
- INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, ConditionTypeOrReference, ConditionValue1, ConditionValue2, ConditionValue3, Comment) VALUES
- (15, @Menu_ID+9, 11, 27, 30, 3, 0, 'Portal Master - Level req'),
- (15, @Menu_ID+9, 10, 27, 57, 3, 0, 'Portal Master - Level req'),
- (15, @Menu_ID+9, 9, 27, 67, 3, 0, 'Portal Master - Level req');
- DELETE FROM `gossip_menu_option` WHERE (`menu_id`=@Menu_ID+9);
- -- These lines add the City teleport options to the main city menu.
- 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 (@Menu_ID+9, 1, 2, 'Stormwind', 1, 1, @Menu_ID, 0, 0, 0, 'Are you sure,that you want to go to Stormwind?');
- 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 (@Menu_ID+9, 2, 2, 'Orgrimmar', 1, 1, @Menu_ID, 0, 0, 0, 'Are you sure,that you want to go to Orgrimmar?');
- 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 (@Menu_ID+9, 3, 2, 'Darnassus', 1, 1, @Menu_ID, 0, 0, 0, 'Are you sure,that you want to go to Darnassus?');
- 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 (@Menu_ID+9, 4, 2, 'Ironforge', 1, 1, @Menu_ID, 0, 0, 0, 'Are you sure,that you want to go to Ironforge?');
- 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 (@Menu_ID+9, 5, 2, 'Exodar', 1, 1, @Menu_ID, 0, 0, 0, 'Are you sure,that you want to go to Exodar?');
- 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 (@Menu_ID+9, 6, 2, 'Thunder bluff', 1, 1, @Menu_ID, 0, 0, 0, 'Are you sure,that you want to go to Thunder bluff?');
- 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 (@Menu_ID+9, 7, 2, 'Undercity', 1, 1, @Menu_ID, 0, 0, 0, 'Are you sure,that you want to go to Undercity?');
- 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 (@Menu_ID+9, 8, 2, 'Silvermoon city', 1, 1, @Menu_ID, 0, 0, 0, 'Are you sure,that you want to go to Silvermoon city?');
- 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 (@Menu_ID+9, 9, 2, 'Dalaran', 1, 1, @Menu_ID, 0, 0, 0, 'Are you sure,that you want to go to Dalaran?');
- 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 (@Menu_ID+9, 10, 2, 'Shattrath', 1, 1, @Menu_ID, 0, 0, 0, 'Are you sure,that you want to go to Shattrath?');
- 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 (@Menu_ID+9, 11, 2, 'Booty bay', 1, 1, @Menu_ID, 0, 0, 0, 'Are you sure,that you want to go to Booty bay?');
- 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 (@Menu_ID+9, 12, 7, 'Back..', 1, 1, @Menu_ID, 0, 0, 0, NULL);
- -- #Success
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement