[BlaCkDe3ViL]

بدل كل اللي في ال Trigger ده ممكن تعمل دي بس!!

USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Trigger [dbo].[FW_COUNTER_NOTICE]    Script Date: 23/06/2020 08:01:44 م ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[FW_COUNTER_NOTICE]  
ON  [dbo].[_FW_COUNTER] 
after  insert,update,delete 
as 
---------------------------- Q1 ----------------------------------------------------------------- 
declare @Guildname Varchar(100)
SET @Guildname = (select Guild_name from _FW_COUNTER)
declare @kills int = (select kills from _FW_COUNTER)


IF @Kills IN (50, 100, 200, 300, 400, 600, 700, 800, 900, 1000, 1100, 1200, 1300, 1400, 1600, 1700, 1800, 2000, 2100, 2200, 2300, 2400, 2500, 2600, 2800, 2900, 3000)
insert into SRO_VT_SHARDLOG..iLegend_Tool (Service,Type,Message,Date) Values (1,'Notice',''+@Guildname+' has destroyed '+CAST(@kills as nvarchar)+' Enimes',Getdate())


GO

والارقام متحطهاش Interger يعني مثلا بدل '20' خليها 20
ده بيسهل العملية علي ال SQL وبيخليه يسحب CPU اقل

واسم ال Guild بردوا VARCHAR(64) مش 100 ولا MAX
MAX دي بتسحب كتير اوي بلاشها ارجوك

و ال SELECT اللي بيتعمل في ال Trigger هتخليه SELECT FROM INSERTED مش FROM FW COUNTER
لو فيه جايلدات كتير مش هشتغل

و Enemies***