• Announcements

    • Otacon

      Securing a Firestorm Account   11/16/19

      Securing your account is very important, so please read our guideline here:    
    • Melfela

      International Game Master Recruitment   04/27/21

        Greetings! The Firestorm International Staff is currently looking for Game Masters! Here you can see the state of recruitment for each expansion: Sethraliss, our Battle for Azeroth realm: OPENED Sylvanas & Greymane, our Legion realms: OPENED Garrosh, our Mists of Pandaria realm: OPENED  
      What is a Game Master ?

      A Game Master's role is to help players, to guide them in their journey and to make sure that everyone's stay on Firestorm is as pleasant as possible, by making sure that we all respect the rules, and each other.
      You will thus be a support for the whole international community in game, and on the forum.  
        Prerequisites: A good knowledge of WoW as a whole, but with a strong emphasize on the expansion you are applying on.  Proper english skills, including a flawless spelling and the capability to follow and answer in a voice conversation. Having a great level of patience and compassion when in contact with players! Being at least 18 years old, and mature Having a functional mic, and a valid discord account A strong will to help, and being able to listen, not just hear! Being able to organize and schedule your own time  Being available at least 10 hours a week, regularly (if you can log 10h the weekend, but not at all during the week it won't do!) Being able to work autonomously but also being comfortable talking with your team!   Will be a good addition to your resume: Having a knowledge of GM Commands (Trinity / Mangos) Having a GM experience, even on another server (if so, which one ?) Anything that you can put forward in your application, that would make us chose you over someone else!  
       
      How to apply?  
      ↓ If you think you would fit in the position, and wish to join the International GM team, please write us an email here: ↓
      »   fsrecruitmentinter@gmail.com   «
      Knowing and mastering everything isn't required! You will join a team of people with their own set of skills: diversity is a good thing!   When you send your application, the email must necessarily have: In the subject, the proper expansion tag: [BFA] / [Legion] / [MOP]  Your discord account username & tag. Example: Discord#1234 All of your Firestorm account emails Your forum account name       The more information and details you provide, the better! It shows involvement, but also helps us evaluate your potential as individual, and within the team.
      Telling us that you're motivated in two lines probably won't work out: we expect to get to know you a little bit when reading your application. To get some insight on you, your personnal experience and knowledge!

      Your application will be reviewed and we will send you an email back with our answer, usually within a week. If it gets accepted we will contact you directly on discord to proceed with a voice interview in order to get to know each other better!

       
      If you have any questions regarding the international GM position, you can send a private message to either Melfela#2038 or 'Pantoufle™#8984 on discord.
      The International staff thanks you for your interest, and hopes to hear from you soon!
    • Melfela

      International Moderator Recruitment   04/27/21

        Greetings, The Firestorm Team is currently looking for Forum and Discord Moderators to reinforce its ranks. It is possible to apply for one of the two platforms only.     Who are we, what are our jobs? The moderators are the people mainly in charge of monitoring the Firestorm forum and the International rooms on the public Discord. They have almost no power in game and will never intervene in game (except in very exceptional cases). They monitor the forum in terms of its content, moderate, warn and sanction people who do not respect the rules. They also provide assistance to players and respond to those who encounter problems.     How to apply ? Applications should be sent to the following address: >> fsrecruitmentinter@gmail.com <<
      The subject of the email must start with the [Moo] tag.
      A minimum of information is to be provided when applying. It goes without saying that two lines to say that you are motivated will not be enough.
      We expect from you in this application an expression and development of your experiences / knowledge / personal information. If your application interests us, you will be contacted automatically by Discord or by email for a possible interview and then a test period will follow, the duration of which will depend entirely on you. Please indicate your nickname on the forum and that of discord so that we can look at your background and your behavior there.
      Are required in your application: Be 16 years of age or older. Impeccable spelling. Know how to use a forum correctly. A minimum of knowledge on WoW. Being able to keep your cool, have rigor, regularity and autonomy. Discord & a functional microphone to facilitate intra-staff communication. Will be a plus for your application: Relatively wide schedules. Have already been a moderator on other forums or other discords (if so, indicate which ones). And what you may find interesting to highlight.   Please indicate your nickname on the forum and that of discord so that we can look at your background and your behavior there.   The Firestorm Team thanks you for your future involvement.
      See you soon.
    • Hanzo

      International Firestorm Team Roster   08/21/21

      Here, you can find the list of members of the International Firestorm team. This topic also allows you to verify the team's identity so you won't make any mistakes or get scammed by a malicious player impersonating a staff member. Please note that no team member will ever ask for your credentials or personal information.  
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