™XerK™
20-01-2014, 10:46 PM
عاوز Query بتاع GM uniform
افندينا ™Hamboka™
20-01-2014, 11:19 PM
اتفضل
use SRO_VT_SHARD
UPDATE [dbo].[_RefObjCommon]
SET CanPick = 1
WHERE CodeName128 like '%ITEM_ETC_AVATAR_M_GM_UNIFORM%'
UPDATE [dbo].[_RefObjCommon]
SET CanPick = 1
WHERE CodeName128 like '%ITEM_ETC_AVATAR_W_GM_UNIFORM%'
و ده code Avatar
M
/makeitem ITEM_ETC_AVATAR_M_GM_UNIFORM 1
F
/makeitem ITEM_ETC_AVATAR_W_GM_UNIFORM 1
che_9299
20-01-2014, 11:19 PM
USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)
set @CharName = 'YOURCHARNAME'
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_AVATAR_M_GM_UNIFORM',1,1