[Release]Quarry to stop trading silk items :)

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

PHP Code:


			
SET CanTrade = 1

Thanks to abdlfattah for this part 2 :)

Quote:

use SRO_VT_SHARD
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_C_OSTRICH%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_C_PEGASUS%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_T_WHITEELEPHANT%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_T_RHINOCEROS%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_C_TIGER%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_C_WILDPI%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_C_SCARABAEUS%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_T_BUFFALO%'