Item Monetary Values

[fallen45078]

Where would one find the values of items? The short is that I want to completely fill the auction house, but I want to set each item's price to equal the buy back price at npc shops. Im trying to find a balance between item availability and the economy of my server. The idea is to stop someone from buying an item from the auction house and immediately selling it for a profit at an npc.

I would have assumed it'd be stored in a table, but I cant seem to find it.

[whasf]

They're in the individual scripts for the NPC that sells them.

[fallen45078]

I found what I was looking for in the item_basic table. This table lists the sell value for each item.

What I need now is the SQL command that would set the price on item 123456 on the auction house to the value listed in the table item_basic for item 123456.

[fallen45078]

Here's the solution. Posting this because no one ever posts how they solved their problem..

UPDATE auction_house
SET price = (SELECT BaseSell
FROM item_basic
WHERE auction_house.itemid = item_basic.itemid)
WHERE EXISTS (SELECT BaseSell
FROM item_basic
WHERE auction_house.itemid = item_basic.itemid);





this query will set your auction house prices to equal what the "sell" price TO the npc shop is. This closes the loophole of players buying cheap in the auction house and selling the items to an NPC shop for profit.

[nasomi]

That would set the price, but it wouldn't fill the AH. Also be weary of crafting mats, many guild npc's will buy items back for more than the base_sell in item_basic.

[fallen45078]

You're correct, but setting the price was all I needed. My auction house was already populated at 100 gil per item.