[Release]Quarry to stop trading silk items :)

[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

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

[_LastSoul_]

Th@nks.

but i hope you share thing like how to add Code's For Silk like joymax

[18andLife]

update _RefObjCommon
set CanTrade = 0
where CodeName128 like 'ITEM_MALL%'

^then you can't trade any item mall items

[ahmed4ever2u]

#1st post updated
Have Fun

18andlife i swear i didn't quote it from you


for me xD

[MKNocivo]

no one really gives a ****,when its free silks they never run out so, infinite pet and ****

[_LastSoul_]

Originally Posted by ahmed4ever2u

#1st post updated
Have Fun

18andlife i swear i didn't quote it from you


for me xD

are you can make thing like how to add Code's For Silk like joymax?

[Keyeight]

Originally Posted by _LastSoul_

are you can make thing like how to add Code's For Silk like joymax?

im sorry but can you till me what you mean with add Code`s for silk !

[JungleRules]

Originally Posted by mats0o0o0

im sorry but can you till me what you mean with add Code`s for silk !

He Mean That
Card by 50 silk
Serial number
194974487
e-pin number
ahmed abdelhady
and it should be alot codes
and the code can charge for 1 time only
another card 50 silk
serial number
198497971647
e-pin number
merrychristmas
like that

[3lyka]

so its look like
use SRO_VT_SHARD
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 1
WHERE CodeName128 like '%ITEM_MALL%'

its is can make u trade any item mall item?

[InZiDeR]

Originally Posted by ahmed4ever2u

PHP Code:

use SRO_VT_SHARD
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS%' 


sorry to say but then are all pets are untradeable xD

[!x_~!]

Originally Posted by InZiDeR

sorry to say but then are all pets are untradeable xD

lol

[Dr.Abdelfattah]

PHP Code:

use SRO_VT_SHARD
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS%' 


about that query will disable the trade for all pets (not only the silk pets) .

[hamada619]

with this neveria sro admins will add free silks

[_LastSoul_]

Originally Posted by JungleRules

He Mean That
Card by 50 silk
Serial number
194974487
e-pin number
ahmed abdelhady
and it should be alot codes
and the code can charge for 1 time only
another card 50 silk
serial number
198497971647
e-pin number
merrychristmas
like that

+1

[ahmed4ever2u]

Originally Posted by Dr.Abdelfattah

PHP Code:

use SRO_VT_SHARD
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS%' 


about that query will disable the trade for all pets (not only the silk pets) .

i know xD

Originally Posted by _LastSoul_

+1

not for free ^_^