Unique proc filter vsroplus

Developer[Boda] · 11/07/2024, 07:57

Unique Kill Reward

Code:

IF @RefUniqueID='51783'
BEGIN
EXEC vPlus.._Char_AddItemToChest @CHARID,9238, 1, 0,'REWARD'-----------------tıger
EXEC vPlus.._Char_SendTextNotification @CHARID,'Your reward has been sent to your Item Chest.',3,0,1,51783
EXEC vPlus.._Char_SendTextNotification @CHARID,'Your reward has been sent to your Item Chest.',1,0,1,51783
end

Unique Give Honor Points

Code:

USE [vPlus]
GO
/****** Object:  StoredProcedure [dbo].[_Logger_UniqueDeath]    Script Date: 7/20/2024 3:24:54 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[_Logger_UniqueDeath]
    -- Add the parameters for the stored procedure here
    @CharID INT,
    @CharName16 VARCHAR(64), -- NOTE: this might be NickName16 which is job alies in case the character killed the unique under job mode
    @RefUniqueID INT
AS
BEGIN
    SET NOCOUNT ON;
    DECLARE @RankPoints INT = (SELECT Points FROM _RefRankingUniquePoints WHERE RefUniqueID = @RefUniqueID)
    IF (@RankPoints > 0)
    BEGIN
        UPDATE _RankingUniquePoints SET TotalKills += 1, TotalPoints += @RankPoints, LastUpdate = GETDATE() WHERE CharID = @CharID
        IF (@@ROWCOUNT = 0)
            INSERT INTO _RankingUniquePoints VALUES (@CharID, 1, @RankPoints, GETDATE());
    END

    DECLARE @RefUniqueCodeName128 VARCHAR(129) =  (SELECT CodeName128 FROM SRO_VT_SHARD.._RefObjCommon WHERE ID = @RefUniqueID)
    DECLARE @UniqueName Varchar(64) =  (SELECT UniqueName FROM _RefUniqueNoticeName WHERE UniqueCodeName128 = @RefUniqueCodeName128)
    DECLARE @MSG VARCHAR(MAX) =  @CharName16 + ' has killed ' + @UniqueName 
    IF @UniqueName IS NOT NULL
    INSERT INTO _DiscordBot_Messages (ChannelID,Message)
    VALUES (1262861649266606161,@MSG)

END




    
    DECLARE @CampID INT;
    DECLARE @HonorMessage NVARCHAR(MAX);

    -- TG (Tiger Girl)
    IF (@RefUniqueID = 1954) 
    BEGIN
        SET @CampID = ISNULL((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID = @CharID), 0);
        UPDATE SRO_VT_SHARD.dbo._TrainingCamp 
        SET EvaluationPoint += 1, GraduateCount += 1 
        WHERE ID = @CampID;

        UPDATE SRO_VT_SHARD.dbo._TrainingCampMember 
        SET HonorPoint = HonorPoint + 1 
        WHERE CharID = @CharID;

        SET @HonorMessage = N'Tebrikler 1 Honor Puan Kazandınız..'
        EXEC _Char_SendTextNotification @CharID, @HonorMessage, 1, 0, 0
    END

    
    IF (@RefUniqueID = 5871) --Cerb
    BEGIN
        SET @CampID = ISNULL((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID = @CharID), 0);
        UPDATE SRO_VT_SHARD.dbo._TrainingCamp 
        SET EvaluationPoint += 1, GraduateCount += 1 
        WHERE ID = @CampID;

        UPDATE SRO_VT_SHARD.dbo._TrainingCampMember 
        SET HonorPoint = HonorPoint + 1 
        WHERE CharID = @CharID;

        SET @HonorMessage = N'Tebrikler 1 Honor Puan Kazandınız..'
        EXEC _Char_SendTextNotification @CharID, @HonorMessage, 1, 0, 0
    END

    
    IF (@RefUniqueID = 14936) --Ivy
    BEGIN
        SET @CampID = ISNULL((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID = @CharID), 0);
        UPDATE SRO_VT_SHARD.dbo._TrainingCamp 
        SET EvaluationPoint += 1, GraduateCount += 1 
        WHERE ID = @CampID;

        UPDATE SRO_VT_SHARD.dbo._TrainingCampMember 
        SET HonorPoint = HonorPoint + 1 
        WHERE CharID = @CharID;

        SET @HonorMessage = N'Tebrikler 1 Honor Puan Kazandınız..'
        EXEC _Char_SendTextNotification @CharID, @HonorMessage, 1, 0, 0
    END

    
    IF (@RefUniqueID = 1982) -- Uru 
    BEGIN
        SET @CampID = ISNULL((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID = @CharID), 0);
        UPDATE SRO_VT_SHARD.dbo._TrainingCamp 
        SET EvaluationPoint += 1, GraduateCount += 1 
        WHERE ID = @CampID;

        UPDATE SRO_VT_SHARD.dbo._TrainingCampMember 
        SET HonorPoint = HonorPoint + 1 
        WHERE CharID = @CharID;

        SET @HonorMessage = N'Tebrikler 1 Honor Puan Kazandınız..'
        EXEC _Char_SendTextNotification @CharID, @HonorMessage, 1, 0, 0
    END

      IF (@RefUniqueID = 2002) -- Isu 
    BEGIN
        SET @CampID = ISNULL((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID = @CharID), 0);
        UPDATE SRO_VT_SHARD.dbo._TrainingCamp 
        SET EvaluationPoint += 1, GraduateCount += 1 
        WHERE ID = @CampID;

        UPDATE SRO_VT_SHARD.dbo._TrainingCampMember 
        SET HonorPoint = HonorPoint + 1 
        WHERE CharID = @CharID;

        SET @HonorMessage = N'Tebrikler 1 Honor Puan Kazandınız..'
        EXEC _Char_SendTextNotification @CharID, @HonorMessage, 1, 0, 0
    END


      IF (@RefUniqueID = 3810) -- Lord 
    BEGIN
        SET @CampID = ISNULL((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID = @CharID), 0);
        UPDATE SRO_VT_SHARD.dbo._TrainingCamp 
        SET EvaluationPoint += 1, GraduateCount += 1 
        WHERE ID = @CampID;

        UPDATE SRO_VT_SHARD.dbo._TrainingCampMember 
        SET HonorPoint = HonorPoint + 1 
        WHERE CharID = @CharID;

        SET @HonorMessage = N'Tebrikler 1 Honor Puan Kazandınız..'
        EXEC _Char_SendTextNotification @CharID, @HonorMessage, 1, 0, 0
    END

      IF (@RefUniqueID = 3875) -- Demon 
    BEGIN
        SET @CampID = ISNULL((SELECT CampID FROM SRO_VT_SHARD.._TrainingCampMember WITH(NOLOCK) WHERE CharID = @CharID), 0);
        UPDATE SRO_VT_SHARD.dbo._TrainingCamp 
        SET EvaluationPoint += 1, GraduateCount += 1 
        WHERE ID = @CampID;

        UPDATE SRO_VT_SHARD.dbo._TrainingCampMember 
        SET HonorPoint = HonorPoint + 1 
        WHERE CharID = @CharID;

        SET @HonorMessage = N'Tebrikler 1 Honor Puan Kazandınız..'
        EXEC _Char_SendTextNotification @CharID, @HonorMessage, 1, 0, 0
    END