How do i add prices to items?

[LJN]

How do I?

+Rep if you are correct

[Illidan1]

In the table "Items"
There is 2 little "buyprice" and "sellprice"

For buying an Item from a vendor (add 1000 = 1g) to "buyprice" and the item
Will cost 1g in that vendor

For selling an Item to a Vendor (Add 10000 = 10g) to "Sellprice" and then the Item will sell for 10g

There you go mate

[Noobcraft]

lol go to db go to items look for item you wana add price to keep scrolling to the side till you find buy price thier ya go

[Gastricpenguin]

In the `items` table, go to Buyprice and sellprice

Buyprice = How much money the item costs
Sellprice = How much the item sells for

Examples:
Buyprice = 100000 (Costs 10 gold)
Sellprice = 123456 (Sells for 12g 34s 56c)

1 = 1 copper
10 = 10 copper
100 = 1 silver
1000 = 10 silver
10000 = 1 gold
100000 = 10 gold

[LJN]

+Rep x2 gasrtic for examples and for this-

1 = 1 copper
10 = 10 copper
100 = 1 silver
1000 = 10 silver
10000 = 1 gold
100000 = 10 gold

Have to wait 24 hrs.

[Spartansp]

yea you are right for 1 gold is 10000 not 1000 as illidan said hehehe i figured that out with a calculator lol

[latruwski]

UPDATE `items` SET `buyprice`='900000' WHERE (`buyprice`='0');

that is a query to set all items without a buy price to 90gold buyprice...
this is a fast way to edit ALL items without buyprice... you can change the value in the query to whatever you like...

grtz