Problem in the prices

03/08/2012 15:42 Mra-z#1
Prices have become high
How do I return to the default mode
plz help
03/08/2012 17:13 Turtlefight#2
just launch this sql-Querry:

Code:
UPDATE [Arcadia].[dbo].[ItemResource]
SET price = 0
03/08/2012 21:48 mlejnek2#3
i would recomend se them to 1 that way you can use the market_resorses to set the price easyer to what you whant for all items in you Shops
03/08/2012 22:05 ismokedrow#4
Quote:
Originally Posted by Turtlefight View Post
just launch this sql-Querry:

Code:
UPDATE [Arcadia].[dbo].[ItemResource]
SET price = 0
WARNING THIS WILL MAKE ALL PRICES IN YOUR SERVER FOR ALL ITEMS 0


To specify which items to change:

Code:
USE Arcadia
UPDATE dbo.ItemResource
SET price = 'xxx'
WHERE id='item_id'
GO