Fix Procedure

[hodamoseba]

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 [MENTION=1059401]operation[/MENTION] = 16
BEGIN
    IF (@ItemRefID = 43914) -- RefObjCommon ID (Scroll) (By ShuJaira)
    BEGIN
 declare [MENTION=304630]upper[/MENTION]_shujaira int = '50' declare [MENTION=759738]lower[/MENTION]_shujaira int = '20'
 declare [MENTION=3950628]Random_[/MENTION]shujaira int = ROUND(( [MENTION=304630]upper[/MENTION]_shujaira - [MENTION=759738]lower[/MENTION]_shujaira -1) * RAND() + [MENTION=759738]lower[/MENTION]_shujaira), 0)
 set @charname = (select CharName16  from sro_vt_shard.dbo._Char where CharID=@CharID)
 end

BEGIN
DECLARE [MENTION=831308]userid[/MENTION] 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] [MENTION=831308]userid[/MENTION] [MENTION=3950628]Random_[/MENTION]shujaira    -- for silks

END
END

[NorseGodTyr]

Originally Posted by hodamoseba

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 @D".

IF [MENTION=1059401]operation[/MENTION] = 16
BEGIN
    IF (@ItemRefID = 43914) -- RefObjCommon ID (Scroll) (By ShuJaira)
    BEGIN
 declare [MENTION=304630]upper[/MENTION]_shujaira int = '50' declare [MENTION=759738]lower[/MENTION]_shujaira int = '20'
 declare [MENTION=3950628]Random_[/MENTION]shujaira int = ROUND(( [MENTION=304630]upper[/MENTION]_shujaira - [MENTION=759738]lower[/MENTION]_shujaira -1) * RAND() + [MENTION=759738]lower[/MENTION]_shujaira), 0)
 set [MENTION=444787]Char[/MENTION]name = (select CharName16  from sro_vt_shard.dbo._Char where CharID [MENTION=395373]Chari[/MENTION]D)
 end

BEGIN
DECLARE [MENTION=831308]userid[/MENTION] 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 = [MENTION=395373]Chari[/MENTION]D)                                                                     

EXEC SRO_VT_ACCOUNT.CGI.[CGI_WebPurchaseSilkPServer] [MENTION=831308]userid[/MENTION] [MENTION=3950628]Random_[/MENTION]shujaira    -- for silks

END
END

do you even read the error?
Must declare the scalar variable @D".

You have to declare the charid

Declare @D int;

[hodamoseba]

Originally Posted by NorseGodTyr

do you even read the error?
Must declare the scalar variable @D".

You have to declare the charid

Declare @D int;

i try to fix it buy you know i,m just started now
i,m new can,t do this

[NorseGodTyr]

Originally Posted by hodamoseba

i try to fix it buy you know i,m just started now
i,m new can,t do this

this is a Declare


Declare @D int;

[hodamoseba]

Originally Posted by NorseGodTyr

this is a Declare


Declare @D int;

so error here if you can fix code fix bro i really don,t know

 declare [MENTION=304630]upper[/MENTION]_shujaira int = '50' declare [MENTION=759738]lower[/MENTION]_shujaira int = '20'
 declare [MENTION=3950628]Random_[/MENTION]shujaira int = ROUND(( [MENTION=304630]upper[/MENTION]_shujaira - [MENTION=759738]lower[/MENTION]_shujaira -1) * RAND() + [MENTION=759738]lower[/MENTION]_shujaira), 0)
 set [MENTION=3898309]charname[/MENTION] = (select CharName16  from sro_vt_shard.dbo._Char where CharID [MENTION=444787]Char[/MENTION]ID)
 end

[Dev_Ninja]

delet MENTION

[hodamoseba]

Originally Posted by Dev_Ninja

delet MENTION

like this

IF [MENTION=1059401]operation[/MENTION] = 16
BEGIN
    IF (@ItemRefID = 43914) -- RefObjCommon ID (Scroll) (By ShuJaira)
    BEGIN
 declare [MENTION=304630]upper[/MENTION] int = '50' declare [MENTION=759738]lower[/MENTION] int = '20'
 declare [MENTION=284104]Random[/MENTION] int = ROUND(( [MENTION=304630]upper[/MENTION] - [MENTION=759738]lower[/MENTION] -1) * RAND() + [MENTION=759738]lower[/MENTION]), 0)
 set @charname = (select CharName16  from sro_vt_shard.dbo._Char where CharID=@CharID)
 end

BEGIN
DECLARE [MENTION=831308]userid[/MENTION] 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] [MENTION=831308]userid[/MENTION] [MENTION=284104]Random[/MENTION]    -- for silks

END
END

[hodamoseba]

up