sql trigger Auto_Reborn juver database

[llenn]

sql for re login you level will reset
in pic said level 10 for reborn then reset you level to 1 max to 80 times

but level character still same not reset to 1 form 10

(in source not have any keyword about reborn)

dbo.charinfo > ChaReborn int (0)

 

[masterband1427]

ChaGPT Response

CREATE TRIGGER ResetLevelAndIncrementReborn
ON RanGame1.dbo.ChaInfo
AFTER UPDATE
AS
BEGIN
    IF UPDATE(ChaLevel) AND UPDATE(ChaReborn)
    BEGIN
        UPDATE c
        SET c.ChaLevel = 1,
            c.ChaReborn = c.ChaReborn + 1,
        FROM RanGame1.dbo.ChaInfo c
        JOIN inserted i ON c.ChaID = i.ChaID
        WHERE i.ChaLevel = 10 AND i.ChaReborn < 80;
    END
END;

Maybe try this?

 

[llenn]

ChaGPT Response

CREATE TRIGGER ResetLevelAndIncrementReborn
ON RanGame1.dbo.ChaInfo
AFTER UPDATE
AS
BEGIN
    IF UPDATE(ChaLevel) AND UPDATE(ChaReborn)
    BEGIN
        UPDATE c
        SET c.ChaLevel = 1,
            c.ChaReborn = c.ChaReborn + 1,
        FROM RanGame1.dbo.ChaInfo c
        JOIN inserted i ON c.ChaID = i.ChaID
        WHERE i.ChaLevel = 10 AND i.ChaReborn < 80;
    END
END;

Maybe try this?

error

 

[baby011528]

Maybe you can try my trigger.

in my scripts, there was some setting which can be configure by yourself.

SET @RebornMax = 50; This is max reborn setting

SET @RebornNeedLevel =
        CASE
            WHEN @TempReborn < 10 THEN 150
            WHEN @TempReborn >= 10 AND @TempReborn < 20 THEN 200
            WHEN @TempReborn >= 20 AND @TempReborn < @RebornMax THEN 300
        END;

    SET @newChaStRemain = 
        CASE
            WHEN @TempReborn < 10 THEN @TempReborn * 100
            WHEN @TempReborn >= 10 AND @TempReborn < 20 THEN @TempReborn * 200
            WHEN @TempReborn >= 20 AND @TempReborn < @RebornMax THEN @TempReborn * 300
        END;

    SET @newChaSkillPoint = 
        CASE
            WHEN @TempReborn < 10 THEN @TempReborn * 50
            WHEN @TempReborn >= 10 AND @TempReborn < 20 THEN @TempReborn * 100
            WHEN @TempReborn >= 20 AND @TempReborn < @RebornMax THEN @TempReborn * 200
        END;

this 3 parts is ,
when reborn below 10, every reborn will increase 100stats, 50skillpoint. and the level is needed over 150level for reborn
when reborn is over 10 and below 20, every reborn will increase 200stats, 100skillpoint. and the level is needed over 200level for reborn
when reborn is over 20 and below max reborn, every reborn will increase 300stats, 200skillpoint. and the level is needed over 300level for reborn

just enjoy it.