change prices?

[gavsta]

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!

[Xijezu]

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

[Yunchen]

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

[Xijezu]

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

Auch bei price_ratio die ' ' benutzen