add item to char problem

[sromab]

i have problem for add item to char

This message appears


Msg 8114, Level 16, State 5, Procedure _ADD_ITEM_EXTERN, Line 0
Error converting data type varchar to int.

[#HB]

You're implementing the procedure wrongly.

[Leodoom]

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @ varchar(64)

set @ = 'YourCharName'

exec _ADD_ITEM_EXTERN @,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,1

[#HB]

Then it might be your procedure code.

[sromab]

same problem

[ZαKuRα]

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_EU_TSTAFF_11_SET_B_RARE',1,100
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_B_RARE',1,100
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_B_RARE',1,100
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_B_RARE',1,100
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,100
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,100
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_HA_SET_B_RARE',1,1 00
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_SA_SET_B_RARE',1,1 00
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_LA_SET_B_RARE',1,1 00
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_FA_SET_B_RARE',1,1 00
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_AA_SET_B_RARE',1,1 00
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_BA_SET_B_RARE',1,1 00

[#HB]

Check _ADD_ITEM_EXTERN arguments date types.