[Release]Quarry to stop trading silk items :)

Quote:

Originally Posted by ahmed4ever2u

well as we know ,,, every one have a server with free silks ! might face a small problem

That the players make lot of different account and start trading the silk items to one account !

this one is the greatest !
by [Only registered and activated users can see links. Click Here To Register...]

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%'

================================
the old Quarry

Spoiler

so what i'll share [ STOP TRADING Silk Items ]

Notice this quarry will stop trading & drop & pick for item mall & pets !

PHP Code:

use SRO_VT_SHARD UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_MALL%'

This one made by [Only registered and activated users can see links. Click Here To Register...]Developed by me

For Grap pets

PHP Code:

use SRO_VT_SHARD use SRO_VT_SHARD UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_MYOWON%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_SEOWON%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_RABBIT%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_SPOT_RABBIT%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_GOLDPIG%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_PINKPIG%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_GGLIDER%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_CAT%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_RACCOONDOG%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_BROWNIE%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_PRE_COS_P_WINTER_SNOWMAN%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_GHOST%'

Change SRO_VT_SHARD to ur shard db name if u change ur shard db name .

--------------------------------

For attack pet

PHP Code:

use SRO_VT_SHARD UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_FLUTE_WHITE%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_JINN%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_RAVEN%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_PENGUIN%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_KANGAROO%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_BEAR%' UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0 WHERE CodeName128 like '%ITEM_COS_P_FOX%'

I remove ITEM_COS_P_FLUTE
as it's the Grey Wolf Summon Scroll
the wolf which sell at stable
if u need to disable it from trade too
just add this to query

PHP Code:

UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 WHERE CodeName128 like '%ITEM_COS_P_FLUTE%'

Warring : if u need to disable the trade of Grey Wolf Summon Scroll and enable the trade of the White Wolf Summon Scroll , use this query to disable the Gery Wolf Summon Scroll

PHP Code:

UPDATE [dbo].[_RefObjCommon] SET CanTrade = 0 WHERE CodeName128 like '%ITEM_COS_P_FLUTE'

---------------------------------
If u need to re-enable the trade for any of them again or also to the silk items
change this part from query
From

PHP Code:

SET CanTrade = 0

to

PHP Code:

SET CanTrade = 1

Thanks to abdlfattah for this part 2 :)

ops