Jump to content
Sign in to follow this  
OMGhixD

[SQL - Release] How to remove item cost from all items in a vendor

Recommended Posts

Here is a simple SQL Query that will allow you to remove all the item cost (the actual item cost) of the items within the vendor you are selecting.

 

Simply change "ENTRY OF VENDOR" to the entry of your vendor.

UPDATE item_template SET BuyPrice = 0, SellPrice = 0 WHERE entry IN(SELECT item FROM npc_vendor WHERE entry = 'ENTRY OF VENDOR');

 

Run the query. Watch it do magic and restart your Server.
After the initialized restart, the items should now be 100% free.

 

- PS this has only been tested on Trinitycore Based databases

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

About us

MMO-Society is the Forum former known as Lordcraft, MMO-Society offers various of Resources to help you evolve your knowledge within Emulation, In the process we make sure to form a strong community bond in-between each other and thus we are proud to can admit that MMO-Society is possibly the friendliest Community Forum to currently exist.

Useful Quick-Links

×
×
  • Create New...