[Release]Quarry to stop trading silk items :)

Page 2 of 3

12/28/2011 09:49 Dr.Abdelfattah#16

Quote:

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 !

12/28/2011 09:54 ahmed4ever2u#17

Quote:

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

12/28/2011 09:55 Dr.Abdelfattah#18

Quote:

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

12/28/2011 09:57 ahmed4ever2u#19

Quote:

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

12/28/2011 10:07 Dr.Abdelfattah#20

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

PHP Code:


			
SET CanTrade = 1

12/28/2011 13:36 Nezekan#21

[Only registered and activated users can see links. Click Here To Register...]

12/28/2011 20:53 GoneUp#22

xD...

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

12/28/2011 22:52 _LastSoul_#23

Quote:

Originally Posted by ahmed4ever2u

i know xD

not for free ^_^

ur offer?

12/28/2011 23:05 ahmed4ever2u#24

Quote:

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 !

12/28/2011 23:45 PortalDark#25

why u wanna do pets untradeable anyway?

12/29/2011 00:34 ahmed4ever2u#26

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 !

12/29/2011 01:59 Dr.Abdelfattah#27

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 !

02/03/2012 15:59 ahmed4ever2u#28

Quote:

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

02/04/2012 03:22 sarkoplata#29

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

02/04/2012 12:00 Schickl#30

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

Page 2 of 3