Dallaryen

[Declined][Warlords of Draenor]: Narkk in Booty Bay, npc=2663

5 posts in this topic

Title: Narkk in Booty Bay, npc=2663
Bugtracker Link:


Patch Content:

Patch:

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

DELETE FROM `npc_vendor` WHERE `entry`=2663;
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
('2663', '0', '10728', '1', '0','1', '0', '0', '23420'),
('2663', '0', '8495', '0', '0','1', '0', '0', '23420'),
('2663', '0', '8496', '0', '0','1', '0', '0', '23420');

 

The same issue is present on Legion (Sylvanas):  same codebase.
When fixing, please merge the changes to Legion too, and hit 2 birds with one stone.
Note: the mouse changes to the vendor icon, so the npcflag is set already.

 

Items:
http://www.wowhead.com/item=10728/pattern-black-swashbucklers-shirt#comments
-- maxcount=1 ;  incrtime=?  might have to be set, exact value is unknown, see comments
http://www.wowhead.com/item=8495
http://www.wowhead.com/item=8496

Vendor:
http://www.wowhead.com/npc=2663/narkk

 

1 person likes this

Share this post


Link to post
Share on other sites

 

I do not know how to do that.

Can you explain step by step how to do it?

Share this post


Link to post
Share on other sites
On 12/27/2017 at 2:18 PM, Suicadere said:

 

I do not know how to do that.

Can you explain step by step how to do it?

It is SQL database scripting. This means Structured Query Language database scripting.

Step by Step on understanding what it does.

  • 1
    • UPDATE `creature_template` SET npcflag ='128' WHERE entry='2663';
      • This starts the query off by setting the navigator to target the creature_template in the database, and set the column to npcflag, and the row to entry.
  • 2
    • DELETE FROM `npc_vendor` WHERE `entry`=2663;
      • This then deletes entry 2663 from the npc_vendor which is located either in creature_template or another part of the database depending how it's set up.
  • 3
    • INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
      ('2663', '0', '10728', '1', '0','1', '0', '0', '23420'),
      ('2663', '0', '8495', '0', '0','1', '0', '0', '23420'),
      ('2663', '0', '8496', '0', '0','1', '0', '0', '23420');
      • This script then inserts the selected values which take the place of these fields [Entry], [Slot], [Item], [Maxcount], [ExtendedCost], [Type], [PlayerConditionID], [IgnoreFiltering], and [VerifiedBuild] into the npc_vendor.

Share this post


Link to post
Share on other sites

Greetings Dallaryen,

Unfortunately, we don't support the development of Warlords of Draenor anymore. Your patch is therefore declined.

Regards, Thyvene.

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.