Fix Procedure

[hodamoseba]

Fix Procedure

need fix this to work i try to add it to give random silk 10~50

Msg 137, Level 15, State 2, Line 33
Must declare the scalar variable "@CharID".

IF @Operation = 16
BEGIN
    IF (@ItemRefID = 43914) -- RefObjCommon ID (Scroll) (By ShuJaira)
    BEGIN
 declare @upper int = '50' declare @lower int = '20'
 declare @random int = ROUND(((@upper - @lower -1) * RAND() + @lower), 0)
 set @charname = (select CharName16  from sro_vt_shard.dbo._Char where CharID=@CharID)
 end

BEGIN
DECLARE @UserID varchar(56) = (SELECT JID FROM SRO_VT_ACCOUNT.dbo.TB_User U WITH(NOLOCK)
JOIN SRO_VT_SHARD.dbo._User U2 WITH(NOLOCK) ON U.JID = U2.UserJID WHERE CharID = @CharID)                                                                     

EXEC SRO_VT_ACCOUNT.CGI.[CGI_WebPurchaseSilkPServer] @UserID,@random    -- for silks

END
END

this procedure give random silk 20~50