change prices?

11/23/2011 01:56 gavsta#1

hello iv made an NPC for Gaia cards. i would like to change the price in the whole shop how do i do it want them all to be 5mil each!

11/23/2011 02:03 Xijezu#2

Either ItemResource (UPDATE ItemResource SET price = '5000000' WHERE id = 'skillcard')
Or MarketResource (UPDATE MarketResource SET price_ratio = '500 (for example)' WHERE name = 'gaia_etc')

11/23/2011 02:03 Yunchen#3

UPDATE [Arcadia].[dbo].[MarketResource]
SET [price_ratio] = 'ammount here'
WHERE [name] = 'name of npc here'
GO

Example :

UPDATE [Arcadia].[dbo].[MarketResource]
SET [price_ratio] = '1'
WHERE [name] = 'TH_creature_give_start'
GO

11/23/2011 02:07 Xijezu#4

Code:

UPDATE [Arcadia].[dbo].[MarketResource]
SET [price_ratio] = '1'
WHERE [name] = 'TH_creature_give_start'
GO

Auch bei price_ratio die ' ' benutzen ;)