Finish

Stored Procedure: _OnQuestFinish

Parameters:

@CharID INT - Character ID
@CharName16 VARCHAR(64) - Character name
@QuestID INT - Quest ID

Let us trigger the completion of the Jangan [Herb Delivery] quest and send a text notification using _Char_SendTextNotification to make sure that the trigger works correctly.

USE [vPlus]
GO
/****** Object:  StoredProcedure [dbo].[_OnQuestFinish]    Script Date: 1/16/2024 3:23:29 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:      <Author,,Name>
-- ALTER date:  <ALTER Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[_OnQuestFinish]
    @CharID INT,
    @CharName16 VARCHAR(64),
    @QuestID INT
AS
BEGIN
    SET NOCOUNT ON;

    /*
        This procedure is executed once a player delivers a quest successfully.
    */

    DECLARE @HwanLevel TINYINT = (
        SELECT CASE
            WHEN @QuestID IN (353, 367) THEN 1
            WHEN @QuestID IN (359, 373) THEN 2
            WHEN @QuestID IN (660, 664) THEN 3
            WHEN @QuestID IN (662, 666) THEN 4
            ELSE 0
        END
    )

    IF (@HwanLevel > 0)
        EXEC vPlus.dbo._Char_AddOrUpdateHwan @CharID, @HwanLevel, 16770651, 1, 0

    --------- Your code starts here --------
    -- Checking the quest ID
    IF (@QuestID = 50)
        EXEC _Char_SendTextNotification @CharID, 'You have completed the quest successfully.', 1, 0, 0
END

Cookies