Hi, can someone share with me how to adjust product price in SQL Server?

[qbaolm1]

Hi, can someone share with me how to adjust product price in SQL Server?

[Worshiper]

Originally Posted by qbaolm1

Hi, can someone share with me how to adjust product price in SQL Server?

Price of what item in npc and item mall ?

[qbaolm1]

Originally Posted by Worshiper

Price of what item in npc and item mall ?

I want to change any number

Originally Posted by Worshiper

Price of what item in npc and item mall ?

I can't use this tool because my database is not standard.

[akaSteven.]

Update _RefPricePolicyOfItem Set Cost = 500 where RefPackageItemCodeName Like 'PACKAGE_ITEM_CODENAME'

[qbaolm1]

Originally Posted by Worshiper

Price of what item in npc and item mall ?

Originally Posted by akaSteven.

Update _RefPricePolicyOfItem Set Cost = 500 where RefPackageItemCodeName Like 'PACKAGE_ITEM_CODENAME'

i changed it and it doesn't work

Do you have any specific videos I can watch?

[Shuma20]

To see the effect you need to update your media.pk2 side too ( refpricepolicyofitem.txt ) edit the price same as you done in SQL

[Xero1993]

database _RefPricePolicyOfItem

and media RefPricePolicyOfItem.txt