المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : عايز Query


™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

●♥ Marwan1337 ♥●
22-01-2014, 11:47 PM
##