Increasing Item costs over whole Database?

[kreegoth]

Just wondering if it is possible to increase the cost of all items by a person by writing a certain Query into Navicat?

something like Insert into 'items' 100000 where "buyprice" = 0...


I want to make it so that the Tier gear and Arena gear costs money but figured somehting like this would be a lot easier than manually editing each piece of gear in the database?..

[Sorayazlawl]

UPDATE items SET buyprice = '1000000' WHERE buyprice = '0';

[kreegoth]

Thanks very much so .. that helped alot:P nice response time as well