Madness Event Per Job

[Sukuna1993]

Hello Today i will release a Madness Event But Working Via Job All you have to do is to make the teleport work that if the person is wearing the Job Suit, he will enter if he is not, he will not enter.

USE [DB_SYSTEM]
GO
/****** Object:  StoredProcedure [dbo].[_EventMadnessLaunch]    Script Date: 1/4/2022 11:51:33 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[_EventMadnessLaunch]
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	UPDATE _Myeventchannel SET [Status] = 1 WHERE EventID = 15
    EXEC vPlus.._AddNotificationAll 'Madness event will start in 10 minutes!', 2, 1
	WAITFOR DELAY '00:05:00'
	EXEC vPlus.._AddNotificationAll 'Madness event will start in 5 minutes!', 2, 1
	WAITFOR DELAY '00:04:00'
	EXEC vPlus.._AddNotificationAll 'Madness event will start in 1 minute!', 2, 1
	WAITFOR DELAY '00:01:00'
	UPDATE vPlus.._RefTeleport SET [Enabled] = 1 WHERE TeleportID = 234
	EXEC vPlus.._Command_SpawnMonster 556894, 1, 25334, 0, 56.32256, 1919, 1
	EXEC vPlus.._AddNotificationAll 'Madness event has just started, Good Luck!', 2, 1

END

USE [DB_SYSTEM]
GO
/****** Object:  StoredProcedure [dbo].[_EventMadnessUniqueKill]    Script Date: 1/4/2022 11:53:39 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[_EventMadnessUniqueKill]
@CharID INT,
@NickName16 VARCHAR(64),
@RefUniqueID INT
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	IF ((SELECT [Status] FROM _Myeventchannel WHERE EventID = 15) = 0) OR (@RefUniqueID != 44113)
		RETURN;

	DECLARE @CharName16 VARCHAR(64) = (SELECT CharName16 FROM SRO_VT_SHARD.._Char WITH(NOLOCK) WHERE CharID = @CharID)
	DECLARE @Announcement VARCHAR(254) = '[War of League]: [' + @CharName16 + ' (' + @NickName16 + ')] has killed [ISY (GM)] and won the war!'
	EXEC vPlus.._AddNotificationAll @Announcement, 5, 1, 52945

	UPDATE _Event_Processing SET [Status] = 0 WHERE EventID = 2
	UPDATE vPlus.._RefTeleport SET [Enabled] = 0 WHERE TeleportID = 234
	EXEC vPlus.._AddNotificationAll 'Madness event has just ended!', 2, 1
	
	---EXEC vPlus.._AddLiveSilk @CharID, 150
	
END

[gmhasan13]

Interesting?

[NorseGodTyr]

Originally Posted by Zerf.

Hello Today i will release a Madness Event But Working Via Job All you have to do is to make the teleport work that if the person is wearing the Job Suit, he will enter if he is not, he will not enter.

its not a *Release* if you paste 2 procedure from a filter that execute it

[rogerio14]

share vPlus filter.

[NorseGodTyr]

Originally Posted by rogerio14

share vPlus filter.

You can register a 30 days trial check it here

[iqodas]

how do we set the clock

[Beba Army]

Originally Posted by Zerf.

Hello Today i will release a Madness Event But Working Via Job All you have to do is to make the teleport work that if the person is wearing the Job Suit, he will enter if he is not, he will not enter.

USE [DB_SYSTEM]
GO
/****** Object:  StoredProcedure [dbo].[_EventMadnessLaunch]    Script Date: 1/4/2022 11:51:33 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[_EventMadnessLaunch]
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	UPDATE _Myeventchannel SET [Status] = 1 WHERE EventID = 15
    EXEC vPlus.._AddNotificationAll 'Madness event will start in 10 minutes!', 2, 1
	WAITFOR DELAY '00:05:00'
	EXEC vPlus.._AddNotificationAll 'Madness event will start in 5 minutes!', 2, 1
	WAITFOR DELAY '00:04:00'
	EXEC vPlus.._AddNotificationAll 'Madness event will start in 1 minute!', 2, 1
	WAITFOR DELAY '00:01:00'
	UPDATE vPlus.._RefTeleport SET [Enabled] = 1 WHERE TeleportID = 234
	EXEC vPlus.._Command_SpawnMonster 556894, 1, 25334, 0, 56.32256, 1919, 1
	EXEC vPlus.._AddNotificationAll 'Madness event has just started, Good Luck!', 2, 1

END

USE [DB_SYSTEM]
GO
/****** Object:  StoredProcedure [dbo].[_EventMadnessUniqueKill]    Script Date: 1/4/2022 11:53:39 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[_EventMadnessUniqueKill]
@CharID INT,
@NickName16 VARCHAR(64),
@RefUniqueID INT
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	IF ((SELECT [Status] FROM _Myeventchannel WHERE EventID = 15) = 0) OR (@RefUniqueID != 44113)
		RETURN;

	DECLARE @CharName16 VARCHAR(64) = (SELECT CharName16 FROM SRO_VT_SHARD.._Char WITH(NOLOCK) WHERE CharID = @CharID)
	DECLARE @Announcement VARCHAR(254) = '[War of League]: [' + @CharName16 + ' (' + @NickName16 + ')] has killed [ISY (GM)] and won the war!'
	EXEC vPlus.._AddNotificationAll @Announcement, 5, 1, 52945

	UPDATE _Event_Processing SET [Status] = 0 WHERE EventID = 2
	UPDATE vPlus.._RefTeleport SET [Enabled] = 0 WHERE TeleportID = 234
	EXEC vPlus.._AddNotificationAll 'Madness event has just ended!', 2, 1
	
	---EXEC vPlus.._AddLiveSilk @CharID, 150
	
END

Can u help me for add it when u have free time

[gehriger10]

Hello bro. And how active the procedure