Dungeon Recall

Stored Procedure: _OnDungeonRecallRequest

Parameters:

@CharID INT - Character ID
@CharName16 VARCHAR(64) - Character name
@TargetJID INT - Target user JID
@GameWorldID SMALLINT - Game World ID

Let us block sending recall requests for a party member to the Forgotten World dungeon level 100-110 [Shipwreck ★] and send a text notification using _Char_SendTextNotification to ensure that the trigger works correctly.

USE [vPlus]
GO
/****** Object:  StoredProcedure [dbo].[_OnDungeonRecallRequest] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_OnDungeonRecallRequest]
    @CharID INT,
    @CharName16 VARCHAR(64),
    @TargetJID INT,
    @GameWorldID SMALLINT
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @TargetCharID INT, @TargetCharName16 VARCHAR(64)

    SELECT TOP 1 
        @TargetCharID = CharID, 
        @TargetCharName16 = CharName16 
    FROM _OnlinePlayers 
    WHERE JID = @TargetJID 
    ORDER BY LoginTime DESC

    --------- Your code starts here --------

    -- Block recalling party members to 1★ Forgotten World (lvl 100-110)
    IF (@GameWorldID = 81)
    BEGIN
        EXEC _Char_SendTextNotification 
            @CharID,
            'You cannot summon a party member to Forgotten World (1★)!',
            1, 0, 0

        RETURN 0
    END

    RETURN 1
END

Cookies