-Want query or a method to close off exchanging silk items any help guys?:o
[Help] Want query or a method to close off exchanging silk items.
05/31/2012 02:28
ImagineSro#1
05/31/2012 05:29
•ᵔBeGodOfWarᵔ•#2
There was a one released by dr.moron once , which it disable every pet item (you can edit lines)
06/01/2012 16:49
ImagineSro#3
I searched it and still cant find :S
06/01/2012 17:09
Over-Limit#4
UPDATE _RefObjCommonQuote:
-Want query or a method to close off exchanging silk items any help guys?:o
SET CanTrade = 0
WHERE CodeName128 LIKE '%ITEM_MALL_%_%'
06/02/2012 00:39
IceAmStiel#5
omq
-> Every item in the mall won't be e.g. tradable anymore
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%'