TopReward Produce

Hi guys! i have a problem
i make this simple produce but i dont know why dosent work
, when i reach the lv 110 nothing happend, and i check the Table _MaxLevelLog and got record but i dont got the silk
Any Hints?

Table:

HTML Code:

CREATE TABLE _MaxLevelLog
(
CharID					INT,
LevelCounter				INT,
Done					BIT
)

Quote:

IF @EventID = 22 AND @Data2 = 110
BEGIN

DECLARE @UserJID int;
DECLARE @MaxLevelCount int = (select max(LevelCounter) from _MaxLevelLog);
DECLARE @SilkTop int;

IF EXISTS (SELECT * FROM _MaxLevelLog WHERE CharID = @CharID )

UPDATE _MaxLevelLog SET LevelCounter = LevelCounter WHERE CharID = @CharID
ELSE

INSERT INTO _MaxLevelLog VALUES (@CharID,(select max(LevelCounter)+1 from _MaxLevelLog),0)

SET @SilkTop = CASE
WHEN @MaxLevelCount <= 50
THEN 200
WHEN @MaxLevelCount <= 100
THEN 100

ELSE 0
END

SELECT @UserJID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @UserJID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @SilkTop where JID = @UserJID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @UserJID, @SilkTop, 0, 0

END

fix it the problem was LevelCounter starts in the table with NULL