Recent posts

Pages 1 2 3 4 5 ... 10
#21
Mu Editors / Mu EditorRe: MU.ToolKit [Silver Edition...
Last post by rookie1902 - Feb 04, 2026, 06:37 AM
thanks
#22
Scripts / querys / SCRIPTSQL queries: Castle Siege Winn...
Last post by Bolo - Feb 03, 2026, 11:17 PM
Use a scheduled SQL job to distribute WCoins to all characters belonging to the Castle Siege winning guild.
Configure the reward amount, then execute the job immediately after the Castle Siege event concludes.

Example: If Castle Siege ends at 22:00, configure the job to run at 22:01.

  • OWNER GUILD: ALL MEMBERS +10 WCoinC
  • ALLIED GUILDS: ALL MEMBERS +10 WCoinC

Code Select
/* ============================================
  Castle Siege Rewards - Optimized
  ============================================ */

DECLARE @OwnerGuild VARCHAR(8)

-- Get castle owner guild
SELECT @OwnerGuild = OWNER_GUILD
FROM MuCastle_DATA

/* ============================================
  Reward OWNER Guild Members
  ============================================ */

UPDATE C
SET C.WCoinC = C.WCoinC + 10
FROM CashShopData C
INNER JOIN Character CH ON C.AccountID = CH.AccountID
INNER JOIN GuildMember GM ON CH.Name = GM.Name
WHERE GM.G_Name = @OwnerGuild


/* ============================================
  Reward ALLIED Guild Members
  ============================================ */

UPDATE C
SET C.WCoinC = C.WCoinC + 10
FROM CashShopData C
INNER JOIN Character CH ON C.AccountID = CH.AccountID
INNER JOIN GuildMember GM ON CH.Name = GM.Name
INNER JOIN Guild G ON GM.G_Name = G.G_Name
WHERE G.G_Union =
(
    SELECT G_Union
    FROM Guild
    WHERE G_Name = @OwnerGuild
)
AND GM.G_Name <> @OwnerGuild
  • Guild Master Extra Reward

Code Select
UPDATE C
SET C.WCoinC = C.WCoinC + 500
FROM CashShopData C
INNER JOIN MEMB_INFO M ON C.AccountID = M.memb___id
INNER JOIN Guild G ON M.memb_name = G.G_Master
WHERE G.G_Name = @OwnerGuild
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.
#23
Season4 / FilesRe: XV-TEAM Season 4 Full File...
Last post by ELLADOR - Feb 03, 2026, 10:49 PM
нажми -Say Thanks- и увидишь сылку  ;)  :)
#24
Mu Online Servers Advertising Here: / Re: mucomando
Last post by jenifer7 - Feb 03, 2026, 08:04 PM
upp
#25
Buy and Sell / *** / SellRe: Do you want to open your o...
Last post by jenifer7 - Feb 03, 2026, 08:01 PM
upp
#26
Season4 / FilesRe: XV-TEAM Season 4 Full File...
Last post by valek - Feb 03, 2026, 06:37 PM
не вижу сылку
#27
Tools Mu Online / ToolsRe: CashShop Design Template
Last post by Crazy1557 - Feb 03, 2026, 07:16 AM
The download link has no content. Could you please re-upload the download content?，Thank you！
#28
Scripts / querys / SCRIPTRe: SQL queries: Reset Reward ...
Last post by ELLADOR - Feb 02, 2026, 07:43 PM
not bad  ;)
#29
Scripts / querys / SCRIPTSQL queries: Reset Reward !
Last post by Bolo - Feb 02, 2026, 07:15 PM
I'm sharing my Season 6 reset reward—last time I used this was back in 2019!

Code Select
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
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.

#30
Buy and Sell / *** / SellRe: FOR SALE – PROFESSIONAL MU...
Last post by fabioozzy - Feb 02, 2026, 07:12 PM
Up
Pages 1 2 3 4 5 ... 10