[Legion]: Marcia Chase <Fishing Trainer & Supplies>

[Herculano]

Title: Marcia Chase <Fishing Trainer & Supplies>
Bugtracker Link:

https://firestorm-servers.com/es/report/see_report/31762

Patch Content:

-- Marcia Chase <Fishing Trainer & Supplies>
-- http://www.wowhead.com/npc=28742

DELETE FROM `gossip_menu` WHERE `entry`=19344;
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
(19344, 28502);

DELETE FROM `gossip_menu_option` WHERE `menu_id`=19344;
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES
(19344, 1, 1, 'Me gustaría comprarte algo.', 0, 0, 0, 0, '', 0),
(19344, 0, 3, 'Quiero instruirme en la pesca.', 0, 0, 0, 0, '', 0);

UPDATE `creature_template` SET gossip_menu_id='19344' WHERE entry='95844';
UPDATE `creature_template` SET npcflag ='193' WHERE entry='95844';

DELETE FROM `npc_vendor` WHERE `entry`=95844;
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
(95844, 15, 138963, 0, 0, 1, 0, 0, 23420), -- Aparato agarrador diminuto
(95844, 14, 138962, 0, 0, 1, 0, 0, 23420), -- Estrella marina con hilo
(95844, 13, 138961, 0, 0, 1, 0, 0, 23420), -- Agente de enlace alquímico
(95844, 12, 138960, 0, 0, 1, 0, 0, 23420), -- Cristal de los deseos
(95844, 11, 138959, 0, 0, 1, 0, 0, 23420), -- Generador de microvórtices
(95844, 10, 138958, 0, 0, 1, 0, 0, 23420), -- Pegote de superadhesivo
(95844, 9, 138957, 0, 0, 1, 0, 0, 23420), -- Sardina aurífaga
(95844, 8, 138956, 0, 0, 1, 0, 0, 23420), -- Cebo hipermagnético
(95844, 7, 35951, 0, 0, 1, 0, 0, 23420), -- Salmón emperador pochado
(95844, 6, 33451, 0, 0, 1, 0, 0, 23420), -- Filete de Aleta Helada
(95844, 5, 6532, 0, 0, 1, 0, 0, 23420), -- Adornos brillantes
(95844, 4, 6530, 0, 0, 1, 0, 0, 23420), -- Reptadores nocturnos
(95844, 3, 6529, 0, 0, 1, 0, 0, 23420), -- Adorno lustroso
(95844, 2, 136377, 0, 0, 1, 0, 0, 23420), -- Corcho descomunal
(95844, 1, 6256, 0, 0, 1, 0, 0, 23420); -- Caña de pescar

DELETE FROM `npc_trainer` WHERE ID ='95844';
INSERT INTO `npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillLine`, `ReqSkillRank`, `ReqLevel`) VALUES
('95844', '7620', '100', '356', '0', '1'),
('95844', '7731', '500', '356', '50', '1'),
('95844', '7732', '10000', '356', '125', '1'),
('95844', '18248', '25000', '356', '200', '1'),
('95844', '33095', '100000', '356', '275', '1'),
('95844', '51294', '150000', '356', '350', '1'),
('95844', '88868', '250000', '356', '425', '1'),
('95844', '110410', '300000', '356', '500', '1'),
('95844', '158743', '300000', '356', '575', '1');