]Exclusive[ Fortress Counter By Notice

[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

[Ram OX]

لقيت محدش رد ولا قيمك بس عارف تعب عمل السيستمات دي و لفت الدماغ
عاش الله ينور عليك
للاسف انا شغال بواحد مقارب لي فا مش هقدر اجرب
بس ردي تقديرا لتعبك <3