Sign in to follow this  
Followers 0
Florix

[Declined][Mists of Pandaria]: Whittler Dewei

2 posts in this topic

Title: Whittler Dewei
Bugtracker Link:


Patch Content:

Seems like this NPC https://www.wowhead.com/npc=57620/whittler-dewei isn't training, only selling

 

Some columns might be wrong.

 

UPDATE `creature_template` SET `gossip_menu_id`='15125',`npcflag`='4305' WHERE `entry`='57620';

DELETE FROM `gossip_menu_option`  WHERE `MenuId`='15125');
INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionType`, `OptionNpcFlag`, `WDBVerified`) VALUES
(15125, 11, 0, 'Tell me about gathering professions.', 1, 1, 15544),
(15125, 12, 0, 'Tell me about production professions.', 1, 1, 15544),
(15125, 13, 1, 'Show me your wares, please.', 3, 128, 15544);

DELETE FROM `gossip_menu` WHERE `MenuId`='15125';
INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `WDBVerified`) VALUES
(15125, 17125, 0); -- TextId might be incorrect / not matching text

DELETE FROM `gossip_menu_option_action` WHERE `MenuId`='15125';
INSERT INTO `gossip_menu_option_action` (`MenuId`, `OptionIndex`, `ActionMenuId`, `ActionPoiId`) VALUES
(15125, 12, 12186, 0),
(15125, 11, 12185, 0);

 

1 person likes this

Share this post


Link to post
Share on other sites

Hey Flo, thanks for making the patch, however, the MoP DB doesn't follow that structure for us, and there were a loooot of bugs with the gossips of this NPC.

I have attached the patch I made and that will be applied with the next changelog for your information. I have made it as close to blizzlike as possible, without introducing custom values.

Spoiler


-- NPC should be a trainer (Got report from forum)
UPDATE `creature_template` SET `gossip_menu_id`=12180, `npcflag`=4305 WHERE `entry`IN(57620);
UPDATE `creature` SET `npcflag`=4305 WHERE `id`IN(57620);
DELETE FROM `gossip_menu_option` WHERE `menu_id`=12180;
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`) VALUES
(12180, 1, 3, 'Train me.', 5, 16, 0),
(12180, 2, 0, 'Tell me about gathering professions.', 1, 1, 12185),
(12180, 3, 0, 'Tell me about production professions.', 1, 1, 12186),
(12180, 4, 1, 'Show me your wares, please.', 3, 128, 0);




