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

[Kled]

اعمل declare لى CharID

[hodamoseba]

اعمل declare لى CharID

set @charname = (select CharName16 from sro_vt_shard.dbo._Char where CharID=@CharID)


قبل العلامة ولا بعدها

[Kled]

فوق وغير اسم ال shard لو هو كابيتال اكتبو كابيتال

[Waxy]

أنت غالبا حولت تستخدمه بره ال _addlogitem علشان كده جالك المشكلة دي لان الProcedure ده بيتحط جوة _addlogitem