[Release]Quarry to stop trading silk items :)

[Dr.Abdelfattah]

Originally Posted by ahmed4ever2u

i know xD



not for free ^_^

Quarry to stop trading silk items

so maybe this query of pets make problems for some people ,
u need another query to disable trade of silk pets .
maybe mint and i will make 1 !

[ahmed4ever2u]

Originally Posted by Dr.Abdelfattah

Quarry to stop trading silk items

so maybe this query of pets make problems for some people ,
u need another query to disable trade of silk pets .
maybe mint and i will make 1 !

you have to put the full code for every pet !
its not Like %ITEM_MALL_COS% this won't work

[Dr.Abdelfattah]

Originally Posted by ahmed4ever2u

you have to put the full code for every pet !
its not Like %ITEM_MALL_COS% this won't work

ya ya

[ahmed4ever2u]

Originally Posted by 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?

yep

[Dr.Abdelfattah]

This is query to disable trade for pickup pets

PHP Code:

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


Change SRO_VT_SHARD to ur shard db name if u change ur shard db name .
i will add for the silk attac pets too

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

This query for attack pet to disable the silk attack pets from trade

PHP Code:

use SRO_VT_SHARD
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_P_FLUTE_WHITE%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_P_JINN%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_P_RAVEN%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_P_PENGUIN%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_P_KANGAROO%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0
WHERE CodeName128 like '%ITEM_COS_P_BEAR%'
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 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 


[Nezekan]

[GoneUp]

xD...

You can still drop and pickup it. So it is completely useless

[_LastSoul_]

Originally Posted by ahmed4ever2u

i know xD



not for free ^_^

ur offer?

[ahmed4ever2u]

Originally Posted by GoneUp

xD...

You can still drop and pickup it. So it is completely useless

oke i'll fix it :-p so simple So easy !

edit: now silk items & pets can't be trade, drop and picked !

[PortalDark]

why u wanna do pets untradeable anyway?

[ahmed4ever2u]

well my server is a pvp server ! i give free silks ! & free gold & free every thing !
i just don't need from any one to farm silk items
i share what i have
Will be weird if i told you i have disabled the Gold trade , drop !

[Dr.Abdelfattah]

Oh I forgot the part of transport pets and trade pets

PHP Code:

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


Those codes i find for new COS
ITEM_COS_C_DRACO
ITEM_COS_C_UNICORN
maybe it will help some people to add new horse lvl 90 or 110 !

[ahmed4ever2u]

Originally Posted by Dr.Abdelfattah

Oh I forgot the part of transport pets and trade pets

PHP Code:

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


Those codes i find for new COS
ITEM_COS_C_DRACO
ITEM_COS_C_UNICORN
maybe it will help some people to add new horse lvl 90 or 110 !

thank you added to the first post

[sarkoplata]

You made the 1000 years old 'query' word -> "Quarry". Power of egy.

[Schickl]

So there are really people out there, who want to run a server, but don't know sql?
lol'd