-- Gathering
DELETE FROM `gossip_menu_option` WHERE `menu_id`=12185;
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`) VALUES
(12185, 0, 0, 'Tell me about herbalism', 1, 1, 12188),
(12185, 1, 0, 'Tell me about Mining', 1, 1, 12189),
(12185, 2, 0, 'Tell me about Skinning', 1, 1, 12190);

-- Herbalism
UPDATE `gossip_menu_option` SET `action_menu_id`=12191, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12188 AND `id`=12; -- alchemy
UPDATE `gossip_menu_option` SET `action_menu_id`=12196, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12188 AND `id`=13; -- inscription
UPDATE `gossip_menu_option` SET `action_menu_id`=12185, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12188 AND `id`=14; -- gathering
UPDATE `gossip_menu_option` SET `action_menu_id`=12186, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12188 AND `id`=15; -- production

-- mining
UPDATE `gossip_menu_option` SET `action_menu_id`=12192, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12189 AND `id`=12; -- blacksmithing
UPDATE `gossip_menu_option` SET `action_menu_id`=12195, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12189 AND `id`=13; -- engineering
UPDATE `gossip_menu_option` SET `action_menu_id`=12197, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12189 AND `id`=14; -- jewelcrafting
UPDATE `gossip_menu_option` SET `action_menu_id`=12185, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12189 AND `id`=15; -- gathering
UPDATE `gossip_menu_option` SET `action_menu_id`=12186, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12189 AND `id`=16; -- production

-- skinning
DELETE FROM `gossip_menu_option` WHERE `menu_id`=12190 AND `id`=9; -- duplicate
UPDATE `gossip_menu_option` SET `action_menu_id`=12198, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12190 AND `id`=12; -- leatherworking
UPDATE `gossip_menu_option` SET `action_menu_id`=12185, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12190 AND `id`=13; -- gathering
UPDATE `gossip_menu_option` SET `action_menu_id`=12186, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12190 AND `id`=14; -- production

-- production
DELETE FROM `gossip_menu_option` WHERE `menu_id`=12186 AND `id`IN(3,8); -- duplicates

UPDATE `gossip_menu_option` SET `action_menu_id`=12191, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12186 AND `id`=11; -- alchemy
UPDATE `gossip_menu_option` SET `action_menu_id`=12192, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12186 AND `id`=12; -- blacksmithing
UPDATE `gossip_menu_option` SET `action_menu_id`=12193, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12186 AND `id`=13; -- enchanting
UPDATE `gossip_menu_option` SET `action_menu_id`=12195, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12186 AND `id`=14; -- engineering
UPDATE `gossip_menu_option` SET `action_menu_id`=12196, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12186 AND `id`=15; -- inscription
UPDATE `gossip_menu_option` SET `action_menu_id`=12197, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12186 AND `id`=16; -- jewelcrafting
UPDATE `gossip_menu_option` SET `action_menu_id`=12198, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12186 AND `id`=17; -- leatherworking
UPDATE `gossip_menu_option` SET `action_menu_id`=12199, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12186 AND `id`=18; -- tailoring
UPDATE `gossip_menu_option` SET `action_menu_id`=12185, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12186 AND `id`=19; -- gathering


-- alchemy
UPDATE `gossip_menu_option` SET `action_menu_id`=12188, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12191 AND `id`=12; -- herbalism
UPDATE `gossip_menu_option` SET `action_menu_id`=12196, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12191 AND `id`=13; -- inscription
UPDATE `gossip_menu_option` SET `action_menu_id`=12185, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12191 AND `id`=14; -- gathering
UPDATE `gossip_menu_option` SET `action_menu_id`=12186, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12191 AND `id`=15; -- production

-- blacksmithing
UPDATE `gossip_menu_option` SET `action_menu_id`=12189, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12192 AND `id`=12; -- mining
UPDATE `gossip_menu_option` SET `action_menu_id`=12185, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12192 AND `id`=13; -- gathering
UPDATE `gossip_menu_option` SET `action_menu_id`=12186, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12192 AND `id`=14; -- production

-- enchanting 12193
UPDATE `gossip_menu_option` SET `action_menu_id`=12199, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12193 AND `id`=12; -- tailoring
UPDATE `gossip_menu_option` SET `action_menu_id`=12185, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12193 AND `id`=13; -- gathering
UPDATE `gossip_menu_option` SET `action_menu_id`=12186, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12193 AND `id`=14; -- production

-- engineering 12195
UPDATE `gossip_menu_option` SET `action_menu_id`=12189, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12195 AND `id`=12; -- mining
UPDATE `gossip_menu_option` SET `action_menu_id`=12185, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12195 AND `id`=13; -- gathering
UPDATE `gossip_menu_option` SET `action_menu_id`=12186, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12195 AND `id`=14; -- production

-- inscription 12196
UPDATE `gossip_menu_option` SET `action_menu_id`=12188, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12196 AND `id`=12; -- herbalism
UPDATE `gossip_menu_option` SET `action_menu_id`=12185, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12196 AND `id`=13; -- gathering
UPDATE `gossip_menu_option` SET `action_menu_id`=12186, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12196 AND `id`=14; -- production

-- jewelcrafting 12197
UPDATE `gossip_menu_option` SET `action_menu_id`=12189, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12197 AND `id`=12; -- mining
UPDATE `gossip_menu_option` SET `action_menu_id`=12185, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12197 AND `id`=13; -- gathering
UPDATE `gossip_menu_option` SET `action_menu_id`=12186, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12197 AND `id`=14; -- production

-- leatherworking 12198
UPDATE `gossip_menu_option` SET `action_menu_id`=12190, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12198 AND `id`=12; -- skinning
UPDATE `gossip_menu_option` SET `action_menu_id`=12185, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12198 AND `id`=13; -- gathering
UPDATE `gossip_menu_option` SET `action_menu_id`=12186, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12198 AND `id`=14; -- production

-- tailoring 12199
UPDATE `gossip_menu_option` SET `action_menu_id`=12193, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12199 AND `id`=12; -- enchanting
UPDATE `gossip_menu_option` SET `action_menu_id`=12185, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12199 AND `id`=13; -- gathering
UPDATE `gossip_menu_option` SET `action_menu_id`=12186, `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=12199 AND `id`=14; -- production

 

 

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  
Followers 0