Fix Procedure

11/25/2021 00:03 hodamoseba#1
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".


Code:
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
11/25/2021 06:32 NorseGodTyr#2
Quote:
Originally Posted by hodamoseba View Post
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 @[Only registered and activated users can see links. Click Here To Register...]D".


Code:
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 @[Only registered and activated users can see links. Click Here To Register...]D".

You have to declare the charid

Declare @[Only registered and activated users can see links. Click Here To Register...]D int;
11/25/2021 10:34 hodamoseba#3
Quote:
Originally Posted by NorseGodTyr View Post
do you even read the error?
Must declare the scalar variable @[Only registered and activated users can see links. Click Here To Register...]D".

You have to declare the charid

Declare @[Only registered and activated users can see links. Click Here To Register...]D int;
i try to fix it buy you know i,m just started now
i,m new can,t do this :D
11/25/2021 11:25 NorseGodTyr#4
Quote:
Originally Posted by hodamoseba View Post
i try to fix it buy you know i,m just started now
i,m new can,t do this :D
this is a Declare


Declare @[Only registered and activated users can see links. Click Here To Register...]D int;
11/25/2021 14:24 hodamoseba#5
Quote:
Originally Posted by NorseGodTyr View Post
this is a Declare


Declare @[Only registered and activated users can see links. Click Here To Register...]D int;
so error here if you can fix code fix bro i really don,t know

Code:
 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
11/25/2021 20:58 Dev_Ninja#6
delet MENTION
11/25/2021 23:47 hodamoseba#7
Quote:
Originally Posted by Dev_Ninja View Post
delet MENTION
like this

Code:
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
11/27/2021 01:32 hodamoseba#8
up