I need help adding Reborn System

[djtrex2]

I get error

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

after executing this

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 ( @ = '41') where do get mine sorry newbie

[Worshiper]

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

[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 ( @ = '41') where do get mine sorry newbie"

[Worshiper]

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 ( @ = '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