giftsilk/pointsilk problem

[Desperado1337]

#Solved
i have problem with giftsilk and pointsilk
first
gift silk:
when i bought items from f10 it used gift silk
i want it not used gift silk

point silk:
when i bought items from npc it not used point silk but when use gift silk it work fine

[JohnDornel^]

Delete the unused paymentdevices from _RefPricePolicyOfItem.
2 - silk
4 - gift_silk
16 - silk_point
Whatever you have as Cost = 0, delete it. It will work. (Import back to media ofc)

[Desperado1337]

Originally Posted by JohnDornel^

Delete the unused paymentdevices from _RefPricePolicyOfItem.
2 - silk
4 - gift_silk
16 - silk_point
Whatever you have as Cost = 0, delete it. It will work. (Import back to media ofc)

can you explain more please
there Query ?

[#HB]

His answer is very clear actually.

[Desperado1337]

Solved by JohnDornel
thx #HB
Use this query

 Spoiler

DELETE FROM SRO_VT_SHARD.dbo._RefPricePolicyOfItem where Cost = '0'AND PaymentDevice = '16'