SQL queries: Reset Reward !

[Bolo]

I'm sharing my Season 6 reset reward—last time I used this was back in 2019!

Code Select Expand

USE MuOnline
GO

ALTER PROCEDURE dbo.CommandReset
    @CharName VARCHAR(10),
    @Msg VARCHAR(500) OUTPUT
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @Level INT
    DECLARE @AccountID VARCHAR(10)

    DECLARE @LevelUpReward INT = 500
    DECLARE @WCoinReward INT = 10
    DECLARE @GoblinReward INT = 5

    -- Get character info
    SELECT
        @Level = cLevel,
        @AccountID = AccountID
    FROM Character
    WHERE Name = @CharName

    -- Level check
    IF (@Level < 400)
    BEGIN
        SET @Msg = '❌ You need level 400 to reset.'
        RETURN
    END

    -- ==========================
    -- RESET CHARACTER
    -- ==========================
    UPDATE Character
    SET
        cLevel = 1,
        Experience = 0,
        ResetCount = ResetCount + 1,
        LevelUpPoint = LevelUpPoint + @LevelUpReward,
        Money = 0,
        MapNumber = 0,
        MapPosX = 125,
        MapPosY = 125
    WHERE Name = @CharName

    SET @Msg = '✅ You received ' + CAST(@LevelUpReward AS VARCHAR) + ' LevelUpPoints! '

    -- ==========================
    -- WCOIN REWARD
    -- ==========================
    UPDATE CashShopData
    SET WCoinC = WCoinC + @WCoinReward
    WHERE AccountID = @AccountID

    SET @Msg = @Msg + '✅ You received ' + CAST(@WCoinReward AS VARCHAR) + ' WCoinC! '

    -- ==========================
    -- GOBLIN POINT REWARD
    -- ==========================
    UPDATE CashShopData
    SET GoblinPoint = GoblinPoint + @GoblinReward
    WHERE AccountID = @AccountID

    SET @Msg = @Msg + '✅ You received ' + CAST(@GoblinReward AS VARCHAR) + ' Goblin Points! '
END
GO


Code Select Expand

DECLARE @Message VARCHAR(500)
EXEC dbo.CommandReset 'PlayerName', @Message OUTPUT

-- GameServer will display @Message to the player
Before applying these queries, please test them on the beta/test version of MuOnline. Once verified, and then you can applied to the official version.

[ELLADOR]

not bad