SQL: Vendor - RageGate/ServerStuff GitHub Wiki

##Vendor Queries

###update the extendedcostID to the desired NPCID (this will affect every item that the NPC sells)

UPDATE 'npc_vendor' set 'extendedcost' = 'EXTENDEDCOSTID' where entry = 'NPCID';

###update the extendedcostID of the desired Item ID (this will affect every item with the specific ID)

UPDATE 'npc_vendor' set 'extendedcost' = 'EXTENDEDCOSTID' where item = 'itemid';

###MultiVendor gossip option (requires multivendor patch)

INSERT INTO `gossip_menu_option` VALUES ('GOSSIPMENUID', 'REQUIRESOWNID', '4', 'OPTION NAME', '0', '3', '128', 'VENDORID', '0', '0', '0', '', '0');