[Legion]: Provisioner Whitecloud <Guardians of Hyjal Quartermaster>

[Herculano]

Title: Provisioner Whitecloud <Guardians of Hyjal Quartermaster>
Bugtracker Link:

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

Patch Content:

UPDATE `creature_template` SET npcflag ='128' WHERE entry='50314';

DELETE FROM `npc_vendor` WHERE `entry`=50314;
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
('50314', '0', '62374', '0', '0','1', '0', '0', '23420'),
('50314', '1', '62375', '0', '0','1', '0', '0', '23420'),
('50314', '2', '62376', '0', '0','1', '0', '0', '23420'),
('50314', '3', '62377', '0', '0','1', '0', '0', '23420'),
('50314', '4', '62378', '0', '0','1', '0', '0', '23420'),
('50314', '5', '62380', '0', '0','1', '0', '0', '23420'),
('50314', '6', '62381', '0', '0','1', '0', '0', '23420'),
('50314', '7', '62382', '0', '0','1', '0', '0', '23420'),
('50314', '8', '62383', '0', '0','1', '0', '0', '23420'),
('50314', '9', '62384', '0', '0','1', '0', '0', '23420'),
('50314', '10', '62385', '0', '0','1', '0', '0', '23420'),
('50314', '11', '62386', '0', '0','1', '0', '0', '23420'),
('50314', '12', '65906', '0', '0','1', '0', '0', '23420'),
('50314', '13', '138803', '0', '0','1', '0', '0', '23420');

 

[Tavari]

On 8.2.2017 at 5:23 AM, Herculano said:

Title: Provisioner Whitecloud <Guardians of Hyjal Quartermaster>
Bugtracker Link:

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

Patch Content:

 

UPDATE `creature_template` SET npcflag ='128' WHERE entry='50314';

DELETE FROM `npc_vendor` WHERE `entry`=50314;
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
('50314', '0', '62374', '0', '0','1', '0', '0', '23420'),
('50314', '1', '62375', '0', '0','1', '0', '0', '23420'),
('50314', '2', '62376', '0', '0','1', '0', '0', '23420'),
('50314', '3', '62377', '0', '0','1', '0', '0', '23420'),
('50314', '4', '62378', '0', '0','1', '0', '0', '23420'),
('50314', '5', '62380', '0', '0','1', '0', '0', '23420'),
('50314', '6', '62381', '0', '0','1', '0', '0', '23420'),
('50314', '7', '62382', '0', '0','1', '0', '0', '23420'),
('50314', '8', '62383', '0', '0','1', '0', '0', '23420'),
('50314', '9', '62384', '0', '0','1', '0', '0', '23420'),
('50314', '10', '62385', '0', '0','1', '0', '0', '23420'),
('50314', '11', '62386', '0', '0','1', '0', '0', '23420'),
('50314', '12', '65906', '0', '0','1', '0', '0', '23420'),
('50314', '13', '138803', '0', '0','1', '0', '0', '23420');

 

 

INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`, `PlayerConditionID`, `VerifiedBuild`) VALUES

It should be like that.

 

('50314', '0', '62374', '0', '0','1', '0', '0', '23420'),

You forgot the Cost of the Item.

[Mikrole]

The NPC is already fixed.