hata devam ediyor..
if(@JobID= '34038') --Remover Blue Avatar
begin
SELECT @ItemID=ItemID from _Inventory where CharID = @CharID AND Slot = '13'
SELECT @RefItemID=RefItemID from _Items where ID64 = @ItemID
If (@RefItemID >='43620' AND @RefItemID <='43625')
begin
Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID
end
Else
If (@RefItemID >='22912' AND @RefItemID <='22923')
begin
Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID
end
bunları eklıyorum addtimedjopa bana bu hataları verıyor.
Msg 137, Level 15, State 1, Procedure _AddTimedJob, Line 64
Must declare the scalar variable "@ItemID".
Msg 137, Level 15, State 1, Procedure _AddTimedJob, Line 65
Must declare the scalar variable "@RefItemID".
Msg 137, Level 15, State 2, Procedure _AddTimedJob, Line 66
Must declare the scalar variable "@RefItemID".
Msg 137, Level 15, State 2, Procedure _AddTimedJob, Line 68
Must declare the scalar variable "@ItemID".
Msg 137, Level 15, State 2, Procedure _AddTimedJob, Line 71
Must declare the scalar variable "@RefItemID".
Msg 137, Level 15, State 2, Procedure _AddTimedJob, Line 73
Must declare the scalar variable "@ItemID".