Remove Item Cost

[crapz]

How can i delete the costs of the item in the vendors ?

[stoneharry]

UPDATE `vendors` SET `item_extendedcost` = '0';
UPDATE `items` SET `vendor_sell_price` = '0';

Adjust column names to correct values + execute into database.

[crapz]

So how can i do it if i want only that the season 2 vendors items sellprice is 0? i hope u understand

[stoneharry]

UPDATE `items` SET `item_vendor_sell` = '0' WHERE `entry` IN (SELECT `itemid` FROM `vendors` WHERE `entry` = 'vendor2ID');

Adjust to your needs (and with item_extended cost as well):

UPDATE `vendors` SET `item_extendedcost` WHERE `npc` = 'vendor2ID';