[Help] Want query or a method to close off exchanging silk items.

[ImagineSro]

-Want query or a method to close off exchanging silk items any help guys?

[•ᵔBeGodOfWarᵔ•]

There was a one released by dr.moron once , which it disable every pet item (you can edit lines)

[ImagineSro]

I searched it and still cant find :S

[Over-Limit]

Originally Posted by ImagineSro

-Want query or a method to close off exchanging silk items any help guys?

UPDATE _RefObjCommon
SET CanTrade = 0
WHERE CodeName128 LIKE '%ITEM_MALL_%_%'

[IceAmStiel]

omq

PHP Code:

UPDATE _RefObjCommon
SET CanTrade = 0
--,CanBorrow = 0 --If you want them not to be able to store the items
FROM _RefObjCommon as ref
LEFT JOIN _RefShopGoods as goods on 'PACKAGE_'+ref.CodeName128 = goods.RefPackageItemCodeName
WHERE RefTabCodeName like '%MALL%' AND RefTabCodeName NOT like '%MALL_TEST%' 


-> Every item in the mall won't be e.g. tradable anymore