I need help adding Reborn System

03/06/2025 09:07 djtrex2#1

I get error

Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable @[Only registered and activated users can see links. Click Here To Register...]".
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@CharID".

after executing this

Code:

IF (  [MENTION=1059401]operation[/MENTION] =   '41') AND [MENTION=1134588]item[/MENTION]RefID  = '42314' -- Reborn scroll
            BEGIN
            UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET CurLevel = 1, ExpOffset = 0, RemainStatPoint = 5 WHERE CharID=@CharID
            END

can someone also tell me about IF ( @[Only registered and activated users can see links. Click Here To Register...] = '41') where do get mine sorry newbie

03/06/2025 12:03 Worshiper#2

Code:

IF ( operation = '41') AND itemRefID = 'Your Scroll ID' 
BEGIN 
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET Strength = 20 + 3, Intellect = 20 + 3, MaxLevel = 1, CurLevel = 1, ExpOffset = 0, RemainStatPoint = 0 WHERE CharID=@CharID 
End

03/07/2025 20:38 djtrex2#3

sir I want to know where can I find my operation ID and where should I put this code?
if its on SRO_VT_SHARD stored procedure or SRO_VT_SHARDLOG?

"can someone also tell me about IF ( @[Only registered and activated users can see links. Click Here To Register...] = '41') where do get mine sorry newbie"

03/08/2025 16:24 Worshiper#4

Quote:

Originally Posted by djtrex2

sir I want to know where can I find my operation ID and where should I put this code?
if its on SRO_VT_SHARD stored procedure or SRO_VT_SHARDLOG?

"can someone also tell me about IF ( @[Only registered and activated users can see links. Click Here To Register...] = '41') where do get mine sorry newbie"

You can find your scroll id in refobjcomon
Yes its SRO_VT_SHARDLOG

DM me i can help