[Release]Quarry to stop trading silk items :)

[ahmed4ever2u]

i'm sorry for sharing my idea's

[IceAmStiel]

Why didn't you simply use the Item Mall itself as an indicator for those items?

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 which is located in the Mall will be changed

[ahmed4ever2u]

Originally Posted by IceAmStiel

Why didn't you simply use the Item Mall itself as an indicator for those items?

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 which is located in the Mall will be changed

you are the best i'm just a student tring to learn

[ღ"Star"ღ]

useful query

[ahmed4ever2u]

1st post updated

[TheShinichi]

Need change something in media.pk2 ?

[ahmed4ever2u]

no you don't need to change anything

[Keyeight]

good work Ahmed and btw happy ramadan

[•ᵔKralᵔ•]

Nice Post Bro Thx

[thetomp2009]

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

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