add item to char problem

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.
:mad::mad:

You're implementing the procedure wrongly.

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @[Only registered and activated users can see links. Click Here To Register...] varchar(64)

set @[Only registered and activated users can see links. Click Here To Register...] = 'YourCharName'

exec _ADD_ITEM_EXTERN @[Only registered and activated users can see links. Click Here To Register...],'ITEM_EU_TSTAFF_11_SET_B_RARE',1,1

Then it might be your procedure code.

same problem

:)

Quote:

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

Check _ADD_ITEM_EXTERN arguments date types.