[H I T L E R]

حاجه بسيطه كدا للابطال ال في المنتدي ❤
متنساش لازم تكون شغال ب VSro Multi Tools
لو قبلك اي مشكله كلمني علطول احلهالك


Table

USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_FW_COUNTER]    Script Date: 11/29/2020 5:40:29 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_FW_COUNTER](
	[No.] [int] IDENTITY(1,1) NOT NULL,
	[Guild_Name] [varchar](max) NOT NULL,
	[kills] [int] NULL,
 CONSTRAINT [PK___HITLERT__C7D1C6D019F64CE0] PRIMARY KEY CLUSTERED 
(
	[No.] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

AddlogChar

DECLARE @Killer1 Varchar(64),
@Killer2 Varchar(64),
@Guildname Varchar(100)
SET @Killer1 =  SUBSTRING(@Desc, CHARINDEX('His(', @Desc), CHARINDEX('): no job,', @Desc) - CHARINDEX('His(', @Desc) + LEN('): no job,'))
SET @killer2 = REPLACE(@Killer1,'His(','');
SET @killer2 = REPLACE(@Killer2,'): no job,','');
SET @Guildname = (Select name From SRO_VT_SHARD.._Guild Where ID = (select GuildID from SRO_VT_SHARD.._Char Where CharName16 = @Killer2))
declare @kills int = (select kills from _FW_COUNTER)
If (@EventID = '20' and @strPos like '%0x%' and @Desc like '%freebattle%')
begin
If exists (select Guild_Name from SRO_VT_SHARDLOG.._FW_COUNTER where Guild_name = @Guildname)
begin
Update SRO_VT_SHARDLOG.._FW_COUNTER Set Kills = Kills+1 where Guild_name = @Guildname
end
else If not exists (select Guild_Name from SRO_VT_SHARDLOG.._FW_COUNTER where Guild_name = @Guildname) 
begin
 Insert Into SRO_VT_SHARDLOG.._FW_COUNTER (Guild_name,kills) values (@Guildname,1)
End
end
declare @Guildname2 Varchar(100) = (select Guild_name from _FW_COUNTER )
declare @kills2 int = (select top 1 kills from _FW_COUNTER where Guild_Name = @Guildname order by kills desc)

IF @Eventid = 20 and @Kills2 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)
begin
insert into SRO_VT_SHARDLOG..iLegend_Tool 
(Service,Type,Message,Date) 
Values 
(1,'Notice',''+@Guildname+' has Killed '+CAST(@kills2 as nvarchar)+' Enimes',Getdate())
end