bug pk

[VsroHost]

Hello,
ihave used this query to disable pk from server

 Spoiler

USE [SRO_VT_SHARD] -- REPLACE THIS DBNAME WITH YOUR SHARD DB
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[Update_MURDERSTATE_onCharTable]
ON [dbo].[_Char]
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON;
UPDATE _Char SET DailyPK = 0 , TotalPK = 0 , PKPenaltyPoint = 0 where DailyPK<>0
END

this query made bug in my server when any one make pk and make Telport pk back to 0
all players use this bug now PKK Then make teleport to reset pk

this query i used made a trigger on _char
how i can remove this trigger please ?

[Coyrud]

Wrong section
Try to re-post this topic

[Exelja]

Did you even read what the query does...?

USE [SRO_VT_SHARD]
DROP TRIGGER [Update_MURDERSTATE_onCharTable]

Use that to remove the trigger you made.