[Request]Item code for the following items

[ImposibleThings]

well i am looking for code for the following item
3days grab bet :
7days devil sprit :
1 day clock :

thx

[HigurashiKai_]

Yo,better but a 28day lols but okay , here you go :
3Days grab pet : @CharName,'ITEM_EVENT_COS_P_RABBIT_SCROLL',1,1
28day one : @CharName,'ITEM_COS_P_RABBIT_SCROLL_SILK',1,1
7days devil spirit :
@CharName,'ITEM_MALL_AVATAR_M_NASRUN',1,1
@CharName,'ITEM_MALL_AVATAR_W_NASRUN',1,1
Not sure if it's 7days devil.
1Day clock : @CharName,'ITEM_COS_P_EXTENSION_1D',1,1

For 7days devil you might try this:
@CharName,'ITEM_MALL_AVATAR_M_NASRUN_7D',1,1
@CharName,'ITEM_MALL_AVATAR_W_NASRUN_7D',1,1

[ImposibleThings]

Thx you bro

Well this are non trade able right ?

[HigurashiKai_]

Originally Posted by eldanger08

+1 :P

Instead of writing +1 , press Thanks

Originally Posted by ImposibleThings

Thx you bro

Well this are non trade able right ?

They are.
If you want non tradable , follow this:

PHP Code:

use SRO_VT_SHARD
UPDATE [dbo].[_RefObjCommon]
SET CanTrade = 0 ,CanDrop = 0 ,CanPick = 0
WHERE CodeName128 like '%ITEM_MALL%' 


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


cretids -> ahmed4ever2u