Stat Sıfırlama Bugu Fix ( Bugsuz , Test Edildi , OnayLandı ! )

CREATE PROCEDURE [dbo].[REPAIR_USER_STAT_POINTS]
@strUserID varchar(21)
AS
/*
Author : Ceribrio
*/
DECLARE @Level int, @Point tinyint, @Class int,@NewPoint int

SELECT @Level = Level,@Class = Class,@Point = Points FROM USERDATA WHERE strUserId = @strUserID

IF @Level >= 74 AND @Point = 31
BEGIN
/*
    IF @Level = 71
    BEGIN
    SET @NewPoint =  210
    END
    ELSE IF @Level = 72
    BEGIN
    SET @NewPoint =  215
    END
    ELSE IF @Level = 73
    BEGIN
    SET @NewPoint =  220
    END
    ELSE IF @Level = 74
*/
    IF @Level = 74
    BEGIN
    SET @NewPoint =  225
    END
    ELSE IF @Level = 75
    BEGIN
    SET @NewPoint =  230
    END
    ELSE IF @Level = 76
    BEGIN
    SET @NewPoint =  235
    END
    ELSE IF @Level = 77
    BEGIN
    SET @NewPoint =  240
    END
    ELSE IF @Level = 78
    BEGIN
    SET @NewPoint =  245
    END
    ELSE IF @Level = 79
    BEGIN
    SET @NewPoint =  250
    END
    ELSE IF @Level = 80
    BEGIN
    SET @NewPoint =  255
    END
   
    IF @Class = 201 OR @Class = 205 OR @Class = 206 OR @Class = 101 OR @Class = 105 OR @Class = 106
    BEGIN
        UPDATE USERDATA Set Strong = '97',Dex = '60',Sta = '65',Intel = '50',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId
    END
    ELSE IF @Class = 202 OR @Class = 207 OR @Class = 208 OR @Class = 102 OR @Class = 107 OR @Class = 108
    BEGIN
        UPDATE USERDATA Set Strong = '60',Dex = '102',Sta = '60',Intel = '50',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId
    END
    ELSE IF @Class = 203 OR @Class = 209 OR @Class = 210 OR @Class = 103 OR @Class = 109 OR @Class = 110
    BEGIN
        UPDATE USERDATA Set Strong = '50',Dex = '70',Sta = '50',Intel = '70',Cha = '82',Points = @NewPoint WHERE strUserId = @strUserId
    END
    ELSE IF @Class = 204 OR @Class = 211 OR @Class = 212 OR @Class = 104 OR @Class = 111 OR @Class = 112
    BEGIN
        UPDATE USERDATA Set Strong = '65',Dex = '60',Sta = '65',Intel = '82',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId
    END
END

SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame,
    Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly
    FROM    USERDATA WHERE strUserId = @id
SET @nRet = @@RowCount

-- # Repair Stat Start #
-- # Ganks , Ceribrio'a teşekkürler ! #
EXEC REPAIR_USER_STAT_POINTS @id
-- # Repair Stat End #