Stored Procedure: _OnGuildPointDonateRequest
Parameters:
@GuildID INT- Guild ID@CharID INT- Character ID@Points INT- Points
Let us block donating points to the guild and send a text notification using _Char_SendTextNotification to make sure that the trigger works correctly.
USE [vPlus]
GO
/****** Object: StoredProcedure [dbo].[_OnGuildPointDonateRequest] Script Date: 1/18/2024 7:33:39 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[_OnGuildPointDonateRequest]
@GuildID INT,
@CharID INT,
@Points INT
AS
BEGIN
SET NOCOUNT ON;
/*
This procedure is executed when a player tries to donate skill points as guild points.
You can cancel the request by returning 0.
*/
--------- Your code starts here --------
-- Sending message
EXEC _Char_SendTextNotification @CharID, 'Donating points to the guild is currently disabled!', 1, 0, 0
RETURN 0 -- Invalid
--RETURN 1 -- Valid
END