vSRO Paylaşım vSRO Max Level Query Bonus 4

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

IF @EventID = 22 AND @Data2 = 110
BEGIN
    DECLARE @AllowReward    BIT

    IF EXISTS (SELECT * FROM _MaxLevelLog WHERE CharID = @CharID AND Done = 0)
    BEGIN
        UPDATE    _MaxLevelLog
        SET    LevelCounter += 1
        WHERE    CharID = @CharID

        SELECT    @AllowReward =
                CASE
                    WHEN LevelCounter <= 50
                        THEN 1
                    ELSE 0
                END
        FROM    _MaxLevelLog
        WHERE    CharID = @CharID
    END
    ELSE IF NOT EXISTS (SELECT * FROM _MaxLevelLog WHERE CharID = @CharID)
    BEGIN
        INSERT INTO _MaxLevelLog
        VALUES    (
                @CharID,
                1,
                0)

        SET    @AllowReward = 1
    END 

    IF    @AllowReward = 1
    BEGIN
        /*
        INSERT REWARD QUERY HERE
        */
        UPDATE    _MaxLevelLog
        SET        Done = 1
        WHERE    CharID = @CharID
    END
END

Declare @MaxLevelCount int = (Select Count(CharID) from MaxLevel_Log)
declare @UserJID int = (select UserJID from SRO_VT_SHARD.._User where CharID =@CharID)
declare @CharName varchar(max) = (select charname16 from SRO_VT_SHARD.._Char where CharID = @CharID)
if (@EventID = '22' and @Data2 = '110')
begin
insert MaxLevel_Log (CharID) values (@CharID)
begin
if @MaxLevelCount <= 50
begin
insert into PlusNotice (sent,Message)values(0,@Charname +' has reached level 110, ' + @MaxLevelCount + '/50')
Update SRO_VT_ACCOUNT..SK_Silk set silk_own += 150 where JID = @UserJID
end
end
end