[Request]Item code for the following items

05/12/2012 08:04 ImposibleThings#1
well i am looking for code for the following item
3days grab bet :
7days devil sprit :
1 day clock :

thx
05/12/2012 08:16 HigurashiKai_#2
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
05/12/2012 08:21 ImposibleThings#3
Thx you bro

Well this are non trade able right ?
05/12/2012 12:59 HigurashiKai_#4
Quote:
Originally Posted by eldanger08 View Post
+1 :P
Instead of writing +1 , press Thanks
Quote:
Originally Posted by ImposibleThings View Post
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